DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on FND_API

Line 1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1772: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 1795: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1791: END IF;
1792:
1793: EXCEPTION WHEN OTHERS THEN /* Added the exception block for bug #6377425 */
1794:
1795: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1796: x_msg_count := 1;
1797: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
1798:
1799: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

Line 1853: x_return_status := FND_API.G_RET_STS_SUCCESS;

1849: l_rbs_max number; /* Added for Bug 9099240 */
1850:
1851: BEGIN
1852:
1853: x_return_status := FND_API.G_RET_STS_SUCCESS;
1854:
1855:
1856: l_process := Pji_Pjp_Sum_Main.g_process || TO_CHAR(p_worker_id);
1857: l_extraction_type := Pji_Process_Util.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 2219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2215:
2216:
2217: EXCEPTION WHEN OTHERS THEN
2218:
2219: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2220: x_msg_count := 1;
2221: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2222:
2223: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

Line 2255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2251:
2252:
2253: EXCEPTION
2254: WHEN OTHERS THEN
2255: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2256: x_msg_count := 1;
2257: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2258: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2259: ,p_procedure_name => 'map_rbs_actuals');

Line 2312: x_return_status := FND_API.G_RET_STS_SUCCESS;

2308: l_rbs_max number; /* Added for Bug 9099240 */
2309:
2310: BEGIN
2311:
2312: x_return_status := FND_API.G_RET_STS_SUCCESS;
2313:
2314:
2315: l_extraction_type := p_calling_mode ;
2316:

Line 2530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2526:
2527:
2528: EXCEPTION WHEN OTHERS THEN
2529:
2530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2531: x_msg_count := 1;
2532: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || NVL(l_msg_data, SQLERRM);
2533:
2534: -- Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'

Line 2559: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2555:
2556:
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2560: x_msg_count := 1;
2561: x_msg_data := 'pa_rbs_mapping.map_rbs_actuals.' || nvl(l_msg_data, SQLERRM);
2562: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
2563: ,p_procedure_name => 'map_rbs_actuals');

Line 2605: x_return_status := FND_API.G_RET_STS_SUCCESS;

2601: l_out number;
2602: l_tmpcnt number; -- Bug#5503706
2603: BEGIN
2604:
2605: x_return_status := FND_API.G_RET_STS_SUCCESS;
2606:
2607: IF g_debug_mode = 'Y' THEN
2608: PA_DEBUG.set_curr_function( p_function => 'map_rbs_plans'
2609: ,p_debug_mode => g_debug_mode );

Line 3206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3202: END IF;
3203:
3204: EXCEPTION
3205: WHEN OTHERS THEN
3206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3207: x_msg_count := 1;
3208: x_msg_data := 'pa_rbs_mapping.map_rbs_plans.' || nvl(l_msg_data, SQLERRM) ;
3209: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3210: ,p_procedure_name => 'map_rbs_plans');

Line 3233: x_return_status := FND_API.G_RET_STS_SUCCESS;

3229: l_resource_name VARCHAR2(240) := p_resource_name; /* bug#3656974 changed 30 to 240 */
3230: l_count NUMBER;
3231: BEGIN
3232:
3233: x_return_status := FND_API.G_RET_STS_SUCCESS;
3234:
3235: IF g_debug_mode = 'Y' THEN
3236: PA_DEBUG.set_curr_function( p_function => 'create_res_type_numeric_id'
3237: ,p_debug_mode => g_debug_mode );

Line 3293: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3289: END IF;
3290:
3291: EXCEPTION
3292: WHEN OTHERS THEN
3293: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3294: x_msg_data := 'pa_rbs_mapping.create_res_type_numeric_id.' || SQLERRM;
3295: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3296: ,p_procedure_name => 'create_res_type_numeric_id');
3297:

Line 3717: x_return_status := FND_API.G_RET_STS_SUCCESS;

3713: l_count number;
3714: l_count_tmp1 number; --Bug#5248414
3715: BEGIN
3716:
3717: x_return_status := FND_API.G_RET_STS_SUCCESS;
3718:
3719: IF g_debug_mode = 'Y' THEN
3720: PA_DEBUG.set_curr_function( p_function => 'create_mapping_rules'
3721: ,p_debug_mode => g_debug_mode );

Line 3836: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN OTHERS THEN
3836: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3837: x_msg_count := 1;
3838: x_msg_data := 'pa_rbs_mapping.create_mapping_rules.' || SQLERRM;
3839: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => 'PA_RBS_MAPPING'
3840: ,p_procedure_name => 'create_mapping_rules');