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_OE_HTML_HEADER dependencies on FND_API

Line 132: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE

128:
129: -- Call Oe_Order_Pvt.Header
130:
131: Oe_Order_Pvt.Header
132: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
133: , p_init_msg_list => FND_API.G_TRUE
134: , p_control_rec =>l_control_rec
135: , p_x_header_rec =>x_header_rec
136: , p_x_old_header_rec =>l_old_header_rec

Line 133: , p_init_msg_list => FND_API.G_TRUE

129: -- Call Oe_Order_Pvt.Header
130:
131: Oe_Order_Pvt.Header
132: ( p_validation_level =>FND_API.G_VALID_LEVEL_NONE
133: , p_init_msg_list => FND_API.G_TRUE
134: , p_control_rec =>l_control_rec
135: , p_x_header_rec =>x_header_rec
136: , p_x_old_header_rec =>l_old_header_rec
137: , x_return_status =>l_return_status

Line 141: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

137: , x_return_status =>l_return_status
138:
139: );
140:
141: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138:
139: );
140:
141: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:

Line 143: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

139: );
140:
141: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147:

Line 144: RAISE FND_API.G_EXC_ERROR;

140:
141: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147:
148: -- Load OUT parameters.

Line 157: x_header_rec.db_flag := FND_API.G_FALSE;

153:
154: -- Write to cache.
155: -- Set db_flag to False before writing to cache
156:
157: x_header_rec.db_flag := FND_API.G_FALSE;
158:
159: -- Re-set the UI flag to FALSE
160: OE_GLOBALS.G_UI_FLAG := FALSE;
161:

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: OE_GLOBALS.G_UI_FLAG := FALSE;
161:
162: -- Set return status.
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: -- Get message count and data
167:
168: OE_MSG_PUB.Count_And_Get

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.DEFAULT_ATTRIBUTES', 1);
174:
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178:
179: OE_GLOBALS.G_UI_FLAG := FALSE;
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: WHEN FND_API.G_EXC_ERROR THEN
178:
179: OE_GLOBALS.G_UI_FLAG := FALSE;
180:
181: x_return_status := FND_API.G_RET_STS_ERROR;
182:
183: -- Get message count and data
184:
185: OE_MSG_PUB.Count_And_Get

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: ( p_count => x_msg_count
187: , p_data => x_msg_data
188: );
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191:
192: OE_GLOBALS.G_UI_FLAG := FALSE;
193:
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191:
192: OE_GLOBALS.G_UI_FLAG := FALSE;
193:
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195:
196: -- Get message count and data
197:
198: OE_MSG_PUB.Count_And_Get

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

203: WHEN OTHERS THEN
204:
205: OE_GLOBALS.G_UI_FLAG := FALSE;
206:
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208:
209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
210: THEN
211: OE_MSG_PUB.Add_Exc_Msg

Line 273: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN

269: l_control_rec.clear_api_requests := FALSE;
270:
271: -- Set Operation.
272:
273: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN
274: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
275: ELSE
276: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
277: END IF;

Line 284: p_validation_level => FND_API.G_VALID_LEVEL_NONE

280: -- Call Oe_Order_Pvt.Header
281:
282: Oe_Order_Pvt.Header
283: (
284: p_validation_level => FND_API.G_VALID_LEVEL_NONE
285: , p_init_msg_list => FND_API.G_TRUE
286: , p_control_rec => l_control_rec
287: , p_x_header_rec => x_header_rec
288: , p_x_old_header_rec => x_old_header_rec

Line 285: , p_init_msg_list => FND_API.G_TRUE

281:
282: Oe_Order_Pvt.Header
283: (
284: p_validation_level => FND_API.G_VALID_LEVEL_NONE
285: , p_init_msg_list => FND_API.G_TRUE
286: , p_control_rec => l_control_rec
287: , p_x_header_rec => x_header_rec
288: , p_x_old_header_rec => x_old_header_rec
289: , x_return_status => l_return_status

Line 294: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

290: );
291: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
292: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
293:
294: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
292: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
293:
294: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:

Line 296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

292: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
293:
294: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300:

Line 297: RAISE FND_API.G_EXC_ERROR;

293:
294: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300:
301: -- Init OUT parameters to missing.

Line 320: x_return_status := FND_API.G_RET_STS_SUCCESS;

316: OE_GLOBALS.G_UI_FLAG := FALSE;
317:
318: -- Set return status.
319:
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321:
322: -- Get message count and data
323:
324: OE_MSG_PUB.Count_And_Get

Line 333: WHEN FND_API.G_EXC_ERROR THEN

329: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.CHANGE_ATTRIBUTES', 1);
330:
331: EXCEPTION
332:
333: WHEN FND_API.G_EXC_ERROR THEN
334:
335: OE_GLOBALS.G_UI_FLAG := FALSE;
336:
337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

333: WHEN FND_API.G_EXC_ERROR THEN
334:
335: OE_GLOBALS.G_UI_FLAG := FALSE;
336:
337: x_return_status := FND_API.G_RET_STS_ERROR;
338:
339: -- Get message count and data
340:
341: OE_MSG_PUB.Count_And_Get

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: ( p_count => x_msg_count
343: , p_data => x_msg_data
344: );
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347:
348: OE_GLOBALS.G_UI_FLAG := FALSE;
349:
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347:
348: OE_GLOBALS.G_UI_FLAG := FALSE;
349:
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351:
352: -- Get message count and data
353:
354: OE_MSG_PUB.Count_And_Get

Line 363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

359: WHEN OTHERS THEN
360:
361: OE_GLOBALS.G_UI_FLAG := FALSE;
362:
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
364:
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg

Line 439: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN

435:
436:
437: -- Set Operation.
438:
439: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN
440: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
441: ELSE
442: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
443: END IF;

Line 449: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

445:
446: -- Call Oe_Order_Pvt.Header
447:
448: Oe_Order_Pvt.Header
449: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
450: , p_init_msg_list => FND_API.G_TRUE
451: , p_control_rec => l_control_rec
452: , p_x_header_rec => x_header_rec
453: , p_x_old_header_rec => x_old_header_rec

Line 450: , p_init_msg_list => FND_API.G_TRUE

446: -- Call Oe_Order_Pvt.Header
447:
448: Oe_Order_Pvt.Header
449: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
450: , p_init_msg_list => FND_API.G_TRUE
451: , p_control_rec => l_control_rec
452: , p_x_header_rec => x_header_rec
453: , p_x_old_header_rec => x_old_header_rec
454: , x_return_status => l_return_status

Line 458: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

454: , x_return_status => l_return_status
455: );
456:
457:
458: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: );
456:
457:
458: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463:

Line 460: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

456:
457:
458: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463:
464: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Save_Header- First PO Call'||

Line 461: RAISE FND_API.G_EXC_ERROR;

457:
458: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463:
464: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Save_Header- First PO Call'||
465: l_return_status, 1);

Line 492: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN

488:
489:
490: -- Set Operation.
491:
492: IF FND_API.To_Boolean(x_header_rec.db_flag) THEN
493: x_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
494: OE_Header_Util.Query_Row
495: ( p_header_id => x_header_rec.header_id
496: , x_header_rec => l_x_old_header_rec

Line 508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

504:
505: oe_debug_pub.add('Entering Oe_Oe_Html_Header.Save_Header-Second Call', 1);
506:
507: Oe_Order_Pvt.Header
508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
509: , p_init_msg_list => FND_API.G_FALSE
510: , p_control_rec => l_control_rec
511: , p_x_header_rec => x_header_rec
512: , p_x_old_header_rec => l_x_old_header_rec

Line 509: , p_init_msg_list => FND_API.G_FALSE

505: oe_debug_pub.add('Entering Oe_Oe_Html_Header.Save_Header-Second Call', 1);
506:
507: Oe_Order_Pvt.Header
508: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
509: , p_init_msg_list => FND_API.G_FALSE
510: , p_control_rec => l_control_rec
511: , p_x_header_rec => x_header_rec
512: , p_x_old_header_rec => l_x_old_header_rec
513: , x_return_status => l_return_status

Line 517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

513: , x_return_status => l_return_status
514: );
515:
516:
517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514: );
515:
516:
517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:

Line 519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

515:
516:
517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: IF p_process THEN

Line 520: RAISE FND_API.G_EXC_ERROR;

516:
517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: IF p_process THEN
524: Process_Object

Line 531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

527: , x_msg_data => x_msg_data
528: , x_cascade_flag => l_cascade_flag
529: );
530:
531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: , x_cascade_flag => l_cascade_flag
529: );
530:
531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: END IF;

Line 533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

529: );
530:
531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: END IF;
537: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Save_Header-After Second PO'||

Line 534: RAISE FND_API.G_EXC_ERROR;

530:
531: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: END IF;
537: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Save_Header-After Second PO'||
538: l_return_status, 1);

Line 544: x_return_status := FND_API.G_RET_STS_SUCCESS;

540: OE_GLOBALS.G_UI_FLAG := FALSE;
541:
542: -- Set return status.
543:
544: x_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546: -- Get message count and data
547:
548: OE_MSG_PUB.Count_And_Get

Line 557: WHEN FND_API.G_EXC_ERROR THEN

553: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Save_Header', 1);
554:
555: EXCEPTION
556:
557: WHEN FND_API.G_EXC_ERROR THEN
558:
559: OE_GLOBALS.G_UI_FLAG := FALSE;
560:
561: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: OE_GLOBALS.G_UI_FLAG := FALSE;
560:
561: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
562:
563: x_return_status := FND_API.G_RET_STS_ERROR;
564:
565: -- Get message count and data
566:
567: OE_MSG_PUB.Count_And_Get

Line 572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

568: ( p_count => x_msg_count
569: , p_data => x_msg_data
570: );
571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573:
574: OE_GLOBALS.G_UI_FLAG := FALSE;
575:
576: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;

Line 578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

574: OE_GLOBALS.G_UI_FLAG := FALSE;
575:
576: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
577:
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579:
580: -- Get message count and data
581:
582: OE_MSG_PUB.Count_And_Get

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

589: OE_GLOBALS.G_UI_FLAG := FALSE;
590:
591: ROLLBACK TO SAVEPOINT Header_Validate_And_Write;
592:
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594:
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: OE_MSG_PUB.Add_Exc_Msg

Line 659: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

655:
656: -- Call Oe_Order_Pvt.Header
657:
658: Oe_Order_Pvt.Header
659: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
660: , p_init_msg_list => FND_API.G_TRUE
661: , p_control_rec => l_control_rec
662: , p_x_header_rec => l_x_header_rec
663: , p_x_old_header_rec => l_x_old_header_rec

Line 660: , p_init_msg_list => FND_API.G_TRUE

656: -- Call Oe_Order_Pvt.Header
657:
658: Oe_Order_Pvt.Header
659: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
660: , p_init_msg_list => FND_API.G_TRUE
661: , p_control_rec => l_control_rec
662: , p_x_header_rec => l_x_header_rec
663: , p_x_old_header_rec => l_x_old_header_rec
664: , x_return_status => l_return_status

Line 667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

663: , p_x_old_header_rec => l_x_old_header_rec
664: , x_return_status => l_return_status
665: );
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: , x_return_status => l_return_status
665: );
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:

Line 669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

665: );
666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673:

Line 670: RAISE FND_API.G_EXC_ERROR;

666:
667: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672:
673:
674:

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: OE_GLOBALS.G_UI_FLAG := FALSE;
678:
679: -- Set return status.
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: -- Get message count and data
684:
685: OE_MSG_PUB.Count_And_Get

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.DELETE_ROW', 1);
691:
692: EXCEPTION
693:
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO SAVEPOINT Header_Delete ;
696: OE_GLOBALS.G_UI_FLAG := FALSE;
697:
698: x_return_status := FND_API.G_RET_STS_ERROR;

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO SAVEPOINT Header_Delete ;
696: OE_GLOBALS.G_UI_FLAG := FALSE;
697:
698: x_return_status := FND_API.G_RET_STS_ERROR;
699:
700: -- Get message count and data
701:
702: OE_MSG_PUB.Count_And_Get

Line 707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

703: ( p_count => x_msg_count
704: , p_data => x_msg_data
705: );
706:
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO SAVEPOINT Header_Delete ;
709:
710: OE_GLOBALS.G_UI_FLAG := FALSE;
711:

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

708: ROLLBACK TO SAVEPOINT Header_Delete ;
709:
710: OE_GLOBALS.G_UI_FLAG := FALSE;
711:
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713:
714: -- Get message count and data
715:
716: OE_MSG_PUB.Count_And_Get

Line 726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

722: ROLLBACK TO SAVEPOINT Header_Delete ;
723:
724: OE_GLOBALS.G_UI_FLAG := FALSE;
725:
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
727:
728: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
729: THEN
730: OE_MSG_PUB.Add_Exc_Msg

Line 752: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE

748:
749: PROCEDURE Process_Object
750:
751: (
752: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
753: , x_return_status OUT NOCOPY VARCHAR2
754: , x_msg_count OUT NOCOPY NUMBER
755: , x_msg_data OUT NOCOPY VARCHAR2
756: , x_cascade_flag OUT NOCOPY BOOLEAN

Line 812: , p_init_msg_list => FND_API.G_FALSE

808: , p_x_line_tbl => l_line_tbl );
809:
810: Oe_Order_Pvt.Process_Requests_And_Notify
811: ( p_process_requests => TRUE
812: , p_init_msg_list => FND_API.G_FALSE
813: , p_notify => TRUE
814: , x_return_status => l_return_status
815: );
816:

Line 818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

814: , x_return_status => l_return_status
815: );
816:
817:
818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815: );
816:
817:
818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:

Line 820: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

816:
817:
818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824: x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;

Line 821: RAISE FND_API.G_EXC_ERROR;

817:
818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824: x_cascade_flag := OE_GLOBALS.G_CASCADING_REQUEST_LOGGED;
825: -- Re-set the UI flag to FALSE

Line 830: x_return_status := FND_API.G_RET_STS_SUCCESS;

826: OE_GLOBALS.G_UI_FLAG := FALSE;
827:
828: -- Set return status.
829:
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831:
832: -- Get message count and data
833:
834: OE_MSG_PUB.Count_And_Get

Line 846: WHEN FND_API.G_EXC_ERROR THEN

842: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.PROCESS_OBJECT', 1);
843:
844: EXCEPTION
845:
846: WHEN FND_API.G_EXC_ERROR THEN
847: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
848: OE_GLOBALS.G_UI_FLAG := FALSE;
849:
850: x_return_status := FND_API.G_RET_STS_ERROR;

Line 850: x_return_status := FND_API.G_RET_STS_ERROR;

846: WHEN FND_API.G_EXC_ERROR THEN
847: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
848: OE_GLOBALS.G_UI_FLAG := FALSE;
849:
850: x_return_status := FND_API.G_RET_STS_ERROR;
851:
852: -- Get message count and data
853:
854: OE_MSG_PUB.Count_And_Get

Line 859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

855: ( p_count => x_msg_count
856: , p_data => x_msg_data
857: );
858:
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
861: OE_GLOBALS.G_UI_FLAG := FALSE;
862:
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
861: OE_GLOBALS.G_UI_FLAG := FALSE;
862:
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864:
865: -- Get message count and data
866:
867: OE_MSG_PUB.Count_And_Get

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

872: WHEN OTHERS THEN
873: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
874: OE_GLOBALS.G_UI_FLAG := FALSE;
875:
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg

Line 928: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

924: OE_Header_Util.Lock_Row
925: ( x_return_status => l_return_status
926: , p_x_header_rec => l_x_header_rec );
927:
928: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
929:
930: -- Set DB flag and write record to cache.
931:
932: l_x_header_rec.db_flag := FND_API.G_TRUE;

Line 932: l_x_header_rec.db_flag := FND_API.G_TRUE;

928: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
929:
930: -- Set DB flag and write record to cache.
931:
932: l_x_header_rec.db_flag := FND_API.G_TRUE;
933:
934:
935: END IF;
936:

Line 940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

936:
937: -- Set return status.
938:
939: x_return_status := l_return_status;
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;

Line 941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

937: -- Set return status.
938:
939: x_return_status := l_return_status;
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:

Line 942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

938:
939: x_return_status := l_return_status;
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946:

Line 943: RAISE FND_API.G_EXC_ERROR;

939: x_return_status := l_return_status;
940: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946:
947: -- Get message count and data

Line 957: WHEN FND_API.G_EXC_ERROR THEN

953:
954: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.LOCK_ROW', 1);
955:
956: EXCEPTION
957: WHEN FND_API.G_EXC_ERROR THEN
958:
959: OE_GLOBALS.G_UI_FLAG := FALSE;
960:
961: x_return_status := FND_API.G_RET_STS_ERROR;

Line 961: x_return_status := FND_API.G_RET_STS_ERROR;

957: WHEN FND_API.G_EXC_ERROR THEN
958:
959: OE_GLOBALS.G_UI_FLAG := FALSE;
960:
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: -- Get message count and data
964:
965: oe_msg_pub.count_and_get

Line 970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

966: ( p_count => x_msg_count
967: , p_data => x_msg_data
968: );
969:
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
971:
972: OE_GLOBALS.G_UI_FLAG := FALSE;
973:
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
971:
972: OE_GLOBALS.G_UI_FLAG := FALSE;
973:
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
975:
976: -- Get message count and data
977:
978: oe_msg_pub.count_and_get

Line 992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

988: , 'Lock_Row'
989: );
990: END IF;
991:
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993:
994: -- Get message count and data
995:
996: OE_MSG_PUB.Count_And_Get

Line 1029: x_return_status := FND_API.G_RET_STS_SUCCESS;

1025: IS
1026: l_return_status Varchar2(30);
1027: BEGIN
1028: OE_MSG_PUB.initialize;
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: OE_ORDER_CACHE.g_header_rec:=null;
1032: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1033: p_entity_code => OE_GLOBALS.G_ENTITY_HEADER

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR;

1055: OE_MSG_PUB.Count_And_Get
1056: ( p_count => x_msg_count
1057: , p_data => x_msg_data
1058: );
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060:
1061: END Clear_Record;
1062:
1063:

Line 1076: x_return_status := FND_API.G_RET_STS_SUCCESS;

1072: IS
1073: l_return_status Varchar2(30);
1074: BEGIN
1075: OE_MSG_PUB.initialize;
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077: OE_DELAYED_REQUESTS_PVT.Clear_Request(
1078: x_return_status => l_return_status);
1079:
1080: EXCEPTION

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

1090: OE_MSG_PUB.Count_And_Get
1091: ( p_count => x_msg_count
1092: , p_data => x_msg_data
1093: );
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095:
1096: END Delete_All_Requests;
1097:
1098: PROCEDURE get_customer_details ( p_site_use_id IN NUMBER,

Line 1244: x_return_status := FND_API.G_RET_STS_SUCCESS;

1240:
1241: END IF;
1242:
1243:
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245: oe_debug_pub.add('Entering Oe_Oe_Html_Header.Get_Values'||x_header_val_rec.salesrep, 1);
1246: oe_debug_pub.add('Exiting Oe_Oe_Html_Header.Get_Values', 1);
1247:
1248:

Line 1263: x_return_status := FND_API.G_RET_STS_ERROR;

1259: OE_MSG_PUB.Count_And_Get
1260: ( p_count => x_msg_count
1261: , p_data => x_msg_data
1262: );
1263: x_return_status := FND_API.G_RET_STS_ERROR;
1264: END Populate_Transient_Attributes;
1265:
1266: END Oe_Oe_Html_Header;