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_WKS_ERROR_CHK dependencies on PQH_PROCESS_LOG

Line 143: l_message_text pqh_process_log.message_text%TYPE;

139: l_pqh_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
140: l_pqh_worksheet_budget_set_rec pqh_worksheet_budget_sets%ROWTYPE;
141: l_pqh_worksheet_bdgt_elmnt_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
142: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
143: l_message_text pqh_process_log.message_text%TYPE;
144: l_message_text_out fnd_new_messages.message_text%TYPE;
145: l_message_number_out fnd_new_messages.message_number%TYPE;
146: l_log_context pqh_process_log.log_context%TYPE;
147: l_pqh_worksheet_details_c_rec pqh_worksheet_details_cur%ROWTYPE;

Line 146: l_log_context pqh_process_log.log_context%TYPE;

142: l_pqh_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
143: l_message_text pqh_process_log.message_text%TYPE;
144: l_message_text_out fnd_new_messages.message_text%TYPE;
145: l_message_number_out fnd_new_messages.message_number%TYPE;
146: l_log_context pqh_process_log.log_context%TYPE;
147: l_pqh_worksheet_details_c_rec pqh_worksheet_details_cur%ROWTYPE;
148: l_level number;
149: l_batch_id number;
150: l_batch_context varchar2(2000);

Line 472: -- UPDATE pqh_process_log

468: updt_batch
469: (
470: p_message_text => l_message_text
471: );
472: -- UPDATE pqh_process_log
473: -- SET message_type_cd = 'ERROR',
474: -- message_text = l_message_text,
475: -- txn_table_route_id = g_table_route_id_wdt,
476: -- batch_status = 'ERROR',

Line 662: l_message_text pqh_process_log.message_text%TYPE;

658: */
659:
660: l_proc varchar2(72) := g_package||'check_level1_rows';
661: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
662: l_message_text pqh_process_log.message_text%TYPE;
663: l_message_text_out fnd_new_messages.message_text%TYPE;
664: l_message_number_out fnd_new_messages.message_number%TYPE;
665: l_log_context pqh_process_log.log_context%TYPE;
666: l_error_flag varchar2(10) := 'N';

Line 665: l_log_context pqh_process_log.log_context%TYPE;

661: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
662: l_message_text pqh_process_log.message_text%TYPE;
663: l_message_text_out fnd_new_messages.message_text%TYPE;
664: l_message_number_out fnd_new_messages.message_number%TYPE;
665: l_log_context pqh_process_log.log_context%TYPE;
666: l_error_flag varchar2(10) := 'N';
667:
668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;
669: l_unit2_available pqh_worksheet_details.budget_unit2_available%TYPE;

Line 877: l_message_text pqh_process_log.message_text%TYPE;

873: */
874:
875: l_proc varchar2(72) := g_package||'check_wks_details';
876: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
877: l_message_text pqh_process_log.message_text%TYPE;
878: l_message_text_out fnd_new_messages.message_text%TYPE;
879: l_count number;
880: l_error_flag varchar2(10) := 'N';
881: l_pc_posn_status varchar2(30);

Line 1236: l_message_text pqh_process_log.message_text%TYPE;

1232: */
1233:
1234: l_proc varchar2(72) := g_package||'check_wks_periods';
1235: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
1236: l_message_text pqh_process_log.message_text%TYPE;
1237: l_message_text_out fnd_new_messages.message_text%TYPE;
1238: l_count NUMBER;
1239: l_error_flag varchar2(10) := 'N';
1240: l_message_type varchar2(10) := 'E';

Line 1433: l_message_text pqh_process_log.message_text%TYPE;

1429: */
1430:
1431: l_proc varchar2(72) := g_package||'check_wks_budget_sets';
1432: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
1433: l_message_text pqh_process_log.message_text%TYPE;
1434: l_message_text_out fnd_new_messages.message_text%TYPE;
1435: l_unit1_sum NUMBER;
1436: l_unit2_sum NUMBER;
1437: l_unit3_sum NUMBER;

Line 1694: l_message_text pqh_process_log.message_text%TYPE;

1690: */
1691:
1692: l_proc varchar2(72) := g_package||'check_wks_budget_elements';
1693: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
1694: l_message_text pqh_process_log.message_text%TYPE;
1695: l_message_text_out fnd_new_messages.message_text%TYPE;
1696: l_percentage_sum NUMBER;
1697: l_error_flag varchar2(10) := 'N';
1698: l_message_type varchar2(10) := 'E';

Line 1915: l_message_text pqh_process_log.message_text%TYPE;

1911: */
1912:
1913: l_proc varchar2(72) := g_package||'check_wks_fund_srcs';
1914: l_worksheet_fund_srcs_rec pqh_worksheet_fund_srcs%ROWTYPE;
1915: l_message_text pqh_process_log.message_text%TYPE;
1916: l_message_text_out fnd_new_messages.message_text%TYPE;
1917: l_percentage_sum NUMBER;
1918: l_error_flag varchar2(10) := 'N';
1919: l_message_type varchar2(10) := 'E';

