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_POO_TRANSACTION dependencies on APP_EXCEPTION

Line 861: app_exception.raise_exception;

857: EXCEPTION
858: WHEN OTHERS THEN
859: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
860: cHeader_select);
861: app_exception.raise_exception;
862: END;
863:
864: xProgress := 'POOB-10-1240';
865: BEGIN

Line 874: app_exception.raise_exception;

870: EXCEPTION
871: WHEN OTHERS THEN
872: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
873: cLine_select);
874: app_exception.raise_exception;
875: END;
876:
877: xProgress := 'POOB-10-1250';
878: BEGIN

Line 887: app_exception.raise_exception;

883: EXCEPTION
884: WHEN OTHERS THEN
885: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
886: cShipment_select);
887: app_exception.raise_exception;
888: END;
889:
890: -- ************
891: -- set counter

Line 2209: app_exception.raise_exception;

2205: WHEN OTHERS THEN
2206: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
2207: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2208:
2209: app_exception.raise_exception;
2210:
2211: END populate_poo_trx;
2212:
2213: PROCEDURE put_data_to_output_table(cCommunication_Method IN VARCHAR2,

Line 2625: app_exception.raise_exception;

2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);
2625: app_exception.raise_exception;
2626:
2627: END;
2628:
2629: xProgress := 'POOB-20-1180';

Line 2636: app_exception.raise_exception;

2632:
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_select);
2636: app_exception.raise_exception;
2637:
2638: END;
2639:
2640: xProgress := 'POOB-20-1190';

Line 2647: app_exception.raise_exception;

2643:
2644: EXCEPTION
2645: WHEN OTHERS THEN
2646: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_select);
2647: app_exception.raise_exception;
2648:
2649: END;
2650:
2651: xProgress := 'POOB-20-1200';

Line 2658: app_exception.raise_exception;

2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);
2658: app_exception.raise_exception;
2659:
2660: END;
2661:
2662: xProgress := 'POOB-20-1210';

Line 2669: app_exception.raise_exception;

2665:
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete1);
2669: app_exception.raise_exception;
2670:
2671: END;
2672:
2673: xProgress := 'POOB-20-1220';

Line 2680: app_exception.raise_exception;

2676:
2677: EXCEPTION
2678: WHEN OTHERS THEN
2679: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete1);
2680: app_exception.raise_exception;
2681:
2682: END;
2683:
2684: xProgress := 'POOB-20-1230';

Line 2691: app_exception.raise_exception;

2687:
2688: EXCEPTION
2689: WHEN OTHERS THEN
2690: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);
2691: app_exception.raise_exception;
2692:
2693: END;
2694:
2695: xProgress := 'POOB-20-1240';

Line 2702: app_exception.raise_exception;

2698:
2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete2);
2702: app_exception.raise_exception;
2703:
2704: END;
2705:
2706: xProgress := 'POOB-20-1250';

Line 2713: app_exception.raise_exception;

2709:
2710: EXCEPTION
2711: WHEN OTHERS THEN
2712: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete2);
2713: app_exception.raise_exception;
2714:
2715: END;
2716:
2717: -- *************

Line 3325: app_exception.raise_exception;

3321: WHEN OTHERS THEN
3322: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3323: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3324:
3325: app_exception.raise_exception;
3326:
3327: END put_data_to_output_table;
3328:
3329:

Line 3518: app_exception.raise_exception;

3514: WHEN OTHERS THEN
3515: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3516: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3517:
3518: app_exception.raise_exception;
3519: END update_po;
3520:
3521: PROCEDURE POPULATE_DISTRIBUTION_INFO(
3522: cCommunication_Method IN VARCHAR2,

Line 3667: app_exception.raise_exception;

3663:
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_select);
3667: app_exception.raise_exception;
3668: END;
3669:
3670: -- Set Counter
3671: xProgress := 'POOB-40-1070';

Line 3882: app_exception.raise_exception;

3878: WHEN OTHERS THEN
3879: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3880: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3881:
3882: app_exception.raise_exception;
3883:
3884: END POPULATE_DISTRIBUTION_INFO;
3885:
3886: PROCEDURE PUT_DISTDATA_TO_OUT_TBL(

Line 4027: app_exception.raise_exception;

4023:
4024: EXCEPTION
4025: WHEN OTHERS THEN
4026: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_select);
4027: app_exception.raise_exception;
4028:
4029: END;
4030:
4031: xProgress := 'POOB-50-1070';

Line 4039: app_exception.raise_exception;

4035:
4036: EXCEPTION
4037: WHEN OTHERS THEN
4038: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_delete1);
4039: app_exception.raise_exception;
4040:
4041: END;
4042:
4043: xProgress := 'POOB-50-1090';

Line 4051: app_exception.raise_exception;

4047:
4048: EXCEPTION
4049: WHEN OTHERS THEN
4050: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_delete2);
4051: app_exception.raise_exception;
4052:
4053: END;
4054:
4055: end if; --Bug 2490109

Line 4180: app_exception.raise_exception;

4176: WHEN OTHERS THEN
4177: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
4178: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
4179:
4180: app_exception.raise_exception;
4181:
4182: END PUT_DISTDATA_TO_OUT_TBL;
4183:
4184: PROCEDURE populate_text_attachment(

Line 4407: app_exception.raise_exception;

4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
4406: v_att_header_select);
4407: app_exception.raise_exception;
4408: END;
4409:
4410: -- Set Counter
4411: xProgress := 'POOB-60-1120';

Line 4533: app_exception.raise_exception;

4529: WHEN OTHERS THEN
4530: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
4531: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
4532:
4533: app_exception.raise_exception;
4534: END populate_text_attachment;
4535:
4536: PROCEDURE populate_text_att_detail(
4537: cCommunication_Method IN VARCHAR2,

Line 4817: app_exception.raise_exception;

4813:
4814: EXCEPTION
4815: WHEN OTHERS THEN
4816: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,v_att_detail_select);
4817: app_exception.raise_exception;
4818:
4819: END;
4820:
4821: xProgress := 'POOB-70-1240';

Line 5254: app_exception.raise_exception;

5250: WHEN OTHERS THEN
5251: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
5252: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
5253:
5254: app_exception.raise_exception;
5255:
5256: END populate_text_att_detail;
5257:
5258: PROCEDURE put_att_to_output_table(

Line 5484: app_exception.raise_exception;

5480:
5481: EXCEPTION
5482: WHEN OTHERS THEN
5483: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);
5484: app_exception.raise_exception;
5485: END;
5486:
5487:
5488: -- Parse the DELETE1 SQL

Line 5496: app_exception.raise_exception;

5492:
5493: EXCEPTION
5494: WHEN OTHERS THEN
5495: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);
5496: app_exception.raise_exception;
5497: END;
5498:
5499: -- Parse the DELETE2 SQL
5500: BEGIN

Line 5507: app_exception.raise_exception;

5503:
5504: EXCEPTION
5505: WHEN OTHERS THEN
5506: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);
5507: app_exception.raise_exception;
5508: END;
5509:
5510: --Set Counter
5511: xProgress := 'POOB-80-1150';

Line 5640: app_exception.raise_exception;

5636: WHEN OTHERS THEN
5637: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
5638: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
5639:
5640: app_exception.raise_exception;
5641:
5642: END put_att_to_output_table;
5643:
5644: PROCEDURE put_att_detail_to_output_table(

Line 5879: app_exception.raise_exception;

5875:
5876: EXCEPTION
5877: WHEN OTHERS THEN
5878: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_select);
5879: app_exception.raise_exception;
5880: END;
5881:
5882: -- Parse the DELETE1 SQL
5883: BEGIN

Line 5890: app_exception.raise_exception;

5886:
5887: EXCEPTION
5888: WHEN OTHERS THEN
5889: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_delete1);
5890: app_exception.raise_exception;
5891: END;
5892:
5893: -- Parse the DELETE2 SQL
5894: BEGIN

Line 5901: app_exception.raise_exception;

5897:
5898: EXCEPTION
5899: WHEN OTHERS THEN
5900: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_delete2);
5901: app_exception.raise_exception;
5902: END;
5903:
5904: --Set Counter
5905: xProgress := 'POOB-90-1170';

Line 6015: app_exception.raise_exception;

6011: WHEN OTHERS THEN
6012: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
6013: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6014:
6015: app_exception.raise_exception;
6016:
6017: END put_att_detail_to_output_table;
6018:
6019:

Line 6132: app_exception.raise_exception;

6128: EXCEPTION
6129: WHEN utl_file.write_error THEN
6130: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6131: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6132: app_exception.raise_exception;
6133:
6134: WHEN utl_file.invalid_path THEN
6135: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6136: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 6137: app_exception.raise_exception;

6133:
6134: WHEN utl_file.invalid_path THEN
6135: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6136: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6137: app_exception.raise_exception;
6138:
6139: WHEN utl_file.invalid_operation THEN
6140: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6141: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 6142: app_exception.raise_exception;

6138:
6139: WHEN utl_file.invalid_operation THEN
6140: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6141: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6142: app_exception.raise_exception;
6143:
6144: WHEN OTHERS THEN
6145: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_POO_TRANSACTION.WRITE_TO_FILE');
6146: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 6154: app_exception.raise_exception;

6150: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
6151: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
6152: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
6153: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
6154: app_exception.raise_exception;
6155:
6156: END write_to_file;
6157:
6158: END ECE_POO_TRANSACTION;