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_ROUTING_STEPS_PUB dependencies on FND_MESSAGE

Line 139: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

135: ,xRouting_id => l_routing_id
136: ,xReturn_status => l_return_status);
137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: /* it indicates that this routing does'ntexists */
139: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
140: FND_MSG_PUB.ADD;
141: RAISE routing_step_creation_failure;
142: END IF;
143: ELSE /* usually in this case user must have passed routing_no and version */

Line 151: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

147: ,xReturn_status => l_return_status);
148:
149: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
150: /* it indicates that this routing does'ntexists */
151: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
152: FND_MSG_PUB.ADD;
153: RAISE routing_step_creation_failure;
154: END IF;
155: END IF;

Line 162: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

158: IF l_routing_id IS NULL THEN
159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line('Routing id is required');
161: END IF;
162: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
163: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
164: FND_MSG_PUB.ADD;
165: RAISE routing_step_creation_failure;
166: END IF;

Line 163: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line('Routing id is required');
161: END IF;
162: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
163: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
164: FND_MSG_PUB.ADD;
165: RAISE routing_step_creation_failure;
166: END IF;
167:

Line 186: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

182: IF p_routing_step_rec.routingstep_no IS NULL THEN
183: IF (l_debug = 'Y') THEN
184: gmd_debug.put_line('Routing step number is required');
185: END IF;
186: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
187: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
188: FND_MSG_PUB.ADD;
189: RAISE routing_step_creation_failure;
190: END IF;

Line 187: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');

183: IF (l_debug = 'Y') THEN
184: gmd_debug.put_line('Routing step number is required');
185: END IF;
186: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
187: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
188: FND_MSG_PUB.ADD;
189: RAISE routing_step_creation_failure;
190: END IF;
191:

Line 198: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

194: IF (l_debug = 'Y') THEN
195: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
196: 'Operation id is required');
197: END IF;
198: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
199: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
200: FND_MSG_PUB.ADD;
201: RAISE routing_step_creation_failure;
202: END IF;

Line 199: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');

195: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
196: 'Operation id is required');
197: END IF;
198: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
199: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
200: FND_MSG_PUB.ADD;
201: RAISE routing_step_creation_failure;
202: END IF;
203:

Line 217: FND_MESSAGE.SET_NAME('GMD', 'FM_RTSTEPERR');

213: /* If this step exists indicate a duplication not allowed message */
214: IF p_routing_step_rec.routingstep_no IS NOT NULL THEN
215: IF GMDRTVAL_PUB.check_routingstep_no(proutingstep_no => p_routing_step_rec.routingstep_no
216: ,prouting_id => p_routing_id) <> 0 THEN
217: FND_MESSAGE.SET_NAME('GMD', 'FM_RTSTEPERR');
218: FND_MSG_PUB.ADD;
219: RAISE routing_step_creation_failure;
220: END IF;
221: END IF;

Line 249: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
252: END IF;
253: -- Bug# 3558478 KMOTUPAL

Line 259: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');

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;
262: END IF; */
263:

Line 270: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');

266: FETCH get_rout_start_date INTO l_rout_eff_start_date, l_rout_eff_end_date;
267: IF get_rout_start_date%NOTFOUND THEN
268: /* Routing has not been created correctly */
269: CLOSE get_rout_start_date;
270: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');
271: FND_MSG_PUB.ADD;
272: RAISE routing_step_creation_failure;
273: END IF;
274: CLOSE get_rout_start_date;

Line 279: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_OPRN');

275:
276: OPEN Get_oprn_details(p_routing_step_rec.oprn_id);
277: FETCH Get_oprn_details INTO l_oprn_no, l_oprn_vers;
278: IF Get_oprn_details%NOTFOUND THEN
279: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_OPRN');
280: FND_MSG_PUB.ADD;
281: CLOSE Get_oprn_details;
282: RAISE routing_step_creation_failure;
283: END IF;

Line 521: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

517: IF p_routingstep_no IS NULL THEN
518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line('routing step number required');
520: END IF;
521: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
522: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
523: FND_MSG_PUB.ADD;
524: RAISE routing_step_dep_failure;
525: END IF;

