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 1407: fnd_global.user_id,

1403: Decode(adj_acc.debit_credit_flag, 1, acc.receiving_account, adj_acc.account) CREDIT_ACCOUNT_ID,
1404: Decode(adj_acc.debit_credit_flag, -1, acc.receiving_account, adj_acc.account) DEBIT_ACCOUNT_ID,
1405: Decode(adj_acc.debit_credit_flag, 1, 'Receiving Inspection', adj_acc.accounting_line_type) CREDIT_ACCOUNTING_LINE_TYPE,
1406: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1407: fnd_global.user_id,
1408: SYSDATE,
1409: fnd_global.prog_appl_id,
1410: fnd_global.conc_program_id,
1411: SYSDATE,

Line 1409: fnd_global.prog_appl_id,

1405: Decode(adj_acc.debit_credit_flag, 1, 'Receiving Inspection', adj_acc.accounting_line_type) CREDIT_ACCOUNTING_LINE_TYPE,
1406: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1407: fnd_global.user_id,
1408: SYSDATE,
1409: fnd_global.prog_appl_id,
1410: fnd_global.conc_program_id,
1411: SYSDATE,
1412: SYSDATE,
1413: fnd_global.login_id,

Line 1410: fnd_global.conc_program_id,

1406: Decode(adj_acc.debit_credit_flag, -1, 'Receiving Inspection', adj_acc.accounting_line_type) DEBIT_ACCOUNTING_LINE_TYPE,
1407: fnd_global.user_id,
1408: SYSDATE,
1409: fnd_global.prog_appl_id,
1410: fnd_global.conc_program_id,
1411: SYSDATE,
1412: SYSDATE,
1413: fnd_global.login_id,
1414: fnd_global.user_id,

Line 1413: fnd_global.login_id,

1409: fnd_global.prog_appl_id,
1410: fnd_global.conc_program_id,
1411: SYSDATE,
1412: SYSDATE,
1413: fnd_global.login_id,
1414: fnd_global.user_id,
1415: fnd_global.conc_request_id,
1416: 'N'
1417: FROM cst_lc_adj_acctg_info_gt acc,

Line 1414: fnd_global.user_id,

1410: fnd_global.conc_program_id,
1411: SYSDATE,
1412: SYSDATE,
1413: fnd_global.login_id,
1414: fnd_global.user_id,
1415: fnd_global.conc_request_id,
1416: 'N'
1417: FROM cst_lc_adj_acctg_info_gt acc,
1418: cst_lc_rcv_txn_gt rt,

Line 1415: fnd_global.conc_request_id,

1411: SYSDATE,
1412: SYSDATE,
1413: fnd_global.login_id,
1414: fnd_global.user_id,
1415: fnd_global.conc_request_id,
1416: 'N'
1417: FROM cst_lc_adj_acctg_info_gt acc,
1418: cst_lc_rcv_txn_gt rt,
1419: cst_lc_accounts_gt adj_acc

Line 1515: fnd_global.user_id,

1511: mmt.cost_group_id,
1512: sum(mmt.primary_quantity),
1513: sum(mmt.primary_quantity) * (acc.new_landed_cost - acc.prior_landed_cost),
1514: SYSDATE,
1515: fnd_global.user_id,
1516: SYSDATE,
1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,

Line 1517: fnd_global.user_id,

1513: sum(mmt.primary_quantity) * (acc.new_landed_cost - acc.prior_landed_cost),
1514: SYSDATE,
1515: fnd_global.user_id,
1516: SYSDATE,
1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,
1520: fnd_global.prog_appl_id,
1521: fnd_global.conc_program_id,

Line 1518: fnd_global.login_id,

1514: SYSDATE,
1515: fnd_global.user_id,
1516: SYSDATE,
1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,
1520: fnd_global.prog_appl_id,
1521: fnd_global.conc_program_id,
1522: SYSDATE,

Line 1519: fnd_global.conc_request_id,

1515: fnd_global.user_id,
1516: SYSDATE,
1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,
1520: fnd_global.prog_appl_id,
1521: fnd_global.conc_program_id,
1522: SYSDATE,
1523: acc.inventory_item_id,

Line 1520: fnd_global.prog_appl_id,

1516: SYSDATE,
1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,
1520: fnd_global.prog_appl_id,
1521: fnd_global.conc_program_id,
1522: SYSDATE,
1523: acc.inventory_item_id,
1524: acc.organization_id,

Line 1521: fnd_global.conc_program_id,

1517: fnd_global.user_id,
1518: fnd_global.login_id,
1519: fnd_global.conc_request_id,
1520: fnd_global.prog_appl_id,
1521: fnd_global.conc_program_id,
1522: SYSDATE,
1523: acc.inventory_item_id,
1524: acc.organization_id,
1525: acc.transaction_date,

Line 1651: fnd_global.user_id,

1647: txn.cost_group_id,
1648: sum(txn.layer_quantity),
1649: txn.value_change,
1650: SYSDATE,
1651: fnd_global.user_id,
1652: SYSDATE,
1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,

Line 1653: fnd_global.user_id,

1649: txn.value_change,
1650: SYSDATE,
1651: fnd_global.user_id,
1652: SYSDATE,
1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,
1656: fnd_global.prog_appl_id,
1657: fnd_global.conc_program_id,

Line 1654: fnd_global.login_id,

1650: SYSDATE,
1651: fnd_global.user_id,
1652: SYSDATE,
1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,
1656: fnd_global.prog_appl_id,
1657: fnd_global.conc_program_id,
1658: SYSDATE,

Line 1655: fnd_global.conc_request_id,

1651: fnd_global.user_id,
1652: SYSDATE,
1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,
1656: fnd_global.prog_appl_id,
1657: fnd_global.conc_program_id,
1658: SYSDATE,
1659: txn.inventory_item_id,

Line 1656: fnd_global.prog_appl_id,

1652: SYSDATE,
1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,
1656: fnd_global.prog_appl_id,
1657: fnd_global.conc_program_id,
1658: SYSDATE,
1659: txn.inventory_item_id,
1660: txn.organization_id,

Line 1657: fnd_global.conc_program_id,

1653: fnd_global.user_id,
1654: fnd_global.login_id,
1655: fnd_global.conc_request_id,
1656: fnd_global.prog_appl_id,
1657: fnd_global.conc_program_id,
1658: SYSDATE,
1659: txn.inventory_item_id,
1660: txn.organization_id,
1661: txn.transaction_date,

Line 2025: fnd_global.user_id,

2021: entered_nr_tax,
2022: entered_rec_tax
2023: )
2024: SELECT
2025: fnd_global.user_id,
2026: SYSDATE,
2027: fnd_global.prog_appl_id,
2028: fnd_global.conc_program_id,
2029: SYSDATE,

Line 2027: fnd_global.prog_appl_id,

2023: )
2024: SELECT
2025: fnd_global.user_id,
2026: SYSDATE,
2027: fnd_global.prog_appl_id,
2028: fnd_global.conc_program_id,
2029: SYSDATE,
2030: SYSDATE,
2031: fnd_global.login_id,

Line 2028: fnd_global.conc_program_id,

2024: SELECT
2025: fnd_global.user_id,
2026: SYSDATE,
2027: fnd_global.prog_appl_id,
2028: fnd_global.conc_program_id,
2029: SYSDATE,
2030: SYSDATE,
2031: fnd_global.login_id,
2032: fnd_global.user_id,

Line 2031: fnd_global.login_id,

2027: fnd_global.prog_appl_id,
2028: fnd_global.conc_program_id,
2029: SYSDATE,
2030: SYSDATE,
2031: fnd_global.login_id,
2032: fnd_global.user_id,
2033: fnd_global.conc_request_id,
2034: rcv_receiving_sub_ledger_s.nextval,
2035: rae.accounting_event_id,

Line 2032: fnd_global.user_id,

2028: fnd_global.conc_program_id,
2029: SYSDATE,
2030: SYSDATE,
2031: fnd_global.login_id,
2032: fnd_global.user_id,
2033: fnd_global.conc_request_id,
2034: rcv_receiving_sub_ledger_s.nextval,
2035: rae.accounting_event_id,
2036: rae.debit_accounting_line_type,

Line 2033: fnd_global.conc_request_id,

2029: SYSDATE,
2030: SYSDATE,
2031: fnd_global.login_id,
2032: fnd_global.user_id,
2033: fnd_global.conc_request_id,
2034: rcv_receiving_sub_ledger_s.nextval,
2035: rae.accounting_event_id,
2036: rae.debit_accounting_line_type,
2037: rae.rcv_transaction_id,

Line 2127: fnd_global.user_id,

2123: accounted_rec_tax,
2124: entered_nr_tax,
2125: entered_rec_tax)
2126: SELECT
2127: fnd_global.user_id,
2128: SYSDATE,
2129: fnd_global.prog_appl_id,
2130: fnd_global.conc_program_id,
2131: SYSDATE,

Line 2129: fnd_global.prog_appl_id,

2125: entered_rec_tax)
2126: SELECT
2127: fnd_global.user_id,
2128: SYSDATE,
2129: fnd_global.prog_appl_id,
2130: fnd_global.conc_program_id,
2131: SYSDATE,
2132: SYSDATE,
2133: fnd_global.login_id,

Line 2130: fnd_global.conc_program_id,

2126: SELECT
2127: fnd_global.user_id,
2128: SYSDATE,
2129: fnd_global.prog_appl_id,
2130: fnd_global.conc_program_id,
2131: SYSDATE,
2132: SYSDATE,
2133: fnd_global.login_id,
2134: fnd_global.user_id,

Line 2133: fnd_global.login_id,

2129: fnd_global.prog_appl_id,
2130: fnd_global.conc_program_id,
2131: SYSDATE,
2132: SYSDATE,
2133: fnd_global.login_id,
2134: fnd_global.user_id,
2135: fnd_global.conc_request_id,
2136: rcv_receiving_sub_ledger_s.NEXTVAL,
2137: rae.accounting_event_id,

Line 2134: fnd_global.user_id,

2130: fnd_global.conc_program_id,
2131: SYSDATE,
2132: SYSDATE,
2133: fnd_global.login_id,
2134: fnd_global.user_id,
2135: fnd_global.conc_request_id,
2136: rcv_receiving_sub_ledger_s.NEXTVAL,
2137: rae.accounting_event_id,
2138: rae.credit_accounting_line_type,

Line 2135: fnd_global.conc_request_id,

2131: SYSDATE,
2132: SYSDATE,
2133: fnd_global.login_id,
2134: fnd_global.user_id,
2135: fnd_global.conc_request_id,
2136: rcv_receiving_sub_ledger_s.NEXTVAL,
2137: rae.accounting_event_id,
2138: rae.credit_accounting_line_type,
2139: rae.rcv_transaction_id,

Line 2212: fnd_global.user_id,

2208: 1,
2209: 1,
2210: mmt.primary_quantity * (acc.new_landed_cost - acc.prior_landed_cost),
2211: SYSDATE,
2212: fnd_global.user_id,
2213: SYSDATE,
2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,

Line 2214: fnd_global.user_id,

2210: mmt.primary_quantity * (acc.new_landed_cost - acc.prior_landed_cost),
2211: SYSDATE,
2212: fnd_global.user_id,
2213: SYSDATE,
2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,

Line 2215: fnd_global.login_id,

2211: SYSDATE,
2212: fnd_global.user_id,
2213: SYSDATE,
2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE

Line 2216: fnd_global.conc_request_id,

2212: fnd_global.user_id,
2213: SYSDATE,
2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE
2220: FROM cst_lc_mmt_gt mmt,

Line 2217: fnd_global.prog_appl_id,

2213: SYSDATE,
2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE
2220: FROM cst_lc_mmt_gt mmt,
2221: cst_lc_adj_acctg_info_gt acc

Line 2218: fnd_global.conc_program_id,

2214: fnd_global.user_id,
2215: fnd_global.login_id,
2216: fnd_global.conc_request_id,
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE
2220: FROM cst_lc_mmt_gt mmt,
2221: cst_lc_adj_acctg_info_gt acc
2222: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;

Line 2415: fnd_global.user_id,

2411: prior_landed_cost,
2412: new_landed_cost,
2413: group_id,
2414: SYSDATE,
2415: fnd_global.user_id,
2416: SYSDATE,
2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,

Line 2417: fnd_global.user_id,

2413: group_id,
2414: SYSDATE,
2415: fnd_global.user_id,
2416: SYSDATE,
2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,
2420: fnd_global.prog_appl_id,
2421: fnd_global.conc_program_id,

Line 2418: fnd_global.login_id,

2414: SYSDATE,
2415: fnd_global.user_id,
2416: SYSDATE,
2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,
2420: fnd_global.prog_appl_id,
2421: fnd_global.conc_program_id,
2422: SYSDATE

Line 2419: fnd_global.conc_request_id,

2415: fnd_global.user_id,
2416: SYSDATE,
2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,
2420: fnd_global.prog_appl_id,
2421: fnd_global.conc_program_id,
2422: SYSDATE
2423: FROM cst_lc_adj_interface

Line 2420: fnd_global.prog_appl_id,

2416: SYSDATE,
2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,
2420: fnd_global.prog_appl_id,
2421: fnd_global.conc_program_id,
2422: SYSDATE
2423: FROM cst_lc_adj_interface
2424: WHERE group_id = p_group_id

Line 2421: fnd_global.conc_program_id,

2417: fnd_global.user_id,
2418: fnd_global.login_id,
2419: fnd_global.conc_request_id,
2420: fnd_global.prog_appl_id,
2421: fnd_global.conc_program_id,
2422: SYSDATE
2423: FROM cst_lc_adj_interface
2424: WHERE group_id = p_group_id
2425: AND organization_id = p_organization_id

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

2604: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2605: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2606: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2607: VALUES (p_group_id, transaction_id, 'NEW_LANDED_COST', 'The column cannot have negative value',
2608: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2609: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2610: WHEN prior_landed_cost < 0 THEN
2611: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2612: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2605: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2606: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2607: VALUES (p_group_id, transaction_id, 'NEW_LANDED_COST', 'The column cannot have negative value',
2608: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2609: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2610: WHEN prior_landed_cost < 0 THEN
2611: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2612: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2613: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2611: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2612: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2613: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2614: VALUES (p_group_id, transaction_id, 'PRIOR_LANDED_COST', 'The column cannot have negative value',
2615: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2616: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2617: WHEN closing_status <> 'O' THEN
2618: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2619: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2612: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2613: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2614: VALUES (p_group_id, transaction_id, 'PRIOR_LANDED_COST', 'The column cannot have negative value',
2615: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2616: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2617: WHEN closing_status <> 'O' THEN
2618: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2619: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2620: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2618: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2619: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2620: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2621: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2622: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2623: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2624: WHEN open_flag = 'N' THEN
2625: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2626: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2619: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2620: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2621: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2622: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2623: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2624: WHEN open_flag = 'N' THEN
2625: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2626: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2627: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2625: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2626: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2627: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2628: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Inventory Period is Closed',
2629: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2630: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2631: WHEN rcv_transaction_id = -1 THEN
2632: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2633: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2626: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2627: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2628: VALUES (p_group_id, transaction_id, 'TRANSACTION_DATE', 'Inventory Period is Closed',
2629: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2630: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2631: WHEN rcv_transaction_id = -1 THEN
2632: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2633: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2634: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2632: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2633: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2634: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2635: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'Invalid Rcv Transaction',
2636: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2637: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2638: WHEN destination_type_code = 'EXPENSE' OR destination_type_code = 'SHOP FLOOR' THEN
2639: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2640: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2633: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2634: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2635: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'Invalid Rcv Transaction',
2636: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2637: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2638: WHEN destination_type_code = 'EXPENSE' OR destination_type_code = 'SHOP FLOOR' THEN
2639: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2640: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2641: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2639: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2640: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2641: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2642: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2643: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2644: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2645: fnd_global.user_id, fnd_global.conc_request_id)
2646: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2647: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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

2640: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2641: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2642: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2643: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2644: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2645: fnd_global.user_id, fnd_global.conc_request_id)
2646: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2647: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2648: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2645: fnd_global.user_id, fnd_global.conc_request_id)

2641: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2642: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2643: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,
2644: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2645: fnd_global.user_id, fnd_global.conc_request_id)
2646: WHEN NOT (parent_transaction_id = -1 AND transaction_type IN ('RECEIVE', 'MATCH') ) THEN
2647: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2648: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2649: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2647: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2648: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2649: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2650: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'The receipt transaction is not the parent receipt',
2651: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2652: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2653: WHEN lcm_flag = 'N' THEN
2654: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2655: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2648: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2649: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2650: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'The receipt transaction is not the parent receipt',
2651: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2652: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2653: WHEN lcm_flag = 'N' THEN
2654: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2655: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2656: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2654: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2655: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2656: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2657: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'PO Shipment is not LCM Enabled',
2658: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2659: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2660: WHEN pol_item_id <> clai_inventory_item_id THEN
2661: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2662: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2655: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2656: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2657: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID', 'PO Shipment is not LCM Enabled',
2658: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2659: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2660: WHEN pol_item_id <> clai_inventory_item_id THEN
2661: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2662: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2663: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2661: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2662: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2663: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2664: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2665: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2666: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2667: fnd_global.user_id, fnd_global.conc_request_id)
2668: WHEN rt_organization_id <> clai_organization_id THEN
2669: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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

2662: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2663: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2664: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2665: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2666: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2667: fnd_global.user_id, fnd_global.conc_request_id)
2668: WHEN rt_organization_id <> clai_organization_id THEN
2669: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2670: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2667: fnd_global.user_id, fnd_global.conc_request_id)

2663: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2664: VALUES (p_group_id, transaction_id, 'INVENTORY_ITEM_ID',
2665: 'Item Id in adjustment transaction and original receipt donot match', fnd_global.user_id, SYSDATE,
2666: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2667: fnd_global.user_id, fnd_global.conc_request_id)
2668: WHEN rt_organization_id <> clai_organization_id THEN
2669: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2670: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2671: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2669: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2670: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2671: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2672: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2673: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2674: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2675: fnd_global.conc_request_id)
2676: WHEN lcm_enabled_flag = 'N' THEN
2677: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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

2670: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2671: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2672: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2673: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2674: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2675: fnd_global.conc_request_id)
2676: WHEN lcm_enabled_flag = 'N' THEN
2677: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2678: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2675: fnd_global.conc_request_id)

2671: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2672: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization Id in adjustment transaction
2673: and original receipt donot match', fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id,
2674: fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id,
2675: fnd_global.conc_request_id)
2676: WHEN lcm_enabled_flag = 'N' THEN
2677: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2678: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2679: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2677: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2678: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2679: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2680: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization is not LCM Enabled',
2681: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2682: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2683: WHEN nvl(lcm_account_id, -1) = -1 THEN
2684: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2685: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

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

2678: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2679: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2680: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID', 'Organization is not LCM Enabled',
2681: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE,
2682: fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id)
2683: WHEN nvl(lcm_account_id, -1) = -1 THEN
2684: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2685: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2686: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2684: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2685: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2686: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2687: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2688: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2689: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2690: fnd_global.user_id, fnd_global.conc_request_id)
2691: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2692: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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

2685: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2686: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2687: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2688: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2689: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2690: fnd_global.user_id, fnd_global.conc_request_id)
2691: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2692: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2693: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,

Line 2690: fnd_global.user_id, fnd_global.conc_request_id)

2686: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2687: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2688: 'Landed cost absorption account is not defined for the organization', fnd_global.user_id, SYSDATE,
2689: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2690: fnd_global.user_id, fnd_global.conc_request_id)
2691: WHEN Decode(primary_cost_method, 1, 0, Nvl(lcm_var_account, -1)) = -1 THEN
2692: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2693: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2694: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)

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

2692: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2693: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2694: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2695: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2696: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2697: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2698: fnd_global.user_id, fnd_global.conc_request_id)
2699: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2700: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,

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

2693: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2694: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2695: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2696: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2697: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2698: fnd_global.user_id, fnd_global.conc_request_id)
2699: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2700: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,
2701: pod.destination_type_code, parent_transaction_id, transaction_type, Nvl(POLL.lcm_flag, 'N') lcm_flag,

Line 2698: fnd_global.user_id, fnd_global.conc_request_id)

2694: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2695: VALUES (p_group_id, transaction_id, 'ORGANIZATION_ID',
2696: 'Landed cost variance account is not defined for the organization', fnd_global.user_id, SYSDATE,
2697: fnd_global.prog_appl_id, fnd_global.conc_program_id, SYSDATE, SYSDATE, fnd_global.login_id,
2698: fnd_global.user_id, fnd_global.conc_request_id)
2699: SELECT distinct clai.transaction_id, clai.rcv_transaction_id, new_landed_cost, prior_landed_cost,
2700: gps.closing_status, open_flag, Nvl(rt.transaction_id, -1) recv_transaction_id,
2701: pod.destination_type_code, parent_transaction_id, transaction_type, Nvl(POLL.lcm_flag, 'N') lcm_flag,
2702: pol.item_id pol_item_id,

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

2756: (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,
2757: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2758: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2759: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2760: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2761: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2762: FROM cst_lc_adj_interface clai,
2763: gl_period_statuses gps,
2764: cst_acct_info_v cai

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

2757: CREATION_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE,
2758: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, REQUEST_ID)
2759: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2760: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2761: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2762: FROM cst_lc_adj_interface clai,
2763: gl_period_statuses gps,
2764: cst_acct_info_v cai
2765: WHERE clai.group_id = p_group_id