DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_DEBUG

Line 7: PA_DEBUG.g_err_stage := p_msg;

3: PROCEDURE print_msg(p_msg varchar2) IS
4: BEGIN
5: --dbms_output.put_line('Log:'||p_msg);
6: --r_debug.r_msg('Log:'||p_msg);
7: PA_DEBUG.g_err_stage := p_msg;
8: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
9: null;
10: END print_msg;
11:

Line 8: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

4: BEGIN
5: --dbms_output.put_line('Log:'||p_msg);
6: --r_debug.r_msg('Log:'||p_msg);
7: PA_DEBUG.g_err_stage := p_msg;
8: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
9: null;
10: END print_msg;
11:
12: PROCEDURE insert_row (

Line 49: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

45: l_error_msg_code varchar2(100) := NULL;
46: l_debug_mode varchar2(1) := 'N';
47: BEGIN
48:
49: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
50: l_debug_mode := NVL(l_debug_mode, 'N');
51:
52: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
53:

Line 52: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

48:
49: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
50: l_debug_mode := NVL(l_debug_mode, 'N');
51:
52: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
53:
54: IF l_debug_mode = 'Y' THEN
55: print_msg('Inside pa_ci_supplier_pkg table handler..');
56: End IF;

Line 177: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

173: recinfo cur_row%rowtype;
174: l_debug_mode varchar2(1) := 'N';
175: BEGIN
176:
177: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
178: l_debug_mode := NVL(l_debug_mode, 'N');
179:
180: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
181:

Line 180: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

176:
177: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
178: l_debug_mode := NVL(l_debug_mode, 'N');
179:
180: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
181:
182: /** set the return status to success **/
183: x_return_status := 'S';
184: x_error_msg_code := NULL;

Line 254: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

250:
251: l_debug_mode varchar2(1) := 'N';
252: BEGIN
253:
254: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
255: l_debug_mode := NVL(l_debug_mode, 'N');
256:
257: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
258:

Line 257: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

253:
254: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
255: l_debug_mode := NVL(l_debug_mode, 'N');
256:
257: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
258:
259: DELETE FROM PA_CI_SUPPLIER_DETAILS
260: WHERE CI_TRANSACTION_ID = P_CI_TRANSACTION_ID;
261: if sql%found then