Line 522: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');

518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line('routing step number required');
520: END IF;
521: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
522: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
523: FND_MSG_PUB.ADD;
524: RAISE routing_step_dep_failure;
525: END IF;
526:

Line 532: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

528: IF p_routings_step_dep_tbl(1).dep_routingstep_no IS NULL THEN
529: IF (l_debug = 'Y') THEN
530: gmd_debug.put_line('dep routing step number required');
531: END IF;
532: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
533: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
534: FND_MSG_PUB.ADD;
535: RAISE routing_step_dep_failure;
536: END IF;

Line 533: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');

529: IF (l_debug = 'Y') THEN
530: gmd_debug.put_line('dep routing step number required');
531: END IF;
532: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
533: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
534: FND_MSG_PUB.ADD;
535: RAISE routing_step_dep_failure;
536: END IF;
537:

Line 543: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

539: IF p_routings_step_dep_tbl(1).routingstep_no_uom IS NULL THEN
540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line('Item uom required');
542: END IF;
543: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
544: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO_UOM');
545: FND_MSG_PUB.ADD;
546: RAISE routing_step_dep_failure;
547: /* call common function to check if um passed is valid */

Line 544: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO_UOM');

540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line('Item uom required');
542: END IF;
543: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
544: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO_UOM');
545: FND_MSG_PUB.ADD;
546: RAISE routing_step_dep_failure;
547: /* call common function to check if um passed is valid */
548: ELSIF (NOT(gmd_api_grp.validate_um(p_routings_step_dep_tbl(1).routingstep_no_uom))) THEN

Line 552: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

548: ELSIF (NOT(gmd_api_grp.validate_um(p_routings_step_dep_tbl(1).routingstep_no_uom))) THEN
549: IF (l_debug = 'Y') THEN
550: gmd_debug.put_line('Item uom invalid');
551: END IF;
552: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
553: FND_MSG_PUB.ADD;
554: RAISE routing_step_dep_failure;
555: END IF;
556:

Line 562: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');

558: IF p_routings_step_dep_tbl(1).transfer_pct < 0 OR p_routings_step_dep_tbl(1).transfer_pct > 100 THEN
559: IF (l_debug = 'Y') THEN
560: gmd_debug.put_line('Transfer percent should be positive value');
561: END IF;
562: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
563: FND_MSG_PUB.ADD;
564: RAISE routing_step_dep_failure;
565: END IF;
566:

Line 572: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');

568: IF p_routings_step_dep_tbl(1).dep_type NOT IN (0,1) THEN
569: IF (l_debug = 'Y') THEN
570: gmd_debug.put_line('Invalid value for dep_type field');
571: END IF;
572: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');
573: FND_MSG_PUB.ADD;
574: RAISE routing_step_dep_failure;
575: END IF;
576:

Line 590: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

586: ,xReturn_status => l_return_status);
587:
588: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
589: /* it indicates that this routing does'ntexists */
590: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
591: FND_MSG_PUB.ADD;
592: RAISE routing_step_dep_failure;
593: END IF;
594: ELSE /* usually in this case use must have passed routing_no and version */

Line 602: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

598: ,xReturn_status => l_return_status);
599:
600: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
601: /* it indicates that this routing does'ntexists */
602: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
603: FND_MSG_PUB.ADD;
604: RAISE routing_step_dep_failure;
605: END IF;
606: END IF;

Line 613: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

609: IF l_routing_id IS NULL THEN
610: IF (l_debug = 'Y') THEN
611: gmd_debug.put_line('Routing id is required');
612: END IF;
613: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
614: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
615: FND_MSG_PUB.ADD;
616: x_return_status := FND_API.g_ret_sts_error;
617: END IF;

Line 614: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

610: IF (l_debug = 'Y') THEN
611: gmd_debug.put_line('Routing id is required');
612: END IF;
613: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
614: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
615: FND_MSG_PUB.ADD;
616: x_return_status := FND_API.g_ret_sts_error;
617: END IF;
618:

Line 634: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
637: END IF;
638:

Line 652: FND_MESSAGE.SET_NAME('GME', 'PC_RECORD_EXISTS');

648: ,x_Return_status => l_return_status);
649:
650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: /* it indicates that this routing does'ntexists */
652: FND_MESSAGE.SET_NAME('GME', 'PC_RECORD_EXISTS');
653: FND_MSG_PUB.ADD;
654: RAISE routing_step_dep_failure;
655: END IF;
656: END LOOP; /* End loop for p_routings_step_dep_tbl.count */

Line 831: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

827: ,xReturn_status => l_return_status);
828:
829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
830: /* it indicates that this routing does'ntexists */
831: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
832: FND_MSG_PUB.ADD;
833: RAISE routing_update_step_failure;
834: END IF;
835: ELSE /* usually in this case user must have passed routing_no and version */

Line 843: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

839: ,xReturn_status => l_return_status);
840:
841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: /* it indicates that this routing does'ntexists */
843: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
844: FND_MSG_PUB.ADD;
845: RAISE routing_update_step_failure;
846: END IF;
847: END IF;

Line 854: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

850: IF l_routing_id IS NULL THEN
851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line('Routing id is required');
853: END IF;
854: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
855: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
856: FND_MSG_PUB.ADD;
857: RAISE routing_update_step_failure;
858: END IF;

Line 855: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line('Routing id is required');
853: END IF;
854: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
855: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
856: FND_MSG_PUB.ADD;
857: RAISE routing_update_step_failure;
858: END IF;
859:

Line 890: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

886: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
887: END IF;
888: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: /* it indicates that this routing does'ntexists */
890: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
891: FND_MSG_PUB.ADD;
892: RAISE routing_update_step_failure;
893: END IF;
894: ELSE

Line 903: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

899: ,pxRoutingStep_id => l_routingstep_id
900: ,x_return_status => l_return_status );
901: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
902: -- it indicates that this routing does not exists
903: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
904: FND_MSG_PUB.ADD;
905: RAISE routing_update_step_failure;
906: END IF;
907: END IF;

Line 914: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

910: IF l_routingstep_id IS NULL THEN
911: IF (l_debug = 'Y') THEN
912: gmd_debug.put_line('Routing step id is required');
913: END IF;
914: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
915: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
916: FND_MSG_PUB.ADD;
917: RAISE routing_update_step_failure;
918: END IF;

Line 915: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');

911: IF (l_debug = 'Y') THEN
912: gmd_debug.put_line('Routing step id is required');
913: END IF;
914: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
915: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
916: FND_MSG_PUB.ADD;
917: RAISE routing_update_step_failure;
918: END IF;
919:

Line 924: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
927: END IF;
928:

Line 940: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');

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;
943: END IF;
944:

Line 1141: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');

1137: IF l_transfer_pct < 0 OR l_transfer_pct > 100 THEN
1138: IF (l_debug = 'Y') THEN
1139: gmd_debug.put_line ('Transfer pct value should be positive');
1140: END IF;
1141: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
1142: FND_MSG_PUB.ADD;
1143: RAISE routing_update_dep_failure;
1144: END IF;
1145:

Line 1151: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');

1147: IF l_std_delay < 0 THEN
1148: IF (l_debug = 'Y') THEN
1149: gmd_debug.put_line ('Transfer pct value should be positive');
1150: END IF;
1151: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
1152: FND_MSG_PUB.ADD;
1153: RAISE routing_update_dep_failure;
1154: END IF;
1155:

Line 1161: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');

1157: IF l_dep_type NOT IN (0,1) THEN
1158: IF (l_debug = 'Y') THEN
1159: gmd_debug.put_line('Invalid value for dep_type field');
1160: END IF;
1161: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');
1162: FND_MSG_PUB.ADD;
1163: RAISE routing_update_dep_failure;
1164: END IF;
1165:

Line 1176: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1172: ,xReturn_status => l_return_status);
1173:
1174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1175: /* it indicates that this routing does'ntexists */
1176: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1177: FND_MSG_PUB.ADD;
1178: RAISE routing_update_dep_failure;
1179: END IF;
1180: ELSE /* usually in this case user must have passed routing_no and version */

