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 431: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');

427: OPEN c_inv_sampling_event;
428: FETCH c_inv_sampling_event INTO x_sampling_event_id;
429: IF c_inv_sampling_event%NOTFOUND THEN
430: CLOSE c_inv_sampling_event;
431: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434: CLOSE c_inv_sampling_event;
435: ELSIF p_sample.source = 'W' THEN

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

437: OPEN c_wip_sampling_event;
438: FETCH c_wip_sampling_event INTO x_sampling_event_id;
439: IF c_wip_sampling_event%NOTFOUND THEN
440: CLOSE c_wip_sampling_event;
441: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444: CLOSE c_wip_sampling_event;
445: ELSIF p_sample.source = 'C' THEN

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

447: OPEN c_cust_sampling_event;
448: FETCH c_cust_sampling_event INTO x_sampling_event_id;
449: IF c_cust_sampling_event%NOTFOUND THEN
450: CLOSE c_cust_sampling_event;
451: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454: CLOSE c_cust_sampling_event;
455: ELSIF p_sample.source = 'S' THEN

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

457: OPEN c_supp_sampling_event;
458: FETCH c_supp_sampling_event INTO x_sampling_event_id;
459: IF c_supp_sampling_event%NOTFOUND THEN
460: CLOSE c_supp_sampling_event;
461: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464: CLOSE c_supp_sampling_event;
465: ELSIF p_sample.source = 'L' THEN

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

480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482: CLOSE c_res_sampling_event;
483: ELSE
484: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487:
488: -- If we reached here then we have found a Sampling event record

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

799: OPEN c_inv_sampling_event;
800: FETCH c_inv_sampling_event INTO x_sampling_event_id;
801: IF c_inv_sampling_event%NOTFOUND THEN
802: CLOSE c_inv_sampling_event;
803: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: CLOSE c_inv_sampling_event;
807: ELSIF p_sample.source = 'W' THEN

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

809: OPEN c_wip_sampling_event;
810: FETCH c_wip_sampling_event INTO x_sampling_event_id;
811: IF c_wip_sampling_event%NOTFOUND THEN
812: CLOSE c_wip_sampling_event;
813: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816: CLOSE c_wip_sampling_event;
817: ELSIF p_sample.source = 'C' THEN

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

819: OPEN c_cust_sampling_event;
820: FETCH c_cust_sampling_event INTO x_sampling_event_id;
821: IF c_cust_sampling_event%NOTFOUND THEN
822: CLOSE c_cust_sampling_event;
823: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826: CLOSE c_cust_sampling_event;
827: ELSIF p_sample.source = 'S' THEN

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

829: OPEN c_supp_sampling_event;
830: FETCH c_supp_sampling_event INTO x_sampling_event_id;
831: IF c_supp_sampling_event%NOTFOUND THEN
832: CLOSE c_supp_sampling_event;
833: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: CLOSE c_supp_sampling_event;
837: ELSIF p_sample.source = 'L' THEN

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

852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: CLOSE c_res_sampling_event;
855: ELSE
856: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
857: RAISE FND_API.G_EXC_ERROR;
858: END IF;
859:
860: -- If we reached here then we have found a Sampling event record

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

1091: OPEN c_inv_sampling_event;
1092: FETCH c_inv_sampling_event INTO x_sampling_event_id;
1093: IF c_inv_sampling_event%NOTFOUND THEN
1094: CLOSE c_inv_sampling_event;
1095: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098: CLOSE c_inv_sampling_event;
1099: ELSIF p_sample.source = 'W' THEN

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

1101: OPEN c_wip_sampling_event;
1102: FETCH c_wip_sampling_event INTO x_sampling_event_id;
1103: IF c_wip_sampling_event%NOTFOUND THEN
1104: CLOSE c_wip_sampling_event;
1105: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: CLOSE c_wip_sampling_event;
1109: ELSIF p_sample.source = 'C' THEN

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

1111: OPEN c_cust_sampling_event;
1112: FETCH c_cust_sampling_event INTO x_sampling_event_id;
1113: IF c_cust_sampling_event%NOTFOUND THEN
1114: CLOSE c_cust_sampling_event;
1115: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118: CLOSE c_cust_sampling_event;
1119: ELSIF p_sample.source = 'S' THEN

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

1121: OPEN c_supp_sampling_event;
1122: FETCH c_supp_sampling_event INTO x_sampling_event_id;
1123: IF c_supp_sampling_event%NOTFOUND THEN
1124: CLOSE c_supp_sampling_event;
1125: --GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: CLOSE c_supp_sampling_event;
1129:

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

1146: END IF;
1147: CLOSE c_res_sampling_event;
1148:
1149: ELSE
1150: --GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153:
1154: -- If we reached here then we have found a Sampling event record

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

1328: , x_return_status => x_return_status
1329: , x_orgn_found => found );
1330:
1331: IF NOT(found) OR (x_return_status <> 'S') THEN
1332: GMD_API_PUB.Log_Message('GMD_QM_ORG_PARAMETER');
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;
1335:
1336: -- Skip if automatic assignmnet type, so sample number can be retrived after

Line 1343: GMD_API_PUB.Log_Message('GMD_SAMPLE_EXIST',

1339:
1340: -- If inserting a Sample, Sample_No must be unique
1341: IF sample_exist(p_sample.organization_id, p_sample.sample_no) THEN
1342: -- Huston, we have a problem...
1343: GMD_API_PUB.Log_Message('GMD_SAMPLE_EXIST',
1344: 'ORGN_CODE', p_sample.organization_id,
1345: 'SAMPLE_NO', p_sample.sample_no);
1346: RAISE FND_API.G_EXC_ERROR;
1347: END IF;

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

1945: WHERE sampling_event_id = l_sampling_event_id ;
1946:
1947:
1948: EXCEPTION WHEN REQ_FIELDS_MISSING THEN
1949: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1950: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952: WHEN INVALID_PARAMETER THEN
1953: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

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

1949: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1950: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952: WHEN INVALID_PARAMETER THEN
1953: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1954: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1955: x_return_status := FND_API.G_RET_STS_ERROR ;
1956: WHEN SAMPLE_SPEC_CHANGED THEN
1957: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

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

1953: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1954: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1955: x_return_status := FND_API.G_RET_STS_ERROR ;
1956: WHEN SAMPLE_SPEC_CHANGED THEN
1957: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1958: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1959: x_return_status := FND_API.G_RET_STS_ERROR ;
1960: WHEN SAMPLE_DISP_CHANGED THEN
1961: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');

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

1957: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1958: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1959: x_return_status := FND_API.G_RET_STS_ERROR ;
1960: WHEN SAMPLE_DISP_CHANGED THEN
1961: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1962: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1963: x_return_status := FND_API.G_RET_STS_ERROR ;
1964: WHEN OTHERS THEN
1965: 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 1965: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1961: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1962: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1963: x_return_status := FND_API.G_RET_STS_ERROR ;
1964: WHEN OTHERS THEN
1965: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1966: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1968:
1969: END update_sample_comp_disp ;

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

2071: );
2072:
2073:
2074: IF SQL%NOTFOUND THEN
2075: gmd_api_pub.log_message('GMD_QM_CHANGE_DISP_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2076: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2077: x_return_status := FND_API.G_RET_STS_ERROR ;
2078: END IF; -- SQL%NOTFOUND THEN
2079:

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

2144:
2145: END IF; -- (p_update_change_disp_rec.LOT_NUMBER IS NOT NULL)
2146:
2147: IF SQL%NOTFOUND THEN
2148: gmd_api_pub.log_message('GMD_QM_CHANGE_LOT_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2149: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2150: x_return_status := FND_API.G_RET_STS_ERROR ;
2151: END IF; -- SQL%NOTFOUND THEN
2152:

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

2785: , p_primary_onhand => NULL --(DEFAULT NULL)
2786: , p_secondary_onhand => NULL ); --(DEFAULT NULL)
2787:
2788: IF x_return_status <> 'S' THEN
2789: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
2790: RAISE FND_API.G_EXC_ERROR;
2791: END IF; -- x_return_status <> 'S'
2792:
2793: END IF; -- (p_from_lot_status_id <> get_curr_lot_status_rec.status_id THEN

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

2899:
2900: EXCEPTION
2901: WHEN SAMPLE_DISP_CHANGED THEN
2902: --RLNAGARA B5668965 Changed the message from GMD_SMPL_DISP_CHANGE to GMD_QM_CURRENT_LOT_VALUE_CHANG
2903: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: WHEN REQ_FIELDS_MISSING THEN
2907: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');

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

2903: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: WHEN REQ_FIELDS_MISSING THEN
2907: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
2908: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2909: x_return_status := FND_API.G_RET_STS_ERROR ;
2910: WHEN INVALID_SAMPLE THEN
2911: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');

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

2907: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
2908: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2909: x_return_status := FND_API.G_RET_STS_ERROR ;
2910: WHEN INVALID_SAMPLE THEN
2911: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
2912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2913: x_return_status := FND_API.G_RET_STS_ERROR ;
2914: WHEN INVALID_QC_STATUS THEN
2915: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');

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

2911: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
2912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2913: x_return_status := FND_API.G_RET_STS_ERROR ;
2914: WHEN INVALID_QC_STATUS THEN
2915: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');
2916: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2917: x_return_status := FND_API.G_RET_STS_ERROR ;
2918:
2919: WHEN RECORD_LOCK THEN

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

2916: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2917: x_return_status := FND_API.G_RET_STS_ERROR ;
2918:
2919: WHEN RECORD_LOCK THEN
2920: GMD_API_PUB.Log_Message('GMD_IC_LOTS_CPG_LOCKED');
2921: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2922: x_return_status := FND_API.G_RET_STS_ERROR ;
2923:
2924: WHEN OTHERS THEN

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

2927: END IF;
2928: IF get_curr_lot_status_cv%ISOPEN THEN
2929: CLOSE get_curr_lot_status_cv;
2930: END IF;
2931: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
2932: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2934: END update_lot_grade_batch ;
2935:

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

3207: x_return_status := FND_API.G_RET_STS_SUCCESS;
3208:
3209: -- Orgn Code
3210: IF (p_sample.organization_id IS NULL) THEN
3211: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_REQD');
3212: RAISE FND_API.G_EXC_ERROR;
3213: ELSE
3214: -- Check that orgn Code exist in SY_ORGN_MST
3215: OPEN c_orgn(p_sample.organization_id);

Line 3219: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_NOT_FOUND',

3215: OPEN c_orgn(p_sample.organization_id);
3216: FETCH c_orgn INTO dummy;
3217: IF c_orgn%NOTFOUND THEN
3218: CLOSE c_orgn;
3219: GMD_API_PUB.Log_Message('GMD_ORGN_CODE_NOT_FOUND',
3220: 'ORGN', p_sample.lab_organization_id);
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223: CLOSE c_orgn;

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

3225:
3226: -- Sampler Id Validation
3227:
3228: IF (p_sample.sampler_id IS NULL ) THEN
3229: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_REQD');
3230: RAISE FND_API.G_EXC_ERROR;
3231: ELSE
3232: -- Check that orgn Code exist in SY_ORGN_MST
3233: OPEN c_sampler(p_sample.organization_id, p_sample.sampler_id);

Line 3236: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',

3232: -- Check that orgn Code exist in SY_ORGN_MST
3233: OPEN c_sampler(p_sample.organization_id, p_sample.sampler_id);
3234: FETCH c_sampler INTO dummy;
3235: IF c_sampler%NOTFOUND THEN
3236: GMD_API_PUB.Log_Message('GMD_SAMPLER_ID_NOTFOUND',
3237: 'SAMPLER', p_sample.sampler_id);
3238: RAISE FND_API.G_EXC_ERROR;
3239: CLOSE c_sampler;
3240: END IF;

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

3243:
3244:
3245: -- Sample No
3246: IF (ltrim(rtrim(p_sample.sample_no)) IS NULL) THEN
3247: GMD_API_PUB.Log_Message('GMD_SAMPLE_NUMBER_REQD');
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250:
3251: -- Sample Source

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

3252: IF (p_sample.source IS NULL OR
3253: (NOT (p_sample.source in ('I', 'W', 'C', 'S','L','R','T')))
3254: ) THEN
3255: -- Now, what is the source of this sample? Where did it come from?
3256: GMD_API_PUB.Log_Message('GMD_SAMPLE_SOURCE_INVALID');
3257: RAISE FND_API.G_EXC_ERROR;
3258: END IF;
3259:
3260: -- QC Lab Orgn Code

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

3258: END IF;
3259:
3260: -- QC Lab Orgn Code
3261: IF (p_sample.lab_organization_id IS NULL) THEN
3262: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_REQD');
3263: RAISE FND_API.G_EXC_ERROR;
3264: ELSE
3265: -- Check that QC Lab Orgn Code exist in SY_ORGN_MST
3266: OPEN c_lab_orgn(p_sample.lab_organization_id);

Line 3270: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_NOT_FOUND',

3266: OPEN c_lab_orgn(p_sample.lab_organization_id);
3267: FETCH c_lab_orgn INTO dummy;
3268: IF c_lab_orgn%NOTFOUND THEN
3269: CLOSE c_lab_orgn;
3270: GMD_API_PUB.Log_Message('GMD_QC_LAB_ORGN_CODE_NOT_FOUND',
3271: 'ORGN', p_sample.lab_organization_id);
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274: CLOSE c_lab_orgn;

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

3280: IF (p_sample.sample_disposition IS NULL OR
3281: (NOT (p_sample.sample_disposition in ('0RT', '1P')))
3282: ) THEN
3283: -- Now, what is the disposition of this sample?
3284: GMD_API_PUB.Log_Message('GMD_SAMPLE_DISPOSITION_INVALID');
3285: RAISE FND_API.G_EXC_ERROR;
3286: END IF;
3287:
3288: -- Item ID

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

3287:
3288: -- Item ID
3289: IF (p_sample.inventory_item_id IS NULL) and
3290: (p_sample.sample_type = 'M' ) THEN
3291: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_REQD');
3292: RAISE FND_API.G_EXC_ERROR;
3293: ELSE
3294: -- Get the Item No
3295: OPEN c_item(p_sample.inventory_item_id, p_sample.organization_id);

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

3295: OPEN c_item(p_sample.inventory_item_id, p_sample.organization_id);
3296: FETCH c_item INTO dummy;
3297: IF c_item%NOTFOUND THEN
3298: CLOSE c_item;
3299: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');
3300: RAISE FND_API.G_EXC_ERROR;
3301: END IF;
3302: CLOSE c_item;
3303: END IF;

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

3312: OPEN c_sampling_event(p_sample.sampling_event_id);
3313: FETCH c_sampling_event INTO dummy;
3314: IF c_sampling_event%NOTFOUND THEN
3315: CLOSE c_sampling_event;
3316: GMD_API_PUB.Log_Message('GMD_SAMPLING_EVENT_NOT_FOUND');
3317: RAISE FND_API.G_EXC_ERROR;
3318: END IF;
3319: CLOSE c_sampling_event;
3320: END IF;

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

3321: ** COMMENT END **/
3322:
3323: -- Sample Qty
3324: IF (p_sample.sample_qty IS NULL) THEN
3325: GMD_API_PUB.Log_Message('GMD_SAMPLE_QTY_REQD');
3326: RAISE FND_API.G_EXC_ERROR;
3327: END IF;
3328:
3329: -- Sample UOM

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

3327: END IF;
3328:
3329: -- Sample UOM
3330: IF (p_sample.sample_qty_uom IS NULL) THEN
3331: GMD_API_PUB.Log_Message('GMD_SAMPLE_UOM_REQD');
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: -- Lot No

Line 3342: GMD_API_PUB.Log_Message('GMD_ITEM_LOT_NOT_FOUND',

3338: FETCH c_item_lot INTO dummy;
3339: IF c_item_lot%NOTFOUND THEN
3340: --Uday Phadtare Bug2982490 changed CLOSE c_whse to CLOSE c_item_lot
3341: CLOSE c_item_lot;
3342: GMD_API_PUB.Log_Message('GMD_ITEM_LOT_NOT_FOUND',
3343: 'LOT_NO', p_sample.lot_number);
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346: CLOSE c_item_lot;

Line 3361: GMD_API_PUB.Log_Message('GMD_SPEC_WHSE_NOT_FOUND',

3357: OPEN c_subinventory;
3358: FETCH c_subinventory INTO dummy;
3359: IF c_subinventory%NOTFOUND THEN
3360: CLOSE c_subinventory;
3361: GMD_API_PUB.Log_Message('GMD_SPEC_WHSE_NOT_FOUND',
3362: 'WHSE', p_sample.subinventory);
3363: RAISE FND_API.G_EXC_ERROR;
3364: END IF;
3365: CLOSE c_subinventory;

Line 3375: GMD_API_PUB.Log_Message('GMD_LOCT_NOT_FOUND',

3371: OPEN c_locator;
3372: FETCH c_locator INTO dummy;
3373: IF c_locator%NOTFOUND THEN
3374: CLOSE c_locator;
3375: GMD_API_PUB.Log_Message('GMD_LOCT_NOT_FOUND',
3376: 'LOCATION', p_sample.locator_id);
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379: CLOSE c_locator;

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

3386: -- those parameters related to WIP
3387:
3388: -- For WIP sample, at least Batch No or Recipe ID is required
3389: IF (p_sample.batch_id IS NULL AND p_sample.recipe_id IS NULL) THEN
3390: GMD_API_PUB.Log_Message('GMD_NO_WIP_PARAM');
3391: RAISE FND_API.G_EXC_ERROR;
3392: END IF;
3393:
3394: -- Batch ID is valid

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

3397: OPEN c_batch;
3398: FETCH c_batch INTO dummy;
3399: IF c_batch%NOTFOUND THEN
3400: CLOSE c_batch;
3401: GMD_API_PUB.Log_Message('GMD_BATCH_NOT_FOUND');
3402: RAISE FND_API.G_EXC_ERROR;
3403: END IF;
3404: CLOSE c_batch;
3405: END IF;

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

3409: OPEN c_recipe_id;
3410: FETCH c_recipe_id INTO dummy;
3411: IF c_recipe_id%NOTFOUND THEN
3412: CLOSE c_recipe_id;
3413: GMD_API_PUB.Log_Message('GMD_RECIPE_NOT_FOUND');
3414: RAISE FND_API.G_EXC_ERROR;
3415: END IF;
3416: CLOSE c_recipe_id;
3417: END IF;

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

3424: OPEN c_formulaline_id;
3425: FETCH c_formulaline_id INTO dummy;
3426: IF c_formulaline_id%NOTFOUND THEN
3427: CLOSE c_formulaline_id;
3428: GMD_API_PUB.Log_Message('GMD_FORMULA_LINE_NOT_FOUND');
3429: RAISE FND_API.G_EXC_ERROR;
3430: END IF;
3431: CLOSE c_formulaline_id;
3432: END IF;

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

3438: OPEN c_material_detail_id;
3439: FETCH c_material_detail_id INTO dummy;
3440: IF c_material_detail_id%NOTFOUND THEN
3441: CLOSE c_material_detail_id;
3442: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');
3443: RAISE FND_API.G_EXC_ERROR;
3444: END IF;
3445: CLOSE c_material_detail_id;
3446: END IF;

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

3451: OPEN c_batchstep;
3452: FETCH c_batchstep INTO dummy;
3453: IF c_batchstep%NOTFOUND THEN
3454: CLOSE c_batchstep;
3455: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');
3456: RAISE FND_API.G_EXC_ERROR;
3457: END IF;
3458: CLOSE c_batchstep;
3459: ELSIF (p_sample.routing_id IS NOT NULL AND p_sample.step_no IS NOT NULL) THEN

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

3461: OPEN c_routingstep;
3462: FETCH c_routingstep INTO dummy;
3463: IF c_routingstep%NOTFOUND THEN
3464: CLOSE c_routingstep;
3465: GMD_API_PUB.Log_Message('GMD_ROUTING_STEP_NOT_FOUND');
3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;
3468: CLOSE c_routingstep;
3469: END IF;

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

3474: OPEN c_oprn;
3475: FETCH c_oprn INTO dummy;
3476: IF c_oprn%NOTFOUND THEN
3477: CLOSE c_oprn;
3478: GMD_API_PUB.Log_Message('GMD_BATCH_STEP_NOT_FOUND');
3479: RAISE FND_API.G_EXC_ERROR;
3480: END IF;
3481: CLOSE c_oprn;
3482: END IF;

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

3488: -- those parameters related to Customer
3489:
3490: -- Customer
3491: IF (p_sample.cust_id IS NULL) THEN
3492: GMD_API_PUB.Log_Message('GMD_CUSTOMER_REQD');
3493: RAISE FND_API.G_EXC_ERROR;
3494: ELSE
3495: OPEN c_cust;
3496: FETCH c_cust INTO dummy;

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

3495: OPEN c_cust;
3496: FETCH c_cust INTO dummy;
3497: IF c_cust%NOTFOUND THEN
3498: CLOSE c_cust;
3499: GMD_API_PUB.Log_Message('GMD_CUSTOMER_NOT_FOUND');
3500: RAISE FND_API.G_EXC_ERROR;
3501: END IF;
3502: CLOSE c_cust;
3503: END IF;

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

3507: -- OPEN c_org;
3508: -- FETCH c_org INTO dummy;
3509: -- IF c_cust%NOTFOUND THEN
3510: -- CLOSE c_org;
3511: -- GMD_API_PUB.Log_Message('GMD_ORG_NOT_FOUND');
3512: -- RAISE FND_API.G_EXC_ERROR;
3513: -- END IF;
3514: -- CLOSE c_org;
3515: --END IF;

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

3519: OPEN c_ship_to;
3520: FETCH c_ship_to INTO dummy;
3521: IF c_ship_to%NOTFOUND THEN
3522: CLOSE c_ship_to;
3523: GMD_API_PUB.Log_Message('GMD_SHIP_TO_NOT_FOUND');
3524: RAISE FND_API.G_EXC_ERROR;
3525: END IF;
3526: CLOSE c_ship_to;
3527: END IF;

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

3531: OPEN c_order;
3532: FETCH c_order INTO dummy;
3533: IF c_order%NOTFOUND THEN
3534: CLOSE c_order;
3535: GMD_API_PUB.Log_Message('GMD_ORDER_NOT_FOUND');
3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;
3538: CLOSE c_order;
3539: END IF;

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

3543: OPEN c_order_line;
3544: FETCH c_order_line INTO dummy;
3545: IF c_order_line%NOTFOUND THEN
3546: CLOSE c_order_line;
3547: GMD_API_PUB.Log_Message('GMD_ORDER_LINE_NOT_FOUND');
3548: RAISE FND_API.G_EXC_ERROR;
3549: END IF;
3550: CLOSE c_order_line;
3551: END IF;

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

3557: -- those parameters related to Supplier
3558:
3559: -- Supplier
3560: IF (p_sample.supplier_id IS NULL) THEN
3561: GMD_API_PUB.Log_Message('GMD_SUPPLIER_REQD');
3562: RAISE FND_API.G_EXC_ERROR;
3563: ELSIF (p_sample.supplier_id IS NOT NULL) THEN
3564: OPEN c_supplier;
3565: FETCH c_supplier INTO dummy;

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

3564: OPEN c_supplier;
3565: FETCH c_supplier INTO dummy;
3566: IF c_supplier%NOTFOUND THEN
3567: CLOSE c_supplier;
3568: GMD_API_PUB.Log_Message('GMD_SUPPLIER_NOT_FOUND');
3569: RAISE FND_API.G_EXC_ERROR;
3570: END IF;
3571: CLOSE c_supplier;
3572: END IF;

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

3576: OPEN c_po;
3577: FETCH c_po INTO dummy;
3578: IF c_po%NOTFOUND THEN
3579: CLOSE c_po;
3580: GMD_API_PUB.Log_Message('GMD_PO_NOT_FOUND');
3581: RAISE FND_API.G_EXC_ERROR;
3582: END IF;
3583: CLOSE c_po;
3584: END IF;

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

3588: OPEN c_po_line;
3589: FETCH c_po_line INTO dummy;
3590: IF c_po_line%NOTFOUND THEN
3591: CLOSE c_po_line;
3592: GMD_API_PUB.Log_Message('GMD_PO_LINE_NOT_FOUND');
3593: RAISE FND_API.G_EXC_ERROR;
3594: END IF;
3595: CLOSE c_po_line;
3596: END IF;

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

3703: , x_return_status => x_return_status
3704: , x_orgn_found => found );
3705:
3706: IF (x_return_status <> 'S') THEN
3707: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
3708: RAISE FND_API.G_EXC_ERROR;
3709: END IF;
3710: l_position := '020' ;
3711:

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

3818: -- , from_name => NULL
3819: -- , to_name => NULL);
3820:
3821: -- IF l_trans_rec.trans_qty2 < 0) THEN
3822: -- GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
3823: -- 'FROM_UOM',p_sample.sample_qty_uom,
3824: -- 'TO_UOM', l_item_rec.primary_uom_code ,
3825: -- 'ITEM_NO', item_rec.item_number);
3826: --

Line 3932: GMD_API_PUB.Log_Message('GMD_API_ERROR',

3928: x_return_status := FND_API.G_RET_STS_ERROR ;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3931: WHEN OTHERS THEN
3932: GMD_API_PUB.Log_Message('GMD_API_ERROR',
3933: 'PACKAGE','CREATE_INV_TXN',
3934: 'ERROR', SUBSTR(SQLERRM,1,100),
3935: 'POSITION',l_position);
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4056: x_return_status := FND_API.G_RET_STS_SUCCESS;
4057:
4058: -- test for batch id, step id and material detail
4059: IF p_sample.batch_id IS NULL THEN
4060: GMD_API_PUB.Log_Message('GMD_INVALID_PARAMETERS');
4061: RAISE FND_API.G_EXC_ERROR;
4062: END IF;
4063: --srakrish bug 5394566: Commenting the cursors as these have hardcoded values and material_detail_id is directly passed.
4064:

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

4087: material_detail_item_um := p_sample.sample_qty_uom;*/
4088:
4089: -- Verify that we have the trx_source_line_id (material_detail_id)
4090: IF p_mmti_rec.trx_source_line_id IS NULL THEN
4091: GMD_API_PUB.Log_Message('GMD_MATERIAL_DTL_NOT_FOUND');
4092: RAISE FND_API.G_EXC_ERROR;
4093: END IF;
4094:
4095: OPEN c_item_no (p_sample.inventory_item_id);

Line 4129: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4125: gmd_debug.put_line('After uom conversion qty2 ='|| p_mmti_rec.transaction_quantity);
4126: END IF;
4127:
4128: IF (p_mmti_rec.transaction_quantity< 0 ) THEN
4129: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4130: 'FROM_UOM',p_sample.sample_qty_uom,
4131: 'TO_UOM',material_detail_item_um,
4132: 'ITEM_NO',l_item_no);
4133: RAISE FND_API.G_EXC_ERROR;

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

4138: OPEN Cur_global_configurator;
4139: FETCH Cur_global_configurator INTO p_mmti_rec.reason_id ;
4140: IF Cur_global_configurator%NOTFOUND THEN
4141: CLOSE Cur_global_configurator;
4142: GMD_API_PUB.Log_Message('GMD_QM_INV_REASON_CODE');
4143: RAISE FND_API.G_EXC_ERROR;
4144: END IF;
4145: CLOSE Cur_global_configurator;
4146:

Line 4196: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4192: from_name => NULL ,
4193: to_name => NULL) ;
4194:
4195: IF (p_mmti_rec.secondary_transaction_quantity< 0 ) THEN
4196: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4197: 'FROM_UOM',p_sample.sample_qty_uom,
4198: 'TO_UOM',l_item_um2,
4199: 'ITEM_NO',l_item_no);
4200: RAISE FND_API.G_EXC_ERROR;

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

4272: RAISE FND_API.G_EXC_ERROR;
4273: END IF;
4274: ELSE
4275: -- Bug 3492053: if replenish whse is not there inventory is not generated
4276: GMD_API_PUB.Log_Message('GMD_QM_NO_INVENTORY_TRANS');
4277: RAISE FND_API.G_EXC_ERROR;
4278: END IF; -- check for replenish whse code
4279:
4280: EXCEPTION

Line 4286: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4282: x_return_status := FND_API.G_RET_STS_ERROR ;
4283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4285: WHEN OTHERS THEN
4286: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4287: 'PACKAGE','INVENTORY_TRANS_INSERT',
4288: 'ERROR', SUBSTR(SQLERRM,1,100));
4289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4290:

Line 4346: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4342: x_return_status := FND_API.G_RET_STS_ERROR ;
4343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4345: WHEN OTHERS THEN
4346: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4347: 'PACKAGE','POST_WIP_TXN',
4348: 'ERROR', SUBSTR(SQLERRM,1,100));
4349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4350:

Line 4564: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',

4560: OPEN C_item_no(l_samples.inventory_item_id,l_samples.organization_id ); --RLNAGARA B5106191 passing organization_id also
4561: FETCH C_item_no INTO l_samples_item_no;
4562: CLOSE C_item_no;
4563:
4564: GMD_API_PUB.Log_Message('FM_SCALE_BAD_UOM_CONV',
4565: 'FROM_UOM',l_results.test_qty_uom,
4566: 'TO_UOM', l_samples.sample_qty_uom,
4567: 'ITEM_NO',l_samples_item_no);
4568: RAISE FND_API.G_EXC_ERROR;

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

4582: SET remaining_qty = remaining_qty - converted_qty
4583: WHERE sample_id = l_samples.sample_id;
4584:
4585: ELSE
4586: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');
4587: RAISE FND_API.G_EXC_ERROR;
4588: END IF; -- Bug 3088216
4589:
4590: ELSE -- samples uom = test uom

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

4602: SET remaining_qty = remaining_qty - qty
4603: WHERE sample_id = l_samples.sample_id;
4604:
4605: ELSE
4606: GMD_API_PUB.Log_Message('GMD_QM_REMAIN_QTY_NEG');
4607: RAISE FND_API.G_EXC_ERROR;
4608: END IF; -- Bug 3088216
4609:
4610:

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

4621: END IF;
4622: IF C_lock_sample%ISOPEN THEN
4623: CLOSE C_lock_sample;
4624: END IF;
4625: GMD_API_PUB.Log_Message('GMD_QM_SAMPLES_LOCKED'); -- Bug# 5463117
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4627: WHEN OTHERS THEN
4628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4629:

Line 4935: GMD_API_PUB.Log_Message('GMD_API_ERROR',

4931: x_return_status := FND_API.G_RET_STS_ERROR ;
4932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4934: WHEN OTHERS THEN
4935: GMD_API_PUB.Log_Message('GMD_API_ERROR',
4936: 'PACKAGE','SAMPLE_SOURCE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100));
4937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4938: END Sample_source_display ;
4939: