DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_API

Line 14: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

10: g_update_num_rows_limit NUMBER := 1; -- 1000;
11: g_smart_rows_deleted NUMBER :=0; --maintains the number of rows deleted in delete smart slice api
12: g_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
13: g_deffered_mode VARCHAR2(1) :='N';
14: g_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15: Invalid_Excep Exception ;
16:
17:
18: ---------------------------------------------------------------------------

Line 469: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

465: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
466: ( p_package_name => g_package_name
467: , x_return_status => x_return_status );
468:
469: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
470:
471: IF NVL(Pa_Task_Pub1.G_CALL_PJI_ROLLUP, 'Y') = 'N' THEN
472: RETURN;
473: END IF;

Line 568: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

564: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
565: ( p_package_name => g_package_name
566: , x_return_status => x_return_status );
567:
568: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
569:
570: print_time ( 'PLAN_UPDATE_PVT begin ' );
571:
572: CLEANUP_TEMP_TABLES;

Line 593: IF (x_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR)) THEN

589: PLAN_EXTR_LINES_LOCK (
590: x_return_status => x_return_status
591: , x_msg_code => x_processing_code);
592:
593: IF (x_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR)) THEN
594: RETURN;
595: END IF;
596:
597:

Line 868: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

864: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
865: ( p_package_name => g_package_name
866: , x_return_status => x_return_status );
867:
868: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
869:
870: print_time ( 'PLAN_UPDATE_ACT_ETC begin ');
871:
872: print_time ( 'PLAN_UPDATE_ACT_ETC p_plan_wbs_ver_id ' || p_plan_wbs_ver_id || ' p_prev_pub_wbs_ver_id ' || p_prev_pub_wbs_ver_id );

Line 992: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

988: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
989: ( p_package_name => g_package_name
990: , x_return_status => x_return_status );
991:
992: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
993:
994: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC begin ' );
995:
996: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC p_plan_version_id ' || p_plan_version_id || ' p_prev_pub_version_id ' || p_prev_pub_version_id );

Line 1293: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1289: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1290: ( p_package_name => g_package_name
1291: , x_return_status => x_return_status );
1292:
1293: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1294:
1295: print_time ( ' plan copy PVT api .. 001 ' );
1296:
1297: SELECT attribute1, event_object, attribute2

Line 1543: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1539: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1540: ( p_package_name => g_package_name
1541: , x_return_status => x_return_status );
1542:
1543: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1544:
1545: print_time ( ' PLAN_BASELINE_PVT api 001 Begin event id is.. ' || p_event_id );
1546:
1547: -----------------------------------------------------------------------------------

Line 1818: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1814: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1815: ( p_package_name => g_package_name
1816: , x_return_status => x_return_status );
1817:
1818: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1819:
1820:
1821: -----------------------------------------------------------------------------------
1822: -- Get event info.

Line 2911: x_return_status := FND_API.G_RET_STS_ERROR;

2907:
2908: EXCEPTION
2909: WHEN excp_resource_busy THEN
2910:
2911: x_return_status := FND_API.G_RET_STS_ERROR;
2912:
2913: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'
2914: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
2915:

Line 2919: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);

2915:
2916: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
2917: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
2918: FND_MESSAGE.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');
2919: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);
2920:
2921: print_time ( ' wbs hdrs lock exception ' || SQLERRM);
2922:
2923: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

Line 2963: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

2959: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
2960: ( p_package_name => g_package_name
2961: , x_return_status => x_return_status );
2962:
2963: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
2964:
2965: print_time ( ' PLAN_EXTR_LINES_LOCK begin ' );
2966:
2967:

Line 2975: x_return_status := FND_API.G_RET_STS_ERROR;

2971: print_time ( ' PLAN_EXTR_LINES_LOCK end ' );
2972:
2973: EXCEPTION
2974: WHEN excp_resource_busy THEN
2975: x_return_status := FND_API.G_RET_STS_ERROR;
2976: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name ,
2977: p_procedure_name => 'PJI_EXTR_LINES_LOCK' );
2978: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'
2979: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');

Line 2984: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);

2980: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
2981: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
2982:
2983: FND_MESSAGE.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');
2984: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);
2985:
2986: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER
2987: ( p_package_name => g_package_name
2988: , p_procedure_name => 'PJI_EXTR_LINES_LOCK'

Line 3939: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

3935: p_plan_version_id => l_plan_version_id,
3936: x_msg_code => l_msg_data,
3937: x_return_status => l_return_status );
3938:
3939: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3940: x_return_status := l_return_status;
3941: IF g_debug_mode='Y' THEN
3942: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
3943: END IF;

Line 4180: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

4176: p_plan_version_id => l_plan_version_id,
4177: x_msg_code => l_msg_data,
4178: x_return_status => l_return_status );
4179:
4180: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4181: x_return_status := l_return_status;
4182: IF g_debug_mode='Y' THEN
4183: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4184: END IF;

Line 4511: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4507: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4508: x_lock_mode => l_lock_mode,
4509: x_return_status => l_return_status );
4510:
4511: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4512: x_return_status := l_return_status;
4513: x_msg_code := SQLERRM;
4514: END IF;
4515:

Line 4612: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4608: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4609: x_lock_mode => l_lock_mode,
4610: x_return_status => l_return_status );
4611:
4612: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4613: x_return_status := l_return_status;
4614: x_msg_code := SQLERRM;
4615: END IF;
4616:

Line 4731: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4727: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4728: x_lock_mode => l_lock_mode,
4729: x_return_status => l_return_status );
4730:
4731: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4732: x_return_status := l_return_status;
4733: x_msg_code := SQLERRM;
4734: END IF;
4735:

Line 4843: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4839: x_return_status => l_return_status );
4840: IF g_debug_mode='Y' THEN
4841: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
4842: end if;
4843: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4844: UPDATE pa_proj_elem_ver_structure
4845: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4846: , 'CONC_PUBLISH', 'PUE'
4847: , 'CONC_UPDATE', 'WUE', null),

Line 4872: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4868: x_return_status => l_return_status );
4869: IF g_debug_mode='Y' THEN
4870: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
4871: end if;
4872: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4873:
4874: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4875: rollback to process_proj_sum_conc;
4876: UPDATE pa_proj_elem_ver_structure

Line 5027: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

5023: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5024: x_lock_mode => l_lock_mode,
5025: x_return_status => l_return_status );
5026:
5027: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5028: x_return_status := l_return_status;
5029: x_msg_data := SQLERRM;
5030: END IF;
5031: