DBA Data[Home] [Help]

APPS.GMD_ROUTING_STEPS_PUB dependencies on GMD_COMMON_VAL

Line 247: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

243: END IF;
244:
245: /* Validation : Routing status is not On Hold nor Obsolete/Archived
246: and Routing is not logically deleted */
247: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
248: Entity_id => l_routing_id ) THEN
249: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
250: FND_MSG_PUB.ADD;
251: RAISE routing_step_creation_failure;

Line 257: /* IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',

253: -- Bug# 3558478 KMOTUPAL
254: -- Commented the code for validation of Operation
255: /* Validation : Operation status is not On Hold nor Obsolete/Archived
256: and Operation is not logically deleted */
257: /* IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',
258: Entity_id => p_routing_step_rec.oprn_id ) THEN
259: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
260: FND_MSG_PUB.ADD;
261: RAISE routing_step_creation_failure;

Line 632: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

628: END IF;
629:
630: /* Validation : Routing status is not On Hold nor Obsolete/Archived
631: and Routing is not logically deleted */
632: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
633: Entity_id => l_routing_id ) THEN
634: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
635: FND_MSG_PUB.ADD;
636: RAISE routing_step_dep_failure;

Line 922: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

918: END IF;
919:
920: /* Validation : Routing status is not On Hold nor Obsolete/Archived
921: and Routing is not logically deleted */
922: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
923: Entity_id => l_routing_id ) THEN
924: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
925: FND_MSG_PUB.ADD;
926: RAISE routing_update_step_failure;

Line 938: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',

934: RAISE routing_update_step_failure;
935: CLOSE get_oprn_id;
936: END IF;
937: CLOSE get_oprn_id;
938: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',
939: Entity_id => l_oprn_id ) THEN
940: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
941: FND_MSG_PUB.ADD;
942: RAISE routing_update_step_failure;

Line 1264: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

1260: END IF;
1261:
1262: /* Validation : Routing status is not On Hold nor Obsolete/Archived
1263: and Routing is not logically deleted */
1264: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
1265: Entity_id => l_routing_id ) THEN
1266: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
1267: FND_MSG_PUB.ADD;
1268: RAISE routing_update_dep_failure;

Line 1527: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

1523: END IF;
1524:
1525: /* Validation : Routing status is not On Hold nor Obsolete/Archived
1526: and Routing is not logically deleted */
1527: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
1528: Entity_id => l_routing_id ) THEN
1529: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
1530: FND_MSG_PUB.ADD;
1531: RAISE routing_delete_step_failure;

Line 1778: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',

1774:
1775:
1776: /* Validation : Routing status is not On Hold nor Obsolete/Archived
1777: and Routing is not logically deleted */
1778: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'ROUTING',
1779: Entity_id => l_routing_id ) THEN
1780: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');
1781: FND_MSG_PUB.ADD;
1782: RAISE routing_delete_dep_failure;