DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ACTION_PVT dependencies on FND_MESSAGE

Line 267: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_NULL');

263: END IF;
264:
265: IF p_x_mr_action_rec.mr_action is null OR p_x_mr_action_rec.mr_action=FND_API.G_MISS_CHAR
266: THEN
267: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_NULL');
268: FND_MSG_PUB.ADD;
269: ELSE
270: OPEN get_lookup_meaning_to_code('AHL_FMP_MR_ACTION',p_x_mr_action_rec.MR_ACTION);
271: FETCH get_lookup_meaning_to_code INTO p_x_mr_action_rec.MR_ACTION_CODE;

Line 275: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_INVALID');

271: FETCH get_lookup_meaning_to_code INTO p_x_mr_action_rec.MR_ACTION_CODE;
272:
273: IF get_lookup_meaning_to_code%NOTFOUND
274: THEN
275: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_INVALID');
276: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
277: FND_MESSAGE.SET_TOKEN('RECORD',nvl(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
278: FND_MSG_PUB.ADD;
279: END IF;

Line 276: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);

272:
273: IF get_lookup_meaning_to_code%NOTFOUND
274: THEN
275: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_INVALID');
276: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
277: FND_MESSAGE.SET_TOKEN('RECORD',nvl(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
278: FND_MSG_PUB.ADD;
279: END IF;
280: CLOSE get_lookup_meaning_to_code;

Line 277: FND_MESSAGE.SET_TOKEN('RECORD',nvl(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);

273: IF get_lookup_meaning_to_code%NOTFOUND
274: THEN
275: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_INVALID');
276: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
277: FND_MESSAGE.SET_TOKEN('RECORD',nvl(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
278: FND_MSG_PUB.ADD;
279: END IF;
280: CLOSE get_lookup_meaning_to_code;
281: END IF;

Line 292: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PLAN_ID_INVALID');

288: OPEN get_planid_frm_name(p_x_mr_action_rec.PLAN);
289: FETCH get_planid_frm_name INTO p_x_mr_action_rec.PLAN_ID;
290: IF get_planid_frm_name%NOTFOUND
291: THEN
292: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PLAN_ID_INVALID');
293: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
294: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
295: FND_MSG_PUB.ADD;
296: END IF;

Line 293: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);

289: FETCH get_planid_frm_name INTO p_x_mr_action_rec.PLAN_ID;
290: IF get_planid_frm_name%NOTFOUND
291: THEN
292: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PLAN_ID_INVALID');
293: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
294: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
295: FND_MSG_PUB.ADD;
296: END IF;
297: CLOSE get_planid_frm_name;

Line 294: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);

290: IF get_planid_frm_name%NOTFOUND
291: THEN
292: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PLAN_ID_INVALID');
293: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_action_rec.MR_ACTION,false);
294: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_x_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_x_mr_action_rec.description,'')||'-'||NVL(p_x_mr_action_rec.plan,''),false);
295: FND_MSG_PUB.ADD;
296: END IF;
297: CLOSE get_planid_frm_name;
298:

Line 347: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_ID_NULL');

343: IF p_mr_action_rec.dml_operation<>'C'
344: THEN
345: IF (p_mr_action_rec.MR_ACTION_ID IS NULL OR p_mr_action_rec.MR_ACTION_ID=FND_API.G_MISS_NUM)
346: THEN
347: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_ID_NULL');
348: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
349: FND_MSG_PUB.ADD;
350: END IF;
351: END IF;

Line 348: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);

344: THEN
345: IF (p_mr_action_rec.MR_ACTION_ID IS NULL OR p_mr_action_rec.MR_ACTION_ID=FND_API.G_MISS_NUM)
346: THEN
347: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_ID_NULL');
348: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
349: FND_MSG_PUB.ADD;
350: END IF;
351: END IF;
352:

Line 360: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_RECORD_CHANGED');

356: FETCH get_ACTION_id INTO l_mr_action_id;
357:
358: IF GET_ACTION_ID%NOTFOUND
359: THEN
360: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_RECORD_CHANGED');
361: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
362: FND_MSG_PUB.ADD;
363: END IF;
364: CLOSE get_ACTION_id;

Line 361: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);

357:
358: IF GET_ACTION_ID%NOTFOUND
359: THEN
360: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_RECORD_CHANGED');
361: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
362: FND_MSG_PUB.ADD;
363: END IF;
364: CLOSE get_ACTION_id;
365: END IF;

Line 369: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');

365: END IF;
366:
367: IF (p_mr_action_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_action_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_num)
368: THEN
369: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
370: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
371: FND_MSG_PUB.ADD;
372: END IF;
373:

Line 370: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);

366:
367: IF (p_mr_action_rec.OBJECT_VERSION_NUMBER IS NULL OR p_mr_action_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_num)
368: THEN
369: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MRA_OBJ_VERSION_NULL');
370: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
371: FND_MSG_PUB.ADD;
372: END IF;
373:
374: IF p_mr_action_rec.dml_operation<>'D'

Line 379: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');

375: THEN
376:
377: IF p_mr_action_rec.MR_HEADER_ID IS NULL OR p_mr_action_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
378: THEN
379: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
380: FND_MSG_PUB.ADD;
381: ELSE
382: OPEN GetMrDet(p_mr_action_rec.MR_HEADER_ID);
383:

Line 388: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_EDIT_STATUS_INVALID');

384: FETCH GetMrDet into l_mr_rec;
385:
386: IF GetMrDet%NOTFOUND
387: THEN
388: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_EDIT_STATUS_INVALID');
389: FND_MSG_PUB.ADD;
390: ELSE
391: IF G_PM_INSTALL='Y'
392: THEN

Line 395: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TYPE_CODE_PROGRAM');

391: IF G_PM_INSTALL='Y'
392: THEN
393: IF l_mr_rec.TYPE_CODE='PROGRAM'
394: THEN
395: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TYPE_CODE_PROGRAM');
396: FND_MSG_PUB.ADD;
397: END IF;
398: END IF;
399: END IF;

Line 410: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');

406: IF CHECK_DUP_ACTION_CODE%FOUND
407: THEN
408: IF p_mr_action_rec.dml_operation='C'
409: THEN
410: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');
411: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
412: FND_MSG_PUB.ADD;
413: ELSIF p_mr_action_rec.dml_operation='U'
414: and l_act_Rec.mr_action_id<>p_mr_action_rec.MR_ACTION_ID

Line 411: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);

407: THEN
408: IF p_mr_action_rec.dml_operation='C'
409: THEN
410: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');
411: FND_MESSAGE.SET_TOKEN('RECORD',NVL(p_mr_action_rec.MR_ACTION,'')||'-'||NVL(p_mr_action_rec.description,'')||'-'||NVL(p_mr_action_rec.plan,''),false);
412: FND_MSG_PUB.ADD;
413: ELSIF p_mr_action_rec.dml_operation='U'
414: and l_act_Rec.mr_action_id<>p_mr_action_rec.MR_ACTION_ID
415: THEN

Line 416: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');

412: FND_MSG_PUB.ADD;
413: ELSIF p_mr_action_rec.dml_operation='U'
414: and l_act_Rec.mr_action_id<>p_mr_action_rec.MR_ACTION_ID
415: THEN
416: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');
417: FND_MESSAGE.SET_TOKEN('ACTION',p_mr_action_rec.MR_ACTION,false);
418: FND_MSG_PUB.ADD;
419: END IF;
420: END IF;

Line 417: FND_MESSAGE.SET_TOKEN('ACTION',p_mr_action_rec.MR_ACTION,false);

413: ELSIF p_mr_action_rec.dml_operation='U'
414: and l_act_Rec.mr_action_id<>p_mr_action_rec.MR_ACTION_ID
415: THEN
416: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ACTION_CODE_DUP');
417: FND_MESSAGE.SET_TOKEN('ACTION',p_mr_action_rec.MR_ACTION,false);
418: FND_MSG_PUB.ADD;
419: END IF;
420: END IF;
421: CLOSE CHECK_DUP_ACTION_CODE;

Line 563: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

559: where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID;
560:
561: if (sql%ROWCOUNT=0)
562: then
563: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
564: FND_MSG_PUB.ADD;
565: else
566: delete from AHL_MR_ACTIONS_B
567: where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID

Line 571: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

567: where MR_ACTION_ID = p_x_mr_ACTION_TBL(i).MR_ACTION_ID
568: AND OBJECT_VERSION_NUMBER=p_x_mr_ACTION_TBL(i).OBJECT_VERSION_NUMBER;
569:
570: if (sql%ROWCOUNT=0) then
571: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
572: FND_MSG_PUB.ADD;
573: end if;
574: end if;
575: ELSIF p_x_mr_ACTION_TBL(i).DML_operation='U' then