DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on PA_BUDGET_UTILS

Line 354: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AC';

350:
351: --Fetch lastest Approved Cost baselined version id as basis_cost_version_id
352:
353: IF p_pa_debug_mode = 'Y' THEN
354: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AC';
355: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
356: END IF;
357:
358: pa_budget_utils.get_baselined_version_id (

Line 358: pa_budget_utils.get_baselined_version_id (

354: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AC';
355: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
356: END IF;
357:
358: pa_budget_utils.get_baselined_version_id (
359: x_project_id => p_project_id
360: ,x_budget_type_code => PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC
361: ,x_budget_version_id => x_upgrade_elements_rec.basis_cost_version_id
362: ,x_err_code => l_err_code

Line 370: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';

366: /* Bug# 2643043 -- Error code 10 is no_data_found */
367: IF l_err_code NOT IN (10,0) THEN
368: -- the api has returned an error
369: IF p_pa_debug_mode = 'Y' THEN
370: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';
371: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
372: END IF;
373: RAISE pa_fp_constants_pkg.invalid_arg_exc;
374: END IF;

Line 381: pa_debug.g_err_stage:='Calling pa_budget_utils.get_draft_version_id as no baselined version for no AC';

377:
378: --Fetch Approved Cost working version as basis_cost_version_id
379:
380: IF p_pa_debug_mode = 'Y' THEN
381: pa_debug.g_err_stage:='Calling pa_budget_utils.get_draft_version_id as no baselined version for no AC';
382: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
383: END IF;
384:
385: pa_budget_utils.get_draft_version_id (

Line 385: pa_budget_utils.get_draft_version_id (

381: pa_debug.g_err_stage:='Calling pa_budget_utils.get_draft_version_id as no baselined version for no AC';
382: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
383: END IF;
384:
385: pa_budget_utils.get_draft_version_id (
386: x_project_id => p_project_id
387: ,x_budget_type_code => PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC
388: ,x_budget_version_id => x_upgrade_elements_rec.basis_cost_version_id
389: ,x_err_code => l_err_code

Line 398: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';

394: /* Bug# 2643043 -- Error code 10 is no_data_found */
395: IF l_err_code NOT IN (10,0) THEN
396: -- the api has returned an error
397: IF p_pa_debug_mode = 'Y' THEN
398: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';
399: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
400: END IF;
401: RAISE pa_fp_constants_pkg.invalid_arg_exc;
402: END IF;

Line 420: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AR';

416:
417: --Fetch lastest Approved Revenue baselined version id as basis_rev_version_id
418:
419: IF p_pa_debug_mode = 'Y' THEN
420: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AR';
421: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
422: END IF;
423:
424: pa_budget_utils.get_baselined_version_id (

Line 424: pa_budget_utils.get_baselined_version_id (

420: pa_debug.g_err_stage:='Calling pa_budget_utils.get_baselined_version_id for AR';
421: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
422: END IF;
423:
424: pa_budget_utils.get_baselined_version_id (
425: x_project_id => p_project_id
426: ,x_budget_type_code => PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR
427: ,x_budget_version_id => x_upgrade_elements_rec.basis_rev_version_id
428: ,x_err_code => l_err_code

Line 437: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';

433: /* Bug# 2643043 -- Error code 10 is no_data_found */
434: IF l_err_code NOT IN (10,0) THEN
435: -- the api has returned an error
436: IF p_pa_debug_mode = 'Y' THEN
437: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';
438: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
439: END IF;
440: RAISE pa_fp_constants_pkg.invalid_arg_exc;
441: END IF;

Line 448: pa_debug.g_err_stage:='Calling pa_budget_utils.get_draft_version_id as no baselined version for no AR';

444:
445: -- baselined version doesn't exist
446:
447: IF p_pa_debug_mode = 'Y' THEN
448: pa_debug.g_err_stage:='Calling pa_budget_utils.get_draft_version_id as no baselined version for no AR';
449: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
450: END IF;
451:
452: --Fetch Approved Revenue working version

Line 454: pa_budget_utils.get_draft_version_id (

450: END IF;
451:
452: --Fetch Approved Revenue working version
453:
454: pa_budget_utils.get_draft_version_id (
455: x_project_id => p_project_id
456: ,x_budget_type_code => PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR
457: ,x_budget_version_id => x_upgrade_elements_rec.basis_rev_version_id
458: ,x_err_code => l_err_code

Line 472: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';

468: /* Bug# 2643043 -- Error code 10 is no_data_found */
469: IF l_err_code NOT IN (10,0) THEN
470: -- the api has returned an error
471: IF p_pa_debug_mode = 'Y' THEN
472: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';
473: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
474: END IF;
475: RAISE pa_fp_constants_pkg.invalid_arg_exc;
476: END IF;

Line 522: pa_budget_utils.get_baselined_version_id (

518: IF x_upgrade_elements_rec.curr_option_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
519:
520: --Fetch lastest baselined version id as basis_cost_version_id
521:
522: pa_budget_utils.get_baselined_version_id (
523: x_project_id => p_project_id
524: ,x_budget_type_code => p_budget_type_code
525: ,x_budget_version_id => x_upgrade_elements_rec.basis_cost_version_id
526: ,x_err_code => l_err_code

Line 535: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';

531: /* Bug# 2643043 -- Error code 10 is no_data_found */
532: IF l_err_code not in (10,0) THEN
533: -- the api has returned an error
534: IF p_pa_debug_mode = 'Y' THEN
535: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';
536: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
537: END IF;
538: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
539: END IF;

Line 545: pa_budget_utils.get_draft_version_id (

541: IF l_err_code = 10 or x_upgrade_elements_rec.basis_cost_version_id IS NULL THEN /* Bug# 2643043 */
542:
543: --Fetch working version as basis_cost_version_id
544:
545: pa_budget_utils.get_draft_version_id (
546: x_project_id => p_project_id
547: ,x_budget_type_code => p_budget_type_code
548: ,x_budget_version_id => x_upgrade_elements_rec.basis_cost_version_id
549: ,x_err_code => l_err_code

Line 563: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';

559: /* Bug# 2643043 -- Error code 10 is no_data_found */
560: IF l_err_code not in (10,0) THEN
561: -- the api has returned an error
562: IF p_pa_debug_mode = 'Y' THEN
563: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';
564: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
565: END IF;
566: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
567: END IF;

Line 574: pa_budget_utils.get_baselined_version_id (

570: ELSIF x_upgrade_elements_rec.curr_option_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
571:
572: --Fetch lastest baselined version id as basis_rev_version_id
573:
574: pa_budget_utils.get_baselined_version_id (
575: x_project_id => p_project_id
576: ,x_budget_type_code => p_budget_type_code
577: ,x_budget_version_id => x_upgrade_elements_rec.basis_rev_version_id
578: ,x_err_code => l_err_code

Line 587: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';

583: /* Bug# 2643043 -- Error code 10 is no_data_found */
584: IF l_err_code not in (10,0) THEN
585: -- the api has returned an error
586: IF p_pa_debug_mode = 'Y' THEN
587: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_baselined_version_id';
588: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
589: END IF;
590: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
591: END IF;

Line 597: pa_budget_utils.get_draft_version_id (

593: IF l_err_code = 10 or x_upgrade_elements_rec.basis_cost_version_id IS NULL THEN /* Bug# 2643043 */
594:
595: --Fetch working version as basis_rev_version_id
596:
597: pa_budget_utils.get_draft_version_id (
598: x_project_id => p_project_id
599: ,x_budget_type_code => p_budget_type_code
600: ,x_budget_version_id => x_upgrade_elements_rec.basis_rev_version_id
601: ,x_err_code => l_err_code

Line 615: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';

611: /* Bug# 2643043 -- Error code 10 is no_data_found */
612: IF l_err_code not in (10,0) THEN
613: -- the api has returned an error
614: IF p_pa_debug_mode = 'Y' THEN
615: pa_debug.g_err_stage:='Error returned by pa_budget_utils.get_draft_version_id';
616: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: END IF;
618: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
619: END IF;

Line 3530: pa_budget_utils.get_draft_version_id (

3526: END IF;
3527:
3528: l_draft_version_id := Null;
3529:
3530: pa_budget_utils.get_draft_version_id (
3531: x_project_id => p_project_id
3532: ,x_budget_type_code => p_budget_type_code
3533: ,x_budget_version_id => l_draft_version_id
3534: ,x_err_code => l_err_code