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.OKL_AM_WF dependencies on OKL_DEBUG_PUB

Line 46: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

42: l_process_desc VARCHAR2(100);
43:
44: -- for debug logging
45: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_wf_launch_message';
46: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
47: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
48: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
49:
50: BEGIN

Line 47: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

43:
44: -- for debug logging
45: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_wf_launch_message';
46: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
47: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
48: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
49:
50: BEGIN
51:

Line 48: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

44: -- for debug logging
45: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_wf_launch_message';
46: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
47: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
48: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
49:
50: BEGIN
51:
52: IF (is_debug_procedure_on) THEN

Line 53: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

49:
50: BEGIN
51:
52: IF (is_debug_procedure_on) THEN
53: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
54: END IF;
55:
56: OPEN c_get_wf_details_csr(p_event_name);
57: FETCH c_get_wf_details_csr INTO l_wf_desc, l_process_desc;

Line 72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

68: END IF;
69: CLOSE c_get_wf_details_csr;
70:
71: IF (is_debug_procedure_on) THEN
72: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
73: END IF;
74:
75: EXCEPTION
76: WHEN OTHERS THEN

Line 121: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

117: and kln.dnz_chr_id = khr.id;
118:
119: -- for debug logging
120: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
121: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
122: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
123: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
124: BEGIN
125:

Line 122: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

118:
119: -- for debug logging
120: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
121: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
122: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
123: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
124: BEGIN
125:
126: IF (is_debug_procedure_on) THEN

Line 123: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

119: -- for debug logging
120: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
121: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
122: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
123: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
124: BEGIN
125:
126: IF (is_debug_procedure_on) THEN
127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

123: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
124: BEGIN
125:
126: IF (is_debug_procedure_on) THEN
127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
128: END IF;
129:
130: SAVEPOINT raise_event;
131:

Line 177: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : event name '||p_event_name);

173: -- that is going to initiate the workflow request. These values will later be used to set the context
174: -- within the workflow, in callback procedure.
175:
176: IF (is_debug_procedure_on) THEN
177: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : event name '||p_event_name);
178: end if;
179:
180: -- rmunjulu added oracle.apps.okl.cs.transferandassumption for bug 11717591
181: if p_event_name in ( 'oracle.apps.okl.am.preproceeds',

Line 189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);

185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;

Line 190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);

186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;
194:

Line 191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);

187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;
194:
195: --vsgandhi

Line 203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID

199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'

Line 205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'

201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
208: APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
209: END IF;

Line 207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'

203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
208: APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
209: END IF;
210: end if;
211: -- 20-OCT-10 sechawla 10194171 : end

Line 225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

221: set_wf_launch_message(p_event_name => p_event_name,
222: p_event_key => l_key);
223:
224: IF (is_debug_procedure_on) THEN
225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
226: END IF;
227:
228: EXCEPTION
229: WHEN OTHERS THEN

Line 283: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

279: FROM dual;
280:
281: -- for debug logging
282: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
283: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
284: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
285: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
286:
287: BEGIN

Line 284: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

280:
281: -- for debug logging
282: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
283: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
284: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
285: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
286:
287: BEGIN
288:

Line 285: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

281: -- for debug logging
282: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
283: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
284: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
285: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
286:
287: BEGIN
288:
289: IF (is_debug_procedure_on) THEN

Line 290: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

286:
287: BEGIN
288:
289: IF (is_debug_procedure_on) THEN
290: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
291: END IF;
292:
293: IF (funcmode = 'RUN') THEN
294:

Line 380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

376: --
377: END IF;
378:
379: IF (is_debug_procedure_on) THEN
380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
381: END IF;
382:
383:
384: EXCEPTION

Line 445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

441: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
442:
443: -- for debug logging
444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
448:
449: BEGIN

Line 446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

442:
443: -- for debug logging
444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
448:
449: BEGIN
450:

Line 447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

443: -- for debug logging
444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
448:
449: BEGIN
450:
451: IF (is_debug_procedure_on) THEN

Line 452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

448:
449: BEGIN
450:
451: IF (is_debug_procedure_on) THEN
452: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
453: END IF;
454:
455: l_mt_bind_names(1) := '';
456: l_mt_bind_values(1) := '';

Line 514: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

510: , p_recipient_email => l_email_address
511: -- , p_commit => FND_API.G_FALSE
512: );
513: IF (is_debug_statement_on) THEN
514: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
515: 'after call to okl_am_util_pvt.execute_fulfillment_request :'||l_return_status);
516: END IF;
517:
518: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 601: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

597: --
598: END IF;
599:
600: IF (is_debug_procedure_on) THEN
601: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
602: END IF;
603:
604:
605: EXCEPTION

Line 664: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

660: PRAGMA EXCEPTION_INIT(invalid_attr, -20002);
661: --dkagrawa -Bug#5256290 end
662: -- for debug logging
663: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
664: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
665: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
666: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
667: BEGIN
668:

Line 665: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

661: --dkagrawa -Bug#5256290 end
662: -- for debug logging
663: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
664: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
665: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
666: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
667: BEGIN
668:
669: IF (is_debug_procedure_on) THEN

Line 666: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

662: -- for debug logging
663: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
664: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
665: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
666: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
667: BEGIN
668:
669: IF (is_debug_procedure_on) THEN
670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

666: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
667: BEGIN
668:
669: IF (is_debug_procedure_on) THEN
670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
671: END IF;
672:
673: OPEN okl_key_csr;
674: FETCH okl_key_csr INTO l_seq;

Line 840: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

836: --
837: END IF;
838:
839: IF (is_debug_procedure_on) THEN
840: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
841: END IF;
842:
843:
844: EXCEPTION

Line 879: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

875: l_transaction_id VARCHAR2(100);
876:
877: -- for debug logging
878: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
879: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
880: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
881: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
882:
883: BEGIN

Line 880: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

876:
877: -- for debug logging
878: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
879: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
880: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
881: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
882:
883: BEGIN
884:

Line 881: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

877: -- for debug logging
878: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
879: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
880: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
881: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
882:
883: BEGIN
884:
885: IF (is_debug_procedure_on) THEN

Line 886: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

882:
883: BEGIN
884:
885: IF (is_debug_procedure_on) THEN
886: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
887: END IF;
888:
889: -- SAVEPOINT set_atts;
890:

Line 963: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

959: --
960: END IF;
961:
962: IF (is_debug_procedure_on) THEN
963: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
964: END IF;
965:
966: EXCEPTION
967: WHEN OTHERS THEN

Line 1019: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1015: */
1016:
1017: -- for debug logging
1018: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
1019: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1020: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1021: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1022: BEGIN
1023:

Line 1020: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1016:
1017: -- for debug logging
1018: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
1019: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1020: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1021: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1022: BEGIN
1023:
1024: IF (is_debug_procedure_on) THEN

Line 1021: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1017: -- for debug logging
1018: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
1019: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1020: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1021: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1022: BEGIN
1023:
1024: IF (is_debug_procedure_on) THEN
1025: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1025: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1021: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1022: BEGIN
1023:
1024: IF (is_debug_procedure_on) THEN
1025: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1026: END IF;
1027:
1028: IF (funcmode = 'RUN') THEN
1029:

Line 1079: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1075: --
1076: END IF;
1077:
1078: IF (is_debug_procedure_on) THEN
1079: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1080: END IF;
1081:
1082:
1083: EXCEPTION

Line 1132: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1128:
1129: l_user_id NUMBER; -- SGORANTL 28-DEC-05 4887809
1130: -- for debug logging
1131: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1132: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1133: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1134: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1135: BEGIN
1136:

Line 1133: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1129: l_user_id NUMBER; -- SGORANTL 28-DEC-05 4887809
1130: -- for debug logging
1131: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1132: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1133: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1134: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1135: BEGIN
1136:
1137: IF (is_debug_procedure_on) THEN

Line 1134: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1130: -- for debug logging
1131: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1132: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1133: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1134: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1135: BEGIN
1136:
1137: IF (is_debug_procedure_on) THEN
1138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1134: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1135: BEGIN
1136:
1137: IF (is_debug_procedure_on) THEN
1138: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1139: END IF;
1140:
1141: IF (funcmode = 'RUN') THEN
1142:

Line 1264: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1260: --
1261: END IF;
1262:
1263: IF (is_debug_procedure_on) THEN
1264: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1265: END IF;
1266:
1267:
1268: EXCEPTION

Line 1302: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1298: l_user_id NUMBER;
1299: l_transaction_id VARCHAR2(100);
1300: -- for debug logging
1301: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1302: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1303: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1304: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1305: BEGIN
1306:

Line 1303: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1299: l_transaction_id VARCHAR2(100);
1300: -- for debug logging
1301: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1302: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1303: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1304: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1305: BEGIN
1306:
1307: IF (is_debug_procedure_on) THEN

Line 1304: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1300: -- for debug logging
1301: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1302: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1303: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1304: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1305: BEGIN
1306:
1307: IF (is_debug_procedure_on) THEN
1308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1304: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1305: BEGIN
1306:
1307: IF (is_debug_procedure_on) THEN
1308: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1309: END IF;
1310:
1311: SAVEPOINT set_atts;
1312:

Line 1409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1405: --
1406: END IF;
1407:
1408: IF (is_debug_procedure_on) THEN
1409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1410: END IF;
1411:
1412:
1413: EXCEPTION

Line 1445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1441: l_error_itemkey VARCHAR2(100);
1442:
1443: -- for debug logging
1444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1448: BEGIN
1449:

Line 1446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1442:
1443: -- for debug logging
1444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1448: BEGIN
1449:
1450: IF (is_debug_procedure_on) THEN

Line 1447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1443: -- for debug logging
1444: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1445: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1446: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1448: BEGIN
1449:
1450: IF (is_debug_procedure_on) THEN
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1447: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1448: BEGIN
1449:
1450: IF (is_debug_procedure_on) THEN
1451: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1452: END IF;
1453:
1454: IF funcmode = 'RUN' THEN
1455:

Line 1499: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1495: RETURN;
1496: END IF;
1497:
1498: IF (is_debug_procedure_on) THEN
1499: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1500: END IF;
1501:
1502:
1503: EXCEPTION

Line 1538: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1534: API_ERROR EXCEPTION;
1535:
1536: -- for debug logging
1537: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1538: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1539: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1540: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1541: BEGIN
1542:

Line 1539: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1535:
1536: -- for debug logging
1537: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1538: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1539: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1540: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1541: BEGIN
1542:
1543: IF (is_debug_procedure_on) THEN

Line 1540: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1536: -- for debug logging
1537: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1538: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1539: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1540: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1541: BEGIN
1542:
1543: IF (is_debug_procedure_on) THEN
1544: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1544: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1540: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1541: BEGIN
1542:
1543: IF (is_debug_procedure_on) THEN
1544: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1545: END IF;
1546:
1547: IF funcmode = 'RUN' THEN
1548:

Line 1592: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1588:
1589: END IF;
1590:
1591: IF (is_debug_procedure_on) THEN
1592: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1593: END IF;
1594:
1595:
1596: EXCEPTION

Line 1646: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1642: l_desc VARCHAR2(100);
1643: l_emp NUMBER;
1644: -- for debug logging
1645: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1646: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1647: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1648: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1649: BEGIN
1650:

Line 1647: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1643: l_emp NUMBER;
1644: -- for debug logging
1645: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1646: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1647: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1648: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1649: BEGIN
1650:
1651: IF (is_debug_procedure_on) THEN

Line 1648: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1644: -- for debug logging
1645: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1646: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1647: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1648: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1649: BEGIN
1650:
1651: IF (is_debug_procedure_on) THEN
1652: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1652: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1648: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1649: BEGIN
1650:
1651: IF (is_debug_procedure_on) THEN
1652: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1653: END IF;
1654:
1655: /* The logic for retrieving a wf user follows this hierarchy:
1656: [Step 1] First check if p_user_id is for an FND user.

Line 1707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1703: x_name := l_user;
1704: x_description := l_desc;
1705:
1706: IF (is_debug_procedure_on) THEN
1707: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1708: END IF;
1709:
1710:
1711: EXCEPTION

Line 1738: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1734:
1735: l_message VARCHAR2(32000);
1736: -- for debug logging
1737: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1738: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1739: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1740: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1741: BEGIN
1742:

Line 1739: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1735: l_message VARCHAR2(32000);
1736: -- for debug logging
1737: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1738: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1739: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1740: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1741: BEGIN
1742:
1743: IF (is_debug_procedure_on) THEN

Line 1740: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1736: -- for debug logging
1737: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1738: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1739: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1740: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1741: BEGIN
1742:
1743: IF (is_debug_procedure_on) THEN
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1740: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1741: BEGIN
1742:
1743: IF (is_debug_procedure_on) THEN
1744: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1745: END IF;
1746:
1747: l_message := wf_engine.GetItemAttrText (
1748: itemtype => 'OKLAMAPP',

Line 1758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1754:
1755: RETURN;
1756:
1757: IF (is_debug_procedure_on) THEN
1758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1759: END IF;
1760:
1761:
1762: EXCEPTION

Line 1785: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1781: funcmode IN VARCHAR2,
1782: resultout OUT NOCOPY VARCHAR2 )IS
1783: -- for debug logging
1784: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1785: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1786: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1787: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1788: BEGIN
1789:

Line 1786: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1782: resultout OUT NOCOPY VARCHAR2 )IS
1783: -- for debug logging
1784: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1785: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1786: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1787: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1788: BEGIN
1789:
1790: IF (is_debug_procedure_on) THEN

Line 1787: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1783: -- for debug logging
1784: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1785: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1786: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1787: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1788: BEGIN
1789:
1790: IF (is_debug_procedure_on) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1791: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1787: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1788: BEGIN
1789:
1790: IF (is_debug_procedure_on) THEN
1791: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1792: END IF;
1793:
1794: SAVEPOINT set_atts;
1795:

Line 1829: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1825: --
1826: END IF;
1827:
1828: IF (is_debug_procedure_on) THEN
1829: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1830: END IF;
1831:
1832:
1833: EXCEPTION

Line 1866: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1862: current_appl_id NUMBER;
1863:
1864: -- for debug logging
1865: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1866: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1867: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1868: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1869: BEGIN
1870:

Line 1867: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1863:
1864: -- for debug logging
1865: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1866: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1867: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1868: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1869: BEGIN
1870:
1871: IF (is_debug_procedure_on) THEN

Line 1868: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1864: -- for debug logging
1865: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1866: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1867: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1868: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1869: BEGIN
1870:
1871: IF (is_debug_procedure_on) THEN
1872: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1872: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1868: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1869: BEGIN
1870:
1871: IF (is_debug_procedure_on) THEN
1872: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1873: END IF;
1874:
1875: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,
1876: itemkey,

Line 1882: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'item type : '||itemtype);

1878: current_org_id := nvl(mo_global.get_current_org_id(),-1);
1879:
1880: --sechawla 30-oct-10 10194171 : begin
1881: IF (is_debug_procedure_on) THEN
1882: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'item type : '||itemtype);
1883: --04-Nov-10 sechawla 10227547,10263799
1884: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'command : '||command);
1885: end if;
1886:

Line 1884: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'command : '||command);

1880: --sechawla 30-oct-10 10194171 : begin
1881: IF (is_debug_procedure_on) THEN
1882: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'item type : '||itemtype);
1883: --04-Nov-10 sechawla 10227547,10263799
1884: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'command : '||command);
1885: end if;
1886:
1887: IF (itemtype = 'OKLAMPPT') THEN
1888: -- Get the user who intiated the workflow

Line 2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);

2004:
2005:
2006: --sechawla 30-oct-10 10194171 : begin
2007: IF (is_debug_procedure_on) THEN
2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);
2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);

Line 2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);

2005:
2006: --sechawla 30-oct-10 10194171 : begin
2007: IF (is_debug_procedure_on) THEN
2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);
2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);
2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);

Line 2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);

2006: --sechawla 30-oct-10 10194171 : begin
2007: IF (is_debug_procedure_on) THEN
2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);
2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);
2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);
2014: end if;

Line 2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);

2007: IF (is_debug_procedure_on) THEN
2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);
2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);
2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);
2014: end if;
2015: --sechawla 30-oct-10 10194171 : end

Line 2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);

2008: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig user : '||l_user_id);
2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);
2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);
2014: end if;
2015: --sechawla 30-oct-10 10194171 : end
2016:

Line 2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);

2009: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr user : '||current_user_id);
2010: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig resp : '||l_resp_id);
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr resp : '||current_resp_id);
2012: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'orig appl : '||l_appl_id);
2013: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'curr appl : '||current_appl_id);
2014: end if;
2015: --sechawla 30-oct-10 10194171 : end
2016:
2017:

Line 2033: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'set ctx : going to initailaize ctx.. '||l_user_id||':'||l_resp_id||':'||l_appl_id);

2029: -- added : 'OKLSOQUO' venkatho Bug:15933691
2030:
2031: --sechawla 20-oct-10 10194171
2032: IF (is_debug_procedure_on) THEN
2033: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'set ctx : going to initailaize ctx.. '||l_user_id||':'||l_resp_id||':'||l_appl_id);
2034: end if;
2035:
2036: FND_GLOBAL.APPS_initialize(l_user_id,l_resp_id,l_appl_id);
2037: END IF;

Line 2054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback test_ctx: context has changed..');

2050: OR l_appl_id <> current_appl_id) THEN
2051:
2052: --sechawla 20-OCT-10 10194171
2053: IF (is_debug_procedure_on) THEN
2054: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback test_ctx: context has changed..');
2055: end if;
2056:
2057: resultout := 'NOTSET';
2058: ELSE

Line 2062: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : context did not change..');

2058: ELSE
2059:
2060: --sechawla 20-OCT-10 10194171
2061: IF (is_debug_procedure_on) THEN
2062: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : context did not change..');
2063: end if;
2064:
2065: resultout := 'TRUE';
2066: END IF;

Line 2075: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : org id has changed..');

2071: IF (l_org_id <> current_org_id) THEN
2072:
2073: --sechawla 20-OCT-10 10194171
2074: IF (is_debug_procedure_on) THEN
2075: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : org id has changed..');
2076: end if;
2077:
2078: resultout := 'NOTSET';
2079: ELSE

Line 2083: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : org id has not changed..');

2079: ELSE
2080:
2081: --sechawla 20-OCT-10 10194171
2082: IF (is_debug_procedure_on) THEN
2083: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'callback : org id has not changed..');
2084: end if;
2085:
2086: resultout := 'TRUE';
2087: END IF;

Line 2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

2091: END IF;
2092:
2093:
2094: IF (is_debug_procedure_on) THEN
2095: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
2096: END IF;
2097:
2098:
2099: EXCEPTION

Line 2253: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

2249: AND PTTL.ID=PT.ID;
2250: --19-jul-2007 ansethur R12B XML Publisher Ends
2251: -- for debug logging
2252: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
2253: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2254: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2255: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2256: BEGIN
2257:

Line 2254: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

2250: --19-jul-2007 ansethur R12B XML Publisher Ends
2251: -- for debug logging
2252: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
2253: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2254: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2255: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2256: BEGIN
2257:
2258: IF (is_debug_procedure_on) THEN

Line 2255: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

2251: -- for debug logging
2252: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
2253: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2254: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2255: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2256: BEGIN
2257:
2258: IF (is_debug_procedure_on) THEN
2259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 2259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

2255: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2256: BEGIN
2257:
2258: IF (is_debug_procedure_on) THEN
2259: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
2260: END IF;
2261:
2262:
2263: IF (funcmode = 'RUN') THEN

Line 2374: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

2370: --
2371: END IF;
2372:
2373: IF (is_debug_procedure_on) THEN
2374: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
2375: END IF;
2376:
2377:
2378: EXCEPTION