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_SP_STAGE dependencies on HR_UTILITY

Line 35: hr_utility.set_location('Creating createHRApiTransaction',10);

31: and PROCESS_NAME='HR_SP_APPROVAL_PRC';
32:
33: begin
34:
35: hr_utility.set_location('Creating createHRApiTransaction',10);
36:
37: open csrHrApiTxnId;
38: fetch csrHrApiTxnId into p_hr_api_txn_id;
39: close csrHrApiTxnId;

Line 41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);

37: open csrHrApiTxnId;
38: fetch csrHrApiTxnId into p_hr_api_txn_id;
39: close csrHrApiTxnId;
40:
41: hr_utility.set_location('p_hr_api_txn_id:'||p_hr_api_txn_id,15);
42:
43: if p_hr_api_txn_id is null then
44: p_hr_api_txn_id := HR_API_TRANSACTIONS_S.NEXTVAL;
45:

Line 61: hr_utility.set_location('Leaving createHRApiTransaction',10);

57: end if;
58:
59: commit;
60:
61: hr_utility.set_location('Leaving createHRApiTransaction',10);
62:
63: exception
64: when others then
65: hr_utility.set_location('issues in createHRApiTransaction',99);

Line 65: hr_utility.set_location('issues in createHRApiTransaction',99);

61: hr_utility.set_location('Leaving createHRApiTransaction',10);
62:
63: exception
64: when others then
65: hr_utility.set_location('issues in createHRApiTransaction',99);
66: raise;
67:
68: end createHRApiTransaction;
69:

Line 82: hr_utility.set_location('Creating cet row',10);

78: p_copy_entity_txn_id out nocopy number) is
79: l_sp_txn_cat number;
80: l_ovn number;
81: begin
82: hr_utility.set_location('Creating cet row',10);
83: begin
84:
85: select transaction_category_id
86: into l_sp_txn_cat

Line 91: hr_utility.set_location('txn_cat is'||l_sp_txn_cat,100);

87: from pqh_transaction_categories
88: where short_name ='SP'
89: and business_group_id is null;
90:
91: hr_utility.set_location('txn_cat is'||l_sp_txn_cat,100);
92: exception
93: when others then
94: hr_utility.set_location('txn_cat doesnot exist',100);
95: raise;

Line 94: hr_utility.set_location('txn_cat doesnot exist',100);

90:
91: hr_utility.set_location('txn_cat is'||l_sp_txn_cat,100);
92: exception
93: when others then
94: hr_utility.set_location('txn_cat doesnot exist',100);
95: raise;
96: end;
97: if l_sp_txn_cat is not null then
98: pqh_copy_entity_txns_api.create_COPY_ENTITY_TXN

Line 114: hr_utility.set_location('issues in creating CET row',100);

110: ,p_effective_date => trunc(sysdate));
111: end if;
112: exception
113: when others then
114: hr_utility.set_location('issues in creating CET row',100);
115: raise;
116: end create_sp_txn;
117:
118: --

Line 132: hr_utility.set_location('creating cet row',10);

128: l_cer_id number;
129: l_cer_ovn number;
130: begin
131:
132: hr_utility.set_location('creating cet row',10);
133:
134: create_sp_txn(p_mode => 'CREATE',
135: p_business_group_id => p_business_group_id,
136: p_copy_entity_txn_id => l_cet_id);

Line 139: hr_utility.set_location('populate out params',10);

135: p_business_group_id => p_business_group_id,
136: p_copy_entity_txn_id => l_cet_id);
137:
138: if l_cet_id is not null then
139: hr_utility.set_location('populate out params',10);
140: p_copy_entity_txn_id := l_cet_id;
141: else
142: hr_utility.set_location('cet row is not there',10);
143: end if;

Line 142: hr_utility.set_location('cet row is not there',10);

138: if l_cet_id is not null then
139: hr_utility.set_location('populate out params',10);
140: p_copy_entity_txn_id := l_cet_id;
141: else
142: hr_utility.set_location('cet row is not there',10);
143: end if;
144:
145:
146: end create_sp;

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

286: l_effective_date DATE;
287:
288:
289: begin
290: hr_utility.set_location('Entering: '||l_proc,10);
291: l_effective_date := TRUNC(p_effective_date);
292:
293:
294: --

Line 304: hr_utility.trace('Inserting the new Succession Plan: '||i.plan_name);

300:
301: FOR i IN csr_spp_stage(p_copy_entity_txn_id)
302: LOOP
303: IF i.dml_operation = 'CREATE' THEN
304: hr_utility.trace('Inserting the new Succession Plan: '||i.plan_name);
305: hr_utility.set_location(l_proc,15);
306: per_sp_plan_api.create_sp_plan(p_validate => false
307: ,p_effective_date => l_effective_date
308: ,p_plan_type => i.plan_type

Line 305: hr_utility.set_location(l_proc,15);

301: FOR i IN csr_spp_stage(p_copy_entity_txn_id)
302: LOOP
303: IF i.dml_operation = 'CREATE' THEN
304: hr_utility.trace('Inserting the new Succession Plan: '||i.plan_name);
305: hr_utility.set_location(l_proc,15);
306: per_sp_plan_api.create_sp_plan(p_validate => false
307: ,p_effective_date => l_effective_date
308: ,p_plan_type => i.plan_type
309: ,p_plan_name => i.plan_name

Line 345: hr_utility.set_location(l_proc,20);

341: ,p_attribute19 => i.attribute19
342: ,p_attribute20 => i.attribute20
343: ,p_plan_id => l_spp_id
344: ,p_object_version_number => l_spp_ovn);
345: hr_utility.set_location(l_proc,20);
346: ELSIF i.dml_operation = 'UPDATE' THEN
347: hr_utility.trace('Updating the new Succession Plan: '||i.plan_name);
348: l_spp_id := i.plan_id;
349: l_spp_ovn := i.object_version_number;

Line 347: hr_utility.trace('Updating the new Succession Plan: '||i.plan_name);

343: ,p_plan_id => l_spp_id
344: ,p_object_version_number => l_spp_ovn);
345: hr_utility.set_location(l_proc,20);
346: ELSIF i.dml_operation = 'UPDATE' THEN
347: hr_utility.trace('Updating the new Succession Plan: '||i.plan_name);
348: l_spp_id := i.plan_id;
349: l_spp_ovn := i.object_version_number;
350: hr_utility.set_location(l_proc,25);
351: per_sp_plan_api.update_sp_plan(p_validate => false

Line 350: hr_utility.set_location(l_proc,25);

346: ELSIF i.dml_operation = 'UPDATE' THEN
347: hr_utility.trace('Updating the new Succession Plan: '||i.plan_name);
348: l_spp_id := i.plan_id;
349: l_spp_ovn := i.object_version_number;
350: hr_utility.set_location(l_proc,25);
351: per_sp_plan_api.update_sp_plan(p_validate => false
352: ,p_effective_date => l_effective_date
353: ,p_plan_type => i.plan_type
354: ,p_plan_name => i.plan_name

Line 390: hr_utility.set_location(l_proc,30);

386: ,p_attribute19 => i.attribute19
387: ,p_attribute20 => i.attribute20
388: ,p_plan_id => l_spp_id
389: ,p_object_version_number => l_spp_ovn);
390: hr_utility.set_location(l_proc,30);
391: ELSIF i.dml_operation = 'DELETE' THEN
392: hr_utility.trace('Deleting the new Succession Plan: '||i.plan_name);
393: l_spp_id := i.plan_id;
394: l_spp_ovn := i.object_version_number;

Line 392: hr_utility.trace('Deleting the new Succession Plan: '||i.plan_name);

388: ,p_plan_id => l_spp_id
389: ,p_object_version_number => l_spp_ovn);
390: hr_utility.set_location(l_proc,30);
391: ELSIF i.dml_operation = 'DELETE' THEN
392: hr_utility.trace('Deleting the new Succession Plan: '||i.plan_name);
393: l_spp_id := i.plan_id;
394: l_spp_ovn := i.object_version_number;
395: hr_utility.set_location(l_proc,35);
396: FOR j IN csr_sip_stage(p_copy_entity_txn_id, i.copy_entity_result_id)

Line 395: hr_utility.set_location(l_proc,35);

