DBA Data[Home] [Help]

APPS.AHL_FMP_PROGTYPE_SUBTYPE_PVT dependencies on FND_MESSAGE

Line 310: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PT_OBJ_VERSION_NULL');

306:
307: IF p_x_prog_type_subtype_rec.object_version_number is null or
308: p_x_prog_type_subtype_rec.object_version_number =FND_API.G_MISS_NUM
309: THEN
310: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PT_OBJ_VERSION_NULL');
311: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
312: FND_MSG_PUB.ADD;
313: END IF;
314:

Line 311: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);

307: IF p_x_prog_type_subtype_rec.object_version_number is null or
308: p_x_prog_type_subtype_rec.object_version_number =FND_API.G_MISS_NUM
309: THEN
310: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PT_OBJ_VERSION_NULL');
311: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
312: FND_MSG_PUB.ADD;
313: END IF;
314:
315: IF p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID is null or

Line 318: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_ID_NULL');

314:
315: IF p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID is null or
316: p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID =fnd_api.g_miss_num
317: THEN
318: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_ID_NULL');
319: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
320: FND_MSG_PUB.ADD;
321: END IF;
322: END IF;

Line 319: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);

315: IF p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID is null or
316: p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID =fnd_api.g_miss_num
317: THEN
318: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_ID_NULL');
319: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
320: FND_MSG_PUB.ADD;
321: END IF;
322: END IF;
323:

Line 329: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGTYPE_NULL');

325: THEN
326: IF p_x_prog_type_subtype_rec.PROGRAM_TYPE is null or
327: p_x_prog_type_subtype_rec.PROGRAM_TYPE=FND_API.G_MISS_CHAR
328: THEN
329: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGTYPE_NULL');
330: FND_MSG_PUB.ADD;
331: l_check_flag:='N';
332: ELSE
333: l_check_flag:='Y';

Line 339: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_NULL');

335:
336: IF p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE is null or
337: p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE=FND_API.G_MISS_char
338: THEN
339: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_NULL');
340: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);
341: FND_MSG_PUB.ADD;
342: l_check_flag:='N';
343: ELSE

Line 340: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);

336: IF p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE is null or
337: p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE=FND_API.G_MISS_char
338: THEN
339: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_NULL');
340: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);
341: FND_MSG_PUB.ADD;
342: l_check_flag:='N';
343: ELSE
344: l_check_flag:='Y';

Line 355: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');

351: OPEN get_lookup_meaning_to_code('AHL_FMP_MR_PROGRAM_TYPE',p_x_prog_type_subtype_rec.PROGRAM_TYPE);
352: FETCH get_lookup_meaning_to_code INTO l_lookup_code;
353: IF get_lookup_meaning_to_code%NOTFOUND
354: THEN
355: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');
356: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);
357: FND_MSG_PUB.ADD;
358: ELSE
359: p_x_prog_type_subtype_rec.PROGRAM_TYPE_CODE:=l_lookup_code;

Line 356: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);

352: FETCH get_lookup_meaning_to_code INTO l_lookup_code;
353: IF get_lookup_meaning_to_code%NOTFOUND
354: THEN
355: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');
356: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prog_type_subtype_rec.PROGRAM_TYPE,false);
357: FND_MSG_PUB.ADD;
358: ELSE
359: p_x_prog_type_subtype_rec.PROGRAM_TYPE_CODE:=l_lookup_code;
360: END IF;

Line 371: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_INVALID');

