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 PA_WORKPLAN_WORKFLOW

Line 1: package body PA_WORKPLAN_WORKFLOW as

1: package body PA_WORKPLAN_WORKFLOW as
2: /*$Header: PAXSTWWB.pls 120.9 2011/04/15 06:52:38 smadhava ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_workplan_workflow';
5:

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_workplan_workflow';

1: package body PA_WORKPLAN_WORKFLOW as
2: /*$Header: PAXSTWWB.pls 120.9 2011/04/15 06:52:38 smadhava ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_workplan_workflow';
5:
6: procedure START_WORKFLOW
7: (
8: p_item_type IN VARCHAR2

Line 33: pa_workplan_workflow_client.start_workflow(p_item_type,

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,
34: x_item_key,
35: p_process_name,
36: p_structure_version_id,
37: p_responsibility_id,

Line 141: pa_workplan_workflow_client.set_notification_party

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: (
143: itemtype,
144: itemkey,
145: l_status,

Line 155: Wf_Core.Context('pa_workplan_workflow','check_workplan_status',itemtype,itemkey,to_char(actid),funcmode);

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;
158:
159: procedure change_status_working

Line 203: Wf_Core.Context('pa_workplan_workflow','change_status_working',itemtype,itemkey,to_char(actid),funcmode);

199: -- I havent reset value of resultout as this param is not assigned value anywhere in this API.
200: -- The Workflow function (Change Status to Working) doesnt expect any result type
201:
202: -- Included as per discussion with Rajnish : 4537865
203: Wf_Core.Context('pa_workplan_workflow','change_status_working',itemtype,itemkey,to_char(actid),funcmode);
204: RAISE;
205: END change_status_working;
206:
207: procedure change_status_rejected

Line 258: Wf_Core.Context('pa_workplan_workflow','change_status_rejected',itemtype,itemkey,to_char(actid),funcmode);

254: -- I havent reset value of resultout as this param is not assigned value anywhere in this API.
255: -- The Workflow function (Change Status to Rejected) doesnt expect any result type
256:
257: -- Included as per discussion with Rajnish : 4537865
258: Wf_Core.Context('pa_workplan_workflow','change_status_rejected',itemtype,itemkey,to_char(actid),funcmode);
259: RAISE;
260: END change_status_rejected;
261:
262: procedure change_status_approved

Line 314: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED Start', x_Log_Level=> 3);

310: ,aname => 'RECORD_VERSION_NUMBER');
311:
312: -- 4609421 : Added debug messages
313: IF l_debug_mode = 'Y' THEN
314: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED Start', x_Log_Level=> 3);
315: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
316: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_id='||l_structure_version_id, x_Log_Level=> 3);
317: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
318: END IF;

Line 315: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);

311:
312: -- 4609421 : Added debug messages
313: IF l_debug_mode = 'Y' THEN
314: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED Start', x_Log_Level=> 3);
315: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
316: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_id='||l_structure_version_id, x_Log_Level=> 3);
317: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
318: END IF;
319:

Line 316: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_id='||l_structure_version_id, x_Log_Level=> 3);

312: -- 4609421 : Added debug messages
313: IF l_debug_mode = 'Y' THEN
314: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED Start', x_Log_Level=> 3);
315: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
316: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_id='||l_structure_version_id, x_Log_Level=> 3);
317: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
318: END IF;
319:
320: OPEN is_auto_published;

Line 317: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);

313: IF l_debug_mode = 'Y' THEN
314: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED Start', x_Log_Level=> 3);
315: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_project_id='||l_project_id, x_Log_Level=> 3);
316: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_id='||l_structure_version_id, x_Log_Level=> 3);
317: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
318: END IF;
319:
320: OPEN is_auto_published;
321: FETCH is_auto_published into l_dummy;

Line 330: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_auto_publish_flag='||l_auto_publish_flag, x_Log_Level=> 3);

326: END IF;
327: CLOSE is_auto_published;
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_auto_publish_flag='||l_auto_publish_flag, x_Log_Level=> 3);
331: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling change_workplan_status', x_Log_Level=> 3);
332: END IF;
333:
334:

Line 331: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling change_workplan_status', x_Log_Level=> 3);

327: CLOSE is_auto_published;
328:
329: IF l_debug_mode = 'Y' THEN
330: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_auto_publish_flag='||l_auto_publish_flag, x_Log_Level=> 3);
331: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling change_workplan_status', x_Log_Level=> 3);
332: END IF;
333:
334:
335: PA_PROJECT_STRUCTURE_PVT1.change_workplan_status

Line 347: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);

343: ,x_msg_data => l_msg_data
344: );
345:
346: IF l_debug_mode = 'Y' THEN
347: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
348: END IF;
349:
350:
351: IF (l_return_status = FND_API.g_ret_sts_success) THEN

Line 389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);

385: ,itemkey => itemkey
386: ,aname => 'USER_ID');
387:
388: IF l_debug_mode = 'Y' THEN
389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);
390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);

Line 390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);

386: ,aname => 'USER_ID');
387:
388: IF l_debug_mode = 'Y' THEN
389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);
390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);
394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);

Line 391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);

387:
388: IF l_debug_mode = 'Y' THEN
389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);
390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);
394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);
395: END IF;

Line 392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);

388: IF l_debug_mode = 'Y' THEN
389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);
390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);
394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);
395: END IF;
396:

Line 393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);

389: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_name='||l_structure_version_name, x_Log_Level=> 3);
390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);
394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);
395: END IF;
396:
397: -- 4609421 : Added call of Set_Global_Info

Line 394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);

390: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_structure_version_desc='||l_structure_version_desc, x_Log_Level=> 3);
391: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_record_version_num='||l_record_version_num, x_Log_Level=> 3);
392: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_responsibility_id='||l_responsibility_id, x_Log_Level=> 3);
393: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_user_id='||l_user_id, x_Log_Level=> 3);
394: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling set global Info', x_Log_Level=> 3);
395: END IF;
396:
397: -- 4609421 : Added call of Set_Global_Info
398: -- Bug 6786278 - Changed l_msg_count to l_msg_data for parameter p_msg_data

Line 409: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);

405: ,p_return_status => l_return_status);
406:
407:
408: IF l_debug_mode = 'Y' THEN
409: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
410: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling Publish_Structure', x_Log_Level=> 3);
411: END IF;
412:
413: --call publish api

Line 410: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling Publish_Structure', x_Log_Level=> 3);

406:
407:
408: IF l_debug_mode = 'Y' THEN
409: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
410: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Calling Publish_Structure', x_Log_Level=> 3);
411: END IF;
412:
413: --call publish api
414: PA_PROJECT_STRUCTURE_PUB1.Publish_Structure(

Line 429: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);

425: ,x_msg_data => l_msg_data
426: );
427:
428: IF l_debug_mode = 'Y' THEN
429: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
430: for i in 1..fnd_msg_pub.count_msg loop
431: pa_interface_utils_pub.get_messages (
432: p_encoded => Fnd_Api.G_FALSE
433: ,p_data => l_data

Line 438: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Error='||l_data, x_Log_Level=> 3);

434: ,p_msg_index => i
435: ,p_msg_count => l_msg_count
436: ,p_msg_data => l_msg_data
437: ,p_msg_index_out => l_msg_index_out );
438: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'Error='||l_data, x_Log_Level=> 3);
439: end loop;
440: END IF;
441:
442: --set structure_ver_id

Line 456: Wf_Core.Context('pa_workplan_workflow','change_status_approved',itemtype,itemkey,to_char(actid),funcmode);

452: -- I havent reset value of resultout as this param is not assigned value anywhere in this API.
453: -- The Workflow function (Change Status to Approved) doesnt expect any result type
454:
455: -- Included as per discussion with Rajnish : 4537865
456: Wf_Core.Context('pa_workplan_workflow','change_status_approved',itemtype,itemkey,to_char(actid),funcmode);
457: RAISE;
458: END change_status_approved;
459:
460:

Line 634: Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',p_item_type,p_item_key,to_char(actid),funcmode);

630: -- I havent reset value of resultout as this param is not assigned value anywhere in this API.
631: -- The Workflow function (Select Error Receiver) doesnt expect any result type
632:
633: -- Included as per discussion with Rajnish : 4537865
634: Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',p_item_type,p_item_key,to_char(actid),funcmode);
635: RAISE;
636: END SELECT_ERROR_RECEIVER;
637:
638:

Line 867: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_WORKFLOW',

863: x_msg_count :=1;
864: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: /* 5369295 -- Added fnd_msg_pub.add_exc_msg() for bug 5366726 */
867: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_WORKFLOW',
868: p_procedure_name => 'START_PROJECT_EXECUTION_WF',
869: p_error_text => SUBSTRB(SQLERRM,1,240));
870:
871: END START_PROJECT_EXECUTION_WF ;

Line 1033: PA_WORKPLAN_WORKFLOW_CLIENT.SET_LEAD_DAYS(

1029:
1030: -- The task execution workflow will be started on the date
1031: -- when the schedule start date minus the Task execution Lead Time
1032:
1033: PA_WORKPLAN_WORKFLOW_CLIENT.SET_LEAD_DAYS(
1034: p_item_type => get_all_tasks_rec.wf_item_type
1035: ,p_task_number => get_all_tasks_rec.element_number
1036: ,p_project_number => l_project_number
1037: ,x_lead_days => l_lead_days

Line 1093: Wf_Core.Context('pa_workplan_workflow','START_TASK_EXECUTION_WF',itemtype,itemkey,to_char(actid),funcmode);

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:
1097:

Line 1344: Wf_Core.Context('pa_workplan_workflow','SELECT_ERROR_RECEIVER',itemtype,itemkey,to_char(actid),funcmode);

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;
1346: END IS_PROJECT_CLOSED ;
1347: -- FP M : Project Execution Workflow
1348:

Line 1349: END PA_WORKPLAN_WORKFLOW;

1345: RAISE;
1346: END IS_PROJECT_CLOSED ;
1347: -- FP M : Project Execution Workflow
1348:
1349: END PA_WORKPLAN_WORKFLOW;