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

Line 236: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',1);

232: l_template_name VARCHAR2(80);
233:
234: BEGIN
235: --
236: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',1);
237: --
238: if p_calc_rule_code = 'FLT' then
239: l_template_name := 'Flat Amount Deduction';
240: --l_template_name := 'Test Flat Amount Deductions';

Line 244: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',2);

240: --l_template_name := 'Test Flat Amount Deductions';
241: elsif p_calc_rule_code = 'PCT' then
242: l_template_name := 'Percent of Earnings Deduction';
243: else
244: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',2);
245: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_DEDN');
246: hr_utility.raise_error;
247: end if;
248: --

Line 245: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_DEDN');

241: elsif p_calc_rule_code = 'PCT' then
242: l_template_name := 'Percent of Earnings Deduction';
243: else
244: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',2);
245: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_DEDN');
246: hr_utility.raise_error;
247: end if;
248: --
249: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',3);

Line 246: hr_utility.raise_error;

242: l_template_name := 'Percent of Earnings Deduction';
243: else
244: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',2);
245: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_DEDN');
246: hr_utility.raise_error;
247: end if;
248: --
249: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',3);
250: hr_utility.trace('Template Name is :'||l_template_name||'****'||

Line 249: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',3);

245: hr_utility.set_message(801,'HR_XXXXX_INVALID_CALC_RULE_DEDN');
246: hr_utility.raise_error;
247: end if;
248: --
249: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',3);
250: hr_utility.trace('Template Name is :'||l_template_name||'****'||
251: 'Legislation is :'||p_legislation_code);
252: --
253: select template_id

Line 250: hr_utility.trace('Template Name is :'||l_template_name||'****'||

246: hr_utility.raise_error;
247: end if;
248: --
249: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',3);
250: hr_utility.trace('Template Name is :'||l_template_name||'****'||
251: 'Legislation is :'||p_legislation_code);
252: --
253: select template_id
254: into l_template_id

Line 261: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',4);

257: and legislation_code = p_legislation_code
258: and business_group_id is NULL
259: and template_type = 'T';
260: --
261: hr_utility.set_location('pay_ca_user_init_dedn.get_template_id',4);
262: --
263: RETURN l_template_id;
264: --
265: END get_template_id;

Line 278: hr_utility.set_location('pay_ca_user_init_dedn.chk_ca_pay_installed',1);

274: l_installed VARCHAR2(1) := 'N';
275:
276: BEGIN
277: --
278: hr_utility.set_location('pay_ca_user_init_dedn.chk_ca_pay_installed',1);
279: --
280: BEGIN
281: select 'Y'
282: into l_installed

Line 292: hr_utility.set_location('pay_ca_user_init_dedn.chk_ca_pay_installed',2);

288: l_installed := 'N';
289:
290: END;
291: --
292: hr_utility.set_location('pay_ca_user_init_dedn.chk_ca_pay_installed',2);
293: --
294: RETURN (l_installed);
295: --
296: END chk_ca_pay_installed;

Line 306: -- hr_utility.trace_on('Y', 'RANJANA');

302: -- Main Procedure
303:
304: BEGIN
305: --
306: -- hr_utility.trace_on('Y', 'RANJANA');
307: --
308: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',1);
309: --
310: -- Set session date

Line 308: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',1);

304: BEGIN
305: --
306: -- hr_utility.trace_on('Y', 'RANJANA');
307: --
308: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',1);
309: --
310: -- Set session date
311: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
312: --

Line 316: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',2);

312: --
313: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
314: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
315: --
316: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',2);
317: --
318: ---------------------------- Check Element Name ---------------------------
319: --
320: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',25);

Line 320: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',25);

316: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',2);
317: --
318: ---------------------------- Check Element Name ---------------------------
319: --
320: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',25);
321: --
322: BEGIN
323: select 'Y'
324: into l_reserved

Line 336: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);

332:
333: END;
334: --
335: if l_reserved = 'Y' then
336: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);
337: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
338: hr_utility.raise_error;
339: end if;
340: --

Line 337: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');

333: END;
334: --
335: if l_reserved = 'Y' then
336: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);
337: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
338: hr_utility.raise_error;
339: end if;
340: --
341: ---------------------------- Get Source Template ID -----------------------

Line 338: hr_utility.raise_error;

334: --
335: if l_reserved = 'Y' then
336: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);
337: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
338: hr_utility.raise_error;
339: end if;
340: --
341: ---------------------------- Get Source Template ID -----------------------
342: --

Line 343: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',3);

339: end if;
340: --
341: ---------------------------- Get Source Template ID -----------------------
342: --
343: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',3);
344: --
345: l_source_template_id := get_template_id(
346: p_legislation_code => g_template_leg_code,
347: p_calc_rule_code => p_ele_calc_rule_code);

Line 351: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',4);

347: p_calc_rule_code => p_ele_calc_rule_code);
348: --
349: ------------------------ Set Arrearage Creation ---------------------------
350: --
351: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',4);
352: --
353: if p_ele_insuff_funds_code in ('A', 'APD') then
354: l_arrearage_create := 'Y';
355: else

Line 361: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',5);

357: end if;
358: --
359: ------------------------ Set Total Owed Creation --------------------------
360: --
361: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',5);
362: --
363: if UPPER(p_ele_stop_rule) = 'TOTAL REACHED' then
364: l_total_owed_create := 'Y';
365: else

Line 379: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',6);

375: end if;
376: --
377: ---------------------------- Create User Structure ------------------------
378: --
379: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',6);
380: --
381: -- The Configuration Flex segments are as follows:
382: -- Config 1 - exclusion rule - create Arrearage related structures if 'Y'
383: -- Config 2 - exclusion rule - create Total Owed related structures if 'Y'

Line 403: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',7);

399: ,p_object_version_number => l_object_version_number);
400: --
401: ---------------------- Get Element Type ID of new Template-----------------
402: --
403: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',7);
404: --
405: select element_type_id, object_version_number
406: into l_element_type_id, l_ele_obj_ver_number
407: from pay_shadow_element_types

Line 427: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',8);

423: end if;
424: --
425: ---------------------------- Update Shadow Structure ----------------------
426: --
427: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',8);
428: --
429: if p_ben_class_id IS NOT NULL then
430: select benefit_classification_name
431: into l_ben_class_name

Line 465: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',9);

461: --
462: --
463: -- Update user-specified Classification on Special Features Element.
464: --
465: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',9);
466: --
467: pay_shadow_element_api.update_shadow_element
468: (p_validate => false
469: ,p_effective_date => p_ele_eff_start_date

Line 478: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',10);

474: --
475: --
476: -- Update user-specified Classification Special Inputs if it exists.
477: --
478: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',10);
479: --
480: if p_ele_processing_type = 'R' then
481: pay_shadow_element_api.update_shadow_element
482: (p_validate => false

Line 492: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',11);

488: end if;
489: --
490: ---------------------------- Generate Core Objects ------------------------
491: --
492: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',11);
493: --
494: if chk_ca_pay_installed = 'Y' then
495: l_hr_only := FALSE;
496: else

Line 500: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);

496: else
497: l_hr_only := TRUE;
498: end if;
499: --
500: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);
501: --
502: pay_element_template_api.generate_part1
503: (p_validate => false
504: ,p_effective_date => p_ele_eff_start_date

Line 509: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',12);

505: ,p_hr_only => l_hr_only
506: ,p_hr_to_payroll => false
507: ,p_template_id => l_template_id);
508: --
509: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',12);
510: --
511: if l_hr_only = FALSE then
512: pay_element_template_api.generate_part2
513: (p_validate => false

Line 520: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',13);

516: end if;
517: --
518: -------------------- Get Element Type ID of Base Element ------------------
519: --
520: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',13);
521: --
522: select element_type_id
523: into l_base_element_type_id
524: from pay_element_types_f

Line 530: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',14);

526: and business_group_id + 0 = p_bg_id;
527: --
528: ------------------ Get Balance Type IDs to update Flex Info ---------------
529: --
530: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',14);
531: --
532: select ptco.core_object_id
533: into l_pri_bal_id
534: from pay_shadow_balance_types psbt,

Line 541: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',15);

537: and psbt.balance_name = p_ele_name
538: and ptco.template_id = psbt.template_id
539: and ptco.shadow_object_id = psbt.balance_type_id;
540: --
541: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',15);
542: --
543: if l_arrearage_create = 'Y' then
544: select ptco.core_object_id
545: into l_arr_bal_id

Line 567: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',16);

563: l_not_taken_bal_id := '';
564: l_arr_bal_id := '';
565: end if;
566: --
567: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',16);
568: --
569: if l_total_owed_create = 'Y' then
570: select ptco.core_object_id
571: into l_accr_bal_id

Line 582: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',17);

578: else
579: l_accr_bal_id := '';
580: end if;
581: --
582: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',17);
583: --
584: update pay_element_types_f
585: set element_information10 = l_pri_bal_id,
586: element_information11 = l_accr_bal_id,

Line 651: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',18);

647: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
648: --
649: ------------------ Conclude Create_User_Init_Deduction Main -----------------
650: --
651: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',18);
652: --
653: RETURN l_base_element_type_id;
654: --
655: END create_user_init_deduction;

Line 758: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',1);

754: l_template_name VARCHAR2(80);
755:
756: BEGIN
757: --
758: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',1);
759: --
760: l_template_name := 'Generic Involuntary Deduction';
761: --
762: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',3);

Line 762: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',3);

758: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',1);
759: --
760: l_template_name := 'Generic Involuntary Deduction';
761: --
762: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',3);
763: hr_utility.trace('Template Name is :'||l_template_name||'****'||
764: 'Legislation is :'||p_legislation_code);
765: --
766: select template_id

Line 763: hr_utility.trace('Template Name is :'||l_template_name||'****'||

759: --
760: l_template_name := 'Generic Involuntary Deduction';
761: --
762: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',3);
763: hr_utility.trace('Template Name is :'||l_template_name||'****'||
764: 'Legislation is :'||p_legislation_code);
765: --
766: select template_id
767: into l_template_id

Line 774: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',4);

770: and legislation_code = p_legislation_code
771: and business_group_id is NULL
772: and template_type = 'T';
773: --
774: hr_utility.set_location('pay_ca_user_init_garn.get_template_id',4);
775: --
776: RETURN l_template_id;
777: --
778: END get_template_id;

Line 791: hr_utility.set_location('pay_ca_user_init_garn.chk_ca_pay_installed',1);

787: l_installed VARCHAR2(1) := 'N';
788:
789: BEGIN
790: --
791: hr_utility.set_location('pay_ca_user_init_garn.chk_ca_pay_installed',1);
792: --
793: BEGIN
794: select 'Y'
795: into l_installed

Line 805: hr_utility.set_location('pay_ca_user_init_garn.chk_ca_pay_installed',2);

801: l_installed := 'N';
802:
803: END;
804: --
805: hr_utility.set_location('pay_ca_user_init_garn.chk_ca_pay_installed',2);
806: --
807: RETURN (l_installed);
808: --
809: END chk_ca_pay_installed;

Line 819: -- hr_utility.trace_on('Y', 'RANJANA');

815: -- Main Procedure
816:
817: BEGIN
818: --
819: -- hr_utility.trace_on('Y', 'RANJANA');
820: --
821: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',1);
822: --
823: -- Set session date

Line 821: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',1);

817: BEGIN
818: --
819: -- hr_utility.trace_on('Y', 'RANJANA');
820: --
821: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',1);
822: --
823: -- Set session date
824: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
825: --

Line 829: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',2);

825: --
826: g_eff_start_date := NVL(p_ele_eff_start_date, sysdate);
827: g_eff_end_date := NVL(p_ele_eff_end_date, c_end_of_time);
828: --
829: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',2);
830: --
831: ---------------------------- Check Element Name ---------------------------
832: --
833: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',25);

Line 833: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',25);

829: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',2);
830: --
831: ---------------------------- Check Element Name ---------------------------
832: --
833: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',25);
834: --
835: BEGIN
836: select 'Y'
837: into l_reserved

Line 849: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);

845:
846: END;
847: --
848: if l_reserved = 'Y' then
849: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);
850:
851: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
852: hr_utility.raise_error;
853: end if;

Line 851: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');

847: --
848: if l_reserved = 'Y' then
849: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);
850:
851: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
852: hr_utility.raise_error;
853: end if;
854: --
855: ---------------------------- Get Source Template ID -----------------------

Line 852: hr_utility.raise_error;

848: if l_reserved = 'Y' then
849: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);
850:
851: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
852: hr_utility.raise_error;
853: end if;
854: --
855: ---------------------------- Get Source Template ID -----------------------
856: --

Line 857: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',3);

853: end if;
854: --
855: ---------------------------- Get Source Template ID -----------------------
856: --
857: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',3);
858: --
859: l_source_template_id := get_template_id(
860: p_legislation_code => g_template_leg_code);
861: --

Line 864: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',7);

860: p_legislation_code => g_template_leg_code);
861: --
862: ---------------------- Get Element Type ID of new Template-----------------
863: --
864: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',7);
865: --
866: pay_element_template_api.create_user_structure
867: (p_validate => false
868: ,p_effective_date => p_ele_eff_start_date

Line 918: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',8);

914: and element_name = p_ele_name||' Special Inputs';
915: --
916: ---------------------------- Update Shadow Structure ----------------------
917: --
918: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',8);
919: --
920: -- Update user-specified Classification, Processing Type and Standard Link.
921: --
922: pay_shadow_element_api.update_shadow_element

Line 951: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',9);

947: --
948: --
949: -- Update user-specified Classification on ISpecial Features Element.
950: --
951: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',9);
952:
953:
954: --
955: pay_shadow_element_api.update_shadow_element

Line 988: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',11);

984: --
985: --
986: -- Update user-specified Classification Special Inputs if it exists.
987: --
988: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',11);
989:
990: --
991: pay_shadow_element_api.update_shadow_element
992: (p_validate => false

Line 1009: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',12);

1005: --
1006: --
1007: -- Update user-specified Classification on Fees Element.
1008: --
1009: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',12);
1010:
1011: --
1012: pay_shadow_element_api.update_shadow_element
1013: (p_validate => false

Line 1030: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',13);

1026: --
1027: --
1028: -- Update user-specified Classification on, last but not least, Verifier Element.
1029: --
1030: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',13);
1031:
1032: --
1033: pay_shadow_element_api.update_shadow_element
1034: (p_validate => false

Line 1052: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',14);

1048: --
1049: ---------------------------- Generate Core Objects ------------------------
1050: --
1051: --
1052: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',14);
1053:
1054: --
1055: if chk_ca_pay_installed = 'Y' then
1056: l_hr_only := FALSE;

Line 1061: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);

1057: else
1058: l_hr_only := TRUE;
1059: end if;
1060: --
1061: hr_utility.trace('HR ONLY is :'||chk_ca_pay_installed);
1062: --
1063: pay_element_template_api.generate_part1
1064: (p_validate => false
1065: ,p_effective_date => p_ele_eff_start_date

Line 1070: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',12);

1066: ,p_hr_only => l_hr_only
1067: ,p_hr_to_payroll => false
1068: ,p_template_id => l_template_id);
1069: --
1070: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',12);
1071:
1072: --
1073: if l_hr_only = FALSE then
1074: pay_element_template_api.generate_part2

Line 1082: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',13);

1078: end if;
1079: --
1080: -------------------- Get Element Type ID of Base Element ------------------
1081: --
1082: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',13);
1083:
1084: --
1085: select element_type_id
1086: into l_base_element_type_id

Line 1099: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',14);

1095: and business_group_id + 0 = p_bg_id;
1096: --
1097: ------------------ Get Balance Type IDs to update Flex Info ---------------
1098: --
1099: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',14);
1100:
1101: --
1102: select ptco.core_object_id
1103: into l_pri_bal_id

Line 1165: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',17);

1161: and psbt.balance_name = p_ele_name||' Arrears'
1162: and ptco.template_id = psbt.template_id
1163: and ptco.shadow_object_id = psbt.balance_type_id;
1164: --
1165: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',17);
1166:
1167: --
1168: update pay_element_types_f
1169: set element_information10 = l_pri_bal_id,

Line 1231: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',18);

1227: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
1228: --
1229: ------------------ Conclude Create_User_Init_Deduction Main -----------------
1230: --
1231: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',18);
1232: --
1233: RETURN l_base_element_type_id;
1234: --
1235: END create_user_init_garnishment;

Line 1267: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',1);

1263: l_del_val_end := nvl(p_del_val_end_date, c_end_of_time);
1264: l_del_val_start := nvl(p_del_val_start_date, sysdate);
1265: l_del_sess_date := nvl(p_del_sess_date, sysdate);
1266: --
1267: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',1);
1268: --
1269: select template_id
1270: into l_template_id
1271: from pay_element_templates

Line 1276: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',2);

1272: where base_name = p_ele_name
1273: and business_group_id = p_business_group_id
1274: and template_type = 'U';
1275: --
1276: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',2);
1277: --
1278: begin
1279: delete from pay_element_type_usages_f
1280: where element_type_id in ( select element_type_id

Line 1285: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3);

1281: from pay_element_types_f
1282: where element_name = p_ele_name
1283: and business_group_id = p_business_group_id );
1284: --
1285: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3);
1286: --
1287: exception
1288: when others then
1289: null;

Line 1296: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',4);

1292: (p_validate => false
1293: ,p_drop_formula_packages => true
1294: ,p_template_id => l_template_id);
1295: --
1296: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',4);
1297: --
1298: END delete_user_init_deduction;
1299: --
1300: ------------------------- Deletion procedures -----------------------------

Line 1331: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',1);

1327: l_del_val_end := nvl(p_del_val_end_date, c_end_of_time);
1328: l_del_val_start := nvl(p_del_val_start_date, sysdate);
1329: l_del_sess_date := nvl(p_del_sess_date, sysdate);
1330: --
1331: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',1);
1332: --
1333: select template_id
1334: into l_template_id
1335: from pay_element_templates

Line 1340: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',2);

1336: where base_name = p_ele_name
1337: and business_group_id = p_business_group_id
1338: and template_type = 'U';
1339: --
1340: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',2);
1341: --
1342: begin
1343: delete from pay_element_type_usages_f
1344: where element_type_id in ( select element_type_id

Line 1349: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3

1345: from pay_element_types_f
1346: where element_name = p_ele_name
1347: and business_group_id = p_business_group_id );
1348: --
1349: hr_utility.set_location('pay_ca_user_init_dedn.delete_user_init_deduction',3
1350: );
1351: --
1352: exception
1353: when others then

Line 1362: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',3);

1358: (p_validate => false
1359: ,p_drop_formula_packages => true
1360: ,p_template_id => l_template_id);
1361: --
1362: hr_utility.set_location('pay_ca_user_init_garn.delete_user_init_garnishment',3);
1363: --
1364: END delete_user_init_garnishment;
1365: --
1366: END pay_ca_user_init_dedn;