DBA Data[Home] [Help]

APPS.GMD_OPERATION_ACTIVITIES_PUB dependencies on FND_MESSAGE

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

129:
130: /* Operation number ID must be passed, otherwise give error, also check operation exists */
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);

Line 134: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');

130: /* Operation number ID must be passed, otherwise give error, also check operation exists */
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;

Line 141: FND_MESSAGE.SET_NAME('GMD','FM_INVOPRN');

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

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

161: IF (l_debug = 'Y') THEN
162: gmd_debug.put_line('operation activity required');
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

Line 166: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');

162: gmd_debug.put_line('operation activity required');
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;

Line 175: FND_MESSAGE.SET_NAME('GMD','FM_INVACTIVITY');

171: OPEN check_activity(v_activity);
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;

Line 204: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_SEQ_DEP_IND');

200: /* check sequence_dependent_ind has a value else default */
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:

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

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;
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);

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

263: WHEN OTHERS THEN
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;

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

336: IF (l_debug = 'Y') THEN
337: gmd_debug.put_line('operation line id is required');
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;

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

337: gmd_debug.put_line('operation line id is required');
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:

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

350: IF (l_debug = 'Y') THEN
351: gmd_debug.put_line('col_to_update required');
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

Line 355: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');

351: gmd_debug.put_line('col_to_update required');
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

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

359: IF (l_debug = 'Y') THEN
360: gmd_debug.put_line('value required');
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;

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

360: gmd_debug.put_line('value required');
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;

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

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

Line 411: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_SEQ_DEP_IND');

407: 'FIELD', p_update_table(a).p_col_to_update);
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;

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

447:
448: WHEN OTHERS THEN
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);

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

448: WHEN OTHERS THEN
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:

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

530: IF (l_debug = 'Y') THEN
531: gmd_debug.put_line('Operation Line id is required');
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

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

531: gmd_debug.put_line('Operation Line id is required');
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);

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

538: ELSE
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);

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

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;
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);

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

594: WHEN OTHERS THEN
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;