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

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

137: AND business_group_id is NULL;
138: --
139: BEGIN
140: --
141: hr_utility.set_location('Entering: '||l_proc, 10);
142: --
143: l_template_name := 'PQP STAKEHOLDER PENSION';
144: --
145: hr_utility.set_location(l_proc, 30);

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

141: hr_utility.set_location('Entering: '||l_proc, 10);
142: --
143: l_template_name := 'PQP STAKEHOLDER PENSION';
144: --
145: hr_utility.set_location(l_proc, 30);
146: --
147: for c4_rec in c4 loop
148: l_template_id := c4_rec.template_id;
149: end loop;

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

147: for c4_rec in c4 loop
148: l_template_id := c4_rec.template_id;
149: end loop;
150: --
151: hr_utility.set_location('Leaving: '||l_proc, 100);
152: --
153: RETURN l_template_id;
154: --
155: END get_template_id;

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

182: AND ptco.template_id = psbt.template_id
183: AND ptco.shadow_object_id = psbt.balance_type_id;
184: --
185: BEGIN
186: hr_utility.set_location('Entering: '||l_proc, 10);
187: --
188: if p_object_type = 'ELE' then
189: for c2_rec in c2 (p_object_name) loop
190: l_object_id := c2_rec.element_type_id; -- element id

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

194: l_object_id := c3_rec.core_object_id; -- balance id
195: end loop;
196: end if;
197: --
198: hr_utility.set_location('Leaving: '||l_proc, 50);
199: --
200: RETURN l_object_id;
201: --
202: END get_object_id;

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

227:
228:
229: BEGIN
230:
231: hr_utility.set_location('Entering : '||l_proc, 10);
232:
233:
234:
235: --------------------------- Set session date ---------------------------------

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

237: pay_db_pay_setup.set_session_date
238: (NVL(p_frm_ctl_effective_start_date, TRUNC(SYSDATE))
239: );
240:
241: hr_utility.set_location(l_proc, 20);
242:
243:
244:
245: -------------------------- Get Source Template ID ----------------------------

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

247: l_te_source_id := get_template_id
248: (p_legislation_code => 'GB'
249: );
250:
251: hr_utility.set_location(l_proc, 30);
252:
253:
254:
255:

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

304: ,p_template_id => l_te_ustrctr_id -- Returned User Struct ID
305: ,p_object_version_number => l_xx_stkhldr_ovn
306: );
307:
308: hr_utility.set_location(l_proc, 40);
309:
310:
311:
312: ---------------------------- Update Shadow Structure --------------------------

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

331: );
332: -- END LOOP;
333: CLOSE csr_el_stkhldr_details;
334:
335: hr_utility.set_location(l_proc, 50);
336:
337:
338: -- Update the input values of the base element with user defaults.
339:

Line 345: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');

341: OPEN csr_iv_emecntr(row_el_stkhldr_details.element_type_id);
342: FETCH csr_iv_emecntr INTO row_iv_emecntr;
343: -- IF csr_iv_emecntr%NOTFOUND THEN
344: -- -- Common Fatal Error Out
345: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');
346: -- hr_utility.raise_error;
347: -- ELSE
348: pay_siv_upd.upd
349: (p_effective_date => p_frm_ctl_effective_start_date

Line 346: -- hr_utility.raise_error;

342: FETCH csr_iv_emecntr INTO row_iv_emecntr;
343: -- IF csr_iv_emecntr%NOTFOUND THEN
344: -- -- Common Fatal Error Out
345: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');
346: -- hr_utility.raise_error;
347: -- ELSE
348: pay_siv_upd.upd
349: (p_effective_date => p_frm_ctl_effective_start_date
350: ,p_input_value_id => row_iv_emecntr.input_value_id

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

366: );
367: -- END IF;
368: CLOSE csr_iv_emecntr;
369:
370: hr_utility.set_location(l_proc, 60);
371:
372:
373: -- And if required update the employer contribution input value
374:

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

373: -- And if required update the employer contribution input value
374:
375: IF p_frm_ae_employer_contribution = 'Y' THEN
376:
377: hr_utility.set_location(l_proc, 70);
378:
379: OPEN csr_iv_emrcntr(row_el_stkhldr_details.element_type_id);
380: FETCH csr_iv_emrcntr INTO row_iv_emrcntr;
381: -- IF csr_iv_emrcntr%NOTFOUND THEN

Line 383: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMRCNTR_NOT_FOUND');

379: OPEN csr_iv_emrcntr(row_el_stkhldr_details.element_type_id);
380: FETCH csr_iv_emrcntr INTO row_iv_emrcntr;
381: -- IF csr_iv_emrcntr%NOTFOUND THEN
382: -- -- Common Fatal Error Out
383: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMRCNTR_NOT_FOUND');
384: -- hr_utility.raise_error;
385: -- ELSE
386: pay_siv_upd.upd
387: (p_effective_date => p_frm_ctl_effective_start_date

Line 384: -- hr_utility.raise_error;

380: FETCH csr_iv_emrcntr INTO row_iv_emrcntr;
381: -- IF csr_iv_emrcntr%NOTFOUND THEN
382: -- -- Common Fatal Error Out
383: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMRCNTR_NOT_FOUND');
384: -- hr_utility.raise_error;
385: -- ELSE
386: pay_siv_upd.upd
387: (p_effective_date => p_frm_ctl_effective_start_date
388: ,p_input_value_id => row_iv_emrcntr.input_value_id

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

406: CLOSE csr_iv_emrcntr;
407:
408: END IF;
409:
410: hr_utility.set_location(l_proc, 80);
411:
412:
413: -- Update the scheme name input value
414: OPEN csr_iv_schname(row_el_stkhldr_details.element_type_id);

Line 418: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');

414: OPEN csr_iv_schname(row_el_stkhldr_details.element_type_id);
415: FETCH csr_iv_schname INTO row_iv_schname;
416: -- IF csr_iv_schname%NOTFOUND THEN
417: -- -- Common Fatal Error Out
418: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');
419: -- hr_utility.raise_error;
420: -- ELSE
421: pay_siv_upd.upd
422: (p_effective_date => p_frm_ctl_effective_start_date

Line 419: -- hr_utility.raise_error;

415: FETCH csr_iv_schname INTO row_iv_schname;
416: -- IF csr_iv_schname%NOTFOUND THEN
417: -- -- Common Fatal Error Out
418: -- hr_utility.set_message(8303, 'PQP_STKTEST_EMECNTR_NOT_FOUND');
419: -- hr_utility.raise_error;
420: -- ELSE
421: pay_siv_upd.upd
422: (p_effective_date => p_frm_ctl_effective_start_date
423: ,p_input_value_id => row_iv_schname.input_value_id

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

440: -- END IF;
441: CLOSE csr_iv_schname;
442:
443:
444: hr_utility.set_location(l_proc, 90);
445:
446:
447:
448: -------------------------- Generate Core Objects -----------------------------

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

454: ,p_hr_to_payroll => FALSE
455: ,p_template_id => l_te_ustrctr_id
456: );
457:
458: hr_utility.set_location(l_proc, 100);
459:
460: pay_element_template_api.generate_part2
461: (p_validate => FALSE
462: ,p_effective_date => p_frm_ctl_effective_start_date

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

463: ,p_template_id => l_te_ustrctr_id
464: );
465:
466:
467: hr_utility.set_location(l_proc, 110);
468:
469: l_el_stkcore_id := get_object_id
470: ('ELE'
471: ,p_frm_be_element_name||l_el_bsuffix_nm

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

470: ('ELE'
471: ,p_frm_be_element_name||l_el_bsuffix_nm
472: );
473:
474: hr_utility.set_location(l_proc, 120);
475:
476: IF p_frm_ae_employer_contribution = 'Y' THEN
477: --
478: hr_utility.set_location(l_proc, 130);

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

474: hr_utility.set_location(l_proc, 120);
475:
476: IF p_frm_ae_employer_contribution = 'Y' THEN
477: --
478: hr_utility.set_location(l_proc, 130);
479:
480: l_employer_contribution_type := p_frm_ae_type;
481: --
482: END IF;

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

480: l_employer_contribution_type := p_frm_ae_type;
481: --
482: END IF;
483:
484: hr_utility.set_location(l_proc, 140);
485:
486: pay_element_extra_info_api.create_element_extra_info
487: (p_element_type_id => l_el_stkcore_id
488: ,p_information_type => 'PQP_GB_STAKEHOLDER_INFORMATION'

Line 498: hr_utility.set_location('Leaving : '||l_proc, 150);

494: ,p_eei_information5 => p_frm_sd_employee_contribution
495: ,p_element_type_extra_info_id => l_ee_stkhldr_id
496: ,p_object_version_number => l_xx_stkhldr_ovn);
497:
498: hr_utility.set_location('Leaving : '||l_proc, 150);
499:
500: RETURN l_el_stkcore_id;
501:
502: END create_user_template;

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

532: AND template_type = 'U';
533: --
534: BEGIN
535: --
536: hr_utility.set_location('Entering :'||l_proc, 10);
537: --
538:
539: OPEN csr_ee_stkhldr;
540: LOOP

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

549:
550: END LOOP;
551: CLOSE csr_ee_stkhldr;
552:
553: hr_utility.set_location(l_proc, 20);
554:
555: FOR csr_te_stkhldr_rec IN csr_te_stkhldr LOOP
556: l_te_ustrctr_id := csr_te_stkhldr_rec.template_id;
557: END LOOP;

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

555: FOR csr_te_stkhldr_rec IN csr_te_stkhldr LOOP
556: l_te_ustrctr_id := csr_te_stkhldr_rec.template_id;
557: END LOOP;
558:
559: hr_utility.set_location(l_proc, 30);
560:
561: pay_element_template_api.delete_user_structure
562: (p_validate => FALSE
563: ,p_drop_formula_packages => TRUE

Line 567: hr_utility.set_location('Leaving :'||l_proc, 40);

563: ,p_drop_formula_packages => TRUE
564: ,p_template_id => l_te_ustrctr_id
565: );
566:
567: hr_utility.set_location('Leaving :'||l_proc, 40);
568:
569: END delete_user_template;
570: --
571: END pqp_gb_stakeholder_template;