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 FND_LOG

Line 126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

122: l_first_disb_flag igf_aw_db_chg_dtls.first_disb_flag%TYPE;
123: l_change_value NUMBER := 0;
124:
125: BEGIN
126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
127: fnd_log.string( fnd_log.level_statement,
128: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ',
129: 'Processing award_id= ' ||new_references.award_id|| ', disb num= ' ||new_references.disb_num);
130: END IF;

Line 127: fnd_log.string( fnd_log.level_statement,

123: l_change_value NUMBER := 0;
124:
125: BEGIN
126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
127: fnd_log.string( fnd_log.level_statement,
128: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ',
129: 'Processing award_id= ' ||new_references.award_id|| ', disb num= ' ||new_references.disb_num);
130: END IF;
131:

Line 134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

130: END IF;
131:
132: l_rowid := NULL;
133: IF (p_action = 'UPDATE') THEN
134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
135: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = update ' );
136: END IF;
137: -- Call all the procedures related to After Update.
138: AfterRowInsertUpdateDelete1

Line 135: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = update ' );

131:
132: l_rowid := NULL;
133: IF (p_action = 'UPDATE') THEN
134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
135: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = update ' );
136: END IF;
137: -- Call all the procedures related to After Update.
138: AfterRowInsertUpdateDelete1
139: (

Line 146: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

142: p_deleting => FALSE
143: );
144: ELSIF (p_action = 'INSERT') THEN
145: -- Call all the procedures related to After insert
146: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
147: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = insert ' );
148: END IF;
149: AfterRowInsertUpdateDelete1
150: (

Line 147: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = insert ' );

143: );
144: ELSIF (p_action = 'INSERT') THEN
145: -- Call all the procedures related to After insert
146: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
147: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml ', 'action = insert ' );
148: END IF;
149: AfterRowInsertUpdateDelete1
150: (
151: p_inserting => TRUE,

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

185: award_year_cal_rec.award_status <> 'SIMULATED' AND
186: (NVL(loans_rec.loan_status,'*') <> 'S' OR NVL(loans_rec.loan_status,'S') <> 'S' ) THEN
187: l_loan_type := 'DL';
188: l_cod_year_flag := igf_sl_dl_validation.check_full_participant (award_year_cal_rec.ci_cal_type,award_year_cal_rec.ci_sequence_number,'DL');
189: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
190: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' DL is true ' );
191: END IF;
192:
193: ELSIF l_fund_code = 'PELL' AND

Line 190: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' DL is true ' );

186: (NVL(loans_rec.loan_status,'*') <> 'S' OR NVL(loans_rec.loan_status,'S') <> 'S' ) THEN
187: l_loan_type := 'DL';
188: l_cod_year_flag := igf_sl_dl_validation.check_full_participant (award_year_cal_rec.ci_cal_type,award_year_cal_rec.ci_sequence_number,'DL');
189: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
190: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' DL is true ' );
191: END IF;
192:
193: ELSIF l_fund_code = 'PELL' AND
194: award_year_cal_rec.award_status <> 'SIMULATED' AND

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

196: (igf_sl_dl_validation.check_full_participant (award_year_cal_rec.ci_cal_type,award_year_cal_rec.ci_sequence_number,'PELL')) THEN
197: l_loan_type := 'PELL';
198: l_cod_year_flag := TRUE;
199:
200: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Pell is true ' );
202: END IF;
203:
204: IF NVL(new_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <> NVL(old_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD'))

Line 201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Pell is true ' );

197: l_loan_type := 'PELL';
198: l_cod_year_flag := TRUE;
199:
200: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
201: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Pell is true ' );
202: END IF;
203:
204: IF NVL(new_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <> NVL(old_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD'))
205: OR NVL(new_references.hold_rel_ind,'*') <> NVL(old_references.hold_rel_ind,'*')

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

204: IF NVL(new_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <> NVL(old_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD'))
205: OR NVL(new_references.hold_rel_ind,'*') <> NVL(old_references.hold_rel_ind,'*')
206: OR NVL(new_references.disb_accepted_amt,0) <> NVL(old_references.disb_accepted_amt,0)
207: OR new_references.disb_date <> old_references.disb_date THEN
208: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
209: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Before update in RFMS ' );
210: END IF;
211: IF pell_rec.rowid IS NOT NULL THEN
212:

Line 209: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Before update in RFMS ' );

205: OR NVL(new_references.hold_rel_ind,'*') <> NVL(old_references.hold_rel_ind,'*')
206: OR NVL(new_references.disb_accepted_amt,0) <> NVL(old_references.disb_accepted_amt,0)
207: OR new_references.disb_date <> old_references.disb_date THEN
208: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
209: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Before update in RFMS ' );
210: END IF;
211: IF pell_rec.rowid IS NOT NULL THEN
212:
213: --akomurav

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

272: x_atd_entity_id_txt => pell_rec.atd_entity_id_txt,
273: x_note_message => pell_rec.note_message,
274: x_full_resp_code => pell_rec.full_resp_code,
275: x_document_id_txt => pell_rec.document_id_txt);
276: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
277: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' updated rfms table ' );
278: END IF;
279: END IF;
280: END IF; -- move rfms status

Line 277: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' updated rfms table ' );

273: x_note_message => pell_rec.note_message,
274: x_full_resp_code => pell_rec.full_resp_code,
275: x_document_id_txt => pell_rec.document_id_txt);
276: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
277: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' updated rfms table ' );
278: END IF;
279: END IF;
280: END IF; -- move rfms status
281: END IF; -- loan type

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

281: END IF; -- loan type
282:
283: IF l_loan_type IN ('DL','PELL') THEN
284: -- Get the Minimum Disbursement Date for the Award
285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Loan Type is ' || l_loan_type );
287: END IF;
288:
289: OPEN min_disb_date_cur (new_references.award_id);

Line 286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Loan Type is ' || l_loan_type );

282:
283: IF l_loan_type IN ('DL','PELL') THEN
284: -- Get the Minimum Disbursement Date for the Award
285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
286: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' Loan Type is ' || l_loan_type );
287: END IF;
288:
289: OPEN min_disb_date_cur (new_references.award_id);
290: FETCH min_disb_date_cur INTO l_min_disb_date;

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

299:
300: -- When a new Disbursement record is created, create a Disbursement change details record
301: IF p_action = 'INSERT' THEN
302:
303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' before insert of change rec 1 ' );
305: END IF;
306:
307: -- Insert the new Disbursement change details record

Line 304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' before insert of change rec 1 ' );

300: -- When a new Disbursement record is created, create a Disbursement change details record
301: IF p_action = 'INSERT' THEN
302:
303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' before insert of change rec 1 ' );
305: END IF;
306:
307: -- Insert the new Disbursement change details record
308: l_row_id := NULL;

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

332: IF l_loan_type = 'DL' THEN
333: l_dl_disb_change_status := TRUE;
334: END IF;
335:
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after insert of change rec 1 ' );
338: END IF;
339:
340: ELSIF (p_action = 'UPDATE') THEN

Line 337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after insert of change rec 1 ' );

333: l_dl_disb_change_status := TRUE;
334: END IF;
335:
336: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
337: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after insert of change rec 1 ' );
338: END IF;
339:
340: ELSIF (p_action = 'UPDATE') THEN
341:

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

338: END IF;
339:
340: ELSIF (p_action = 'UPDATE') THEN
341:
342: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','p_action= ' ||p_action);
344: END IF;
345:
346: OPEN upd_db_chg_dtls_cur( new_references.award_id, new_references.disb_num, 1);

Line 343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','p_action= ' ||p_action);

339:
340: ELSIF (p_action = 'UPDATE') THEN
341:
342: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
343: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','p_action= ' ||p_action);
344: END IF;
345:
346: OPEN upd_db_chg_dtls_cur( new_references.award_id, new_references.disb_num, 1);
347: FETCH upd_db_chg_dtls_cur INTO upd_db_chg_dtls_rec;

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

380: IF (NVL(new_references.hold_rel_ind, 'FALSE') = 'TRUE' AND NVL(old_references.hold_rel_ind, 'FALSE') = 'FALSE') THEN
381: -- DRI changed from FALSE to TRUE. Update disb sequence
382: l_change_value := 1;
383:
384: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI has changed from FALSE to TRUE');
386: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
387: END IF;
388: ELSE

Line 385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI has changed from FALSE to TRUE');

381: -- DRI changed from FALSE to TRUE. Update disb sequence
382: l_change_value := 1;
383:
384: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI has changed from FALSE to TRUE');
386: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
387: END IF;
388: ELSE
389: IF (

Line 386: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);

382: l_change_value := 1;
383:
384: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
385: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI has changed from FALSE to TRUE');
386: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
387: END IF;
388: ELSE
389: IF (
390: (old_references.disb_accepted_amt <> new_references.disb_accepted_amt OR

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

398: (old_references.disb_date <> new_references.disb_date)
399: ) THEN
400: -- Disb amt (or) Disb date changed
401:
402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amt (or) Disb date has changed');
404: END IF;
405:
406: IF ( (NVL(new_references.hold_rel_ind, 'FALSE') = 'TRUE') AND (lv_first_disb_seq_accepted) ) THEN

Line 403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amt (or) Disb date has changed');

399: ) THEN
400: -- Disb amt (or) Disb date changed
401:
402: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
403: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amt (or) Disb date has changed');
404: END IF;
405:
406: IF ( (NVL(new_references.hold_rel_ind, 'FALSE') = 'TRUE') AND (lv_first_disb_seq_accepted) ) THEN
407: l_change_value := 2;

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

405:
406: IF ( (NVL(new_references.hold_rel_ind, 'FALSE') = 'TRUE') AND (lv_first_disb_seq_accepted) ) THEN
407: l_change_value := 2;
408:
409: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Both DRI and lv_first_disb_seq_accepted are TRUE');
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
412: END IF;
413: ELSE

Line 410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Both DRI and lv_first_disb_seq_accepted are TRUE');

406: IF ( (NVL(new_references.hold_rel_ind, 'FALSE') = 'TRUE') AND (lv_first_disb_seq_accepted) ) THEN
407: l_change_value := 2;
408:
409: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Both DRI and lv_first_disb_seq_accepted are TRUE');
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
412: END IF;
413: ELSE
414: l_change_value := 1;

Line 411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);

407: l_change_value := 2;
408:
409: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
410: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Both DRI and lv_first_disb_seq_accepted are TRUE');
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
412: END IF;
413: ELSE
414: l_change_value := 1;
415:

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

412: END IF;
413: ELSE
414: l_change_value := 1;
415:
416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI or lv_first_disb_seq_accepted is FALSE');
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
419: END IF;
420: END IF;

Line 417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI or lv_first_disb_seq_accepted is FALSE');

413: ELSE
414: l_change_value := 1;
415:
416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI or lv_first_disb_seq_accepted is FALSE');
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
419: END IF;
420: END IF;
421: END IF; -- <>

Line 418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);

414: l_change_value := 1;
415:
416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','DRI or lv_first_disb_seq_accepted is FALSE');
418: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Marking l_change_value= ' ||l_change_value);
419: END IF;
420: END IF;
421: END IF; -- <>
422: END IF; -- <>

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

421: END IF; -- <>
422: END IF; -- <>
423: END IF; -- <>
424:
425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','l_change_value= ' ||l_change_value);
427: END IF;
428: -- museshad (Bug 4930323)
429:

Line 426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','l_change_value= ' ||l_change_value);

422: END IF; -- <>
423: END IF; -- <>
424:
425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','l_change_value= ' ||l_change_value);
427: END IF;
428: -- museshad (Bug 4930323)
429:
430: IF (l_change_value = 1) THEN

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

458: );
459: IF l_loan_type = 'DL' THEN
460: l_dl_disb_change_status := TRUE;
461: END IF;
462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after update of change rec disb status chg true 1 ' );
464: END IF;
465:
466: ELSIF (l_change_value = 2) THEN

Line 463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after update of change rec disb status chg true 1 ' );

459: IF l_loan_type = 'DL' THEN
460: l_dl_disb_change_status := TRUE;
461: END IF;
462: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
463: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',' after update of change rec disb status chg true 1 ' );
464: END IF;
465:
466: ELSIF (l_change_value = 2) THEN
467:

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

473: NVL(old_references.affirm_flag,' ') <> NVL(new_references.affirm_flag,' ') OR
474: NVL(old_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <>
475: NVL(new_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) THEN
476:
477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amount change');
479: END IF;
480:
481: -- Get latest AMOUNT record to be updated.

Line 478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amount change');

474: NVL(old_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <>
475: NVL(new_references.payment_prd_st_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) THEN
476:
477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb amount change');
479: END IF;
480:
481: -- Get latest AMOUNT record to be updated.
482: OPEN cur_latest_DateAmt_for_update(new_references.award_id, new_references.disb_num, 'A');

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

489: CLOSE cur_latest_accepted_DateAmt;
490:
491: IF latest_update_rec.award_id IS NOT NULL THEN
492:
493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(fnd_log.level_statement,
495: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
496: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb amount');
497: END IF;

Line 494: fnd_log.string(fnd_log.level_statement,

490:
491: IF latest_update_rec.award_id IS NOT NULL THEN
492:
493: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
494: fnd_log.string(fnd_log.level_statement,
495: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
496: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb amount');
497: END IF;
498:

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

530: FETCH max_disb_seq_num_cur INTO l_max_disb_seq_num;
531: CLOSE max_disb_seq_num_cur;
532: l_row_id := NULL;
533:
534: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
535: fnd_log.string(fnd_log.level_statement,
536: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
537: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb amount');
538: END IF;

Line 535: fnd_log.string(fnd_log.level_statement,

531: CLOSE max_disb_seq_num_cur;
532: l_row_id := NULL;
533:
534: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
535: fnd_log.string(fnd_log.level_statement,
536: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
537: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb amount');
538: END IF;
539:

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

569:
570: -- For Disbursement Date Change
571: IF (old_references.disb_date <> new_references.disb_date) THEN
572:
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb date change');
575: END IF;
576:
577: -- Get latest DATE record to be updated.

Line 574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb date change');

570: -- For Disbursement Date Change
571: IF (old_references.disb_date <> new_references.disb_date) THEN
572:
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug','Disb date change');
575: END IF;
576:
577: -- Get latest DATE record to be updated.
578: OPEN cur_latest_DateAmt_for_update(new_references.award_id, new_references.disb_num, 'Q');

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

585: CLOSE cur_latest_accepted_DateAmt;
586:
587: IF latest_update_rec.award_id IS NOT NULL THEN
588:
589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
590: fnd_log.string(fnd_log.level_statement,
591: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
592: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb date');
593: END IF;

Line 590: fnd_log.string(fnd_log.level_statement,

586:
587: IF latest_update_rec.award_id IS NOT NULL THEN
588:
589: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
590: fnd_log.string(fnd_log.level_statement,
591: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
592: 'Updating disb sequence ' ||latest_update_rec.disb_seq_num|| ' with the new disb date');
593: END IF;
594:

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

626: FETCH max_disb_seq_num_cur INTO l_max_disb_seq_num;
627: CLOSE max_disb_seq_num_cur;
628: l_row_id := NULL;
629:
630: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
631: fnd_log.string(fnd_log.level_statement,
632: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
633: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb date');
634: END IF;

Line 631: fnd_log.string(fnd_log.level_statement,

627: CLOSE max_disb_seq_num_cur;
628: l_row_id := NULL;
629:
630: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
631: fnd_log.string(fnd_log.level_statement,
632: 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug',
633: 'Inserting new disb sequence ' ||NVL(l_max_disb_seq_num,1)|| ' with the new disb date');
634: END IF;
635:

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

668: -- If Change Details record inserted/updated with status "Ready to Send"
669: -- then update loan change status or loan status. Bug #4390112
670: IF l_dl_disb_change_status = TRUE THEN
671:
672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
673: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug', 'l_dl_disb_change_status = TRUE');
674: END IF;
675:
676: -- Get loans record.

Line 673: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug', 'l_dl_disb_change_status = TRUE');

669: -- then update loan change status or loan status. Bug #4390112
670: IF l_dl_disb_change_status = TRUE THEN
671:
672: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
673: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.after_dml.debug', 'l_dl_disb_change_status = TRUE');
674: END IF;
675:
676: -- Get loans record.
677: OPEN loans_cur(new_references.award_id);

Line 938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

934: IF p_deleting THEN
935: OPEN c_aw_awd_disb (cp_rowid => p_rowid);
936: FETCH c_aw_awd_disb INTO l_n_award_id,l_n_disb_num;
937: CLOSE c_aw_awd_disb ;
938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
939: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'Action = delete ' );
940: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'inside BeforeRowInsertUpdateDelete1 ' );
941: END IF;
942: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,

Line 939: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'Action = delete ' );

935: OPEN c_aw_awd_disb (cp_rowid => p_rowid);
936: FETCH c_aw_awd_disb INTO l_n_award_id,l_n_disb_num;
937: CLOSE c_aw_awd_disb ;
938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
939: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'Action = delete ' );
940: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'inside BeforeRowInsertUpdateDelete1 ' );
941: END IF;
942: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
943: p_v_message_name => l_v_message_name

Line 940: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'inside BeforeRowInsertUpdateDelete1 ' );

936: FETCH c_aw_awd_disb INTO l_n_award_id,l_n_disb_num;
937: CLOSE c_aw_awd_disb ;
938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
939: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'Action = delete ' );
940: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'inside BeforeRowInsertUpdateDelete1 ' );
941: END IF;
942: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
943: p_v_message_name => l_v_message_name
944: );

Line 945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

941: END IF;
942: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
943: p_v_message_name => l_v_message_name
944: );
945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
946: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_fed_fund_code : '||l_v_fed_fund_code );
947: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'g_v_called_from : '||g_v_called_from );
948: END IF;
949: IF l_v_message_name IS NOT NULL THEN

Line 946: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_fed_fund_code : '||l_v_fed_fund_code );

942: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
943: p_v_message_name => l_v_message_name
944: );
945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
946: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_fed_fund_code : '||l_v_fed_fund_code );
947: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'g_v_called_from : '||g_v_called_from );
948: END IF;
949: IF l_v_message_name IS NOT NULL THEN
950: fnd_message.set_name ('IGS',l_v_message_name);

Line 947: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'g_v_called_from : '||g_v_called_from );

943: p_v_message_name => l_v_message_name
944: );
945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
946: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_fed_fund_code : '||l_v_fed_fund_code );
947: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'g_v_called_from : '||g_v_called_from );
948: END IF;
949: IF l_v_message_name IS NOT NULL THEN
950: fnd_message.set_name ('IGS',l_v_message_name);
951: igs_ge_msg_stack.add;

Line 977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

973: -- Loan Status = Accepted
974: -- Loan Record Status is Guaranteed or Accepted
975: -- Processing Type Code is GP or GO
976: -- information is different from the latest guaranteed response for the loan
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );

Line 978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );

974: -- Loan Record Status is Guaranteed or Accepted
975: -- Processing Type Code is GP or GO
976: -- information is different from the latest guaranteed response for the loan
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );

Line 979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );

975: -- Processing Type Code is GP or GO
976: -- information is different from the latest guaranteed response for the loan
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );
983: END IF;

Line 980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );

976: -- information is different from the latest guaranteed response for the loan
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );
983: END IF;
984: IF (l_n_cl_version = 'RELEASE-4' AND

Line 981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );

977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );
983: END IF;
984: IF (l_n_cl_version = 'RELEASE-4' AND
985: l_v_loan_status = 'A' AND

Line 982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );

978: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
979: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
980: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
981: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
982: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', 'l_n_disb_num : '||l_n_disb_num );
983: END IF;
984: IF (l_n_cl_version = 'RELEASE-4' AND
985: l_v_loan_status = 'A' AND
986: l_v_prc_type_code IN ('GO','GP') AND

Line 995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

991: cp_new_disb_num => l_n_disb_num
992: );
993: FETCH c_sl_clchsn_dtls INTO rec_c_sl_clchsn_dtls;
994: IF c_sl_clchsn_dtls%FOUND THEN
995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');
997: END IF;
998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');

992: );
993: FETCH c_sl_clchsn_dtls INTO rec_c_sl_clchsn_dtls;
994: IF c_sl_clchsn_dtls%FOUND THEN
995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');
997: END IF;
998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record deleted successfully ');

Line 999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');
997: END IF;
998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record deleted successfully ');
1001: END IF;
1002: END IF;
1003: CLOSE c_sl_clchsn_dtls;

Line 1000: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record deleted successfully ');

996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');
997: END IF;
998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record deleted successfully ');
1001: END IF;
1002: END IF;
1003: CLOSE c_sl_clchsn_dtls;
1004: END IF;

Line 1064: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1060:
1061: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
1062:
1063: BEGIN
1064: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1065: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );
1066: END IF;
1067: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
1068: p_v_message_name => l_v_message_name

Line 1065: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );

1061: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
1062:
1063: BEGIN
1064: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1065: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );
1066: END IF;
1067: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
1068: p_v_message_name => l_v_message_name
1069: );

Line 1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1066: END IF;
1067: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
1068: p_v_message_name => l_v_message_name
1069: );
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' fund code = '||l_v_fed_fund_code );
1072: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' called from = '||g_v_called_from );
1073: END IF;
1074: IF l_v_message_name IS NOT NULL THEN

Line 1071: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' fund code = '||l_v_fed_fund_code );

1067: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
1068: p_v_message_name => l_v_message_name
1069: );
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' fund code = '||l_v_fed_fund_code );
1072: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' called from = '||g_v_called_from );
1073: END IF;
1074: IF l_v_message_name IS NOT NULL THEN
1075: fnd_message.set_name ('IGS',l_v_message_name);

Line 1072: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' called from = '||g_v_called_from );

1068: p_v_message_name => l_v_message_name
1069: );
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' fund code = '||l_v_fed_fund_code );
1072: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' called from = '||g_v_called_from );
1073: END IF;
1074: IF l_v_message_name IS NOT NULL THEN
1075: fnd_message.set_name ('IGS',l_v_message_name);
1076: igs_ge_msg_stack.add;

Line 1091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1087: (new_references.disb_accepted_amT <> old_references.disb_accepted_amt) OR
1088: (NVL(new_references.hold_rel_ind, 'FALSE') <> NVL(old_references.hold_rel_ind, 'FALSE')) OR
1089: (NVL(new_references.change_type_code, '*') <> NVL(old_references.change_type_code, '*'))
1090: ) THEN
1091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1092: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_disb_chg_rec. ' );
1093: END IF;
1094: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
1095: igf_sl_cl_create_chg.create_disb_chg_rec(

Line 1092: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_disb_chg_rec. ' );

1088: (NVL(new_references.hold_rel_ind, 'FALSE') <> NVL(old_references.hold_rel_ind, 'FALSE')) OR
1089: (NVL(new_references.change_type_code, '*') <> NVL(old_references.change_type_code, '*'))
1090: ) THEN
1091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1092: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_disb_chg_rec. ' );
1093: END IF;
1094: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
1095: igf_sl_cl_create_chg.create_disb_chg_rec(
1096: p_new_disb_rec => new_references,

Line 1116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1112: fnd_message.set_token(igf_sl_cl_chg_prc.g_message_tokens(token_counter).token_name, igf_sl_cl_chg_prc.g_message_tokens(token_counter).token_value);
1113: END LOOP;
1114: */
1115: igs_ge_msg_stack.add;
1116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1117: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_disb_chg_rec returned error '|| l_v_message_name);
1118: END IF;
1119: app_exception.raise_exception;
1120: END IF;

Line 1117: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_disb_chg_rec returned error '|| l_v_message_name);

1113: END LOOP;
1114: */
1115: igs_ge_msg_stack.add;
1116: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1117: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_disb_chg_rec returned error '|| l_v_message_name);
1118: END IF;
1119: app_exception.raise_exception;
1120: END IF;
1121: END IF;

Line 1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1136: -- Loan Status = Accepted
1137: -- Loan Record Status is Guaranteed or Accepted
1138: -- Processing Type Code is GP or GO
1139: -- information is different from the latest guaranteed response for the loan
1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );

Line 1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );

1137: -- Loan Record Status is Guaranteed or Accepted
1138: -- Processing Type Code is GP or GO
1139: -- information is different from the latest guaranteed response for the loan
1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
1145: END IF;

Line 1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );

1138: -- Processing Type Code is GP or GO
1139: -- information is different from the latest guaranteed response for the loan
1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
1145: END IF;
1146: IF (l_n_cl_version = 'RELEASE-4' AND

Line 1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );

1139: -- information is different from the latest guaranteed response for the loan
1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
1145: END IF;
1146: IF (l_n_cl_version = 'RELEASE-4' AND
1147: l_v_loan_status = 'A' AND

Line 1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );

1140: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1141: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_n_cl_version : '||l_n_cl_version );
1142: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_loan_status : '||l_v_loan_status );
1143: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_v_prc_type_code : '||l_v_prc_type_code );
1144: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'l_c_cl_rec_status : '||l_c_cl_rec_status );
1145: END IF;
1146: IF (l_n_cl_version = 'RELEASE-4' AND
1147: l_v_loan_status = 'A' AND
1148: l_v_prc_type_code IN ('GO','GP') AND

Line 1156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1152: cp_new_disb_num => new_references.disb_num
1153: );
1154: FETCH c_sl_clchsn_dtls INTO rec_c_sl_clchsn_dtls;
1155: IF c_sl_clchsn_dtls%FOUND THEN
1156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');
1158: END IF;
1159: igf_sl_clchsn_dtls_pkg.update_row (
1160: x_rowid => rec_c_sl_clchsn_dtls.row_id,

Line 1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');

1153: );
1154: FETCH c_sl_clchsn_dtls INTO rec_c_sl_clchsn_dtls;
1155: IF c_sl_clchsn_dtls%FOUND THEN
1156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');
1158: END IF;
1159: igf_sl_clchsn_dtls_pkg.update_row (
1160: x_rowid => rec_c_sl_clchsn_dtls.row_id,
1161: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,

Line 1202: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1198: x_send_record_txt => rec_c_sl_clchsn_dtls.send_record_txt
1199: );
1200: -- invoke validation edits to validate the change record. The validation checks if
1201: -- all the required fields are populated or not for a change record
1202: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1203: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1204: END IF;
1205: igf_sl_cl_chg_prc.validate_chg (
1206: p_n_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id,

Line 1203: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);

1199: );
1200: -- invoke validation edits to validate the change record. The validation checks if
1201: -- all the required fields are populated or not for a change record
1202: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1203: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1204: END IF;
1205: igf_sl_cl_chg_prc.validate_chg (
1206: p_n_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id,
1207: p_b_return_status => l_b_return_status,

Line 1214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1210: );
1211: IF NOT(l_b_return_status) THEN
1212: -- substring of the out bound parameter l_v_message_name is carried
1213: -- out since it can expect either IGS OR IGF message
1214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1215: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1216: END IF;
1217: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
1218: igf_sl_cl_chg_prc.parse_tokens(

Line 1215: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);

1211: IF NOT(l_b_return_status) THEN
1212: -- substring of the out bound parameter l_v_message_name is carried
1213: -- out since it can expect either IGS OR IGF message
1214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1215: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1216: END IF;
1217: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
1218: igf_sl_cl_chg_prc.parse_tokens(
1219: p_t_message_tokens => l_d_message_tokens);

Line 1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1221: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
1222: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1223: END LOOP;
1224: */
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');
1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1228: END IF;
1229: igf_sl_clchsn_dtls_pkg.update_row (

Line 1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');

1222: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1223: END LOOP;
1224: */
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');
1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1228: END IF;
1229: igf_sl_clchsn_dtls_pkg.update_row (
1230: x_rowid => rec_c_sl_clchsn_dtls.row_id,

Line 1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);

1223: END LOOP;
1224: */
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');
1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1228: END IF;
1229: igf_sl_clchsn_dtls_pkg.update_row (
1230: x_rowid => rec_c_sl_clchsn_dtls.row_id,
1231: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,

Line 1270: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1266: x_guarantor_use_txt => rec_c_sl_clchsn_dtls.guarantor_use_txt ,
1267: x_validation_edit_txt => fnd_message.get ,
1268: x_send_record_txt => rec_c_sl_clchsn_dtls.send_record_txt
1269: );
1270: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' updated the status to Not Ready to Send for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1272: END IF;
1273: END IF;
1274: END IF;

Line 1271: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' updated the status to Not Ready to Send for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);

1267: x_validation_edit_txt => fnd_message.get ,
1268: x_send_record_txt => rec_c_sl_clchsn_dtls.send_record_txt
1269: );
1270: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' updated the status to Not Ready to Send for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1272: END IF;
1273: END IF;
1274: END IF;
1275: CLOSE c_sl_clchsn_dtls;

Line 1301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1297: l_v_prc_type_code IN ('GO','GP') AND
1298: l_c_cl_rec_status IN ('B','G')) THEN
1299: l_v_rowid := NULL;
1300: l_n_clchgsnd_id := NULL;
1301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');
1303: END IF;
1304: igf_sl_clchsn_dtls_pkg.insert_row (
1305: x_rowid => l_v_rowid ,

Line 1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');

1298: l_c_cl_rec_status IN ('B','G')) THEN
1299: l_v_rowid := NULL;
1300: l_n_clchgsnd_id := NULL;
1301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');
1303: END IF;
1304: igf_sl_clchsn_dtls_pkg.insert_row (
1305: x_rowid => l_v_rowid ,
1306: x_clchgsnd_id => l_n_clchgsnd_id ,

Line 1345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1341: x_guarantor_use_txt => NULL ,
1342: x_validation_edit_txt => NULL ,
1343: x_send_record_txt => NULL
1344: );
1345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1346: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Inserted @9 record of change_code_txt = D ');
1347: END IF;
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id);

Line 1346: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Inserted @9 record of change_code_txt = D ');

1342: x_validation_edit_txt => NULL ,
1343: x_send_record_txt => NULL
1344: );
1345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1346: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Inserted @9 record of change_code_txt = D ');
1347: END IF;
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id);
1350: END IF;

Line 1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1344: );
1345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1346: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Inserted @9 record of change_code_txt = D ');
1347: END IF;
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id);
1350: END IF;
1351: igf_sl_cl_chg_prc.validate_chg (
1352: p_n_clchgsnd_id => l_n_clchgsnd_id,

Line 1349: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id);

1345: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1346: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'Inserted @9 record of change_code_txt = D ');
1347: END IF;
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id);
1350: END IF;
1351: igf_sl_cl_chg_prc.validate_chg (
1352: p_n_clchgsnd_id => l_n_clchgsnd_id,
1353: p_b_return_status => l_b_return_status,

Line 1367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1363: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1364: END LOOP;
1365: */
1366: igs_ge_msg_stack.add;
1367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||l_n_clchgsnd_id);
1369: END IF;
1370: app_exception.raise_exception;
1371: END IF;

Line 1368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||l_n_clchgsnd_id);

1364: END LOOP;
1365: */
1366: igs_ge_msg_stack.add;
1367: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1368: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' validation of the Change record failed for Change send id: ' ||l_n_clchgsnd_id);
1369: END IF;
1370: app_exception.raise_exception;
1371: END IF;
1372: END IF;

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

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');
1422: igs_ge_msg_stack.add;

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

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');
1422: igs_ge_msg_stack.add;
1423: app_exception.raise_exception;

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

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;
1434: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1435: igs_ge_msg_stack.add;

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

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;
1434: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1435: igs_ge_msg_stack.add;
1436: app_exception.raise_exception;

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

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');
1448: igs_ge_msg_stack.add;

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

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');
1448: igs_ge_msg_stack.add;
1449: app_exception.raise_exception;

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

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');
1464: igs_ge_msg_stack.add;

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

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');
1464: igs_ge_msg_stack.add;
1465: app_exception.raise_exception;

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

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');
1477: igs_ge_msg_stack.add;

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

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');
1477: igs_ge_msg_stack.add;
1478: app_exception.raise_exception;

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

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');
1490: igs_ge_msg_stack.add;

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

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');
1490: igs_ge_msg_stack.add;
1491: app_exception.raise_exception;

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

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');
1503: igs_ge_msg_stack.add;

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

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');
1503: igs_ge_msg_stack.add;
1504: app_exception.raise_exception;

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

1511: -- This is required as IGF_DB_DISB_HOLDS_PKG calls this Table Handler
1512: -- for Update Row.
1513: IF (UPPER(column_name) = 'MANUAL_HOLD_IND' OR column_name IS NULL) THEN
1514: IF NOT (new_references.manual_hold_ind IN ('N','Y')) THEN
1515: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.manual_hold_ind || ' for MANUAL_HOLD_IND is invalid ');
1517: END IF;
1518: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1519: igs_ge_msg_stack.add;

Line 1516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.manual_hold_ind || ' for MANUAL_HOLD_IND is invalid ');

1512: -- for Update Row.
1513: IF (UPPER(column_name) = 'MANUAL_HOLD_IND' OR column_name IS NULL) THEN
1514: IF NOT (new_references.manual_hold_ind IN ('N','Y')) THEN
1515: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1516: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.manual_hold_ind || ' for MANUAL_HOLD_IND is invalid ');
1517: END IF;
1518: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1519: igs_ge_msg_stack.add;
1520: app_exception.raise_exception;

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

1522: END IF;
1523:
1524: IF (UPPER(column_name) = 'LATE_DISB_IND' OR column_name IS NULL) THEN
1525: IF NOT (new_references.late_disb_ind IN ('Y', 'N')) THEN
1526: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1527: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.late_disb_ind || ' for LATE_DISB_IND is invalid ');
1528: END IF;
1529: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1530: igs_ge_msg_stack.add;

Line 1527: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.late_disb_ind || ' for LATE_DISB_IND is invalid ');

1523:
1524: IF (UPPER(column_name) = 'LATE_DISB_IND' OR column_name IS NULL) THEN
1525: IF NOT (new_references.late_disb_ind IN ('Y', 'N')) THEN
1526: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1527: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.late_disb_ind || ' for LATE_DISB_IND is invalid ');
1528: END IF;
1529: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1530: igs_ge_msg_stack.add;
1531: app_exception.raise_exception;

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

1533: END IF;
1534:
1535: IF (UPPER(column_name) = 'DIRECT_TO_BORR_FLAG' OR column_name IS NULL) THEN
1536: IF NOT (new_references.direct_to_borr_flag IN ('Y', 'N')) THEN
1537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.direct_to_borr_flag || ' for DIRECT_TO_BORR_FLAG is invalid ');
1539: END IF;
1540: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1541: igs_ge_msg_stack.add;

Line 1538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.direct_to_borr_flag || ' for DIRECT_TO_BORR_FLAG is invalid ');

1534:
1535: IF (UPPER(column_name) = 'DIRECT_TO_BORR_FLAG' OR column_name IS NULL) THEN
1536: IF NOT (new_references.direct_to_borr_flag IN ('Y', 'N')) THEN
1537: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1538: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_awd_disb_pkg.check_constraints.debug','TBH: Check Constraints Fail: Value ' || new_references.direct_to_borr_flag || ' for DIRECT_TO_BORR_FLAG is invalid ');
1539: END IF;
1540: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
1541: igs_ge_msg_stack.add;
1542: app_exception.raise_exception;

Line 2284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2280: --
2281: -- To Reflect summation of Disbursement Amounts into Award Table
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 (

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

2281: -- To Reflect summation of Disbursement Amounts into Award Table
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,

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 2296: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2292: new_references.disb_date,
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');

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

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:
2302: OPEN c;

Line 2723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2719: -- To Reflect summation of Disbursement Amounts into Award Table
2720: -- Action UPDATE
2721: --
2722: g_v_called_from := x_called_from;
2723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2724: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', ' g_v_called_from '||g_v_called_from);
2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );
2726: END IF;
2727: after_dml(p_action => 'UPDATE');

Line 2724: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', ' g_v_called_from '||g_v_called_from);

2720: -- Action UPDATE
2721: --
2722: g_v_called_from := x_called_from;
2723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2724: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', ' g_v_called_from '||g_v_called_from);
2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );
2726: END IF;
2727: after_dml(p_action => 'UPDATE');
2728: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );

2721: --
2722: g_v_called_from := x_called_from;
2723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2724: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', ' g_v_called_from '||g_v_called_from);
2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );
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 ' );

Line 2728: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2724: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', ' g_v_called_from '||g_v_called_from);
2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );
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,

Line 2729: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'after invoking after_dml ' );

2725: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.update_row ', 'before invoking after_dml ' );
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,

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 2739: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2735: new_references.disb_date,
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;

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 2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2963: FETCH cur_get_award INTO get_award_rec;
2964: CLOSE cur_get_award;
2965:
2966: g_v_called_from := x_called_from;
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2968: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' g_v_called_from '||g_v_called_from);
2969: END IF;
2970: before_dml (
2971: p_action => 'DELETE',

Line 2968: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' g_v_called_from '||g_v_called_from);

2964: CLOSE cur_get_award;
2965:
2966: g_v_called_from := x_called_from;
2967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2968: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' g_v_called_from '||g_v_called_from);
2969: END IF;
2970: before_dml (
2971: p_action => 'DELETE',
2972: x_rowid => x_rowid

Line 2974: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2970: before_dml (
2971: p_action => 'DELETE',
2972: x_rowid => x_rowid
2973: );
2974: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2975: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking BeforeRowInsertUpdateDelete1 ');
2976: END IF;
2977: BeforeRowInsertUpdateDelete1(
2978: p_rowid => x_rowid,

Line 2975: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking BeforeRowInsertUpdateDelete1 ');

2971: p_action => 'DELETE',
2972: x_rowid => x_rowid
2973: );
2974: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2975: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' before invoking BeforeRowInsertUpdateDelete1 ');
2976: END IF;
2977: BeforeRowInsertUpdateDelete1(
2978: p_rowid => x_rowid,
2979: p_inserting => FALSE,

Line 2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2979: p_inserting => FALSE,
2980: p_updating => FALSE ,
2981: p_deleting => TRUE
2982: );
2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');
2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);
2986: END IF;
2987: DELETE FROM igf_aw_awd_disb_all

Line 2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');

2980: p_updating => FALSE ,
2981: p_deleting => TRUE
2982: );
2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');
2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);
2986: END IF;
2987: DELETE FROM igf_aw_awd_disb_all
2988: WHERE rowid = x_rowid;

Line 2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);

2981: p_deleting => TRUE
2982: );
2983: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2984: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' after invoking BeforeRowInsertUpdateDelete1 ');
2985: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.delete_row ', ' deleting the record from igf_aw_awd_disb_all table for rowid '||x_rowid);
2986: END IF;
2987: DELETE FROM igf_aw_awd_disb_all
2988: WHERE rowid = x_rowid;
2989:

Line 2998: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2994: --
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,

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,