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

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

200: IF p_oprn_line_id IS NULL THEN
201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line('operation line ID is required');
203: END IF;
204: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
205: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
206: FND_MSG_PUB.ADD;
207: RAISE ins_oprn_rsrc_err;
208: ELSIF p_oprn_line_id IS NOT NULL THEN

Line 205: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');

201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line('operation line ID is required');
203: END IF;
204: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
205: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
206: FND_MSG_PUB.ADD;
207: RAISE ins_oprn_rsrc_err;
208: ELSIF p_oprn_line_id IS NOT NULL THEN
209: /* check to see that it is valid id */

Line 214: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');

210: OPEN check_oprn_line_id(p_oprn_line_id);
211: FETCH check_oprn_line_id INTO v_count;
212: IF check_oprn_line_id%NOTFOUND THEN
213: /* must pass existing operation line id */
214: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');
215: FND_MSG_PUB.ADD;
216: CLOSE check_oprn_line_id;
217: RAISE ins_oprn_rsrc_err;
218: END IF;

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

240: IF l_oprn_rsrc_tbl(i).resources IS NULL THEN
241: IF (l_debug = 'Y') THEN
242: gmd_debug.put_line('operation resource required');
243: END IF;
244: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
245: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCES');
246: FND_MSG_PUB.ADD;
247: RAISE ins_oprn_rsrc_err;
248: ELSE /* check resource exists */

Line 245: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCES');

241: IF (l_debug = 'Y') THEN
242: gmd_debug.put_line('operation resource required');
243: END IF;
244: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
245: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCES');
246: FND_MSG_PUB.ADD;
247: RAISE ins_oprn_rsrc_err;
248: ELSE /* check resource exists */
249: v_resources := l_oprn_rsrc_tbl(i).resources;

Line 254: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');

250: OPEN get_resource_det(v_resources);
251: FETCH get_resource_det INTO l_cost_cmpntcls_id;
252: IF get_resource_det%NOTFOUND THEN
253: /* must pass valid resource */
254: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');
255: FND_MSG_PUB.ADD;
256: CLOSE get_resource_det;
257: RAISE ins_oprn_rsrc_err;
258: END IF;

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

263: IF l_oprn_rsrc_tbl(i).process_qty IS NULL THEN
264: IF (l_debug = 'Y') THEN
265: gmd_debug.put_line('resource process qty required');
266: END IF;
267: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
268: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY');
269: FND_MSG_PUB.ADD;
270: RAISE ins_oprn_rsrc_err;
271: ELSIF l_oprn_rsrc_tbl(i).process_qty < 0 THEN

Line 268: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY');

264: IF (l_debug = 'Y') THEN
265: gmd_debug.put_line('resource process qty required');
266: END IF;
267: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
268: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY');
269: FND_MSG_PUB.ADD;
270: RAISE ins_oprn_rsrc_err;
271: ELSIF l_oprn_rsrc_tbl(i).process_qty < 0 THEN
272: FND_MESSAGE.SET_TOKEN('GMD', 'FM_PROCQTYERR');

Line 272: FND_MESSAGE.SET_TOKEN('GMD', 'FM_PROCQTYERR');

268: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY');
269: FND_MSG_PUB.ADD;
270: RAISE ins_oprn_rsrc_err;
271: ELSIF l_oprn_rsrc_tbl(i).process_qty < 0 THEN
272: FND_MESSAGE.SET_TOKEN('GMD', 'FM_PROCQTYERR');
273: FND_MSG_PUB.ADD;
274: RAISE ins_oprn_rsrc_err;
275: END IF;
276:

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

279: IF (l_debug = 'Y') THEN
280: gmd_debug.put_line('resource usage required');
281: END IF;
282:
283: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_USAGE');
285: FND_MSG_PUB.ADD;
286: RAISE ins_oprn_rsrc_err;
287: END IF;

Line 284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_USAGE');

280: gmd_debug.put_line('resource usage required');
281: END IF;
282:
283: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_USAGE');
285: FND_MSG_PUB.ADD;
286: RAISE ins_oprn_rsrc_err;
287: END IF;
288:

Line 291: FND_MESSAGE.SET_NAME('GMD', 'FM_RESUSGERR');

