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

Line 436: -- then call the Initialize program of the FND_MSG_PUB package

432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: -- If the calling program has passed the parameter for initializing the message list
436: -- then call the Initialize program of the FND_MSG_PUB package
437: IF fnd_api.to_boolean(p_init_msg_list) THEN
438: fnd_msg_pub.initialize;
439: END IF;
440:

Line 438: fnd_msg_pub.initialize;

434:
435: -- If the calling program has passed the parameter for initializing the message list
436: -- then call the Initialize program of the FND_MSG_PUB package
437: IF fnd_api.to_boolean(p_init_msg_list) THEN
438: fnd_msg_pub.initialize;
439: END IF;
440:
441: -- Set the return status to success
442: x_return_status := fnd_api.g_ret_sts_success;

Line 452: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

448: p_v_message_name => l_c_message_name
449: );
450: IF (l_c_manage_acc IS NULL) THEN
451: l_b_error := TRUE;
452: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
453: fnd_message.set_name('IGS',l_c_message_name);
454: fnd_msg_pub.add;
455: RAISE fnd_api.g_exc_error;
456: END IF;

Line 454: fnd_msg_pub.add;

450: IF (l_c_manage_acc IS NULL) THEN
451: l_b_error := TRUE;
452: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
453: fnd_message.set_name('IGS',l_c_message_name);
454: fnd_msg_pub.add;
455: RAISE fnd_api.g_exc_error;
456: END IF;
457: END IF;
458:

Line 462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

458:
459:
460: IF (p_person_id IS NOT NULL AND p_api_person_id IS NOT NULL) THEN
461: l_b_error := TRUE;
462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
463: fnd_message.set_name('IGS','IGS_FI_PRSID_ALTID_INVALID');
464: fnd_message.set_token('PERSON_ID',p_person_id);
465: fnd_message.set_token('API_PERS_ID',p_api_person_id);
466: fnd_msg_pub.add;

Line 466: fnd_msg_pub.add;

462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
463: fnd_message.set_name('IGS','IGS_FI_PRSID_ALTID_INVALID');
464: fnd_message.set_token('PERSON_ID',p_person_id);
465: fnd_message.set_token('API_PERS_ID',p_api_person_id);
466: fnd_msg_pub.add;
467: END IF;
468: END IF;
469:
470: -- check if the user has provided either person_id or alternate person details

Line 473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

469:
470: -- check if the user has provided either person_id or alternate person details
471: IF (p_person_id IS NULL AND p_api_person_id IS NULL) THEN
472: l_b_error := TRUE;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
474: fnd_message.set_name('IGS','IGS_FI_PRSID_OR_ALTID');
475: fnd_msg_pub.add;
476: END IF;
477: END IF;

Line 475: fnd_msg_pub.add;

471: IF (p_person_id IS NULL AND p_api_person_id IS NULL) THEN
472: l_b_error := TRUE;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
474: fnd_message.set_name('IGS','IGS_FI_PRSID_OR_ALTID');
475: fnd_msg_pub.add;
476: END IF;
477: END IF;
478:
479: --validate person id parameter if it is not null

Line 484: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

480: IF p_person_id IS NOT NULL THEN
481: l_b_ret_status := validate_prsn(p_person_id);
482: IF NOT l_b_ret_status THEN
483: l_b_error := TRUE;
484: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
485: fnd_message.set_name('IGS','IGS_FI_INVALID_PRS_ID');
486: fnd_message.set_token('PERSON_ID',p_person_id);
487: fnd_msg_pub.add;
488: END IF;

Line 487: fnd_msg_pub.add;

483: l_b_error := TRUE;
484: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
485: fnd_message.set_name('IGS','IGS_FI_INVALID_PRS_ID');
486: fnd_message.set_token('PERSON_ID',p_person_id);
487: fnd_msg_pub.add;
488: END IF;
489: END IF;
490: END IF;
491:

Line 504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

500: p_c_sys_alt_prs_id_typ => l_c_sys_alt_prs_id_typ);
501:
502: IF NOT l_b_ret_status THEN
503: l_b_error := TRUE;
504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
505: fnd_message.set_name('IGS','IGS_FI_INVALID_ALT_PERS_ID_TYP');
506: fnd_message.set_token('API_PERS_ID_TYPE',p_alt_person_id_type);
507: fnd_msg_pub.add;
508: END IF;

Line 507: fnd_msg_pub.add;

503: l_b_error := TRUE;
504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
505: fnd_message.set_name('IGS','IGS_FI_INVALID_ALT_PERS_ID_TYP');
506: fnd_message.set_token('API_PERS_ID_TYPE',p_alt_person_id_type);
507: fnd_msg_pub.add;
508: END IF;
509: END IF;
510: END IF;
511:

Line 523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

519:
520:
521: IF NOT l_b_ret_status THEN
522: l_b_error := TRUE;
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
524: fnd_message.set_name('IGS','IGS_FI_INVALID_ALT_PERS_ID');
525: fnd_message.set_token('API_PERS_ID',p_api_person_id);
526: fnd_msg_pub.add;
527: END IF;

Line 526: fnd_msg_pub.add;

522: l_b_error := TRUE;
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
524: fnd_message.set_name('IGS','IGS_FI_INVALID_ALT_PERS_ID');
525: fnd_message.set_token('API_PERS_ID',p_api_person_id);
526: fnd_msg_pub.add;
527: END IF;
528: END IF;
529: END IF;
530:

Line 534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

530:
531: -- validate sponsor code parameter
532: IF p_sponsor_code IS NULL THEN
533: l_b_error := TRUE;
534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
535: fnd_message.set_name('IGS','IGS_FI_SPNSR_CD_NULL');
536: fnd_msg_pub.add;
537: END IF;
538: ELSE

Line 536: fnd_msg_pub.add;

532: IF p_sponsor_code IS NULL THEN
533: l_b_error := TRUE;
534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
535: fnd_message.set_name('IGS','IGS_FI_SPNSR_CD_NULL');
536: fnd_msg_pub.add;
537: END IF;
538: ELSE
539: l_b_ret_status := validate_spnsr_cd(p_sponsor_code);
540: IF NOT l_b_ret_status THEN

Line 542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

538: ELSE
539: l_b_ret_status := validate_spnsr_cd(p_sponsor_code);
540: IF NOT l_b_ret_status THEN
541: l_b_error := TRUE;
542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
543: fnd_message.set_name('IGS','IGS_FI_INVALID_SPNSR_CD');
544: fnd_message.set_token('SPONSOR_CODE',p_sponsor_code);
545: fnd_msg_pub.add;
546: END IF;

Line 545: fnd_msg_pub.add;

541: l_b_error := TRUE;
542: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
543: fnd_message.set_name('IGS','IGS_FI_INVALID_SPNSR_CD');
544: fnd_message.set_token('SPONSOR_CODE',p_sponsor_code);
545: fnd_msg_pub.add;
546: END IF;
547: END IF;
548: END IF;
549:

Line 553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

549:
550: -- validate Award Calendar Instance parameters
551: IF (p_awd_ci_cal_type IS NULL OR p_awd_ci_sequence_number IS NULL) THEN
552: l_b_error := TRUE;
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
554: fnd_message.set_name('IGS','IGS_FI_AWD_INST_NULL');
555: fnd_msg_pub.add;
556: END IF;
557: ELSE

Line 555: fnd_msg_pub.add;

551: IF (p_awd_ci_cal_type IS NULL OR p_awd_ci_sequence_number IS NULL) THEN
552: l_b_error := TRUE;
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
554: fnd_message.set_name('IGS','IGS_FI_AWD_INST_NULL');
555: fnd_msg_pub.add;
556: END IF;
557: ELSE
558: l_b_ret_status := validate_award_cal_inst(p_awd_ci_cal_type,p_awd_ci_sequence_number);
559: IF NOT l_b_ret_status THEN

Line 561: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

557: ELSE
558: l_b_ret_status := validate_award_cal_inst(p_awd_ci_cal_type,p_awd_ci_sequence_number);
559: IF NOT l_b_ret_status THEN
560: l_b_error := TRUE;
561: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
562: fnd_message.set_name('IGS','IGS_FI_INVALID_AWD_CAL_INST');
563: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);
564: fnd_message.set_token('AWARD_YR_CAL_SEQ',p_awd_ci_sequence_number);
565: fnd_msg_pub.add;

Line 565: fnd_msg_pub.add;

561: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
562: fnd_message.set_name('IGS','IGS_FI_INVALID_AWD_CAL_INST');
563: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);
564: fnd_message.set_token('AWARD_YR_CAL_SEQ',p_awd_ci_sequence_number);
565: fnd_msg_pub.add;
566: END IF;
567: END IF;
568:
569: --Validate the Award Year Status. If the status is not open, show the error message.

Line 578: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

574: p_v_message_name => l_c_message_name
575: );
576: IF l_c_message_name IS NOT NULL THEN
577: l_b_error := TRUE;
578: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
579: IF l_c_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
580: fnd_message.set_name('IGF',l_c_message_name);
581: ELSE
582: fnd_message.set_name('IGS',l_c_message_name);

Line 584: fnd_msg_pub.add;

580: fnd_message.set_name('IGF',l_c_message_name);
581: ELSE
582: fnd_message.set_name('IGS',l_c_message_name);
583: END IF;
584: fnd_msg_pub.add;
585: END IF;
586: END IF;
587: END IF;
588:

Line 592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

588:
589: -- validate Load Calendar Instance parameters
590: IF (p_ld_cal_type IS NULL OR p_ld_ci_sequence_number IS NULL ) THEN
591: l_b_error := TRUE;
592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
593: fnd_message.set_name('IGS','IGS_FI_LD_INST_NULL');
594: fnd_msg_pub.add;
595: END IF;
596: ELSE

Line 594: fnd_msg_pub.add;

590: IF (p_ld_cal_type IS NULL OR p_ld_ci_sequence_number IS NULL ) THEN
591: l_b_error := TRUE;
592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
593: fnd_message.set_name('IGS','IGS_FI_LD_INST_NULL');
594: fnd_msg_pub.add;
595: END IF;
596: ELSE
597: l_b_ret_status := validate_load_cal_inst(p_ld_cal_type,p_ld_ci_sequence_number);
598: IF NOT l_b_ret_status THEN

Line 600: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

596: ELSE
597: l_b_ret_status := validate_load_cal_inst(p_ld_cal_type,p_ld_ci_sequence_number);
598: IF NOT l_b_ret_status THEN
599: l_b_error := TRUE;
600: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
601: fnd_message.set_name('IGS','IGS_FI_INVALID_TRM_CAL_INST');
602: fnd_message.set_token('LOAD_CAL_TYPE',p_ld_cal_type);
603: fnd_message.set_token('LOAD_CAL_SEQ',p_ld_ci_sequence_number);
604: fnd_msg_pub.add;

Line 604: fnd_msg_pub.add;

600: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
601: fnd_message.set_name('IGS','IGS_FI_INVALID_TRM_CAL_INST');
602: fnd_message.set_token('LOAD_CAL_TYPE',p_ld_cal_type);
603: fnd_message.set_token('LOAD_CAL_SEQ',p_ld_ci_sequence_number);
604: fnd_msg_pub.add;
605: END IF;
606: END IF;
607: END IF;
608:

Line 612: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

608:
609: -- Validate Amount parameter
610: IF (p_amount IS NULL OR p_amount < 0) THEN
611: l_b_error := TRUE;
612: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
613: fnd_message.set_name('IGS','IGS_FI_INVALID_SPR_AMT');
614: fnd_msg_pub.add;
615: END IF;
616: END IF;

Line 614: fnd_msg_pub.add;

610: IF (p_amount IS NULL OR p_amount < 0) THEN
611: l_b_error := TRUE;
612: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
613: fnd_message.set_name('IGS','IGS_FI_INVALID_SPR_AMT');
614: fnd_msg_pub.add;
615: END IF;
616: END IF;
617:
618: IF (p_sponsor_code IS NOT NULL AND

Line 634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

630: p_n_fund_id => l_n_fund_id );
631:
632: IF NOT l_b_ret_status THEN
633: l_b_error := TRUE;
634: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
635: fnd_message.set_name('IGS','IGS_FI_SPNR_INACTIVE');
636: fnd_message.set_token('SPONSOR_CODE',p_sponsor_code);
637: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);
638: fnd_message.set_token('AWARD_YR_CAL_SEQ',p_awd_ci_sequence_number);

Line 641: fnd_msg_pub.add;

637: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);
638: fnd_message.set_token('AWARD_YR_CAL_SEQ',p_awd_ci_sequence_number);
639: fnd_message.set_token('LOAD_CAL_TYPE',p_ld_cal_type);
640: fnd_message.set_token('LOAD_CAL_SEQ',p_ld_ci_sequence_number);
641: fnd_msg_pub.add;
642: END IF;
643: END IF;
644: END IF;
645:

Line 659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

655: l_n_base_id,
656: p_ld_cal_type,
657: p_ld_ci_sequence_number);
658: IF l_b_ret_status THEN
659: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
660: fnd_message.set_name('IGS','IGS_FI_SPNR_STDNT_EXISTS');
661: fnd_message.set_token('PERSON_ID',NVL(p_person_id,l_n_person_id));
662: fnd_message.set_token('SPONSOR_CODE',p_sponsor_code);
663: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);

Line 667: fnd_msg_pub.add;

663: fnd_message.set_token('AWARD_YR_TYPE',p_awd_ci_cal_type);
664: fnd_message.set_token('AWARD_YR_CAL_SEQ',p_awd_ci_sequence_number);
665: fnd_message.set_token('LOAD_CAL_TYPE',p_ld_cal_type);
666: fnd_message.set_token('LOAD_CAL_SEQ',p_ld_ci_sequence_number);
667: fnd_msg_pub.add;
668: RAISE fnd_api.g_exc_error;
669: END IF;
670: ELSE
671: -- If there is no relation then a new Sponsor-Student relation should be created.

Line 695: fnd_msg_pub.count_and_get(p_count => x_msg_count,

691: IF fnd_api.to_boolean(p_commit) THEN
692: COMMIT WORK;
693: END IF;
694:
695: fnd_msg_pub.count_and_get(p_count => x_msg_count,
696: p_data => x_msg_data);
697:
698: EXCEPTION
699: WHEN fnd_api.g_exc_error THEN

Line 702: fnd_msg_pub.count_and_get( p_count => x_msg_count,

698: EXCEPTION
699: WHEN fnd_api.g_exc_error THEN
700: ROLLBACK TO create_stdnt_spnsr_rel_pub;
701: x_return_status := fnd_api.g_ret_sts_error;
702: fnd_msg_pub.count_and_get( p_count => x_msg_count,
703: p_data => x_msg_data);
704: WHEN fnd_api.g_exc_unexpected_error THEN
705: ROLLBACK TO create_stdnt_spnsr_rel_pub;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 707: fnd_msg_pub.count_and_get( p_count => x_msg_count,

703: p_data => x_msg_data);
704: WHEN fnd_api.g_exc_unexpected_error THEN
705: ROLLBACK TO create_stdnt_spnsr_rel_pub;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
707: fnd_msg_pub.count_and_get( p_count => x_msg_count,
708: p_data => x_msg_data);
709: WHEN OTHERS THEN
710: ROLLBACK TO create_stdnt_spnsr_rel_pub;
711: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 712: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

708: p_data => x_msg_data);
709: WHEN OTHERS THEN
710: ROLLBACK TO create_stdnt_spnsr_rel_pub;
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
713: fnd_msg_pub.add_exc_msg(g_pkg_name,
714: l_api_name);
715: END IF;
716: fnd_msg_pub.count_and_get( p_count => x_msg_count,

Line 713: fnd_msg_pub.add_exc_msg(g_pkg_name,

709: WHEN OTHERS THEN
710: ROLLBACK TO create_stdnt_spnsr_rel_pub;
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
713: fnd_msg_pub.add_exc_msg(g_pkg_name,
714: l_api_name);
715: END IF;
716: fnd_msg_pub.count_and_get( p_count => x_msg_count,
717: p_data => x_msg_data);

Line 716: fnd_msg_pub.count_and_get( p_count => x_msg_count,

712: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
713: fnd_msg_pub.add_exc_msg(g_pkg_name,
714: l_api_name);
715: END IF;
716: fnd_msg_pub.count_and_get( p_count => x_msg_count,
717: p_data => x_msg_data);
718: END create_stdnt_spnsr_rel;
719: END igf_sp_assign_pub;