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 3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');

3551: -- =========================== FND LOG ===========================
3552: psa_utils.debug_other_string(g_state_level,l_full_path,
3553: ' PSA_MAX_LOCK_WAIT_COUNT reached, raising resource_busy exception');
3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;

Line 3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');

3552: psa_utils.debug_other_string(g_state_level,l_full_path,
3553: ' PSA_MAX_LOCK_WAIT_COUNT reached, raising resource_busy exception');
3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;
3560: END IF;

Line 3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');

3553: ' PSA_MAX_LOCK_WAIT_COUNT reached, raising resource_busy exception');
3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;
3560: END IF;
3561: END;

Line 3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');

3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;
3560: END IF;
3561: END;
3562: END LOOP;

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

8027: l_xml_f_bud_sum_header := true;
8028:
8029: --Start of xml report output
8030: -- =========================== XML OUT =============================
8031: fnd_file.put_line(fnd_file.output, '');
8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');

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

8028:
8029: --Start of xml report output
8030: -- =========================== XML OUT =============================
8031: fnd_file.put_line(fnd_file.output, '');
8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');

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

8029: --Start of xml report output
8030: -- =========================== XML OUT =============================
8031: fnd_file.put_line(fnd_file.output, '');
8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');

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

8030: -- =========================== XML OUT =============================
8031: fnd_file.put_line(fnd_file.output, '');
8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
8038: fnd_file.put_line(fnd_file.output, ' ');

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

8031: fnd_file.put_line(fnd_file.output, '');
8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
8038: fnd_file.put_line(fnd_file.output, ' ');
8039: -- =========================== XML OUT =============================

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

8032: fnd_file.put_line(fnd_file.output, '');
8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
8038: fnd_file.put_line(fnd_file.output, ' ');
8039: -- =========================== XML OUT =============================
8040:

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

8033: fnd_file.put_line(fnd_file.output, ' ');
8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
8038: fnd_file.put_line(fnd_file.output, ' ');
8039: -- =========================== XML OUT =============================
8040:
8041: BEGIN

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

8034: fnd_file.put_line(fnd_file.output, ' '||l_application_name||'');
8035: fnd_file.put_line(fnd_file.output, ' '||l_report_name||'');
8036: fnd_file.put_line(fnd_file.output, ' '||l_date||'');
8037: fnd_file.put_line(fnd_file.output, ' '||l_funds_action||'');
8038: fnd_file.put_line(fnd_file.output, ' ');
8039: -- =========================== XML OUT =============================
8040:
8041: BEGIN
8042: SELECT

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

8057: set_of_books_id = p_ledger_id;
8058: EXCEPTION
8059: WHEN OTHERS THEN
8060: -- =========================== FND LOG ===========================
8061: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8062: psa_utils.debug_other_string(g_excep_level,l_full_path,
8063: 'Funds C/R: Failed to fetch data from gl_sets_of_books');
8064: -- ========================= FND LOG =============================
8065: END;

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

8064: -- ========================= FND LOG =============================
8065: END;
8066:
8067: -- =========================== FND LOG ===========================
8068: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);

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

8065: END;
8066:
8067: -- =========================== FND LOG ===========================
8068: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
8073: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);

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

8066:
8067: -- =========================== FND LOG ===========================
8068: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
8073: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
8074: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);

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

8067: -- =========================== FND LOG ===========================
8068: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
8073: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
8074: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
8075: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);

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

8068: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_sob_name -> '||l_sob_name);
8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
8073: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
8074: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
8075: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8076: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);

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

8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8070: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8071: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_coa_id -> '||l_coa_id);
8072: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_currency_code -> '||l_currency_code);
8073: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_check_flag -> '||l_check_flag);
8074: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_sob_name -> '||l_sob_name);
8075: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag);
8076: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_automatic_tax_flag -> '||l_automatic_tax_flag);
8077: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_coa_id -> '||l_coa_id);

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

8084: l_bc_not_enabled_msg := FND_MESSAGE.GET();
8085: -- =========================== FND LOG ===========================
8086: psa_utils.debug_other_string(g_state_level, l_full_path,
8087: 'Funds C/R: l_budgetary_control_flag -> '||l_budgetary_control_flag); --Need to finalize the debug level
8088: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);
8089: -- ========================= FND LOG =============================
8090:
8091: -- =========================== XML OUT =============================
8092: fnd_file.put_line(fnd_file.output, ''||l_bc_not_enabled_msg||'');

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

8088: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_bc_not_enabled_msg);
8089: -- ========================= FND LOG =============================
8090:
8091: -- =========================== XML OUT =============================
8092: fnd_file.put_line(fnd_file.output, ''||l_bc_not_enabled_msg||'');
8093: -- =========================== XML OUT =============================
8094: GOTO normal_exit;
8095: END IF;
8096:

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

8107: WHEN OTHERS THEN
8108: -- =========================== FND LOG ===========================
8109: psa_utils.debug_other_string(g_excep_level,l_full_path,
8110: 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8111: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch autopost_set_name from gl_automatic_posting_sets');
8112: -- ========================= FND LOG =============================
8113: END;
8114:
8115: l_appl_id := 101;

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

8116: l_resp_id := FND_GLOBAL.resp_id;
8117: l_user_id := FND_GLOBAL.user_id;
8118:
8119: -- =========================== FND LOG ===========================
8120: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8121: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8122: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
8123: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
8124: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);

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

8117: l_user_id := FND_GLOBAL.user_id;
8118:
8119: -- =========================== FND LOG ===========================
8120: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8121: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8122: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
8123: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
8124: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
8125: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);

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

8118:
8119: -- =========================== FND LOG ===========================
8120: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8121: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8122: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
8123: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
8124: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
8125: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8126: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);

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

8119: -- =========================== FND LOG ===========================
8120: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8121: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8122: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
8123: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
8124: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
8125: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8126: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8127: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_appl_id -> '||l_appl_id);

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

8120: fnd_file.put_line(fnd_file.log, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8121: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8122: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_appl_id -> '||l_appl_id);
8123: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_resp_id -> '||l_resp_id);
8124: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_user_id -> '||l_user_id);
8125: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: p_autopost_set_id -> '||p_autopost_set_id);
8126: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_autopost_set_name -> '||l_autopost_set_name);
8127: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_appl_id -> '||l_appl_id);
8128: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_resp_id -> '||l_resp_id);

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

8173:
8174: l_packet_id := get_packet_id;
8175:
8176: -- =========================== FND LOG ===========================
8177: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);

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

8174: l_packet_id := get_packet_id;
8175:
8176: -- =========================== FND LOG ===========================
8177: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);

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

8175:
8176: -- =========================== FND LOG ===========================
8177: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
8183: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);

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

8176: -- =========================== FND LOG ===========================
8177: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
8183: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
8184: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');

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

8177: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
8183: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
8184: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
8185: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);

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

8178: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_period_name -> '||l_period_name);
8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
8183: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
8184: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
8185: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);
8186: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_actual_flag -> '||l_actual_flag);

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

8179: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8180: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);
8181: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_packet_id -> '||l_packet_id);
8182: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_batch_name -> '||l_batch_name);
8183: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_source_name -> '||l_source_name);
8184: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: -------------------------------');
8185: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_period_name -> '||l_period_name);
8186: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_actual_flag -> '||l_actual_flag);
8187: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_je_batch_id -> '||l_je_batch_id);

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

8191: -- =========================== FND LOG =============================
8192:
8193: -- =========================== XML OUT =============================
8194: IF (l_xml_b_header <> FALSE) THEN
8195: fnd_file.put_line(fnd_file.output, ' ');
8196: l_xml_b_header := FALSE;
8197: END IF;
8198: -- =========================== XML OUT =============================
8199:

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

8214:
8215: l_main_stmt := '';
8216:
8217: -- =========================== FND LOG ===========================
8218: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8219: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8220: -- =========================== FND LOG =============================
8221:
8222: l_tmp_stmt := 'SELECT '||

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

8251: l_session_id||', '||l_serial_id||', '||l_appl_id||', '||
8252: 'NULL, NULL';
8253:
8254: -- =========================== FND LOG ===========================
8255: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8256: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8257: -- =========================== FND LOG =============================
8258:
8259: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';

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

8275:
8276: l_tmp_stmt := l_tmp_stmt || l_action_stmt;
8277:
8278: -- =========================== FND LOG ===========================
8279: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8280: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8281: -- =========================== FND LOG =============================
8282:
8283: l_main_stmt := l_main_stmt || l_tmp_stmt;

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

8282:
8283: l_main_stmt := l_main_stmt || l_tmp_stmt;
8284:
8285: -- =========================== FND LOG ===========================
8286: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8287: fnd_file.put_line(fnd_file.log, 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8288: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8289: psa_utils.debug_other_string(g_state_level, l_full_path,
8290: 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');

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

8283: l_main_stmt := l_main_stmt || l_tmp_stmt;
8284:
8285: -- =========================== FND LOG ===========================
8286: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8287: fnd_file.put_line(fnd_file.log, 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8288: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_main_stmt -> '||l_main_stmt);
8289: psa_utils.debug_other_string(g_state_level, l_full_path,
8290: 'Funds C/R: Executing l_main_stmt -> '||l_main_stmt||' using EXECUTE IMMEDIATE');
8291: -- =========================== FND LOG =============================

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

8312:
8313: -- Invoke funds checker per packet_id
8314:
8315: -- ====== FND LOG ======
8316: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() per packet.');
8317: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: BCTRL -> Invoking glxfck() per packet.');
8318: -- ====== FND LOG ======
8319:
8320: FOR x in 1..l_bc_pkts.count

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

8321: LOOP
8322: IF (x = 1 OR (l_bc_pkts(x).packet_id <> l_bc_pkts(x-1).packet_id)) THEN
8323:
8324: -- ====== FND LOG ======
8325: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> Invoking glxfck() for packet_id '||l_bc_pkts(x).packet_id);
8326: psa_utils.debug_other_string(g_state_level,l_full_path,
8327: 'Funds C/R: BCTRL -> Invoking glxfck() for packet_id '||l_bc_pkts(x).packet_id);
8328: -- ====== FND LOG ======
8329:

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

8336: p_user_resp_id => l_resp_id,
8337: p_calling_prog_flag => 'G',
8338: p_return_code => l_glxfck_return_code) THEN
8339: -- ====== FND LOG ======
8340: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL -> glxfck() failed ');
8341: psa_utils.debug_other_string(g_error_level,l_full_path, 'Funds C/R: BCTRL -> glxfck() failed ');
8342: -- ====== FND LOG ======
8343:
8344: -- ============================== FND LOG =========================

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

8341: psa_utils.debug_other_string(g_error_level,l_full_path, 'Funds C/R: BCTRL -> glxfck() failed ');
8342: -- ====== FND LOG ======
8343:
8344: -- ============================== FND LOG =========================
8345: fnd_file.put_line(fnd_file.log, 'Funds C/R: BCTRL l_glxfck_return_code -> T ');
8346: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: BCTRL l_glxfck_return_code -> T ');
8347: -- ============================== FND LOG =========================
8348:
8349: l_glxfck_return_code := 'T';

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

8355: -- Fatal, we insert into failed packets table type.
8356: IF (l_glxfck_return_code <> 'S') THEN
8357:
8358: -- ============================== FND LOG =========================
8359: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8360: 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);
8361: psa_utils.debug_other_string(g_state_level,l_full_path,
8362: 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8363: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 8360: 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);

8356: IF (l_glxfck_return_code <> 'S') THEN
8357:
8358: -- ============================== FND LOG =========================
8359: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8360: 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);
8361: psa_utils.debug_other_string(g_state_level,l_full_path,
8362: 'Funds C/R: l_glxfck_return_code ->'||l_glxfck_return_code);
8363: psa_utils.debug_other_string(g_state_level,l_full_path,
8364: 'Funds C/R: Inserting into l_failed_bc_pkts for packet_id->'||l_bc_pkts(x).packet_id);

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

8370:
8371: END IF;
8372:
8373: -- =========================== FND LOG ===========================
8374: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8375: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8376: -- =========================== FND LOG =============================
8377: BEGIN
8378: UPDATE

Line 8404: fnd_file.put_line(fnd_file.log,

8400: WHEN OTHERS THEN
8401: -- =========================== FND LOG ===========================
8402: psa_utils.debug_other_string(g_excep_level,l_full_path,
8403: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8404: fnd_file.put_line(fnd_file.log,
8405: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8406: -- ========================= FND LOG =============================
8407: END;
8408:

Line 8424: fnd_file.put_line(fnd_file.log,

8420: WHEN OTHERS THEN
8421: -- =========================== FND LOG ===========================
8422: psa_utils.debug_other_string(g_excep_level,l_full_path,
8423: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8424: fnd_file.put_line(fnd_file.log,
8425: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8426: -- ========================= FND LOG =============================
8427: END;
8428:

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

8426: -- ========================= FND LOG =============================
8427: END;
8428:
8429: -- =========================== FND LOG ===========================
8430: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code F Meaning l_fmeaning -> '||l_fmeaning);
8431: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code F Meaning l_fmeaning -> '||l_fmeaning);
8432: -- =========================== FND LOG =============================
8433:
8434: BEGIN

Line 8451: fnd_file.put_line(fnd_file.log,

8447: WHEN OTHERS THEN
8448: -- =========================== FND LOG ===========================
8449: psa_utils.debug_other_string(g_excep_level,l_full_path,
8450: 'Funds C/R: Failed to fetch meaning from gl_je_batches');
8451: fnd_file.put_line(fnd_file.log,
8452: 'Funds C/R: Failed to fetch meaning from gl_be_batches');
8453: -- ========================= FND LOG =============================
8454: END;
8455:

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

8453: -- ========================= FND LOG =============================
8454: END;
8455:
8456: -- =========================== FND LOG ===========================
8457: fnd_file.put_line(fnd_file.log, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8458: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8459: -- =========================== FND LOG =============================
8460:
8461: -- =========================== XML OUT =============================

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

8458: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: Return Code J Meaning l_jmeaning -> '||l_jmeaning);
8459: -- =========================== FND LOG =============================
8460:
8461: -- =========================== XML OUT =============================
8462: fnd_file.put_line(fnd_file.output, ' ');
8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');

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

8459: -- =========================== FND LOG =============================
8460:
8461: -- =========================== XML OUT =============================
8462: fnd_file.put_line(fnd_file.output, ' ');
8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8467: fnd_file.put_line(fnd_file.output, ' ');

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

8460:
8461: -- =========================== XML OUT =============================
8462: fnd_file.put_line(fnd_file.output, ' ');
8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8467: fnd_file.put_line(fnd_file.output, ' ');
8468: -- =========================== XML OUT =============================

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

8461: -- =========================== XML OUT =============================
8462: fnd_file.put_line(fnd_file.output, ' ');
8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8467: fnd_file.put_line(fnd_file.output, ' ');
8468: -- =========================== XML OUT =============================
8469:

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

8462: fnd_file.put_line(fnd_file.output, ' ');
8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8467: fnd_file.put_line(fnd_file.output, ' ');
8468: -- =========================== XML OUT =============================
8469:
8470: END IF;

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

8463: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).je_batch_name||'');
8464: fnd_file.put_line(fnd_file.output, ' '||l_bc_pkts(x).period_name||'');
8465: fnd_file.put_line(fnd_file.output, ' '||l_fmeaning||'');
8466: fnd_file.put_line(fnd_file.output, ' '||l_jmeaning||'');
8467: fnd_file.put_line(fnd_file.output, ' ');
8468: -- =========================== XML OUT =============================
8469:
8470: END IF;
8471:

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

8472: END LOOP; --End of loop for all l_bc_pkts
8473:
8474: -- =========================== XML OUT =============================
8475: IF (l_xml_b_header <> TRUE) THEN
8476: fnd_file.put_line(fnd_file.output, ' ');
8477: END IF;
8478: -- =========================== XML OUT =============================
8479:
8480: -- =========================== FND LOG ===========================

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

8477: END IF;
8478: -- =========================== XML OUT =============================
8479:
8480: -- =========================== FND LOG ===========================
8481: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8482: -- =========================== FND LOG ===========================
8483:
8484: --Now processing failed batches/packets.
8485: FOR x in 1..l_failed_bc_pkts.count

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

8483:
8484: --Now processing failed batches/packets.
8485: FOR x in 1..l_failed_bc_pkts.count
8486: LOOP
8487: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8488: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8489: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8490: l_failed_bc_pkts(x).packet_id||
8491: ' Batch Id: '||

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

8484: --Now processing failed batches/packets.
8485: FOR x in 1..l_failed_bc_pkts.count
8486: LOOP
8487: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8488: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8489: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8490: l_failed_bc_pkts(x).packet_id||
8491: ' Batch Id: '||
8492: l_failed_bc_pkts(x).je_batch_id||

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

8485: FOR x in 1..l_failed_bc_pkts.count
8486: LOOP
8487: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed Funds Check Packets Info');
8488: fnd_file.put_line(fnd_file.log, 'Funds C/R: -------------------------------');
8489: fnd_file.put_line(fnd_file.log, 'Funds C/R: Packet Id: '||
8490: l_failed_bc_pkts(x).packet_id||
8491: ' Batch Id: '||
8492: l_failed_bc_pkts(x).je_batch_id||
8493: ' Batch Name: '||l_failed_bc_pkts(x).je_batch_name);

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

8494:
8495:
8496: -- =========================== XML OUT =============================
8497: IF (l_xml_f_b_header <> FALSE) THEN
8498: fnd_file.put_line(fnd_file.output, ' YES');
8499: fnd_file.put_line(fnd_file.output, ' ');
8500: l_xml_f_b_header := FALSE;
8501: END IF;
8502: -- =========================== XML OUT =============================

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

8495:
8496: -- =========================== XML OUT =============================
8497: IF (l_xml_f_b_header <> FALSE) THEN
8498: fnd_file.put_line(fnd_file.output, ' YES');
8499: fnd_file.put_line(fnd_file.output, ' ');
8500: l_xml_f_b_header := FALSE;
8501: END IF;
8502: -- =========================== XML OUT =============================
8503:

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

8501: END IF;
8502: -- =========================== XML OUT =============================
8503:
8504: -- =========================== XML OUT =============================
8505: fnd_file.put_line(fnd_file.output, ' ');
8506: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8507: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8508: -- =========================== XML OUT =============================
8509:

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

8502: -- =========================== XML OUT =============================
8503:
8504: -- =========================== XML OUT =============================
8505: fnd_file.put_line(fnd_file.output, ' ');
8506: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8507: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8508: -- =========================== XML OUT =============================
8509:
8510:

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

8503:
8504: -- =========================== XML OUT =============================
8505: fnd_file.put_line(fnd_file.output, ' ');
8506: fnd_file.put_line(fnd_file.output, ' '||l_failure_warning||'');
8507: fnd_file.put_line(fnd_file.output, ' '||l_failed_bc_pkts(x).je_batch_name||'');
8508: -- =========================== XML OUT =============================
8509:
8510:
8511: l_je_stmt := 'SELECT ';

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

8539: ' and p.ussgl_link_to_parent_id is null'||
8540: ' and (p.result_code like ''F%'' or p.result_code like ''P2%'') '||
8541: ' order by l.je_header_id, l.je_line_num';
8542:
8543: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_stmt -> '|| l_je_stmt);
8544:
8545: l_xml_je_lines_header := TRUE;
8546:
8547: OPEN l_je_lines FOR l_je_stmt;

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

8550: FETCH l_je_lines INTO l_seg_ccid, l_je_header_name, l_je_header_id, l_je_line_num, l_entered_dr,
8551: l_entered_cr, l_line_description, l_line_result_code, l_ccid, l_rowid;
8552:
8553: -- =========================== FND LOG ===========================
8554: fnd_file.put_line(fnd_file.log, 'Funds C/R: '|| l_seg_ccid||' '||l_je_header_name||' '||l_je_header_id
8555: ||' '||l_je_line_num||' '||l_entered_dr||' '||l_entered_cr||
8556: ' '||l_line_description||' '||l_line_result_code||' '||l_ccid||
8557: ' '||l_rowid);
8558: -- =========================== FND LOG ===========================

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

8572: EXCEPTION
8573: WHEN OTHERS THEN
8574: -- =========================== FND LOG ===========================
8575: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8576: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8577: -- ========================= FND LOG =============================
8578: END;
8579:
8580:

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

8578: END;
8579:
8580:
8581: -- =========================== FND LOG ===========================
8582: fnd_file.put_line(fnd_file.log, 'Funds C/R: '||l_failed_bc_pkts(x).je_batch_name||
8583: l_je_header_name||' '||l_seg_ccid||' '||
8584: l_entered_dr||' '||l_entered_cr||
8585: ' '||l_priority);
8586: -- =========================== FND LOG ===========================

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

8586: -- =========================== FND LOG ===========================
8587:
8588: -- =========================== XML OUT =============================
8589: IF (l_xml_je_lines_header <> FALSE) THEN
8590: fnd_file.put_line(fnd_file.output, ' '||l_je_header_name||'');
8591: fnd_file.put_line(fnd_file.output, ' ');
8592: l_xml_je_lines_header := FALSE;
8593: END IF;
8594: -- =========================== XML OUT =============================

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

8587:
8588: -- =========================== XML OUT =============================
8589: IF (l_xml_je_lines_header <> FALSE) THEN
8590: fnd_file.put_line(fnd_file.output, ' '||l_je_header_name||'');
8591: fnd_file.put_line(fnd_file.output, ' ');
8592: l_xml_je_lines_header := FALSE;
8593: END IF;
8594: -- =========================== XML OUT =============================
8595:

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

8593: END IF;
8594: -- =========================== XML OUT =============================
8595:
8596: -- =========================== XML OUT =============================
8597: fnd_file.put_line(fnd_file.output, ' ');
8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');

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

8594: -- =========================== XML OUT =============================
8595:
8596: -- =========================== XML OUT =============================
8597: fnd_file.put_line(fnd_file.output, ' ');
8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');

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

8595:
8596: -- =========================== XML OUT =============================
8597: fnd_file.put_line(fnd_file.output, ' ');
8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');

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

8596: -- =========================== XML OUT =============================
8597: fnd_file.put_line(fnd_file.output, ' ');
8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');
8604: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');

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

8597: fnd_file.put_line(fnd_file.output, ' ');
8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');
8604: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8605: -- =========================== XML OUT =============================

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

8598: fnd_file.put_line(fnd_file.output, ' '||l_je_line_num||'');
8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');
8604: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8605: -- =========================== XML OUT =============================
8606:

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

8599: fnd_file.put_line(fnd_file.output, ' '||l_seg_ccid||'');
8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');
8604: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8605: -- =========================== XML OUT =============================
8606:
8607:

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

8600: fnd_file.put_line(fnd_file.output, ' '||l_entered_dr||'');
8601: fnd_file.put_line(fnd_file.output, ' '||l_entered_cr||'');
8602: fnd_file.put_line(fnd_file.output, ' '||l_priority||'');
8603: fnd_file.put_line(fnd_file.output, ' ');
8604: fnd_file.put_line(fnd_file.output, ' '||l_line_description||'');
8605: -- =========================== XML OUT =============================
8606:
8607:
8608: l_xml_f_sum_header := true;

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

8633: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8634: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8635: ' and c.code_combination_id = p.code_combination_id';
8636:
8637: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_seg_stmt -> '||l_je_seg_stmt);
8638:
8639: OPEN l_je_sum_lines for l_je_seg_stmt;
8640: LOOP
8641: FETCH l_je_sum_lines into l_je_sum_flex;

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

8642: EXIT WHEN l_je_sum_lines%NOTFOUND;
8643:
8644: -- =========================== XML OUT =============================
8645: IF (l_xml_f_sum_header <> FALSE) THEN
8646: fnd_file.put_line(fnd_file.output, ' ');
8647: fnd_file.put_line(fnd_file.output, ' YES');
8648: l_xml_f_sum_header := FALSE;
8649: END IF;
8650: -- =========================== XML OUT =============================

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

8643:
8644: -- =========================== XML OUT =============================
8645: IF (l_xml_f_sum_header <> FALSE) THEN
8646: fnd_file.put_line(fnd_file.output, ' ');
8647: fnd_file.put_line(fnd_file.output, ' YES');
8648: l_xml_f_sum_header := FALSE;
8649: END IF;
8650: -- =========================== XML OUT =============================
8651:

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

8648: l_xml_f_sum_header := FALSE;
8649: END IF;
8650: -- =========================== XML OUT =============================
8651:
8652: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8653:
8654: -- =========================== XML OUT =============================
8655: fnd_file.put_line(fnd_file.output, ' ');
8656: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');

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

8651:
8652: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8653:
8654: -- =========================== XML OUT =============================
8655: fnd_file.put_line(fnd_file.output, ' ');
8656: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8657: fnd_file.put_line(fnd_file.output, ' ');
8658: -- =========================== XML OUT =============================
8659:

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

8652: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_sum_flex -> '||l_je_sum_flex);
8653:
8654: -- =========================== XML OUT =============================
8655: fnd_file.put_line(fnd_file.output, ' ');
8656: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8657: fnd_file.put_line(fnd_file.output, ' ');
8658: -- =========================== XML OUT =============================
8659:
8660: END LOOP; --End of l_je_sum_lines cursor

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

8653:
8654: -- =========================== XML OUT =============================
8655: fnd_file.put_line(fnd_file.output, ' ');
8656: fnd_file.put_line(fnd_file.output, ' '||l_je_sum_flex||'');
8657: fnd_file.put_line(fnd_file.output, ' ');
8658: -- =========================== XML OUT =============================
8659:
8660: END LOOP; --End of l_je_sum_lines cursor
8661:

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

8661:
8662: CLOSE l_je_sum_lines;
8663: -- =========================== XML OUT =============================
8664: IF (l_xml_f_sum_header <> TRUE) THEN
8665: fnd_file.put_line(fnd_file.output, ' ');
8666: l_xml_f_sum_header := TRUE;
8667: END IF;
8668: -- =========================== XML OUT =============================
8669:

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

8697: EXCEPTION
8698: WHEN OTHERS THEN
8699: -- =========================== FND LOG ===========================
8700: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch ussgl_parent_id from gl_bc_packets');
8701: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch ussgl_parent_id from gl_bc_packets');
8702: -- ========================= FND LOG =============================
8703: END;
8704:
8705: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||

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

8710: ' and p.result_code between ''F00'' AND ''F30'' and '||
8711: ' p.result_code = l.lookup_code and l.lookup_type = ''FUNDS_CHECK_RESULT_CODE'' '||
8712: ' order by p.code_combination_id';
8713:
8714: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_stmt -> '||l_je_bud_stmt);
8715:
8716: OPEN l_je_bud_lines for l_je_bud_stmt;
8717: LOOP
8718: FETCH l_je_bud_lines into l_je_bud_flex, l_je_bud_dr, l_je_bud_cr, l_je_bud_result_code,

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

8718: FETCH l_je_bud_lines into l_je_bud_flex, l_je_bud_dr, l_je_bud_cr, l_je_bud_result_code,
8719: l_je_bud_desc, l_je_bud_ccid;
8720:
8721: EXIT WHEN l_je_bud_lines%NOTFOUND;
8722: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_flex -> '||l_je_bud_flex
8723: ||'l_je_bud_dr ->' ||l_je_bud_dr
8724: ||'l_je_bud_cr ->' ||l_je_bud_cr
8725: ||'l_je_bud_result_code ->' ||l_je_bud_result_code
8726: ||'l_je_bud_desc ->' ||l_je_bud_desc

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

8728: );
8729:
8730: -- =========================== XML OUT =============================
8731: IF (l_xml_f_bud_header <> FALSE) THEN
8732: fnd_file.put_line(fnd_file.output, ' ');
8733: fnd_file.put_line(fnd_file.output, ' YES');
8734: l_xml_f_bud_header := FALSE;
8735: END IF;
8736: -- =========================== XML OUT =============================

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

8729:
8730: -- =========================== XML OUT =============================
8731: IF (l_xml_f_bud_header <> FALSE) THEN
8732: fnd_file.put_line(fnd_file.output, ' ');
8733: fnd_file.put_line(fnd_file.output, ' YES');
8734: l_xml_f_bud_header := FALSE;
8735: END IF;
8736: -- =========================== XML OUT =============================
8737:

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

8735: END IF;
8736: -- =========================== XML OUT =============================
8737:
8738: -- =========================== XML OUT =============================
8739: fnd_file.put_line(fnd_file.output, ' ');
8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');

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

8736: -- =========================== XML OUT =============================
8737:
8738: -- =========================== XML OUT =============================
8739: fnd_file.put_line(fnd_file.output, ' ');
8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8744: fnd_file.put_line(fnd_file.output, ' ');

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

8737:
8738: -- =========================== XML OUT =============================
8739: fnd_file.put_line(fnd_file.output, ' ');
8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8744: fnd_file.put_line(fnd_file.output, ' ');
8745: -- =========================== XML OUT =============================

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

8738: -- =========================== XML OUT =============================
8739: fnd_file.put_line(fnd_file.output, ' ');
8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8744: fnd_file.put_line(fnd_file.output, ' ');
8745: -- =========================== XML OUT =============================
8746:

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

8739: fnd_file.put_line(fnd_file.output, ' ');
8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8744: fnd_file.put_line(fnd_file.output, ' ');
8745: -- =========================== XML OUT =============================
8746:
8747: l_xml_f_bud_sum_header := true;

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

8740: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_flex||'');
8741: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_dr||'');
8742: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_cr||'');
8743: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_desc||'');
8744: fnd_file.put_line(fnd_file.output, ' ');
8745: -- =========================== XML OUT =============================
8746:
8747: l_xml_f_bud_sum_header := true;
8748:

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

8770: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8771: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8772: ' and c.code_combination_id = p.code_combination_id';
8773:
8774: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_seg_stmt -> '||l_je_bud_seg_stmt);
8775:
8776: OPEN l_je_sum_lines for l_je_bud_seg_stmt;
8777: LOOP
8778: FETCH l_je_sum_lines into l_je_bud_sum_flex;

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

8776: OPEN l_je_sum_lines for l_je_bud_seg_stmt;
8777: LOOP
8778: FETCH l_je_sum_lines into l_je_bud_sum_flex;
8779: EXIT WHEN l_je_sum_lines%NOTFOUND;
8780: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_sum_flex -> '||l_je_bud_sum_flex);
8781:
8782: -- =========================== XML OUT =============================
8783: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8784: fnd_file.put_line(fnd_file.output, ' ');

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

8780: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_je_bud_sum_flex -> '||l_je_bud_sum_flex);
8781:
8782: -- =========================== XML OUT =============================
8783: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8784: fnd_file.put_line(fnd_file.output, ' ');
8785: fnd_file.put_line(fnd_file.output, ' YES');
8786: l_xml_f_bud_sum_header := FALSE;
8787: END IF;
8788: -- =========================== XML OUT =============================

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

8781:
8782: -- =========================== XML OUT =============================
8783: IF (l_xml_f_bud_sum_header <> FALSE) THEN
8784: fnd_file.put_line(fnd_file.output, ' ');
8785: fnd_file.put_line(fnd_file.output, ' YES');
8786: l_xml_f_bud_sum_header := FALSE;
8787: END IF;
8788: -- =========================== XML OUT =============================
8789: -- =========================== XML OUT =============================

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

8786: l_xml_f_bud_sum_header := FALSE;
8787: END IF;
8788: -- =========================== XML OUT =============================
8789: -- =========================== XML OUT =============================
8790: fnd_file.put_line(fnd_file.output, ' ');
8791: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8792: fnd_file.put_line(fnd_file.output, ' ');
8793: -- =========================== XML OUT =============================
8794:

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

8787: END IF;
8788: -- =========================== XML OUT =============================
8789: -- =========================== XML OUT =============================
8790: fnd_file.put_line(fnd_file.output, ' ');
8791: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8792: fnd_file.put_line(fnd_file.output, ' ');
8793: -- =========================== XML OUT =============================
8794:
8795:

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

8788: -- =========================== XML OUT =============================
8789: -- =========================== XML OUT =============================
8790: fnd_file.put_line(fnd_file.output, ' ');
8791: fnd_file.put_line(fnd_file.output, ' '||l_je_bud_sum_flex||'');
8792: fnd_file.put_line(fnd_file.output, ' ');
8793: -- =========================== XML OUT =============================
8794:
8795:
8796:

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

8797: END LOOP; --End of l_je_sum_lines cursor
8798: CLOSE l_je_sum_lines;
8799: -- =========================== XML OUT =============================
8800: IF (l_xml_f_bud_sum_header <> TRUE) THEN
8801: fnd_file.put_line(fnd_file.output, ' ');
8802: l_xml_f_bud_sum_header := TRUE;
8803: END IF;
8804: -- =========================== XML OUT =============================
8805:

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

8809: END LOOP; --End of l_je_bud_lines cursor
8810:
8811: -- =========================== XML OUT =============================
8812: IF (l_xml_f_bud_header <> TRUE) THEN
8813: fnd_file.put_line(fnd_file.output, ' ');
8814: l_xml_f_bud_header := TRUE;
8815: END IF;
8816: -- =========================== XML OUT =============================
8817:

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

8817:
8818: CLOSE l_je_bud_lines;
8819:
8820: -- =========================== XML OUT =============================
8821: fnd_file.put_line(fnd_file.output, ' ');
8822: fnd_file.put_line(fnd_file.output, ' ');
8823: -- =========================== XML OUT =============================
8824:
8825:

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

8818: CLOSE l_je_bud_lines;
8819:
8820: -- =========================== XML OUT =============================
8821: fnd_file.put_line(fnd_file.output, ' ');
8822: fnd_file.put_line(fnd_file.output, ' ');
8823: -- =========================== XML OUT =============================
8824:
8825:
8826: END LOOP;

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

8827:
8828: CLOSE l_je_lines;
8829: -- =========================== XML OUT =============================
8830: IF (l_xml_je_lines_header <> TRUE) THEN
8831: fnd_file.put_line(fnd_file.output, ' ');
8832: END IF;
8833: fnd_file.put_line(fnd_file.output, ' ');
8834: -- =========================== XML OUT =============================
8835:

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

8829: -- =========================== XML OUT =============================
8830: IF (l_xml_je_lines_header <> TRUE) THEN
8831: fnd_file.put_line(fnd_file.output, ' ');
8832: END IF;
8833: fnd_file.put_line(fnd_file.output, ' ');
8834: -- =========================== XML OUT =============================
8835:
8836: END LOOP; -- End of failed pkts loop
8837: -- =========================== XML OUT =============================

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

8835:
8836: END LOOP; -- End of failed pkts loop
8837: -- =========================== XML OUT =============================
8838: IF (l_xml_f_b_header <> TRUE) THEN
8839: fnd_file.put_line(fnd_file.output, ' ');
8840: END IF;
8841: -- =========================== XML OUT =============================
8842:
8843: <>

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

8841: -- =========================== XML OUT =============================
8842:
8843: <>
8844: -- =========================== XML OUT =============================
8845: fnd_file.put_line(fnd_file.output, '');
8846: -- =========================== XML OUT =============================
8847:
8848:
8849: IF sel1%ISOPEN THEN

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

9041: BEGIN
9042: l_full_path := g_path||'Glsfbc';
9043:
9044: -- =========================== FND LOG ===========================
9045: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
9046: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
9047: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
9048: -- =========================== FND LOG =============================
9049:

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

9042: l_full_path := g_path||'Glsfbc';
9043:
9044: -- =========================== FND LOG ===========================
9045: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
9046: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
9047: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
9048: -- =========================== FND LOG =============================
9049:
9050: INSERT INTO GL_BC_PACKETS

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

9043:
9044: -- =========================== FND LOG ===========================
9045: fnd_file.put_line(fnd_file.log, 'p_curr_temp_id = '||p_curr_temp_id);
9046: fnd_file.put_line(fnd_file.log, 'p_ledger_id = '||p_ledger_id);
9047: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Inserting into GL_BC_PACKETS ...');
9048: -- =========================== FND LOG =============================
9049:
9050: INSERT INTO GL_BC_PACKETS
9051: (packet_id,

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

9192: -- ========================= FND LOG =============================
9193:
9194:
9195: -- =========================== FND LOG ===========================
9196: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9197: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Updating GL_BC_PACKETS ...');
9198: -- =========================== FND LOG =============================
9199:
9200: UPDATE gl_bc_packets bp2

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

9193:
9194:
9195: -- =========================== FND LOG ===========================
9196: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9197: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Updating GL_BC_PACKETS ...');
9198: -- =========================== FND LOG =============================
9199:
9200: UPDATE gl_bc_packets bp2
9201: SET (entered_dr, entered_cr, accounted_dr, accounted_cr,

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

9296: | The Delete statement will be executed here ALWAYS |
9297: +---------------------------------------------------*/
9298:
9299: -- =========================== FND LOG ===========================
9300: fnd_file.put_line(fnd_file.log, 'SHRD0114 ' || '1 ' || 'stmt ' || 'Deleting from GL_BC_PACKETS ...');
9301: -- =========================== FND LOG =============================
9302:
9303:
9304: DELETE FROM gl_bc_packets bp

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

9320: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete GL_BC_PACKETS -> ' || SQL%ROWCOUNT);
9321: -- ========================= FND LOG =============================
9322:
9323: -- =========================== FND LOG ===========================
9324: fnd_file.put_line(fnd_file.log, 'GL_BC_PACKETS');
9325: -- =========================== FND LOG =============================
9326:
9327: END glsfbc;
9328:

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

10184: psa_utils.debug_other_string(g_error_level,l_full_path,
10185: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
10186: -- ====== FND LOG ======
10187:
10188: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
10189: fnd_file.put_line(fnd_file.log,'=============================================== ');
10190: for acc_error in ( select document_reference , encoded_message
10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))

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

10185: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
10186: -- ====== FND LOG ======
10187:
10188: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
10189: fnd_file.put_line(fnd_file.log,'=============================================== ');
10190: for acc_error in ( select document_reference , encoded_message
10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))
10193: loop

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

10190: for acc_error in ( select document_reference , encoded_message
10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))
10193: loop
10194: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
10195: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);
10196: End loop;
10197:
10198: IF NOT(NVL(l_ae_event_cnt, 0) = l_event_cnt) THEN

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

10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))
10193: loop
10194: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
10195: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);
10196: End loop;
10197:
10198: IF NOT(NVL(l_ae_event_cnt, 0) = l_event_cnt) THEN
10199: -- ====== FND LOG ======

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

10203: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL Return False ');
10204:
10205: check_for_xla_errors ('EVENTS_NOT_PROCESSED', l_xla_return_code);
10206:
10207: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');
10208: fnd_file.put_line(fnd_file.log,'======================================= ');
10209: for missing_entity in
10210: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
10211: from xla_transaction_entities_upg e , xla_events_gt g

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

10204:
10205: check_for_xla_errors ('EVENTS_NOT_PROCESSED', l_xla_return_code);
10206:
10207: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');
10208: fnd_file.put_line(fnd_file.log,'======================================= ');
10209: for missing_entity in
10210: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
10211: from xla_transaction_entities_upg e , xla_events_gt g
10212: where g.entity_id = e.entity_id

Line 10215: 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 );

10211: from xla_transaction_entities_upg e , xla_events_gt g
10212: where g.entity_id = e.entity_id
10213: and g.event_id not in (select event_id from xla_ae_lines_gt) )
10214: loop
10215: 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 );
10216: end loop;
10217:
10218:
10219: -- ====== FND LOG ======