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_DEBUG

Line 292: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

288: where project_id = l_project_id
289: and WP_AUTO_PUBLISH_FLAG = 'Y';
290:
291: -- 4609421 : Following three variables
292: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
293: l_msg_index_out NUMBER;
294: l_data VARCHAR2(300);
295:
296: BEGIN

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 754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

750:
751: BEGIN
752: x_msg_count := 0;
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
755:
756: IF l_debug_mode = 'Y' THEN
757: PA_DEBUG.set_curr_function( p_function => 'START_PROJECT_EXECUTION_WF',
758: p_debug_mode => l_debug_mode );

Line 757: PA_DEBUG.set_curr_function( p_function => 'START_PROJECT_EXECUTION_WF',

753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
755:
756: IF l_debug_mode = 'Y' THEN
757: PA_DEBUG.set_curr_function( p_function => 'START_PROJECT_EXECUTION_WF',
758: p_debug_mode => l_debug_mode );
759: END IF;
760:
761: OPEN is_wf_running;

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 786: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

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;
790: FETCH proj_number INTO proj_number_rec;

Line 799: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Setting project Id';

795: process => l_process_name
796: );
797:
798: IF l_debug_mode = 'Y' THEN
799: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Setting project Id';
800: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
801: END IF ;
802:
803: -- Set attribute Project Id

Line 800: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

796: );
797:
798: IF l_debug_mode = 'Y' THEN
799: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Setting project Id';
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

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 828: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

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
832: ,to_char(p_project_id));

Line 968: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

964: get_all_tasks_rec get_all_tasks%ROWTYPE ;
965:
966: BEGIN
967:
968: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
969:
970: IF l_debug_mode = 'Y' THEN
971: PA_DEBUG.set_curr_function( p_function => 'START_TASK_EXECUTION_WF',
972: p_debug_mode => l_debug_mode );

Line 971: PA_DEBUG.set_curr_function( p_function => 'START_TASK_EXECUTION_WF',

967:
968: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
969:
970: IF l_debug_mode = 'Y' THEN
971: PA_DEBUG.set_curr_function( p_function => 'START_TASK_EXECUTION_WF',
972: p_debug_mode => l_debug_mode );
973: END IF;
974:
975: -- Return if WF Not Running

Line 982: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get Project Id';

978: RETURN;
979: END IF;
980:
981: IF l_debug_mode = 'Y' THEN
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

Line 983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

979: END IF;
980:
981: IF l_debug_mode = 'Y' THEN
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

Line 997: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get the latest published version';

993: ,itemkey => itemkey
994: ,aname => 'PROJECT_NUMBER') ;
995:
996: IF l_debug_mode = 'Y' THEN
997: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get the latest published version';
998: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
999: END IF ;
1000:
1001: -- Check whether versioning is enabled

Line 998: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

994: ,aname => 'PROJECT_NUMBER') ;
995:
996: IF l_debug_mode = 'Y' THEN
997: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get the latest published version';
998: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
999: END IF ;
1000:
1001: -- Check whether versioning is enabled
1002: l_versioned := PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(l_project_id);

Line 1017: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get all the tasks ';

1013: CLOSE get_struct_version_id ;
1014: END IF ;
1015:
1016: IF l_debug_mode = 'Y' THEN
1017: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get all the tasks ';
1018: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1019: END IF ;
1020:
1021: -- For all the tasks for which WP is enabled loop.

Line 1018: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1014: END IF ;
1015:
1016: IF l_debug_mode = 'Y' THEN
1017: Pa_Debug.g_err_stage:= 'START_TASK_EXECUTION_WF : Get all the tasks ';
1018: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1019: END IF ;
1020:
1021: -- For all the tasks for which WP is enabled loop.
1022: FOR get_all_tasks_rec IN get_all_tasks(l_structure_version_id) LOOP

Line 1048: Pa_Debug.g_err_stage:= 'START_PROJECT_EXECUTION_WF : Create Process';

1044: INTO l_item_key
1045: FROM dual;
1046:
1047: IF l_debug_mode = 'Y' THEN
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,

Line 1049: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1045: FROM dual;
1046:
1047: IF l_debug_mode = 'Y' THEN
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),

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 1066: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

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
1070: ,to_char(l_item_key));

Line 1127: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1123: task_info_rec task_info%ROWTYPE ;
1124:
1125: BEGIN
1126:
1127: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1128:
1129: IF l_debug_mode = 'Y' THEN
1130: PA_DEBUG.set_curr_function( p_function => 'RESTART_TASK_EXECUTION_WF',
1131: p_debug_mode => l_debug_mode );

Line 1130: PA_DEBUG.set_curr_function( p_function => 'RESTART_TASK_EXECUTION_WF',

1126:
1127: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1128:
1129: IF l_debug_mode = 'Y' THEN
1130: PA_DEBUG.set_curr_function( p_function => 'RESTART_TASK_EXECUTION_WF',
1131: p_debug_mode => l_debug_mode );
1132: END IF;
1133:
1134:

Line 1136: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Open Cursor task_info';

1132: END IF;
1133:
1134:
1135: IF l_debug_mode = 'Y' THEN
1136: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Open Cursor task_info';
1137: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1138: END IF ;
1139:
1140: OPEN task_info ;

Line 1137: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1133:
1134:
1135: IF l_debug_mode = 'Y' THEN
1136: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Open Cursor task_info';
1137: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1138: END IF ;
1139:
1140: OPEN task_info ;
1141: FETCH task_info INTO task_info_rec ;

Line 1172: Pa_Debug.g_err_stage:= 'RESTART_TASK_EXECUTION_WF : Create Process';

1168: INTO l_item_key
1169: FROM dual;
1170:
1171: IF l_debug_mode = 'Y' THEN
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,

Line 1173: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1169: FROM dual;
1170:
1171: IF l_debug_mode = 'Y' THEN
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),

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 1190: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

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
1194: ,to_char(l_item_key));

Line 1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1246:
1247: BEGIN
1248:
1249: x_return_status := FND_API.g_ret_sts_success;
1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1251:
1252: IF l_debug_mode = 'Y' THEN
1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';
1254: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

Line 1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';

1249: x_return_status := FND_API.g_ret_sts_success;
1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1251:
1252: IF l_debug_mode = 'Y' THEN
1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';
1254: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1255: END IF ;
1256:
1257: OPEN get_item_type ;

Line 1254: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1251:
1252: IF l_debug_mode = 'Y' THEN
1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';
1254: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);
1255: END IF ;
1256:
1257: OPEN get_item_type ;
1258: FETCH get_item_type INTO get_item_type_rec ;

Line 1306: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1302: proj_status_cur_rec proj_status_cur%ROWTYPE ;
1303:
1304: BEGIN
1305:
1306: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1307:
1308: IF l_debug_mode = 'Y' THEN
1309: PA_DEBUG.set_curr_function( p_function => 'IS_PROJECT_CLOSED',
1310: p_debug_mode => l_debug_mode );

Line 1309: PA_DEBUG.set_curr_function( p_function => 'IS_PROJECT_CLOSED',

1305:
1306: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1307:
1308: IF l_debug_mode = 'Y' THEN
1309: PA_DEBUG.set_curr_function( p_function => 'IS_PROJECT_CLOSED',
1310: p_debug_mode => l_debug_mode );
1311: END IF;
1312:
1313: -- Return if WF Not Running

Line 1320: Pa_Debug.g_err_stage:= 'IS_PROJECT_CLOSED : Get Project Id';

1316: RETURN;
1317: END IF;
1318:
1319: IF l_debug_mode = 'Y' THEN
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

Line 1321: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,3);

1317: END IF;
1318:
1319: IF l_debug_mode = 'Y' THEN
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