DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on FND_API

Line 1675: x_return_status := FND_API.G_RET_STS_SUCCESS;

1671: l number; --added for bug#4101364
1672:
1673: BEGIN
1674:
1675: x_return_status := FND_API.G_RET_STS_SUCCESS;
1676:
1677: IF g_debug_mode = 'Y' THEN
1678: PA_DEBUG.set_curr_function( p_function => 'map_rbs_txn'
1679: ,p_debug_mode => g_debug_mode );

Line 1769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1765:
1766: process_top_rule(p_rbs_struct_version_id,l_res_class_id(j));
1767:
1768: ELSE --no rules are present
1769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1770: x_msg_count := 1;
1771: x_msg_data := 'Rules for RBS version is missing';
1772: raise no_rule_excp;
1773: END IF;

Line 1785: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1781: END IF;
1782:
1783: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */
1784:
1785: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1786: x_msg_count := 1;
1787: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
1788:
1789: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

Line 1841: x_return_status := FND_API.G_RET_STS_SUCCESS;

1837: --AECOM Change END
1838:
1839: BEGIN
1840:
1841: x_return_status := FND_API.G_RET_STS_SUCCESS;
1842:
1843:
1844: l_process := Pji_Pjp_Sum_Main.g_process || TO_CHAR(p_worker_id);
1845: l_extraction_type := Pji_Process_Util.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 2190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2186:
2187:
2188: EXCEPTION WHEN OTHERS THEN
2189:
2190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2191: x_msg_count := 1;
2192: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2193:
2194: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

Line 2226: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2222:
2223:
2224: EXCEPTION
2225: WHEN OTHERS THEN
2226: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2227: x_msg_count := 1;
2228: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2229: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2230: ,p_procedure_name => 'map_rbs_actuals');

Line 2270: x_return_status := FND_API.G_RET_STS_SUCCESS;

2266: l_out number;
2267: l_tmpcnt number; -- Bug#5503706
2268: BEGIN
2269:
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271:
2272: IF g_debug_mode = 'Y' THEN
2273: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2274: ,p_debug_mode => g_debug_mode );

Line 2871: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2867: END IF;
2868:
2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2872: x_msg_count := 1;
2873: x_msg_data := 'pa_rbs_mapping.map_rbs_plans.' || nvl(l_msg_data, SQLERRM) ;
2874: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2875: ,p_procedure_name => 'map_rbs_plans');

Line 2898: x_return_status := FND_API.G_RET_STS_SUCCESS;

2894: l_resource_name VARCHAR2(240) := p_resource_name; /* bug#3656974 changed 30 to 240 */
2895: l_count NUMBER;
2896: BEGIN
2897:
2898: x_return_status := FND_API.G_RET_STS_SUCCESS;
2899:
2900: IF g_debug_mode = 'Y' THEN
2901: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
2902: ,p_debug_mode => g_debug_mode );

Line 2958: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2954: END IF;
2955:
2956: EXCEPTION
2957: WHEN OTHERS THEN
2958: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2959: x_msg_data := 'pa_rbs_mapping.create_res_type_numeric_id.' || SQLERRM;
2960: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2961: ,p_procedure_name => 'create_res_type_numeric_id');
2962:

Line 3380: x_return_status := FND_API.G_RET_STS_SUCCESS;

3376: l_count number;
3377: l_count_tmp1 number; --Bug#5248414
3378: BEGIN
3379:
3380: x_return_status := FND_API.G_RET_STS_SUCCESS;
3381:
3382: IF g_debug_mode = 'Y' THEN
3383: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3384: ,p_debug_mode => g_debug_mode );

Line 3499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3495: END IF;
3496:
3497: EXCEPTION
3498: WHEN OTHERS THEN
3499: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3500: x_msg_count := 1;
3501: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3502: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3503: ,p_procedure_name => 'create_mapping_rules');