Line 2107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2103:
2104: PROCEDURE set_wks_log_context
2105: (
2106: p_worksheet_detail_id IN pqh_worksheet_details.worksheet_detail_id%TYPE,
2107: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2108: ) IS
2109:
2110: /*
2111: This procedure will set the log_context at wks detail level

Line 2223: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2219:
2220: PROCEDURE set_wpr_log_context
2221: (
2222: p_worksheet_period_id IN pqh_worksheet_periods.worksheet_period_id%TYPE,
2223: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2224: ) IS
2225: /*
2226: This procedure will set the log_context at wks periods level
2227:

Line 2304: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2300:
2301: PROCEDURE set_wst_log_context
2302: (
2303: p_worksheet_budget_set_id IN pqh_worksheet_budget_sets.worksheet_budget_set_id%TYPE,
2304: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2305: ) IS
2306:
2307: /*
2308: This procedure will set the log_context at wks budget sets level

Line 2369: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2365:
2366: PROCEDURE set_wel_log_context
2367: (
2368: p_worksheet_bdgt_elmnt_id IN pqh_worksheet_bdgt_elmnts.worksheet_bdgt_elmnt_id%TYPE,
2369: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2370: ) IS
2371:
2372: /*
2373: This procedure will set the log_context at wks budget elements level

Line 2466: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE

2462:
2463: PROCEDURE set_wfs_log_context
2464: (
2465: p_worksheet_fund_src_id IN pqh_worksheet_fund_srcs.worksheet_fund_src_id%TYPE,
2466: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2467: ) IS
2468:
2469: /*
2470: This procedure will set the log_context at wks budget fund srcs level

Line 2578: l_message_text pqh_process_log.message_text%TYPE;

2574: */
2575:
2576: l_proc varchar2(72) := g_package||'check_input_wks_details';
2577: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2578: l_message_text pqh_process_log.message_text%TYPE;
2579: l_message_text_out fnd_new_messages.message_text%TYPE;
2580: l_count number;
2581: l_budget_count number;
2582: l_error_flag varchar2(10) := 'N';

Line 2711: -- UPDATE pqh_process_log

2707: (
2708: p_message_text => l_message_text
2709: );
2710:
2711: -- UPDATE pqh_process_log
2712: -- SET message_type_cd = 'ERROR',
2713: -- message_text = l_message_text,
2714: -- txn_table_route_id = g_table_route_id_wdt,
2715: -- batch_status = 'ERROR',

Line 2752: l_pqh_process_log_rec pqh_process_log%ROWTYPE;

2748: l_proc varchar2(72) := g_package||'end_log';
2749: l_count_error NUMBER := 0;
2750: l_count_warning NUMBER := 0;
2751: l_status VARCHAR2(30);
2752: l_pqh_process_log_rec pqh_process_log%ROWTYPE;
2753:
2754:
2755: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
2756: SELECT COUNT(*)

Line 2757: FROM pqh_process_log

2753:
2754:
2755: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
2756: SELECT COUNT(*)
2757: FROM pqh_process_log
2758: WHERE message_type_cd = p_message_type_cd
2759: START WITH process_log_id = pqh_process_batch_log.g_master_process_log_id
2760: CONNECT BY PRIOR process_log_id = master_process_log_id;
2761:

Line 2764: FROM pqh_process_log

2760: CONNECT BY PRIOR process_log_id = master_process_log_id;
2761:
2762: CURSOR csr_batch_rec IS
2763: SELECT *
2764: FROM pqh_process_log
2765: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2766:
2767: PRAGMA AUTONOMOUS_TRANSACTION;
2768:

Line 2818: FETCH csr_batch_rec INTO l_pqh_process_log_rec;

2814: update the batch_end_date with current date time
2815: */
2816:
2817: OPEN csr_batch_rec;
2818: FETCH csr_batch_rec INTO l_pqh_process_log_rec;
2819: CLOSE csr_batch_rec;
2820:
2821: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2822: -- no errors in the batch

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

2817: OPEN csr_batch_rec;
2818: FETCH csr_batch_rec INTO l_pqh_process_log_rec;
2819: CLOSE csr_batch_rec;
2820:
2821: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2822: -- no errors in the batch
2823: UPDATE pqh_process_log
2824: SET message_type_cd = 'COMPLETE',
2825: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),

Line 2823: UPDATE pqh_process_log

2819: CLOSE csr_batch_rec;
2820:
2821: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2822: -- no errors in the batch
2823: UPDATE pqh_process_log
2824: SET message_type_cd = 'COMPLETE',
2825: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
2826: txn_table_route_id = g_table_route_id_wdt,
2827: batch_status = l_status,

Line 2833: UPDATE pqh_process_log

2829: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2830: ELSE
2831: -- there were errors in the batch header record i.w the root node
2832: -- so only update the batch status and end date
2833: UPDATE pqh_process_log
2834: SET batch_status = l_status,
2835: batch_end_date = sysdate,
2836: txn_table_route_id = g_table_route_id_wdt
2837: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line 2867: p_message_text IN pqh_process_log.message_text%TYPE

2863: ------------------------------------------------------------------*/
2864:
2865: PROCEDURE updt_batch
2866: (
2867: p_message_text IN pqh_process_log.message_text%TYPE
2868: )
2869: IS
2870: --
2871: -- local variables

Line 2874: l_message_text pqh_process_log.message_text%TYPE;

2870: --
2871: -- local variables
2872: --
2873: l_proc varchar2(72) := g_package||'updt_batch';
2874: l_message_text pqh_process_log.message_text%TYPE;
2875:
2876: PRAGMA AUTONOMOUS_TRANSACTION;
2877:
2878: BEGIN

Line 2883: UPDATE pqh_process_log

2879:
2880: hr_utility.set_location('Entering: '||l_proc, 5);
2881:
2882:
2883: UPDATE pqh_process_log
2884: SET message_type_cd = 'ERROR',
2885: message_text = p_message_text,
2886: txn_table_route_id = g_table_route_id_wdt,
2887: batch_status = 'ERROR',