DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_API

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

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

Line 620: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

616: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
617: ( p_package_name => g_package_name
618: , x_return_status => x_return_status );
619:
620: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
621:
622: IF NVL(Pa_Task_Pub1.G_CALL_PJI_ROLLUP, 'Y') = 'N' THEN
623: RETURN;
624: END IF;

Line 846: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

842: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
843: ( p_package_name => g_package_name
844: , x_return_status => x_return_status );
845:
846: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
847:
848: print_time ( 'PLAN_UPDATE_PVT begin ' );
849:
850: CLEANUP_TEMP_TABLES;

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

867: PLAN_EXTR_LINES_LOCK (
868: x_return_status => x_return_status
869: , x_msg_code => x_processing_code);
870:
871: IF (x_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR)) THEN
872: RETURN;
873: END IF;
874:
875:

Line 1146: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

1142: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1143: ( p_package_name => g_package_name
1144: , x_return_status => x_return_status );
1145:
1146: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
1147:
1148: print_time ( 'PLAN_UPDATE_ACT_ETC begin ');
1149:
1150: 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 1270: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1266: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1267: ( p_package_name => g_package_name
1268: , x_return_status => x_return_status );
1269:
1270: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1271:
1272: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC begin ' );
1273:
1274: 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 1623: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1619: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1620: ( p_package_name => g_package_name
1621: , x_return_status => x_return_status );
1622:
1623: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1624:
1625: print_time ( ' plan copy PVT api .. 001 ' );
1626:
1627: SELECT attribute1, event_object, attribute2

Line 1919: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

1915: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
1916: ( p_package_name => g_package_name
1917: , x_return_status => x_return_status );
1918:
1919: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
1920:
1921: print_time ( ' PLAN_BASELINE_PVT api 001 Begin event id is.. ' || p_event_id );
1922:
1923: -----------------------------------------------------------------------------------

Line 2194: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;

2190: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
2191: ( p_package_name => g_package_name
2192: , x_return_status => x_return_status );
2193:
2194: x_processing_code := Fnd_Api.G_RET_STS_SUCCESS;
2195:
2196:
2197: -----------------------------------------------------------------------------------
2198: -- Get event info.

Line 3287: x_return_status := FND_API.G_RET_STS_ERROR;

3283:
3284: EXCEPTION
3285: WHEN excp_resource_busy THEN
3286:
3287: x_return_status := FND_API.G_RET_STS_ERROR;
3288:
3289: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'
3290: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
3291:

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

3291:
3292: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
3293: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
3294: FND_MESSAGE.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');
3295: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);
3296:
3297: print_time ( ' wbs hdrs lock exception ' || SQLERRM);
3298:
3299: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER

Line 3339: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;

3335: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK
3336: ( p_package_name => g_package_name
3337: , x_return_status => x_return_status );
3338:
3339: x_msg_code := Fnd_Api.G_RET_STS_SUCCESS;
3340:
3341: print_time ( ' PLAN_EXTR_LINES_LOCK begin ' );
3342:
3343:

Line 3351: x_return_status := FND_API.G_RET_STS_ERROR;

3347: print_time ( ' PLAN_EXTR_LINES_LOCK end ' );
3348:
3349: EXCEPTION
3350: WHEN excp_resource_busy THEN
3351: x_return_status := FND_API.G_RET_STS_ERROR;
3352: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name ,
3353: p_procedure_name => 'PJI_EXTR_LINES_LOCK' );
3354: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'
3355: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');

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

3356: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
3357: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
3358:
3359: FND_MESSAGE.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');
3360: Fnd_Msg_Pub.add_detail(p_message_type=>FND_API.G_RET_STS_ERROR);
3361:
3362: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER
3363: ( p_package_name => g_package_name
3364: , p_procedure_name => 'PJI_EXTR_LINES_LOCK'

Line 4315: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

4311: p_plan_version_id => l_plan_version_id,
4312: x_msg_code => l_msg_data,
4313: x_return_status => l_return_status );
4314:
4315: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4316: x_return_status := l_return_status;
4317: IF g_debug_mode='Y' THEN
4318: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4319: END IF;

Line 4557: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

4553: p_plan_version_id => l_plan_version_id,
4554: x_msg_code => l_msg_data,
4555: x_return_status => l_return_status );
4556:
4557: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
4558: x_return_status := l_return_status;
4559: IF g_debug_mode='Y' THEN
4560: Pji_Utils.write2log('WBS Maint Pvt:' || 'Failure in plan_update call');
4561: END IF;

Line 4889: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4885: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4886: x_lock_mode => l_lock_mode,
4887: x_return_status => l_return_status );
4888:
4889: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4890: x_return_status := l_return_status;
4891: x_msg_code := SQLERRM;
4892: END IF;
4893:

Line 4990: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

4986: p_request_id => Fnd_Global.CONC_REQUEST_ID,
4987: x_lock_mode => l_lock_mode,
4988: x_return_status => l_return_status );
4989:
4990: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4991: x_return_status := l_return_status;
4992: x_msg_code := SQLERRM;
4993: END IF;
4994:

Line 5109: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

5105: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5106: x_lock_mode => l_lock_mode,
5107: x_return_status => l_return_status );
5108:
5109: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5110: x_return_status := l_return_status;
5111: x_msg_code := SQLERRM;
5112: END IF;
5113:

Line 5221: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

5217: x_return_status => l_return_status );
5218: IF g_debug_mode='Y' THEN
5219: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
5220: end if;
5221: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5222: UPDATE pa_proj_elem_ver_structure
5223: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5224: , 'CONC_PUBLISH', 'PUE'
5225: , 'CONC_UPDATE', 'WUE', null),

Line 5250: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

5246: x_return_status => l_return_status );
5247: IF g_debug_mode='Y' THEN
5248: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_MAINT_PVT: l_return_status '||l_return_status ,null,3);
5249: end if;
5250: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5251:
5252: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5253: rollback to process_proj_sum_conc;
5254: UPDATE pa_proj_elem_ver_structure

Line 5405: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

5401: p_request_id => Fnd_Global.CONC_REQUEST_ID,
5402: x_lock_mode => l_lock_mode,
5403: x_return_status => l_return_status );
5404:
5405: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5406: x_return_status := l_return_status;
5407: x_msg_data := SQLERRM;
5408: END IF;
5409: