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 IGF_SL_CLCHSN_DTLS_PKG

Line 998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);

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 ');
1001: END IF;
1002: END IF;

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 1159: igf_sl_clchsn_dtls_pkg.update_row (

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 ,
1162: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
1163: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,

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 1229: igf_sl_clchsn_dtls_pkg.update_row (

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 ,
1232: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
1233: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,

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 1304: igf_sl_clchsn_dtls_pkg.insert_row (

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 ,
1307: x_award_id => l_n_award_id ,
1308: x_loan_number_txt => l_v_loan_number ,