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

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

178: AND business_group_id is NULL;
179: --
180: BEGIN
181: --
182: hr_utility.set_location('Entering: '||l_proc, 10);
183: --
184: l_te_unnddn_nm := 'PQP UNION DEDUCTIONS';
185: --
186: hr_utility.set_location(l_proc, 30);

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

182: hr_utility.set_location('Entering: '||l_proc, 10);
183: --
184: l_te_unnddn_nm := 'PQP UNION DEDUCTIONS';
185: --
186: hr_utility.set_location(l_proc, 30);
187: --
188: FOR rec_te_unnddn IN csr_te_unnddn LOOP
189: l_te_unnddn_id := rec_te_unnddn.template_id;
190: END LOOP;

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

188: FOR rec_te_unnddn IN csr_te_unnddn LOOP
189: l_te_unnddn_id := rec_te_unnddn.template_id;
190: END LOOP;
191: --
192: hr_utility.set_location('Leaving: '||l_proc, 100);
193: --
194: RETURN l_te_unnddn_id;
195: --
196: END get_template_id;

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

355: AND ptco.shadow_object_id = p_shadow_id
356: AND ptco.core_object_type = p_object_type;
357: --
358: BEGIN
359: hr_utility.set_location('Entering: '||l_proc, 10);
360: --
361: IF p_object_type = 'ELE' THEN
362: FOR rec_el_payele IN csr_el_payele(p_object_name) LOOP
363: l_xx_object_id := rec_el_payele.element_type_id; -- element id

Line 377: hr_utility.set_location('Leaving: '||l_proc, 50);

373: END LOOP;
374: END IF;
375: END IF;
376: --
377: hr_utility.set_location('Leaving: '||l_proc, 50);
378: --
379: RETURN l_xx_object_id;
380: --
381: END get_object_id;

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

384: -- MAIN FUNCTION
385: --=============================================================================
386: BEGIN
387:
388: hr_utility.set_location('Entering : '||l_proc, 10);
389: ---------------------
390: -- Set session date
391: ---------------------
392:

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

391: ---------------------
392:
393: pay_db_pay_setup.set_session_date(nvl(p_frm_effective_start_date, sysdate));
394: --
395: hr_utility.set_location(l_proc, 20);
396:
397: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
398: THEN
399:

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

393: pay_db_pay_setup.set_session_date(nvl(p_frm_effective_start_date, sysdate));
394: --
395: hr_utility.set_location(l_proc, 20);
396:
397: IF (hr_utility.chk_product_install('Oracle Payroll',g_template_leg_code))
398: THEN
399:
400: ---------------------------
401: -- Get Source Template ID

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

402: ---------------------------
403: l_te_source_id := get_template_id
404: (p_legislation_code => g_template_leg_code);
405:
406: hr_utility.set_location(l_proc, 30);
407:
408:
409: /*--------------------------------------------------------------------
410: The input values are explained below : V-varchar2, D-Date, N-number

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

445: ,p_template_id => l_te_usrstr_id
446: ,p_object_version_number => l_xx_unnddn_ovn
447: );
448:
449: hr_utility.set_location(l_proc, 40);
450:
451:
452:
453:

Line 487: -- hr_utility.set_message(8303, 'PQP_UNNTEST_FUNDIVLU_NOT_FOUND');

483: FETCH csr_iv_payvlu INTO row_iv_payvlu;
484: -- IF csr_iv_payvlu%NOTFOUND THEN
485: -- --
486: -- --Error Out
487: -- hr_utility.set_message(8303, 'PQP_UNNTEST_FUNDIVLU_NOT_FOUND');
488: -- hr_utility.raise_error;
489: --
490: -- ELSE
491:

Line 488: -- hr_utility.raise_error;

484: -- IF csr_iv_payvlu%NOTFOUND THEN
485: -- --
486: -- --Error Out
487: -- hr_utility.set_message(8303, 'PQP_UNNTEST_FUNDIVLU_NOT_FOUND');
488: -- hr_utility.raise_error;
489: --
490: -- ELSE
491:
492: pay_siv_upd.upd

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

510: );
511: -- END IF; /* IF csr_iv_payvlu%NOTFOUND THEN */
512: CLOSE csr_iv_payvlu;
513:
514: hr_utility.set_location(l_proc, 50);
515:
516:
517:
518: ---------------------------------------------------------------------------

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

525: ,p_hr_only => FALSE
526: ,p_hr_to_payroll => FALSE
527: ,p_template_id => l_te_usrstr_id);
528:
529: hr_utility.set_location(l_proc, 60);
530:
531: pay_element_template_api.generate_part2
532: (p_validate => FALSE
533: ,p_effective_date => p_frm_effective_start_date

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

532: (p_validate => FALSE
533: ,p_effective_date => p_frm_effective_start_date
534: ,p_template_id => l_te_usrstr_id);
535:
536: hr_utility.set_location(l_proc, 70);
537:
538:
539: l_el_core_id := get_object_id (p_object_type => 'ELE'
540: ,p_object_name => p_frm_element_name

Line 664: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');

660: OPEN csr_bl_unnbal;
661: FETCH csr_bl_unnbal INTO row_bl_unnbal;
662: IF csr_bl_unnbal%NOTFOUND THEN
663: --
664: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');
665: hr_utility.raise_error;
666: ELSE
667:
668: l_bl_core_id := row_bl_unnbal.balance_type_id;

Line 665: hr_utility.raise_error;

661: FETCH csr_bl_unnbal INTO row_bl_unnbal;
662: IF csr_bl_unnbal%NOTFOUND THEN
663: --
664: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');
665: hr_utility.raise_error;
666: ELSE
667:
668: l_bl_core_id := row_bl_unnbal.balance_type_id;
669:

Line 680: -- hr_utility.set_message(8303, 'PQP_UNNTEST_PAYIVLU_NOT_FOUND');

676: OPEN csr_iv_payvlu(row_el_unnddn.element_type_id, c_iv_payvlu_nm);
677: FETCH csr_iv_payvlu INTO row_iv_payvlu;
678: -- IF csr_iv_payvlu%NOTFOUND THEN
679: -- --
680: -- hr_utility.set_message(8303, 'PQP_UNNTEST_PAYIVLU_NOT_FOUND');
681: -- hr_utility.raise_error;
682: -- END IF;
683: CLOSE csr_iv_payvlu;
684:

Line 681: -- hr_utility.raise_error;

677: FETCH csr_iv_payvlu INTO row_iv_payvlu;
678: -- IF csr_iv_payvlu%NOTFOUND THEN
679: -- --
680: -- hr_utility.set_message(8303, 'PQP_UNNTEST_PAYIVLU_NOT_FOUND');
681: -- hr_utility.raise_error;
682: -- END IF;
683: CLOSE csr_iv_payvlu;
684:
685:

Line 696: hr_utility.set_message(8303, 'PQP_230533_GENERATE_PART_FAIL');

692:
693:
694: IF l_iv_core_id IS NULL OR l_el_core_id IS NULL THEN
695: -- Error Out
696: hr_utility.set_message(8303, 'PQP_230533_GENERATE_PART_FAIL');
697: hr_utility.raise_error;
698:
699: ELSE
700: l_xx_rowid_id := NULL;

Line 697: hr_utility.raise_error;

693:
694: IF l_iv_core_id IS NULL OR l_el_core_id IS NULL THEN
695: -- Error Out
696: hr_utility.set_message(8303, 'PQP_230533_GENERATE_PART_FAIL');
697: hr_utility.raise_error;
698:
699: ELSE
700: l_xx_rowid_id := NULL;
701: pay_balance_feeds_f_pkg.insert_row

Line 733: -- hr_utility.set_message(8303, 'PQP_UNNTEST_UNNORG_NOT_FOUND');

729: FETCH csr_or_unnorg INTO row_or_unnorg;
730: -- IF csr_or_unnorg%NOTFOUND THEN
731: -- -- Error out, the union does not exist as a organization for the
732: -- -- given business group.
733: -- hr_utility.set_message(8303, 'PQP_UNNTEST_UNNORG_NOT_FOUND');
734: -- hr_utility.raise_error;
735: -- --
736: -- END IF;
737: CLOSE csr_or_unnorg;

Line 734: -- hr_utility.raise_error;

730: -- IF csr_or_unnorg%NOTFOUND THEN
731: -- -- Error out, the union does not exist as a organization for the
732: -- -- given business group.
733: -- hr_utility.set_message(8303, 'PQP_UNNTEST_UNNORG_NOT_FOUND');
734: -- hr_utility.raise_error;
735: -- --
736: -- END IF;
737: CLOSE csr_or_unnorg;
738:

Line 756: hr_utility.set_message(8303, 'PQP_230534_ORGINFO_NOT_FOUND');

752: ,p_ERROR_MESSAGE => l_ERROR_MESSAGE -- OUT VARCHAR2
753: ) <> 0 THEN
754: --
755: -- Error Out
756: hr_utility.set_message(8303, 'PQP_230534_ORGINFO_NOT_FOUND');
757: hr_utility.raise_error;
758: --
759: ELSE
760:

Line 757: hr_utility.raise_error;

753: ) <> 0 THEN
754: --
755: -- Error Out
756: hr_utility.set_message(8303, 'PQP_230534_ORGINFO_NOT_FOUND');
757: hr_utility.raise_error;
758: --
759: ELSE
760:
761: create_table_columns

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

780:
781:
782: ELSE
783:
784: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
785: hr_utility.raise_error;
786:
787:
788: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))

Line 785: hr_utility.raise_error;

781:
782: ELSE
783:
784: hr_utility.set_message(8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
785: hr_utility.raise_error;
786:
787:
788: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
789:

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

890:
891: --
892: BEGIN
893: --
894: hr_utility.set_location('Entering :'||l_proc, 10);
895: --
896: FOR csr_te_unnddn_rec IN csr_te_unnddn LOOP
897: l_te_unnddn_id := csr_te_unnddn_rec.template_id;
898: END LOOP;

Line 944: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');

940: OPEN csr_bt_unnbal;
941: FETCH csr_bt_unnbal INTO row_bt_unnbal;
942: IF csr_bt_unnbal%NOTFOUND THEN
943: --
944: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');
945: hr_utility.raise_error;
946: --
947: END IF;
948: CLOSE csr_bt_unnbal;

Line 945: hr_utility.raise_error;

941: FETCH csr_bt_unnbal INTO row_bt_unnbal;
942: IF csr_bt_unnbal%NOTFOUND THEN
943: --
944: hr_utility.set_message(8303, 'PQP_230532_UNNBAL_NOT_FOUND');
945: hr_utility.raise_error;
946: --
947: END IF;
948: CLOSE csr_bt_unnbal;
949:

Line 978: hr_utility.set_location('Leaving :'||l_proc, 50);

974: ,p_drop_formula_packages => TRUE
975: ,p_template_id => l_te_unnddn_id);
976:
977:
978: hr_utility.set_location('Leaving :'||l_proc, 50);
979: --
980: END delete_user_template;
981: --
982: END pqp_uk_union_template ;