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_AWD_DISB_PKG dependencies on IGF_AW_GEN

Line 1417: IF igf_aw_gen.lookup_desc('IGF_DB_TRANS_TYPE',new_references.trans_type) IS NULL THEN

1413: new_references.direct_to_borr_flag := column_value;
1414: END IF;
1415:
1416: IF (UPPER(column_name) = 'TRANS_TYPE' OR column_name IS NULL) THEN
1417: IF igf_aw_gen.lookup_desc('IGF_DB_TRANS_TYPE',new_references.trans_type) IS NULL THEN
1418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.trans_type || ' for TRANS_TYPE is invalid ');
1420: END IF;
1421: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 1429: IF igf_aw_gen.lookup_desc('IGF_DB_ELIG_STATUS',new_references.elig_status) IS NULL THEN

1425: END IF;
1426:
1427: IF (UPPER(column_name) = 'ELIG_STATUS' OR column_name IS NULL) THEN
1428: IF new_references.elig_status IS NOT NULL THEN
1429: IF igf_aw_gen.lookup_desc('IGF_DB_ELIG_STATUS',new_references.elig_status) IS NULL THEN
1430:
1431: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1432: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.elig_status || ' for ELIG_STAUS is invalid');
1433: END IF;

Line 1443: IF igf_aw_gen.lookup_desc('IGF_AP_YES_NO',new_references.affirm_flag) IS NULL THEN

1439: END IF;
1440:
1441: IF (UPPER(column_name) = 'AFFIRM_FLAG' OR column_name IS NULL) THEN
1442: IF new_references.affirm_flag IS NOT NULL THEN
1443: IF igf_aw_gen.lookup_desc('IGF_AP_YES_NO',new_references.affirm_flag) IS NULL THEN
1444: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.affirm_flag || ' for AFFIRM_FLAG is invalid ');
1446: END IF;
1447: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 1459: IF igf_aw_gen.lookup_desc('IGF_SL_CL_HOLD_REL_IND_TF',new_references.hold_rel_ind) IS NULL THEN

1455: -- Bug 2983181
1456: --
1457: IF (UPPER(column_name) = 'HOLD_REL_IND' OR column_name IS NULL) THEN
1458: IF new_references.hold_rel_ind IS NOT NULL THEN
1459: IF igf_aw_gen.lookup_desc('IGF_SL_CL_HOLD_REL_IND_TF',new_references.hold_rel_ind) IS NULL THEN
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.hold_rel_ind || ' for HOLD_REL_IND is invalid ');
1462: END IF;
1463: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 1472: IF igf_aw_gen.lookup_desc('IGF_SL_CL_DB_FUND_DISB_METH',new_references.fund_dist_mthd) IS NULL THEN

1468: END IF;
1469:
1470: IF (UPPER(column_name) = 'FUND_DIST_MTHD' OR column_name IS NULL) THEN
1471: IF new_references.fund_dist_mthd IS NOT NULL THEN
1472: IF igf_aw_gen.lookup_desc('IGF_SL_CL_DB_FUND_DISB_METH',new_references.fund_dist_mthd) IS NULL THEN
1473: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1474: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.fund_dist_mthd || ' for FUND_DIST_MTHD is invalid ');
1475: END IF;
1476: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 1485: IF igf_aw_gen.lookup_desc('IGF_AP_YES_NO',new_references.prev_reported_ind) IS NULL THEN

1481: END IF;
1482:
1483: IF (UPPER(column_name) = 'PREV_REPORTED_IND' OR column_name IS NULL) THEN
1484: IF new_references.prev_reported_ind IS NOT NULL THEN
1485: IF igf_aw_gen.lookup_desc('IGF_AP_YES_NO',new_references.prev_reported_ind) IS NULL THEN
1486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.prev_reported_ind || ' for PREV_REPORTED_IND is invalid ');
1488: END IF;
1489: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 1498: IF igf_aw_gen.lookup_desc('IGF_SL_CL_DB_FUND_STATUS',new_references.fund_status) IS NULL THEN

1494: END IF;
1495:
1496: IF (UPPER(column_name) = 'FUND_STATUS' OR column_name IS NULL) THEN
1497: IF new_references.fund_status IS NOT NULL THEN
1498: IF igf_aw_gen.lookup_desc('IGF_SL_CL_DB_FUND_STATUS',new_references.fund_status) IS NULL THEN
1499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.fund_status || ' for FUND_STATUS is invalid ');
1501: END IF;
1502: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

Line 2077: l_org_id := igf_aw_gen.get_org_id;

2073: x_program_update_date DATE;
2074: l_org_id igf_aw_awd_disb_all.org_id%TYPE;
2075:
2076: BEGIN
2077: l_org_id := igf_aw_gen.get_org_id;
2078:
2079: x_last_update_date := SYSDATE;
2080: IF (x_mode = 'I') THEN
2081: x_last_updated_by := 1;

Line 2286: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'before invoking igf_aw_gen.update_award ' );

2282: -- Action INSERT
2283: --
2284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2285: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', ' g_v_called_from '||g_v_called_from);
2286: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'before invoking igf_aw_gen.update_award ' );
2287: END IF;
2288: igf_aw_gen.update_award (
2289: new_references.award_id,
2290: new_references.disb_num,

Line 2288: igf_aw_gen.update_award (

2284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2285: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', ' g_v_called_from '||g_v_called_from);
2286: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'before invoking igf_aw_gen.update_award ' );
2287: END IF;
2288: igf_aw_gen.update_award (
2289: new_references.award_id,
2290: new_references.disb_num,
2291: new_references.disb_net_amt,
2292: new_references.disb_date,

Line 2297: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'after invoking igf_aw_gen.update_award ' );

2293: 'I',
2294: g_v_called_from
2295: );
2296: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2297: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'after invoking igf_aw_gen.update_award ' );
2298: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.insert_row ', 'before invoking after_dml for p_action = INSERT ' );
2299: END IF;
2300: after_dml(p_action => 'INSERT');
2301:

Line 2659: igf_aw_gen.update_disb( old_references,new_references );

2655: --
2656: -- To Crate Adjustments
2657: --
2658:
2659: igf_aw_gen.update_disb( old_references,new_references );
2660:
2661: UPDATE igf_aw_awd_disb_all
2662: SET
2663: tp_cal_type = new_references.tp_cal_type,

Line 2730: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking igf_aw_gen.update_award ' );

2726: END IF;
2727: after_dml(p_action => 'UPDATE');
2728: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2729: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'after invoking after_dml ' );
2730: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking igf_aw_gen.update_award ' );
2731: END IF;
2732: igf_aw_gen.update_award (new_references.award_id,
2733: new_references.disb_num,
2734: new_references.disb_net_amt,

Line 2732: igf_aw_gen.update_award (new_references.award_id,

2728: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2729: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'after invoking after_dml ' );
2730: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking igf_aw_gen.update_award ' );
2731: END IF;
2732: igf_aw_gen.update_award (new_references.award_id,
2733: new_references.disb_num,
2734: new_references.disb_net_amt,
2735: new_references.disb_date,
2736: 'U',

Line 2740: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'after invoking igf_aw_gen.update_award ' );

2736: 'U',
2737: g_v_called_from
2738: );
2739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2740: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'after invoking igf_aw_gen.update_award ' );
2741: END IF;
2742: g_v_called_from := NULL;
2743: END update_row;
2744:

Line 2999: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking igf_aw_gen.update_award ');

2995: -- To Reflect summation of Disbursement Amounts into Award Table
2996: -- Action DELETE
2997: --
2998: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2999: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking igf_aw_gen.update_award ');
3000: END IF;
3001: igf_aw_gen.update_award (get_award_rec.award_id,
3002: 0,
3003: 0,

Line 3001: igf_aw_gen.update_award (get_award_rec.award_id,

2997: --
2998: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2999: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking igf_aw_gen.update_award ');
3000: END IF;
3001: igf_aw_gen.update_award (get_award_rec.award_id,
3002: 0,
3003: 0,
3004: TRUNC(SYSDATE),
3005: 'D',