DBA Data[Home] [Help]

APPS.PA_AUTOALLOC_WF_PKG dependencies on FND_PROFILE

Line 38: /*Bug:920470. set user_id, resp_id etc. before calling fnd_profile.get()*/

34: process => 'PA_AUTO_ALLOC_PROCESS');
35: /* dbms_output.put_line('Created Process'); */
36: Init_PA_WF_Stack (PA_Item_Type,PA_Item_Key,v_Err_Stack);
37:
38: /*Bug:920470. set user_id, resp_id etc. before calling fnd_profile.get()*/
39: v_user_id := WF_ENGINE.GetItemAttrNumber
40: (PA_item_type,
41: PA_item_key,
42: 'USER_ID');

Line 64: FND_PROFILE.put('LANG', v_lang);

60: (PA_item_type,
61: PA_item_key,
62: 'LANG');
63:
64: FND_PROFILE.put('LANG', v_lang);
65:
66: -- Fix for bug : 4640479
67: -- FND_PROFILE.put('ORG_ID', v_org_id);
68: MO_GLOBAL.set_policy_context('S',v_org_id);

Line 67: -- FND_PROFILE.put('ORG_ID', v_org_id);

63:
64: FND_PROFILE.put('LANG', v_lang);
65:
66: -- Fix for bug : 4640479
67: -- FND_PROFILE.put('ORG_ID', v_org_id);
68: MO_GLOBAL.set_policy_context('S',v_org_id);
69: FND_PROFILE.put('USER_ID', v_user_id );
70: FND_PROFILE.put('RESP_ID', v_resp_id);
71: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

Line 69: FND_PROFILE.put('USER_ID', v_user_id );

65:
66: -- Fix for bug : 4640479
67: -- FND_PROFILE.put('ORG_ID', v_org_id);
68: MO_GLOBAL.set_policy_context('S',v_org_id);
69: FND_PROFILE.put('USER_ID', v_user_id );
70: FND_PROFILE.put('RESP_ID', v_resp_id);
71: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
72: /*end bug920470*/
73:

Line 70: FND_PROFILE.put('RESP_ID', v_resp_id);

66: -- Fix for bug : 4640479
67: -- FND_PROFILE.put('ORG_ID', v_org_id);
68: MO_GLOBAL.set_policy_context('S',v_org_id);
69: FND_PROFILE.put('USER_ID', v_user_id );
70: FND_PROFILE.put('RESP_ID', v_resp_id);
71: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
72: /*end bug920470*/
73:
74: /*Bug 931037.set workflow attribute DEBUG_MODE,then get the attribute value from

Line 71: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

67: -- FND_PROFILE.put('ORG_ID', v_org_id);
68: MO_GLOBAL.set_policy_context('S',v_org_id);
69: FND_PROFILE.put('USER_ID', v_user_id );
70: FND_PROFILE.put('RESP_ID', v_resp_id);
71: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
72: /*end bug920470*/
73:
74: /*Bug 931037.set workflow attribute DEBUG_MODE,then get the attribute value from
75: function DebugFlag */

Line 76: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);

72: /*end bug920470*/
73:
74: /*Bug 931037.set workflow attribute DEBUG_MODE,then get the attribute value from
75: function DebugFlag */
76: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);
77: Wf_Engine.SetItemAttrText( itemtype => PA_item_type,
78: itemkey => PA_item_key,
79: aname => 'DEBUG_MODE',
80: avalue => v_debug_mode);

Line 87: -- Commented out for bug 5218394 v_debug_file_dir := NVL(FND_PROFILE.VALUE('PA_DEBUG_LOG_DIRECTORY'),'/sqlcom/log');

83: /* Set attribute DEBUG_FILE_DIR and initialize debug only if
84: Debug Flag is on */
85: if DebugFlag then
86: v_debug_file_dir := GetDebugLogDir; -- Added for bug 5218394
87: -- Commented out for bug 5218394 v_debug_file_dir := NVL(FND_PROFILE.VALUE('PA_DEBUG_LOG_DIRECTORY'),'/sqlcom/log');
88:
89: wf_engine.SetItemAttrText( itemtype => PA_item_type,
90: itemkey => PA_item_key,
91: aname => 'DEBUG_FILE_DIR',

Line 238: v_lang fnd_profile_option_values.profile_option_value%TYPE;

234: v_batch_name Varchar2(60);
235: v_batch_type_code Varchar2(1);
236: v_allocation_method_code Varchar2(1);
237: v_step_number Number;
238: v_lang fnd_profile_option_values.profile_option_value%TYPE;
239: v_value fnd_profile_option_values.profile_option_value%TYPE;
240: v_launched_from VARCHAR2(10);
241:
242: Begin

Line 239: v_value fnd_profile_option_values.profile_option_value%TYPE;

235: v_batch_type_code Varchar2(1);
236: v_allocation_method_code Varchar2(1);
237: v_step_number Number;
238: v_lang fnd_profile_option_values.profile_option_value%TYPE;
239: v_value fnd_profile_option_values.profile_option_value%TYPE;
240: v_launched_from VARCHAR2(10);
241:
242: Begin
243:

Line 795: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);

791: 'PAXACMPT');
792: WriteDebugMsg('Attribute CONC_PRG_CODE = PAXACMPT');
793:
794: /* Get Parameters needed to submit the concurrent Process */
795: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);
796: WriteDebugMsg('Debug Mode value = '||v_debug_mode);
797:
798: /** Set default values to all required parameters **/
799: v_request_id := Submit_Conc_Process(p_prog_code => 'PAXACMPT'

Line 1204: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);

1200: p_item_key,
1201: 'EXPENDITURE_GROUP');
1202: WriteDebugMsg('The attribute EXPENDITURE_GROUP is '||v_expenditure_group);
1203:
1204: FND_PROFILE.GET('PA_DEBUG_MODE',v_debug_mode);
1205: Writedebugmsg('Debug Mode = '||v_debug_mode);
1206:
1207: /* Bug 2497324 change p_arg9 to p_arg11 as two parameters added in the process */
1208: v_request_id := Submit_Conc_Process(

Line 1374: FND_PROFILE.put('LANG', v_lang);

1370: (PA_item_type,
1371: PA_item_key,
1372: 'LAST_UPDATE_LOGIN');
1373:
1374: FND_PROFILE.put('LANG', v_lang);
1375: -- Fix for bug : 4640479
1376: -- FND_PROFILE.put('ORG_ID', v_org_id);
1377: MO_GLOBAL.set_policy_context('S',v_org_id);
1378: FND_PROFILE.put('USER_ID', v_user_id );

Line 1376: -- FND_PROFILE.put('ORG_ID', v_org_id);

1372: 'LAST_UPDATE_LOGIN');
1373:
1374: FND_PROFILE.put('LANG', v_lang);
1375: -- Fix for bug : 4640479
1376: -- FND_PROFILE.put('ORG_ID', v_org_id);
1377: MO_GLOBAL.set_policy_context('S',v_org_id);
1378: FND_PROFILE.put('USER_ID', v_user_id );
1379: FND_PROFILE.put('RESP_ID', v_resp_id);
1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

Line 1378: FND_PROFILE.put('USER_ID', v_user_id );

1374: FND_PROFILE.put('LANG', v_lang);
1375: -- Fix for bug : 4640479
1376: -- FND_PROFILE.put('ORG_ID', v_org_id);
1377: MO_GLOBAL.set_policy_context('S',v_org_id);
1378: FND_PROFILE.put('USER_ID', v_user_id );
1379: FND_PROFILE.put('RESP_ID', v_resp_id);
1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1381:
1382: FND_PROFILE.GET('LANG', v_userenv_lang);

Line 1379: FND_PROFILE.put('RESP_ID', v_resp_id);

1375: -- Fix for bug : 4640479
1376: -- FND_PROFILE.put('ORG_ID', v_org_id);
1377: MO_GLOBAL.set_policy_context('S',v_org_id);
1378: FND_PROFILE.put('USER_ID', v_user_id );
1379: FND_PROFILE.put('RESP_ID', v_resp_id);
1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1381:
1382: FND_PROFILE.GET('LANG', v_userenv_lang);
1383: WriteDebugMsg('User Env. Lang = '||v_userenv_lang);

Line 1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

1376: -- FND_PROFILE.put('ORG_ID', v_org_id);
1377: MO_GLOBAL.set_policy_context('S',v_org_id);
1378: FND_PROFILE.put('USER_ID', v_user_id );
1379: FND_PROFILE.put('RESP_ID', v_resp_id);
1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1381:
1382: FND_PROFILE.GET('LANG', v_userenv_lang);
1383: WriteDebugMsg('User Env. Lang = '||v_userenv_lang);
1384:

Line 1382: FND_PROFILE.GET('LANG', v_userenv_lang);

1378: FND_PROFILE.put('USER_ID', v_user_id );
1379: FND_PROFILE.put('RESP_ID', v_resp_id);
1380: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1381:
1382: FND_PROFILE.GET('LANG', v_userenv_lang);
1383: WriteDebugMsg('User Env. Lang = '||v_userenv_lang);
1384:
1385: Open conc_prog_name_C;
1386: Fetch conc_prog_name_C into v_conc_prg_name;

Line 1713: FND_PROFILE.put('LANG', v_lang);

1709: (PA_item_type,
1710: PA_item_key,
1711: 'LANG');
1712:
1713: FND_PROFILE.put('LANG', v_lang);
1714: -- Fix for bug : 4640479
1715: -- FND_PROFILE.put('ORG_ID', v_org_id);
1716: MO_GLOBAL.set_policy_context('S',v_org_id);
1717: FND_PROFILE.put('USER_ID', v_user_id );

Line 1715: -- FND_PROFILE.put('ORG_ID', v_org_id);

1711: 'LANG');
1712:
1713: FND_PROFILE.put('LANG', v_lang);
1714: -- Fix for bug : 4640479
1715: -- FND_PROFILE.put('ORG_ID', v_org_id);
1716: MO_GLOBAL.set_policy_context('S',v_org_id);
1717: FND_PROFILE.put('USER_ID', v_user_id );
1718: FND_PROFILE.put('RESP_ID', v_resp_id);
1719: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

Line 1717: FND_PROFILE.put('USER_ID', v_user_id );

1713: FND_PROFILE.put('LANG', v_lang);
1714: -- Fix for bug : 4640479
1715: -- FND_PROFILE.put('ORG_ID', v_org_id);
1716: MO_GLOBAL.set_policy_context('S',v_org_id);
1717: FND_PROFILE.put('USER_ID', v_user_id );
1718: FND_PROFILE.put('RESP_ID', v_resp_id);
1719: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1720:
1721: v_call_status :=

Line 1718: FND_PROFILE.put('RESP_ID', v_resp_id);

1714: -- Fix for bug : 4640479
1715: -- FND_PROFILE.put('ORG_ID', v_org_id);
1716: MO_GLOBAL.set_policy_context('S',v_org_id);
1717: FND_PROFILE.put('USER_ID', v_user_id );
1718: FND_PROFILE.put('RESP_ID', v_resp_id);
1719: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1720:
1721: v_call_status :=
1722: Fnd_Concurrent.Wait_For_Request(

Line 1719: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);

1715: -- FND_PROFILE.put('ORG_ID', v_org_id);
1716: MO_GLOBAL.set_policy_context('S',v_org_id);
1717: FND_PROFILE.put('USER_ID', v_user_id );
1718: FND_PROFILE.put('RESP_ID', v_resp_id);
1719: FND_PROFILE.put('RESP_APPL_ID', v_resp_appl_id);
1720:
1721: v_call_status :=
1722: Fnd_Concurrent.Wait_For_Request(
1723: request_id => v_request_id