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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 650: pa_debug.reset_curr_function;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

857: AND pbl.pfc_cur_conv_rejection_code IS NULL ;
858:
859: l_rows_inserted := SQL%ROWCOUNT;
860: IF l_debug_mode = 'Y' THEN
861: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
862: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
863: END IF;
864:
865: END IF;

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

858:
859: l_rows_inserted := SQL%ROWCOUNT;
860: IF l_debug_mode = 'Y' THEN
861: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
862: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
863: END IF;
864:
865: END IF;
866:

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

866:
867: IF p_source ='PL-SQL' THEN
868:
869: IF l_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:='Selectiong from PL-SQL ';
871: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
872: END IF;
873:
874: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST

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

867: IF p_source ='PL-SQL' THEN
868:
869: IF l_debug_mode = 'Y' THEN
870: pa_debug.g_err_stage:='Selectiong from PL-SQL ';
871: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
872: END IF;
873:
874: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST
875: INSERT INTO PJI_FM_EXTR_PLAN_LINES

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

946: AND p_pfc_cur_conv_rej_code_tbl(i) IS NULL ;
947:
948: l_rows_inserted := SQL%ROWCOUNT;
949: IF l_debug_mode = 'Y' THEN
950: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
951: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
952: END IF;
953:
954: END IF;

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

947:
948: l_rows_inserted := SQL%ROWCOUNT;
949: IF l_debug_mode = 'Y' THEN
950: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
951: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
952: END IF;
953:
954: END IF;
955:

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

955:
956: IF p_source = 'REFRESH_WP_SETTINGS' THEN --Bug 5073350. Changed the source from POPULATE_PJI_TABLE to REFRESH_WP_SETTINGS.
957:
958: IF l_debug_mode = 'Y' THEN
959: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
960: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
961: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
962: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
963: END IF;

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

956: IF p_source = 'REFRESH_WP_SETTINGS' THEN --Bug 5073350. Changed the source from POPULATE_PJI_TABLE to REFRESH_WP_SETTINGS.
957:
958: IF l_debug_mode = 'Y' THEN
959: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
960: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
961: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
962: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
963: END IF;
964:

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

957:
958: IF l_debug_mode = 'Y' THEN
959: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
960: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
961: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
962: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
963: END IF;
964:
965: INSERT INTO PJI_FM_EXTR_PLAN_LINES

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

958: IF l_debug_mode = 'Y' THEN
959: pa_debug.g_err_stage:='In If p_source = POPULATE_PJI_TAB ';
960: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
961: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
962: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
963: END IF;
964:
965: INSERT INTO PJI_FM_EXTR_PLAN_LINES
966: ( PROJECT_ID

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

1041:
1042: l_rows_inserted := SQL%ROWCOUNT;
1043:
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1047: END IF;
1048:
1049: END IF;

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

1042: l_rows_inserted := SQL%ROWCOUNT;
1043:
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage:='No of rows inserted = '||l_rows_inserted;
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1047: END IF;
1048:
1049: END IF;
1050:

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

1050:
1051: IF nvl(l_rows_inserted,0) >0 THEN
1052:
1053: IF l_debug_mode = 'Y' THEN
1054: pa_debug.g_err_stage:='Calling the PJI API';
1055: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1056: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1057:
1058: END IF;

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

1051: IF nvl(l_rows_inserted,0) >0 THEN
1052:
1053: IF l_debug_mode = 'Y' THEN
1054: pa_debug.g_err_stage:='Calling the PJI API';
1055: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1056: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1057:
1058: END IF;
1059:

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

1052:
1053: IF l_debug_mode = 'Y' THEN
1054: pa_debug.g_err_stage:='Calling the PJI API';
1055: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1056: pa_debug.write('xxxxxxx','x_return_status before plan update '||x_return_status,5);
1057:
1058: END IF;
1059:
1060: /*Bug 5073350. Commented out this IF condition as the plan_update api

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

1066: ,x_msg_code =>l_msg_code
1067: ,x_return_status =>x_return_status);
1068:
1069: IF l_debug_mode = 'Y' THEN
1070: pa_debug.write('xxxxxxx','x_return_status from plan update '||x_return_status,5);
1071: END IF;
1072: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1073:
1074: IF l_debug_mode = 'Y' THEN

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

1071: END IF;
1072: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1073:
1074: IF l_debug_mode = 'Y' THEN
1075: pa_debug.g_err_stage:='Called API PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE returned error';
1076: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1077: END IF;
1078: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1079:

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

1072: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1073:
1074: IF l_debug_mode = 'Y' THEN
1075: pa_debug.g_err_stage:='Called API PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE returned error';
1076: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1077: END IF;
1078: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1079:
1080: END IF;

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

1082:
1083: END IF;
1084:
1085: IF l_debug_mode = 'Y' THEN
1086: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1087: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1088: pa_debug.reset_curr_function;
1089: END IF;
1090: EXCEPTION

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

1083: END IF;
1084:
1085: IF l_debug_mode = 'Y' THEN
1086: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1087: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1088: pa_debug.reset_curr_function;
1089: END IF;
1090: EXCEPTION
1091: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1088: pa_debug.reset_curr_function;

1084:
1085: IF l_debug_mode = 'Y' THEN
1086: pa_debug.g_err_stage:='Leaving call_update_rep_lines_api';
1087: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1088: pa_debug.reset_curr_function;
1089: END IF;
1090: EXCEPTION
1091: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1092: l_msg_count := FND_MSG_PUB.count_msg;

Line 1108: pa_debug.reset_curr_function;

1104: x_msg_count := l_msg_count;
1105: END IF;
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: IF l_debug_mode = 'Y' THEN
1108: pa_debug.reset_curr_function;
1109: END IF;
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: x_msg_count := 1;

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

1114: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_UTILS'
1115: ,p_procedure_name => 'call_update_rep_lines_api');
1116:
1117: IF l_debug_mode = 'Y' THEN
1118: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1119: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1120: pa_debug.reset_curr_function;
1121: END IF;
1122: RAISE;

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

1115: ,p_procedure_name => 'call_update_rep_lines_api');
1116:
1117: IF l_debug_mode = 'Y' THEN
1118: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1119: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1120: pa_debug.reset_curr_function;
1121: END IF;
1122: RAISE;
1123:

Line 1120: pa_debug.reset_curr_function;

1116:
1117: IF l_debug_mode = 'Y' THEN
1118: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1119: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
1120: pa_debug.reset_curr_function;
1121: END IF;
1122: RAISE;
1123:
1124: END call_update_rep_lines_api;