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.PAY_IE_PENSION_TEMPLATE dependencies on HR_UTILITY

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

39: l_proc_name Varchar2(80) := g_proc_name || 'compile_formula';
40: l_user_id number;
41: l_resp_id number;
42: begin
43: hr_utility.set_location('Entering: '||l_proc_name, 10);
44: -- ------------------------------------------------------------
45: -- Query formula info (ie. the formula attached to this
46: -- element's Standard status proc rule.
47: -- ------------------------------------------------------------

Line 50: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);

46: -- element's Standard status proc rule.
47: -- ------------------------------------------------------------
48: for fra_rec in csr_fra (c_element_type_id => p_element_type_id)
49: loop
50: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);
51: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);
52: -- ----------------------------------------------
53: -- Submit the request to compile the formula
54: -- ----------------------------------------------

Line 51: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);

47: -- ------------------------------------------------------------
48: for fra_rec in csr_fra (c_element_type_id => p_element_type_id)
49: loop
50: hr_utility.set_location('..FF Name :'||fra_rec.formula_name,15);
51: hr_utility.set_location('..FF Type Name :'||fra_rec.formula_type_name,20);
52: -- ----------------------------------------------
53: -- Submit the request to compile the formula
54: -- ----------------------------------------------
55: --fnd_profile.get('USER_ID', l_user_id);

Line 57: --hr_utility.set_location('..User Id :'||l_user_id, 25);

53: -- Submit the request to compile the formula
54: -- ----------------------------------------------
55: --fnd_profile.get('USER_ID', l_user_id);
56: --fnd_profile.get('RESP_ID', l_resp_id);
57: --hr_utility.set_location('..User Id :'||l_user_id, 25);
58: --hr_utility.set_location('..Responsibility Id :'||l_resp_id, 25);
59: --fnd_global.apps_initialize(l_user_id,l_resp_id,800);
60:
61: --13843294

Line 58: --hr_utility.set_location('..Responsibility Id :'||l_resp_id, 25);

54: -- ----------------------------------------------
55: --fnd_profile.get('USER_ID', l_user_id);
56: --fnd_profile.get('RESP_ID', l_resp_id);
57: --hr_utility.set_location('..User Id :'||l_user_id, 25);
58: --hr_utility.set_location('..Responsibility Id :'||l_resp_id, 25);
59: --fnd_global.apps_initialize(l_user_id,l_resp_id,800);
60:
61: --13843294
62: /* l_request_id := fnd_request.submit_request

Line 75: hr_utility.set_location('..Request Id :'||p_request_id, 25);

71: ,p_formula_name => fra_rec.formula_name); --formula name
72:
73: --13843294
74: p_request_id := l_request_id;
75: hr_utility.set_location('..Request Id :'||p_request_id, 25);
76: end loop;
77: hr_utility.set_location('Leaving: '||l_proc_name, 30);
78: exception
79: when others then

Line 77: hr_utility.set_location('Leaving: '||l_proc_name, 30);

73: --13843294
74: p_request_id := l_request_id;
75: hr_utility.set_location('..Request Id :'||p_request_id, 25);
76: end loop;
77: hr_utility.set_location('Leaving: '||l_proc_name, 30);
78: exception
79: when others then
80: hr_utility.set_location('..Entering exception when others ', 80);
81: hr_utility.set_location('Leaving: '||l_proc_name, 90);

Line 80: hr_utility.set_location('..Entering exception when others ', 80);

76: end loop;
77: hr_utility.set_location('Leaving: '||l_proc_name, 30);
78: exception
79: when others then
80: hr_utility.set_location('..Entering exception when others ', 80);
81: hr_utility.set_location('Leaving: '||l_proc_name, 90);
82: p_request_id := null; raise;
83: end Compile_Formula;
84:

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

77: hr_utility.set_location('Leaving: '||l_proc_name, 30);
78: exception
79: when others then
80: hr_utility.set_location('..Entering exception when others ', 80);
81: hr_utility.set_location('Leaving: '||l_proc_name, 90);
82: p_request_id := null; raise;
83: end Compile_Formula;
84:
85: -- ----------------------------------------------------------------------------

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

142: and ptco.template_id = psbt.template_id
143: and ptco.shadow_object_id = psbt.balance_type_id;
144: --
145: begin
146: hr_utility.set_location('Entering: '||l_proc_name, 10);
147: --
148: if p_object_type = 'ELE' then
149: for c2_rec in c2 (p_object_name) loop
150: l_object_id := c2_rec.element_type_id; -- element id

Line 158: hr_utility.set_location('Leaving: '||l_proc_name, 20);

154: l_object_id := c3_rec.core_object_id; -- balance id
155: end loop;
156: end if;
157: --
158: hr_utility.set_location('Leaving: '||l_proc_name, 20);
159: --
160: return l_object_id;
161: end Get_Object_ID;
162:

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

177: l_proc_name Varchar2(72) := g_proc_name || 'get_formula_id';
178: l_formula_id Number;
179: begin
180: --
181: hr_utility.set_location ('Entering '||l_proc_name, 10);
182: --
183: open csr_get_formula_id;
184: fetch csr_get_formula_id into l_formula_id;
185: close csr_get_formula_id;

Line 187: hr_utility.set_location ('Leaving '||l_proc_name, 20);

183: open csr_get_formula_id;
184: fetch csr_get_formula_id into l_formula_id;
185: close csr_get_formula_id;
186: --
187: hr_utility.set_location ('Leaving '||l_proc_name, 20);
188: --
189: return l_formula_id;
190: end Get_Formula_ID;
191:

Line 253: hr_utility.set_location('..In Create_Formula_Results', 51);

249: effective_start_date AND effective_end_date;
250:
251: BEGIN
252:
253: hr_utility.set_location('..In Create_Formula_Results', 51);
254:
255: OPEN c_formula_id (replace(p_scheme_prefix,' ','_')||'_ER_CONTRIBUTION');
256: FETCH c_formula_id INTO l_er_formula_id;
257: IF c_formula_id%NOTFOUND THEN

Line 263: hr_utility.set_location('..Fetched Formula ID', 51);

259: fnd_message.raise_error;
260: ELSE
261: CLOSE c_formula_id;
262: END IF;
263: hr_utility.set_location('..Fetched Formula ID', 51);
264: OPEN c_ele_id (p_scheme_prefix||' ER Contribution');
265: FETCH c_ele_id INTO l_er_ele_id;
266: IF c_ele_id%NOTFOUND THEN
267: CLOSE c_ele_id;

Line 272: hr_utility.set_location('..Fetched Element ID', 51);

268: fnd_message.raise_error;
269: ELSE
270: CLOSE c_ele_id;
271: END IF;
272: hr_utility.set_location('..Fetched Element ID', 51);
273: OPEN c_status_proc_id (l_er_ele_id, l_er_formula_id);
274: FETCH c_status_proc_id INTO l_er_status_proc_rule_id;
275: IF c_status_proc_id%NOTFOUND THEN
276: CLOSE c_status_proc_id;

Line 282: hr_utility.set_location('..Creating Formula Result Rules for BIK', 51);

278: ELSE
279: CLOSE c_status_proc_id;
280: END IF;
281:
282: hr_utility.set_location('..Creating Formula Result Rules for BIK', 51);
283: IF p_pension_category='PRSA' THEN
284: OPEN c_ele_id ('IE BIK PRSA ER Contribution');
285: FETCH c_ele_id INTO l_bik_er_ele_id;
286: IF c_ele_id%NOTFOUND THEN

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

403: 'update_ipval_defval';
404: --
405: begin
406: --
407: hr_utility.set_location ('Entering '||l_proc_name, 10);
408: --
409: open csr_getinput(p_ele_name ,p_ip_name);
410: loop
411: fetch csr_getinput into csr_getinput_rec;

Line 414: hr_utility.set_location (l_proc_name, 20);

410: loop
411: fetch csr_getinput into csr_getinput_rec;
412: exit when csr_getinput%notfound;
413: --
414: hr_utility.set_location (l_proc_name, 20);
415: --
416: open csr_updinput(csr_getinput_rec.input_value_id
417: ,csr_getinput_rec.element_type_id);
418: loop

Line 422: hr_utility.set_location (l_proc_name, 30);

418: loop
419: fetch csr_updinput into csr_updinput_rec;
420: exit when csr_updinput%notfound;
421: --
422: hr_utility.set_location (l_proc_name, 30);
423: --
424: update pay_input_values_f
425: set default_value = p_def_value
426: where rowid = csr_updinput_rec.rowid;

Line 432: hr_utility.set_location ('Leaving '||l_proc_name, 40);

428: close csr_updinput;
429: end loop;
430: close csr_getinput;
431: --
432: hr_utility.set_location ('Leaving '||l_proc_name, 40);
433: --
434: end Update_Ipval_Defval;
435:
436: -- ---------------------------------------------------------------------

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

652:
653: --
654: begin
655: --
656: hr_utility.set_location('Entering: '||l_proc_name, 10);
657: --
658: l_template_name := 'Ireland Pension Deduction';
659: --
660: hr_utility.set_location(l_proc_name, 20);

Line 660: hr_utility.set_location(l_proc_name, 20);

656: hr_utility.set_location('Entering: '||l_proc_name, 10);
657: --
658: l_template_name := 'Ireland Pension Deduction';
659: --
660: hr_utility.set_location(l_proc_name, 20);
661: --
662: for csr_get_temp_id_rec in csr_get_temp_id loop
663: l_template_id := csr_get_temp_id_rec.template_id;
664: end loop;

Line 666: hr_utility.set_location('Leaving: '||l_proc_name, 30);

662: for csr_get_temp_id_rec in csr_get_temp_id loop
663: l_template_id := csr_get_temp_id_rec.template_id;
664: end loop;
665: --
666: hr_utility.set_location('Leaving: '||l_proc_name, 30);
667: hr_utility.set_location('Template_id: '||l_template_id , 30);
668: --
669: return l_template_id;
670: --

Line 667: hr_utility.set_location('Template_id: '||l_template_id , 30);

663: l_template_id := csr_get_temp_id_rec.template_id;
664: end loop;
665: --
666: hr_utility.set_location('Leaving: '||l_proc_name, 30);
667: hr_utility.set_location('Template_id: '||l_template_id , 30);
668: --
669: return l_template_id;
670: --
671: end Get_Template_ID;

Line 674: --hr_utility.trace_on('Y', 'PENSIONIE');

670: --
671: end Get_Template_ID;
672:
673: begin
674: --hr_utility.trace_on('Y', 'PENSIONIE');
675: -- ---------------------------------------------------------------------
676: -- |-------------< Main Function : Create_User_Template Body >----------|
677: -- ---------------------------------------------------------------------
678: hr_utility.set_location('Entering : '||l_proc_name, 10);

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

674: --hr_utility.trace_on('Y', 'PENSIONIE');
675: -- ---------------------------------------------------------------------
676: -- |-------------< Main Function : Create_User_Template Body >----------|
677: -- ---------------------------------------------------------------------
678: hr_utility.set_location('Entering : '||l_proc_name, 10);
679:
680: chk_scheme_prefix(p_scheme_prefix);
681:
682: -- ---------------------------------------------------------------------

Line 687: hr_utility.set_location('..Setting the Session Date', 15);

683: -- Set session date
684: -- ---------------------------------------------------------------------
685: pay_db_pay_setup.set_session_date(nvl(p_effective_start_date, sysdate));
686: --
687: hr_utility.set_location('..Setting the Session Date', 15);
688: -- ---------------------------------------------------------------------
689: -- Get Source Template ID
690: -- ---------------------------------------------------------------------
691: l_source_template_id := get_template_id

Line 703: hr_utility.set_location('..Checking all the Exclusion Rules', 20);

699: CLOSE csr_get_category;
700: -- ---------------------------------------------------------------------
701: -- Exclusion rules
702: -- ---------------------------------------------------------------------
703: hr_utility.set_location('..Checking all the Exclusion Rules', 20);
704:
705: -- Define the exclusion_rule for Employer Component
706: IF l_pension_category <> 'RBSAVC' AND l_pension_category <> 'PRSAAVC' THEN
707: l_configuration_information1 := 'Y';

Line 725: hr_utility.set_location('..Creating template User structure', 25);

721:
722: -- ---------------------------------------------------------------------
723: -- Create user structure from the template
724: -- ---------------------------------------------------------------------
725: hr_utility.set_location('..Creating template User structure', 25);
726: pay_element_template_api.create_user_structure
727: (p_validate => false
728: ,p_effective_date => p_effective_start_date
729: ,p_business_group_id => p_business_group_id

Line 736: hr_utility.set_location('..Created template User structure', 25);

732: ,p_configuration_information1 => l_configuration_information1
733: ,p_template_id => l_template_id
734: ,p_object_version_number => l_object_version_number
735: );
736: hr_utility.set_location('..Created template User structure', 25);
737: -- ---------------------------------------------------------------------
738: -- |-------------------< Update Shadow Structure >----------------------|
739: -- ---------------------------------------------------------------------
740: -- Get Element Type id and update user-specified Classification,

Line 818: hr_utility.set_location('..Updating the scheme shadow elements', 30);

814: l_shadow_element(l_count).priority := csr_rec.relative_processing_priority;
815: l_shadow_element(l_count).third_party_pay_only_flag := csr_rec.third_party_pay_only_flag;
816: l_shadow_element(l_count).classification_name := csr_rec.classification_name;
817: end loop;
818: hr_utility.set_location('..Updating the scheme shadow elements', 30);
819: for i in 1..l_count
820: loop
821: pay_shadow_element_api.update_shadow_element
822: (p_validate => false

Line 835: hr_utility.set_location('..After Updating the scheme shadow elements', 50);

831: ,p_third_party_pay_only_flag => l_shadow_element(i).third_party_pay_only_flag
832: ,p_classification_name => l_shadow_element(i).classification_name
833: );
834: end loop;
835: hr_utility.set_location('..After Updating the scheme shadow elements', 50);
836:
837: -- Replace the spaces in the prefix with underscores. The formula name
838: -- has underscores if the prefix name has spaces in it .
839: l_scheme_prefix := upper(replace(l_scheme_prefix,' ','_'));

Line 842: hr_utility.set_location('..Updated Shadow element', 25);

838: -- has underscores if the prefix name has spaces in it .
839: l_scheme_prefix := upper(replace(l_scheme_prefix,' ','_'));
840:
841:
842: hr_utility.set_location('..Updated Shadow element', 25);
843:
844: -- ---------------------------------------------------------------------
845: -- |-------------------< Generate Core Objects >------------------------|
846: -- ---------------------------------------------------------------------

Line 854: hr_utility.set_location('After Generating Core objects : Part - 1', 50);

850: ,p_hr_only => false
851: ,p_hr_to_payroll => false
852: ,p_template_id => l_template_id);
853: --
854: hr_utility.set_location('After Generating Core objects : Part - 1', 50);
855: --
856: pay_element_template_api.generate_part2
857: (p_validate => false
858: ,p_effective_date => p_effective_start_date

Line 861: hr_utility.set_location('After Generating Core objects : Part - 2', 50);

857: (p_validate => false
858: ,p_effective_date => p_effective_start_date
859: ,p_template_id => l_template_id);
860: --
861: hr_utility.set_location('After Generating Core objects : Part - 2', 50);
862:
863: -- Update some of the input values on the main element
864:
865: Update_Ipval_Defval( p_scheme_prefix||' Pension Deduction'

Line 1014: hr_utility.set_location('..After Creating element extra information', 50);

1010: ,p_eei_information20 => null
1011: ,p_element_type_extra_info_id => l_eei_info_id
1012: ,p_object_version_number => l_ovn_eei);
1013:
1014: hr_utility.set_location('..After Creating element extra information', 50);
1015:
1016: -- ---------------------------------------------------------------------
1017: -- The base element's Pay Value should feed the EE Contribution balance
1018: -- for the pension scheme created.

Line 1106: hr_utility.set_location('..After creating the balance feed for the base, Pay Value', 50);

1102: l_row_id := null;
1103:
1104: end loop;
1105:
1106: hr_utility.set_location('..After creating the balance feed for the base, Pay Value', 50);
1107:
1108: -- ---------------------------------------------------------------------
1109: -- The ER base element's Pay Value should feed the ER Contribution balance
1110: -- for the pension scheme created.

Line 1156: hr_utility.set_location('..After creating the balance feed for the ER base, Pay Value', 51);

1152: l_Balance_Feed_Id := null;
1153: l_row_id := null;
1154: end loop;
1155: END IF;
1156: hr_utility.set_location('..After creating the balance feed for the ER base, Pay Value', 51);
1157:
1158: -- ---------------------------------------------------------------------
1159: -- Compile the base element's standard formula
1160: -- ---------------------------------------------------------------------

Line 1197: hr_utility.set_location('..After creating the formula result rules', 51);

1193: ,p_effective_start_date
1194: ,p_effective_end_date);
1195: END IF;
1196:
1197: hr_utility.set_location('..After creating the formula result rules', 51);
1198: END IF;
1199:
1200:
1201: return l_base_element_type_id;

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

1231: -- Other variables
1232: l_return_status varchar2(1);
1233: l_proc varchar2(72) := 'Create_User_Template_Swi';
1234: Begin
1235: hr_utility.set_location(' Entering:' || l_proc,10);
1236: l_element_type_id := -1;
1237: --
1238: -- Issue a savepoint
1239: --

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

1282: -- messages of any type exist in the Multiple Message List.
1283: -- Also disable Multiple Message Detection.
1284: --
1285: l_return_status := hr_multi_message.get_return_status_disable;
1286: hr_utility.set_location(' Leaving:' || l_proc,20);
1287: return l_element_type_id;
1288:
1289: --
1290: exception

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

1298: --
1299: -- Reset IN OUT parameters and set OUT parameters
1300: --
1301: return l_element_type_id;
1302: hr_utility.set_location(' Leaving:' || l_proc, 30);
1303:
1304: when others then
1305: --
1306: -- When Multiple Message Detection is enabled catch

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

1310: -- error.
1311: --
1312: rollback to Create_User_Template_Swi;
1313: if hr_multi_message.unexpected_error_add(l_proc) then
1314: hr_utility.set_location(' Leaving:' || l_proc,40);
1315: raise;
1316: end if;
1317: --
1318: -- Reset IN OUT and set OUT parameters

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

1318: -- Reset IN OUT and set OUT parameters
1319: --
1320: l_return_status := hr_multi_message.get_return_status_disable;
1321: return l_element_type_id;
1322: hr_utility.set_location(' Leaving:' || l_proc,50);
1323:
1324:
1325: END create_user_template_swi;
1326:

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

1353: l_template_id Number(9);
1354: l_proc Varchar2(60) := g_proc_name||'Delete_User_Template';
1355:
1356: begin
1357: hr_utility.set_location('Entering :'||l_proc, 10);
1358: --
1359: for c1_rec in c1 loop
1360: l_template_id := c1_rec.template_id;
1361: end loop;

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

1376: (p_element_type_extra_info_id => temp_rec.element_type_extra_info_id
1377: ,p_object_version_number => temp_rec.object_version_number);
1378: END LOOP;
1379:
1380: hr_utility.set_location('Leaving :'||l_proc, 50);
1381:
1382: end Delete_User_Template;
1383: --
1384:

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

1403: -- Other variables
1404: l_return_status varchar2(1);
1405: l_proc varchar2(72) := 'Delete_User_Template_Swi';
1406: Begin
1407: hr_utility.set_location(' Entering:' || l_proc,10);
1408: --
1409: -- Issue a savepoint
1410: --
1411: savepoint Delete_User_Template_Swi;

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

1447: -- messages of any type exist in the Multiple Message List.
1448: -- Also disable Multiple Message Detection.
1449: --
1450: l_return_status := hr_multi_message.get_return_status_disable;
1451: hr_utility.set_location(' Leaving:' || l_proc,20);
1452:
1453: --
1454: exception
1455: when hr_multi_message.error_message_exist then

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

1461: rollback to Delete_User_Template_Swi;
1462: --
1463: -- Reset IN OUT parameters and set OUT parameters
1464: --
1465: hr_utility.set_location(' Leaving:' || l_proc, 30);
1466:
1467: when others then
1468: --
1469: -- When Multiple Message Detection is enabled catch

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

1473: -- error.
1474: --
1475: rollback to Delete_User_Template_Swi;
1476: if hr_multi_message.unexpected_error_add(l_proc) then
1477: hr_utility.set_location(' Leaving:' || l_proc,40);
1478: raise;
1479: end if;
1480: --
1481: -- Reset IN OUT and set OUT parameters

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

1480: --
1481: -- Reset IN OUT and set OUT parameters
1482: --
1483: l_return_status := hr_multi_message.get_return_status_disable;
1484: hr_utility.set_location(' Leaving:' || l_proc,50);
1485:
1486: END delete_user_template_swi;
1487:
1488: --