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_GEN dependencies on FND_LOG

Line 381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

377:
378: --
379: -- check if any of the following fields are changed
380: --
381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
382: THEN
383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
384: 'p_disb_old_rec.disb_net_amt:' || p_disb_old_rec.disb_net_amt);
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

Line 383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

379: -- check if any of the following fields are changed
380: --
381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
382: THEN
383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
384: 'p_disb_old_rec.disb_net_amt:' || p_disb_old_rec.disb_net_amt);
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
386: 'p_disb_new_rec.disb_net_amt:' || p_disb_new_rec.disb_net_amt);
387: END IF;

Line 385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
382: THEN
383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
384: 'p_disb_old_rec.disb_net_amt:' || p_disb_old_rec.disb_net_amt);
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
386: 'p_disb_new_rec.disb_net_amt:' || p_disb_new_rec.disb_net_amt);
387: END IF;
388:
389: OPEN cur_get_fed(p_disb_old_rec.award_id);

Line 442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

438:
439: --Only if the Award Status is Accepted will the adjustment details would be created .
440: IF get_fed_rec.award_status IN ('ACCEPTED', 'CANCELLED')
441: THEN
442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
443: THEN
444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
445: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
446: END IF;

Line 444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

440: IF get_fed_rec.award_status IN ('ACCEPTED', 'CANCELLED')
441: THEN
442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
443: THEN
444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
445: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
446: END IF;
447:
448: igf_db_awd_disb_dtl_pkg.insert_row(

Line 541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

537:
538: --Only if the Award Status is Accepted will the adjustment details would be created .
539: IF get_fed_rec.award_status IN ('ACCEPTED', 'CANCELLED')
540: THEN
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
542: THEN
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
544: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
545: END IF;

Line 543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

539: IF get_fed_rec.award_status IN ('ACCEPTED', 'CANCELLED')
540: THEN
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
542: THEN
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
544: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
545: END IF;
546: --creating an invoice record in disb_dtl table
547: igf_db_awd_disb_dtl_pkg.insert_row(

Line 681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

677:
678: --Only if the Award Status is Accepted will the adjustment details would be created .
679: IF get_fed_rec.award_status = 'ACCEPTED'
680: THEN
681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
682: THEN
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
684: 'Inserting to igf_db_awd_disb_dtl award_id:'|| dbdtlrec.award_id);
685: END IF;

Line 683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

679: IF get_fed_rec.award_status = 'ACCEPTED'
680: THEN
681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
682: THEN
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
684: 'Inserting to igf_db_awd_disb_dtl award_id:'|| dbdtlrec.award_id);
685: END IF;
686:
687: igf_db_awd_disb_dtl_pkg.insert_row(

Line 742: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

738: IF TRUNC(p_disb_old_rec.disb_date) <> TRUNC(p_disb_new_rec.disb_date)
739: OR p_disb_old_rec.disb_net_amt <> p_disb_new_rec.disb_net_amt
740: OR p_disb_old_rec.hold_rel_ind <> p_disb_old_rec.hold_rel_ind
741: THEN
742: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
743: THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
745: 'Updating loan ' || loans_rec.loan_id || ' as ready to send');
746: END IF;

Line 744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

740: OR p_disb_old_rec.hold_rel_ind <> p_disb_old_rec.hold_rel_ind
741: THEN
742: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
743: THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
745: 'Updating loan ' || loans_rec.loan_id || ' as ready to send');
746: END IF;
747: igf_sl_loans_pkg.update_row(
748: x_rowid => loans_rec.row_id,

Line 778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

774: THEN
775: IF TRUNC(p_disb_old_rec.disb_date) <> TRUNC(p_disb_new_rec.disb_date)
776: OR p_disb_old_rec.disb_net_amt <> p_disb_new_rec.disb_net_amt
777: THEN
778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
779: THEN
780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
781: 'Updating loan ' || loans_rec.loan_id || ' as ready to send');
782: END IF;

Line 780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',

776: OR p_disb_old_rec.disb_net_amt <> p_disb_new_rec.disb_net_amt
777: THEN
778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
779: THEN
780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
781: 'Updating loan ' || loans_rec.loan_id || ' as ready to send');
782: END IF;
783:
784: igf_sl_loans_pkg.update_row(

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

867:
868: --- Get packaged Totals
869: igf_aw_gen.set_org_id(NULL);
870:
871: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_base_id:'||p_base_id);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_pack_status:'||p_pack_status);
874: END IF;
875:

Line 872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_base_id:'||p_base_id);

868: --- Get packaged Totals
869: igf_aw_gen.set_org_id(NULL);
870:
871: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_base_id:'||p_base_id);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_pack_status:'||p_pack_status);
874: END IF;
875:
876: OPEN c_pkg_tot ( p_base_id ) ;

Line 873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_pack_status:'||p_pack_status);

869: igf_aw_gen.set_org_id(NULL);
870:
871: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_base_id:'||p_base_id);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','p_pack_status:'||p_pack_status);
874: END IF;
875:
876: OPEN c_pkg_tot ( p_base_id ) ;
877: FETCH c_pkg_tot INTO l_pkg_tot ;

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

912: l_stud_det.packaging_status_date := Trunc(Sysdate) ;
913: l_stud_det.total_package_accepted := l_pkg_tot.accepted_amt ;
914: l_stud_det.total_package_offered := l_pkg_tot.offered_amt ;
915:
916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');
918: END IF;
919: igf_ap_fa_base_rec_pkg.update_row(
920: x_rowid => l_stud_det.row_id,

Line 917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');

913: l_stud_det.total_package_accepted := l_pkg_tot.accepted_amt ;
914: l_stud_det.total_package_offered := l_pkg_tot.offered_amt ;
915:
916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
917: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fabase_awds.debug','Updating igf_ap_fa_base_rec');
918: END IF;
919: igf_ap_fa_base_rec_pkg.update_row(
920: x_rowid => l_stud_det.row_id,
921: x_base_id => l_stud_det.base_id,

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

1126: l_fmast c_fmast%ROWTYPE;
1127:
1128: BEGIN
1129:
1130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','flag:'||flag);
1132: END IF;
1133: IF ( flag = 'DELETE' ) THEN
1134: OPEN c_fmast( x_old_ref.fund_id );

Line 1131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','flag:'||flag);

1127:
1128: BEGIN
1129:
1130: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1131: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','flag:'||flag);
1132: END IF;
1133: IF ( flag = 'DELETE' ) THEN
1134: OPEN c_fmast( x_old_ref.fund_id );
1135: ELSE

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

1281:
1282:
1283: END IF;
1284:
1285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);

Line 1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);

1282:
1283: END IF;
1284:
1285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);

Line 1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);

1283: END IF;
1284:
1285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);

Line 1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);

1284:
1285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);

Line 1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);

1285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);
1293: END IF;

Line 1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);

1286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.offered_amt:'||l_fmast.offered_amt);
1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);
1293: END IF;
1294: igf_aw_fund_mast_pkg.update_row (

Line 1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);

1287: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.accepted_amt:'||l_fmast.accepted_amt);
1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);
1293: END IF;
1294: igf_aw_fund_mast_pkg.update_row (
1295: x_rowid => l_fmast.row_id,

Line 1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);

1288: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_offered:'||l_fmast.total_offered);
1289: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.cancelled_amt:'||l_fmast.cancelled_amt);
1290: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_cancelled:'||l_fmast.total_cancelled);
1291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.declined_amt:'||l_fmast.declined_amt);
1292: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_fmast.debug','l_fmast.total_declined:'||l_fmast.total_declined);
1293: END IF;
1294: igf_aw_fund_mast_pkg.update_row (
1295: x_rowid => l_fmast.row_id,
1296: x_fund_id => l_fmast.fund_id,

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

1555: l_v_called_from := x_called_from;
1556: --
1557: -- Get Number of Disbursements
1558: --
1559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);

Line 1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);

1556: --
1557: -- Get Number of Disbursements
1558: --
1559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);
1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);

Line 1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);

1557: -- Get Number of Disbursements
1558: --
1559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);
1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);
1565: END IF;

Line 1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);

1558: --
1559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);
1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);
1565: END IF;
1566:

Line 1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);

1559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);
1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);
1565: END IF;
1566:
1567:

Line 1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);

1560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_award_id: '||p_award_id);
1561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_num: '||p_disb_num);
1562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_amt: '||p_disb_amt);
1563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_disb_dt: '||p_disb_dt);
1564: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','p_action: '||p_action);
1565: END IF;
1566:
1567:
1568: OPEN cur_award(p_award_id);

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

1582: OPEN cur_fund_dtls( award_rec.fund_id);
1583: FETCH cur_fund_dtls INTO cur_fund_dtls_rec;
1584: CLOSE cur_fund_dtls;
1585:
1586: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','disb_rec.paid_amt: '||disb_rec.paid_amt);
1588: END IF;
1589:
1590: /*

Line 1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','disb_rec.paid_amt: '||disb_rec.paid_amt);

1583: FETCH cur_fund_dtls INTO cur_fund_dtls_rec;
1584: CLOSE cur_fund_dtls;
1585:
1586: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','disb_rec.paid_amt: '||disb_rec.paid_amt);
1588: END IF;
1589:
1590: /*
1591: If the user updates the disb_accepted_amt of an award while the award is still in

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

1598: CLOSE c_get_accept_amt;
1599:
1600: IF NVL(l_get_accept_amt.accepted_amt,-1) > 0 THEN
1601: l_awd_status := 'ACCEPTED';
1602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','setting the award status to accepted');
1604: END IF;
1605: END IF;
1606: END IF;

Line 1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','setting the award status to accepted');

1599:
1600: IF NVL(l_get_accept_amt.accepted_amt,-1) > 0 THEN
1601: l_awd_status := 'ACCEPTED';
1602: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1603: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_award.debug','setting the award status to accepted');
1604: END IF;
1605: END IF;
1606: END IF;
1607:

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

1620: l_awd_acc_amt := 0;
1621: l_awd_proc_status_code := 'AWARDED';
1622: END IF;
1623: -- Log
1624: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1625: fnd_log.string(fnd_log.level_statement,
1626: 'igf.plsql.igf_aw_gen.update_award.debug',
1627: 'All the disbursements in award ' ||award_rec.award_id|| ' are cancelled. Cancelling the award.');
1628: END IF;

Line 1625: fnd_log.string(fnd_log.level_statement,

1621: l_awd_proc_status_code := 'AWARDED';
1622: END IF;
1623: -- Log
1624: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1625: fnd_log.string(fnd_log.level_statement,
1626: 'igf.plsql.igf_aw_gen.update_award.debug',
1627: 'All the disbursements in award ' ||award_rec.award_id|| ' are cancelled. Cancelling the award.');
1628: END IF;
1629: ELSE

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

1640: only at award level. Retain award paid amout for FWS awards.
1641: */
1642: IF cur_fund_dtls_rec.fed_fund_code = 'FWS' THEN
1643: disb_rec.paid_amt := award_rec.paid_amt;
1644: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1645: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_gen.update_award.debug',
1646: 'Not updtaing award paid_amt with sum of disb paid_amt bcoz this is an FWS award. Retaining existing award paid amt. Award Id= '
1647: ||award_rec.award_id);
1648: END IF;

Line 1645: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_gen.update_award.debug',

1641: */
1642: IF cur_fund_dtls_rec.fed_fund_code = 'FWS' THEN
1643: disb_rec.paid_amt := award_rec.paid_amt;
1644: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1645: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_gen.update_award.debug',
1646: 'Not updtaing award paid_amt with sum of disb paid_amt bcoz this is an FWS award. Retaining existing award paid amt. Award Id= '
1647: ||award_rec.award_id);
1648: END IF;
1649: END IF;

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

1774: WHERE tech.adterms_id = terms.adterms_id
1775: );
1776: l_check_teach cur_check_teach%ROWTYPE;
1777: BEGIN
1778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1779: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.check_ld_cal_tps.debug','p_adplans_id:'||p_adplans_id);
1780: END IF;
1781: OPEN cur_check_terms(p_adplans_id);
1782: FETCH cur_check_terms INTO l_check_terms;

Line 1779: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.check_ld_cal_tps.debug','p_adplans_id:'||p_adplans_id);

1775: );
1776: l_check_teach cur_check_teach%ROWTYPE;
1777: BEGIN
1778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1779: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.check_ld_cal_tps.debug','p_adplans_id:'||p_adplans_id);
1780: END IF;
1781: OPEN cur_check_terms(p_adplans_id);
1782: FETCH cur_check_terms INTO l_check_terms;
1783: IF cur_check_terms%FOUND THEN

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

1854:
1855:
1856: BEGIN
1857:
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_base_id:'||p_base_id);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_isir_id:'||p_isir_id);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_method_code:'||p_method_code);
1862: END IF;

Line 1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_base_id:'||p_base_id);

1855:
1856: BEGIN
1857:
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_base_id:'||p_base_id);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_isir_id:'||p_isir_id);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_method_code:'||p_method_code);
1862: END IF;
1863: p_category := 0 ;

Line 1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_isir_id:'||p_isir_id);

1856: BEGIN
1857:
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_base_id:'||p_base_id);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_isir_id:'||p_isir_id);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_method_code:'||p_method_code);
1862: END IF;
1863: p_category := 0 ;
1864: p_dependency_status := '' ;

Line 1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_method_code:'||p_method_code);

1857:
1858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1859: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_base_id:'||p_base_id);
1860: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_isir_id:'||p_isir_id);
1861: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.depend_stat_2001.debug','p_method_code:'||p_method_code);
1862: END IF;
1863: p_category := 0 ;
1864: p_dependency_status := '' ;
1865:

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

2016: APT.CI_SEQUENCE_NUMBER = cp_ci_sequence_number AND
2017: APT.award_prd_cd = NVL(cp_award_prd_code, award_prd_cd));
2018: award_rec c_awards%ROWTYPE;
2019: BEGIN
2020: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);

Line 2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);

2017: APT.award_prd_cd = NVL(cp_award_prd_code, award_prd_cd));
2018: award_rec c_awards%ROWTYPE;
2019: BEGIN
2020: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);

Line 2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);

2018: award_rec c_awards%ROWTYPE;
2019: BEGIN
2020: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);

Line 2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);

2019: BEGIN
2020: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);

Line 2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);

2020: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);

Line 2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);

2021: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_cal_type - ' || p_cal_type);
2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2029: END IF;

Line 2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);

2022: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_seq_num - ' || p_seq_num);
2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2029: END IF;
2030: OPEN c_awards ( cp_ci_cal_type => p_cal_type,

Line 2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);

2023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2029: END IF;
2030: OPEN c_awards ( cp_ci_cal_type => p_cal_type,
2031: cp_ci_sequence_number => p_seq_num,

Line 2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);

2024: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_base_id - ' || p_base_id);
2025: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2026: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_awarding_period - ' || p_awarding_period);
2028: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2029: END IF;
2030: OPEN c_awards ( cp_ci_cal_type => p_cal_type,
2031: cp_ci_sequence_number => p_seq_num,
2032: cp_award_prd_code => p_awarding_period,

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

2078: awd.award_id = cp_award_id;
2079: -- award_rec c_award%ROWTYPE;
2080: BEGIN
2081:
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);

Line 2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);

2079: -- award_rec c_award%ROWTYPE;
2080: BEGIN
2081:
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2087: END IF;

Line 2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);

2080: BEGIN
2081:
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2087: END IF;
2088:

Line 2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);

2081:
2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2087: END IF;
2088:
2089: -- OPEN c_award (cp_award_id => p_award_id);

Line 2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);

2082: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_award_id - ' || p_award_id);
2084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_code - ' || p_notification_status_code);
2085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_notification_status_date - ' || p_notification_status_date);
2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_notification_status.debug', 'p_called_from - ' || p_called_from);
2087: END IF;
2088:
2089: -- OPEN c_award (cp_award_id => p_award_id);
2090: FOR award_rec IN c_award (cp_award_id => p_award_id) LOOP