DBA Data[Home] [Help]

APPS.GMD_QA_RCV_PUB dependencies on GMD_QA_RCV_PUB

Line 1: PACKAGE BODY GMD_QA_RCV_PUB AS

1: PACKAGE BODY GMD_QA_RCV_PUB AS
2: /* $Header: GMDPRECB.pls 120.1 2006/04/10 09:20:41 plowe noship $ */
3:
4: FUNCTION get_disposition
5: ( p_po_num IN VARCHAR2,

Line 72: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_DISPOSITION','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

68: IF cur_get_disposition%ISOPEN THEN
69: CLOSE cur_get_disposition;
70: END IF;
71:
72: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_DISPOSITION','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
73: return(l_progress);
74: --return (sqlerrm);
75:
76:

Line 144: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_QUANTITY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

140: IF cur_get_quantity%ISOPEN THEN
141: CLOSE cur_get_quantity;
142: END IF;
143:
144: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_QUANTITY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
145: return(l_progress);
146: --return (sqlerrm);
147:
148: END get_quantity;

Line 259: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_INSPECTION_RESULT','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

255: IF cur_lkup%ISOPEN THEN
256: CLOSE cur_lkup;
257: END IF;
258:
259: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_INSPECTION_RESULT','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
260: return(l_progress);
261: --return (sqlerrm);
262:
263: END get_inspection_result;

Line 389: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.STORE_COLLECTION_DETAILS','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

385: IF cur_get_id%ISOPEN THEN
386: CLOSE cur_get_id;
387: END IF;
388:
389: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.STORE_COLLECTION_DETAILS','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
390: rollback;
391:
392: END store_collection_details ;
393:

Line 396: END GMD_QA_RCV_PUB;

392: END store_collection_details ;
393:
394:
395:
396: END GMD_QA_RCV_PUB;