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

Line 119: hr_utility.raise_error;

115: FETCH c_check_references1 into V_name;
116: IF c_check_references1%FOUND THEN
117: CLOSE c_check_references1;
118: fnd_message.set_name('PER','HR_6125_REQS_VACS_DEL_ASSIGN');
119: hr_utility.raise_error;
120: ELSE CLOSE c_check_references1;
121: END IF;
122: --
123: OPEN c_check_ref_2;

Line 129: hr_utility.raise_error;

125: IF c_check_ref_2%FOUND THEN
126: CLOSE c_check_ref_2;
127: fnd_message.set_name('PER','HR_6126_REQS_VACS_DEL_REC_ACTY');
128: fnd_message.set_token('VACANCY_NAME',V_name);
129: hr_utility.raise_error;
130: ELSE CLOSE c_check_ref_2;
131: END IF;
132: --
133: END Check_References;

Line 269: hr_utility.raise_error;

265:
266: if csr_appl_exists%found then
267: close csr_appl_exists;
268: fnd_message.set_name('PER','HR_449819_VACS_APL_ACTS');
269: hr_utility.raise_error;
270: else
271: close csr_appl_exists;
272: end if;
273:

Line 305: hr_utility.raise_error;

301: IF name_exists%found THEN
302: CLOSE name_exists;
303: fnd_message.set_name('PER', 'HR_6638_VACS_UNIQUE_VAC_NAME');
304: fnd_message.set_token('REQ_NAME',v_req_name);
305: hr_utility.raise_error;
306: ELSE CLOSE name_exists;
307: END IF;
308: END Check_Unique_Name;
309: --

Line 340: hr_utility.raise_error;

336: FETCH c_check_in_req_dates into v_dummy;
337: IF c_check_in_req_dates%found THEN
338: CLOSE c_check_in_req_dates;
339: fnd_message.set_name('PER', 'HR_6640_VACS_IN_REQ_DATES');
340: hr_utility.raise_error;
341: ELSE CLOSE c_check_in_req_dates;
342: END IF;
343: END Check_in_req_dates;
344: --

Line 375: hr_utility.raise_error;

371: FETCH c_in_req_dt into v_dummy;
372: IF c_in_req_dt%found THEN
373: CLOSE c_in_req_dt;
374: fnd_message.set_name('PER','HR_6843_VACS_DATE_TO_VAC');
375: hr_utility.raise_error;
376: ELSE CLOSE c_in_req_dt;
377: END IF;
378: END Chk_dt_to_in_req_dates;
379: --

Line 486: hr_utility.set_location('Entering: D_from_updt_rec_act_chk',10);

482: --
483: BEGIN
484: --
485: -- stubbed for bug 6497289
486: hr_utility.set_location('Entering: D_from_updt_rec_act_chk',10);
487: /*
488: OPEN c_rec_act_chk;
489: FETCH c_rec_act_chk into v_dummy;
490: IF c_rec_act_chk%found THEN

Line 493: hr_utility.raise_error;

489: FETCH c_rec_act_chk into v_dummy;
490: IF c_rec_act_chk%found THEN
491: CLOSE c_rec_act_chk;
492: fnd_message.set_name('PER','HR_6641_VACS_REC_ACTS');
493: hr_utility.raise_error;
494: ELSE CLOSE c_rec_act_chk;
495: END IF;
496: */
497: hr_utility.set_location('Leaving: D_from_updt_rec_act_chk',100);

Line 497: hr_utility.set_location('Leaving: D_from_updt_rec_act_chk',100);

493: hr_utility.raise_error;
494: ELSE CLOSE c_rec_act_chk;
495: END IF;
496: */
497: hr_utility.set_location('Leaving: D_from_updt_rec_act_chk',100);
498: --
499: END D_from_updt_rec_act_chk;
500: --
501: -----------------------------------------------------------------------------

Line 532: hr_utility.raise_error;

528: IF c_org_chk%found THEN
529: CLOSE c_org_chk;
530: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
531: fnd_message.set_token('PART','organization');
532: hr_utility.raise_error;
533: ELSE CLOSE c_org_chk;
534: END IF;
535: --
536: END D_from_updt_org_chk;

Line 572: hr_utility.raise_error;

568: IF c_org_chk%found THEN
569: CLOSE c_org_chk;
570: fnd_message.set_name('PER',' HR_289199_ORG_VACS_DATE_TO');
571: fnd_message.set_token('DATE',v_date);
572: hr_utility.raise_error;
573: ELSE CLOSE c_org_chk;
574: END IF;
575: --
576: END D_to_updt_org_chk;

Line 609: hr_utility.raise_error;

605: IF c_pos_chk%found THEN
606: CLOSE c_pos_chk;
607: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
608: fnd_message.set_token('PART','position');
609: hr_utility.raise_error;
610: ELSE CLOSE c_pos_chk;
611: END IF;
612: END D_from_updt_pos_chk;
613: --

Line 645: hr_utility.raise_error;

641: IF c_grp_chk%found THEN
642: CLOSE c_grp_chk;
643: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
644: fnd_message.set_token('PART','group');
645: hr_utility.raise_error;
646: ELSE CLOSE c_grp_chk;
647: END IF;
648: END D_from_updt_grp_chk;
649: --

Line 681: hr_utility.raise_error;

677: IF c_job_chk%found THEN
678: CLOSE c_job_chk;
679: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
680: fnd_message.set_token('PART','job');
681: hr_utility.raise_error;
682: ELSE CLOSE c_job_chk;
683: END IF;
684: END D_from_updt_job_chk;
685: --

Line 717: hr_utility.raise_error;

713: IF c_grade_chk%found THEN
714: CLOSE c_grade_chk;
715: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
716: fnd_message.set_token('PART','grade');
717: hr_utility.raise_error;
718: ELSE CLOSE c_grade_chk;
719: END IF;
720: END D_from_updt_grd_chk;
721: --

Line 752: hr_utility.raise_error;

748: IF c_loc_chk%found THEN
749: CLOSE c_loc_chk;
750: fnd_message.set_name('PER','HR_6188_REQS_VACS_DATE_FROM');
751: fnd_message.set_token('PART','location');
752: hr_utility.raise_error;
753: ELSE CLOSE c_loc_chk;
754: END IF;
755: END D_from_updt_loc_chk;
756: --

Line 791: hr_utility.raise_error;

787: FETCH c_person into v_dummy;
788: IF c_person%notfound THEN
789: CLOSE c_person;
790: fnd_message.set_name('PER','HR_6642_VACS_RECRUITER');
791: hr_utility.raise_error;
792: ELSE CLOSE c_person;
793: END IF;
794: END D_from_updt_person;
795: --

Line 971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

967: OPEN C;
968: FETCH C INTO X_Rowid;
969: if (C%NOTFOUND) then
970: CLOSE C;
971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
972: hr_utility.set_message_token('PROCEDURE',
973: 'per_vacancies_pkg.insert_row');
974: hr_utility.set_message_token('STEP','1');
975: hr_utility.raise_error;

Line 972: hr_utility.set_message_token('PROCEDURE',

968: FETCH C INTO X_Rowid;
969: if (C%NOTFOUND) then
970: CLOSE C;
971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
972: hr_utility.set_message_token('PROCEDURE',
973: 'per_vacancies_pkg.insert_row');
974: hr_utility.set_message_token('STEP','1');
975: hr_utility.raise_error;
976: end if;

Line 974: hr_utility.set_message_token('STEP','1');

970: CLOSE C;
971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
972: hr_utility.set_message_token('PROCEDURE',
973: 'per_vacancies_pkg.insert_row');
974: hr_utility.set_message_token('STEP','1');
975: hr_utility.raise_error;
976: end if;
977: CLOSE C;
978: --

Line 975: hr_utility.raise_error;

971: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
972: hr_utility.set_message_token('PROCEDURE',
973: 'per_vacancies_pkg.insert_row');
974: hr_utility.set_message_token('STEP','1');
975: hr_utility.raise_error;
976: end if;
977: CLOSE C;
978: --
979: per_applicant_pkg.update_group ( x_people_group_id,

Line 1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1044: OPEN C;
1045: FETCH C INTO g_Recinfo;
1046: if (C%NOTFOUND) then
1047: CLOSE C;
1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1049: hr_utility.set_message_token('PROCEDURE',
1050: 'per_vacancies_pkb.lock_row');
1051: hr_utility.set_message_token('STEP','1');
1052: hr_utility.raise_error;

Line 1049: hr_utility.set_message_token('PROCEDURE',

1045: FETCH C INTO g_Recinfo;
1046: if (C%NOTFOUND) then
1047: CLOSE C;
1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1049: hr_utility.set_message_token('PROCEDURE',
1050: 'per_vacancies_pkb.lock_row');
1051: hr_utility.set_message_token('STEP','1');
1052: hr_utility.raise_error;
1053: end if;

Line 1051: hr_utility.set_message_token('STEP','1');

1047: CLOSE C;
1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1049: hr_utility.set_message_token('PROCEDURE',
1050: 'per_vacancies_pkb.lock_row');
1051: hr_utility.set_message_token('STEP','1');
1052: hr_utility.raise_error;
1053: end if;
1054: CLOSE C;
1055: --

Line 1052: hr_utility.raise_error;

1048: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1049: hr_utility.set_message_token('PROCEDURE',
1050: 'per_vacancies_pkb.lock_row');
1051: hr_utility.set_message_token('STEP','1');
1052: hr_utility.raise_error;
1053: end if;
1054: CLOSE C;
1055: --
1056: g_Recinfo.attribute18 := rtrim(g_Recinfo.attribute18);

Line 1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1324: attribute20 = X_Attribute20
1325: WHERE rowid = X_rowid;
1326:
1327: if (SQL%NOTFOUND) then
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE',
1330: 'per_vacancies_pkb.update_row');
1331: hr_utility.set_message_token('STEP','1');
1332: hr_utility.raise_error;

Line 1329: hr_utility.set_message_token('PROCEDURE',

1325: WHERE rowid = X_rowid;
1326:
1327: if (SQL%NOTFOUND) then
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE',
1330: 'per_vacancies_pkb.update_row');
1331: hr_utility.set_message_token('STEP','1');
1332: hr_utility.raise_error;
1333: end if;

Line 1331: hr_utility.set_message_token('STEP','1');

1327: if (SQL%NOTFOUND) then
1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE',
1330: 'per_vacancies_pkb.update_row');
1331: hr_utility.set_message_token('STEP','1');
1332: hr_utility.raise_error;
1333: end if;
1334:
1335:

Line 1332: hr_utility.raise_error;

1328: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1329: hr_utility.set_message_token('PROCEDURE',
1330: 'per_vacancies_pkb.update_row');
1331: hr_utility.set_message_token('STEP','1');
1332: hr_utility.raise_error;
1333: end if;
1334:
1335:
1336: -- Cascade changes to applicants

Line 1448: hr_utility.set_location('Entering: end_date_irec_RA',10);

1444: --
1445:
1446: begin
1447:
1448: hr_utility.set_location('Entering: end_date_irec_RA',10);
1449:
1450: hr_utility.set_location(' P_vacancy_id:'||P_vacancy_id,11);
1451: hr_utility.set_location(' P_vac_date_from:'||P_vac_date_from,12);
1452: hr_utility.set_location(' P_vac_date_to:'||P_vac_date_to,13);

Line 1450: hr_utility.set_location(' P_vacancy_id:'||P_vacancy_id,11);

1446: begin
1447:
1448: hr_utility.set_location('Entering: end_date_irec_RA',10);
1449:
1450: hr_utility.set_location(' P_vacancy_id:'||P_vacancy_id,11);
1451: hr_utility.set_location(' P_vac_date_from:'||P_vac_date_from,12);
1452: hr_utility.set_location(' P_vac_date_to:'||P_vac_date_to,13);
1453:
1454: FOR Irec_site_RA IN c_get_irec_site_RA

Line 1451: hr_utility.set_location(' P_vac_date_from:'||P_vac_date_from,12);

1447:
1448: hr_utility.set_location('Entering: end_date_irec_RA',10);
1449:
1450: hr_utility.set_location(' P_vacancy_id:'||P_vacancy_id,11);
1451: hr_utility.set_location(' P_vac_date_from:'||P_vac_date_from,12);
1452: hr_utility.set_location(' P_vac_date_to:'||P_vac_date_to,13);
1453:
1454: FOR Irec_site_RA IN c_get_irec_site_RA
1455: LOOP

Line 1452: hr_utility.set_location(' P_vac_date_to:'||P_vac_date_to,13);

1448: hr_utility.set_location('Entering: end_date_irec_RA',10);
1449:
1450: hr_utility.set_location(' P_vacancy_id:'||P_vacancy_id,11);
1451: hr_utility.set_location(' P_vac_date_from:'||P_vac_date_from,12);
1452: hr_utility.set_location(' P_vac_date_to:'||P_vac_date_to,13);
1453:
1454: FOR Irec_site_RA IN c_get_irec_site_RA
1455: LOOP
1456: --

Line 1457: hr_utility.set_location(' i-recruitment_activity_id:'||Irec_site_RA.recruitment_activity_id,15);

1453:
1454: FOR Irec_site_RA IN c_get_irec_site_RA
1455: LOOP
1456: --
1457: hr_utility.set_location(' i-recruitment_activity_id:'||Irec_site_RA.recruitment_activity_id,15);
1458:
1459: l_object_version_number := Irec_site_RA.object_version_number;
1460:
1461: per_recruitment_activity_swi.update_recruitment_activity

Line 1468: hr_utility.set_location(' l_return_status:'||l_return_status,16);

1464: ,p_object_version_number => l_object_version_number
1465: ,p_return_status => l_return_status
1466: );
1467:
1468: hr_utility.set_location(' l_return_status:'||l_return_status,16);
1469: --
1470: END loop;
1471:
1472: hr_utility.set_location('Leaving: end_date_irec_RA',100);

