APPS.PQH_COMMITMENT_POSTING dependencies on PQH_PROCESS_LOG

Line 271: p_message_text IN pqh_process_log.message_text%TYPE

267: -- end the process log as the batch itself has error
268: --
269: PROCEDURE populate_globals_error
270: (
271: p_message_text IN pqh_process_log.message_text%TYPE
272: ) IS
273: --
274: -- local variables
275: --

Line 283: UPDATE pqh_process_log

279: BEGIN
280: --
281: hr_utility.set_location('Entering: '||l_proc, 5);
282: --
283: UPDATE pqh_process_log
284: SET message_type_cd = 'ERROR',
285: message_text = p_message_text,
286: txn_table_route_id = g_table_route_id_bvr
287: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line 328: l_message_text pqh_process_log.message_text%TYPE;

324: l_transfer_to_gl_flag pqh_budgets.transfer_to_gl_flag%TYPE;
325: l_psb_budget_flag pqh_budgets.psb_budget_flag%TYPE;
326: l_default_currency_code gl_interface.currency_code%TYPE;
327: --
328: l_message_text pqh_process_log.message_text%TYPE;
329: l_message_text_out fnd_new_messages.message_text%TYPE;
330: l_error_flag varchar2(10) := 'N';
331: l_level number;
332: l_batch_id number;

Line 2018: l_message_text pqh_process_log.message_text%TYPE;

2014: l_accounting_date gl_period_statuses.start_date%TYPE;
2015: --
2016: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2017: --
2018: l_message_text pqh_process_log.message_text%TYPE;
2019: l_log_context pqh_process_log.log_context%TYPE;
2020: --
2021: l_proc varchar2(72) := 'update_period_commitment_tab';
2022: --

Line 2019: l_log_context pqh_process_log.log_context%TYPE;

2015: --
2016: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
2017: --
2018: l_message_text pqh_process_log.message_text%TYPE;
2019: l_log_context pqh_process_log.log_context%TYPE;
2020: --
2021: l_proc varchar2(72) := 'update_period_commitment_tab';
2022: --
2023: BEGIN

Line 2851: -- 1. Put the error message in pqh_process_log ( context : Period Name + CCID + currency code )

2847: hr_utility.set_location('GL Fund Checker return Code Desc : '||l_packet_status_code,111);
2848: --
2849: -- If the fund checker program failed i.e l_fc_success = FALSE or
2850: -- l_fc_return in ('T', 'F','R') then we would do the following :
2851: -- 1. Put the error message in pqh_process_log ( context : Period Name + CCID + currency code )
2852: -- 2.update gl_status of budget_detail records which have this Period Name+CCID+currency code to ERROR
2853: -- 3. Reverse unposted adjustment txns in pqh_gl_interface
2854: -- 4. Delete all unposted non-adjustment txns from pqh_gl_interface
2855: --

Line 3107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

3103: --
3104: PROCEDURE set_bdt_log_context
3105: (
3106: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
3107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
3108: ) IS
3109: --
3110: -- This procedure will set the log_context at Budget detail level
3111: -- We are processing only positions . So we need to set store the

Line 3116: l_log_context pqh_process_log.log_context%TYPE;

3112: -- position_name.
3113: --
3114: l_budget_details_rec pqh_budget_details%ROWTYPE;
3115: l_position_name hr_all_positions.name%TYPE;
3116: l_log_context pqh_process_log.log_context%TYPE;
3117: --
3118: CURSOR csr_bdt_detail_rec IS
3119: SELECT *
3120: FROM pqh_budget_details

Line 3635: l_log_context pqh_process_log.log_context%TYPE;

3631: --
3632: -- Declaring local variables
3633: --
3634: l_budget_details_rec pqh_budget_details%ROWTYPE;
3635: l_log_context pqh_process_log.log_context%TYPE;
3636: l_effective_dt date;
3637: --
3638: CURSOR csr_budget_detail_recs IS
3639: SELECT *

Line 4831: l_log_context pqh_process_log.log_context%TYPE;

4827: l_amount NUMBER;
4828: tran_setup_exception EXCEPTION;
4829: tran_source_exception EXCEPTION;
4830: l_pqh_interface_rec pqh_gl_interface%ROWTYPE;
4831: l_log_context pqh_process_log.log_context%TYPE;
4832: l_proc varchar2(72) := g_package||'.populate_gms_interface';
4833: l_log_message varchar2(8000);
4834: cnt BINARY_INTEGER := 1;
4835: ref_cnt BINARY_INTEGER := 1;