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.PQP_US_STUDENT_EARNINGS dependencies on HR_UTILITY

Line 154: hr_utility.set_location('Entering: '||l_proc_name, 5);

150: partyids varchar2(2000);
151: l_status varchar2(20);
152: l_proc_name constant varchar2(150) := g_pkg||'get_person_id';
153: begin
154: hr_utility.set_location('Entering: '||l_proc_name, 5);
155: plsql_block :=
156: ' declare
157: l_sql varchar2(2000);
158: begin

Line 170: hr_utility.set_location('Leaving: '||l_proc_name, 80);

166: execute immediate plsql_block
167: using p_group_id
168: ,out l_status
169: ,out partyids;
170: hr_utility.set_location('Leaving: '||l_proc_name, 80);
171: return partyids;
172: end get_person_id;
173:
174: begin

Line 176: hr_utility.set_location('Entering: '||l_proc_name, 5);

172: end get_person_id;
173:
174: begin
175:
176: hr_utility.set_location('Entering: '||l_proc_name, 5);
177: if hr_utility.debug_enabled then
178: g_debug := true;
179: end if;
180:

Line 177: if hr_utility.debug_enabled then

173:
174: begin
175:
176: hr_utility.set_location('Entering: '||l_proc_name, 5);
177: if hr_utility.debug_enabled then
178: g_debug := true;
179: end if;
180:
181: -- Translating the earnings type code as used in by the Student Financial Aid

Line 205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);

201: l_earnings_type := p_earnings_type;
202: end if;
203:
204: if g_debug then
205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);
206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);

Line 206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);

202: end if;
203:
204: if g_debug then
205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);
206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);
210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);

Line 207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);

203:
204: if g_debug then
205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);
206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);
210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);
211: end if;

Line 208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);

204: if g_debug then
205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);
206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);
210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);
211: end if;
212:

Line 209: hr_utility.set_location('SSN : '||p_ssn, 15);

205: hr_utility.set_location('Selection Criteria : '||p_selection_criteria, 15);
206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);
210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);
211: end if;
212:
213: if p_selection_criteria = 'Assignment Set' then

Line 210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);

206: hr_utility.set_location('Element Selection : '||p_element_selection, 15);
207: hr_utility.set_location('Business Group Id : '||p_business_group_id, 15);
208: hr_utility.set_location('Element Type Id : '||p_element_type_id, 15);
209: hr_utility.set_location('SSN : '||p_ssn, 15);
210: hr_utility.set_location('l_earnings_type : '||l_earnings_type, 15);
211: end if;
212:
213: if p_selection_criteria = 'Assignment Set' then
214:

Line 336: hr_utility.set_location('Group PartyId List: '||l_grp_party_list_id, 15);

332:
333: if l_grp_party_list_id is not null then
334:
335: l_grp_party_list_id := l_grp_party_list_id ||')';
336: hr_utility.set_location('Group PartyId List: '||l_grp_party_list_id, 15);
337:
338: if p_element_selection = 'Element Name' then
339:
340: l_selcrs :=

Line 665: hr_utility.set_location(' Start of Main Loop ', 20);

661:
662: end if; --if p_selection_criteria
663:
664: if g_debug then
665: hr_utility.set_location(' Start of Main Loop ', 20);
666:
667: end if;
668:
669: loop -- Start: Main Cursor

Line 679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);

675: l_element_type_id;
676: exit when pri_cur%notfound;
677: --
678: if g_debug then
679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);
680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);
681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);
682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);
683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);

Line 680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);

676: exit when pri_cur%notfound;
677: --
678: if g_debug then
679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);
680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);
681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);
682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);
683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);
684: end if;

Line 681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);

677: --
678: if g_debug then
679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);
680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);
681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);
682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);
683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);
684: end if;
685: -- Process the record if the Earnings Type matches

Line 682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);

678: if g_debug then
679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);
680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);
681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);
682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);
683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);
684: end if;
685: -- Process the record if the Earnings Type matches
686: for c_rec in c_get_run_value (l_assignment_action_id

Line 683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);

679: hr_utility.set_location('Assignment Id: '||l_assignment_id, 21);
680: hr_utility.set_location('Assignment Action Id: '||l_assignment_action_id, 21);
681: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 21);
682: hr_utility.set_location('Payroll ID: '||l_payroll_id, 21);
683: hr_utility.set_location('Element Type Id: '||l_element_type_id, 21);
684: end if;
685: -- Process the record if the Earnings Type matches
686: for c_rec in c_get_run_value (l_assignment_action_id
687: ,l_element_type_id

Line 695: hr_utility.set_location('l_chk_earnings_type: '||l_chk_earnings_type, 21);

691: l_chk_earnings_type := c_rec.result_value;
692: end loop;
693: if nvl(p_earnings_type, l_chk_earnings_type) <> l_chk_earnings_type then
694: -- raise error;
695: hr_utility.set_location('l_chk_earnings_type: '||l_chk_earnings_type, 21);
696: hr_utility.set_location('p_earnings_type: '||p_earnings_type, 21);
697: exit;
698: end if;
699: -- Get Authorization Number

Line 696: hr_utility.set_location('p_earnings_type: '||p_earnings_type, 21);

692: end loop;
693: if nvl(p_earnings_type, l_chk_earnings_type) <> l_chk_earnings_type then
694: -- raise error;
695: hr_utility.set_location('l_chk_earnings_type: '||l_chk_earnings_type, 21);
696: hr_utility.set_location('p_earnings_type: '||p_earnings_type, 21);
697: exit;
698: end if;
699: -- Get Authorization Number
700: l_authorization_number := null;

Line 721: hr_utility.set_location('Stu Party Id: '||l_person_id, 22);

717: -- Get Person Id from Student System, i.e. party_id
718: open c_party_id (c_asssignment_id => l_assignment_id
719: ,c_effective_date => l_date_earned);
720: fetch c_party_id into l_person_id;
721: hr_utility.set_location('Stu Party Id: '||l_person_id, 22);
722:
723: if c_party_id%found then
724: if g_debug then
725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);

Line 725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);

721: hr_utility.set_location('Stu Party Id: '||l_person_id, 22);
722:
723: if c_party_id%found then
724: if g_debug then
725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);
726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);

Line 726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);

722:
723: if c_party_id%found then
724: if g_debug then
725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);
726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);
730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);

Line 727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);

723: if c_party_id%found then
724: if g_debug then
725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);
726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);
730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);
731: end if;

Line 728: hr_utility.set_location('Party Id: '||l_person_id, 22);

724: if g_debug then
725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);
726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);
730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);
731: end if;
732: --

Line 729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);

725: hr_utility.set_location('Payroll Id: '||l_payroll_id, 22);
726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);
730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);
731: end if;
732: --
733: plsql_block :=

Line 730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);

726: hr_utility.set_location('Date Earned: '||l_date_earned, 22);
727: hr_utility.set_location('Authorization Number: '||l_authorization_number, 22);
728: hr_utility.set_location('Party Id: '||l_person_id, 22);
729: hr_utility.set_location('Paid Amount: '||l_paid_amount, 22);
730: hr_utility.set_location('Tax Unit Id: '||l_tax_unit_id, 22);
731: end if;
732: --
733: plsql_block :=
734: 'declare

Line 774: hr_utility.set_location(' l_transaction_id: '||l_transaction_id, 70);

770: end if;
771: Close c_party_id;
772:
773: if g_debug then
774: hr_utility.set_location(' l_transaction_id: '||l_transaction_id, 70);
775: hr_utility.set_location(' l_return_status : '||l_return_status, 70);
776: end if;
777: l_transaction_id := null; l_msg_data := null;
778: l_return_status := null;

Line 775: hr_utility.set_location(' l_return_status : '||l_return_status, 70);

771: Close c_party_id;
772:
773: if g_debug then
774: hr_utility.set_location(' l_transaction_id: '||l_transaction_id, 70);
775: hr_utility.set_location(' l_return_status : '||l_return_status, 70);
776: end if;
777: l_transaction_id := null; l_msg_data := null;
778: l_return_status := null;
779: end loop; -- end: main cursor

Line 781: hr_utility.set_location('leaving: '||l_proc_name, 80);

777: l_transaction_id := null; l_msg_data := null;
778: l_return_status := null;
779: end loop; -- end: main cursor
780: close pri_cur;
781: hr_utility.set_location('leaving: '||l_proc_name, 80);
782: commit;
783:
784: end Transfer_Student_Earnings;
785: