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 FND_NEW_MESSAGES

Line 144: l_message_text_out fnd_new_messages.message_text%TYPE;

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;
148: l_level number;

Line 145: l_message_number_out fnd_new_messages.message_number%TYPE;

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;
148: l_level number;
149: l_batch_id number;

Line 663: l_message_text_out fnd_new_messages.message_text%TYPE;

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';
667:

Line 664: l_message_number_out fnd_new_messages.message_number%TYPE;

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';
667:
668: l_unit1_available pqh_worksheet_details.budget_unit1_available%TYPE;

Line 878: l_message_text_out fnd_new_messages.message_text%TYPE;

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);
882: l_availability_status_id hr_positions.availability_status_id%type;

Line 1237: l_message_text_out fnd_new_messages.message_text%TYPE;

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';
1241: l_warnings_rec pqh_utility.warnings_rec;

Line 1434: l_message_text_out fnd_new_messages.message_text%TYPE;

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;
1438: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;

Line 1695: l_message_text_out fnd_new_messages.message_text%TYPE;

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';
1699: l_warnings_rec pqh_utility.warnings_rec;

Line 1916: l_message_text_out fnd_new_messages.message_text%TYPE;

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';
1920: l_warnings_rec pqh_utility.warnings_rec;

Line 2579: l_message_text_out fnd_new_messages.message_text%TYPE;

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';
2583:

Line 2932: l_message_text_out fnd_new_messages.message_text%TYPE;

2928: l_worksheets_rec pqh_worksheets%ROWTYPE;
2929: l_wks_ll_date date;
2930: l_wks_ul_date date;
2931: l_status varchar2(10);
2932: l_message_text_out fnd_new_messages.message_text%TYPE;
2933: l_pc_start_date date;
2934: l_pc_end_date date;
2935: l_pc_bdgt_name varchar2(80);
2936: l_pc_version_no number(9);