DBA Data[Home] [Help]

APPS.WSH_ITM_POST_PROCESS_HANDLER dependencies on WSH_DEBUG_SV

Line 34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

30: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
31: --
32: IF ( l_debug_on IS NULL )
33: THEN
34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on and p_source = 'ITM' THEN
38: WSH_DEBUG_SV.Push(l_module_name);

Line 38: WSH_DEBUG_SV.Push(l_module_name);

34: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
35: END IF;
36: --
37: IF l_debug_on and p_source = 'ITM' THEN
38: WSH_DEBUG_SV.Push(l_module_name);
39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );
40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );
41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );
42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );

Line 39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );

35: END IF;
36: --
37: IF l_debug_on and p_source = 'ITM' THEN
38: WSH_DEBUG_SV.Push(l_module_name);
39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );
40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );
41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );
42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );
43: END IF;

Line 40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );

36: --
37: IF l_debug_on and p_source = 'ITM' THEN
38: WSH_DEBUG_SV.Push(l_module_name);
39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );
40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );
41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );
42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );
43: END IF;
44: --

Line 41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );

37: IF l_debug_on and p_source = 'ITM' THEN
38: WSH_DEBUG_SV.Push(l_module_name);
39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );
40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );
41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );
42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );
43: END IF;
44: --
45:

Line 42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );

38: WSH_DEBUG_SV.Push(l_module_name);
39: WSH_DEBUG_SV.Log(l_module_name, 'p_request_control_id', p_request_control_id );
40: WSH_DEBUG_SV.Log(l_module_name, 'p_request_set_id', p_request_set_id );
41: WSH_DEBUG_SV.Log(l_module_name, 'p_application_id', p_application_id );
42: WSH_DEBUG_SV.Log(l_module_name, 'p_source', p_source );
43: END IF;
44: --
45:
46: BEGIN

Line 56: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Program Unit CALL_CUSTOM_API with p_request_set_id',WSH_DEBUG_SV.C_PROC_LEVEL);

52: AND PROCESS_FLAG <= 0;
53:
54: IF l_count = 0 THEN
55: IF l_debug_on THEN
56: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Program Unit CALL_CUSTOM_API with p_request_set_id',WSH_DEBUG_SV.C_PROC_LEVEL);
57: END IF;
58: CALL_CUSTOM_API(0, p_request_set_id, p_application_id, p_source);
59: ELSE
60: IF l_debug_on AND P_SOURCE = 'ITM' THEN

Line 61: WSH_DEBUG_SV.logmsg(l_module_name, 'Pending records for Request Set '|| p_request_set_id);

57: END IF;
58: CALL_CUSTOM_API(0, p_request_set_id, p_application_id, p_source);
59: ELSE
60: IF l_debug_on AND P_SOURCE = 'ITM' THEN
61: WSH_DEBUG_SV.logmsg(l_module_name, 'Pending records for Request Set '|| p_request_set_id);
62: END IF;
63: END IF;
64: ELSE
65: IF l_debug_on THEN

Line 66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Program Unit CALL_CUSTOM_API with p_request_control_id',WSH_DEBUG_SV.C_PROC_LEVEL);

62: END IF;
63: END IF;
64: ELSE
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Program Unit CALL_CUSTOM_API with p_request_control_id',WSH_DEBUG_SV.C_PROC_LEVEL);
67: END IF;
68: CALL_CUSTOM_API(p_request_control_id, 0, p_application_id, p_source);
69: END IF;
70: EXCEPTION

Line 75: WSH_DEBUG_SV.logmsg(l_module_name, 'Error in calling CALL_CUSTOM_API '||SQLERRM);

71: WHEN OTHERS THEN
72:
73: WSH_UTIL_CORE.Default_Handler(l_module_name);
74: IF l_debug_on AND P_SOURCE = 'ITM' THEN
75: WSH_DEBUG_SV.logmsg(l_module_name, 'Error in calling CALL_CUSTOM_API '||SQLERRM);
76: END IF;
77: END;
78: --
79: IF l_debug_on AND p_source = 'ITM' THEN

Line 80: WSH_DEBUG_SV.Pop(l_module_name);

76: END IF;
77: END;
78: --
79: IF l_debug_on AND p_source = 'ITM' THEN
80: WSH_DEBUG_SV.Pop(l_module_name);
81: END IF;
82: --
83:
84: EXCEPTION

Line 87: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);

83:
84: EXCEPTION
85: WHEN OTHERS THEN
86: IF l_debug_on AND p_source = 'ITM' THEN
87: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);
88: WSH_DEBUG_SV.Pop(l_module_name);
89: END IF;
90:
91: END;

Line 88: WSH_DEBUG_SV.Pop(l_module_name);

84: EXCEPTION
85: WHEN OTHERS THEN
86: IF l_debug_on AND p_source = 'ITM' THEN
87: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);
88: WSH_DEBUG_SV.Pop(l_module_name);
89: END IF;
90:
91: END;
92:

Line 121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

117: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
118: --
119: IF ( l_debug_on IS NULL )
120: THEN
121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123: --
124: IF l_debug_on and p_source = 'ITM' THEN
125: WSH_DEBUG_SV.Push(l_module_name);

Line 125: WSH_DEBUG_SV.Push(l_module_name);

121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123: --
124: IF l_debug_on and p_source = 'ITM' THEN
125: WSH_DEBUG_SV.Push(l_module_name);
126: END IF;
127: --
128:
129: --GET APPLICATION SHORT NAME

Line 139: WSH_DEBUG_SV.Log(l_module_name, 'Error getting application shortname for Id - ' || p_application_id, SQLERRM);

135: EXCEPTION
136: WHEN OTHERS THEN
137: WSH_UTIL_CORE.Default_Handler(l_module_name);
138: IF l_debug_on AND p_source = 'ITM' THEN
139: WSH_DEBUG_SV.Log(l_module_name, 'Error getting application shortname for Id - ' || p_application_id, SQLERRM);
140: END IF;
141: goto end_block;
142: END;
143:

Line 148: WSH_DEBUG_SV.Logmsg(l_module_name, 'l_procedure_name '||l_procedure_name );

144: -- build procedure _ITM_PKG.WSH_ITM_
145: l_procedure_name := ' BEGIN '||l_app_shname||'_ITM_PKG.WSH_ITM_'||l_app_shname ||'(p_request_control_id=>:p_request_control_id, p_request_set_id=>:p_request_set_id); END;';
146:
147: IF l_debug_on AND p_source = 'ITM' THEN
148: WSH_DEBUG_SV.Logmsg(l_module_name, 'l_procedure_name '||l_procedure_name );
149: END IF;
150:
151: BEGIN
152: EXECUTE IMMEDIATE l_procedure_name

Line 159: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error in Custom Procedure '|| SQLERRM);

155: EXCEPTION
156: WHEN OTHERS THEN
157: WSH_UTIL_CORE.Default_Handler(l_module_name);
158: IF l_debug_on AND p_source = 'ITM' THEN
159: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error in Custom Procedure '|| SQLERRM);
160: END IF;
161: goto end_block;
162: END;
163: -- Added as part of Additional Attributes required by G.E

Line 166: WSH_DEBUG_SV.Logmsg(l_module_name, 'Calling WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_'||l_app_shname||'_REQUEST');

162: END;
163: -- Added as part of Additional Attributes required by G.E
164: -- build procedure _ITM_CUSTOM_PROCESS.POST_PROCESS_REQUEST
165: IF l_debug_on AND p_source = 'ITM' THEN
166: WSH_DEBUG_SV.Logmsg(l_module_name, 'Calling WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_'||l_app_shname||'_REQUEST');
167: END IF;
168:
169: l_procedure_name := ' BEGIN WSH_ITM_CUSTOM_PROCESS.POST_PROCESS_'||l_app_shname||'_REQUEST (p_request_control_id=>:p_request_control_id); END;';
170:

Line 178: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error in Custom Procedure:' || l_procedure_name || ' - ' || SQLERRM);

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: IF l_debug_on AND p_source = 'ITM' THEN
178: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error in Custom Procedure:' || l_procedure_name || ' - ' || SQLERRM);
179: END IF;
180: END;
181: <>
182: --

Line 184: WSH_DEBUG_SV.Pop(l_module_name);

180: END;
181: <>
182: --
183: IF l_debug_on AND p_source = 'ITM' THEN
184: WSH_DEBUG_SV.Pop(l_module_name);
185: END IF;
186: --
187:
188: EXCEPTION

Line 191: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);

187:
188: EXCEPTION
189: WHEN OTHERS THEN
190: IF l_debug_on AND p_source = 'ITM' THEN
191: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);
192: WSH_DEBUG_SV.Pop(l_module_name);
193: END IF;
194:
195: END CALL_CUSTOM_API;

Line 192: WSH_DEBUG_SV.Pop(l_module_name);

188: EXCEPTION
189: WHEN OTHERS THEN
190: IF l_debug_on AND p_source = 'ITM' THEN
191: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE||'-'||SQLERRM);
192: WSH_DEBUG_SV.Pop(l_module_name);
193: END IF;
194:
195: END CALL_CUSTOM_API;
196: