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

Line 83: hr_utility.set_location('Entering {' || gv_package || lv_procedure_name, 10);

79: AS
80: l_exists varchar2(2) := 'N';
81: lv_procedure_name VArchar2(80) := '.valid_business_group';
82: BEGIN
83: hr_utility.set_location('Entering {' || gv_package || lv_procedure_name, 10);
84: begin
85: SELECT 'Y'
86: INTO l_exists
87: FROM dual

Line 95: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');

91: WHERE name = p_business_group_name
92: );
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
96: hr_utility.raise_error;
97: END;
98: hr_utility.set_location('Exiting }' || gv_package ||
99: lv_procedure_name, 50);

Line 96: hr_utility.raise_error;

92: );
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
96: hr_utility.raise_error;
97: END;
98: hr_utility.set_location('Exiting }' || gv_package ||
99: lv_procedure_name, 50);
100: --

Line 98: hr_utility.set_location('Exiting }' || gv_package ||

94: WHEN NO_DATA_FOUND THEN
95: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
96: hr_utility.raise_error;
97: END;
98: hr_utility.set_location('Exiting }' || gv_package ||
99: lv_procedure_name, 50);
100: --
101: --
102: END;

Line 152: hr_utility.set_location('Entering {' || gv_package ||

148: FROM pay_functional_usages
149: WHERE area_id = p_area_id
150: AND business_group_id = p_business_group_id;
151: BEGIN
152: hr_utility.set_location('Entering {' || gv_package ||
153: lv_procedure_name, 10);
154:
155: l_business_group_id := p_business_group_id;
156: l_salary_flag := p_salary_flag ;

Line 272: hr_utility.trace('Generate Trigger Event');

268: enabled_flag = 'Y'
269: WHERE event_id = l_event_id;
270:
271: pay_dyn_triggers.generate_trigger_event(l_short_name);
272: hr_utility.trace('Generate Trigger Event');
273:
274: END LOOP;
275:
276: FOR c1 IN c_functional_areas

Line 291: hr_utility.trace('The count is ' || TO_CHAR(l_count));

287: -- The following code inserts a row in pay_functional_usages table for the
288: -- respective Business Group.
289: --************************************************************************
290: IF (l_count = 0) THEN
291: hr_utility.trace('The count is ' || TO_CHAR(l_count));
292: pay_functional_usages_pkg.insert_row(
293: p_row_id => l_row_id ,
294: p_usage_id => l_usage_id ,
295: p_area_id => l_area_id ,

Line 300: hr_utility.set_location('Leaving }' || gv_package || lv_procedure_name, 20);

296: p_legislation_code => NULL ,
297: p_business_group_id => l_business_group_id ,
298: p_payroll_id => NULL );
299: END IF;
300: hr_utility.set_location('Leaving }' || gv_package || lv_procedure_name, 20);
301: END enable_dynamic_triggers;
302:
303: --*************************************************************************
304: -- Procedure : Standard Procedure

Line 361: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);

357: l_req_id NUMBER ;
358: l_etei_ovn NUMBER ;
359: l_etei_id NUMBER ;
360: BEGIN
361: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);
362: l_business_group_name := UPPER(business_group) ;
363: l_business := business_group ;
364: l_upper_base := UPPER(basename) ;
365: l_base := basename ;

Line 390: hr_utility.trace('Salary Flag is true');

386:
387: --*********** SALARY ********************
388:
389: IF (l_salary_flag = 'TRUE') THEN
390: hr_utility.trace('Salary Flag is true');
391:
392: -- We should basically
393: -- a) Create a Pro ration Group with the events enabled for SALARY.
394: -- b) Create an Element.

Line 410: hr_utility.trace('The count 15 is ' || TO_CHAR(l_count));

406: INTO l_count
407: FROM pay_event_groups
408: WHERE event_group_name = UPPER(l_modified_base_pg || ' sal pg');
409:
410: hr_utility.trace('The count 15 is ' || TO_CHAR(l_count));
411:
412: IF (l_count = 0) THEN
413: hr_utility.trace('If condition ... Creating Even Group');
414:

Line 413: hr_utility.trace('If condition ... Creating Even Group');

409:
410: hr_utility.trace('The count 15 is ' || TO_CHAR(l_count));
411:
412: IF (l_count = 0) THEN
413: hr_utility.trace('If condition ... Creating Even Group');
414:
415: pay_event_groups_api.create_event_group
416: (
417: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')

Line 427: hr_utility.trace('Else condition ');

423: ,p_event_group_id => l_event_group_id
424: ,p_object_version_number => l_ovn
425: );
426: ELSE
427: hr_utility.trace('Else condition ');
428: l_event_group_id := NULL;
429:
430: -- SELECT event_group_id
431: -- INTO l_event_group_id

Line 455: hr_utility.trace('The count 20 is ' || TO_CHAR(l_count));

451: WHERE column_name = 'EFFECTIVE_START_DATE'
452: AND event_group_id = l_event_group_id
453: AND dated_table_id = l_dated_table_id ;
454:
455: hr_utility.trace('The count 20 is ' || TO_CHAR(l_count));
456:
457: IF (l_count = 0) THEN
458: hr_utility.trace('If condition ... Creating Date Tracked Events');
459: pay_datetracked_events_api.create_datetracked_event

Line 458: hr_utility.trace('If condition ... Creating Date Tracked Events');

454:
455: hr_utility.trace('The count 20 is ' || TO_CHAR(l_count));
456:
457: IF (l_count = 0) THEN
458: hr_utility.trace('If condition ... Creating Date Tracked Events');
459: pay_datetracked_events_api.create_datetracked_event
460: (
461: p_validate => FALSE
462: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')

Line 484: hr_utility.trace('The count 25 is ' || TO_CHAR(l_count));

480: WHERE column_name = 'EFFECTIVE_END_DATE'
481: AND event_group_id = l_event_group_id
482: AND dated_table_id = l_dated_table_id ;
483:
484: hr_utility.trace('The count 25 is ' || TO_CHAR(l_count));
485:
486: IF (l_count = 0) THEN
487: hr_utility.trace('If condition ... Creating Date Tracked Events');
488: pay_datetracked_events_api.create_datetracked_event

Line 487: hr_utility.trace('If condition ... Creating Date Tracked Events');

483:
484: hr_utility.trace('The count 25 is ' || TO_CHAR(l_count));
485:
486: IF (l_count = 0) THEN
487: hr_utility.trace('If condition ... Creating Date Tracked Events');
488: pay_datetracked_events_api.create_datetracked_event
489: (
490: p_validate => FALSE
491: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')

Line 505: hr_utility.trace('If condition for English Teachers');

501: END IF;
502: --b) Step b
503:
504: IF (teacher_england = 'YES') THEN
505: hr_utility.trace('If condition for English Teachers');
506:
507: l_count := 0;
508:
509: SELECT COUNT(*)

Line 516: hr_utility.trace('If condition ... Creating Element');

512: WHERE UPPER(element_name) =
513: UPPER(l_modified_base_ele || ' sal ele');
514:
515: IF (l_count = 0) THEN
516: hr_utility.trace('If condition ... Creating Element');
517:
518: l_ele_id := pay_db_pay_setup.create_element(
519: p_element_name => l_modified_base_ele || ' sal ele'
520: ,p_description => 'Element to prorate the salary'

Line 550: hr_utility.trace('If condition ... Creating Input Value');

546: l_ipv_as := c_iv.input_value_id;
547: END LOOP;
548:
549: IF (l_ipv_as IS NULL) THEN
550: hr_utility.trace('If condition ... Creating Input Value');
551: l_ipv_as := pay_db_pay_setup.create_input_value(
552: p_element_name => l_modified_base_ele || ' sal ele'
553: ,p_name => 'Amount'
554: ,p_uom_code => 'M'

Line 564: hr_utility.trace(l_modified_base_ele ||

560: ,p_legislation_code => NULL);
561: END IF;
562: --
563: ELSE
564: hr_utility.trace(l_modified_base_ele ||
565: '_sal_ele already exists.');
566: END IF;
567: END IF;
568: IF (teacher_scotland = 'YES' OR

Line 570: hr_utility.trace('If condition ... Teacher Scotland ');

566: END IF;
567: END IF;
568: IF (teacher_scotland = 'YES' OR
569: (teacher_england = 'NO' AND teacher_scotland = 'NO')) THEN
570: hr_utility.trace('If condition ... Teacher Scotland ');
571: l_count := 0;
572:
573: SELECT COUNT(*)
574: INTO l_count

Line 580: hr_utility.trace('If condition ... create element');

576: WHERE UPPER(element_name) =
577: UPPER(l_modified_base_ele || ' sal ele1');
578:
579: IF (l_count = 0) THEN
580: hr_utility.trace('If condition ... create element');
581:
582: l_ele_id_scot := pay_db_pay_setup.create_element(
583: p_element_name => l_modified_base_ele || ' sal ele1'
584: ,p_description => 'Element to prorate the salary'

Line 612: hr_utility.trace('If condition ... create input value');

608: l_ipv_as := c_iv.input_value_id;
609: END LOOP;
610:
611: IF (l_ipv_as IS NULL) THEN
612: hr_utility.trace('If condition ... create input value');
613: l_ipv_as := pay_db_pay_setup.create_input_value(
614: p_element_name => l_modified_base_ele || ' sal ele1'
615: ,p_name => 'Amount'
616: ,p_uom_code => 'M'

Line 625: hr_utility.trace(l_modified_base_ele ||

621: ,p_effective_end_date => TO_DATE('31/12/4712','DD/MM/YYYY')
622: ,p_legislation_code => NULL);
623: END IF;
624: ELSE
625: hr_utility.trace(l_modified_base_ele ||
626: ' sal ele1 already exists.');
627: END IF;
628: END IF;
629:

Line 633: hr_utility.trace('If condition ... teacher england');

629:
630: -- c) Step c)
631:
632: IF (teacher_england = 'YES') THEN
633: hr_utility.trace('If condition ... teacher england');
634: l_count := 0;
635:
636: SELECT COUNT(*)
637: INTO l_count

Line 642: hr_utility.trace('If condition ... count = 0');

638: FROM ff_formulas_f
639: WHERE formula_name = UPPER(l_modified_base_formula || '_sal_ff');
640:
641: IF (l_count = 0) THEN
642: hr_utility.trace('If condition ... count = 0');
643:
644: SELECT formula_type_id
645: INTO l_formula_type_id
646: FROM ff_formula_types

Line 741: hr_utility.trace(l_modified_base_formula ||

737: ,p_result_rule_type => 'D'
738: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
739: );
740: ELSE
741: hr_utility.trace(l_modified_base_formula ||
742: '_sal_ff already exists.');
743: END IF;
744: END IF;
745:

Line 748: hr_utility.trace('If condition ... teacher scotland');

744: END IF;
745:
746: IF (teacher_scotland = 'YES' OR
747: (teacher_england = 'NO' AND teacher_scotland = 'NO')) THEN
748: hr_utility.trace('If condition ... teacher scotland');
749: l_count := 0;
750:
751: SELECT COUNT(*)
752: INTO l_count

Line 757: hr_utility.trace('If condition ... count = 0');

753: FROM ff_formulas_f
754: WHERE formula_name = UPPER(l_modified_base_formula || '_sal_ff1');
755:
756: IF (l_count = 0) THEN
757: hr_utility.trace('If condition ... count = 0');
758:
759: SELECT formula_type_id
760: INTO l_formula_type_id
761: FROM ff_formula_types

Line 856: hr_utility.trace(l_modified_base_formula ||

852: ,p_result_rule_type => 'D'
853: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
854: );
855: ELSE
856: hr_utility.trace(l_modified_base_formula ||
857: '_sal_ff1 already exists.');
858: END IF;
859: END IF;
860: END IF;

Line 865: hr_utility.trace('If condition ... grade flag is true');

861:
862: --**************** GRADES ******************************
863:
864: IF (l_grade_flag = 'TRUE') THEN
865: hr_utility.trace('If condition ... grade flag is true');
866:
867: -- We should basically
868: -- a) Create a Pro ration Group with the events enabled for SALARY.
869: -- b) Create an Element.

Line 886: hr_utility.trace('If condition ... creating event group');

882: FROM pay_event_groups
883: WHERE event_group_name = UPPER(l_modified_base_pg || ' GRADE pg');
884:
885: IF (l_count = 0 ) THEN
886: hr_utility.trace('If condition ... creating event group');
887: pay_event_groups_api.create_event_group
888: (
889: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
890: ,p_event_group_name => UPPER(l_modified_base_pg || ' grade pg')

Line 899: hr_utility.trace('Else condition ...');

895: ,p_event_group_id => l_event_group_id
896: ,p_object_version_number => l_ovn
897: );
898: ELSE
899: hr_utility.trace('Else condition ...');
900: l_event_group_id := NULL;
901:
902: -- SELECT event_group_id
903: -- INTO l_event_group_id

Line 927: hr_utility.trace('If condition ... creating datetracked events');

923: AND event_group_id = l_event_group_id
924: AND dated_table_id = l_dated_table_id;
925:
926: IF (l_count = 0) THEN
927: hr_utility.trace('If condition ... creating datetracked events');
928:
929: pay_datetracked_events_api.create_datetracked_event
930: (
931: p_validate => FALSE

Line 960: hr_utility.trace('If condition ... creating datetracked events');

956: AND event_group_id = l_event_group_id
957: AND dated_table_id = l_dated_table_id ;
958:
959: IF (l_count = 0) THEN
960: hr_utility.trace('If condition ... creating datetracked events');
961:
962: pay_datetracked_events_api.create_datetracked_event
963: (
964: p_validate => FALSE

Line 988: hr_utility.trace('If condition ... creating elements');

984: FROM pay_element_types_f
985: WHERE UPPER(element_name) = UPPER(l_modified_base_ele || ' grade ele');
986:
987: IF (l_count = 0) THEN
988: hr_utility.trace('If condition ... creating elements');
989:
990: l_ele_id := pay_db_pay_setup.create_element(
991: p_element_name => l_modified_base_ele || ' grade ele'
992: ,p_description => 'Element to prorate the Grades'

Line 1023: hr_utility.trace(l_modified_base_ele || '_grade_ele already exists.');

1019: l_ipv_pv := c_iv.input_value_id;
1020: END LOOP;
1021: --
1022: ELSE
1023: hr_utility.trace(l_modified_base_ele || '_grade_ele already exists.');
1024: END IF;
1025:
1026: IF (p_ele_gr_name IS NOT NULL) THEN
1027: IF (l_count <> 0) THEN

Line 1041: hr_utility.trace('If condition ...creating element extra info');

1037: LOOP
1038: l_count := cetei.count;
1039: END LOOP;
1040: IF (l_count = 0 ) THEN
1041: hr_utility.trace('If condition ...creating element extra info');
1042: pay_db_pay_setup.set_session_date(trunc(sysdate));
1043: l_etei_id := NULL;
1044: l_etei_ovn := NULL;
1045: pay_element_extra_info_api.create_element_extra_info

Line 1062: hr_utility.trace('Else condition..updating element extra info');

1058: ,p_object_version_number => l_etei_ovn
1059: -- 'No' Service History
1060: );
1061: ELSE
1062: hr_utility.trace('Else condition..updating element extra info');
1063: pay_db_pay_setup.set_session_date(trunc(sysdate));
1064: l_etei_id := NULL;
1065: l_etei_ovn := NULL;
1066: FOR cetei1 IN c_element_extra_info_id(l_ele_id)

Line 1099: hr_utility.trace('If condition ...creating formula');

1095: FROM ff_formulas_f
1096: WHERE formula_name = UPPER(l_modified_base_formula || '_grade_ff');
1097:
1098: IF (l_count = 0) THEN
1099: hr_utility.trace('If condition ...creating formula');
1100: SELECT formula_type_id
1101: INTO l_formula_type_id
1102: FROM ff_formula_types
1103: WHERE formula_type_name = 'Oracle Payroll';

Line 1198: hr_utility.trace(l_modified_base_formula || '_grade_ff already exists.');

1194: ,p_result_rule_type => 'D'
1195: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
1196: );
1197: ELSE
1198: hr_utility.trace(l_modified_base_formula || '_grade_ff already exists.');
1199: END IF;
1200: END IF;
1201: --*************** PROGRESSION POINTS (Pay Scale) **************************
1202:

Line 1204: hr_utility.trace('If condition ...pay scale flag is true');

1200: END IF;
1201: --*************** PROGRESSION POINTS (Pay Scale) **************************
1202:
1203: IF (l_pscale_flag = 'TRUE') THEN
1204: hr_utility.trace('If condition ...pay scale flag is true');
1205: -- We should basically
1206: -- a) Create a Pro ration Group with the events enabled for SALARY.
1207: -- b) Create an Element.
1208: -- c) Link the formula to the element.

Line 1225: hr_utility.trace('If condition ...creating event group');

1221: FROM pay_event_groups
1222: WHERE event_group_name = UPPER(l_modified_base_pg || ' PAYSCALE pg');
1223:
1224: IF (l_count = 0) THEN
1225: hr_utility.trace('If condition ...creating event group');
1226: pay_event_groups_api.create_event_group
1227: (
1228: p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')
1229: ,p_event_group_name => UPPER(l_modified_base_pg || ' payscale pg' )

Line 1238: hr_utility.trace('else condition ...selecting from event group');

1234: ,p_event_group_id => l_event_group_id
1235: ,p_object_version_number => l_ovn
1236: );
1237: ELSE
1238: hr_utility.trace('else condition ...selecting from event group');
1239: l_event_group_id := NULL;
1240:
1241: -- SELECT event_group_id
1242: -- INTO l_event_group_id

Line 1267: hr_utility.trace('If condition ...creating datetracked events');

1263: AND event_group_id = l_event_group_id
1264: AND dated_table_id = l_dated_table_id ;
1265:
1266: IF (l_count = 0) THEN
1267: hr_utility.trace('If condition ...creating datetracked events');
1268: pay_datetracked_events_api.create_datetracked_event
1269: (
1270: p_validate => FALSE
1271: ,p_effective_date => TO_DATE(l_date,'dd/mm/yyyy')

Line 1297: hr_utility.trace('If condition ...creating datetracked events');

1293: AND event_group_id = l_event_group_id
1294: AND dated_table_id = l_dated_table_id;
1295:
1296: IF (l_count = 0) THEN
1297: hr_utility.trace('If condition ...creating datetracked events');
1298:
1299: pay_datetracked_events_api.create_datetracked_event
1300: (
1301: p_validate => FALSE

Line 1330: hr_utility.trace('If condition ...creating datetracked events');

1326: AND event_group_id = l_event_group_id
1327: AND dated_table_id = l_dated_table_id ;
1328:
1329: IF (l_count = 0) THEN
1330: hr_utility.trace('If condition ...creating datetracked events');
1331:
1332: pay_datetracked_events_api.create_datetracked_event
1333: (
1334: p_validate => FALSE

Line 1357: hr_utility.trace('The count is ' || TO_CHAR(l_count));

1353: INTO l_count
1354: FROM pay_element_types_f
1355: WHERE UPPER(element_name) =
1356: UPPER(l_modified_base_ele || ' payscale ele');
1357: hr_utility.trace('The count is ' || TO_CHAR(l_count));
1358:
1359: IF (l_count = 0) THEN
1360: hr_utility.trace('If condition ...creating element');
1361:

Line 1360: hr_utility.trace('If condition ...creating element');

1356: UPPER(l_modified_base_ele || ' payscale ele');
1357: hr_utility.trace('The count is ' || TO_CHAR(l_count));
1358:
1359: IF (l_count = 0) THEN
1360: hr_utility.trace('If condition ...creating element');
1361:
1362: l_ele_id := pay_db_pay_setup.create_element(
1363: p_element_name => l_modified_base_ele || ' payscale ele'
1364: ,p_description => 'Element to prorate the Pay Scale'

Line 1377: hr_utility.trace('The element type id is ' || TO_CHAR(l_ele_id));

1373: ,p_effective_start_date => to_date(l_date,'dd/mm/yyyy')
1374: ,p_effective_end_date => to_date('31/12/4712','dd/mm/yyyy')
1375: ,p_proration_group_id => l_event_group_id);
1376:
1377: hr_utility.trace('The element type id is ' || TO_CHAR(l_ele_id));
1378:
1379: --
1380: -- create input values
1381: --

Line 1396: hr_utility.trace(l_modified_base_ele ||

1392: LOOP
1393: l_ipv_pv := c_iv.input_value_id;
1394: END LOOP;
1395: ELSE
1396: hr_utility.trace(l_modified_base_ele ||
1397: ' payscale ele already exists.');
1398: END IF;
1399: IF (p_ele_psr_name IS NOT NULL) THEN
1400: hr_utility.trace('Pay Scale qualifier is not null');

Line 1400: hr_utility.trace('Pay Scale qualifier is not null');

1396: hr_utility.trace(l_modified_base_ele ||
1397: ' payscale ele already exists.');
1398: END IF;
1399: IF (p_ele_psr_name IS NOT NULL) THEN
1400: hr_utility.trace('Pay Scale qualifier is not null');
1401: IF (l_count <> 0) THEN
1402: hr_utility.trace('Second iteration');
1403: FOR ceti IN c_element_id(l_modified_base_ele || ' payscale ele')
1404: LOOP

Line 1402: hr_utility.trace('Second iteration');

1398: END IF;
1399: IF (p_ele_psr_name IS NOT NULL) THEN
1400: hr_utility.trace('Pay Scale qualifier is not null');
1401: IF (l_count <> 0) THEN
1402: hr_utility.trace('Second iteration');
1403: FOR ceti IN c_element_id(l_modified_base_ele || ' payscale ele')
1404: LOOP
1405: l_ele_id := ceti.element_type_id;
1406: END LOOP;

Line 1407: hr_utility.trace('The element id is ' || TO_CHAR(l_ele_id));

1403: FOR ceti IN c_element_id(l_modified_base_ele || ' payscale ele')
1404: LOOP
1405: l_ele_id := ceti.element_type_id;
1406: END LOOP;
1407: hr_utility.trace('The element id is ' || TO_CHAR(l_ele_id));
1408: END IF;
1409:
1410: l_count := 0;
1411:

Line 1416: hr_utility.trace('The count is ' || TO_CHAR(l_count));

1412: FOR cetei IN c_element_extra_info_cnt(l_ele_id)
1413: LOOP
1414: l_count := cetei.count;
1415: END LOOP;
1416: hr_utility.trace('The count is ' || TO_CHAR(l_count));
1417:
1418: IF (l_count = 0) THEN
1419: hr_utility.trace('If condition ...creating element extra info');
1420: l_etei_id := NULL;

Line 1419: hr_utility.trace('If condition ...creating element extra info');

1415: END LOOP;
1416: hr_utility.trace('The count is ' || TO_CHAR(l_count));
1417:
1418: IF (l_count = 0) THEN
1419: hr_utility.trace('If condition ...creating element extra info');
1420: l_etei_id := NULL;
1421: l_etei_ovn := NULL;
1422: pay_db_pay_setup.set_session_date(trunc(sysdate));
1423: pay_element_extra_info_api.create_element_extra_info

Line 1439: hr_utility.trace('The extra info id is '|| TO_CHAR(l_etei_id));

1435: ,p_element_type_extra_info_id => l_etei_id
1436: ,p_object_version_number => l_etei_ovn
1437: -- 'No' Service History
1438: );
1439: hr_utility.trace('The extra info id is '|| TO_CHAR(l_etei_id));
1440: ELSE
1441: hr_utility.trace('Else condition..updating element extra info');
1442: pay_db_pay_setup.set_session_date(trunc(sysdate));
1443: l_etei_id := NULL;

Line 1441: hr_utility.trace('Else condition..updating element extra info');

1437: -- 'No' Service History
1438: );
1439: hr_utility.trace('The extra info id is '|| TO_CHAR(l_etei_id));
1440: ELSE
1441: hr_utility.trace('Else condition..updating element extra info');
1442: pay_db_pay_setup.set_session_date(trunc(sysdate));
1443: l_etei_id := NULL;
1444: l_etei_ovn := NULL;
1445: FOR cetei1 IN c_element_extra_info_id(l_ele_id)

Line 1576: hr_utility.trace(l_modified_base_formula ||

1572: ,p_result_rule_type => 'D'
1573: ,p_effective_start_date => TO_DATE(l_date,'dd/mm/yyyy')
1574: );
1575: ELSE
1576: hr_utility.trace(l_modified_base_formula ||
1577: '_payscale_ff already exists.');
1578: END IF;
1579: END IF;
1580:

Line 1581: hr_utility.trace('Enabling dynamic trigger ');

1577: '_payscale_ff already exists.');
1578: END IF;
1579: END IF;
1580:
1581: hr_utility.trace('Enabling dynamic trigger ');
1582: enable_dynamic_triggers
1583: (
1584: p_business_group_id => l_business_group_id ,
1585: p_salary_flag => l_salary_flag ,

Line 1591: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 250);

1587: p_spinal_flag => l_pscale_flag ,
1588: p_address_flag => 'FALSE' ,
1589: p_location_flag => 'FALSE'
1590: );
1591: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 250);
1592:
1593: END standard_proc;
1594: -- ***************************************************************************
1595: -- proration_group_proc

Line 1630: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 250);

1626: l_payscale_flag VARCHAR2(40) := 'FALSE';
1627: l_address_flag VARCHAR2(40) := 'FALSE';
1628: l_location_flag VARCHAR2(40) := 'FALSE';
1629: BEGIN
1630: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 250);
1631: valid_business_group(p_business_group_name => p_business_group_pg);
1632: l_business_group_name := p_business_group_pg;
1633: FOR c1 IN c_biz_group (l_business_group_name)
1634: LOOP

Line 1653: hr_utility.trace('If condition ... Creating event groups');

1649: FROM pay_event_groups
1650: WHERE event_group_name = l_pg_name;
1651:
1652: IF (l_count = 0) THEN
1653: hr_utility.trace('If condition ... Creating event groups');
1654: pay_event_groups_api.create_event_group
1655: (
1656: p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')
1657: ,p_event_group_name => l_pg_name

Line 1666: hr_utility.trace('Else condition ...');

1662: ,p_event_group_id => l_event_group_id
1663: ,p_object_version_number => l_ovn
1664: );
1665: ELSE
1666: hr_utility.trace('Else condition ...');
1667: l_event_group_id := NULL;
1668:
1669: -- SELECT event_group_id
1670: -- INTO l_event_group_id

Line 1683: hr_utility.trace('If condition ... p_pggrd');

1679:
1680: -- Change in Grade
1681:
1682: IF (UPPER(p_pggrd) = 'YES') THEN
1683: hr_utility.trace('If condition ... p_pggrd');
1684: FOR c2 IN c_dated_pay_table ('PER_ALL_ASSIGNMENTS_F')
1685: LOOP
1686: l_dated_table_id := c2.dated_table_id;
1687: END LOOP;

Line 1698: hr_utility.trace('If condition ... creating datetracked event');

1694: AND event_group_id = l_event_group_id
1695: AND dated_table_id = l_dated_table_id ;
1696:
1697: IF (l_count = 0) THEN
1698: hr_utility.trace('If condition ... creating datetracked event');
1699:
1700: pay_datetracked_events_api.create_datetracked_event
1701: (
1702: p_validate => FALSE

Line 1719: hr_utility.trace('If condition ... p_pgchgpysc');

1715:
1716: -- Change in Pay Scale
1717:
1718: IF (UPPER(p_pgchgpysc) = 'YES') THEN
1719: hr_utility.trace('If condition ... p_pgchgpysc');
1720:
1721: l_payscale_flag := 'TRUE';
1722:
1723: FOR c2 IN c_dated_pay_table ('PER_SPINAL_POINT_PLACEMENTS_F')

Line 1737: hr_utility.trace('If condition ... creating datetracked event');

1733: AND event_group_id = l_event_group_id
1734: AND dated_table_id = l_dated_table_id ;
1735:
1736: IF (l_count = 0) THEN
1737: hr_utility.trace('If condition ... creating datetracked event');
1738:
1739: pay_datetracked_events_api.create_datetracked_event
1740: (
1741: p_validate => FALSE

Line 1759: hr_utility.trace('If condition ... p_pggrdrt p_pgchrtpysc');

1755:
1756: -- Change in Grade Rate or Change in Rate associated with Payscale
1757:
1758: IF (UPPER(p_pggrdrt) = 'YES' OR UPPER(p_pgchrtpysc) = 'YES') THEN
1759: hr_utility.trace('If condition ... p_pggrdrt p_pgchrtpysc');
1760:
1761: l_grade_flag := 'TRUE';
1762:
1763: FOR c2 IN c_dated_pay_table ('PAY_GRADE_RULES_F')

Line 1777: hr_utility.trace('If condition ... creating datetracked event');

1773: AND event_group_id = l_event_group_id
1774: AND dated_table_id = l_dated_table_id ;
1775:
1776: IF (l_count = 0) THEN
1777: hr_utility.trace('If condition ... creating datetracked event');
1778:
1779: pay_datetracked_events_api.create_datetracked_event
1780: (
1781: p_validate => FALSE

Line 1807: hr_utility.trace('If condition ... p_pgchgsal p_pgtermemp p_pgnewhre p_pgstchenea p_pgstchended');

1803: UPPER(p_pgtermemp) = 'YES' OR
1804: UPPER(p_pgnewhre ) = 'YES' OR
1805: UPPER(p_pgstchenea) = 'YES' OR
1806: UPPER(p_pgstchended) = 'YES' ) THEN
1807: hr_utility.trace('If condition ... p_pgchgsal p_pgtermemp p_pgnewhre p_pgstchenea p_pgstchended');
1808:
1809: l_salary_flag := 'TRUE';
1810:
1811: FOR c2 IN c_dated_pay_table ('PAY_ELEMENT_ENTRIES_F')

Line 1826: hr_utility.trace('If condition ... creating datetracked event');

1822: AND event_group_id = l_event_group_id
1823: AND dated_table_id = l_dated_table_id ;
1824:
1825: IF (l_count = 0) THEN
1826: hr_utility.trace('If condition ... creating datetracked event');
1827: pay_datetracked_events_api.create_datetracked_event
1828: (
1829: p_validate => FALSE
1830: ,p_effective_date => TO_DATE(p_pg_startdate,'dd/mm/yyyy')

Line 1853: hr_utility.trace('If condition ... creating datetracked event');

1849: AND event_group_id = l_event_group_id
1850: AND dated_table_id = l_dated_table_id;
1851:
1852: IF (l_count = 0) THEN
1853: hr_utility.trace('If condition ... creating datetracked event');
1854: pay_datetracked_events_api.create_datetracked_event
1855: (
1856: p_validate => FALSE
1857: ,p_effective_date =>

Line 1874: hr_utility.trace('If condition ... p_pgchgloc');

1870:
1871: -- Change of location
1872:
1873: IF ( UPPER(p_pgchgloc) = 'YES' ) THEN
1874: hr_utility.trace('If condition ... p_pgchgloc');
1875: l_location_flag := 'TRUE';
1876:
1877: FOR c2 IN c_dated_pay_table ('PER_ALL_ASSIGNMENTS_F')
1878: LOOP

Line 1891: hr_utility.trace('If condition ... creating datetracked event');

1887: AND event_group_id = l_event_group_id
1888: AND dated_table_id = l_dated_table_id ;
1889:
1890: IF (l_count = 0) THEN
1891: hr_utility.trace('If condition ... creating datetracked event');
1892:
1893: pay_datetracked_events_api.create_datetracked_event
1894: (
1895: p_validate => FALSE

Line 1909: hr_utility.trace('Enable Dynamic Trigger');

1905: ,p_object_version_number => l_ovn
1906: ) ;
1907: END IF;
1908: END IF;
1909: hr_utility.trace('Enable Dynamic Trigger');
1910:
1911: enable_dynamic_triggers
1912: (
1913: p_business_group_id => l_business_group_id ,

Line 1920: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 250);

1916: p_spinal_flag => l_payscale_flag ,
1917: p_address_flag => l_address_flag ,
1918: p_location_flag => l_location_flag
1919: );
1920: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 250);
1921: END proration_group_proc;
1922: --*************************************************************************
1923: --Procedure : Element_proc
1924: --*************************************************************************

Line 1962: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);

1958: l_pg_name VARCHAR2(40);
1959: l_business_group_name VARCHAR2(80);
1960: lv_procedure_name VARCHAR2(250) := '.element_proc';
1961: BEGIN
1962: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);
1963: l_count := 0;
1964:
1965: l_business_group_name := p_business_group;
1966:

Line 1972: hr_utility.trace('The count is ' || TO_CHAR(l_count) );

1968: INTO l_count
1969: FROM pay_element_types_f
1970: WHERE UPPER(element_name) = UPPER(LTRIM(RTRIM(p_ele_name)));
1971:
1972: hr_utility.trace('The count is ' || TO_CHAR(l_count) );
1973:
1974: IF (l_count = 0) THEN
1975: hr_utility.trace('If condition ' );
1976:

Line 1975: hr_utility.trace('If condition ' );

1971:
1972: hr_utility.trace('The count is ' || TO_CHAR(l_count) );
1973:
1974: IF (l_count = 0) THEN
1975: hr_utility.trace('If condition ' );
1976:
1977: l_pg_name := UPPER(SUBSTR(REPLACE(p_ele_pg, ' ',' '), 1, 40));
1978:
1979: -- SELECT event_group_id

Line 1998: hr_utility.trace('Creating element ' );

1994: LOOP
1995: l_default_priority := c_pc.default_priority;
1996: END LOOP;
1997:
1998: hr_utility.trace('Creating element ' );
1999:
2000: l_ele_id := pay_db_pay_setup.create_element(
2001: p_element_name => LTRIM(RTRIM(p_ele_name))
2002: ,p_description => p_ele_desc

Line 2022: hr_utility.trace('If condition ... before creating input value ' );

2018:
2019: IF (p_ele_teach_eng = 'YES' AND p_ele_payment = 'S') THEN
2020: l_ipv_as := NULL;
2021:
2022: hr_utility.trace('If condition ... before creating input value ' );
2023:
2024: FOR c_iv IN c_input_value(l_ele_id, 'Amount')
2025: LOOP
2026: l_ipv_as := c_iv.input_value_id;

Line 2031: hr_utility.trace('If condition ... Creating input value ');

2027: END LOOP;
2028:
2029: IF (l_ipv_as IS NULL) THEN
2030:
2031: hr_utility.trace('If condition ... Creating input value ');
2032:
2033: l_ipv_as := pay_db_pay_setup.create_input_value(
2034: p_element_name => p_ele_name
2035: ,p_name => 'Amount'

Line 2047: hr_utility.trace('Element ' || p_ele_name || ' already exists.');

2043: ,p_legislation_code => NULL);
2044: END IF;
2045: END IF;
2046: ELSE
2047: hr_utility.trace('Element ' || p_ele_name || ' already exists.');
2048: END IF;
2049:
2050: IF (p_ele_extra_qualifier IS NOT NULL) THEN
2051: IF (l_count <> 0) THEN

Line 2065: hr_utility.trace('If condition ... Creating element extra info' );

2061: l_count := cetei.count;
2062: END LOOP;
2063: IF (l_count = 0) THEN
2064:
2065: hr_utility.trace('If condition ... Creating element extra info' );
2066:
2067: pay_db_pay_setup.set_session_date(trunc(sysdate));
2068: pay_element_extra_info_api.create_element_extra_info
2069: ( p_element_type_id => l_ele_id

Line 2085: hr_utility.trace('Else condition..updating element extra info');

2081: ,p_object_version_number => l_etei_ovn
2082: -- 'No' Service History */
2083: );
2084: ELSE
2085: hr_utility.trace('Else condition..updating element extra info');
2086: pay_db_pay_setup.set_session_date(trunc(sysdate));
2087: l_etei_id := NULL;
2088: l_etei_ovn := NULL;
2089: FOR cetei1 IN c_element_extra_info_id(l_ele_id)

Line 2111: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 200);

2107: -- 'No' Service History
2108: );
2109: END IF;
2110: END IF;
2111: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 200);
2112: END element_proc;
2113: -- *************************************************************************
2114: -- Procedure : Input_Value_proc
2115: -- ***************************************************************************

Line 2142: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);

2138: l_formula_id NUMBER;
2139: l_business_group_name VARCHAR2(80);
2140: lv_procedure_name VARCHAR2(80) := '.input_value_proc';
2141: BEGIN
2142: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);
2143: FOR ceti IN c_element_id(p_ele_name_ipv)
2144: LOOP
2145: l_ele_id := ceti.element_type_id;
2146: END LOOP;

Line 2157: hr_utility.trace('If condition...');

2153: l_ipv_as := civ1.input_value_id;
2154: END LOOP;
2155:
2156: IF (l_ipv_as IS NULL) THEN
2157: hr_utility.trace('If condition...');
2158: FOR cfi IN c_formula_id (p_ipvalue_formula)
2159: LOOP
2160: l_formula_id := cfi.formula_id;
2161: END LOOP;

Line 2162: hr_utility.trace('Creating input value');

2158: FOR cfi IN c_formula_id (p_ipvalue_formula)
2159: LOOP
2160: l_formula_id := cfi.formula_id;
2161: END LOOP;
2162: hr_utility.trace('Creating input value');
2163: l_ipv_as := pay_db_pay_setup.create_input_value(
2164: p_element_name => LTRIM(RTRIM(p_ele_name_ipv))
2165: ,p_name => SUBSTR(LTRIM(RTRIM(p_ipvalue_name)),
2166: 1, 80)

Line 2183: hr_utility.trace('Input Value ' || p_ele_name_ipv ||' already exists.');

2179: ,p_formula_id => l_formula_id
2180: ,p_hot_default_flag => p_ipvalue_hotdflt
2181: ,p_generate_db_item_flag => p_ipvalue_dbitem );
2182: ELSE
2183: hr_utility.trace('Input Value ' || p_ele_name_ipv ||' already exists.');
2184: END IF;
2185: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 10);
2186: END input_value_proc;
2187: --*************************************************************************

