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_SAMPLES_GRP dependencies on GMD_API_PUB

Line 476: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

472: OPEN c_inv_sampling_event;
473: FETCH c_inv_sampling_event INTO x_sampling_event_id;
474: IF c_inv_sampling_event%NOTFOUND THEN
475: CLOSE c_inv_sampling_event;
476: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479: CLOSE c_inv_sampling_event;
480: ELSIF p_sample.source = 'W' THEN

Line 486: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

482: OPEN c_wip_sampling_event;
483: FETCH c_wip_sampling_event INTO x_sampling_event_id;
484: IF c_wip_sampling_event%NOTFOUND THEN
485: CLOSE c_wip_sampling_event;
486: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489: CLOSE c_wip_sampling_event;
490: ELSIF p_sample.source = 'C' THEN

Line 496: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

492: OPEN c_cust_sampling_event;
493: FETCH c_cust_sampling_event INTO x_sampling_event_id;
494: IF c_cust_sampling_event%NOTFOUND THEN
495: CLOSE c_cust_sampling_event;
496: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: CLOSE c_cust_sampling_event;
500: ELSIF p_sample.source = 'S' THEN

Line 506: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

502: OPEN c_supp_sampling_event;
503: FETCH c_supp_sampling_event INTO x_sampling_event_id;
504: IF c_supp_sampling_event%NOTFOUND THEN
505: CLOSE c_supp_sampling_event;
506: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509: CLOSE c_supp_sampling_event;
510: ELSIF p_sample.source = 'L' THEN

Line 529: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');

525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527: CLOSE c_res_sampling_event;
528: ELSE
529: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: -- If we reached here then we have found a Sampling event record

Line 878: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

874: OPEN c_inv_sampling_event;
875: FETCH c_inv_sampling_event INTO x_sampling_event_id;
876: IF c_inv_sampling_event%NOTFOUND THEN
877: CLOSE c_inv_sampling_event;
878: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881: CLOSE c_inv_sampling_event;
882: ELSIF p_sample.source = 'W' THEN

Line 888: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

884: OPEN c_wip_sampling_event;
885: FETCH c_wip_sampling_event INTO x_sampling_event_id;
886: IF c_wip_sampling_event%NOTFOUND THEN
887: CLOSE c_wip_sampling_event;
888: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: CLOSE c_wip_sampling_event;
892: ELSIF p_sample.source = 'C' THEN

Line 898: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

894: OPEN c_cust_sampling_event;
895: FETCH c_cust_sampling_event INTO x_sampling_event_id;
896: IF c_cust_sampling_event%NOTFOUND THEN
897: CLOSE c_cust_sampling_event;
898: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
899: RAISE FND_API.G_EXC_ERROR;
900: END IF;
901: CLOSE c_cust_sampling_event;
902: ELSIF p_sample.source = 'S' THEN

Line 908: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

904: OPEN c_supp_sampling_event;
905: FETCH c_supp_sampling_event INTO x_sampling_event_id;
906: IF c_supp_sampling_event%NOTFOUND THEN
907: CLOSE c_supp_sampling_event;
908: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911: CLOSE c_supp_sampling_event;
912: ELSIF p_sample.source = 'L' THEN

Line 931: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');

927: RAISE FND_API.G_EXC_ERROR;
928: END IF;
929: CLOSE c_res_sampling_event;
930: ELSE
931: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: -- If we reached here then we have found a Sampling event record

Line 1183: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

1179: OPEN c_inv_sampling_event;
1180: FETCH c_inv_sampling_event INTO x_sampling_event_id;
1181: IF c_inv_sampling_event%NOTFOUND THEN
1182: CLOSE c_inv_sampling_event;
1183: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: CLOSE c_inv_sampling_event;
1187: ELSIF p_sample.source = 'W' THEN

Line 1193: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

1189: OPEN c_wip_sampling_event;
1190: FETCH c_wip_sampling_event INTO x_sampling_event_id;
1191: IF c_wip_sampling_event%NOTFOUND THEN
1192: CLOSE c_wip_sampling_event;
1193: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196: CLOSE c_wip_sampling_event;
1197: ELSIF p_sample.source = 'C' THEN

Line 1203: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

1199: OPEN c_cust_sampling_event;
1200: FETCH c_cust_sampling_event INTO x_sampling_event_id;
1201: IF c_cust_sampling_event%NOTFOUND THEN
1202: CLOSE c_cust_sampling_event;
1203: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;
1206: CLOSE c_cust_sampling_event;
1207: ELSIF p_sample.source = 'S' THEN

Line 1213: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

1209: OPEN c_supp_sampling_event;
1210: FETCH c_supp_sampling_event INTO x_sampling_event_id;
1211: IF c_supp_sampling_event%NOTFOUND THEN
1212: CLOSE c_supp_sampling_event;
1213: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1214: RAISE FND_API.G_EXC_ERROR;
1215: END IF;
1216: CLOSE c_supp_sampling_event;
1217:

Line 1238: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');

1234: END IF;
1235: CLOSE c_res_sampling_event;
1236:
1237: ELSE
1238: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241:
1242: -- If we reached here then we have found a Sampling event record

Line 1429: GMD_API_PUB.Log_Message('GMD_QM_ORG_PARAMETER');

1425: , x_return_status => x_return_status
1426: , x_orgn_found => found );
1427:
1428: IF NOT(found) OR (x_return_status <> 'S') THEN
1429: GMD_API_PUB.Log_Message('GMD_QM_ORG_PARAMETER');
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: -- Skip if automatic assignmnet type, so sample number can be retrived after

Line 1440: GMD_API_PUB.Log_Message('GMD_SAMPLE_EXIST',

1436:
1437: -- If inserting a Sample, Sample_No must be unique
1438: IF sample_exist(p_sample.organization_id, p_sample.sample_no) THEN
1439: -- Huston, we have a problem...
1440: GMD_API_PUB.Log_Message('GMD_SAMPLE_EXIST',
1441: 'ORGN_CODE', p_sample.organization_id,
1442: 'SAMPLE_NO', p_sample.sample_no);
1443: RAISE FND_API.G_EXC_ERROR;
1444: END IF;

Line 2131: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

2127: WHERE sampling_event_id = l_sampling_event_id ;
2128:
2129:
2130: EXCEPTION WHEN REQ_FIELDS_MISSING THEN
2131: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2132: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2133: x_return_status := FND_API.G_RET_STS_ERROR ;
2134: WHEN INVALID_PARAMETER THEN
2135: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

Line 2135: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

2131: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2132: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2133: x_return_status := FND_API.G_RET_STS_ERROR ;
2134: WHEN INVALID_PARAMETER THEN
2135: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2136: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2137: x_return_status := FND_API.G_RET_STS_ERROR ;
2138: WHEN SAMPLE_SPEC_CHANGED THEN
2139: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

Line 2139: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

2135: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2136: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2137: x_return_status := FND_API.G_RET_STS_ERROR ;
2138: WHEN SAMPLE_SPEC_CHANGED THEN
2139: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2140: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2141: x_return_status := FND_API.G_RET_STS_ERROR ;
2142: WHEN SAMPLE_DISP_CHANGED THEN
2143: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

Line 2143: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

2139: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2140: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2141: x_return_status := FND_API.G_RET_STS_ERROR ;
2142: WHEN SAMPLE_DISP_CHANGED THEN
2143: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2144: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2145: x_return_status := FND_API.G_RET_STS_ERROR ;
2146: WHEN OTHERS THEN
2147: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

Line 2147: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

2143: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2144: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2145: x_return_status := FND_API.G_RET_STS_ERROR ;
2146: WHEN OTHERS THEN
2147: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
2148: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2150:
2151: END update_sample_comp_disp ;

Line 2257: gmd_api_pub.log_message('GMD_QM_CHANGE_DISP_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');

2253: );
2254:
2255:
2256: IF SQL%NOTFOUND THEN
2257: gmd_api_pub.log_message('GMD_QM_CHANGE_DISP_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2258: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2259: x_return_status := FND_API.G_RET_STS_ERROR ;
2260: END IF; -- SQL%NOTFOUND THEN
2261:

Line 2330: gmd_api_pub.log_message('GMD_QM_CHANGE_LOT_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');

2326:
2327: END IF; -- (p_update_change_disp_rec.LOT_NUMBER IS NOT NULL)
2328:
2329: IF SQL%NOTFOUND THEN
2330: gmd_api_pub.log_message('GMD_QM_CHANGE_LOT_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2331: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2332: x_return_status := FND_API.G_RET_STS_ERROR ;
2333: END IF; -- SQL%NOTFOUND THEN
2334:

Line 3373: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');

3369: , p_onhand_reason_id => l_onhand_reason_id -- Added for # 91432301
3370: ); */
3371: --end of bug 10169386
3372: IF x_return_status <> 'S' THEN
3373: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
3374: RAISE FND_API.G_EXC_ERROR;
3375: END IF; -- x_return_status <> 'S'
3376:
3377: END IF; -- (p_from_lot_status_id <> get_curr_lot_status_rec.status_id THEN

Line 3497: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

3493:
3494: EXCEPTION
3495: WHEN SAMPLE_DISP_CHANGED THEN
3496: --RLNAGARA B5668965 Changed the message from GMD_SMPL_DISP_CHANGE to GMD_QM_CURRENT_LOT_VALUE_CHANG
3497: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
3498: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3499: x_return_status := FND_API.G_RET_STS_ERROR ;
3500: WHEN REQ_FIELDS_MISSING THEN
3501: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');

Line 3501: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');

3497: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
3498: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3499: x_return_status := FND_API.G_RET_STS_ERROR ;
3500: WHEN REQ_FIELDS_MISSING THEN
3501: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
3502: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3503: x_return_status := FND_API.G_RET_STS_ERROR ;
3504: WHEN INVALID_SAMPLE THEN
3505: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');

Line 3505: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');

3501: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
3502: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3503: x_return_status := FND_API.G_RET_STS_ERROR ;
3504: WHEN INVALID_SAMPLE THEN
3505: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
3506: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3507: x_return_status := FND_API.G_RET_STS_ERROR ;
3508: WHEN INVALID_QC_STATUS THEN
3509: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');

Line 3509: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');

3505: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
3506: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3507: x_return_status := FND_API.G_RET_STS_ERROR ;
3508: WHEN INVALID_QC_STATUS THEN
3509: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');
3510: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3511: x_return_status := FND_API.G_RET_STS_ERROR ;
3512:
3513: WHEN RECORD_LOCK THEN

Line 3514: GMD_API_PUB.Log_Message('GMD_IC_LOTS_CPG_LOCKED');

3510: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3511: x_return_status := FND_API.G_RET_STS_ERROR ;
3512:
3513: WHEN RECORD_LOCK THEN
3514: GMD_API_PUB.Log_Message('GMD_IC_LOTS_CPG_LOCKED');
3515: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3516: x_return_status := FND_API.G_RET_STS_ERROR ;
3517:
3518: WHEN OTHERS THEN

Line 3525: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

3521: END IF;
3522: IF get_curr_lot_status_cv%ISOPEN THEN
3523: CLOSE get_curr_lot_status_cv;
3524: END IF;
3525: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
3526: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
3527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3528: END update_lot_grade_batch ;
3529:

Line 3820: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_REQD');

3816: x_return_status := FND_API.G_RET_STS_SUCCESS;
3817:
3818: -- Orgn Code
3819: IF (p_sample.organization_id IS NULL) THEN
3820: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_REQD');
3821: RAISE FND_API.G_EXC_ERROR;
3822: ELSE
3823: -- Check that orgn Code exist in SY_ORGN_MST
3824: OPEN c_orgn(p_sample.organization_id);

Line 3828: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_NOT_FOUND',

3824: OPEN c_orgn(p_sample.organization_id);
3825: FETCH c_orgn INTO dummy;
3826: IF c_orgn%NOTFOUND THEN
3827: CLOSE c_orgn;
3828: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_NOT_FOUND',
3829: 'ORGN', p_sample.lab_organization_id);
3830: RAISE FND_API.G_EXC_ERROR;
3831: END IF;
3832: CLOSE c_orgn;

Line 3838: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_REQD');

3834:
3835: -- Sampler Id Validation
3836:
3837: IF (p_sample.sampler_id IS NULL ) THEN
3838: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_REQD');
3839: RAISE FND_API.G_EXC_ERROR;
3840: ELSE
3841: -- Check that orgn Code exist in SY_ORGN_MST
3842: OPEN c_sampler(p_sample.organization_id, p_sample.sampler_id);

Line 3845: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',

3841: -- Check that orgn Code exist in SY_ORGN_MST
3842: OPEN c_sampler(p_sample.organization_id, p_sample.sampler_id);
3843: FETCH c_sampler INTO dummy;
3844: IF c_sampler%NOTFOUND THEN
3845: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',
3846: 'SAMPLER', p_sample.sampler_id);
3847: RAISE FND_API.G_EXC_ERROR;
3848: CLOSE c_sampler;
3849: END IF;

Line 3856: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');

3852:
3853:
3854: -- Sample No
3855: IF (ltrim(rtrim(p_sample.sample_no)) IS NULL) THEN
3856: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');
3857: RAISE FND_API.G_EXC_ERROR;
3858: END IF;
3859:
3860: -- Sample Source

Line 3865: GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');

3861: IF (p_sample.source IS NULL OR
3862: (NOT (p_sample.source in ('I', 'W', 'C', 'S','L','R','T')))
3863: ) THEN
3864: -- Now, what is the source of this sample? Where did it come from?
3865: GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
3866: RAISE FND_API.G_EXC_ERROR;
3867: END IF;
3868:
3869: -- QC Lab Orgn Code

Line 3871: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_REQD');

3867: END IF;
3868:
3869: -- QC Lab Orgn Code
3870: IF (p_sample.lab_organization_id IS NULL) THEN
3871: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_REQD');
3872: RAISE FND_API.G_EXC_ERROR;
3873: ELSE
3874: -- Check that QC Lab Orgn Code exist in SY_ORGN_MST
3875: OPEN c_lab_orgn(p_sample.lab_organization_id);

Line 3879: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_NOT_FOUND',

3875: OPEN c_lab_orgn(p_sample.lab_organization_id);
3876: FETCH c_lab_orgn INTO dummy;
3877: IF c_lab_orgn%NOTFOUND THEN
3878: CLOSE c_lab_orgn;
3879: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_NOT_FOUND',
3880: 'ORGN', p_sample.lab_organization_id);
3881: RAISE FND_API.G_EXC_ERROR;
3882: END IF;
3883: CLOSE c_lab_orgn;

Line 3893: GMD_API_PUB.Log_Message('GMD_SAMPLE_DISPOSITION_INVALID');

3889: IF (p_sample.sample_disposition IS NULL OR
3890: (NOT (p_sample.sample_disposition in ('0RT', '1P')))
3891: ) THEN
3892: -- Now, what is the disposition of this sample?
3893: GMD_API_PUB.Log_Message('GMD_SAMPLE_DISPOSITION_INVALID');
3894: RAISE FND_API.G_EXC_ERROR;
3895: END IF;
3896:
3897: -- Item ID

Line 3900: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_REQD');

3896:
3897: -- Item ID
3898: IF (p_sample.inventory_item_id IS NULL) and
3899: (p_sample.sample_type = 'M' ) THEN
3900: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_REQD');
3901: RAISE FND_API.G_EXC_ERROR;
3902: ELSE
3903: -- Get the Item No
3904: OPEN c_item(p_sample.inventory_item_id, p_sample.organization_id);

Line 3908: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');

3904: OPEN c_item(p_sample.inventory_item_id, p_sample.organization_id);
3905: FETCH c_item INTO dummy;
3906: IF c_item%NOTFOUND THEN
3907: CLOSE c_item;
3908: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');
3909: RAISE FND_API.G_EXC_ERROR;
3910: END IF;
3911: CLOSE c_item;
3912: END IF;

Line 3925: GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

3921: OPEN c_sampling_event(p_sample.sampling_event_id);
3922: FETCH c_sampling_event INTO dummy;
3923: IF c_sampling_event%NOTFOUND THEN
3924: CLOSE c_sampling_event;
3925: GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
3926: RAISE FND_API.G_EXC_ERROR;
3927: END IF;
3928: CLOSE c_sampling_event;
3929: END IF;

Line 3934: GMD_API_PUB.Log_Message('GMD_SAMPLE_QTY_REQD');

3930: ** COMMENT END **/
3931:
3932: -- Sample Qty
3933: IF (p_sample.sample_qty IS NULL) THEN
3934: GMD_API_PUB.Log_Message('GMD_SAMPLE_QTY_REQD');
3935: RAISE FND_API.G_EXC_ERROR;
3936: END IF;
3937:
3938: -- Sample UOM

Line 3940: GMD_API_PUB.Log_Message('GMD_SAMPLE_UOM_REQD');

3936: END IF;
3937:
3938: -- Sample UOM
3939: IF (p_sample.sample_qty_uom IS NULL) THEN
3940: GMD_API_PUB.Log_Message('GMD_SAMPLE_UOM_REQD');
3941: RAISE FND_API.G_EXC_ERROR;
3942: END IF;
3943:
3944: -- Lot No

