DBA Data[Home] [Help]

APPS.IGF_AW_AWARD_PKG dependencies on IGF_SL_CL_CREATE_CHG

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 308: igf_sl_cl_create_chg.create_awd_chg_rec

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,
311: p_n_old_amount => old_references.accepted_amt ,
312: p_n_new_amount => 0,

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 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 339: igf_sl_cl_create_chg.create_awd_chg_rec

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,
342: p_n_old_amount => old_references.accepted_amt ,
343: p_n_new_amount => new_references.accepted_amt,

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;