eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_GENERAL dependencies on HR_UTILITY

Line 44: hr_utility.set_location('--In Formula ',20);

40: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
41: l_inputs ff_exec.inputs_t;
42: l_outputs ff_exec.outputs_t;
43: BEGIN
44: hr_utility.set_location('--In Formula ',20);
45: --
46: -- Initialize the formula
47: --
48: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

Line 50: hr_utility.trace('after ff_exec');

46: -- Initialize the formula
47: --
48: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
49: --
50: hr_utility.trace('after ff_exec');
51: -- Set up the input values
52: --
53: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
54: FOR i IN l_inputs.first..l_inputs.last LOOP

Line 66: hr_utility.trace('about to exec');

62: END IF;
63: --
64: -- Run the formula
65: --
66: hr_utility.trace('about to exec');
67: ff_exec.run_formula(l_inputs,l_outputs);
68: --
69: -- Populate the output table
70: --

Line 184: --hr_utility.trace_on(null,'A');

180: l_outputs(3).name := 'HOLIDAY_PAY_RESERVE';
181: l_outputs(4).name := 'WORKING_DAYS';
182: l_outputs(5).name := 'WORKING_HOURS';
183:
184: --hr_utility.trace_on(null,'A');
185: hr_utility.trace('p_assignment_id '||p_assignment_id);
186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;

Line 185: hr_utility.trace('p_assignment_id '||p_assignment_id);

181: l_outputs(4).name := 'WORKING_DAYS';
182: l_outputs(5).name := 'WORKING_HOURS';
183:
184: --hr_utility.trace_on(null,'A');
185: hr_utility.trace('p_assignment_id '||p_assignment_id);
186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);

Line 186: hr_utility.trace('p_date_earned '||l_inputs(2).value);

182: l_outputs(5).name := 'WORKING_HOURS';
183:
184: --hr_utility.trace_on(null,'A');
185: hr_utility.trace('p_assignment_id '||p_assignment_id);
186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);
190: hr_utility.trace('p_balance_date '||l_inputs(11).value);

Line 187: hr_utility.trace('p_balance_date '||l_inputs(11).value);

183:
184: --hr_utility.trace_on(null,'A');
185: hr_utility.trace('p_assignment_id '||p_assignment_id);
186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);
190: hr_utility.trace('p_balance_date '||l_inputs(11).value);
191: --hr_utility.trace_off;

Line 189: hr_utility.trace('p_date_earned '||l_inputs(2).value);

185: hr_utility.trace('p_assignment_id '||p_assignment_id);
186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);
190: hr_utility.trace('p_balance_date '||l_inputs(11).value);
191: --hr_utility.trace_off;
192:
193: if l_formula_id is not null then

Line 190: hr_utility.trace('p_balance_date '||l_inputs(11).value);

186: hr_utility.trace('p_date_earned '||l_inputs(2).value);
187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);
190: hr_utility.trace('p_balance_date '||l_inputs(11).value);
191: --hr_utility.trace_off;
192:
193: if l_formula_id is not null then
194: run_formula (l_formula_id

Line 191: --hr_utility.trace_off;

187: hr_utility.trace('p_balance_date '||l_inputs(11).value);
188: l_inputs(11).value :=l_inputs(2).value ;
189: hr_utility.trace('p_date_earned '||l_inputs(2).value);
190: hr_utility.trace('p_balance_date '||l_inputs(11).value);
191: --hr_utility.trace_off;
192:
193: if l_formula_id is not null then
194: run_formula (l_formula_id
195: ,p_date_earned

Line 1355: --hr_utility.trace('In Column Update or insert ');

1351: l_Action VARCHAR2(3);
1352:
1353: BEGIN
1354:
1355: --hr_utility.trace('In Column Update or insert ');
1356: --hr_utility.trace(' p_Session_Date ==>' || p_Session_Date);
1357: --hr_utility.trace('p_new_value ==> ' ||p_new_value );
1358:
1359: OPEN csr_PERSON_EIT;

Line 1356: --hr_utility.trace(' p_Session_Date ==>' || p_Session_Date);

1352:
1353: BEGIN
1354:
1355: --hr_utility.trace('In Column Update or insert ');
1356: --hr_utility.trace(' p_Session_Date ==>' || p_Session_Date);
1357: --hr_utility.trace('p_new_value ==> ' ||p_new_value );
1358:
1359: OPEN csr_PERSON_EIT;
1360: FETCH csr_PERSON_EIT

Line 1357: --hr_utility.trace('p_new_value ==> ' ||p_new_value );

1353: BEGIN
1354:
1355: --hr_utility.trace('In Column Update or insert ');
1356: --hr_utility.trace(' p_Session_Date ==>' || p_Session_Date);
1357: --hr_utility.trace('p_new_value ==> ' ||p_new_value );
1358:
1359: OPEN csr_PERSON_EIT;
1360: FETCH csr_PERSON_EIT
1361: INTO lr_PERSON_EIT;

Line 1364: --hr_utility.trace('In Not Found So Creation is gonna happen');

1360: FETCH csr_PERSON_EIT
1361: INTO lr_PERSON_EIT;
1362: IF csr_PERSON_EIT%NOTFOUND
1363: THEN
1364: --hr_utility.trace('In Not Found So Creation is gonna happen');
1365:
1366: hr_person_extra_info_api.create_person_extra_info
1367: (p_person_id => p_PERSON_ID
1368: ,p_information_type =>'FI_PENSION'

Line 1379: hr_utility.trace('p_person_extra_info_id Created ==> ' ||L_person_extra_info_id );

1375: ,p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(p_Session_Date)
1376: ,p_person_extra_info_id =>L_person_extra_info_id
1377: ,p_object_version_number =>L_OVN
1378: ) ;
1379: hr_utility.trace('p_person_extra_info_id Created ==> ' ||L_person_extra_info_id );
1380:
1381:
1382: ELSE
1383:

Line 1384: hr_utility.trace('Found record so Updation gonna Happen '||p_new_value);

1380:
1381:
1382: ELSE
1383:
1384: hr_utility.trace('Found record so Updation gonna Happen '||p_new_value);
1385:
1386: L_OVN := lr_PERSON_EIT.object_version_number;
1387: IF p_dt_update_mode ='UPDATE' or p_dt_update_mode='UPDATE_CHANGE'
1388: THEN

Line 1445: --hr_utility.trace('Updated Record ==> ' ||lr_PERSON_EIT.person_extra_info_id);

1441: p_pei_information5 => 'N',
1442: p_pei_information6 => l_Action
1443: );
1444: END IF;
1445: --hr_utility.trace('Updated Record ==> ' ||lr_PERSON_EIT.person_extra_info_id);
1446: END IF; -- END if of INSERT_CHANGE
1447: END IF;
1448: CLOSE csr_PERSON_EIT ;
1449: END INS_OR_UPD_PERSON_EIT_COLUMN;

Line 1478: --hr_utility.trace_on(NULL,'TELL');

1474: -- PER_INFORMATION16 Pension Group PERSON.LOC_INFORMATION_C01
1475: -- PER_INFORMATION24 Pension Insurance Number PERSON.LOC_INFORMATION_C06
1476: -- PER_INFORMATION17 Planned Retirement age PERSON.LOC_NUM03
1477:
1478: --hr_utility.trace_on(NULL,'TELL');
1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);

Line 1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);

1475: -- PER_INFORMATION24 Pension Insurance Number PERSON.LOC_INFORMATION_C06
1476: -- PER_INFORMATION17 Planned Retirement age PERSON.LOC_NUM03
1477:
1478: --hr_utility.trace_on(NULL,'TELL');
1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);

Line 1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);

1476: -- PER_INFORMATION17 Planned Retirement age PERSON.LOC_NUM03
1477:
1478: --hr_utility.trace_on(NULL,'TELL');
1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);

Line 1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);

1477:
1478: --hr_utility.trace_on(NULL,'TELL');
1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);

Line 1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);

1478: --hr_utility.trace_on(NULL,'TELL');
1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);

Line 1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);

1479: --hr_utility.trace(' In p_new_PENSION_JOINING_DATE => ' || p_new_PENSION_JOINING_DATE);
1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);

Line 1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);

1480: --hr_utility.trace(' In p_old_PENSION_JOINING_DATE => ' || p_old_PENSION_JOINING_DATE);
1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);

Line 1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);

1481: --hr_utility.trace(' In p_new_PENSION_TYPES => ' || p_new_PENSION_TYPES);
1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);

Line 1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);

1482: --hr_utility.trace(' In p_old_PENSION_TYPES => ' || p_old_PENSION_TYPES);
1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);
1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);

Line 1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);

1483: --hr_utility.trace(' In p_new_PENSION_INS_NUM => ' || p_new_PENSION_INS_NUM);
1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);
1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);
1491:

Line 1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);

1484: --hr_utility.trace(' In p_old_PENSION_INS_NUM => ' || p_old_PENSION_INS_NUM);
1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);
1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);
1491:
1492: IF p_where ='ASSIGN' or p_where ='MAINTAIN'

Line 1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);

1485: --hr_utility.trace(' In p_new_PENSION_GROUP => ' || p_new_PENSION_GROUP);
1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);
1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);
1491:
1492: IF p_where ='ASSIGN' or p_where ='MAINTAIN'
1493: THEN

Line 1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);

1486: --hr_utility.trace(' In p_old_PENSION_GROUP => ' || p_old_PENSION_GROUP);
1487: --hr_utility.trace(' In p_new_PENSION_RETIRE_DATE => ' || p_new_PENSION_RETIRE_DATE);
1488: --hr_utility.trace(' In p_old_PENSION_RETIRE_DATE => ' || p_old_PENSION_RETIRE_DATE);
1489: --hr_utility.trace(' In p_new_LOCAL_UNIT => ' || p_new_LOCAL_UNIT);
1490: --hr_utility.trace(' In p_old_LOCAL_UNIT => ' || p_old_LOCAL_UNIT);
1491:
1492: IF p_where ='ASSIGN' or p_where ='MAINTAIN'
1493: THEN
1494:

Line 1499: hr_utility.trace('In Equals for Local Unit');

1495: IF (p_new_LOCAL_UNIT IS NOT null or p_old_LOCAL_UNIT IS NOT NULL )
1496: THEN
1497: IF ( trim(p_new_LOCAL_UNIT) = trim(p_old_LOCAL_UNIT) )
1498: THEN
1499: hr_utility.trace('In Equals for Local Unit');
1500: ELSE
1501: hr_utility.trace('In Not Equals for Local Unit');
1502: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_LOCAL_UNIT,p_Session_Date,'Local Unit',p_dt_update_mode);
1503: END IF;

Line 1501: hr_utility.trace('In Not Equals for Local Unit');

1497: IF ( trim(p_new_LOCAL_UNIT) = trim(p_old_LOCAL_UNIT) )
1498: THEN
1499: hr_utility.trace('In Equals for Local Unit');
1500: ELSE
1501: hr_utility.trace('In Not Equals for Local Unit');
1502: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_LOCAL_UNIT,p_Session_Date,'Local Unit',p_dt_update_mode);
1503: END IF;
1504: END IF;
1505: END IF;

Line 1516: hr_utility.trace('In Equals for Pension Date');

1512: THEN
1513: IF(FND_DATE.CANONICAL_to_date(p_new_PENSION_JOINING_DATE)=
1514: FND_DATE.CANONICAL_to_date(p_old_PENSION_JOINING_DATE))
1515: THEN
1516: hr_utility.trace('In Equals for Pension Date');
1517: ELSE
1518: hr_utility.trace('Calling the Column update ');
1519: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_JOINING_DATE,p_Session_Date,'Pension Joining Date',p_dt_update_mode);
1520: END IF;

Line 1518: hr_utility.trace('Calling the Column update ');

1514: FND_DATE.CANONICAL_to_date(p_old_PENSION_JOINING_DATE))
1515: THEN
1516: hr_utility.trace('In Equals for Pension Date');
1517: ELSE
1518: hr_utility.trace('Calling the Column update ');
1519: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_JOINING_DATE,p_Session_Date,'Pension Joining Date',p_dt_update_mode);
1520: END IF;
1521: END IF;
1522: /*

Line 1527: hr_utility.trace('In Equals for AGE');

1523: IF (p_new_PENSION_RETIRE_DATE IS NOT null OR p_old_PENSION_RETIRE_DATE IS NOT null )
1524: THEN
1525: IF ( to_number(p_new_PENSION_RETIRE_DATE) = to_number(p_old_PENSION_RETIRE_DATE) )
1526: THEN
1527: hr_utility.trace('In Equals for AGE');
1528: ELSE
1529: hr_utility.trace('In Not Equals for AGE');
1530: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_RETIRE_DATE,p_Session_Date,'Pension Retirement Age');
1531: END IF;

Line 1529: hr_utility.trace('In Not Equals for AGE');

1525: IF ( to_number(p_new_PENSION_RETIRE_DATE) = to_number(p_old_PENSION_RETIRE_DATE) )
1526: THEN
1527: hr_utility.trace('In Equals for AGE');
1528: ELSE
1529: hr_utility.trace('In Not Equals for AGE');
1530: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_RETIRE_DATE,p_Session_Date,'Pension Retirement Age');
1531: END IF;
1532: END IF;
1533: */

Line 1540: hr_utility.trace('IF NOT NULL for Pension Group' || p_new_PENSION_GROUP ||' '||p_old_PENSION_GROUP);

1536: THEN
1537: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_GROUP,p_Session_Date,'Pension Group','INSERT');
1538: ELSIF (p_new_PENSION_GROUP IS NOT null OR p_old_PENSION_GROUP IS NOT null )
1539: THEN
1540: hr_utility.trace('IF NOT NULL for Pension Group' || p_new_PENSION_GROUP ||' '||p_old_PENSION_GROUP);
1541: IF ( trim(p_new_PENSION_GROUP) = trim(p_old_PENSION_GROUP) )
1542: THEN
1543: hr_utility.trace('In Equals for Pension group');
1544: ELSE

Line 1543: hr_utility.trace('In Equals for Pension group');

1539: THEN
1540: hr_utility.trace('IF NOT NULL for Pension Group' || p_new_PENSION_GROUP ||' '||p_old_PENSION_GROUP);
1541: IF ( trim(p_new_PENSION_GROUP) = trim(p_old_PENSION_GROUP) )
1542: THEN
1543: hr_utility.trace('In Equals for Pension group');
1544: ELSE
1545: hr_utility.trace('value ' ||p_new_PENSION_GROUP );
1546: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_GROUP,p_Session_Date,'Pension Group',p_dt_update_mode);
1547: END IF;

Line 1545: hr_utility.trace('value ' ||p_new_PENSION_GROUP );

1541: IF ( trim(p_new_PENSION_GROUP) = trim(p_old_PENSION_GROUP) )
1542: THEN
1543: hr_utility.trace('In Equals for Pension group');
1544: ELSE
1545: hr_utility.trace('value ' ||p_new_PENSION_GROUP );
1546: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_GROUP,p_Session_Date,'Pension Group',p_dt_update_mode);
1547: END IF;
1548: END IF;
1549:

Line 1555: hr_utility.trace('IF NOT NULL for Pension Insurance Number' || p_new_PENSION_INS_NUM ||' '||p_old_PENSION_INS_NUM);

1551: THEN
1552: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_INS_NUM,p_Session_Date,'Insurance Number','INSERT');
1553: ELSIF (p_new_PENSION_INS_NUM IS NOT null OR p_old_PENSION_INS_NUM IS NOT null )
1554: THEN
1555: hr_utility.trace('IF NOT NULL for Pension Insurance Number' || p_new_PENSION_INS_NUM ||' '||p_old_PENSION_INS_NUM);
1556: IF ( trim(p_new_PENSION_INS_NUM) = trim(p_old_PENSION_INS_NUM) )
1557: THEN
1558: hr_utility.trace('In Equals for Pension Insurance Number');
1559: ELSE

Line 1558: hr_utility.trace('In Equals for Pension Insurance Number');

1554: THEN
1555: hr_utility.trace('IF NOT NULL for Pension Insurance Number' || p_new_PENSION_INS_NUM ||' '||p_old_PENSION_INS_NUM);
1556: IF ( trim(p_new_PENSION_INS_NUM) = trim(p_old_PENSION_INS_NUM) )
1557: THEN
1558: hr_utility.trace('In Equals for Pension Insurance Number');
1559: ELSE
1560: hr_utility.trace('value ' ||p_new_PENSION_INS_NUM );
1561: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_INS_NUM,p_Session_Date,'Insurance Number',p_dt_update_mode);
1562: END IF;

Line 1560: hr_utility.trace('value ' ||p_new_PENSION_INS_NUM );

1556: IF ( trim(p_new_PENSION_INS_NUM) = trim(p_old_PENSION_INS_NUM) )
1557: THEN
1558: hr_utility.trace('In Equals for Pension Insurance Number');
1559: ELSE
1560: hr_utility.trace('value ' ||p_new_PENSION_INS_NUM );
1561: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_INS_NUM,p_Session_Date,'Insurance Number',p_dt_update_mode);
1562: END IF;
1563: END IF;
1564:

Line 1572: hr_utility.trace('In Equals for Pension Types');

1568: ELSIF (p_new_PENSION_TYPES IS NOT null OR p_old_PENSION_TYPES IS NOT null )
1569: THEN
1570: IF ( trim(p_new_PENSION_TYPES) = trim(p_old_PENSION_TYPES) )
1571: THEN
1572: hr_utility.trace('In Equals for Pension Types');
1573: ELSE
1574: hr_utility.trace('Value ' ||p_new_PENSION_TYPES );
1575: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_TYPES,p_Session_Date,'Pension Types',p_dt_update_mode);
1576: -- Pension type has been changed, so insert the joinig date and group.

Line 1574: hr_utility.trace('Value ' ||p_new_PENSION_TYPES );

1570: IF ( trim(p_new_PENSION_TYPES) = trim(p_old_PENSION_TYPES) )
1571: THEN
1572: hr_utility.trace('In Equals for Pension Types');
1573: ELSE
1574: hr_utility.trace('Value ' ||p_new_PENSION_TYPES );
1575: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_TYPES,p_Session_Date,'Pension Types',p_dt_update_mode);
1576: -- Pension type has been changed, so insert the joinig date and group.
1577: -- so that pension joindate record displayed in report
1578: INS_OR_UPD_PERSON_EIT_COLUMN(p_person_id,p_new_PENSION_JOINING_DATE,p_Session_Date,'Pension Joining Date','INSERT_CHANGE');

Line 1630: hr_utility.set_location('Entering '||'.calc_sch_based_dur',10);

1626: CURSOR get_time_format(l_time varchar2) is
1627: SELECT replace(trim(to_char(to_number(l_time),'00.00')),'.',':') FROM dual;
1628: --
1629: BEGIN
1630: hr_utility.set_location('Entering '||'.calc_sch_based_dur',10);
1631: l_return := 0;
1632: p_duration := 0;
1633: l_time_start := p_time_start;
1634: l_time_end := p_time_end;

Line 1666: hr_utility.set_location('calling hr_wrk_sch_pkg.get_per_asg_schedule',10);

1662: -- l_end_date := l_end_date; --knelli
1663: END IF;
1664: --
1665: -- Fetch the work schedule
1666: hr_utility.set_location('calling hr_wrk_sch_pkg.get_per_asg_schedule',10);
1667: --
1668: hr_wrk_sch_pkg.get_per_asg_schedule
1669: ( p_person_assignment_id => p_assignment_id
1670: , p_period_start_date => l_start_date

Line 1682: hr_utility.set_location('l_return status :' || l_return_status,10);

1678: , x_return_message => l_return_message
1679: );
1680: --
1681: --knelli
1682: hr_utility.set_location('l_return status :' || l_return_status,10);
1683: IF l_return_status = '0' THEN
1684: --
1685: -- Calculate duration
1686: --

Line 1688: hr_utility.set_location('l_idx - loop index :' || l_schedule.first,10);

1684: --
1685: -- Calculate duration
1686: --
1687: l_idx := l_schedule.first;
1688: hr_utility.set_location('l_idx - loop index :' || l_schedule.first,10);
1689: --
1690: IF p_days_or_hours = 'D' THEN
1691: --
1692: l_first_band := TRUE;

Line 1697: --hr_utility.set_location('free or busy '|| l_schedule(l_idx).FREE_BUSY_TYPE,20);

1693: l_ref_date := NULL;
1694: WHILE l_idx IS NOT NULL
1695: LOOP
1696: --knelli
1697: --hr_utility.set_location('free or busy '|| l_schedule(l_idx).FREE_BUSY_TYPE,20);
1698: --l_schedule(l_idx).FREE_BUSY_TYPE := 'FREE'; --SET BY KNELLI
1699: --knelli
1700: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
1701: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN --knelli changed FREE to BUSY

Line 1706: hr_utility.set_location('start date time '|| l_schedule(l_idx).START_DATE_TIME,20);

1702: IF l_first_band THEN
1703: l_first_band := FALSE;
1704: l_ref_date := TRUNC(l_schedule(l_idx).START_DATE_TIME);
1705: --knelli
1706: hr_utility.set_location('start date time '|| l_schedule(l_idx).START_DATE_TIME,20);
1707: hr_utility.set_location('end date time '|| l_schedule(l_idx).END_DATE_TIME,20);
1708: IF (TRUNC(l_schedule(l_idx).END_DATE_TIME) = TRUNC(l_schedule(l_idx).START_DATE_TIME)) THEN
1709: p_duration := p_duration + (TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) + 1);
1710: ELSE

Line 1707: hr_utility.set_location('end date time '|| l_schedule(l_idx).END_DATE_TIME,20);

1703: l_first_band := FALSE;
1704: l_ref_date := TRUNC(l_schedule(l_idx).START_DATE_TIME);
1705: --knelli
1706: hr_utility.set_location('start date time '|| l_schedule(l_idx).START_DATE_TIME,20);
1707: hr_utility.set_location('end date time '|| l_schedule(l_idx).END_DATE_TIME,20);
1708: IF (TRUNC(l_schedule(l_idx).END_DATE_TIME) = TRUNC(l_schedule(l_idx).START_DATE_TIME)) THEN
1709: p_duration := p_duration + (TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) + 1);
1710: ELSE
1711: p_duration := p_duration + (TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME));

Line 1737: --hr_utility.set_location('free or busy '|| l_schedule(l_idx).FREE_BUSY_TYPE,20);

1733: l_day_end_time := '23:59';
1734: WHILE l_idx IS NOT NULL
1735: LOOP
1736: --knelli
1737: --hr_utility.set_location('free or busy '|| l_schedule(l_idx).FREE_BUSY_TYPE,20);
1738: --l_schedule(l_idx).FREE_BUSY_TYPE := 'FREE'; --SET BY KNELLI
1739: IF l_schedule(l_idx).FREE_BUSY_TYPE IS NOT NULL THEN
1740: IF l_schedule(l_idx).FREE_BUSY_TYPE = 'FREE' THEN ----knelli changed FREE to BUSY
1741: IF l_schedule(l_idx).END_DATE_TIME < l_schedule(l_idx).START_DATE_TIME THEN

Line 1786: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);

1782: END IF;
1783: END IF;
1784: RETURN l_return;
1785: --
1786: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
1787: EXCEPTION
1788: --
1789: WHEN e_bad_time_format THEN
1790: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);

Line 1790: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);

1786: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',20);
1787: EXCEPTION
1788: --
1789: WHEN e_bad_time_format THEN
1790: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
1791: hr_utility.set_location(SQLERRM,35);
1792: RAISE;
1793: --
1794: WHEN OTHERS THEN

Line 1791: hr_utility.set_location(SQLERRM,35);

1787: EXCEPTION
1788: --
1789: WHEN e_bad_time_format THEN
1790: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',30);
1791: hr_utility.set_location(SQLERRM,35);
1792: RAISE;
1793: --
1794: WHEN OTHERS THEN
1795: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);

Line 1795: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);

1791: hr_utility.set_location(SQLERRM,35);
1792: RAISE;
1793: --
1794: WHEN OTHERS THEN
1795: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
1796: hr_utility.set_location(SQLERRM,45);
1797: RAISE;
1798: --
1799: RETURN l_return;

Line 1796: hr_utility.set_location(SQLERRM,45);

1792: RAISE;
1793: --
1794: WHEN OTHERS THEN
1795: hr_utility.set_location('Leaving '||g_package||'.calc_sch_based_dur',40);
1796: hr_utility.set_location(SQLERRM,45);
1797: RAISE;
1798: --
1799: RETURN l_return;
1800: END calc_sch_based_dur;

Line 1914: HR_UTILITY.TRACE_ON(NULL,'X');

1910:
1911: FUNCTION PRINT1(P_LEVEL IN NUMBER,P_TEXT IN VARCHAR2,P_VALUE IN VARCHAR2) RETURN NUMBER
1912: IS
1913: BEGIN
1914: HR_UTILITY.TRACE_ON(NULL,'X');
1915: HR_UTILITY.TRACE(P_LEVEL ||' ' || P_TEXT || ' ' || P_VALUE );
1916: HR_UTILITY.TRACE_OFF;
1917: RETURN 1;
1918: END;

Line 1915: HR_UTILITY.TRACE(P_LEVEL ||' ' || P_TEXT || ' ' || P_VALUE );

1911: FUNCTION PRINT1(P_LEVEL IN NUMBER,P_TEXT IN VARCHAR2,P_VALUE IN VARCHAR2) RETURN NUMBER
1912: IS
1913: BEGIN
1914: HR_UTILITY.TRACE_ON(NULL,'X');
1915: HR_UTILITY.TRACE(P_LEVEL ||' ' || P_TEXT || ' ' || P_VALUE );
1916: HR_UTILITY.TRACE_OFF;
1917: RETURN 1;
1918: END;
1919:

Line 1916: HR_UTILITY.TRACE_OFF;

1912: IS
1913: BEGIN
1914: HR_UTILITY.TRACE_ON(NULL,'X');
1915: HR_UTILITY.TRACE(P_LEVEL ||' ' || P_TEXT || ' ' || P_VALUE );
1916: HR_UTILITY.TRACE_OFF;
1917: RETURN 1;
1918: END;
1919:
1920: FUNCTION get_input_value_in_varchar