eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_LI_IMPORT dependencies on FND_LOG

Line 156: g_debug_string fnd_log_messages.message_text%TYPE;

152: g_award_id igf_aw_award_all.award_id%TYPE;
153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;
154: g_person_id hz_parties.party_id%TYPE;
155: g_processing_string VARCHAR2(1000);
156: g_debug_string fnd_log_messages.message_text%TYPE;
157: g_debug_runtime_level NUMBER;
158: g_entry_point VARCHAR2(30);
159:
160: g_print_msg VARCHAR2(200);

Line 234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

230: IF l_get_fab.base_id IS NOT NULL THEN
231:
232: FOR l_items IN c_items(l_get_fab.base_id)
233: LOOP
234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the item level');
236: END IF;
237:
238: igf_aw_coa_items_pkg.update_row(

Line 235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the item level');

231:
232: FOR l_items IN c_items(l_get_fab.base_id)
233: LOOP
234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the item level');
236: END IF;
237:
238: igf_aw_coa_items_pkg.update_row(
239: x_rowid => l_items.row_id,

Line 254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

250:
251:
252: FOR l_terms IN c_terms(l_get_fab.base_id,l_items.item_code)
253: LOOP
254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the term level');
256: END IF;
257:
258: igf_aw_coa_itm_terms_pkg.update_row(

Line 255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the term level');

251:
252: FOR l_terms IN c_terms(l_get_fab.base_id,l_items.item_code)
253: LOOP
254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','locking at the term level');
256: END IF;
257:
258: igf_aw_coa_itm_terms_pkg.update_row(
259: x_rowid => l_terms.row_id,

Line 273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

269: END LOOP;
270: END LOOP;
271:
272:
273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','l_get_fab.base_id IS NOT NULL');
275: END IF;
276:
277: igf_ap_fa_base_rec_pkg.update_row

Line 274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','l_get_fab.base_id IS NOT NULL');

270: END LOOP;
271:
272:
273: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
274: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.lock_std_coa.debug','l_get_fab.base_id IS NOT NULL');
275: END IF;
276:
277: igf_ap_fa_base_rec_pkg.update_row
278: (x_Mode => 'R',

Line 401: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

397: EXCEPTION
398: WHEN OTHERS THEN
399: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
400: fnd_message.set_token('NAME','igf_aw_li_import.lock_std_coa :' || SQLERRM);
401: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
402: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_li_import.lock_std_coa.exception','sql error:'||SQLERRM);
403: END IF;
404: igs_ge_msg_stack.conc_exception_hndl;
405: app_exception.raise_exception;

Line 402: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_li_import.lock_std_coa.exception','sql error:'||SQLERRM);

398: WHEN OTHERS THEN
399: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
400: fnd_message.set_token('NAME','igf_aw_li_import.lock_std_coa :' || SQLERRM);
401: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
402: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_li_import.lock_std_coa.exception','sql error:'||SQLERRM);
403: END IF;
404: igs_ge_msg_stack.conc_exception_hndl;
405: app_exception.raise_exception;
406:

Line 565: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

561: OPEN c_get_pay_isir; FETCH c_get_pay_isir INTO l_payment_isir_id; CLOSE c_get_pay_isir;
562: OPEN c_get_fund_source; FETCH c_get_fund_source INTO l_fund_source; CLOSE c_get_fund_source;
563: OPEN c_get_fund_amt; FETCH c_get_fund_amt INTO c_get_fund_amt_rec; CLOSE c_get_fund_amt;
564:
565: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
566: g_debug_string := 'Fund ID'||g_fund_id||', Payment Isir'||l_payment_isir_id||',Fund Source'||l_fund_source||
567: ',Remaining Amt'||c_get_fund_amt_rec.remaining_amt||',Max Award Amount'||
568: c_get_fund_amt_rec.max_Award_amt||',Max Yearly Amt'||c_get_fund_amt_rec.max_yearly_amt||
569: ',Max Life Amount'||c_get_fund_amt_rec.max_life_amt;

Line 616: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

612: -- sum of total year award amount and legacy award amount greater than the maximum year amount
613: -- defined at the fund
614: c_std_max_yr_amt_rec := NULL;
615: OPEN c_std_max_yr_amt; FETCH c_std_max_yr_amt INTO c_std_max_yr_amt_rec; CLOSE c_std_max_yr_amt;
616: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
617: g_debug_string := g_debug_string ||'Year Total'||c_std_max_yr_amt_rec.yr_total;
618: END IF;
619: IF((c_get_fund_amt_rec.max_yearly_amt IS NOT NULL) AND
620: ((c_std_max_yr_amt_rec.yr_total + li_awd_rec.offered_amt) > c_get_fund_amt_rec.max_yearly_amt))THEN

Line 630: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

626: -- sum of total life award amount and legacy award amount greater than the maximum life amount defined
627: -- at the fund
628: c_std_max_lf_count_rec := NULL;
629: OPEN c_std_max_lf_count; FETCH c_std_max_lf_count INTO c_std_max_lf_count_rec; CLOSE c_std_max_lf_count;
630: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
631: g_debug_string := g_debug_string ||'Life Total'||c_std_max_lf_count_rec.lf_total;
632: END IF;
633: IF((c_get_fund_amt_rec.max_life_amt IS NOT NULL) AND
634: ((c_std_max_lf_count_rec.lf_total + li_awd_rec.offered_amt) > c_get_fund_amt_rec.max_life_amt))THEN

Line 653: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

649: FND_MESSAGE.SET_TOKEN('FUND',g_fund_code);
650: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
651: END LOOP;
652:
653: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_open_award_year.debug',g_debug_string);
655: g_debug_string := NULL;
656: END IF;
657: EXCEPTION WHEN OTHERS THEN

Line 654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_open_award_year.debug',g_debug_string);

650: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
651: END LOOP;
652:
653: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
654: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_open_award_year.debug',g_debug_string);
655: g_debug_string := NULL;
656: END IF;
657: EXCEPTION WHEN OTHERS THEN
658: l_status_open_awd_yr :='E';

Line 659: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

655: g_debug_string := NULL;
656: END IF;
657: EXCEPTION WHEN OTHERS THEN
658: l_status_open_awd_yr :='E';
659: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
660: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
661: 'igf.plsql.igf_aw_li_import.validate_open_award_year.exception',
662: SQLERRM );
663: END IF;

Line 660: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

656: END IF;
657: EXCEPTION WHEN OTHERS THEN
658: l_status_open_awd_yr :='E';
659: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
660: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
661: 'igf.plsql.igf_aw_li_import.validate_open_award_year.exception',
662: SQLERRM );
663: END IF;
664: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 1025: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1021: );
1022:
1023: EXCEPTION
1024: WHEN igf_se_gen_001.IGFSEGEN001 THEN
1025: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);
1027: END IF;
1028: l_awd_ins_status := 'E';
1029: RETURN;

Line 1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);

1022:
1023: EXCEPTION
1024: WHEN igf_se_gen_001.IGFSEGEN001 THEN
1025: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1026: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);
1027: END IF;
1028: l_awd_ins_status := 'E';
1029: RETURN;
1030:

Line 1035: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1031: WHEN OTHERS THEN
1032: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1033: FND_MESSAGE.SET_TOKEN('NAME','CREATING WORK AUTHORIZATION : '||SQLERRM);
1034: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(' ',3,' ')||'-- '||FND_MESSAGE.GET);
1035: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1036: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);
1037: END IF;
1038: l_awd_ins_status := 'E';
1039: RETURN;

Line 1036: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);

1032: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
1033: FND_MESSAGE.SET_TOKEN('NAME','CREATING WORK AUTHORIZATION : '||SQLERRM);
1034: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(' ',3,' ')||'-- '||FND_MESSAGE.GET);
1035: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1036: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_work_authorization.exception',SQLERRM);
1037: END IF;
1038: l_awd_ins_status := 'E';
1039: RETURN;
1040: END;

Line 1045: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1041: END IF;
1042:
1043: EXCEPTION WHEN OTHERS THEN
1044: l_awd_ins_status := 'E';
1045: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1047: 'igf.plsql.igf_aw_li_import.create_award_record.exception',
1048: SQLERRM );
1049: END IF;

Line 1046: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1042:
1043: EXCEPTION WHEN OTHERS THEN
1044: l_awd_ins_status := 'E';
1045: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1047: 'igf.plsql.igf_aw_li_import.create_award_record.exception',
1048: SQLERRM );
1049: END IF;
1050: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 1264: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1260: END upd_aw_rec_with_legacy_status;
1261:
1262: BEGIN -- begin of validate_awdyear_int_rec
1263:
1264: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','start' );
1266: END IF;
1267:
1268: -- initialize the return statuses, assuming all the validations are successful.

Line 1265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','start' );

1261:
1262: BEGIN -- begin of validate_awdyear_int_rec
1263:
1264: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1265: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','start' );
1266: END IF;
1267:
1268: -- initialize the return statuses, assuming all the validations are successful.
1269: l_return_value :='S'; l_status_open_awd_yr :='S'; l_return_status_db := 'S';

Line 1317: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

1313: -- second, validate if the fund code in the interface table matches with that of the fund master
1314:
1315: g_fund_code := NULL; g_fed_fund_code := NULL; g_fund_id := NULL;
1316: OPEN cur_get_fund_code(li_awd_rec.fund_code); FETCH cur_get_fund_code INTO g_fund_code, g_fed_fund_code, g_fund_id; CLOSE cur_get_fund_code;
1317: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
1318: g_debug_string := g_debug_string || 'Fund Code'||g_fund_code||'Fed Fund Code'||g_fed_fund_code||'Fund Id'||g_fund_id;
1319: END IF;
1320: IF(g_fund_code IS NULL OR g_fund_id IS NULL)THEN
1321:

Line 1333: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1329: -- delete production records only if legacy record is present in the system with legacy_record_flag = Y
1330: IF(l_award_id IS NOT NULL)THEN
1331: IF(NVL(l_legacy_record_flag,'N') = 'Y')THEN
1332:
1333: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1334: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling DELETE with award id' || l_award_id );
1335: END IF;
1336: g_update_mode := TRUE; -- bvisvana - Bug # 4635941 - To track the update mode
1337: delete_award_and_child_records(l_award_id);

Line 1334: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling DELETE with award id' || l_award_id );

1330: IF(l_award_id IS NOT NULL)THEN
1331: IF(NVL(l_legacy_record_flag,'N') = 'Y')THEN
1332:
1333: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1334: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling DELETE with award id' || l_award_id );
1335: END IF;
1336: g_update_mode := TRUE; -- bvisvana - Bug # 4635941 - To track the update mode
1337: delete_award_and_child_records(l_award_id);
1338:

Line 1339: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1335: END IF;
1336: g_update_mode := TRUE; -- bvisvana - Bug # 4635941 - To track the update mode
1337: delete_award_and_child_records(l_award_id);
1338:
1339: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1340: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','deleted records with award id' || l_award_id );
1341: END IF;
1342: ELSE
1343: l_return_value :='E';

Line 1340: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','deleted records with award id' || l_award_id );

1336: g_update_mode := TRUE; -- bvisvana - Bug # 4635941 - To track the update mode
1337: delete_award_and_child_records(l_award_id);
1338:
1339: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1340: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','deleted records with award id' || l_award_id );
1341: END IF;
1342: ELSE
1343: l_return_value :='E';
1344: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LI_UPD_FAILED_NOT_LI'); --sjalasut, should this message b changed ?

Line 1509: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

1505: FND_MESSAGE.SET_TOKEN('FUND_CODE',li_awd_rec.fund_code);
1506: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1507: END IF;
1508: END IF;
1509: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
1510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug', g_debug_string);
1511: g_debug_string := NULL;
1512: END IF;
1513:

Line 1510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug', g_debug_string);

1506: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1507: END IF;
1508: END IF;
1509: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
1510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug', g_debug_string);
1511: g_debug_string := NULL;
1512: END IF;
1513:
1514: --

Line 1537: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1533: END IF;
1534: -- sixth, if the context award year is open and the return status is not E then perform open year validations
1535: IF(l_return_value IN ('S','W') AND g_award_year_status_code = 'O')THEN
1536:
1537: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1538: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate open awd' );
1539: END IF;
1540:
1541: validate_open_award_year(li_awd_rec, l_status_open_awd_yr);

Line 1538: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate open awd' );

1534: -- sixth, if the context award year is open and the return status is not E then perform open year validations
1535: IF(l_return_value IN ('S','W') AND g_award_year_status_code = 'O')THEN
1536:
1537: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1538: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate open awd' );
1539: END IF;
1540:
1541: validate_open_award_year(li_awd_rec, l_status_open_awd_yr);
1542:

Line 1548: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1544: IF(l_return_value IN ('S','W') AND l_status_open_awd_yr IN ('S','W')) THEN
1545: BEGIN
1546:
1547: -- insert into awards table
1548: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1549: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling create awd rec' );
1550: END IF;
1551:
1552: create_award_record(li_awd_rec, l_return_status_awd);

Line 1549: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling create awd rec' );

1545: BEGIN
1546:
1547: -- insert into awards table
1548: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1549: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling create awd rec' );
1550: END IF;
1551:
1552: create_award_record(li_awd_rec, l_return_status_awd);
1553:

Line 1560: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1556: ROLLBACK TO st_def_del_award_records;
1557: RETURN;
1558: END IF;
1559:
1560: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1561: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate_disb_int_rec' );
1562: END IF;
1563:
1564: validate_disburs_int_rec(li_awd_rec, l_return_status_db);

Line 1561: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate_disb_int_rec' );

1557: RETURN;
1558: END IF;
1559:
1560: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1561: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','calling validate_disb_int_rec' );
1562: END IF;
1563:
1564: validate_disburs_int_rec(li_awd_rec, l_return_status_db);
1565:

Line 1566: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1562: END IF;
1563:
1564: validate_disburs_int_rec(li_awd_rec, l_return_status_db);
1565:
1566: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1567: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','status returned = ' || l_return_status_db );
1568: END IF;
1569:
1570: IF(l_return_status_db = 'E') THEN

Line 1567: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','status returned = ' || l_return_status_db );

1563:
1564: validate_disburs_int_rec(li_awd_rec, l_return_status_db);
1565:
1566: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1567: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','status returned = ' || l_return_status_db );
1568: END IF;
1569:
1570: IF(l_return_status_db = 'E') THEN
1571: l_return_value := 'E';

Line 1576: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1572: ROLLBACK TO st_def_del_award_records;
1573: RETURN;
1574: ELSE
1575:
1576: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1577: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','upd_awd_with_leg_stat' );
1578: END IF;
1579:
1580: upd_aw_rec_with_legacy_status(g_award_id);

Line 1577: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','upd_awd_with_leg_stat' );

1573: RETURN;
1574: ELSE
1575:
1576: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1577: fnd_log.string(fnd_log.level_exception, 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.debug','upd_awd_with_leg_stat' );
1578: END IF;
1579:
1580: upd_aw_rec_with_legacy_status(g_award_id);
1581:

Line 1591: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1587: l_return_value := 'S';
1588: END IF;
1589: EXCEPTION WHEN OTHERS THEN
1590:
1591: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1592: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1593: 'igf.plsql.igf_aw_li_import.create_award_validate_disb_section.exception',
1594: SQLERRM);
1595: END IF;

Line 1592: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1588: END IF;
1589: EXCEPTION WHEN OTHERS THEN
1590:
1591: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1592: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1593: 'igf.plsql.igf_aw_li_import.create_award_validate_disb_section.exception',
1594: SQLERRM);
1595: END IF;
1596: ROLLBACK TO st_def_del_award_records;

Line 1617: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1613: END IF;
1614: EXCEPTION WHEN OTHERS THEN
1615: ROLLBACK TO st_def_del_award_records;
1616: l_return_value :='E';
1617: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1618: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1619: 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.exception',
1620: SQLERRM);
1621: END IF;

Line 1618: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

1614: EXCEPTION WHEN OTHERS THEN
1615: ROLLBACK TO st_def_del_award_records;
1616: l_return_value :='E';
1617: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1618: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1619: 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.exception',
1620: SQLERRM);
1621: END IF;
1622: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 1944: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

1940: RETURN;
1941: END IF;
1942:
1943: EXCEPTION WHEN OTHERS THEN
1944: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1945: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_disbursment_record.exception',SQLERRM);
1946: END IF;
1947: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1948: l_disb_rec_ins_status := 'E';

Line 1945: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_disbursment_record.exception',SQLERRM);

1941: END IF;
1942:
1943: EXCEPTION WHEN OTHERS THEN
1944: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
1945: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.create_disbursment_record.exception',SQLERRM);
1946: END IF;
1947: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1948: l_disb_rec_ins_status := 'E';
1949: END create_disbursment_record;

Line 1963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1959: igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','DISBURSMNT');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
1962:
1963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','no of disb'|| cur_legacy_disb_total_rec.number_of_disb || 'max no = ' ||cur_legacy_disb_total_rec.max_disb_number);
1965: END IF;
1966: -- if total number of disbursement = 0 then error
1967: IF(cur_legacy_disb_total_rec.number_of_disb = 0)THEN

Line 1964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','no of disb'|| cur_legacy_disb_total_rec.number_of_disb || 'max no = ' ||cur_legacy_disb_total_rec.max_disb_number);

1960: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,g_processing_string);
1962:
1963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','no of disb'|| cur_legacy_disb_total_rec.number_of_disb || 'max no = ' ||cur_legacy_disb_total_rec.max_disb_number);
1965: END IF;
1966: -- if total number of disbursement = 0 then error
1967: IF(cur_legacy_disb_total_rec.number_of_disb = 0)THEN
1968: p_return_status := 'E';

Line 2059: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

2055: cur_legacy_disb_int_rec.ld_alternate_code,
2056: l_var_cal_type,
2057: l_var_seq_number);
2058:
2059: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug',
2061: 'LOAD validation ci_alternate_code'||li_awd_rec.ci_alternate_code||'ld_alternate_code:'||
2062: cur_legacy_disb_int_rec.ld_alternate_code||'l_var_cal_type'||l_var_cal_type||'l_var_seq_number'||l_var_seq_number
2063: );

Line 2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug',

2056: l_var_cal_type,
2057: l_var_seq_number);
2058:
2059: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug',
2061: 'LOAD validation ci_alternate_code'||li_awd_rec.ci_alternate_code||'ld_alternate_code:'||
2062: cur_legacy_disb_int_rec.ld_alternate_code||'l_var_cal_type'||l_var_cal_type||'l_var_seq_number'||l_var_seq_number
2063: );
2064: END IF;

Line 2464: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2460: -- process disb activity for context disb. process disb activity only if transaction type is ACTUAL or CANCELLED
2461: -- disbursement activity records are not processed for FWS funds.
2462:
2463: IF(cur_legacy_disb_int_rec.trans_type_code IN ('A','C') AND p_return_status <> 'E' AND g_fed_fund_code <> 'FWS') THEN
2464: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2465: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','calling validate_disb_act_int_rec');
2466: END IF;
2467:
2468: validate_disb_act_int_rec(li_awd_rec,cur_legacy_disb_int_rec,l_return_status_da);

Line 2465: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','calling validate_disb_act_int_rec');

2461: -- disbursement activity records are not processed for FWS funds.
2462:
2463: IF(cur_legacy_disb_int_rec.trans_type_code IN ('A','C') AND p_return_status <> 'E' AND g_fed_fund_code <> 'FWS') THEN
2464: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2465: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','calling validate_disb_act_int_rec');
2466: END IF;
2467:
2468: validate_disb_act_int_rec(li_awd_rec,cur_legacy_disb_int_rec,l_return_status_da);
2469:

Line 2470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2466: END IF;
2467:
2468: validate_disb_act_int_rec(li_awd_rec,cur_legacy_disb_int_rec,l_return_status_da);
2469:
2470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','done validate_disb_act_int_rec');
2472: END IF;
2473: IF(l_return_status_da = 'E')THEN
2474: ROLLBACK TO st_def_ins_disb_records;

Line 2471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','done validate_disb_act_int_rec');

2467:
2468: validate_disb_act_int_rec(li_awd_rec,cur_legacy_disb_int_rec,l_return_status_da);
2469:
2470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.debug','done validate_disb_act_int_rec');
2472: END IF;
2473: IF(l_return_status_da = 'E')THEN
2474: ROLLBACK TO st_def_ins_disb_records;
2475: p_return_status := 'E';

Line 2483: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

2479: END IF;
2480: END LOOP;
2481: EXCEPTION WHEN OTHERS THEN
2482: p_return_status := 'E';
2483: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
2484: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2485: 'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.exception',
2486: SQLERRM);
2487: END IF;

Line 2484: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

2480: END LOOP;
2481: EXCEPTION WHEN OTHERS THEN
2482: p_return_status := 'E';
2483: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
2484: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
2485: 'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.exception',
2486: SQLERRM);
2487: END IF;
2488: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 2817: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

2813: cur_sf_credit_num_rec := NULL;
2814: OPEN cur_sf_credit_num(cur_li_disb_act_int_rec.sf_credit_num_txt); FETCH cur_sf_credit_num INTO cur_sf_credit_num_rec;
2815: CLOSE cur_sf_credit_num;
2816: l_trans_credit_id := cur_sf_credit_num_rec.credit_id;
2817: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2818: g_debug_string := 'SF Credit Num'||cur_sf_credit_num_rec.credit_number||'credit id'||l_trans_credit_id;
2819: END IF;
2820: IF(cur_sf_credit_num_rec.credit_number IS NULL)THEN
2821: p_return_status := 'E';

Line 2842: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

2838: cur_sf_invoice_num_rec := NULL;
2839: OPEN cur_sf_invoice_num(cur_li_disb_act_int_rec.sf_invoice_num_txt); FETCH cur_sf_invoice_num INTO cur_sf_invoice_num_rec;
2840: CLOSE cur_sf_invoice_num;
2841: l_trans_invoice_id := cur_sf_invoice_num_rec.invoice_id;
2842: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2843: g_debug_string := g_debug_string ||'SF Invoice Num'||cur_sf_invoice_num_rec.invoice_number||'invoice id'||l_trans_invoice_id;
2844: END IF;
2845: IF(cur_sf_invoice_num_rec.invoice_number IS NULL)THEN
2846: p_return_status := 'E';

Line 2867: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

2863: cur_sf_credit_num_rec := NULL;
2864: OPEN cur_sf_credit_num(cur_li_disb_act_int_rec.spnsr_credit_num_txt); FETCH cur_sf_credit_num INTO cur_sf_credit_num_rec;
2865: CLOSE cur_sf_credit_num;
2866: l_trans_spnsr_credit_id := cur_sf_credit_num_rec.credit_id;
2867: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2868: g_debug_string := 'SF sponsor credit num'||cur_sf_credit_num_rec.credit_number||'credit id is'||l_trans_spnsr_credit_id;
2869: END IF;
2870: IF(cur_sf_credit_num_rec.credit_number IS NULL)THEN
2871: p_return_status := 'E';

Line 2892: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

2888: cur_sf_invoice_num_rec := NULL;
2889: OPEN cur_sf_invoice_num(cur_li_disb_act_int_rec.spnsr_charge_num_txt); FETCH cur_sf_invoice_num INTO cur_sf_invoice_num_rec;
2890: CLOSE cur_sf_invoice_num;
2891: l_trans_spnsr_charge_id := cur_sf_invoice_num_rec.invoice_id;
2892: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
2893: g_debug_string := g_debug_string ||'SF sponsor charge Num'||cur_sf_invoice_num_rec.invoice_number||'charge id'||l_trans_spnsr_charge_id;
2894: END IF;
2895: IF(cur_sf_invoice_num_rec.invoice_number IS NULL)THEN
2896: p_return_status := 'E';

Line 3005: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3001:
3002: -- insert row only if all the validations are successful
3003: -- check for cal of l_adjust_amt
3004:
3005: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3006: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_db_awd_disb_dtl table');
3007: END IF;
3008:
3009: IF p_return_status <> 'E' THEN

Line 3006: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_db_awd_disb_dtl table');

3002: -- insert row only if all the validations are successful
3003: -- check for cal of l_adjust_amt
3004:
3005: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3006: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_db_awd_disb_dtl table');
3007: END IF;
3008:
3009: IF p_return_status <> 'E' THEN
3010: l_rowid := NULL;

Line 3056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3052: p_return_status := 'E';
3053: RETURN;
3054: END IF;
3055:
3056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');
3058: END IF;
3059: -- insert into IGF_AW_DB_CHG_DTLS table also
3060:

Line 3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');

3053: RETURN;
3054: END IF;
3055:
3056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug','inserting into igf_aw_db_chg_dtls table');
3058: END IF;
3059: -- insert into IGF_AW_DB_CHG_DTLS table also
3060:
3061: -- First delete the record in the table if present

Line 3108: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

3104:
3105:
3106: END IF; -- End if of p_return_status <> 'E'
3107:
3108: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug',g_debug_string);
3110: g_debug_string := NULL;
3111: END IF;
3112: END LOOP;

Line 3109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug',g_debug_string);

3105:
3106: END IF; -- End if of p_return_status <> 'E'
3107:
3108: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.debug',g_debug_string);
3110: g_debug_string := NULL;
3111: END IF;
3112: END LOOP;
3113:

Line 3116: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

3112: END LOOP;
3113:
3114: EXCEPTION WHEN OTHERS THEN
3115: p_return_status := 'E';
3116: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3117: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3118: 'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.exception',
3119: SQLERRM);
3120: END IF;

Line 3117: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3113:
3114: EXCEPTION WHEN OTHERS THEN
3115: p_return_status := 'E';
3116: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3117: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3118: 'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.exception',
3119: SQLERRM);
3120: END IF;
3121: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 3219: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

3215: END IF;
3216: END LOOP;
3217: EXCEPTION WHEN OTHERS THEN
3218: p_return_status := 'E';
3219: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3221: 'igf.plsql.igf_aw_li_import.validate_disb_hold_int_rec.exception',
3222: SQLERRM);
3223: END IF;

Line 3220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3216: END LOOP;
3217: EXCEPTION WHEN OTHERS THEN
3218: p_return_status := 'E';
3219: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3221: 'igf.plsql.igf_aw_li_import.validate_disb_hold_int_rec.exception',
3222: SQLERRM);
3223: END IF;
3224: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 3323: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

3319: AND award_number_txt = ctx_li_awd_rec.award_number_txt
3320: AND import_status_type = ctx_li_awd_rec.import_status_type;
3321: END IF;
3322: EXCEPTION WHEN OTHERS THEN
3323: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3324: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3325: 'igf.plsql.igf_aw_li_import.del_or_upd_int_records.exception',
3326: 'Unhandled Exception'||SQLERRM);
3327: END IF;

Line 3324: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

3320: AND import_status_type = ctx_li_awd_rec.import_status_type;
3321: END IF;
3322: EXCEPTION WHEN OTHERS THEN
3323: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3324: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
3325: 'igf.plsql.igf_aw_li_import.del_or_upd_int_records.exception',
3326: 'Unhandled Exception'||SQLERRM);
3327: END IF;
3328: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 3339: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3335: igf_aw_gen.set_org_id(NULL);
3336:
3337: -- begin of procedure main
3338: -- Obtain cal_type and sequence number from the Parameter p_award_year
3339: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3340: l_cal_type := TRIM(SUBSTR(p_award_year,1,10));
3341: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
3342:
3343: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

