DBA Data[Home] [Help]

APPS.OE_BLANKET_PVT dependencies on OE_BLANKET_UTIL

Line 37: oe_blanket_util.query_header( p_header_id =>

33:
34: -- Query Old Record
35:
36: IF p_x_header_rec.operation <> oe_globals.g_opr_create THEN
37: oe_blanket_util.query_header( p_header_id =>
38: p_x_header_rec.header_id,
39: x_header_rec => p_x_old_header_rec,
40: x_return_status => l_return_status);
41: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 96: oe_blanket_util.validate_attributes( p_x_header_Rec => p_x_header_rec,

92:
93:
94: IF p_control_rec.validate_attributes THEN
95: oe_debug_pub.add( ' Validate Blanket Attribute ' ,1);
96: oe_blanket_util.validate_attributes( p_x_header_Rec => p_x_header_rec,
97: p_old_header_rec => l_old_header_rec,
98: p_validation_level => p_validation_level,
99: x_return_status => l_return_status);
100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 109: oe_blanket_util.default_attributes (

105:
106: -- Default Attributes if the operation is create
107:
108: IF p_x_header_rec.operation = oe_globals.g_opr_create THEN
109: oe_blanket_util.default_attributes (
110: p_x_header_Rec => p_x_header_rec,
111: x_return_status => l_return_status);
112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
113: x_return_status := l_return_status;

Line 152: oe_blanket_util.Validate_entity ( p_header_rec => p_x_header_rec,

148:
149: -- Validate entity and check required fields
150:
151: IF p_control_rec.validate_entity THEN
152: oe_blanket_util.Validate_entity ( p_header_rec => p_x_header_rec,
153: p_old_header_rec => l_old_header_rec,
154: x_return_status => l_return_status);
155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: x_return_status := l_return_status;

Line 167: oe_blanket_util.update_row (p_header_rec => p_x_header_rec,

163: IF p_control_rec.write_to_db AND
164: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
165:
166: IF p_x_header_rec.operation = oe_globals.g_opr_update THEN
167: oe_blanket_util.update_row (p_header_rec => p_x_header_rec,
168: x_return_status => l_return_status);
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: x_return_status := l_return_status;
171: END IF;

Line 174: oe_blanket_util.insert_row (p_header_rec => p_x_header_rec,

170: x_return_status := l_return_status;
171: END IF;
172:
173: ELSIF p_x_header_rec.operation = oe_globals.g_opr_create THEN
174: oe_blanket_util.insert_row (p_header_rec => p_x_header_rec,
175: x_return_status => l_return_status);
176: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
177: x_return_status := l_return_status;
178: END IF;

Line 182: oe_blanket_util.delete_row (p_header_id => p_x_header_rec.header_id,

178: END IF;
179:
180: -- hashraf start of pack J
181: ELSIF p_x_header_rec.operation = oe_globals.g_opr_delete THEN
182: oe_blanket_util.delete_row (p_header_id => p_x_header_rec.header_id,
183: x_return_status => l_return_status);
184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: x_return_status := l_return_status;
186: END IF;

Line 280: l_old_line_rec :=oe_blanket_util.query_row(p_line_id =>

276:
277: l_line_rec := p_x_line_tbl(I);
278:
279: IF l_line_rec.operation <> oe_globals.g_opr_create THEN
280: l_old_line_rec :=oe_blanket_util.query_row(p_line_id =>
281: l_line_rec.line_id );
282: p_x_old_line_tbl(I) := l_old_line_rec;
283: END IF;
284:

Line 301: oe_blanket_util.validate_attributes( p_x_line_Rec => l_line_rec,

297:
298: -- Validate user passed attributes
299:
300: IF p_control_rec.validate_attributes THEN
301: oe_blanket_util.validate_attributes( p_x_line_Rec => l_line_rec,
302: p_old_line_rec => l_old_line_rec,
303: p_validation_level => p_validation_level,
304: x_return_status => l_return_status);
305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 345: oe_blanket_util.default_attributes (

341:
342:
343: IF l_line_rec.operation = oe_globals.g_opr_create
344: THEN
345: oe_blanket_util.default_attributes (
346: p_x_line_rec => l_line_rec,
347: p_default_from_header => p_control_rec.default_from_header,
348: x_return_status => l_return_status);
349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 390: oe_blanket_util.Validate_entity ( p_line_rec => l_line_rec,

386:
387:
388: IF p_control_rec.validate_entity THEN
389:
390: oe_blanket_util.Validate_entity ( p_line_rec => l_line_rec,
391: p_old_line_rec => l_old_line_rec,
392: x_return_status => l_return_status);
393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
394: x_return_status := l_return_status;

Line 406: oe_blanket_util.update_row (p_line_rec => l_line_rec,

402: IF p_control_rec.write_to_db AND
403: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
404:
405: IF l_line_rec.operation = oe_globals.g_opr_update THEN
406: oe_blanket_util.update_row (p_line_rec => l_line_rec,
407: x_return_status => l_return_status);
408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
409: x_return_status := l_return_status;
410: END IF;

Line 415: oe_blanket_util.insert_row (p_line_rec => l_line_rec,

411:
412: ELSIF l_line_rec.operation = oe_globals.g_opr_create THEN
413:
414:
415: oe_blanket_util.insert_row (p_line_rec => l_line_rec,
416: x_return_status => l_return_status);
417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
418: x_return_status := l_return_status;
419: END IF;

Line 425: oe_blanket_util.delete_row (p_line_id => l_line_rec.line_id,

421: -- hashraf start of Pack J
422: ELSIF l_line_rec.operation = oe_globals.g_opr_delete THEN
423:
424:
425: oe_blanket_util.delete_row (p_line_id => l_line_rec.line_id,
426: x_return_status => l_return_status);
427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
428: x_return_status := l_return_status;
429: END IF;

Line 642: oe_blanket_util.Process_Object( x_return_status => l_return_status);

638: x_line_tbl := l_line_tbl;
639:
640: -- Process Object level requests
641:
642: oe_blanket_util.Process_Object( x_return_status => l_return_status);
643:
644: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
646: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN