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

Line 1: PACKAGE BODY GMD_STABILITY_STUDIES_GRP AS

1: PACKAGE BODY GMD_STABILITY_STUDIES_GRP AS
2: /* $Header: GMDGSSTB.pls 120.2 2005/09/02 01:55:35 svankada noship $ */
3:
4: FUNCTION Stability_Study_Exist(p_stability_study_no IN VARCHAR2 )
5: RETURN BOOLEAN IS

Line 204: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.CALCULATE_SAMPLE_QTY');

200:
201:
202: EXCEPTION
203: WHEN REQ_FIELDS_MISSING THEN
204: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.CALCULATE_SAMPLE_QTY');
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206:
207: WHEN MISSING_TIME_POINTS THEN
208: IF cr_all_variants%ISOPEN THEN

Line 251: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.CALCULATE_SAMPLE_QTY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

247: WHEN OTHERS THEN
248: IF cr_all_variants%ISOPEN THEN
249: CLOSE cr_all_variants;
250: END IF ;
251: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.CALCULATE_SAMPLE_QTY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: END calculate_sample_qty ;
255:

Line 413: gmd_stability_studies_grp.calculate_sample_qty(

409: l_progress := '040';
410:
411: FOR cr_material_sources_rec in cr_material_sources
412: LOOP
413: gmd_stability_studies_grp.calculate_sample_qty(
414: p_source_id => cr_material_sources_rec.source_id,
415: p_sample_qty => l_sample_qty_out,
416: p_sample_uom => l_sample_uom_out,
417: x_return_status => l_return_status) ;

Line 482: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK');

478: END LOOP ;
479:
480: EXCEPTION
481: WHEN REQ_FIELDS_MISSING THEN
482: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK');
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484:
485: WHEN OTHERS THEN
486: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

Line 486: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

482: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK');
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484:
485: WHEN OTHERS THEN
486: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_APPROVAL_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488:
489: END ss_approval_checklist_ok ;
490:

Line 630: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK');

626:
627:
628: EXCEPTION
629: WHEN REQ_FIELDS_MISSING THEN
630: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK');
631: x_return_status := FND_API.G_RET_STS_ERROR ;
632:
633: WHEN OTHERS THEN
634: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

Line 634: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

630: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK');
631: x_return_status := FND_API.G_RET_STS_ERROR ;
632:
633: WHEN OTHERS THEN
634: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.SS_LAUNCH_CHECKLIST_OK','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
636:
637: END ss_launch_checklist_ok ;
638:

Line 763: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.CHANGE_SS_STATUS','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);

759:
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_STABILITY_STUDIES_GRP.CHANGE_SS_STATUS','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_progress);
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: --x_message := FND_MESSAGE.GET;
766: FND_MSG_PUB.GET(p_msg_index => -3,
767: p_data => X_message,

Line 773: END GMD_STABILITY_STUDIES_GRP;

769: p_msg_index_out => l_temp_index) ;
770:
771: END change_ss_status ;
772:
773: END GMD_STABILITY_STUDIES_GRP;