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.PQH_GL_POSTING dependencies on PQH_PROCESS_LOG

Line 47: ( p_message_text IN pqh_process_log.message_text%TYPE) ;

43: --
44: -- Private procedures
45: --
46: PROCEDURE populate_globals_error
47: ( p_message_text IN pqh_process_log.message_text%TYPE) ;
48:
49: --
50: PROCEDURE reverse_commitment_post(p_last_posted_ver IN NUMBER,
51: p_curr_bdgt_version IN NUMBER);

Line 175: l_log_context pqh_process_log.log_context%TYPE;

171: -- local variables
172: --
173: l_proc varchar2(72) := g_package||'.post_budget';
174: l_budget_details_rec pqh_budget_details%ROWTYPE;
175: l_log_context pqh_process_log.log_context%TYPE;
176: l_budget_detail_result varchar2(1);
177: l_message_text fnd_new_messages.message_text%TYPE;
178: l_dummy varchar2(10);
179:

Line 376: l_message_text pqh_process_log.message_text%TYPE;

372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
375: l_transfer_to_gl_flag varchar2(10);
376: l_message_text pqh_process_log.message_text%TYPE;
377: l_message_text_out fnd_new_messages.message_text%TYPE;
378: l_error_flag varchar2(10) := 'N';
379: l_level number;
380: l_batch_id number;

Line 870: UPDATE pqh_process_log

866: -- we would rollback any inserts before we update
867: -- this is done to undo apply_budget if called from apply_transaction
868: rollback;
869:
870: UPDATE pqh_process_log
871: SET message_type_cd = 'ERROR',
872: message_text = l_message_text,
873: txn_table_route_id = g_table_route_id_bvr
874: -- batch_status = 'ERROR',

Line 1076: l_message_text pqh_process_log.message_text%TYPE;

1072: l_period_name gl_period_statuses.period_name%TYPE;
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;
1078: l_count NUMBER;
1079: l_error_flag varchar2(10) := 'N';
1080: l_log_context pqh_process_log.log_context%TYPE;

Line 1080: l_log_context pqh_process_log.log_context%TYPE;

1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;
1078: l_count NUMBER;
1079: l_error_flag varchar2(10) := 'N';
1080: l_log_context pqh_process_log.log_context%TYPE;
1081:
1082:
1083:
1084: BEGIN

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

1802: -----------------------------------------------------------------------------------------------------
1803: If the fund checker program failed i.e l_fc_success = FALSE or l_fc_return in ('T', 'F','R') then we
1804: would do the following :
1805:
1806: 1. Put the error message in pqh_process_log ( context : Period Name + CCID + currency code )
1807:
1808: 2. update all the budget_detail records which have this Period Name + CCID + currency code to ERROR ( gl_status)
1809:
1810: 3. Reverse unposted adjustment txns in pqh_gl_interface

Line 2574: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2570: -- ----------------------------------------------------------------------------
2571: PROCEDURE set_bdt_log_context
2572: (
2573: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2574: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2575: ) IS
2576:
2577: /*
2578: This procedure will set the log_context at Budget detail level

Line 2669: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2665: --------------------------------------------------------------------------------------------------------------
2666: PROCEDURE set_bpr_log_context
2667: (
2668: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2669: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2670: ) IS
2671: /*
2672: This procedure will set the log_context at bpr periods level
2673:

Line 2741: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2737: --------------------------------------------------------------------------------------------------------------
2738: PROCEDURE set_bfs_log_context
2739: (
2740: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
2741: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2742: ) IS
2743:
2744: /*
2745: This procedure will set the log_context at wks budget fund srcs level

Line 2798: l_pqh_process_log_rec pqh_process_log%ROWTYPE;

2794: l_proc varchar2(72) := g_package||'end_log';
2795: l_count_error NUMBER := 0;
2796: l_count_warning NUMBER := 0;
2797: l_status VARCHAR2(30);
2798: l_pqh_process_log_rec pqh_process_log%ROWTYPE;
2799: PRAGMA AUTONOMOUS_TRANSACTION;
2800:
2801:
2802: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS

Line 2804: FROM pqh_process_log

2800:
2801:
2802: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
2803: SELECT COUNT(*)
2804: FROM pqh_process_log
2805: WHERE message_type_cd = p_message_type_cd
2806: START WITH process_log_id = pqh_process_batch_log.g_master_process_log_id
2807: CONNECT BY PRIOR process_log_id = master_process_log_id;
2808:

Line 2811: FROM pqh_process_log

2807: CONNECT BY PRIOR process_log_id = master_process_log_id;
2808:
2809: CURSOR csr_batch_rec IS
2810: SELECT *
2811: FROM pqh_process_log
2812: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2813:
2814:
2815: BEGIN

Line 2863: FETCH csr_batch_rec INTO l_pqh_process_log_rec;

2859: update the batch_end_date with current date time
2860: */
2861:
2862: OPEN csr_batch_rec;
2863: FETCH csr_batch_rec INTO l_pqh_process_log_rec;
2864: CLOSE csr_batch_rec;
2865:
2866: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2867: -- no errors in the batch

Line 2866: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN

2862: OPEN csr_batch_rec;
2863: FETCH csr_batch_rec INTO l_pqh_process_log_rec;
2864: CLOSE csr_batch_rec;
2865:
2866: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2867: -- no errors in the batch
2868: UPDATE pqh_process_log
2869: SET message_type_cd = 'COMPLETE',
2870: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),

Line 2868: UPDATE pqh_process_log

2864: CLOSE csr_batch_rec;
2865:
2866: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2867: -- no errors in the batch
2868: UPDATE pqh_process_log
2869: SET message_type_cd = 'COMPLETE',
2870: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
2871: txn_table_route_id = g_table_route_id_bvr,
2872: batch_status = l_status,

Line 2878: UPDATE pqh_process_log

2874: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2875: ELSE
2876: -- there were errors in the batch header record i.e the root node
2877: -- so only update the batch status and end date
2878: UPDATE pqh_process_log
2879: SET batch_status = l_status,
2880: batch_end_date = sysdate,
2881: txn_table_route_id = g_table_route_id_bvr
2882: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line 2906: p_message_text IN pqh_process_log.message_text%TYPE

2902:
2903: --------------------------------------------------------------------------------------------------------------
2904: PROCEDURE populate_globals_error
2905: (
2906: p_message_text IN pqh_process_log.message_text%TYPE
2907: ) IS
2908: /*
2909: If there are errors in populate globals procedure we will call this procedure which will
2910: end the process log as the batch itself has error

Line 2922: UPDATE pqh_process_log

2918: BEGIN
2919:
2920: hr_utility.set_location('Entering: '||l_proc, 5);
2921:
2922: UPDATE pqh_process_log
2923: SET message_type_cd = 'ERROR',
2924: message_text = p_message_text,
2925: txn_table_route_id = g_table_route_id_bvr
2926: -- batch_status = 'ERROR',

Line 5798: l_log_context pqh_process_log.log_context%TYPE;

5794: l_amount NUMBER;
5795: tran_setup_exception EXCEPTION;
5796: tran_source_exception EXCEPTION;
5797: l_pqh_interface_rec pqh_gl_interface%ROWTYPE;
5798: l_log_context pqh_process_log.log_context%TYPE;
5799: l_proc varchar2(72) := g_package||'.populate_gms_interface';
5800: l_log_message varchar2(8000);
5801: cnt BINARY_INTEGER := 1;
5802: ref_cnt BINARY_INTEGER := 1;