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.EC_INBOUND_STAGE dependencies on EC_INBOUND_STAGE

Line 1: PACKAGE BODY EC_INBOUND_STAGE AS

1: PACKAGE BODY EC_INBOUND_STAGE AS
2: -- $Header: ECISTGB.pls 120.4 2005/09/29 10:38:49 arsriniv ship $
3:
4: --- Local PL/SQL table variables.
5: --- i_stage_record_type Stage_Record_Type;

Line 91: ec_debug.push('EC_INBOUND_STAGE.LOAD_DATA');

87: i_location_code_pos number;
88:
89: BEGIN
90: if EC_DEBUG.G_debug_level >= 2 then
91: ec_debug.push('EC_INBOUND_STAGE.LOAD_DATA');
92: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
93: ec_debug.pl(3,'i_file_name',i_file_name);
94: ec_debug.pl(3,'i_file_path',i_file_path);
95: ec_debug.pl(3,'i_map_id',i_map_id);

Line 208: if ec_inbound_stage.g_source_charset IS NULL then

204: end if;
205:
206: -- Bug 2162062
207:
208: if ec_inbound_stage.g_source_charset IS NULL then
209: select value
210: into ec_inbound_stage.g_source_charset
211: from v$nls_parameters
212: where parameter='NLS_CHARACTERSET';

Line 210: into ec_inbound_stage.g_source_charset

206: -- Bug 2162062
207:
208: if ec_inbound_stage.g_source_charset IS NULL then
209: select value
210: into ec_inbound_stage.g_source_charset
211: from v$nls_parameters
212: where parameter='NLS_CHARACTERSET';
213: end if;
214:

Line 219: select value,decode(value,ec_inbound_stage.g_source_charset,'Y','N')

215: -- Get the character set from the profile option and verify it with fnd_lookups,and database settings.
216: -- bug 2110652
217:
218:
219: select value,decode(value,ec_inbound_stage.g_source_charset,'Y','N')
220: into i_db_charset,i_db_charset_flag
221: from v$nls_parameters
222: where parameter = 'NLS_CHARACTERSET';
223:

Line 236: and lookup_code = ec_inbound_stage.g_source_charset;

232: select 'Y'
233: into i_fnd_charset_flag
234: from fnd_lookups
235: where lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
236: and lookup_code = ec_inbound_stage.g_source_charset;
237:
238: if sql%notfound then
239: ec_debug.pl(0,'Invalid Character Set specified in the FND_LOOKUPS');
240: EC_UTILS.i_ret_code := 2;

Line 600: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA');

596: end if;
597: <>
598: if EC_DEBUG.G_debug_level >= 1 then
599: ec_debug.pl(1,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',i_document_number);
600: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA');
601: end if;
602: EXCEPTION
603: WHEN UTL_FILE.write_error THEN
604: EC_UTILS.i_ret_code :=2;

Line 606: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

602: EXCEPTION
603: WHEN UTL_FILE.write_error THEN
604: EC_UTILS.i_ret_code :=2;
605: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
606: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
607: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
608: utl_file.fclose(u_file_handle);
609: raise EC_UTILS.PROGRAM_EXIT;
610: WHEN UTL_FILE.read_error THEN

Line 613: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

609: raise EC_UTILS.PROGRAM_EXIT;
610: WHEN UTL_FILE.read_error THEN
611: EC_UTILS.i_ret_code :=2;
612: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
613: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
614: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
615: utl_file.fclose(u_file_handle);
616: raise EC_UTILS.PROGRAM_EXIT;
617: WHEN UTL_FILE.invalid_path THEN

Line 620: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

616: raise EC_UTILS.PROGRAM_EXIT;
617: WHEN UTL_FILE.invalid_path THEN
618: EC_UTILS.i_ret_code :=2;
619: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
620: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
621: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
622: utl_file.fclose(u_file_handle);
623: raise EC_UTILS.PROGRAM_EXIT;
624: WHEN UTL_FILE.invalid_mode THEN

Line 627: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

623: raise EC_UTILS.PROGRAM_EXIT;
624: WHEN UTL_FILE.invalid_mode THEN
625: EC_UTILS.i_ret_code :=2;
626: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
627: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
628: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
629: utl_file.fclose(u_file_handle);
630: raise EC_UTILS.PROGRAM_EXIT;
631: WHEN UTL_FILE.invalid_operation THEN

Line 634: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

630: raise EC_UTILS.PROGRAM_EXIT;
631: WHEN UTL_FILE.invalid_operation THEN
632: EC_UTILS.i_ret_code :=2;
633: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
634: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
635: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
636: utl_file.fclose(u_file_handle);
637: raise EC_UTILS.PROGRAM_EXIT;
638: WHEN UTL_FILE.invalid_filehandle THEN

Line 641: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

637: raise EC_UTILS.PROGRAM_EXIT;
638: WHEN UTL_FILE.invalid_filehandle THEN
639: EC_UTILS.i_ret_code :=2;
640: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
641: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
642: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
643: utl_file.fclose(u_file_handle);
644: raise EC_UTILS.PROGRAM_EXIT;
645: WHEN UTL_FILE.internal_error THEN

Line 648: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

644: raise EC_UTILS.PROGRAM_EXIT;
645: WHEN UTL_FILE.internal_error THEN
646: EC_UTILS.i_ret_code :=2;
647: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
648: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
649: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
650: utl_file.fclose(u_file_handle);
651: raise EC_UTILS.PROGRAM_EXIT;
652: WHEN EC_UTILS.PROGRAM_EXIT THEN

Line 656: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');

652: WHEN EC_UTILS.PROGRAM_EXIT THEN
653: raise;
654: WHEN OTHERS THEN
655: EC_UTILS.i_ret_code :=2;
656: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
657: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
658: utl_file.fclose(u_file_handle);
659: raise EC_UTILS.PROGRAM_EXIT;
660: END Load_Data;

Line 684: ec_debug.push('EC_INBOUND_STAGE.MATCH_RECORD_NUM');

680: i_total_unit NUMBER :=0;
681:
682: begin
683: if EC_DEBUG.G_debug_level >= 2 then
684: ec_debug.push('EC_INBOUND_STAGE.MATCH_RECORD_NUM');
685: ec_debug.pl(3,'i_current_level',i_current_level);
686: ec_debug.pl(3,'i_record_num',i_record_num);
687: end if;
688: for k in i_next_file_pos..i_stage_record_type.count

Line 715: ec_debug.pop('EC_INBOUND_STAGE.MATCH_RECORD_NUM');

711: ec_debug.pl(3,'i_file_pos',i_file_pos);
712: ec_debug.pl(3,'i_next_file_pos',i_next_file_pos);
713: ec_debug.pl(3,'i_total_rec_unit',i_total_rec_unit);
714: ec_debug.pl(3,'b_match_found',b_match_found);
715: ec_debug.pop('EC_INBOUND_STAGE.MATCH_RECORD_NUM');
716: end if;
717: return b_match_found;
718: EXCEPTION
719: WHEN OTHERS then

Line 720: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.MATCH_RECORD_NUM');

716: end if;
717: return b_match_found;
718: EXCEPTION
719: WHEN OTHERS then
720: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.MATCH_RECORD_NUM');
721: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
722: EC_UTILS.i_ret_code:=2;
723: raise EC_UTILS.PROGRAM_EXIT;
724: end match_record_num;

Line 750: ec_debug.push('EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');

746: i_new_file_value Varchar2(500);
747:
748: begin
749: if EC_DEBUG.G_debug_level >= 2 then
750: ec_debug.push('EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');
751: ec_debug.pl(3,'i_file_pos',i_file_pos);
752: ec_debug.pl(3,'i_total_rec_unit',i_total_rec_unit);
753: ec_debug.pl(3,'c_current_line',c_current_line);
754: end if;

Line 781: convert(i_data_file_value,i_db_charset,ec_inbound_stage.g_source_charset);

777: i_data_length := nvl(i_stage_record_type(i).width,0);
778: --Bug 2164672
779: i_data_file_value := rtrim(substrb(c_current_line,i_cur_pos+1,i_data_length));
780: i_stage_record_type(i).value :=
781: convert(i_data_file_value,i_db_charset,ec_inbound_stage.g_source_charset);
782: i_new_file_value :=
783: convert(i_stage_record_type(i).value,ec_inbound_stage.g_source_charset,i_db_charset);
784:
785: if i_new_file_value not like i_data_file_value then

Line 783: convert(i_stage_record_type(i).value,ec_inbound_stage.g_source_charset,i_db_charset);

779: i_data_file_value := rtrim(substrb(c_current_line,i_cur_pos+1,i_data_length));
780: i_stage_record_type(i).value :=
781: convert(i_data_file_value,i_db_charset,ec_inbound_stage.g_source_charset);
782: i_new_file_value :=
783: convert(i_stage_record_type(i).value,ec_inbound_stage.g_source_charset,i_db_charset);
784:
785: if i_new_file_value not like i_data_file_value then
786: i_data_status_flag := FALSE;
787: end if;

Line 799: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');

795: end if;
796: end if;
797:
798: if EC_DEBUG.G_debug_level >= 2 then
799: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');
800: end if;
801: EXCEPTION
802: WHEN OTHERS then
803: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');

Line 803: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');

799: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');
800: end if;
801: EXCEPTION
802: WHEN OTHERS then
803: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA_FROM_FILE');
804: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
805: EC_UTILS.i_ret_code:=2;
806: raise EC_UTILS.PROGRAM_EXIT;
807: end load_data_from_file;

Line 848: ec_debug.push('EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

844: i_previous_level NUMBER := 0;
845:
846: BEGIN
847: if EC_DEBUG.G_debug_level >= 2 then
848: ec_debug.push('EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
849: ec_debug.pl(3,'i_transaction_type',i_transaction_type);
850: ec_debug.pl(3,'i_Level',i_level);
851: ec_debug.pl(3,'EC','ECE_INTERFACE_MAPPING','TRANSACTION_TYPE',i_transaction_type,'LEVEL',i_level);
852: end if;

Line 910: ec_debug.pop('EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

906: raise EC_UTILS.PROGRAM_EXIT;
907: end if;
908:
909: if EC_DEBUG.G_debug_level >= 2 then
910: ec_debug.pop('EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
911: end if;
912: EXCEPTION
913: WHEN EC_UTILS.PROGRAM_EXIT then
914: raise;

Line 916: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');

912: EXCEPTION
913: WHEN EC_UTILS.PROGRAM_EXIT then
914: raise;
915: WHEN OTHERS then
916: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.POPULATE_FLATFILE_MAPPING');
917: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
918: EC_UTILS.i_ret_code:=2;
919: raise EC_UTILS.PROGRAM_EXIT;
920: END populate_flatfile_mapping;

Line 944: ec_debug.push('EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

940: error_position integer;
941:
942: BEGIN
943: if EC_DEBUG.G_debug_level >= 2 then
944: ec_debug.push('EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
945: ec_debug.pl(3,'i_level',i_level);
946: ec_debug.pl(3,'i_insert_cursor',i_insert_cursor);
947: end if;
948:

Line 1004: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

1000: dbms_sql.parse(i_Insert_Cursor,cInsert_stmt,dbms_sql.native);
1001: exception
1002: when others then
1003: error_position := dbms_sql.last_error_position;
1004: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1005: ece_error_handling_pvt.print_parse_error (error_position,cInsert_stmt);
1006: EC_UTILS.i_ret_code :=2;
1007: raise EC_UTILS.PROGRAM_EXIT;
1008: end;

Line 1102: 'EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

1098:
1099: exception
1100: when others then
1101: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',
1102: 'EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1103: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1104: ec_debug.pl(0,'EC','ECE_ERROR_SQL',null);
1105: ec_debug.pl(0,cInsert_stmt);
1106:

Line 1114: ec_debug.pop('EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

1110: end if;
1111:
1112: if EC_DEBUG.G_debug_level >= 2 then
1113: ec_debug.pl(3,'i_insert_cursor',i_insert_cursor);
1114: ec_debug.pop('EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1115: end if;
1116: EXCEPTION
1117: WHEN EC_UTILS.PROGRAM_EXIT then
1118: raise;

Line 1124: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');

1120: IF dbms_sql.IS_OPEN(i_insert_cursor)
1121: then
1122: dbms_sql.close_cursor(i_insert_cursor);
1123: end if;
1124: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.INSERT_INTO_STAGE_TABLE');
1125: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1126: EC_UTILS.i_ret_code:=2;
1127: raise EC_UTILS.PROGRAM_EXIT;
1128: END Insert_Into_Stage_Table;

Line 1250: ec_debug.push('EC_INBOUND_STAGE.GET_TP_CODE');

1246: counter number :=0;
1247: i_level number :=0;
1248: begin
1249: if EC_DEBUG.G_debug_level >= 2 then
1250: ec_debug.push('EC_INBOUND_STAGE.GET_TP_CODE');
1251: ec_debug.pl(3,'i_translator_code',i_translator_code);
1252: ec_debug.pl(3,'i_location_code',i_location_code);
1253: ec_debug.pl(3,'i_address_type',i_address_type);
1254: end if;

Line 1311: ec_debug.pop('EC_INBOUND_STAGE.GET_TP_CODE');

1307:
1308: end if;
1309: if EC_DEBUG.G_debug_level >= 2 then
1310: ec_debug.pl(3,'i_tp_code',i_tp_code);
1311: ec_debug.pop('EC_INBOUND_STAGE.GET_TP_CODE');
1312: end if;
1313: EXCEPTION
1314: WHEN OTHERS then
1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.GET_TP_CODE');

Line 1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.GET_TP_CODE');

1311: ec_debug.pop('EC_INBOUND_STAGE.GET_TP_CODE');
1312: end if;
1313: EXCEPTION
1314: WHEN OTHERS then
1315: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.GET_TP_CODE');
1316: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1317: EC_UTILS.i_ret_code:=2;
1318: raise EC_UTILS.PROGRAM_EXIT;
1319: end get_tp_code;

Line 1335: ec_debug.PUSH('EC_INBOUND_STAGE.FIND_POS');

1331: bFound BOOLEAN := FALSE;
1332: POS_NOT_FOUND EXCEPTION;
1333: BEGIN
1334: if EC_DEBUG.G_debug_level >= 2 then
1335: ec_debug.PUSH('EC_INBOUND_STAGE.FIND_POS');
1336: ec_debug.pl(3,'i_level',i_level);
1337: ec_debug.pl(3,'i_search_text',i_search_text);
1338: ec_debug.pl(3,'o_pos',o_pos);
1339: ec_debug.pl(3,'i_required',i_required);

Line 1365: ec_debug.POP('EC_INBOUND_STAGE.FIND_POS');

1361: end if;
1362: end if;
1363: if EC_DEBUG.G_debug_level >= 2 then
1364: ec_debug.pl(3,'o_pos',o_pos);
1365: ec_debug.POP('EC_INBOUND_STAGE.FIND_POS');
1366: end if;
1367: EXCEPTION
1368: WHEN POS_NOT_FOUND THEN
1369: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME',cIn_String);

Line 1370: ec_debug.POP('EC_INBOUND_STAGE.FIND_POS');

1366: end if;
1367: EXCEPTION
1368: WHEN POS_NOT_FOUND THEN
1369: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME',cIn_String);
1370: ec_debug.POP('EC_INBOUND_STAGE.FIND_POS');
1371: EC_UTILS.i_ret_code := 2;
1372: raise EC_UTILS.PROGRAM_EXIT;
1373: WHEN OTHERS THEN
1374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.FIND_POS');

Line 1374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.FIND_POS');

1370: ec_debug.POP('EC_INBOUND_STAGE.FIND_POS');
1371: EC_UTILS.i_ret_code := 2;
1372: raise EC_UTILS.PROGRAM_EXIT;
1373: WHEN OTHERS THEN
1374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.FIND_POS');
1375: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1376: EC_UTILS.i_ret_code := 2;
1377: raise EC_UTILS.PROGRAM_EXIT;
1378: END find_pos;

Line 1380: END EC_INBOUND_STAGE;

1376: EC_UTILS.i_ret_code := 2;
1377: raise EC_UTILS.PROGRAM_EXIT;
1378: END find_pos;
1379:
1380: END EC_INBOUND_STAGE;