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 IGF_AW_AWARD_PKG

Line 1: PACKAGE BODY igf_aw_award_pkg AS

1: PACKAGE BODY igf_aw_award_pkg AS
2: /* $Header: IGFWI22B.pls 120.5 2006/08/03 12:14:46 tsailaja ship $ */
3: /*=======================================================================+
4: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, CalIFornia, USA|
5: | All rights reserved. |

Line 9: | PL/SQL body for package: IGF_AW_AWARD_PKG

5: | All rights reserved. |
6: +=======================================================================+
7: | |
8: | DESCRIPTION |
9: | PL/SQL body for package: IGF_AW_AWARD_PKG
10: | |
11: | NOTES |
12: | |
13: | This package has a flag on the end of some of the procedures called |

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 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 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 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 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 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 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 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 1004: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.update_award_history' || SQLERRM);

1000: CLOSE c_lookup_attribute;
1001: EXCEPTION
1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1004: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.update_award_history' || SQLERRM);
1005: IGS_GE_MSG_STACK.ADD;
1006: App_Exception.Raise_Exception;
1007: END update_award_history;
1008:

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 1352: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.insert_row' || SQLERRM);

1348: ) ;
1349: EXCEPTION
1350: WHEN OTHERS THEN
1351: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1352: FND_MESSAGE.SET_TOKEN('NAME','igf_aw_award_pkg.insert_row' || SQLERRM);
1353: IGS_GE_MSG_STACK.ADD;
1354: App_Exception.Raise_Exception;
1355: END insert_row;
1356:

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 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 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 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: /*

Line 2051: END igf_aw_award_pkg;

2047: BEGIN
2048: g_award_hist_tran_id := NULL;
2049: END reset_awd_hist_trans_id;
2050:
2051: END igf_aw_award_pkg;