1: PACKAGE BODY BIS_CUSTOM_CAUSE_EFFECT_PVT AS
2: /* $Header: BISVCECB.pls 120.0 2006/08/04 17:13:46 appldev noship $ */
3:
4: PROCEDURE Create_Custom_Cause_Effect_Rel(
5: p_commit IN VARCHAR2 := FND_API.G_FALSE
74: EXCEPTION
75: WHEN OTHERS THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: IF (x_msg_data IS NOT NULL) THEN
78: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Create_Custom_Cause_Effect_Rel ';
79: ELSE
80: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Create_Custom_Cause_Effect_Rel ';
81: END IF;
82: END Create_Custom_Cause_Effect_Rel;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: IF (x_msg_data IS NOT NULL) THEN
78: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Create_Custom_Cause_Effect_Rel ';
79: ELSE
80: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Create_Custom_Cause_Effect_Rel ';
81: END IF;
82: END Create_Custom_Cause_Effect_Rel;
83:
84: PROCEDURE Update_Custom_Cause_Effect_Rel(
152: EXCEPTION
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: IF (x_msg_data IS NOT NULL) THEN
156: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';
157: ELSE
158: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';
159: END IF;
160: END Update_Custom_Cause_Effect_Rel;
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: IF (x_msg_data IS NOT NULL) THEN
156: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';
157: ELSE
158: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Update_Custom_Cause_Effect_Rel ';
159: END IF;
160: END Update_Custom_Cause_Effect_Rel;
161:
162:
210: EXCEPTION
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
215: ELSE
216: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
217: END IF;
218:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
215: ELSE
216: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
217: END IF;
218:
219: END Delete_Custom_Cause_Effect_Rel;
220:
276: EXCEPTION
277: WHEN OTHERS THEN
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF (x_msg_data IS NOT NULL) THEN
280: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
281: ELSE
282: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
283: END IF;
284:
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF (x_msg_data IS NOT NULL) THEN
280: x_msg_data := x_msg_data||' -> BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
281: ELSE
282: x_msg_data := SQLERRM||' at BIS_CUSTOM_CAUSE_EFFECT_PVT.Delete_Custom_Cause_Effect_Rel ';
283: END IF;
284:
285: END Delete_Custom_Cause_Effect_Rel;
286:
283: END IF;
284:
285: END Delete_Custom_Cause_Effect_Rel;
286:
287: END BIS_CUSTOM_CAUSE_EFFECT_PVT;