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_API_PUB

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 211: gmd_api_pub.log_message('GMD_SS_TIME_POINTS_NOT_DEF','VARIANT_NO',to_char(l_variant_no));

207: WHEN MISSING_TIME_POINTS THEN
208: IF cr_all_variants%ISOPEN THEN
209: CLOSE cr_all_variants;
210: END IF ;
211: gmd_api_pub.log_message('GMD_SS_TIME_POINTS_NOT_DEF','VARIANT_NO',to_char(l_variant_no));
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213:
214: WHEN MISSING_SAMPLE_TIME_POINT THEN
215: IF cr_all_variants%ISOPEN THEN

Line 218: gmd_api_pub.log_message('GMD_SS_TIME_POINT_NO_SMPL','VARIANT_NO',to_char(l_variant_no));

214: WHEN MISSING_SAMPLE_TIME_POINT THEN
215: IF cr_all_variants%ISOPEN THEN
216: CLOSE cr_all_variants;
217: END IF ;
218: gmd_api_pub.log_message('GMD_SS_TIME_POINT_NO_SMPL','VARIANT_NO',to_char(l_variant_no));
219: x_return_status := FND_API.G_RET_STS_ERROR ;
220:
221: WHEN VARIANTS_MISSING THEN
222: IF cr_all_variants%ISOPEN THEN

Line 225: gmd_api_pub.log_message('GMD_SS_NO_RETAIN_SMPL','VARIANT_NO',to_char(l_variant_no));

221: WHEN VARIANTS_MISSING THEN
222: IF cr_all_variants%ISOPEN THEN
223: CLOSE cr_all_variants;
224: END IF ;
225: gmd_api_pub.log_message('GMD_SS_NO_RETAIN_SMPL','VARIANT_NO',to_char(l_variant_no));
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227:
228: WHEN MISSING_SAMPLE_QTY_UOM THEN
229: IF cr_all_variants%ISOPEN THEN

Line 232: gmd_api_pub.log_message('GMD_SS_NO_SMPL_QTY_UOM','VARIANT_NO',to_char(l_variant_no));

228: WHEN MISSING_SAMPLE_QTY_UOM THEN
229: IF cr_all_variants%ISOPEN THEN
230: CLOSE cr_all_variants;
231: END IF ;
232: gmd_api_pub.log_message('GMD_SS_NO_SMPL_QTY_UOM','VARIANT_NO',to_char(l_variant_no));
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234:
235: WHEN MISSING_RETAINED_SAMPLE THEN
236: IF cr_all_variants%ISOPEN THEN

Line 239: gmd_api_pub.log_message('GMD_SS_NO_VARIANT_MTRL_SRC');

235: WHEN MISSING_RETAINED_SAMPLE THEN
236: IF cr_all_variants%ISOPEN THEN
237: CLOSE cr_all_variants;
238: END IF ;
239: gmd_api_pub.log_message('GMD_SS_NO_VARIANT_MTRL_SRC');
240: x_return_status := FND_API.G_RET_STS_ERROR ;
241:
242: WHEN FND_API.G_EXC_ERROR THEN
243: 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 301: gmd_api_pub.log_message('GMD_SS_SMPL_QTY_LESS','LOT',l_lot_label);

297: AND lot_number = cr_material_sources_lot_rec.lot_number;
298:
299: IF cr_material_sources_lot_rec.sample_qty > l_onhand_qty THEN
300: l_lot_label := l_lot_number; -- INVCONV
301: gmd_api_pub.log_message('GMD_SS_SMPL_QTY_LESS','LOT',l_lot_label);
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: RETURN ;
304: END IF;
305: END LOOP;

Line 388: gmd_api_pub.log_message('GMD_SS_SMPL_MANUAL_NUM','ORGN',l_organization_id);

384: if l_sample_numbering < 0 then
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: RETURN ;
387: elsif l_sample_numbering = 1 THEN -- manual numbering
388: gmd_api_pub.log_message('GMD_SS_SMPL_MANUAL_NUM','ORGN',l_organization_id);
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: RETURN ;
391: end if;
392:

Line 401: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_CNT_LESS','MTRL_CNT',to_char(l_material_sources_cnt));

397: FROM gmd_ss_material_sources
398: WHERE ss_id = p_ss_id ;
399:
400: IF l_actual_mtrl_src_cnt < l_material_sources_cnt THEN
401: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_CNT_LESS','MTRL_CNT',to_char(l_material_sources_cnt));
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: RETURN;
404: END IF;
405:

Line 465: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_VAR_MISSING','SOURCE',l_source_label);

461: cr_material_src_variant_rec.lot_number || decode(cr_material_src_variant_rec.lot_number,NULL,NULL,decode(cr_material_src_variant_rec.recipe_no,NULL,NULL,'-')) || -- INVCONV
462: cr_material_src_variant_rec.recipe_no INTO l_source_label
463: FROM DUAL ;
464:
465: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_VAR_MISSING','SOURCE',l_source_label);
466: x_return_status := FND_API.G_RET_STS_ERROR ;
467: RETURN;
468: END LOOP;
469:

Line 475: gmd_api_pub.log_message('GMD_SS_VAR_STORAGE_SPEC','SPEC',cr_variants_storage_spec_rec.spec_name || '-' || cr_variants_storage_spec_rec.spec_vers);

471: -- Monitoring specs used for variants should be approved
472:
473: FOR cr_variants_storage_spec_rec in cr_variants_storage_spec
474: LOOP
475: gmd_api_pub.log_message('GMD_SS_VAR_STORAGE_SPEC','SPEC',cr_variants_storage_spec_rec.spec_name || '-' || cr_variants_storage_spec_rec.spec_vers);
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: RETURN;
478: END LOOP ;
479:

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 571: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_LOT_MISSING','SOURCE',l_source_label);

567: cr_material_src_smpl_event_rec.recipe_no INTO l_source_label
568: FROM DUAL ;
569:
570: IF cr_material_src_smpl_event_rec.lot_number IS NULL THEN
571: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_LOT_MISSING','SOURCE',l_source_label);
572: ELSE
573: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_EVENT_MISSING','SOURCE',l_source_label);
574: END IF;
575: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 573: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_EVENT_MISSING','SOURCE',l_source_label);

569:
570: IF cr_material_src_smpl_event_rec.lot_number IS NULL THEN
571: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_LOT_MISSING','SOURCE',l_source_label);
572: ELSE
573: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_EVENT_MISSING','SOURCE',l_source_label);
574: END IF;
575: x_return_status := FND_API.G_RET_STS_ERROR ;
576: RETURN;
577: END LOOP;

Line 597: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_YIELD_MISSING','SOURCE',l_source_label);

593: cr_material_src_yield_date_rec.recipe_no INTO l_source_label
594: FROM DUAL ;
595:
596: IF cr_material_src_yield_date_rec.yield_date IS NULL THEN
597: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_YIELD_MISSING','SOURCE',l_source_label);
598: ELSE
599: gmd_api_pub.log_message('GMD_SS_INVALID_VAR_SCH_DATE','SOURCE',l_source_label,'VARIANT',cr_material_src_yield_date_rec.variant_no);
600: END IF;
601: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 599: gmd_api_pub.log_message('GMD_SS_INVALID_VAR_SCH_DATE','SOURCE',l_source_label,'VARIANT',cr_material_src_yield_date_rec.variant_no);

595:
596: IF cr_material_src_yield_date_rec.yield_date IS NULL THEN
597: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_YIELD_MISSING','SOURCE',l_source_label);
598: ELSE
599: gmd_api_pub.log_message('GMD_SS_INVALID_VAR_SCH_DATE','SOURCE',l_source_label,'VARIANT',cr_material_src_yield_date_rec.variant_no);
600: END IF;
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: RETURN;
603: END LOOP;

Line 622: gmd_api_pub.log_message('GMD_SS_MISS_VAR_STORAGE_DATE','VARIANT',cr_variant_storage_date_rec.variant_no);

618: l_progress := '060';
619:
620: FOR cr_variant_storage_date_rec in cr_variant_storage_date
621: LOOP
622: gmd_api_pub.log_message('GMD_SS_MISS_VAR_STORAGE_DATE','VARIANT',cr_variant_storage_date_rec.variant_no);
623: x_return_status := FND_API.G_RET_STS_ERROR ;
624: RETURN;
625: END LOOP;
626:

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 725: GMD_API_PUB.RAISE ('oracle.apps.gmd.qm.ss.test',p_ss_id);

721: x_message := FND_MESSAGE.GET;
722: END IF;
723: ELSIF (p_target_status = 700) THEN
724: -- We need to launch; Enable the Mother workflow for testing
725: GMD_API_PUB.RAISE ('oracle.apps.gmd.qm.ss.test',p_ss_id);
726: END IF;
727:
728: RETURN ;
729: END IF;

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,