eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PA_DEBUG

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

121:
122: BEGIN
123:
124:
125: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
126: l_debug_mode := NVL(l_debug_mode, 'N');
127: x_msg_count := 0;
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: IF l_debug_mode = 'Y' THEN

Line 130: PA_DEBUG.Set_Curr_Function( p_function => 'PA_PLAN_TXN_UTILS.Get_Res_Class_Rlm_Ids',

126: l_debug_mode := NVL(l_debug_mode, 'N');
127: x_msg_count := 0;
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: IF l_debug_mode = 'Y' THEN
130: PA_DEBUG.Set_Curr_Function( p_function => 'PA_PLAN_TXN_UTILS.Get_Res_Class_Rlm_Ids',
131: p_debug_mode => l_debug_mode );
132: END IF;
133: ---------------------------------------------------------------
134: -- validating input parameter p_resource_list_id.

Line 139: pa_debug.g_err_stage:='Validating input parameters';

135: -- p_resource_list_id cannot be passed as null.
136: ---------------------------------------------------------------
137:
138: IF l_debug_mode = 'Y' THEN
139: pa_debug.g_err_stage:='Validating input parameters';
140: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);
141: END IF;
142:
143: IF (p_resource_list_id IS NULL) THEN

Line 140: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);

136: ---------------------------------------------------------------
137:
138: IF l_debug_mode = 'Y' THEN
139: pa_debug.g_err_stage:='Validating input parameters';
140: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);
141: END IF;
142:
143: IF (p_resource_list_id IS NULL) THEN
144:

Line 146: pa_debug.g_err_stage:='p_resource_list_id is null';

142:
143: IF (p_resource_list_id IS NULL) THEN
144:
145: IF l_debug_mode = 'Y' THEN
146: pa_debug.g_err_stage:='p_resource_list_id is null';
147: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Id: ' || g_module_name,pa_debug.g_err_stage,5);
148: END IF;
149: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
150: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 147: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Id: ' || g_module_name,pa_debug.g_err_stage,5);

143: IF (p_resource_list_id IS NULL) THEN
144:
145: IF l_debug_mode = 'Y' THEN
146: pa_debug.g_err_stage:='p_resource_list_id is null';
147: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Id: ' || g_module_name,pa_debug.g_err_stage,5);
148: END IF;
149: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
150: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
151:

Line 169: pa_debug.g_err_stage:='Fetching rlm ids';

165: -------------------------------------------------------------------
166:
167:
168: IF l_debug_mode = 'Y' THEN
169: pa_debug.g_err_stage:='Fetching rlm ids';
170: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);
171: END IF;
172:
173: FOR c1 IN c_rlm_ids LOOP -- LoopA starts

Line 170: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);

166:
167:
168: IF l_debug_mode = 'Y' THEN
169: pa_debug.g_err_stage:='Fetching rlm ids';
170: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids: ' || g_module_name,pa_debug.g_err_stage,3);
171: END IF;
172:
173: FOR c1 IN c_rlm_ids LOOP -- LoopA starts
174:

Line 190: pa_debug.reset_curr_function;

186:
187: END IF;
188: END LOOP; -- LoopA Ends
189: IF l_debug_mode = 'Y' THEN
190: pa_debug.reset_curr_function;
191: END IF;
192: EXCEPTION
193:
194: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 213: pa_debug.g_err_stage:='Invalid Arguments Passed';

209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211:
212: IF l_debug_mode = 'Y' THEN
213: pa_debug.g_err_stage:='Invalid Arguments Passed';
214: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids : ' || g_module_name,pa_debug.g_err_stage,5);
215: pa_debug.reset_curr_function;
216: END IF;
217: WHEN Others THEN

Line 214: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids : ' || g_module_name,pa_debug.g_err_stage,5);

210: x_return_status := FND_API.G_RET_STS_ERROR;
211:
212: IF l_debug_mode = 'Y' THEN
213: pa_debug.g_err_stage:='Invalid Arguments Passed';
214: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids : ' || g_module_name,pa_debug.g_err_stage,5);
215: pa_debug.reset_curr_function;
216: END IF;
217: WHEN Others THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 215: pa_debug.reset_curr_function;

211:
212: IF l_debug_mode = 'Y' THEN
213: pa_debug.g_err_stage:='Invalid Arguments Passed';
214: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids : ' || g_module_name,pa_debug.g_err_stage,5);
215: pa_debug.reset_curr_function;
216: END IF;
217: WHEN Others THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: x_msg_count := 1;

Line 225: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

221: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_TRANSACTION_UTILS'
222: ,p_procedure_name => 'PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids');
223:
224: IF l_debug_mode = 'Y' THEN
225: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
226: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids: ' || g_module_name,pa_debug.g_err_stage,5);
227: pa_debug.reset_curr_function;
228: END IF;
229: RAISE;

Line 226: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids: ' || g_module_name,pa_debug.g_err_stage,5);

222: ,p_procedure_name => 'PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids');
223:
224: IF l_debug_mode = 'Y' THEN
225: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
226: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids: ' || g_module_name,pa_debug.g_err_stage,5);
227: pa_debug.reset_curr_function;
228: END IF;
229: RAISE;
230:

Line 227: pa_debug.reset_curr_function;

223:
224: IF l_debug_mode = 'Y' THEN
225: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
226: pa_debug.write('PA_PLANNING_TRANSACTION_UTILS.Get_res_class_rlm_ids: ' || g_module_name,pa_debug.g_err_stage,5);
227: pa_debug.reset_curr_function;
228: END IF;
229: RAISE;
230:
231:

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

278: l_parent_struct_st_dt DATE ;
279: l_parent_struct_end_dt DATE ;
280: BEGIN
281:
282: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
283: l_debug_mode := NVL(l_debug_mode, 'Y');
284: x_msg_count := 0;
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: IF l_debug_mode = 'Y' THEN

Line 287: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLAN_TXN_UTILS.get_def_planning_dates',

283: l_debug_mode := NVL(l_debug_mode, 'Y');
284: x_msg_count := 0;
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: IF l_debug_mode = 'Y' THEN
287: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLAN_TXN_UTILS.get_def_planning_dates',
288: p_debug_mode => l_debug_mode );
289: END IF;
290: --If no records are found in the input element version id table then return
291: IF p_element_version_id_tbl.COUNT=0 THEN

Line 294: pa_debug.g_err_stage:='p_element_version_id_tbl is empty. Returning';

290: --If no records are found in the input element version id table then return
291: IF p_element_version_id_tbl.COUNT=0 THEN
292:
293: IF l_debug_mode = 'Y' THEN
294: pa_debug.g_err_stage:='p_element_version_id_tbl is empty. Returning';
295: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
296: pa_debug.reset_curr_function;
297: END IF;
298: RETURN;

Line 295: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);

291: IF p_element_version_id_tbl.COUNT=0 THEN
292:
293: IF l_debug_mode = 'Y' THEN
294: pa_debug.g_err_stage:='p_element_version_id_tbl is empty. Returning';
295: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
296: pa_debug.reset_curr_function;
297: END IF;
298: RETURN;
299:

Line 296: pa_debug.reset_curr_function;

292:
293: IF l_debug_mode = 'Y' THEN
294: pa_debug.g_err_stage:='p_element_version_id_tbl is empty. Returning';
295: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
296: pa_debug.reset_curr_function;
297: END IF;
298: RETURN;
299:
300: END IF;

Line 310: pa_debug.g_err_stage:= 'p_project_structure_version_id passed is '||p_project_structure_version_id;

306: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
307:
308: IF l_debug_mode = 'Y' THEN
309:
310: pa_debug.g_err_stage:= 'p_project_structure_version_id passed is '||p_project_structure_version_id;
311: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
312:
313: pa_debug.g_err_stage:= 'p_project_id passed is '|| p_project_id;
314: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 311: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

307:
308: IF l_debug_mode = 'Y' THEN
309:
310: pa_debug.g_err_stage:= 'p_project_structure_version_id passed is '||p_project_structure_version_id;
311: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
312:
313: pa_debug.g_err_stage:= 'p_project_id passed is '|| p_project_id;
314: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
315:

Line 313: pa_debug.g_err_stage:= 'p_project_id passed is '|| p_project_id;

309:
310: pa_debug.g_err_stage:= 'p_project_structure_version_id passed is '||p_project_structure_version_id;
311: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
312:
313: pa_debug.g_err_stage:= 'p_project_id passed is '|| p_project_id;
314: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
315:
316: END IF;
317:

Line 314: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

310: pa_debug.g_err_stage:= 'p_project_structure_version_id passed is '||p_project_structure_version_id;
311: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
312:
313: pa_debug.g_err_stage:= 'p_project_id passed is '|| p_project_id;
314: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
315:
316: END IF;
317:
318: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 324: pa_debug.g_err_stage:='Looping thru the element version id tbl to derive the dates';

320: END IF;
321:
322:
323: IF l_debug_mode = 'Y' THEN
324: pa_debug.g_err_stage:='Looping thru the element version id tbl to derive the dates';
325: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
326: END IF;
327:
328: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();

Line 325: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);

321:
322:
323: IF l_debug_mode = 'Y' THEN
324: pa_debug.g_err_stage:='Looping thru the element version id tbl to derive the dates';
325: pa_debug.write(l_module_name ,pa_debug.g_err_stage,3);
326: END IF;
327:
328: x_planning_start_date_tbl := SYSTEM.pa_date_tbl_type();
329: x_planning_end_date_tbl := SYSTEM.pa_date_tbl_type();

Line 347: pa_debug.g_err_stage:='p_planning_start_date_tbl NOT Exists :'||i;

343: OR (NOT(p_planning_start_date_tbl.EXISTS(i)) AND (p_planning_end_date_tbl.EXISTS(i)))) THEN
344:
345: IF l_debug_mode = 'Y' THEN
346: IF NOT(p_planning_start_date_tbl.EXISTS(i)) THEN
347: pa_debug.g_err_stage:='p_planning_start_date_tbl NOT Exists :'||i;
348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
349: END IF;
350: IF NOT(p_planning_end_date_tbl.EXISTS(i)) THEN
351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;

Line 348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

344:
345: IF l_debug_mode = 'Y' THEN
346: IF NOT(p_planning_start_date_tbl.EXISTS(i)) THEN
347: pa_debug.g_err_stage:='p_planning_start_date_tbl NOT Exists :'||i;
348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
349: END IF;
350: IF NOT(p_planning_end_date_tbl.EXISTS(i)) THEN
351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;
352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

Line 351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;

347: pa_debug.g_err_stage:='p_planning_start_date_tbl NOT Exists :'||i;
348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
349: END IF;
350: IF NOT(p_planning_end_date_tbl.EXISTS(i)) THEN
351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;
352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
353: END IF;
354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

Line 352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
349: END IF;
350: IF NOT(p_planning_end_date_tbl.EXISTS(i)) THEN
351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;
352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
353: END IF;
354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
356:

Line 354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);

350: IF NOT(p_planning_end_date_tbl.EXISTS(i)) THEN
351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;
352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
353: END IF;
354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
356:
357: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_end_date_tbl :'||p_planning_end_date_tbl(i);
358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

Line 355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

351: pa_debug.g_err_stage:='p_planning_end_date_tbl NOT Exists :'||i;
352: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
353: END IF;
354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
356:
357: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_end_date_tbl :'||p_planning_end_date_tbl(i);
358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
359: END IF;

Line 357: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_end_date_tbl :'||p_planning_end_date_tbl(i);

353: END IF;
354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
356:
357: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_end_date_tbl :'||p_planning_end_date_tbl(i);
358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
359: END IF;
360: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
361: p_msg_name => 'PA_FP_INV_PARAM_PASSED',

Line 358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);

354: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_start_date_tbl :'||p_planning_start_date_tbl(i);
355: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
356:
357: pa_debug.g_err_stage:='InCorrect Dates Passed p_planning_end_date_tbl :'||p_planning_end_date_tbl(i);
358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_UTILS.get_default_planning_dates: ' || l_module_name,pa_debug.g_err_stage,3);
359: END IF;
360: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
361: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
362: p_token1 => 'PROCEDURENAME',

Line 488: pa_debug.g_err_stage:='Leaving get_default_planning_dates';

484: END IF;
485: END LOOP;
486:
487: IF l_debug_mode = 'Y' THEN
488: pa_debug.g_err_stage:='Leaving get_default_planning_dates';
489: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
490: pa_debug.reset_curr_function;
491: END IF;
492: EXCEPTION

Line 489: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

485: END LOOP;
486:
487: IF l_debug_mode = 'Y' THEN
488: pa_debug.g_err_stage:='Leaving get_default_planning_dates';
489: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
490: pa_debug.reset_curr_function;
491: END IF;
492: EXCEPTION
493:

Line 490: pa_debug.reset_curr_function;

486:
487: IF l_debug_mode = 'Y' THEN
488: pa_debug.g_err_stage:='Leaving get_default_planning_dates';
489: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
490: pa_debug.reset_curr_function;
491: END IF;
492: EXCEPTION
493:
494: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 513: pa_debug.reset_curr_function;

509: x_msg_count := l_msg_count;
510: END IF;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: IF l_debug_mode = 'Y' THEN
513: pa_debug.reset_curr_function;
514: END IF;
515: WHEN OTHERS THEN
516:
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 524: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

520: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_UTILS'
521: ,p_procedure_name => 'get_default_planning_dates');
522:
523: IF l_debug_mode = 'Y' THEN
524: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
525: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
526: pa_debug.reset_curr_function;
527: END IF;
528: RAISE;

Line 525: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

521: ,p_procedure_name => 'get_default_planning_dates');
522:
523: IF l_debug_mode = 'Y' THEN
524: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
525: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
526: pa_debug.reset_curr_function;
527: END IF;
528: RAISE;
529:

Line 526: pa_debug.reset_curr_function;

522:
523: IF l_debug_mode = 'Y' THEN
524: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
525: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
526: pa_debug.reset_curr_function;
527: END IF;
528: RAISE;
529:
530: END get_default_planning_dates;

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

602:
603: l_project_id pa_budget_versions.project_id%TYPE;
604: l_fin_structure_ver_id pa_budget_versions.project_structure_version_id%Type;
605: BEGIN
606: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
607: l_debug_mode := NVL(l_debug_mode, 'N');
608: x_msg_count := 0;
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610: IF l_debug_mode = 'Y' THEN

