DBA Data[Home] [Help]

APPS.IGS_FI_GEN_004 dependencies on FND_MESSAGE

Line 274: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');

270: p_course_cd IS NULL OR
271: p_commencement_dt IS NULL OR
272: p_completion_dt IS NULL THEN
273: -- Replaced message IGS_GE_INVALID_VALUE with IGS_FI_PARAMETER_NULL
274: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
277: END IF;
278: v_previous_fee_type := NULL;

Line 276: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

272: p_completion_dt IS NULL THEN
273: -- Replaced message IGS_GE_INVALID_VALUE with IGS_FI_PARAMETER_NULL
274: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
277: END IF;
278: v_previous_fee_type := NULL;
279: FOR v_scafcflrv_rec IN c_scafcflrv('ACTIVE','N','INSTITUTN','OTHER','TUTNFEE','TUITION','TRUE','FCFL','FTCI') LOOP
280: v_rec_found := TRUE;

Line 319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

315: RAISE;
316: END;
317: EXCEPTION
318: WHEN OTHERS THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
320: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_CFAR');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END finp_prc_cfar;

Line 320: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_CFAR');

316: END;
317: EXCEPTION
318: WHEN OTHERS THEN
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
320: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_CFAR');
321: IGS_GE_MSG_STACK.ADD;
322: App_Exception.Raise_Exception;
323: END finp_prc_cfar;
324: --

Line 343: FND_MESSAGE.Set_Name('IGS',

339:
340: -- As per SFCR005, this concurrent program is obsolete and if the user
341: -- tries to run this program then an error message should be logged into the log
342: -- file that the concurrent program is obsolete and should not be run.
343: FND_MESSAGE.Set_Name('IGS',
344: 'IGS_GE_OBSOLETE_JOB');
345: FND_FILE.Put_Line(FND_FILE.Log,
346: FND_MESSAGE.Get);
347: EXCEPTION

Line 346: FND_MESSAGE.Get);

342: -- file that the concurrent program is obsolete and should not be run.
343: FND_MESSAGE.Set_Name('IGS',
344: 'IGS_GE_OBSOLETE_JOB');
345: FND_FILE.Put_Line(FND_FILE.Log,
346: FND_MESSAGE.Get);
347: EXCEPTION
348: WHEN OTHERS THEN
349: RETCODE:=2;
350: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 350: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

346: FND_MESSAGE.Get);
347: EXCEPTION
348: WHEN OTHERS THEN
349: RETCODE:=2;
350: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
351: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
352: END finp_prc_disb_jnl;
353: --
354: PROCEDURE finp_prc_disb_snpsht(

Line 368: FND_MESSAGE.Set_Name('IGS',

364: retcode:=0;
365: -- As per SFCR005, this concurrent program is obsolete and if the user
366: -- tries to run this program then an error message should be logged into the log
367: -- file that the concurrent program is obsolete and should not be run.
368: FND_MESSAGE.Set_Name('IGS',
369: 'IGS_GE_OBSOLETE_JOB');
370: FND_FILE.Put_Line(FND_FILE.Log,
371: FND_MESSAGE.Get);
372: EXCEPTION

Line 371: FND_MESSAGE.Get);

367: -- file that the concurrent program is obsolete and should not be run.
368: FND_MESSAGE.Set_Name('IGS',
369: 'IGS_GE_OBSOLETE_JOB');
370: FND_FILE.Put_Line(FND_FILE.Log,
371: FND_MESSAGE.Get);
372: EXCEPTION
373: WHEN OTHERS THEN
374: RETCODE:=2;
375: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 375: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

371: FND_MESSAGE.Get);
372: EXCEPTION
373: WHEN OTHERS THEN
374: RETCODE:=2;
375: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
376: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
377: END finp_prc_disb_snpsht;
378: --
379: PROCEDURE finp_prc_enr_fa_todo(

Line 431: fnd_message.set_name ( 'IGS', l_v_message_name );

427: -- If this value is NULL then this process cannot run. Added as part of Enh# 2831569.
428: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
429: p_v_message_name => l_v_message_name );
430: IF l_v_manage_accounts IS NULL THEN
431: fnd_message.set_name ( 'IGS', l_v_message_name );
432: fnd_file.put_line (fnd_file.log, ' ');
433: fnd_file.put_line (fnd_file.log, fnd_message.get);
434: fnd_file.put_line (fnd_file.log, ' ');
435: retcode :=2;

Line 433: fnd_file.put_line (fnd_file.log, fnd_message.get);

429: p_v_message_name => l_v_message_name );
430: IF l_v_manage_accounts IS NULL THEN
431: fnd_message.set_name ( 'IGS', l_v_message_name );
432: fnd_file.put_line (fnd_file.log, ' ');
433: fnd_file.put_line (fnd_file.log, fnd_message.get);
434: fnd_file.put_line (fnd_file.log, ' ');
435: retcode :=2;
436: RETURN;
437: END IF;

Line 582: fnd_message.set_name('IGS',l_message);

578: p_ret_cal_type => l_fee_cal_type,
579: p_ret_ci_sequence_number => l_fee_ci_sequence_number,
580: p_message_name => l_message) = FALSE THEN
581: -- Code to add to stack has been added as part of 2734512
582: fnd_message.set_name('IGS',l_message);
583: igs_ge_msg_stack.add;
584: x_msg_data := l_message;
585: RAISE fnd_api.g_exc_error;
586: END IF;

Line 612: fnd_message.set_name ('IGS', l_message_name);

608: p_c_career => NULL,
609: p_d_gl_date => l_d_gl_date,
610: p_v_wav_calc_flag => 'N',
611: p_n_waiver_amount => l_n_waiver_amount) = FALSE) THEN
612: fnd_message.set_name ('IGS', l_message_name);
613: IF l_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
614: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
615: END IF;
616: igs_ge_msg_stack.add;

Line 614: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);

610: p_v_wav_calc_flag => 'N',
611: p_n_waiver_amount => l_n_waiver_amount) = FALSE) THEN
612: fnd_message.set_name ('IGS', l_message_name);
613: IF l_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
614: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
615: END IF;
616: igs_ge_msg_stack.add;
617: x_msg_data := l_message_name;
618: RAISE FND_API.G_EXC_ERROR;

Line 637: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_SUCC_TODO_REC'));

633: x_mode => 'R',
634: x_uoo_id => lp_todo_ref_rec.uoo_id
635: );
636:
637: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_SUCC_TODO_REC'));
638:
639: END IF; -- End if for core fee asssessment routine
640: END IF; -- End if for repeat load calendar record
641:

Line 681: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );

677: v_record_found := TRUE;
678: END LOOP;
679: IF(v_record_found = FALSE) THEN
680: -- Replaced IGS_GE_INVALID_VALUE with IGS_FI_INVALID_PARAMETER, Bug# 2765239
681: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
682: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'FEE_CAL_TYPE') );
683: fnd_file.put_line (fnd_file.log, fnd_message.get);
684: RETURN;
685: ELSE

Line 682: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'FEE_CAL_TYPE') );

678: END LOOP;
679: IF(v_record_found = FALSE) THEN
680: -- Replaced IGS_GE_INVALID_VALUE with IGS_FI_INVALID_PARAMETER, Bug# 2765239
681: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
682: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'FEE_CAL_TYPE') );
683: fnd_file.put_line (fnd_file.log, fnd_message.get);
684: RETURN;
685: ELSE
686: v_record_found := FALSE;

Line 683: fnd_file.put_line (fnd_file.log, fnd_message.get);

679: IF(v_record_found = FALSE) THEN
680: -- Replaced IGS_GE_INVALID_VALUE with IGS_FI_INVALID_PARAMETER, Bug# 2765239
681: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
682: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'FEE_CAL_TYPE') );
683: fnd_file.put_line (fnd_file.log, fnd_message.get);
684: RETURN;
685: ELSE
686: v_record_found := FALSE;
687: END IF;

Line 700: fnd_message.set_name('IGS', v_message_name);

696: igs_fi_gen_gl.get_period_status_for_date(p_d_date => l_d_gl_date,
697: p_v_closing_status => l_c_closing_status,
698: p_v_message_name => v_message_name);
699: IF v_message_name IS NOT NULL THEN
700: fnd_message.set_name('IGS', v_message_name);
701: fnd_file.put_line(fnd_file.log, fnd_message.get);
702: retcode :=2;
703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN

Line 701: fnd_file.put_line(fnd_file.log, fnd_message.get);

697: p_v_closing_status => l_c_closing_status,
698: p_v_message_name => v_message_name);
699: IF v_message_name IS NOT NULL THEN
700: fnd_message.set_name('IGS', v_message_name);
701: fnd_file.put_line(fnd_file.log, fnd_message.get);
702: retcode :=2;
703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');

Line 705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');

701: fnd_file.put_line(fnd_file.log, fnd_message.get);
702: retcode :=2;
703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');
706: fnd_message.set_token('GL_DATE',l_d_gl_date);
707: fnd_file.put_line (fnd_file.log, fnd_message.get);
708: retcode :=2;
709: RETURN;

Line 706: fnd_message.set_token('GL_DATE',l_d_gl_date);

702: retcode :=2;
703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');
706: fnd_message.set_token('GL_DATE',l_d_gl_date);
707: fnd_file.put_line (fnd_file.log, fnd_message.get);
708: retcode :=2;
709: RETURN;
710: END IF;

Line 707: fnd_file.put_line (fnd_file.log, fnd_message.get);

703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');
706: fnd_message.set_token('GL_DATE',l_d_gl_date);
707: fnd_file.put_line (fnd_file.log, fnd_message.get);
708: retcode :=2;
709: RETURN;
710: END IF;
711: ELSE

Line 712: fnd_message.set_name('IGS', 'IGS_UC_NO_MANDATORY_PARAMS');

708: retcode :=2;
709: RETURN;
710: END IF;
711: ELSE
712: fnd_message.set_name('IGS', 'IGS_UC_NO_MANDATORY_PARAMS');
713: fnd_file.put_line (fnd_file.log, fnd_message.get);
714: retcode :=2;
715: RETURN;
716: END IF;

Line 713: fnd_file.put_line (fnd_file.log, fnd_message.get);

709: RETURN;
710: END IF;
711: ELSE
712: fnd_message.set_name('IGS', 'IGS_UC_NO_MANDATORY_PARAMS');
713: fnd_file.put_line (fnd_file.log, fnd_message.get);
714: retcode :=2;
715: RETURN;
716: END IF;
717:

Line 723: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');

719: -- If this is not defined, then log error message
720: -- Added as part of Enh# 3117341, Audit Special Fees.
721: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
722: IF l_v_include_audit IS NULL THEN
723: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
724: fnd_file.put_line (fnd_file.log, fnd_message.get);
725: retcode :=2;
726: RETURN;
727: END IF;

Line 724: fnd_file.put_line (fnd_file.log, fnd_message.get);

720: -- Added as part of Enh# 3117341, Audit Special Fees.
721: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
722: IF l_v_include_audit IS NULL THEN
723: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
724: fnd_file.put_line (fnd_file.log, fnd_message.get);
725: retcode :=2;
726: RETURN;
727: END IF;
728:

Line 736: fnd_message.set_name ('IGS', l_v_message);

732: p_cal_category => 'FEE',
733: p_ret_cal_type => l_v_load_cal_type,
734: p_ret_ci_sequence_number => l_n_load_ci_seq_num,
735: p_message_name => l_v_message) = FALSE THEN
736: fnd_message.set_name ('IGS', l_v_message);
737: igs_ge_msg_stack.add;
738: RAISE fnd_api.g_exc_error;
739: END IF;
740: ELSE

Line 777: fnd_message.set_encoded(l_v_msg_data);

773: IF (l_msg_data IS NULL) THEN
774: fnd_msg_pub.count_and_get( p_count => l_n_msg_count,
775: p_data => l_v_msg_data);
776: IF l_n_msg_count = 1 THEN
777: fnd_message.set_encoded(l_v_msg_data);
778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);

Line 778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

774: fnd_msg_pub.count_and_get( p_count => l_n_msg_count,
775: p_data => l_v_msg_data);
776: IF l_n_msg_count = 1 THEN
777: fnd_message.set_encoded(l_v_msg_data);
778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);
782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

Line 781: fnd_message.set_encoded(fnd_msg_pub.get);

777: fnd_message.set_encoded(l_v_msg_data);
778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);
782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
783: END LOOP;
784: END IF;
785: END IF;

Line 782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);
782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
783: END LOOP;
784: END IF;
785: END IF;
786: END IF;

Line 811: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION'));

807: x_logical_delete_dt => SYSDATE,
808: x_mode => 'R');
809: EXCEPTION
810: WHEN OTHERS THEN
811: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION'));
812: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
813: END;
814: -- assignment of repeat variable rpt_person_id
815: l_rpt_person_id := v_student_todo_rec.person_id;

Line 829: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

825: EXCEPTION
826: WHEN OTHERS THEN
827: RETCODE:=2;
828: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
829: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
831: END;
832: END finp_prc_enr_fa_todo;
833: --

Line 969: fnd_file.put_line (fnd_file.log, fnd_message.get);

965: l_org_id := NULL;
966: igs_ge_gen_003.set_org_id(l_org_id);
967: EXCEPTION
968: WHEN OTHERS THEN
969: fnd_file.put_line (fnd_file.log, fnd_message.get);
970: retcode :=2;
971: RETURN;
972: END;
973: retcode := 0;

Line 986: fnd_message.set_name ( 'IGS', l_v_message_name );

982: -- If this value is NULL then this process cannot run. Added as part of Enh# 2831569.
983: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
984: p_v_message_name => l_v_message_name );
985: IF l_v_manage_accounts IS NULL THEN
986: fnd_message.set_name ( 'IGS', l_v_message_name );
987: igs_ge_msg_stack.ADD;
988: app_exception.raise_exception (NULL, NULL, fnd_message.get);
989: END IF;
990:

Line 988: app_exception.raise_exception (NULL, NULL, fnd_message.get);

984: p_v_message_name => l_v_message_name );
985: IF l_v_manage_accounts IS NULL THEN
986: fnd_message.set_name ( 'IGS', l_v_message_name );
987: igs_ge_msg_stack.ADD;
988: app_exception.raise_exception (NULL, NULL, fnd_message.get);
989: END IF;
990:
991: -- Validate parameters
992: -- Process can take only one parameter between Person Number and Person Group ID. Added as part of Enh# 2831569.

Line 994: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;

990:
991: -- Validate parameters
992: -- Process can take only one parameter between Person Number and Person Group ID. Added as part of Enh# 2831569.
993: IF ( (l_n_person_id IS NOT NULL) AND (l_n_person_grp_id IS NOT NULL) ) THEN
994: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
995: igs_ge_msg_stack.ADD;
996: app_exception.raise_exception(null, null, fnd_message.get);
997: END IF;
998:

Line 996: app_exception.raise_exception(null, null, fnd_message.get);

992: -- Process can take only one parameter between Person Number and Person Group ID. Added as part of Enh# 2831569.
993: IF ( (l_n_person_id IS NOT NULL) AND (l_n_person_grp_id IS NOT NULL) ) THEN
994: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
995: igs_ge_msg_stack.ADD;
996: app_exception.raise_exception(null, null, fnd_message.get);
997: END IF;
998:
999: -- Enh# 3167098, Either of the two parameters must be specified.
1000: IF l_n_person_id IS NULL AND

Line 1002: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;

998:
999: -- Enh# 3167098, Either of the two parameters must be specified.
1000: IF l_n_person_id IS NULL AND
1001: l_n_person_grp_id IS NULL THEN
1002: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
1003: igs_ge_msg_stack.ADD;
1004: app_exception.raise_exception(null, null, fnd_message.get);
1005: END IF;
1006:

Line 1004: app_exception.raise_exception(null, null, fnd_message.get);

1000: IF l_n_person_id IS NULL AND
1001: l_n_person_grp_id IS NULL THEN
1002: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
1003: igs_ge_msg_stack.ADD;
1004: app_exception.raise_exception(null, null, fnd_message.get);
1005: END IF;
1006:
1007: -- Validate the person id group
1008: IF l_n_person_grp_id IS NOT NULL THEN

Line 1013: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

1009: OPEN cur_pers_grp(l_n_person_grp_id);
1010: FETCH cur_pers_grp INTO l_c_var;
1011: IF cur_pers_grp%NOTFOUND THEN
1012: CLOSE cur_pers_grp;
1013: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1014: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1015: igs_ge_msg_stack.ADD;
1016: app_exception.raise_exception(null, null, fnd_message.get);
1017: END IF;

Line 1014: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));

1010: FETCH cur_pers_grp INTO l_c_var;
1011: IF cur_pers_grp%NOTFOUND THEN
1012: CLOSE cur_pers_grp;
1013: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1014: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1015: igs_ge_msg_stack.ADD;
1016: app_exception.raise_exception(null, null, fnd_message.get);
1017: END IF;
1018: CLOSE cur_pers_grp;

Line 1016: app_exception.raise_exception(null, null, fnd_message.get);

1012: CLOSE cur_pers_grp;
1013: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1014: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
1015: igs_ge_msg_stack.ADD;
1016: app_exception.raise_exception(null, null, fnd_message.get);
1017: END IF;
1018: CLOSE cur_pers_grp;
1019: END IF;
1020:

Line 1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');

1019: END IF;
1020:
1021: IF(p_trace_on IS NULL ) THEN
1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);
1027: retcode:=2;

Line 1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));

1020:
1021: IF(p_trace_on IS NULL ) THEN
1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);
1027: retcode:=2;
1028: RETURN;

Line 1025: fnd_file.put_line (fnd_file.log, fnd_message.get);

1021: IF(p_trace_on IS NULL ) THEN
1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);
1027: retcode:=2;
1028: RETURN;
1029: END IF;

Line 1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');

1029: END IF;
1030:
1031: IF( p_test_run IS NULL ) THEN
1032: fnd_file.new_line(fnd_file.log);
1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));
1035: fnd_file.put_line (fnd_file.log, fnd_message.get);
1036: retcode:=2;
1037: RETURN;

Line 1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));

1030:
1031: IF( p_test_run IS NULL ) THEN
1032: fnd_file.new_line(fnd_file.log);
1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));
1035: fnd_file.put_line (fnd_file.log, fnd_message.get);
1036: retcode:=2;
1037: RETURN;
1038: END IF;

Line 1035: fnd_file.put_line (fnd_file.log, fnd_message.get);

1031: IF( p_test_run IS NULL ) THEN
1032: fnd_file.new_line(fnd_file.log);
1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));
1035: fnd_file.put_line (fnd_file.log, fnd_message.get);
1036: retcode:=2;
1037: RETURN;
1038: END IF;
1039:

