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.PQH_FR_UTILITY dependencies on HR_UTILITY

Line 55: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN

51:
52: BEGIN
53: --
54: /* Added for GSI Bug 5472781 */
55: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
56: hr_utility.set_location('Leaving : pqh_fr_utility.delete_duplicate_asg_records' , 5);
57: return;
58: END IF;
59: --

Line 56: hr_utility.set_location('Leaving : pqh_fr_utility.delete_duplicate_asg_records' , 5);

52: BEGIN
53: --
54: /* Added for GSI Bug 5472781 */
55: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
56: hr_utility.set_location('Leaving : pqh_fr_utility.delete_duplicate_asg_records' , 5);
57: return;
58: END IF;
59: --
60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);

Line 60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);

56: hr_utility.set_location('Leaving : pqh_fr_utility.delete_duplicate_asg_records' , 5);
57: return;
58: END IF;
59: --
60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);
61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);
62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);
63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);
64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);

Line 61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);

57: return;
58: END IF;
59: --
60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);
61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);
62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);
63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);
64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);
65:

Line 62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);

58: END IF;
59: --
60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);
61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);
62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);
63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);
64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);
65:
66: open csr_get_context;

Line 63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);

59: --
60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);
61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);
62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);
63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);
64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);
65:
66: open csr_get_context;
67: fetch csr_get_context into l_context;

Line 64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);

60: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_RESULT_ID'||P_COPY_ENTITY_RESULT_ID, 5);
61: HR_UTILITY.SET_LOCATION('P_COPY_ENTITY_TXN_ID'||P_COPY_ENTITY_TXN_ID, 5);
62: HR_UTILITY.SET_LOCATION('P_INFORMATION2'||P_INFORMATION2, 5);
63: HR_UTILITY.SET_LOCATION('P_INFORMATION67'||P_INFORMATION67, 5);
64: HR_UTILITY.SET_LOCATION('P_RESULT_TYPE_CD'||P_RESULT_TYPE_CD, 5);
65:
66: open csr_get_context;
67: fetch csr_get_context into l_context;
68: if l_context = 'PQH_ASSIGNMENT_UPDATE' then

Line 70: HR_UTILITY.SET_LOCATION('In pqh_assignment_update context', 20);

66: open csr_get_context;
67: fetch csr_get_context into l_context;
68: if l_context = 'PQH_ASSIGNMENT_UPDATE' then
69:
70: HR_UTILITY.SET_LOCATION('In pqh_assignment_update context', 20);
71: -- Added for Bug 6031763
72: if NOT(length(p_information67) > 11) then
73: l_information67 := fnd_date.date_to_canonical(fnd_date.string_to_date(p_information67,NVL(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY')));
74: else

Line 85: HR_UTILITY.SET_LOCATION('In Legislation', 10);

81: --
82: fetch csr_get_legislation into l_legislation;
83: if csr_get_legislation%found then
84:
85: HR_UTILITY.SET_LOCATION('In Legislation', 10);
86: if l_legislation = 'FR' then
87:
88: HR_UTILITY.SET_LOCATION('In France Legislation', 15);
89: open csr_chk_dup_rec;

Line 88: HR_UTILITY.SET_LOCATION('In France Legislation', 15);

84:
85: HR_UTILITY.SET_LOCATION('In Legislation', 10);
86: if l_legislation = 'FR' then
87:
88: HR_UTILITY.SET_LOCATION('In France Legislation', 15);
89: open csr_chk_dup_rec;
90: fetch csr_chk_dup_rec into l_duplicate;
91: if l_duplicate > 0 then
92:

Line 93: hr_utility.set_location('Has Duplicate Records', 25);

89: open csr_chk_dup_rec;
90: fetch csr_chk_dup_rec into l_duplicate;
91: if l_duplicate > 0 then
92:
93: hr_utility.set_location('Has Duplicate Records', 25);
94: fnd_message.set_name('PER', 'HR_FR_DUP_ORG_MASS_UPD');
95: fnd_message.raise_error;
96: end if;
97: close csr_chk_dup_rec;

Line 104: HR_UTILITY.SET_LOCATION('l_duplicate'||l_duplicate, 25);

100: close csr_get_legislation;
101: end if; -- context different
102: close csr_get_context;
103:
104: HR_UTILITY.SET_LOCATION('l_duplicate'||l_duplicate, 25);
105:
106: END DELETE_DUPLICATE_ASG_RECORDS;
107:
108: FUNCTION get_kf_id_flex_num(p_id_flex_code Varchar2,

Line 1270: hr_utility.set_location('inside the career loop',10);

1266:
1267: if p_action = 'CAREER' then
1268: --
1269: FOR i IN csr_asg_career LOOP
1270: hr_utility.set_location('inside the career loop',10);
1271: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1272: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1273: IF i.effective_start_date = p_start_date THEN
1274: hr_utility.set_location('current record',10);

Line 1271: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1267: if p_action = 'CAREER' then
1268: --
1269: FOR i IN csr_asg_career LOOP
1270: hr_utility.set_location('inside the career loop',10);
1271: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1272: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1273: IF i.effective_start_date = p_start_date THEN
1274: hr_utility.set_location('current record',10);
1275: l_emp_catg := i.employment_category;

Line 1272: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1268: --
1269: FOR i IN csr_asg_career LOOP
1270: hr_utility.set_location('inside the career loop',10);
1271: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1272: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1273: IF i.effective_start_date = p_start_date THEN
1274: hr_utility.set_location('current record',10);
1275: l_emp_catg := i.employment_category;
1276: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;

Line 1274: hr_utility.set_location('current record',10);

1270: hr_utility.set_location('inside the career loop',10);
1271: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1272: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1273: IF i.effective_start_date = p_start_date THEN
1274: hr_utility.set_location('current record',10);
1275: l_emp_catg := i.employment_category;
1276: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1277: l_grd_id := i.grade_id;
1278: ELSE

Line 1279: hr_utility.set_location('previous record',10);

1275: l_emp_catg := i.employment_category;
1276: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1277: l_grd_id := i.grade_id;
1278: ELSE
1279: hr_utility.set_location('previous record',10);
1280: l_old_start_date := i.effective_start_date;
1281: l_old_emp_catg := i.employment_category;
1282: l_old_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1283: l_old_grd_id := i.grade_id;

Line 1287: hr_utility.set_location('1st exit',10);

1283: l_old_grd_id := i.grade_id;
1284: END IF;
1285: END LOOP;
1286: IF l_old_start_date IS NULL THEN
1287: hr_utility.set_location('1st exit',10);
1288: RETURN HR_GENERAL.end_of_time; --Returning end of time because we dont want to match it to asg.effective_start_date
1289: ELSE
1290: IF l_emp_catg <> l_old_emp_catg AND (l_grd_ldr_pgm_id = l_old_grd_ldr_pgm_id AND l_grd_id = l_old_grd_id) THEN
1291: hr_utility.set_location('3rd exit',10);

Line 1291: hr_utility.set_location('3rd exit',10);

1287: hr_utility.set_location('1st exit',10);
1288: RETURN HR_GENERAL.end_of_time; --Returning end of time because we dont want to match it to asg.effective_start_date
1289: ELSE
1290: IF l_emp_catg <> l_old_emp_catg AND (l_grd_ldr_pgm_id = l_old_grd_ldr_pgm_id AND l_grd_id = l_old_grd_id) THEN
1291: hr_utility.set_location('3rd exit',10);
1292: RETURN p_start_date;
1293: ELSE
1294: hr_utility.set_location('2nd exit',10);
1295: RETURN HR_GENERAL.end_of_time; --Returning end of time because we dont want to match it to asg.effective_start_date

Line 1294: hr_utility.set_location('2nd exit',10);

1290: IF l_emp_catg <> l_old_emp_catg AND (l_grd_ldr_pgm_id = l_old_grd_ldr_pgm_id AND l_grd_id = l_old_grd_id) THEN
1291: hr_utility.set_location('3rd exit',10);
1292: RETURN p_start_date;
1293: ELSE
1294: hr_utility.set_location('2nd exit',10);
1295: RETURN HR_GENERAL.end_of_time; --Returning end of time because we dont want to match it to asg.effective_start_date
1296: END IF;
1297: END IF;
1298: --

Line 1301: hr_utility.set_location('inside the employ loop',10);

1297: END IF;
1298: --
1299: elsif p_action = 'EMPLOY' then
1300: for i in csr_asg_employ loop
1301: hr_utility.set_location('inside the employ loop',10);
1302: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1303: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1304: if i.effective_start_date = p_start_date then
1305: hr_utility.set_location('current record',10);

Line 1302: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1298: --
1299: elsif p_action = 'EMPLOY' then
1300: for i in csr_asg_employ loop
1301: hr_utility.set_location('inside the employ loop',10);
1302: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1303: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1304: if i.effective_start_date = p_start_date then
1305: hr_utility.set_location('current record',10);
1306: l_normal_hours := i.normal_hours;

Line 1303: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1299: elsif p_action = 'EMPLOY' then
1300: for i in csr_asg_employ loop
1301: hr_utility.set_location('inside the employ loop',10);
1302: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1303: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1304: if i.effective_start_date = p_start_date then
1305: hr_utility.set_location('current record',10);
1306: l_normal_hours := i.normal_hours;
1307: l_frequency := i.frequency;

Line 1305: hr_utility.set_location('current record',10);

1301: hr_utility.set_location('inside the employ loop',10);
1302: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1303: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1304: if i.effective_start_date = p_start_date then
1305: hr_utility.set_location('current record',10);
1306: l_normal_hours := i.normal_hours;
1307: l_frequency := i.frequency;
1308: l_establish := i.establishment_id;
1309: l_category := i.category;

Line 1313: hr_utility.set_location('previous record',10);

1309: l_category := i.category;
1310: l_reason := i.reason;
1311: l_share := i.share_part;
1312: else
1313: hr_utility.set_location('previous record',10);
1314: l_old_start_date := i.effective_start_date;
1315: l_old_normal_hours := i.normal_hours;
1316: l_old_frequency := i.frequency;
1317: l_old_establish := i.establishment_id;

Line 1324: hr_utility.set_location('1st exit',10);

1320: l_old_share := i.share_part;
1321: end if;
1322: end loop;
1323: if l_old_start_date is null then
1324: hr_utility.set_location('1st exit',10);
1325: return p_start_date;
1326: else
1327: if l_normal_hours = l_old_normal_hours
1328: and l_frequency = l_old_frequency

Line 1333: hr_utility.set_location('2nd exit',10);

1329: and l_establish = l_old_establish
1330: and l_category = l_old_category
1331: and l_reason = l_old_reason
1332: and l_share = l_old_share then
1333: hr_utility.set_location('2nd exit',10);
1334: return l_old_start_date;
1335: else
1336: hr_utility.set_location('3rd exit',10);
1337: return p_start_date;

Line 1336: hr_utility.set_location('3rd exit',10);

1332: and l_share = l_old_share then
1333: hr_utility.set_location('2nd exit',10);
1334: return l_old_start_date;
1335: else
1336: hr_utility.set_location('3rd exit',10);
1337: return p_start_date;
1338: end if;
1339: end if;
1340: elsif p_action = 'AFFECT' then

Line 1342: hr_utility.set_location('inside the affect loop',10);

1338: end if;
1339: end if;
1340: elsif p_action = 'AFFECT' then
1341: for i in csr_asg_affect loop
1342: hr_utility.set_location('inside the affect loop',10);
1343: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1344: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1345: if i.effective_start_date = p_start_date then
1346: hr_utility.set_location('current record',10);

Line 1343: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1339: end if;
1340: elsif p_action = 'AFFECT' then
1341: for i in csr_asg_affect loop
1342: hr_utility.set_location('inside the affect loop',10);
1343: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1344: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1345: if i.effective_start_date = p_start_date then
1346: hr_utility.set_location('current record',10);
1347: l_identifier := i.identifier;

Line 1344: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1340: elsif p_action = 'AFFECT' then
1341: for i in csr_asg_affect loop
1342: hr_utility.set_location('inside the affect loop',10);
1343: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1344: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1345: if i.effective_start_date = p_start_date then
1346: hr_utility.set_location('current record',10);
1347: l_identifier := i.identifier;
1348: l_type := i.type;

Line 1346: hr_utility.set_location('current record',10);

1342: hr_utility.set_location('inside the affect loop',10);
1343: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1344: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1345: if i.effective_start_date = p_start_date then
1346: hr_utility.set_location('current record',10);
1347: l_identifier := i.identifier;
1348: l_type := i.type;
1349: l_seg27 := i.seg27;
1350: l_seg26 := i.seg26;

Line 1358: hr_utility.set_location('previous record',10);

1354: l_frequency := i.frequency;
1355: l_supervisor_id := i.supervisor;
1356: l_assignment_status_type_id := i.assignment_status_type_id;
1357: else
1358: hr_utility.set_location('previous record',10);
1359: l_old_identifier := i.identifier;
1360: l_old_type := i.type;
1361: l_old_seg27 := i.seg27;
1362: l_old_seg26 := i.seg26;

Line 1373: hr_utility.set_location('1st exit',10);

1369: l_old_assign_status_type_id := i.assignment_status_type_id;
1370: end if;
1371: end loop;
1372: if l_old_start_date is null then
1373: hr_utility.set_location('1st exit',10);
1374: return p_start_date;
1375: else
1376: if l_old_identifier = l_identifier
1377: and l_old_type = l_type

Line 1386: hr_utility.set_location('2nd exit',10);

1382: and l_old_normal_hours = l_normal_hours
1383: and l_old_frequency = l_frequency
1384: and l_old_supervisor_id = l_supervisor_id
1385: and l_old_assign_status_type_id = l_assignment_status_type_id then
1386: hr_utility.set_location('2nd exit',10);
1387: return l_old_start_date;
1388: else
1389: hr_utility.set_location('3rd exit',10);
1390: return p_start_date;

Line 1389: hr_utility.set_location('3rd exit',10);

1385: and l_old_assign_status_type_id = l_assignment_status_type_id then
1386: hr_utility.set_location('2nd exit',10);
1387: return l_old_start_date;
1388: else
1389: hr_utility.set_location('3rd exit',10);
1390: return p_start_date;
1391: end if;
1392: end if;
1393: else

Line 1394: hr_utility.set_location('invalid action passed'||p_action,10);

1390: return p_start_date;
1391: end if;
1392: end if;
1393: else
1394: hr_utility.set_location('invalid action passed'||p_action,10);
1395: end if;
1396:
1397: end view_start_date;
1398: --

Line 1793: hr_utility.set_location('inside the career loop',10);

1789: FOR i IN csr_end_date LOOP
1790: l_end_date := i.effective_end_date;
1791: END LOOP;
1792: FOR i IN csr_asg_career LOOP
1793: hr_utility.set_location('inside the career loop',10);
1794: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1795: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1796: IF i.effective_start_date = p_start_date THEN
1797: hr_utility.set_location('current record',10);

Line 1794: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1790: l_end_date := i.effective_end_date;
1791: END LOOP;
1792: FOR i IN csr_asg_career LOOP
1793: hr_utility.set_location('inside the career loop',10);
1794: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1795: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1796: IF i.effective_start_date = p_start_date THEN
1797: hr_utility.set_location('current record',10);
1798: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;

Line 1795: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1791: END LOOP;
1792: FOR i IN csr_asg_career LOOP
1793: hr_utility.set_location('inside the career loop',10);
1794: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1795: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1796: IF i.effective_start_date = p_start_date THEN
1797: hr_utility.set_location('current record',10);
1798: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1799: l_grade_id := i.grade_id;

Line 1797: hr_utility.set_location('current record',10);

1793: hr_utility.set_location('inside the career loop',10);
1794: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1795: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1796: IF i.effective_start_date = p_start_date THEN
1797: hr_utility.set_location('current record',10);
1798: l_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1799: l_grade_id := i.grade_id;
1800: l_emp_cat := i.employment_category;
1801: l_end_date := i.effective_end_date;

Line 1803: hr_utility.set_location('future record',10);

1799: l_grade_id := i.grade_id;
1800: l_emp_cat := i.employment_category;
1801: l_end_date := i.effective_end_date;
1802: ELSE
1803: hr_utility.set_location('future record',10);
1804: l_fut_start_date := i.effective_start_date;
1805: l_fut_grd_ldr_pgm_id := i.grade_ladder_pgm_id;
1806: l_fut_grade_id := i.grade_id;
1807: l_fut_emp_cat := i.employment_category;

Line 1811: hr_utility.set_location('first time in loop',10);

1807: l_fut_emp_cat := i.employment_category;
1808: l_fut_end_date := i.effective_end_date;
1809: END IF;
1810: IF l_fut_start_date IS NULL THEN
1811: hr_utility.set_location('first time in loop',10);
1812: l_return_end_date := l_end_date;
1813: ELSE
1814: IF l_grd_ldr_pgm_id=l_fut_grd_ldr_pgm_id AND l_grade_id=l_fut_grade_id AND l_emp_cat=l_fut_emp_cat THEN
1815: hr_utility.set_location('equality condition satisfied',10);

Line 1815: hr_utility.set_location('equality condition satisfied',10);

1811: hr_utility.set_location('first time in loop',10);
1812: l_return_end_date := l_end_date;
1813: ELSE
1814: IF l_grd_ldr_pgm_id=l_fut_grd_ldr_pgm_id AND l_grade_id=l_fut_grade_id AND l_emp_cat=l_fut_emp_cat THEN
1815: hr_utility.set_location('equality condition satisfied',10);
1816: l_return_end_date := l_fut_end_date;
1817: ELSE
1818: hr_utility.set_location('Equality condition not satisfied',10);
1819: EXIT;

Line 1818: hr_utility.set_location('Equality condition not satisfied',10);

1814: IF l_grd_ldr_pgm_id=l_fut_grd_ldr_pgm_id AND l_grade_id=l_fut_grade_id AND l_emp_cat=l_fut_emp_cat THEN
1815: hr_utility.set_location('equality condition satisfied',10);
1816: l_return_end_date := l_fut_end_date;
1817: ELSE
1818: hr_utility.set_location('Equality condition not satisfied',10);
1819: EXIT;
1820: END IF;
1821: END IF;
1822: END LOOP;

Line 1823: hr_utility.set_location('Out of loop',10);

1819: EXIT;
1820: END IF;
1821: END IF;
1822: END LOOP;
1823: hr_utility.set_location('Out of loop',10);
1824: RETURN l_return_end_date;
1825: --
1826: elsif p_action = 'EMPLOY' then
1827:

Line 1833: hr_utility.set_location('inside the employ loop',10);

1829: for i in csr_end_date loop
1830: l_end_date := i.effective_end_date;
1831: end loop;
1832: for i in csr_asg_employ loop
1833: hr_utility.set_location('inside the employ loop',10);
1834: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1835: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1836: if i.effective_start_date = p_start_date then
1837: hr_utility.set_location('current record',10);

Line 1834: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1830: l_end_date := i.effective_end_date;
1831: end loop;
1832: for i in csr_asg_employ loop
1833: hr_utility.set_location('inside the employ loop',10);
1834: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1835: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1836: if i.effective_start_date = p_start_date then
1837: hr_utility.set_location('current record',10);
1838: l_normal_hours := i.normal_hours;

Line 1835: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1831: end loop;
1832: for i in csr_asg_employ loop
1833: hr_utility.set_location('inside the employ loop',10);
1834: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1835: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1836: if i.effective_start_date = p_start_date then
1837: hr_utility.set_location('current record',10);
1838: l_normal_hours := i.normal_hours;
1839: l_frequency := i.frequency;

Line 1837: hr_utility.set_location('current record',10);

1833: hr_utility.set_location('inside the employ loop',10);
1834: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1835: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1836: if i.effective_start_date = p_start_date then
1837: hr_utility.set_location('current record',10);
1838: l_normal_hours := i.normal_hours;
1839: l_frequency := i.frequency;
1840: l_establish := i.establishment_id;
1841: l_category := i.category;

Line 1846: hr_utility.set_location('previous record',10);

1842: l_reason := i.reason;
1843: l_share := i.share_part;
1844: l_end_date := i.effective_end_date;
1845: else
1846: hr_utility.set_location('previous record',10);
1847: l_fut_start_date := i.effective_start_date;
1848: l_fut_normal_hours := i.normal_hours;
1849: l_fut_frequency := i.frequency;
1850: l_fut_establish := i.establishment_id;

Line 1857: hr_utility.set_location('first time in loop',10);

1853: l_fut_share := i.share_part;
1854: l_fut_end_date := i.effective_end_date;
1855: end if;
1856: if l_fut_start_date is null then
1857: hr_utility.set_location('first time in loop',10);
1858: l_return_end_date := l_end_date;
1859: else
1860: if l_normal_hours = l_fut_normal_hours
1861: and l_frequency = l_fut_frequency

Line 1866: hr_utility.set_location('equality condition satisfied',10);

1862: and l_establish = l_fut_establish
1863: and l_category = l_fut_category
1864: and l_reason = l_fut_reason
1865: and l_share = l_fut_share then
1866: hr_utility.set_location('equality condition satisfied',10);
1867: l_return_end_date := l_fut_end_date;
1868: else
1869: hr_utility.set_location('Equality condition not satisfied',10);
1870: exit;

Line 1869: hr_utility.set_location('Equality condition not satisfied',10);

1865: and l_share = l_fut_share then
1866: hr_utility.set_location('equality condition satisfied',10);
1867: l_return_end_date := l_fut_end_date;
1868: else
1869: hr_utility.set_location('Equality condition not satisfied',10);
1870: exit;
1871: end if;
1872: end if;
1873: end loop;

Line 1874: hr_utility.set_location('Out of loop',10);

1870: exit;
1871: end if;
1872: end if;
1873: end loop;
1874: hr_utility.set_location('Out of loop',10);
1875: return l_return_end_date;
1876: elsif p_action = 'AFFECT' then
1877: l_assignment_id := p_assignment_id;
1878: for i in csr_end_date loop

Line 1882: hr_utility.set_location('inside the affect loop',10);

1878: for i in csr_end_date loop
1879: l_end_date := i.effective_end_date;
1880: end loop;
1881: for i in csr_asg_affect loop
1882: hr_utility.set_location('inside the affect loop',10);
1883: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1884: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1885: if i.effective_start_date = p_start_date then
1886: hr_utility.set_location('current record',10);

Line 1883: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);

1879: l_end_date := i.effective_end_date;
1880: end loop;
1881: for i in csr_asg_affect loop
1882: hr_utility.set_location('inside the affect loop',10);
1883: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1884: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1885: if i.effective_start_date = p_start_date then
1886: hr_utility.set_location('current record',10);
1887: l_identifier := i.identifier;

Line 1884: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);

1880: end loop;
1881: for i in csr_asg_affect loop
1882: hr_utility.set_location('inside the affect loop',10);
1883: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1884: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1885: if i.effective_start_date = p_start_date then
1886: hr_utility.set_location('current record',10);
1887: l_identifier := i.identifier;
1888: l_type := i.type;

Line 1886: hr_utility.set_location('current record',10);

1882: hr_utility.set_location('inside the affect loop',10);
1883: hr_utility.set_location('start date is '||to_char(p_start_date,'ddmmyyyy'),10);
1884: hr_utility.set_location('asg start date is '||to_char(i.effective_start_date,'ddmmyyyy'),10);
1885: if i.effective_start_date = p_start_date then
1886: hr_utility.set_location('current record',10);
1887: l_identifier := i.identifier;
1888: l_type := i.type;
1889: l_seg27 := i.seg27;
1890: l_seg26 := i.seg26;

Line 1899: hr_utility.set_location('previous record',10);

1895: l_supervisor_id := i.supervisor;
1896: l_assignment_status_type_id := i.assignment_status_type_id;
1897: l_end_date := i.effective_end_date;
1898: else
1899: hr_utility.set_location('previous record',10);
1900: l_fut_identifier := i.identifier;
1901: l_fut_type := i.type;
1902: l_fut_seg27 := i.seg27;
1903: l_fut_seg26 := i.seg26;

Line 1914: hr_utility.set_location('first time in loop',10);

1910: l_fut_assign_status_type_id := i.assignment_status_type_id;
1911: l_fut_end_date := i.effective_end_date;
1912: end if;
1913: if l_fut_start_date is null then
1914: hr_utility.set_location('first time in loop',10);
1915: l_return_end_date := l_end_date;
1916: else
1917: if l_fut_identifier = l_identifier
1918: and l_fut_type = l_type

Line 1927: hr_utility.set_location('equality condition satisfied',10);

1923: and l_fut_normal_hours = l_normal_hours
1924: and l_fut_frequency = l_frequency
1925: and l_fut_supervisor_id = l_supervisor_id
1926: and l_fut_assign_status_type_id = l_assignment_status_type_id then
1927: hr_utility.set_location('equality condition satisfied',10);
1928: l_return_end_date := l_fut_end_date;
1929: else
1930: hr_utility.set_location('Equality condition not satisfied',10);
1931: exit;

Line 1930: hr_utility.set_location('Equality condition not satisfied',10);

1926: and l_fut_assign_status_type_id = l_assignment_status_type_id then
1927: hr_utility.set_location('equality condition satisfied',10);
1928: l_return_end_date := l_fut_end_date;
1929: else
1930: hr_utility.set_location('Equality condition not satisfied',10);
1931: exit;
1932: end if;
1933: end if;
1934: end loop;

Line 1935: hr_utility.set_location('Out of loop',10);

1931: exit;
1932: end if;
1933: end if;
1934: end loop;
1935: hr_utility.set_location('Out of loop',10);
1936: return l_return_end_date;
1937: else
1938: hr_utility.set_location('invalid action passed'||p_action,10);
1939: return null;

Line 1938: hr_utility.set_location('invalid action passed'||p_action,10);

1934: end loop;
1935: hr_utility.set_location('Out of loop',10);
1936: return l_return_end_date;
1937: else
1938: hr_utility.set_location('invalid action passed'||p_action,10);
1939: return null;
1940: end if;
1941:
1942: end view_end_date;