Line 611: PA_DEBUG.Set_Curr_Function( p_function => 'pafpptub.call_update_rep_lines_api',

607: l_debug_mode := NVL(l_debug_mode, 'N');
608: x_msg_count := 0;
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610: IF l_debug_mode = 'Y' THEN
611: PA_DEBUG.Set_Curr_Function( p_function => 'pafpptub.call_update_rep_lines_api',
612: p_debug_mode => l_debug_mode );
613: pa_debug.g_err_stage:='Validating input parameters';
614: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
615: END IF;

Line 613: pa_debug.g_err_stage:='Validating input parameters';

609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610: IF l_debug_mode = 'Y' THEN
611: PA_DEBUG.Set_Curr_Function( p_function => 'pafpptub.call_update_rep_lines_api',
612: p_debug_mode => l_debug_mode );
613: pa_debug.g_err_stage:='Validating input parameters';
614: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
615: END IF;
616:
617: IF p_source IS NULL THEN

Line 614: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

610: IF l_debug_mode = 'Y' THEN
611: PA_DEBUG.Set_Curr_Function( p_function => 'pafpptub.call_update_rep_lines_api',
612: p_debug_mode => l_debug_mode );
613: pa_debug.g_err_stage:='Validating input parameters';
614: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
615: END IF;
616:
617: IF p_source IS NULL THEN
618:

Line 620: pa_debug.g_err_stage:='p_source is '||p_source;

616:
617: IF p_source IS NULL THEN
618:
619: IF l_debug_mode = 'Y' THEN
620: pa_debug.g_err_stage:='p_source is '||p_source;
621: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
622: END IF;
623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
624: p_msg_name => 'PA_FP_INV_PARAM_PASSED',

Line 621: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

617: IF p_source IS NULL THEN
618:
619: IF l_debug_mode = 'Y' THEN
620: pa_debug.g_err_stage:='p_source is '||p_source;
621: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
622: END IF;
623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
624: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
625: p_token1 => 'PROCEDURENAME',

Line 634: pa_debug.g_err_stage:='p_budget_version_id is '||p_budget_version_id;

630:
631: IF p_budget_version_id IS NULL THEN
632:
633: IF l_debug_mode = 'Y' THEN
634: pa_debug.g_err_stage:='p_budget_version_id is '||p_budget_version_id;
635: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
636: END IF;
637: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
638: p_msg_name => 'PA_FP_INV_PARAM_PASSED',

Line 635: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

631: IF p_budget_version_id IS NULL THEN
632:
633: IF l_debug_mode = 'Y' THEN
634: pa_debug.g_err_stage:='p_budget_version_id is '||p_budget_version_id;
635: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
636: END IF;
637: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
638: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
639: p_token1 => 'PROCEDURENAME',

Line 649: pa_debug.g_err_stage:='Resource assignment id table is empty. Returning';

645: IF p_source ='PL-SQL' AND
646: p_resource_assignment_id_tbl.COUNT = 0 THEN
647:
648: IF l_debug_mode = 'Y' THEN
649: pa_debug.g_err_stage:='Resource assignment id table is empty. Returning';
650: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
651: pa_debug.reset_curr_function;
652: END IF;
653: RETURN;

Line 650: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

646: p_resource_assignment_id_tbl.COUNT = 0 THEN
647:
648: IF l_debug_mode = 'Y' THEN
649: pa_debug.g_err_stage:='Resource assignment id table is empty. Returning';
650: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
651: pa_debug.reset_curr_function;
652: END IF;
653: RETURN;
654:

Line 651: pa_debug.reset_curr_function;

647:
648: IF l_debug_mode = 'Y' THEN
649: pa_debug.g_err_stage:='Resource assignment id table is empty. Returning';
650: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
651: pa_debug.reset_curr_function;
652: END IF;
653: RETURN;
654:
655: END IF;

Line 659: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';

655: END IF;
656:
657:
658: IF l_debug_mode = 'Y' THEN
659: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';
660: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
661: END IF;
662:
663: --Getting the project id to call the function PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID

Line 660: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

656:
657:
658: IF l_debug_mode = 'Y' THEN
659: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';
660: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
661: END IF;
662:
663: --Getting the project id to call the function PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID
664: SELECT project_id INTO l_project_id

Line 676: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';

672: IF p_source = 'PA_RBS_PLANS_OUT_TMP' OR
673: p_source = 'PROCESS_RES_CHG_DERV_CALC_PRMS'THEN
674:
675: IF l_debug_mode = 'Y' THEN
676: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';
677: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
678: END IF;
679:
680: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 677: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

673: p_source = 'PROCESS_RES_CHG_DERV_CALC_PRMS'THEN
674:
675: IF l_debug_mode = 'Y' THEN
676: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';
677: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
678: END IF;
679:
680: INSERT INTO PJI_FM_EXTR_PLAN_LINES
681: ( PROJECT_ID

Line 770: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;

766: AND pbl.start_date <= nvl(pbv.etc_start_date, pbl.start_date+1);
767:
768: l_rows_inserted := SQL%ROWCOUNT;
769: IF l_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
771: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
772: END IF;
773:
774: END IF;

Line 771: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

767:
768: l_rows_inserted := SQL%ROWCOUNT;
769: IF l_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
771: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
772: END IF;
773:
774: END IF;
775:

Line 779: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';

775:
776: IF p_source ='PA_FP_RA_MAP_TMP' THEN
777:
778: IF l_debug_mode = 'Y' THEN
779: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';
780: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
781: END IF;
782:
783: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 780: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

776: IF p_source ='PA_FP_RA_MAP_TMP' THEN
777:
778: IF l_debug_mode = 'Y' THEN
779: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';
780: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
781: END IF;
782:
783: INSERT INTO PJI_FM_EXTR_PLAN_LINES
784: ( PROJECT_ID

Line 866: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;

862: AND pbl.pfc_cur_conv_rejection_code IS NULL ;
863:
864: l_rows_inserted := SQL%ROWCOUNT;
865: IF l_debug_mode = 'Y' THEN
866: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
867: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
868: END IF;
869:
870: END IF;

Line 867: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

863:
864: l_rows_inserted := SQL%ROWCOUNT;
865: IF l_debug_mode = 'Y' THEN
866: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
867: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
868: END IF;
869:
870: END IF;
871: /*

Line 908: pa_debug.g_err_stage:='Selectiong from PL-SQL ';

904: */
905: IF p_source ='PL-SQL' THEN
906:
907: IF l_debug_mode = 'Y' THEN
908: pa_debug.g_err_stage:='Selectiong from PL-SQL ';
909: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
910: END IF;
911:
912: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST

Line 909: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

905: IF p_source ='PL-SQL' THEN
906:
907: IF l_debug_mode = 'Y' THEN
908: pa_debug.g_err_stage:='Selectiong from PL-SQL ';
909: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
910: END IF;
911:
912: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST
913: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 991: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;

987:
988: l_rows_inserted := SQL%ROWCOUNT;
989: --DEBUG_NS('No of rows inserted = ' || l_rows_inserted);
990: IF l_debug_mode = 'Y' THEN
991: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
993: END IF;
994:
995: END IF;

Line 992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

988: l_rows_inserted := SQL%ROWCOUNT;
989: --DEBUG_NS('No of rows inserted = ' || l_rows_inserted);
990: IF l_debug_mode = 'Y' THEN
991: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
992: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
993: END IF;
994:
995: END IF;
996:

Line 1000: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';

996:
997: IF p_source = 'REFRESH_WP_SETTINGS' THEN --Bug 5073350. Changed the source from POPULATE_PJI_TABLE to REFRESH_WP_SETTINGS.
998:
999: IF l_debug_mode = 'Y' THEN
1000: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
1001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1004: END IF;

Line 1001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

997: IF p_source = 'REFRESH_WP_SETTINGS' THEN --Bug 5073350. Changed the source from POPULATE_PJI_TABLE to REFRESH_WP_SETTINGS.
998:
999: IF l_debug_mode = 'Y' THEN
1000: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
1001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1004: END IF;
1005:

Line 1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;

998:
999: IF l_debug_mode = 'Y' THEN
1000: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
1001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1004: END IF;
1005:
1006: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

999: IF l_debug_mode = 'Y' THEN
1000: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
1001: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1004: END IF;
1005:
1006: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1007: ( PROJECT_ID

Line 1088: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;

1084:
1085: l_rows_inserted := SQL%ROWCOUNT;
1086:
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
1089: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1090: END IF;
1091:
1092: END IF;

Line 1089: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1085: l_rows_inserted := SQL%ROWCOUNT;
1086:
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
1089: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1090: END IF;
1091:
1092: END IF;
1093:

Line 1106: pa_debug.g_err_stage:='Calling the PJI API';

1102:
1103: IF nvl(l_rows_inserted,0) >0 THEN
1104:
1105: IF l_debug_mode = 'Y' THEN
1106: pa_debug.g_err_stage:='Calling the PJI API';
1107: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1108: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1109:
1110: END IF;

Line 1107: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1103: IF nvl(l_rows_inserted,0) >0 THEN
1104:
1105: IF l_debug_mode = 'Y' THEN
1106: pa_debug.g_err_stage:='Calling the PJI API';
1107: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1108: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1109:
1110: END IF;
1111:

Line 1108: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);

1104:
1105: IF l_debug_mode = 'Y' THEN
1106: pa_debug.g_err_stage:='Calling the PJI API';
1107: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1108: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1109:
1110: END IF;
1111:
1112: /*Bug 5073350. Commented out this IF condition as the plan_update api

Line 1122: pa_debug.write('xxxxxxx','x_return_status from plan update '||x_return_status,5);

1118: ,x_msg_code =>l_msg_code
1119: ,x_return_status =>x_return_status);
1120:
1121: IF l_debug_mode = 'Y' THEN
1122: pa_debug.write('xxxxxxx','x_return_status from plan update '||x_return_status,5);
1123: END IF;
1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125:
1126: IF l_debug_mode = 'Y' THEN

Line 1127: pa_debug.g_err_stage:='Called API PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE returned error';

1123: END IF;
1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125:
1126: IF l_debug_mode = 'Y' THEN
1127: pa_debug.g_err_stage:='Called API PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE returned error';
1128: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1129: END IF;
1130: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1131:

Line 1128: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);

1124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125:
1126: IF l_debug_mode = 'Y' THEN
1127: pa_debug.g_err_stage:='Called API PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE returned error';
1128: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1129: END IF;
1130: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1131:
1132: END IF;

Line 1138: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';

1134:
1135: END IF;
1136:
1137: IF l_debug_mode = 'Y' THEN
1138: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1139: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1140: pa_debug.reset_curr_function;
1141: END IF;
1142: EXCEPTION

Line 1139: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1135: END IF;
1136:
1137: IF l_debug_mode = 'Y' THEN
1138: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1139: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1140: pa_debug.reset_curr_function;
1141: END IF;
1142: EXCEPTION
1143: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1140: pa_debug.reset_curr_function;

1136:
1137: IF l_debug_mode = 'Y' THEN
1138: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1139: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1140: pa_debug.reset_curr_function;
1141: END IF;
1142: EXCEPTION
1143: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1144: l_msg_count := FND_MSG_PUB.count_msg;

Line 1160: pa_debug.reset_curr_function;

1156: x_msg_count := l_msg_count;
1157: END IF;
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: IF l_debug_mode = 'Y' THEN
1160: pa_debug.reset_curr_function;
1161: END IF;
1162: WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: x_msg_count := 1;

Line 1170: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

1166: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_UTILS'
1167: ,p_procedure_name => 'call_update_rep_lines_api');
1168:
1169: IF l_debug_mode = 'Y' THEN
1170: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1171: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1172: pa_debug.reset_curr_function;
1173: END IF;
1174: RAISE;

Line 1171: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);

1167: ,p_procedure_name => 'call_update_rep_lines_api');
1168:
1169: IF l_debug_mode = 'Y' THEN
1170: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1171: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1172: pa_debug.reset_curr_function;
1173: END IF;
1174: RAISE;
1175:

Line 1172: pa_debug.reset_curr_function;

1168:
1169: IF l_debug_mode = 'Y' THEN
1170: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1171: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1172: pa_debug.reset_curr_function;
1173: END IF;
1174: RAISE;
1175:
1176: END call_update_rep_lines_api;