DBA Data[Home] [Help]

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on FND_MESSAGE

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

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

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

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

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:

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

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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;

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

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:

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

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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;

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

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:

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

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