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 256: FND_MSG_PUB.count_and_get(p_count => x_message_count

252: COMMIT;
253: END IF;
254: END IF;
255:
256: FND_MSG_PUB.count_and_get(p_count => x_message_count
257: ,p_data => x_message_list);
258: EXCEPTION
259: WHEN setup_failure OR invalid_version THEN
260: ROLLBACK TO SAVEPOINT insert_oprn_actv;

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

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

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

263: P_data => x_message_list);
264: WHEN ins_oprn_actv_err THEN
265: ROLLBACK TO SAVEPOINT insert_oprn_actv;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list);
269: WHEN OTHERS THEN
270: ROLLBACK TO SAVEPOINT insert_oprn_actv;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 274: FND_MSG_PUB.ADD;

270: ROLLBACK TO SAVEPOINT insert_oprn_actv;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
274: FND_MSG_PUB.ADD;
275: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
276: P_data => x_message_list);
277: END insert_operation_activity;
278:

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

271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
274: FND_MSG_PUB.ADD;
275: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
276: P_data => x_message_list);
277: END insert_operation_activity;
278:
279: /*===============================================

Line 315: fnd_msg_pub.initialize;

311: SAVEPOINT upd_oprn_actv;
312:
313: /* Initialize message list and count if needed */
314: IF p_init_msg_list THEN
315: fnd_msg_pub.initialize;
316: END IF;
317:
318: /* Initially let us assign the return status to success */
319: x_return_status := FND_API.g_ret_sts_success;

Line 348: FND_MSG_PUB.ADD;

344: END IF;
345:
346: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
347: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
348: FND_MSG_PUB.ADD;
349: RAISE upd_oprn_actv_err;
350: END IF;
351:
352: /* Loop thru cols to be updated - verify col and value are present */

Line 362: FND_MSG_PUB.ADD;

358: END IF;
359:
360: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
361: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
362: FND_MSG_PUB.ADD;
363: RAISE upd_oprn_actv_err;
364: ELSIF p_update_table(i).p_value IS NULL THEN
365: IF (l_debug = 'Y') THEN
366: gmd_debug.put_line('value required');

Line 371: FND_MSG_PUB.ADD;

367: END IF;
368:
369: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
370: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
371: FND_MSG_PUB.ADD;
372: RAISE upd_oprn_actv_err;
373: END IF;
374: END LOOP;
375:

Line 397: FND_MSG_PUB.ADD;

393:
394: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED(Entity => 'OPERATION',
395: Entity_id => v_oprn_id ) THEN
396: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
397: FND_MSG_PUB.ADD;
398: RAISE upd_oprn_actv_err;
399: END IF;
400:
401: /* delete_mark validation */

Line 418: FND_MSG_PUB.ADD;

414: RAISE upd_oprn_actv_err;
415: ELSIF (UPPER(p_update_table(a).p_col_to_update) = 'SEQUENCE_DEPENDENT_IND' AND
416: p_update_table(a).p_value NOT IN (1,0)) THEN
417: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_SEQ_DEP_IND');
418: FND_MSG_PUB.ADD;
419: RAISE upd_oprn_actv_err;
420: END IF;
421: END LOOP;
422:

Line 444: FND_MSG_PUB.count_and_get(p_count => x_message_count

440: END IF;
441:
442: END IF;
443:
444: FND_MSG_PUB.count_and_get(p_count => x_message_count
445: ,p_data => x_message_list);
446:
447: EXCEPTION
448: WHEN setup_failure OR invalid_version THEN

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

447: EXCEPTION
448: WHEN setup_failure OR invalid_version THEN
449: ROLLBACK TO SAVEPOINT upd_oprn_actv;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
452: P_data => x_message_list);
453: WHEN upd_oprn_actv_err THEN
454: ROLLBACK TO SAVEPOINT upd_oprn_actv;
455: x_return_status := FND_API.G_RET_STS_ERROR;

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

452: P_data => x_message_list);
453: WHEN upd_oprn_actv_err THEN
454: ROLLBACK TO SAVEPOINT upd_oprn_actv;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
457: P_data => x_message_list);
458:
459: WHEN OTHERS THEN
460: ROLLBACK TO SAVEPOINT upd_oprn_actv;

Line 464: FND_MSG_PUB.ADD;

460: ROLLBACK TO SAVEPOINT upd_oprn_actv;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
463: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
464: FND_MSG_PUB.ADD;
465: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
466: P_data => x_message_list);
467:
468:

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

461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
463: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
464: FND_MSG_PUB.ADD;
465: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
466: P_data => x_message_list);
467:
468:
469: END update_operation_activity;

Line 512: fnd_msg_pub.initialize;

508: SAVEPOINT delete_oprn_actv;
509:
510: /* Initialize message list and count if needed */
511: IF p_init_msg_list THEN
512: fnd_msg_pub.initialize;
513: END IF;
514:
515: /* Initially let us assign the return status to success */
516: x_return_status := FND_API.g_ret_sts_success;

Line 547: FND_MSG_PUB.ADD;

543: END IF;
544:
545: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
546: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_LINE_ID');
547: FND_MSG_PUB.ADD;
548: RAISE del_oprn_actv_err;
549: ELSE
550: OPEN chk_oprn_line_id(p_oprn_line_id);
551: FETCH chk_oprn_line_Id INTO l_oprn_id;

Line 554: FND_MSG_PUB.ADD;

550: OPEN chk_oprn_line_id(p_oprn_line_id);
551: FETCH chk_oprn_line_Id INTO l_oprn_id;
552: IF chk_oprn_line_ID%NOTFOUND THEN
553: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPRNLINE_ID');
554: FND_MSG_PUB.ADD;
555: RAISE del_oprn_actv_err;
556: ELSE
557: OPEN get_activity_count (l_oprn_id);
558: FETCH get_activity_count INTO v_count;

Line 591: FND_MSG_PUB.count_and_get(p_count => x_message_count

587: COMMIT;
588: END IF;
589: END IF;
590:
591: FND_MSG_PUB.count_and_get(p_count => x_message_count
592: ,p_data => x_message_list);
593:
594: EXCEPTION
595: WHEN setup_failure OR invalid_version THEN

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

594: EXCEPTION
595: WHEN setup_failure OR invalid_version THEN
596: ROLLBACK TO SAVEPOINT delete_oprn_actv;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
599: P_data => x_message_list);
600: WHEN del_oprn_actv_err THEN
601: ROLLBACK TO SAVEPOINT delete_oprn_actv;
602: x_return_status := FND_API.G_RET_STS_ERROR;

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

599: P_data => x_message_list);
600: WHEN del_oprn_actv_err THEN
601: ROLLBACK TO SAVEPOINT delete_oprn_actv;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
604: P_data => x_message_list);
605: WHEN OTHERS THEN
606: ROLLBACK TO SAVEPOINT delete_oprn_actv;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 610: FND_MSG_PUB.ADD;

606: ROLLBACK TO SAVEPOINT delete_oprn_actv;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
609: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
612: P_data => x_message_list);
613: END delete_operation_activity;
614:

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

607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
609: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
612: P_data => x_message_list);
613: END delete_operation_activity;
614:
615: END GMD_OPERATION_ACTIVITIES_PUB;