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_ACTIVITIES_PUB dependencies on FND_MSG_PUB

Line 105: fnd_msg_pub.initialize;

101: SAVEPOINT insert_oprn_actv;
102:
103: /* Initialize message list and count if needed */
104: IF p_init_msg_list THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: IF (l_debug = 'Y') THEN
109: gmd_debug.put_line('In insert_operation_activity public.');

Line 135: FND_MSG_PUB.ADD;

131: IF (p_oprn_activity.oprn_id IS NULL) THEN
132: IF ((p_oprn_no IS NULL) OR (p_oprn_vers IS NULL)) THEN
133: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
134: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');
135: FND_MSG_PUB.ADD;
136: ELSE
137: OPEN check_oprn_no_vers(p_oprn_no, p_oprn_vers);
138: FETCH check_oprn_no_vers INTO v_oprn_id;
139: IF check_oprn_no_vers%NOTFOUND THEN

Line 142: FND_MSG_PUB.ADD;

138: FETCH check_oprn_no_vers INTO v_oprn_id;
139: IF check_oprn_no_vers%NOTFOUND THEN
140: /* must pass existing operation no and vers */
141: FND_MESSAGE.SET_NAME('GMD','FM_INVOPRN');
142: FND_MSG_PUB.ADD;
143: RAISE ins_oprn_actv_err;
144: END IF;
145: CLOSE check_oprn_no_vers;
146: END IF;

Line 167: FND_MSG_PUB.ADD;

163: END IF;
164:
165: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
166: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');
167: FND_MSG_PUB.ADD;
168: RAISE ins_oprn_actv_err;
169: ELSE
170: v_activity := p_oprn_activity.activity;
171: OPEN check_activity(v_activity);

Line 176: FND_MSG_PUB.ADD;

172: FETCH check_activity INTO v_count;
173: IF check_activity%NOTFOUND THEN
174: /* must pass existing activity */
175: FND_MESSAGE.SET_NAME('GMD','FM_INVACTIVITY');
176: FND_MSG_PUB.ADD;
177: RAISE ins_oprn_actv_err;
178: END IF;
179: CLOSE check_activity;
180: END IF;

Line 205: FND_MSG_PUB.ADD;

201: IF p_oprn_activity.sequence_dependent_ind IS NULL THEN
202: p_oprn_activity.sequence_dependent_ind := 0;
203: ELSIF p_oprn_activity.sequence_dependent_ind NOT IN (1,0) THEN
204: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_SEQ_DEP_IND');
205: FND_MSG_PUB.ADD;
206: RAISE ins_oprn_actv_err;
207: END IF;
208:
209: /* generate oprnline_id */

Line 250: FND_MSG_PUB.count_and_get(p_count => x_message_count

246: COMMIT;
247: END IF;
248: END IF;
249:
250: FND_MSG_PUB.count_and_get(p_count => x_message_count
251: ,p_data => x_message_list);
252: EXCEPTION
253: WHEN setup_failure OR invalid_version THEN
254: ROLLBACK TO SAVEPOINT insert_oprn_actv;

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

252: EXCEPTION
253: WHEN setup_failure OR invalid_version THEN
254: ROLLBACK TO SAVEPOINT insert_oprn_actv;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
257: P_data => x_message_list);
258: WHEN ins_oprn_actv_err THEN
259: ROLLBACK TO SAVEPOINT insert_oprn_actv;
260: x_return_status := FND_API.G_RET_STS_ERROR;

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

257: P_data => x_message_list);
258: WHEN ins_oprn_actv_err THEN
259: ROLLBACK TO SAVEPOINT insert_oprn_actv;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
262: P_data => x_message_list);
263: WHEN OTHERS THEN
264: ROLLBACK TO SAVEPOINT insert_oprn_actv;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 268: FND_MSG_PUB.ADD;

264: ROLLBACK TO SAVEPOINT insert_oprn_actv;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
267: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
268: FND_MSG_PUB.ADD;
269: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
270: P_data => x_message_list);
271: END insert_operation_activity;
272:

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

265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
267: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
268: FND_MSG_PUB.ADD;
269: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
270: P_data => x_message_list);
271: END insert_operation_activity;
272:
273: /*===============================================

Line 309: fnd_msg_pub.initialize;

305: SAVEPOINT upd_oprn_actv;
306:
307: /* Initialize message list and count if needed */
308: IF p_init_msg_list THEN
309: fnd_msg_pub.initialize;
310: END IF;
311:
312: /* Initially let us assign the return status to success */
313: x_return_status := FND_API.g_ret_sts_success;

Line 342: FND_MSG_PUB.ADD;

338: END IF;
339:
340: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
341: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
342: FND_MSG_PUB.ADD;
343: RAISE upd_oprn_actv_err;
344: END IF;
345:
346: /* Loop thru cols to be updated - verify col and value are present */

Line 356: FND_MSG_PUB.ADD;

352: END IF;
353:
354: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
355: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
356: FND_MSG_PUB.ADD;
357: RAISE upd_oprn_actv_err;
358: ELSIF p_update_table(i).p_value IS NULL THEN
359: IF (l_debug = 'Y') THEN
360: gmd_debug.put_line('value required');

Line 365: FND_MSG_PUB.ADD;

361: END IF;
362:
363: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
364: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
365: FND_MSG_PUB.ADD;
366: RAISE upd_oprn_actv_err;
367: END IF;
368: END LOOP;
369:

Line 391: FND_MSG_PUB.ADD;

387:
388: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',
389: Entity_id => v_oprn_id ) THEN
390: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
391: FND_MSG_PUB.ADD;
392: RAISE upd_oprn_actv_err;
393: END IF;
394:
395: /* delete_mark validation */

Line 412: FND_MSG_PUB.ADD;

408: RAISE upd_oprn_actv_err;
409: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'SEQUENCE_DEPENDENT_IND' AND
410: p_update_table(a).p_value NOT IN (1,0)) THEN
411: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_SEQ_DEP_IND');
412: FND_MSG_PUB.ADD;
413: RAISE upd_oprn_actv_err;
414: END IF;
415: END LOOP;
416:

Line 433: FND_MSG_PUB.count_and_get(p_count => x_message_count

429: END IF;
430:
431: END IF;
432:
433: FND_MSG_PUB.count_and_get(p_count => x_message_count
434: ,p_data => x_message_list);
435:
436: EXCEPTION
437: WHEN setup_failure OR invalid_version THEN

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

436: EXCEPTION
437: WHEN setup_failure OR invalid_version THEN
438: ROLLBACK TO SAVEPOINT upd_oprn_actv;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
441: P_data => x_message_list);
442: WHEN upd_oprn_actv_err THEN
443: ROLLBACK TO SAVEPOINT upd_oprn_actv;
444: x_return_status := FND_API.G_RET_STS_ERROR;

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

441: P_data => x_message_list);
442: WHEN upd_oprn_actv_err THEN
443: ROLLBACK TO SAVEPOINT upd_oprn_actv;
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
446: P_data => x_message_list);
447:
448: WHEN OTHERS THEN
449: ROLLBACK TO SAVEPOINT upd_oprn_actv;

Line 453: FND_MSG_PUB.ADD;

449: ROLLBACK TO SAVEPOINT upd_oprn_actv;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
452: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
453: FND_MSG_PUB.ADD;
454: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
455: P_data => x_message_list);
456:
457:

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

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
452: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
453: FND_MSG_PUB.ADD;
454: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
455: P_data => x_message_list);
456:
457:
458: END update_operation_activity;

Line 501: fnd_msg_pub.initialize;

497: SAVEPOINT delete_oprn_actv;
498:
499: /* Initialize message list and count if needed */
500: IF p_init_msg_list THEN
501: fnd_msg_pub.initialize;
502: END IF;
503:
504: /* Initially let us assign the return status to success */
505: x_return_status := FND_API.g_ret_sts_success;

Line 536: FND_MSG_PUB.ADD;

532: END IF;
533:
534: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
535: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
536: FND_MSG_PUB.ADD;
537: RAISE del_oprn_actv_err;
538: ELSE
539: OPEN chk_oprn_line_id(p_oprn_line_id);
540: FETCH chk_oprn_line_Id INTO l_oprn_id;

Line 543: FND_MSG_PUB.ADD;

539: OPEN chk_oprn_line_id(p_oprn_line_id);
540: FETCH chk_oprn_line_Id INTO l_oprn_id;
541: IF chk_oprn_line_ID%NOTFOUND THEN
542: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');
543: FND_MSG_PUB.ADD;
544: RAISE del_oprn_actv_err;
545: ELSE
546: OPEN get_activity_count (l_oprn_id);
547: FETCH get_activity_count INTO v_count;

Line 580: FND_MSG_PUB.count_and_get(p_count => x_message_count

576: COMMIT;
577: END IF;
578: END IF;
579:
580: FND_MSG_PUB.count_and_get(p_count => x_message_count
581: ,p_data => x_message_list);
582:
583: EXCEPTION
584: WHEN setup_failure OR invalid_version THEN

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

583: EXCEPTION
584: WHEN setup_failure OR invalid_version THEN
585: ROLLBACK TO SAVEPOINT delete_oprn_actv;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
588: P_data => x_message_list);
589: WHEN del_oprn_actv_err THEN
590: ROLLBACK TO SAVEPOINT delete_oprn_actv;
591: x_return_status := FND_API.G_RET_STS_ERROR;

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

588: P_data => x_message_list);
589: WHEN del_oprn_actv_err THEN
590: ROLLBACK TO SAVEPOINT delete_oprn_actv;
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
593: P_data => x_message_list);
594: WHEN OTHERS THEN
595: ROLLBACK TO SAVEPOINT delete_oprn_actv;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 599: FND_MSG_PUB.ADD;

595: ROLLBACK TO SAVEPOINT delete_oprn_actv;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
598: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
599: FND_MSG_PUB.ADD;
600: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
601: P_data => x_message_list);
602: END delete_operation_activity;
603:

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

596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
598: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
599: FND_MSG_PUB.ADD;
600: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
601: P_data => x_message_list);
602: END delete_operation_activity;
603:
604: END GMD_OPERATION_ACTIVITIES_PUB;