APPS.IGF_GR_LI_IMPORT dependencies on FND_LOG_MESSAGES

Line 276: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Function derive_rep_pell_id() :: ';

272: || (reverse chronological order - newest change first)
273: */
274: AS
275: l_rep_pell VARCHAR2(30);
276: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Function derive_rep_pell_id() :: ';
277:
278:
279: BEGIN
280: IF (p_pell_orig_int.ope_cd IS NOT NULL)

Line 408: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure update_fa_base_data :: ';

404: WHERE base.base_id = cp_base_id;
405:
406: lc_get_base_rec_dtls c_get_base_rec_dtls%ROWTYPE;
407:
408: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure update_fa_base_data :: ';
409:
410: BEGIN
411:
412: -- Get the details of the Base record to update the PELL COA and PELL ALT Expenses

Line 605: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure delete_existing_pell_rec :: ';

601: FROM igf_gr_rfms_disb_all pdb
602: WHERE pdb.origination_id = cp_origination_id;
603:
604: l_return_val VARCHAR2(1) := 'E';
605: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure delete_existing_pell_rec :: ';
606:
607: BEGIN
608:
609: -- check whether Pell Origination record is present in the system with the legacy flag is set to 'Y'

Line 856: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Function import_pell_disb :: ';

852:
853: lc_awd_disb c_awd_disb%ROWTYPE;
854:
855: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
856: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Function import_pell_disb :: ';
857: l_disb_import_status VARCHAR2(1) := 'I';
858: l_disb_batch_id VARCHAR2(30);
859:
860: BEGIN

Line 1315: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure create_pell_orig :: ';

1311:
1312: lc_pymt_prds_n_date c_pymt_prds_n_date%ROWTYPE;
1313:
1314: l_row_id ROWID;
1315: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure create_pell_orig :: ';
1316:
1317: BEGIN
1318:
1319: -- Get the Total Payment periods and First disbursement date

Line 1485: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure import_pell_orig (1) :: ';

1481: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;
1482: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;
1483: l_disb_num_prmpt igf_lookups_view.meaning%TYPE;
1484: l_processing igf_lookups_view.meaning%TYPE;
1485: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure import_pell_orig (1) :: ';
1486: l_error VARCHAR2(30);
1487: l_orig_batch_id VARCHAR2(30);
1488: l_pell_mat VARCHAR2(10);
1489: l_pell_disb_full_status VARCHAR2(1);

Line 2550: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure main :: ';

2546: l_prev_person_number hz_parties.party_number%TYPE;
2547: l_processing igf_lookups_view.meaning%TYPE;
2548: l_person_number igf_lookups_view.meaning%TYPE;
2549: l_award_number igf_lookups_view.meaning%TYPE;
2550: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure main :: ';
2551: l_pell_import_status VARCHAR2(1);
2552: l_chk_batch VARCHAR2(1);
2553: l_chk_setups VARCHAR2(1);
2554: l_chk_profile VARCHAR2(1);