DBA Data[Home] [Help]

APPS.OKC_ASYNC_PVT dependencies on FND_GLOBAL

Line 56: avalue => fnd_global.user_id);

52: begin
53: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
54: itemkey => p_key,
55: aname => 'USER_ID',
56: avalue => fnd_global.user_id);
57: IF (l_debug = 'Y') THEN
58: okc_debug.Log('001 in set_env user_id:'||fnd_global.user_id,2);
59: END IF;
60: exception

Line 58: okc_debug.Log('001 in set_env user_id:'||fnd_global.user_id,2);

54: itemkey => p_key,
55: aname => 'USER_ID',
56: avalue => fnd_global.user_id);
57: IF (l_debug = 'Y') THEN
58: okc_debug.Log('001 in set_env user_id:'||fnd_global.user_id,2);
59: END IF;
60: exception
61: when others then
62: wf_engine.AddItemAttr (itemtype => p_wf_name,

Line 68: avalue => fnd_global.user_id);

64: aname => 'USER_ID');
65: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
66: itemkey => p_key,
67: aname => 'USER_ID',
68: avalue => fnd_global.user_id);
69: IF (l_debug = 'Y') THEN
70: okc_debug.Log('002 in set_env user_id:'||fnd_global.user_id,2);
71: END IF;
72: end;

Line 70: okc_debug.Log('002 in set_env user_id:'||fnd_global.user_id,2);

66: itemkey => p_key,
67: aname => 'USER_ID',
68: avalue => fnd_global.user_id);
69: IF (l_debug = 'Y') THEN
70: okc_debug.Log('002 in set_env user_id:'||fnd_global.user_id,2);
71: END IF;
72: end;
73: begin
74: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,

Line 77: avalue => fnd_global.resp_id);

73: begin
74: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
75: itemkey => p_key,
76: aname => 'RESP_ID',
77: avalue => fnd_global.resp_id);
78: IF (l_debug = 'Y') THEN
79: okc_debug.Log('003 in set_env resp_id:'||fnd_global.resp_id,2);
80: END IF;
81: exception

Line 79: okc_debug.Log('003 in set_env resp_id:'||fnd_global.resp_id,2);

75: itemkey => p_key,
76: aname => 'RESP_ID',
77: avalue => fnd_global.resp_id);
78: IF (l_debug = 'Y') THEN
79: okc_debug.Log('003 in set_env resp_id:'||fnd_global.resp_id,2);
80: END IF;
81: exception
82: when others then
83: wf_engine.AddItemAttr (itemtype => p_wf_name,

Line 89: avalue => fnd_global.resp_id);

85: aname => 'RESP_ID');
86: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
87: itemkey => p_key,
88: aname => 'RESP_ID',
89: avalue => fnd_global.resp_id);
90: IF (l_debug = 'Y') THEN
91: okc_debug.Log('004 in set_env resp_id:'||fnd_global.resp_id,2);
92: END IF;
93: end;

Line 91: okc_debug.Log('004 in set_env resp_id:'||fnd_global.resp_id,2);

87: itemkey => p_key,
88: aname => 'RESP_ID',
89: avalue => fnd_global.resp_id);
90: IF (l_debug = 'Y') THEN
91: okc_debug.Log('004 in set_env resp_id:'||fnd_global.resp_id,2);
92: END IF;
93: end;
94: begin
95: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,

Line 98: avalue => fnd_global.RESP_APPL_id);

94: begin
95: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
96: itemkey => p_key,
97: aname => 'RESP_APPL_ID',
98: avalue => fnd_global.RESP_APPL_id);
99: IF (l_debug = 'Y') THEN
100: okc_debug.Log('005 in set_env resp_id:'||fnd_global.resp_appl_id,2);
101: END IF;
102: exception

Line 100: okc_debug.Log('005 in set_env resp_id:'||fnd_global.resp_appl_id,2);

96: itemkey => p_key,
97: aname => 'RESP_APPL_ID',
98: avalue => fnd_global.RESP_APPL_id);
99: IF (l_debug = 'Y') THEN
100: okc_debug.Log('005 in set_env resp_id:'||fnd_global.resp_appl_id,2);
101: END IF;
102: exception
103: when others then
104: wf_engine.AddItemAttr (itemtype => p_wf_name,

Line 110: avalue => fnd_global.RESP_APPL_id);

106: aname => 'RESP_APPL_ID');
107: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
108: itemkey => p_key,
109: aname => 'RESP_APPL_ID',
110: avalue => fnd_global.RESP_APPL_id);
111: IF (l_debug = 'Y') THEN
112: okc_debug.Log('006 in set_env resp_id:'||fnd_global.resp_appl_id,2);
113: END IF;
114: end;

Line 112: okc_debug.Log('006 in set_env resp_id:'||fnd_global.resp_appl_id,2);

108: itemkey => p_key,
109: aname => 'RESP_APPL_ID',
110: avalue => fnd_global.RESP_APPL_id);
111: IF (l_debug = 'Y') THEN
112: okc_debug.Log('006 in set_env resp_id:'||fnd_global.resp_appl_id,2);
113: END IF;
114: end;
115: --
116: -- save NLS/NTF preferences from P_RESOLVER/P_S_RECIPIENT/P_E_RECIPIENT/apps

Line 312: avalue => fnd_global.user_name);

308: if (p_proc is NULL and p_s_recipient is NULL) then
309: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
310: itemkey => L_KEY,
311: aname => 'P_S_RECIPIENT',
312: avalue => fnd_global.user_name);
313: IF (l_debug = 'Y') THEN
314: okc_debug.Log('009 in wf_call p_s_recipient :'||fnd_global.user_name,2);
315: END IF;
316: else

Line 314: okc_debug.Log('009 in wf_call p_s_recipient :'||fnd_global.user_name,2);

310: itemkey => L_KEY,
311: aname => 'P_S_RECIPIENT',
312: avalue => fnd_global.user_name);
313: IF (l_debug = 'Y') THEN
314: okc_debug.Log('009 in wf_call p_s_recipient :'||fnd_global.user_name,2);
315: END IF;
316: else
317: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
318: itemkey => L_KEY,

Line 402: owner => fnd_global.user_name);

398: --
399: save_env(G_WF_NAME, l_key);
400: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
401: itemkey => L_KEY,
402: owner => fnd_global.user_name);
403:
404: IF (l_debug = 'Y') THEN
405: okc_debug.Log('100: WF Owner : '||fnd_global.user_name,2);
406: END IF;

Line 405: okc_debug.Log('100: WF Owner : '||fnd_global.user_name,2);

401: itemkey => L_KEY,
402: owner => fnd_global.user_name);
403:
404: IF (l_debug = 'Y') THEN
405: okc_debug.Log('100: WF Owner : '||fnd_global.user_name,2);
406: END IF;
407:
408: wf_engine.StartProcess( itemtype => G_WF_NAME,
409: itemkey => L_KEY);

Line 516: fnd_global.apps_initialize

512: end if;
513: --
514: -- set apps context
515: --
516: fnd_global.apps_initialize
517: (
518: user_id =>
519: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'USER_ID'),
520: resp_id =>

Line 526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);

522: resp_appl_id =>
523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')
524: );
525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);
527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);
528: okc_debug.Log('100-13: RESP_ID = '|| to_char(fnd_global.resp_id),2);
529: okc_debug.Log('100-14: RESP_APPL_ID = '|| to_char(fnd_global.resp_appl_id),2);
530: END IF;

Line 527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);

523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')
524: );
525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);
527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);
528: okc_debug.Log('100-13: RESP_ID = '|| to_char(fnd_global.resp_id),2);
529: okc_debug.Log('100-14: RESP_APPL_ID = '|| to_char(fnd_global.resp_appl_id),2);
530: END IF;
531:

Line 528: okc_debug.Log('100-13: RESP_ID = '|| to_char(fnd_global.resp_id),2);

524: );
525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);
527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);
528: okc_debug.Log('100-13: RESP_ID = '|| to_char(fnd_global.resp_id),2);
529: okc_debug.Log('100-14: RESP_APPL_ID = '|| to_char(fnd_global.resp_appl_id),2);
530: END IF;
531:
532:

Line 529: okc_debug.Log('100-14: RESP_APPL_ID = '|| to_char(fnd_global.resp_appl_id),2);

525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);
527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);
528: okc_debug.Log('100-13: RESP_ID = '|| to_char(fnd_global.resp_id),2);
529: okc_debug.Log('100-14: RESP_APPL_ID = '|| to_char(fnd_global.resp_appl_id),2);
530: END IF;
531:
532:
533: --

Line 606: G_USER_ID := FND_GLOBAL.user_id;

602:
603: OPEN req_submit_csr;
604: FETCH req_submit_csr INTO l_created_by;
605: IF req_submit_csr%NOTFOUND THEN
606: G_USER_ID := FND_GLOBAL.user_id;
607: ELSE
608: G_USER_ID := l_created_by;
609: END IF;
610:

Line 926: nl:=fnd_global.NewLine;

922: okc_debug.Set_Indentation(l_proc);
923: okc_debug.Log('10: Entering ',2);
924: END IF;
925:
926: nl:=fnd_global.NewLine;
927: P_SUBJ_FIRST_MSG := wf_engine.GetItemAttrText(itemtype,itemkey,'P_SUBJ_FIRST_MSG');
928: j := NVL(FND_MSG_PUB.Count_Msg,0);
929:
930: if (j=0) then

Line 1724: owner => fnd_global.user_name);

1720: --
1721: save_env(G_WF_NAME, l_key);
1722: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
1723: itemkey => L_KEY,
1724: owner => fnd_global.user_name);
1725: wf_engine.StartProcess( itemtype => G_WF_NAME,
1726: itemkey => L_KEY);
1727: -- commit;
1728: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2201: owner => fnd_global.user_name);

2197: --
2198: save_env(G_WF_NAME, l_key);
2199: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
2200: itemkey => L_KEY,
2201: owner => fnd_global.user_name);
2202:
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.Log('50: WF Owner : '||fnd_global.user_name,2);
2205: END IF;

Line 2204: okc_debug.Log('50: WF Owner : '||fnd_global.user_name,2);

2200: itemkey => L_KEY,
2201: owner => fnd_global.user_name);
2202:
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.Log('50: WF Owner : '||fnd_global.user_name,2);
2205: END IF;
2206:
2207: wf_engine.StartProcess( itemtype => G_WF_NAME,
2208: itemkey => L_KEY);