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 107: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

103: FROM dual;
104:
105: -- for debug logging
106: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
107: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
108: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
109: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
110: BEGIN
111:

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

104:
105: -- for debug logging
106: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
107: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
108: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
109: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
110: BEGIN
111:
112: IF (is_debug_procedure_on) THEN

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

105: -- for debug logging
106: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_business_event';
107: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
108: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
109: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
110: BEGIN
111:
112: IF (is_debug_procedure_on) THEN
113: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

109: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
110: BEGIN
111:
112: IF (is_debug_procedure_on) THEN
113: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
114: END IF;
115:
116: SAVEPOINT raise_event;
117:

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

153: set_wf_launch_message(p_event_name => p_event_name,
154: p_event_key => l_key);
155:
156: IF (is_debug_procedure_on) THEN
157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
158: END IF;
159:
160: EXCEPTION
161: WHEN OTHERS THEN

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

211: FROM dual;
212:
213: -- for debug logging
214: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
215: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
216: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
217: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
218:
219: BEGIN

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

212:
213: -- for debug logging
214: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
215: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
216: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
217: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
218:
219: BEGIN
220:

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

213: -- for debug logging
214: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'raise_fulfillment_event';
215: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
216: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
217: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
218:
219: BEGIN
220:
221: IF (is_debug_procedure_on) THEN

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

218:
219: BEGIN
220:
221: IF (is_debug_procedure_on) THEN
222: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
223: END IF;
224:
225: IF (funcmode = 'RUN') THEN
226:

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

308: --
309: END IF;
310:
311: IF (is_debug_procedure_on) THEN
312: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
313: END IF;
314:
315:
316: EXCEPTION

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

373: l_msg_idx INTEGER := FND_MSG_PUB.G_FIRST;
374:
375: -- for debug logging
376: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
377: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
378: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
379: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
380:
381: BEGIN

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

374:
375: -- for debug logging
376: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
377: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
378: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
379: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
380:
381: BEGIN
382:

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

375: -- for debug logging
376: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'call_am_fulfillment';
377: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
378: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
379: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
380:
381: BEGIN
382:
383: IF (is_debug_procedure_on) THEN

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

380:
381: BEGIN
382:
383: IF (is_debug_procedure_on) THEN
384: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
385: END IF;
386:
387: l_mt_bind_names(1) := '';
388: l_mt_bind_values(1) := '';

Line 446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

442: , p_recipient_email => l_email_address
443: -- , p_commit => FND_API.G_FALSE
444: );
445: IF (is_debug_statement_on) THEN
446: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
447: 'after call to okl_am_util_pvt.execute_fulfillment_request :'||l_return_status);
448: END IF;
449:
450: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

529: --
530: END IF;
531:
532: IF (is_debug_procedure_on) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
534: END IF;
535:
536:
537: EXCEPTION

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

590: PRAGMA EXCEPTION_INIT(invalid_attr, -20002);
591: --dkagrawa -Bug#5256290 end
592: -- for debug logging
593: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
594: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
595: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
596: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
597: BEGIN
598:

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

591: --dkagrawa -Bug#5256290 end
592: -- for debug logging
593: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
594: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
595: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
596: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
597: BEGIN
598:
599: IF (is_debug_procedure_on) THEN

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

592: -- for debug logging
593: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'start_approval_process';
594: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
595: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
596: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
597: BEGIN
598:
599: IF (is_debug_procedure_on) THEN
600: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

596: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
597: BEGIN
598:
599: IF (is_debug_procedure_on) THEN
600: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
601: END IF;
602:
603: OPEN okl_key_csr;
604: FETCH okl_key_csr INTO l_seq;

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

753: --
754: END IF;
755:
756: IF (is_debug_procedure_on) THEN
757: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
758: END IF;
759:
760:
761: EXCEPTION

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

792: l_transaction_id VARCHAR2(100);
793:
794: -- for debug logging
795: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
796: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
797: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
798: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
799:
800: BEGIN

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

793:
794: -- for debug logging
795: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
796: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
797: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
798: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
799:
800: BEGIN
801:

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

794: -- for debug logging
795: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_parent_attributes';
796: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
797: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
798: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
799:
800: BEGIN
801:
802: IF (is_debug_procedure_on) THEN

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

799:
800: BEGIN
801:
802: IF (is_debug_procedure_on) THEN
803: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
804: END IF;
805:
806: -- SAVEPOINT set_atts;
807:

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

876: --
877: END IF;
878:
879: IF (is_debug_procedure_on) THEN
880: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
881: END IF;
882:
883: EXCEPTION
884: WHEN OTHERS THEN

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

932: */
933:
934: -- for debug logging
935: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
936: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
937: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
938: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
939: BEGIN
940:

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

933:
934: -- for debug logging
935: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
936: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
937: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
938: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
939: BEGIN
940:
941: IF (is_debug_procedure_on) THEN

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

934: -- for debug logging
935: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'validate_approval_request';
936: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
937: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
938: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
939: BEGIN
940:
941: IF (is_debug_procedure_on) THEN
942: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

938: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
939: BEGIN
940:
941: IF (is_debug_procedure_on) THEN
942: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
943: END IF;
944:
945: IF (funcmode = 'RUN') THEN
946:

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

992: --
993: END IF;
994:
995: IF (is_debug_procedure_on) THEN
996: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
997: END IF;
998:
999:
1000: EXCEPTION

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

1045:
1046: l_user_id NUMBER; -- SGORANTL 28-DEC-05 4887809
1047: -- for debug logging
1048: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1049: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1050: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1051: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1052: BEGIN
1053:

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

1046: l_user_id NUMBER; -- SGORANTL 28-DEC-05 4887809
1047: -- for debug logging
1048: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1049: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1050: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1051: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1052: BEGIN
1053:
1054: IF (is_debug_procedure_on) THEN

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

1047: -- for debug logging
1048: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_approver';
1049: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1050: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1051: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1052: BEGIN
1053:
1054: IF (is_debug_procedure_on) THEN
1055: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1051: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1052: BEGIN
1053:
1054: IF (is_debug_procedure_on) THEN
1055: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1056: END IF;
1057:
1058: IF (funcmode = 'RUN') THEN
1059:

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

1177: --
1178: END IF;
1179:
1180: IF (is_debug_procedure_on) THEN
1181: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1182: END IF;
1183:
1184:
1185: EXCEPTION

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

1215: l_user_id NUMBER;
1216: l_transaction_id VARCHAR2(100);
1217: -- for debug logging
1218: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1219: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1220: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1221: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1222: BEGIN
1223:

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

1216: l_transaction_id VARCHAR2(100);
1217: -- for debug logging
1218: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1219: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1220: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1221: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1222: BEGIN
1223:
1224: IF (is_debug_procedure_on) THEN

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

1217: -- for debug logging
1218: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_approval_status';
1219: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1220: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1221: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1222: BEGIN
1223:
1224: IF (is_debug_procedure_on) THEN
1225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1221: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1222: BEGIN
1223:
1224: IF (is_debug_procedure_on) THEN
1225: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1226: END IF;
1227:
1228: SAVEPOINT set_atts;
1229:

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

1322: --
1323: END IF;
1324:
1325: IF (is_debug_procedure_on) THEN
1326: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1327: END IF;
1328:
1329:
1330: EXCEPTION

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

1358: l_error_itemkey VARCHAR2(100);
1359:
1360: -- for debug logging
1361: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1362: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1363: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1364: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1365: BEGIN
1366:

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

1359:
1360: -- for debug logging
1361: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1362: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1363: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1364: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1365: BEGIN
1366:
1367: IF (is_debug_procedure_on) THEN

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

1360: -- for debug logging
1361: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_error_stack';
1362: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1363: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1364: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1365: BEGIN
1366:
1367: IF (is_debug_procedure_on) THEN
1368: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1364: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1365: BEGIN
1366:
1367: IF (is_debug_procedure_on) THEN
1368: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1369: END IF;
1370:
1371: IF funcmode = 'RUN' THEN
1372:

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

1412: RETURN;
1413: END IF;
1414:
1415: IF (is_debug_procedure_on) THEN
1416: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1417: END IF;
1418:
1419:
1420: EXCEPTION

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

1451: API_ERROR EXCEPTION;
1452:
1453: -- for debug logging
1454: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1455: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1456: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1457: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1458: BEGIN
1459:

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

1452:
1453: -- for debug logging
1454: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1455: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1456: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1457: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1458: BEGIN
1459:
1460: IF (is_debug_procedure_on) THEN

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

1453: -- for debug logging
1454: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_error_atts';
1455: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1456: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1457: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1458: BEGIN
1459:
1460: IF (is_debug_procedure_on) THEN
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1457: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1458: BEGIN
1459:
1460: IF (is_debug_procedure_on) THEN
1461: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1462: END IF;
1463:
1464: IF funcmode = 'RUN' THEN
1465:

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

1505:
1506: END IF;
1507:
1508: IF (is_debug_procedure_on) THEN
1509: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1510: END IF;
1511:
1512:
1513: EXCEPTION

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

1559: l_desc VARCHAR2(100);
1560: l_emp NUMBER;
1561: -- for debug logging
1562: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1563: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1564: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1565: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1566: BEGIN
1567:

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

1560: l_emp NUMBER;
1561: -- for debug logging
1562: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1563: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1564: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1565: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1566: BEGIN
1567:
1568: IF (is_debug_procedure_on) THEN

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

1561: -- for debug logging
1562: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_notification_agent';
1563: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1564: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1565: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1566: BEGIN
1567:
1568: IF (is_debug_procedure_on) THEN
1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1565: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1566: BEGIN
1567:
1568: IF (is_debug_procedure_on) THEN
1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1570: END IF;
1571:
1572: /* The logic for retrieving a wf user follows this hierarchy:
1573: [Step 1] First check if p_user_id is for an FND user.

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

1620: x_name := l_user;
1621: x_description := l_desc;
1622:
1623: IF (is_debug_procedure_on) THEN
1624: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1625: END IF;
1626:
1627:
1628: EXCEPTION

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

1651:
1652: l_message VARCHAR2(32000);
1653: -- for debug logging
1654: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1655: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1656: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1657: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1658: BEGIN
1659:

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

1652: l_message VARCHAR2(32000);
1653: -- for debug logging
1654: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1655: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1656: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1657: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1658: BEGIN
1659:
1660: IF (is_debug_procedure_on) THEN

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

1653: -- for debug logging
1654: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'pop_approval_doc';
1655: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1656: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1657: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1658: BEGIN
1659:
1660: IF (is_debug_procedure_on) THEN
1661: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1657: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1658: BEGIN
1659:
1660: IF (is_debug_procedure_on) THEN
1661: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1662: END IF;
1663:
1664: l_message := wf_engine.GetItemAttrText (
1665: itemtype => 'OKLAMAPP',

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

1671:
1672: RETURN;
1673:
1674: IF (is_debug_procedure_on) THEN
1675: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1676: END IF;
1677:
1678:
1679: EXCEPTION

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

1698: funcmode IN VARCHAR2,
1699: resultout OUT NOCOPY VARCHAR2 )IS
1700: -- for debug logging
1701: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1702: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1703: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1704: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1705: BEGIN
1706:

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

1699: resultout OUT NOCOPY VARCHAR2 )IS
1700: -- for debug logging
1701: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1702: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1703: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1704: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1705: BEGIN
1706:
1707: IF (is_debug_procedure_on) THEN

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

1700: -- for debug logging
1701: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'set_status_on_exit';
1702: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1703: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1704: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1705: BEGIN
1706:
1707: IF (is_debug_procedure_on) THEN
1708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1704: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1705: BEGIN
1706:
1707: IF (is_debug_procedure_on) THEN
1708: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1709: END IF;
1710:
1711: SAVEPOINT set_atts;
1712:

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

1742: --
1743: END IF;
1744:
1745: IF (is_debug_procedure_on) THEN
1746: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1747: END IF;
1748:
1749:
1750: EXCEPTION

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

1777: current_appl_id NUMBER;
1778:
1779: -- for debug logging
1780: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1781: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1782: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1783: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1784: BEGIN
1785:

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

1778:
1779: -- for debug logging
1780: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1781: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1782: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1783: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1784: BEGIN
1785:
1786: IF (is_debug_procedure_on) THEN

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

1779: -- for debug logging
1780: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'callback';
1781: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1782: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1783: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1784: BEGIN
1785:
1786: IF (is_debug_procedure_on) THEN
1787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1783: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1784: BEGIN
1785:
1786: IF (is_debug_procedure_on) THEN
1787: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1788: END IF;
1789:
1790: l_org_id:= wf_engine.GetItemAttrNumber(itemtype,
1791: itemkey,

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

1844: END IF;
1845:
1846:
1847: IF (is_debug_procedure_on) THEN
1848: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1849: END IF;
1850:
1851:
1852: EXCEPTION

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

1911: AND PTTL.ID=PT.ID;
1912: --19-jul-2007 ansethur R12B XML Publisher Ends
1913: -- for debug logging
1914: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
1915: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1916: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1917: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1918: BEGIN
1919:

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

1912: --19-jul-2007 ansethur R12B XML Publisher Ends
1913: -- for debug logging
1914: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
1915: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1916: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1917: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1918: BEGIN
1919:
1920: IF (is_debug_procedure_on) THEN

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

1913: -- for debug logging
1914: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'populate_attributes';
1915: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1916: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1917: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1918: BEGIN
1919:
1920: IF (is_debug_procedure_on) THEN
1921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

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

1917: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1918: BEGIN
1919:
1920: IF (is_debug_procedure_on) THEN
1921: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1922: END IF;
1923:
1924:
1925: IF (funcmode = 'RUN') THEN

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

2032: --
2033: END IF;
2034:
2035: IF (is_debug_procedure_on) THEN
2036: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
2037: END IF;
2038:
2039:
2040: EXCEPTION