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:
2916: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
2917: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
2914: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
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:
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');
2980: -- PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PJI'
2981: -- , p_msg_name => 'PJI_LOCK_NOT_OBTAINED');
2982:
2979: , NAMEIN => 'PJI_LOCK_NOT_OBTAINED');
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
3974: end if;
3975:
3976: if l_chd_dev_status ='ERROR' THEN
3977: l_return_status:='E';
3978: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3979: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3980: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
3981:
3982: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3975:
3976: if l_chd_dev_status ='ERROR' THEN
3977: l_return_status:='E';
3978: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3979: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3980: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
3981:
3982: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3983: p_procedure_name => 'WBS_MAINT_PVT',
3976: if l_chd_dev_status ='ERROR' THEN
3977: l_return_status:='E';
3978: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3979: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3980: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
3981:
3982: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3983: p_procedure_name => 'WBS_MAINT_PVT',
3984: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3980: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
3981:
3982: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3983: p_procedure_name => 'WBS_MAINT_PVT',
3984: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3985:
3986: IF g_debug_mode='Y' THEN null;
3987: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3988: end if;
3983: p_procedure_name => 'WBS_MAINT_PVT',
3984: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3985:
3986: IF g_debug_mode='Y' THEN null;
3987: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3988: end if;
3989: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
3990: l_return_status:='E';
3991: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3987: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3988: end if;
3989: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
3990: l_return_status:='E';
3991: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3992: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3993: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3988: end if;
3989: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
3990: l_return_status:='E';
3991: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3992: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3993: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3996: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3989: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
3990: l_return_status:='E';
3991: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
3992: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3993: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3996: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3997: IF g_debug_mode='Y' THEN null;
3992: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
3993: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3996: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3997: IF g_debug_mode='Y' THEN null;
3998: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3999: end if;
4000:
3994: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
3995: p_procedure_name => 'WBS_MAINT_PVT',
3996: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
3997: IF g_debug_mode='Y' THEN null;
3998: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
3999: end if;
4000:
4001: end if;
4002: END IF; -- Bug 5999999
4215:
4216: end if;
4217: if l_chd_dev_status ='ERROR' THEN
4218: l_return_status:='E';
4219: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4220: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4221: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4222:
4223: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4216: end if;
4217: if l_chd_dev_status ='ERROR' THEN
4218: l_return_status:='E';
4219: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4220: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4221: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4222:
4223: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4224: p_procedure_name => 'WBS_MAINT_PVT',
4217: if l_chd_dev_status ='ERROR' THEN
4218: l_return_status:='E';
4219: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4220: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4221: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4222:
4223: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4224: p_procedure_name => 'WBS_MAINT_PVT',
4225: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4221: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text
4222:
4223: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4224: p_procedure_name => 'WBS_MAINT_PVT',
4225: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4226:
4227: IF g_debug_mode='Y' THEN null;
4228: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4229: end if;
4224: p_procedure_name => 'WBS_MAINT_PVT',
4225: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4226:
4227: IF g_debug_mode='Y' THEN null;
4228: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4229: end if;
4230: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4231: l_return_status:='E';
4232: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4228: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4229: end if;
4230: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4231: l_return_status:='E';
4232: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4233: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4234: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4229: end if;
4230: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4231: l_return_status:='E';
4232: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4233: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4234: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4237: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4230: elsif l_chd_dev_status in ('CANCELLED','TERMINATED','DELETED') THEN
4231: l_return_status:='E';
4232: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');
4233: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4234: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4237: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4238: IF g_debug_mode='Y' THEN null;
4233: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);
4234: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4237: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4238: IF g_debug_mode='Y' THEN null;
4239: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4240: end if;
4241:
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => g_package_name,
4236: p_procedure_name => 'WBS_MAINT_PVT',
4237: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));
4238: IF g_debug_mode='Y' THEN null;
4239: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));
4240: end if;
4241:
4242: end if;
4243: END IF ; --Bug 5999999