[Home] [Help]
692: -- when the procedure returns a message name it is presumed as if an error has occurred
693: -- show the message name that is returned from the general procedure and error out.
694: IF p_d_gl_date IS NOT NULL THEN
695: l_d_gl_date := igs_ge_date.igsdate(p_d_gl_date);
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);
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;
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;
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;
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;
1071: -- When the Gl-Date parameter is not null then do the validation for checking the period status.
1072: -- If the period status is not in Open or Future periods then error out
1073: -- when the procedure returns a message name it is presumed as if an error has occurred
1074: -- show the message name that is returned from the general procedure and error out.
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);
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);
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
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);
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));
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);
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));
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);
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));
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);
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');
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);
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
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);
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));
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);
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
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);
1161:
1173: IF (p_trace_on = 'Y') THEN
1174: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1175: OPEN cur_fee_calc_mthd;
1176: FETCH cur_fee_calc_mthd INTO l_fee_calc_mthd_code;
1177: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CALC_MTHD') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_FEE_CALC_MTHD',l_fee_calc_mthd_code));
1178: CLOSE cur_fee_calc_mthd;
1179: l_b_fci_lci := igs_fi_gen_001.finp_get_lfci_reln( l_v_fee_cal_type,
1180: l_n_fee_ci_sequence_number,
1181: 'FEE',
1182: l_v_load_cal_type,
1183: l_n_load_ci_sequence_number,
1184: l_v_message_name);
1185: IF l_b_fci_lci=TRUE THEN
1186: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_AS_ALL_TERM', 'TERM') || ': ' || igs_ca_gen_001.calp_get_alt_cd(l_v_load_cal_type,l_n_load_ci_sequence_number));
1187: END IF;
1188: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1189: END IF;
1190: