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

45: l_error_msg_code varchar2(100) := NULL;
46:
47: l_debug_mode varchar2(1) := 'N';
48: BEGIN
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: BEGIN
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_labor_sch_rule_pkg table handler..');
56: End If;

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

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

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

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

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

262:
263: l_debug_mode varchar2(1) := 'N';
264:
265: BEGIN
266: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
267: l_debug_mode := NVL(l_debug_mode, 'N');
268:
269: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
270:

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

265: BEGIN
266: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
267: l_debug_mode := NVL(l_debug_mode, 'N');
268:
269: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
270:
271: DELETE FROM PA_ORG_LABOR_SCH_RULE
272: WHERE ORG_LABOR_SCH_RULE_ID = p_ORG_LABOR_SCH_RULE_ID;
273: if sql%found then

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

323:
324: l_debug_mode varchar2(1) := 'N';
325:
326: BEGIN
327: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
328: l_debug_mode := NVL(l_debug_mode, 'N');
329:
330: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
331:

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

326: BEGIN
327: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
328: l_debug_mode := NVL(l_debug_mode, 'N');
329:
330: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
331:
332: OPEN cur_row;
333: FETCH cur_row INTO recinfo;
334: If cur_row%NOTFOUND then