367: p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE);
368: FETCH get_lookup_meaning_to_code INTO l_lookup_code;
369: IF get_lookup_meaning_to_code%NOTFOUND
370: THEN
371: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_INVALID');
372: FND_MESSAGE.SET_TOKEN('FIELD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
373: FND_MSG_PUB.ADD;
374: ELSE
375: p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE_CODE:=l_lookup_code;

Line 372: FND_MESSAGE.SET_TOKEN('FIELD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);

368: FETCH get_lookup_meaning_to_code INTO l_lookup_code;
369: IF get_lookup_meaning_to_code%NOTFOUND
370: THEN
371: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROGSUBTYPE_INVALID');
372: FND_MESSAGE.SET_TOKEN('FIELD',p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
373: FND_MSG_PUB.ADD;
374: ELSE
375: p_x_prog_type_subtype_rec.PROGRAM_SUBTYPE_CODE:=l_lookup_code;
376: END IF;

Line 448: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_OBJ_VERSION_NULL');

444:
445: IF p_prog_type_subtype_rec.object_version_number is null
446: or p_prog_type_subtype_rec.object_version_number=FND_API.G_MISS_NUM
447: THEN
448: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_OBJ_VERSION_NULL');
449: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
450: FND_MSG_PUB.ADD;
451: END IF;
452:

Line 449: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);

445: IF p_prog_type_subtype_rec.object_version_number is null
446: or p_prog_type_subtype_rec.object_version_number=FND_API.G_MISS_NUM
447: THEN
448: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_OBJ_VERSION_NULL');
449: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE,false);
450: FND_MSG_PUB.ADD;
451: END IF;
452:
453: IF p_prog_type_subtype_rec.dml_operation<>'D'

Line 458: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');

454: THEN
455: IF p_prog_type_subtype_rec.PROGRAM_TYPE is null
456: or p_prog_type_subtype_rec.PROGRAM_TYPE=FND_API.G_MISS_char
457: THEN
458: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');
459: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_TYPE,false);
460: FND_MSG_PUB.ADD;
461: l_check_flag:='N';
462: ELSE

Line 459: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_TYPE,false);

455: IF p_prog_type_subtype_rec.PROGRAM_TYPE is null
456: or p_prog_type_subtype_rec.PROGRAM_TYPE=FND_API.G_MISS_char
457: THEN
458: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PROG_TYPE_INVALID');
459: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_TYPE,false);
460: FND_MSG_PUB.ADD;
461: l_check_flag:='N';
462: ELSE
463: l_check_flag:='Y';

Line 475: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SUBTYPE_DUP');

471: FETCH check_prog_subtype INTO l_counter;
472:
473: IF l_counter>0 and p_prog_type_subtype_rec.dml_operation<>'D'
474: THEN
475: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SUBTYPE_DUP');
476: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE, false);
477: FND_MSG_PUB.ADD;
478: END IF;
479: CLOSE check_prog_subtype; */

Line 476: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE, false);

472:
473: IF l_counter>0 and p_prog_type_subtype_rec.dml_operation<>'D'
474: THEN
475: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SUBTYPE_DUP');
476: FND_MESSAGE.SET_TOKEN('RECORD',p_prog_type_subtype_rec.PROGRAM_SUBTYPE, false);
477: FND_MSG_PUB.ADD;
478: END IF;
479: CLOSE check_prog_subtype; */
480: ELSE

Line 498: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_DEL_SUBTYP_MR');

494: SELECT PROGRAM_SUBTYPE_CODE into l_prog_sub_type
495: FROM AHL_PROG_TYPE_SUBTYPES
496: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID;
497:
498: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_DEL_SUBTYP_MR');
499: FND_MESSAGE.SET_TOKEN('RECORD',l_prog_sub_type,false);
500: FND_MSG_PUB.ADD;
501: end if;
502: --END

Line 499: FND_MESSAGE.SET_TOKEN('RECORD',l_prog_sub_type,false);

495: FROM AHL_PROG_TYPE_SUBTYPES
496: WHERE PROG_TYPE_SUBTYPE_ID = p_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID;
497:
498: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_DEL_SUBTYP_MR');
499: FND_MESSAGE.SET_TOKEN('RECORD',l_prog_sub_type,false);
500: FND_MSG_PUB.ADD;
501: end if;
502: --END
503: END IF;

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

660: where PROG_TYPE_SUBTYPE_ID =p_x_prog_type_subtype_tabl(i).PROG_TYPE_SUBTYPE_ID
661: and OBJECT_VERSION_NUMBER=p_x_prog_type_subtype_tabl(i).OBJECT_VERSION_NUMBER;
662:
663: if sql%rowcount=0 then
664: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
665: FND_MSG_PUB.ADD;
666: end if;
667: elsif p_x_prog_type_subtype_tabl(i).DML_operation='U' then
668: IF x_return_status=FND_API.G_RET_STS_SUCCESS