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.

[Home] [Help]

APPS.IGF_AW_GEN dependencies on IGF_AW_GEN

Line 1: PACKAGE BODY igf_aw_gen AS

1: PACKAGE BODY igf_aw_gen AS
2: /* $Header: IGFAW02B.pls 120.14 2006/06/06 07:31:50 akomurav ship $ */
3:
4: --------------------------------------------------------------------------------------
5: -- Who When What

Line 195: fnd_message.set_token('NAME','IGF_AW_GEN.GET_VER_NUM' ||' ' || SQLERRM);

191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
195: fnd_message.set_token('NAME','IGF_AW_GEN.GET_VER_NUM' ||' ' || SQLERRM);
196: igs_ge_msg_stack.add;
197: app_exception.raise_exception;
198:
199: END get_ver_num;

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 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 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 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 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 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 811: fnd_message.set_token('NAME', 'IGF_AW_GEN.UPDATE_DISB' || ' ' || SQLERRM);

807: EXCEPTION
808: WHEN OTHERS
809: THEN
810: fnd_message.set_name('IGS', 'IGS_GE_UNHANDLED_EXP');
811: fnd_message.set_token('NAME', 'IGF_AW_GEN.UPDATE_DISB' || ' ' || SQLERRM);
812: igs_ge_msg_stack.ADD;
813: app_exception.raise_exception;
814: END update_disb;
815:

Line 869: igf_aw_gen.set_org_id(NULL);

865:
866: BEGIN
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);

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 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 1038: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_FA_BASE_AWD' ||' ' || SQLERRM);

1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1038: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_FA_BASE_AWD' ||' ' || SQLERRM);
1039: igs_ge_msg_stack.add;
1040: app_exception.raise_exception ;
1041: END update_fabase_awds;
1042:

Line 1065: fnd_message.set_token('NAME','IGF_AW_GEN.GET_ORG_ID' ||' ' || SQLERRM);

1061:
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1065: fnd_message.set_token('NAME','IGF_AW_GEN.GET_ORG_ID' ||' ' || SQLERRM);
1066: igs_ge_msg_stack.add;
1067: app_exception.raise_exception;
1068:
1069: END get_org_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 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 1424: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_FMAST' ||' ' || SQLERRM);

1420:
1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1424: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_FMAST' ||' ' || SQLERRM);
1425: igs_ge_msg_stack.add;
1426: app_exception.raise_exception;
1427:
1428: END update_fmast;

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 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 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 1626: 'igf.plsql.igf_aw_gen.update_award.debug',

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
1630: -- There is atleast one uncancelled disbursement in the award.

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 1731: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_AWARD' || ' ' || SQLERRM);

1727: igs_ge_msg_stack.add;
1728: app_exception.raise_exception ;
1729: ELSE
1730: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1731: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_AWARD' || ' ' || SQLERRM);
1732: igs_ge_msg_stack.add;
1733: app_exception.raise_exception ;
1734: END IF;
1735: END update_award;

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 1797: fnd_message.set_token('NAME','IGF_AW_GEN.CHECK_LD_CAL_TPS' ||' ' || SQLERRM);

1793: END IF;
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1797: fnd_message.set_token('NAME','IGF_AW_GEN.CHECK_LD_CAL_TPS' ||' ' || SQLERRM);
1798: igs_ge_msg_stack.add;
1799: app_exception.raise_exception;
1800:
1801: END check_ld_cal_tps;

Line 1830: fnd_message.set_token('NAME','IGF_AW_GEN.CHECK_NUMBER_FORMAT' ||' ' || SQLERRM);

1826: ret:=1;
1827:
1828: WHEN OTHERS THEN
1829: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1830: fnd_message.set_token('NAME','IGF_AW_GEN.CHECK_NUMBER_FORMAT' ||' ' || SQLERRM);
1831: igs_ge_msg_stack.add;
1832: app_exception.raise_exception;
1833:
1834: END check_number_format;

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 1869: fnd_message.set_token('NAME','IGF_AW_GEN.DEPEND_STAT_2001' ||' ' || SQLERRM);

1865:
1866: EXCEPTION
1867: WHEN OTHERS THEN
1868: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1869: fnd_message.set_token('NAME','IGF_AW_GEN.DEPEND_STAT_2001' ||' ' || SQLERRM);
1870: igs_ge_msg_stack.add;
1871: app_exception.raise_exception;
1872:
1873: END depend_stat_2001;

Line 1963: fnd_message.set_token('NAME','IGF_AW_GEN.GET_NOTIFICATION_STATUS ' || SQLERRM);

1959: CLOSE c_process_status;
1960: EXCEPTION
1961: WHEN OTHERS THEN
1962: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1963: fnd_message.set_token('NAME','IGF_AW_GEN.GET_NOTIFICATION_STATUS ' || SQLERRM);
1964: igs_ge_msg_stack.add;
1965: app_exception.raise_exception;
1966: END get_notification_status;
1967:

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 2047: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_NOTIFICATION_STATUS ' || SQLERRM);

2043: END LOOP; -- END Award Noification Status Update
2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2047: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_NOTIFICATION_STATUS ' || SQLERRM);
2048: igs_ge_msg_stack.add;
2049: app_exception.raise_exception;
2050: END update_notification_status;
2051:

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

Line 2145: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_AWD_NOTIFICATION_STATUS ' || SQLERRM);

2141: END LOOP;
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2145: fnd_message.set_token('NAME','IGF_AW_GEN.UPDATE_AWD_NOTIFICATION_STATUS ' || SQLERRM);
2146: igs_ge_msg_stack.add;
2147: app_exception.raise_exception;
2148: END update_awd_notification_status;
2149:

Line 2254: END igf_aw_gen;

2250: END;
2251:
2252:
2253:
2254: END igf_aw_gen;