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.5.12020000.3 2012/11/13 21:44:39 plowe ship $ */
3:
4: FUNCTION get_disposition
5: ( p_po_num IN VARCHAR2,

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

111: IF cur_get_disposition%ISOPEN THEN
112: CLOSE cur_get_disposition;
113: END IF;
114:
115: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_DISPOSITION','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
116: return(l_progress);
117: --return (sqlerrm);
118:
119:

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

228: IF cur_get_quantity%ISOPEN THEN
229: CLOSE cur_get_quantity;
230: END IF;
231:
232: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_QUANTITY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
233: return(l_progress);
234: --return (sqlerrm);
235:
236: END get_quantity;

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

388: IF cur_lkup%ISOPEN THEN
389: CLOSE cur_lkup;
390: END IF;
391:
392: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.GET_INSPECTION_RESULT','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
393: return(l_progress);
394: --return (sqlerrm);
395:
396: END get_inspection_result;

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

519: IF cur_get_id%ISOPEN THEN
520: CLOSE cur_get_id;
521: END IF;
522: gmd_debug.put_line('progress = ', l_progress);
523: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QA_RCV_PUB.STORE_COLLECTION_DETAILS','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
524: rollback;
525:
526: END store_collection_details ;
527:

Line 530: END GMD_QA_RCV_PUB;

526: END store_collection_details ;
527:
528:
529:
530: END GMD_QA_RCV_PUB;