DBA Data[Home] [Help]

APPS.OE_REASONS_UTIL dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: --
33: l_version_number NUMBER := p_version_number;
34: BEGIN
35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: IF p_header_id IS NULL THEN
39: IF p_entity_code = 'HEADER' THEN
40: l_header_id := p_entity_id;

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: ELSIF p_entity_code = 'BLANKET_LINE' THEN
53: SELECT header_id INTO l_header_id
54: FROM oe_blanket_lines_all WHERE line_id = p_entity_id;
55: ELSE
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: END IF;
58: ELSE
59: l_header_id := p_header_id;
60: END IF;

Line 75: RAISE FND_API.G_EXC_ERROR;

71: IF l_debug_level > 0 THEN
72: oe_debug_pub.add('Reason_Code is NULL ',1);
73: END IF;
74:
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: */
78: IF p_reason_type IS NULL THEN
79: IF l_debug_level > 0 THEN

Line 83: RAISE FND_API.G_EXC_ERROR;

79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add('Reason_Type is NULL ',1);
81: END IF;
82:
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:
86: IF l_version_number IS NULL THEN
87: IF l_debug_level > 0 THEN

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: END IF;
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130:
131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
132: OE_MSG_PUB.Add_Exc_Msg
133: ( G_PKG_NAME

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: , 'Apply_Reason'
135: );
136: END IF;
137:
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END Apply_Reason;
140:
141: Procedure Get_Reason(
142: p_reason_id IN NUMBER DEFAULT NULL,

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: END IF;
172:
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: WHEN OTHERS THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178:
179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: WHEN OTHERS THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178:
179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
180: OE_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

182: , 'Get_Reason'
183: );
184: END IF;
185:
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END Get_Reason;
188:
189: END OE_Reasons_Util;