DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_MESSAGE

Line 3289: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'

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');

Line 3294: FND_MESSAGE.SET_NAME('PJI', '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:

Line 3354: x_msg_code := FND_MESSAGE.GET_STRING( APPIN => 'PJI'

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:

Line 3359: FND_MESSAGE.SET_NAME('PJI', 'PJI_LOCK_NOT_OBTAINED');

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

Line 4355: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

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,

Line 4356: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);

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',

Line 4357: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text

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));

Line 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;

Line 4364: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

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');

Line 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',

Line 4369: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);

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));

Line 4370: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);

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;

Line 4373: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));

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:

Line 4375: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

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

Line 4597: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUMM_ERR');

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,

Line 4598: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);

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',

Line 4599: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_message); --bug#5524224, passed completion text

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));

Line 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;

Line 4606: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

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');

Line 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',

Line 4611: FND_MESSAGE.SET_TOKEN ('REQUEST_ID', l_request_id);

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));

Line 4612: FND_MESSAGE.SET_TOKEN ('SQLERRM', l_chd_status);

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;

Line 4615: p_error_text => SUBSTRB(FND_MESSAGE.GET,1,240));

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:

Line 4617: Pji_Utils.write2log(SUBSTRB(FND_MESSAGE.GET,1,240));

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