Line 3343: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

3339: g_debug_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3340: l_cal_type := TRIM(SUBSTR(p_award_year,1,10));
3341: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
3342:
3343: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3344: g_debug_string := 'REQUEST ID: '||fnd_global.conc_request_id;
3345: END IF;
3346:
3347: -- copy the values into global variables for further processing

Line 3395: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

3391: ELSE -- award year is present in the sys award year form. check for validity
3392: CLOSE cur_in_award_year_form;
3393: -- copy the award year status code and sys award year values into global variables.for further processing.
3394: g_award_year_status_code := l_award_year_status_code; g_sys_award_year := l_sys_award_year;
3395: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3396: g_debug_string := g_debug_string || 'Award year status code '||g_award_year_status_code||'Sys Award Year'||g_sys_award_year;
3397: END IF;
3398: IF(l_award_year_status_code NOT IN ('O','LD')) THEN
3399: FND_MESSAGE.SET_NAME('IGF','IGF_AP_LG_INVALID_STAT');

Line 3470: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN

3466: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LI_SKIPPING_AWD');
3467: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3468: ELSIF(l_out_base_id IS NOT NULL AND l_out_person_id IS NOT NULL)THEN -- here both person id and base id are found
3469: -- write to the log and clear the string so that it can be used for other procedures being called.
3470: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3471: g_debug_string := g_debug_string || 'Base Id'||l_out_base_id||'Person Id'||l_out_person_id;
3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.main.debug',g_debug_string);
3473: g_debug_string := NULL;
3474: END IF;

Line 3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.main.debug',g_debug_string);

3468: ELSIF(l_out_base_id IS NOT NULL AND l_out_person_id IS NOT NULL)THEN -- here both person id and base id are found
3469: -- write to the log and clear the string so that it can be used for other procedures being called.
3470: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3471: g_debug_string := g_debug_string || 'Base Id'||l_out_base_id||'Person Id'||l_out_person_id;
3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_aw_li_import.main.debug',g_debug_string);
3473: g_debug_string := NULL;
3474: END IF;
3475: -- call to validate award year interface record. this is the main fork. control goes around the
3476: -- world before comming back here.

Line 3557: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

3553: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-',55,'-'));
3554: END IF;
3555: EXCEPTION WHEN OTHERS THEN
3556: ROLLBACK;
3557: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3559: g_debug_string );
3560: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3561: 'Unhandled Exception '||SQLERRM );

Line 3558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',

3554: END IF;
3555: EXCEPTION WHEN OTHERS THEN
3556: ROLLBACK;
3557: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3559: g_debug_string );
3560: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3561: 'Unhandled Exception '||SQLERRM );
3562: END IF;

Line 3560: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',

3556: ROLLBACK;
3557: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3559: g_debug_string );
3560: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.main.exception',
3561: 'Unhandled Exception '||SQLERRM );
3562: END IF;
3563: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
3564: FND_MESSAGE.SET_TOKEN('NAME','MAIN : '||SQLERRM);

Line 3641: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

3637: p_delete_flag);
3638:
3639: EXCEPTION WHEN OTHERS THEN
3640: ROLLBACK;
3641: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3642: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3643: g_debug_string );
3644: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3645: 'Unhandled Exception '||SQLERRM );

Line 3642: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',

3638:
3639: EXCEPTION WHEN OTHERS THEN
3640: ROLLBACK;
3641: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3642: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3643: g_debug_string );
3644: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3645: 'Unhandled Exception '||SQLERRM );
3646: END IF;

Line 3644: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',

3640: ROLLBACK;
3641: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
3642: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3643: g_debug_string );
3644: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_aw_li_import.run.exception',
3645: 'Unhandled Exception '||SQLERRM );
3646: END IF;
3647: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
3648: FND_MESSAGE.SET_TOKEN('NAME','RUN : '||SQLERRM);