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

Line 293: hr_utility.set_location ( 'Entering: '

289: AND business_group_id IS NULL;
290: --
291: BEGIN
292: --
293: hr_utility.set_location ( 'Entering: '
294: || l_proc_name, 10);
295: --
296:
297: OPEN csr_get_temp_id;

Line 301: hr_utility.set_location ( 'l_template_id: '||l_template_id, 25);

297: OPEN csr_get_temp_id;
298: FETCH csr_get_temp_id INTO l_template_id;
299: CLOSE csr_get_temp_id;
300: --
301: hr_utility.set_location ( 'l_template_id: '||l_template_id, 25);
302:
303: hr_utility.set_location ( 'Leaving: '
304: || l_proc_name, 30);
305: --

Line 303: hr_utility.set_location ( 'Leaving: '

299: CLOSE csr_get_temp_id;
300: --
301: hr_utility.set_location ( 'l_template_id: '||l_template_id, 25);
302:
303: hr_utility.set_location ( 'Leaving: '
304: || l_proc_name, 30);
305: --
306: RETURN l_template_id;
307: --

Line 348: hr_utility.set_location ( 'Entering: '

344: AND ptco.template_id = psbt.template_id
345: AND ptco.shadow_object_id = psbt.balance_type_id;
346: --
347: BEGIN
348: hr_utility.set_location ( 'Entering: '
349: || l_proc_name, 10);
350:
351: --
352: IF p_object_type = 'ELE'

Line 364: hr_utility.set_location ( 'l_object_id (ELE) : '||l_object_id, 15);

360: fnd_message.set_name ('PQP', 'PQP_230933_ELE_TYPE_NOTFOUND');
361: fnd_message.set_token ('ELEMENT_TYPE', p_object_name);
362: fnd_message.raise_error;
363: END IF; -- End if of csr ele id row not found check ...
364: hr_utility.set_location ( 'l_object_id (ELE) : '||l_object_id, 15);
365:
366: CLOSE csr_get_ele_id;
367: ELSIF p_object_type = 'BAL'
368: THEN

Line 379: hr_utility.set_location ( 'l_object_id (BAL) : '||l_object_id, 15);

375: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
376: fnd_message.set_token ('BALANCE_TYPE', p_object_name);
377: fnd_message.raise_error;
378: END IF; -- End if of csr bal id row not found check ...
379: hr_utility.set_location ( 'l_object_id (BAL) : '||l_object_id, 15);
380:
381: CLOSE csr_get_bal_id;
382: END IF; -- End if of object type = ele check ...
383:

Line 385: hr_utility.set_location ( 'Leaving: '

381: CLOSE csr_get_bal_id;
382: END IF; -- End if of object type = ele check ...
383:
384: --
385: hr_utility.set_location ( 'Leaving: '
386: || l_proc_name, 20);
387: --
388: RETURN l_object_id;
389: --

Line 430: hr_utility.set_location ( 'Entering '

426: BEGIN
427: --
428:
429: --
430: hr_utility.set_location ( 'Entering '
431: || l_proc_name, 10);
432: --
433: OPEN csr_getinput (p_ele_name, p_ip_name);
434:

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

435: LOOP
436: FETCH csr_getinput INTO csr_getinput_rec;
437: EXIT WHEN csr_getinput%NOTFOUND;
438: --
439: hr_utility.set_location (l_proc_name, 20);
440: --
441:
442: OPEN csr_updinput (
443: csr_getinput_rec.input_value_id

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

447: LOOP
448: FETCH csr_updinput INTO csr_updinput_rec;
449: EXIT WHEN csr_updinput%NOTFOUND;
450: --
451: hr_utility.set_location (l_proc_name, 30);
452:
453: --
454:
455: UPDATE pay_input_values_f

Line 465: hr_utility.set_location ( 'Leaving '

461: END LOOP;
462:
463: CLOSE csr_getinput;
464: --
465: hr_utility.set_location ( 'Leaving '
466: || l_proc_name, 40);
467: --
468:
469: END update_ipval_defval;

Line 503: hr_utility.set_location ( 'Entering: '

499: l_er_request_id NUMBER;
500: l_proc_name VARCHAR2 (80) := g_proc_name
501: || 'compile_formula';
502: BEGIN
503: hr_utility.set_location ( 'Entering: '
504: || l_proc_name, 10);
505:
506:
507: -- ------------------------------------------------------------

Line 515: hr_utility.set_location (

511: FOR fra_rec IN csr_get_ff_id (
512: c_element_type_id => p_element_type_id
513: )
514: LOOP
515: hr_utility.set_location (
516: '..FF Name :'
517: || fra_rec.formula_name
518: ,15
519: );

Line 520: hr_utility.set_location (

516: '..FF Name :'
517: || fra_rec.formula_name
518: ,15
519: );
520: hr_utility.set_location (
521: '..FF Type Name :'
522: || fra_rec.formula_type_name
523: ,20
524: );

Line 539: hr_utility.set_location (

535: THEN
536: l_request_id := ff_formula_webui_pkg.submit_singlecompile
537: (p_formula_type => fra_rec.formula_type_name --Oracle Payroll
538: ,p_formula_name => fra_rec.formula_name); --formula name
539: hr_utility.set_location (
540: '..Request Id :'
541: || l_request_id
542: ,25
543: );

Line 549: hr_utility.set_location ( 'Leaving: '

545: g_tab_formula_ids (fra_rec.formula_id) := fra_rec.formula_id;
546: END IF; -- End if of formula id exists in collection check ...
547: END LOOP;
548:
549: hr_utility.set_location ( 'Leaving: '
550: || l_proc_name, 30);
551: END compile_formula;
552:
553:

Line 563: hr_utility.set_location ( 'Entering : chk_scheme_prefix ', 10);

559: l_element_name VARCHAR2 (100) := p_scheme_prefix;
560: l_output VARCHAR2 (100);
561: l_rgeflg VARCHAR2 (100);
562: BEGIN
563: hr_utility.set_location ( 'Entering : chk_scheme_prefix ', 10);
564:
565: hr_chkfmt.checkformat (
566: VALUE => l_element_name
567: ,format => 'PAY_NAME'

Line 576: hr_utility.set_location ( 'Exiting : chk_scheme_prefix ', 20);

572: ,rgeflg => l_rgeflg
573: ,curcode => NULL
574: );
575:
576: hr_utility.set_location ( 'Exiting : chk_scheme_prefix ', 20);
577:
578: EXCEPTION
579: WHEN OTHERS
580: THEN

Line 617: hr_utility.set_location ( 'Entering: '

613: --
614:
615: BEGIN
616: --
617: hr_utility.set_location ( 'Entering: '
618: || l_proc_name, 10);
619: --
620:
621: OPEN csr_get_bal_info;

Line 631: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);

627: fnd_message.set_name ('PQP', 'PQP_230549_BAL_TYPE_NOT_FOUND');
628: fnd_message.raise_error;
629: END IF; -- End if of row found check ...
630:
631: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);
632:
633: CLOSE csr_get_bal_info;
634: --
635: hr_utility.set_location ( 'Leaving: '

Line 635: hr_utility.set_location ( 'Leaving: '

631: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);
632:
633: CLOSE csr_get_bal_info;
634: --
635: hr_utility.set_location ( 'Leaving: '
636: || l_proc_name, 20);
637: RETURN l_balance_name;
638: --
639: END get_balance_info;

Line 668: hr_utility.set_location ( 'Entering: '

664: --
665:
666: BEGIN
667: --
668: hr_utility.set_location ( 'Entering: '
669: || l_proc_name, 10);
670: --
671:
672: OPEN csr_get_ele_class_info;

Line 682: hr_utility.set_location ( 'l_ele_class_info : '|| l_ele_class_info.classification_name, 20);

678: l_ele_class_info.classification_name;
679: p_default_priority := l_ele_class_info.default_priority;
680: END IF; -- End if of row found check ...
681:
682: hr_utility.set_location ( 'l_ele_class_info : '|| l_ele_class_info.classification_name, 20);
683:
684: CLOSE csr_get_ele_class_info;
685: --
686: hr_utility.set_location ( 'Leaving: '

Line 686: hr_utility.set_location ( 'Leaving: '

682: hr_utility.set_location ( 'l_ele_class_info : '|| l_ele_class_info.classification_name, 20);
683:
684: CLOSE csr_get_ele_class_info;
685: --
686: hr_utility.set_location ( 'Leaving: '
687: || l_proc_name, 20);
688: --
689:
690: EXCEPTION

Line 693: hr_utility.set_location (

689:
690: EXCEPTION
691: WHEN OTHERS
692: THEN
693: hr_utility.set_location (
694: 'Others Exception: '
695: || l_proc_name
696: ,30
697: );

Line 698: hr_utility.set_location ( 'Leaving: '

694: 'Others Exception: '
695: || l_proc_name
696: ,30
697: );
698: hr_utility.set_location ( 'Leaving: '
699: || l_proc_name, 40);
700: p_classification_name := NULL;
701: p_default_priority := NULL;
702: RAISE;

Line 729: hr_utility.set_location ( 'Entering: '

725: l_iterative_priority NUMBER;
726: --
727: BEGIN
728: --
729: hr_utility.set_location ( 'Entering: '
730: || l_proc_name, 10);
731: --
732: OPEN csr_get_prs_priority;
733: FETCH csr_get_prs_priority INTO l_processing_priority;

Line 738: hr_utility.set_location ( 'Leaving: '

734: CLOSE csr_get_prs_priority;
735: l_iterative_priority := 400
736: - l_processing_priority;
737: --
738: hr_utility.set_location ( 'Leaving: '
739: || l_proc_name, 20);
740: --
741:
742: RETURN l_iterative_priority;

Line 783: hr_utility.set_location ( 'Entering: '

779: l_tab_pension_types t_pension_types;
780: --
781: BEGIN
782: --
783: hr_utility.set_location ( 'Entering: '
784: || l_proc_name, 10);
785: --
786:
787: OPEN csr_get_pension_type_info;

Line 799: hr_utility.set_location ( 'l_pension_type_info : '|| l_pension_type_info.pension_type_name, 20);

795: END IF; -- End if of pension type row found check ...
796:
797: CLOSE csr_get_pension_type_info;
798:
799: hr_utility.set_location ( 'l_pension_type_info : '|| l_pension_type_info.pension_type_name, 20);
800:
801:
802: l_tab_pension_types (p_pension_type_id).pension_type_id :=
803: l_pension_type_info.pension_type_id;

Line 825: hr_utility.set_location ( 'Leaving: '

821: l_pension_type_info.ee_contribution_bal_type_id;
822: l_tab_pension_types (p_pension_type_id).er_contribution_bal_type_id :=
823: l_pension_type_info.er_contribution_bal_type_id;
824: --
825: hr_utility.set_location ( 'Leaving: '
826: || l_proc_name, 20);
827: --
828:
829: RETURN l_tab_pension_types;

Line 926: hr_utility.set_location ( 'Entering: '

922: l_scon_number pay_element_type_extra_info.eei_information1%TYPE;
923: --
924: BEGIN
925: --
926: hr_utility.set_location ( 'Entering: '
927: || l_proc_name, 10);
928: --
929: -- Check mandatory arguments first
930: -- Pension Scheme Name

Line 931: hr_utility.set_location('Pension Scheme Name',15);

927: || l_proc_name, 10);
928: --
929: -- Check mandatory arguments first
930: -- Pension Scheme Name
931: hr_utility.set_location('Pension Scheme Name',15);
932:
933: hr_api.mandatory_arg_error (
934: p_api_name => l_proc_name
935: ,p_argument => 'Pension Scheme Name'

Line 940: hr_utility.set_location('Pension Year Start Date',15);

936: ,p_argument_value => p_pension_scheme_name
937: );
938:
939: -- Pension Year Start Date
940: hr_utility.set_location('Pension Year Start Date',15);
941: hr_api.mandatory_arg_error (
942: p_api_name => l_proc_name
943: ,p_argument => 'Pension Year Start Date'
944: ,p_argument_value => p_pension_year_start_dt

Line 948: hr_utility.set_location('Effective Start Date',15);

944: ,p_argument_value => p_pension_year_start_dt
945: );
946:
947: -- Effective Start Date
948: hr_utility.set_location('Effective Start Date',15);
949: hr_api.mandatory_arg_error (
950: p_api_name => l_proc_name
951: ,p_argument => 'Effective Start Date'
952: ,p_argument_value => p_effective_start_date

Line 955: hr_utility.set_location('Pension Category',15);

951: ,p_argument => 'Effective Start Date'
952: ,p_argument_value => p_effective_start_date
953: );
954:
955: hr_utility.set_location('Pension Category',15);
956: -- Pension Category
957: hr_api.mandatory_arg_error (
958: p_api_name => l_proc_name
959: ,p_argument => 'Pension Category'

Line 963: hr_utility.set_location('Pension Provider ID',15);

959: ,p_argument => 'Pension Category'
960: ,p_argument_value => p_pension_category
961: );
962:
963: hr_utility.set_location('Pension Provider ID',15);
964: -- Pension Provider
965: hr_api.mandatory_arg_error (
966: p_api_name => l_proc_name
967: ,p_argument => 'Pension Provider ID'

Line 971: hr_utility.set_location('Pension Type ID',15);

967: ,p_argument => 'Pension Provider ID'
968: ,p_argument_value => p_pension_provider_id
969: );
970:
971: hr_utility.set_location('Pension Type ID',15);
972: -- Pension Type
973: hr_api.mandatory_arg_error (
974: p_api_name => l_proc_name
975: ,p_argument => 'Pension Type ID'

Line 979: hr_utility.set_location('Employee Deduction Method',15);

975: ,p_argument => 'Pension Type ID'
976: ,p_argument_value => p_pension_type_id
977: );
978:
979: hr_utility.set_location('Employee Deduction Method',15);
980: -- Employee Deduction Method
981: hr_api.mandatory_arg_error (
982: p_api_name => l_proc_name
983: ,p_argument => 'Employee Deduction Method'

Line 987: hr_utility.set_location('Scheme Prefix',15);

983: ,p_argument => 'Employee Deduction Method'
984: ,p_argument_value => l_emp_deduction_method
985: );
986:
987: hr_utility.set_location('Scheme Prefix',15);
988: -- Element Base Name
989: hr_api.mandatory_arg_error (
990: p_api_name => l_proc_name
991: ,p_argument => 'Scheme Prefix'

Line 995: hr_utility.set_location('Reporting Name',15);

991: ,p_argument => 'Scheme Prefix'
992: ,p_argument_value => p_ele_base_name
993: );
994:
995: hr_utility.set_location('Reporting Name',15);
996: -- Reporting Name
997: hr_api.mandatory_arg_error (
998: p_api_name => l_proc_name
999: ,p_argument => 'Reporting Name'

Line 1003: hr_utility.set_location('Classification',15);

999: ,p_argument => 'Reporting Name'
1000: ,p_argument_value => p_ele_reporting_name
1001: );
1002:
1003: hr_utility.set_location('Classification',15);
1004: -- Element Classification
1005: hr_api.mandatory_arg_error (
1006: p_api_name => l_proc_name
1007: ,p_argument => 'Classification'

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

1018: );
1019: END IF; -- End if of pension category is AVC check ...
1020:
1021: --
1022: hr_utility.set_location (l_proc_name, 20);
1023:
1024: --
1025: -- Check pension category lookup code
1026: --

Line 1039: hr_utility.set_location (l_proc_name, 25);

1035: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1036: fnd_message.set_token ('COLUMN', 'Pension Category');
1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1038:
1039: hr_utility.set_location (l_proc_name, 25);
1040:
1041: fnd_message.raise_error;
1042: END IF; -- End if of not exists in lookup check ...
1043:

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

1042: END IF; -- End if of not exists in lookup check ...
1043:
1044: -- Check Pension Provider exists for this BG
1045: --
1046: hr_utility.set_location (l_proc_name, 30);
1047: --
1048:
1049: OPEN csr_chk_provider_exists;
1050: FETCH csr_chk_provider_exists INTO l_exists;

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

1058:
1059: CLOSE csr_chk_provider_exists;
1060: -- Get Pension Type Info
1061: --
1062: hr_utility.set_location (l_proc_name, 30);
1063:
1064: --
1065:
1066: IF NOT g_tab_pension_types_info.EXISTS (p_pension_type_id)

Line 1099: hr_utility.set_location (l_proc_name, 40);

1095: END IF; -- End if of pension category in pension type matches with parameter check ...
1096:
1097: -- Check pension type is supported by this pension provider
1098: --
1099: hr_utility.set_location (l_proc_name, 40);
1100: --
1101:
1102: OPEN csr_chk_pens_type_in_prov;
1103: FETCH csr_chk_pens_type_in_prov INTO l_exists;

Line 1115: hr_utility.set_location (l_proc_name, 50);

1111:
1112: CLOSE csr_chk_pens_type_in_prov;
1113: -- Check employee deduction method in lookup
1114: --
1115: hr_utility.set_location (l_proc_name, 50);
1116:
1117: --
1118: IF hr_api.not_exists_in_hr_lookups (
1119: p_effective_date => p_effective_start_date

Line 1136: hr_utility.set_location (l_proc_name, 60);

1132: END IF; -- End if of not exists in lookup check ...
1133:
1134: -- Check employer deduction method in lookup
1135: --
1136: hr_utility.set_location (l_proc_name, 60);
1137:
1138: --
1139: IF p_eer_deduction_method IS NOT NULL
1140: THEN

Line 1161: -- hr_utility.set_location (l_proc_name, 70);

1157:
1158: -- NOT required now
1159: -- Check scon if pension category is OCP
1160: --
1161: -- hr_utility.set_location (l_proc_name, 70);
1162: --
1163: -- --
1164: --
1165: -- IF p_pension_category = 'OCP'

Line 1177: hr_utility.set_location (l_proc_name, 80);

1173: -- END IF; -- End if of pension category is OCP check ...
1174:
1175: -- Check deduction method codes for Additional contributions
1176: --
1177: hr_utility.set_location (l_proc_name, 80);
1178:
1179: --
1180:
1181: IF p_additional_contribution IS NOT NULL

Line 1205: hr_utility.set_location (l_proc_name, 90);

1201: END IF; -- End if of additional contribution deduction method specified check ...
1202:
1203: -- Check deduction method codes for Addded Years contributions
1204: --
1205: hr_utility.set_location (l_proc_name, 90);
1206:
1207: --
1208:
1209: IF p_added_years IS NOT NULL

Line 1233: hr_utility.set_location (l_proc_name, 100);

1229: END IF; -- End if of added years deduction method specified check ...
1230:
1231: -- Check deduction method codes for Family Widower
1232: --
1233: hr_utility.set_location (l_proc_name, 100);
1234:
1235: --
1236:
1237: IF p_family_widower IS NOT NULL

Line 1262: hr_utility.set_location (l_proc_name, 90);

1258:
1259:
1260: -- Check deduction method codes for Family Widower Addded Years contributions
1261: --
1262: hr_utility.set_location (l_proc_name, 90);
1263:
1264: --
1265:
1266: IF p_fwc_added_years IS NOT NULL

Line 1292: hr_utility.set_location (l_proc_name, 110);

1288:
1289:
1290: -- Check pension scheme type
1291: --
1292: hr_utility.set_location (l_proc_name, 110);
1293:
1294: --
1295:
1296: IF p_pension_scheme_type IS NOT NULL

Line 1339: hr_utility.set_location (l_proc_name, 111);

1335: -- END IF; -- End if of scon or econ is null check ...
1336: END IF; -- End if of pension scheme type specified check ...
1337:
1338: --
1339: hr_utility.set_location (l_proc_name, 111);
1340:
1341: --
1342:
1343: -- Added validation for SCON format

Line 1361: hr_utility.set_location (l_proc_name, 112);

1357: END IF; -- End if of scon number in invalid check ...
1358: END IF; -- End if of scon number entered check ...
1359:
1360: --
1361: hr_utility.set_location (l_proc_name, 112);
1362:
1363: -- Added validation for ECON format
1364: IF p_econ_number IS NOT NULL
1365: THEN

Line 1384: hr_utility.set_location (l_proc_name, 115);

1380: END IF; -- End if of econ number in invalid check ...
1381: END IF; -- End if of econ number entered check ...
1382:
1383: --
1384: hr_utility.set_location (l_proc_name, 115);
1385:
1386: --
1387:
1388: -- Check associated OCP element id validity

Line 1407: hr_utility.set_location (l_proc_name, 120);

1403: END IF; -- End if of associated ocp ele id not null check ...
1404:
1405: -- Check post termination rule
1406: --
1407: hr_utility.set_location (l_proc_name, 120);
1408:
1409: --
1410:
1411: IF hr_api.not_exists_in_hr_lookups (

Line 1428: hr_utility.set_location ( 'Leaving: '

1424: fnd_message.raise_error;
1425: END IF; -- End if of not exists in lookup check ...
1426:
1427: --
1428: hr_utility.set_location ( 'Leaving: '
1429: || l_proc_name, 130);
1430: --
1431: END insert_validate;
1432:

Line 1460: hr_utility.set_location ( 'Entering: '

1456: l_formula_id NUMBER;
1457: --
1458: BEGIN
1459: --
1460: hr_utility.set_location ( 'Entering: '
1461: || l_proc_name, 10);
1462: --
1463: OPEN csr_get_formula_info;
1464: FETCH csr_get_formula_info INTO l_formula_id;

Line 1475: hr_utility.set_location ( 'Leaving: '

1471: END IF; -- End if of csr row not found check ...
1472:
1473: CLOSE csr_get_formula_info;
1474: --
1475: hr_utility.set_location ( 'Leaving: '
1476: || l_proc_name, 20);
1477: --
1478: RETURN l_formula_id;
1479: END get_shadow_formula_id;

Line 1509: hr_utility.set_location ( 'Entering: '

1505: l_formula_text pay_shadow_formulas.formula_text%type;
1506: --
1507: BEGIN
1508: --
1509: hr_utility.set_location ( 'Entering: '
1510: || l_proc_name, 10);
1511: --
1512: OPEN csr_get_formula_info;
1513: FETCH csr_get_formula_info INTO l_formula_text;

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

1522: CLOSE csr_get_formula_info;
1523: l_formula_text :=
1524: REPLACE (l_formula_text, p_search_string, p_replace_string);
1525: --
1526: hr_utility.set_location (l_proc_name, 20);
1527:
1528: --
1529: UPDATE pay_shadow_formulas
1530: SET formula_text = l_formula_text

Line 1534: hr_utility.set_location ( 'Leaving: '

1530: SET formula_text = l_formula_text
1531: WHERE formula_id = p_formula_id;
1532:
1533: --
1534: hr_utility.set_location ( 'Leaving: '
1535: || l_proc_name, 30);
1536:
1537: --
1538: END update_shadow_formula;

Line 1572: hr_utility.set_location ( 'Entering: '

1568: l_element_type_id NUMBER;
1569: --
1570: BEGIN
1571: --
1572: hr_utility.set_location ( 'Entering: '
1573: || l_proc_name, 10);
1574:
1575: IF p_element_type_id IS NULL
1576: THEN

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

1585: l_element_type_id := p_element_type_id;
1586: END IF; -- End if of p_element_type_id is null check ...
1587:
1588: --
1589: hr_utility.set_location (l_proc_name, 20);
1590: --
1591: OPEN csr_get_ipv_info (l_element_type_id);
1592: FETCH csr_get_ipv_info INTO l_input_value_id;
1593:

Line 1605: hr_utility.set_location ( 'Leaving: '

1601:
1602: CLOSE csr_get_ipv_info;
1603:
1604: --
1605: hr_utility.set_location ( 'Leaving: '
1606: || l_proc_name, 20);
1607: --
1608: RETURN l_input_value_id;
1609: END get_input_value_id;

Line 1631: hr_utility.set_location ( 'Entering: '

1627: l_input_value_id NUMBER;
1628: --
1629: BEGIN
1630: --
1631: hr_utility.set_location ( 'Entering: '
1632: || l_proc_name, 10);
1633: --
1634:
1635: -- Get input value id

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

1639: ,p_element_type_id => p_element_type_id
1640: ,p_element_name => NULL
1641: );
1642: --
1643: hr_utility.set_location (l_proc_name, 20);
1644:
1645: --
1646: UPDATE pay_input_values_f
1647: SET mandatory_flag = p_mandatory_flag

Line 1653: hr_utility.set_location ( 'Leaving: '

1649: AND p_effective_start_date BETWEEN effective_start_date
1650: AND effective_end_date;
1651:
1652: --
1653: hr_utility.set_location ( 'Leaving: '
1654: || l_proc_name, 30);
1655: --
1656: END update_ipv_mandatory_flag;
1657:

Line 1682: hr_utility.set_location ( 'Entering: '

1678: l_balance_feed_id NUMBER;
1679: --
1680: BEGIN
1681: --
1682: hr_utility.set_location ( 'Entering: '
1683: || l_proc_name, 10);
1684: --
1685: -- Get input value id for the input value name
1686:

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

1690: ,p_element_name => p_element_name
1691: ,p_element_type_id => NULL
1692: );
1693: --
1694: hr_utility.set_location (l_proc_name, 20);
1695: --
1696: -- Create Balance Feed
1697: pay_balance_feeds_f_pkg.insert_row (
1698: x_rowid => l_row_id

Line 1710: hr_utility.set_location ( 'Leaving: '

1706: ,x_scale => p_scale
1707: ,x_legislation_subgroup => NULL
1708: );
1709: --
1710: hr_utility.set_location ( 'Leaving: '
1711: || l_proc_name, 30);
1712: --
1713: END create_balance_feeds;
1714:

Line 1739: hr_utility.set_location ( 'Entering: '

1735: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
1736: --
1737: BEGIN
1738: --
1739: hr_utility.set_location ( 'Entering: '
1740: || l_proc_name, 10);
1741: --
1742: OPEN csr_get_scheme_prefix;
1743: FETCH csr_get_scheme_prefix INTO l_scheme_prefix;

Line 1754: hr_utility.set_location ( 'Leaving: '

1750: END IF; -- End if of row not found check ...
1751:
1752: CLOSE csr_get_scheme_prefix;
1753: --
1754: hr_utility.set_location ( 'Leaving: '
1755: || l_proc_name, 20);
1756: --
1757:
1758: RETURN l_scheme_prefix;

Line 1794: hr_utility.set_location ( 'Entering: '

1790: l_login_id NUMBER := fnd_global.login_id;
1791: --
1792: BEGIN
1793: --
1794: hr_utility.set_location ( 'Entering: '
1795: || l_proc_name, 10);
1796: --
1797:
1798: -- Get classification id

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

1809:
1810: CLOSE csr_get_class_id;
1811: -- Insert sub classification rule
1812: --
1813: hr_utility.set_location (l_proc_name, 20);
1814: --
1815:
1816: pay_sub_class_rules_pkg.insert_row (
1817: p_rowid => l_rowid

Line 1832: hr_utility.set_location ( 'Leaving: '

1828: ,p_last_updated_by => l_user_id
1829: ,p_last_update_login => l_login_id
1830: );
1831: --
1832: hr_utility.set_location ( 'Leaving: '
1833: || l_proc_name, 30);
1834: --
1835: END create_sub_class_rules;
1836:

Line 1845: hr_utility.set_location ( 'Entering : '

1841: --==============================================================================
1842:
1843: BEGIN
1844: --
1845: hr_utility.set_location ( 'Entering : '
1846: || l_proc_name, 10);
1847: --
1848:
1849: -- Check scheme prefix

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

1848:
1849: -- Check scheme prefix
1850: chk_scheme_prefix (p_scheme_prefix => p_ele_base_name);
1851: --
1852: hr_utility.set_location (l_proc_name, 20);
1853: --
1854:
1855: OPEN csr_chk_uniq_base_name;
1856: FETCH csr_chk_uniq_base_name INTO l_exists;

Line 1876: hr_utility.set_location (l_proc_name, 25);

1872: END IF; -- Cursor is open check ...
1873:
1874: -- Validate all the parameters before processing
1875: --
1876: hr_utility.set_location (l_proc_name, 25);
1877:
1878: --
1879:
1880: IF p_validate

Line 1924: hr_utility.set_location (l_proc_name, 50);

1920: -- Set employees contribution exclusion rule based
1921: -- on pension category
1922:
1923: --
1924: hr_utility.set_location (l_proc_name, 50);
1925:
1926: --
1927:
1928: IF p_pension_category = 'OCP'

Line 1949: hr_utility.set_location (l_proc_name, 60);

1945: -- Set employees input value exclusion rule based
1946: -- on employees deduction method
1947:
1948: --
1949: hr_utility.set_location (l_proc_name, 60);
1950: --
1951:
1952: -- Check whether the pension type supports the employee
1953: -- and employer deduction method chosen

Line 2047: hr_utility.set_location (l_proc_name, 70);

2043: -- Set employers contribution exclusion rule based
2044: -- on employer deduction method
2045:
2046: --
2047: hr_utility.set_location (l_proc_name, 70);
2048:
2049: --
2050:
2051: IF p_eer_deduction_method = 'PE'

Line 2147: hr_utility.set_location (l_proc_name, 80);

2143: -- Set exclusion rules for additional, added and family widower
2144: -- contributions
2145:
2146: --
2147: hr_utility.set_location (l_proc_name, 80);
2148:
2149: --
2150:
2151: IF p_additional_contribution = 'PE'

Line 2213: hr_utility.set_location (l_proc_name, 90);

2209: l_exc_bb_fwc_rule_id := NULL;
2210: END IF; -- End if of added years check ...
2211: -- Get element classification name
2212: --
2213: hr_utility.set_location (l_proc_name, 90);
2214: --
2215:
2216: get_ele_classification_info (
2217: p_classification_id => p_ele_classification_id

Line 2249: hr_utility.set_location (l_proc_name, 100);

2245:
2246: -- Set exclusion rule for superannuable salary balance
2247: -- based on pensionable salary information
2248: --
2249: hr_utility.set_location (l_proc_name, 100);
2250:
2251: --
2252:
2253: IF p_pensionable_sal_bal_id IS NULL

Line 2276: hr_utility.set_location (l_proc_name, 110);

2272:
2273: -- Get Source Template ID
2274:
2275: --
2276: hr_utility.set_location (l_proc_name, 110);
2277: --
2278:
2279: l_source_template_id :=
2280: get_template_id (p_legislation_code => g_template_leg_code);

Line 2312: hr_utility.set_location (l_proc_name, 120);

2308: Config24 -- l_exc_fsavc_eer_rule_id
2309:
2310: ---------------------------------------------------------------------------*/
2311: --
2312: hr_utility.set_location (l_proc_name, 120);
2313: --
2314:
2315: --
2316: -- create user structure from the template

Line 2357: hr_utility.set_location (l_proc_name, 130);

2353: ,p_object_version_number => l_object_version_number
2354: ,p_allow_base_name_reuse => TRUE
2355: );
2356: --
2357: hr_utility.set_location (l_proc_name, 130);
2358: --
2359: ---------------------------- Update Shadow Structure ----------------------
2360: --
2361:

Line 2389: hr_utility.set_location (l_proc_name, 140);

2385: l_iterative_formula := 'PQP_GB_ITERATIVE_PRETAX';
2386: END IF; -- End if of iterative flag = Y check ...
2387:
2388: --
2389: hr_utility.set_location (l_proc_name, 140);
2390: --
2391:
2392: pay_shadow_element_api.update_shadow_element (
2393: p_validate => FALSE

Line 2410: hr_utility.set_location (l_proc_name, 150);

2406: ,p_post_termination_rule => p_termination_rule
2407: ,p_object_version_number => l_ele_obj_ver_number
2408: );
2409: --
2410: hr_utility.set_location (l_proc_name, 150);
2411:
2412: --
2413:
2414: -- Employer Pension Element

Line 2455: hr_utility.set_location (l_proc_name, 170);

2451: FETCH csr_get_shadow_ele_info INTO l_element_type_id
2452: ,l_ele_obj_ver_number;
2453: EXIT WHEN csr_get_shadow_ele_info%NOTFOUND;
2454: --
2455: hr_utility.set_location (l_proc_name, 170);
2456:
2457: --
2458:
2459: pay_shadow_element_api.update_shadow_element (

Line 2478: hr_utility.set_location (l_proc_name, 180);

2474: END LOOP;
2475: END IF; -- End if of i > 1 check ...
2476:
2477: --
2478: hr_utility.set_location (l_proc_name, 180);
2479: --
2480:
2481: -- set counter initial value
2482: j := l_ele_name.LAST;

Line 2586: hr_utility.set_location (l_proc_name, 190);

2582: );
2583: END IF; -- End if of iterative flag = Y check ...
2584:
2585: --
2586: hr_utility.set_location (l_proc_name, 190);
2587: --
2588:
2589: pay_shadow_element_api.update_shadow_element (
2590: p_validate => FALSE

Line 2612: hr_utility.set_location (l_proc_name, 200);

2608:
2609: -- Update shadow structure for Balances
2610:
2611: --
2612: hr_utility.set_location (l_proc_name, 200);
2613:
2614: --
2615:
2616: -- Employer Pension Balance

Line 2653: hr_utility.set_location (l_proc_name, 185);

2649: l_associated_ocp_base_name :=
2650: get_scheme_prefix (p_element_type_id => p_associated_ocp_ele_id);
2651: l_associated_ocp_base_name :=
2652: UPPER (TRANSLATE (TRIM (l_associated_ocp_base_name), ' ', '_'));
2653: hr_utility.set_location (l_proc_name, 185);
2654: --
2655: l_ees_cont_formula_id :=
2656: get_shadow_formula_id (p_formula_name => l_ees_cont_formula);
2657: --

Line 2658: hr_utility.set_location (l_proc_name, 186);

2654: --
2655: l_ees_cont_formula_id :=
2656: get_shadow_formula_id (p_formula_name => l_ees_cont_formula);
2657: --
2658: hr_utility.set_location (l_proc_name, 186);
2659: --
2660: l_search_string := '';
2661: l_replace_string := l_associated_ocp_base_name;
2662: update_shadow_formula (

Line 2675: hr_utility.set_location (l_proc_name, 191);

2671: IF l_exc_ers_rule_id IS NULL
2672: THEN
2673: -- Update the employer contribution formula
2674: --
2675: hr_utility.set_location (l_proc_name, 191);
2676: --
2677: l_ers_cont_formula_id :=
2678: get_shadow_formula_id (p_formula_name => l_ers_cont_formula);
2679: --

Line 2680: hr_utility.set_location (l_proc_name, 192);

2676: --
2677: l_ers_cont_formula_id :=
2678: get_shadow_formula_id (p_formula_name => l_ers_cont_formula);
2679: --
2680: hr_utility.set_location (l_proc_name, 192);
2681: --
2682: l_search_string := '';
2683: l_replace_string := p_pension_category;
2684: update_shadow_formula (

Line 2691: hr_utility.set_location (l_proc_name, 193);

2687: ,p_replace_string => l_replace_string
2688: );
2689: -- Check whether the pension category is AVC
2690: --
2691: hr_utility.set_location (l_proc_name, 193);
2692:
2693: --
2694: IF l_exc_avc_rule_id IS NULL
2695: THEN

Line 2749: hr_utility.set_location (l_proc_name, 201);

2745:
2746: IF p_pensionable_sal_bal_id IS NOT NULL
2747: THEN
2748: --
2749: hr_utility.set_location (l_proc_name, 201);
2750: --
2751: -- Get the balance name
2752: l_pensionable_sal_bal_name :=
2753: get_balance_info (p_balance_type_id => p_pensionable_sal_bal_id);

Line 2756: hr_utility.set_location (l_proc_name, 202);

2752: l_pensionable_sal_bal_name :=
2753: get_balance_info (p_balance_type_id => p_pensionable_sal_bal_id);
2754: -- Update the employee contribution formula
2755: --
2756: hr_utility.set_location (l_proc_name, 202);
2757: --
2758: l_ees_cont_formula_id :=
2759: get_shadow_formula_id (p_formula_name => l_ees_cont_formula);
2760: --

Line 2761: hr_utility.set_location (l_proc_name, 203);

2757: --
2758: l_ees_cont_formula_id :=
2759: get_shadow_formula_id (p_formula_name => l_ees_cont_formula);
2760: --
2761: hr_utility.set_location (l_proc_name, 203);
2762: --
2763: l_search_string :=
2764: l_format_base_name
2765: || '_SUPERANNUABLE_SALARY';

Line 2778: hr_utility.set_location (l_proc_name, 204);

2774: IF l_exc_ers_rule_id IS NULL
2775: THEN
2776: -- Update the employer contribution formula
2777: --
2778: hr_utility.set_location (l_proc_name, 204);
2779: --
2780: l_ers_cont_formula_id :=
2781: get_shadow_formula_id (p_formula_name => l_ers_cont_formula);
2782: --

Line 2783: hr_utility.set_location (l_proc_name, 205);

2779: --
2780: l_ers_cont_formula_id :=
2781: get_shadow_formula_id (p_formula_name => l_ers_cont_formula);
2782: --
2783: hr_utility.set_location (l_proc_name, 205);
2784: --
2785: update_shadow_formula (
2786: p_formula_id => l_ers_cont_formula_id
2787: ,p_search_string => l_search_string

Line 2796: hr_utility.set_location (l_proc_name, 204);

2792: IF l_exc_adl_rule_id IS NULL
2793: THEN
2794: -- Update the additional contribution formula
2795: --
2796: hr_utility.set_location (l_proc_name, 204);
2797: --
2798: l_adl_cont_formula_id :=
2799: get_shadow_formula_id (p_formula_name => l_adl_cont_formula);
2800: --

Line 2801: hr_utility.set_location (l_proc_name, 205);

2797: --
2798: l_adl_cont_formula_id :=
2799: get_shadow_formula_id (p_formula_name => l_adl_cont_formula);
2800: --
2801: hr_utility.set_location (l_proc_name, 205);
2802: --
2803: update_shadow_formula (
2804: p_formula_id => l_adl_cont_formula_id
2805: ,p_search_string => l_search_string

Line 2814: hr_utility.set_location (l_proc_name, 206);

2810: IF l_exc_ayr_rule_id IS NULL
2811: THEN
2812: -- Update the added years contribution formula
2813: --
2814: hr_utility.set_location (l_proc_name, 206);
2815: --
2816: l_ayr_cont_formula_id :=
2817: get_shadow_formula_id (p_formula_name => l_ayr_cont_formula);
2818: --

Line 2819: hr_utility.set_location (l_proc_name, 207);

2815: --
2816: l_ayr_cont_formula_id :=
2817: get_shadow_formula_id (p_formula_name => l_ayr_cont_formula);
2818: --
2819: hr_utility.set_location (l_proc_name, 207);
2820: --
2821: update_shadow_formula (
2822: p_formula_id => l_ayr_cont_formula_id
2823: ,p_search_string => l_search_string

Line 2832: hr_utility.set_location (l_proc_name, 208);

2828: IF l_exc_fwd_rule_id IS NULL
2829: THEN
2830: -- Update the family widower contribution formula
2831: --
2832: hr_utility.set_location (l_proc_name, 208);
2833: --
2834: l_fwd_cont_formula_id :=
2835: get_shadow_formula_id (p_formula_name => l_fwd_cont_formula);
2836: --

Line 2837: hr_utility.set_location (l_proc_name, 209);

2833: --
2834: l_fwd_cont_formula_id :=
2835: get_shadow_formula_id (p_formula_name => l_fwd_cont_formula);
2836: --
2837: hr_utility.set_location (l_proc_name, 209);
2838: --
2839: update_shadow_formula (
2840: p_formula_id => l_fwd_cont_formula_id
2841: ,p_search_string => l_search_string

Line 2851: hr_utility.set_location (l_proc_name, 206);

2847: IF l_exc_bb_fwc_rule_id IS NULL
2848: THEN
2849: -- Update the added years family widower contribution formula
2850: --
2851: hr_utility.set_location (l_proc_name, 206);
2852: --
2853: l_bb_fwc_cont_formula_id :=
2854: get_shadow_formula_id (p_formula_name => l_bb_fwc_cont_formula);
2855: --

Line 2856: hr_utility.set_location (l_proc_name, 207);

2852: --
2853: l_bb_fwc_cont_formula_id :=
2854: get_shadow_formula_id (p_formula_name => l_bb_fwc_cont_formula);
2855: --
2856: hr_utility.set_location (l_proc_name, 207);
2857: --
2858: update_shadow_formula (
2859: p_formula_id => l_bb_fwc_cont_formula_id
2860: ,p_search_string => l_search_string

Line 2873: hr_utility.set_location (l_proc_name, 210);

2869:
2870: -------------------------------------------------------------------------
2871: --
2872: --
2873: hr_utility.set_location (l_proc_name, 210);
2874:
2875: ---------------------------------------------------------------------------
2876: ---------------------------- Generate Core Objects ------------------------
2877: ---------------------------------------------------------------------------

Line 2887: hr_utility.set_location (l_proc_name, 220);

2883: ,p_hr_to_payroll => FALSE
2884: ,p_template_id => l_template_id
2885: );
2886: --
2887: hr_utility.set_location (l_proc_name, 220);
2888: --
2889:
2890: pay_element_template_api.generate_part2 (
2891: p_validate => FALSE

Line 2903: hr_utility.set_location (l_proc_name, 230);

2899: -- Remember l_cont_iv_name and iv_default_value are already
2900: -- stored for employee contribution element
2901:
2902: --
2903: hr_utility.set_location (l_proc_name, 230);
2904: --
2905: i := 0;
2906: i := i
2907: + 1;

Line 2928: hr_utility.set_location (l_proc_name, 240);

2924: fnd_message.raise_error;
2925: END IF; -- End if of ee contribution balance is null check ...
2926:
2927: --
2928: hr_utility.set_location (l_proc_name, 240);
2929: --
2930:
2931: create_balance_feeds (
2932: p_balance_type_id => g_tab_pension_types_info (

Line 2946: hr_utility.set_location (l_proc_name, 250);

2942: -- so check them before you update the default values
2943: -- safe assumption would be to start checking the exclusion rule
2944:
2945: --
2946: hr_utility.set_location (l_proc_name, 250);
2947:
2948: --
2949:
2950: IF l_exc_ers_cent_rule_id IS NULL

Line 2978: hr_utility.set_location (l_proc_name, 260);

2974: fnd_message.raise_error;
2975: END IF; -- End if of er contribution balance is null check ...
2976:
2977: --
2978: hr_utility.set_location (l_proc_name, 260);
2979: --
2980:
2981: create_balance_feeds (
2982: p_balance_type_id => g_tab_pension_types_info (

Line 2992: hr_utility.set_location (l_proc_name, 270);

2988: );
2989: END IF; -- End if of employer percent rule is null check ...
2990:
2991: --
2992: hr_utility.set_location (l_proc_name, 270);
2993:
2994: --
2995:
2996: IF l_exc_ers_fxd_rule_id IS NULL

Line 3024: hr_utility.set_location (l_proc_name, 280);

3020: fnd_message.raise_error;
3021: END IF; -- End if of er contribution balance is null check ...
3022:
3023: --
3024: hr_utility.set_location (l_proc_name, 280);
3025: --
3026:
3027: create_balance_feeds (
3028: p_balance_type_id => g_tab_pension_types_info (

Line 3038: hr_utility.set_location (l_proc_name, 290);

3034: );
3035: END IF; -- End if of employer fixed rate rule is null check ...
3036:
3037: --
3038: hr_utility.set_location (l_proc_name, 290);
3039: --
3040:
3041: l_base_element_type_id := get_object_id ('ELE', l_ele_name (1));
3042: --

Line 3043: hr_utility.set_location (l_proc_name, 295);

3039: --
3040:
3041: l_base_element_type_id := get_object_id ('ELE', l_ele_name (1));
3042: --
3043: hr_utility.set_location (l_proc_name, 295);
3044: --
3045: -- Get pensionable salary details
3046: l_pensionable_sal_bal_id := NULL;
3047:

Line 3079: hr_utility.set_location (l_proc_name, 300);

3075: l_sub_class_name :=
3076: 'Pre Tax Employee Pension '
3077: || p_pension_scheme_type;
3078: --
3079: hr_utility.set_location (l_proc_name, 300);
3080: --
3081:
3082: create_sub_class_rules (
3083: p_classification_name => l_sub_class_name

Line 3097: hr_utility.set_location (l_proc_name, 310);

3093:
3094: -- Create EEIT for the base element as the values are different
3095:
3096: --
3097: hr_utility.set_location (l_proc_name, 310);
3098: --
3099: -- Create a row in pay_element_extra_info with all the element information
3100:
3101: pay_element_extra_info_api.create_element_extra_info (

Line 3139: hr_utility.set_location (l_proc_name, 320);

3135: ,p_element_type_extra_info_id => l_eei_info_id
3136: ,p_object_version_number => l_ovn_eei
3137: );
3138: --
3139: hr_utility.set_location (l_proc_name, 320);
3140: --
3141:
3142: -- Create a row in pay_element_extra_info with arrearage information
3143: pay_element_extra_info_api.create_element_extra_info (

Line 3159: hr_utility.set_location (l_proc_name, 330);

3155: -- compilation
3156: g_tab_formula_ids.DELETE;
3157: -- Compile formula attached with this base element
3158: --
3159: hr_utility.set_location (l_proc_name, 330);
3160: --
3161: compile_formula (p_element_type_id => l_base_element_type_id);
3162:
3163: FOR i IN 2 .. l_ele_name.COUNT

Line 3165: hr_utility.set_location (l_proc_name, 340);

3161: compile_formula (p_element_type_id => l_base_element_type_id);
3162:
3163: FOR i IN 2 .. l_ele_name.COUNT
3164: LOOP
3165: hr_utility.set_location (l_proc_name, 340);
3166: l_eei_element_type_id := get_object_id ('ELE', l_ele_name (i));
3167: --
3168: hr_utility.set_location (l_proc_name, 350);
3169: --

Line 3168: hr_utility.set_location (l_proc_name, 350);

3164: LOOP
3165: hr_utility.set_location (l_proc_name, 340);
3166: l_eei_element_type_id := get_object_id ('ELE', l_ele_name (i));
3167: --
3168: hr_utility.set_location (l_proc_name, 350);
3169: --
3170:
3171:
3172: --- bug fix : 5128634

Line 3270: hr_utility.set_location (l_proc_name, 360);

3266: ,p_element_type_extra_info_id => l_eei_info_id
3267: ,p_object_version_number => l_ovn_eei
3268: );
3269: --
3270: hr_utility.set_location (l_proc_name, 360);
3271:
3272: --
3273:
3274: -- Do not create arrear info for ers contribution..

Line 3301: hr_utility.set_location (l_proc_name, 370);

3297: END IF; -- End if of ele name not in ERS cont check ...
3298:
3299: -- Compile formula attached with this base element
3300: --
3301: hr_utility.set_location (l_proc_name, 370);
3302: --
3303: compile_formula (p_element_type_id => l_eei_element_type_id);
3304: END LOOP;
3305:

Line 3306: hr_utility.set_location ( 'Leaving :'

3302: --
3303: compile_formula (p_element_type_id => l_eei_element_type_id);
3304: END LOOP;
3305:
3306: hr_utility.set_location ( 'Leaving :'
3307: || l_proc_name, 380);
3308: RETURN l_base_element_type_id;
3309: --
3310: END create_user_template_low;

Line 3439: hr_utility.set_location ( 'Entering: '

3435: l_exists VARCHAR2 (1);
3436: --
3437: BEGIN
3438: --
3439: hr_utility.set_location ( 'Entering: '
3440: || l_proc_name, 10);
3441: --
3442:
3443: OPEN csr_chk_uniq_sch_name;

Line 3460: hr_utility.set_location ( 'Leaving: '

3456: IF csr_chk_uniq_sch_name%ISOPEN THEN
3457: CLOSE csr_chk_uniq_sch_name;
3458: END IF; -- Cursor is open check ...
3459: --
3460: hr_utility.set_location ( 'Leaving: '
3461: || l_proc_name, 20);
3462: --
3463: END chk_scheme_name;
3464:

Line 3473: hr_utility.set_location ( 'Entering : '

3469: --==============================================================================
3470:
3471: BEGIN
3472: --
3473: hr_utility.set_location ( 'Entering : '
3474: || l_proc_name, 10);
3475: --
3476:
3477: ---------------------

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

3481: pay_db_pay_setup.set_session_date (
3482: NVL (l_effective_start_date, SYSDATE)
3483: );
3484: --
3485: hr_utility.set_location (l_proc_name, 20);
3486:
3487: --
3488:
3489: IF (hr_utility.chk_product_install (

Line 3489: IF (hr_utility.chk_product_install (

3485: hr_utility.set_location (l_proc_name, 20);
3486:
3487: --
3488:
3489: IF (hr_utility.chk_product_install (
3490: 'Oracle Payroll'
3491: ,g_template_leg_code
3492: )
3493: )

Line 3498: hr_utility.set_location (l_proc_name, 25);

3494: THEN
3495: -- Check scheme name for its uniqueness
3496: chk_scheme_name;
3497: --
3498: hr_utility.set_location (l_proc_name, 25);
3499: -- Delete the pension type collection
3500: g_tab_pension_types_info.DELETE;
3501:
3502:

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

3506: IF p_emp_deduction_method = 'PEFR'
3507: THEN
3508: -- Set the same base name but pass percentage first
3509: --
3510: hr_utility.set_location (l_proc_name, 30);
3511: --
3512: l_element_type_id :=
3513: create_user_template_low (
3514: p_pension_scheme_name => p_pension_scheme_name

Line 3550: hr_utility.set_location (l_proc_name, 35);

3546: -- Get the pensionable salary balance if a new one is created above
3547: -- so that the same information is used for the fixed rate element
3548:
3549: --
3550: hr_utility.set_location (l_proc_name, 35);
3551:
3552: --
3553:
3554: IF p_pensionable_sal_bal_id IS NULL

Line 3566: hr_utility.set_location (l_proc_name, 40);

3562: END IF; -- End if of pensionable sal bal id null check ...
3563:
3564: -- Change the base name and pass FR now
3565: --
3566: hr_utility.set_location (l_proc_name, 40);
3567: --
3568: l_element_type_id :=
3569: create_user_template_low (
3570: p_pension_scheme_name => p_pension_scheme_name

Line 3606: hr_utility.set_location (l_proc_name, 50);

3602: );
3603: ELSE -- not PEFR
3604: -- Call the low level function with the same parameters
3605: --
3606: hr_utility.set_location (l_proc_name, 50);
3607: --
3608: l_element_type_id :=
3609: create_user_template_low (
3610: p_pension_scheme_name => p_pension_scheme_name

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

3640: ,p_validate => TRUE
3641: );
3642: END IF; -- End if of emp deduction method = PEFR check ...
3643: ELSE
3644: hr_utility.set_message (8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
3645: hr_utility.raise_error;
3646: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
3647:
3648: --

Line 3645: hr_utility.raise_error;

3641: );
3642: END IF; -- End if of emp deduction method = PEFR check ...
3643: ELSE
3644: hr_utility.set_message (8303, 'PQP_230535_GBORAPAY_NOT_FOUND');
3645: hr_utility.raise_error;
3646: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
3647:
3648: --
3649: hr_utility.set_location ( 'Leaving: '

Line 3649: hr_utility.set_location ( 'Leaving: '

3645: hr_utility.raise_error;
3646: END IF; -- IF chk_product_install('Oracle Payroll',g_template_leg_code))
3647:
3648: --
3649: hr_utility.set_location ( 'Leaving: '
3650: || l_proc_name, 60);
3651: --
3652:
3653: RETURN l_element_type_id;

Line 3712: -- hr_utility.trace_on(NULL, 'ag_pension');

3708: BEGIN
3709:
3710: --*********************************
3711: -- AG IMP !!
3712: -- hr_utility.trace_on(NULL, 'ag_pension');
3713:
3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);

Line 3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);

3710: --*********************************
3711: -- AG IMP !!
3712: -- hr_utility.trace_on(NULL, 'ag_pension');
3713:
3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);

Line 3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);

3711: -- AG IMP !!
3712: -- hr_utility.trace_on(NULL, 'ag_pension');
3713:
3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);

Line 3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);

3712: -- hr_utility.trace_on(NULL, 'ag_pension');
3713:
3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);

Line 3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);

3713:
3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);

Line 3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);

3714: hr_utility.set_location('p_pension_scheme_name :' ||p_pension_scheme_name ,5);
3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);

Line 3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);

3715: hr_utility.set_location('p_pension_year_start_dt :' ||p_pension_year_start_dt ,5);
3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);

Line 3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);

3716: hr_utility.set_location(' p_pension_category :' ||p_pension_category ,5);
3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);

Line 3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);

3717: hr_utility.set_location(' p_pension_provider_id :' ||p_pension_provider_id ,5);
3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);

Line 3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);

3718: hr_utility.set_location(' p_pension_type_id :' ||p_pension_type_id ,5);
3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);

Line 3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);

3719: hr_utility.set_location(' p_emp_deduction_method :' ||p_emp_deduction_method ,5);
3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);

Line 3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);

3720: hr_utility.set_location(' p_ele_base_name :' ||p_ele_base_name ,5);
3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);

Line 3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);

3721: hr_utility.set_location(' p_effective_start_date :' ||p_effective_start_date ,5);
3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);

Line 3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);

3722: hr_utility.set_location(' p_ele_reporting_name :' ||p_ele_reporting_name ,5);
3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);

Line 3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);

3723: hr_utility.set_location(' p_ele_classification_id :' ||p_ele_classification_id ,5);
3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);

Line 3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);

3724: hr_utility.set_location(' p_business_group_id :' ||p_business_group_id ,5);
3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);

Line 3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);

3725: hr_utility.set_location(' p_eer_deduction_method :' ||p_eer_deduction_method ,5);
3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);

Line 3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);

3726: hr_utility.set_location(' p_scon_number :' ||p_scon_number ,5);
3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);

Line 3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);

3727: hr_utility.set_location(' p_econ_number :' ||p_econ_number ,5);
3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);

Line 3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);

3728: hr_utility.set_location(' p_additional_contribution:' ||p_additional_contribution ,5);
3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);

Line 3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);

3729: hr_utility.set_location(' p_added_years :' ||p_added_years ,5);
3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);

Line 3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);

3730: hr_utility.set_location(' p_family_widower :' ||p_family_widower ,5);
3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);

Line 3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);

3731: hr_utility.set_location(' p_fwc_added_years :' ||p_fwc_added_years ,5);
3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);

Line 3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);

3732: hr_utility.set_location(' p_scheme_reference_no :' ||p_scheme_reference_no ,5);
3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);

Line 3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);

3733: hr_utility.set_location(' p_employer_reference_no :' ||p_employer_reference_no ,5);
3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);

Line 3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);

3734: hr_utility.set_location(' p_associated_ocp_ele_id :' ||p_associated_ocp_ele_id ,5);
3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);

Line 3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);

3735: hr_utility.set_location(' p_ele_description :' ||p_ele_description ,5);
3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);

Line 3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);

3736: hr_utility.set_location(' p_pension_scheme_type :' ||p_pension_scheme_type ,5);
3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:

Line 3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);

3737: hr_utility.set_location(' p_pensionable_sal_bal_id :' ||p_pensionable_sal_bal_id ,5);
3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:
3745: --**********************************

Line 3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);

3738: hr_utility.set_location(' p_third_party_only_flag :' ||p_third_party_only_flag ,5);
3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:
3745: --**********************************
3746:

Line 3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);

3739: hr_utility.set_location(' p_iterative_processing :' ||p_iterative_processing ,5);
3740: hr_utility.set_location(' p_arrearage_allowed :' ||p_arrearage_allowed ,5);
3741: hr_utility.set_location(' p_partial_deduction :' ||p_partial_deduction ,5);
3742: hr_utility.set_location(' p_termination_rule :' ||p_termination_rule ,5);
3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:
3745: --**********************************
3746:
3747: hr_utility.set_location ( ' Entering:'

Line 3747: hr_utility.set_location ( ' Entering:'

3743: hr_utility.set_location(' p_standard_link :' ||p_standard_link ,5);
3744:
3745: --**********************************
3746:
3747: hr_utility.set_location ( ' Entering:'
3748: || l_proc_name, 10);
3749: l_element_type_id := -1;
3750: --
3751: -- Issue a savepoint

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

3769: --
3770: -- Call API
3771: --
3772: --
3773: hr_utility.set_location (l_proc_name, 20);
3774: --
3775: l_element_type_id :=
3776: create_user_template (
3777: p_pension_scheme_name => p_pension_scheme_name

Line 3809: hr_utility.set_location ( 'l_element_type_id: ' || l_element_type_id, 25);

3805: ,p_termination_rule => p_termination_rule
3806: ,p_standard_link => p_standard_link
3807: );
3808:
3809: hr_utility.set_location ( 'l_element_type_id: ' || l_element_type_id, 25);
3810: --
3811: -- Convert API warning boolean parameter values to specific
3812: -- messages and add them to Multiple Message List
3813: --

Line 3824: hr_utility.set_location ( ' Leaving:'

3820: -- Also disable Multiple Message Detection.
3821: --
3822: l_return_status :=
3823: hr_multi_message.get_return_status_disable;
3824: hr_utility.set_location ( ' Leaving:'
3825: || l_proc_name, 30);
3826: RETURN l_element_type_id;
3827: --
3828: EXCEPTION

Line 3841: hr_utility.set_location ( ' Leaving:'

3837: --
3838: -- Reset IN OUT parameters and set OUT parameters
3839: --
3840: RETURN l_element_type_id;
3841: hr_utility.set_location ( ' Leaving:'
3842: || l_proc_name, 40);
3843: WHEN OTHERS
3844: THEN
3845: --

Line 3856: hr_utility.set_location ( ' Leaving:'

3852: ROLLBACK TO create_user_template_swi;
3853:
3854: IF hr_multi_message.unexpected_error_add (l_proc_name)
3855: THEN
3856: hr_utility.set_location ( ' Leaving:'
3857: || l_proc_name, 50);
3858: RAISE;
3859: END IF;
3860:

Line 3867: hr_utility.set_location ( ' Leaving:'

3863: --
3864: l_return_status :=
3865: hr_multi_message.get_return_status_disable;
3866: RETURN l_element_type_id;
3867: hr_utility.set_location ( ' Leaving:'
3868: || l_proc_name, 60);
3869: END create_user_template_swi;
3870:
3871:

Line 3996: hr_utility.set_location ( 'Entering :'

3992:
3993: --
3994: BEGIN
3995: --
3996: hr_utility.set_location ( 'Entering :'
3997: || l_proc_name, 10);
3998: -- Get the pension category
3999: OPEN csr_get_pens_cat;
4000: FETCH csr_get_pens_cat INTO l_pension_category, l_emp_deduction_method;

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

4050: LOOP
4051: l_template_id := csr_get_template_id_rec.template_id;
4052: END LOOP;
4053:
4054: hr_utility.set_location (l_proc_name, 20);
4055: OPEN csr_get_ele_type_id (l_template_id);
4056:
4057: LOOP
4058: FETCH csr_get_ele_type_id INTO l_element_type_id;

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

4065: FETCH csr_get_eei_info INTO l_eei_info_id;
4066: EXIT WHEN csr_get_eei_info%NOTFOUND;
4067: -- Delete the EEI row
4068: --
4069: hr_utility.set_location (l_proc_name, 30);
4070: --
4071: pay_element_extra_info_api.delete_element_extra_info (
4072: p_validate => FALSE
4073: ,p_element_type_extra_info_id => l_eei_info_id

Line 4083: hr_utility.set_location (l_proc_name, 40);

4079: END LOOP; -- Element type id LOOP
4080:
4081: CLOSE csr_get_ele_type_id;
4082: --
4083: hr_utility.set_location (l_proc_name, 40);
4084: --
4085:
4086: -- Delete sub classification rules if one exist
4087: OPEN csr_chk_sub_class_exists;

Line 4104: hr_utility.set_location (l_proc_name, 50);

4100: END IF; -- End if of sub class row exists check ...
4101:
4102: CLOSE csr_chk_sub_class_exists;
4103: --
4104: hr_utility.set_location (l_proc_name, 50);
4105: --
4106:
4107: pay_element_template_api.delete_user_structure (
4108: p_validate => FALSE

Line 4113: hr_utility.set_location ( 'Leaving :'

4109: ,p_drop_formula_packages => TRUE
4110: ,p_template_id => l_template_id
4111: );
4112: --
4113: hr_utility.set_location ( 'Leaving :'
4114: || l_proc_name, 60);
4115: --
4116:
4117: END delete_user_template;

Line 4143: hr_utility.set_location ( ' Entering:'

4139: l_proc_name VARCHAR2 (80)
4140: := g_proc_name
4141: || 'delete_user_template_swi';
4142: BEGIN
4143: hr_utility.set_location ( ' Entering:'
4144: || l_proc_name, 10);
4145: --
4146: -- Issue a savepoint
4147: --

Line 4187: hr_utility.set_location ( ' Leaving:'

4183: -- Also disable Multiple Message Detection.
4184: --
4185: l_return_status :=
4186: hr_multi_message.get_return_status_disable;
4187: hr_utility.set_location ( ' Leaving:'
4188: || l_proc_name, 20);
4189: --
4190: EXCEPTION
4191: WHEN hr_multi_message.error_message_exist

Line 4202: hr_utility.set_location ( ' Leaving:'

4198: ROLLBACK TO delete_user_template_swi;
4199: --
4200: -- Reset IN OUT parameters and set OUT parameters
4201: --
4202: hr_utility.set_location ( ' Leaving:'
4203: || l_proc_name, 30);
4204: WHEN OTHERS
4205: THEN
4206: --

Line 4217: hr_utility.set_location ( ' Leaving:'

4213: ROLLBACK TO delete_user_template_swi;
4214:
4215: IF hr_multi_message.unexpected_error_add (l_proc_name)
4216: THEN
4217: hr_utility.set_location ( ' Leaving:'
4218: || l_proc_name, 40);
4219: RAISE;
4220: END IF;
4221:

Line 4227: hr_utility.set_location ( ' Leaving:'

4223: -- Reset IN OUT and set OUT parameters
4224: --
4225: l_return_status :=
4226: hr_multi_message.get_return_status_disable;
4227: hr_utility.set_location ( ' Leaving:'
4228: || l_proc_name, 50);
4229: END delete_user_template_swi;
4230: --
4231: END pqp_gb_pension_scheme_template;