391: ELSIF i.dml_operation = 'DELETE' THEN
392: hr_utility.trace('Deleting the new Succession Plan: '||i.plan_name);
393: l_spp_id := i.plan_id;
394: l_spp_ovn := i.object_version_number;
395: hr_utility.set_location(l_proc,35);
396: FOR j IN csr_sip_stage(p_copy_entity_txn_id, i.copy_entity_result_id)
397: LOOP
398: hr_utility.set_location(l_proc,38);
399: IF j.successor_in_plan_id IS NOT NULL AND j.object_version_number IS NOT NULL THEN

Line 398: hr_utility.set_location(l_proc,38);

394: l_spp_ovn := i.object_version_number;
395: hr_utility.set_location(l_proc,35);
396: FOR j IN csr_sip_stage(p_copy_entity_txn_id, i.copy_entity_result_id)
397: LOOP
398: hr_utility.set_location(l_proc,38);
399: IF j.successor_in_plan_id IS NOT NULL AND j.object_version_number IS NOT NULL THEN
400: per_successor_in_plan_api.delete_successor_in_plan(p_validate => false
401: ,p_successor_in_plan_id => j.successor_in_plan_id
402: ,p_object_version_number => j.object_version_number);

Line 404: hr_utility.set_location(l_proc,39);

400: per_successor_in_plan_api.delete_successor_in_plan(p_validate => false
401: ,p_successor_in_plan_id => j.successor_in_plan_id
402: ,p_object_version_number => j.object_version_number);
403: END IF;
404: hr_utility.set_location(l_proc,39);
405: END LOOP;
406: per_sp_plan_api.delete_sp_plan(p_validate => false
407: ,p_plan_id => l_spp_id
408: ,p_object_version_number => l_spp_ovn);

Line 409: hr_utility.set_location(l_proc,40);

405: END LOOP;
406: per_sp_plan_api.delete_sp_plan(p_validate => false
407: ,p_plan_id => l_spp_id
408: ,p_object_version_number => l_spp_ovn);
409: hr_utility.set_location(l_proc,40);
410:
411: ELSIF i.dml_operation = 'COPIED' THEN
412: l_spp_id := i.plan_id;
413:

Line 415: hr_utility.trace('Invaid SPP dml_operation:'||i.dml_operation||'-'||l_proc);

411: ELSIF i.dml_operation = 'COPIED' THEN
412: l_spp_id := i.plan_id;
413:
414: ELSE
415: hr_utility.trace('Invaid SPP dml_operation:'||i.dml_operation||'-'||l_proc);
416: END IF;
417: IF i.dml_operation IN ('CREATE','UPDATE') THEN
418: FOR j IN csr_sip_stage(p_copy_entity_txn_id, i.copy_entity_result_id)
419: LOOP

Line 421: hr_utility.set_location(l_proc,45);

417: IF i.dml_operation IN ('CREATE','UPDATE') THEN
418: FOR j IN csr_sip_stage(p_copy_entity_txn_id, i.copy_entity_result_id)
419: LOOP
420: IF j.dml_operation = 'CREATE' THEN
421: hr_utility.set_location(l_proc,45);
422: per_successor_in_plan_api.create_successor_in_plan
423: (p_validate => false
424: ,p_effective_date => l_effective_date
425: ,p_plan_id => l_spp_id

Line 482: hr_utility.set_location(l_proc,50);

478: ,p_location_id => j.location_id
479: ,p_contract_id => j.contract_id
480: ,p_successor_in_plan_id => l_sip_id
481: ,p_object_version_number => l_sip_ovn);
482: hr_utility.set_location(l_proc,50);
483:
484:
485: ELSIF j.dml_operation = 'UPDATE' THEN
486: hr_utility.set_location(l_proc,55);

Line 486: hr_utility.set_location(l_proc,55);

482: hr_utility.set_location(l_proc,50);
483:
484:
485: ELSIF j.dml_operation = 'UPDATE' THEN
486: hr_utility.set_location(l_proc,55);
487: l_sip_id := j.successor_in_plan_id;
488: l_sip_ovn := j.object_version_number;
489: per_successor_in_plan_api.update_successor_in_plan
490: (p_validate => false

Line 549: hr_utility.set_location(l_proc,50);

545: ,p_location_id => j.location_id
546: ,p_contract_id => j.contract_id
547: ,p_successor_in_plan_id => l_sip_id
548: ,p_object_version_number => l_sip_ovn);
549: hr_utility.set_location(l_proc,50);
550:
551: ELSIF j.dml_operation = 'DELETE' THEN
552: per_successor_in_plan_api.delete_successor_in_plan(p_validate => false
553: ,p_successor_in_plan_id => j.successor_in_plan_id

Line 558: hr_utility.trace('Invaid SIP dml_operation:'||j.dml_operation||'-'||l_proc);

554: ,p_object_version_number => j.object_version_number);
555: ELSIF j.dml_operation = 'COPIED' THEN
556: l_sip_id := j.successor_in_plan_id;
557: ELSE
558: hr_utility.trace('Invaid SIP dml_operation:'||j.dml_operation||'-'||l_proc);
559: END IF;
560:
561: if j.dml_operation <> 'DELETE' then
562: --

Line 610: hr_utility.set_location('Leaving: '||l_proc,80);

606: --
607: -- A validation or unexpected error has occured
608: rollback to stage_to_sp;
609: raise;
610: hr_utility.set_location('Leaving: '||l_proc,80);
611: end stage_to_sp;
612:
613: --
614: -- ---------------------------------------------------------------------------

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

741:
742:
743: begin
744:
745: hr_utility.set_location('Entering:'||l_proc,10);
746: hr_utility.trace('p_plan_id : '||p_plan_id);
747: hr_utility.trace('p_business_group_id: '||p_business_group_id);
748: hr_utility.trace('p_mode:'||p_mode);
749:

Line 746: hr_utility.trace('p_plan_id : '||p_plan_id);

742:
743: begin
744:
745: hr_utility.set_location('Entering:'||l_proc,10);
746: hr_utility.trace('p_plan_id : '||p_plan_id);
747: hr_utility.trace('p_business_group_id: '||p_business_group_id);
748: hr_utility.trace('p_mode:'||p_mode);
749:
750: l_business_group_id :=p_business_group_id;

Line 747: hr_utility.trace('p_business_group_id: '||p_business_group_id);

743: begin
744:
745: hr_utility.set_location('Entering:'||l_proc,10);
746: hr_utility.trace('p_plan_id : '||p_plan_id);
747: hr_utility.trace('p_business_group_id: '||p_business_group_id);
748: hr_utility.trace('p_mode:'||p_mode);
749:
750: l_business_group_id :=p_business_group_id;
751:

Line 748: hr_utility.trace('p_mode:'||p_mode);

744:
745: hr_utility.set_location('Entering:'||l_proc,10);
746: hr_utility.trace('p_plan_id : '||p_plan_id);
747: hr_utility.trace('p_business_group_id: '||p_business_group_id);
748: hr_utility.trace('p_mode:'||p_mode);
749:
750: l_business_group_id :=p_business_group_id;
751:
752: IF p_business_group_id IS NULL

Line 761: hr_utility.trace('Copy Entity Txn Id: '||l_copy_entity_txn_id);

757:
758: create_sp(p_business_group_id => l_business_group_id,
759: p_copy_entity_txn_id => l_copy_entity_txn_id);
760:
761: hr_utility.trace('Copy Entity Txn Id: '||l_copy_entity_txn_id);
762:
763:
764:
765: FOR i IN csr_sp_rec(p_plan_id)

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

1016: END LOOP;
1017: END LOOP;
1018:
1019: p_copy_entity_txn_id := l_copy_entity_txn_id;
1020: hr_utility.set_location('Leaving: '||l_proc,30);
1021: EXCEPTION
1022: WHEN Others THEN
1023: p_copy_entity_txn_id := NULL;
1024: hr_utility.trace('error in sp_to_stage');

Line 1024: hr_utility.trace('error in sp_to_stage');

1020: hr_utility.set_location('Leaving: '||l_proc,30);
1021: EXCEPTION
1022: WHEN Others THEN
1023: p_copy_entity_txn_id := NULL;
1024: hr_utility.trace('error in sp_to_stage');
1025: hr_utility.trace(SqlErrm);
1026: hr_utility.set_location('Leaving: '||l_proc,40);
1027: Raise ;
1028: end sp_to_stage;

Line 1025: hr_utility.trace(SqlErrm);

1021: EXCEPTION
1022: WHEN Others THEN
1023: p_copy_entity_txn_id := NULL;
1024: hr_utility.trace('error in sp_to_stage');
1025: hr_utility.trace(SqlErrm);
1026: hr_utility.set_location('Leaving: '||l_proc,40);
1027: Raise ;
1028: end sp_to_stage;
1029:

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

1022: WHEN Others THEN
1023: p_copy_entity_txn_id := NULL;
1024: hr_utility.trace('error in sp_to_stage');
1025: hr_utility.trace(SqlErrm);
1026: hr_utility.set_location('Leaving: '||l_proc,40);
1027: Raise ;
1028: end sp_to_stage;
1029:
1030:

Line 1071: hr_utility.set_location('Leaving commit_transaction', 90);

1067: and process_name='HR_SP_APPROVAL_PRC';
1068:
1069: resultout:='COMPLETE:SUCCESS';
1070:
1071: hr_utility.set_location('Leaving commit_transaction', 90);
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: resultout:='COMPLETE:FAILURE';

Line 1098: hr_utility.set_location('ENTERING commit_transaction', 10);

1094: l_hrApiTxnId number;
1095: response varchar2(4000);
1096: begin
1097:
1098: hr_utility.set_location('ENTERING commit_transaction', 10);
1099:
1100: l_hrApiTxnId := wf_engine.GetItemAttrNumber(itemtype=> itemtype,itemkey=> itemkey,aname => 'TRANSACTION_ID' );
1101:
1102: response := wf_engine.getItemAttrText(itemtype=> itemtype,itemkey=> itemkey,aname => 'WF_NOTE' );

Line 1110: hr_utility.set_location('l_copy_entity_txn_id:'||l_copy_entity_txn_id, 40);

1106: from hr_api_transactions
1107: where transaction_id=l_hrApiTxnId
1108: and process_name='HR_SP_APPROVAL_PRC';
1109:
1110: hr_utility.set_location('l_copy_entity_txn_id:'||l_copy_entity_txn_id, 40);
1111:
1112: commit_txn(l_copy_entity_txn_id);
1113:
1114: hr_utility.set_location('delete from hr_api_transactions..', 50);

Line 1114: hr_utility.set_location('delete from hr_api_transactions..', 50);

1110: hr_utility.set_location('l_copy_entity_txn_id:'||l_copy_entity_txn_id, 40);
1111:
1112: commit_txn(l_copy_entity_txn_id);
1113:
1114: hr_utility.set_location('delete from hr_api_transactions..', 50);
1115:
1116: delete from hr_api_transactions
1117: where item_type=itemtype and item_key=itemkey;
1118:

Line 1121: hr_utility.set_location('Leaving commit_transaction', 90);

1117: where item_type=itemtype and item_key=itemkey;
1118:
1119: resultout:='COMPLETE:SUCCESS';
1120:
1121: hr_utility.set_location('Leaving commit_transaction', 90);
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: resultout:='COMPLETE:FAILURE';

Line 1141: hr_utility.set_location('ENTERING refresh_txn', 10);

1137:
1138:
1139: begin
1140:
1141: hr_utility.set_location('ENTERING refresh_txn', 10);
1142:
1143:
1144: --
1145: -- Purge data from transaction tables.

Line 1161: hr_utility.set_location('leaving refresh_txn', 90);

1157: where transaction_ref_id = p_copy_entity_txn_id
1158: and process_name='HR_SP_APPROVAL_PRC';
1159:
1160:
1161: hr_utility.set_location('leaving refresh_txn', 90);
1162: end refresh_txn;
1163:
1164: --
1165: -- ---------------------------------------------------------------------------

Line 1175: hr_utility.set_location('ENTERING commit_txn', 10);

1171:
1172: plan_id number;
1173: begin
1174:
1175: hr_utility.set_location('ENTERING commit_txn', 10);
1176:
1177: stage_to_sp(trunc(sysdate), p_copy_entity_txn_id,'N');
1178:
1179: hr_utility.set_location('getting the plan Id....', 50);

Line 1179: hr_utility.set_location('getting the plan Id....', 50);

1175: hr_utility.set_location('ENTERING commit_txn', 10);
1176:
1177: stage_to_sp(trunc(sysdate), p_copy_entity_txn_id,'N');
1178:
1179: hr_utility.set_location('getting the plan Id....', 50);
1180:
1181: select distinct information1 into plan_id
1182: from ben_copy_entity_results
1183: where copy_entity_txn_id = p_copy_entity_txn_id

Line 1186: hr_utility.set_location('deleting from stage..PLAN:'||plan_id, 50);

1182: from ben_copy_entity_results
1183: where copy_entity_txn_id = p_copy_entity_txn_id
1184: and table_alias='SP';
1185:
1186: hr_utility.set_location('deleting from stage..PLAN:'||plan_id, 50);
1187:
1188: if plan_id is not null
1189: then
1190: --

Line 1217: hr_utility.set_location('leaving commit_txn', 90);

1213: and process_name='HR_SP_APPROVAL_PRC';
1214:
1215:
1216:
1217: hr_utility.set_location('leaving commit_txn', 90);
1218: end commit_txn;
1219:
1220: --
1221: -- ---------------------------------------------------------------------------

Line 1238: hr_utility.set_location('ENTERING get_approval_req', 10);

1234:
1235:
1236:
1237: BEGIN
1238: hr_utility.set_location('ENTERING get_approval_req', 10);
1239: IF (funcmode='RUN') THEN
1240:
1241:
1242:

Line 1261: hr_utility.trace('l_resultout' || resultout);

1257: resultout:='COMPLETE:Y';
1258:
1259:
1260: end if;
1261: hr_utility.trace('l_resultout' || resultout);
1262:
1263: RETURN;
1264: END IF; --RUN
1265:

Line 1273: hr_utility.set_location('ENTERING exception get_approval_req', 10);

1269: END IF;
1270: Exception
1271:
1272: when others then
1273: hr_utility.set_location('ENTERING exception get_approval_req', 10);
1274:
1275:
1276:
1277: end get_approval_req;

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

1323: and table_alias='SP';
1324:
1325: begin
1326:
1327: hr_utility.set_location('Entering:'||l_proc, 10);
1328:
1329: select transaction_id, item_key into l_hrApiTxnId, l_item_key
1330: from hr_api_transactions
1331: where TRANSACTION_REF_ID=p_copy_entity_txn_id

Line 1396: hr_utility.set_location(' l_role_name'||l_role_name,10);

1392: wf_engine.setItemOwner
1393: (itemtype => l_item_type
1394: ,itemkey => l_item_key
1395: ,owner => l_role_name);
1396: hr_utility.set_location(' l_role_name'||l_role_name,10);
1397:
1398:
1399:
1400: -- set 'CURRENT_EFFECTIVE_DATE'

Line 1401: hr_utility.set_location(' lr_transaction_rec.item_type'||l_item_type,50);

1397:
1398:
1399:
1400: -- set 'CURRENT_EFFECTIVE_DATE'
1401: hr_utility.set_location(' lr_transaction_rec.item_type'||l_item_type,50);
1402: hr_approval_ss.create_item_attrib_if_notexist(itemtype => l_item_type
1403: ,itemkey => l_item_key
1404: ,aname => 'CURRENT_EFFECTIVE_DATE'
1405: ,text_value=>null

Line 1432: hr_utility.set_location('started process:'||l_proc, 20);

1428:
1429:
1430: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1431:
1432: hr_utility.set_location('started process:'||l_proc, 20);
1433:
1434:
1435: -- check the wf status before returning the status back to caller
1436: -- we need to check if the flow is in error state or not

Line 1458: hr_utility.set_location('leaving:'||l_proc, 90);

1454: where copy_entity_txn_id=p_copy_entity_txn_id
1455: and table_alias='SP'
1456: and status='W';
1457:
1458: hr_utility.set_location('leaving:'||l_proc, 90);
1459: EXCEPTION
1460: WHEN OTHERS THEN
1461:
1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;