DBA Data[Home] [Help]

APPS.HR_REVTERMINATION_SS dependencies on HR_UTILITY

Line 163: hr_utility.set_location('Entering: '|| l_proc,5);

159: AND pps.SYSTEM_PERSON_TYPE = 'EX_EMP';
160:
161: l_proc constant varchar2(100) := g_package || ' ex_emp_process_save';
162: BEGIN
163: hr_utility.set_location('Entering: '|| l_proc,5);
164:
165: l_actual_termination_date := to_date(p_actual_termination_date,g_date_format);
166:
167: SAVEPOINT revterminate_ee;

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

659: p_api_name => 'hr_revtermination_ss.ex_emp_process_save',
660: p_transaction_data => hr_revtermination_ss.gtt_transaction_steps
661: );
662: --end of transaction logic
663: hr_utility.set_location('Leaving: '|| l_proc,20);
664: EXCEPTION
665: WHEN OTHERS THEN
666: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
667: hr_utility.set_location('EXCEPTION: '|| SQLERRM,555);

Line 666: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

662: --end of transaction logic
663: hr_utility.set_location('Leaving: '|| l_proc,20);
664: EXCEPTION
665: WHEN OTHERS THEN
666: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
667: hr_utility.set_location('EXCEPTION: '|| SQLERRM,555);
668: p_error_message := hr_utility.get_message;
669: -- rollback the changes in case of exception
670: rollback to revterminate_ee;

Line 667: hr_utility.set_location('EXCEPTION: '|| SQLERRM,555);

663: hr_utility.set_location('Leaving: '|| l_proc,20);
664: EXCEPTION
665: WHEN OTHERS THEN
666: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
667: hr_utility.set_location('EXCEPTION: '|| SQLERRM,555);
668: p_error_message := hr_utility.get_message;
669: -- rollback the changes in case of exception
670: rollback to revterminate_ee;
671:

Line 668: p_error_message := hr_utility.get_message;

664: EXCEPTION
665: WHEN OTHERS THEN
666: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
667: hr_utility.set_location('EXCEPTION: '|| SQLERRM,555);
668: p_error_message := hr_utility.get_message;
669: -- rollback the changes in case of exception
670: rollback to revterminate_ee;
671:
672:

Line 801: hr_utility.set_location('Entering: '|| l_proc,5);

797: l_proc constant varchar2(100) := g_package || ' ex_cwk_process_save';
798:
799:
800: BEGIN
801: hr_utility.set_location('Entering: '|| l_proc,5);
802: p_fut_actns_exist_warning := 0;
803: l_actual_termination_date := to_date(p_actual_termination_date,g_date_format);
804:
805: SAVEPOINT revterminate_ee;

Line 1343: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1339: );
1340:
1341: EXCEPTION
1342: when others then
1343: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1344: p_error_message := hr_utility.get_message;
1345: -- rollback the changes in case of exception
1346: rollback to revterminate_ee;
1347:

Line 1344: p_error_message := hr_utility.get_message;

1340:
1341: EXCEPTION
1342: when others then
1343: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1344: p_error_message := hr_utility.get_message;
1345: -- rollback the changes in case of exception
1346: rollback to revterminate_ee;
1347:
1348: END ex_cwk_process_save;

Line 1381: hr_utility.set_location('Entering: ' || l_proc,5 );

1377: l_err_msg long default null;
1378:
1379: BEGIN
1380:
1381: hr_utility.set_location('Entering: ' || l_proc,5 );
1382:
1383: lv_person_id :=
1384: hr_transaction_api.get_number_value
1385: (p_transaction_step_id => p_transaction_step_id

Line 1448: hr_utility.set_location(' Leaving: ' || l_proc,15);

1444:
1445:
1446: end if;
1447:
1448: hr_utility.set_location(' Leaving: ' || l_proc,15);
1449:
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: l_err_msg := hr_utility.get_message;

Line 1452: l_err_msg := hr_utility.get_message;

1448: hr_utility.set_location(' Leaving: ' || l_proc,15);
1449:
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: l_err_msg := hr_utility.get_message;
1453: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
1454: rollback to ex_emp_savepoint;
1455: RAISE;
1456: END process_api;

Line 1453: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);

1449:
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: l_err_msg := hr_utility.get_message;
1453: hr_utility.set_location('EXCEPTION '|| l_err_msg || ': ' || l_proc,5600);
1454: rollback to ex_emp_savepoint;
1455: RAISE;
1456: END process_api;
1457:

Line 1471: g_debug := hr_utility.debug_enabled;

1467: lv_person_id per_all_people_f.person_id%type;
1468: l_person_type VARCHAR2(100) default 'EX_EMP';
1469:
1470: begin
1471: g_debug := hr_utility.debug_enabled;
1472:
1473: if g_debug then
1474: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1475: end if;

Line 1474: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

1470: begin
1471: g_debug := hr_utility.debug_enabled;
1472:
1473: if g_debug then
1474: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1475: end if;
1476: if ( funmode = wf_engine.eng_run ) then
1477: begin
1478: lv_person_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);

Line 1491: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

1487:
1488: result := l_person_type;
1489:
1490: if (g_debug ) then
1491: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1492: end if;
1493: exception
1494: when others then
1495: raise;

Line 1579: hr_utility.set_location('Entering:' || l_proc, 5);

1575: l_proc varchar2(72) := g_package ||'getCwkTransactionDetails';
1576:
1577: BEGIN
1578:
1579: hr_utility.set_location('Entering:' || l_proc, 5);
1580: --
1581: p_person_id :=
1582: hr_transaction_api.get_number_value
1583: (p_transaction_step_id => p_transaction_step_id

Line 1952: hr_utility.set_location('SSHR: Leaving:' || l_proc, 10);

1948: hr_transaction_api.get_varchar2_value
1949: (p_transaction_step_id => p_transaction_step_id
1950: ,p_name => 'P_CLEAR_DETAILS');
1951:
1952: hr_utility.set_location('SSHR: Leaving:' || l_proc, 10);
1953:
1954: END getCwkTransactionDetails;
1955:
1956: PROCEDURE getEmpTransactionDetails

Line 2028: hr_utility.set_location('Entering:' || l_proc, 5);

2024:
2025: l_proc varchar2(72) := g_package ||'getEmpTransactionDetails';
2026:
2027: BEGIN
2028: hr_utility.set_location('Entering:' || l_proc, 5);
2029:
2030: --
2031: p_person_id :=
2032: hr_transaction_api.get_number_value

Line 2370: hr_utility.set_location('Leaving:' || l_proc, 10);

2366: hr_transaction_api.get_varchar2_value
2367: (p_transaction_step_id => p_transaction_step_id
2368: ,p_name => 'P_CLEAR_DETAILS');
2369:
2370: hr_utility.set_location('Leaving:' || l_proc, 10);
2371:
2372: END getEmpTransactionDetails;
2373:
2374: END hr_revtermination_ss;