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

Line 144: g_debug := hr_utility.debug_enabled;

140: ln_appraisal_id number;
141: --
142: begin
143:
144: g_debug := hr_utility.debug_enabled;
145:
146: IF g_debug THEN
147: l_proc := gv_package||'start_transaction';
148: hr_utility.set_location('Entering:'|| l_proc, 5);

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

144: g_debug := hr_utility.debug_enabled;
145:
146: IF g_debug THEN
147: l_proc := gv_package||'start_transaction';
148: hr_utility.set_location('Entering:'|| l_proc, 5);
149: END IF;
150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);

Line 202: hr_utility.set_location('Entered:'|| gv_package || '.create_hr_transaction', 1);

198: l_main_appraiser_user_name wf_users.name%type;
199: l_display_name wf_users.display_name%type;
200:
201: begin
202: hr_utility.set_location('Entered:'|| gv_package || '.create_hr_transaction', 1);
203: -- get the appraisal_id from the item attribute , APPRAISAL_ID
204: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
205: itemkey => p_itemkey ,
206: aname => 'APPRAISAL_ID',

Line 272: hr_utility.set_location('Leaving:'|| gv_package || '.create_hr_transaction', 10);

268: setAppraisalSystemParams(p_itemtype,p_itemkey, p_actid, p_funcmode, p_result );
269: p_result:= wf_engine.eng_trans_default;
270:
271:
272: hr_utility.set_location('Leaving:'|| gv_package || '.create_hr_transaction', 10);
273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: wf_core.Context(gv_package, '.create_hr_transaction', p_itemtype, p_itemkey, p_actid, p_funcmode);

Line 277: hr_utility.trace(' exception in '||gv_package||'.create_hr_transaction : ' || sqlerrm);

273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: wf_core.Context(gv_package, '.create_hr_transaction', p_itemtype, p_itemkey, p_actid, p_funcmode);
277: hr_utility.trace(' exception in '||gv_package||'.create_hr_transaction : ' || sqlerrm);
278: raise;
279:
280: end create_hr_transaction;
281:

Line 300: g_debug := hr_utility.debug_enabled;

296: lv_addtnlParams VARCHAR2(30) ;
297:
298:
299: begin
300: g_debug := hr_utility.debug_enabled;
301: if g_debug then
302: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);
303: end if;
304:

Line 302: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);

298:
299: begin
300: g_debug := hr_utility.debug_enabled;
301: if g_debug then
302: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);
303: end if;
304:
305: -- get the itemtype and item key for the notification id
306: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);

Line 335: hr_utility.set_location('Unable to retrieve function details,web_html_call and parameters for:'||lv_pageFunc||' '|| gv_package||'.'||c_proc, 10);

331: from fnd_form_functions_vl
332: where function_name=lv_pageFunc;
333: exception
334: when no_data_found then
335: hr_utility.set_location('Unable to retrieve function details,web_html_call and parameters for:'||lv_pageFunc||' '|| gv_package||'.'||c_proc, 10);
336: when others then
337: raise;
338: end;
339: -- set the out variables

Line 356: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);

352: -- document := null;
353: -- end if;
354:
355: if g_debug then
356: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);
357: end if;
358:
359: exception
360: when others then

Line 363: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);

359: exception
360: when others then
361: document := null;
362: document_type :=null;
363: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
364: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
365: raise;
366: end build_link;
367:

Line 808: if(hr_utility.debug_enabled) then

804: begin
805: ln_appr_main_block_id := wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR');
806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');
807: begin
808: if(hr_utility.debug_enabled) then
809: -- write debug statements
810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);
811: end if;
812:

Line 810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);

806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');
807: begin
808: if(hr_utility.debug_enabled) then
809: -- write debug statements
810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);
811: end if;
812:
813: SELECT process_activity
814: into ln_appr_approval_block_id

Line 824: if(hr_utility.debug_enabled) then

820: (getApprovalBlockId.ln_appr_main_block_id,getApprovalBlockId.ln_appr_particp_block_id);
821:
822: exception
823: when no_data_found then
824: if(hr_utility.debug_enabled) then
825: -- write debug statements
826: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES for itemtype:'|| p_itemType||' and item key:'||p_itemType, 4);
827: end if;
828: ln_appr_approval_block_id := null;

Line 826: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES for itemtype:'|| p_itemType||' and item key:'||p_itemType, 4);

822: exception
823: when no_data_found then
824: if(hr_utility.debug_enabled) then
825: -- write debug statements
826: hr_utility.set_location('no notified activity found in WF_ITEM_ACTIVITY_STATUSES for itemtype:'|| p_itemType||' and item key:'||p_itemType, 4);
827: end if;
828: ln_appr_approval_block_id := null;
829: when others then
830: ln_appr_approval_block_id := null;

Line 847: hr_utility.trace(' exception in '||gv_package||'.getApprovalBlockId : ' || sqlerrm);

843: end if;
844: exception
845: when no_data_found then
846: wf_core.Context(gv_package, '.getApprovalBlockId', p_itemtype, p_itemkey);
847: hr_utility.trace(' exception in '||gv_package||'.getApprovalBlockId : ' || sqlerrm);
848: when others then
849: raise;
850: end;
851: p_blockId := ln_appr_approval_block_id;

Line 855: hr_utility.trace(' exception in '||gv_package||'.getApprovalBlockId : ' || sqlerrm);

851: p_blockId := ln_appr_approval_block_id;
852: exception
853: when others then
854: wf_core.Context(gv_package, '.getApprovalBlockId', p_itemtype, p_itemkey);
855: hr_utility.trace(' exception in '||gv_package||'.getApprovalBlockId : ' || sqlerrm);
856: raise;
857: end getApprovalBlockId;
858:
859:

Line 876: hr_utility.set_location('Entered:'|| gv_package || '.reset_main_appraiser', 1);

872: l_role_name varchar2(320);
873: l_role_displayname varchar2(360);
874:
875: begin
876: hr_utility.set_location('Entered:'|| gv_package || '.reset_main_appraiser', 1);
877: -- get the appraisal_id from the item attribute , APPRAISAL_ID
878: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
879: itemkey => p_itemkey ,
880: aname => 'APPRAISAL_ID',

Line 924: hr_utility.set_location('Leaving:'|| gv_package || '.reset_main_appraiser', 10);

920: p_result := wf_engine.eng_trans_default;
921:
922:
923:
924: hr_utility.set_location('Leaving:'|| gv_package || '.reset_main_appraiser', 10);
925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: wf_core.Context(gv_package, '.reset_main_appraiser', p_itemtype, p_itemkey, p_actid, p_funcmode);

Line 929: hr_utility.trace(' exception in '||gv_package||'.reset_main_appraiser : ' || sqlerrm);

925:
926: EXCEPTION
927: WHEN OTHERS THEN
928: wf_core.Context(gv_package, '.reset_main_appraiser', p_itemtype, p_itemkey, p_actid, p_funcmode);
929: hr_utility.trace(' exception in '||gv_package||'.reset_main_appraiser : ' || sqlerrm);
930: raise;
931:
932: end reset_main_appraiser;
933:

Line 946: hr_utility.set_location('Entered:'|| gv_package || '.commit_transaction', 1);

942: -- local variables
943: l_appraisal_id per_appraisals.appraisal_id%type;
944: lv_result varchar2(3);
945: begin
946: hr_utility.set_location('Entered:'|| gv_package || '.commit_transaction', 1);
947: hr_utility.set_location('calling hr_complete_appraisal_ss.complete_appr', 2);
948: hr_complete_appraisal_ss.complete_appr(p_itemtype,p_itemkey,lv_result);
949: hr_utility.set_location('returned from hr_complete_appraisal_ss.complete_appr with result:'
950: ||lv_result, 3);

Line 947: hr_utility.set_location('calling hr_complete_appraisal_ss.complete_appr', 2);

943: l_appraisal_id per_appraisals.appraisal_id%type;
944: lv_result varchar2(3);
945: begin
946: hr_utility.set_location('Entered:'|| gv_package || '.commit_transaction', 1);
947: hr_utility.set_location('calling hr_complete_appraisal_ss.complete_appr', 2);
948: hr_complete_appraisal_ss.complete_appr(p_itemtype,p_itemkey,lv_result);
949: hr_utility.set_location('returned from hr_complete_appraisal_ss.complete_appr with result:'
950: ||lv_result, 3);
951: /*

Line 949: hr_utility.set_location('returned from hr_complete_appraisal_ss.complete_appr with result:'

945: begin
946: hr_utility.set_location('Entered:'|| gv_package || '.commit_transaction', 1);
947: hr_utility.set_location('calling hr_complete_appraisal_ss.complete_appr', 2);
948: hr_complete_appraisal_ss.complete_appr(p_itemtype,p_itemkey,lv_result);
949: hr_utility.set_location('returned from hr_complete_appraisal_ss.complete_appr with result:'
950: ||lv_result, 3);
951: /*
952: E : Error -- ntf to MA, HR/Sysadmin
953: W : Warning -- ntf MA

Line 961: hr_utility.set_location('Leaving:'|| gv_package || '.commit_transaction', 10);

957: p_result:= 'COMPLETE:SUCCESS';
958: else
959: p_result:= 'COMPLETE:APPLICATION_ERROR';
960: end if;
961: hr_utility.set_location('Leaving:'|| gv_package || '.commit_transaction', 10);
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: wf_core.Context(gv_package, '.commit_transaction', p_itemtype, p_itemkey, p_actid, p_funcmode);

Line 966: hr_utility.trace(' exception in '||gv_package||'.commit_transaction : ' || sqlerrm);

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: wf_core.Context(gv_package, '.commit_transaction', p_itemtype, p_itemkey, p_actid, p_funcmode);
966: hr_utility.trace(' exception in '||gv_package||'.commit_transaction : ' || sqlerrm);
967: raise;
968:
969: end commit_transaction;
970:

Line 986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);

982: l_object_version_number per_appraisals.object_version_number%type;
983: l_system_params per_appraisals.system_params%type;
984:
985: begin
986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);
987: -- get the appraisal_id from the item attribute , APPRAISAL_ID
988: if(hr_utility.debug_enabled) then
989: -- write debug statements
990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);

Line 988: if(hr_utility.debug_enabled) then

984:
985: begin
986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);
987: -- get the appraisal_id from the item attribute , APPRAISAL_ID
988: if(hr_utility.debug_enabled) then
989: -- write debug statements
990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);
991: end if;
992: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

Line 990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);

986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);
987: -- get the appraisal_id from the item attribute , APPRAISAL_ID
988: if(hr_utility.debug_enabled) then
989: -- write debug statements
990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);
991: end if;
992: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
993: itemkey => p_itemkey ,
994: aname => 'APPRAISAL_ID',

Line 1008: if(hr_utility.debug_enabled) then

1004: when others then
1005: raise;
1006: end;
1007: -- call the api to update the system status
1008: if(hr_utility.debug_enabled) then
1009: -- write debug statements
1010: hr_utility.set_location('Calling hr_appraisals_api.update_appraisal with p_appraisal_id:
1011: p_object_version_number:p_appraiser_person_id:p_appraisal_system_status '
1012: || l_appraisal_id||':'||l_object_version_number||':'

Line 1010: hr_utility.set_location('Calling hr_appraisals_api.update_appraisal with p_appraisal_id:

1006: end;
1007: -- call the api to update the system status
1008: if(hr_utility.debug_enabled) then
1009: -- write debug statements
1010: hr_utility.set_location('Calling hr_appraisals_api.update_appraisal with p_appraisal_id:
1011: p_object_version_number:p_appraiser_person_id:p_appraisal_system_status '
1012: || l_appraisal_id||':'||l_object_version_number||':'
1013: ||l_appraiser_person_id||p_status,3);
1014: end if;

Line 1024: hr_utility.set_location('Leaving:'|| gv_package || '.update_appraisal_system_status', 10);

1020: p_appraisal_system_status=>p_status --7210916 Bug Fix ,
1021: --p_system_params => l_system_params
1022: );
1023:
1024: hr_utility.set_location('Leaving:'|| gv_package || '.update_appraisal_system_status', 10);
1025:
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: wf_core.Context(gv_package, '.update_appraisal_system_status', p_itemtype, p_itemkey);

Line 1029: hr_utility.trace(' exception in '||gv_package||'.update_appraisal_system_status : ' || sqlerrm);

1025:
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: wf_core.Context(gv_package, '.update_appraisal_system_status', p_itemtype, p_itemkey);
1029: hr_utility.trace(' exception in '||gv_package||'.update_appraisal_system_status : ' || sqlerrm);
1030: raise;
1031:
1032: end update_appraisal_system_status;
1033:

Line 1045: hr_utility.set_location('Entered:'|| gv_package || '.set_appraisal_rfc_status', 1);

1041: is
1042: -- local variables
1043:
1044: begin
1045: hr_utility.set_location('Entered:'|| gv_package || '.set_appraisal_rfc_status', 1);
1046:
1047: -- call the update_appraisal_system_status with proper status
1048: update_appraisal_system_status(p_itemtype=>p_itemtype, p_itemkey=>p_itemkey,p_status=>'RFC');
1049:

Line 1050: hr_utility.set_location('Leaving:'|| gv_package || '.set_appraisal_rfc_status', 10);

1046:
1047: -- call the update_appraisal_system_status with proper status
1048: update_appraisal_system_status(p_itemtype=>p_itemtype, p_itemkey=>p_itemkey,p_status=>'RFC');
1049:
1050: hr_utility.set_location('Leaving:'|| gv_package || '.set_appraisal_rfc_status', 10);
1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: wf_core.Context(gv_package, '.set_appraisal_rfc_status', p_itemtype, p_itemkey, p_actid, p_funcmode);

Line 1055: hr_utility.trace(' exception in '||gv_package||'.set_appraisal_rfc_status : ' || sqlerrm);

1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: wf_core.Context(gv_package, '.set_appraisal_rfc_status', p_itemtype, p_itemkey, p_actid, p_funcmode);
1055: hr_utility.trace(' exception in '||gv_package||'.set_appraisal_rfc_status : ' || sqlerrm);
1056: raise;
1057:
1058: end set_appraisal_rfc_status;
1059:

Line 1087: hr_utility.set_location ('Entered:' || gv_package || '.set_appraisal_reject_status', 1);

1083: prll_ntf VARCHAR2 (600) DEFAULT NULL;
1084: l_txn_id NUMBER;
1085: l_appr_list_clear_on_reject VARCHAR2 (3) := 'Y';
1086: BEGIN
1087: hr_utility.set_location ('Entered:' || gv_package || '.set_appraisal_reject_status', 1);
1088: -- call the update_appraisal_system_status with proper status
1089: update_appraisal_system_status (p_itemtype => p_itemtype, p_itemkey => p_itemkey, p_status => 'ONGOING');
1090:
1091: --- Added for fixing bug#11661757

Line 1154: hr_utility.set_location ('Leaving:' || gv_package || '.set_appraisal_reject_status', 10);

1150: );
1151: END IF;
1152: END IF;
1153:
1154: hr_utility.set_location ('Leaving:' || gv_package || '.set_appraisal_reject_status', 10);
1155: EXCEPTION
1156: WHEN OTHERS
1157: THEN
1158: wf_core.CONTEXT (gv_package, '.set_appraisal_reject_status', p_itemtype, p_itemkey, p_actid, p_funcmode);

Line 1159: hr_utility.TRACE (' exception in ' || gv_package || '.set_appraisal_reject_status : ' || SQLERRM);

1155: EXCEPTION
1156: WHEN OTHERS
1157: THEN
1158: wf_core.CONTEXT (gv_package, '.set_appraisal_reject_status', p_itemtype, p_itemkey, p_actid, p_funcmode);
1159: hr_utility.TRACE (' exception in ' || gv_package || '.set_appraisal_reject_status : ' || SQLERRM);
1160: RAISE;
1161: END set_appraisal_reject_status;
1162:
1163:

Line 1176: hr_utility.set_location('Entered:'|| gv_package || '.notify_appraisee_on_completion', 1);

1172: is
1173: -- local variables
1174:
1175: begin
1176: hr_utility.set_location('Entered:'|| gv_package || '.notify_appraisee_on_completion', 1);
1177: --bug 4403850, to support old appraisals on upgrade, set the appraisal system status to COMPLETED,
1178: -- if APPRFEEDBACK
1179: appraisee_commit_aft_feedback(p_itemtype, p_itemkey, p_actid, p_funcmode, p_result);
1180: hr_complete_appraisal_ss.send_notification(p_itemtype,

Line 1183: hr_utility.set_location('Leaving:'|| gv_package || '.set_appraisal_commit_status', 10);

1179: appraisee_commit_aft_feedback(p_itemtype, p_itemkey, p_actid, p_funcmode, p_result);
1180: hr_complete_appraisal_ss.send_notification(p_itemtype,
1181: p_itemkey,
1182: p_result);
1183: hr_utility.set_location('Leaving:'|| gv_package || '.set_appraisal_commit_status', 10);
1184:
1185:
1186: EXCEPTION
1187: WHEN OTHERS THEN

Line 1189: hr_utility.trace(' exception in '||gv_package||'.notify_appraisee_on_completion : ' || sqlerrm);

1185:
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: wf_core.Context(gv_package, '.notify_appraisee_on_completion', p_itemtype, p_itemkey, p_actid, p_funcmode);
1189: hr_utility.trace(' exception in '||gv_package||'.notify_appraisee_on_completion : ' || sqlerrm);
1190: raise;
1191:
1192: end notify_appraisee_on_completion;
1193:

Line 1203: g_debug := hr_utility.debug_enabled;

1199: c_proc varchar2(30) default 'build_ma_compl_log_msg';
1200: lv_item_type wf_item_activity_statuses.item_type%type;
1201: lv_item_key wf_item_activity_statuses.item_key%type;
1202: begin
1203: g_debug := hr_utility.debug_enabled;
1204: if g_debug then
1205: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);
1206: end if;
1207: -- get the itemtype and item key for the notification id

Line 1205: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);

1201: lv_item_key wf_item_activity_statuses.item_key%type;
1202: begin
1203: g_debug := hr_utility.debug_enabled;
1204: if g_debug then
1205: hr_utility.set_location('Entering:'|| gv_package||'.'||c_proc, 1);
1206: end if;
1207: -- get the itemtype and item key for the notification id
1208: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1209: -- build the log message, the log is restricted to 32k

Line 1232: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);

1228: -- set the document type
1229: document_type := wf_notification.doc_html;
1230:
1231: if g_debug then
1232: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);
1233: end if;
1234:
1235: exception
1236: when others then

Line 1239: hr_utility.set_location('hr_appraisal_workflow_ss.build_ma_compl_log_msg errored : '

1235: exception
1236: when others then
1237: document := null;
1238: document_type :=null;
1239: hr_utility.set_location('hr_appraisal_workflow_ss.build_ma_compl_log_msg errored : '
1240: ||SQLERRM ||' '||to_char(SQLCODE), 20);
1241: Wf_Core.Context('hr_workflow_ss', 'build_ma_compl_log_msg',
1242: document_id, display_type);
1243: raise;

Line 1277: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_feedback_allowed', 1);

1273: l_log varchar2(4000);
1274: lv_chg_appr_status_log wf_item_attributes.text_default%TYPE;
1275: chg_appr_status varchar2(2);
1276: begin
1277: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_feedback_allowed', 1);
1278:
1279: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
1280: itemkey => p_itemkey ,
1281: aname => 'APPRAISAL_ID',

Line 1286: hr_utility.trace(l_log);

1282: ignore_notfound=>true);
1283:
1284: if l_appraisal_id is null then
1285: l_log := l_log || 'Error: No Appraisal Id for this WorkFlow Transaction';
1286: hr_utility.trace(l_log);
1287: end if;
1288:
1289:
1290: hr_utility.trace('calling isAppraiseeFeebackAllowed');

Line 1290: hr_utility.trace('calling isAppraiseeFeebackAllowed');

1286: hr_utility.trace(l_log);
1287: end if;
1288:
1289:
1290: hr_utility.trace('calling isAppraiseeFeebackAllowed');
1291: chg_appr_status := isAppraiseeFeebackAllowed(p_appraisal_id => l_appraisal_id);
1292: hr_utility.trace('returned from isAppraiseeFeebackAllowed with result:'
1293: ||chg_appr_status);
1294:

Line 1292: hr_utility.trace('returned from isAppraiseeFeebackAllowed with result:'

1288:
1289:
1290: hr_utility.trace('calling isAppraiseeFeebackAllowed');
1291: chg_appr_status := isAppraiseeFeebackAllowed(p_appraisal_id => l_appraisal_id);
1292: hr_utility.trace('returned from isAppraiseeFeebackAllowed with result:'
1293: ||chg_appr_status);
1294:
1295: if ( chg_appr_status = 'Y' ) then
1296: p_result := 'COMPLETE:'||'Y' ; -- TBD shud be made 'Y' for testing

Line 1302: hr_utility.set_location('Exiting:'|| gv_package || '.appraisee_feedback_allowed', 1);

1298: p_result := 'COMPLETE:'||'N' ;
1299: end if;
1300:
1301:
1302: hr_utility.set_location('Exiting:'|| gv_package || '.appraisee_feedback_allowed', 1);
1303:
1304:
1305: exception
1306: when others then

Line 1309: hr_utility.trace('Exception in ' || gv_package || '.appraisee_feedback_allowed' ||

1305: exception
1306: when others then
1307: wf_core.Context(gv_package,'.appraisee_feedback_allowed',p_itemtype, p_itemkey
1308: , p_actid,p_funcmode );
1309: hr_utility.trace('Exception in ' || gv_package || '.appraisee_feedback_allowed' ||
1310: sqlerrm );
1311: raise ;
1312: end appraisee_feedback_allowed;
1313:

Line 1329: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_commit_aft_feedback', 1);

1325: l_log varchar2(4000);
1326: lv_chg_appr_status_log wf_item_attributes.text_default%TYPE;
1327: chg_appr_status varchar2(2);
1328: begin
1329: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_commit_aft_feedback', 1);
1330:
1331: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
1332: itemkey => p_itemkey ,
1333: aname => 'APPRAISAL_ID',

Line 1341: hr_utility.set_location('calling hr_complete_appraisal_ss.change_appr_status', 2);

1337: l_log := l_log || 'No Appraisal Id for this WorkFlow Transaction';
1338: --raise ; -- Should raise an Exception ?????
1339: end if;
1340:
1341: hr_utility.set_location('calling hr_complete_appraisal_ss.change_appr_status', 2);
1342: hr_complete_appraisal_ss.change_appr_status(l_appraisal_id, p_itemtype,p_itemkey,
1343: lv_chg_appr_status_log,chg_appr_status);
1344:
1345:

Line 1347: hr_utility.set_location('Exiting:'|| gv_package || '.appraisee_commit_aft_feedback', 1);

1343: lv_chg_appr_status_log,chg_appr_status);
1344:
1345:
1346: p_result := 'COMPLETE:SUCCESS';
1347: hr_utility.set_location('Exiting:'|| gv_package || '.appraisee_commit_aft_feedback', 1);
1348:
1349: exception
1350: when others then
1351: wf_core.Context(gv_package,'.appraisee_commit_aft_feedback',p_itemtype, p_itemkey

Line 1353: hr_utility.trace('Exception in ' || gv_package || '.appraisee_commit_aft_feedback' ||

1349: exception
1350: when others then
1351: wf_core.Context(gv_package,'.appraisee_commit_aft_feedback',p_itemtype, p_itemkey
1352: , p_actid,p_funcmode );
1353: hr_utility.trace('Exception in ' || gv_package || '.appraisee_commit_aft_feedback' ||
1354: sqlerrm );
1355: raise ;
1356: end appraisee_commit_aft_feedback ;
1357:

Line 1440: hr_utility.trace_on (null, 'KMG_TXN');

1436: l_proc VARCHAR2 (100);
1437: lv_send_nft VARCHAR2 (30) := 'N';
1438:
1439: BEGIN
1440: hr_utility.trace_on (null, 'KMG_TXN');
1441: l_proc := gv_package||'.send_emp_ntf_on_rejection';
1442: hr_utility.set_location('Entering:'|| l_proc, 1);
1443: lv_send_nft :=
1444: wf_engine.getitemattrtext (itemtype => p_itemtype,

Line 1442: hr_utility.set_location('Entering:'|| l_proc, 1);

1438:
1439: BEGIN
1440: hr_utility.trace_on (null, 'KMG_TXN');
1441: l_proc := gv_package||'.send_emp_ntf_on_rejection';
1442: hr_utility.set_location('Entering:'|| l_proc, 1);
1443: lv_send_nft :=
1444: wf_engine.getitemattrtext (itemtype => p_itemtype,
1445: itemkey => p_itemkey,
1446: aname => 'HR_APPR_NTF_ON_REJ_REQD',

Line 1452: hr_utility.TRACE ('In (if lv_send_nft = Y)' || l_proc);

1448: );
1449:
1450: IF lv_send_nft = 'Y'
1451: THEN
1452: hr_utility.TRACE ('In (if lv_send_nft = Y)' || l_proc);
1453: p_result := 'COMPLETE:' || 'Y';
1454: ELSE
1455: hr_utility.TRACE ('In (if lv_send_nft = N)' || l_proc);
1456: p_result := 'COMPLETE:' || 'N';

Line 1455: hr_utility.TRACE ('In (if lv_send_nft = N)' || l_proc);

1451: THEN
1452: hr_utility.TRACE ('In (if lv_send_nft = Y)' || l_proc);
1453: p_result := 'COMPLETE:' || 'Y';
1454: ELSE
1455: hr_utility.TRACE ('In (if lv_send_nft = N)' || l_proc);
1456: p_result := 'COMPLETE:' || 'N';
1457: END IF;
1458:
1459: hr_utility.set_location ('Leaving' || l_proc, 20);

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

1455: hr_utility.TRACE ('In (if lv_send_nft = N)' || l_proc);
1456: p_result := 'COMPLETE:' || 'N';
1457: END IF;
1458:
1459: hr_utility.set_location ('Leaving' || l_proc, 20);
1460: hr_utility.trace_off;
1461: EXCEPTION
1462: WHEN OTHERS
1463: THEN

Line 1460: hr_utility.trace_off;

1456: p_result := 'COMPLETE:' || 'N';
1457: END IF;
1458:
1459: hr_utility.set_location ('Leaving' || l_proc, 20);
1460: hr_utility.trace_off;
1461: EXCEPTION
1462: WHEN OTHERS
1463: THEN
1464: hr_utility.set_location ('EXCEPTION' || l_proc, 555);

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

1460: hr_utility.trace_off;
1461: EXCEPTION
1462: WHEN OTHERS
1463: THEN
1464: hr_utility.set_location ('EXCEPTION' || l_proc, 555);
1465: wf_core.CONTEXT (gv_package,
1466: 'send_emp_ntf_on_rejection',
1467: p_itemtype,
1468: p_itemkey,