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

Line 171: hr_utility.set_location('Entering : '||l_proc_name, 10);

167: l_proc_name VARCHAR2(150) := g_proc_name ||'Chk_Neg_Amt';
168: csr_asg_rec csr_asg%ROWTYPE;
169:
170: BEGIN
171: hr_utility.set_location('Entering : '||l_proc_name, 10);
172: FOR rpt_rec IN csr_rpt
173: LOOP
174: OPEN csr_asg (c_payroll_action_id => p_payroll_action_id
175: ,c_assignment_id => rpt_rec.attribute5

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

186: END IF;
187: CLOSE csr_asg;
188: COMMIT;
189: END LOOP;
190: hr_utility.set_location('Leaving : '||l_proc_name, 90);
191: EXCEPTION
192: WHEN others THEN
193: hr_utility.set_location('..Error in Chk_Neg_Amt :' ||SQLERRM,150);
194: hr_utility.set_location('Leaving : '||l_proc_name, 150);

Line 193: hr_utility.set_location('..Error in Chk_Neg_Amt :' ||SQLERRM,150);

189: END LOOP;
190: hr_utility.set_location('Leaving : '||l_proc_name, 90);
191: EXCEPTION
192: WHEN others THEN
193: hr_utility.set_location('..Error in Chk_Neg_Amt :' ||SQLERRM,150);
194: hr_utility.set_location('Leaving : '||l_proc_name, 150);
195: RAISE;
196: END Chk_Neg_Amt;
197:

Line 194: hr_utility.set_location('Leaving : '||l_proc_name, 150);

190: hr_utility.set_location('Leaving : '||l_proc_name, 90);
191: EXCEPTION
192: WHEN others THEN
193: hr_utility.set_location('..Error in Chk_Neg_Amt :' ||SQLERRM,150);
194: hr_utility.set_location('Leaving : '||l_proc_name, 150);
195: RAISE;
196: END Chk_Neg_Amt;
197:
198: -- ---------------------------------------------------------------------

Line 218: hr_utility.set_location('Entering : '||l_proc_name, 10);

214: l_proc_name VARCHAR2(150) := g_proc_name ||'insert_rpt_data';
215: i per_assignments_f.assignment_id%TYPE;
216:
217: BEGIN
218: hr_utility.set_location('Entering : '||l_proc_name, 10);
219: -- Check if for the assignment id if there are any non-zero balances
220: i := p_assignment_id;
221: IF ins_val_t.EXISTS(i) THEN
222: IF ins_val_t(i).assignment_id = p_assignment_id AND

Line 243: hr_utility.set_location('..After the check if atleast one balance is <> 0', 15);

239: END IF;
240: END IF;
241: END IF;
242:
243: hr_utility.set_location('..After the check if atleast one balance is <> 0', 15);
244: IF l_insert_valid THEN
245: hr_utility.set_location('..Valid for Assignment : '||p_assignment_id, 20);
246: INSERT INTO pay_us_rpt_totals
247: (tax_unit_id,

Line 245: hr_utility.set_location('..Valid for Assignment : '||p_assignment_id, 20);

241: END IF;
242:
243: hr_utility.set_location('..After the check if atleast one balance is <> 0', 15);
244: IF l_insert_valid THEN
245: hr_utility.set_location('..Valid for Assignment : '||p_assignment_id, 20);
246: INSERT INTO pay_us_rpt_totals
247: (tax_unit_id,
248: gre_name,
249: organization_name,

Line 322: hr_utility.set_location('..Inserted for assignment :'||p_assignment_id, 25);

318: ins_val_t(i).balance_value6, --value7
319: ins_val_t(i).assignment_action_id, --organization_id
320: l_chunk_no, --value8
321: ins_val_t(i).payroll_id ); --value9
322: hr_utility.set_location('..Inserted for assignment :'||p_assignment_id, 25);
323: END IF; -- IF l_insert_valid Then
324: -- Delete all the records from the PL/SQL table for the assignment id
325: hr_utility.set_location('..After Inserting into pay_us_rpt_totals ', 70);
326:

Line 325: hr_utility.set_location('..After Inserting into pay_us_rpt_totals ', 70);

321: ins_val_t(i).payroll_id ); --value9
322: hr_utility.set_location('..Inserted for assignment :'||p_assignment_id, 25);
323: END IF; -- IF l_insert_valid Then
324: -- Delete all the records from the PL/SQL table for the assignment id
325: hr_utility.set_location('..After Inserting into pay_us_rpt_totals ', 70);
326:
327: IF ins_val_t.EXISTS(i) THEN
328: ins_val_t.DELETE(i);
329: hr_utility.set_location('..Deleting for Assg ID : '||p_assignment_id,75);

Line 329: hr_utility.set_location('..Deleting for Assg ID : '||p_assignment_id,75);

325: hr_utility.set_location('..After Inserting into pay_us_rpt_totals ', 70);
326:
327: IF ins_val_t.EXISTS(i) THEN
328: ins_val_t.DELETE(i);
329: hr_utility.set_location('..Deleting for Assg ID : '||p_assignment_id,75);
330: END IF;
331: l_err_msg := NULL;
332: l_err_num := NULL;
333:

Line 334: hr_utility.set_location('..After Deleting rows from PL/SQL table', 80);

330: END IF;
331: l_err_msg := NULL;
332: l_err_num := NULL;
333:
334: hr_utility.set_location('..After Deleting rows from PL/SQL table', 80);
335: hr_utility.set_location('Leaving : '||l_proc_name, 90);
336:
337: EXCEPTION
338: WHEN OTHERS THEN

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

331: l_err_msg := NULL;
332: l_err_num := NULL;
333:
334: hr_utility.set_location('..After Deleting rows from PL/SQL table', 80);
335: hr_utility.set_location('Leaving : '||l_proc_name, 90);
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: hr_utility.set_location('..Error in Insert_Rpt_Data :' ||SQLERRM,150);

Line 339: hr_utility.set_location('..Error in Insert_Rpt_Data :' ||SQLERRM,150);

335: hr_utility.set_location('Leaving : '||l_proc_name, 90);
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: hr_utility.set_location('..Error in Insert_Rpt_Data :' ||SQLERRM,150);
340: hr_utility.set_location('Leaving : '||l_proc_name, 150);
341: RAISE;
342:
343: END insert_rpt_data;

Line 340: hr_utility.set_location('Leaving : '||l_proc_name, 150);

336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: hr_utility.set_location('..Error in Insert_Rpt_Data :' ||SQLERRM,150);
340: hr_utility.set_location('Leaving : '||l_proc_name, 150);
341: RAISE;
342:
343: END insert_rpt_data;
344:

Line 373: hr_utility.set_location('Entering : '||l_proc_name, 10);

369: l_proc_name VARCHAR2(150) := g_proc_name ||'load_balances';
370: i per_all_assignments_f.assignment_id%TYPE;
371:
372: BEGIN
373: hr_utility.set_location('Entering : '||l_proc_name, 10);
374: IF l_org_ppg IS NULL AND
375: l_asg_ppg_code IS NULL AND
376: l_ppg_billing IS NULL THEN
377: l_err_num := '999';

Line 382: hr_utility.set_location('..Set the tax and date earned contexts ', 15);

378: l_err_msg := 'PPG CODE REQUIRED';
379: END IF;
380:
381: -- set the date earned and tax unit id context for the balance pkg
382: hr_utility.set_location('..Set the tax and date earned contexts ', 15);
383: pay_balance_pkg.set_context('tax_unit_id',l_tax_unit_id);
384:
385: hr_utility.set_location('..No. of def. balances : '||g_balance_rec.count, 20);
386:

Line 385: hr_utility.set_location('..No. of def. balances : '||g_balance_rec.count, 20);

381: -- set the date earned and tax unit id context for the balance pkg
382: hr_utility.set_location('..Set the tax and date earned contexts ', 15);
383: pay_balance_pkg.set_context('tax_unit_id',l_tax_unit_id);
384:
385: hr_utility.set_location('..No. of def. balances : '||g_balance_rec.count, 20);
386:
387: FOR i_bals IN 1..g_balance_rec.count
388: LOOP
389: l_defined_balance_id := g_balance_rec(i_bals).defined_balance_id;

Line 396: hr_utility.set_location('..Balance name : '||l_balance_name, 25);

392: -- Get the value for each of the def. balance id for the given assig. action
393: l_balance_end := pay_balance_pkg.get_value
394: (p_defined_balance_id => l_defined_balance_id,
395: p_assignment_action_id => p_assignment_action_id );
396: hr_utility.set_location('..Balance name : '||l_balance_name, 25);
397:
398: l_balance := NVL(l_balance_end,0);
399: l_update_flag := FALSE;
400: i := p_assignment_id;

Line 429: hr_utility.set_location('..New balance for the same assignment id :'||l_balance_name, 25);

425: ins_val_t(i).balance_value6 := ins_val_t(i).balance_value6 + l_balance;
426: l_update_flag := TRUE;
427: END IF;
428: IF NOT l_update_flag THEN
429: hr_utility.set_location('..New balance for the same assignment id :'||l_balance_name, 25);
430: IF l_balance_name = 'RA GRA PLAN BY INST' THEN
431: ins_val_t(i).balance_name1 := l_balance_name;
432: ins_val_t(i).balance_value1 := l_balance;
433: ELSIF l_balance_name = 'RA GRA PLAN REDUCT' THEN

Line 464: hr_utility.set_location('..After Checking the PL/SQL table ', 40);

460: ins_val_t(i).input_start_date := l_input_start_date;
461: ins_val_t(i).payroll_id := l_ld_payroll_id;
462: END IF;
463: END IF;
464: hr_utility.set_location('..After Checking the PL/SQL table ', 40);
465:
466: IF NOT l_update_flag THEN
467: i := p_assignment_id;
468: hr_utility.set_location('..Next new index used : '||i, 40);

Line 468: hr_utility.set_location('..Next new index used : '||i, 40);

464: hr_utility.set_location('..After Checking the PL/SQL table ', 40);
465:
466: IF NOT l_update_flag THEN
467: i := p_assignment_id;
468: hr_utility.set_location('..Next new index used : '||i, 40);
469: ins_val_t(i).assignment_id := p_assignment_id;
470: ins_val_t(i).assignment_action_id := p_assignment_action_id;
471:
472: IF l_balance_name = 'RA GRA PLAN BY INST' THEN

Line 517: hr_utility.set_location('..After looping thru g_balance_rec PL/SQL table ', 85);

513: END IF;
514: END IF;
515: END LOOP; --For i_bals in 1..g_balance_rec.count
516:
517: hr_utility.set_location('..After looping thru g_balance_rec PL/SQL table ', 85);
518: hr_utility.set_location('Leaving : '||l_proc_name, 90);
519: EXCEPTION
520: WHEN OTHERS THEN
521: hr_utility.set_location('..Error:' ||SQLERRM,150);

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

514: END IF;
515: END LOOP; --For i_bals in 1..g_balance_rec.count
516:
517: hr_utility.set_location('..After looping thru g_balance_rec PL/SQL table ', 85);
518: hr_utility.set_location('Leaving : '||l_proc_name, 90);
519: EXCEPTION
520: WHEN OTHERS THEN
521: hr_utility.set_location('..Error:' ||SQLERRM,150);
522: hr_utility.set_location('Leaving : '||l_proc_name, 150);

Line 521: hr_utility.set_location('..Error:' ||SQLERRM,150);

517: hr_utility.set_location('..After looping thru g_balance_rec PL/SQL table ', 85);
518: hr_utility.set_location('Leaving : '||l_proc_name, 90);
519: EXCEPTION
520: WHEN OTHERS THEN
521: hr_utility.set_location('..Error:' ||SQLERRM,150);
522: hr_utility.set_location('Leaving : '||l_proc_name, 150);
523: RAISE;
524: END load_balances;
525:

Line 522: hr_utility.set_location('Leaving : '||l_proc_name, 150);

518: hr_utility.set_location('Leaving : '||l_proc_name, 90);
519: EXCEPTION
520: WHEN OTHERS THEN
521: hr_utility.set_location('..Error:' ||SQLERRM,150);
522: hr_utility.set_location('Leaving : '||l_proc_name, 150);
523: RAISE;
524: END load_balances;
525:
526: -- ---------------------------------------------------------------------

Line 562: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);

558: CLOSE c_ppg_billing;
559: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN
562: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);
563: END ppg_billing;
564:
565: -- ---------------------------------------------------------------------
566: -- |---------------------------< pay_mode >-----------------------------|

Line 615: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);

611: END IF;
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);
616: END pay_mode;
617:
618: -- ---------------------------------------------------------------------
619: -- |------------------------< load_asg_ppg >----------------------------|

Line 644: hr_utility.trace('Error occurred load_asg_ppg ...' ||SQLERRM);

640: END LOOP;
641: CLOSE asg_ppg;
642: EXCEPTION
643: WHEN OTHERS THEN
644: hr_utility.trace('Error occurred load_asg_ppg ...' ||SQLERRM);
645: END load_asg_ppg;
646:
647: -- ---------------------------------------------------------------------
648: -- |------------------------< load_details >----------------------------|

Line 714: hr_utility.trace('Error occurred load_details ...' ||SQLERRM);

710:
711: EXCEPTION
712: WHEN OTHERS THEN
713: msg1:=SQLERRM;
714: hr_utility.trace('Error occurred load_details ...' ||SQLERRM);
715: END load_details;
716: -- ---------------------------------------------------------------------
717: -- |------------------------< load_org_ppg >----------------------------|
718: -- ---------------------------------------------------------------------

Line 748: hr_utility.trace('Error occurred load_org_ppg ...' ||SQLERRM);

744: CLOSE c_org_ppg;
745: END IF;
746: EXCEPTION
747: WHEN OTHERS THEN
748: hr_utility.trace('Error occurred load_org_ppg ...' ||SQLERRM);
749: END load_org_ppg;
750:
751: -- ---------------------------------------------------------------------
752: -- |-------------------------< load_data >------------------------------|

Line 821: hr_utility.set_location('Entering : '||l_proc_name, 10);

817: l_count NUMBER(5);
818: l_proc_name VARCHAR2(150) := g_proc_name ||'load_data';
819:
820: BEGIN
821: hr_utility.set_location('Entering : '||l_proc_name, 10);
822: l_chunk_no := chnkno;
823: BEGIN
824: SELECT ppa.legislative_parameters,
825: ppa.business_group_id,

Line 845: hr_utility.set_location('..Legislative Details not found...',30);

841: WHERE ppa.payroll_action_id = pactid;
842:
843: EXCEPTION
844: WHEN NO_DATA_FOUND THEN
845: hr_utility.set_location('..Legislative Details not found...',30);
846: RAISE;
847: END;
848:
849: IF chnkno = 1 THEN

Line 866: hr_utility.set_location('..Store the balances in the PL/SQL table',35);

862: --
863: -- Store all the six balances in a PL/SQL as they would be the same for
864: -- all assignments.
865: --
866: hr_utility.set_location('..Store the balances in the PL/SQL table',35);
867: l_count := 1;
868: FOR bal_rec IN c1
869: LOOP
870: g_balance_rec(l_count).defined_balance_id := bal_rec.defined_balance_id;

Line 874: hr_utility.set_location('..Open and loop thru the SEL_AAID Cursor',40);

870: g_balance_rec(l_count).defined_balance_id := bal_rec.defined_balance_id;
871: g_balance_rec(l_count).balance_name := bal_rec.balance_name;
872: l_count := l_count + 1;
873: END LOOP;
874: hr_utility.set_location('..Open and loop thru the SEL_AAID Cursor',40);
875: OPEN sel_aaid (TO_NUMBER(pactid),chnkno);
876: LOOP
877: FETCH sel_aaid INTO l_assignment_id,
878: l_start_date,

Line 894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);

890: l_assignment_action_id,
891: l_ld_payroll_id;
892: EXIT WHEN sel_aaid%NOTFOUND;
893:
894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);
895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);

Line 895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);

891: l_ld_payroll_id;
892: EXIT WHEN sel_aaid%NOTFOUND;
893:
894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);
895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);

Line 896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);

892: EXIT WHEN sel_aaid%NOTFOUND;
893:
894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);
895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);

Line 897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);

893:
894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);
895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);

Line 898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);

894: hr_utility.set_location('..Chunk No = '||TO_CHAR(chnkno),50);
895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);

Line 899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);

895: hr_utility.set_location('..PPA_FINDER = '||ppa_finder,25);
896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);

Line 900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);

896: hr_utility.set_location('..Start Date = '||TO_CHAR(l_start_date),50);
897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);

Line 901: hr_utility.set_location('..Action Type = '||l_action_type,50);

897: hr_utility.set_location('..End Date = '||TO_CHAR(l_end_date),50);
898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);

Line 902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);

898: hr_utility.set_location('..BG ID = '||TO_CHAR(l_business_group_id),50);
899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);

Line 903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);

899: hr_utility.set_location('..Payroll Action ID = '||TO_CHAR(l_payroll_action_id),50);
900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);

Line 904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);

900: hr_utility.set_location('..Effective Date = '||TO_CHAR(l_effective_date),50);
901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);

Line 905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);

901: hr_utility.set_location('..Action Type = '||l_action_type,50);
902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);
909: hr_utility.set_location('..Loc Code = '||l_location_code,50);

Line 906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);

902: hr_utility.set_location('..Asg Act ID = '||TO_CHAR(l_assignment_action_id),50);
903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);
909: hr_utility.set_location('..Loc Code = '||l_location_code,50);
910:

Line 907: hr_utility.set_location('..ORG Name = '||l_org_name,50);

903: hr_utility.set_location('..Asg ID = '||TO_CHAR(l_assignment_id),50);
904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);
909: hr_utility.set_location('..Loc Code = '||l_location_code,50);
910:
911: -- If its diff. assign. Id then insert into pay_us_rpt_totals for that

Line 908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);

904: hr_utility.set_location('..Tax Unit ID = '||TO_CHAR(l_tax_unit_id),50);
905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);
909: hr_utility.set_location('..Loc Code = '||l_location_code,50);
910:
911: -- If its diff. assign. Id then insert into pay_us_rpt_totals for that
912: -- assignment id.

Line 909: hr_utility.set_location('..Loc Code = '||l_location_code,50);

905: hr_utility.set_location('..GRE Name = '||l_gre_name,50);
906: hr_utility.set_location('..ORG ID = '||TO_CHAR(l_organization_id),50);
907: hr_utility.set_location('..ORG Name = '||l_org_name,50);
908: hr_utility.set_location('..Loc ID = '||TO_CHAR(l_location_id),50);
909: hr_utility.set_location('..Loc Code = '||l_location_code,50);
910:
911: -- If its diff. assign. Id then insert into pay_us_rpt_totals for that
912: -- assignment id.
913: IF l_prev_assignment_id IS NOT NULL AND

Line 916: hr_utility.set_location('..Calling INSERT_RPT_DATA within loop ', 55);

912: -- assignment id.
913: IF l_prev_assignment_id IS NOT NULL AND
914: (l_assignment_id <> l_prev_assignment_id OR
915: l_ld_payroll_id <> l_prev_payroll_id ) THEN
916: hr_utility.set_location('..Calling INSERT_RPT_DATA within loop ', 55);
917: insert_rpt_data (p_assignment_id => l_prev_assignment_id
918: ,p_assignment_action_id => l_prev_assignment_action_id
919: ,p_dimension_name => p_dimension_name
920: ,p_effective_date => l_prev_end_date

Line 946: hr_utility.set_location('..Calling INSERT_RPT_DATA outside loop ', 60);

942: l_row_count := 0;
943: COMMIT;
944: END IF;
945: END LOOP;
946: hr_utility.set_location('..Calling INSERT_RPT_DATA outside loop ', 60);
947: insert_rpt_data (p_assignment_id => l_prev_assignment_id
948: ,p_assignment_action_id => l_prev_assignment_action_id
949: ,p_dimension_name => p_dimension_name
950: ,p_effective_date => l_prev_end_date

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

952:
953: CLOSE sel_aaid;
954: ins_val_t.DELETE;
955: COMMIT;
956: hr_utility.set_location('Leaving : '||l_proc_name, 90);
957: EXCEPTION
958: WHEN others THEN
959: hr_utility.set_location('..Error in LOAD_DATA :' ||SQLERRM,150);
960: hr_utility.set_location('Leaving : '||l_proc_name, 150);

Line 959: hr_utility.set_location('..Error in LOAD_DATA :' ||SQLERRM,150);

955: COMMIT;
956: hr_utility.set_location('Leaving : '||l_proc_name, 90);
957: EXCEPTION
958: WHEN others THEN
959: hr_utility.set_location('..Error in LOAD_DATA :' ||SQLERRM,150);
960: hr_utility.set_location('Leaving : '||l_proc_name, 150);
961: RAISE;
962: END load_data;
963:

Line 960: hr_utility.set_location('Leaving : '||l_proc_name, 150);

956: hr_utility.set_location('Leaving : '||l_proc_name, 90);
957: EXCEPTION
958: WHEN others THEN
959: hr_utility.set_location('..Error in LOAD_DATA :' ||SQLERRM,150);
960: hr_utility.set_location('Leaving : '||l_proc_name, 150);
961: RAISE;
962: END load_data;
963:
964: END pqp_tiaalod_pkg;