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

Line 163: hr_utility.set_location('Entering: '||l_proc, 10);

159: AND business_group_id is NULL;
160: --
161: BEGIN
162: --
163: hr_utility.set_location('Entering: '||l_proc, 10);
164: --
165: l_template_name := 'PQP PROFESSIONAL BODY';
166: --
167: hr_utility.set_location(l_proc, 20);

Line 167: hr_utility.set_location(l_proc, 20);

163: hr_utility.set_location('Entering: '||l_proc, 10);
164: --
165: l_template_name := 'PQP PROFESSIONAL BODY';
166: --
167: hr_utility.set_location(l_proc, 20);
168: --
169: for csr_get_temp_id_rec in csr_get_temp_id loop
170: l_template_id := csr_get_temp_id_rec.template_id;
171: end loop;

Line 173: hr_utility.set_location('Leaving: '||l_proc, 30);

169: for csr_get_temp_id_rec in csr_get_temp_id loop
170: l_template_id := csr_get_temp_id_rec.template_id;
171: end loop;
172: --
173: hr_utility.set_location('Leaving: '||l_proc, 30);
174: --
175: RETURN l_template_id;
176: --
177: END get_template_id;

Line 206: hr_utility.set_location('Entering: '||l_proc, 10);

202: l_proc varchar2(80) := 'pqp_gb_professional_body_temp.get_balance_dimension_id';
203:
204: BEGIN
205:
206: hr_utility.set_location('Entering: '||l_proc, 10);
207: --
208: FOR csr_id_baldmn_rec IN csr_id_baldmn LOOP
209: l_bd_baldmn_id := csr_id_baldmn_rec.balance_dimension_id;
210: END LOOP;

Line 212: hr_utility.set_location('Leaving: '||l_proc, 20);

208: FOR csr_id_baldmn_rec IN csr_id_baldmn LOOP
209: l_bd_baldmn_id := csr_id_baldmn_rec.balance_dimension_id;
210: END LOOP;
211: --
212: hr_utility.set_location('Leaving: '||l_proc, 20);
213:
214: --
215:
216: RETURN l_bd_baldmn_id;

Line 258: hr_utility.set_location('Entering: '||l_proc, 10);

254: AND ptco.core_object_type = p_object_type;
255: --
256: BEGIN
257:
258: hr_utility.set_location('Entering: '||l_proc, 10);
259: --
260: if p_object_type = 'ELE' then
261: for csr_get_ele_type_id_rec in csr_get_ele_type_id (p_object_name) loop
262: l_object_id := csr_get_ele_type_id_rec.element_type_id; -- element id

Line 277: hr_utility.set_location('Leaving: '||l_proc, 20);

273: end if;
274:
275: end if;
276: --
277: hr_utility.set_location('Leaving: '||l_proc, 20);
278: --
279: RETURN l_object_id;
280: --
281: END get_object_id;

Line 288: hr_utility.set_location('Entering : '||l_proc, 10);

284: -- MAIN FUNCTION
285: --===============================================================================
286: BEGIN
287:
288: hr_utility.set_location('Entering : '||l_proc, 10);
289: ---------------------
290: -- Set session date
291: ---------------------
292:

Line 295: hr_utility.set_location(l_proc, 20);

291: ---------------------
292:
293: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
294: --
295: hr_utility.set_location(l_proc, 20);
296: --
297:
298: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
299: THEN

Line 298: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))

294: --
295: hr_utility.set_location(l_proc, 20);
296: --
297:
298: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
299: THEN
300:
301: ---------------------------
302: -- Get Source Template ID

Line 316: hr_utility.set_location(l_proc, 30);

312: Config1 --
313: Config2 --
314: ---------------------------------------------------------------------------*/
315:
316: hr_utility.set_location(l_proc, 30);
317:
318: l_override_amount := 'N';
319: i := 0;
320:

Line 353: hr_utility.set_location(l_proc, 40);

349: ,p_object_version_number => l_object_version_number
350: );
351: --
352:
353: hr_utility.set_location(l_proc, 40);
354: ---------------------------------------------------------------------------
355: ---------------------------- Update Shadow Structure ----------------------
356: --
357:

Line 381: hr_utility.set_location(l_proc, 50);

377:
378: -------------------------------------------------------------------------
379: --
380: --
381: hr_utility.set_location(l_proc, 50);
382: ---------------------------------------------------------------------------
383: ---------------------------- Generate Core Objects ------------------------
384: ---------------------------------------------------------------------------
385:

Line 393: hr_utility.set_location(l_proc, 60);

389: ,p_hr_only => false
390: ,p_hr_to_payroll => false
391: ,p_template_id => l_template_id);
392: --
393: hr_utility.set_location(l_proc, 60);
394: --
395: pay_element_template_api.generate_part2
396: (p_validate => false
397: ,p_effective_date => p_ele_eff_start_date

Line 401: hr_utility.set_location(l_proc, 70);

397: ,p_effective_date => p_ele_eff_start_date
398: ,p_template_id => l_template_id);
399: --
400:
401: hr_utility.set_location(l_proc, 70);
402:
403: l_ele_core_id := get_object_id (p_object_type => 'ELE'
404: ,p_object_name => p_ele_name
405: );

Line 407: hr_utility.set_location(l_proc, 80);

403: l_ele_core_id := get_object_id (p_object_type => 'ELE'
404: ,p_object_name => p_ele_name
405: );
406:
407: hr_utility.set_location(l_proc, 80);
408:
409: IF p_professional_body_level_yn = 'N' THEN
410: --
411: -- If this is the first time that the driver is being run for an element

Line 474: hr_utility.set_location(l_proc, 90);

470: ,X_Attribute20 => NULL -- VARCHAR2
471: ,X_balance_category_id => l_balance_category_id
472: );
473:
474: hr_utility.set_location(l_proc, 90);
475:
476: -- now create the defined balances also for _ASG_RUN/PROC_PTD/STAT_YTD
477:
478: l_dim(1) := '_ASG_RUN';

Line 507: hr_utility.set_location(l_proc, 100);

503: ELSE -- this is not the first run
504:
505: -- so query out the core balance type id for the given balance name
506:
507: hr_utility.set_location(l_proc, 100);
508:
509: OPEN csr_get_pb_balid;
510: FETCH csr_get_pb_balid INTO csr_get_pb_balid_rec;
511: IF csr_get_pb_balid%NOTFOUND THEN

Line 514: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');

510: FETCH csr_get_pb_balid INTO csr_get_pb_balid_rec;
511: IF csr_get_pb_balid%NOTFOUND THEN
512: --
513: CLOSE csr_get_pb_balid;
514: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');
515: hr_utility.raise_error;
516:
517: ELSE
518:

Line 515: hr_utility.raise_error;

511: IF csr_get_pb_balid%NOTFOUND THEN
512: --
513: CLOSE csr_get_pb_balid;
514: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');
515: hr_utility.raise_error;
516:
517: ELSE
518:
519: l_bl_core_id := csr_get_pb_balid_rec.balance_type_id;

Line 526: hr_utility.set_location(l_proc, 110);

522: CLOSE csr_get_pb_balid;
523:
524: END IF;
525:
526: hr_utility.set_location(l_proc, 110);
527:
528: OPEN csr_get_ivid(l_element_type_id, 'Pay Value');
529: FETCH csr_get_ivid INTO csr_get_ivid_rec;
530: CLOSE csr_get_ivid;

Line 532: hr_utility.set_location(l_proc, 120);

528: OPEN csr_get_ivid(l_element_type_id, 'Pay Value');
529: FETCH csr_get_ivid INTO csr_get_ivid_rec;
530: CLOSE csr_get_ivid;
531:
532: hr_utility.set_location(l_proc, 120);
533:
534: l_iv_core_id := get_object_id
535: (p_object_type => 'IV'
536: ,p_object_name => 'Pay Value' -- dummy

Line 542: hr_utility.set_message(8303, 'PQP_230539_PBD_GENERATE_FAILED');

538: );
539:
540: IF l_iv_core_id IS NULL OR l_ele_core_id IS NULL THEN
541: -- Error Out
542: hr_utility.set_message(8303, 'PQP_230539_PBD_GENERATE_FAILED');
543: hr_utility.raise_error;
544:
545: ELSE
546:

Line 543: hr_utility.raise_error;

539:
540: IF l_iv_core_id IS NULL OR l_ele_core_id IS NULL THEN
541: -- Error Out
542: hr_utility.set_message(8303, 'PQP_230539_PBD_GENERATE_FAILED');
543: hr_utility.raise_error;
544:
545: ELSE
546:
547: hr_utility.set_location(l_proc, 130);

Line 547: hr_utility.set_location(l_proc, 130);

543: hr_utility.raise_error;
544:
545: ELSE
546:
547: hr_utility.set_location(l_proc, 130);
548:
549: l_xx_rowid_id := NULL;
550: pay_balance_feeds_f_pkg.insert_row
551: (x_rowid => l_xx_rowid_id -- IN OUT VARCHAR2,

Line 566: hr_utility.set_location(l_proc, 140);

562:
563:
564: END IF; -- IF any core id is null THEN
565:
566: hr_utility.set_location(l_proc, 140);
567:
568: --
569: -- Retrieve organization id for the organization name
570: --

Line 579: hr_utility.set_message(8303, 'PQP_230537_PBD_ORG_NOT_FOUND');

575: IF csr_get_orgid%NOTFOUND THEN
576:
577: -- Error Out
578: CLOSE csr_get_orgid;
579: hr_utility.set_message(8303, 'PQP_230537_PBD_ORG_NOT_FOUND');
580: hr_utility.raise_error;
581:
582: END IF; -- Organization id not found chk...
583: CLOSE csr_get_orgid;

Line 580: hr_utility.raise_error;

576:
577: -- Error Out
578: CLOSE csr_get_orgid;
579: hr_utility.set_message(8303, 'PQP_230537_PBD_ORG_NOT_FOUND');
580: hr_utility.raise_error;
581:
582: END IF; -- Organization id not found chk...
583: CLOSE csr_get_orgid;
584:

Line 585: hr_utility.set_location(l_proc, 160);

581:
582: END IF; -- Organization id not found chk...
583: CLOSE csr_get_orgid;
584:
585: hr_utility.set_location(l_proc, 160);
586:
587: l_base_element_type_id := get_object_id ('ELE', p_ele_name);
588:
589: hr_utility.set_location(l_proc, 170);

Line 589: hr_utility.set_location(l_proc, 170);

585: hr_utility.set_location(l_proc, 160);
586:
587: l_base_element_type_id := get_object_id ('ELE', p_ele_name);
588:
589: hr_utility.set_location(l_proc, 170);
590:
591: -- Create a row in pay_element_extra_info with all the element information
592:
593: pay_element_extra_info_api.create_element_extra_info

Line 607: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');

603: ,p_object_version_number => l_ovn_eei);
604:
605: ELSE
606:
607: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
608: hr_utility.raise_error;
609:
610:
611: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))

Line 608: hr_utility.raise_error;

604:
605: ELSE
606:
607: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
608: hr_utility.raise_error;
609:
610:
611: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
612:

Line 613: hr_utility.set_location('Leaving :'||l_proc, 180);

609:
610:
611: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
612:
613: hr_utility.set_location('Leaving :'||l_proc, 180);
614:
615: RETURN l_base_element_type_id;
616:
617: --

Line 705: hr_utility.set_location('Entering :'||l_proc, 10);

701:
702: --
703: BEGIN
704: --
705: hr_utility.set_location('Entering :'||l_proc, 10);
706:
707: --
708: FOR csr_get_template_id_rec IN csr_get_template_id LOOP
709: l_template_id := csr_get_template_id_rec.template_id;

Line 712: hr_utility.set_location(l_proc, 20);

708: FOR csr_get_template_id_rec IN csr_get_template_id LOOP
709: l_template_id := csr_get_template_id_rec.template_id;
710: END LOOP;
711:
712: hr_utility.set_location(l_proc, 20);
713:
714: --
715: -- Check to see if there are other user structures for the given template.
716: -- If there are then check to see if they have they belong to the same

Line 731: hr_utility.set_location(l_proc, 30);

727: --
728: IF csr_get_other_tempid%FOUND THEN
729: LOOP
730:
731: hr_utility.set_location(l_proc, 30);
732:
733: OPEN csr_get_orginfo(csr_get_other_tempid_rec.template_id);
734: FETCH csr_get_orginfo INTO csr_get_orginfo_rec;
735: CLOSE csr_get_orginfo;

Line 737: hr_utility.set_location(l_proc, 40);

733: OPEN csr_get_orginfo(csr_get_other_tempid_rec.template_id);
734: FETCH csr_get_orginfo INTO csr_get_orginfo_rec;
735: CLOSE csr_get_orginfo;
736:
737: hr_utility.set_location(l_proc, 40);
738:
739: OPEN csr_get_orgid(csr_get_orginfo_rec.pbd_org_id);
740: FETCH csr_get_orgid INTO csr_get_orgid_rec;
741: IF csr_get_orgid%FOUND THEN

Line 749: hr_utility.set_location(l_proc, 50);

745: -- the balance cannot be deleted.
746: END IF;
747: CLOSE csr_get_orgid;
748:
749: hr_utility.set_location(l_proc, 50);
750:
751: FETCH csr_get_other_tempid INTO csr_get_other_tempid_rec;
752: EXIT WHEN csr_get_other_tempid%NOTFOUND;
753: END LOOP;

Line 758: hr_utility.set_location(l_proc, 60);

754: --
755: END IF;
756: CLOSE csr_get_other_tempid;
757:
758: hr_utility.set_location(l_proc, 60);
759:
760: IF l_del_pbd_level_balance_yn = 'Y' THEN
761: --
762: -- Delete the professional body level balance also.

Line 770: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');

766: FETCH csr_get_pb_balid INTO csr_get_pb_balid_rec;
767: IF csr_get_pb_balid%NOTFOUND THEN
768: --
769: CLOSE csr_get_pb_balid;
770: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');
771: hr_utility.raise_error;
772: --
773: END IF;
774: CLOSE csr_get_pb_balid;

Line 771: hr_utility.raise_error;

767: IF csr_get_pb_balid%NOTFOUND THEN
768: --
769: CLOSE csr_get_pb_balid;
770: hr_utility.set_message(8303, 'PQP_230538_PBDBAL_NOT_FOUND');
771: hr_utility.raise_error;
772: --
773: END IF;
774: CLOSE csr_get_pb_balid;
775:

Line 776: hr_utility.set_location(l_proc, 70);

772: --
773: END IF;
774: CLOSE csr_get_pb_balid;
775:
776: hr_utility.set_location(l_proc, 70);
777:
778: pay_balance_types_pkg.delete_row
779: (x_rowid => csr_get_pb_balid_rec.rowid -- VARCHAR2
780: ,x_balance_type_id => csr_get_pb_balid_rec.balance_type_id -- NUMBER

Line 785: hr_utility.set_location(l_proc, 80);

781: );
782:
783: END IF;
784:
785: hr_utility.set_location(l_proc, 80);
786: --
787: OPEN eei;
788: LOOP
789: FETCH eei INTO l_eei_info_id ;

Line 803: hr_utility.set_location(l_proc, 90);

799: END LOOP;
800: CLOSE eei;
801:
802: --
803: hr_utility.set_location(l_proc, 90);
804:
805: pay_element_template_api.delete_user_structure
806: (p_validate => false
807: ,p_drop_formula_packages => true

Line 811: hr_utility.set_location('Leaving :'||l_proc, 100);

807: ,p_drop_formula_packages => true
808: ,p_template_id => l_template_id);
809: --
810:
811: hr_utility.set_location('Leaving :'||l_proc, 100);
812: --
813: END delete_user_template;
814: --
815: END pqp_gb_professional_body_temp;