eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_LCMADJUSTMENTS_PVT dependencies on FND_GLOBAL

Line 916: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,

912: (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
913: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
914: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
915: VALUES (p_group_id, c_account.lcm_transaction_id, 'ACCOUNT', l_error_msg,
916: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
917: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id);
918:
919: IF (l_sLog AND l_pLog) THEN
920: l_num_records := SQL%ROWCOUNT;

Line 917: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id);

913: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
914: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
915: VALUES (p_group_id, c_account.lcm_transaction_id, 'ACCOUNT', l_error_msg,
916: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
917: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id);
918:
919: IF (l_sLog AND l_pLog) THEN
920: l_num_records := SQL%ROWCOUNT;
921: FND_LOG.STRING(

Line 1261: fnd_global.user_id,

1257: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), -1, acc.receiving_account, acc.lcm_account) CREDIT_ACCOUNT_ID,
1258: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), 1, acc.receiving_account, acc.lcm_account) DEBIT_ACCOUNT_ID,
1259: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), -1, 'Receiving Inspection', 'Landed Cost Absorption') CREDIT_ACCOUNTING_LINE_TYPE,
1260: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), 1, 'Receiving Inspection', 'Landed Cost Absorption') DEBIT_ACCOUNTING_LINE_TYPE,
1261: fnd_global.user_id,
1262: SYSDATE,
1263: fnd_global.prog_appl_id,
1264: fnd_global.conc_program_id,
1265: SYSDATE,

Line 1263: fnd_global.prog_appl_id,

1259: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), -1, 'Receiving Inspection', 'Landed Cost Absorption') CREDIT_ACCOUNTING_LINE_TYPE,
1260: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), 1, 'Receiving Inspection', 'Landed Cost Absorption') DEBIT_ACCOUNTING_LINE_TYPE,
1261: fnd_global.user_id,
1262: SYSDATE,
1263: fnd_global.prog_appl_id,
1264: fnd_global.conc_program_id,
1265: SYSDATE,
1266: SYSDATE,
1267: fnd_global.login_id,

Line 1264: fnd_global.conc_program_id,

1260: Decode(SIGN(acc.new_landed_cost-acc.prior_landed_cost), 1, 'Receiving Inspection', 'Landed Cost Absorption') DEBIT_ACCOUNTING_LINE_TYPE,
1261: fnd_global.user_id,
1262: SYSDATE,
1263: fnd_global.prog_appl_id,
1264: fnd_global.conc_program_id,
1265: SYSDATE,
1266: SYSDATE,
1267: fnd_global.login_id,
1268: fnd_global.user_id,

Line 1267: fnd_global.login_id,

1263: fnd_global.prog_appl_id,
1264: fnd_global.conc_program_id,
1265: SYSDATE,
1266: SYSDATE,
1267: fnd_global.login_id,
1268: fnd_global.user_id,
1269: fnd_global.conc_request_id,
1270: 'N'
1271: FROM CST_LC_ADJ_ACCTG_INFO_GT ACC,

Line 1268: fnd_global.user_id,

1264: fnd_global.conc_program_id,
1265: SYSDATE,
1266: SYSDATE,
1267: fnd_global.login_id,
1268: fnd_global.user_id,
1269: fnd_global.conc_request_id,
1270: 'N'
1271: FROM CST_LC_ADJ_ACCTG_INFO_GT ACC,
1272: CST_LC_RCV_TXN_GT RT

Line 1269: fnd_global.conc_request_id,

1265: SYSDATE,
1266: SYSDATE,
1267: fnd_global.login_id,
1268: fnd_global.user_id,
1269: fnd_global.conc_request_id,
1270: 'N'
1271: FROM CST_LC_ADJ_ACCTG_INFO_GT ACC,
1272: CST_LC_RCV_TXN_GT RT
1273: WHERE acc.lcm_transaction_id = RT.lcm_transaction_id

Line 1416: fnd_global.user_id,

1412: Decode(adj_acc.debit_credit_flag, 1, acc.receiving_account, adj_acc.account) CREDIT_ACCOUNT_ID,
1413: Decode(adj_acc.debit_credit_flag, -1, acc.receiving_account, adj_acc.account) DEBIT_ACCOUNT_ID,
1414: Decode(adj_acc.debit_credit_flag, 1, 'Receiving Inspection', adj_acc.accounting_line_type) CREDIT_ACCOUNTING_LINE_TYPE,
1415: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1416: fnd_global.user_id,
1417: SYSDATE,
1418: fnd_global.prog_appl_id,
1419: fnd_global.conc_program_id,
1420: SYSDATE,

Line 1418: fnd_global.prog_appl_id,

1414: Decode(adj_acc.debit_credit_flag, 1, 'Receiving Inspection', adj_acc.accounting_line_type) CREDIT_ACCOUNTING_LINE_TYPE,
1415: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1416: fnd_global.user_id,
1417: SYSDATE,
1418: fnd_global.prog_appl_id,
1419: fnd_global.conc_program_id,
1420: SYSDATE,
1421: SYSDATE,
1422: fnd_global.login_id,

Line 1419: fnd_global.conc_program_id,

1415: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1416: fnd_global.user_id,
1417: SYSDATE,
1418: fnd_global.prog_appl_id,
1419: fnd_global.conc_program_id,
1420: SYSDATE,
1421: SYSDATE,
1422: fnd_global.login_id,
1423: fnd_global.user_id,

Line 1422: fnd_global.login_id,

1418: fnd_global.prog_appl_id,
1419: fnd_global.conc_program_id,
1420: SYSDATE,
1421: SYSDATE,
1422: fnd_global.login_id,
1423: fnd_global.user_id,
1424: fnd_global.conc_request_id,
1425: 'N'
1426: FROM cst_lc_adj_acctg_info_gt acc,

Line 1423: fnd_global.user_id,

1419: fnd_global.conc_program_id,
1420: SYSDATE,
1421: SYSDATE,
1422: fnd_global.login_id,
1423: fnd_global.user_id,
1424: fnd_global.conc_request_id,
1425: 'N'
1426: FROM cst_lc_adj_acctg_info_gt acc,
1427: cst_lc_rcv_txn_gt rt,

Line 1424: fnd_global.conc_request_id,

1420: SYSDATE,
1421: SYSDATE,
1422: fnd_global.login_id,
1423: fnd_global.user_id,
1424: fnd_global.conc_request_id,
1425: 'N'
1426: FROM cst_lc_adj_acctg_info_gt acc,
1427: cst_lc_rcv_txn_gt rt,
1428: cst_lc_accounts_gt adj_acc

Line 1531: fnd_global.user_id,

1527: mmt.cost_group_id,
1528: sum(mmt.primary_quantity),
1529: sum(mmt.primary_quantity) * (acc.new_landed_cost - acc.prior_landed_cost),
1530: SYSDATE,
1531: fnd_global.user_id,
1532: SYSDATE,
1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,

Line 1533: fnd_global.user_id,

1529: sum(mmt.primary_quantity) * (acc.new_landed_cost - acc.prior_landed_cost),
1530: SYSDATE,
1531: fnd_global.user_id,
1532: SYSDATE,
1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,
1536: fnd_global.prog_appl_id,
1537: fnd_global.conc_program_id,

Line 1534: fnd_global.login_id,

1530: SYSDATE,
1531: fnd_global.user_id,
1532: SYSDATE,
1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,
1536: fnd_global.prog_appl_id,
1537: fnd_global.conc_program_id,
1538: SYSDATE,

Line 1535: fnd_global.conc_request_id,

1531: fnd_global.user_id,
1532: SYSDATE,
1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,
1536: fnd_global.prog_appl_id,
1537: fnd_global.conc_program_id,
1538: SYSDATE,
1539: acc.inventory_item_id,

Line 1536: fnd_global.prog_appl_id,

1532: SYSDATE,
1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,
1536: fnd_global.prog_appl_id,
1537: fnd_global.conc_program_id,
1538: SYSDATE,
1539: acc.inventory_item_id,
1540: acc.organization_id,

Line 1537: fnd_global.conc_program_id,

1533: fnd_global.user_id,
1534: fnd_global.login_id,
1535: fnd_global.conc_request_id,
1536: fnd_global.prog_appl_id,
1537: fnd_global.conc_program_id,
1538: SYSDATE,
1539: acc.inventory_item_id,
1540: acc.organization_id,
1541: acc.transaction_date,

Line 1668: fnd_global.user_id,

1664: txn.cost_group_id,
1665: sum(txn.layer_quantity),
1666: txn.value_change,
1667: SYSDATE,
1668: fnd_global.user_id,
1669: SYSDATE,
1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,

Line 1670: fnd_global.user_id,

1666: txn.value_change,
1667: SYSDATE,
1668: fnd_global.user_id,
1669: SYSDATE,
1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,
1673: fnd_global.prog_appl_id,
1674: fnd_global.conc_program_id,

Line 1671: fnd_global.login_id,

1667: SYSDATE,
1668: fnd_global.user_id,
1669: SYSDATE,
1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,
1673: fnd_global.prog_appl_id,
1674: fnd_global.conc_program_id,
1675: SYSDATE,

Line 1672: fnd_global.conc_request_id,

1668: fnd_global.user_id,
1669: SYSDATE,
1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,
1673: fnd_global.prog_appl_id,
1674: fnd_global.conc_program_id,
1675: SYSDATE,
1676: txn.inventory_item_id,

Line 1673: fnd_global.prog_appl_id,

1669: SYSDATE,
1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,
1673: fnd_global.prog_appl_id,
1674: fnd_global.conc_program_id,
1675: SYSDATE,
1676: txn.inventory_item_id,
1677: txn.organization_id,

Line 1674: fnd_global.conc_program_id,

1670: fnd_global.user_id,
1671: fnd_global.login_id,
1672: fnd_global.conc_request_id,
1673: fnd_global.prog_appl_id,
1674: fnd_global.conc_program_id,
1675: SYSDATE,
1676: txn.inventory_item_id,
1677: txn.organization_id,
1678: txn.transaction_date,

Line 2043: fnd_global.user_id,

2039: entered_nr_tax,
2040: entered_rec_tax
2041: )
2042: SELECT
2043: fnd_global.user_id,
2044: SYSDATE,
2045: fnd_global.prog_appl_id,
2046: fnd_global.conc_program_id,
2047: SYSDATE,

Line 2045: fnd_global.prog_appl_id,

2041: )
2042: SELECT
2043: fnd_global.user_id,
2044: SYSDATE,
2045: fnd_global.prog_appl_id,
2046: fnd_global.conc_program_id,
2047: SYSDATE,
2048: SYSDATE,
2049: fnd_global.login_id,

Line 2046: fnd_global.conc_program_id,

2042: SELECT
2043: fnd_global.user_id,
2044: SYSDATE,
2045: fnd_global.prog_appl_id,
2046: fnd_global.conc_program_id,
2047: SYSDATE,
2048: SYSDATE,
2049: fnd_global.login_id,
2050: fnd_global.user_id,

Line 2049: fnd_global.login_id,

2045: fnd_global.prog_appl_id,
2046: fnd_global.conc_program_id,
2047: SYSDATE,
2048: SYSDATE,
2049: fnd_global.login_id,
2050: fnd_global.user_id,
2051: fnd_global.conc_request_id,
2052: rcv_receiving_sub_ledger_s.nextval,
2053: rae.accounting_event_id,

Line 2050: fnd_global.user_id,

2046: fnd_global.conc_program_id,
2047: SYSDATE,
2048: SYSDATE,
2049: fnd_global.login_id,
2050: fnd_global.user_id,
2051: fnd_global.conc_request_id,
2052: rcv_receiving_sub_ledger_s.nextval,
2053: rae.accounting_event_id,
2054: rae.debit_accounting_line_type,

Line 2051: fnd_global.conc_request_id,

2047: SYSDATE,
2048: SYSDATE,
2049: fnd_global.login_id,
2050: fnd_global.user_id,
2051: fnd_global.conc_request_id,
2052: rcv_receiving_sub_ledger_s.nextval,
2053: rae.accounting_event_id,
2054: rae.debit_accounting_line_type,
2055: rae.rcv_transaction_id,

Line 2145: fnd_global.user_id,

2141: accounted_rec_tax,
2142: entered_nr_tax,
2143: entered_rec_tax)
2144: SELECT
2145: fnd_global.user_id,
2146: SYSDATE,
2147: fnd_global.prog_appl_id,
2148: fnd_global.conc_program_id,
2149: SYSDATE,

Line 2147: fnd_global.prog_appl_id,

2143: entered_rec_tax)
2144: SELECT
2145: fnd_global.user_id,
2146: SYSDATE,
2147: fnd_global.prog_appl_id,
2148: fnd_global.conc_program_id,
2149: SYSDATE,
2150: SYSDATE,
2151: fnd_global.login_id,

Line 2148: fnd_global.conc_program_id,

2144: SELECT
2145: fnd_global.user_id,
2146: SYSDATE,
2147: fnd_global.prog_appl_id,
2148: fnd_global.conc_program_id,
2149: SYSDATE,
2150: SYSDATE,
2151: fnd_global.login_id,
2152: fnd_global.user_id,

Line 2151: fnd_global.login_id,

2147: fnd_global.prog_appl_id,
2148: fnd_global.conc_program_id,
2149: SYSDATE,
2150: SYSDATE,
2151: fnd_global.login_id,
2152: fnd_global.user_id,
2153: fnd_global.conc_request_id,
2154: rcv_receiving_sub_ledger_s.NEXTVAL,
2155: rae.accounting_event_id,

Line 2152: fnd_global.user_id,

2148: fnd_global.conc_program_id,
2149: SYSDATE,
2150: SYSDATE,
2151: fnd_global.login_id,
2152: fnd_global.user_id,
2153: fnd_global.conc_request_id,
2154: rcv_receiving_sub_ledger_s.NEXTVAL,
2155: rae.accounting_event_id,
2156: rae.credit_accounting_line_type,

Line 2153: fnd_global.conc_request_id,

2149: SYSDATE,
2150: SYSDATE,
2151: fnd_global.login_id,
2152: fnd_global.user_id,
2153: fnd_global.conc_request_id,
2154: rcv_receiving_sub_ledger_s.NEXTVAL,
2155: rae.accounting_event_id,
2156: rae.credit_accounting_line_type,
2157: rae.rcv_transaction_id,

Line 2230: fnd_global.user_id,

2226: 1,
2227: 1,
2228: mmt.primary_quantity * (acc.new_landed_cost - acc.prior_landed_cost),
2229: SYSDATE,
2230: fnd_global.user_id,
2231: SYSDATE,
2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,

Line 2232: fnd_global.user_id,

2228: mmt.primary_quantity * (acc.new_landed_cost - acc.prior_landed_cost),
2229: SYSDATE,
2230: fnd_global.user_id,
2231: SYSDATE,
2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,

Line 2233: fnd_global.login_id,

2229: SYSDATE,
2230: fnd_global.user_id,
2231: SYSDATE,
2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE

Line 2234: fnd_global.conc_request_id,

2230: fnd_global.user_id,
2231: SYSDATE,
2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE
2238: FROM cst_lc_mmt_gt mmt,

Line 2235: fnd_global.prog_appl_id,

2231: SYSDATE,
2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE
2238: FROM cst_lc_mmt_gt mmt,
2239: cst_lc_adj_acctg_info_gt acc

Line 2236: fnd_global.conc_program_id,

2232: fnd_global.user_id,
2233: fnd_global.login_id,
2234: fnd_global.conc_request_id,
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE
2238: FROM cst_lc_mmt_gt mmt,
2239: cst_lc_adj_acctg_info_gt acc
2240: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;

Line 2433: fnd_global.user_id,

2429: prior_landed_cost,
2430: new_landed_cost,
2431: group_id,
2432: SYSDATE,
2433: fnd_global.user_id,
2434: SYSDATE,
2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,

Line 2435: fnd_global.user_id,

2431: group_id,
2432: SYSDATE,
2433: fnd_global.user_id,
2434: SYSDATE,
2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,
2438: fnd_global.prog_appl_id,
2439: fnd_global.conc_program_id,

Line 2436: fnd_global.login_id,

2432: SYSDATE,
2433: fnd_global.user_id,
2434: SYSDATE,
2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,
2438: fnd_global.prog_appl_id,
2439: fnd_global.conc_program_id,
2440: SYSDATE

Line 2437: fnd_global.conc_request_id,

2433: fnd_global.user_id,
2434: SYSDATE,
2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,
2438: fnd_global.prog_appl_id,
2439: fnd_global.conc_program_id,
2440: SYSDATE
2441: FROM cst_lc_adj_interface

Line 2438: fnd_global.prog_appl_id,

2434: SYSDATE,
2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,
2438: fnd_global.prog_appl_id,
2439: fnd_global.conc_program_id,
2440: SYSDATE
2441: FROM cst_lc_adj_interface
2442: WHERE group_id = p_group_id

Line 2439: fnd_global.conc_program_id,

2435: fnd_global.user_id,
2436: fnd_global.login_id,
2437: fnd_global.conc_request_id,
2438: fnd_global.prog_appl_id,
2439: fnd_global.conc_program_id,
2440: SYSDATE
2441: FROM cst_lc_adj_interface
2442: WHERE group_id = p_group_id
2443: AND organization_id = p_organization_id

Line 2626: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2622: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2623: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2624: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2625: VALUES (p_group_id, transaction_id, 'NEW_LANDED_COST', 'The column cannot have negative value',
2626: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2627: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2628: WHEN prior_landed_cost < 0 THEN
2629: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2630: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2627: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2623: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2624: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2625: VALUES (p_group_id, transaction_id, 'NEW_LANDED_COST', 'The column cannot have negative value',
2626: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2627: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2628: WHEN prior_landed_cost < 0 THEN
2629: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2630: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2631: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2633: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2629: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2630: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2631: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2632: VALUES (p_group_id, transaction_id, 'PRIOR_LANDED_COST', 'The column cannot have negative value',
2633: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2634: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2635: WHEN closing_status <> 'O' THEN
2636: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2637: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2634: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2630: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2631: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2632: VALUES (p_group_id, transaction_id, 'PRIOR_LANDED_COST', 'The column cannot have negative value',
2633: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2634: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2635: WHEN closing_status <> 'O' THEN
2636: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2637: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2638: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2640: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2636: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2637: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2638: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2639: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2640: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2641: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2642: WHEN open_flag = 'N' THEN
2643: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2644: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2641: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2637: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2638: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2639: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2640: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2641: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2642: WHEN open_flag = 'N' THEN
2643: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2644: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2645: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2647: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2643: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2644: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2645: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2646: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Inventory Period is Closed',
2647: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2648: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2649: WHEN rcv_transaction_id = -1 THEN
2650: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2651: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2648: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2644: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2645: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2646: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Inventory Period is Closed',
2647: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2648: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2649: WHEN rcv_transaction_id = -1 THEN
2650: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2651: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2652: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2654: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2650: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2651: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2652: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2653: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'Invalid Rcv Transaction',
2654: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2655: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2656: WHEN destination_type_code = 'EXPENSE' OR destination_type_code = 'SHOP FLOOR' THEN
2657: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2658: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2655: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2651: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2652: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2653: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'Invalid Rcv Transaction',
2654: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2655: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2656: WHEN destination_type_code = 'EXPENSE' OR destination_type_code = 'SHOP FLOOR' THEN
2657: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2658: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2659: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2661: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,

2657: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2658: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2659: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2660: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2661: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2662: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2663: fnd_global.user_id, fnd_global.conc_request_id)
2664: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2665: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2662: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,

2658: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2659: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2660: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2661: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2662: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2663: fnd_global.user_id, fnd_global.conc_request_id)
2664: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2665: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2666: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2663: fnd_global.user_id, fnd_global.conc_request_id)

2659: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2660: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2661: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2662: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2663: fnd_global.user_id, fnd_global.conc_request_id)
2664: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2665: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2666: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2667: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2669: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2665: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2666: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2667: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2668: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'The receipt transaction is not the parent receipt',
2669: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2670: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2671: WHEN lcm_flag = 'N' THEN
2672: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2673: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2670: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2666: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2667: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2668: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'The receipt transaction is not the parent receipt',
2669: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2670: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2671: WHEN lcm_flag = 'N' THEN
2672: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2673: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2674: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2676: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2672: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2673: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2674: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2675: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'PO Shipment is not LCM Enabled',
2676: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2677: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2678: /* Bug 13960596 WHEN pol_item_id <> clai_inventory_item_id THEN */
2679: WHEN rcv_item_id <> clai_inventory_item_id THEN
2680: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2677: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2673: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2674: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2675: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'PO Shipment is not LCM Enabled',
2676: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2677: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2678: /* Bug 13960596 WHEN pol_item_id <> clai_inventory_item_id THEN */
2679: WHEN rcv_item_id <> clai_inventory_item_id THEN
2680: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2681: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2684: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,

2680: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2681: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2682: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2683: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2684: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2685: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2686: fnd_global.user_id, fnd_global.conc_request_id)
2687: WHEN rt_organization_id <> clai_organization_id THEN
2688: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2685: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,

2681: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2682: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2683: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2684: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2685: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2686: fnd_global.user_id, fnd_global.conc_request_id)
2687: WHEN rt_organization_id <> clai_organization_id THEN
2688: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2689: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2686: fnd_global.user_id, fnd_global.conc_request_id)

2682: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2683: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2684: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2685: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2686: fnd_global.user_id, fnd_global.conc_request_id)
2687: WHEN rt_organization_id <> clai_organization_id THEN
2688: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2689: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2690: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2692: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,

2688: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2689: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2690: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2691: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2692: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2693: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2694: fnd_global.conc_request_id)
2695: WHEN lcm_enabled_flag = 'N' THEN
2696: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2693: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,

2689: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2690: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2691: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2692: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2693: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2694: fnd_global.conc_request_id)
2695: WHEN lcm_enabled_flag = 'N' THEN
2696: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2697: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2694: fnd_global.conc_request_id)

2690: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2691: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2692: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2693: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2694: fnd_global.conc_request_id)
2695: WHEN lcm_enabled_flag = 'N' THEN
2696: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2697: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2698: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2700: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,

2696: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2697: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2698: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2699: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization is not LCM Enabled',
2700: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2701: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2702: WHEN nvl(lcm_account_id, -1) = -1 THEN
2703: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2704: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2701: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)

2697: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2698: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2699: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization is not LCM Enabled',
2700: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2701: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2702: WHEN nvl(lcm_account_id, -1) = -1 THEN
2703: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2704: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2705: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2707: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,

2703: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2704: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2705: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2706: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2707: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2708: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2709: fnd_global.user_id, fnd_global.conc_request_id)
2710: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2711: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2708: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,

2704: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2705: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2706: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2707: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2708: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2709: fnd_global.user_id, fnd_global.conc_request_id)
2710: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2711: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2712: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2709: fnd_global.user_id, fnd_global.conc_request_id)

2705: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2706: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2707: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2708: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2709: fnd_global.user_id, fnd_global.conc_request_id)
2710: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2711: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2712: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2713: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

Line 2715: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,

2711: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2712: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2713: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2714: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2715: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2716: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2717: fnd_global.user_id, fnd_global.conc_request_id)
2718: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2719: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,

Line 2716: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,

2712: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2713: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2714: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2715: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2716: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2717: fnd_global.user_id, fnd_global.conc_request_id)
2718: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2719: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,
2720: pod.destination_type_code, parent_transaction_id, transaction_type, Nvl(POLL.lcm_flag, 'N') lcm_flag,

Line 2717: fnd_global.user_id, fnd_global.conc_request_id)

2713: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2714: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2715: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2716: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2717: fnd_global.user_id, fnd_global.conc_request_id)
2718: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2719: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,
2720: pod.destination_type_code, parent_transaction_id, transaction_type, Nvl(POLL.lcm_flag, 'N') lcm_flag,
2721: /* Bug 13960596 pol.item_id pol_item_id, */

Line 2782: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,

2778: (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2779: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2780: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2781: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2782: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2783: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2784: FROM cst_lc_adj_interface clai,
2785: gl_period_statuses gps,
2786: cst_acct_info_v cai

Line 2783: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id

2779: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2780: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2781: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2782: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2783: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2784: FROM cst_lc_adj_interface clai,
2785: gl_period_statuses gps,
2786: cst_acct_info_v cai
2787: WHERE clai.group_id = p_group_id