DBA Data[Home] [Help]

APPS.PA_FP_CI_INCLUDE_PKG dependencies on PA_DEBUG

Line 65: pa_debug.init_err_stack('PAFPINCB.FP_CI_COPY_CONTROL_ITEMS');

61: l_source_project_id pa_control_items.project_id%TYPE;
62:
63: BEGIN
64: savepoint before_copy_control_items;
65: pa_debug.init_err_stack('PAFPINCB.FP_CI_COPY_CONTROL_ITEMS');
66: IF NVL(p_init_msg_list,'N') = 'Y' THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

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

65: pa_debug.init_err_stack('PAFPINCB.FP_CI_COPY_CONTROL_ITEMS');
66: IF NVL(p_init_msg_list,'N') = 'Y' THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
70: l_debug_mode := NVL(l_debug_mode, 'Y');
71: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: x_msg_count := 0;

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

67: FND_MSG_PUB.initialize;
68: END IF;
69: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
70: l_debug_mode := NVL(l_debug_mode, 'Y');
71: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: x_msg_count := 0;
74:
75: IF (p_calling_context = 'COPY') THEN

Line 306: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

302: ROLLBACK TO before_copy_control_items;
303: FND_MSG_PUB.add_exc_msg
304: ( p_pkg_name => 'pa_fp_ci_include_pkg.' ||
305: 'FP_CI_COPY_CONTROL_ITEMS'
306: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
307: PA_DEBUG.g_err_stage := 'Unexpected error in FP_CI_COPY_CONTROL_ITEMS';
308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
309: ----DBMS_OUTPUT.PUT_LINE('FP_CI_COPY_CONTROL_ITEMS - 11*****');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 307: PA_DEBUG.g_err_stage := 'Unexpected error in FP_CI_COPY_CONTROL_ITEMS';

303: FND_MSG_PUB.add_exc_msg
304: ( p_pkg_name => 'pa_fp_ci_include_pkg.' ||
305: 'FP_CI_COPY_CONTROL_ITEMS'
306: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
307: PA_DEBUG.g_err_stage := 'Unexpected error in FP_CI_COPY_CONTROL_ITEMS';
308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
309: ----DBMS_OUTPUT.PUT_LINE('FP_CI_COPY_CONTROL_ITEMS - 11*****');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: PA_DEBUG.Reset_Curr_Function;

Line 308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

304: ( p_pkg_name => 'pa_fp_ci_include_pkg.' ||
305: 'FP_CI_COPY_CONTROL_ITEMS'
306: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
307: PA_DEBUG.g_err_stage := 'Unexpected error in FP_CI_COPY_CONTROL_ITEMS';
308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
309: ----DBMS_OUTPUT.PUT_LINE('FP_CI_COPY_CONTROL_ITEMS - 11*****');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: PA_DEBUG.Reset_Curr_Function;
312: RAISE;

Line 311: PA_DEBUG.Reset_Curr_Function;

307: PA_DEBUG.g_err_stage := 'Unexpected error in FP_CI_COPY_CONTROL_ITEMS';
308: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
309: ----DBMS_OUTPUT.PUT_LINE('FP_CI_COPY_CONTROL_ITEMS - 11*****');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: PA_DEBUG.Reset_Curr_Function;
312: RAISE;
313:
314: END FP_CI_COPY_CONTROL_ITEMS;
315: --end of FP_CI_COPY_CONTROL_ITEMS

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

393:
394: x_msg_count := 0;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
398: l_debug_mode := NVL(l_debug_mode, 'Y');
399:
400: -- Set curr function
401: pa_debug.set_curr_function(

Line 401: pa_debug.set_curr_function(

397: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
398: l_debug_mode := NVL(l_debug_mode, 'Y');
399:
400: -- Set curr function
401: pa_debug.set_curr_function(
402: p_function =>'PAFPINCB.populate_ci_fin_impact_records'
403: ,p_debug_mode => l_debug_mode );
404:
405: -- Check for business rules violations

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

403: ,p_debug_mode => l_debug_mode );
404:
405: -- Check for business rules violations
406: IF l_debug_mode = 'Y' THEN
407: pa_debug.g_err_stage:='Validating input parameters';
408: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);
409: END IF;
410:
411: IF (p_project_id IS NULL) OR

Line 408: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);

404:
405: -- Check for business rules violations
406: IF l_debug_mode = 'Y' THEN
407: pa_debug.g_err_stage:='Validating input parameters';
408: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);
409: END IF;
410:
411: IF (p_project_id IS NULL) OR
412: (p_target_ci_id IS NULL) OR

Line 418: pa_debug.g_err_stage:='Project_id = '||p_project_id;

414: (p_calling_context NOT IN ('INCLUDE','COPY'))
415: THEN
416:
417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:='Project_id = '||p_project_id;
419: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
420:
421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

Line 419: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

415: THEN
416:
417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:='Project_id = '||p_project_id;
419: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
420:
421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
423:

Line 421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;

417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:='Project_id = '||p_project_id;
419: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
420:
421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
423:
424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

Line 422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

418: pa_debug.g_err_stage:='Project_id = '||p_project_id;
419: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
420:
421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
423:
424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
426:

Line 424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;

420:
421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
423:
424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
426:
427: pa_debug.g_err_stage:='p_calling_context = '||p_calling_context;
428: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

Line 425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

421: pa_debug.g_err_stage:='p_target_ci_id = '||p_target_ci_id;
422: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
423:
424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
426:
427: pa_debug.g_err_stage:='p_calling_context = '||p_calling_context;
428: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
429: END IF;

Line 427: pa_debug.g_err_stage:='p_calling_context = '||p_calling_context;

423:
424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
426:
427: pa_debug.g_err_stage:='p_calling_context = '||p_calling_context;
428: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
429: END IF;
430:
431: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 428: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

424: pa_debug.g_err_stage:='p_source_ci_id = '||p_source_ci_id;
425: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
426:
427: pa_debug.g_err_stage:='p_calling_context = '||p_calling_context;
428: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
429: END IF;
430:
431: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
432: p_msg_name => 'PA_FP_INV_PARAM_PASSED',

Line 471: pa_debug.reset_curr_function();

467: AND impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE');
468:
469: IF l_allowed_impacts_count = 0 THEN
470: -- target change order type does not allow financail impact
471: pa_debug.reset_curr_function();
472: return;
473: ELSIF l_allowed_impacts_count = 1 THEN
474:
475: IF l_appr_bdgt_pt_exists = 'Y' THEN

Line 478: pa_debug.reset_curr_function();

474:
475: IF l_appr_bdgt_pt_exists = 'Y' THEN
476: -- if its approved budget create impact records only if change
477: -- type allows both cost and revenue impacts
478: pa_debug.reset_curr_function();
479: return;
480: END IF;
481: END IF;
482:

Line 540: pa_debug.g_err_stage:='Exiting populate_ci_fin_impact_records';

536: END LOOP;
537:
538:
539: IF l_debug_mode = 'Y' THEN
540: pa_debug.g_err_stage:='Exiting populate_ci_fin_impact_records';
541: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);
542: END IF;
543:
544: -- reset curr function

Line 541: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);

537:
538:
539: IF l_debug_mode = 'Y' THEN
540: pa_debug.g_err_stage:='Exiting populate_ci_fin_impact_records';
541: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);
542: END IF;
543:
544: -- reset curr function
545: pa_debug.reset_curr_function();

Line 545: pa_debug.reset_curr_function();

541: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,3);
542: END IF;
543:
544: -- reset curr function
545: pa_debug.reset_curr_function();
546:
547: EXCEPTION
548:
549: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 569: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';

565:
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: IF l_debug_mode = 'Y' THEN
569: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
570: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
571:
572: END IF;
573:

Line 570: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: IF l_debug_mode = 'Y' THEN
569: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
570: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
571:
572: END IF;
573:
574: -- reset curr function

Line 575: pa_debug.reset_curr_function();

571:
572: END IF;
573:
574: -- reset curr function
575: pa_debug.reset_curr_function();
576:
577: RETURN;
578: WHEN Others THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

583: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'FP_CI_COPY_CONTROL_ITEMS'
584: ,p_procedure_name => 'populate_ci_fin_impact_records');
585:
586: IF l_debug_mode = 'Y' THEN
587: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
588: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
589: END IF;
590:
591: -- reset curr function

Line 588: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);

584: ,p_procedure_name => 'populate_ci_fin_impact_records');
585:
586: IF l_debug_mode = 'Y' THEN
587: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
588: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
589: END IF;
590:
591: -- reset curr function
592: pa_debug.Reset_Curr_Function();

Line 592: pa_debug.Reset_Curr_Function();

588: pa_debug.write('populate_ci_fin_impact_records: ' || l_module_name,pa_debug.g_err_stage,5);
589: END IF;
590:
591: -- reset curr function
592: pa_debug.Reset_Curr_Function();
593:
594: RAISE;
595: END populate_ci_fin_impact_records;
596: