DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_SWI dependencies on HR_UTILITY

Line 164: hr_utility.set_location(' Entering:' || l_proc,10);

160: --
161: -- Other variables
162: l_proc varchar2(72) := g_package ||'create_employee';
163: Begin
164: hr_utility.set_location(' Entering:' || l_proc,10);
165: --
166: -- Issue a savepoint
167: --
168: savepoint create_employee_swi;

Line 361: hr_utility.set_location(' Leaving:' || l_proc,20);

357: -- messages of any type exist in the Multiple Message List.
358: -- Also disable Multiple Message Detection.
359: --
360: p_return_status := hr_multi_message.get_return_status_disable;
361: hr_utility.set_location(' Leaving:' || l_proc,20);
362: --
363: exception
364: when hr_multi_message.error_message_exist then
365: --

Line 386: hr_utility.set_location(' Leaving:' || l_proc, 30);

382: p_per_comment_id := null;
383: p_assignment_sequence := null;
384: p_assignment_number := null;
385: p_return_status := hr_multi_message.get_return_status_disable;
386: hr_utility.set_location(' Leaving:' || l_proc, 30);
387: when others then
388: --
389: -- When Multiple Message Detection is enabled catch
390: -- any Application specific or other unexpected

Line 397: hr_utility.set_location(' Leaving:' || l_proc,40);

393: -- error.
394: --
395: rollback to create_employee_swi;
396: if hr_multi_message.unexpected_error_add(l_proc) then
397: hr_utility.set_location(' Leaving:' || l_proc,40);
398: raise;
399: end if;
400: --
401: -- Reset IN OUT and set OUT parameters

Line 415: hr_utility.set_location(' Leaving:' || l_proc,50);

411: p_per_comment_id := null;
412: p_assignment_sequence := null;
413: p_assignment_number := null;
414: p_return_status := hr_multi_message.get_return_status_disable;
415: hr_utility.set_location(' Leaving:' || l_proc,50);
416: end create_employee;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |----------------------------< create_employee >---------------------------|

Line 633: hr_utility.set_location(' Entering:' || l_proc,10);

629: -- Other variables
630: l_proc varchar2(72) := g_package ||'create_employee';
631: --
632: Begin
633: hr_utility.set_location(' Entering:' || l_proc,10);
634: --
635: -- Issue a savepoint
636: --
637: savepoint create_employee_swi;

Line 890: hr_utility.set_location(' Leaving:' || l_proc,20);

886: ,p_return_status => l_addr_return_status
887: );
888:
889: p_return_status := hr_multi_message.get_return_status_disable;
890: hr_utility.set_location(' Leaving:' || l_proc,20);
891: --
892: exception
893: when hr_multi_message.error_message_exist then
894: --

Line 915: hr_utility.set_location(' Leaving:' || l_proc, 30);

911: p_per_comment_id := null;
912: p_assignment_sequence := null;
913: p_assignment_number := null;
914: p_return_status := hr_multi_message.get_return_status_disable;
915: hr_utility.set_location(' Leaving:' || l_proc, 30);
916: when others then
917: --
918: -- When Multiple Message Detection is enabled catch
919: -- any Application specific or other unexpected

Line 926: hr_utility.set_location(' Leaving:' || l_proc,40);

922: -- error.
923: --
924: rollback to create_employee_swi;
925: if hr_multi_message.unexpected_error_add(l_proc) then
926: hr_utility.set_location(' Leaving:' || l_proc,40);
927: raise;
928: end if;
929: --
930: -- Reset IN OUT and set OUT parameters

Line 944: hr_utility.set_location(' Leaving:' || l_proc,50);

940: p_per_comment_id := null;
941: p_assignment_sequence := null;
942: p_assignment_number := null;
943: p_return_status := hr_multi_message.get_return_status_disable;
944: hr_utility.set_location(' Leaving:' || l_proc,50);
945: end create_employee;
946: -- ----------------------------------------------------------------------------
947: -- |----------------------< apply_for_internal_vacancy >----------------------|
948: -- ----------------------------------------------------------------------------

Line 977: hr_utility.set_location(' Entering:' || l_proc,10);

973: --
974: -- Other variables
975: l_proc varchar2(72) := g_package ||'apply_for_internal_vacancy';
976: Begin
977: hr_utility.set_location(' Entering:' || l_proc,10);
978: --
979: -- Issue a savepoint
980: --
981: savepoint apply_for_internal_vacancy_swi;

Line 1032: hr_utility.set_location(' Leaving:' || l_proc,20);

1028: -- messages of any type exist in the Multiple Message List.
1029: -- Also disable Multiple Message Detection.
1030: --
1031: p_return_status := hr_multi_message.get_return_status_disable;
1032: hr_utility.set_location(' Leaving:' || l_proc,20);
1033: --
1034: exception
1035: when hr_multi_message.error_message_exist then
1036: --

Line 1055: hr_utility.set_location(' Leaving:' || l_proc, 30);

1051: p_assignment_sequence := null;
1052: p_per_effective_start_date := null;
1053: p_per_effective_end_date := null;
1054: p_return_status := hr_multi_message.get_return_status_disable;
1055: hr_utility.set_location(' Leaving:' || l_proc, 30);
1056: when others then
1057: --
1058: -- When Multiple Message Detection is enabled catch
1059: -- any Application specific or other unexpected

Line 1066: hr_utility.set_location(' Leaving:' || l_proc,40);

1062: -- error.
1063: --
1064: rollback to apply_for_internal_vacancy_swi;
1065: if hr_multi_message.unexpected_error_add(l_proc) then
1066: hr_utility.set_location(' Leaving:' || l_proc,40);
1067: raise;
1068: end if;
1069: --
1070: -- Reset IN OUT and set OUT parameters

Line 1082: hr_utility.set_location(' Leaving:' || l_proc,50);

1078: p_assignment_sequence := null;
1079: p_per_effective_start_date := null;
1080: p_per_effective_end_date := null;
1081: p_return_status := hr_multi_message.get_return_status_disable;
1082: hr_utility.set_location(' Leaving:' || l_proc,50);
1083: end apply_for_internal_vacancy;
1084: -- ----------------------------------------------------------------------------
1085: -- |-----------------------------< hire_into_job >----------------------------|
1086: -- ----------------------------------------------------------------------------

Line 1113: hr_utility.set_location(' Entering:' || l_proc,10);

1109: --
1110: -- Other variables
1111: l_proc varchar2(72) := g_package ||'hire_into_job';
1112: Begin
1113: hr_utility.set_location(' Entering:' || l_proc,10);
1114: --
1115: -- Issue a savepoint
1116: --
1117: savepoint hire_into_job_swi;

Line 1177: hr_utility.set_location(' Leaving:' || l_proc,20);

1173: -- messages of any type exist in the Multiple Message List.
1174: -- Also disable Multiple Message Detection.
1175: --
1176: p_return_status := hr_multi_message.get_return_status_disable;
1177: hr_utility.set_location(' Leaving:' || l_proc,20);
1178: --
1179: exception
1180: when hr_multi_message.error_message_exist then
1181: --

Line 1195: hr_utility.set_location(' Leaving:' || l_proc, 30);

1191: p_employee_number := l_employee_number;
1192: p_effective_start_date := null;
1193: p_effective_end_date := null;
1194: p_return_status := hr_multi_message.get_return_status_disable;
1195: hr_utility.set_location(' Leaving:' || l_proc, 30);
1196: when others then
1197: --
1198: -- When Multiple Message Detection is enabled catch
1199: -- any Application specific or other unexpected

Line 1206: hr_utility.set_location(' Leaving:' || l_proc,40);

1202: -- error.
1203: --
1204: rollback to hire_into_job_swi;
1205: if hr_multi_message.unexpected_error_add(l_proc) then
1206: hr_utility.set_location(' Leaving:' || l_proc,40);
1207: raise;
1208: end if;
1209: --
1210: -- Reset IN OUT and set OUT parameters

Line 1217: hr_utility.set_location(' Leaving:' || l_proc,50);

1213: p_employee_number := l_employee_number;
1214: p_effective_start_date := null;
1215: p_effective_end_date := null;
1216: p_return_status := hr_multi_message.get_return_status_disable;
1217: hr_utility.set_location(' Leaving:' || l_proc,50);
1218: end hire_into_job;
1219: -- ----------------------------------------------------------------------------
1220: -- |--------------------------< re_hire_ex_employee >-------------------------|
1221: -- ----------------------------------------------------------------------------

Line 1248: hr_utility.set_location(' Entering:' || l_proc,10);

1244: --
1245: -- Other variables
1246: l_proc varchar2(72) := g_package ||'re_hire_ex_employee';
1247: Begin
1248: hr_utility.set_location(' Entering:' || l_proc,10);
1249: --
1250: -- Issue a savepoint
1251: --
1252: savepoint re_hire_ex_employee_swi;

Line 1306: hr_utility.set_location(' Leaving:' || l_proc,20);

1302: -- messages of any type exist in the Multiple Message List.
1303: -- Also disable Multiple Message Detection.
1304: --
1305: p_return_status := hr_multi_message.get_return_status_disable;
1306: hr_utility.set_location(' Leaving:' || l_proc,20);
1307: --
1308: exception
1309: when hr_multi_message.error_message_exist then
1310: --

Line 1327: hr_utility.set_location(' Leaving:' || l_proc, 30);

1323: p_per_effective_end_date := null;
1324: p_assignment_sequence := null;
1325: p_assignment_number := null;
1326: p_return_status := hr_multi_message.get_return_status_disable;
1327: hr_utility.set_location(' Leaving:' || l_proc, 30);
1328: when others then
1329: --
1330: -- When Multiple Message Detection is enabled catch
1331: -- any Application specific or other unexpected

Line 1338: hr_utility.set_location(' Leaving:' || l_proc,40);

1334: -- error.
1335: --
1336: rollback to re_hire_ex_employee_swi;
1337: if hr_multi_message.unexpected_error_add(l_proc) then
1338: hr_utility.set_location(' Leaving:' || l_proc,40);
1339: raise;
1340: end if;
1341: --
1342: -- Reset IN OUT and set OUT parameters

Line 1352: hr_utility.set_location(' Leaving:' || l_proc,50);

1348: p_per_effective_end_date := null;
1349: p_assignment_sequence := null;
1350: p_assignment_number := null;
1351: p_return_status := hr_multi_message.get_return_status_disable;
1352: hr_utility.set_location(' Leaving:' || l_proc,50);
1353: end re_hire_ex_employee;
1354: -- ----------------------------------------------------------------------------
1355: -- |-------------------< convert_to_manual_gen_method >-----------------------|
1356: -- ----------------------------------------------------------------------------

Line 1397: --hr_utility.trace_on(null,'oracle');

1393: FOR UPDATE of Org_information3 -- method_of_generation_apl_num
1394: , Org_information2 -- method_of_generation_emp_num
1395: , Org_information16 NOWAIT; -- method_of_generation_cwk_num
1396: BEGIN
1397: --hr_utility.trace_on(null,'oracle');
1398:
1399: hr_utility.set_location('Entering: '||c_proc_name,10);
1400: hr_utility.trace('Parameters:');
1401: hr_utility.trace(' business_group_id = '||to_char(p_business_group_id));

Line 1399: hr_utility.set_location('Entering: '||c_proc_name,10);

1395: , Org_information16 NOWAIT; -- method_of_generation_cwk_num
1396: BEGIN
1397: --hr_utility.trace_on(null,'oracle');
1398:
1399: hr_utility.set_location('Entering: '||c_proc_name,10);
1400: hr_utility.trace('Parameters:');
1401: hr_utility.trace(' business_group_id = '||to_char(p_business_group_id));
1402: --
1403: BEGIN

Line 1400: hr_utility.trace('Parameters:');

1396: BEGIN
1397: --hr_utility.trace_on(null,'oracle');
1398:
1399: hr_utility.set_location('Entering: '||c_proc_name,10);
1400: hr_utility.trace('Parameters:');
1401: hr_utility.trace(' business_group_id = '||to_char(p_business_group_id));
1402: --
1403: BEGIN
1404: l_organization_id := p_business_group_id;

Line 1401: hr_utility.trace(' business_group_id = '||to_char(p_business_group_id));

1397: --hr_utility.trace_on(null,'oracle');
1398:
1399: hr_utility.set_location('Entering: '||c_proc_name,10);
1400: hr_utility.trace('Parameters:');
1401: hr_utility.trace(' business_group_id = '||to_char(p_business_group_id));
1402: --
1403: BEGIN
1404: l_organization_id := p_business_group_id;
1405:

Line 1409: hr_utility.set_location(c_proc_name,20);

1405:
1406: -- Lock per_all_people_f to ensure person records are not
1407: -- created/updated/deleted
1408: --
1409: hr_utility.set_location(c_proc_name,20);
1410:
1411: --LOCK TABLE per_all_people_f
1412: -- IN EXCLUSIVE MODE NOWAIT;
1413: --

Line 1419: hr_utility.set_location(c_proc_name,30);

1415: fetch csr_method into l_rec_per_bg_groups;
1416:
1417: if csr_method%FOUND then
1418:
1419: hr_utility.set_location(c_proc_name,30);
1420: -- -------------------------------------------------------------+
1421: -- Processing Applicants, Employee, Contigent Workers +
1422: -- -------------------------------------------------------------+
1423:

Line 1424: hr_utility.set_location(c_proc_name,40);

1420: -- -------------------------------------------------------------+
1421: -- Processing Applicants, Employee, Contigent Workers +
1422: -- -------------------------------------------------------------+
1423:
1424: hr_utility.set_location(c_proc_name,40);
1425:
1426: UPDATE HR_ORGANIZATION_INFORMATION
1427: SET org_information2 = 'M' -- method_of_generation_emp_num
1428: /*,org_information3 = 'M' -- method_of_generation_apl_num

Line 1434: hr_utility.set_location(c_proc_name,40);

1430: */
1431: WHERE organization_id = l_organization_id
1432: AND ORG_INFORMATION_CONTEXT = 'Business Group Information';
1433:
1434: hr_utility.set_location(c_proc_name,40);
1435:
1436: end if; -- csr_method cursor
1437: --
1438: hr_utility.set_location(c_proc_name,50);

Line 1438: hr_utility.set_location(c_proc_name,50);

1434: hr_utility.set_location(c_proc_name,40);
1435:
1436: end if; -- csr_method cursor
1437: --
1438: hr_utility.set_location(c_proc_name,50);
1439: --
1440: close csr_method;
1441: EXCEPTION
1442: WHEN TIMEOUT_ON_RESOURCE OR e_ResourceBusy THEN

Line 1443: hr_utility.set_location(c_proc_name,60);

1439: --
1440: close csr_method;
1441: EXCEPTION
1442: WHEN TIMEOUT_ON_RESOURCE OR e_ResourceBusy THEN
1443: hr_utility.set_location(c_proc_name,60);
1444: -- The required resources are used by some other process.
1445:
1446: hr_utility.set_message(800,'PER_289849_RESOURCE_BUSY');
1447: hr_utility.raise_error;

Line 1446: hr_utility.set_message(800,'PER_289849_RESOURCE_BUSY');

1442: WHEN TIMEOUT_ON_RESOURCE OR e_ResourceBusy THEN
1443: hr_utility.set_location(c_proc_name,60);
1444: -- The required resources are used by some other process.
1445:
1446: hr_utility.set_message(800,'PER_289849_RESOURCE_BUSY');
1447: hr_utility.raise_error;
1448:
1449: WHEN OTHERS THEN
1450: hr_utility.set_location(c_proc_name,70);

Line 1447: hr_utility.raise_error;

1443: hr_utility.set_location(c_proc_name,60);
1444: -- The required resources are used by some other process.
1445:
1446: hr_utility.set_message(800,'PER_289849_RESOURCE_BUSY');
1447: hr_utility.raise_error;
1448:
1449: WHEN OTHERS THEN
1450: hr_utility.set_location(c_proc_name,70);
1451: hr_utility.trace(SQLERRM);

Line 1450: hr_utility.set_location(c_proc_name,70);

1446: hr_utility.set_message(800,'PER_289849_RESOURCE_BUSY');
1447: hr_utility.raise_error;
1448:
1449: WHEN OTHERS THEN
1450: hr_utility.set_location(c_proc_name,70);
1451: hr_utility.trace(SQLERRM);
1452:
1453: RAISE;
1454:

Line 1451: hr_utility.trace(SQLERRM);

1447: hr_utility.raise_error;
1448:
1449: WHEN OTHERS THEN
1450: hr_utility.set_location(c_proc_name,70);
1451: hr_utility.trace(SQLERRM);
1452:
1453: RAISE;
1454:
1455: END; -- Lock table

Line 1456: hr_utility.set_location('Leaving: '||c_proc_name,80);

1452:
1453: RAISE;
1454:
1455: END; -- Lock table
1456: hr_utility.set_location('Leaving: '||c_proc_name,80);
1457: --hr_utility.trace_off;
1458:
1459: END convert_to_manual_gen_method;
1460: --

Line 1457: --hr_utility.trace_off;

1453: RAISE;
1454:
1455: END; -- Lock table
1456: hr_utility.set_location('Leaving: '||c_proc_name,80);
1457: --hr_utility.trace_off;
1458:
1459: END convert_to_manual_gen_method;
1460: --
1461: end hr_employee_swi;