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

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

248: l_v_message_name fnd_new_messages.message_name%TYPE;
249: l_b_return_status BOOLEAN;
250: BEGIN
251: IF p_updating THEN
252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
253: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );
254: END IF;
255: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
256: p_v_message_name => l_v_message_name

Line 253: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );

249: l_b_return_status BOOLEAN;
250: BEGIN
251: IF p_updating THEN
252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
253: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'inside AfterRowInsertUpdateDelete1 ' );
254: END IF;
255: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => new_references.award_id,
256: p_v_message_name => l_v_message_name
257: );

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

259: fnd_message.set_name ('IGS',l_v_message_name);
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );

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

260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );

Line 265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );

261: app_exception.raise_exception;
262: END IF;
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );
269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );

Line 266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );

262: END IF;
263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );
269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );
270: END IF;

Line 267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );

263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );
269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );
270: END IF;
271: -- tsailaja -FA 163 -Bug 5337555

Line 268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );

264: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'fund code = '||l_v_fed_fund_code );
265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );
269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );
270: END IF;
271: -- tsailaja -FA 163 -Bug 5337555
272: IF l_v_fed_fund_code NOT IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN

Line 269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );

265: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'g_v_called_from = '||g_v_called_from );
266: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.award_status = '||old_references.award_status );
267: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.award_status = '||new_references.award_status );
268: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'old_references.accepted_amt = '||old_references.accepted_amt );
269: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'new_references.accepted_amt = '||new_references.accepted_amt );
270: END IF;
271: -- tsailaja -FA 163 -Bug 5337555
272: IF l_v_fed_fund_code NOT IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN
273: RETURN;

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

281: g_v_called_from = 'IGFAW016' ) THEN
282: -- delete all the change records created for this award id
283: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_n_award_id => new_references.award_id)
284: LOOP
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_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );

Line 286: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );

282: -- delete all the change records created for this award id
283: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_n_award_id => new_references.award_id)
284: LOOP
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_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );

Line 287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );

283: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_n_award_id => new_references.award_id)
284: LOOP
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_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );

Line 288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );

284: LOOP
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_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;

Line 289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );

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_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);

Line 290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );

286: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.clchgsnd_id : '||rec_c_sl_clchsn_dtls.clchgsnd_id );
287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );

287: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.loan_number_txt : '||rec_c_sl_clchsn_dtls.loan_number_txt );
288: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_field_code : '||rec_c_sl_clchsn_dtls.change_field_code );
289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Change Send Record deleted successfully ');

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

290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Change Send Record deleted successfully ');
296: END IF;
297: END LOOP;
298: END IF;

Line 295: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Change Send Record deleted successfully ');

291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Change Send Record deleted successfully ');
296: END IF;
297: END LOOP;
298: END IF;
299: IF ((new_references.award_status <> old_references.award_status) AND

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

300: new_references.award_status = 'CANCELLED' AND
301: new_references.accepted_amt = 0)
302: THEN
303: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
305: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan Cancellation. ' );
306: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
307: END IF;
308: igf_sl_cl_create_chg.create_awd_chg_rec

Line 305: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan Cancellation. ' );

301: new_references.accepted_amt = 0)
302: THEN
303: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
305: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan Cancellation. ' );
306: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
307: END IF;
308: igf_sl_cl_create_chg.create_awd_chg_rec
309: (

Line 306: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );

302: THEN
303: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
305: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan Cancellation. ' );
306: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
307: END IF;
308: igf_sl_cl_create_chg.create_awd_chg_rec
309: (
310: p_n_award_id => new_references.award_id,

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

321: THEN
322: -- substring of the out bound parameter l_v_message_name is carried
323: -- out since it can expect either IGS OR IGF message
324: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
325: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
326: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
327: END IF;
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;

Line 326: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);

322: -- substring of the out bound parameter l_v_message_name is carried
323: -- out since it can expect either IGS OR IGF message
324: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
325: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
326: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
327: END IF;
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;

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

331: END IF;
332: -- invoke the procedure to create reinstatement change record in igf_sl_clchsn_dtls table
333: IF ((old_references.accepted_amt <> new_references.accepted_amt) AND
334: new_references.award_status = 'ACCEPTED') THEN
335: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
336: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan reinstatement/loan increase. ' );
337: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
338: END IF;
339: igf_sl_cl_create_chg.create_awd_chg_rec

Line 336: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan reinstatement/loan increase. ' );

332: -- invoke the procedure to create reinstatement change record in igf_sl_clchsn_dtls table
333: IF ((old_references.accepted_amt <> new_references.accepted_amt) AND
334: new_references.award_status = 'ACCEPTED') THEN
335: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
336: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan reinstatement/loan increase. ' );
337: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
338: END IF;
339: igf_sl_cl_create_chg.create_awd_chg_rec
340: (

Line 337: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );

333: IF ((old_references.accepted_amt <> new_references.accepted_amt) AND
334: new_references.award_status = 'ACCEPTED') THEN
335: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
336: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan reinstatement/loan increase. ' );
337: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
338: END IF;
339: igf_sl_cl_create_chg.create_awd_chg_rec
340: (
341: p_n_award_id => new_references.award_id,

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

353: -- substring of the out bound parameter l_v_message_name is carried
354: -- out since it can expect either IGS OR IGF message
355: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
356: igs_ge_msg_stack.add;
357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
358: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
359: END IF;
360: app_exception.raise_exception;
361: END IF;

Line 358: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);

354: -- out since it can expect either IGS OR IGF message
355: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
356: igs_ge_msg_stack.add;
357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
358: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Call to igf_sl_cl_create_chg.create_awd_chg_rec returned error '|| l_v_message_name);
359: END IF;
360: app_exception.raise_exception;
361: END IF;
362: END IF;

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

1023: BEGIN
1024: l_rowid := NULL;
1025: IF (p_action = 'UPDATE') THEN
1026: -- Call all the procedures related to After Update.
1027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1028: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.after_dml ', 'before call to AfterRowInsertUpdateDelete1 ' );
1029: END IF;
1030: AfterRowInsertUpdateDelete1
1031: (

Line 1028: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.after_dml ', 'before call to AfterRowInsertUpdateDelete1 ' );

1024: l_rowid := NULL;
1025: IF (p_action = 'UPDATE') THEN
1026: -- Call all the procedures related to After Update.
1027: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1028: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.after_dml ', 'before call to AfterRowInsertUpdateDelete1 ' );
1029: END IF;
1030: AfterRowInsertUpdateDelete1
1031: (
1032: p_inserting => FALSE,

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

1557: BEGIN
1558: IF g_award_hist_tran_id IS NULL THEN
1559: SELECT IGF_AW_AWARD_LEVEL_HIST_S.NEXTVAL INTO g_award_hist_tran_id from dual;
1560: END IF;
1561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1562: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.check_award_history ', 'Transaction Id = '||g_award_hist_tran_id );
1563: END IF;
1564: END check_award_history;
1565:

Line 1562: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.check_award_history ', 'Transaction Id = '||g_award_hist_tran_id );

1558: IF g_award_hist_tran_id IS NULL THEN
1559: SELECT IGF_AW_AWARD_LEVEL_HIST_S.NEXTVAL INTO g_award_hist_tran_id from dual;
1560: END IF;
1561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1562: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.check_award_history ', 'Transaction Id = '||g_award_hist_tran_id );
1563: END IF;
1564: END check_award_history;
1565:
1566:

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

1785: new_references,
1786: 'UPDATE'
1787: );
1788: g_v_called_from := x_called_from;
1789: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1790: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'g_v_called_from '||g_v_called_from );
1791: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'before invoking after_dml ' );
1792: END IF;
1793: after_dml(

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

1786: 'UPDATE'
1787: );
1788: g_v_called_from := x_called_from;
1789: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1790: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'g_v_called_from '||g_v_called_from );
1791: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'before invoking after_dml ' );
1792: END IF;
1793: after_dml(
1794: p_action =>'UPDATE',

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

1787: );
1788: g_v_called_from := x_called_from;
1789: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1790: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'g_v_called_from '||g_v_called_from );
1791: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'before invoking after_dml ' );
1792: END IF;
1793: after_dml(
1794: p_action =>'UPDATE',
1795: x_rowid => x_rowid

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

1793: after_dml(
1794: p_action =>'UPDATE',
1795: x_rowid => x_rowid
1796: );
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'after invoking after_dml ' );
1799: END IF;
1800: g_v_called_from := NULL;
1801: END update_row;

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

1794: p_action =>'UPDATE',
1795: x_rowid => x_rowid
1796: );
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.update_row ', 'after invoking after_dml ' );
1799: END IF;
1800: g_v_called_from := NULL;
1801: END update_row;
1802:

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

2026: p_award_change_source IN igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE
2027: ) AS
2028: BEGIN
2029: g_award_change_source := p_award_change_source ;
2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2031: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.set_award_change_source ', 'g_award_source_change= '||g_award_change_source);
2032: END IF;
2033: END set_award_change_source;
2034:

Line 2031: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.set_award_change_source ', 'g_award_source_change= '||g_award_change_source);

2027: ) AS
2028: BEGIN
2029: g_award_change_source := p_award_change_source ;
2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2031: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.set_award_change_source ', 'g_award_source_change= '||g_award_change_source);
2032: END IF;
2033: END set_award_change_source;
2034:
2035: /*