DBA Data[Home] [Help]

APPS.ECE_FLATFILE_PVT dependencies on APP_EXCEPTION

Line 271: app_exception.raise_exception;

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;
272:
273: END select_clause;
274:
275: ---PROCEDURE write_to_ece_output

Line 383: app_exception.raise_exception;

379: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
380: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
381: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
382: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
383: app_exception.raise_exception;
384:
385: END write_to_ece_output;
386:
387: PROCEDURE Find_pos(

Line 425: app_exception.raise_exception;

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');
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);

Line 431: app_exception.raise_exception;

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;
433: /*
434: PROCEDURE match_data_loc_id(
435: p_Interface_tbl IN Interface_tbl_type,

Line 542: app_exception.raise_exception;

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');
542: app_exception.raise_exception;
543:
544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

Line 548: app_exception.raise_exception;

544: WHEN OTHERS THEN
545: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
546: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
547: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
548: app_exception.raise_exception;
549:
550: END match_conversion_group_id;
551:
552: -- *******************************************

Line 753: app_exception.raise_exception;

749: then
750: EC_DEBUG.PL(0,'EC','ECE_RECORD_NUM_NOT_FOUND','RECORD_NUM','to_char(p_Record_num)');
751: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
752: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
753: app_exception.raise_exception;
754: END match_record_num;
755:
756: PROCEDURE init_table(
757: cTransaction_Type IN VARCHAR2,

Line 909: app_exception.raise_exception;

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');
909: app_exception.raise_exception;
910:
911: END init_table;
912:
913: PROCEDURE ADD_TO_WHERE_CLAUSE (cString IN OUT NOCOPY VARCHAR2,

Line 967: app_exception.raise_exception;

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;
968: END DEFINE_INTERFACE_COLUMN_TYPE;
969:
970: PROCEDURE ASSIGN_COLUMN_VALUE_TO_TBL (
971: c IN INTEGER,

Line 987: app_exception.raise_exception;

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;
989:
990: PROCEDURE ASSIGN_COLUMN_VALUE_TO_TBL (
991: c IN INTEGER,

Line 1013: app_exception.raise_exception;

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;
1014: END ASSIGN_COLUMN_VALUE_TO_TBL;
1015:
1016: FUNCTION POS_OF (pInterface_tbl ece_flatfile_pvt.Interface_tbl_type,
1017: cCol_name VARCHAR2)

Line 1058: app_exception.raise_exception;

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:
1060: END POS_OF;
1061:
1062: END ECE_FLATFILE_PVT;