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:
3292: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
3293: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
3290: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
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:
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');
3356: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
3357: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
3358:
3355: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
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
4351: end if;
4352:
4353: if l_chd_dev_status ='ERROR' THEN
4354: l_return_status:='E';
4355: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4356: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4357: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4358:
4359: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4352:
4353: if l_chd_dev_status ='ERROR' THEN
4354: l_return_status:='E';
4355: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4356: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4357: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4358:
4359: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4360: p_procedure_name => 'WBS_MAINT_PVT',
4353: if l_chd_dev_status ='ERROR' THEN
4354: l_return_status:='E';
4355: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4356: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4357: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4358:
4359: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4360: p_procedure_name => 'WBS_MAINT_PVT',
4361: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4357: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4358:
4359: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4360: p_procedure_name => 'WBS_MAINT_PVT',
4361: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4362:
4363: IF g_debug_mode='Y' THEN null;
4364: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4365: end if;
4360: p_procedure_name => 'WBS_MAINT_PVT',
4361: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4362:
4363: IF g_debug_mode='Y' THEN null;
4364: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4365: end if;
4366: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4367: l_return_status:='E';
4368: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4364: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4365: end if;
4366: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4367: l_return_status:='E';
4368: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4369: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4370: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4365: end if;
4366: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4367: l_return_status:='E';
4368: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4369: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4370: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4366: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4367: l_return_status:='E';
4368: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4369: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4370: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4374: IF g_debug_mode='Y' THEN null;
4369: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4370: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4374: IF g_debug_mode='Y' THEN null;
4375: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4376: end if;
4377:
4371: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4372: p_procedure_name => 'WBS_MAINT_PVT',
4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4374: IF g_debug_mode='Y' THEN null;
4375: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4376: end if;
4377:
4378: end if;
4379: END IF; -- Bug 5999999
4593:
4594: end if;
4595: if l_chd_dev_status ='ERROR' THEN
4596: l_return_status:='E';
4597: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4598: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4599: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4600:
4601: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4594: end if;
4595: if l_chd_dev_status ='ERROR' THEN
4596: l_return_status:='E';
4597: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4598: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4599: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4600:
4601: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4602: p_procedure_name => 'WBS_MAINT_PVT',
4595: if l_chd_dev_status ='ERROR' THEN
4596: l_return_status:='E';
4597: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4598: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4599: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4600:
4601: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4602: p_procedure_name => 'WBS_MAINT_PVT',
4603: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4599: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4600:
4601: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4602: p_procedure_name => 'WBS_MAINT_PVT',
4603: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4604:
4605: IF g_debug_mode='Y' THEN null;
4606: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4607: end if;
4602: p_procedure_name => 'WBS_MAINT_PVT',
4603: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4604:
4605: IF g_debug_mode='Y' THEN null;
4606: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4607: end if;
4608: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4609: l_return_status:='E';
4610: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4606: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4607: end if;
4608: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4609: l_return_status:='E';
4610: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4611: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4612: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4607: end if;
4608: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4609: l_return_status:='E';
4610: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4611: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4612: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4608: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4609: l_return_status:='E';
4610: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4611: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4612: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4616: IF g_debug_mode='Y' THEN null;
4611: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4612: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4616: IF g_debug_mode='Y' THEN null;
4617: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4618: end if;
4619:
4613: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4614: p_procedure_name => 'WBS_MAINT_PVT',
4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4616: IF g_debug_mode='Y' THEN null;
4617: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4618: end if;
4619:
4620: end if;
4621: END IF ; --Bug 5999999