APPS.FND_OAM_DSCFG_PROCS_PKG dependencies on FND_OAM_DEBUG

Line 139: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

135: l_error_is_fatal_flag VARCHAR2(3);
136: l_location VARCHAR2(2000);
137: l_executable VARCHAR2(2000);
138: BEGIN
139: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
140:
141: --make sure the cursor's prep'd
142: IF NOT B_PROCS%ISOPEN THEN
143: OPEN B_PROCS(p_stage);

Line 173: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

169: x_proc_type := l_proc_type;
170: x_error_is_fatal := l_error_is_fatal_flag;
171: x_location := l_location;
172: x_executable := l_executable;
173: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: x_proc_id := NULL;
177: x_proc_type := NULL;

Line 181: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

177: x_proc_type := NULL;
178: x_error_is_fatal := NULL;
179: x_location := NULL;
180: x_executable := NULL;
181: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
182: RETURN;
183: WHEN OTHERS THEN
184: x_proc_id := NULL;
185: x_proc_type := NULL;

Line 189: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

185: x_proc_type := NULL;
186: x_error_is_fatal := NULL;
187: x_location := NULL;
188: x_executable := NULL;
189: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
190: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
191: RAISE;
192: END;
193:

Line 190: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

186: x_error_is_fatal := NULL;
187: x_location := NULL;
188: x_executable := NULL;
189: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
190: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
191: RAISE;
192: END;
193:
194: -- Public

Line 205: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

201: l_error_is_fatal_flag VARCHAR2(3);
202: l_location VARCHAR2(2000);
203: l_executable VARCHAR2(2000);
204: BEGIN
205: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
206:
207: --query out the import proc attributes
208: SELECT proc_id, proc_type, error_is_fatal_flag, location, executable
209: INTO l_proc_id, l_proc_type, l_error_is_fatal_flag, l_location, l_executable

Line 221: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

217: l_error_is_fatal_flag,
218: l_location,
219: l_executable);
220:
221: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN
224: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
225: RAISE;

Line 224: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

220:
221: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN
224: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
225: RAISE;
226: WHEN OTHERS THEN
227: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
228: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 227: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

223: WHEN NO_DATA_FOUND THEN
224: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
225: RAISE;
226: WHEN OTHERS THEN
227: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
228: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
229: RAISE;
230: END;
231:

Line 228: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

224: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
225: RAISE;
226: WHEN OTHERS THEN
227: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
228: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
229: RAISE;
230: END;
231:
232: