DBA Data[Home] [Help]

APPS.PJI_MT_ROWSET_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 105: pa_fp_constants_pkg.g_debug_level3);

101:
102: IF g_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;
104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:
108: INSERT INTO pji_mt_rowset_B
109: (

Line 130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);

126: );
127:
128: IF g_debug_mode = 'Y' THEN
129: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_tl '||X_Rowset_Code;
130: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
131: END IF;
132:
133: INSERT INTO pji_mt_rowset_tl
134: (

Line 171: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

167:
168: CLOSE C;
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Rowid could not be fetched after Inserting for '||X_Rowset_Code;
171: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
172: END IF;
173: RAISE NO_DATA_FOUND;
174:
175: END IF;

Line 218: pa_fp_constants_pkg.g_debug_level5);

214:
215: IF g_debug_mode = 'Y' THEN
216: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
217: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
218: pa_fp_constants_pkg.g_debug_level5);
219: pa_debug.reset_curr_function;
220: END IF;
221:
222: RAISE;

Line 262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

258: END IF;
259:
260: IF g_debug_mode = 'Y' THEN
261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;
262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
263: END IF;
264:
265: -- The lock row procedure need not be called when the update_row is called
266: -- from the lct. It should be called when update row is called from the

Line 287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

283:
284: IF (SQL%NOTFOUND) THEN
285: IF g_debug_mode = 'Y' THEN
286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;
287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
288: END IF;
289: RAISE NO_DATA_FOUND;
290: END IF;
291:

Line 294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);

290: END IF;
291:
292: IF g_debug_mode = 'Y' THEN
293: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_tl for '||X_Rowset_Code;
294: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
295: END IF;
296:
297: UPDATE pji_mt_rowset_tl
298: SET Name = X_Name,

Line 310: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);

306:
307: IF (SQL%NOTFOUND) THEN
308: IF g_debug_mode = 'Y' THEN
309: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_T '||X_Rowset_Code;
310: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
311: END IF;
312: RAISE NO_DATA_FOUND;
313: END IF;
314:

Line 355: pa_fp_constants_pkg.g_debug_level5);

351:
352: IF g_debug_mode = 'Y' THEN
353: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
354: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
355: pa_fp_constants_pkg.g_debug_level5);
356: pa_debug.reset_curr_function;
357: END IF;
358:
359: RAISE;

Line 437: pa_fp_constants_pkg.g_debug_level5);

433:
434: IF g_debug_mode = 'Y' THEN
435: pa_debug.g_err_stage:= 'Unexpected Error'||l_msg_data;
436: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
437: pa_fp_constants_pkg.g_debug_level5);
438: pa_debug.reset_curr_function;
439: END IF;
440:
441: RAISE;