DBA Data[Home] [Help]

APPS.GMD_QA_RCV_PUB dependencies on GMD_API_PUB

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 450: --gmd_api_pub.log_message('GMD 1','entering store_collection_details ');

446:
447: BEGIN
448: gmd_debug.log_initialize('PLOWE');
449: gmd_debug.put_line('entering store_collection_details ');
450: --gmd_api_pub.log_message('GMD 1','entering store_collection_details ');
451: --gmd_api_pub.log_message('GMD 1','PO_NUM = ',p_po_num,'ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
452:
453: IF (p_po_num IS NOT NULL) THEN
454: OPEN cur_get_id;

Line 451: --gmd_api_pub.log_message('GMD 1','PO_NUM = ',p_po_num,'ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

447: BEGIN
448: gmd_debug.log_initialize('PLOWE');
449: gmd_debug.put_line('entering store_collection_details ');
450: --gmd_api_pub.log_message('GMD 1','entering store_collection_details ');
451: --gmd_api_pub.log_message('GMD 1','PO_NUM = ',p_po_num,'ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
452:
453: IF (p_po_num IS NOT NULL) THEN
454: OPEN cur_get_id;
455: l_progress := '010';

Line 513: gmd_api_pub.log_message('GMD 11','exiting store_collection_details ');

509: l_progress := '110';
510: COMMIT;
511: l_progress := '120';
512: end if;
513: gmd_api_pub.log_message('GMD 11','exiting store_collection_details ');
514: exception
515: when others then
516: IF cur_get_plan_id%ISOPEN THEN
517: CLOSE cur_get_plan_id;

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: