APPS.INL_INTERFACE_PVT dependencies on INL_INTERFACE_ERRORS

Line 387: INSERT INTO inl_interface_errors (

383: p_module_name => g_module_name,
384: p_procedure_name => l_program_name,
385: p_debug_info => l_debug_info) ;
386:
387: INSERT INTO inl_interface_errors (
388: interface_error_id, /*01*/
389: parent_table_name, /*02*/
390: parent_table_id, /*03*/
391: column_name, /*04*/

Line 419: inl_interface_errors_s.NEXTVAL,/*01*/

415: program_update_date, /*28*/
416: request_id /*29*/
417: )
418: VALUES (
419: inl_interface_errors_s.NEXTVAL,/*01*/
420: p_parent_table_name, /*02*/
421: p_parent_table_id, /*03*/
422: p_column_name, /*04*/
423: p_column_value, /*05*/

Line 518: FROM inl_interface_errors

514: p_procedure_name => l_program_name,
515: p_debug_info => l_debug_info
516: ) ;
517: DELETE
518: FROM inl_interface_errors
519: WHERE parent_table_name = p_parent_table_name
520: AND parent_table_id = p_parent_table_id;
521: -- Standard End of Procedure/Function Logging
522: INL_LOGGING_PVT.Log_EndProc(

Line 15154: -- Bug 13920858: Commented the code to avoid Error Messages getting Inserted into INL_INTERFACE_ERRORS table.

15150:
15151: ELSE
15152: IF g_records_processed = 0 THEN
15153: -- Add a line into inl_ship_errors
15154: -- Bug 13920858: Commented the code to avoid Error Messages getting Inserted into INL_INTERFACE_ERRORS table.
15155: l_debug_info := 'Error Mesage: No records found for processing.';
15156: INL_LOGGING_PVT.Log_Statement(
15157: p_module_name => g_module_name,
15158: p_procedure_name => l_program_name,

Line 16215: INSERT INTO inl_interface_errors (

16211: p_procedure_name => l_program_name,
16212: p_debug_info => l_debug_info
16213: ) ;
16214:
16215: INSERT INTO inl_interface_errors (
16216: interface_error_id, /*01*/
16217: parent_table_name, /*02*/
16218: parent_table_id, /*03*/
16219: column_name, /*04*/

Line 16237: inl_interface_errors_s.NEXTVAL, /*01*/

16233: program_update_date, /*18*/
16234: request_id /*19*/
16235: )
16236: SELECT
16237: inl_interface_errors_s.NEXTVAL, /*01*/
16238: 'INL_SHIP_HEADERS_INT', /*02*/
16239: h.ship_header_int_id, /*03*/
16240: 'ship_header_int_id', /*04*/
16241: h.ship_header_int_id, /*05*/

Line 17408: -- -- Bug 13920858: Commented the code to avoid Error Messages getting Inserted into INL_INTERFACE_ERRORS table.

17404: --Bug#10381495
17405:
17406: IF NVL(G_RECORDS_PROCESSED,0) = 0 THEN
17407: -- Add a line into inl_ship_errors, No records found for processing
17408: -- -- Bug 13920858: Commented the code to avoid Error Messages getting Inserted into INL_INTERFACE_ERRORS table.
17409: l_debug_info := 'Error Mesage: No records found for processing.';
17410: INL_LOGGING_PVT.Log_Statement(
17411: p_module_name => g_module_name,
17412: p_procedure_name => l_program_name,