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 225: oe_msg_pub.add;

221: l_ordered_quantity2 := l_line_rec.ordered_quantity2;
222:
223: if (l_ordered_quantity = 0 or l_line_rec.cancelled_flag = 'Y') then
224: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
225: oe_msg_pub.add;
226: RAISE FND_API.G_EXC_ERROR ;
227: end if;
228:
229: IF l_debug_level > 0 THEN

Line 357: OE_MSG_PUB.Count_And_Get

353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'AFTER CALLING PROCESSE for last set' , 1 ) ;
355: END IF;
356:
357: OE_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );
361:

Line 384: OE_MSG_PUB.Count_And_Get

380: EXCEPTION /* Procedure exception handler */
381:
382: WHEN FND_API.G_EXC_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: OE_MSG_PUB.Count_And_Get
385: ( p_count => x_msg_count,
386: p_data => x_msg_data
387: );
388: ROLLBACK TO SAVEPOINT Process_cancel_quantity;

Line 392: OE_MSG_PUB.Count_And_Get

388: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: OE_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,
394: p_data => x_msg_data
395: );
396: ROLLBACK TO SAVEPOINT Process_cancel_quantity;

Line 400: IF OE_MSG_PUB.Check_Msg_Level

396: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF OE_MSG_PUB.Check_Msg_Level
401: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg
404: (G_PKG_NAME,

Line 401: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF OE_MSG_PUB.Check_Msg_Level
401: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg
404: (G_PKG_NAME,
405: l_api_name

Line 403: OE_MSG_PUB.Add_Exc_Msg

399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF OE_MSG_PUB.Check_Msg_Level
401: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg
404: (G_PKG_NAME,
405: l_api_name
406: );
407: END IF;

Line 408: OE_MSG_PUB.Count_And_Get

404: (G_PKG_NAME,
405: l_api_name
406: );
407: END IF;
408: OE_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data);
411: ROLLBACK TO SAVEPOINT Process_cancel_quantity;
412:

Line 449: oe_msg_pub.initialize;

445: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
446: l_orgid number;
447: --
448: BEGIN
449: oe_msg_pub.initialize;
450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add( 'PROCEDURE PROCESS_CANCEL_ORDER' , 1 ) ;
452: END IF;
453: l_header_rec := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 518: oe_msg_pub.Add;

514: FND_MESSAGE.SET_TOKEN('ORDER',
515: L_header_rec.Order_Number);
516:
517:
518: oe_msg_pub.Add;
519: RAISE FND_API.G_EXC_ERROR ;
520: END IF;
521: IF nvl(l_header_rec.open_flag,'N') = 'N' THEN
522: IF l_debug_level > 0 THEN

Line 528: oe_msg_pub.Add;

524: END IF;
525: fnd_message.set_name('ONT', 'OE_CAN_ORDER_CLOSED');
526: FND_MESSAGE.SET_TOKEN('ORDER',
527: L_header_rec.Order_Number);
528: oe_msg_pub.Add;
529: RAISE FND_API.G_EXC_ERROR ;
530: END IF;
531:
532: l_header_rec.cancelled_flag :='Y';

Line 546: OE_MSG_PUB.Count_And_Get

542: , x_return_status => l_return_status
543:
544: );
545:
546: OE_MSG_PUB.Count_And_Get
547: ( p_count => x_msg_count,
548: p_data => x_msg_data
549: );
550:

Line 569: OE_MSG_PUB.Count_And_Get

565: , p_header_rec => l_header_rec
566: , p_old_header_rec => l_old_header_rec
567: );
568: --16594370 start
569: OE_MSG_PUB.Count_And_Get
570: ( p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573: --16594370 end

Line 602: OE_MSG_PUB.Count_And_Get

598: EXCEPTION /* Procedure exception handler */
599:
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: OE_MSG_PUB.Count_And_Get
603: ( p_count => x_msg_count,
604: p_data => x_msg_data
605: );
606: g_ord_lvl_can := FALSE; --For fix bug# 2922468.

Line 611: OE_MSG_PUB.Count_And_Get

607: ROLLBACK TO SAVEPOINT Process_cancel_order;
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
611: OE_MSG_PUB.Count_And_Get
612: ( p_count => x_msg_count,
613: p_data => x_msg_data
614: );
615: g_ord_lvl_can:=FALSE; --Fix for bug# 2922468.

Line 620: IF OE_MSG_PUB.Check_Msg_Level

616: ROLLBACK TO SAVEPOINT Process_cancel_order;
617:
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF OE_MSG_PUB.Check_Msg_Level
621: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg
624: (G_PKG_NAME,

Line 621: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

617:
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF OE_MSG_PUB.Check_Msg_Level
621: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg
624: (G_PKG_NAME,
625: l_api_name

Line 623: OE_MSG_PUB.Add_Exc_Msg

619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF OE_MSG_PUB.Check_Msg_Level
621: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg
624: (G_PKG_NAME,
625: l_api_name
626: );
627: END IF;

Line 628: OE_MSG_PUB.Count_And_Get

624: (G_PKG_NAME,
625: l_api_name
626: );
627: END IF;
628: OE_MSG_PUB.Count_And_Get
629: ( p_count => x_msg_count,
630: p_data => x_msg_data);
631: g_ord_lvl_can := FALSE; --Fix for bug# 2922468.
632: ROLLBACK TO SAVEPOINT Process_cancel_order;

Line 770: OE_MSG_PUB.Count_And_Get

766: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( 'INTO CANCELLATION EXPECTED FAILURE' ) ;
769: END IF;
770: OE_MSG_PUB.Count_And_Get
771: ( p_count => x_msg_count,
772: p_data => x_msg_data
773: );
774:

Line 785: OE_MSG_PUB.Count_And_Get

781: EXCEPTION /* Procedure exception handler */
782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_ERROR ;
785: OE_MSG_PUB.Count_And_Get
786: ( p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;

Line 792: OE_MSG_PUB.Count_And_Get

788: );
789: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: OE_MSG_PUB.Count_And_Get
793: ( p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796: WHEN OTHERS THEN

Line 798: IF OE_MSG_PUB.Check_Msg_Level

794: p_data => x_msg_data
795: );
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798: IF OE_MSG_PUB.Check_Msg_Level
799: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
800: THEN
801: OE_MSG_PUB.Add_Exc_Msg
802: (G_PKG_NAME,

Line 799: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

795: );
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798: IF OE_MSG_PUB.Check_Msg_Level
799: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
800: THEN
801: OE_MSG_PUB.Add_Exc_Msg
802: (G_PKG_NAME,
803: l_api_name

Line 801: OE_MSG_PUB.Add_Exc_Msg

797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
798: IF OE_MSG_PUB.Check_Msg_Level
799: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
800: THEN
801: OE_MSG_PUB.Add_Exc_Msg
802: (G_PKG_NAME,
803: l_api_name
804: );
805: END IF;

Line 806: OE_MSG_PUB.Count_And_Get

802: (G_PKG_NAME,
803: l_api_name
804: );
805: END IF;
806: OE_MSG_PUB.Count_And_Get
807: ( p_count => x_msg_count,
808: p_data => x_msg_data);
809: ROLLBACK TO SAVEPOINT Cancel_Remaining_Order;
810:

Line 867: OE_MSG_PUB.Count_And_Get

863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add( 'AFTER CALLING PROCESSE' , 1 ) ;
865: END IF;
866:
867: OE_MSG_PUB.Count_And_Get
868: ( p_count => x_msg_count,
869: p_data => x_msg_data
870: );
871:

Line 894: OE_MSG_PUB.Count_And_Get

890: EXCEPTION /* Procedure exception handler */
891:
892: WHEN FND_API.G_EXC_ERROR THEN
893: x_return_status := FND_API.G_RET_STS_ERROR ;
894: OE_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count,
896: p_data => x_msg_data
897: );
898:

Line 901: OE_MSG_PUB.Count_And_Get

897: );
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: OE_MSG_PUB.Count_And_Get
902: ( p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905: WHEN OTHERS THEN

Line 907: IF OE_MSG_PUB.Check_Msg_Level

903: p_data => x_msg_data
904: );
905: WHEN OTHERS THEN
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF OE_MSG_PUB.Check_Msg_Level
908: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: OE_MSG_PUB.Add_Exc_Msg
911: (G_PKG_NAME,

Line 908: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

904: );
905: WHEN OTHERS THEN
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF OE_MSG_PUB.Check_Msg_Level
908: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: OE_MSG_PUB.Add_Exc_Msg
911: (G_PKG_NAME,
912: l_api_name

Line 910: OE_MSG_PUB.Add_Exc_Msg

906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF OE_MSG_PUB.Check_Msg_Level
908: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: OE_MSG_PUB.Add_Exc_Msg
911: (G_PKG_NAME,
912: l_api_name
913: );
914: END IF;

Line 915: OE_MSG_PUB.Count_And_Get

911: (G_PKG_NAME,
912: l_api_name
913: );
914: END IF;
915: OE_MSG_PUB.Count_And_Get
916: ( p_count => x_msg_count,
917: p_data => x_msg_data);
918:
919: END Call_Process_Order;