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.PSA_FUNDS_CHECKER_PKG dependencies on FND_FILE

Line 7845: fnd_file.put_line(fnd_file.output, '');

7841: l_xml_f_bud_sum_header := true;
7842:
7843: --Start of xml report output
7844: -- =========================== XML OUT =============================
7845: fnd_file.put_line(fnd_file.output, '');
7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');

Line 7846: fnd_file.put_line(fnd_file.output, '');

7842:
7843: --Start of xml report output
7844: -- =========================== XML OUT =============================
7845: fnd_file.put_line(fnd_file.output, '');
7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');

Line 7847: fnd_file.put_line(fnd_file.output, ' ');

7843: --Start of xml report output
7844: -- =========================== XML OUT =============================
7845: fnd_file.put_line(fnd_file.output, '');
7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');

Line 7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');

7844: -- =========================== XML OUT =============================
7845: fnd_file.put_line(fnd_file.output, '');
7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
7852: fnd_file.put_line(fnd_file.output, ' ');

Line 7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');

7845: fnd_file.put_line(fnd_file.output, '');
7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
7852: fnd_file.put_line(fnd_file.output, ' ');
7853: -- =========================== XML OUT =============================

Line 7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');

7846: fnd_file.put_line(fnd_file.output, '');
7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
7852: fnd_file.put_line(fnd_file.output, ' ');
7853: -- =========================== XML OUT =============================
7854:

Line 7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');

7847: fnd_file.put_line(fnd_file.output, ' ');
7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
7852: fnd_file.put_line(fnd_file.output, ' ');
7853: -- =========================== XML OUT =============================
7854:
7855: BEGIN

Line 7852: fnd_file.put_line(fnd_file.output, ' ');

7848: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
7849: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
7850: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
7851: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
7852: fnd_file.put_line(fnd_file.output, ' ');
7853: -- =========================== XML OUT =============================
7854:
7855: BEGIN
7856: SELECT

Line 7875: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');

7871: set_of_books_id = p_ledger_id;
7872: EXCEPTION
7873: WHEN OTHERS THEN
7874: -- =========================== FND LOG ===========================
7875: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7876: psa_utils.debug_other_string(g_excep_level,l_full_path,
7877: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
7878: -- ========================= FND LOG =============================
7879: END;

Line 7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);

7878: -- ========================= FND LOG =============================
7879: END;
7880:
7881: -- =========================== FND LOG ===========================
7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);

Line 7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);

7879: END;
7880:
7881: -- =========================== FND LOG ===========================
7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);

Line 7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);

7880:
7881: -- =========================== FND LOG ===========================
7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
7888: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);

Line 7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);

7881: -- =========================== FND LOG ===========================
7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
7888: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
7889: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);

Line 7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);

7882: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
7888: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
7889: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7890: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);

Line 7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);

7883: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7884: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7885: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
7886: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
7887: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
7888: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
7889: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
7890: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
7891: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_coa_id -> '||l_coa_id);

Line 7902: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);

7898: l_bc_not_enabled_msg := FND_MESSAGE.GET();
7899: -- =========================== FND LOG ===========================
7900: psa_utils.debug_other_string(g_state_level, l_full_path,
7901: 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag); --Need to finalize the debug level
7902: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);
7903: -- ========================= FND LOG =============================
7904:
7905: -- =========================== XML OUT =============================
7906: fnd_file.put_line(fnd_file.output, ''||l_bc_not_enabled_msg||'');

Line 7906: fnd_file.put_line(fnd_file.output, ''||l_bc_not_enabled_msg||'');

7902: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);
7903: -- ========================= FND LOG =============================
7904:
7905: -- =========================== XML OUT =============================
7906: fnd_file.put_line(fnd_file.output, ''||l_bc_not_enabled_msg||'');
7907: -- =========================== XML OUT =============================
7908: GOTO normal_exit;
7909: END IF;
7910:

Line 7925: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');

7921: WHEN OTHERS THEN
7922: -- =========================== FND LOG ===========================
7923: psa_utils.debug_other_string(g_excep_level,l_full_path,
7924: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7925: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
7926: -- ========================= FND LOG =============================
7927: END;
7928:
7929: l_appl_id := 101;

Line 7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);

7930: l_resp_id := FND_GLOBAL.resp_id;
7931: l_user_id := FND_GLOBAL.user_id;
7932:
7933: -- =========================== FND LOG ===========================
7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);

Line 7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);

7931: l_user_id := FND_GLOBAL.user_id;
7932:
7933: -- =========================== FND LOG ===========================
7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
7939: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);

Line 7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);

7932:
7933: -- =========================== FND LOG ===========================
7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
7939: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7940: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);

Line 7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);

7933: -- =========================== FND LOG ===========================
7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
7939: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7940: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7941: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_appl_id -> '||l_appl_id);

Line 7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);

7934: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7935: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7936: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
7937: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
7938: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
7939: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
7940: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
7941: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_appl_id -> '||l_appl_id);
7942: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_resp_id -> '||l_resp_id);

Line 7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');

7987:
7988: l_packet_id := get_packet_id;
7989:
7990: -- =========================== FND LOG ===========================
7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);

Line 7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);

7988: l_packet_id := get_packet_id;
7989:
7990: -- =========================== FND LOG ===========================
7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);

Line 7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);

7989:
7990: -- =========================== FND LOG ===========================
7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);

Line 7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);

7990: -- =========================== FND LOG ===========================
7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
7998: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');

Line 7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);

7991: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
7998: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
7999: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);

Line 7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);

7992: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
7998: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
7999: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);
8000: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_actual_flag -> '||l_actual_flag);

Line 7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);

7993: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
7994: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
7995: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
7996: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
7997: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
7998: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
7999: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);
8000: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8001: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);

Line 8009: fnd_file.put_line(fnd_file.output, ' ');

8005: -- =========================== FND LOG =============================
8006:
8007: -- =========================== XML OUT =============================
8008: IF (l_xml_b_header <> FALSE) THEN
8009: fnd_file.put_line(fnd_file.output, ' ');
8010: l_xml_b_header := FALSE;
8011: END IF;
8012: -- =========================== XML OUT =============================
8013:

Line 8032: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);

8028:
8029: l_main_stmt := '';
8030:
8031: -- =========================== FND LOG ===========================
8032: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8033: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8034: -- =========================== FND LOG =============================
8035:
8036: l_tmp_stmt := 'SELECT '||

Line 8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);

8065: l_session_id||', '||l_serial_id||', '||l_appl_id||', '||
8066: 'NULL, NULL';
8067:
8068: -- =========================== FND LOG ===========================
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8070: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8071: -- =========================== FND LOG =============================
8072:
8073: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';

Line 8093: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);

8089:
8090: l_tmp_stmt := l_tmp_stmt || l_action_stmt;
8091:
8092: -- =========================== FND LOG ===========================
8093: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8094: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8095: -- =========================== FND LOG =============================
8096:
8097: l_main_stmt := l_main_stmt || l_tmp_stmt;

Line 8100: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);

8096:
8097: l_main_stmt := l_main_stmt || l_tmp_stmt;
8098:
8099: -- =========================== FND LOG ===========================
8100: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8101: fnd_file.put_line(fnd_file.log, 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8102: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8103: psa_utils.debug_other_string(g_state_level, l_full_path,
8104: 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');

Line 8101: fnd_file.put_line(fnd_file.log, 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');

8097: l_main_stmt := l_main_stmt || l_tmp_stmt;
8098:
8099: -- =========================== FND LOG ===========================
8100: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8101: fnd_file.put_line(fnd_file.log, 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8102: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8103: psa_utils.debug_other_string(g_state_level, l_full_path,
8104: 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8105: -- =========================== FND LOG =============================

Line 8130: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() per packet.');

8126:
8127: -- Invoke funds checker per packet_id
8128:
8129: -- ====== FND LOG ======
8130: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() per packet.');
8131: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: BCTRL -> Invoking glxfck() per packet.');
8132: -- ====== FND LOG ======
8133:
8134: FOR x in 1..l_bc_pkts.count

Line 8139: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() for packet_id '||l_bc_pkts(x).packet_id);

8135: LOOP
8136: IF (x = 1 OR (l_bc_pkts(x).packet_id <> l_bc_pkts(x-1).packet_id)) THEN
8137:
8138: -- ====== FND LOG ======
8139: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() for packet_id '||l_bc_pkts(x).packet_id);
8140: psa_utils.debug_other_string(g_state_level,l_full_path,
8141: 'Funds C/R: BCTRL -> Invoking glxfck() for packet_id '||l_bc_pkts(x).packet_id);
8142: -- ====== FND LOG ======
8143:

Line 8154: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> glxfck() failed ');

8150: p_user_resp_id => l_resp_id,
8151: p_calling_prog_flag => 'G',
8152: p_return_code => l_glxfck_return_code) THEN
8153: -- ====== FND LOG ======
8154: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> glxfck() failed ');
8155: psa_utils.debug_other_string(g_error_level,l_full_path, 'Funds C/R: BCTRL -> glxfck() failed ');
8156: -- ====== FND LOG ======
8157:
8158: -- ============================== FND LOG =========================

Line 8159: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL l_glxfck_return_code -> T ');

8155: psa_utils.debug_other_string(g_error_level,l_full_path, 'Funds C/R: BCTRL -> glxfck() failed ');
8156: -- ====== FND LOG ======
8157:
8158: -- ============================== FND LOG =========================
8159: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL l_glxfck_return_code -> T ');
8160: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: BCTRL l_glxfck_return_code -> T ');
8161: -- ============================== FND LOG =========================
8162:
8163: l_glxfck_return_code := 'T';

Line 8173: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);

8169: -- Fatal, we insert into failed packets table type.
8170: IF (l_glxfck_return_code <> 'S') THEN
8171:
8172: -- ============================== FND LOG =========================
8173: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8174: fnd_file.put_line(fnd_file.log, 'Funds C/R: Inserting into l_failed_bc_pkts for packet_id->'||l_bc_pkts(x).packet_id);
8175: psa_utils.debug_other_string(g_state_level,l_full_path,
8176: 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8177: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 8174: fnd_file.put_line(fnd_file.log, 'Funds C/R: Inserting into l_failed_bc_pkts for packet_id->'||l_bc_pkts(x).packet_id);

8170: IF (l_glxfck_return_code <> 'S') THEN
8171:
8172: -- ============================== FND LOG =========================
8173: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8174: fnd_file.put_line(fnd_file.log, 'Funds C/R: Inserting into l_failed_bc_pkts for packet_id->'||l_bc_pkts(x).packet_id);
8175: psa_utils.debug_other_string(g_state_level,l_full_path,
8176: 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8177: psa_utils.debug_other_string(g_state_level,l_full_path,
8178: 'Funds C/R: Inserting into l_failed_bc_pkts for packet_id->'||l_bc_pkts(x).packet_id);

Line 8188: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);

8184:
8185: END IF;
8186:
8187: -- =========================== FND LOG ===========================
8188: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8189: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8190: -- =========================== FND LOG =============================
8191: BEGIN
8192: UPDATE

Line 8218: fnd_file.put_line(fnd_file.log,

8214: WHEN OTHERS THEN
8215: -- =========================== FND LOG ===========================
8216: psa_utils.debug_other_string(g_excep_level,l_full_path,
8217: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8218: fnd_file.put_line(fnd_file.log,
8219: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8220: -- ========================= FND LOG =============================
8221: END;
8222:

Line 8238: fnd_file.put_line(fnd_file.log,

8234: WHEN OTHERS THEN
8235: -- =========================== FND LOG ===========================
8236: psa_utils.debug_other_string(g_excep_level,l_full_path,
8237: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8238: fnd_file.put_line(fnd_file.log,
8239: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8240: -- ========================= FND LOG =============================
8241: END;
8242:

Line 8244: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code F Meaning l_fmeaning -> '||l_fmeaning);

8240: -- ========================= FND LOG =============================
8241: END;
8242:
8243: -- =========================== FND LOG ===========================
8244: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code F Meaning l_fmeaning -> '||l_fmeaning);
8245: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code F Meaning l_fmeaning -> '||l_fmeaning);
8246: -- =========================== FND LOG =============================
8247:
8248: BEGIN

Line 8265: fnd_file.put_line(fnd_file.log,

8261: WHEN OTHERS THEN
8262: -- =========================== FND LOG ===========================
8263: psa_utils.debug_other_string(g_excep_level,l_full_path,
8264: 'Funds C/R: Failed to fetch meaning from gl_je_batches');
8265: fnd_file.put_line(fnd_file.log,
8266: 'Funds C/R: Failed to fetch meaning from gl_be_batches');
8267: -- ========================= FND LOG =============================
8268: END;
8269:

Line 8271: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);

8267: -- ========================= FND LOG =============================
8268: END;
8269:
8270: -- =========================== FND LOG ===========================
8271: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8272: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8273: -- =========================== FND LOG =============================
8274:
8275: -- =========================== XML OUT =============================

Line 8276: fnd_file.put_line(fnd_file.output, ' ');

8272: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8273: -- =========================== FND LOG =============================
8274:
8275: -- =========================== XML OUT =============================
8276: fnd_file.put_line(fnd_file.output, ' ');
8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');

Line 8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');

8273: -- =========================== FND LOG =============================
8274:
8275: -- =========================== XML OUT =============================
8276: fnd_file.put_line(fnd_file.output, ' ');
8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8281: fnd_file.put_line(fnd_file.output, ' ');

Line 8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');

8274:
8275: -- =========================== XML OUT =============================
8276: fnd_file.put_line(fnd_file.output, ' ');
8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8281: fnd_file.put_line(fnd_file.output, ' ');
8282: -- =========================== XML OUT =============================

Line 8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');

8275: -- =========================== XML OUT =============================
8276: fnd_file.put_line(fnd_file.output, ' ');
8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8281: fnd_file.put_line(fnd_file.output, ' ');
8282: -- =========================== XML OUT =============================
8283:

Line 8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');

8276: fnd_file.put_line(fnd_file.output, ' ');
8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8281: fnd_file.put_line(fnd_file.output, ' ');
8282: -- =========================== XML OUT =============================
8283:
8284: END IF;

Line 8281: fnd_file.put_line(fnd_file.output, ' ');

8277: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8278: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8279: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8280: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8281: fnd_file.put_line(fnd_file.output, ' ');
8282: -- =========================== XML OUT =============================
8283:
8284: END IF;
8285:

Line 8290: fnd_file.put_line(fnd_file.output, ' ');

8286: END LOOP; --End of loop for all l_bc_pkts
8287:
8288: -- =========================== XML OUT =============================
8289: IF (l_xml_b_header <> TRUE) THEN
8290: fnd_file.put_line(fnd_file.output, ' ');
8291: END IF;
8292: -- =========================== XML OUT =============================
8293:
8294: -- =========================== FND LOG ===========================

Line 8295: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');

8291: END IF;
8292: -- =========================== XML OUT =============================
8293:
8294: -- =========================== FND LOG ===========================
8295: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8296: -- =========================== FND LOG ===========================
8297:
8298: --Now processing failed batches/packets.
8299: FOR x in 1..l_failed_bc_pkts.count

Line 8301: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');

8297:
8298: --Now processing failed batches/packets.
8299: FOR x in 1..l_failed_bc_pkts.count
8300: LOOP
8301: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8302: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8303: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8304: l_failed_bc_pkts(x).packet_id||
8305: ' Batch Id: '||

Line 8302: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');

8298: --Now processing failed batches/packets.
8299: FOR x in 1..l_failed_bc_pkts.count
8300: LOOP
8301: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8302: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8303: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8304: l_failed_bc_pkts(x).packet_id||
8305: ' Batch Id: '||
8306: l_failed_bc_pkts(x).je_batch_id||

Line 8303: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||

8299: FOR x in 1..l_failed_bc_pkts.count
8300: LOOP
8301: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8302: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8303: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8304: l_failed_bc_pkts(x).packet_id||
8305: ' Batch Id: '||
8306: l_failed_bc_pkts(x).je_batch_id||
8307: ' Batch Name: '||l_failed_bc_pkts(x).je_batch_name);

Line 8312: fnd_file.put_line(fnd_file.output, ' YES');

8308:
8309:
8310: -- =========================== XML OUT =============================
8311: IF (l_xml_f_b_header <> FALSE) THEN
8312: fnd_file.put_line(fnd_file.output, ' YES');
8313: fnd_file.put_line(fnd_file.output, ' ');
8314: l_xml_f_b_header := FALSE;
8315: END IF;
8316: -- =========================== XML OUT =============================

Line 8313: fnd_file.put_line(fnd_file.output, ' ');

8309:
8310: -- =========================== XML OUT =============================
8311: IF (l_xml_f_b_header <> FALSE) THEN
8312: fnd_file.put_line(fnd_file.output, ' YES');
8313: fnd_file.put_line(fnd_file.output, ' ');
8314: l_xml_f_b_header := FALSE;
8315: END IF;
8316: -- =========================== XML OUT =============================
8317:

Line 8319: fnd_file.put_line(fnd_file.output, ' ');

8315: END IF;
8316: -- =========================== XML OUT =============================
8317:
8318: -- =========================== XML OUT =============================
8319: fnd_file.put_line(fnd_file.output, ' ');
8320: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8321: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8322: -- =========================== XML OUT =============================
8323:

Line 8320: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');

8316: -- =========================== XML OUT =============================
8317:
8318: -- =========================== XML OUT =============================
8319: fnd_file.put_line(fnd_file.output, ' ');
8320: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8321: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8322: -- =========================== XML OUT =============================
8323:
8324:

Line 8321: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');

8317:
8318: -- =========================== XML OUT =============================
8319: fnd_file.put_line(fnd_file.output, ' ');
8320: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8321: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8322: -- =========================== XML OUT =============================
8323:
8324:
8325: l_je_stmt := 'SELECT ';

Line 8357: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_stmt -> '|| l_je_stmt);

8353: ' and p.ussgl_link_to_parent_id is null'||
8354: ' and (p.result_code like ''F%'' or p.result_code like ''P2%'') '||
8355: ' order by l.je_header_id, l.je_line_num';
8356:
8357: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_stmt -> '|| l_je_stmt);
8358:
8359: l_xml_je_lines_header := TRUE;
8360:
8361: OPEN l_je_lines FOR l_je_stmt;

Line 8368: fnd_file.put_line(fnd_file.log, 'Funds C/R: '|| l_seg_ccid||' '||l_je_header_name||' '||l_je_header_id

8364: FETCH l_je_lines INTO l_seg_ccid, l_je_header_name, l_je_header_id, l_je_line_num, l_entered_dr,
8365: l_entered_cr, l_line_description, l_line_result_code, l_ccid, l_rowid;
8366:
8367: -- =========================== FND LOG ===========================
8368: fnd_file.put_line(fnd_file.log, 'Funds C/R: '|| l_seg_ccid||' '||l_je_header_name||' '||l_je_header_id
8369: ||' '||l_je_line_num||' '||l_entered_dr||' '||l_entered_cr||
8370: ' '||l_line_description||' '||l_line_result_code||' '||l_ccid||
8371: ' '||l_rowid);
8372: -- =========================== FND LOG ===========================

Line 8390: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');

8386: EXCEPTION
8387: WHEN OTHERS THEN
8388: -- =========================== FND LOG ===========================
8389: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8390: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8391: -- ========================= FND LOG =============================
8392: END;
8393:
8394:

Line 8396: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_failed_bc_pkts(x).je_batch_name||

8392: END;
8393:
8394:
8395: -- =========================== FND LOG ===========================
8396: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_failed_bc_pkts(x).je_batch_name||
8397: l_je_header_name||' '||l_seg_ccid||' '||
8398: l_entered_dr||' '||l_entered_cr||
8399: ' '||l_priority);
8400: -- =========================== FND LOG ===========================

Line 8404: fnd_file.put_line(fnd_file.output, ' '||l_je_header_name||'');

8400: -- =========================== FND LOG ===========================
8401:
8402: -- =========================== XML OUT =============================
8403: IF (l_xml_je_lines_header <> FALSE) THEN
8404: fnd_file.put_line(fnd_file.output, ' '||l_je_header_name||'');
8405: fnd_file.put_line(fnd_file.output, ' ');
8406: l_xml_je_lines_header := FALSE;
8407: END IF;
8408: -- =========================== XML OUT =============================

Line 8405: fnd_file.put_line(fnd_file.output, ' ');

8401:
8402: -- =========================== XML OUT =============================
8403: IF (l_xml_je_lines_header <> FALSE) THEN
8404: fnd_file.put_line(fnd_file.output, ' '||l_je_header_name||'');
8405: fnd_file.put_line(fnd_file.output, ' ');
8406: l_xml_je_lines_header := FALSE;
8407: END IF;
8408: -- =========================== XML OUT =============================
8409:

Line 8411: fnd_file.put_line(fnd_file.output, ' ');

8407: END IF;
8408: -- =========================== XML OUT =============================
8409:
8410: -- =========================== XML OUT =============================
8411: fnd_file.put_line(fnd_file.output, ' ');
8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');

Line 8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');

8408: -- =========================== XML OUT =============================
8409:
8410: -- =========================== XML OUT =============================
8411: fnd_file.put_line(fnd_file.output, ' ');
8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');

Line 8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');

8409:
8410: -- =========================== XML OUT =============================
8411: fnd_file.put_line(fnd_file.output, ' ');
8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');

Line 8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');

8410: -- =========================== XML OUT =============================
8411: fnd_file.put_line(fnd_file.output, ' ');
8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');
8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');

Line 8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');

8411: fnd_file.put_line(fnd_file.output, ' ');
8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');
8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8419: -- =========================== XML OUT =============================

Line 8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');

8412: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');
8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8419: -- =========================== XML OUT =============================
8420:

Line 8417: fnd_file.put_line(fnd_file.output, ' ');

8413: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');
8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8419: -- =========================== XML OUT =============================
8420:
8421:

Line 8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');

8414: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8415: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8416: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8417: fnd_file.put_line(fnd_file.output, ' ');
8418: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8419: -- =========================== XML OUT =============================
8420:
8421:
8422: l_xml_f_sum_header := true;

Line 8451: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_seg_stmt -> '||l_je_seg_stmt);

8447: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8448: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8449: ' and c.code_combination_id = p.code_combination_id';
8450:
8451: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_seg_stmt -> '||l_je_seg_stmt);
8452:
8453: OPEN l_je_sum_lines for l_je_seg_stmt;
8454: LOOP
8455: FETCH l_je_sum_lines into l_je_sum_flex;

Line 8460: fnd_file.put_line(fnd_file.output, ' ');

8456: EXIT WHEN l_je_sum_lines%NOTFOUND;
8457:
8458: -- =========================== XML OUT =============================
8459: IF (l_xml_f_sum_header <> FALSE) THEN
8460: fnd_file.put_line(fnd_file.output, ' ');
8461: fnd_file.put_line(fnd_file.output, ' YES');
8462: l_xml_f_sum_header := FALSE;
8463: END IF;
8464: -- =========================== XML OUT =============================

Line 8461: fnd_file.put_line(fnd_file.output, ' YES');

8457:
8458: -- =========================== XML OUT =============================
8459: IF (l_xml_f_sum_header <> FALSE) THEN
8460: fnd_file.put_line(fnd_file.output, ' ');
8461: fnd_file.put_line(fnd_file.output, ' YES');
8462: l_xml_f_sum_header := FALSE;
8463: END IF;
8464: -- =========================== XML OUT =============================
8465:

Line 8466: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);

8462: l_xml_f_sum_header := FALSE;
8463: END IF;
8464: -- =========================== XML OUT =============================
8465:
8466: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8467:
8468: -- =========================== XML OUT =============================
8469: fnd_file.put_line(fnd_file.output, ' ');
8470: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');

Line 8469: fnd_file.put_line(fnd_file.output, ' ');

8465:
8466: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8467:
8468: -- =========================== XML OUT =============================
8469: fnd_file.put_line(fnd_file.output, ' ');
8470: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8471: fnd_file.put_line(fnd_file.output, ' ');
8472: -- =========================== XML OUT =============================
8473:

Line 8470: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');

8466: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8467:
8468: -- =========================== XML OUT =============================
8469: fnd_file.put_line(fnd_file.output, ' ');
8470: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8471: fnd_file.put_line(fnd_file.output, ' ');
8472: -- =========================== XML OUT =============================
8473:
8474: END LOOP; --End of l_je_sum_lines cursor

Line 8471: fnd_file.put_line(fnd_file.output, ' ');

8467:
8468: -- =========================== XML OUT =============================
8469: fnd_file.put_line(fnd_file.output, ' ');
8470: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8471: fnd_file.put_line(fnd_file.output, ' ');
8472: -- =========================== XML OUT =============================
8473:
8474: END LOOP; --End of l_je_sum_lines cursor
8475:

Line 8479: fnd_file.put_line(fnd_file.output, ' ');

8475:
8476: CLOSE l_je_sum_lines;
8477: -- =========================== XML OUT =============================
8478: IF (l_xml_f_sum_header <> TRUE) THEN
8479: fnd_file.put_line(fnd_file.output, ' ');
8480: l_xml_f_sum_header := TRUE;
8481: END IF;
8482: -- =========================== XML OUT =============================
8483:

Line 8515: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch ussgl_parent_id from gl_bc_packets');

8511: EXCEPTION
8512: WHEN OTHERS THEN
8513: -- =========================== FND LOG ===========================
8514: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch ussgl_parent_id from gl_bc_packets');
8515: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch ussgl_parent_id from gl_bc_packets');
8516: -- ========================= FND LOG =============================
8517: END;
8518:
8519: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||

Line 8528: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_stmt -> '||l_je_bud_stmt);

8524: ' and p.result_code between ''F00'' AND ''F30'' and '||
8525: ' p.result_code = l.lookup_code and l.lookup_type = ''FUNDS_CHECK_RESULT_CODE'' '||
8526: ' order by p.code_combination_id';
8527:
8528: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_stmt -> '||l_je_bud_stmt);
8529:
8530: OPEN l_je_bud_lines for l_je_bud_stmt;
8531: LOOP
8532: FETCH l_je_bud_lines into l_je_bud_flex, l_je_bud_dr, l_je_bud_cr, l_je_bud_result_code,

Line 8536: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_flex -> '||l_je_bud_flex

8532: FETCH l_je_bud_lines into l_je_bud_flex, l_je_bud_dr, l_je_bud_cr, l_je_bud_result_code,
8533: l_je_bud_desc, l_je_bud_ccid;
8534:
8535: EXIT WHEN l_je_bud_lines%NOTFOUND;
8536: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_flex -> '||l_je_bud_flex
8537: ||'l_je_bud_dr ->' ||l_je_bud_dr
8538: ||'l_je_bud_cr ->' ||l_je_bud_cr
8539: ||'l_je_bud_result_code ->' ||l_je_bud_result_code
8540: ||'l_je_bud_desc ->' ||l_je_bud_desc

Line 8546: fnd_file.put_line(fnd_file.output, ' ');

8542: );
8543:
8544: -- =========================== XML OUT =============================
8545: IF (l_xml_f_bud_header <> FALSE) THEN
8546: fnd_file.put_line(fnd_file.output, ' ');
8547: fnd_file.put_line(fnd_file.output, ' YES');
8548: l_xml_f_bud_header := FALSE;
8549: END IF;
8550: -- =========================== XML OUT =============================

Line 8547: fnd_file.put_line(fnd_file.output, ' YES');

8543:
8544: -- =========================== XML OUT =============================
8545: IF (l_xml_f_bud_header <> FALSE) THEN
8546: fnd_file.put_line(fnd_file.output, ' ');
8547: fnd_file.put_line(fnd_file.output, ' YES');
8548: l_xml_f_bud_header := FALSE;
8549: END IF;
8550: -- =========================== XML OUT =============================
8551:

Line 8553: fnd_file.put_line(fnd_file.output, ' ');

8549: END IF;
8550: -- =========================== XML OUT =============================
8551:
8552: -- =========================== XML OUT =============================
8553: fnd_file.put_line(fnd_file.output, ' ');
8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');

Line 8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');

8550: -- =========================== XML OUT =============================
8551:
8552: -- =========================== XML OUT =============================
8553: fnd_file.put_line(fnd_file.output, ' ');
8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8558: fnd_file.put_line(fnd_file.output, ' ');

Line 8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');

8551:
8552: -- =========================== XML OUT =============================
8553: fnd_file.put_line(fnd_file.output, ' ');
8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8558: fnd_file.put_line(fnd_file.output, ' ');
8559: -- =========================== XML OUT =============================

Line 8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');

8552: -- =========================== XML OUT =============================
8553: fnd_file.put_line(fnd_file.output, ' ');
8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8558: fnd_file.put_line(fnd_file.output, ' ');
8559: -- =========================== XML OUT =============================
8560:

Line 8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');

8553: fnd_file.put_line(fnd_file.output, ' ');
8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8558: fnd_file.put_line(fnd_file.output, ' ');
8559: -- =========================== XML OUT =============================
8560:
8561: l_xml_f_bud_sum_header := true;

Line 8558: fnd_file.put_line(fnd_file.output, ' ');

8554: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8555: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8556: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8557: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8558: fnd_file.put_line(fnd_file.output, ' ');
8559: -- =========================== XML OUT =============================
8560:
8561: l_xml_f_bud_sum_header := true;
8562:

Line 8588: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_seg_stmt -> '||l_je_bud_seg_stmt);

8584: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8585: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8586: ' and c.code_combination_id = p.code_combination_id';
8587:
8588: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_seg_stmt -> '||l_je_bud_seg_stmt);
8589:
8590: OPEN l_je_sum_lines for l_je_bud_seg_stmt;
8591: LOOP
8592: FETCH l_je_sum_lines into l_je_bud_sum_flex;

Line 8594: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_sum_flex -> '||l_je_bud_sum_flex);

8590: OPEN l_je_sum_lines for l_je_bud_seg_stmt;
8591: LOOP
8592: FETCH l_je_sum_lines into l_je_bud_sum_flex;
8593: EXIT WHEN l_je_sum_lines%NOTFOUND;
8594: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_sum_flex -> '||l_je_bud_sum_flex);
8595:
8596: -- =========================== XML OUT =============================
8597: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8598: fnd_file.put_line(fnd_file.output, ' ');

Line 8598: fnd_file.put_line(fnd_file.output, ' ');

8594: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_sum_flex -> '||l_je_bud_sum_flex);
8595:
8596: -- =========================== XML OUT =============================
8597: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8598: fnd_file.put_line(fnd_file.output, ' ');
8599: fnd_file.put_line(fnd_file.output, ' YES');
8600: l_xml_f_bud_sum_header := FALSE;
8601: END IF;
8602: -- =========================== XML OUT =============================

Line 8599: fnd_file.put_line(fnd_file.output, ' YES');

8595:
8596: -- =========================== XML OUT =============================
8597: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8598: fnd_file.put_line(fnd_file.output, ' ');
8599: fnd_file.put_line(fnd_file.output, ' YES');
8600: l_xml_f_bud_sum_header := FALSE;
8601: END IF;
8602: -- =========================== XML OUT =============================
8603: -- =========================== XML OUT =============================

Line 8604: fnd_file.put_line(fnd_file.output, ' ');

8600: l_xml_f_bud_sum_header := FALSE;
8601: END IF;
8602: -- =========================== XML OUT =============================
8603: -- =========================== XML OUT =============================
8604: fnd_file.put_line(fnd_file.output, ' ');
8605: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8606: fnd_file.put_line(fnd_file.output, ' ');
8607: -- =========================== XML OUT =============================
8608:

Line 8605: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');

8601: END IF;
8602: -- =========================== XML OUT =============================
8603: -- =========================== XML OUT =============================
8604: fnd_file.put_line(fnd_file.output, ' ');
8605: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8606: fnd_file.put_line(fnd_file.output, ' ');
8607: -- =========================== XML OUT =============================
8608:
8609:

Line 8606: fnd_file.put_line(fnd_file.output, ' ');

8602: -- =========================== XML OUT =============================
8603: -- =========================== XML OUT =============================
8604: fnd_file.put_line(fnd_file.output, ' ');
8605: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8606: fnd_file.put_line(fnd_file.output, ' ');
8607: -- =========================== XML OUT =============================
8608:
8609:
8610:

Line 8615: fnd_file.put_line(fnd_file.output, ' ');

8611: END LOOP; --End of l_je_sum_lines cursor
8612: CLOSE l_je_sum_lines;
8613: -- =========================== XML OUT =============================
8614: IF (l_xml_f_bud_sum_header <> TRUE) THEN
8615: fnd_file.put_line(fnd_file.output, ' ');
8616: l_xml_f_bud_sum_header := TRUE;
8617: END IF;
8618: -- =========================== XML OUT =============================
8619:

Line 8627: fnd_file.put_line(fnd_file.output, ' ');

8623: END LOOP; --End of l_je_bud_lines cursor
8624:
8625: -- =========================== XML OUT =============================
8626: IF (l_xml_f_bud_header <> TRUE) THEN
8627: fnd_file.put_line(fnd_file.output, ' ');
8628: l_xml_f_bud_header := TRUE;
8629: END IF;
8630: -- =========================== XML OUT =============================
8631:

Line 8635: fnd_file.put_line(fnd_file.output, ' ');

8631:
8632: CLOSE l_je_bud_lines;
8633:
8634: -- =========================== XML OUT =============================
8635: fnd_file.put_line(fnd_file.output, ' ');
8636: fnd_file.put_line(fnd_file.output, ' ');
8637: -- =========================== XML OUT =============================
8638:
8639:

Line 8636: fnd_file.put_line(fnd_file.output, ' ');

8632: CLOSE l_je_bud_lines;
8633:
8634: -- =========================== XML OUT =============================
8635: fnd_file.put_line(fnd_file.output, ' ');
8636: fnd_file.put_line(fnd_file.output, ' ');
8637: -- =========================== XML OUT =============================
8638:
8639:
8640: END LOOP;

Line 8645: fnd_file.put_line(fnd_file.output, ' ');

8641:
8642: CLOSE l_je_lines;
8643: -- =========================== XML OUT =============================
8644: IF (l_xml_je_lines_header <> TRUE) THEN
8645: fnd_file.put_line(fnd_file.output, ' ');
8646: END IF;
8647: fnd_file.put_line(fnd_file.output, ' ');
8648: -- =========================== XML OUT =============================
8649:

Line 8647: fnd_file.put_line(fnd_file.output, ' ');

8643: -- =========================== XML OUT =============================
8644: IF (l_xml_je_lines_header <> TRUE) THEN
8645: fnd_file.put_line(fnd_file.output, ' ');
8646: END IF;
8647: fnd_file.put_line(fnd_file.output, ' ');
8648: -- =========================== XML OUT =============================
8649:
8650: END LOOP; -- End of failed pkts loop
8651: -- =========================== XML OUT =============================

Line 8653: fnd_file.put_line(fnd_file.output, ' ');

8649:
8650: END LOOP; -- End of failed pkts loop
8651: -- =========================== XML OUT =============================
8652: IF (l_xml_f_b_header <> TRUE) THEN
8653: fnd_file.put_line(fnd_file.output, ' ');
8654: END IF;
8655: -- =========================== XML OUT =============================
8656:
8657: <>

Line 8659: fnd_file.put_line(fnd_file.output, '');

8655: -- =========================== XML OUT =============================
8656:
8657: <>
8658: -- =========================== XML OUT =============================
8659: fnd_file.put_line(fnd_file.output, '');
8660: -- =========================== XML OUT =============================
8661:
8662:
8663: IF sel1%ISOPEN THEN

Line 8859: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);

8855: BEGIN
8856: l_full_path := g_path||'Glsfbc';
8857:
8858: -- =========================== FND LOG ===========================
8859: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
8860: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
8861: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
8862: -- =========================== FND LOG =============================
8863:

Line 8860: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);

8856: l_full_path := g_path||'Glsfbc';
8857:
8858: -- =========================== FND LOG ===========================
8859: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
8860: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
8861: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
8862: -- =========================== FND LOG =============================
8863:
8864: INSERT INTO GL_BC_PACKETS

Line 8861: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');

8857:
8858: -- =========================== FND LOG ===========================
8859: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
8860: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
8861: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
8862: -- =========================== FND LOG =============================
8863:
8864: INSERT INTO GL_BC_PACKETS
8865: (packet_id,

Line 9010: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');

9006: -- ========================= FND LOG =============================
9007:
9008:
9009: -- =========================== FND LOG ===========================
9010: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9011: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Updating GL_BC_PACKETS ...');
9012: -- =========================== FND LOG =============================
9013:
9014: UPDATE gl_bc_packets bp2

Line 9011: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Updating GL_BC_PACKETS ...');

9007:
9008:
9009: -- =========================== FND LOG ===========================
9010: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9011: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Updating GL_BC_PACKETS ...');
9012: -- =========================== FND LOG =============================
9013:
9014: UPDATE gl_bc_packets bp2
9015: SET (entered_dr, entered_cr, accounted_dr, accounted_cr,

Line 9114: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Deleting from GL_BC_PACKETS ...');

9110: | The Delete statement will be executed here ALWAYS |
9111: +---------------------------------------------------*/
9112:
9113: -- =========================== FND LOG ===========================
9114: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Deleting from GL_BC_PACKETS ...');
9115: -- =========================== FND LOG =============================
9116:
9117:
9118: DELETE FROM gl_bc_packets bp

Line 9138: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');

9134: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete GL_BC_PACKETS -> ' || SQL%ROWCOUNT);
9135: -- ========================= FND LOG =============================
9136:
9137: -- =========================== FND LOG ===========================
9138: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9139: -- =========================== FND LOG =============================
9140:
9141: END glsfbc;
9142:

Line 9902: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');

9898: psa_utils.debug_other_string(g_error_level,l_full_path,
9899: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
9900: -- ====== FND LOG ======
9901:
9902: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
9903: fnd_file.put_line(fnd_file.log,'=============================================== ');
9904: for acc_error in ( select document_reference , encoded_message
9905: from psa_bc_accounting_errors b
9906: where event_id in (select event_id from xla_events_gt))

Line 9903: fnd_file.put_line(fnd_file.log,'=============================================== ');

9899: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
9900: -- ====== FND LOG ======
9901:
9902: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
9903: fnd_file.put_line(fnd_file.log,'=============================================== ');
9904: for acc_error in ( select document_reference , encoded_message
9905: from psa_bc_accounting_errors b
9906: where event_id in (select event_id from xla_events_gt))
9907: loop

Line 9908: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);

9904: for acc_error in ( select document_reference , encoded_message
9905: from psa_bc_accounting_errors b
9906: where event_id in (select event_id from xla_events_gt))
9907: loop
9908: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
9909: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);
9910: End loop;
9911:
9912: IF NOT(NVL(l_ae_event_cnt, 0) = l_event_cnt) THEN

Line 9909: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);

9905: from psa_bc_accounting_errors b
9906: where event_id in (select event_id from xla_events_gt))
9907: loop
9908: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
9909: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);
9910: End loop;
9911:
9912: IF NOT(NVL(l_ae_event_cnt, 0) = l_event_cnt) THEN
9913: -- ====== FND LOG ======

Line 9919: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');

9915: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> ERROR: FATAL ');
9916: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL p_return_code -> T');
9917: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL Return False ');
9918:
9919: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');
9920: fnd_file.put_line(fnd_file.log,'======================================= ');
9921: for missing_entity in
9922: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
9923: from xla_transaction_entities_upg e , xla_events_gt g

Line 9920: fnd_file.put_line(fnd_file.log,'======================================= ');

9916: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL p_return_code -> T');
9917: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL Return False ');
9918:
9919: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');
9920: fnd_file.put_line(fnd_file.log,'======================================= ');
9921: for missing_entity in
9922: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
9923: from xla_transaction_entities_upg e , xla_events_gt g
9924: where g.entity_id = e.entity_id

Line 9927: fnd_file.put_line(fnd_file.log , ' BC_Event_id ' || missing_entity.event_id || ' Transaction Number ' || missing_entity.transaction_number || ' Distribution id ' || missing_entity.source_id_int_2 );

9923: from xla_transaction_entities_upg e , xla_events_gt g
9924: where g.entity_id = e.entity_id
9925: and g.event_id not in (select event_id from xla_ae_lines_gt) )
9926: loop
9927: fnd_file.put_line(fnd_file.log , ' BC_Event_id ' || missing_entity.event_id || ' Transaction Number ' || missing_entity.transaction_number || ' Distribution id ' || missing_entity.source_id_int_2 );
9928: end loop;
9929:
9930:
9931: -- ====== FND LOG ======