DBA Data[Home] [Help]

APPS.PA_DATE_RANGE_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 338: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

334: l_debug_mode := NVL(l_debug_mode, 'Y');
335: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
336: IF l_debug_mode = 'Y' THEN
337: pa_debug.g_err_stage := 'Entered Date Range Upgrade';
338: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
339:
340: pa_debug.g_err_stage := 'Checking for valid parameters';
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
342: END IF;

Line 341: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

337: pa_debug.g_err_stage := 'Entered Date Range Upgrade';
338: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
339:
340: pa_debug.g_err_stage := 'Checking for valid parameters';
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
342: END IF;
343:
344:
345:

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

345:
346: if (p_budget_versions.count <= 0 ) then
347: IF l_debug_mode = 'Y' THEN
348: pa_debug.g_err_stage := 'Budget Versions Not Passed as Input';
349: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
350: END IF;
351: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
352: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
353: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 353: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

349: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
350: END IF;
351: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
352: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
353: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
354: end if;
355:
356:
357:

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

379:
380: --NOT Plan-Version: SKIP to the Next Budget Version
381: IF l_debug_mode = 'Y' THEN
382: pa_debug.g_err_stage := 'SKIPPED NON-Plan-Version Budget Version='||to_char(l_budget_version_id);
383: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
384: END IF;
385:
386: GOTO skip_version; -- goto end of budget version loop
387:

Line 532: pa_debug.write(l_module_name,'Upgrade Mode is' || g_upgrade_mode,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

528: -- End Bug 3673111, 07-JUN-04, jwhite ------------------------------------------------------
529:
530: IF l_debug_mode = 'Y' THEN
531: pa_debug.g_err_stage := 'Mode of the upgrade';
532: pa_debug.write(l_module_name,'Upgrade Mode is' || g_upgrade_mode,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
533: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
534: end if;
535:
536:

Line 533: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

529:
530: IF l_debug_mode = 'Y' THEN
531: pa_debug.g_err_stage := 'Mode of the upgrade';
532: pa_debug.write(l_module_name,'Upgrade Mode is' || g_upgrade_mode,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
533: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
534: end if;
535:
536:
537: IF l_debug_mode = 'Y' THEN

Line 539: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

535:
536:
537: IF l_debug_mode = 'Y' THEN
538: pa_debug.g_err_stage := 'Updating pa_proj_fp_options table';
539: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
540: end if;
541:
542: -- Bug 3804286, 12-AUG-03, jwhite -------------------------------------------------------------
543:

Line 717: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

713:
714: if g_upgrade_mode = 'Non_Time_Phase_Multi_Line' then
715: IF l_debug_mode = 'Y' THEN
716: pa_debug.g_err_stage := 'Entered Non Time Phase Multi Line';
717: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
718: end if;
719: -- Loop for each budget line for the given version
720: for l_get_non_time_multi_csr in get_non_time_multi_csr(l_get_elig_bud_ver_csr.budget_version_id)
721: loop

Line 936: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

932: if (g_upgrade_mode = 'PA_Period_Upgrade') or (g_upgrade_mode = 'GL_Period_Upgrade') then
933:
934: IF l_debug_mode = 'Y' THEN
935: pa_debug.g_err_stage := 'Entered PA/GL Period Upgrade';
936: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
937: end if;
938:
939: -- Loop for Resource Assignment Id for given Budget Version
940: select decode(g_upgrade_mode,'PA_Period_Upgrade',l_pa_period_type,l_accounted_per_type) into l_per_type from dual;

Line 1015: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1011:
1012:
1013: IF l_debug_mode = 'Y' THEN
1014: pa_debug.g_err_stage := 'Inserting into Backup Table';
1015: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1016: end if;
1017:
1018: insert into pa_budget_lines_m_upg_dtrange
1019: (

Line 1408: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1404:
1405: -- Loop to traverse through the array or records.
1406: IF l_debug_mode = 'Y' THEN
1407: pa_debug.g_err_stage := 'Deleting from pa_budget_lines table';
1408: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1409: end if;
1410: for i in l_get_budget_lines_tbl.first .. l_get_budget_lines_tbl.last
1411: loop
1412: delete pa_budget_lines

Line 1526: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1522:
1523: -- Loop to traverse through the array or records for insertion ends.
1524: IF l_debug_mode = 'Y' THEN
1525: pa_debug.g_err_stage := 'Updating pa_budget_lines table';
1526: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1527: end if;
1528: update pa_budget_lines
1529: set
1530: attribute_category = l_attribute_category ,

Line 1569: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then

1565:
1566: end loop;
1567:
1568: EXCEPTION
1569: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then
1570: l_msg_count := FND_MSG_PUB.count_msg;
1571: IF l_msg_count = 1 THEN
1572: PA_INTERFACE_UTILS_PUB.get_messages
1573: (p_encoded => FND_API.G_TRUE

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

1584: END IF;
1585:
1586: IF l_debug_mode = 'Y' THEN
1587: pa_debug.g_err_stage:='Invalid Arguments Passed';
1588: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1589: END IF;
1590: x_return_status:= FND_API.G_RET_STS_ERROR;
1591: pa_debug.reset_err_stack;
1592: -- ROLLBACK; /* Commented-out to maintain the savepoint for the concurrent program. */

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

1638:
1639: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DATE_RANGE_PKG',p_procedure_name => 'DATE_RANGE_UPGRD');
1640: IF l_debug_mode = 'Y' THEN
1641: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1642: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1643: END IF;
1644:
1645: pa_debug.write_file('DATE_RANGE_UPGRD: Upgrade has failed for the budget version '||l_budget_version_id,5);
1646: pa_debug.write_file('DATE_RANGE_UPGRD: Failure Reason:'||pa_debug.G_Err_Stack,5);