DBA Data[Home] [Help]

APPS.IGS_FI_PRC_WAIVERS dependencies on FND_MESSAGE

Line 94: fnd_message.set_name('IGS',

90: CLOSE cur_wav_pgm;
91:
92: IF NOT l_b_rec_found THEN
93: IF p_v_waiver_name IS NULL THEN
94: fnd_message.set_name('IGS',
95: 'IGS_FI_WAV_PGM_NO_REC_FOUND');
96: fnd_message.set_token('FEE_ALT_CD',
97: igs_ca_gen_001.calp_get_alt_cd(p_v_fee_cal_type,p_n_fee_ci_seq));
98: fnd_message.set_token('FEE_TYPE',

Line 96: fnd_message.set_token('FEE_ALT_CD',

92: IF NOT l_b_rec_found THEN
93: IF p_v_waiver_name IS NULL THEN
94: fnd_message.set_name('IGS',
95: 'IGS_FI_WAV_PGM_NO_REC_FOUND');
96: fnd_message.set_token('FEE_ALT_CD',
97: igs_ca_gen_001.calp_get_alt_cd(p_v_fee_cal_type,p_n_fee_ci_seq));
98: fnd_message.set_token('FEE_TYPE',
99: p_v_fee_type);
100: ELSE

Line 98: fnd_message.set_token('FEE_TYPE',

94: fnd_message.set_name('IGS',
95: 'IGS_FI_WAV_PGM_NO_REC_FOUND');
96: fnd_message.set_token('FEE_ALT_CD',
97: igs_ca_gen_001.calp_get_alt_cd(p_v_fee_cal_type,p_n_fee_ci_seq));
98: fnd_message.set_token('FEE_TYPE',
99: p_v_fee_type);
100: ELSE
101: fnd_message.set_name('IGS',
102: 'IGS_FI_WAV_FEE_CAL_INST');

Line 101: fnd_message.set_name('IGS',

97: igs_ca_gen_001.calp_get_alt_cd(p_v_fee_cal_type,p_n_fee_ci_seq));
98: fnd_message.set_token('FEE_TYPE',
99: p_v_fee_type);
100: ELSE
101: fnd_message.set_name('IGS',
102: 'IGS_FI_WAV_FEE_CAL_INST');
103: END IF;
104: fnd_msg_pub.add;
105: l_b_ret_val := FALSE;

Line 667: fnd_message.set_name('IGS',

663: p_v_message_name => l_v_message_name);
664:
665: IF l_v_manage_acc IS NULL OR l_v_manage_acc = 'OTHER' THEN
666: x_return_status := 'E';
667: fnd_message.set_name('IGS',
668: l_v_message_name);
669: fnd_msg_pub.add;
670: RAISE fnd_api.g_exc_error;
671: END IF;

Line 684: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');

680: p_v_currency_cd IS NULL OR
681: p_d_gl_date IS NULL OR
682: p_v_raise_wf_event IS NULL
683: THEN
684: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
685: fnd_msg_pub.add;
686: RAISE fnd_api.g_exc_error;
687: END IF;
688:

Line 712: fnd_message.set_name('IGS',

708: IF l_v_ret_status = 'E' THEN
709: log_to_fnd(p_v_module => 'create_waivers',
710: p_v_string => ' proc_manual_waiver_adj errored out'
711: );
712: fnd_message.set_name('IGS',
713: 'IGS_FI_WAV_NO_TRANS_CREATED');
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END IF;

Line 773: fnd_message.set_name('IGS','IGS_FI_WAV_CHG_ERR');

769: );
770: IF (l_b_chr_err_account=1) THEN
771: log_to_fnd(p_v_module => 'create_waivers',
772: p_v_string => 'Charges with Error Account exist. Waivers cannot be created');
773: fnd_message.set_name('IGS','IGS_FI_WAV_CHG_ERR');
774: fnd_message.set_token('PERSON',igs_fi_gen_008.get_party_number(p_n_party_id => p_n_person_id));
775: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
776: fnd_message.set_token('FEE_PERIOD',
777: igs_ca_gen_001.calp_get_alt_cd(p_cal_type => p_v_fee_cal_type,

Line 774: fnd_message.set_token('PERSON',igs_fi_gen_008.get_party_number(p_n_party_id => p_n_person_id));

770: IF (l_b_chr_err_account=1) THEN
771: log_to_fnd(p_v_module => 'create_waivers',
772: p_v_string => 'Charges with Error Account exist. Waivers cannot be created');
773: fnd_message.set_name('IGS','IGS_FI_WAV_CHG_ERR');
774: fnd_message.set_token('PERSON',igs_fi_gen_008.get_party_number(p_n_party_id => p_n_person_id));
775: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
776: fnd_message.set_token('FEE_PERIOD',
777: igs_ca_gen_001.calp_get_alt_cd(p_cal_type => p_v_fee_cal_type,
778: p_sequence_number => p_n_fee_ci_seq_number)

Line 775: fnd_message.set_token('FEE_TYPE',p_v_fee_type);

771: log_to_fnd(p_v_module => 'create_waivers',
772: p_v_string => 'Charges with Error Account exist. Waivers cannot be created');
773: fnd_message.set_name('IGS','IGS_FI_WAV_CHG_ERR');
774: fnd_message.set_token('PERSON',igs_fi_gen_008.get_party_number(p_n_party_id => p_n_person_id));
775: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
776: fnd_message.set_token('FEE_PERIOD',
777: igs_ca_gen_001.calp_get_alt_cd(p_cal_type => p_v_fee_cal_type,
778: p_sequence_number => p_n_fee_ci_seq_number)
779: );

Line 776: fnd_message.set_token('FEE_PERIOD',

772: p_v_string => 'Charges with Error Account exist. Waivers cannot be created');
773: fnd_message.set_name('IGS','IGS_FI_WAV_CHG_ERR');
774: fnd_message.set_token('PERSON',igs_fi_gen_008.get_party_number(p_n_party_id => p_n_person_id));
775: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
776: fnd_message.set_token('FEE_PERIOD',
777: igs_ca_gen_001.calp_get_alt_cd(p_cal_type => p_v_fee_cal_type,
778: p_sequence_number => p_n_fee_ci_seq_number)
779: );
780: fnd_msg_pub.add;

Line 814: fnd_message.set_name('IGS',

810: IF x_return_status = 'E' THEN
811: log_to_fnd(p_v_module => 'create_waivers',
812: p_v_string => ' get_calc_new_waiver_amt errored out'
813: );
814: fnd_message.set_name('IGS',
815: 'IGS_FI_WAV_NO_TRANS_CREATED');
816: fnd_msg_pub.add;
817: x_waiver_amount := 0;
818: RAISE fnd_api.g_exc_error;

Line 836: fnd_message.set_name('IGS',

832: IF x_return_status = 'E' THEN
833: log_to_fnd(p_v_module => 'create_waivers',
834: p_v_string => ' igs_fi_wav_utils_001.get_eligible_waiver_amt errored out'
835: );
836: fnd_message.set_name('IGS',
837: 'IGS_FI_WAV_NO_TRANS_CREATED');
838: fnd_msg_pub.add;
839: x_waiver_amount := 0;
840: RAISE fnd_api.g_exc_error;

Line 886: fnd_message.set_name('IGS',

882: IF x_return_status <> 'S' THEN
883: log_to_fnd(p_v_module => 'create_waivers',
884: p_v_string => ' igs_fi_wav_utils_002.call_credits_api errored out'
885: );
886: fnd_message.set_name('IGS',
887: 'IGS_FI_WAV_NO_TRANS_CREATED');
888: fnd_msg_pub.add;
889: x_waiver_amount := 0;
890: RAISE fnd_api.g_exc_error;

Line 912: fnd_message.set_name('IGS',

908: IF x_return_status <> 'S' THEN
909: log_to_fnd(p_v_module => 'create_waivers',
910: p_v_string => ' igs_fi_wav_utils_002.call_charges_api errored out'
911: );
912: fnd_message.set_name('IGS',
913: 'IGS_FI_WAV_NO_TRANS_CREATED');
914: fnd_msg_pub.add;
915: x_waiver_amount := 0;
916: RAISE fnd_api.g_exc_error;

Line 943: fnd_message.set_name('IGS',

939: IF x_return_status <> 'S' THEN
940: log_to_fnd(p_v_module => 'create_waivers',
941: p_v_string => ' igs_fi_wav_utils_001.apply_waivers errored out'
942: );
943: fnd_message.set_name('IGS',
944: 'IGS_FI_WAV_NO_TRANS_CREATED');
945: fnd_msg_pub.add;
946: x_waiver_amount := 0;
947: RAISE fnd_api.g_exc_error;

Line 1265: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON');

1261: --validate person id
1262: IF p_n_person_id IS NOT NULL THEN
1263: l_v_valid_person := igs_fi_gen_007.validate_person(p_person_id => p_n_person_id);
1264: IF l_v_valid_person = 'N' THEN
1265: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON');
1266: fnd_file.put_line(fnd_file.log,fnd_message.get);
1267: l_b_parameter_val_status := FALSE;
1268: END IF;
1269: END IF;

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

1262: IF p_n_person_id IS NOT NULL THEN
1263: l_v_valid_person := igs_fi_gen_007.validate_person(p_person_id => p_n_person_id);
1264: IF l_v_valid_person = 'N' THEN
1265: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON');
1266: fnd_file.put_line(fnd_file.log,fnd_message.get);
1267: l_b_parameter_val_status := FALSE;
1268: END IF;
1269: END IF;
1270:

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

1273: OPEN cur_chk_per_grp_id(p_n_person_grp_id);
1274: FETCH cur_chk_per_grp_id into l_v_dummy;
1275: IF cur_chk_per_grp_id%NOTFOUND THEN
1276: CLOSE cur_chk_per_grp_id;
1277: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1278: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||p_n_person_id);
1279: fnd_file.put_line(fnd_file.log,fnd_message.get);
1280: l_b_parameter_val_status := FALSE;
1281: ELSE

Line 1278: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||p_n_person_id);

1274: FETCH cur_chk_per_grp_id into l_v_dummy;
1275: IF cur_chk_per_grp_id%NOTFOUND THEN
1276: CLOSE cur_chk_per_grp_id;
1277: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1278: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||p_n_person_id);
1279: fnd_file.put_line(fnd_file.log,fnd_message.get);
1280: l_b_parameter_val_status := FALSE;
1281: ELSE
1282: CLOSE cur_chk_per_grp_id;

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

1275: IF cur_chk_per_grp_id%NOTFOUND THEN
1276: CLOSE cur_chk_per_grp_id;
1277: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1278: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||p_n_person_id);
1279: fnd_file.put_line(fnd_file.log,fnd_message.get);
1280: l_b_parameter_val_status := FALSE;
1281: ELSE
1282: CLOSE cur_chk_per_grp_id;
1283: END IF;

Line 1288: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');

1284: END IF;
1285:
1286: --person number and person grp id both cannot be provided.
1287: IF p_n_person_id IS NOT NULL AND p_n_person_grp_id IS NOT NULL THEN
1288: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
1289: fnd_file.put_line(fnd_file.log,fnd_message.get);
1290: l_b_parameter_val_status := FALSE;
1291: END IF;
1292:

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

1285:
1286: --person number and person grp id both cannot be provided.
1287: IF p_n_person_id IS NOT NULL AND p_n_person_grp_id IS NOT NULL THEN
1288: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
1289: fnd_file.put_line(fnd_file.log,fnd_message.get);
1290: l_b_parameter_val_status := FALSE;
1291: END IF;
1292:
1293: IF p_v_fee_cal IS NOT NULL THEN

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

1306: p_n_ld_ci_sequence_number => l_n_ld_ci_sequence_number ,
1307: p_v_message_name => l_v_message_name ,
1308: p_b_return_stat =>l_b_return_stat);
1309: IF NOT l_b_return_stat THEN
1310: fnd_message.set_name('IGS',l_v_message_name);
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: l_b_parameter_val_status := FALSE;
1313: END IF;
1314: ELSE

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

1307: p_v_message_name => l_v_message_name ,
1308: p_b_return_stat =>l_b_return_stat);
1309: IF NOT l_b_return_stat THEN
1310: fnd_message.set_name('IGS',l_v_message_name);
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: l_b_parameter_val_status := FALSE;
1313: END IF;
1314: ELSE
1315: -- The Message 'Invalid Fee Period Parameters Passed To The Process.' Is Logged If

Line 1317: fnd_message.set_name('IGS','IGS_FI_FCI_NOTFOUND');

1313: END IF;
1314: ELSE
1315: -- The Message 'Invalid Fee Period Parameters Passed To The Process.' Is Logged If
1316: -- The Function Returns False.
1317: fnd_message.set_name('IGS','IGS_FI_FCI_NOTFOUND');
1318: fnd_file.put_line(fnd_file.log,fnd_message.get);
1319: l_b_parameter_val_status := FALSE;
1320: END IF;
1321: END IF;

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

1314: ELSE
1315: -- The Message 'Invalid Fee Period Parameters Passed To The Process.' Is Logged If
1316: -- The Function Returns False.
1317: fnd_message.set_name('IGS','IGS_FI_FCI_NOTFOUND');
1318: fnd_file.put_line(fnd_file.log,fnd_message.get);
1319: l_b_parameter_val_status := FALSE;
1320: END IF;
1321: END IF;
1322:

Line 1329: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WPRG_FTYP_NOT_EXIST');

1325: IF p_v_fee_cal IS NOT NULL THEN
1326: OPEN cur_chk_waiver_name(l_v_fee_cal_type, l_n_fee_ci_sequence_number, p_v_waiver_name);
1327: FETCH cur_chk_waiver_name INTO l_rec_cur_chk_waiver_name;
1328: IF cur_chk_waiver_name%NOTFOUND THEN
1329: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WPRG_FTYP_NOT_EXIST');
1330: fnd_file.put_line(fnd_file.log,fnd_message.get);
1331: l_b_parameter_val_status := FALSE;
1332: END IF;
1333: CLOSE cur_chk_waiver_name;

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

1326: OPEN cur_chk_waiver_name(l_v_fee_cal_type, l_n_fee_ci_sequence_number, p_v_waiver_name);
1327: FETCH cur_chk_waiver_name INTO l_rec_cur_chk_waiver_name;
1328: IF cur_chk_waiver_name%NOTFOUND THEN
1329: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WPRG_FTYP_NOT_EXIST');
1330: fnd_file.put_line(fnd_file.log,fnd_message.get);
1331: l_b_parameter_val_status := FALSE;
1332: END IF;
1333: CLOSE cur_chk_waiver_name;
1334:

Line 1336: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_CAT_INVALID');

1332: END IF;
1333: CLOSE cur_chk_waiver_name;
1334:
1335: IF l_rec_cur_chk_waiver_name.WAIVER_METHOD_CODE <> 'COMP_RULE' THEN
1336: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_CAT_INVALID');
1337: fnd_file.put_line(fnd_file.log,fnd_message.get);
1338: l_b_parameter_val_status := FALSE;
1339: END IF;
1340: END IF;

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

1333: CLOSE cur_chk_waiver_name;
1334:
1335: IF l_rec_cur_chk_waiver_name.WAIVER_METHOD_CODE <> 'COMP_RULE' THEN
1336: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_CAT_INVALID');
1337: fnd_file.put_line(fnd_file.log,fnd_message.get);
1338: l_b_parameter_val_status := FALSE;
1339: END IF;
1340: END IF;
1341:

Line 1344: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');

1340: END IF;
1341:
1342: IF p_v_fee_type IS NOT NULL THEN
1343: IF l_rec_cur_chk_waiver_name.TARGET_FEE_TYPE <> p_v_fee_type THEN
1344: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');
1345: fnd_file.put_line(fnd_file.log,fnd_message.get);
1346: l_b_parameter_val_status := FALSE;
1347: END IF;
1348: END IF;

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

1341:
1342: IF p_v_fee_type IS NOT NULL THEN
1343: IF l_rec_cur_chk_waiver_name.TARGET_FEE_TYPE <> p_v_fee_type THEN
1344: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');
1345: fnd_file.put_line(fnd_file.log,fnd_message.get);
1346: l_b_parameter_val_status := FALSE;
1347: END IF;
1348: END IF;
1349:

Line 1358: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');

1354: IF p_v_fee_cal IS NOT NULL THEN
1355: OPEN cur_chk_fee_type(l_v_fee_cal_type, l_n_fee_ci_sequence_number, p_v_fee_type);
1356: FETCH cur_chk_fee_type INTO l_v_dummy;
1357: IF cur_chk_fee_type%NOTFOUND THEN
1358: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');
1359: fnd_file.put_line(fnd_file.log,fnd_message.get);
1360: l_b_parameter_val_status := FALSE;
1361: END IF;
1362:

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

1355: OPEN cur_chk_fee_type(l_v_fee_cal_type, l_n_fee_ci_sequence_number, p_v_fee_type);
1356: FETCH cur_chk_fee_type INTO l_v_dummy;
1357: IF cur_chk_fee_type%NOTFOUND THEN
1358: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WAV_FEE_CAL_INST');
1359: fnd_file.put_line(fnd_file.log,fnd_message.get);
1360: l_b_parameter_val_status := FALSE;
1361: END IF;
1362:
1363: END IF;

Line 1368: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INSUFFICIENT_PARAMETER');

1364: END IF;
1365:
1366: -- To Validate The Parameter Gl Date
1367: IF p_d_gl_date IS NULL THEN
1368: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1369: fnd_file.put_line(fnd_file.log,fnd_message.get);
1370: l_b_parameter_val_status := FALSE;
1371: ELSE
1372: igs_fi_gen_gl.get_period_status_for_date(p_d_date => igs_ge_date.igsdate(p_d_gl_date),

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

1365:
1366: -- To Validate The Parameter Gl Date
1367: IF p_d_gl_date IS NULL THEN
1368: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1369: fnd_file.put_line(fnd_file.log,fnd_message.get);
1370: l_b_parameter_val_status := FALSE;
1371: ELSE
1372: igs_fi_gen_gl.get_period_status_for_date(p_d_date => igs_ge_date.igsdate(p_d_gl_date),
1373: p_v_closing_status => l_v_closing_status,

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

1372: igs_fi_gen_gl.get_period_status_for_date(p_d_date => igs_ge_date.igsdate(p_d_gl_date),
1373: p_v_closing_status => l_v_closing_status,
1374: p_v_message_name => l_v_message_name);
1375: IF l_v_message_name IS NOT NULL THEN
1376: fnd_message.set_name('IGS',l_v_message_name);
1377: fnd_file.put_line(fnd_file.log,fnd_message.get);
1378: l_b_parameter_val_status := FALSE;
1379: END IF;
1380:

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

1373: p_v_closing_status => l_v_closing_status,
1374: p_v_message_name => l_v_message_name);
1375: IF l_v_message_name IS NOT NULL THEN
1376: fnd_message.set_name('IGS',l_v_message_name);
1377: fnd_file.put_line(fnd_file.log,fnd_message.get);
1378: l_b_parameter_val_status := FALSE;
1379: END IF;
1380:
1381: IF l_v_closing_status NOT IN ('O','F') THEN

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

1378: l_b_parameter_val_status := FALSE;
1379: END IF;
1380:
1381: IF l_v_closing_status NOT IN ('O','F') THEN
1382: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1383: fnd_message.set_token('GL_DATE',p_d_gl_date);
1384: fnd_file.put_line(fnd_file.log,fnd_message.get);
1385: l_b_parameter_val_status := FALSE;
1386: END IF;

Line 1383: fnd_message.set_token('GL_DATE',p_d_gl_date);

1379: END IF;
1380:
1381: IF l_v_closing_status NOT IN ('O','F') THEN
1382: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1383: fnd_message.set_token('GL_DATE',p_d_gl_date);
1384: fnd_file.put_line(fnd_file.log,fnd_message.get);
1385: l_b_parameter_val_status := FALSE;
1386: END IF;
1387:

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

1380:
1381: IF l_v_closing_status NOT IN ('O','F') THEN
1382: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
1383: fnd_message.set_token('GL_DATE',p_d_gl_date);
1384: fnd_file.put_line(fnd_file.log,fnd_message.get);
1385: l_b_parameter_val_status := FALSE;
1386: END IF;
1387:
1388: END IF;

Line 1418: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1414: --Who When What
1415: -------------------------------------------------------------------
1416: BEGIN
1417: --Logging Person Number.
1418: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1419: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1420: fnd_file.put_line(fnd_file.log,fnd_message.get);
1421:
1422: --Logging Waiver Program Name.

Line 1419: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));

1415: -------------------------------------------------------------------
1416: BEGIN
1417: --Logging Person Number.
1418: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1419: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1420: fnd_file.put_line(fnd_file.log,fnd_message.get);
1421:
1422: --Logging Waiver Program Name.
1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1416: BEGIN
1417: --Logging Person Number.
1418: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1419: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1420: fnd_file.put_line(fnd_file.log,fnd_message.get);
1421:
1422: --Logging Waiver Program Name.
1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);

Line 1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1419: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1420: fnd_file.put_line(fnd_file.log,fnd_message.get);
1421:
1422: --Logging Waiver Program Name.
1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1425: fnd_file.put_line(fnd_file.log,fnd_message.get);
1426:
1427: --Logging Fee Type

Line 1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);

1420: fnd_file.put_line(fnd_file.log,fnd_message.get);
1421:
1422: --Logging Waiver Program Name.
1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1425: fnd_file.put_line(fnd_file.log,fnd_message.get);
1426:
1427: --Logging Fee Type
1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1421:
1422: --Logging Waiver Program Name.
1423: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1425: fnd_file.put_line(fnd_file.log,fnd_message.get);
1426:
1427: --Logging Fee Type
1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1429: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);

Line 1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1424: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1425: fnd_file.put_line(fnd_file.log,fnd_message.get);
1426:
1427: --Logging Fee Type
1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1429: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1430: fnd_file.put_line(fnd_file.log,fnd_message.get);
1431:
1432: IF p_v_status = 'SUCCESS' THEN

Line 1429: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);

1425: fnd_file.put_line(fnd_file.log,fnd_message.get);
1426:
1427: --Logging Fee Type
1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1429: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1430: fnd_file.put_line(fnd_file.log,fnd_message.get);
1431:
1432: IF p_v_status = 'SUCCESS' THEN
1433: --Logging Waiver Amount

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

1426:
1427: --Logging Fee Type
1428: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1429: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1430: fnd_file.put_line(fnd_file.log,fnd_message.get);
1431:
1432: IF p_v_status = 'SUCCESS' THEN
1433: --Logging Waiver Amount
1434: fnd_message.set_name('IGS','IGS_FI_END_DATE');

Line 1434: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1430: fnd_file.put_line(fnd_file.log,fnd_message.get);
1431:
1432: IF p_v_status = 'SUCCESS' THEN
1433: --Logging Waiver Amount
1434: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1435: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||p_n_waiver_amount);
1436: fnd_file.put_line(fnd_file.log,fnd_message.get);
1437: END IF;
1438:

Line 1435: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||p_n_waiver_amount);

1431:
1432: IF p_v_status = 'SUCCESS' THEN
1433: --Logging Waiver Amount
1434: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1435: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||p_n_waiver_amount);
1436: fnd_file.put_line(fnd_file.log,fnd_message.get);
1437: END IF;
1438:
1439: --Logging Status

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

1432: IF p_v_status = 'SUCCESS' THEN
1433: --Logging Waiver Amount
1434: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1435: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||p_n_waiver_amount);
1436: fnd_file.put_line(fnd_file.log,fnd_message.get);
1437: END IF;
1438:
1439: --Logging Status
1440: fnd_message.set_name('IGS','IGS_FI_END_DATE');

Line 1440: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1436: fnd_file.put_line(fnd_file.log,fnd_message.get);
1437: END IF;
1438:
1439: --Logging Status
1440: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1441: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS')||': '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',p_v_status));
1442: fnd_file.put_line(fnd_file.log,fnd_message.get);
1443:
1444: END log_result;

Line 1441: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS')||': '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',p_v_status));

1437: END IF;
1438:
1439: --Logging Status
1440: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1441: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS')||': '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',p_v_status));
1442: fnd_file.put_line(fnd_file.log,fnd_message.get);
1443:
1444: END log_result;
1445:

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

1438:
1439: --Logging Status
1440: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1441: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS')||': '||igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',p_v_status));
1442: fnd_file.put_line(fnd_file.log,fnd_message.get);
1443:
1444: END log_result;
1445:
1446: PROCEDURE log_in_parameters(p_n_person_id IN hz_parties.party_id%TYPE,

Line 1493: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1489:
1490: FETCH c_get_alt_code INTO l_c_alt_code_desc;
1491: CLOSE c_get_alt_code;
1492: g_v_alternatecode := l_c_alt_code_desc.alternate_code;
1493: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1494: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||': '||l_c_alt_code_desc.alternate_code);
1495: fnd_file.put_line(fnd_file.log,fnd_message.get);
1496:
1497: --Logging Person Number.

Line 1494: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||': '||l_c_alt_code_desc.alternate_code);

1490: FETCH c_get_alt_code INTO l_c_alt_code_desc;
1491: CLOSE c_get_alt_code;
1492: g_v_alternatecode := l_c_alt_code_desc.alternate_code;
1493: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1494: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||': '||l_c_alt_code_desc.alternate_code);
1495: fnd_file.put_line(fnd_file.log,fnd_message.get);
1496:
1497: --Logging Person Number.
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1491: CLOSE c_get_alt_code;
1492: g_v_alternatecode := l_c_alt_code_desc.alternate_code;
1493: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1494: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||': '||l_c_alt_code_desc.alternate_code);
1495: fnd_file.put_line(fnd_file.log,fnd_message.get);
1496:
1497: --Logging Person Number.
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));

Line 1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1494: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD')||': '||l_c_alt_code_desc.alternate_code);
1495: fnd_file.put_line(fnd_file.log,fnd_message.get);
1496:
1497: --Logging Person Number.
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1500: fnd_file.put_line(fnd_file.log,fnd_message.get);
1501:
1502: --Logging Person Group.

Line 1499: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));

1495: fnd_file.put_line(fnd_file.log,fnd_message.get);
1496:
1497: --Logging Person Number.
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1500: fnd_file.put_line(fnd_file.log,fnd_message.get);
1501:
1502: --Logging Person Group.
1503: OPEN c_get_person_grp(p_n_person_grp_id);

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

1496:
1497: --Logging Person Number.
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1500: fnd_file.put_line(fnd_file.log,fnd_message.get);
1501:
1502: --Logging Person Group.
1503: OPEN c_get_person_grp(p_n_person_grp_id);
1504: FETCH c_get_person_grp INTO l_c_get_person_grp;

Line 1506: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1502: --Logging Person Group.
1503: OPEN c_get_person_grp(p_n_person_grp_id);
1504: FETCH c_get_person_grp INTO l_c_get_person_grp;
1505: CLOSE c_get_person_grp;
1506: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1507: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);
1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509:
1510: --Logging Waiver Program Name.

Line 1507: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);

1503: OPEN c_get_person_grp(p_n_person_grp_id);
1504: FETCH c_get_person_grp INTO l_c_get_person_grp;
1505: CLOSE c_get_person_grp;
1506: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1507: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);
1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509:
1510: --Logging Waiver Program Name.
1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1504: FETCH c_get_person_grp INTO l_c_get_person_grp;
1505: CLOSE c_get_person_grp;
1506: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1507: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);
1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509:
1510: --Logging Waiver Program Name.
1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);

Line 1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1507: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);
1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509:
1510: --Logging Waiver Program Name.
1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1513: fnd_file.put_line(fnd_file.log,fnd_message.get);
1514:
1515: --Logging Fee Type

Line 1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);

1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509:
1510: --Logging Waiver Program Name.
1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1513: fnd_file.put_line(fnd_file.log,fnd_message.get);
1514:
1515: --Logging Fee Type
1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1509:
1510: --Logging Waiver Program Name.
1511: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1513: fnd_file.put_line(fnd_file.log,fnd_message.get);
1514:
1515: --Logging Fee Type
1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);

Line 1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1512: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_NAME')||': '||p_v_waiver_name);
1513: fnd_file.put_line(fnd_file.log,fnd_message.get);
1514:
1515: --Logging Fee Type
1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519:
1520: --Logging GL Date.

Line 1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);

1513: fnd_file.put_line(fnd_file.log,fnd_message.get);
1514:
1515: --Logging Fee Type
1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519:
1520: --Logging GL Date.
1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');

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

1514:
1515: --Logging Fee Type
1516: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519:
1520: --Logging GL Date.
1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1522: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||p_d_gl_date);

Line 1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');

1517: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519:
1520: --Logging GL Date.
1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1522: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||p_d_gl_date);
1523: fnd_file.put_line(fnd_file.log,fnd_message.get);
1524:
1525: END log_in_parameters;

Line 1522: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||p_d_gl_date);

1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519:
1520: --Logging GL Date.
1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1522: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||p_d_gl_date);
1523: fnd_file.put_line(fnd_file.log,fnd_message.get);
1524:
1525: END log_in_parameters;
1526:

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

1519:
1520: --Logging GL Date.
1521: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1522: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||p_d_gl_date);
1523: fnd_file.put_line(fnd_file.log,fnd_message.get);
1524:
1525: END log_in_parameters;
1526:
1527:

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

1638: l_org_id := NULL;
1639: igs_ge_gen_003.set_org_id(l_org_id);
1640: EXCEPTION
1641: WHEN OTHERS THEN
1642: fnd_file.put_line (fnd_file.log, fnd_message.get);
1643: retcode:=2;
1644: RETURN;
1645: END;
1646:

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

1664: p_v_message_name => l_v_message_name);
1665:
1666: IF l_v_manage_acc IS NULL OR l_v_manage_acc = 'OTHER' THEN
1667: fnd_file.new_line(fnd_file.log);
1668: fnd_message.set_name('IGS',l_v_message_name);
1669: fnd_file.put_line(fnd_file.log,fnd_message.get);
1670: retcode := 2;
1671: RETURN;
1672: END IF;

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

1665:
1666: IF l_v_manage_acc IS NULL OR l_v_manage_acc = 'OTHER' THEN
1667: fnd_file.new_line(fnd_file.log);
1668: fnd_message.set_name('IGS',l_v_message_name);
1669: fnd_file.put_line(fnd_file.log,fnd_message.get);
1670: retcode := 2;
1671: RETURN;
1672: END IF;
1673:

Line 1699: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');

1695: p_v_message_name => l_v_message_name );
1696:
1697: IF ((l_conv_process_run_ind IS NOT NULL) AND (l_conv_process_run_ind = 1)) THEN
1698: fnd_file.new_line(fnd_file.log);
1699: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get());
1701: retcode := 2;
1702: RETURN;
1703: END IF;

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

1696:
1697: IF ((l_conv_process_run_ind IS NOT NULL) AND (l_conv_process_run_ind = 1)) THEN
1698: fnd_file.new_line(fnd_file.log);
1699: fnd_message.set_name('IGS','IGS_FI_REASS_BAL_PRC_RUN');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get());
1701: retcode := 2;
1702: RETURN;
1703: END IF;
1704:

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

1703: END IF;
1704:
1705: IF ((l_v_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1706: fnd_file.new_line(fnd_file.log);
1707: fnd_message.set_name('IGS',l_v_message_name);
1708: fnd_file.put_line(fnd_file.log,fnd_message.get());
1709: retcode := 2;
1710: RETURN;
1711: END IF;

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

1704:
1705: IF ((l_v_message_name IS NOT NULL) AND (l_conv_process_run_ind IS NULL)) THEN
1706: fnd_file.new_line(fnd_file.log);
1707: fnd_message.set_name('IGS',l_v_message_name);
1708: fnd_file.put_line(fnd_file.log,fnd_message.get());
1709: retcode := 2;
1710: RETURN;
1711: END IF;
1712:

Line 1724: fnd_message.set_name('IGS','IGS_FI_CANNOT_CRT_TXN');

1720: IF l_n_version_number = 0 THEN
1721:
1722: --no active balance rule exists
1723: fnd_file.new_line(fnd_file.log);
1724: fnd_message.set_name('IGS','IGS_FI_CANNOT_CRT_TXN');
1725: fnd_file.put_line(fnd_file.log,fnd_message.get());
1726: retcode := 2;
1727: RETURN;
1728: END IF;

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

1721:
1722: --no active balance rule exists
1723: fnd_file.new_line(fnd_file.log);
1724: fnd_message.set_name('IGS','IGS_FI_CANNOT_CRT_TXN');
1725: fnd_file.put_line(fnd_file.log,fnd_message.get());
1726: retcode := 2;
1727: RETURN;
1728: END IF;
1729:

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

1737: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(p_person_grp_id,l_v_status );
1738: IF l_v_status <> 'S' THEN
1739:
1740: --Log the error message and stop the processing.
1741: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: retcode := 2;
1744: RETURN;
1745: END IF;

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

1738: IF l_v_status <> 'S' THEN
1739:
1740: --Log the error message and stop the processing.
1741: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: retcode := 2;
1744: RETURN;
1745: END IF;
1746:

Line 1797: fnd_message.set_encoded(l_v_msg_data);

1793: p_n_waiver_amount => NULL,
1794: p_v_status => 'FAIL');
1795:
1796: IF l_n_msg_count = 1 THEN
1797: fnd_message.set_encoded(l_v_msg_data);
1798: fnd_file.put_line(fnd_file.log,fnd_message.get);
1799: ELSE
1800: FOR l_count IN 1 .. l_n_msg_count LOOP
1801: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');

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

1794: p_v_status => 'FAIL');
1795:
1796: IF l_n_msg_count = 1 THEN
1797: fnd_message.set_encoded(l_v_msg_data);
1798: fnd_file.put_line(fnd_file.log,fnd_message.get);
1799: ELSE
1800: FOR l_count IN 1 .. l_n_msg_count LOOP
1801: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1802: fnd_message.set_encoded(l_msg);

Line 1802: fnd_message.set_encoded(l_msg);

1798: fnd_file.put_line(fnd_file.log,fnd_message.get);
1799: ELSE
1800: FOR l_count IN 1 .. l_n_msg_count LOOP
1801: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1802: fnd_message.set_encoded(l_msg);
1803: fnd_file.put_line(fnd_file.log,fnd_message.get);
1804: END LOOP;
1805: END IF;
1806: ELSIF l_v_return_status = 'S' THEN

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

1799: ELSE
1800: FOR l_count IN 1 .. l_n_msg_count LOOP
1801: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1802: fnd_message.set_encoded(l_msg);
1803: fnd_file.put_line(fnd_file.log,fnd_message.get);
1804: END LOOP;
1805: END IF;
1806: ELSIF l_v_return_status = 'S' THEN
1807: fnd_file.new_line(fnd_file.log,2);

Line 1873: fnd_message.set_encoded(l_v_msg_data);

1869: p_n_waiver_amount => NULL,
1870: p_v_status => 'FAIL');
1871:
1872: IF l_n_msg_count = 1 THEN
1873: fnd_message.set_encoded(l_v_msg_data);
1874: fnd_file.put_line(fnd_file.log,fnd_message.get);
1875: ELSE
1876: FOR l_count IN 1 .. l_n_msg_count LOOP
1877: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');

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

1870: p_v_status => 'FAIL');
1871:
1872: IF l_n_msg_count = 1 THEN
1873: fnd_message.set_encoded(l_v_msg_data);
1874: fnd_file.put_line(fnd_file.log,fnd_message.get);
1875: ELSE
1876: FOR l_count IN 1 .. l_n_msg_count LOOP
1877: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1878: fnd_message.set_encoded(l_msg);

Line 1878: fnd_message.set_encoded(l_msg);

1874: fnd_file.put_line(fnd_file.log,fnd_message.get);
1875: ELSE
1876: FOR l_count IN 1 .. l_n_msg_count LOOP
1877: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1878: fnd_message.set_encoded(l_msg);
1879: fnd_file.put_line(fnd_file.log,fnd_message.get);
1880: END LOOP;
1881: END IF;
1882: ELSIF l_v_return_status = 'S' THEN

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

1875: ELSE
1876: FOR l_count IN 1 .. l_n_msg_count LOOP
1877: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1878: fnd_message.set_encoded(l_msg);
1879: fnd_file.put_line(fnd_file.log,fnd_message.get);
1880: END LOOP;
1881: END IF;
1882: ELSIF l_v_return_status = 'S' THEN
1883: fnd_file.new_line(fnd_file.log,2);

Line 1899: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');

1895: END IF;
1896:
1897: IF NOT l_b_flag THEN
1898: fnd_file.new_line(fnd_file.log);
1899: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
1900: fnd_file.put_line(fnd_file.log,fnd_message.get);
1901: END IF;
1902:
1903: EXCEPTION

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

1896:
1897: IF NOT l_b_flag THEN
1898: fnd_file.new_line(fnd_file.log);
1899: fnd_message.set_name('IGS','IGS_GE_NO_DATA_FOUND');
1900: fnd_file.put_line(fnd_file.log,fnd_message.get);
1901: END IF;
1902:
1903: EXCEPTION
1904: WHEN OTHERS THEN

Line 1907: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: ROLLBACK TO sp_process_waivers;
1906: retcode := 2;
1907: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1908: igs_ge_msg_stack.conc_exception_hndl;
1909:
1910: END process_waivers;
1911: END igs_fi_prc_waivers;