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

Line 28: ---hr_utility.trace_on('Y','WF-1');

24:
25: l_er_count integer;
26: l_error_count integer;
27: begin
28: ---hr_utility.trace_on('Y','WF-1');
29: l_request_id :=
30: wf_engine.GetItemAttrText(itemtype => itemtype,
31: itemkey => itemkey,
32: aname => 'REQUEST_ID');

Line 38: hr_utility.trace('er_workflow --> FATAL error .. request_id = '||l_request_id);

34: l_retry_request_id := wf_engine.GetItemAttrText(itemtype => itemtype,
35: itemkey => itemkey,
36: aname => 'RETRY_REQUEST_ID');
37:
38: hr_utility.trace('er_workflow --> FATAL error .. request_id = '||l_request_id);
39: open fatal_error_cursor;
40: fetch fatal_error_cursor into l_error_count;
41: close fatal_error_cursor;
42:

Line 43: hr_utility.trace('er_workflow --> FATAL error .. count = '||l_er_count);

39: open fatal_error_cursor;
40: fetch fatal_error_cursor into l_error_count;
41: close fatal_error_cursor;
42:
43: hr_utility.trace('er_workflow --> FATAL error .. count = '||l_er_count);
44: open count_er;
45: fetch count_er into l_er_count;
46: close count_er;
47:

Line 48: hr_utility.trace('er_workflow --> FATAL error .. count = '||l_error_count);

44: open count_er;
45: fetch count_er into l_er_count;
46: close count_er;
47:
48: hr_utility.trace('er_workflow --> FATAL error .. count = '||l_error_count);
49: if (l_er_count + l_error_count) = 0 then
50: result := 'COMPLETE:NOERRORNOREPORT';
51: elsif (l_er_count > 0) AND (l_error_count > 0) THEN
52: result := 'COMPLETE:ERRORSANDREPORTS';

Line 247: ---hr_utility.trace_on('Y','WF-1');

243: l_param_string varchar2(1000);
244: effort_manual_override_flag varchar2(10); --added for bug 4106614: Effort Manual Override
245:
246: begin
247: ---hr_utility.trace_on('Y','WF-1');
248: hr_utility.trace('er_workflow --> 100');
249: if funcmode = 'RUN' then
250: l_initiator_rname :=
251: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 248: hr_utility.trace('er_workflow --> 100');

244: effort_manual_override_flag varchar2(10); --added for bug 4106614: Effort Manual Override
245:
246: begin
247: ---hr_utility.trace_on('Y','WF-1');
248: hr_utility.trace('er_workflow --> 100');
249: if funcmode = 'RUN' then
250: l_initiator_rname :=
251: wf_engine.GetItemAttrText(itemtype => itemtype,
252: itemkey => itemkey,

Line 292: hr_utility.trace('er_workflow --> count =0 req_id='||to_char(l_request_id));

288: fetch wf_item_key_cur bulk collect into wf_rname_array, wf_ikey_array;
289: close wf_item_key_cur;
290:
291: if wf_rname_array.count = 0 then
292: hr_utility.trace('er_workflow --> count =0 req_id='||to_char(l_request_id));
293: --dbms_output.put_line('INIT APPROVALS:no recs for approval.. raise error');
294: ---- raise error here, with appropriate error;
295: RAISE fnd_api.g_exc_unexpected_error;
296: end if;

Line 310: hr_utility.trace('er_workflow --> LOOP START ');

306: where erd.effort_report_id = er.effort_report_id
307: and er.request_id = l_request_id
308: and er.status_code = 'N');
309: k := 1;
310: hr_utility.trace('er_workflow --> LOOP START ');
311: loop
312: hr_utility.trace('er_workflow --> INSIDE LOOP ');
313: if k > wf_rname_array.count then
314: exit;

Line 312: hr_utility.trace('er_workflow --> INSIDE LOOP ');

308: and er.status_code = 'N');
309: k := 1;
310: hr_utility.trace('er_workflow --> LOOP START ');
311: loop
312: hr_utility.trace('er_workflow --> INSIDE LOOP ');
313: if k > wf_rname_array.count then
314: exit;
315: end if;
316: -- call workflow

Line 429: hr_utility.trace('er_workflow --> 1000 ');

425: k := k + 1;
426: end loop;
427: wf_ikey_array.delete;
428:
429: hr_utility.trace('er_workflow --> 1000 ');
430: result := 'COMPLETE';
431: end if; --- funcmode = RUN
432:
433: result := 'COMPLETE';

Line 436: hr_utility.trace('er_workflow --> err '||sqlerrm);

432:
433: result := 'COMPLETE';
434: exception
435: when others then
436: hr_utility.trace('er_workflow --> err '||sqlerrm);
437: result := 'ERROR';
438: wf_core.context('PSP_EFFORT_REPORTS', 'INIT_APPROVALS', itemtype, itemkey, to_char(actid), funcmode);
439: raise;
440: end;

Line 622: hr_utility.trace(' Entering GET_NEXT_APPROVER');

618: from psp_Report_templates_h
619: where request_id = l_request_id;
620:
621: begin
622: hr_utility.trace(' Entering GET_NEXT_APPROVER');
623: l_same_approval_level := 'N';
624: ---hr_utility.trace_on('Y','WF-1');
625:
626: l_user_id := fnd_global.user_id;

Line 624: ---hr_utility.trace_on('Y','WF-1');

620:
621: begin
622: hr_utility.trace(' Entering GET_NEXT_APPROVER');
623: l_same_approval_level := 'N';
624: ---hr_utility.trace_on('Y','WF-1');
625:
626: l_user_id := fnd_global.user_id;
627: l_login_id := fnd_global.login_id;
628: if funcmode = 'RUN' then

Line 744: hr_utility.trace(' ER workflow -> order number = '||l_next_approver(1).approver_order_number);

740: (select er.effort_report_id
741: from psp_eff_reports er
742: where er.request_id = l_request_id
743: and er.status_code = 'N');
744: hr_utility.trace(' ER workflow -> order number = '||l_next_approver(1).approver_order_number);
745: -- copy the previous approvers overwrites to the new approver
746: if l_next_approver(1).approver_order_number > 1 then
747: update psp_eff_report_approvals A1
748: set (A1.actual_cost_share, A1.overwritten_effort_percent, comments,

Line 781: hr_utility.trace(' ER workflow -> update count= '||sql%rowcount);

777: where er.request_id = l_request_id
778: and er.effort_report_id = erd.effort_report_id
779: and erd.ame_transaction_id = ame_txn_id_array(i)
780: and er.status_code = 'N');
781: hr_utility.trace(' ER workflow -> update count= '||sql%rowcount);
782: end if;
783:
784:
785: end if;

Line 848: hr_utility.trace('GET_NEXT value for temp_approver_order ='|| l_approver_order_num);

844: ||'&requestId='||l_request_id
845: ||'&wfRoleName='||l_wf_rname
846: ||'&approverOrderNum='||l_approver_order_num); */
847:
848: hr_utility.trace('GET_NEXT value for temp_approver_order ='|| l_approver_order_num);
849: wf_engine.SetItemAttrNumber(itemtype => itemtype,
850: itemkey => itemkey,
851: aname => 'TEMP_APPROVER_ORDER',
852: avalue => l_approver_order_num);

Line 854: hr_utility.trace('er_workflow --> GET NEXT APPROVER jsp string='||

850: itemkey => itemkey,
851: aname => 'TEMP_APPROVER_ORDER',
852: avalue => l_approver_order_num);
853:
854: hr_utility.trace('er_workflow --> GET NEXT APPROVER jsp string='||
855: 'JSP:/OA_HTML/OA.jsp?OAFunc=PSP_WF_ER_DETAILS&wfItemKey='||itemkey
856: ||'&requestId='||l_request_id
857: ||'&wfRoleName='||l_wf_rname
858: ||'&approverOrderNum='||l_approver_order_num);

Line 971: ---hr_utility.trace_on('Y','WF-1');

967: l_approver_order_num integer;
968:
969: begin
970: l_recipnt_role := 'PSP_PAST_APPROVERS_'||itemkey;
971: ---hr_utility.trace_on('Y','WF-1');
972: if funcmode = 'RUN' then
973: hr_utility.trace('er_workflow -->1 ');
974: l_request_id :=
975: wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 973: hr_utility.trace('er_workflow -->1 ');

969: begin
970: l_recipnt_role := 'PSP_PAST_APPROVERS_'||itemkey;
971: ---hr_utility.trace_on('Y','WF-1');
972: if funcmode = 'RUN' then
973: hr_utility.trace('er_workflow -->1 ');
974: l_request_id :=
975: wf_engine.GetItemAttrNumber(itemtype => itemtype,
976: itemkey => itemkey,
977: aname => 'REQUEST_ID');

Line 999: hr_utility.trace('er_workflow -->2 ');

995: approver_rec.orig_system := l_orig_system;
996: approver_rec.orig_system_id := l_orig_system_id;
997: approver_rec.approval_status:= 'REJECTED';
998:
999: hr_utility.trace('er_workflow -->2 ');
1000: open get_txn_id_cur;
1001: loop
1002: hr_utility.trace('er_workflow -->3 ');
1003: fetch get_txn_id_cur into l_txn_id;

Line 1002: hr_utility.trace('er_workflow -->3 ');

998:
999: hr_utility.trace('er_workflow -->2 ');
1000: open get_txn_id_cur;
1001: loop
1002: hr_utility.trace('er_workflow -->3 ');
1003: fetch get_txn_id_cur into l_txn_id;
1004: if get_txn_id_cur%notfound then
1005: close get_txn_id_cur;
1006: exit;

Line 1008: hr_utility.trace('er_workflow -->5 ');

1004: if get_txn_id_cur%notfound then
1005: close get_txn_id_cur;
1006: exit;
1007: end if;
1008: hr_utility.trace('er_workflow -->5 ');
1009:
1010: ame_api2.updateapprovalstatus(applicationidin => 8403,
1011: transactiontypein => 'PSP-ER-APPROVAL',
1012: transactionidin => l_txn_id,

Line 1014: hr_utility.trace('er_workflow -->6 ');

1010: ame_api2.updateapprovalstatus(applicationidin => 8403,
1011: transactiontypein => 'PSP-ER-APPROVAL',
1012: transactionidin => l_txn_id,
1013: approverin => approver_rec);
1014: hr_utility.trace('er_workflow -->6 ');
1015: end loop;
1016:
1017: hr_utility.trace('er_workflow -->7 ');
1018: update psp_eff_report_approvals era

Line 1017: hr_utility.trace('er_workflow -->7 ');

1013: approverin => approver_rec);
1014: hr_utility.trace('er_workflow -->6 ');
1015: end loop;
1016:
1017: hr_utility.trace('er_workflow -->7 ');
1018: update psp_eff_report_approvals era
1019: set era.approval_status = 'S',
1020: era.response_date = sysdate,
1021: era.last_update_date = sysdate,

Line 1051: hr_utility.trace('er_workflow -->8 ');

1047: where er.effort_report_id = erd.effort_report_id
1048: and erd.effort_report_detail_id = era.effort_report_detail_id
1049: and er.status_code = 'S' );
1050:
1051: hr_utility.trace('er_workflow -->8 ');
1052: open effort_report_id_cur;
1053: loop
1054: fetch effort_report_id_cur into l_effort_report_id;
1055: hr_utility.trace('er_workflow -->9 ');

Line 1055: hr_utility.trace('er_workflow -->9 ');

1051: hr_utility.trace('er_workflow -->8 ');
1052: open effort_report_id_cur;
1053: loop
1054: fetch effort_report_id_cur into l_effort_report_id;
1055: hr_utility.trace('er_workflow -->9 ');
1056: if effort_report_id_cur%notfound then
1057: close effort_report_id_cur;
1058: exit;
1059: end if;

Line 1066: hr_utility.trace('er_workflow -->19 ');

1062: last_update_date = sysdate,
1063: last_update_login = fnd_global.login_id,
1064: last_updated_by = fnd_global.user_id
1065: where effort_report_id = l_effort_report_id;
1066: hr_utility.trace('er_workflow -->19 ');
1067: end loop;
1068:
1069: l_initiator_rname :=
1070: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1076: hr_utility.trace('er_workflow -->29 ');

1072: aname => 'INITIATOR');
1073:
1074: wf_directory.createAdhocRole(l_recipnt_role,
1075: l_recipnt_role);
1076: hr_utility.trace('er_workflow -->29 ');
1077: open past_approvers_cur;
1078: loop
1079: hr_utility.trace('er_workflow -->39 ');
1080: fetch past_approvers_cur into l_rname;

Line 1079: hr_utility.trace('er_workflow -->39 ');

1075: l_recipnt_role);
1076: hr_utility.trace('er_workflow -->29 ');
1077: open past_approvers_cur;
1078: loop
1079: hr_utility.trace('er_workflow -->39 ');
1080: fetch past_approvers_cur into l_rname;
1081: if past_approvers_cur%notfound then
1082: close past_approvers_cur;
1083: exit;

Line 1085: hr_utility.trace('er_workflow -->49 ');

1081: if past_approvers_cur%notfound then
1082: close past_approvers_cur;
1083: exit;
1084: end if;
1085: hr_utility.trace('er_workflow -->49 ');
1086: wf_directory.AddUsersToAdHocRole
1087: (role_name => l_recipnt_role,
1088: role_users => l_rname);
1089: end loop;

Line 1091: hr_utility.trace('er_workflow -->59 ');

1087: (role_name => l_recipnt_role,
1088: role_users => l_rname);
1089: end loop;
1090:
1091: hr_utility.trace('er_workflow -->59 ');
1092: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1093: itemkey => itemkey,
1094: aname => 'NOTIFY_REJECTIONS_ROLE',
1095: avalue => l_recipnt_role);

Line 1096: hr_utility.trace('er_workflow -->69 ');

1092: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1093: itemkey => itemkey,
1094: aname => 'NOTIFY_REJECTIONS_ROLE',
1095: avalue => l_recipnt_role);
1096: hr_utility.trace('er_workflow -->69 ');
1097:
1098: result := 'COMPLETE:REJECTED';
1099: open same_approval_level_cur(l_approver_order_num);
1100: fetch same_approval_level_cur into l_rname;

Line 1107: hr_utility.trace('er_workflow -->79 ');

1103: if same_approval_level_cur%found then
1104: result := 'COMPLETE:MORE_RESP_REQD';
1105: end if;
1106: close same_approval_level_cur;
1107: hr_utility.trace('er_workflow -->79 ');
1108: end if; --- funcmode
1109: hr_utility.trace('er_workflow -->89 ');
1110: exception
1111: when others then

Line 1109: hr_utility.trace('er_workflow -->89 ');

1105: end if;
1106: close same_approval_level_cur;
1107: hr_utility.trace('er_workflow -->79 ');
1108: end if; --- funcmode
1109: hr_utility.trace('er_workflow -->89 ');
1110: exception
1111: when others then
1112: hr_utility.trace('er_workflow -->when others then exception occured Error = '||sqlerrm);
1113: result := 'ERROR';

Line 1112: hr_utility.trace('er_workflow -->when others then exception occured Error = '||sqlerrm);

1108: end if; --- funcmode
1109: hr_utility.trace('er_workflow -->89 ');
1110: exception
1111: when others then
1112: hr_utility.trace('er_workflow -->when others then exception occured Error = '||sqlerrm);
1113: result := 'ERROR';
1114: wf_core.context('PSP_EFFORT_REPORTS', 'PROCESS_REJECTIONS', itemtype, itemkey, to_char(actid), funcmode);
1115: --- debug;
1116: raise;

Line 1152: hr_utility.trace(' the valus of Run Id is : '|| funcmode);

1148: and era.wf_orig_system_id = l_orig_system_id
1149: and era.wf_orig_system = l_orig_system;
1150:
1151: begin
1152: hr_utility.trace(' the valus of Run Id is : '|| funcmode);
1153: if funcmode = 'RUN' then
1154: l_rname :=
1155: wf_engine.GetItemAttrText(itemtype => itemtype,
1156: itemkey => itemkey,

Line 1456: ---hr_utility.trace_on('Y','WF-1');

1452: END IF;
1453: END IF;
1454:
1455: if funcmode in ('TRANSFER', 'FORWARD') then
1456: ---hr_utility.trace_on('Y','WF-1');
1457: hr_utility.trace('Post Notification...TRANSFER . FORWARD');
1458: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'APPROVER_ROLE_NAME');

Line 1457: hr_utility.trace('Post Notification...TRANSFER . FORWARD');

1453: END IF;
1454:
1455: if funcmode in ('TRANSFER', 'FORWARD') then
1456: ---hr_utility.trace_on('Y','WF-1');
1457: hr_utility.trace('Post Notification...TRANSFER . FORWARD');
1458: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'APPROVER_ROLE_NAME');
1461: hr_utility.trace('role name from T and F = '||l_rname);

Line 1461: hr_utility.trace('role name from T and F = '||l_rname);

1457: hr_utility.trace('Post Notification...TRANSFER . FORWARD');
1458: l_rname := wf_engine.GetItemAttrText(itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'APPROVER_ROLE_NAME');
1461: hr_utility.trace('role name from T and F = '||l_rname);
1462:
1463: open get_orig_system;
1464: fetch get_orig_system into l_orig_system_id, l_orig_system;
1465: close get_orig_system;

Line 1477: hr_utility.trace('post notification...Transfer . Forwardee='||l_rname2||' nid ='||l_nid);

1473: open get_forwarde_details;
1474: fetch get_forwarde_details into l_orig_system2, l_orig_system_id2,l_role_display_name2;
1475: close get_forwarde_details;
1476: forward_rec.name := l_rname2;
1477: hr_utility.trace('post notification...Transfer . Forwardee='||l_rname2||' nid ='||l_nid);
1478: forward_rec.orig_system := l_orig_system2;
1479: forward_rec.orig_system_id := l_orig_system_id2;
1480: forward_rec.approval_status:= ame_util.notifiedStatus;
1481: update psp_eff_report_approvals

Line 1517: hr_utility.trace('Transfer mode CALLING UPDATEAME txn_id ='||l_txn_id);

1513: if get_txn_id_cur%notfound then
1514: close get_txn_id_cur;
1515: exit;
1516: end if;
1517: hr_utility.trace('Transfer mode CALLING UPDATEAME txn_id ='||l_txn_id);
1518: ame_api2.updateapprovalstatus(applicationidin => 8403,
1519: transactiontypein => 'PSP-ER-APPROVAL',
1520: transactionidin => l_txn_id,
1521: approverin => approver_rec,

Line 1531: hr_utility.trace('funcmode, role name from RUN = '||funcmode||','||l_rname);

1527: aname => 'APPROVER_ROLE_NAME');
1528:
1529:
1530:
1531: hr_utility.trace('funcmode, role name from RUN = '||funcmode||','||l_rname);
1532: end if; ---funcmode
1533:
1534: -- BUG 4334816 START
1535: -- New code added to capture the Notification id in psp_eff_report_approvals table

Line 1797: hr_utility.trace('er_workflow --> start_int: reqid ='||to_char(p_request_id));

1793: wf_engine.CreateProcess(itemtype => 'PSPERAVL',
1794: itemkey => l_wf_itemkey,
1795: process => 'INITIATOR_PROCESS');
1796:
1797: hr_utility.trace('er_workflow --> start_int: reqid ='||to_char(p_request_id));
1798:
1799: /*Added for bug 7004679 */
1800: wf_engine.setitemowner(itemtype => 'PSPERAVL',
1801: itemkey => l_wf_itemkey,

Line 2047: ---hr_utility.trace('er_workflow --> 120'||l_debug);

2043:
2044: exception
2045: when others then
2046: ---l_debug := sqlerrm;
2047: ---hr_utility.trace('er_workflow --> 120'||l_debug);
2048: result := 'ERROR';
2049: wf_core.context('PSP_EFFORT_REPORTS', 'CREATE_FRP_ROLE', itemtype, itemkey, to_char(actid), funcmode);
2050: end;
2051:

Line 2264: hr_utility.trace('PDF_ATTACHMENT attribute exists');

2260: --Bug 7135471
2261: If itemkey is not null then
2262:
2263: if(item_attribute_exists(itemtype,itemkey,'PDF_ATTACHMENT')) then
2264: hr_utility.trace('PDF_ATTACHMENT attribute exists');
2265: else
2266: wf_engine.additemattr
2267: (itemtype => itemtype,
2268: itemkey => itemkey,