DBA Data[Home] [Help]

APPS.PA_FP_ROLLUP_PKG dependencies on FND_PROFILE

Line 21: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

17: based on a budget version id. These local variables are required for processing in other APIs.
18: Hence this procedure is called wherever local variables need to be populated.
19: =================================================================================================*/
20:
21: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
22:
23: PROCEDURE POPULATE_LOCAL_VARS(p_budget_version_id IN NUMBER
24: ,x_project_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
25: ,x_resource_list_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

53: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Populate_Local_Vars');
54:
55: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
56:
57: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
58: l_debug_mode := NVL(l_debug_mode, 'Y');
59:
60: -- Initialize the return status to success
61: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

468: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Rollup_Budget_Version');
469: END IF;
470:
471: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
472: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
473: l_debug_mode := NVL(l_debug_mode, 'Y');
474:
475: -- Initialize the return status to success
476: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

990: -- Set the error stack.
991: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Refresh_Resource_Assignments');
992:
993: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
994: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
995: l_debug_mode := NVL(l_debug_mode, 'Y');
996:
997: -- Initialize the return status to success
998: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1614: -- Set the error stack.
1615: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.UPDATE_RES_PARENT_ASSIGN_ID');
1616:
1617: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
1618: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1619: l_debug_mode := NVL(l_debug_mode, 'Y');
1620:
1621: -- Initialize the return status to success
1622: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1891: -- Set the error stack.
1892: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Insert_Bulk_Rows_Res');
1893:
1894: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
1895: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1896: l_debug_mode := NVL(l_debug_mode, 'Y');
1897:
1898: -- Initialize the return status to success
1899: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2059: -- Set the error stack.
2060: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Refresh_Period_Denorm');
2061:
2062: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
2063: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2064: l_debug_mode := NVL(l_debug_mode, 'Y');
2065:
2066: -- Initialize the return status to success
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2481: -- Set the error stack.
2482: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Update_Denorm_Parent_Assign_ID');
2483:
2484: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
2485: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2486: l_debug_mode := NVL(l_debug_mode, 'Y');
2487:
2488: -- Initialize the return status to success
2489: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2645: -- Set the error stack.
2646: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Insert_Missing_Res_Parents');
2647:
2648: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
2649: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2650: l_debug_mode := NVL(l_debug_mode, 'Y');
2651:
2652: -- Initialize the return status to success
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3395: -- Set the error stack.
3396: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Rollup_Res_Assignment_Amounts');
3397:
3398: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3399: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3400: l_debug_mode := NVL(l_debug_mode, 'Y');
3401:
3402: -- Initialize the return status to success
3403: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3724: -- Set the error stack.
3725: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Insert_Missing_Parent_Denorm');
3726:
3727: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3728: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3729: l_debug_mode := NVL(l_debug_mode, 'Y');
3730:
3731: -- Initialize the return status to success
3732: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3976: -- Set the error stack.
3977: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Rollup_Denorm_Amounts');
3978:
3979: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
3980: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3981: l_debug_mode := NVL(l_debug_mode, 'Y');
3982:
3983: -- Initialize the return status to success
3984: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4457: -- Set the error stack.
4458: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Delete_Element');
4459:
4460: -- Get the Debug mode into local variable and set it to 'Y'if its NULL
4461: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4462: l_debug_mode := NVL(l_debug_mode, 'Y');
4463:
4464: -- Initialize the return status to success
4465: x_return_status := FND_API.G_RET_STS_SUCCESS;