Line 3951: GMD_API_PUB.Log_Message('GMD_ITEM_LOT_NOT_FOUND',

3947: FETCH c_item_lot INTO dummy;
3948: IF c_item_lot%NOTFOUND THEN
3949: --Uday Phadtare Bug2982490 changed CLOSE c_whse to CLOSE c_item_lot
3950: CLOSE c_item_lot;
3951: GMD_API_PUB.Log_Message('GMD_ITEM_LOT_NOT_FOUND',
3952: 'LOT_NO', p_sample.lot_number);
3953: RAISE FND_API.G_EXC_ERROR;
3954: END IF;
3955: CLOSE c_item_lot;

Line 3970: GMD_API_PUB.Log_Message('GMD_SPEC_WHSE_NOT_FOUND',

3966: OPEN c_subinventory;
3967: FETCH c_subinventory INTO dummy;
3968: IF c_subinventory%NOTFOUND THEN
3969: CLOSE c_subinventory;
3970: GMD_API_PUB.Log_Message('GMD_SPEC_WHSE_NOT_FOUND',
3971: 'WHSE', p_sample.subinventory);
3972: RAISE FND_API.G_EXC_ERROR;
3973: END IF;
3974: CLOSE c_subinventory;

Line 3984: GMD_API_PUB.Log_Message('GMD_LOCT_NOT_FOUND',

3980: OPEN c_locator;
3981: FETCH c_locator INTO dummy;
3982: IF c_locator%NOTFOUND THEN
3983: CLOSE c_locator;
3984: GMD_API_PUB.Log_Message('GMD_LOCT_NOT_FOUND',
3985: 'LOCATION', p_sample.locator_id);
3986: RAISE FND_API.G_EXC_ERROR;
3987: END IF;
3988: CLOSE c_locator;

Line 3999: GMD_API_PUB.Log_Message('GMD_NO_WIP_PARAM');

3995: -- those parameters related to WIP
3996:
3997: -- For WIP sample, at least Batch No or Recipe ID is required
3998: IF (p_sample.batch_id IS NULL AND p_sample.recipe_id IS NULL) THEN
3999: GMD_API_PUB.Log_Message('GMD_NO_WIP_PARAM');
4000: RAISE FND_API.G_EXC_ERROR;
4001: END IF;
4002:
4003: -- Batch ID is valid

Line 4010: GMD_API_PUB.Log_Message('GMD_BATCH_NOT_FOUND');

4006: OPEN c_batch;
4007: FETCH c_batch INTO dummy;
4008: IF c_batch%NOTFOUND THEN
4009: CLOSE c_batch;
4010: GMD_API_PUB.Log_Message('GMD_BATCH_NOT_FOUND');
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;
4013: CLOSE c_batch;
4014: END IF;

Line 4022: GMD_API_PUB.Log_Message('GMD_RECIPE_NOT_FOUND');

4018: OPEN c_recipe_id;
4019: FETCH c_recipe_id INTO dummy;
4020: IF c_recipe_id%NOTFOUND THEN
4021: CLOSE c_recipe_id;
4022: GMD_API_PUB.Log_Message('GMD_RECIPE_NOT_FOUND');
4023: RAISE FND_API.G_EXC_ERROR;
4024: END IF;
4025: CLOSE c_recipe_id;
4026: END IF;

Line 4037: GMD_API_PUB.Log_Message('GMD_FORMULA_LINE_NOT_FOUND');

4033: OPEN c_formulaline_id;
4034: FETCH c_formulaline_id INTO dummy;
4035: IF c_formulaline_id%NOTFOUND THEN
4036: CLOSE c_formulaline_id;
4037: GMD_API_PUB.Log_Message('GMD_FORMULA_LINE_NOT_FOUND');
4038: RAISE FND_API.G_EXC_ERROR;
4039: END IF;
4040: CLOSE c_formulaline_id;
4041: END IF;

Line 4051: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');

4047: OPEN c_material_detail_id;
4048: FETCH c_material_detail_id INTO dummy;
4049: IF c_material_detail_id%NOTFOUND THEN
4050: CLOSE c_material_detail_id;
4051: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');
4052: RAISE FND_API.G_EXC_ERROR;
4053: END IF;
4054: CLOSE c_material_detail_id;
4055: END IF;

Line 4064: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');

4060: OPEN c_batchstep;
4061: FETCH c_batchstep INTO dummy;
4062: IF c_batchstep%NOTFOUND THEN
4063: CLOSE c_batchstep;
4064: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067: CLOSE c_batchstep;
4068: ELSIF (p_sample.routing_id IS NOT NULL AND p_sample.step_no IS NOT NULL) THEN

Line 4074: GMD_API_PUB.Log_Message('GMD_ROUTING_STEP_NOT_FOUND');

4070: OPEN c_routingstep;
4071: FETCH c_routingstep INTO dummy;
4072: IF c_routingstep%NOTFOUND THEN
4073: CLOSE c_routingstep;
4074: GMD_API_PUB.Log_Message('GMD_ROUTING_STEP_NOT_FOUND');
4075: RAISE FND_API.G_EXC_ERROR;
4076: END IF;
4077: CLOSE c_routingstep;
4078: END IF;

Line 4087: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');

4083: OPEN c_oprn;
4084: FETCH c_oprn INTO dummy;
4085: IF c_oprn%NOTFOUND THEN
4086: CLOSE c_oprn;
4087: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');
4088: RAISE FND_API.G_EXC_ERROR;
4089: END IF;
4090: CLOSE c_oprn;
4091: END IF;

Line 4101: GMD_API_PUB.Log_Message('GMD_CUSTOMER_REQD');

4097: -- those parameters related to Customer
4098:
4099: -- Customer
4100: IF (p_sample.cust_id IS NULL) THEN
4101: GMD_API_PUB.Log_Message('GMD_CUSTOMER_REQD');
4102: RAISE FND_API.G_EXC_ERROR;
4103: ELSE
4104: OPEN c_cust;
4105: FETCH c_cust INTO dummy;

Line 4108: GMD_API_PUB.Log_Message('GMD_CUSTOMER_NOT_FOUND');

4104: OPEN c_cust;
4105: FETCH c_cust INTO dummy;
4106: IF c_cust%NOTFOUND THEN
4107: CLOSE c_cust;
4108: GMD_API_PUB.Log_Message('GMD_CUSTOMER_NOT_FOUND');
4109: RAISE FND_API.G_EXC_ERROR;
4110: END IF;
4111: CLOSE c_cust;
4112: END IF;

Line 4120: -- GMD_API_PUB.Log_Message('GMD_ORG_NOT_FOUND');

4116: -- OPEN c_org;
4117: -- FETCH c_org INTO dummy;
4118: -- IF c_cust%NOTFOUND THEN
4119: -- CLOSE c_org;
4120: -- GMD_API_PUB.Log_Message('GMD_ORG_NOT_FOUND');
4121: -- RAISE FND_API.G_EXC_ERROR;
4122: -- END IF;
4123: -- CLOSE c_org;
4124: --END IF;

Line 4132: GMD_API_PUB.Log_Message('GMD_SHIP_TO_NOT_FOUND');

4128: OPEN c_ship_to;
4129: FETCH c_ship_to INTO dummy;
4130: IF c_ship_to%NOTFOUND THEN
4131: CLOSE c_ship_to;
4132: GMD_API_PUB.Log_Message('GMD_SHIP_TO_NOT_FOUND');
4133: RAISE FND_API.G_EXC_ERROR;
4134: END IF;
4135: CLOSE c_ship_to;
4136: END IF;

Line 4144: GMD_API_PUB.Log_Message('GMD_ORDER_NOT_FOUND');

4140: OPEN c_order;
4141: FETCH c_order INTO dummy;
4142: IF c_order%NOTFOUND THEN
4143: CLOSE c_order;
4144: GMD_API_PUB.Log_Message('GMD_ORDER_NOT_FOUND');
4145: RAISE FND_API.G_EXC_ERROR;
4146: END IF;
4147: CLOSE c_order;
4148: END IF;

Line 4156: GMD_API_PUB.Log_Message('GMD_ORDER_LINE_NOT_FOUND');

4152: OPEN c_order_line;
4153: FETCH c_order_line INTO dummy;
4154: IF c_order_line%NOTFOUND THEN
4155: CLOSE c_order_line;
4156: GMD_API_PUB.Log_Message('GMD_ORDER_LINE_NOT_FOUND');
4157: RAISE FND_API.G_EXC_ERROR;
4158: END IF;
4159: CLOSE c_order_line;
4160: END IF;

Line 4170: GMD_API_PUB.Log_Message('GMD_SUPPLIER_REQD');

4166: -- those parameters related to Supplier
4167:
4168: -- Supplier
4169: IF (p_sample.supplier_id IS NULL) THEN
4170: GMD_API_PUB.Log_Message('GMD_SUPPLIER_REQD');
4171: RAISE FND_API.G_EXC_ERROR;
4172: ELSIF (p_sample.supplier_id IS NOT NULL) THEN
4173: OPEN c_supplier;
4174: FETCH c_supplier INTO dummy;

Line 4177: GMD_API_PUB.Log_Message('GMD_SUPPLIER_NOT_FOUND');

4173: OPEN c_supplier;
4174: FETCH c_supplier INTO dummy;
4175: IF c_supplier%NOTFOUND THEN
4176: CLOSE c_supplier;
4177: GMD_API_PUB.Log_Message('GMD_SUPPLIER_NOT_FOUND');
4178: RAISE FND_API.G_EXC_ERROR;
4179: END IF;
4180: CLOSE c_supplier;
4181: END IF;

Line 4189: GMD_API_PUB.Log_Message('GMD_PO_NOT_FOUND');

4185: OPEN c_po;
4186: FETCH c_po INTO dummy;
4187: IF c_po%NOTFOUND THEN
4188: CLOSE c_po;
4189: GMD_API_PUB.Log_Message('GMD_PO_NOT_FOUND');
4190: RAISE FND_API.G_EXC_ERROR;
4191: END IF;
4192: CLOSE c_po;
4193: END IF;

Line 4201: GMD_API_PUB.Log_Message('GMD_PO_LINE_NOT_FOUND');

4197: OPEN c_po_line;
4198: FETCH c_po_line INTO dummy;
4199: IF c_po_line%NOTFOUND THEN
4200: CLOSE c_po_line;
4201: GMD_API_PUB.Log_Message('GMD_PO_LINE_NOT_FOUND');
4202: RAISE FND_API.G_EXC_ERROR;
4203: END IF;
4204: CLOSE c_po_line;
4205: END IF;

Line 4218: GMD_API_PUB.Log_Message('WMS_ONLY_FUNCTIONALITY');

4214: FETCH get_wms_flag INTO l_wms_enabled_flag;
4215: CLOSE get_wms_flag;
4216:
4217: IF l_wms_enabled_flag = 'N' then
4218: GMD_API_PUB.Log_Message('WMS_ONLY_FUNCTIONALITY');
4219: RAISE FND_API.G_EXC_ERROR;
4220: END IF;
4221:
4222: END IF; -- IF (p_sample.lpn_id IS NOT NULL or p_sample.lpn IS NOT NULL ) THEN

Line 4229: GMD_API_PUB.Log_Message('WMS_LPN_NOT_FOUND');

4225: OPEN get_lpn;
4226: FETCH get_lpn INTO dummy;
4227: IF get_lpn%NOTFOUND THEN
4228: CLOSE get_lpn;
4229: GMD_API_PUB.Log_Message('WMS_LPN_NOT_FOUND');
4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4232: CLOSE get_lpn;
4233: END IF;

Line 4344: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');

4340: , x_return_status => x_return_status
4341: , x_orgn_found => found );
4342:
4343: IF (x_return_status <> 'S') THEN
4344: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
4345: RAISE FND_API.G_EXC_ERROR;
4346: END IF;
4347: l_position := '020' ;
4348:

Line 4460: -- GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4456: -- , from_name => NULL
4457: -- , to_name => NULL);
4458:
4459: -- IF l_trans_rec.trans_qty2 < 0) THEN
4460: -- GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4461: -- 'FROM_UOM',p_sample.sample_qty_uom,
4462: -- 'TO_UOM', l_item_rec.primary_uom_code ,
4463: -- 'ITEM_NO', item_rec.item_number);
4464: --

Line 4577: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4573: x_return_status := FND_API.G_RET_STS_ERROR ;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4576: WHEN OTHERS THEN
4577: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4578: 'PACKAGE','CREATE_INV_TXN',
4579: 'ERROR', SUBSTR(SQLERRM,1,100),
4580: 'POSITION',l_position);
4581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4705: GMD_API_PUB.Log_Message('GMD_INVALID_PARAMETERS');

4701: x_return_status := FND_API.G_RET_STS_SUCCESS;
4702:
4703: -- test for batch id, step id and material detail
4704: IF p_sample.batch_id IS NULL THEN
4705: GMD_API_PUB.Log_Message('GMD_INVALID_PARAMETERS');
4706: RAISE FND_API.G_EXC_ERROR;
4707: END IF;
4708: --srakrish bug 5394566: Commenting the cursors as these have hardcoded values and material_detail_id is directly passed.
4709:

Line 4736: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');

4732: material_detail_item_um := p_sample.sample_qty_uom;*/
4733:
4734: -- Verify that we have the trx_source_line_id (material_detail_id)
4735: IF p_mmti_rec.trx_source_line_id IS NULL THEN
4736: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');
4737: RAISE FND_API.G_EXC_ERROR;
4738: END IF;
4739:
4740: OPEN c_item_no (p_sample.inventory_item_id);

Line 4774: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4770: gmd_debug.put_line('After uom conversion qty2 ='|| p_mmti_rec.transaction_quantity);
4771: END IF;
4772:
4773: IF (p_mmti_rec.transaction_quantity< 0 ) THEN
4774: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4775: 'FROM_UOM',p_sample.sample_qty_uom,
4776: 'TO_UOM',material_detail_item_um,
4777: 'ITEM_NO',l_item_no);
4778: RAISE FND_API.G_EXC_ERROR;

Line 4787: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');

4783: OPEN Cur_global_configurator;
4784: FETCH Cur_global_configurator INTO p_mmti_rec.reason_id ;
4785: IF Cur_global_configurator%NOTFOUND THEN
4786: CLOSE Cur_global_configurator;
4787: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
4788: RAISE FND_API.G_EXC_ERROR;
4789: END IF;
4790: CLOSE Cur_global_configurator;
4791:

Line 4841: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4837: from_name => NULL ,
4838: to_name => NULL) ;
4839:
4840: IF (p_mmti_rec.secondary_transaction_quantity< 0 ) THEN
4841: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4842: 'FROM_UOM',p_sample.sample_qty_uom,
4843: 'TO_UOM',l_item_um2,
4844: 'ITEM_NO',l_item_no);
4845: RAISE FND_API.G_EXC_ERROR;

Line 4921: GMD_API_PUB.Log_Message('GMD_QM_NO_INVENTORY_TRANS');

4917: RAISE FND_API.G_EXC_ERROR;
4918: END IF;
4919: ELSE
4920: -- Bug 3492053: if replenish whse is not there inventory is not generated
4921: GMD_API_PUB.Log_Message('GMD_QM_NO_INVENTORY_TRANS');
4922: RAISE FND_API.G_EXC_ERROR;
4923: END IF; -- check for replenish whse code
4924:
4925: EXCEPTION

Line 4931: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4927: x_return_status := FND_API.G_RET_STS_ERROR ;
4928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4930: WHEN OTHERS THEN
4931: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4932: 'PACKAGE','INVENTORY_TRANS_INSERT',
4933: 'ERROR', SUBSTR(SQLERRM,1,100));
4934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4935:

Line 4991: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4987: x_return_status := FND_API.G_RET_STS_ERROR ;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4990: WHEN OTHERS THEN
4991: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4992: 'PACKAGE','POST_WIP_TXN',
4993: 'ERROR', SUBSTR(SQLERRM,1,100));
4994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4995:

Line 5209: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

5205: OPEN C_item_no(l_samples.inventory_item_id,l_samples.organization_id ); --RLNAGARA B5106191 passing organization_id also
5206: FETCH C_item_no INTO l_samples_item_no;
5207: CLOSE C_item_no;
5208:
5209: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
5210: 'FROM_UOM',l_results.test_qty_uom,
5211: 'TO_UOM', l_samples.sample_qty_uom,
5212: 'ITEM_NO',l_samples_item_no);
5213: RAISE FND_API.G_EXC_ERROR;

Line 5231: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');

5227: SET remaining_qty = remaining_qty - converted_qty
5228: WHERE sample_id = l_samples.sample_id;
5229:
5230: ELSE
5231: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');
5232: RAISE FND_API.G_EXC_ERROR;
5233: END IF; -- Bug 3088216
5234:
5235: ELSE -- samples uom = test uom

Line 5251: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');

5247: SET remaining_qty = remaining_qty - qty
5248: WHERE sample_id = l_samples.sample_id;
5249:
5250: ELSE
5251: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');
5252: RAISE FND_API.G_EXC_ERROR;
5253: END IF; -- Bug 3088216
5254:
5255:

Line 5270: GMD_API_PUB.Log_Message('GMD_QM_SAMPLES_LOCKED'); -- Bug# 5463117

5266: END IF;
5267: IF C_lock_sample%ISOPEN THEN
5268: CLOSE C_lock_sample;
5269: END IF;
5270: GMD_API_PUB.Log_Message('GMD_QM_SAMPLES_LOCKED'); -- Bug# 5463117
5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: WHEN OTHERS THEN
5273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5274:

Line 5600: GMD_API_PUB.Log_Message('GMD_API_ERROR',

5596: x_return_status := FND_API.G_RET_STS_ERROR ;
5597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5599: WHEN OTHERS THEN
5600: GMD_API_PUB.Log_Message('GMD_API_ERROR',
5601: 'PACKAGE','SAMPLE_SOURCE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100));
5602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5603: END Sample_source_display ;
5604: