eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_PVT dependencies on OE_GLOBALS

Line 36: IF p_x_header_rec.operation <> oe_globals.g_opr_create THEN

32: END IF;
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);

Line 63: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

59:
60: -- Check security
61: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
62: AND p_control_rec.check_security
63: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
64: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
65: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
66: THEN
67:

Line 64: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE

60: -- Check security
61: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
62: AND p_control_rec.check_security
63: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
64: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
65: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
66: THEN
67:
68: IF l_debug_level > 0 THEN

Line 65: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J

61: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
62: AND p_control_rec.check_security
63: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
64: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
65: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
66: THEN
67:
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add( 'CHECK BLANKET HEADER ATTRIBUTES SECURITY', 1 ) ;

Line 108: IF p_x_header_rec.operation = oe_globals.g_opr_create THEN

104:
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

Line 123: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE

119:
120: -- Validate entity security
121: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
122: AND p_control_rec.check_security
123: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
124: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
125: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf Pack J
126: THEN
127: IF l_debug_level > 0 THEN

Line 124: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE

120: -- Validate entity security
121: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
122: AND p_control_rec.check_security
123: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
124: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
125: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf Pack J
126: THEN
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'CHECK BLANKET HEADER ENTITY SECURITY' ) ;

Line 125: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf Pack J

121: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
122: AND p_control_rec.check_security
123: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
124: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
125: OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf Pack J
126: THEN
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'CHECK BLANKET HEADER ENTITY SECURITY' ) ;
129: END IF;

Line 166: IF p_x_header_rec.operation = oe_globals.g_opr_update THEN

162:
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;

Line 173: ELSIF p_x_header_rec.operation = oe_globals.g_opr_create THEN

169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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;

Line 181: ELSIF p_x_header_rec.operation = oe_globals.g_opr_delete THEN

177: x_return_status := l_return_status;
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;

Line 199: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

195:
196: EXCEPTION
197:
198: WHEN FND_API.G_EXC_ERROR THEN
199: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
200: if l_debug_level > 0 then
201: oe_debug_pub.add('delete request1',2);
202: end if;
203: OE_Delayed_Requests_Pvt.Clear_Request

Line 215: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

211: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
212: x_return_status := FND_API.G_RET_STS_ERROR;
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
216: if l_debug_level > 0 then
217: oe_debug_pub.add('delete request1',2);
218: end if;
219: OE_Delayed_Requests_Pvt.Clear_Request

Line 231: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

227: p_x_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: WHEN OTHERS THEN
231: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
232: if l_debug_level > 0 then
233: oe_debug_pub.add('delete request1',2);
234: end if;
235: OE_Delayed_Requests_Pvt.Clear_Request

Line 279: IF l_line_rec.operation <> oe_globals.g_opr_create THEN

275: -- Query the old record if exists
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;

Line 313: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

309:
310: -- Check security attributes
311: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
312: AND p_control_rec.check_security
313: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
314: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
315: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
316: THEN
317:

Line 314: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

310: -- Check security attributes
311: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
312: AND p_control_rec.check_security
313: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
314: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
315: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
316: THEN
317:
318: IF l_debug_level > 0 THEN

Line 315: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J

311: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
312: AND p_control_rec.check_security
313: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
314: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
315: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
316: THEN
317:
318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add( 'CHECK BLANKET LINE ATTRIBUTES SECURITY' ) ;

Line 343: IF l_line_rec.operation = oe_globals.g_opr_create

339:
340: -- Default Attributes if the operation is create
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,

Line 359: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

355:
356: -- Check security attributes
357: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
358: AND p_control_rec.check_security
359: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
360: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
361: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
362: THEN
363:

Line 360: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

356: -- Check security attributes
357: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
358: AND p_control_rec.check_security
359: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
360: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
361: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
362: THEN
363:
364: IF l_debug_level > 0 THEN

Line 361: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J

357: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
358: AND p_control_rec.check_security
359: AND (l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
360: OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
361: OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
362: THEN
363:
364: IF l_debug_level > 0 THEN
365: oe_debug_pub.add( 'CHECK BLANKET LINE ENTITY SECURITY' ) ;

Line 405: IF l_line_rec.operation = oe_globals.g_opr_update THEN

401:
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;

Line 412: ELSIF l_line_rec.operation = oe_globals.g_opr_create THEN

408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
409: x_return_status := l_return_status;
410: END IF;
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);

Line 422: ELSIF l_line_rec.operation = oe_globals.g_opr_delete THEN

418: x_return_status := l_return_status;
419: END IF;
420:
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);

Line 454: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

450:
451: EXCEPTION
452:
453: WHEN FND_API.G_EXC_ERROR THEN
454: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
455: if l_debug_level > 0 then
456: oe_debug_pub.add('delete request1',2);
457: end if;
458: OE_Delayed_Requests_Pvt.Clear_Request

Line 471: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

467: x_return_status := FND_API.G_RET_STS_ERROR;
468:
469:
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
472: if l_debug_level > 0 then
473: oe_debug_pub.add('delete request1',2);
474: end if;
475: OE_Delayed_Requests_Pvt.Clear_Request

Line 488: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485:
486:
487: WHEN OTHERS THEN
488: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
489: if l_debug_level > 0 then
490: oe_debug_pub.add('delete request1',2);
491: end if;
492: OE_Delayed_Requests_Pvt.Clear_Request

Line 610: IF l_line_tbl(I).operation = oe_globals.g_opr_create AND

606: I := l_line_tbl.first;
607:
608: While I is not null
609: Loop
610: IF l_line_tbl(I).operation = oe_globals.g_opr_create AND
611: l_line_tbl(I).header_id IS NULL THEN
612: l_line_tbl(I).header_id := l_header_rec.header_id;
613: END IF;
614: