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.

[Home] [Help]

APPS.ECE_POO_TRANSACTION dependencies on APP_EXCEPTION

Line 862: app_exception.raise_exception;

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

Line 875: app_exception.raise_exception;

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

Line 888: app_exception.raise_exception;

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

Line 2242: app_exception.raise_exception;

2238: WHEN OTHERS THEN
2239: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
2240: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2241:
2242: app_exception.raise_exception;
2243:
2244: END populate_poo_trx;
2245:
2246: PROCEDURE put_data_to_output_table(cCommunication_Method IN VARCHAR2,

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_select);
2658: app_exception.raise_exception;
2659:
2660: END;
2661:
2662: xProgress := 'POOB-20-1180';

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_select);
2669: app_exception.raise_exception;
2670:
2671: END;
2672:
2673: xProgress := 'POOB-20-1190';

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_select);
2680: app_exception.raise_exception;
2681:
2682: END;
2683:
2684: xProgress := 'POOB-20-1200';

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_delete1);
2691: app_exception.raise_exception;
2692:
2693: END;
2694:
2695: xProgress := 'POOB-20-1210';

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_delete1);
2702: app_exception.raise_exception;
2703:
2704: END;
2705:
2706: xProgress := 'POOB-20-1220';

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_delete1);
2713: app_exception.raise_exception;
2714:
2715: END;
2716:
2717: xProgress := 'POOB-20-1230';

Line 2724: app_exception.raise_exception;

2720:
2721: EXCEPTION
2722: WHEN OTHERS THEN
2723: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);
2724: app_exception.raise_exception;
2725:
2726: END;
2727:
2728: xProgress := 'POOB-20-1240';

Line 2735: app_exception.raise_exception;

2731:
2732: EXCEPTION
2733: WHEN OTHERS THEN
2734: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cLine_delete2);
2735: app_exception.raise_exception;
2736:
2737: END;
2738:
2739: xProgress := 'POOB-20-1250';

Line 2746: app_exception.raise_exception;

2742:
2743: EXCEPTION
2744: WHEN OTHERS THEN
2745: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cShipment_delete2);
2746: app_exception.raise_exception;
2747:
2748: END;
2749:
2750: -- *************

Line 3358: app_exception.raise_exception;

3354: WHEN OTHERS THEN
3355: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3356: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3357:
3358: app_exception.raise_exception;
3359:
3360: END put_data_to_output_table;
3361:
3362:

Line 3551: app_exception.raise_exception;

3547: WHEN OTHERS THEN
3548: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3549: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3550:
3551: app_exception.raise_exception;
3552: END update_po;
3553:
3554: PROCEDURE POPULATE_DISTRIBUTION_INFO(
3555: cCommunication_Method IN VARCHAR2,

Line 3700: app_exception.raise_exception;

3696:
3697: EXCEPTION
3698: WHEN OTHERS THEN
3699: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_select);
3700: app_exception.raise_exception;
3701: END;
3702:
3703: -- Set Counter
3704: xProgress := 'POOB-40-1070';

Line 3915: app_exception.raise_exception;

3911: WHEN OTHERS THEN
3912: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
3913: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
3914:
3915: app_exception.raise_exception;
3916:
3917: END POPULATE_DISTRIBUTION_INFO;
3918:
3919: PROCEDURE PUT_DISTDATA_TO_OUT_TBL(

Line 4060: app_exception.raise_exception;

4056:
4057: EXCEPTION
4058: WHEN OTHERS THEN
4059: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_select);
4060: app_exception.raise_exception;
4061:
4062: END;
4063:
4064: xProgress := 'POOB-50-1070';

Line 4072: app_exception.raise_exception;

4068:
4069: EXCEPTION
4070: WHEN OTHERS THEN
4071: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_delete1);
4072: app_exception.raise_exception;
4073:
4074: END;
4075:
4076: xProgress := 'POOB-50-1090';

Line 4084: app_exception.raise_exception;

4080:
4081: EXCEPTION
4082: WHEN OTHERS THEN
4083: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cProject_delete2);
4084: app_exception.raise_exception;
4085:
4086: END;
4087:
4088: end if; --Bug 2490109

Line 4213: app_exception.raise_exception;

4209: WHEN OTHERS THEN
4210: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
4211: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
4212:
4213: app_exception.raise_exception;
4214:
4215: END PUT_DISTDATA_TO_OUT_TBL;
4216:
4217: PROCEDURE populate_text_attachment(

Line 4440: app_exception.raise_exception;

4436: EXCEPTION
4437: WHEN OTHERS THEN
4438: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,
4439: v_att_header_select);
4440: app_exception.raise_exception;
4441: END;
4442:
4443: -- Set Counter
4444: xProgress := 'POOB-60-1120';

Line 4566: app_exception.raise_exception;

4562: WHEN OTHERS THEN
4563: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
4564: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
4565:
4566: app_exception.raise_exception;
4567: END populate_text_attachment;
4568:
4569: PROCEDURE populate_text_att_detail(
4570: cCommunication_Method IN VARCHAR2,

Line 4850: app_exception.raise_exception;

4846:
4847: EXCEPTION
4848: WHEN OTHERS THEN
4849: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,v_att_detail_select);
4850: app_exception.raise_exception;
4851:
4852: END;
4853:
4854: xProgress := 'POOB-70-1240';

Line 5287: app_exception.raise_exception;

5283: WHEN OTHERS THEN
5284: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
5285: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
5286:
5287: app_exception.raise_exception;
5288:
5289: END populate_text_att_detail;
5290:
5291: PROCEDURE put_att_to_output_table(

Line 5517: app_exception.raise_exception;

5513:
5514: EXCEPTION
5515: WHEN OTHERS THEN
5516: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_select);
5517: app_exception.raise_exception;
5518: END;
5519:
5520:
5521: -- Parse the DELETE1 SQL

Line 5529: app_exception.raise_exception;

5525:
5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete1);
5529: app_exception.raise_exception;
5530: END;
5531:
5532: -- Parse the DELETE2 SQL
5533: BEGIN

Line 5540: app_exception.raise_exception;

5536:
5537: EXCEPTION
5538: WHEN OTHERS THEN
5539: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cHeader_delete2);
5540: app_exception.raise_exception;
5541: END;
5542:
5543: --Set Counter
5544: xProgress := 'POOB-80-1150';

Line 5673: app_exception.raise_exception;

5669: WHEN OTHERS THEN
5670: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
5671: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
5672:
5673: app_exception.raise_exception;
5674:
5675: END put_att_to_output_table;
5676:
5677: PROCEDURE put_att_detail_to_output_table(

Line 5912: app_exception.raise_exception;

5908:
5909: EXCEPTION
5910: WHEN OTHERS THEN
5911: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_select);
5912: app_exception.raise_exception;
5913: END;
5914:
5915: -- Parse the DELETE1 SQL
5916: BEGIN

Line 5923: app_exception.raise_exception;

5919:
5920: EXCEPTION
5921: WHEN OTHERS THEN
5922: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_delete1);
5923: app_exception.raise_exception;
5924: END;
5925:
5926: -- Parse the DELETE2 SQL
5927: BEGIN

Line 5934: app_exception.raise_exception;

5930:
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: ece_error_handling_pvt.print_parse_error(dbms_sql.last_error_position,cDetail_delete2);
5934: app_exception.raise_exception;
5935: END;
5936:
5937: --Set Counter
5938: xProgress := 'POOB-90-1170';

Line 6048: app_exception.raise_exception;

6044: WHEN OTHERS THEN
6045: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
6046: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6047:
6048: app_exception.raise_exception;
6049:
6050: END put_att_detail_to_output_table;
6051:
6052:

Line 6165: app_exception.raise_exception;

6161: EXCEPTION
6162: WHEN utl_file.write_error THEN
6163: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6165: app_exception.raise_exception;
6166:
6167: WHEN utl_file.invalid_path THEN
6168: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6169: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 6170: app_exception.raise_exception;

6166:
6167: WHEN utl_file.invalid_path THEN
6168: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6169: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6170: app_exception.raise_exception;
6171:
6172: WHEN utl_file.invalid_operation THEN
6173: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6174: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 6175: app_exception.raise_exception;

6171:
6172: WHEN utl_file.invalid_operation THEN
6173: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6174: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6175: app_exception.raise_exception;
6176:
6177: WHEN OTHERS THEN
6178: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_POO_TRANSACTION.WRITE_TO_FILE');
6179: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 6187: app_exception.raise_exception;

6183: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(l_count)');
6184: ec_debug.pl(0,'EC','ECE_PLSQL_VALUE','COLUMN_NAME', 'p_interface_tbl(l_count).value');
6185: ec_debug.pl(0,'EC','ECE_PLSQL_DATA_TYPE','COLUMN_NAME', 'p_interface_tbl(l_count).data_type');
6186: ec_debug.pl(0,'EC','ECE_PLSQL_COLUMN_NAME','COLUMN_NAME', 'p_interface_tbl(l_count).base_column');
6187: app_exception.raise_exception;
6188:
6189: END write_to_file;
6190:
6191: END ECE_POO_TRANSACTION;