DBA Data[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_RLMI_RBS_MAP_PUB

Line 1: PACKAGE BODY PA_RLMI_RBS_MAP_PUB AS

1: PACKAGE BODY PA_RLMI_RBS_MAP_PUB AS
2: /* $Header: PAFPUT3B.pls 120.6.12020000.6 2013/05/30 22:49:17 sachandr ship $ */
3:
4: g_debug_flag Varchar2(1) := NULL;
5: g_calling_context Varchar2(100) := Null;

Line 127: l_module varchar2(100) := 'PA_RLMI_RBS_MAP_PUB';

123: PROCEDURE print_msg(p_debug_flag varchar2
124: ,p_msg varchar2
125: ,p_proc_name varchar2 default NULL ) IS
126:
127: l_module varchar2(100) := 'PA_RLMI_RBS_MAP_PUB';
128: BEGIN
129: --calc_log(p_msg);
130: /* Bug fix:4403327 Enclose the Push_RBS_Version calls inside the debug flag */
131: If p_debug_flag = 'Y' Then

Line 132: PA_DEBUG.WRITE(x_module => 'PA_RLMI_RBS_MAP_PUB.map_rlmi_rbs'

128: BEGIN
129: --calc_log(p_msg);
130: /* Bug fix:4403327 Enclose the Push_RBS_Version calls inside the debug flag */
131: If p_debug_flag = 'Y' Then
132: PA_DEBUG.WRITE(x_module => 'PA_RLMI_RBS_MAP_PUB.map_rlmi_rbs'
133: ,x_msg => p_msg
134: ,x_log_level => 3 );
135:
136: If p_proc_name = 'Push_RBS_Version' Then

Line 1736: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');

1732: --x_rbs_map_reject_code_tab.delete;
1733: g_debug_context := p_calling_context;
1734:
1735: --- Initialize the error statck
1736: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');
1737:
1738: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1739: g_debug_flag := NVL(g_debug_flag, 'N');
1740:

Line 2199: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';

2195: x_return_status := l_return_status;
2196: x_msg_count := l_msg_count;
2197: x_msg_data := l_msg_data;
2198:
2199: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';
2200: print_msg(g_debug_flag,l_stage);
2201: /* Reset the error Stack */
2202: PA_DEBUG.reset_err_stack;
2203:

Line 2216: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

2212: ,x_msg => l_stage||':'||SQLCODE||SQLERRM
2213: ,x_log_level => 5 );
2214: End If;
2215: FND_MSG_PUB.add_exc_msg
2216: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2217: ,p_procedure_name => 'Map_Rlmi_Rbs');
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219: PA_DEBUG.reset_err_stack;
2220: RAISE;

Line 2294: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');

2290: x_return_status := 'S';
2291: x_msg_data := Null;
2292: x_msg_count := Null;
2293: --- Initialize the error statck
2294: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');
2295:
2296: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
2297: g_debug_flag := NVL(g_debug_flag, 'N');
2298:

Line 2812: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';

2808: x_return_status := l_return_status;
2809: x_msg_count := l_msg_count;
2810: x_msg_data := l_msg_data;
2811:
2812: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';
2813: print_msg(g_debug_flag,l_stage);
2814: /* Reset the error Stack */
2815: PA_DEBUG.reset_err_stack;
2816:

Line 2829: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

2825: ,x_msg => l_stage||':'||SQLCODE||SQLERRM
2826: ,x_log_level => 5 );
2827: End If;
2828: FND_MSG_PUB.add_exc_msg
2829: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2830: ,p_procedure_name => 'Map_Rlmi_Rbs');
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832: PA_DEBUG.reset_err_stack;
2833: RAISE;

Line 2951: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Push_RBS_Version');

2947: x_msg_data := Null;
2948: x_msg_count := Null;
2949:
2950: --- Initialize the error statck
2951: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Push_RBS_Version');
2952:
2953: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
2954: g_debug_flag := NVL(g_debug_flag, 'N');
2955:

Line 3041: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);

3037: END IF;
3038: CLOSE check_ResAsgn_Exists;
3039:
3040: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
3041: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
3042: l_return_status := 'S';
3043: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
3044: ( p_budget_version_id => i.budget_version_id
3045: ,p_resource_list_id => Null

Line 3043: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs

3039:
3040: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
3041: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
3042: l_return_status := 'S';
3043: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
3044: ( p_budget_version_id => i.budget_version_id
3045: ,p_resource_list_id => Null
3046: ,p_rbs_version_id => p_new_rbs_version_id
3047: ,p_calling_process => 'RBS_PUSH'

Line 3159: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);

3155: END IF;
3156: CLOSE check_ResAsgn_Exists;
3157:
3158: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
3159: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
3160: l_return_status := 'S';
3161: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
3162: ( p_budget_version_id => i.budget_version_id
3163: ,p_resource_list_id => Null

Line 3161: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs

3157:
3158: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
3159: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
3160: l_return_status := 'S';
3161: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
3162: ( p_budget_version_id => i.budget_version_id
3163: ,p_resource_list_id => Null
3164: ,p_rbs_version_id => p_new_rbs_version_id
3165: ,p_calling_process => 'RBS_PUSH'

Line 3273: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

3269: print_msg(g_debug_flag,l_stage||':'||'INVALID_PARAMS',l_proc_name);
3270: PA_DEBUG.WRITE_FILE('LOG',l_stage);
3271: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
3272: FND_MSG_PUB.add_exc_msg
3273: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
3274: ,p_procedure_name => 'Push_RBS_Version');
3275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3276: x_msg_data := 'INVALID_PARAMS';
3277: PA_DEBUG.reset_err_stack;

Line 3283: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

3279: print_msg(g_debug_flag,l_stage||':'||SQLCODE||SQLERRM,l_proc_name);
3280: PA_DEBUG.WRITE_FILE('LOG',l_stage);
3281: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
3282: FND_MSG_PUB.add_exc_msg
3283: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
3284: ,p_procedure_name => 'Push_RBS_Version');
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: PA_DEBUG.reset_err_stack;
3287: RAISE;

Line 3292: END PA_RLMI_RBS_MAP_PUB ;

3288:
3289: END Push_RBS_Version;
3290:
3291:
3292: END PA_RLMI_RBS_MAP_PUB ;