Line 1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');

1038: END IF;
1039:
1040: IF( l_d_gl_date IS NULL ) THEN
1041: fnd_file.new_line(fnd_file.log);
1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));
1044: fnd_file.put_line (fnd_file.log, fnd_message.get);
1045: retcode:=2;
1046: RETURN;

Line 1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));

1039:
1040: IF( l_d_gl_date IS NULL ) THEN
1041: fnd_file.new_line(fnd_file.log);
1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));
1044: fnd_file.put_line (fnd_file.log, fnd_message.get);
1045: retcode:=2;
1046: RETURN;
1047: END IF;

Line 1044: fnd_file.put_line (fnd_file.log, fnd_message.get);

1040: IF( l_d_gl_date IS NULL ) THEN
1041: fnd_file.new_line(fnd_file.log);
1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));
1044: fnd_file.put_line (fnd_file.log, fnd_message.get);
1045: retcode:=2;
1046: RETURN;
1047: END IF;
1048:

Line 1052: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');

1048:
1049: -- ensuring that fee calendar instance is not null as a change implemented in
1050: -- fee calc build july-2001 (bug: 1851586)
1051: IF l_v_fee_cal_type IS NULL OR l_n_fee_ci_sequence_number IS NULL THEN
1052: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
1053: IGS_GE_MSG_STACK.ADD;
1054: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1055: RETURN;
1056: END IF;

Line 1054: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

1050: -- fee calc build july-2001 (bug: 1851586)
1051: IF l_v_fee_cal_type IS NULL OR l_n_fee_ci_sequence_number IS NULL THEN
1052: Fnd_Message.Set_Name ('IGS', 'IGS_FI_PARAMETER_NULL');
1053: IGS_GE_MSG_STACK.ADD;
1054: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1055: RETURN;
1056: END IF;
1057:
1058: -- Added as part of Tuition Waivers.

Line 1064: fnd_message.set_name('IGS', 'IGS_FI_WAV_FEE_TYPE');

1060: OPEN cur_wav_calc_flag( p_fee_category, l_v_fee_cal_type, l_n_fee_ci_sequence_number, p_fee_type );
1061: FETCH cur_wav_calc_flag INTO l_v_wav_calc_flag;
1062: CLOSE cur_wav_calc_flag;
1063: IF (l_v_wav_calc_flag = 'Y') THEN
1064: fnd_message.set_name('IGS', 'IGS_FI_WAV_FEE_TYPE');
1065: igs_ge_msg_stack.add;
1066: app_exception.raise_exception(Null, Null, fnd_message.get);
1067: RETURN;
1068: END IF;

Line 1066: app_exception.raise_exception(Null, Null, fnd_message.get);

1062: CLOSE cur_wav_calc_flag;
1063: IF (l_v_wav_calc_flag = 'Y') THEN
1064: fnd_message.set_name('IGS', 'IGS_FI_WAV_FEE_TYPE');
1065: igs_ge_msg_stack.add;
1066: app_exception.raise_exception(Null, Null, fnd_message.get);
1067: RETURN;
1068: END IF;
1069: END IF;
1070:

Line 1079: FND_MESSAGE.SET_NAME('IGS', v_message_name);

1075: igs_fi_gen_gl.get_period_status_for_date(p_d_date => l_d_gl_date,
1076: p_v_closing_status => l_c_closing_status,
1077: p_v_message_name => v_message_name);
1078: IF v_message_name IS NOT NULL THEN
1079: FND_MESSAGE.SET_NAME('IGS', v_message_name);
1080: IGS_GE_MSG_STACK.ADD;
1081: APP_EXCEPTION.RAISE_EXCEPTION;
1082: ELSIF l_c_closing_status NOT IN ('O','F') THEN
1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');

Line 1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');

1079: FND_MESSAGE.SET_NAME('IGS', v_message_name);
1080: IGS_GE_MSG_STACK.ADD;
1081: APP_EXCEPTION.RAISE_EXCEPTION;
1082: ELSIF l_c_closing_status NOT IN ('O','F') THEN
1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');
1084: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);
1085: IGS_GE_MSG_STACK.ADD;
1086: APP_EXCEPTION.RAISE_EXCEPTION;
1087: END IF;

Line 1084: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);

1080: IGS_GE_MSG_STACK.ADD;
1081: APP_EXCEPTION.RAISE_EXCEPTION;
1082: ELSIF l_c_closing_status NOT IN ('O','F') THEN
1083: FND_MESSAGE.SET_NAME('IGS', 'IGS_FI_INVALID_GL_DATE');
1084: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);
1085: IGS_GE_MSG_STACK.ADD;
1086: APP_EXCEPTION.RAISE_EXCEPTION;
1087: END IF;
1088:

Line 1099: Fnd_Message.Set_Name ('IGS', 'IGS_FI_NO_FEE_CAL_INS');

1095: l_n_fee_ci_sequence_number) LOOP
1096: v_record_found := TRUE;
1097: END LOOP;
1098: IF(v_record_found = FALSE) THEN
1099: Fnd_Message.Set_Name ('IGS', 'IGS_FI_NO_FEE_CAL_INS');
1100: IGS_GE_MSG_STACK.ADD;
1101: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1102: RETURN;
1103: ELSE

Line 1101: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

1097: END LOOP;
1098: IF(v_record_found = FALSE) THEN
1099: Fnd_Message.Set_Name ('IGS', 'IGS_FI_NO_FEE_CAL_INS');
1100: IGS_GE_MSG_STACK.ADD;
1101: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1102: RETURN;
1103: ELSE
1104: v_record_found := FALSE;
1105: END IF;

Line 1117: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );

1113: -- fee calc build july-2001 (bug: 1851586)
1114:
1115: -- Enh# 3167098, Removed INITIAL and COMBINED modes.
1116: IF NVL(p_process_mode, 'NULL') NOT IN ('ACTUAL', 'PREDICTIVE') THEN
1117: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
1118: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'PROCESS_MODE' ) );
1119: IGS_GE_MSG_STACK.ADD;
1120: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1121: RETURN;

Line 1118: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'PROCESS_MODE' ) );

1114:
1115: -- Enh# 3167098, Removed INITIAL and COMBINED modes.
1116: IF NVL(p_process_mode, 'NULL') NOT IN ('ACTUAL', 'PREDICTIVE') THEN
1117: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
1118: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'PROCESS_MODE' ) );
1119: IGS_GE_MSG_STACK.ADD;
1120: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1121: RETURN;
1122: END IF;

Line 1120: App_Exception.Raise_Exception(Null, Null, fnd_message.get);

1116: IF NVL(p_process_mode, 'NULL') NOT IN ('ACTUAL', 'PREDICTIVE') THEN
1117: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
1118: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'PROCESS_MODE' ) );
1119: IGS_GE_MSG_STACK.ADD;
1120: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
1121: RETURN;
1122: END IF;
1123:
1124: -- Obtain the value of the profile 'IGS: Charge tuition for Audited Student Attempt'

Line 1129: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');

1125: -- If this is not defined, then log error message
1126: -- Added as part of Enh# 3117341, Audit Special Fees.
1127: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
1128: IF l_v_include_audit IS NULL THEN
1129: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
1130: igs_ge_msg_stack.ADD;
1131: app_exception.raise_exception(null, null, fnd_message.get);
1132: END IF;
1133:

Line 1131: app_exception.raise_exception(null, null, fnd_message.get);

1127: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
1128: IF l_v_include_audit IS NULL THEN
1129: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
1130: igs_ge_msg_stack.ADD;
1131: app_exception.raise_exception(null, null, fnd_message.get);
1132: END IF;
1133:
1134: fnd_file.new_line(fnd_file.log);
1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);

Line 1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');

1132: END IF;
1133:
1134: fnd_file.new_line(fnd_file.log);
1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);
1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
1137: IF l_n_person_id IS NOT NULL THEN
1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);

Line 1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));

1134: fnd_file.new_line(fnd_file.log);
1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);
1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
1137: IF l_n_person_id IS NOT NULL THEN
1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);

1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
1137: IF l_n_person_id IS NOT NULL THEN
1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));

Line 1142: fnd_file.put_line (fnd_file.log, fnd_message.get);

1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);

Line 1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');

1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN
1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);

Line 1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));

1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN
1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);

1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN
1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');

Line 1156: fnd_file.put_line (fnd_file.log, fnd_message.get);

1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');

1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:
1162: -- case in which the person id is not provided but the person group id is provided.

Line 1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));

1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:
1162: -- case in which the person id is not provided but the person group id is provided.
1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN

Line 1160: fnd_file.put_line (fnd_file.log, fnd_message.get);

1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:
1162: -- case in which the person id is not provided but the person group id is provided.
1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN
1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql

Line 1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');

1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN
1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql
1165: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(l_n_person_grp_id,l_v_status );
1166: IF l_v_status <> 'S' THEN
1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception(NULL,NULL,fnd_message.get);
1170: END IF;
1171:

Line 1169: app_exception.raise_exception(NULL,NULL,fnd_message.get);

1165: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(l_n_person_grp_id,l_v_status );
1166: IF l_v_status <> 'S' THEN
1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception(NULL,NULL,fnd_message.get);
1170: END IF;
1171:
1172:
1173: IF (p_trace_on = 'Y') THEN

Line 1218: Fnd_Message.Set_Name ('IGS', v_message_name);

1214: p_c_career,
1215: l_d_gl_date,
1216: 'N',
1217: l_n_waiver_amount) = FALSE) THEN
1218: Fnd_Message.Set_Name ('IGS', v_message_name);
1219: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1221: END IF;
1222: IGS_GE_MSG_STACK.ADD;

Line 1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);

1216: 'N',
1217: l_n_waiver_amount) = FALSE) THEN
1218: Fnd_Message.Set_Name ('IGS', v_message_name);
1219: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1221: END IF;
1222: IGS_GE_MSG_STACK.ADD;
1223: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1224: END IF;

Line 1223: App_Exception.Raise_Exception(Null, Null, fnd_message.get );

1219: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1221: END IF;
1222: IGS_GE_MSG_STACK.ADD;
1223: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1224: END IF;
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: -- If any exception is raised for a person, log person_number

Line 1231: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');

1227: -- If any exception is raised for a person, log person_number
1228: -- and continue processing for next person
1229: retcode:=1;
1230: l_v_person_number := igs_fi_gen_008.get_party_number(rec_person_grp.p_n_person_id);
1231: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1232: fnd_message.set_token('PERSON_NUM',l_v_person_number);
1233: igs_ge_msg_stack.add;
1234: END;
1235:

Line 1232: fnd_message.set_token('PERSON_NUM',l_v_person_number);

1228: -- and continue processing for next person
1229: retcode:=1;
1230: l_v_person_number := igs_fi_gen_008.get_party_number(rec_person_grp.p_n_person_id);
1231: fnd_message.set_name('IGS','IGS_FI_PERSON_NUM');
1232: fnd_message.set_token('PERSON_NUM',l_v_person_number);
1233: igs_ge_msg_stack.add;
1234: END;
1235:
1236: END LOOP;

Line 1259: Fnd_Message.Set_Name ('IGS', v_message_name);

1255: p_c_career,
1256: l_d_gl_date,
1257: 'N',
1258: l_n_waiver_amount) = FALSE) THEN
1259: Fnd_Message.Set_Name ('IGS', v_message_name);
1260: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1262: END IF;
1263: IGS_GE_MSG_STACK.ADD;

Line 1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);

1257: 'N',
1258: l_n_waiver_amount) = FALSE) THEN
1259: Fnd_Message.Set_Name ('IGS', v_message_name);
1260: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1262: END IF;
1263: IGS_GE_MSG_STACK.ADD;
1264: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1265: END IF;

Line 1264: App_Exception.Raise_Exception(Null, Null, fnd_message.get );

1260: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1262: END IF;
1263: IGS_GE_MSG_STACK.ADD;
1264: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1265: END IF;
1266:
1267: END IF;
1268: IF p_test_run = 'Y' THEN

Line 1269: fnd_message.set_name('IGS',

1265: END IF;
1266:
1267: END IF;
1268: IF p_test_run = 'Y' THEN
1269: fnd_message.set_name('IGS',
1270: 'IGS_FI_PRC_TEST_RUN');
1271: fnd_file.put_line(fnd_file.log,
1272: fnd_message.get);
1273: END IF;

Line 1272: fnd_message.get);

1268: IF p_test_run = 'Y' THEN
1269: fnd_message.set_name('IGS',
1270: 'IGS_FI_PRC_TEST_RUN');
1271: fnd_file.put_line(fnd_file.log,
1272: fnd_message.get);
1273: END IF;
1274:
1275: RETURN;
1276:

Line 1281: errbuf:=fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1277: END;
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: retcode:=2;
1281: errbuf:=fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1282: igs_ge_msg_stack.conc_exception_hndl;
1283: END finp_prc_enr_fee_ass;
1284:
1285: --

Line 1310: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_OBSOLETE_JOB');

1306:
1307:
1308: --As part of bug fix of bug #2318488 the following code has been added
1309: retcode:=0;
1310: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_OBSOLETE_JOB');
1311: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN

Line 1311: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

1307:
1308: --As part of bug fix of bug #2318488 the following code has been added
1309: retcode:=0;
1310: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_OBSOLETE_JOB');
1311: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: RETCODE:=2;

Line 1316: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: RETCODE:=2;
1316: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1317: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1318: END finp_prc_hecs_pymnt_optn;
1319: --
1320: PROCEDURE finp_prc_penalties(

Line 1339: FND_MESSAGE.Set_Name('IGS',

1335: retcode:=0;
1336: -- As per SFCR005, this concurrent program is obsolete and if the user
1337: -- tries to run this program then an error message should be logged into the log
1338: -- file that the concurrent program is obsolete and should not be run.
1339: FND_MESSAGE.Set_Name('IGS',
1340: 'IGS_GE_OBSOLETE_JOB');
1341: FND_FILE.Put_Line(FND_FILE.Log,
1342: FND_MESSAGE.Get);
1343: EXCEPTION

Line 1342: FND_MESSAGE.Get);

1338: -- file that the concurrent program is obsolete and should not be run.
1339: FND_MESSAGE.Set_Name('IGS',
1340: 'IGS_GE_OBSOLETE_JOB');
1341: FND_FILE.Put_Line(FND_FILE.Log,
1342: FND_MESSAGE.Get);
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: RETCODE:=2;
1346: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

Line 1346: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1342: FND_MESSAGE.Get);
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: RETCODE:=2;
1346: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1347: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1348: END finp_prc_penalties;
1349: --
1350: PROCEDURE finp_prc_sca_unconf(

Line 1438: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1434: v_log_entry_ind := 'Y';
1435: END;
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1439: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_INS_LOG_ENTRY');
1440: IGS_GE_MSG_STACK.ADD;
1441: App_Exception.Raise_Exception;
1442: END finpl_prc_ins_log_entry;

Line 1439: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_INS_LOG_ENTRY');

1435: END;
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1439: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_INS_LOG_ENTRY');
1440: IGS_GE_MSG_STACK.ADD;
1441: App_Exception.Raise_Exception;
1442: END finpl_prc_ins_log_entry;
1443: PROCEDURE finpl_prc_end_fee_contract(

Line 1494: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1490: 'N');
1491: END;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1495: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_END_FEE_CONTRACT');
1496: IGS_GE_MSG_STACK.ADD;
1497: App_Exception.Raise_Exception;
1498: END finpl_prc_end_fee_contract;

Line 1495: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_END_FEE_CONTRACT');

1491: END;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1495: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_END_FEE_CONTRACT');
1496: IGS_GE_MSG_STACK.ADD;
1497: App_Exception.Raise_Exception;
1498: END finpl_prc_end_fee_contract;
1499:

Line 1589: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1585: END IF;
1586: END;
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1590: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_REVERSE_FEE_ASSESS');
1591: IGS_GE_MSG_STACK.ADD;
1592: App_Exception.Raise_Exception;
1593: END finpl_prc_reverse_fee_assess;

Line 1590: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_REVERSE_FEE_ASSESS');

1586: END;
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1590: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_REVERSE_FEE_ASSESS');
1591: IGS_GE_MSG_STACK.ADD;
1592: App_Exception.Raise_Exception;
1593: END finpl_prc_reverse_fee_assess;
1594: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.

Line 1641: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1637: RAISE;
1638: END;
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_THIS_CRS_LIABLE');
1643: IGS_GE_MSG_STACK.ADD;
1644: App_Exception.Raise_Exception;
1645: END finpl_prc_this_crs_liable;

Line 1642: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_THIS_CRS_LIABLE');

1638: END;
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1642: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_THIS_CRS_LIABLE');
1643: IGS_GE_MSG_STACK.ADD;
1644: App_Exception.Raise_Exception;
1645: END finpl_prc_this_crs_liable;
1646: --Modified the declartion of datatype based on IGS_FI_FEE_ASS_DEBT_V to point to IGS_FI_FEE_AS.

Line 1694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1690: RAISE;
1691: END;
1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1695: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_ANOTHER_CRS_LIABLE');
1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END finpl_prc_another_crs_liable;

Line 1695: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_ANOTHER_CRS_LIABLE');

1691: END;
1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1695: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_ANOTHER_CRS_LIABLE');
1696: IGS_GE_MSG_STACK.ADD;
1697: App_Exception.Raise_Exception;
1698: END finpl_prc_another_crs_liable;
1699: PROCEDURE finpl_prc_delete_fee_contract (

Line 1730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1726: RAISE;
1727: END;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1731: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_DELETE_FEE_CONTRACT');
1732: IGS_GE_MSG_STACK.ADD;
1733: App_Exception.Raise_Exception;
1734: END finpl_prc_delete_fee_contract;

Line 1731: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_DELETE_FEE_CONTRACT');

1727: END;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1731: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINPL_PRC_DELETE_FEE_CONTRACT');
1732: IGS_GE_MSG_STACK.ADD;
1733: App_Exception.Raise_Exception;
1734: END finpl_prc_delete_fee_contract;
1735: BEGIN

Line 1832: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');

1828: RAISE;
1829: END;
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1833: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_SCA_UNCONF');
1834: IGS_GE_MSG_STACK.ADD;
1835: App_Exception.Raise_Exception;
1836: END finp_prc_sca_unconf;

Line 1833: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_SCA_UNCONF');

1829: END;
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: Fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1833: Fnd_Message.Set_Token('NAME','IGS_FI_GEN_004.FINP_PRC_SCA_UNCONF');
1834: IGS_GE_MSG_STACK.ADD;
1835: App_Exception.Raise_Exception;
1836: END finp_prc_sca_unconf;
1837: END igs_fi_gen_004;