287: END IF;
288:
289: -- Negative usage
290: IF l_oprn_rsrc_tbl(i).resource_usage < 0 THEN
291: FND_MESSAGE.SET_NAME('GMD', 'FM_RESUSGERR');
292: FND_MSG_PUB.ADD;
293: RAISE ins_oprn_rsrc_err;
294: END IF;
295:

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

300: END IF;
301: OPEN Cur_get_resource_usage_uom(l_oprn_rsrc_tbl(i).resources);
302: FETCH Cur_get_resource_usage_uom INTO l_oprn_rsrc_tbl(i).resource_usage_uom;
303: IF Cur_get_resource_usage_uom%NOTFOUND THEN
304: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
305: FND_MESSAGE.SET_TOKEN ('MISSING', 'resource_usage_uom');
306: FND_MSG_PUB.ADD;
307: CLOSE Cur_get_resource_usage_uom;
308: RAISE ins_oprn_rsrc_err;

Line 305: FND_MESSAGE.SET_TOKEN ('MISSING', 'resource_usage_uom');

301: OPEN Cur_get_resource_usage_uom(l_oprn_rsrc_tbl(i).resources);
302: FETCH Cur_get_resource_usage_uom INTO l_oprn_rsrc_tbl(i).resource_usage_uom;
303: IF Cur_get_resource_usage_uom%NOTFOUND THEN
304: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
305: FND_MESSAGE.SET_TOKEN ('MISSING', 'resource_usage_uom');
306: FND_MSG_PUB.ADD;
307: CLOSE Cur_get_resource_usage_uom;
308: RAISE ins_oprn_rsrc_err;
309: END IF;

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

313: OPEN check_uom(v_uom);
314: FETCH check_uom INTO v_count;
315: IF check_uom%NOTFOUND THEN
316: /* must pass existing uom */
317: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
318: FND_MSG_PUB.ADD;
319: CLOSE check_uom;
320: RAISE ins_oprn_rsrc_err;
321: END IF;

Line 333: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_CMPNTCLS_ID');

329: v_cost_cmpntcls_id := l_oprn_rsrc_tbl(i).cost_cmpntcls_id;
330: OPEN check_cost_cmpntcls_id(v_cost_cmpntcls_id);
331: FETCH check_cost_cmpntcls_id INTO v_count;
332: IF check_cost_cmpntcls_id%NOTFOUND THEN
333: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_CMPNTCLS_ID');
334: FND_MSG_PUB.ADD;
335: CLOSE check_cost_cmpntcls_id;
336: RAISE ins_oprn_rsrc_err;
337: END IF;

Line 351: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');

347: v_cost_analysis_code := l_oprn_rsrc_tbl(i).cost_analysis_code;
348: OPEN check_cost_analysis_code(v_cost_analysis_code);
349: FETCH check_cost_analysis_code INTO v_count;
350: IF check_cost_analysis_code%NOTFOUND THEN
351: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
352: FND_MSG_PUB.ADD;
353: CLOSE check_cost_analysis_code;
354: RAISE ins_oprn_rsrc_err;
355: END IF;

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

369: IF l_oprn_rsrc_tbl(i).resource_count IS NULL THEN
370: IF (l_debug = 'Y') THEN
371: gmd_debug.put_line('Resource Count required');
372: END IF;
373: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
374: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_COUNT');
375: FND_MSG_PUB.ADD;
376: RAISE ins_oprn_rsrc_err;
377: ELSIF l_oprn_rsrc_tbl(i).resource_count < 0 THEN

Line 374: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_COUNT');

370: IF (l_debug = 'Y') THEN
371: gmd_debug.put_line('Resource Count required');
372: END IF;
373: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
374: FND_MESSAGE.SET_TOKEN ('MISSING', 'RESOURCE_COUNT');
375: FND_MSG_PUB.ADD;
376: RAISE ins_oprn_rsrc_err;
377: ELSIF l_oprn_rsrc_tbl(i).resource_count < 0 THEN
378: gmd_api_grp.log_message ('FM_RESCOUNTERR');

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

383: IF l_oprn_rsrc_tbl(i).offset_interval IS NULL THEN
384: IF (l_debug = 'Y') THEN
385: gmd_debug.put_line('Offset interval required');
386: END IF;
387: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
388: FND_MESSAGE.SET_TOKEN ('MISSING', 'OFFSET_INTERVAL');
389: FND_MSG_PUB.ADD;
390: RAISE ins_oprn_rsrc_err;
391: END IF;

Line 388: FND_MESSAGE.SET_TOKEN ('MISSING', 'OFFSET_INTERVAL');

384: IF (l_debug = 'Y') THEN
385: gmd_debug.put_line('Offset interval required');
386: END IF;
387: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
388: FND_MESSAGE.SET_TOKEN ('MISSING', 'OFFSET_INTERVAL');
389: FND_MSG_PUB.ADD;
390: RAISE ins_oprn_rsrc_err;
391: END IF;
392:

Line 471: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

467: P_data => x_message_list);
468: WHEN OTHERS THEN
469: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
472: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
473: FND_MSG_PUB.ADD;
474: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
475: P_data => x_message_list);

Line 472: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

468: WHEN OTHERS THEN
469: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
472: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
473: FND_MSG_PUB.ADD;
474: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
475: P_data => x_message_list);
476: END insert_operation_resources;

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

538: END IF;
539:
540: /* Oprn_line_id must be passed, otherwise give error */
541: IF p_oprn_line_id IS NULL THEN
542: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
543: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
544: FND_MSG_PUB.ADD;
545: RAISE upd_oprn_rsrc_err;
546: ELSE /* check oprn_line_id exists */

Line 543: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');

539:
540: /* Oprn_line_id must be passed, otherwise give error */
541: IF p_oprn_line_id IS NULL THEN
542: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
543: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
544: FND_MSG_PUB.ADD;
545: RAISE upd_oprn_rsrc_err;
546: ELSE /* check oprn_line_id exists */
547: OPEN check_oprn_line_id(p_oprn_line_id);

Line 550: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');

546: ELSE /* check oprn_line_id exists */
547: OPEN check_oprn_line_id(p_oprn_line_id);
548: FETCH check_oprn_line_id INTO l_exist;
549: IF check_oprn_line_id%NOTFOUND THEN
550: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');
551: FND_MSG_PUB.ADD;
552: CLOSE check_oprn_line_id;
553: RAISE upd_oprn_rsrc_err;
554: END IF;

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

556: END IF;
557:
558: /* Resources must be passed, otherwise give error */
559: IF p_resources IS NULL THEN
560: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
561: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_RESOURCES');
562: FND_MSG_PUB.ADD;
563: RAISE upd_oprn_rsrc_err;
564: ELSE /* check resource exists */

Line 561: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_RESOURCES');

557:
558: /* Resources must be passed, otherwise give error */
559: IF p_resources IS NULL THEN
560: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
561: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_RESOURCES');
562: FND_MSG_PUB.ADD;
563: RAISE upd_oprn_rsrc_err;
564: ELSE /* check resource exists */
565: OPEN check_resource(p_oprn_line_id, p_resources);

Line 569: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');

565: OPEN check_resource(p_oprn_line_id, p_resources);
566: FETCH check_resource INTO l_exist;
567: IF check_resource%NOTFOUND THEN
568: /* must pass valid resource */
569: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');
570: FND_MSG_PUB.ADD;
571: CLOSE check_resource;
572: RAISE upd_oprn_rsrc_err;
573: END IF;

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

577: /* Loop thru cols to be updated - verify col and value are present */
578: FOR i in 1 .. p_update_table.count LOOP
579: /* Col_to_update and value must be passed, otherwise give error */
580: IF p_update_table(i).p_col_to_update IS NULL THEN
581: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
582: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_COL_TO_UPDATE');
583: FND_MSG_PUB.ADD;
584: RAISE upd_oprn_rsrc_err;
585: ELSIF p_update_table(i).p_value IS NULL THEN

Line 582: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_COL_TO_UPDATE');

578: FOR i in 1 .. p_update_table.count LOOP
579: /* Col_to_update and value must be passed, otherwise give error */
580: IF p_update_table(i).p_col_to_update IS NULL THEN
581: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
582: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_COL_TO_UPDATE');
583: FND_MSG_PUB.ADD;
584: RAISE upd_oprn_rsrc_err;
585: ELSIF p_update_table(i).p_value IS NULL THEN
586: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

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

582: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_COL_TO_UPDATE');
583: FND_MSG_PUB.ADD;
584: RAISE upd_oprn_rsrc_err;
585: ELSIF p_update_table(i).p_value IS NULL THEN
586: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
587: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
588: FND_MSG_PUB.ADD;
589: RAISE upd_oprn_rsrc_err;
590: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN

Line 587: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');

583: FND_MSG_PUB.ADD;
584: RAISE upd_oprn_rsrc_err;
585: ELSIF p_update_table(i).p_value IS NULL THEN
586: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
587: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
588: FND_MSG_PUB.ADD;
589: RAISE upd_oprn_rsrc_err;
590: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
591: OPEN check_cost_analysis_code(p_update_table(i).p_value);

Line 594: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');

590: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
591: OPEN check_cost_analysis_code(p_update_table(i).p_value);
592: FETCH check_cost_analysis_code INTO l_exist;
593: IF check_cost_analysis_code%NOTFOUND THEN
594: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
595: FND_MSG_PUB.ADD;
596: CLOSE check_cost_analysis_code;
597: RAISE upd_oprn_rsrc_err;
598: END IF;

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

611: OPEN check_uom(p_update_table(i).p_value);
612: FETCH check_uom INTO l_exist;
613: IF check_uom%NOTFOUND THEN
614: /* must pass existing uom */
615: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
616: FND_MSG_PUB.ADD;
617: CLOSE check_uom;
618: RAISE upd_oprn_rsrc_err;
619: END IF;

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

621: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_CMPNTCLS_ID' THEN
622: OPEN check_cost_cmpntcls_id(p_update_table(i).p_value);
623: FETCH check_cost_cmpntcls_id INTO l_exist;
624: IF check_cost_cmpntcls_id%NOTFOUND THEN
625: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_CMPNTCLS_ID');
626: FND_MSG_PUB.ADD;
627: CLOSE check_cost_cmpntcls_id;
628: RAISE upd_oprn_rsrc_err;
629: END IF;

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

686: /* Validation : Verify Operation status is not On Hold nor Obsolete/Archived
687: and Operation is not logically deleted */
688: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',
689: Entity_id => v_oprn_id ) THEN
690: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
691: FND_MSG_PUB.ADD;
692: RAISE upd_oprn_rsrc_err;
693: END IF;
694:

Line 735: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

731: P_data => x_message_list);
732: WHEN OTHERS THEN
733: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
736: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
739: P_data => x_message_list);

Line 736: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

732: WHEN OTHERS THEN
733: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
736: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
739: P_data => x_message_list);
740: END update_operation_resources;

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

814: END IF;
815:
816: /* Operation Line ID must be passed, otherwise give error */
817: IF (p_oprn_line_id IS NULL OR p_resources IS NULL) THEN
818: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
819: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_OPRN_LINE_ID');
820: FND_MSG_PUB.ADD;
821: RAISE del_oprn_rsrc_err;
822: ELSE /* check oprn_line_id and resource exist */

Line 819: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_OPRN_LINE_ID');

815:
816: /* Operation Line ID must be passed, otherwise give error */
817: IF (p_oprn_line_id IS NULL OR p_resources IS NULL) THEN
818: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
819: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_OPRN_LINE_ID');
820: FND_MSG_PUB.ADD;
821: RAISE del_oprn_rsrc_err;
822: ELSE /* check oprn_line_id and resource exist */
823: OPEN check_oprn_line_id(p_oprn_line_id);

Line 827: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');

823: OPEN check_oprn_line_id(p_oprn_line_id);
824: FETCH check_oprn_line_id INTO v_count;
825: IF check_oprn_line_id%NOTFOUND THEN
826: /* must pass valid oprn_line_id */
827: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');
828: FND_MSG_PUB.ADD;
829: CLOSE check_oprn_line_id; /* pku */
830: RAISE del_oprn_rsrc_err;
831: ELSE

Line 836: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');

832: OPEN check_resource(p_oprn_line_id, p_resources);
833: FETCH check_resource INTO v_count;
834: IF check_resource%NOTFOUND THEN
835: /* must pass valid resource */
836: FND_MESSAGE.SET_NAME('GMD','FM_BAD_RESOURCE');
837: FND_MSG_PUB.ADD;
838: CLOSE check_resource;
839: CLOSE check_oprn_line_id; /* pku */
840: RAISE del_oprn_rsrc_err;

Line 911: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

907: P_data => x_message_list);
908: WHEN OTHERS THEN
909: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
912: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
913: FND_MSG_PUB.ADD;
914: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
915: P_data => x_message_list);

Line 912: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

908: WHEN OTHERS THEN
909: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
912: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
913: FND_MSG_PUB.ADD;
914: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
915: P_data => x_message_list);
916: END delete_operation_resources;