|
1
|
データベースGodizillaDB_STGに接続中です。
|
|
2
|
BEGIN: IN_SALES_YM=[2023/06], IN_FROM_WHERE=[1], IN_GROUP_ID=[20619]
|
|
3
|
STEP01: IN_GROUP_ID=[20619], num_COMPANY_ID=[29]
|
|
4
|
STEP02: dat_INVOICE_DATE=[2023-06-30]
|
|
5
|
STEP03: dat_RANGE_FROM/TO=[2023-06-01/2023-06-30]
|
|
6
|
STEP04: num_FINANCIAL_ID=[22282]
|
|
7
|
STEP05: UPDATE T_ORDER_DETAILS_ADDRESSES
|
|
8
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[0]
|
|
9
|
STEP06-02: PKG_CREATE_MON_INVOICE:num_INVOICE_NUMBER=[15791611]
|
|
10
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[2], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
11
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
12
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
13
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
14
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[6], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
15
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
16
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[1], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
17
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
18
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
19
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
20
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[5], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
21
|
STEP06-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791611]
|
|
22
|
STEP06-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791611], dtl.NETWORK_CONTRACT_ID=[19722], dtl.TRF_PRODUCT_CODE=[MS-LINEV-INI], dtl.QTY=[3], num_OUT_NUM=[-1], var_OUT_MSG=[起算日関連の情報取得に失敗しました。ORA-01403: no data found]
|
|
23
|
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[0]
|
|
24
|
STEP07-02: PKG_CREATE_MON_INVOICE:num_INVOICE_NUMBER=[15791612]
|
|
25
|
STEP07-04: PKG_CREATE_MON_INVOICE_DTL:num_INVOICE_NUMBER=[15791612], fixdtl.NETWORK_CONTRACT_ID=[17392], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1], num_OUT_NUM=[838070971], var_OUT_MSG=[請求明細情報生成に成功しました。]
|
|
26
|
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
|
|
27
|
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
|
|
28
|
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[17430], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
|
|
29
|
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
|
|
30
|
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
|
|
31
|
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[17614], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
|
|
32
|
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
|
|
33
|
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
|
|
34
|
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[18147], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
|
|
35
|
STEP07-01: FNC_FIND_INVOICES_EX:num_INVOICE_NUMBER=[15791612]
|
|
36
|
STEP07-03: FIND-INVOICE-DTLS:num_LINE_NUMBER=[838070971], num_INV_DTL_QTY=[1]
|
|
37
|
STEP07-05: UPDATE-QTY:num_INVOICE_NUMBER=[15791612], num_LINE_NUMBER=[838070971], fixdtl.NETWORK_CONTRACT_ID=[20187], fixdtl.TRF_PRODUCT_CODE=[MS-PORTAL-FEE], fixdtl.QTY=[1]
|
|
38
|
STEP08: PKG_STORE_INVOICE_TOTAL: START.
|
|
39
|
PRC_STORE_INVOICE_TOTAL: numClaimColGuarantee=[0].
|
|
40
|
PRC_STORE_INVOICE_TOTAL: AMOUNT=[-1].
|
|
41
|
PRC_STORE_INVOICE_TOTAL: TAXABLE_AMOUNT=[-1].
|
|
42
|
PRC_STORE_INVOICE_TOTAL: NON_TAXABLE_AMOUNT=[-1].
|
|
43
|
PRC_STORE_INVOICE_TOTAL: TAX_AMOUNT=[-1].
|
|
44
|
STEP08: PKG_STORE_INVOICE_TOTAL:num_INVOICE_NUMBER=[15791611],num_OUT_NUM=[15791611], var_OUT_MSG=[]
|
|
45
|
STEP08: PKG_STORE_INVOICE_TOTAL: END.
|
|
46
|
END: IN_SALES_YM=[2023/06], IN_FROM_WHERE=[1], IN_GROUP_ID=[20619]
|
|
47
|
プロセスが終了しました。
|
|
48
|
データベースGodizillaDB_STGから切断中です。
|
