DBA Data[Home] [Help]

APPS.BOMPPRCB dependencies on BOMPPRCB

Line 1: package body BOMPPRCB as

1: package body BOMPPRCB as
2: /* $Header: BOMPRCBB.pls 115.6 2002/10/31 07:33:35 djebar ship $ */
3: function bmprobm_process_bom
4: ( ato_flag in NUMBER,
5: prg_appid in NUMBER,

Line 392: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: return(1);
391: WHEN OTHERS THEN
392: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);
393: message_name := 'BOM_ATO_PROCESS_ERROR';
394: return(0);
395:
396: END bmprobm_process_bom;

Line 970: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'||substrb(sqlerrm,1,150);

966: EXCEPTION
967: WHEN NO_DATA_FOUND THEN
968: return(1);
969: WHEN OTHERS THEN
970: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'||substrb(sqlerrm,1,150);
971: message_name := 'BOM_ATO_PROCESS_ERROR';
972: return(0);
973:
974: END bmprort_process_rtg;

Line 1204: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

1200: EXCEPTION
1201: WHEN NO_DATA_FOUND THEN
1202: return(1);
1203: WHEN OTHERS THEN
1204: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);
1205: message_name := 'BOM_ATO_PROCESS_ERROR';
1206: return(0);
1207:
1208: END bmproec_process_eco;

Line 1439: error_message :='BOMPPRCB:'||to_char(stmt_num)||':'||substrb(sqlerrm,1,150);

1435: EXCEPTION
1436: WHEN NO_DATA_FOUND THEN
1437: return(1);
1438: WHEN PROCESS_ERROR THEN
1439: error_message :='BOMPPRCB:'||to_char(stmt_num)||':'||substrb(sqlerrm,1,150);
1440: message_name := 'BOM_ATO_PROCESS_ERROR';
1441: return(status);
1442: WHEN OTHERS THEN
1443: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

Line 1443: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

1439: error_message :='BOMPPRCB:'||to_char(stmt_num)||':'||substrb(sqlerrm,1,150);
1440: message_name := 'BOM_ATO_PROCESS_ERROR';
1441: return(status);
1442: WHEN OTHERS THEN
1443: error_message:='BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);
1444: message_name := 'BOM_ATO_PROCESS_ERROR';
1445: return(status);
1446:
1447: END bmprobr_process_bom_rtg;

Line 1964: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

1960: WHEN NO_DATA_FOUND THEN
1961: return(1);
1962: WHEN OTHERS THEN
1963: rollback;
1964: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);
1965: message_name := 'BOM_BILL_PROCESS_ERROR';
1966: return(SQLCODE);
1967:
1968: END bmprbill_process_bill_data;

Line 2373: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);

2369: WHEN NO_DATA_FOUND THEN
2370: return(1);
2371: WHEN OTHERS THEN
2372: rollback;
2373: error_message := 'BOMPPRCB:'||to_char(stmt_num)||':'|| substrb(sqlerrm,1,150);
2374: message_name := 'BOM_RTG_PROCESS_ERROR';
2375: return(SQLCODE);
2376:
2377: END bmprrtg_process_rtg_data;

Line 2380: END BOMPPRCB;

2376:
2377: END bmprrtg_process_rtg_data;
2378:
2379:
2380: END BOMPPRCB;