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 543: hr_utility.set_location (

539: ,program => 'SINGLECOMPILE'
540: ,argument1 => fra_rec.formula_type_name --Oracle Payroll
541: ,argument2 => fra_rec.formula_name
542: ); --formula name
543: hr_utility.set_location (
544: '..Request Id :'
545: || l_request_id
546: ,25
547: );

Line 553: hr_utility.set_location ( 'Leaving: '

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

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

563: l_element_name VARCHAR2 (100) := p_scheme_prefix;
564: l_output VARCHAR2 (100);
565: l_rgeflg VARCHAR2 (100);
566: BEGIN
567: hr_utility.set_location ( 'Entering : chk_scheme_prefix ', 10);
568:
569: hr_chkfmt.checkformat (
570: VALUE => l_element_name
571: ,format => 'PAY_NAME'

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

576: ,rgeflg => l_rgeflg
577: ,curcode => NULL
578: );
579:
580: hr_utility.set_location ( 'Exiting : chk_scheme_prefix ', 20);
581:
582: EXCEPTION
583: WHEN OTHERS
584: THEN

Line 621: hr_utility.set_location ( 'Entering: '

617: --
618:
619: BEGIN
620: --
621: hr_utility.set_location ( 'Entering: '
622: || l_proc_name, 10);
623: --
624:
625: OPEN csr_get_bal_info;

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

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

Line 639: hr_utility.set_location ( 'Leaving: '

635: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);
636:
637: CLOSE csr_get_bal_info;
638: --
639: hr_utility.set_location ( 'Leaving: '
640: || l_proc_name, 20);
641: RETURN l_balance_name;
642: --
643: END get_balance_info;

Line 672: hr_utility.set_location ( 'Entering: '

668: --
669:
670: BEGIN
671: --
672: hr_utility.set_location ( 'Entering: '
673: || l_proc_name, 10);
674: --
675:
676: OPEN csr_get_ele_class_info;

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

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

Line 690: hr_utility.set_location ( 'Leaving: '

686: hr_utility.set_location ( 'l_ele_class_info : '|| l_ele_class_info.classification_name, 20);
687:
688: CLOSE csr_get_ele_class_info;
689: --
690: hr_utility.set_location ( 'Leaving: '
691: || l_proc_name, 20);
692: --
693:
694: EXCEPTION

Line 697: hr_utility.set_location (

693:
694: EXCEPTION
695: WHEN OTHERS
696: THEN
697: hr_utility.set_location (
698: 'Others Exception: '
699: || l_proc_name
700: ,30
701: );

Line 702: hr_utility.set_location ( 'Leaving: '

698: 'Others Exception: '
699: || l_proc_name
700: ,30
701: );
702: hr_utility.set_location ( 'Leaving: '
703: || l_proc_name, 40);
704: p_classification_name := NULL;
705: p_default_priority := NULL;
706: RAISE;

Line 733: hr_utility.set_location ( 'Entering: '

729: l_iterative_priority NUMBER;
730: --
731: BEGIN
732: --
733: hr_utility.set_location ( 'Entering: '
734: || l_proc_name, 10);
735: --
736: OPEN csr_get_prs_priority;
737: FETCH csr_get_prs_priority INTO l_processing_priority;

Line 742: hr_utility.set_location ( 'Leaving: '

738: CLOSE csr_get_prs_priority;
739: l_iterative_priority := 400
740: - l_processing_priority;
741: --
742: hr_utility.set_location ( 'Leaving: '
743: || l_proc_name, 20);
744: --
745:
746: RETURN l_iterative_priority;

Line 787: hr_utility.set_location ( 'Entering: '

783: l_tab_pension_types t_pension_types;
784: --
785: BEGIN
786: --
787: hr_utility.set_location ( 'Entering: '
788: || l_proc_name, 10);
789: --
790:
791: OPEN csr_get_pension_type_info;

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

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

Line 829: hr_utility.set_location ( 'Leaving: '

825: l_pension_type_info.ee_contribution_bal_type_id;
826: l_tab_pension_types (p_pension_type_id).er_contribution_bal_type_id :=
827: l_pension_type_info.er_contribution_bal_type_id;
828: --
829: hr_utility.set_location ( 'Leaving: '
830: || l_proc_name, 20);
831: --
832:
833: RETURN l_tab_pension_types;

Line 930: hr_utility.set_location ( 'Entering: '

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

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

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

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

940: ,p_argument_value => p_pension_scheme_name
941: );
942:
943: -- Pension Year Start Date
944: hr_utility.set_location('Pension Year Start Date',15);
945: hr_api.mandatory_arg_error (
946: p_api_name => l_proc_name
947: ,p_argument => 'Pension Year Start Date'
948: ,p_argument_value => p_pension_year_start_dt

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

948: ,p_argument_value => p_pension_year_start_dt
949: );
950:
951: -- Effective Start Date
952: hr_utility.set_location('Effective Start Date',15);
953: hr_api.mandatory_arg_error (
954: p_api_name => l_proc_name
955: ,p_argument => 'Effective Start Date'
956: ,p_argument_value => p_effective_start_date

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

955: ,p_argument => 'Effective Start Date'
956: ,p_argument_value => p_effective_start_date
957: );
958:
959: hr_utility.set_location('Pension Category',15);
960: -- Pension Category
961: hr_api.mandatory_arg_error (
962: p_api_name => l_proc_name
963: ,p_argument => 'Pension Category'

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

963: ,p_argument => 'Pension Category'
964: ,p_argument_value => p_pension_category
965: );
966:
967: hr_utility.set_location('Pension Provider ID',15);
968: -- Pension Provider
969: hr_api.mandatory_arg_error (
970: p_api_name => l_proc_name
971: ,p_argument => 'Pension Provider ID'

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

971: ,p_argument => 'Pension Provider ID'
972: ,p_argument_value => p_pension_provider_id
973: );
974:
975: hr_utility.set_location('Pension Type ID',15);
976: -- Pension Type
977: hr_api.mandatory_arg_error (
978: p_api_name => l_proc_name
979: ,p_argument => 'Pension Type ID'

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

979: ,p_argument => 'Pension Type ID'
980: ,p_argument_value => p_pension_type_id
981: );
982:
983: hr_utility.set_location('Employee Deduction Method',15);
984: -- Employee Deduction Method
985: hr_api.mandatory_arg_error (
986: p_api_name => l_proc_name
987: ,p_argument => 'Employee Deduction Method'

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

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

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

995: ,p_argument => 'Scheme Prefix'
996: ,p_argument_value => p_ele_base_name
997: );
998:
999: hr_utility.set_location('Reporting Name',15);
1000: -- Reporting Name
1001: hr_api.mandatory_arg_error (
1002: p_api_name => l_proc_name
1003: ,p_argument => 'Reporting Name'

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

1003: ,p_argument => 'Reporting Name'
1004: ,p_argument_value => p_ele_reporting_name
1005: );
1006:
1007: hr_utility.set_location('Classification',15);
1008: -- Element Classification
1009: hr_api.mandatory_arg_error (
1010: p_api_name => l_proc_name
1011: ,p_argument => 'Classification'

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

1022: );
1023: END IF; -- End if of pension category is AVC check ...
1024:
1025: --
1026: hr_utility.set_location (l_proc_name, 20);
1027:
1028: --
1029: -- Check pension category lookup code
1030: --

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

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

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

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

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

1062:
1063: CLOSE csr_chk_provider_exists;
1064: -- Get Pension Type Info
1065: --
1066: hr_utility.set_location (l_proc_name, 30);
1067:
1068: --
1069:
1070: IF NOT g_tab_pension_types_info.EXISTS (p_pension_type_id)

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

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

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

1115:
1116: CLOSE csr_chk_pens_type_in_prov;
1117: -- Check employee deduction method in lookup
1118: --
1119: hr_utility.set_location (l_proc_name, 50);
1120:
1121: --
1122: IF hr_api.not_exists_in_hr_lookups (
1123: p_effective_date => p_effective_start_date

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

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

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

1161:
1162: -- NOT required now
1163: -- Check scon if pension category is OCP
1164: --
1165: -- hr_utility.set_location (l_proc_name, 70);
1166: --
1167: -- --
1168: --
1169: -- IF p_pension_category = 'OCP'

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

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

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

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

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

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

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

1262:
1263:
1264: -- Check deduction method codes for Family Widower Addded Years contributions
1265: --
1266: hr_utility.set_location (l_proc_name, 90);
1267:
1268: --
1269:
1270: IF p_fwc_added_years IS NOT NULL

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

1292:
1293:
1294: -- Check pension scheme type
1295: --
1296: hr_utility.set_location (l_proc_name, 110);
1297:
1298: --
1299:
1300: IF p_pension_scheme_type IS NOT NULL

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

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

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

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

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

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

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

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

Line 1432: hr_utility.set_location ( 'Leaving: '

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

Line 1464: hr_utility.set_location ( 'Entering: '

1460: l_formula_id NUMBER;
1461: --
1462: BEGIN
1463: --
1464: hr_utility.set_location ( 'Entering: '
1465: || l_proc_name, 10);
1466: --
1467: OPEN csr_get_formula_info;
1468: FETCH csr_get_formula_info INTO l_formula_id;

Line 1479: hr_utility.set_location ( 'Leaving: '

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

Line 1511: hr_utility.set_location ( 'Entering: '

1507: l_formula_text LONG;
1508: --
1509: BEGIN
1510: --
1511: hr_utility.set_location ( 'Entering: '
1512: || l_proc_name, 10);
1513: --
1514: OPEN csr_get_formula_info;
1515: FETCH csr_get_formula_info INTO l_formula_text;

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

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

Line 1536: hr_utility.set_location ( 'Leaving: '

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

Line 1574: hr_utility.set_location ( 'Entering: '

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

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

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

Line 1607: hr_utility.set_location ( 'Leaving: '

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

Line 1633: hr_utility.set_location ( 'Entering: '

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

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

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

Line 1655: hr_utility.set_location ( 'Leaving: '

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

Line 1684: hr_utility.set_location ( 'Entering: '

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

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

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

Line 1712: hr_utility.set_location ( 'Leaving: '

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

Line 1741: hr_utility.set_location ( 'Entering: '

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

Line 1756: hr_utility.set_location ( 'Leaving: '

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

Line 1796: hr_utility.set_location ( 'Entering: '

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

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

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

Line 1834: hr_utility.set_location ( 'Leaving: '

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

Line 1847: hr_utility.set_location ( 'Entering : '

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3308: hr_utility.set_location ( 'Leaving :'

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

Line 3441: hr_utility.set_location ( 'Entering: '

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

Line 3462: hr_utility.set_location ( 'Leaving: '

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

Line 3475: hr_utility.set_location ( 'Entering : '

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

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

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

Line 3491: IF (hr_utility.chk_product_install (

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3647: hr_utility.raise_error;

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

Line 3651: hr_utility.set_location ( 'Leaving: '

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3750: hr_utility.set_location ( ' Entering:'

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

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

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

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

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

Line 3827: hr_utility.set_location ( ' Leaving:'

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

Line 3844: hr_utility.set_location ( ' Leaving:'

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

Line 3859: hr_utility.set_location ( ' Leaving:'

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

Line 3870: hr_utility.set_location ( ' Leaving:'

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

Line 3999: hr_utility.set_location ( 'Entering :'

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

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

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

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

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

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

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

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

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

Line 4116: hr_utility.set_location ( 'Leaving :'

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

Line 4146: hr_utility.set_location ( ' Entering:'

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

Line 4190: hr_utility.set_location ( ' Leaving:'

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

Line 4205: hr_utility.set_location ( ' Leaving:'

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

Line 4220: hr_utility.set_location ( ' Leaving:'

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

Line 4230: hr_utility.set_location ( ' Leaving:'

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