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

Line 1: PACKAGE BODY ECE_FLATFILE_PVT AS

1: PACKAGE BODY ECE_FLATFILE_PVT AS
2: -- $Header: ECVFILEB.pls 120.3 2005/10/04 02:19:41 arsriniv ship $
3:
4: debug_mode_on_select BOOLEAN := FALSE;
5: debug_mode_on_write BOOLEAN := FALSE;

Line 128: ec_debug.push('ECE_FLATFILE_PVT.SELECT_CLAUSE');

124: eic.position;
125:
126: BEGIN
127: if EC_DEBUG.G_debug_level >= 2 then
128: ec_debug.push('ECE_FLATFILE_PVT.SELECT_CLAUSE');
129: end if;
130:
131: IF cMapCode IS NULL THEN
132: SELECT map_id INTO iMap_ID

Line 262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');

258: ec_debug.pl(3,'cExt_Table : ',cExt_Table);
259: end if;
260:
261: if EC_DEBUG.G_debug_level >= 2 then
262: ec_debug.pop('ECE_FLATFILE_PVT.SELECT_CLAUSE');
263: end if;
264:
265: EXCEPTION
266: WHEN OTHERS THEN

Line 267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');

263: end if;
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.SELECT_CLAUSE');
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
269: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
270: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
271: app_exception.raise_exception;

Line 305: ec_debug.push('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

301: l_count NUMBER;
302:
303: BEGIN
304: if EC_DEBUG.G_debug_level >= 2 then
305: ec_debug.push('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
306: end if;
307: xProgress := 'FILEB-WR-1020';
308: FOR i IN 1..iData_count LOOP
309: xProgress := 'FILEB-WR-1030';

Line 369: ec_debug.pop('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

365: END IF;
366: END LOOP;
367:
368: if EC_DEBUG.G_debug_level >= 2 then
369: ec_debug.pop('ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
370: end if;
371:
372: EXCEPTION
373: WHEN OTHERS THEN

Line 374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');

370: end if;
371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.WRITE_TO_ECE_OUTPUT');
375: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
376: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
377: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
378:

Line 401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');

397: cOutput_path VARCHAR2(120);
398: BEGIN
399:
400: if EC_DEBUG.G_debug_level >= 2 then
401: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.Find_pos');
402: EC_DEBUG.PL(3, 'Search text : ', cSearch_text);
403: EC_DEBUG.PL(3, 'nColumn_count : ', nColumn_count);
404: end if;
405: For k in 1..nColumn_count loop

Line 420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');

416: if NOT b_found then
417: Raise POS_NOT_FOUND;
418: end if;
419: if EC_DEBUG.G_debug_level >= 2 then
420: EC_DEBUG.POP('ECE_FLATFILE_PVT.Find_pos');
421: end if;
422: EXCEPTION
423: WHEN POS_NOT_FOUND THEN
424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');

Line 428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');

424: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'cIn_string');
425: app_exception.raise_exception;
426:
427: WHEN OTHERS THEN
428: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.FIND_POS');
429: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
430: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
431: app_exception.raise_exception;
432: END Find_pos;

Line 442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');

438:
439: IS
440:
441: BEGIN
442: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_data_loc_id');
443: if EC_DEBUG.G_debug_level >= 3 then
444: EC_DEBUG.PL(3, 'Data loc id : ', p_data_loc_id);
445: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
446: end if;

Line 458: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_data_loc_id');

454: end if;
455: exit;
456: end if;
457: end loop;
458: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_data_loc_id');
459: END match_data_loc_id;
460:
461: -- *******************************************
462: */

Line 472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');

468: IS
469:
470: BEGIN
471: if EC_DEBUG.G_debug_level >= 2 then
472: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_interface_column_id');
473: EC_DEBUG.PL(3, 'Interface_column_id : ', p_Interface_column_id);
474: EC_DEBUG.PL(3, 'Loop count : ', p_Interface_tbl.count);
475: end if;
476: For k in 1..p_Interface_tbl.count

Line 488: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_interface_column_id');

484: exit;
485: end if;
486: end loop;
487: if EC_DEBUG.G_debug_level >= 2 then
488: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_interface_column_id');
489: end if;
490: END match_interface_column_id;
491:
492: -- *******************************************

Line 509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');

505:
506: BEGIN
507: xProgress := 'FILEB-MA-1000';
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_conversion_group_id');
510:
511: EC_DEBUG.PL(3, 'Conversion id : ', p_conversion_id);
512: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
513: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);

Line 526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');

522: xProgress := 'FILEB-MA-1020';
523: p_pos := k;
524: if EC_DEBUG.G_debug_level >= 2 then
525: EC_DEBUG.PL(3, 'Position : ', p_pos);
526: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
527: end if;
528: b_found := TRUE;
529: return b_found;
530: end if;

Line 537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');

533: IF NOT b_found THEN
534: RAISE POS_NOT_FOUND;
535: END IF;
536: if EC_DEBUG.G_debug_level >= 2 then
537: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_conversion_group_id');
538: end if;
539: EXCEPTION
540: WHEN POS_NOT_FOUND THEN
541: EC_DEBUG.PL(0,'EC','ECE_CONVERSION_ID_NOT_FOUND','CONVERSION_ID', 'p_conversion_id', 'SEQUENCE', 'p_sequence_num');

Line 564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');

560: b_found BOOLEAN := FALSE;
561:
562: BEGIN
563: if EC_DEBUG.G_debug_level >= 2 then
564: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
565: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
566: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
567: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
568: end if;

Line 583: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');

579: exit;
580: end if;
581: end loop;
582: if EC_DEBUG.G_debug_level >= 2 then
583: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
584: end if;
585: return b_found;
586:
587: END match_xref_conv_seq;

Line 603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');

599: hash_string varchar2(3200);
600: tbl_pos pls_integer;
601: BEGIN
602: if EC_DEBUG.G_debug_level >= 2 then
603: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_xref_conv_seq');
604: EC_DEBUG.PL(3, 'p_level group : ', p_level);
605: EC_DEBUG.PL(3, 'Conversion group : ', p_conversion_group);
606: EC_DEBUG.PL(3, 'Seq num : ', p_sequence_num);
607: ec_debug.pl(3, 'file_start_pos',ec_utils.g_ext_levels(p_level).file_start_pos);

Line 681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');

677:
678: if EC_DEBUG.G_debug_level >= 2 then
679: EC_DEBUG.PL(3, 'p_Pos', p_Pos);
680: EC_DEBUG.PL(3, 'b_found', b_found);
681: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_xref_conv_seq');
682: end if;
683: return b_found;
684:
685: END match_xref_conv_seq;

Line 710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');

706: l_total_unit NUMBER := 0;
707: cOutput_path varchar2(120);
708: BEGIN
709: if EC_DEBUG.G_debug_level >= 2 then
710: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.match_record_num');
711: EC_DEBUG.PL(3, 'Record num : ', p_Record_num);
712: EC_DEBUG.PL(3, 'Loop count : ', p_gateway_tbl.count);
713: end if;
714: For k in 1..p_gateway_tbl.count

Line 744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');

740:
741: p_total_unit := l_total_unit;
742: if EC_DEBUG.G_debug_level >= 2 then
743: EC_DEBUG.PL(3, 'Total records found : ', p_total_unit);
744: EC_DEBUG.POP('ECE_FLATFILE_PVT.match_record_num');
745: end if;
746: return b_match_found;
747: EXCEPTION
748: when others

Line 761: cInterface_tbl OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

757: cTransaction_Type IN VARCHAR2,
758: cInt_tbl_name IN VARCHAR2,
759: cOutput_level IN VARCHAR2,
760: bKey_exist IN BOOLEAN,
761: cInterface_tbl OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
762: cKey_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
763: cMapCode IN VARCHAR2 DEFAULT NULL) IS
764:
765: CURSOR c_source_data(cMap_ID INTEGER) IS

Line 762: cKey_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

758: cInt_tbl_name IN VARCHAR2,
759: cOutput_level IN VARCHAR2,
760: bKey_exist IN BOOLEAN,
761: cInterface_tbl OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
762: cKey_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
763: cMapCode IN VARCHAR2 DEFAULT NULL) IS
764:
765: CURSOR c_source_data(cMap_ID INTEGER) IS
766: SELECT eic.conversion_group_id,

Line 802: ec_debug.push('ECE_FLATFILE_PVT.INIT_TABLE');

798: cOutput_path VARCHAR2(120);
799:
800: BEGIN
801: if EC_DEBUG.G_debug_level >= 2 then
802: ec_debug.push('ECE_FLATFILE_PVT.INIT_TABLE');
803: end if;
804: IF cMapCode IS NULL THEN
805: SELECT map_id INTO iMap_ID
806: FROM ece_mappings

Line 899: ec_debug.pop('ECE_FLATFILE_PVT.INIT_TABLE');

895:
896: END LOOP;
897:
898: if EC_DEBUG.G_debug_level >= 2 then
899: ec_debug.pop('ECE_FLATFILE_PVT.INIT_TABLE');
900: end if;
901:
902: EXCEPTION
903: WHEN OTHERS THEN

Line 904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');

900: end if;
901:
902: EXCEPTION
903: WHEN OTHERS THEN
904: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.init_table');
905: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
906: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
907: ec_debug.pl(0,'EC','ECE_PLSQL_TABLE_NAME','TABLE_NAME', 'cInterface_tbl(i_count).base_table_name');
908: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'cInterface_tbl(i_count).base_column_name');

Line 917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');

913: PROCEDURE ADD_TO_WHERE_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
914: cAdd IN VARCHAR2) IS
915: BEGIN
916: if EC_DEBUG.G_debug_level >= 2 then
917: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
918: EC_DEBUG.PL(3, 'Add string : ', cAdd);
919: end if;
920:
921: cString := cString || ' AND '|| cAdd;

Line 925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');

921: cString := cString || ' AND '|| cAdd;
922:
923: if EC_DEBUG.G_debug_level >= 2 then
924: EC_DEBUG.PL(3, 'String : ', cString);
925: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_WHERE_CLAUSE');
926: end if;
927: END ADD_TO_WHERE_CLAUSE;
928:
929: PROCEDURE ADD_TO_FROM_CLAUSE (cString IN OUT NOCOPY VARCHAR2,

Line 933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');

929: PROCEDURE ADD_TO_FROM_CLAUSE (cString IN OUT NOCOPY VARCHAR2,
930: cAdd IN VARCHAR2) IS
931: BEGIN
932: if EC_DEBUG.G_debug_level >= 2 then
933: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
934: EC_DEBUG.PL(3, 'Add string : ', cAdd);
935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then

Line 939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');

935: end if;
936: cString := cString || cAdd || ', ';
937: if EC_DEBUG.G_debug_level >= 3 then
938: EC_DEBUG.PL(3, 'String : ', cString);
939: EC_DEBUG.POP('ECE_FLATFILE_PVT.ADD_TO_FROM_CLAUSE');
940: end if;
941: END ADD_TO_FROM_CLAUSE;
942:
943: PROCEDURE DEFINE_INTERFACE_COLUMN_TYPE (

Line 947: p_tbl IN ece_flatfile_pvt.Interface_tbl_type)

943: PROCEDURE DEFINE_INTERFACE_COLUMN_TYPE (
944: c IN INTEGER,
945: cCol IN VARCHAR2,
946: iCol_size IN INTEGER,
947: p_tbl IN ece_flatfile_pvt.Interface_tbl_type)
948: IS
949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');

Line 951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');

947: p_tbl IN ece_flatfile_pvt.Interface_tbl_type)
948: IS
949: BEGIN
950: if EC_DEBUG.G_debug_level >= 2 then
951: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
952: EC_DEBUG.PL(3, 'Column value: ', c);
953: EC_DEBUG.PL(3, 'Column : ', cCol);
954: EC_DEBUG.PL(3, 'Column size: ', iCol_size);
955: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);

Line 963: EC_DEBUG.POP('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');

959: dbms_sql.define_column(c, k, cCol, iCol_size);
960: End Loop;
961:
962: if EC_DEBUG.G_debug_level >= 2 then
963: EC_DEBUG.POP('ECE_FLATFILE_PVT.DEFINE_INTERFACE_COLUMN_TYPE');
964: end if;
965: EXCEPTION
966: when others then
967: app_exception.raise_exception;

Line 972: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)

968: END DEFINE_INTERFACE_COLUMN_TYPE;
969:
970: PROCEDURE ASSIGN_COLUMN_VALUE_TO_TBL (
971: c IN INTEGER,
972: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
973: IS
974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then

Line 975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

971: c IN INTEGER,
972: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
973: IS
974: BEGIN
975: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
976: if EC_DEBUG.G_debug_level >= 3 then
977: EC_DEBUG.PL(3, 'Column value: ', c);
978: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
979: end if;

Line 984: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

980: for k in 1..p_tbl.count loop
981: dbms_sql.column_value(c, k, p_tbl(k).value);
982: end loop;
983:
984: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
985: EXCEPTION
986: when others then
987: app_exception.raise_exception;
988: END ASSIGN_COLUMN_VALUE_TO_TBL;

Line 993: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,

989:
990: PROCEDURE ASSIGN_COLUMN_VALUE_TO_TBL (
991: c IN INTEGER,
992: iCount IN INTEGER,
993: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then

Line 994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)

990: PROCEDURE ASSIGN_COLUMN_VALUE_TO_TBL (
991: c IN INTEGER,
992: iCount IN INTEGER,
993: p_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type,
994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

Line 998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

994: p_key_tbl IN OUT NOCOPY ece_flatfile_pvt.Interface_tbl_type)
995: IS
996: BEGIN
997: if EC_DEBUG.G_debug_level >= 2 then
998: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
999: EC_DEBUG.PL(3, 'Column : ', c);
1000: EC_DEBUG.PL(3, 'iCount : ', iCount);
1001: EC_DEBUG.PL(3, 'Table loop count : ', p_tbl.count);
1002: end if;

Line 1009: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');

1005: dbms_sql.column_value(c, k, p_key_tbl(k+iCount).value);
1006: end loop;
1007:
1008: if EC_DEBUG.G_debug_level >= 2 then
1009: EC_DEBUG.POP('ECE_FLATFILE_PVT.ASSIGN_COLUMN_VALUE_TO_TBL');
1010: end if;
1011: EXCEPTION
1012: when others then
1013: app_exception.raise_exception;

Line 1016: FUNCTION POS_OF (pInterface_tbl ece_flatfile_pvt.Interface_tbl_type,

1012: when others then
1013: app_exception.raise_exception;
1014: END ASSIGN_COLUMN_VALUE_TO_TBL;
1015:
1016: FUNCTION POS_OF (pInterface_tbl ece_flatfile_pvt.Interface_tbl_type,
1017: cCol_name VARCHAR2)
1018: RETURN NUMBER
1019: IS
1020: l_Row_count NUMBER := pInterface_tbl.count;

Line 1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');

1022: pos_not_found EXCEPTION;
1023: cOutput_path VARCHAR2(120);
1024: BEGIN
1025: if EC_DEBUG.G_debug_level >= 2 then
1026: EC_DEBUG.PUSH('ECE_FLATFILE_PVT.POS_OF');
1027: EC_DEBUG.PL(3, 'Row_count : ', l_Row_count);
1028: end if;
1029: For k in 1..l_Row_count loop
1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then

Line 1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');

1030: if UPPER(nvl(pInterface_tbl(k).interface_column_name, 'NULL')) = UPPER(cCol_name) then
1031: b_found := TRUE;
1032: if EC_DEBUG.G_debug_level >= 2 then
1033: EC_DEBUG.PL(3, 'Position : ', k);
1034: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1035: end if;
1036: return(k);
1037: exit;
1038: end if;

Line 1047: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');

1043: raise pos_not_found;
1044: end if;
1045:
1046: if EC_DEBUG.G_debug_level >= 2 then
1047: EC_DEBUG.POP('ECE_FLATFILE_PVT.POS_OF');
1048: end if;
1049: EXCEPTION
1050: WHEN pos_not_found THEN
1051: fnd_message.set_name('EC','ECE_PLSQL_POS_NOT_FOUND');

Line 1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');

1051: fnd_message.set_name('EC','ECE_PLSQL_POS_NOT_FOUND');
1052: fnd_message.set_token('COLUMN_NAME', upper(cCol_name));
1053: raise;
1054: WHEN OTHERS THEN
1055: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_FLATFILE_PVT.POS_OF');
1056: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1057: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1058: app_exception.raise_exception;
1059:

Line 1062: END ECE_FLATFILE_PVT;

1058: app_exception.raise_exception;
1059:
1060: END POS_OF;
1061:
1062: END ECE_FLATFILE_PVT;