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.4.12010000.2 2008/11/13 06:53:27 rthumma ship $ */
3:
4: g_debug_flag Varchar2(1) := NULL;
5: g_calling_context Varchar2(100) := Null;

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

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

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

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

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

1518: --x_rbs_map_reject_code_tab.delete;
1519: g_debug_context := p_calling_context;
1520:
1521: --- Initialize the error statck
1522: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');
1523:
1524: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1525: g_debug_flag := NVL(g_debug_flag, 'N');
1526:

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

1967: x_return_status := l_return_status;
1968: x_msg_count := l_msg_count;
1969: x_msg_data := l_msg_data;
1970:
1971: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';
1972: print_msg(g_debug_flag,l_stage);
1973: /* Reset the error Stack */
1974: PA_DEBUG.reset_err_stack;
1975:

Line 1988: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

1984: ,x_msg => l_stage||':'||SQLCODE||SQLERRM
1985: ,x_log_level => 5 );
1986: End If;
1987: FND_MSG_PUB.add_exc_msg
1988: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
1989: ,p_procedure_name => 'Map_Rlmi_Rbs');
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: PA_DEBUG.reset_err_stack;
1992: RAISE;

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

2061: x_return_status := 'S';
2062: x_msg_data := Null;
2063: x_msg_count := Null;
2064: --- Initialize the error statck
2065: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs');
2066:
2067: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
2068: g_debug_flag := NVL(g_debug_flag, 'N');
2069:

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

2558: x_return_status := l_return_status;
2559: x_msg_count := l_msg_count;
2560: x_msg_data := l_msg_data;
2561:
2562: l_stage := 'End Of PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API';
2563: print_msg(g_debug_flag,l_stage);
2564: /* Reset the error Stack */
2565: PA_DEBUG.reset_err_stack;
2566:

Line 2579: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

2575: ,x_msg => l_stage||':'||SQLCODE||SQLERRM
2576: ,x_log_level => 5 );
2577: End If;
2578: FND_MSG_PUB.add_exc_msg
2579: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2580: ,p_procedure_name => 'Map_Rlmi_Rbs');
2581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2582: PA_DEBUG.reset_err_stack;
2583: RAISE;

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

2666: x_msg_data := Null;
2667: x_msg_count := Null;
2668:
2669: --- Initialize the error statck
2670: PA_DEBUG.init_err_stack ('PA_RLMI_RBS_MAP_PUB.Push_RBS_Version');
2671:
2672: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
2673: g_debug_flag := NVL(g_debug_flag, 'N');
2674:

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

2745: END IF;
2746: CLOSE check_ResAsgn_Exists;
2747:
2748: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
2749: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
2750: l_return_status := 'S';
2751: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
2752: ( p_budget_version_id => i.budget_version_id
2753: ,p_resource_list_id => Null

Line 2751: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs

2747:
2748: IF nvl(l_resAsgnExistsFlag,'N') = 'Y' Then
2749: print_msg(g_debug_flag,'Calling PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs API l_resAsgnExistsFlag['||l_resAsgnExistsFlag||']',l_proc_name);
2750: l_return_status := 'S';
2751: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs
2752: ( p_budget_version_id => i.budget_version_id
2753: ,p_resource_list_id => Null
2754: ,p_rbs_version_id => p_new_rbs_version_id
2755: ,p_calling_process => 'RBS_PUSH'

Line 2862: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

2858: print_msg(g_debug_flag,l_stage||':'||'INVALID_PARAMS',l_proc_name);
2859: PA_DEBUG.WRITE_FILE('LOG',l_stage);
2860: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
2861: FND_MSG_PUB.add_exc_msg
2862: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2863: ,p_procedure_name => 'Push_RBS_Version');
2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2865: x_msg_data := 'INVALID_PARAMS';
2866: PA_DEBUG.reset_err_stack;

Line 2872: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'

2868: print_msg(g_debug_flag,l_stage||':'||SQLCODE||SQLERRM,l_proc_name);
2869: PA_DEBUG.WRITE_FILE('LOG',l_stage);
2870: PA_DEBUG.WRITE_FILE('LOG','SQLERROR:'||SQLCODE||SQLERRM);
2871: FND_MSG_PUB.add_exc_msg
2872: ( p_pkg_name => 'PA_RLMI_RBS_MAP_PUB'
2873: ,p_procedure_name => 'Push_RBS_Version');
2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2875: PA_DEBUG.reset_err_stack;
2876: RAISE;

Line 2881: END PA_RLMI_RBS_MAP_PUB ;

2877:
2878: END Push_RBS_Version;
2879:
2880:
2881: END PA_RLMI_RBS_MAP_PUB ;