Line 1188: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1184: ,xReturn_status => l_return_status);
1185:
1186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1187: /* it indicates that this routing does'ntexists */
1188: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1189: FND_MSG_PUB.ADD;
1190: RAISE routing_update_dep_failure;
1191: END IF;
1192: END IF;

Line 1199: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1195: IF l_routing_id IS NULL THEN
1196: IF (l_debug = 'Y') THEN
1197: gmd_debug.put_line('Routing id is required');
1198: END IF;
1199: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1200: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1201: FND_MSG_PUB.ADD;
1202: RAISE routing_update_dep_failure;
1203: END IF;

Line 1200: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

1196: IF (l_debug = 'Y') THEN
1197: gmd_debug.put_line('Routing id is required');
1198: END IF;
1199: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1200: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1201: FND_MSG_PUB.ADD;
1202: RAISE routing_update_dep_failure;
1203: END IF;
1204:

Line 1229: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

1225: ,pxRoutingStep_id => l_routingstep_id
1226: ,x_return_status => l_return_status );
1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1228: /* it indicates that this routing does'ntexists */
1229: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1230: FND_MSG_PUB.ADD;
1231: RAISE routing_update_dep_failure;
1232: END IF;
1233: ELSE

Line 1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

1237: ,pxRoutingStep_id => l_routingstep_id
1238: ,x_return_status => l_return_status );
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: /* it indicates that this routing does'ntexists */
1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1242: FND_MSG_PUB.ADD;
1243: RAISE routing_update_dep_failure;
1244: END IF;
1245: END IF;

Line 1252: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1248: IF l_routingstep_no IS NULL THEN
1249: IF (l_debug = 'Y') THEN
1250: gmd_debug.put_line('Routing id is required');
1251: END IF;
1252: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1253: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1254: FND_MSG_PUB.ADD;
1255: RAISE routing_update_dep_failure;
1256: END IF;

Line 1253: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');

1249: IF (l_debug = 'Y') THEN
1250: gmd_debug.put_line('Routing id is required');
1251: END IF;
1252: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1253: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1254: FND_MSG_PUB.ADD;
1255: RAISE routing_update_dep_failure;
1256: END IF;
1257:

Line 1266: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
1269: END IF;
1270:

Line 1428: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1424: ,xReturn_status => l_return_status);
1425:
1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: /* it indicates that this routing does'ntexists */
1428: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1429: FND_MSG_PUB.ADD;
1430: RAISE routing_delete_step_failure;
1431: END IF;
1432: ELSE /* usually in this case user must have passed routing_no and version */

Line 1440: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1436: ,xReturn_status => l_return_status);
1437:
1438: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1439: /* it indicates that this routing does'ntexists */
1440: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1441: FND_MSG_PUB.ADD;
1442: RAISE routing_delete_step_failure;
1443: END IF;
1444: END IF;

Line 1451: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1447: IF l_routing_id IS NULL THEN
1448: IF (l_debug = 'Y') THEN
1449: gmd_debug.put_line('Routing id is required');
1450: END IF;
1451: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1452: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1453: FND_MSG_PUB.ADD;
1454: x_return_status := FND_API.g_ret_sts_error;
1455: END IF;

Line 1452: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

1448: IF (l_debug = 'Y') THEN
1449: gmd_debug.put_line('Routing id is required');
1450: END IF;
1451: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1452: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1453: FND_MSG_PUB.ADD;
1454: x_return_status := FND_API.g_ret_sts_error;
1455: END IF;
1456:

Line 1485: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

1481: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
1482: END IF;
1483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1484: /* it indicates that this routing does'ntexists */
1485: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1486: FND_MSG_PUB.ADD;
1487: RAISE routing_delete_step_failure;
1488: END IF;
1489: ELSE

Line 1500: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

1496: ,pxRoutingStep_id => l_routingstep_id
1497: ,x_return_status => l_return_status );
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1499: /* it indicates that this routing does'ntexists */
1500: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1501: FND_MSG_PUB.ADD;
1502: RAISE routing_delete_step_failure;
1503: END IF;
1504: END IF;

Line 1511: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1507: IF l_routingstep_id IS NULL THEN
1508: IF (l_debug = 'Y') THEN
1509: gmd_debug.put_line('Routing step id is required');
1510: END IF;
1511: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1512: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1513: FND_MSG_PUB.ADD;
1514: RAISE routing_delete_step_failure;
1515: END IF;

Line 1512: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');

1508: IF (l_debug = 'Y') THEN
1509: gmd_debug.put_line('Routing step id is required');
1510: END IF;
1511: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1512: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1513: FND_MSG_PUB.ADD;
1514: RAISE routing_delete_step_failure;
1515: END IF;
1516:

Line 1520: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');

1516:
1517: /* Validation : Check if this step is used in recipe override table and
1518: step material association table. If it is then delete is not allowed */
1519: IF GMDRTVAL_PUB.Check_routing_override_exists(l_routingstep_id) THEN
1520: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');
1521: FND_MSG_PUB.ADD;
1522: RAISE routing_delete_step_failure;
1523: END IF;
1524:

Line 1529: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
1532: END IF;
1533:

Line 1691: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1687: ,xReturn_status => l_return_status);
1688:
1689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1690: /* it indicates that this routing does'ntexists */
1691: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1692: FND_MSG_PUB.ADD;
1693: RAISE routing_delete_dep_failure;
1694: END IF;
1695: ELSE /* usually in this case user must have passed routing_no and version */

Line 1703: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');

1699: ,xReturn_status => l_return_status);
1700:
1701: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1702: /* it indicates that this routing does'ntexists */
1703: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1704: FND_MSG_PUB.ADD;
1705: RAISE routing_delete_dep_failure;
1706: END IF;
1707: END IF;

Line 1714: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1710: IF l_routing_id IS NULL THEN
1711: IF (l_debug = 'Y') THEN
1712: gmd_debug.put_line('Routing id is required');
1713: END IF;
1714: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1715: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1716: FND_MSG_PUB.ADD;
1717: RAISE routing_delete_dep_failure;
1718: END IF;

Line 1715: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');

1711: IF (l_debug = 'Y') THEN
1712: gmd_debug.put_line('Routing id is required');
1713: END IF;
1714: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1715: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1716: FND_MSG_PUB.ADD;
1717: RAISE routing_delete_dep_failure;
1718: END IF;
1719:

Line 1739: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

1735: ,pxRoutingStep_id => l_routingstep_id
1736: ,x_return_status => l_return_status );
1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1738: /* it indicates that this routing does'ntexists */
1739: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
1740: FND_MSG_PUB.ADD;
1741: RAISE routing_delete_dep_failure;
1742: END IF;
1743: END IF;

Line 1750: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1746: IF p_routingstep_no IS NULL THEN
1747: IF (l_debug = 'Y') THEN
1748: gmd_debug.put_line('Routing step number is required');
1749: END IF;
1750: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1751: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1752: FND_MSG_PUB.ADD;
1753: RAISE routing_delete_dep_failure;
1754: END IF;

Line 1751: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');

1747: IF (l_debug = 'Y') THEN
1748: gmd_debug.put_line('Routing step number is required');
1749: END IF;
1750: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1751: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1752: FND_MSG_PUB.ADD;
1753: RAISE routing_delete_dep_failure;
1754: END IF;
1755:

Line 1761: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1757: IF p_dep_routingstep_no IS NULL THEN
1758: IF (l_debug = 'Y') THEN
1759: gmd_debug.put_line('Dep Routing step number is required');
1760: END IF;
1761: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1762: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
1763: FND_MSG_PUB.ADD;
1764: RAISE routing_delete_dep_failure;
1765: END IF;

Line 1762: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');

1758: IF (l_debug = 'Y') THEN
1759: gmd_debug.put_line('Dep Routing step number is required');
1760: END IF;
1761: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1762: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
1763: FND_MSG_PUB.ADD;
1764: RAISE routing_delete_dep_failure;
1765: END IF;
1766:

Line 1780: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_NOT_VALID');

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;
1783: END IF;
1784: