DBA Data[Home] [Help]

APPS.PA_LABOR_SCH_RULE_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 52: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

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

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

51: BEGIN
52: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
53: l_debug_mode := NVL(l_debug_mode, 'N');
54:
55: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
56:
57: IF l_debug_mode = 'Y' THEN
58: print_msg('Inside pa_labor_sch_rule_pkg table handler..');
59: End If;

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

193:
194: recinfo cur_row%rowtype;
195: l_debug_mode varchar2(1) := 'N';
196: BEGIN
197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
198: l_debug_mode := NVL(l_debug_mode, 'N');
199:
200: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
201:

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

196: BEGIN
197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
198: l_debug_mode := NVL(l_debug_mode, 'N');
199:
200: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
201:
202: /** set the return status to success **/
203: x_return_status := 'S';
204: x_error_msg_code := NULL;

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

285:
286: l_debug_mode varchar2(1) := 'N';
287:
288: BEGIN
289: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
290: l_debug_mode := NVL(l_debug_mode, 'N');
291:
292: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
293:

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

288: BEGIN
289: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
290: l_debug_mode := NVL(l_debug_mode, 'N');
291:
292: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
293:
294: DELETE FROM PA_ORG_LABOR_SCH_RULE
295: WHERE ORG_LABOR_SCH_RULE_ID = p_ORG_LABOR_SCH_RULE_ID;
296: if sql%found then

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

349:
350: l_debug_mode varchar2(1) := 'N';
351:
352: BEGIN
353: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
354: l_debug_mode := NVL(l_debug_mode, 'N');
355:
356: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
357:

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

352: BEGIN
353: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
354: l_debug_mode := NVL(l_debug_mode, 'N');
355:
356: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
357:
358: OPEN cur_row;
359: FETCH cur_row INTO recinfo;
360: If cur_row%NOTFOUND then