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

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

19: ,p_login_person_id in number) IS
20:
21: l_proc constant varchar2(100) := g_package || ' update_object_version';
22: BEGIN
23: hr_utility.set_location('Entering'|| l_proc,5);
24: -- We don't need to have specific code to update the object version
25: -- number for SAVE_FOR_LATER because in update_supervisor procedure, it
26: -- always gets the object version number at run time every time. Therefore,
27: -- no specific code is required here. We just need to have dummy stub

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

26: -- always gets the object version number at run time every time. Therefore,
27: -- no specific code is required here. We just need to have dummy stub
28: -- for SAVE_FOR_LATER to resolve the call.
29: null;
30: hr_utility.set_location('Leaving'|| l_proc,10);
31: END update_object_version;
32:
33: /*
34: ||===========================================================================

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

184:
185: BEGIN
186: --
187: -- Get the action person id, ie. selected person id
188: hr_utility.set_location('Entering '|| l_proc,5);
189: ln_person_id := wf_engine.GetItemAttrNumber
190: (itemtype => itemtype
191: ,itemkey => itemkey
192: ,aname => 'CURRENT_PERSON_ID');

Line 224: hr_utility.trace('In (if lv_term_sup_flag = Y)'|| l_proc);

220: -- We will set the result code to 'Y' only if the item attribute
221: -- HR_TERM_SUP_FLAG is set to 'Y', that means the caller is from Termination.
222: -- Otherwise, we don't need to branch to the Cost Center Manager module.
223: IF lv_term_sup_flag = 'Y' THEN
224: hr_utility.trace('In (if lv_term_sup_flag = Y)'|| l_proc);
225: resultout := 'COMPLETE:'|| 'N';
226: lv_no_access_to_some_cc := 'N';
227:
228: select primary_flag into dummy from per_all_assignments_f where

Line 285: hr_utility.trace('In (if lv_no_access_to_some_cc = Y)'|| l_proc);

281: -- is some cost centers that the login person cannot access and the
282: -- person terminated is a cost center manager.
283:
284: IF lv_no_access_to_some_cc = 'Y' THEN
285: hr_utility.trace('In (if lv_no_access_to_some_cc = Y)'|| l_proc);
286: OPEN csr_get_mgr_id_of_login;
287: FETCH csr_get_mgr_id_of_login into ln_manager_id;
288: IF csr_get_mgr_id_of_login%NOTFOUND THEN
289: -- set the WF item attribute hr_mgr_id_of_login_person to the

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

307:
308: CLOSE csr_get_mgr_id_of_login;
309: END IF;
310: END IF; -- lv_term_sup_flag = 'Y'
311: hr_utility.set_location('Leaving'|| l_proc,20);
312: EXCEPTION
313: WHEN OTHERS THEN
314: hr_utility.set_location('EXCEPTION'|| l_proc,555);
315: WF_CORE.CONTEXT(gv_package

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

310: END IF; -- lv_term_sup_flag = 'Y'
311: hr_utility.set_location('Leaving'|| l_proc,20);
312: EXCEPTION
313: WHEN OTHERS THEN
314: hr_utility.set_location('EXCEPTION'|| l_proc,555);
315: WF_CORE.CONTEXT(gv_package
316: ,'BRANCH_ON_COST_CENTER_MGR'
317: ,itemtype
318: ,itemkey

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

359: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
360: ln_term_flag BOOLEAN DEFAULT FALSE;
361: l_proc constant varchar2(1000) := g_package || ' Create_transaction';
362: BEGIN
363: hr_utility.set_location('Entering'|| l_proc,5);
364: ln_transaction_id := hr_transaction_ss.get_transaction_id
365: (p_Item_Type => p_item_type
366: ,p_Item_Key => p_item_key);
367:

Line 371: hr_utility.trace('In ( IF ln_transaction_id IS NULL)'|| l_proc);

367:
368: IF ln_transaction_id IS NULL
369:
370: THEN
371: hr_utility.trace('In ( IF ln_transaction_id IS NULL)'|| l_proc);
372: hr_transaction_ss.start_transaction
373: ( itemtype => p_item_type
374: ,itemkey => p_item_key
375: ,actid => p_act_id

Line 398: hr_utility.trace('In (if ln_trans_step_rows < 1)'|| l_proc);

394: ,p_object_version_number => ltt_trans_obj_vers_num
395: ,p_rows => ln_trans_step_rows);
396:
397: IF ln_trans_step_rows < 1 THEN
398: hr_utility.trace('In (if ln_trans_step_rows < 1)'|| l_proc);
399: --There is no transaction step for this transaction.
400: --Create a step within this new transaction
401:
402: hr_transaction_api.create_transaction_step(

Line 415: hr_utility.trace('In else of (If ln_trans_step_rows < 1)'|| l_proc);

411: ,p_object_version_number =>ln_ovn ) ;
412:
413:
414: ELSE
415: hr_utility.trace('In else of (If ln_trans_step_rows < 1)'|| l_proc);
416: --There are transaction steps for this transaction.
417: --Get the Transaction Step ID for this activity.
418: ln_transaction_step_id :=
419: hr_transaction_ss.get_activity_trans_step_id(

Line 491: hr_utility.set_location('Leaving'|| l_proc,25);

487:
488:
489: p_transaction_id := ln_transaction_id ;
490: p_transaction_step_id := ln_transaction_step_id ;
491: hr_utility.set_location('Leaving'|| l_proc,25);
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: hr_utility.set_location('EXCEPTION'|| l_proc,555);

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

491: hr_utility.set_location('Leaving'|| l_proc,25);
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: hr_utility.set_location('EXCEPTION'|| l_proc,555);
496: raise ;
497:
498: END create_transaction ;
499:

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

546: l_supervisor_assignment_id number ;
547: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
548: l_proc constant varchar2(100) := g_package || ' update_supervisor';
549: BEGIN
550: hr_utility.set_location('Entering'|| l_proc,5);
551: OPEN lc_object_version_no ;
552: FETCH lc_object_version_no into ln_object_version_no, ln_assignment_type ;
553: CLOSE lc_object_version_no ;
554:

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

584: p_effective_start_date=>ld_effective_start_date,
585: p_effective_end_date=>ld_effective_end_date,
586: p_no_managers_warning=>lb_no_managers_warning,
587: p_other_manager_warning=>lb_other_manager_warning ) ;
588: hr_utility.set_location('Leaving'|| l_proc,10);
589:
590: EXCEPTION
591: /*WHEN hr_utility.hr_error THEN
592: hr_message.provide_error;

Line 591: /*WHEN hr_utility.hr_error THEN

587: p_other_manager_warning=>lb_other_manager_warning ) ;
588: hr_utility.set_location('Leaving'|| l_proc,10);
589:
590: EXCEPTION
591: /*WHEN hr_utility.hr_error THEN
592: hr_message.provide_error;
593: lv_message_number := hr_message.last_message_number;
594: hr_errors_api.addErrorToTable(
595: p_errormsg => hr_message.get_message_text,

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

596: p_errorcode => lv_message_number
597: );*/
598:
599: WHEN OTHERS THEN
600: hr_utility.set_location('EXCEPTION'|| l_proc,555);
601: raise ;
602:
603: END update_supervisor ;
604:

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

638: l_proc constant varchar2(100) := g_package || 'validate_api';
639:
640:
641: BEGIN
642: hr_utility.set_location('Entering'|| l_proc,5);
643: SAVEPOINT update_supervisor ;
644: -- if not invoked from termination , update the
645: -- selected employee's supervisor
646: -- we need to check here if the supervisor is changed and

Line 658: hr_utility.trace('In (if p_term_flag = N)'|| l_proc);

654: -- remove the comments and the update_supervisor
655: -- RAJ just to test IF p_from_term = FALSE TO p_term_flag="N"
656: IF p_term_flag = 'N'
657: THEN
658: hr_utility.trace('In (if p_term_flag = N)'|| l_proc);
659: IF (
660: ( p_selected_person_sup_id IS NOT NULL AND
661: p_selected_person_old_sup_id IS NULL ) OR
662: ( p_selected_person_sup_id IS NULL AND

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

748: IF p_validate
749: THEN
750: ROLLBACK to update_supervisor ;
751: END IF ;
752: hr_utility.set_location('Leaving'|| l_proc,15);
753: EXCEPTION
754: -- add api error
755: /*WHEN hr_utility.hr_error THEN
756: hr_message.provide_error;

Line 755: /*WHEN hr_utility.hr_error THEN

751: END IF ;
752: hr_utility.set_location('Leaving'|| l_proc,15);
753: EXCEPTION
754: -- add api error
755: /*WHEN hr_utility.hr_error THEN
756: hr_message.provide_error;
757: lv_message_number := hr_message.last_message_number;
758: hr_errors_api.addErrorToTable(
759: p_errormsg => hr_message.get_message_text,

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

760: p_errorcode => lv_message_number
761: );*/
762:
763: WHEN OTHERS THEN
764: hr_utility.set_location('EXCEPTION'|| l_proc,555);
765: raise ;
766:
767: END validate_api;
768:

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

810: ln_assignment_id NUMBER ;
811: l_proc constant varchar2(100) := g_package || 'validate_emp_assignments';
812:
813: BEGIN
814: hr_utility.set_location('Entering'|| l_proc,5);
815: p_error_flag := FALSE ;
816:
817: FOR i in 1..p_emp_id.count
818: LOOP

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

833:
834: close lc_assignment_id ;
835:
836: END LOOP ;
837: hr_utility.set_location('Leaving'|| l_proc,10);
838:
839: EXCEPTION
840: WHEN OTHERS THEN
841:

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

838:
839: EXCEPTION
840: WHEN OTHERS THEN
841:
842: hr_utility.set_location('EXCEPTION'|| l_proc,555);
843: raise ;
844:
845:
846: END ;

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

899: l_proc constant varchar2(100) := g_package || 'get_txn_details';
900: -- ld_passed_effective_date DATE ;
901:
902: BEGIN
903: hr_utility.set_location('Entering'|| l_proc,5);
904: ln_transaction_id := hr_transaction_ss.get_transaction_id
905: (p_Item_Type => p_item_type,
906: p_Item_Key => p_item_key);
907:

Line 911: hr_utility.trace('In if ln_transaction_id IS NOT NULL '|| l_proc);

907:
908:
909: IF ln_transaction_id IS NOT NULL
910: THEN
911: hr_utility.trace('In if ln_transaction_id IS NOT NULL '|| l_proc);
912: hr_transaction_api.get_transaction_step_info
913: (p_Item_Type => p_item_type,
914: p_Item_Key => p_item_key,
915: p_activity_id =>p_act_id,

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

920:
921: -- if no transaction steps are found , return
922: IF ln_trans_step_rows < 1
923: THEN
924: hr_utility.set_location('Leaving'|| l_proc,15);
925: RETURN ;
926:
927: ELSE
928:

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

939: (p_transaction_step_id => ln_transaction_step_id,
940: p_name =>'p_selected_emp');
941: EXCEPTION
942: WHEN OTHERS THEN
943: hr_utility.set_location('EXCEPTION'|| l_proc,555);
944: lv_selected_emp := false;
945: END;
946:
947: BEGIN

Line 954: hr_utility.set_location('EXCEPTION'|| l_proc,560);

950: (p_transaction_step_id => ln_transaction_step_id,
951: p_name =>'p_direct_reports');
952: EXCEPTION
953: WHEN OTHERS THEN
954: hr_utility.set_location('EXCEPTION'|| l_proc,560);
955: lv_direct_reports := false;
956: END;
957:
958: BEGIN

Line 965: hr_utility.set_location('EXCEPTION'|| l_proc,565);

961: (p_transaction_step_id => ln_transaction_step_id,
962: p_name =>'p_new_reports');
963: EXCEPTION
964: WHEN OTHERS THEN
965: hr_utility.set_location('EXCEPTION'|| l_proc,565);
966: lv_new_reports := false;
967: END;
968:
969: -- now get the individual txn data

Line 997: hr_utility.trace('In (if p_term_flag=N) '|| l_proc);

993: (p_transaction_step_id => ln_transaction_step_id,
994: p_name =>'p_single_effective_date');
995:
996: if p_term_flag='N' Then
997: hr_utility.trace('In (if p_term_flag=N) '|| l_proc);
998: if lv_selected_emp then
999: hr_utility.trace('In (if lv_selected_emp) '|| l_proc);
1000: p_passed_assignment_id :=
1001: hr_transaction_api.get_number_value

Line 999: hr_utility.trace('In (if lv_selected_emp) '|| l_proc);

995:
996: if p_term_flag='N' Then
997: hr_utility.trace('In (if p_term_flag=N) '|| l_proc);
998: if lv_selected_emp then
999: hr_utility.trace('In (if lv_selected_emp) '|| l_proc);
1000: p_passed_assignment_id :=
1001: hr_transaction_api.get_number_value
1002: (p_transaction_step_id => ln_transaction_step_id,
1003: p_name =>'p_passed_assignment_id');

Line 1052: hr_utility.trace('In (if lv_new_reports) '|| l_proc);

1048: p_name =>'p_passed_effective_date');
1049: end if; -- end selected emp
1050:
1051: IF lv_new_reports THEN
1052: hr_utility.trace('In (if lv_new_reports) '|| l_proc);
1053:
1054: FOR i in 1 ..ln_no_of_emp
1055: LOOP
1056:

Line 1093: hr_utility.trace('In (if lv_direct_reports) '|| l_proc);

1089: (p_transaction_step_id => ln_transaction_step_id,
1090: p_name =>'p_no_of_reports');
1091:
1092: IF lv_direct_reports THEN
1093: hr_utility.trace('In (if lv_direct_reports) '|| l_proc);
1094: -- now get all the direct reports info
1095: FOR i in 1..ln_no_of_reports
1096: LOOP
1097:

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

1132: END LOOP ;
1133: END IF;
1134: END IF; -- end Direct reports
1135: END IF ;
1136: hr_utility.set_location('Leaving'|| l_proc,40);
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: hr_utility.set_location('EXCEPTION'|| l_proc,570);
1140: raise ;

Line 1139: hr_utility.set_location('EXCEPTION'|| l_proc,570);

1135: END IF ;
1136: hr_utility.set_location('Leaving'|| l_proc,40);
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: hr_utility.set_location('EXCEPTION'|| l_proc,570);
1140: raise ;
1141:
1142: END ;
1143:

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

1191: ld_effective_date date default null;
1192: l_proc constant varchar2(100) := g_package || 'process_api';
1193: BEGIN
1194:
1195: hr_utility.set_location('Entering'|| l_proc,5);
1196: hr_transaction_api.get_transaction_step_info(
1197: p_transaction_step_id => p_transaction_step_id
1198: ,p_item_type => lv_item_type
1199: ,p_item_key => lv_item_key

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

1305:
1306:
1307: -- end if;
1308:
1309: hr_utility.set_location('Leaving'|| l_proc,10);
1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: hr_utility.set_location('EXCEPTION'|| l_proc,555);

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

1309: hr_utility.set_location('Leaving'|| l_proc,10);
1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1314: raise ;
1315:
1316: END PROCESS_API;
1317:

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

1341: l_proc constant varchar2(100) := g_package || ' write_transaction';
1342:
1343: BEGIN
1344:
1345: hr_utility.set_location('Entering'|| l_proc,5);
1346:
1347: -- write data for selected employee
1348: IF p_section_code = 'NEW_MANAGER'
1349: THEN

Line 1351: hr_utility.trace('In (IF p_section_code = NEW_MANAGER)'|| l_proc);

1347: -- write data for selected employee
1348: IF p_section_code = 'NEW_MANAGER'
1349: THEN
1350:
1351: hr_utility.trace('In (IF p_section_code = NEW_MANAGER)'|| l_proc);
1352:
1353: -- Store the p_selected_emp to be used in process_Api
1354: hr_transaction_api.set_boolean_value (
1355: p_transaction_step_id =>p_transaction_step_id,

Line 1441: hr_utility.trace('In (IF p_section_code = DIR_REPORTS)'|| l_proc);

1437:
1438: -- write transaction data for direct reports section
1439: IF p_section_code = 'DIR_REPORTS'
1440: THEN
1441: hr_utility.trace('In (IF p_section_code = DIR_REPORTS)'|| l_proc);
1442: -- Store the p_selected_emp to be used in process_Api
1443: hr_transaction_api.set_boolean_value (
1444: p_transaction_step_id =>p_transaction_step_id,
1445: p_person_id => p_login_person_id ,

Line 1519: hr_utility.trace('In (IF p_section_code = NEW_REPORTS)'|| l_proc);

1515:
1516: -- write data for new direct reports
1517: IF p_section_code = 'NEW_REPORTS'
1518: THEN
1519: hr_utility.trace('In (IF p_section_code = NEW_REPORTS)'|| l_proc);
1520: -- Store the p_selected_emp to be used in process_Api
1521: hr_transaction_api.set_boolean_value (
1522: p_transaction_step_id =>p_transaction_step_id,
1523: p_person_id => p_login_person_id ,

Line 1561: hr_utility.set_location('Leaving'|| l_proc,25);

1557: p_value =>p_new_sup_asg_id ) ;
1558:
1559:
1560: END IF ;
1561: hr_utility.set_location('Leaving'|| l_proc,25);
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1565: hr_utility.set_location('EXCEPTION'|| l_proc,555);

Line 1564: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );

1560: END IF ;
1561: hr_utility.set_location('Leaving'|| l_proc,25);
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1565: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1566: raise ;
1567:
1568: END WRITE_TRANSACTION ;

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

1561: hr_utility.set_location('Leaving'|| l_proc,25);
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1565: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1566: raise ;
1567:
1568: END WRITE_TRANSACTION ;
1569:

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

1605: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
1606: l_proc constant varchar2(100) := g_package || 'update_asg';
1607:
1608: BEGIN
1609: hr_utility.set_location('Entering'|| l_proc,5);
1610: -- first call update_asg if not save for later
1611: IF (p_save_for_later = 'SAVE') THEN
1612: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);
1613: FOR I IN 1 ..p_manager_details_tab.count LOOP

Line 1612: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);

1608: BEGIN
1609: hr_utility.set_location('Entering'|| l_proc,5);
1610: -- first call update_asg if not save for later
1611: IF (p_save_for_later = 'SAVE') THEN
1612: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);
1613: FOR I IN 1 ..p_manager_details_tab.count LOOP
1614: -- Assignment Security
1615: IF(l_assignment_security_profile <> 'TRUE') then
1616: l_supervisor_assignment_id := hr_api.g_number;

Line 1645: hr_utility.trace('end of checking in update_asg');

1641: l_error_found := true;
1642: END IF;
1643: END LOOP;
1644: END IF;
1645: hr_utility.trace('end of checking in update_asg');
1646:
1647: IF (NOT l_error_found) THEN
1648: hr_utility.trace('IN if (NOT l_error_found)'|| l_proc);
1649:

Line 1648: hr_utility.trace('IN if (NOT l_error_found)'|| l_proc);

1644: END IF;
1645: hr_utility.trace('end of checking in update_asg');
1646:
1647: IF (NOT l_error_found) THEN
1648: hr_utility.trace('IN if (NOT l_error_found)'|| l_proc);
1649:
1650: -- second call create transaction to start transaction
1651: create_transaction(p_item_type => p_item_type,
1652: p_item_key => p_item_key,

Line 1669: hr_utility.trace('bdefore writing Txn in update_asg');

1665: p_term_flag => p_term_sup_flag,
1666: p_rptg_grp_id => p_rptg_grp_id,
1667: p_plan_id => p_plan_id,
1668: p_effective_date_option => p_effective_date_option);
1669: hr_utility.trace('bdefore writing Txn in update_asg');
1670: hr_utility.trace('p_manager_details_tab.count=' || p_manager_details_tab.count);
1671: -- third call write transactions to write to transaction tables
1672: FOR I IN 1 ..p_manager_details_tab.count LOOP
1673:

Line 1670: hr_utility.trace('p_manager_details_tab.count=' || p_manager_details_tab.count);

1666: p_rptg_grp_id => p_rptg_grp_id,
1667: p_plan_id => p_plan_id,
1668: p_effective_date_option => p_effective_date_option);
1669: hr_utility.trace('bdefore writing Txn in update_asg');
1670: hr_utility.trace('p_manager_details_tab.count=' || p_manager_details_tab.count);
1671: -- third call write transactions to write to transaction tables
1672: FOR I IN 1 ..p_manager_details_tab.count LOOP
1673:
1674: -- Assignment Security

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

1704: -- now commit the transaction table data
1705: commit;
1706: END IF;
1707: p_transaction_step_id := l_transaction_step_id;
1708: hr_utility.set_location('Leaving'|| l_proc,15);
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1712:

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

1707: p_transaction_step_id := l_transaction_step_id;
1708: hr_utility.set_location('Leaving'|| l_proc,15);
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1712:
1713: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1714: hr_utility.raise_error;
1715: hr_utility.set_location('Leaving'|| l_proc,10);

Line 1713: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));

1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1712:
1713: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1714: hr_utility.raise_error;
1715: hr_utility.set_location('Leaving'|| l_proc,10);
1716: END update_asg;
1717:

Line 1714: hr_utility.raise_error;

1710: WHEN OTHERS THEN
1711: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1712:
1713: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1714: hr_utility.raise_error;
1715: hr_utility.set_location('Leaving'|| l_proc,10);
1716: END update_asg;
1717:
1718:

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

1711: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1712:
1713: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1714: hr_utility.raise_error;
1715: hr_utility.set_location('Leaving'|| l_proc,10);
1716: END update_asg;
1717:
1718:
1719: /*

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

1913: and l_effective_date between effective_start_date and effective_end_date;
1914:
1915: l_proc constant varchar2(100) := g_package || ' update_asg';
1916: BEGIN
1917: hr_utility.set_location('Entering'|| l_proc,5);
1918: SAVEPOINT sup_update_asg;
1919: l_attribute_update_mode := p_attribute_update_mode;
1920: l_assignment_id := p_assignment_id;
1921:

Line 1939: hr_utility.trace('In ( if l_supervisor_id is not null )'|| l_proc);

1935: l_supervisor_id := p_supervisor_id;
1936: l_supervisor_assignment_id := p_supervisor_assignment_id;
1937: --Validate the p_supervisor_id
1938: if l_supervisor_id is not null then
1939: hr_utility.trace('In ( if l_supervisor_id is not null )'|| l_proc);
1940: l_re_hire_flow := wf_engine.GetItemAttrText(p_item_type,p_item_key,'HR_FLOW_IDENTIFIER',true);
1941: open chk_ex_emp(l_supervisor_id, p_effective_date);
1942: fetch chk_ex_emp into l_ex_emp;
1943: close chk_ex_emp;

Line 1956: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);

1952: else
1953: open csr_person;
1954: fetch csr_person into l_supervisor_id;
1955: if csr_person%notfound then
1956: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);
1957: hr_new_user_reg_ss.processNewUserTransaction
1958: (WfItemType => p_item_type
1959: ,WfItemKey => p_item_key
1960: ,PersonId => l_supervisor_id

Line 1982: hr_utility.trace('Entering if (p_supervisor_id<>l_supervisor_old_id)');

1978: fetch csr_present_supervisor_id into l_supervisor_old_id;
1979: close csr_present_supervisor_id;
1980:
1981: if (p_supervisor_id<>l_supervisor_old_id) then
1982: hr_utility.trace('Entering if (p_supervisor_id<>l_supervisor_old_id)');
1983: --added condition to check only for direct reports
1984: if (l_current_person_id <> l_person_id) then
1985: open csr_assignment_future(l_person_id,p_effective_date);
1986: fetch csr_assignment_future into l_assignment_id;

Line 1988: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);

1984: if (l_current_person_id <> l_person_id) then
1985: open csr_assignment_future(l_person_id,p_effective_date);
1986: fetch csr_assignment_future into l_assignment_id;
1987: if csr_assignment_future%found then
1988: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);
1989: hr_utility.trace('Future assignemnt change found');
1990:
1991: RAISE e_future_assignment_change;
1992: end if;

Line 1989: hr_utility.trace('Future assignemnt change found');

1985: open csr_assignment_future(l_person_id,p_effective_date);
1986: fetch csr_assignment_future into l_assignment_id;
1987: if csr_assignment_future%found then
1988: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);
1989: hr_utility.trace('Future assignemnt change found');
1990:
1991: RAISE e_future_assignment_change;
1992: end if;
1993: end if; --End of added condition to check only for direct reports

Line 2031: hr_utility.trace('In ( if of checking Case1 mode )'|| l_proc);

2027:
2028: if (l_current_applicant_flag = 'Y' AND
2029: nvl(l_current_employee_flag, 'N') <> 'Y' AND
2030: nvl(l_current_npw_flag, 'N') <> 'Y') then
2031: hr_utility.trace('In ( if of checking Case1 mode )'|| l_proc);
2032: g_applicant_hire := true;
2033: isApplicantSubordinate := false;
2034: l_applicant_person_id := p_supervisor_id;
2035: -- Get the assignment_id for the applicant from workflow

Line 2062: hr_utility.trace('In ( if (l_appl_assignment_type = A )'|| l_proc);

2058: ,l_person_id;
2059: close asg_appl_rec_assign_manager;
2060:
2061: if(l_appl_assignment_type = 'A') then
2062: hr_utility.trace('In ( if (l_appl_assignment_type = A )'|| l_proc);
2063: g_applicant_hire := true;
2064: isApplicantSubordinate := false;
2065: -- Get the person_id from assignment record.
2066: l_applicant_person_id := l_person_id;

Line 2081: hr_utility.trace('In ( if of g_applicant_hire )'|| l_proc);

2077: close per_applicant_rec;
2078: end if;
2079:
2080: if (g_applicant_hire) then
2081: hr_utility.trace('In ( if of g_applicant_hire )'|| l_proc);
2082: -- SAVEPOINT applicant_hire;
2083:
2084: -- get the employee number from Basic Details Step
2085: /*hr_person_info_util_ss.get_trns_employee_number(

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

2145: if (g_applicant_hire) then
2146: g_applicant_hire := false;
2147: --rollback to applicant_hire;
2148: end if;
2149: hr_utility.set_location('Leaving'|| l_proc,40);
2150: ROLLBACK TO sup_update_asg;
2151:
2152: EXCEPTION
2153: --added for Bug 11679239

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

2151:
2152: EXCEPTION
2153: --added for Bug 11679239
2154: WHEN e_future_assignment_change THEN
2155: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2156: hr_utility.set_message ('800','HR_50438_FUTUR_CHNG_EXST_ERR');
2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);
2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239

Line 2156: hr_utility.set_message ('800','HR_50438_FUTUR_CHNG_EXST_ERR');

2152: EXCEPTION
2153: --added for Bug 11679239
2154: WHEN e_future_assignment_change THEN
2155: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2156: hr_utility.set_message ('800','HR_50438_FUTUR_CHNG_EXST_ERR');
2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);
2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239
2160:

Line 2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);

2153: --added for Bug 11679239
2154: WHEN e_future_assignment_change THEN
2155: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2156: hr_utility.set_message ('800','HR_50438_FUTUR_CHNG_EXST_ERR');
2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);
2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239
2160:
2161: WHEN hr_utility.hr_error THEN

Line 2158: p_error_message := hr_utility.get_message;

2154: WHEN e_future_assignment_change THEN
2155: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2156: hr_utility.set_message ('800','HR_50438_FUTUR_CHNG_EXST_ERR');
2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);
2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239
2160:
2161: WHEN hr_utility.hr_error THEN
2162: hr_utility.set_location('EXCEPTION'|| l_proc,555);

Line 2161: WHEN hr_utility.hr_error THEN

2157: hr_utility.set_message_token ('PERSON_NAME', l_person_name);
2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239
2160:
2161: WHEN hr_utility.hr_error THEN
2162: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2163: -- -------------------------------------------
2164: -- an application error has been raised so we must
2165: -- redisplay the web form to display the error

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

2158: p_error_message := hr_utility.get_message;
2159: --End of added for Bug 11679239
2160:
2161: WHEN hr_utility.hr_error THEN
2162: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2163: -- -------------------------------------------
2164: -- an application error has been raised so we must
2165: -- redisplay the web form to display the error
2166: -- --------------------------------------------

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

2170: p_error_message_name := hr_message.last_message_name;
2171: p_error_message := null;
2172:
2173: WHEN OTHERS THEN
2174: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2175: -- applicant_hire
2176: if (g_applicant_hire) then
2177: g_applicant_hire := false;
2178: -- rollback to applicant_hire;

Line 2180: IF (hr_utility.get_message IS NOT NULL) THEN

2176: if (g_applicant_hire) then
2177: g_applicant_hire := false;
2178: -- rollback to applicant_hire;
2179: end if;
2180: IF (hr_utility.get_message IS NOT NULL) THEN
2181: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2182: hr_utility.get_message;
2183: ELSE
2184: p_error_message := hr_message.get_message_text;

Line 2181: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||

2177: g_applicant_hire := false;
2178: -- rollback to applicant_hire;
2179: end if;
2180: IF (hr_utility.get_message IS NOT NULL) THEN
2181: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2182: hr_utility.get_message;
2183: ELSE
2184: p_error_message := hr_message.get_message_text;
2185: END IF;

Line 2182: hr_utility.get_message;

2178: -- rollback to applicant_hire;
2179: end if;
2180: IF (hr_utility.get_message IS NOT NULL) THEN
2181: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2182: hr_utility.get_message;
2183: ELSE
2184: p_error_message := hr_message.get_message_text;
2185: END IF;
2186: p_error_message_appl := null;