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 272: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

458:
459: WHEN OTHERS THEN
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);

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

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

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

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

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

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

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

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

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

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

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

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