Line 1472: hr_utility.set_location('Leaving: end_date_irec_RA',100);

1468: hr_utility.set_location(' l_return_status:'||l_return_status,16);
1469: --
1470: END loop;
1471:
1472: hr_utility.set_location('Leaving: end_date_irec_RA',100);
1473:
1474: END end_date_irec_RA;
1475: --
1476:

Line 1511: hr_utility.set_location('Entering: end_date_per_RA',10);

1507: --
1508:
1509: BEGIN
1510:
1511: hr_utility.set_location('Entering: end_date_per_RA',10);
1512:
1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);
1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);
1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);

Line 1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);

1509: BEGIN
1510:
1511: hr_utility.set_location('Entering: end_date_per_RA',10);
1512:
1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);
1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);
1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);
1516: hr_utility.set_location(' P_vac_date_to: '||P_vac_date_to,14);
1517:

Line 1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);

1510:
1511: hr_utility.set_location('Entering: end_date_per_RA',10);
1512:
1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);
1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);
1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);
1516: hr_utility.set_location(' P_vac_date_to: '||P_vac_date_to,14);
1517:
1518: OPEN c_per_vac_RA;

Line 1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);

1511: hr_utility.set_location('Entering: end_date_per_RA',10);
1512:
1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);
1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);
1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);
1516: hr_utility.set_location(' P_vac_date_to: '||P_vac_date_to,14);
1517:
1518: OPEN c_per_vac_RA;
1519: FETCH c_per_vac_RA INTO l_recruitment_activity_id, l_object_version_number;

Line 1516: hr_utility.set_location(' P_vac_date_to: '||P_vac_date_to,14);

1512:
1513: hr_utility.set_location(' P_vacancy_id: '||P_vacancy_id,11);
1514: hr_utility.set_location(' P_recruitment_activity_id: '||P_recruitment_activity_id,12);
1515: hr_utility.set_location(' P_vac_date_from: '||P_vac_date_from,13);
1516: hr_utility.set_location(' P_vac_date_to: '||P_vac_date_to,14);
1517:
1518: OPEN c_per_vac_RA;
1519: FETCH c_per_vac_RA INTO l_recruitment_activity_id, l_object_version_number;
1520:

Line 1529: hr_utility.set_location(' l_return_status: '||l_return_status,15);

1525: ,p_date_end => P_vac_date_to
1526: ,p_object_version_number => l_object_version_number
1527: ,p_return_status => l_return_status
1528: );
1529: hr_utility.set_location(' l_return_status: '||l_return_status,15);
1530: ELSE
1531: CLOSE c_per_vac_RA;
1532: END if;
1533:

Line 1535: hr_utility.set_location('Leaving: end_date_per_RA',100);

1531: CLOSE c_per_vac_RA;
1532: END if;
1533:
1534: --
1535: hr_utility.set_location('Leaving: end_date_per_RA',100);
1536:
1537: END end_date_per_RA;
1538: --end changes for bug 6497289
1539: -- Begin - Changes for ER#8530112

Line 1608: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 550);

1604: OPEN c_bus_grp_id(p_position_id);
1605: FETCH c_bus_grp_id into l_business_group_id;
1606: CLOSE c_bus_grp_id;
1607:
1608: hr_utility.set_location('l_business_group_id:' || l_business_group_id, 550);
1609:
1610:
1611: FOR l_budget_details_rec in c_budget_id(l_business_group_id)
1612: LOOP

Line 1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);

1616: l_budget_unit3_id := l_budget_details_rec.budget_unit3_id;
1617: l_calendar := l_budget_details_rec.period_set_name;
1618: END LOOP;
1619:
1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);
1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

Line 1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);

1617: l_calendar := l_budget_details_rec.period_set_name;
1618: END LOOP;
1619:
1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);
1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
1625: OPEN c1(l_budget_unit1_id);

Line 1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);

1618: END LOOP;
1619:
1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);
1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
1625: OPEN c1(l_budget_unit1_id);
1626: FETCH c1 into l_unit1_name;

Line 1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);

1619:
1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);
1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
1625: OPEN c1(l_budget_unit1_id);
1626: FETCH c1 into l_unit1_name;
1627: CLOSE c1;

Line 1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);

1620: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
1621: hr_utility.set_location('l_calendar:' || l_calendar, 600);
1622: hr_utility.set_location('l_budget_unit1_id:' || l_budget_unit1_id, 600);
1623: hr_utility.set_location('l_budget_unit2_id:' || l_budget_unit2_id, 600);
1624: hr_utility.set_location('l_budget_unit3_id:' || l_budget_unit3_id, 600);
1625: OPEN c1(l_budget_unit1_id);
1626: FETCH c1 into l_unit1_name;
1627: CLOSE c1;
1628: OPEN c1(l_budget_unit2_id);

Line 1634: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);

1630: CLOSE c1;
1631: OPEN c1(l_budget_unit3_id);
1632: FETCH c1 into l_unit3_name;
1633: CLOSE c1;
1634: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
1635: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
1636: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
1637: EXCEPTION
1638: WHEN others THEN

Line 1635: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);

1631: OPEN c1(l_budget_unit3_id);
1632: FETCH c1 into l_unit3_name;
1633: CLOSE c1;
1634: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
1635: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
1636: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
1637: EXCEPTION
1638: WHEN others THEN
1639: hr_utility.set_location('Error: ' || SQLERRM, 602);

Line 1636: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);

1632: FETCH c1 into l_unit3_name;
1633: CLOSE c1;
1634: hr_utility.set_location('l_unit1_name:' || l_unit1_name, 601);
1635: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
1636: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
1637: EXCEPTION
1638: WHEN others THEN
1639: hr_utility.set_location('Error: ' || SQLERRM, 602);
1640: RETURN l_budgeted_hc;

Line 1639: hr_utility.set_location('Error: ' || SQLERRM, 602);

1635: hr_utility.set_location('l_unit2_name:' || l_unit2_name, 601);
1636: hr_utility.set_location('l_unit3_name:' || l_unit3_name, 601);
1637: EXCEPTION
1638: WHEN others THEN
1639: hr_utility.set_location('Error: ' || SQLERRM, 602);
1640: RETURN l_budgeted_hc;
1641: END;
1642: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
1643: for i in c2(l_budget_id) loop

Line 1642: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);

1638: WHEN others THEN
1639: hr_utility.set_location('Error: ' || SQLERRM, 602);
1640: RETURN l_budgeted_hc;
1641: END;
1642: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
1643: for i in c2(l_budget_id) loop
1644: -- row corresponding to the position is picked up
1645: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
1646: --

Line 1645: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);

1641: END;
1642: hr_utility.set_location('l_budget_id:' || l_budget_id, 602);
1643: for i in c2(l_budget_id) loop
1644: -- row corresponding to the position is picked up
1645: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
1646: --
1647: for j in c3(i.budget_detail_id) loop
1648: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
1649: if l_unit1_name ='HEAD' then

Line 1648: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);

1644: -- row corresponding to the position is picked up
1645: hr_utility.set_location('budget_detail_id:' || i.budget_detail_id, 603);
1646: --
1647: for j in c3(i.budget_detail_id) loop
1648: hr_utility.set_location('budget_unit1_value:' || j.budget_unit1_value, 604);
1649: if l_unit1_name ='HEAD' then
1650: l_budgeted_hc := nvl(l_budgeted_hc,0) + nvl(j.budget_unit1_value,0);
1651: elsif l_unit2_name ='HEAD' then
1652: l_budgeted_hc := nvl(l_budgeted_hc,0) + nvl(j.budget_unit2_value,0);

Line 1658: hr_utility.set_location('l_budgeted_hc:' || l_budgeted_hc, 605);

1654: l_budgeted_hc := nvl(l_budgeted_hc,0) + nvl(j.budget_unit3_value,0);
1655: end if;
1656: end loop;
1657: end loop;
1658: hr_utility.set_location('l_budgeted_hc:' || l_budgeted_hc, 605);
1659: return l_budgeted_hc;
1660: end;
1661:
1662: function GET_ASGND_HC_BUDGET_VAL(p_position_id in number default null,

Line 1686: hr_utility.set_location ('l_assignment_hc GET_ASGND_HC_BUDGET_VAL '||l_assignment_hc,1);

1682: close c_budgeted_hc;
1683: else
1684: l_assignment_hc := 0;
1685: end if;
1686: hr_utility.set_location ('l_assignment_hc GET_ASGND_HC_BUDGET_VAL '||l_assignment_hc,1);
1687: return(nvl(l_assignment_hc,0));
1688: end;
1689:
1690: function GET_NUM_OF_VAC(p_position_id in number,

Line 1724: hr_utility.set_location ('coming CHK_POS_BUDGET_VAL',1);

1720: l_pos_asg_hc number;
1721: l_pos_vac_opn number;
1722: Begin
1723:
1724: hr_utility.set_location ('coming CHK_POS_BUDGET_VAL',1);
1725:
1726: hr_utility.set_location ('p_position_id CHK_POS_BUDGET_VAL'||p_position_id,1);
1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);
1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);

Line 1726: hr_utility.set_location ('p_position_id CHK_POS_BUDGET_VAL'||p_position_id,1);

1722: Begin
1723:
1724: hr_utility.set_location ('coming CHK_POS_BUDGET_VAL',1);
1725:
1726: hr_utility.set_location ('p_position_id CHK_POS_BUDGET_VAL'||p_position_id,1);
1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);
1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);
1729:
1730: l_pos_bud_hc := GET_POS_HC_BUDGET_VAL(p_position_id,p_effective_date);

Line 1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);

1723:
1724: hr_utility.set_location ('coming CHK_POS_BUDGET_VAL',1);
1725:
1726: hr_utility.set_location ('p_position_id CHK_POS_BUDGET_VAL'||p_position_id,1);
1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);
1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);
1729:
1730: l_pos_bud_hc := GET_POS_HC_BUDGET_VAL(p_position_id,p_effective_date);
1731: hr_utility.set_location ('l_pos_bud_hc CHK_POS_BUDGET_VAL'||l_pos_bud_hc,1);

Line 1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);

1724: hr_utility.set_location ('coming CHK_POS_BUDGET_VAL',1);
1725:
1726: hr_utility.set_location ('p_position_id CHK_POS_BUDGET_VAL'||p_position_id,1);
1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);
1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);
1729:
1730: l_pos_bud_hc := GET_POS_HC_BUDGET_VAL(p_position_id,p_effective_date);
1731: hr_utility.set_location ('l_pos_bud_hc CHK_POS_BUDGET_VAL'||l_pos_bud_hc,1);
1732:

Line 1731: hr_utility.set_location ('l_pos_bud_hc CHK_POS_BUDGET_VAL'||l_pos_bud_hc,1);

1727: hr_utility.set_location ('p_vacancy_id CHK_POS_BUDGET_VAL'||p_vacancy_id,1);
1728: hr_utility.set_location ('p_effective_date CHK_POS_BUDGET_VAL'||p_effective_date,1);
1729:
1730: l_pos_bud_hc := GET_POS_HC_BUDGET_VAL(p_position_id,p_effective_date);
1731: hr_utility.set_location ('l_pos_bud_hc CHK_POS_BUDGET_VAL'||l_pos_bud_hc,1);
1732:
1733: l_pos_asg_hc := GET_ASGND_HC_BUDGET_VAL(p_position_id,p_effective_date);
1734: hr_utility.set_location ('l_pos_asg_hc CHK_POS_BUDGET_VAL'||l_pos_asg_hc,1);
1735:

Line 1734: hr_utility.set_location ('l_pos_asg_hc CHK_POS_BUDGET_VAL'||l_pos_asg_hc,1);

1730: l_pos_bud_hc := GET_POS_HC_BUDGET_VAL(p_position_id,p_effective_date);
1731: hr_utility.set_location ('l_pos_bud_hc CHK_POS_BUDGET_VAL'||l_pos_bud_hc,1);
1732:
1733: l_pos_asg_hc := GET_ASGND_HC_BUDGET_VAL(p_position_id,p_effective_date);
1734: hr_utility.set_location ('l_pos_asg_hc CHK_POS_BUDGET_VAL'||l_pos_asg_hc,1);
1735:
1736: l_pos_vac_opn := GET_NUM_OF_VAC(p_position_id,p_effective_date,p_vacancy_id);
1737: hr_utility.set_location ('l_pos_vac_opn CHK_POS_BUDGET_VAL'||l_pos_vac_opn,1);
1738:

Line 1737: hr_utility.set_location ('l_pos_vac_opn CHK_POS_BUDGET_VAL'||l_pos_vac_opn,1);

1733: l_pos_asg_hc := GET_ASGND_HC_BUDGET_VAL(p_position_id,p_effective_date);
1734: hr_utility.set_location ('l_pos_asg_hc CHK_POS_BUDGET_VAL'||l_pos_asg_hc,1);
1735:
1736: l_pos_vac_opn := GET_NUM_OF_VAC(p_position_id,p_effective_date,p_vacancy_id);
1737: hr_utility.set_location ('l_pos_vac_opn CHK_POS_BUDGET_VAL'||l_pos_vac_opn,1);
1738:
1739: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);
1740:
1741: If ((l_pos_asg_hc + l_pos_vac_opn + p_number_of_openings) > L_pos_bud_hc) then

Line 1739: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);

1735:
1736: l_pos_vac_opn := GET_NUM_OF_VAC(p_position_id,p_effective_date,p_vacancy_id);
1737: hr_utility.set_location ('l_pos_vac_opn CHK_POS_BUDGET_VAL'||l_pos_vac_opn,1);
1738:
1739: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);
1740:
1741: If ((l_pos_asg_hc + l_pos_vac_opn + p_number_of_openings) > L_pos_bud_hc) then
1742: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);
1743: pqh_utility.set_message(8302,'PQH_SUM_POS_BGT_HC', p_org_id);

Line 1742: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);

1738:
1739: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);
1740:
1741: If ((l_pos_asg_hc + l_pos_vac_opn + p_number_of_openings) > L_pos_bud_hc) then
1742: hr_utility.set_location ('p_number_of_openings CHK_POS_BUDGET_VAL'||p_number_of_openings,1);
1743: pqh_utility.set_message(8302,'PQH_SUM_POS_BGT_HC', p_org_id);
1744: pqh_utility.raise_error;
1745: End If;
1746: