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.PA_WORKPLAN_WORKFLOW dependencies on WF_ENGINE

Line 29: wf_engine.createProcess(p_item_type,

25: from dual;
26:
27: x_item_key := to_char(l_item_key);
28:
29: wf_engine.createProcess(p_item_type,
30: x_item_key,
31: p_process_name);
32:
33: pa_workplan_workflow_client.start_workflow(p_item_type,

Line 46: WF_ENGINE.startProcess(p_item_type,

42: );
43:
44:
45: IF x_return_status = FND_API.g_ret_sts_success THEN
46: WF_ENGINE.startProcess(p_item_type,
47: x_item_key);
48: END IF;
49:
50: EXCEPTION

Line 72: WF_ENGINE.ABORTPROCESS(p_item_type,

68:
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: WF_ENGINE.ABORTPROCESS(p_item_type,
73: p_item_key);
74: EXCEPTION
75: WHEN OTHERS THEN
76: x_msg_count :=1;

Line 113: l_project_id := wf_engine.GetItemAttrNumber(

109: and b.element_version_id = c_structure_version_id;
110: l_working_ver_id NUMBER;
111:
112: BEGIN
113: l_project_id := wf_engine.GetItemAttrNumber(
114: itemtype => itemtype,
115: itemkey => itemkey,
116: aname => 'PROJECT_ID');
117:

Line 118: l_structure_version_id := wf_engine.GetItemAttrNumber(

114: itemtype => itemtype,
115: itemkey => itemkey,
116: aname => 'PROJECT_ID');
117:
118: l_structure_version_id := wf_engine.GetItemAttrNumber(
119: itemtype => itemtype,
120: itemkey => itemkey,
121: aname => 'STRUCTURE_VER_ID');
122:

Line 128: resultout := wf_engine.eng_completed||':'||'APPROVED';

124: FETCH getWorkplanStatus into l_status;
125: CLOSE getWorkplanStatus;
126:
127: IF l_status = 'STRUCTURE_APPROVED' THEN
128: resultout := wf_engine.eng_completed||':'||'APPROVED';
129: ELSIF l_status = 'STRUCTURE_PUBLISHED' THEN
130: OPEN get_working_ver(l_structure_version_id);
131: FETCH get_working_ver into l_working_ver_id;
132: CLOSE get_working_ver;

Line 134: wf_engine.SetItemAttrText(itemtype, itemkey,

130: OPEN get_working_ver(l_structure_version_id);
131: FETCH get_working_ver into l_working_ver_id;
132: CLOSE get_working_ver;
133:
134: wf_engine.SetItemAttrText(itemtype, itemkey,
135: 'STRUCTURE_VER_ID_T',to_char(l_working_ver_id));
136: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
137: ELSIF l_status = 'STRUCTURE_REJECTED' THEN
138: resultout := wf_engine.eng_completed||':'||'REJECTED';

Line 136: resultout := wf_engine.eng_completed||':'||'PUBLISHED';

132: CLOSE get_working_ver;
133:
134: wf_engine.SetItemAttrText(itemtype, itemkey,
135: 'STRUCTURE_VER_ID_T',to_char(l_working_ver_id));
136: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
137: ELSIF l_status = 'STRUCTURE_REJECTED' THEN
138: resultout := wf_engine.eng_completed||':'||'REJECTED';
139: END IF;
140:

Line 138: resultout := wf_engine.eng_completed||':'||'REJECTED';

134: wf_engine.SetItemAttrText(itemtype, itemkey,
135: 'STRUCTURE_VER_ID_T',to_char(l_working_ver_id));
136: resultout := wf_engine.eng_completed||':'||'PUBLISHED';
137: ELSIF l_status = 'STRUCTURE_REJECTED' THEN
138: resultout := wf_engine.eng_completed||':'||'REJECTED';
139: END IF;
140:
141: pa_workplan_workflow_client.set_notification_party
142: (

Line 153: resultout := wf_engine.eng_null ; -- This is a Non existent value : 4537865

149: );
150: -- 4537865 : Included EXCEPTION BLOCK
151: EXCEPTION
152: WHEN OTHERS THEN
153: resultout := wf_engine.eng_null ; -- This is a Non existent value : 4537865
154: -- Included as per discussion with Rajnish : 4537865
155: Wf_Core.Context('pa_workplan_workflow','check_workplan_status',itemtype,itemkey,to_char(actid),funcmode);
156: RAISE ;
157: END check_workplan_status;

Line 176: l_project_id := wf_engine.GetItemAttrNumber(

172: BEGIN
173: --nofity party already set in start_workflow
174: --change status to working
175:
176: l_project_id := wf_engine.GetItemAttrNumber(
177: itemtype => itemtype,
178: itemkey => itemkey,
179: aname => 'PROJECT_ID');
180:

Line 181: l_structure_version_id := wf_engine.getItemAttrNumber(

177: itemtype => itemtype,
178: itemkey => itemkey,
179: aname => 'PROJECT_ID');
180:
181: l_structure_version_id := wf_engine.getItemAttrNumber(
182: itemtype => itemtype
183: ,itemkey => itemkey
184: ,aname => 'STRUCTURE_VER_ID');
185:

Line 186: l_record_version_num := wf_engine.getItemAttrNumber(

182: itemtype => itemtype
183: ,itemkey => itemkey
184: ,aname => 'STRUCTURE_VER_ID');
185:
186: l_record_version_num := wf_engine.getItemAttrNumber(
187: itemtype => itemtype
188: ,itemkey => itemkey
189: ,aname => 'RECORD_VERSION_NUMBER');
190:

Line 224: l_project_id := wf_engine.GetItemAttrNumber(

220: l_return_status VARCHAR2(1);
221: l_msg_count NUMBER;
222: l_msg_data VARCHAR2(300);
223: BEGIN
224: l_project_id := wf_engine.GetItemAttrNumber(
225: itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'PROJECT_ID');
228:

Line 229: l_structure_version_id := wf_engine.getItemAttrNumber(

225: itemtype => itemtype,
226: itemkey => itemkey,
227: aname => 'PROJECT_ID');
228:
229: l_structure_version_id := wf_engine.getItemAttrNumber(
230: itemtype => itemtype
231: ,itemkey => itemkey
232: ,aname => 'STRUCTURE_VER_ID');
233:

Line 234: l_record_version_num := wf_engine.getItemAttrNumber(

230: itemtype => itemtype
231: ,itemkey => itemkey
232: ,aname => 'STRUCTURE_VER_ID');
233:
234: l_record_version_num := wf_engine.getItemAttrNumber(
235: itemtype => itemtype
236: ,itemkey => itemkey
237: ,aname => 'RECORD_VERSION_NUMBER');
238:

Line 297: l_project_id := wf_engine.GetItemAttrNumber(

293: l_msg_index_out NUMBER;
294: l_data VARCHAR2(300);
295:
296: BEGIN
297: l_project_id := wf_engine.GetItemAttrNumber(
298: itemtype => itemtype,
299: itemkey => itemkey,
300: aname => 'PROJECT_ID');
301:

Line 302: l_structure_version_id := wf_engine.getItemAttrNumber(

298: itemtype => itemtype,
299: itemkey => itemkey,
300: aname => 'PROJECT_ID');
301:
302: l_structure_version_id := wf_engine.getItemAttrNumber(
303: itemtype => itemtype
304: ,itemkey => itemkey
305: ,aname => 'STRUCTURE_VER_ID');
306:

Line 307: l_record_version_num := wf_engine.getItemAttrNumber(

303: itemtype => itemtype
304: ,itemkey => itemkey
305: ,aname => 'STRUCTURE_VER_ID');
306:
307: l_record_version_num := wf_engine.getItemAttrNumber(
308: itemtype => itemtype
309: ,itemkey => itemkey
310: ,aname => 'RECORD_VERSION_NUMBER');
311:

Line 352: wf_engine.SetItemAttrNumber(itemtype, itemkey,

348: END IF;
349:
350:
351: IF (l_return_status = FND_API.g_ret_sts_success) THEN
352: wf_engine.SetItemAttrNumber(itemtype, itemkey,
353: 'RECORD_VERSION_NUMBER',l_record_version_num+1);
354: END IF;
355:
356: l_record_version_num := wf_engine.getItemAttrNumber(

Line 356: l_record_version_num := wf_engine.getItemAttrNumber(

352: wf_engine.SetItemAttrNumber(itemtype, itemkey,
353: 'RECORD_VERSION_NUMBER',l_record_version_num+1);
354: END IF;
355:
356: l_record_version_num := wf_engine.getItemAttrNumber(
357: itemtype => itemtype
358: ,itemkey => itemkey
359: ,aname => 'RECORD_VERSION_NUMBER');
360:

Line 363: l_structure_version_name := wf_engine.getItemAttrText(

359: ,aname => 'RECORD_VERSION_NUMBER');
360:
361:
362: IF l_auto_publish_flag = 'Y' THEN
363: l_structure_version_name := wf_engine.getItemAttrText(
364: itemtype => itemtype
365: ,itemkey => itemkey
366: ,aname => 'STRUCTURE_VER_NAME');
367:

Line 368: l_structure_version_desc := wf_engine.getItemAttrText(

364: itemtype => itemtype
365: ,itemkey => itemkey
366: ,aname => 'STRUCTURE_VER_NAME');
367:
368: l_structure_version_desc := wf_engine.getItemAttrText(
369: itemtype => itemtype
370: ,itemkey => itemkey
371: ,aname => 'STRUCTURE_VER_DESC');
372:

Line 373: l_record_version_num := wf_engine.getItemAttrNumber(

369: itemtype => itemtype
370: ,itemkey => itemkey
371: ,aname => 'STRUCTURE_VER_DESC');
372:
373: l_record_version_num := wf_engine.getItemAttrNumber(
374: itemtype => itemtype
375: ,itemkey => itemkey
376: ,aname => 'RECORD_VERSION_NUMBER');
377:

Line 378: l_responsibility_id := wf_engine.getItemAttrNumber(

374: itemtype => itemtype
375: ,itemkey => itemkey
376: ,aname => 'RECORD_VERSION_NUMBER');
377:
378: l_responsibility_id := wf_engine.getItemAttrNumber(
379: itemtype => itemtype
380: ,itemkey => itemkey
381: ,aname => 'RESPONSIBILITY_ID');
382:

Line 383: l_user_id := wf_engine.getItemAttrNumber(

379: itemtype => itemtype
380: ,itemkey => itemkey
381: ,aname => 'RESPONSIBILITY_ID');
382:
383: l_user_id := wf_engine.getItemAttrNumber(
384: itemtype => itemtype
385: ,itemkey => itemkey
386: ,aname => 'USER_ID');
387:

Line 443: wf_engine.SetItemAttrNumber(itemtype, itemkey,

439: end loop;
440: END IF;
441:
442: --set structure_ver_id
443: wf_engine.SetItemAttrNumber(itemtype, itemkey,
444: 'STRUCTURE_VER_ID',l_published_struc_ver_id);
445: wf_engine.SetItemAttrText(itemtype, itemkey,
446: 'STRUCTURE_VER_ID_T',to_char(l_published_struc_ver_id));
447: --call PA_PROJECT_STRUCTURE_PVT1.change_workplan_status

Line 445: wf_engine.SetItemAttrText(itemtype, itemkey,

441:
442: --set structure_ver_id
443: wf_engine.SetItemAttrNumber(itemtype, itemkey,
444: 'STRUCTURE_VER_ID',l_published_struc_ver_id);
445: wf_engine.SetItemAttrText(itemtype, itemkey,
446: 'STRUCTURE_VER_ID_T',to_char(l_published_struc_ver_id));
447: --call PA_PROJECT_STRUCTURE_PVT1.change_workplan_status
448: END IF;
449: -- 4537865 : Included EXCEPTION BLOCK

Line 565: l_project_id := wf_engine.GetItemAttrNumber(

561: notification_preference VARCHAR2(2000);
562: language VARCHAR2(2000);
563: territory VARCHAR2(2000);
564: BEGIN
565: l_project_id := wf_engine.GetItemAttrNumber(
566: itemtype => p_item_type,
567: itemkey => p_item_key,
568: aname => 'PROJECT_ID');
569:

Line 570: l_structure_version_id := wf_engine.GetItemAttrNumber(

566: itemtype => p_item_type,
567: itemkey => p_item_key,
568: aname => 'PROJECT_ID');
569:
570: l_structure_version_id := wf_engine.GetItemAttrNumber(
571: itemtype => p_item_type,
572: itemkey => p_item_key,
573: aname => 'STRUCTURE_VER_ID');
574:

Line 622: wf_engine.setitemattrtext(p_item_type

618:
619: IF (l_error_role_user IS NOT NULL) THEN
620: wf_directory.adduserstoadhocRole(l_error_role
621: ,l_error_role_user);
622: wf_engine.setitemattrtext(p_item_type
623: ,p_item_key
624: ,'WORKPLAN_ERR_RECEIVER'
625: ,l_error_role);
626: END IF;

Line 785: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.createprocess';

781: END IF ;
782:
783:
784: IF l_debug_mode = 'Y' THEN
785: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.createprocess';
786: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
787: END IF ;
788:
789: OPEN proj_number;

Line 793: wf_engine.createprocess(itemtype => l_item_type,

789: OPEN proj_number;
790: FETCH proj_number INTO proj_number_rec;
791: CLOSE proj_number ;
792:
793: wf_engine.createprocess(itemtype => l_item_type,
794: itemkey => to_char(p_project_id),
795: process => l_process_name
796: );
797:

Line 804: wf_engine.SetItemAttrNumber

800: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
801: END IF ;
802:
803: -- Set attribute Project Id
804: wf_engine.SetItemAttrNumber
805: (itemtype => l_item_type
806: ,itemkey => to_char(p_project_id)
807: ,aname => 'PROJECT_ID'
808: ,avalue => p_project_id

Line 812: wf_engine.SetItemAttrText

808: ,avalue => p_project_id
809: );
810:
811: -- Set attribute Project Number
812: wf_engine.SetItemAttrText
813: (itemtype => l_item_type
814: ,itemkey => to_char(p_project_id)
815: ,aname => 'PROJECT_NUMBER'
816: ,avalue => proj_number_rec.segment1

Line 820: wf_engine.SetItemUserKey

816: ,avalue => proj_number_rec.segment1
817: );
818:
819: -- Set User Key
820: wf_engine.SetItemUserKey
821: (itemtype => l_item_type ,
822: itemkey => to_char(p_project_id) ,
823: userkey => proj_number_rec.segment1
824: );

Line 827: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';

823: userkey => proj_number_rec.segment1
824: );
825:
826: IF l_debug_mode = 'Y' THEN
827: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';
828: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
829: END IF ;
830:
831: wf_engine.startprocess(l_item_type

Line 831: wf_engine.startprocess(l_item_type

827: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';
828: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
829: END IF ;
830:
831: wf_engine.startprocess(l_item_type
832: ,to_char(p_project_id));
833:
834: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
835: --update pa_wf_process_table

Line 887: WF_ENGINE.AbortProcess(l_item_type

883:
884: BEGIN
885: x_return_status := FND_API.g_ret_sts_success;
886:
887: WF_ENGINE.AbortProcess(l_item_type
888: , to_char(p_project_id)
889: );
890: --Bug#3693248
891: --Added item_type join as part of performance fix.

Line 976: IF (funcmode <> wf_engine.eng_run) THEN

972: p_debug_mode => l_debug_mode );
973: END IF;
974:
975: -- Return if WF Not Running
976: IF (funcmode <> wf_engine.eng_run) THEN
977: resultout := wf_engine.eng_null;
978: RETURN;
979: END IF;
980:

Line 977: resultout := wf_engine.eng_null;

973: END IF;
974:
975: -- Return if WF Not Running
976: IF (funcmode <> wf_engine.eng_run) THEN
977: resultout := wf_engine.eng_null;
978: RETURN;
979: END IF;
980:
981: IF l_debug_mode = 'Y' THEN

Line 986: l_project_id := wf_engine.GetItemAttrNumber

982: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get Project Id';
983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
984: END IF ;
985:
986: l_project_id := wf_engine.GetItemAttrNumber
987: (itemtype => itemtype
988: ,itemkey => itemkey
989: ,aname => 'PROJECT_ID') ;
990:

Line 991: l_project_number := wf_engine.GetItemAttrText

987: (itemtype => itemtype
988: ,itemkey => itemkey
989: ,aname => 'PROJECT_ID') ;
990:
991: l_project_number := wf_engine.GetItemAttrText
992: (itemtype => itemtype
993: ,itemkey => itemkey
994: ,aname => 'PROJECT_NUMBER') ;
995:

Line 1052: wf_engine.createprocess(itemtype => get_all_tasks_rec.wf_item_type,

1048: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Create Process';
1049: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1050: END IF ;
1051:
1052: wf_engine.createprocess(itemtype => get_all_tasks_rec.wf_item_type,
1053: itemkey => to_char(l_item_key),
1054: process => get_all_tasks_rec.wf_process
1055: );
1056:

Line 1058: wf_engine.setItemParent(itemtype => get_all_tasks_rec.wf_item_type,

1054: process => get_all_tasks_rec.wf_process
1055: );
1056:
1057:
1058: wf_engine.setItemParent(itemtype => get_all_tasks_rec.wf_item_type,
1059: itemkey => to_char(l_item_key),
1060: parent_itemtype => itemtype,
1061: parent_itemkey => itemkey,
1062: parent_context => null);

Line 1065: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';

1061: parent_itemkey => itemkey,
1062: parent_context => null);
1063:
1064: IF l_debug_mode = 'Y' THEN
1065: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';
1066: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1067: END IF ;
1068:
1069: wf_engine.startprocess(get_all_tasks_rec.wf_item_type

Line 1069: wf_engine.startprocess(get_all_tasks_rec.wf_item_type

1065: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Calling wf_engine.startprocess';
1066: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1067: END IF ;
1068:
1069: wf_engine.startprocess(get_all_tasks_rec.wf_item_type
1070: ,to_char(l_item_key));
1071:
1072:
1073: --update pa_wf_process_table

Line 1092: resultout := wf_engine.eng_null;

1088: END IF ;
1089: END LOOP ;
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: resultout := wf_engine.eng_null;
1093: Wf_Core.Context('pa_workplan_workflow','START_TASK_EXECUTION_WF',itemtype,itemkey,to_char(actid),funcmode);
1094: RAISE ;
1095: END START_TASK_EXECUTION_WF ;
1096:

Line 1176: wf_engine.createprocess(itemtype => task_info_rec.wf_item_type,

1172: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Create Process';
1173: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1174: END IF ;
1175:
1176: wf_engine.createprocess(itemtype => task_info_rec.wf_item_type,
1177: itemkey => to_char(l_item_key),
1178: process => task_info_rec.wf_process
1179: );
1180:

Line 1182: wf_engine.setItemParent(itemtype => task_info_rec.wf_item_type ,

1178: process => task_info_rec.wf_process
1179: );
1180:
1181:
1182: wf_engine.setItemParent(itemtype => task_info_rec.wf_item_type ,
1183: itemkey => to_char(l_item_key),
1184: parent_itemtype => 'PAPRJEX' ,
1185: parent_itemkey => to_char(task_info_rec.project_id),
1186: parent_context => null);

Line 1189: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Calling wf_engine.startprocess';

1185: parent_itemkey => to_char(task_info_rec.project_id),
1186: parent_context => null);
1187:
1188: IF l_debug_mode = 'Y' THEN
1189: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Calling wf_engine.startprocess';
1190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1191: END IF ;
1192:
1193: wf_engine.startprocess(task_info_rec.wf_item_type

Line 1193: wf_engine.startprocess(task_info_rec.wf_item_type

1189: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Calling wf_engine.startprocess';
1190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1191: END IF ;
1192:
1193: wf_engine.startprocess(task_info_rec.wf_item_type
1194: ,to_char(l_item_key));
1195:
1196:
1197: --update pa_wf_process_table

Line 1270: WF_ENGINE.AbortProcess

1266: ,p_project_id => get_item_type_rec.project_id
1267: ,p_wf_type_code =>'TASK_EXECUTION'
1268: );
1269:
1270: WF_ENGINE.AbortProcess
1271: (get_item_type_rec.wf_item_type
1272: ,to_char(l_item_key)
1273: );
1274: END IF ;

Line 1314: IF (funcmode <> wf_engine.eng_run) THEN

1310: p_debug_mode => l_debug_mode );
1311: END IF;
1312:
1313: -- Return if WF Not Running
1314: IF (funcmode <> wf_engine.eng_run) THEN
1315: resultout := wf_engine.eng_null;
1316: RETURN;
1317: END IF;
1318:

Line 1315: resultout := wf_engine.eng_null;

1311: END IF;
1312:
1313: -- Return if WF Not Running
1314: IF (funcmode <> wf_engine.eng_run) THEN
1315: resultout := wf_engine.eng_null;
1316: RETURN;
1317: END IF;
1318:
1319: IF l_debug_mode = 'Y' THEN

Line 1324: l_project_id := wf_engine.GetItemAttrNumber

1320: Pa_Debug.g_err_stage:= 'IS_PROJECT_CLOSED : Get Project Id';
1321: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1322: END IF ;
1323:
1324: l_project_id := wf_engine.GetItemAttrNumber
1325: (itemtype => itemtype
1326: ,itemkey => itemkey
1327: ,aname => 'PROJECT_ID') ;
1328:

Line 1334: resultout := wf_engine.eng_completed||':'||'Y';

1330: FETCH proj_status_cur INTO proj_status_cur_rec ;
1331: CLOSE proj_status_cur ;
1332:
1333: IF proj_status_cur_rec.project_system_status_code = 'CLOSED' THEN
1334: resultout := wf_engine.eng_completed||':'||'Y';
1335: ELSE
1336: resultout := wf_engine.eng_completed||':'||'N';
1337: END IF ;
1338: -- 4537865 : Included EXCEPTION BLOCK

Line 1336: resultout := wf_engine.eng_completed||':'||'N';

1332:
1333: IF proj_status_cur_rec.project_system_status_code = 'CLOSED' THEN
1334: resultout := wf_engine.eng_completed||':'||'Y';
1335: ELSE
1336: resultout := wf_engine.eng_completed||':'||'N';
1337: END IF ;
1338: -- 4537865 : Included EXCEPTION BLOCK
1339: EXCEPTION
1340: WHEN OTHERS THEN

Line 1341: resultout := wf_engine.eng_null;

1337: END IF ;
1338: -- 4537865 : Included EXCEPTION BLOCK
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: resultout := wf_engine.eng_null;
1342:
1343: -- Included as per discussion with Rajnish : 4537865
1344: Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',itemtype,itemkey,to_char(actid),funcmode);
1345: RAISE;