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.AHL_FMP_PROGTYPE_SUBTYPE_PVT dependencies on FND_MSG_PUB

Line 312: FND_MSG_PUB.ADD;

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
316: p_x_prog_type_subtype_rec.PROG_TYPE_SUBTYPE_ID =fnd_api.g_miss_num

Line 320: FND_MSG_PUB.ADD;

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:
324: IF p_x_prog_type_subtype_rec.dml_operation<>'D'

Line 330: FND_MSG_PUB.ADD;

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

Line 341: FND_MSG_PUB.ADD;

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

Line 357: FND_MSG_PUB.ADD;

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

Line 373: FND_MSG_PUB.ADD;

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

Line 386: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

382:
383: EXCEPTION
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data);
389:
390: WHEN FND_API.G_EXC_ERROR THEN

Line 392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

388: p_data => x_msg_data);
389:
390: WHEN FND_API.G_EXC_ERROR THEN
391: X_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => X_msg_data);
395: WHEN OTHERS THEN
396: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

393: p_count => x_msg_count,
394: p_data => X_msg_data);
395: WHEN OTHERS THEN
396: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
400: p_procedure_name => L_API_NAME,
401: p_error_text => SUBSTR(SQLERRM,1,240));

Line 399: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

395: WHEN OTHERS THEN
396: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
400: p_procedure_name => L_API_NAME,
401: p_error_text => SUBSTR(SQLERRM,1,240));
402: END IF;
403: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 403: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

399: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
400: p_procedure_name => L_API_NAME,
401: p_error_text => SUBSTR(SQLERRM,1,240));
402: END IF;
403: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
404: p_count => x_msg_count,
405: p_data => X_msg_data);
406: END;
407:

Line 450: FND_MSG_PUB.ADD;

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'
454: THEN

Line 460: FND_MSG_PUB.ADD;

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

Line 477: FND_MSG_PUB.ADD;

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
481: --AMSRINIV. Bug 2730079. Added code to throw error if subtype asccociated to MRs is selected for delete.

Line 500: FND_MSG_PUB.ADD;

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

Line 508: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_ERROR THEN

Line 514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

510: p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: X_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => X_msg_data);
517: WHEN OTHERS THEN
518: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

515: p_count => x_msg_count,
516: p_data => X_msg_data);
517: WHEN OTHERS THEN
518: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
522: p_procedure_name => l_api_name,
523: p_error_text => SUBSTR(SQLERRM,1,240));

Line 521: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

517: WHEN OTHERS THEN
518: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
522: p_procedure_name => l_api_name,
523: p_error_text => SUBSTR(SQLERRM,1,240));
524: END IF;
525: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 525: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

521: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
522: p_procedure_name => l_api_name,
523: p_error_text => SUBSTR(SQLERRM,1,240));
524: END IF;
525: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => X_msg_data);
528: END;
529:

Line 563: FND_MSG_PUB.initialize;

559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
562: IF FND_API.to_boolean(l_init_msg_list) THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:

Line 611: l_msg_count := FND_MSG_PUB.count_msg;

607: p_x_prog_type_subtype_tabl(i).PROGRAM_SUBTYPE:=l_prog_subtype_rec.PROGRAM_SUBTYPE;
608:
609: END LOOP;
610:
611: l_msg_count := FND_MSG_PUB.count_msg;
612: IF l_msg_count > 0 THEN
613: X_msg_count := l_msg_count;
614: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: RAISE FND_API.G_EXC_ERROR;

Line 652: l_msg_count := FND_MSG_PUB.count_msg;

648: p_prog_type_subtype_rec =>p_x_prog_type_subtype_tabl(i)
649: );
650:
651: END IF;
652: l_msg_count := FND_MSG_PUB.count_msg;
653: IF l_msg_count > 0 THEN
654: X_msg_count := l_msg_count;
655: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: END IF;

Line 665: FND_MSG_PUB.ADD;

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
669: THEN

Line 737: l_msg_count := FND_MSG_PUB.count_msg;

733: end if;
734:
735: END LOOP;
736:
737: l_msg_count := FND_MSG_PUB.count_msg;
738: IF l_msg_count > 0 THEN
739: X_msg_count := l_msg_count;
740: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: RAISE FND_API.G_EXC_ERROR;

Line 758: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

754: EXCEPTION
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756: ROLLBACK TO process_prog_type_subtypes;
757: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data);
761:
762: WHEN FND_API.G_EXC_ERROR THEN

Line 765: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO process_prog_type_subtypes;
764: X_return_status := FND_API.G_RET_STS_ERROR;
765: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => X_msg_data);
768: WHEN OTHERS THEN
769: ROLLBACK TO process_prog_type_subtypes;

Line 771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

767: p_data => X_msg_data);
768: WHEN OTHERS THEN
769: ROLLBACK TO process_prog_type_subtypes;
770: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
774: p_procedure_name => l_api_name,
775: p_error_text => SUBSTR(SQLERRM,1,240));

Line 773: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

769: ROLLBACK TO process_prog_type_subtypes;
770: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
774: p_procedure_name => l_api_name,
775: p_error_text => SUBSTR(SQLERRM,1,240));
776: END IF;
777: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 777: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

773: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
774: p_procedure_name => l_api_name,
775: p_error_text => SUBSTR(SQLERRM,1,240));
776: END IF;
777: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
778: p_count => x_msg_count,
779: p_data => X_msg_data);
780: END;
781: END AHL_FMP_PROGTYPE_SUBTYPE_PVT;