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 CST_LC_ADJ_INTERFACE_ERRORS

Line 911: INSERT INTO cst_lc_adj_interface_errors

907: l_error_msg := 'Retrieval of ' || c_account.accounting_line_type || ' account' ||
908: ' from client extension errored out with: ' || '(' || substr(l_error_code, 10) || ') - ' || substr(Nvl(l_error_msg, 'Unknown Error'), 100);
909:
910: l_stmt_num := 110;
911: INSERT INTO cst_lc_adj_interface_errors
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,

Line 951: FROM cst_lc_adj_interface_errors e

947: WHERE group_id = p_group_id
948: AND process_status IN (1,2)
949: AND organization_id = p_organization_id
950: AND EXISTS (SELECT 1
951: FROM cst_lc_adj_interface_errors e
952: WHERE e.transaction_id = i.transaction_id
953: AND e.group_id = p_group_id
954: AND error_column = 'ACCOUNT');
955:

Line 969: FROM cst_lc_adj_interface_errors e

965:
966: l_stmt_num := 150;
967: DELETE FROM cst_lc_accounts_gt t
968: WHERE EXISTS (SELECT 1
969: FROM cst_lc_adj_interface_errors e
970: WHERE e.transaction_id = t.lcm_transaction_id
971: AND e.group_id = p_group_id
972: AND error_column = 'ACCOUNT');
973:

Line 987: FROM cst_lc_adj_interface_errors e

983:
984: l_stmt_num := 160;
985: DELETE FROM cst_lc_rcv_txn_gt t
986: WHERE EXISTS (SELECT 1
987: FROM cst_lc_adj_interface_errors e
988: WHERE e.transaction_id = t.lcm_transaction_id
989: AND e.group_id = p_group_id
990: AND error_column = 'ACCOUNT');
991:

Line 1005: FROM cst_lc_adj_interface_errors e

1001:
1002: l_stmt_num := 170;
1003: DELETE FROM cst_lc_adj_acctg_info_gt t
1004: WHERE EXISTS (SELECT 1
1005: FROM cst_lc_adj_interface_errors e
1006: WHERE e.transaction_id = t.lcm_transaction_id
1007: AND e.group_id = p_group_id
1008: AND error_column = 'ACCOUNT');
1009:

Line 2525: | CST_LC_ADJ_INTERFACE_ERRORS and updates the process_status|

2521: | PROCEDURE : Validate_Lc_Interface |
2522: | |
2523: | DESCRIPTION : This procedure validates unvalidated interface records, |
2524: | populates details of failed validation into table |
2525: | CST_LC_ADJ_INTERFACE_ERRORS and updates the process_status|
2526: | of interface records to validated = 2 or errored = 3. |
2527: | |
2528: | |
2529: | |

Line 2618: the cst_lc_adj_interface_errors table and the adjustment interface record will be

2614: l_stmt_num := 10;
2615:
2616: /* Validating the lcm adjustments.
2617: A record will be created for each, lcm adjustment transaction and error combination in
2618: the cst_lc_adj_interface_errors table and the adjustment interface record will be
2619: set to error status */
2620: INSERT ALL
2621: WHEN new_landed_cost < 0 THEN
2622: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

Line 2622: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

2618: the cst_lc_adj_interface_errors table and the adjustment interface record will be
2619: set to error status */
2620: INSERT ALL
2621: WHEN new_landed_cost < 0 THEN
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,

Line 2629: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2636: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2643: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2650: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2657: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
2660: VALUES (p_group_id, transaction_id, 'RCV_TRANSACTION_ID',
2661: 'Destination type is set to ' || destination_type_code, fnd_global.user_id, SYSDATE,

Line 2665: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2672: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2680: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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,
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,

Line 2688: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2696: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2703: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2711: INTO cst_lc_adj_interface_errors (GROUP_ID, transaction_id, error_column, error_message, CREATED_BY,

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)
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,

Line 2777: INSERT INTO cst_lc_adj_interface_errors

2773: END IF;
2774:
2775: l_stmt_num := 20;
2776: /* For already validated transactions only check if PO period is still open */
2777: INSERT INTO cst_lc_adj_interface_errors
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',

Line 2817: FROM cst_lc_adj_interface_errors e

2813: WHERE group_id = p_group_id
2814: AND process_status IN (1,2)
2815: AND organization_id = p_organization_id
2816: AND EXISTS (SELECT 1
2817: FROM cst_lc_adj_interface_errors e
2818: WHERE e.transaction_id = i.transaction_id
2819: AND e.group_id = p_group_id);
2820:
2821: IF (l_sLog AND l_pLog) THEN