229:
230: RETURN TRUE;
231: EXCEPTION
232: WHEN OTHERS THEN
233: IF g_debug <= gme_debug.g_log_unexpected THEN
234: gme_debug.put_line ( 'When others exception in '
235: || g_pkg_name
236: || '.'
237: || l_api_name
230: RETURN TRUE;
231: EXCEPTION
232: WHEN OTHERS THEN
233: IF g_debug <= gme_debug.g_log_unexpected THEN
234: gme_debug.put_line ( 'When others exception in '
235: || g_pkg_name
236: || '.'
237: || l_api_name
238: || ' Error is '
631: ,'TABLE_NAME'
632: ,g_table_name);
633: RETURN FALSE;
634: WHEN OTHERS THEN
635: IF g_debug <= gme_debug.g_log_unexpected THEN
636: gme_debug.put_line ( 'When others exception in '
637: || g_pkg_name
638: || '.'
639: || l_api_name
632: ,g_table_name);
633: RETURN FALSE;
634: WHEN OTHERS THEN
635: IF g_debug <= gme_debug.g_log_unexpected THEN
636: gme_debug.put_line ( 'When others exception in '
637: || g_pkg_name
638: || '.'
639: || l_api_name
640: || ' Error is '
760: ,'KEY'
761: ,TO_CHAR (p_material_detail.line_no) );
762: RETURN FALSE;
763: WHEN OTHERS THEN
764: IF g_debug <= gme_debug.g_log_unexpected THEN
765: gme_debug.put_line ( 'When others exception in '
766: || g_pkg_name
767: || '.'
768: || l_api_name
761: ,TO_CHAR (p_material_detail.line_no) );
762: RETURN FALSE;
763: WHEN OTHERS THEN
764: IF g_debug <= gme_debug.g_log_unexpected THEN
765: gme_debug.put_line ( 'When others exception in '
766: || g_pkg_name
767: || '.'
768: || l_api_name
769: || ' Error is '
1038: ,'KEY'
1039: ,TO_CHAR (p_material_detail.line_no) );
1040: RETURN FALSE;
1041: WHEN OTHERS THEN
1042: IF g_debug <= gme_debug.g_log_unexpected THEN
1043: gme_debug.put_line ( 'When others exception in '
1044: || g_pkg_name
1045: || '.'
1046: || l_api_name
1039: ,TO_CHAR (p_material_detail.line_no) );
1040: RETURN FALSE;
1041: WHEN OTHERS THEN
1042: IF g_debug <= gme_debug.g_log_unexpected THEN
1043: gme_debug.put_line ( 'When others exception in '
1044: || g_pkg_name
1045: || '.'
1046: || l_api_name
1047: || ' Error is '
1110: WHERE batch_id = l_batch_id
1111: AND line_no = l_line_no
1112: AND line_type = l_line_type;
1113: BEGIN
1114: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1115: gme_debug.put_line ( l_api_name
1116: || ' in fetch_tab. batch_id= '
1117: || p_material_detail.batch_id);
1118: END IF;
1111: AND line_no = l_line_no
1112: AND line_type = l_line_type;
1113: BEGIN
1114: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1115: gme_debug.put_line ( l_api_name
1116: || ' in fetch_tab. batch_id= '
1117: || p_material_detail.batch_id);
1118: END IF;
1119:
1192: ,'TABLE_NAME'
1193: ,g_table_name);
1194: RETURN FALSE;
1195: WHEN OTHERS THEN
1196: IF g_debug <= gme_debug.g_log_unexpected THEN
1197: gme_debug.put_line ( 'When others exception in '
1198: || g_pkg_name
1199: || '.'
1200: || l_api_name
1193: ,g_table_name);
1194: RETURN FALSE;
1195: WHEN OTHERS THEN
1196: IF g_debug <= gme_debug.g_log_unexpected THEN
1197: gme_debug.put_line ( 'When others exception in '
1198: || g_pkg_name
1199: || '.'
1200: || l_api_name
1201: || ' Error is '