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 IGF_AW_LI_IMPORT

Line 1: PACKAGE BODY igf_aw_li_import AS

1: PACKAGE BODY igf_aw_li_import AS
2: /* $Header: IGFAW15B.pls 120.14 2006/09/08 13:55:06 akomurav ship $ */
3:
4: /*=======================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|

Line 10: | PL/SQL body for package: IGF_AW_LI_IMPORT |

6: | All rights reserved. |
7: +=======================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL body for package: IGF_AW_LI_IMPORT |
11: | |
12: | NOTES |
13: | |
14: |The Legacy - Award and Disbursement Data Import Process imports data |

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 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 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 400: fnd_message.set_token('NAME','igf_aw_li_import.lock_std_coa :' || SQLERRM);

396:
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;

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 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 661: 'igf.plsql.igf_aw_li_import.validate_open_award_year.exception',

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');
665: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_OPEN_AWARD_YEAR : '||SQLERRM);

Line 796: fnd_message.set_token('NAME','igf_aw_li_import.create_new_award_hist_rec' || SQLERRM);

792:
793: EXCEPTION
794: WHEN OTHERS THEN
795: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
796: fnd_message.set_token('NAME','igf_aw_li_import.create_new_award_hist_rec' || SQLERRM);
797: igs_ge_msg_stack.add;
798: app_exception.raise_exception;
799: END create_new_award_hist_rec;
800:

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 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 1047: 'igf.plsql.igf_aw_li_import.create_award_record.exception',

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');
1051: FND_MESSAGE.SET_TOKEN('NAME','CREATE_AWARD_RECORD : '||SQLERRM);

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 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 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 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 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 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 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 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 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 1593: 'igf.plsql.igf_aw_li_import.create_award_validate_disb_section.exception',

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;
1597: l_return_value := 'E';

Line 1619: 'igf.plsql.igf_aw_li_import.validate_awdyear_int_rec.exception',

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');
1623: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_AWDYEAR_INT_REC : '||SQLERRM);

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 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 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 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 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 2485: 'igf.plsql.igf_aw_li_import.validate_disburs_int_rec.exception',

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');
2489: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_DISBURS_INT_REC : '||SQLERRM);

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 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 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 3118: 'igf.plsql.igf_aw_li_import.validate_disb_act_int_rec.exception',

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');
3122: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_DISB_ACT_INT_REC : '||SQLERRM);

Line 3221: 'igf.plsql.igf_aw_li_import.validate_disb_hold_int_rec.exception',

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');
3225: FND_MESSAGE.SET_TOKEN('NAME','VALIDATE_DISB_HOLD_INT_REC : '||SQLERRM);

Line 3325: 'igf.plsql.igf_aw_li_import.del_or_upd_int_records.exception',

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');
3329: FND_MESSAGE.SET_TOKEN('NAME','DEL_OR_UPD_INT_RECORDS : '||SQLERRM );

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 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 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);

Line 3657: END igf_aw_li_import;

3653: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3654:
3655: END run;
3656:
3657: END igf_aw_li_import;