DBA Data[Home] [Help]

APPS.PA_WORKFLOW_UTILS dependencies on FND_PROFILE

Line 67: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

63: --
64:
65: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
66: l_description pa_wf_processes.description%TYPE;
67: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
68:
69: BEGIN
70:
71: IF P_PA_DEBUG_MODE = 'Y' Then

Line 202: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

198: l_msg_data VARCHAR2(500) := 0;
199: l_data VARCHAR2(500) := 0;
200: l_return_status VARCHAR2(1) ;
201: l_msg_index_out NUMBER;
202: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
203:
204: BEGIN
205: IF P_PA_DEBUG_MODE = 'Y' Then
206: PA_DEBUG.g_err_stage := 'Procedure Set_Global_Attr - Begin';

Line 310: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

306: l_msg_count NUMBER := 0;
307: l_msg_text VARCHAR2(2000) := NULL;
308: l_encoded_mesg VARCHAR2(2000);
309:
310: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
311: BEGIN
312: IF P_PA_DEBUG_MODE = 'Y' Then
313: PA_DEBUG.g_err_stage := 'Procedure Set_Notification_Messages - Begin';
314: PA_DEBUG.write

Line 473: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

469: WHERE
470: status_type = p_project_status_type
471: AND
472: project_status_code = p_project_status_code;
473: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
474: BEGIN
475: IF P_PA_DEBUG_MODE = 'Y' Then
476: PA_DEBUG.g_err_stage := 'Procedure get_workflow_info - Begin';
477: PA_DEBUG.write

Line 532: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

528: )
529:
530: IS
531:
532: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
533:
534: BEGIN
535:
536: IF P_PA_DEBUG_MODE = 'Y' Then

Line 601: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

597: )
598: IS
599:
600: l_item_key NUMBER;
601: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
602:
603: BEGIN
604: IF P_PA_DEBUG_MODE = 'Y' Then
605: PA_DEBUG.g_err_stage := 'Procedure create_workflow_process - Begin';

Line 687: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

683: IS
684: l_err_code NUMBER;
685: l_err_stage VARCHAR2(30);
686: l_err_stack VARCHAR2(240);
687: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
688:
689: BEGIN
690: IF P_PA_DEBUG_MODE = 'Y' Then
691: PA_DEBUG.g_err_stage := 'Procedure start_workflow_process - Begin';

Line 839: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

835:
836: STYLE_TAG varchar2(22) := ' 837:
838: INPUT_TAG constant varchar2(6) := ' 839: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
840:
841: BEGIN
842: IF P_PA_DEBUG_MODE = 'Y' Then
843: PA_DEBUG.g_err_stage := 'Procedure modify_wf_clob_content - Begin';

Line 859: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

855: END IF;
856: x_msg_count := 0;
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858: pa_debug.set_err_stack('PA_WORKFLOW_UTILS.modify_wf_clob_content');
859: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
860: l_debug_mode := NVL(l_debug_mode, 'Y');
861: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
862: l_start_index := dbms_lob.instr(p_document,l_class_attr,1,1);
863: while l_start_index <> 0 loop