DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on FND_MESSAGE

Line 349: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');

345: x_fa_location_id => l_fa_location_id,
346: x_return_status => l_return_status);
347:
348: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
349: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
350: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
351: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
352: l_error_message := fnd_message.get;
353: RAISE fnd_api.g_exc_error;

Line 350: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');

346: x_return_status => l_return_status);
347:
348: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
349: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
350: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
351: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
352: l_error_message := fnd_message.get;
353: RAISE fnd_api.g_exc_error;
354: END IF;

Line 351: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);

347:
348: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
349: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
350: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
351: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
352: l_error_message := fnd_message.get;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:

Line 352: l_error_message := fnd_message.get;

348: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
349: fnd_message.set_name('CSE','CSE_FA_CREATION_ATRIB_ERROR');
350: fnd_message.set_token('ASSET_ATTRIBUTE','LOCATION');
351: fnd_message.set_token('CSI_TRANSACTION_ID',p_in_srv_pa_attr_rec.transaction_id);
352: l_error_message := fnd_message.get;
353: RAISE fnd_api.g_exc_error;
354: END IF;
355:
356: debug(' fa_location_id : '||l_fa_location_id);

Line 634: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

630: FROM csi_transactions
631: WHERE transaction_id = p_in_srv_pa_attr_rec.transaction_id;
632: EXCEPTION
633: WHEN OTHERS THEN
634: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
635: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
636: x_error_message := fnd_message.get;
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);

Line 635: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);

631: WHERE transaction_id = p_in_srv_pa_attr_rec.transaction_id;
632: EXCEPTION
633: WHEN OTHERS THEN
634: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
635: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
636: x_error_message := fnd_message.get;
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
639: END;

Line 636: x_error_message := fnd_message.get;

632: EXCEPTION
633: WHEN OTHERS THEN
634: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
635: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
636: x_error_message := fnd_message.get;
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
639: END;
640: --End Changes for Bug 7354734

Line 668: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

664: x_return_status := l_return_status;
665: x_error_message := l_error_message;
666: debug('error in interface_nl_to_pa : '||x_error_message);
667: WHEN OTHERS THEN
668: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
669: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
670: x_error_message := fnd_message.get;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);

Line 669: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);

665: x_error_message := l_error_message;
666: debug('error in interface_nl_to_pa : '||x_error_message);
667: WHEN OTHERS THEN
668: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
669: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
670: x_error_message := fnd_message.get;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
673: END interface_nl_to_pa;

Line 670: x_error_message := fnd_message.get;

666: debug('error in interface_nl_to_pa : '||x_error_message);
667: WHEN OTHERS THEN
668: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
669: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
670: x_error_message := fnd_message.get;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672: debug('Inside OTHERS in interface_nl_to_pa : ' ||x_error_message);
673: END interface_nl_to_pa;
674:

Line 697: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

693: END LOOP;
694: END IF; -- tbl.count IF
695: EXCEPTION
696: WHEN OTHERS THEN
697: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
698: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_IN_SRV_PKG.Interface_Nl_To_PA'||'='|| SQLERRM);
699: x_error_message := fnd_message.get;
700: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
701: END interface_nl_to_pa;

Line 698: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_IN_SRV_PKG.Interface_Nl_To_PA'||'='|| SQLERRM);

694: END IF; -- tbl.count IF
695: EXCEPTION
696: WHEN OTHERS THEN
697: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
698: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_IN_SRV_PKG.Interface_Nl_To_PA'||'='|| SQLERRM);
699: x_error_message := fnd_message.get;
700: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
701: END interface_nl_to_pa;
702:

Line 699: x_error_message := fnd_message.get;

695: EXCEPTION
696: WHEN OTHERS THEN
697: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
698: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_IN_SRV_PKG.Interface_Nl_To_PA'||'='|| SQLERRM);
699: x_error_message := fnd_message.get;
700: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
701: END interface_nl_to_pa;
702:
703: END cse_proj_item_in_srv_pkg;