Line 2185: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 10);

2181: ,p_generate_db_item_flag => p_ipvalue_dbitem );
2182: ELSE
2183: hr_utility.trace('Input Value ' || p_ele_name_ipv ||' already exists.');
2184: END IF;
2185: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 10);
2186: END input_value_proc;
2187: --*************************************************************************
2188: --Procedure Formula_proc
2189: --****************************************************************************/

Line 2217: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);

2213: l_business_group_name VARCHAR2(80) ;
2214: l_result VARCHAR2(80) ;
2215: lv_procedure_name VARCHAR2(80) ;
2216: BEGIN
2217: hr_utility.set_location('Entering {'|| gv_package || lv_procedure_name, 10);
2218: l_count := 0;
2219: l_business_group_name := p_business_group_fr;
2220:
2221: IF (UPPER(p_ele_priclass_fr) LIKE '%DEDUCTION%') THEN

Line 2393: hr_utility.trace('Formula ' || l_new_formula_name ||' already exists.');

2389: ,p_effective_start_date =>
2390: TO_DATE(p_ele_startdate_fr,'dd/mm/yyyy')
2391: );
2392: ELSE
2393: hr_utility.trace('Formula ' || l_new_formula_name ||' already exists.');
2394: END IF;
2395: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 200);
2396: END formula_proc;
2397: --************************************************************************

Line 2395: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 200);

2391: );
2392: ELSE
2393: hr_utility.trace('Formula ' || l_new_formula_name ||' already exists.');
2394: END IF;
2395: hr_utility.set_location('Leaving }'|| gv_package || lv_procedure_name, 200);
2396: END formula_proc;
2397: --************************************************************************
2398: --**************************************************************************
2399: FUNCTION get_contract_type(p_assignment_id IN NUMBER ,