DBA Data[Home] [Help]

APPS.OE_OE_FORM_CANCEL_LINE dependencies on OE_MSG_PUB

Line 95: oe_msg_pub.initialize;

91: g_record_ids := l_record_ids; -- Added For bug#2965878
92: IF l_debug_level > 0 THEN
93: oe_debug_pub.add( 'ENTER PROCEDURE PROCESS CANCEL QTY' , 1 ) ;
94: END IF;
95: oe_msg_pub.initialize;
96: x_error_count := l_error_count;
97:
98: IF l_debug_level > 0 THEN
99: oe_debug_pub.add( ' NO. OF RECORDS: '||TO_CHAR ( P_NUM_OF_RECORDS ) , 1 ) ;

Line 219: oe_msg_pub.add;

215: l_ordered_quantity2 := l_line_rec.ordered_quantity2;
216:
217: if (l_ordered_quantity = 0 or l_line_rec.cancelled_flag = 'Y') then
218: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
219: oe_msg_pub.add;
220: RAISE FND_API.G_EXC_ERROR ;
221: end if;
222:
223: IF l_debug_level > 0 THEN

Line 351: OE_MSG_PUB.Count_And_Get

347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'AFTER CALLING PROCESSE for last set' , 1 ) ;
349: END IF;
350:
351: OE_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355:

Line 378: OE_MSG_PUB.Count_And_Get

374: EXCEPTION /* Procedure exception handler */
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_ERROR ;
378: OE_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data
381: );
382: ROLLBACK TO SAVEPOINT Process_cancel_quantity;

Line 386: OE_MSG_PUB.Count_And_Get

382: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
386: OE_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count,
388: p_data => x_msg_data
389: );
390: ROLLBACK TO SAVEPOINT Process_cancel_quantity;

Line 394: IF OE_MSG_PUB.Check_Msg_Level

390: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
391:
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: IF OE_MSG_PUB.Check_Msg_Level
395: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: OE_MSG_PUB.Add_Exc_Msg
398: (G_PKG_NAME,

Line 395: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

391:
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: IF OE_MSG_PUB.Check_Msg_Level
395: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: OE_MSG_PUB.Add_Exc_Msg
398: (G_PKG_NAME,
399: l_api_name

Line 397: OE_MSG_PUB.Add_Exc_Msg

393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: IF OE_MSG_PUB.Check_Msg_Level
395: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
396: THEN
397: OE_MSG_PUB.Add_Exc_Msg
398: (G_PKG_NAME,
399: l_api_name
400: );
401: END IF;

Line 402: OE_MSG_PUB.Count_And_Get

398: (G_PKG_NAME,
399: l_api_name
400: );
401: END IF;
402: OE_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,
404: p_data => x_msg_data);
405: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
406:

Line 443: oe_msg_pub.initialize;

439: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
440: l_orgid number;
441: --
442: BEGIN
443: oe_msg_pub.initialize;
444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
446: END IF;
447: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 512: oe_msg_pub.Add;

508: FND_MESSAGE.SET_TOKEN('ORDER',
509: L_header_rec.Order_Number);
510:
511:
512: oe_msg_pub.Add;
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515: IF nvl(l_header_rec.open_flag,'N') = 'N' THEN
516: IF l_debug_level > 0 THEN

Line 522: oe_msg_pub.Add;

518: END IF;
519: fnd_message.set_name('ONT', 'OE_CAN_ORDER_CLOSED');
520: FND_MESSAGE.SET_TOKEN('ORDER',
521: L_header_rec.Order_Number);
522: oe_msg_pub.Add;
523: RAISE FND_API.G_EXC_ERROR ;
524: END IF;
525:
526: l_header_rec.cancelled_flag :='Y';

Line 540: OE_MSG_PUB.Count_And_Get

536: , x_return_status => l_return_status
537:
538: );
539:
540: OE_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:

Line 591: OE_MSG_PUB.Count_And_Get

587: EXCEPTION /* Procedure exception handler */
588:
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR ;
591: OE_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data
594: );
595: g_ord_lvl_can := FALSE; --For fix bug# 2922468.

Line 600: OE_MSG_PUB.Count_And_Get

596: ROLLBACK TO SAVEPOINT Process_cancel_order;
597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
600: OE_MSG_PUB.Count_And_Get
601: ( p_count => x_msg_count,
602: p_data => x_msg_data
603: );
604: g_ord_lvl_can:=FALSE; --Fix for bug# 2922468.

Line 609: IF OE_MSG_PUB.Check_Msg_Level

605: ROLLBACK TO SAVEPOINT Process_cancel_order;
606:
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF OE_MSG_PUB.Check_Msg_Level
610: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME,

Line 610: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

606:
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF OE_MSG_PUB.Check_Msg_Level
610: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME,
614: l_api_name

Line 612: OE_MSG_PUB.Add_Exc_Msg

608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: IF OE_MSG_PUB.Check_Msg_Level
610: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: (G_PKG_NAME,
614: l_api_name
615: );
616: END IF;

Line 617: OE_MSG_PUB.Count_And_Get

613: (G_PKG_NAME,
614: l_api_name
615: );
616: END IF;
617: OE_MSG_PUB.Count_And_Get
618: ( p_count => x_msg_count,
619: p_data => x_msg_data);
620: g_ord_lvl_can := FALSE; --Fix for bug# 2922468.
621: ROLLBACK TO SAVEPOINT Process_cancel_order;

Line 759: OE_MSG_PUB.Count_And_Get

755: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'INTO CANCELLATION EXPECTED FAILURE' ) ;
758: END IF;
759: OE_MSG_PUB.Count_And_Get
760: ( p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:

Line 774: OE_MSG_PUB.Count_And_Get

770: EXCEPTION /* Procedure exception handler */
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR ;
774: OE_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count,
776: p_data => x_msg_data
777: );
778: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;

Line 781: OE_MSG_PUB.Count_And_Get

777: );
778: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
781: OE_MSG_PUB.Count_And_Get
782: ( p_count => x_msg_count,
783: p_data => x_msg_data
784: );
785: WHEN OTHERS THEN

Line 787: IF OE_MSG_PUB.Check_Msg_Level

783: p_data => x_msg_data
784: );
785: WHEN OTHERS THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: IF OE_MSG_PUB.Check_Msg_Level
788: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: OE_MSG_PUB.Add_Exc_Msg
791: (G_PKG_NAME,

Line 788: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

784: );
785: WHEN OTHERS THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: IF OE_MSG_PUB.Check_Msg_Level
788: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: OE_MSG_PUB.Add_Exc_Msg
791: (G_PKG_NAME,
792: l_api_name

Line 790: OE_MSG_PUB.Add_Exc_Msg

786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: IF OE_MSG_PUB.Check_Msg_Level
788: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790: OE_MSG_PUB.Add_Exc_Msg
791: (G_PKG_NAME,
792: l_api_name
793: );
794: END IF;

Line 795: OE_MSG_PUB.Count_And_Get

791: (G_PKG_NAME,
792: l_api_name
793: );
794: END IF;
795: OE_MSG_PUB.Count_And_Get
796: ( p_count => x_msg_count,
797: p_data => x_msg_data);
798: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
799:

Line 856: OE_MSG_PUB.Count_And_Get

852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add( 'AFTER CALLING PROCESSE' , 1 ) ;
854: END IF;
855:
856: OE_MSG_PUB.Count_And_Get
857: ( p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860:

Line 883: OE_MSG_PUB.Count_And_Get

879: EXCEPTION /* Procedure exception handler */
880:
881: WHEN FND_API.G_EXC_ERROR THEN
882: x_return_status := FND_API.G_RET_STS_ERROR ;
883: OE_MSG_PUB.Count_And_Get
884: ( p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887:

Line 890: OE_MSG_PUB.Count_And_Get

886: );
887:
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
890: OE_MSG_PUB.Count_And_Get
891: ( p_count => x_msg_count,
892: p_data => x_msg_data
893: );
894: WHEN OTHERS THEN

Line 896: IF OE_MSG_PUB.Check_Msg_Level

892: p_data => x_msg_data
893: );
894: WHEN OTHERS THEN
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: IF OE_MSG_PUB.Check_Msg_Level
897: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: OE_MSG_PUB.Add_Exc_Msg
900: (G_PKG_NAME,

Line 897: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

893: );
894: WHEN OTHERS THEN
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: IF OE_MSG_PUB.Check_Msg_Level
897: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: OE_MSG_PUB.Add_Exc_Msg
900: (G_PKG_NAME,
901: l_api_name

Line 899: OE_MSG_PUB.Add_Exc_Msg

895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: IF OE_MSG_PUB.Check_Msg_Level
897: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899: OE_MSG_PUB.Add_Exc_Msg
900: (G_PKG_NAME,
901: l_api_name
902: );
903: END IF;

Line 904: OE_MSG_PUB.Count_And_Get

900: (G_PKG_NAME,
901: l_api_name
902: );
903: END IF;
904: OE_MSG_PUB.Count_And_Get
905: ( p_count => x_msg_count,
906: p_data => x_msg_data);
907:
908: END Call_Process_Order;