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_BEE dependencies on HR_UTILITY

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

162: ) return varchar2 is
163: l_lookup_meaning fnd_lookup_values_vl.meaning%type;
164: l_proc_name varchar2(150) := g_pkg ||'Get_Lookup_Meaning';
165: begin
166: hr_utility.set_location('Entering: '||l_proc_name, 5);
167: open csr_lookup_meaning
168: (p_lookup_type => p_lookup_type
169: ,p_lookup_code => p_lookup_code);
170: fetch csr_lookup_meaning into l_lookup_meaning;

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

168: (p_lookup_type => p_lookup_type
169: ,p_lookup_code => p_lookup_code);
170: fetch csr_lookup_meaning into l_lookup_meaning;
171: close csr_lookup_meaning;
172: hr_utility.set_location('Leaving: '||l_proc_name, 80);
173: return l_lookup_meaning;
174:
175: end Get_Lookup_Meaning;
176: -- =============================================================================

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

182:
183: l_proc_name varchar2(150) := g_pkg ||'Check_Input_Values';
184:
185: Begin
186: hr_utility.set_location('Entering: '||l_proc_name, 5);
187: For i in 1..15
188: Loop
189: For j in 1..15
190: Loop

Line 193: hr_utility.set_location('Old IPV: '||p_ipv_rec_old(i).screen_entry_value, 5);

189: For j in 1..15
190: Loop
191: If Upper(p_ipv_rec_old(i).name) = Upper(p_ipv_rec_new(j).name) Then
192: If p_ipv_rec_new(j).screen_entry_value is Null Then
193: hr_utility.set_location('Old IPV: '||p_ipv_rec_old(i).screen_entry_value, 5);
194: hr_utility.set_location('New IPV: '||p_ipv_rec_new(j).screen_entry_value, 5);
195: p_ipv_rec_new(j).screen_entry_value
196: := p_ipv_rec_old(i).screen_entry_value;
197: Exit;

Line 194: hr_utility.set_location('New IPV: '||p_ipv_rec_new(j).screen_entry_value, 5);

190: Loop
191: If Upper(p_ipv_rec_old(i).name) = Upper(p_ipv_rec_new(j).name) Then
192: If p_ipv_rec_new(j).screen_entry_value is Null Then
193: hr_utility.set_location('Old IPV: '||p_ipv_rec_old(i).screen_entry_value, 5);
194: hr_utility.set_location('New IPV: '||p_ipv_rec_new(j).screen_entry_value, 5);
195: p_ipv_rec_new(j).screen_entry_value
196: := p_ipv_rec_old(i).screen_entry_value;
197: Exit;
198: End If;

Line 202: hr_utility.set_location('Leaving: '||l_proc_name, 60);

198: End If;
199: End If;
200: End Loop;
201: End Loop;
202: hr_utility.set_location('Leaving: '||l_proc_name, 60);
203: End Check_Input_Values;
204: -- =============================================================================
205: -- ~ Init_Ipv_Rec: Used to re-set the values of the input names, before using it
206: -- ~ another element type id.

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

255: l_count number;
256:
257: Begin
258:
259: hr_utility.set_location('Entering: '||l_proc_name, 5);
260: p_award_paid := false;
261: p_award_amt_adj := false;
262: -- We have to back one year for the assignment to see if the same auth id
263: -- was already given to the student and end dated already.

Line 270: hr_utility.set_location(' l_start_date: '|| l_start_date,6);

266: l_count := 0;
267:
268: Init_Ipv_Rec(l_ipv_rec_old);
269:
270: hr_utility.set_location(' l_start_date: '|| l_start_date,6);
271: hr_utility.set_location(' l_end_date: '|| l_end_date,6);
272:
273: -- Check for all the past one years Student Earnings to see if the student
274: -- has been paid for this work authorization already.

Line 271: hr_utility.set_location(' l_end_date: '|| l_end_date,6);

267:
268: Init_Ipv_Rec(l_ipv_rec_old);
269:
270: hr_utility.set_location(' l_start_date: '|| l_start_date,6);
271: hr_utility.set_location(' l_end_date: '|| l_end_date,6);
272:
273: -- Check for all the past one years Student Earnings to see if the student
274: -- has been paid for this work authorization already.
275: For prv_awds in csr_chk_ele

Line 283: hr_utility.set_location(' Element Type Id: '|| prv_awds.element_type_id,6);

279: ,c_end_date => l_end_date )
280: Loop
281: -- Check if the element has an input call Authorization ID
282: If g_debug Then
283: hr_utility.set_location(' Element Type Id: '|| prv_awds.element_type_id,6);
284: hr_utility.set_location(' Element Entry Id: '|| prv_awds.element_entry_id,6);
285: hr_utility.set_location(' Element Link Id: '|| prv_awds.element_link_id,6);
286: End If;
287: Open ipv_id (prv_awds.element_type_id

Line 284: hr_utility.set_location(' Element Entry Id: '|| prv_awds.element_entry_id,6);

280: Loop
281: -- Check if the element has an input call Authorization ID
282: If g_debug Then
283: hr_utility.set_location(' Element Type Id: '|| prv_awds.element_type_id,6);
284: hr_utility.set_location(' Element Entry Id: '|| prv_awds.element_entry_id,6);
285: hr_utility.set_location(' Element Link Id: '|| prv_awds.element_link_id,6);
286: End If;
287: Open ipv_id (prv_awds.element_type_id
288: ,'Authorization ID');

Line 285: hr_utility.set_location(' Element Link Id: '|| prv_awds.element_link_id,6);

281: -- Check if the element has an input call Authorization ID
282: If g_debug Then
283: hr_utility.set_location(' Element Type Id: '|| prv_awds.element_type_id,6);
284: hr_utility.set_location(' Element Entry Id: '|| prv_awds.element_entry_id,6);
285: hr_utility.set_location(' Element Link Id: '|| prv_awds.element_link_id,6);
286: End If;
287: Open ipv_id (prv_awds.element_type_id
288: ,'Authorization ID');
289: Fetch ipv_id Into l_authId_ipv_id, l_awdId_name;

Line 297: hr_utility.set_location(' l_maxAmt_name: '|| l_maxAmt_name,9);

293: ,'Maximum Amount');
294: Fetch ipv_id Into l_maxAmt_ipvId,l_maxAmt_name;
295: Close ipv_id;
296: If g_debug Then
297: hr_utility.set_location(' l_maxAmt_name: '|| l_maxAmt_name,9);
298: hr_utility.set_location(' l_maxAmt_ipvId: '|| l_maxAmt_ipvId,9);
299: hr_utility.set_location(' l_awdId_name: '|| l_awdId_name,7);
300: hr_utility.set_location(' l_authId_ipv_id: '|| l_authId_ipv_id,7);
301: End If;

Line 298: hr_utility.set_location(' l_maxAmt_ipvId: '|| l_maxAmt_ipvId,9);

294: Fetch ipv_id Into l_maxAmt_ipvId,l_maxAmt_name;
295: Close ipv_id;
296: If g_debug Then
297: hr_utility.set_location(' l_maxAmt_name: '|| l_maxAmt_name,9);
298: hr_utility.set_location(' l_maxAmt_ipvId: '|| l_maxAmt_ipvId,9);
299: hr_utility.set_location(' l_awdId_name: '|| l_awdId_name,7);
300: hr_utility.set_location(' l_authId_ipv_id: '|| l_authId_ipv_id,7);
301: End If;
302: If l_maxAmt_ipvId Is Null or l_authId_ipv_id Is Null Then

Line 299: hr_utility.set_location(' l_awdId_name: '|| l_awdId_name,7);

295: Close ipv_id;
296: If g_debug Then
297: hr_utility.set_location(' l_maxAmt_name: '|| l_maxAmt_name,9);
298: hr_utility.set_location(' l_maxAmt_ipvId: '|| l_maxAmt_ipvId,9);
299: hr_utility.set_location(' l_awdId_name: '|| l_awdId_name,7);
300: hr_utility.set_location(' l_authId_ipv_id: '|| l_authId_ipv_id,7);
301: End If;
302: If l_maxAmt_ipvId Is Null or l_authId_ipv_id Is Null Then
303: Goto Next_Element;

Line 300: hr_utility.set_location(' l_authId_ipv_id: '|| l_authId_ipv_id,7);

296: If g_debug Then
297: hr_utility.set_location(' l_maxAmt_name: '|| l_maxAmt_name,9);
298: hr_utility.set_location(' l_maxAmt_ipvId: '|| l_maxAmt_ipvId,9);
299: hr_utility.set_location(' l_awdId_name: '|| l_awdId_name,7);
300: hr_utility.set_location(' l_authId_ipv_id: '|| l_authId_ipv_id,7);
301: End If;
302: If l_maxAmt_ipvId Is Null or l_authId_ipv_id Is Null Then
303: Goto Next_Element;
304: End If;

Line 313: hr_utility.set_location(' l_authId_ipv_value: '|| l_authId_ipv_value,8);

309: ,c_input_value_id => l_authId_ipv_id
310: );
311: Fetch csr_entry_val Into l_authId_ipv_value;
312: Close csr_entry_val;
313: hr_utility.set_location(' l_authId_ipv_value: '|| l_authId_ipv_value,8);
314:
315: -- Get the Max. Auth Amount screen entry value
316: Open csr_entry_val(c_element_entry_id => prv_awds.element_entry_id
317: ,c_start_date => l_start_date

Line 322: hr_utility.set_location(' l_maxAmt_ipv_value: '|| l_maxAmt_ipv_value,10);

318: ,c_end_date => l_end_date
319: ,c_input_value_id => l_maxAmt_ipvId);
320: Fetch csr_entry_val Into l_maxAmt_ipv_value;
321: Close csr_entry_val;
322: hr_utility.set_location(' l_maxAmt_ipv_value: '|| l_maxAmt_ipv_value,10);
323:
324: -- Check if the Student had already gotten the authorization paid in the
325: -- past one year.
326: If l_authId_ipv_value is not null and

Line 337: hr_utility.set_location(' l_ele_entry_st_date: '|| l_ele_entry_st_date,10);

333: ,p_assignment_id);
334: Fetch entry_date Into l_ele_entry_st_date, l_ele_entry_ed_date;
335: Close entry_date;
336: If g_debug Then
337: hr_utility.set_location(' l_ele_entry_st_date: '|| l_ele_entry_st_date,10);
338: hr_utility.set_location(' l_ele_entry_ed_date: '|| l_ele_entry_ed_date,10);
339: End If;
340: -- Auth Id are same, now check the amounts.
341: If p_award_max_amt > to_number(l_maxAmt_ipv_value) and

Line 338: hr_utility.set_location(' l_ele_entry_ed_date: '|| l_ele_entry_ed_date,10);

334: Fetch entry_date Into l_ele_entry_st_date, l_ele_entry_ed_date;
335: Close entry_date;
336: If g_debug Then
337: hr_utility.set_location(' l_ele_entry_st_date: '|| l_ele_entry_st_date,10);
338: hr_utility.set_location(' l_ele_entry_ed_date: '|| l_ele_entry_ed_date,10);
339: End If;
340: -- Auth Id are same, now check the amounts.
341: If p_award_max_amt > to_number(l_maxAmt_ipv_value) and
342: l_ele_entry_ed_date < l_end_date Then

Line 345: hr_utility.set_location(' p_award_amt_adj: TRUE', 11);

341: If p_award_max_amt > to_number(l_maxAmt_ipv_value) and
342: l_ele_entry_ed_date < l_end_date Then
343: l_new_Maxdiff_amt := (p_award_max_amt - to_number(l_maxAmt_ipv_value));
344: p_award_amt_adj := True;
345: hr_utility.set_location(' p_award_amt_adj: TRUE', 11);
346: For i in 1..15
347: Loop
348: if p_ipv_val_tab(i).name ='Maximum Amount' Then
349: p_ipv_val_tab(i).screen_entry_value := l_new_Maxdiff_amt;

Line 356: hr_utility.set_location(' p_award_paid: TRUE', 11);

352: End Loop;
353: Elsif p_award_max_amt = to_number(l_maxAmt_ipv_value) and
354: l_ele_entry_ed_date < l_end_date Then
355: p_award_paid := True;
356: hr_utility.set_location(' p_award_paid: TRUE', 11);
357: Exit;
358: Elsif p_award_max_amt = to_number(l_maxAmt_ipv_value) and
359: p_effective_date Between l_ele_entry_st_date and
360: l_ele_entry_ed_date Then

Line 361: hr_utility.set_location(' Entry Already Exists', 11);

357: Exit;
358: Elsif p_award_max_amt = to_number(l_maxAmt_ipv_value) and
359: p_effective_date Between l_ele_entry_st_date and
360: l_ele_entry_ed_date Then
361: hr_utility.set_location(' Entry Already Exists', 11);
362: p_award_paid := True;
363: Exit;
364: End If;
365:

Line 368: hr_utility.set_location(' p_element_type_id: '||p_element_type_id, 12);

364: End If;
365:
366: If p_element_type_id = prv_awds.element_type_id Then
367: If g_debug Then
368: hr_utility.set_location(' p_element_type_id: '||p_element_type_id, 12);
369: hr_utility.set_location(' prv_awds.element_type_id: '||prv_awds.element_type_id, 12);
370: End If;
371: l_ipv_rec_old := p_ipv_val_tab;
372: Else

Line 369: hr_utility.set_location(' prv_awds.element_type_id: '||prv_awds.element_type_id, 12);

365:
366: If p_element_type_id = prv_awds.element_type_id Then
367: If g_debug Then
368: hr_utility.set_location(' p_element_type_id: '||p_element_type_id, 12);
369: hr_utility.set_location(' prv_awds.element_type_id: '||prv_awds.element_type_id, 12);
370: End If;
371: l_ipv_rec_old := p_ipv_val_tab;
372: Else
373: -- Means the element type is diff. even though the both the

Line 401: hr_utility.set_location(' IPV Name: '||l_ipv_rec_old(i).name, 13);

397: ,c_end_date => l_ele_entry_ed_date
398: ,c_input_value_id => l_ipv_rec_old(i).input_value_id);
399: Fetch csr_entry_val Into l_ipv_rec_old(i).screen_entry_value;
400: If g_debug Then
401: hr_utility.set_location(' IPV Name: '||l_ipv_rec_old(i).name, 13);
402: hr_utility.set_location(' IPV Value: '||l_ipv_rec_old(i).screen_entry_value, 13);
403: end if;
404: Close csr_entry_val;
405: End loop;

Line 402: hr_utility.set_location(' IPV Value: '||l_ipv_rec_old(i).screen_entry_value, 13);

398: ,c_input_value_id => l_ipv_rec_old(i).input_value_id);
399: Fetch csr_entry_val Into l_ipv_rec_old(i).screen_entry_value;
400: If g_debug Then
401: hr_utility.set_location(' IPV Name: '||l_ipv_rec_old(i).name, 13);
402: hr_utility.set_location(' IPV Value: '||l_ipv_rec_old(i).screen_entry_value, 13);
403: end if;
404: Close csr_entry_val;
405: End loop;
406: Check_Input_Values(p_ipv_val_tab,l_ipv_rec_old);

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

414: l_authId_ipv_value := Null; l_maxAmt_ipv_value := Null;
415: l_ele_entry_st_date:= Null; l_ele_entry_ed_date:= Null;
416:
417: End Loop; --For prv_awds
418: hr_utility.set_location('Leaving: '||l_proc_name, 80);
419: exception
420: when others then
421: hr_utility.set_location('Leaving: '||l_proc_name, 90);
422:

Line 421: hr_utility.set_location('Leaving: '||l_proc_name, 90);

417: End Loop; --For prv_awds
418: hr_utility.set_location('Leaving: '||l_proc_name, 80);
419: exception
420: when others then
421: hr_utility.set_location('Leaving: '||l_proc_name, 90);
422:
423: End Chk_If_Entry_Exists;
424:
425: -- =============================================================================

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

548: end Get_Person_ID;
549:
550: begin -- Main
551:
552: hr_utility.set_location('Entering: '||l_proc_name, 5);
553: if hr_utility.debug_enabled then
554: g_debug := true;
555: end if;
556:

Line 553: if hr_utility.debug_enabled then

549:
550: begin -- Main
551:
552: hr_utility.set_location('Entering: '||l_proc_name, 5);
553: if hr_utility.debug_enabled then
554: g_debug := true;
555: end if;
556:
557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);

Line 557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);

553: if hr_utility.debug_enabled then
554: g_debug := true;
555: end if;
556:
557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);
558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);

Line 558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);

554: g_debug := true;
555: end if;
556:
557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);
558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);

Line 559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);

555: end if;
556:
557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);
558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);
563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);

Line 560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);

556:
557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);
558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);
563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);
564:

Line 561: hr_utility.set_location('p_ssn: '||p_ssn, 5);

557: hr_utility.set_location('p_effective_date: '||p_effective_date, 5);
558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);
563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);
564:
565: -- ===========================================================================

Line 562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);

558: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 5);
559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);
563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);
564:
565: -- ===========================================================================
566: -- ~ Assign default values to the local variables.

Line 563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);

559: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 5);
560: hr_utility.set_location('p_assignment_set: '||p_assignment_set, 5);
561: hr_utility.set_location('p_ssn: '||p_ssn, 5);
562: hr_utility.set_location('p_person_group_id: '||p_person_group_id, 5);
563: hr_utility.set_location('p_element_type_id: '||p_element_type_id, 5);
564:
565: -- ===========================================================================
566: -- ~ Assign default values to the local variables.
567: -- ===========================================================================

Line 568: hr_utility.set_location('Assign default value to local variables ', 5);

564:
565: -- ===========================================================================
566: -- ~ Assign default values to the local variables.
567: -- ===========================================================================
568: hr_utility.set_location('Assign default value to local variables ', 5);
569: l_ct := 0; l_person_id := null;
570: l_new_batch := 0; l_ssn := null;
571: l_object_version_number:= 0; l_fund_code := null;
572: l_batch_line_id := 0; l_auth_id := null;

Line 578: hr_utility.set_location('p_earnings_type: '||p_earnings_type, 10);

574: l_batch_header_created := false;
575:
576: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
577:
578: hr_utility.set_location('p_earnings_type: '||p_earnings_type, 10);
579: -- Translating the earnings type code as used in by the Student Financial Aid
580: -- Module. For HRMS its PQP_US_STUDENT_EARNINGS_TYPE and for OSS Fin. Aid its
581: -- IGF_AW_FUND_SOURCE.
582:

Line 603: hr_utility.set_location('l_earnings_type: '||l_earnings_type, 10);

599: l_earnings_type := 'FEDERAL';
600:
601: end if;
602:
603: hr_utility.set_location('l_earnings_type: '||l_earnings_type, 10);
604:
605: if p_selection_criteria = 'Assignment Set' then
606:
607: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 11);

Line 607: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 11);

603: hr_utility.set_location('l_earnings_type: '||l_earnings_type, 10);
604:
605: if p_selection_criteria = 'Assignment Set' then
606:
607: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 11);
608: -- If the selection criteria is an Assignment set then get all the employee
609: -- assignments of those who are student employees within the assignment set.
610: l_selcrs :=
611: 'select per.national_identifier,

Line 645: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 12);

641: ,to_number(p_assignment_set);
642:
643: elsif p_selection_criteria = 'OSS Student Person Group' then
644:
645: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 12);
646: -- If the selection criteris is an OSS Person Group, then call the dynamic
647: -- sql to get the list of student party ids and match those with the
648: -- party id in per_all_people_f.
649: l_selcrs := get_person_id(to_number(p_person_group_id));

Line 654: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 13);

650: open pri_cur for l_selcrs;
651:
652: elsif p_selection_criteria = 'ALL' then
653:
654: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 13);
655: -- To get the awards details from OSS for all the student employees
656: -- within the business group id.
657: l_selcrs :=
658: 'select per.national_identifier,

Line 685: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 14);

681: ,p_business_group_id;
682:
683: elsif p_selection_criteria = 'Social Security Number' then
684:
685: hr_utility.set_location('p_selection_criteria: '||p_selection_criteria, 14);
686: -- Get the Student award details for the given social security number.
687: l_selcrs :=
688: 'select per.national_identifier,
689: paf.assignment_id,

Line 716: hr_utility.set_location('Delete the PL/SQL table and create null records ', 15);

712: ,p_business_group_id;
713: end if;
714:
715: l_batch_header_created := false;
716: hr_utility.set_location('Delete the PL/SQL table and create null records ', 15);
717: l_ipv.delete;
718: for i in 1..15
719: loop
720: l_ipv(i).screen_entry_value := null;

Line 731: hr_utility.set_location('Assign the input names to the PL/SQL table ', 15);

727: l_ipv(i).min_value := null;
728: end loop;
729: -- Get the input value names for the earnings element
730: l_count := 0;
731: hr_utility.set_location('Assign the input names to the PL/SQL table ', 15);
732: for ipv_rec in csr_ipv_id(c_ele_type_id => p_element_type_id
733: ,c_effective_date => l_effective_date)
734: loop
735: l_count := l_count + 1;

Line 758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);

754: l_party_id;
755: end if;
756: --
757: if g_debug then
758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);
759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);

Line 759: hr_utility.set_location('SSN :'||l_ssn, 15);

755: end if;
756: --
757: if g_debug then
758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);
759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);

Line 760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);

756: --
757: if g_debug then
758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);
759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);
764: hr_utility.set_location('Element Name: '||l_element_name, 15);

Line 761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);

757: if g_debug then
758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);
759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);
764: hr_utility.set_location('Element Name: '||l_element_name, 15);
765: end if;

Line 762: hr_utility.set_location('Party ID: '||l_party_id, 15);

758: hr_utility.set_location('Assignment Set ID'||p_assignment_set, 15);
759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);
764: hr_utility.set_location('Element Name: '||l_element_name, 15);
765: end if;
766: -- If no more students left then, exit.

Line 763: hr_utility.set_location('Person ID: '||l_person_id, 15);

759: hr_utility.set_location('SSN :'||l_ssn, 15);
760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);
764: hr_utility.set_location('Element Name: '||l_element_name, 15);
765: end if;
766: -- If no more students left then, exit.
767: exit when pri_cur%notfound;

Line 764: hr_utility.set_location('Element Name: '||l_element_name, 15);

760: hr_utility.set_location('Assignment ID :'||l_assignment_id, 15);
761: hr_utility.set_location('Assignment Number: '||l_assignment_number, 15);
762: hr_utility.set_location('Party ID: '||l_party_id, 15);
763: hr_utility.set_location('Person ID: '||l_person_id, 15);
764: hr_utility.set_location('Element Name: '||l_element_name, 15);
765: end if;
766: -- If no more students left then, exit.
767: exit when pri_cur%notfound;
768:

Line 772: hr_utility.set_location('Create the BEE header', 16);

768:
769: -- Create the BEE header and set the flag value to true.
770: if not l_batch_header_created then
771:
772: hr_utility.set_location('Create the BEE header', 16);
773: -- Create the Batch Element Entry Header need execute this code only once.
774: pay_batch_element_entry_api.create_batch_header
775: (p_session_date => l_effective_date
776: ,p_batch_name => 'OSS Batch '||rtrim(fnd_global.conc_request_id)

Line 845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);

841: --
842: exit when stu_cur%notfound;
843: --
844: if g_debug then
845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);
846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);

Line 846: hr_utility.set_location('Amount: '||l_auth_amt, 20);

842: exit when stu_cur%notfound;
843: --
844: if g_debug then
845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);
846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);
850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);

Line 847: hr_utility.set_location('FundId: '||l_fund_id, 20);

843: --
844: if g_debug then
845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);
846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);
850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);
851: end if;

Line 848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);

844: if g_debug then
845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);
846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);
850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);
851: end if;
852: --

Line 849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);

845: hr_utility.set_location('Authorization ID: '||l_auth_id, 20);
846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);
850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);
851: end if;
852: --
853: if stu_cur%found then

Line 850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);

846: hr_utility.set_location('Amount: '||l_auth_amt, 20);
847: hr_utility.set_location('FundId: '||l_fund_id, 20);
848: hr_utility.set_location('Auth Start Date: '||l_st_date, 20);
849: hr_utility.set_location('SSN: '||l_stusys_ssn, 20);
850: hr_utility.set_location('Auth End Date: '||l_end_date, 20);
851: end if;
852: --
853: if stu_cur%found then
854: -- Get assignment details in case if the selection criteria

Line 866: hr_utility.set_location('Assign input values from OSS: ', 25);

862: l_assignment_id := c1.assignment_id;
863: l_assignment_number := c1.assignment_number;
864: end loop;
865: end if;
866: hr_utility.set_location('Assign input values from OSS: ', 25);
867: -- Assign the proper values to each input value of the element entry
868: for i in 1..15
869: loop
870: if l_ipv(i).name = 'Amount' then

Line 920: hr_utility.set_location('Calling : PAY_Batch_Element_Entry_API.Create_Batch_Line', 26);

916: );
917: If not l_award_paid Then
918: -- Increment the batch sequence
919: l_ct := l_ct + 1;
920: hr_utility.set_location('Calling : PAY_Batch_Element_Entry_API.Create_Batch_Line', 26);
921: PAY_Batch_Element_Entry_API.Create_Batch_Line
922: (p_session_date => l_effective_date
923: ,p_batch_id => l_new_batch
924: ,p_assignment_id => l_assignment_id

Line 951: hr_utility.set_location('Re-set the entry values for next record ', 27);

947: ,p_object_version_number=> l_object_version_number
948: );
949: End If;
950: end if; --if stu_cur%found
951: hr_utility.set_location('Re-set the entry values for next record ', 27);
952: for i in 1..15
953: loop
954: l_ipv(i).screen_entry_value := null;
955: end loop;

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

958:
959: end loop;
960: close pri_cur;
961:
962: hr_utility.set_location('leaving: '||l_proc_name, 80);
963: -- Commit the records in the BEE tables.
964: commit;
965:
966: exception

Line 969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);

965:
966: exception
967: when others then
968: l_error_msg := sqlerrm;
969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
973: Hr_Utility.raise_error;

Line 970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

966: exception
967: when others then
968: l_error_msg := sqlerrm;
969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
973: Hr_Utility.raise_error;
974:

Line 971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );

967: when others then
968: l_error_msg := sqlerrm;
969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
973: Hr_Utility.raise_error;
974:
975:

Line 972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

968: l_error_msg := sqlerrm;
969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
973: Hr_Utility.raise_error;
974:
975:
976: end Create_Student_Batch_Entry;

Line 973: Hr_Utility.raise_error;

969: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
970: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
971: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
972: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
973: Hr_Utility.raise_error;
974:
975:
976: end Create_Student_Batch_Entry;
977: