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_MSG_PUB

Line 192: fnd_msg_pub.initialize;

188: END IF;
189:
190: /* Initialize message list and count if needed */
191: IF p_init_msg_list THEN
192: fnd_msg_pub.initialize;
193: END IF;
194:
195: IF (l_debug = 'Y') THEN
196: gmd_debug.put_line('In insert_operation_resources public.');

Line 206: FND_MSG_PUB.ADD;

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 */
210: OPEN check_oprn_line_id(p_oprn_line_id);

Line 215: FND_MSG_PUB.ADD;

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;
219: CLOSE check_oprn_line_id;

Line 246: FND_MSG_PUB.ADD;

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;
250: OPEN get_resource_det(v_resources);

Line 255: FND_MSG_PUB.ADD;

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;
259: CLOSE get_resource_det;

Line 269: FND_MSG_PUB.ADD;

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');
273: FND_MSG_PUB.ADD;

Line 273: FND_MSG_PUB.ADD;

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:
277: /* resource usagemust be passed, otherwise give error */

Line 285: FND_MSG_PUB.ADD;

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:
289: -- Negative usage

Line 292: FND_MSG_PUB.ADD;

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:
296: /* If Usage is not passed, derive the default from resource */

Line 306: FND_MSG_PUB.ADD;

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;
310: CLOSE Cur_get_resource_usage_uom;

Line 318: FND_MSG_PUB.ADD;

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;
322: CLOSE check_uom;

Line 334: FND_MSG_PUB.ADD;

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;
338: CLOSE check_cost_cmpntcls_id;

Line 352: FND_MSG_PUB.ADD;

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;
356: CLOSE check_cost_analysis_code;

Line 375: FND_MSG_PUB.ADD;

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

Line 389: FND_MSG_PUB.ADD;

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:
393: /* Scale Type must be passed, otherwise give error */

Line 451: FND_MSG_PUB.count_and_get(p_count => x_message_count

447: COMMIT;
448: END IF;
449: END IF;
450:
451: FND_MSG_PUB.count_and_get(p_count => x_message_count
452: ,p_data => x_message_list);
453:
454: IF (l_debug = 'Y') THEN
455: gmd_debug.put_line('End of insert_operation_resource PUB');

Line 461: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

457: EXCEPTION
458: WHEN setup_failure OR invalid_version OR inv_resource_ind THEN
459: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
462: P_data => x_message_list);
463: WHEN ins_oprn_rsrc_err THEN
464: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
465: x_return_status := FND_API.G_RET_STS_ERROR;

Line 466: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

462: P_data => x_message_list);
463: WHEN ins_oprn_rsrc_err THEN
464: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
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;

Line 473: FND_MSG_PUB.ADD;

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;
477:

Line 474: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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;
477:
478: /*========================================================

Line 526: fnd_msg_pub.initialize;

522: END IF;
523:
524: /* Initialize message list and count if needed */
525: IF p_init_msg_list THEN
526: fnd_msg_pub.initialize;
527: END IF;
528:
529: IF NOT gmd_api_grp.setup_done THEN
530: gmd_api_grp.setup_done := gmd_api_grp.setup;

Line 544: FND_MSG_PUB.ADD;

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);
548: FETCH check_oprn_line_id INTO l_exist;

Line 551: FND_MSG_PUB.ADD;

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;
555: CLOSE check_oprn_line_id;

Line 562: FND_MSG_PUB.ADD;

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);
566: FETCH check_resource INTO l_exist;

Line 570: FND_MSG_PUB.ADD;

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;
574: CLOSE check_resource;

Line 583: FND_MSG_PUB.ADD;

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');
587: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');

Line 588: 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);
592: FETCH check_cost_analysis_code INTO l_exist;

Line 595: FND_MSG_PUB.ADD;

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;
599: CLOSE check_cost_analysis_code;

Line 616: FND_MSG_PUB.ADD;

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;
620: CLOSE check_uom;

Line 626: FND_MSG_PUB.ADD;

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;
630: CLOSE check_cost_cmpntcls_id;

Line 691: FND_MSG_PUB.ADD;

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:
695: IF x_return_status = 'S' THEN

Line 714: FND_MSG_PUB.count_and_get(p_count => x_message_count

710: COMMIT;
711: END IF;
712: END IF;
713:
714: FND_MSG_PUB.count_and_get(p_count => x_message_count
715: ,p_data => x_message_list);
716:
717: IF (l_debug = 'Y') THEN
718: gmd_debug.put_line('END of update_operation_resource PUB');

Line 725: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

721: EXCEPTION
722: WHEN invalid_version OR setup_failure THEN
723: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
726: P_data => x_message_list);
727: WHEN upd_oprn_rsrc_err THEN
728: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
729: x_return_status := FND_API.G_RET_STS_ERROR;

Line 730: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

726: P_data => x_message_list);
727: WHEN upd_oprn_rsrc_err THEN
728: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
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;

Line 737: FND_MSG_PUB.ADD;

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;
741:

Line 738: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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;
741:
742: /*=============================================================

Line 794: fnd_msg_pub.initialize;

790: x_return_status := FND_API.g_ret_sts_success;
791:
792: /* Initialize message list and count if needed */
793: IF p_init_msg_list THEN
794: fnd_msg_pub.initialize;
795: END IF;
796:
797: /* Make sure we are call compatible */
798: IF NOT FND_API.compatible_api_call(l_api_version

Line 820: FND_MSG_PUB.ADD;

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);
824: FETCH check_oprn_line_id INTO v_count;

Line 828: FND_MSG_PUB.ADD;

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
832: OPEN check_resource(p_oprn_line_id, p_resources);

Line 837: FND_MSG_PUB.ADD;

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

Line 890: FND_MSG_PUB.count_and_get(p_count => x_message_count

886: COMMIT;
887: END IF;
888: END IF;
889:
890: FND_MSG_PUB.count_and_get(p_count => x_message_count
891: ,p_data => x_message_list);
892:
893: IF (l_debug = 'Y') THEN
894: gmd_debug.put_line('END of delete_operation_resources PUB');

Line 901: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

897: EXCEPTION
898: WHEN invalid_version OR setup_failure OR inv_resource_ind THEN
899: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
902: P_data => x_message_list);
903: WHEN del_oprn_rsrc_err THEN
904: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
905: x_return_status := FND_API.G_RET_STS_ERROR;

Line 906: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

902: P_data => x_message_list);
903: WHEN del_oprn_rsrc_err THEN
904: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
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;

Line 913: FND_MSG_PUB.ADD;

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;
917:

Line 914: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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;
917:
918: END GMD_OPERATION_RESOURCES_PUB;