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_SPEC_VRS_GRP dependencies on FND_MSG_PUB

Line 628: FND_MSG_PUB.ADD;

624: CLOSE c_mon_vr;
625: FND_MESSAGE.SET_NAME('GMD', 'GMD_MON_VR_EXIST');
626: FND_MESSAGE.SET_TOKEN('spec', specname);
627: FND_MESSAGE.SET_TOKEN('vers', specvers);
628: FND_MSG_PUB.ADD;
629: RETURN TRUE;
630: ELSE
631: CLOSE c_mon_vr;
632: RETURN FALSE;

Line 643: FND_MSG_PUB.ADD;

639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
641: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.MON_VR_EXIST' );
642: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
643: FND_MSG_PUB.ADD;
644:
645: RETURN TRUE;
646:
647: END mon_vr_exist;

Line 1043: FND_MSG_PUB.ADD;

1039: END IF;
1040: CLOSE c_item_lot_number;
1041: ELSE --Item is not lot controlled
1042: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_NOT_LOT_CONTROL');
1043: FND_MSG_PUB.ADD;
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046: END IF;
1047:

Line 1063: FND_MSG_PUB.ADD;

1059: END IF;
1060: CLOSE c_item_parent_lot;
1061: ELSE --Item is not child lot controlled
1062: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_NOT_CHILD_LOT_CONTROL');
1063: FND_MSG_PUB.ADD;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: END IF;
1067:

Line 1277: FND_MSG_PUB.ADD;

1273: CLOSE c_inv_vr;
1274: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_VR_EXIST');
1275: FND_MESSAGE.SET_TOKEN('spec', specname);
1276: FND_MESSAGE.SET_TOKEN('vers', specvers);
1277: FND_MSG_PUB.ADD;
1278: RETURN TRUE;
1279: ELSE
1280: CLOSE c_inv_vr;
1281: RETURN FALSE;

Line 1292: FND_MSG_PUB.ADD;

1288: WHEN OTHERS THEN
1289: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
1290: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.INV_VR_EXIST' );
1291: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
1292: FND_MSG_PUB.ADD;
1293:
1294: RETURN TRUE;
1295:
1296: END inv_vr_exist;

Line 2625: FND_MSG_PUB.ADD;

2621: CLOSE c_wip_vr;
2622: FND_MESSAGE.SET_NAME('GMD', 'GMD_WIP_VR_EXIST');
2623: FND_MESSAGE.SET_TOKEN('spec', specname);
2624: FND_MESSAGE.SET_TOKEN('vers', specvers);
2625: FND_MSG_PUB.ADD;
2626: RETURN TRUE;
2627: ELSE
2628: CLOSE c_wip_vr;
2629: RETURN FALSE;

Line 3273: FND_MSG_PUB.ADD;

3269: CLOSE c_cust_vr;
3270: FND_MESSAGE.SET_NAME('GMD', 'GMD_CUST_VR_EXIST');
3271: FND_MESSAGE.SET_TOKEN('spec', specname);
3272: FND_MESSAGE.SET_TOKEN('vers', specvers);
3273: FND_MSG_PUB.ADD;
3274: RETURN TRUE;
3275: ELSE
3276: CLOSE c_cust_vr;
3277: RETURN FALSE;

Line 3651: FND_MSG_PUB.ADD;

3647: CLOSE c_item_controls;
3648: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');
3649: FND_MESSAGE.SET_TOKEN('WHAT', 'INVENTORY_ITEM_ID');
3650: FND_MESSAGE.SET_TOKEN('VALUE', p_spec.inventory_item_id);
3651: FND_MSG_PUB.ADD;
3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;
3654: CLOSE c_item_controls;
3655:

Line 3751: FND_MSG_PUB.ADD;

3747: CLOSE c_supplier_site;
3748: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');
3749: FND_MESSAGE.SET_TOKEN('WHAT', 'SUPPLIER_SITE_ID');
3750: FND_MESSAGE.SET_TOKEN('VALUE', p_supp_vr.supplier_site_id);
3751: FND_MSG_PUB.ADD;
3752: RAISE FND_API.G_EXC_ERROR;
3753: END IF;
3754: CLOSE c_supplier_site;
3755: END IF;

Line 3914: FND_MSG_PUB.ADD;

3910: CLOSE c_supp_vr;
3911: FND_MESSAGE.SET_NAME('GMD', 'GMD_SUPP_VR_EXIST');
3912: FND_MESSAGE.SET_TOKEN('spec', specname);
3913: FND_MESSAGE.SET_TOKEN('vers', specvers);
3914: FND_MSG_PUB.ADD;
3915: RETURN TRUE;
3916: ELSE
3917: CLOSE c_supp_vr;
3918: RETURN FALSE;

Line 4004: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4000:
4001: EXCEPTION
4002: WHEN FND_API.G_EXC_ERROR THEN
4003: x_return_status := FND_API.G_RET_STS_ERROR ;
4004: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4005:
4006: WHEN OTHERS THEN
4007: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4008: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 4011: FND_MSG_PUB.ADD;

4007: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4008: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4009: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4010: FND_MESSAGE.Set_Token('POSITION',l_progress );
4011: FND_MSG_PUB.ADD;
4012: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014:
4015: END VALIDATE_BEFORE_DELETE_INV_VRS ;

Line 4012: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4008: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4009: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4010: FND_MESSAGE.Set_Token('POSITION',l_progress );
4011: FND_MSG_PUB.ADD;
4012: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014:
4015: END VALIDATE_BEFORE_DELETE_INV_VRS ;
4016:

Line 4088: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4084:
4085: EXCEPTION
4086: WHEN FND_API.G_EXC_ERROR THEN
4087: x_return_status := FND_API.G_RET_STS_ERROR ;
4088: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4089:
4090: WHEN OTHERS THEN
4091: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4092: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 4095: FND_MSG_PUB.ADD;

4091: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4092: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4093: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4094: FND_MESSAGE.Set_Token('POSITION',l_progress );
4095: FND_MSG_PUB.ADD;
4096: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4098:
4099: END VALIDATE_BEFORE_DELETE_WIP_VRS ;

Line 4096: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4092: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4093: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4094: FND_MESSAGE.Set_Token('POSITION',l_progress );
4095: FND_MSG_PUB.ADD;
4096: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4098:
4099: END VALIDATE_BEFORE_DELETE_WIP_VRS ;
4100:

Line 4171: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4167:
4168: EXCEPTION
4169: WHEN FND_API.G_EXC_ERROR THEN
4170: x_return_status := FND_API.G_RET_STS_ERROR ;
4171: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4172:
4173: WHEN OTHERS THEN
4174: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4175: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 4178: FND_MSG_PUB.ADD;

4174: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4175: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4176: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4177: FND_MESSAGE.Set_Token('POSITION',l_progress );
4178: FND_MSG_PUB.ADD;
4179: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181:
4182: END VALIDATE_BEFORE_DELETE_CST_VRS ;

Line 4179: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4175: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4176: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4177: FND_MESSAGE.Set_Token('POSITION',l_progress );
4178: FND_MSG_PUB.ADD;
4179: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181:
4182: END VALIDATE_BEFORE_DELETE_CST_VRS ;
4183:

Line 4254: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4250:
4251: EXCEPTION
4252: WHEN FND_API.G_EXC_ERROR THEN
4253: x_return_status := FND_API.G_RET_STS_ERROR ;
4254: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4255:
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4258: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

Line 4261: FND_MSG_PUB.ADD;

4257: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');
4258: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4259: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4260: FND_MESSAGE.Set_Token('POSITION',l_progress );
4261: FND_MSG_PUB.ADD;
4262: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4264:
4265: END VALIDATE_BEFORE_DELETE_SUP_VRS ;

Line 4262: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

4258: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');
4259: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4260: FND_MESSAGE.Set_Token('POSITION',l_progress );
4261: FND_MSG_PUB.ADD;
4262: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4264:
4265: END VALIDATE_BEFORE_DELETE_SUP_VRS ;
4266:

Line 4292: FND_MSG_PUB.ADD;

4288: IF (p_user_id IS NULL)
4289: THEN
4290: FND_MESSAGE.SET_NAME('GMD','GMD_WRONG_VALUE');
4291: FND_MESSAGE.SET_TOKEN('WHAT', 'USER_ID');
4292: FND_MSG_PUB.ADD;
4293: RAISE FND_API.G_EXC_ERROR;
4294: ELSE
4295: OPEN c_who( p_user_id);
4296: FETCH c_who

Line 4305: FND_MSG_PUB.ADD;

4301: CLOSE c_who;
4302: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');
4303: FND_MESSAGE.SET_TOKEN('WHAT', 'USER_ID');
4304: FND_MESSAGE.SET_TOKEN('VALUE', p_user_id);
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_ERROR;
4307: END IF;
4308: CLOSE c_who;
4309: END IF;

Line 4373: FND_MSG_PUB.Add;

4369: CLOSE c_coa_type;
4370: FND_MESSAGE.Set_Name('GMD','GMD_NOTFOUND');
4371: FND_MESSAGE.Set_Token('WHAT', 'COA_TYPE');
4372: FND_MESSAGE.Set_Token('VALUE', p_coa_type);
4373: FND_MSG_PUB.Add;
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: CLOSE c_coa_type;
4377: END IF;

Line 4663: FND_MSG_PUB.ADD;

4659: CLOSE c_lot_status;
4660: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');
4661: FND_MESSAGE.SET_TOKEN('WHAT', 'IN_SPEC_LOT_STATUS_ID');
4662: FND_MESSAGE.SET_TOKEN('VALUE', p_in_spec_lot_status_id);
4663: FND_MSG_PUB.ADD;
4664: RAISE FND_API.G_EXC_ERROR;
4665: END IF;
4666: CLOSE c_lot_status;
4667: END IF; -- in_spec_lot_status IS NULL

Line 4683: FND_MSG_PUB.ADD;

4679: CLOSE c_lot_status;
4680: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');
4681: FND_MESSAGE.SET_TOKEN('WHAT', 'OUT_OF_SPEC_LOT_STATUS_ID');
4682: FND_MESSAGE.SET_TOKEN('VALUE', p_out_of_spec_lot_status_id);
4683: FND_MSG_PUB.ADD;
4684: RAISE FND_API.G_EXC_ERROR;
4685: END IF;
4686: CLOSE c_lot_status;
4687: END IF; -- out_of_spec_lot_status_id IS NULL