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_MESSAGE

Line 625: FND_MESSAGE.SET_NAME('GMD', 'GMD_MON_VR_EXIST');

621: OPEN c_mon_vr;
622: FETCH c_mon_vr INTO dummy, specname, specvers;
623: IF c_mon_vr%FOUND THEN
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;

Line 626: FND_MESSAGE.SET_TOKEN('spec', specname);

622: FETCH c_mon_vr INTO dummy, specname, specvers;
623: IF c_mon_vr%FOUND THEN
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

Line 627: FND_MESSAGE.SET_TOKEN('vers', specvers);

623: IF c_mon_vr%FOUND THEN
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;

Line 640: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

636: -- Though there is no reason the program can reach
637: -- here, this is coded just for the reasons we can
638: -- not think of!
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:

Line 641: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.MON_VR_EXIST' );

637: -- here, this is coded just for the reasons we can
638: -- not think of!
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;

Line 642: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));

638: -- not think of!
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:

Line 1042: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_NOT_LOT_CONTROL');

1038: RAISE FND_API.G_EXC_ERROR;
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;

Line 1062: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_NOT_CHILD_LOT_CONTROL');

1058: RAISE FND_API.G_EXC_ERROR;
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;

Line 1274: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_VR_EXIST');

1270: OPEN c_inv_vr;
1271: FETCH c_inv_vr INTO dummy, specname, specvers;
1272: IF c_inv_vr%FOUND THEN
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;

Line 1275: FND_MESSAGE.SET_TOKEN('spec', specname);

1271: FETCH c_inv_vr INTO dummy, specname, specvers;
1272: IF c_inv_vr%FOUND THEN
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

Line 1276: FND_MESSAGE.SET_TOKEN('vers', specvers);

1272: IF c_inv_vr%FOUND THEN
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;

Line 1289: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

1285: -- Though there is no reason the program can reach
1286: -- here, this is coded just for the reasons we can
1287: -- not think of!
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:

Line 1290: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.INV_VR_EXIST' );

1286: -- here, this is coded just for the reasons we can
1287: -- not think of!
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;

Line 1291: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));

1287: -- not think of!
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:

Line 2622: FND_MESSAGE.SET_NAME('GMD', 'GMD_WIP_VR_EXIST');

2618: OPEN c_wip_vr;
2619: FETCH c_wip_vr INTO dummy, specname, specvers;
2620: IF c_wip_vr%FOUND THEN
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;

Line 2623: FND_MESSAGE.SET_TOKEN('spec', specname);

2619: FETCH c_wip_vr INTO dummy, specname, specvers;
2620: IF c_wip_vr%FOUND THEN
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

Line 2624: FND_MESSAGE.SET_TOKEN('vers', specvers);

2620: IF c_wip_vr%FOUND THEN
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;

Line 2637: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

2633: -- Though there is no reason the program can reach
2634: -- here, this is coded just for the reasons we can
2635: -- not think of!
2636: WHEN OTHERS THEN
2637: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2638: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.WIP_VR_EXIST' );
2639: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
2640: RETURN TRUE;
2641:

Line 2638: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.WIP_VR_EXIST' );

2634: -- here, this is coded just for the reasons we can
2635: -- not think of!
2636: WHEN OTHERS THEN
2637: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2638: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.WIP_VR_EXIST' );
2639: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
2640: RETURN TRUE;
2641:
2642: END wip_vr_exist;

Line 2639: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));

2635: -- not think of!
2636: WHEN OTHERS THEN
2637: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
2638: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.WIP_VR_EXIST' );
2639: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
2640: RETURN TRUE;
2641:
2642: END wip_vr_exist;
2643:

Line 3270: FND_MESSAGE.SET_NAME('GMD', 'GMD_CUST_VR_EXIST');

3266: OPEN c_cust_vr;
3267: FETCH c_cust_vr INTO dummy, specname, specvers;
3268: IF c_cust_vr%FOUND THEN
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;

Line 3271: FND_MESSAGE.SET_TOKEN('spec', specname);

3267: FETCH c_cust_vr INTO dummy, specname, specvers;
3268: IF c_cust_vr%FOUND THEN
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

Line 3272: FND_MESSAGE.SET_TOKEN('vers', specvers);

3268: IF c_cust_vr%FOUND THEN
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;

Line 3285: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

3281: -- Though there is no reason the program can reach
3282: -- here, this is coded just for the reasons we can
3283: -- not think of!
3284: WHEN OTHERS THEN
3285: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3286: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.CUST_VR_EXIST' );
3287: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3288: RETURN TRUE;
3289:

Line 3286: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.CUST_VR_EXIST' );

3282: -- here, this is coded just for the reasons we can
3283: -- not think of!
3284: WHEN OTHERS THEN
3285: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3286: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.CUST_VR_EXIST' );
3287: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3288: RETURN TRUE;
3289:
3290: END cust_vr_exist;

Line 3287: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));

3283: -- not think of!
3284: WHEN OTHERS THEN
3285: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3286: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.CUST_VR_EXIST' );
3287: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3288: RETURN TRUE;
3289:
3290: END cust_vr_exist;
3291:

Line 3648: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');

3644: INTO l_lot_ctl;
3645: IF (c_item_controls%NOTFOUND)
3646: THEN
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;

Line 3649: FND_MESSAGE.SET_TOKEN('WHAT', 'INVENTORY_ITEM_ID');

3645: IF (c_item_controls%NOTFOUND)
3646: THEN
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;

Line 3650: FND_MESSAGE.SET_TOKEN('VALUE', p_spec.inventory_item_id);

3646: THEN
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;

Line 3748: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');

3744: INTO dummy;
3745: IF (c_supplier_site%NOTFOUND)
3746: THEN
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;

Line 3749: FND_MESSAGE.SET_TOKEN('WHAT', 'SUPPLIER_SITE_ID');

3745: IF (c_supplier_site%NOTFOUND)
3746: THEN
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;

Line 3750: FND_MESSAGE.SET_TOKEN('VALUE', p_supp_vr.supplier_site_id);

3746: THEN
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;

Line 3911: FND_MESSAGE.SET_NAME('GMD', 'GMD_SUPP_VR_EXIST');

3907: OPEN c_supp_vr;
3908: FETCH c_supp_vr INTO dummy, specname, specvers;
3909: IF c_supp_vr%FOUND THEN
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;

Line 3912: FND_MESSAGE.SET_TOKEN('spec', specname);

3908: FETCH c_supp_vr INTO dummy, specname, specvers;
3909: IF c_supp_vr%FOUND THEN
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

Line 3913: FND_MESSAGE.SET_TOKEN('vers', specvers);

3909: IF c_supp_vr%FOUND THEN
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;

Line 3926: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');

3922: -- Though there is no reason the program can reach
3923: -- here, this is coded just for the reasons we can
3924: -- not think of!
3925: WHEN OTHERS THEN
3926: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3927: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.SUPP_VR_EXIST' );
3928: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3929: RETURN TRUE;
3930:

Line 3927: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.SUPP_VR_EXIST' );

3923: -- here, this is coded just for the reasons we can
3924: -- not think of!
3925: WHEN OTHERS THEN
3926: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3927: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.SUPP_VR_EXIST' );
3928: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3929: RETURN TRUE;
3930:
3931: END supp_vr_exist;

Line 3928: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));

3924: -- not think of!
3925: WHEN OTHERS THEN
3926: FND_MESSAGE.SET_NAME('GMD', 'GMD_API_ERROR');
3927: FND_MESSAGE.SET_TOKEN('PACKAGE', 'GMD_SPEC_VRS_GRP.SUPP_VR_EXIST' );
3928: FND_MESSAGE.SET_TOKEN('ERROR', SUBSTR(SQLERRM,1,200));
3929: RETURN TRUE;
3930:
3931: END supp_vr_exist;
3932:

Line 4007: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
4009: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4010: FND_MESSAGE.Set_Token('POSITION',l_progress );
4011: FND_MSG_PUB.ADD;

Line 4008: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 4009: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 4010: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 4091: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
4093: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4094: FND_MESSAGE.Set_Token('POSITION',l_progress );
4095: FND_MSG_PUB.ADD;

Line 4092: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 4093: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 4094: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 4174: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
4176: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4177: FND_MESSAGE.Set_Token('POSITION',l_progress );
4178: FND_MSG_PUB.ADD;

Line 4175: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 4176: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 4177: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 4257: FND_MESSAGE.Set_Name('GMD','GMD_API_ERROR');

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');
4259: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));
4260: FND_MESSAGE.Set_Token('POSITION',l_progress );
4261: FND_MSG_PUB.ADD;

Line 4258: FND_MESSAGE.Set_Token('PACKAGE','GMD_SPEC_GRP.VALIDATE_BEFORE_DELETE');

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');
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);

Line 4259: FND_MESSAGE.Set_Token('ERROR', substr(sqlerrm,1,100));

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');
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;

Line 4260: FND_MESSAGE.Set_Token('POSITION',l_progress );

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');
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:

Line 4290: FND_MESSAGE.SET_NAME('GMD','GMD_WRONG_VALUE');

4286: BEGIN
4287:
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

Line 4291: FND_MESSAGE.SET_TOKEN('WHAT', 'USER_ID');

4287:
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);

Line 4302: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');

4298:
4299: IF (c_who%NOTFOUND)
4300: THEN
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;

Line 4303: FND_MESSAGE.SET_TOKEN('WHAT', 'USER_ID');

4299: IF (c_who%NOTFOUND)
4300: THEN
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;

Line 4304: FND_MESSAGE.SET_TOKEN('VALUE', p_user_id);

4300: THEN
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;

Line 4370: FND_MESSAGE.Set_Name('GMD','GMD_NOTFOUND');

4366: INTO dummy;
4367: IF (c_coa_type%NOTFOUND)
4368: THEN
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;

Line 4371: FND_MESSAGE.Set_Token('WHAT', 'COA_TYPE');

4367: IF (c_coa_type%NOTFOUND)
4368: THEN
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;

Line 4372: FND_MESSAGE.Set_Token('VALUE', p_coa_type);

4368: THEN
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;

Line 4660: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');

4656: FETCH c_lot_status INTO dummy;
4657: IF (c_lot_status%NOTFOUND)
4658: THEN
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;

Line 4661: FND_MESSAGE.SET_TOKEN('WHAT', 'IN_SPEC_LOT_STATUS_ID');

4657: IF (c_lot_status%NOTFOUND)
4658: THEN
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;

Line 4662: FND_MESSAGE.SET_TOKEN('VALUE', p_in_spec_lot_status_id);

4658: THEN
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;

Line 4680: FND_MESSAGE.SET_NAME('GMD','GMD_NOTFOUND');

4676: FETCH c_lot_status INTO dummy;
4677: IF (c_lot_status%NOTFOUND)
4678: THEN
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;

Line 4681: FND_MESSAGE.SET_TOKEN('WHAT', 'OUT_OF_SPEC_LOT_STATUS_ID');

4677: IF (c_lot_status%NOTFOUND)
4678: THEN
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;

Line 4682: FND_MESSAGE.SET_TOKEN('VALUE', p_out_of_spec_lot_status_id);

4678: THEN
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;