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 177: hr_utility.set_location('Entering '|| l_proc,5);

173:
174: BEGIN
175: --
176: -- Get the action person id, ie. selected person id
177: hr_utility.set_location('Entering '|| l_proc,5);
178: ln_person_id := wf_engine.GetItemAttrNumber
179: (itemtype => itemtype
180: ,itemkey => itemkey
181: ,aname => 'CURRENT_PERSON_ID');

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

204: -- We will set the result code to 'Y' only if the item attribute
205: -- HR_TERM_SUP_FLAG is set to 'Y', that means the caller is from Termination.
206: -- Otherwise, we don't need to branch to the Cost Center Manager module.
207: IF lv_term_sup_flag = 'Y' THEN
208: hr_utility.trace('In (if lv_term_sup_flag = Y)'|| l_proc);
209: resultout := 'COMPLETE:'|| 'N';
210: lv_no_access_to_some_cc := 'N';
211: -- We need to run the update_access_check cursor to see if the
212: -- login person has the security access to select another manager

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

236: -- is some cost centers that the login person cannot access and the
237: -- person terminated is a cost center manager.
238:
239: IF lv_no_access_to_some_cc = 'Y' THEN
240: hr_utility.trace('In (if lv_no_access_to_some_cc = Y)'|| l_proc);
241: OPEN csr_get_mgr_id_of_login;
242: FETCH csr_get_mgr_id_of_login into ln_manager_id;
243: IF csr_get_mgr_id_of_login%NOTFOUND THEN
244: -- set the WF item attribute hr_mgr_id_of_login_person to the

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

262:
263: CLOSE csr_get_mgr_id_of_login;
264: END IF;
265: END IF; -- lv_term_sup_flag = 'Y'
266: hr_utility.set_location('Leaving'|| l_proc,20);
267: EXCEPTION
268: WHEN OTHERS THEN
269: hr_utility.set_location('EXCEPTION'|| l_proc,555);
270: WF_CORE.CONTEXT(gv_package

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

265: END IF; -- lv_term_sup_flag = 'Y'
266: hr_utility.set_location('Leaving'|| l_proc,20);
267: EXCEPTION
268: WHEN OTHERS THEN
269: hr_utility.set_location('EXCEPTION'|| l_proc,555);
270: WF_CORE.CONTEXT(gv_package
271: ,'BRANCH_ON_COST_CENTER_MGR'
272: ,itemtype
273: ,itemkey

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

314: ln_ovn hr_api_transaction_steps.object_version_number%TYPE;
315: ln_term_flag BOOLEAN DEFAULT FALSE;
316: l_proc constant varchar2(1000) := g_package || ' Create_transaction';
317: BEGIN
318: hr_utility.set_location('Entering'|| l_proc,5);
319: ln_transaction_id := hr_transaction_ss.get_transaction_id
320: (p_Item_Type => p_item_type
321: ,p_Item_Key => p_item_key);
322:

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

322:
323: IF ln_transaction_id IS NULL
324:
325: THEN
326: hr_utility.trace('In ( IF ln_transaction_id IS NULL)'|| l_proc);
327: hr_transaction_ss.start_transaction
328: ( itemtype => p_item_type
329: ,itemkey => p_item_key
330: ,actid => p_act_id

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

349: ,p_object_version_number => ltt_trans_obj_vers_num
350: ,p_rows => ln_trans_step_rows);
351:
352: IF ln_trans_step_rows < 1 THEN
353: hr_utility.trace('In (if ln_trans_step_rows < 1)'|| l_proc);
354: --There is no transaction step for this transaction.
355: --Create a step within this new transaction
356:
357: hr_transaction_api.create_transaction_step(

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

366: ,p_object_version_number =>ln_ovn ) ;
367:
368:
369: ELSE
370: hr_utility.trace('In else of (If ln_trans_step_rows < 1)'|| l_proc);
371: --There are transaction steps for this transaction.
372: --Get the Transaction Step ID for this activity.
373: ln_transaction_step_id :=
374: hr_transaction_ss.get_activity_trans_step_id(

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

442:
443:
444: p_transaction_id := ln_transaction_id ;
445: p_transaction_step_id := ln_transaction_step_id ;
446: hr_utility.set_location('Leaving'|| l_proc,25);
447:
448: EXCEPTION
449: WHEN OTHERS THEN
450: hr_utility.set_location('EXCEPTION'|| l_proc,555);

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

446: hr_utility.set_location('Leaving'|| l_proc,25);
447:
448: EXCEPTION
449: WHEN OTHERS THEN
450: hr_utility.set_location('EXCEPTION'|| l_proc,555);
451: raise ;
452:
453: END create_transaction ;
454:

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

501: l_supervisor_assignment_id number ;
502: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
503: l_proc constant varchar2(100) := g_package || ' update_supervisor';
504: BEGIN
505: hr_utility.set_location('Entering'|| l_proc,5);
506: OPEN lc_object_version_no ;
507: FETCH lc_object_version_no into ln_object_version_no, ln_assignment_type ;
508: CLOSE lc_object_version_no ;
509:

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

539: p_effective_start_date=>ld_effective_start_date,
540: p_effective_end_date=>ld_effective_end_date,
541: p_no_managers_warning=>lb_no_managers_warning,
542: p_other_manager_warning=>lb_other_manager_warning ) ;
543: hr_utility.set_location('Leaving'|| l_proc,10);
544:
545: EXCEPTION
546: /*WHEN hr_utility.hr_error THEN
547: hr_message.provide_error;

Line 546: /*WHEN hr_utility.hr_error THEN

542: p_other_manager_warning=>lb_other_manager_warning ) ;
543: hr_utility.set_location('Leaving'|| l_proc,10);
544:
545: EXCEPTION
546: /*WHEN hr_utility.hr_error THEN
547: hr_message.provide_error;
548: lv_message_number := hr_message.last_message_number;
549: hr_errors_api.addErrorToTable(
550: p_errormsg => hr_message.get_message_text,

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

551: p_errorcode => lv_message_number
552: );*/
553:
554: WHEN OTHERS THEN
555: hr_utility.set_location('EXCEPTION'|| l_proc,555);
556: raise ;
557:
558: END update_supervisor ;
559:

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

593: l_proc constant varchar2(100) := g_package || 'validate_api';
594:
595:
596: BEGIN
597: hr_utility.set_location('Entering'|| l_proc,5);
598: SAVEPOINT update_supervisor ;
599: -- if not invoked from termination , update the
600: -- selected employee's supervisor
601: -- we need to check here if the supervisor is changed and

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

609: -- remove the comments and the update_supervisor
610: -- RAJ just to test IF p_from_term = FALSE TO p_term_flag="N"
611: IF p_term_flag = 'N'
612: THEN
613: hr_utility.trace('In (if p_term_flag = N)'|| l_proc);
614: IF (
615: ( p_selected_person_sup_id IS NOT NULL AND
616: p_selected_person_old_sup_id IS NULL ) OR
617: ( p_selected_person_sup_id IS NULL AND

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

703: IF p_validate
704: THEN
705: ROLLBACK to update_supervisor ;
706: END IF ;
707: hr_utility.set_location('Leaving'|| l_proc,15);
708: EXCEPTION
709: -- add api error
710: /*WHEN hr_utility.hr_error THEN
711: hr_message.provide_error;

Line 710: /*WHEN hr_utility.hr_error THEN

706: END IF ;
707: hr_utility.set_location('Leaving'|| l_proc,15);
708: EXCEPTION
709: -- add api error
710: /*WHEN hr_utility.hr_error THEN
711: hr_message.provide_error;
712: lv_message_number := hr_message.last_message_number;
713: hr_errors_api.addErrorToTable(
714: p_errormsg => hr_message.get_message_text,

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

715: p_errorcode => lv_message_number
716: );*/
717:
718: WHEN OTHERS THEN
719: hr_utility.set_location('EXCEPTION'|| l_proc,555);
720: raise ;
721:
722: END validate_api;
723:

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

765: ln_assignment_id NUMBER ;
766: l_proc constant varchar2(100) := g_package || 'validate_emp_assignments';
767:
768: BEGIN
769: hr_utility.set_location('Entering'|| l_proc,5);
770: p_error_flag := FALSE ;
771:
772: FOR i in 1..p_emp_id.count
773: LOOP

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

788:
789: close lc_assignment_id ;
790:
791: END LOOP ;
792: hr_utility.set_location('Leaving'|| l_proc,10);
793:
794: EXCEPTION
795: WHEN OTHERS THEN
796:

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

793:
794: EXCEPTION
795: WHEN OTHERS THEN
796:
797: hr_utility.set_location('EXCEPTION'|| l_proc,555);
798: raise ;
799:
800:
801: END ;

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

854: l_proc constant varchar2(100) := g_package || 'get_txn_details';
855: -- ld_passed_effective_date DATE ;
856:
857: BEGIN
858: hr_utility.set_location('Entering'|| l_proc,5);
859: ln_transaction_id := hr_transaction_ss.get_transaction_id
860: (p_Item_Type => p_item_type,
861: p_Item_Key => p_item_key);
862:

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

862:
863:
864: IF ln_transaction_id IS NOT NULL
865: THEN
866: hr_utility.trace('In if ln_transaction_id IS NOT NULL '|| l_proc);
867: hr_transaction_api.get_transaction_step_info
868: (p_Item_Type => p_item_type,
869: p_Item_Key => p_item_key,
870: p_activity_id =>p_act_id,

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

875:
876: -- if no transaction steps are found , return
877: IF ln_trans_step_rows < 1
878: THEN
879: hr_utility.set_location('Leaving'|| l_proc,15);
880: RETURN ;
881:
882: ELSE
883:

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

894: (p_transaction_step_id => ln_transaction_step_id,
895: p_name =>'p_selected_emp');
896: EXCEPTION
897: WHEN OTHERS THEN
898: hr_utility.set_location('EXCEPTION'|| l_proc,555);
899: lv_selected_emp := false;
900: END;
901:
902: BEGIN

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

905: (p_transaction_step_id => ln_transaction_step_id,
906: p_name =>'p_direct_reports');
907: EXCEPTION
908: WHEN OTHERS THEN
909: hr_utility.set_location('EXCEPTION'|| l_proc,560);
910: lv_direct_reports := false;
911: END;
912:
913: BEGIN

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

916: (p_transaction_step_id => ln_transaction_step_id,
917: p_name =>'p_new_reports');
918: EXCEPTION
919: WHEN OTHERS THEN
920: hr_utility.set_location('EXCEPTION'|| l_proc,565);
921: lv_new_reports := false;
922: END;
923:
924: -- now get the individual txn data

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

948: (p_transaction_step_id => ln_transaction_step_id,
949: p_name =>'p_single_effective_date');
950:
951: if p_term_flag='N' Then
952: hr_utility.trace('In (if p_term_flag=N) '|| l_proc);
953: if lv_selected_emp then
954: hr_utility.trace('In (if lv_selected_emp) '|| l_proc);
955: p_passed_assignment_id :=
956: hr_transaction_api.get_number_value

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

950:
951: if p_term_flag='N' Then
952: hr_utility.trace('In (if p_term_flag=N) '|| l_proc);
953: if lv_selected_emp then
954: hr_utility.trace('In (if lv_selected_emp) '|| l_proc);
955: p_passed_assignment_id :=
956: hr_transaction_api.get_number_value
957: (p_transaction_step_id => ln_transaction_step_id,
958: p_name =>'p_passed_assignment_id');

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

1003: p_name =>'p_passed_effective_date');
1004: end if; -- end selected emp
1005:
1006: IF lv_new_reports THEN
1007: hr_utility.trace('In (if lv_new_reports) '|| l_proc);
1008:
1009: FOR i in 1 ..ln_no_of_emp
1010: LOOP
1011:

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

1044: (p_transaction_step_id => ln_transaction_step_id,
1045: p_name =>'p_no_of_reports');
1046:
1047: IF lv_direct_reports THEN
1048: hr_utility.trace('In (if lv_direct_reports) '|| l_proc);
1049: -- now get all the direct reports info
1050: FOR i in 1..ln_no_of_reports
1051: LOOP
1052:

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

1087: END LOOP ;
1088: END IF;
1089: END IF; -- end Direct reports
1090: END IF ;
1091: hr_utility.set_location('Leaving'|| l_proc,40);
1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: hr_utility.set_location('EXCEPTION'|| l_proc,570);
1095: raise ;

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

1090: END IF ;
1091: hr_utility.set_location('Leaving'|| l_proc,40);
1092: EXCEPTION
1093: WHEN OTHERS THEN
1094: hr_utility.set_location('EXCEPTION'|| l_proc,570);
1095: raise ;
1096:
1097: END ;
1098:

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

1146: ld_effective_date date default null;
1147: l_proc constant varchar2(100) := g_package || 'process_api';
1148: BEGIN
1149:
1150: hr_utility.set_location('Entering'|| l_proc,5);
1151: hr_transaction_api.get_transaction_step_info(
1152: p_transaction_step_id => p_transaction_step_id
1153: ,p_item_type => lv_item_type
1154: ,p_item_key => lv_item_key

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

1260:
1261:
1262: -- end if;
1263:
1264: hr_utility.set_location('Leaving'|| l_proc,10);
1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: hr_utility.set_location('EXCEPTION'|| l_proc,555);

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

1264: hr_utility.set_location('Leaving'|| l_proc,10);
1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1269: raise ;
1270:
1271: END PROCESS_API;
1272:

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

1296: l_proc constant varchar2(100) := g_package || ' write_transaction';
1297:
1298: BEGIN
1299:
1300: hr_utility.set_location('Entering'|| l_proc,5);
1301:
1302: -- write data for selected employee
1303: IF p_section_code = 'NEW_MANAGER'
1304: THEN

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

1302: -- write data for selected employee
1303: IF p_section_code = 'NEW_MANAGER'
1304: THEN
1305:
1306: hr_utility.trace('In (IF p_section_code = NEW_MANAGER)'|| l_proc);
1307:
1308: -- Store the p_selected_emp to be used in process_Api
1309: hr_transaction_api.set_boolean_value (
1310: p_transaction_step_id =>p_transaction_step_id,

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

1392:
1393: -- write transaction data for direct reports section
1394: IF p_section_code = 'DIR_REPORTS'
1395: THEN
1396: hr_utility.trace('In (IF p_section_code = DIR_REPORTS)'|| l_proc);
1397: -- Store the p_selected_emp to be used in process_Api
1398: hr_transaction_api.set_boolean_value (
1399: p_transaction_step_id =>p_transaction_step_id,
1400: p_person_id => p_login_person_id ,

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

1470:
1471: -- write data for new direct reports
1472: IF p_section_code = 'NEW_REPORTS'
1473: THEN
1474: hr_utility.trace('In (IF p_section_code = NEW_REPORTS)'|| l_proc);
1475: -- Store the p_selected_emp to be used in process_Api
1476: hr_transaction_api.set_boolean_value (
1477: p_transaction_step_id =>p_transaction_step_id,
1478: p_person_id => p_login_person_id ,

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

1512: p_value =>p_new_sup_asg_id ) ;
1513:
1514:
1515: END IF ;
1516: hr_utility.set_location('Leaving'|| l_proc,25);
1517: EXCEPTION
1518: WHEN OTHERS THEN
1519: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1520: hr_utility.set_location('EXCEPTION'|| l_proc,555);

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

1515: END IF ;
1516: hr_utility.set_location('Leaving'|| l_proc,25);
1517: EXCEPTION
1518: WHEN OTHERS THEN
1519: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1520: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1521: raise ;
1522:
1523: END WRITE_TRANSACTION ;

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

1516: hr_utility.set_location('Leaving'|| l_proc,25);
1517: EXCEPTION
1518: WHEN OTHERS THEN
1519: hr_utility.trace(' HR_SUPERVISOR_SS.write_transaction: ' || SQLERRM );
1520: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1521: raise ;
1522:
1523: END WRITE_TRANSACTION ;
1524:

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

1560: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
1561: l_proc constant varchar2(100) := g_package || 'update_asg';
1562:
1563: BEGIN
1564: hr_utility.set_location('Entering'|| l_proc,5);
1565: -- first call update_asg if not save for later
1566: IF (p_save_for_later = 'SAVE') THEN
1567: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);
1568: FOR I IN 1 ..p_manager_details_tab.count LOOP

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

1563: BEGIN
1564: hr_utility.set_location('Entering'|| l_proc,5);
1565: -- first call update_asg if not save for later
1566: IF (p_save_for_later = 'SAVE') THEN
1567: hr_utility.trace('IN (if p_save_for_later = SAVE)'|| l_proc);
1568: FOR I IN 1 ..p_manager_details_tab.count LOOP
1569: -- Assignment Security
1570: IF(l_assignment_security_profile <> 'TRUE') then
1571: l_supervisor_assignment_id := hr_api.g_number;

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

1596: l_error_found := true;
1597: END IF;
1598: END LOOP;
1599: END IF;
1600: hr_utility.trace('end of checking in update_asg');
1601:
1602: IF (NOT l_error_found) THEN
1603: hr_utility.trace('IN if (NOT l_error_found)'|| l_proc);
1604:

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

1599: END IF;
1600: hr_utility.trace('end of checking in update_asg');
1601:
1602: IF (NOT l_error_found) THEN
1603: hr_utility.trace('IN if (NOT l_error_found)'|| l_proc);
1604:
1605: -- second call create transaction to start transaction
1606: create_transaction(p_item_type => p_item_type,
1607: p_item_key => p_item_key,

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

1620: p_term_flag => p_term_sup_flag,
1621: p_rptg_grp_id => p_rptg_grp_id,
1622: p_plan_id => p_plan_id,
1623: p_effective_date_option => p_effective_date_option);
1624: hr_utility.trace('bdefore writing Txn in update_asg');
1625: hr_utility.trace('p_manager_details_tab.count=' || p_manager_details_tab.count);
1626: -- third call write transactions to write to transaction tables
1627: FOR I IN 1 ..p_manager_details_tab.count LOOP
1628:

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

1621: p_rptg_grp_id => p_rptg_grp_id,
1622: p_plan_id => p_plan_id,
1623: p_effective_date_option => p_effective_date_option);
1624: hr_utility.trace('bdefore writing Txn in update_asg');
1625: hr_utility.trace('p_manager_details_tab.count=' || p_manager_details_tab.count);
1626: -- third call write transactions to write to transaction tables
1627: FOR I IN 1 ..p_manager_details_tab.count LOOP
1628:
1629: -- Assignment Security

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

1659: -- now commit the transaction table data
1660: commit;
1661: END IF;
1662: p_transaction_step_id := l_transaction_step_id;
1663: hr_utility.set_location('Leaving'|| l_proc,15);
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1667:

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

1662: p_transaction_step_id := l_transaction_step_id;
1663: hr_utility.set_location('Leaving'|| l_proc,15);
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1667:
1668: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1669: hr_utility.raise_error;
1670: hr_utility.set_location('Leaving'|| l_proc,10);

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

1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1667:
1668: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1669: hr_utility.raise_error;
1670: hr_utility.set_location('Leaving'|| l_proc,10);
1671: END update_asg;
1672:

Line 1669: hr_utility.raise_error;

1665: WHEN OTHERS THEN
1666: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1667:
1668: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1669: hr_utility.raise_error;
1670: hr_utility.set_location('Leaving'|| l_proc,10);
1671: END update_asg;
1672:
1673:

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

1666: hr_utility.set_location('EXCEPTION'|| l_proc,555);
1667:
1668: hr_utility.set_message('PER', SQLERRM ||' '||to_char(SQLCODE));
1669: hr_utility.raise_error;
1670: hr_utility.set_location('Leaving'|| l_proc,10);
1671: END update_asg;
1672:
1673:
1674: /*

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

1835: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1836:
1837: l_proc constant varchar2(100) := g_package || ' update_asg';
1838: BEGIN
1839: hr_utility.set_location('Entering'|| l_proc,5);
1840: SAVEPOINT sup_update_asg;
1841: l_attribute_update_mode := p_attribute_update_mode;
1842: l_assignment_id := p_assignment_id;
1843:

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

1857: l_supervisor_id := p_supervisor_id;
1858: l_supervisor_assignment_id := p_supervisor_assignment_id;
1859: --Validate the p_supervisor_id
1860: if l_supervisor_id is not null then
1861: hr_utility.trace('In ( if l_supervisor_id is not null )'|| l_proc);
1862: open csr_person;
1863: fetch csr_person into l_supervisor_id;
1864: if csr_person%notfound then
1865: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);

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

1861: hr_utility.trace('In ( if l_supervisor_id is not null )'|| l_proc);
1862: open csr_person;
1863: fetch csr_person into l_supervisor_id;
1864: if csr_person%notfound then
1865: hr_utility.trace('In ( if csr_person%notfound )'|| l_proc);
1866: hr_new_user_reg_ss.processNewUserTransaction
1867: (WfItemType => p_item_type
1868: ,WfItemKey => p_item_key
1869: ,PersonId => l_supervisor_id

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

1903:
1904: if (l_current_applicant_flag = 'Y' AND
1905: nvl(l_current_employee_flag, 'N') <> 'Y' AND
1906: nvl(l_current_npw_flag, 'N') <> 'Y') then
1907: hr_utility.trace('In ( if of checking Case1 mode )'|| l_proc);
1908: g_applicant_hire := true;
1909: isApplicantSubordinate := false;
1910: l_applicant_person_id := p_supervisor_id;
1911: -- Get the assignment_id for the applicant from workflow

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

1934: ,l_person_id;
1935: close asg_appl_rec_assign_manager;
1936:
1937: if(l_appl_assignment_type = 'A') then
1938: hr_utility.trace('In ( if (l_appl_assignment_type = A )'|| l_proc);
1939: g_applicant_hire := true;
1940: isApplicantSubordinate := false;
1941: -- Get the person_id from assignment record.
1942: l_applicant_person_id := l_person_id;

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

1953: close per_applicant_rec;
1954: end if;
1955:
1956: if (g_applicant_hire) then
1957: hr_utility.trace('In ( if of g_applicant_hire )'|| l_proc);
1958: -- SAVEPOINT applicant_hire;
1959:
1960: -- get the employee number from Basic Details Step
1961: /*hr_person_info_util_ss.get_trns_employee_number(

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

2021: if (g_applicant_hire) then
2022: g_applicant_hire := false;
2023: --rollback to applicant_hire;
2024: end if;
2025: hr_utility.set_location('Leaving'|| l_proc,40);
2026: ROLLBACK TO sup_update_asg;
2027:
2028: EXCEPTION
2029: WHEN hr_utility.hr_error THEN

Line 2029: WHEN hr_utility.hr_error THEN

2025: hr_utility.set_location('Leaving'|| l_proc,40);
2026: ROLLBACK TO sup_update_asg;
2027:
2028: EXCEPTION
2029: WHEN hr_utility.hr_error THEN
2030: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2031: -- -------------------------------------------
2032: -- an application error has been raised so we must
2033: -- redisplay the web form to display the error

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

2026: ROLLBACK TO sup_update_asg;
2027:
2028: EXCEPTION
2029: WHEN hr_utility.hr_error THEN
2030: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2031: -- -------------------------------------------
2032: -- an application error has been raised so we must
2033: -- redisplay the web form to display the error
2034: -- --------------------------------------------

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

2038: p_error_message_name := hr_message.last_message_name;
2039: p_error_message := null;
2040:
2041: WHEN OTHERS THEN
2042: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2043: -- applicant_hire
2044: if (g_applicant_hire) then
2045: g_applicant_hire := false;
2046: -- rollback to applicant_hire;

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

2044: if (g_applicant_hire) then
2045: g_applicant_hire := false;
2046: -- rollback to applicant_hire;
2047: end if;
2048: IF (hr_utility.get_message IS NOT NULL) THEN
2049: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2050: hr_utility.get_message;
2051: ELSE
2052: p_error_message := hr_message.get_message_text;

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

2045: g_applicant_hire := false;
2046: -- rollback to applicant_hire;
2047: end if;
2048: IF (hr_utility.get_message IS NOT NULL) THEN
2049: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2050: hr_utility.get_message;
2051: ELSE
2052: p_error_message := hr_message.get_message_text;
2053: END IF;

Line 2050: hr_utility.get_message;

2046: -- rollback to applicant_hire;
2047: end if;
2048: IF (hr_utility.get_message IS NOT NULL) THEN
2049: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2050: hr_utility.get_message;
2051: ELSE
2052: p_error_message := hr_message.get_message_text;
2053: END IF;
2054: p_error_message_appl := null;