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

Line 1: PACKAGE BODY MSD_CL_PRE_PROCESS AS -- Package Body

1: PACKAGE BODY MSD_CL_PRE_PROCESS AS -- Package Body
2: /* $Header: MSDCLPPB.pls 120.13.12010000.1 2008/05/01 18:19:41 appldev ship $ */
3:
4:
5: v_sql_stmt PLS_INTEGER;--Holds the DML statement no used for error logging.

Line 214: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_ORG_CUST '||'('

210: EXCEPTION
211: WHEN OTHERS THEN
212: ROLLBACK;
213:
214: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_ORG_CUST '||'('
215: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
216: msc_st_util.log_message(lv_error_text);
217: ERRBUF := lv_error_text;
218: RETCODE := G_WARNING;

Line 730: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_ITEMS '||'('

726: EXCEPTION
727: WHEN OTHERS THEN
728: ROLLBACK;
729:
730: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_ITEMS '||'('
731: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
732: msc_st_util.log_message(SQLERRM);
733: msc_st_util.log_message(lv_error_text);
734: ERRBUF := lv_error_text;

Line 987: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CATEGORY '||'('

983: EXCEPTION
984: WHEN OTHERS THEN
985: ROLLBACK;
986:
987: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CATEGORY '||'('
988: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
989: msc_st_util.log_message(lv_error_text);
990: ERRBUF := lv_error_text;
991: RETCODE := G_WARNING;

Line 1136: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SITE '||'('

1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: ROLLBACK;
1135:
1136: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SITE '||'('
1137: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1138: msc_st_util.log_message(lv_error_text);
1139: ERRBUF := lv_error_text;
1140: RETCODE := G_WARNING;

Line 1361: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_DEMAND_CLASS '||'('

1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: ROLLBACK;
1360:
1361: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_DEMAND_CLASS '||'('
1362: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1363: msc_st_util.log_message(lv_error_text);
1364: ERRBUF := lv_error_text;
1365: RETCODE := G_WARNING;

Line 1800: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_LEVEL_VALUE '||'('

1796:
1797: WHEN OTHERS THEN
1798: ROLLBACK;
1799:
1800: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_LEVEL_VALUE '||'('
1801: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
1802: msc_st_util.log_message(lv_error_text);
1803: ERRBUF := lv_error_text;
1804: RETCODE := G_WARNING;

Line 2085: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_LEVEL_ASSOC'||'('

2081:
2082: WHEN OTHERS THEN
2083: ROLLBACK;
2084:
2085: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_LEVEL_ASSOC'||'('
2086: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2087: msc_st_util.log_message(lv_error_text);
2088: ERRBUF := lv_error_text;
2089: RETCODE := G_WARNING;

Line 2974: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_BOOKING_DATA '||'('

2970:
2971: WHEN OTHERS THEN
2972: ROLLBACK;
2973:
2974: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_BOOKING_DATA '||'('
2975: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
2976: msc_st_util.log_message(lv_error_text);
2977: ERRBUF := lv_error_text;
2978: RETCODE := G_WARNING;

Line 3862: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SHIPMENT_DATA '||'('

3858:
3859: WHEN OTHERS THEN
3860: ROLLBACK;
3861:
3862: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SHIPMENT_DATA '||'('
3863: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3864: msc_st_util.log_message(lv_error_text);
3865: ERRBUF := lv_error_text;
3866: RETCODE := G_WARNING;

Line 4645: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_MFG_FORECAST '||'('

4641:
4642: WHEN OTHERS THEN
4643: ROLLBACK;
4644:
4645: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_MFG_FORECAST '||'('
4646: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
4647: msc_st_util.log_message(lv_error_text);
4648: ERRBUF := lv_error_text;
4649: RETCODE := G_WARNING;

Line 4783: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_MFG_TIME '||'('

4779: EXCEPTION
4780: WHEN OTHERS THEN
4781: ROLLBACK;
4782:
4783: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_MFG_TIME '||'('
4784: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
4785: msc_st_util.log_message(lv_error_text);
4786: ERRBUF := lv_error_text;
4787: RETCODE := G_WARNING;

Line 5215: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_FISCAL_TIME '||'('

5211:
5212: WHEN OTHERS THEN
5213: ROLLBACK;
5214:
5215: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_FISCAL_TIME '||'('
5216: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5217: msc_st_util.log_message(lv_error_text);
5218: ERRBUF := lv_error_text;
5219: RETCODE := G_WARNING;

Line 5696: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_COMPOSITE_TIME '||'('

5692:
5693: WHEN OTHERS THEN
5694: ROLLBACK;
5695:
5696: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_COMPOSITE_TIME '||'('
5697: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5698: msc_st_util.log_message(lv_error_text);
5699: ERRBUF := lv_error_text;
5700: RETCODE := G_WARNING;

Line 5857: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CURRENCY_CONV '||'('

5853:
5854: WHEN OTHERS THEN
5855: ROLLBACK;
5856:
5857: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CURRENCY_CONV '||'('
5858: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5859: msc_st_util.log_message(lv_error_text);
5860: ERRBUF := lv_error_text;
5861: RETCODE := G_WARNING;

Line 6774: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CS_DATA'||'('

6770:
6771: WHEN OTHERS THEN
6772: ROLLBACK;
6773:
6774: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_CS_DATA'||'('
6775: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
6776: msc_st_util.log_message(lv_error_text);
6777: ERRBUF := lv_error_text;
6778: RETCODE := G_WARNING;

Line 7514: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_PRICE_LIST'||'('

7510:
7511: WHEN OTHERS THEN
7512: ROLLBACK;
7513:
7514: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_PRICE_LIST'||'('
7515: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
7516: msc_st_util.log_message(lv_error_text);
7517: ERRBUF := lv_error_text;
7518: RETCODE := G_WARNING;

Line 7719: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_UOM_CONV '||'('

7715:
7716: WHEN OTHERS THEN
7717: ROLLBACK;
7718:
7719: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_UOM_CONV '||'('
7720: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
7721: msc_st_util.log_message(lv_error_text);
7722: ERRBUF := lv_error_text;
7723: RETCODE := G_WARNING;

Line 7894: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SETUP_PARAMETER '||'('

7890:
7891: WHEN OTHERS THEN
7892: ROLLBACK;
7893:
7894: lv_error_text := substr('MSD_CL_PRE_PROCESS.LOAD_SETUP_PARAMETER '||'('
7895: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
7896: msc_st_util.log_message(lv_error_text);
7897: ERRBUF := lv_error_text;
7898: RETCODE := G_WARNING;

Line 8797: END MSD_CL_PRE_PROCESS;

8793:
8794:
8795: END;
8796:
8797: END MSD_CL_PRE_PROCESS;