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_INTERNAL_REQUISITION_PVT dependencies on OE_MSG_PUB

Line 81: OE_MSG_PUB.Add;

77: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment With No Data Found Error', 1 ) ;
78: END IF;
79: FND_Message.Set_Name('ONT', 'OE_IRCMS_NOT_ELIGIBLE');
80: -- There is no sales order line shipment eligible for update/cancellation.
81: OE_MSG_PUB.Add;
82: X_return_status := FND_API.G_RET_STS_ERROR;
83:
84: WHEN TOO_MANY_ROWS THEN
85: IF l_debug_level > 0 THEN

Line 91: OE_MSG_PUB.Add;

87: END IF;
88: FND_Message.Set_Name('ONT', 'OE_IRCMS_TOO_MANY_ROWS');
89: -- There are multiple sales order line shipments eligible for update.
90: -- This is not allowed.
91: OE_MSG_PUB.Add;
92: X_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN OTHERS THEN
95: IF l_debug_level > 0 THEN

Line 98: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

94: WHEN OTHERS THEN
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with others error'||sqlerrm,1);
97: END IF;
98: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
99: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Eligible_ISO_Shipment');
100: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'
101: END IF;
102: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 99: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Eligible_ISO_Shipment');

95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with others error'||sqlerrm,1);
97: END IF;
98: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
99: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Eligible_ISO_Shipment');
100: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'
101: END IF;
102: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
103: End Get_Eligible_ISO_Shipment;

Line 238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

234: END IF;
235: Exception
236: WHEN OTHERS THEN
237: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Update_Allowed '||sqlerrm,1);
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Allowed');
240: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'
241: END IF;
242: RETURN FALSE;

Line 239: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Allowed');

235: Exception
236: WHEN OTHERS THEN
237: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Update_Allowed '||sqlerrm,1);
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Allowed');
240: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'
241: END IF;
242: RETURN FALSE;
243: End Update_Allowed;

Line 345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

341:
342: Exception
343: WHEN OTHERS THEN
344: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Allowed '||sqlerrm,1);
345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Allowed');
347: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
348: END IF;
349: RETURN FALSE;

Line 346: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Allowed');

342: Exception
343: WHEN OTHERS THEN
344: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Allowed '||sqlerrm,1);
345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Allowed');
347: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
348: END IF;
349: RETURN FALSE;
350: End Cancel_Allowed;

Line 406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

402:
403: Exception
404: WHEN OTHERS THEN
405: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Header_Allowed '||sqlerrm,1);
406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
407: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Header_Allowed');
408: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
409: END IF;
410: RETURN FALSE;

Line 407: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Header_Allowed');

403: Exception
404: WHEN OTHERS THEN
405: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Header_Allowed '||sqlerrm,1);
406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
407: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Header_Allowed');
408: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
409: END IF;
410: RETURN FALSE;
411: End Cancel_Header_Allowed;

Line 505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

501:
502: EXCEPTION
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: OE_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME
508: , 'Process_Line_Entity' );
509: END IF;

Line 506: OE_MSG_PUB.Add_Exc_Msg

502: EXCEPTION
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
506: OE_MSG_PUB.Add_Exc_Msg
507: ( G_PKG_NAME
508: , 'Process_Line_Entity' );
509: END IF;
510:

Line 516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

512: x_return_status := FND_API.G_RET_STS_ERROR;
513:
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: OE_MSG_PUB.Add_Exc_Msg
518: ( G_PKG_NAME
519: , 'Process_Line_Entity' );
520: END IF;

Line 517: OE_MSG_PUB.Add_Exc_Msg

513:
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: OE_MSG_PUB.Add_Exc_Msg
518: ( G_PKG_NAME
519: , 'Process_Line_Entity' );
520: END IF;
521: IF l_debug_level > 0 THEN

Line 568: -- OE_MSG_PUB.set_msg_context();

564: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
565: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
566: END IF;
567:
568: -- OE_MSG_PUB.set_msg_context();
569: -- No need to set the message context as the caller of this API is PO
570: -- and Message window is not applicable in Requesting organization
571:
572: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 580: OE_MSG_PUB.Add;

576: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
577: END IF;
578: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
579: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');
580: OE_MSG_PUB.Add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583: IF P_internal_req_header_id is NULL THEN
584: IF l_debug_level > 0 THEN

Line 598: OE_MSG_PUB.Add;

594: IF l_req_hdr_id IS NULL THEN
595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
596: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
597: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
598: OE_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601: Exception
602: When No_Data_Found Then

Line 606: OE_MSG_PUB.Add;

602: When No_Data_Found Then
603: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
604: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
605: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
606: OE_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;
608: End;
609: ELSE
610: l_req_hdr_id := P_internal_req_header_id;

Line 650: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

646: END IF;
647:
648: x_return_status := l_return_status;
649:
650: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
651: P_Data => x_msg_Data);
652:
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;

Line 659: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

655: END IF;
656:
657: Exception
658: WHEN FND_API.G_EXC_ERROR THEN
659: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
662: P_Data => x_msg_Data);
663: ROLLBACK TO Apply_Hold_For_IReq;

Line 661: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

657: Exception
658: WHEN FND_API.G_EXC_ERROR THEN
659: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
662: P_Data => x_msg_Data);
663: ROLLBACK TO Apply_Hold_For_IReq;
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 666: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

662: P_Data => x_msg_Data);
663: ROLLBACK TO Apply_Hold_For_IReq;
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
669: P_Data => x_msg_Data);
670: ROLLBACK TO Apply_Hold_For_IReq;

Line 668: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
669: P_Data => x_msg_Data);
670: ROLLBACK TO Apply_Hold_For_IReq;
671:
672: WHEN OTHERS THEN

Line 674: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

670: ROLLBACK TO Apply_Hold_For_IReq;
671:
672: WHEN OTHERS THEN
673: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
674: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
678: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

Line 676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

672: WHEN OTHERS THEN
673: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
674: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
678: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
679: END IF;
680: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');

673: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
674: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
678: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
679: END IF;
680: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
681: P_Data => x_msg_Data);

Line 680: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
678: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
679: END IF;
680: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
681: P_Data => x_msg_Data);
682: ROLLBACK TO Apply_Hold_For_IReq;
683:
684: End Apply_Hold_for_IReq;

Line 729: -- OE_MSG_PUB.set_msg_context();

725: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
726: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
727: END IF;
728:
729: -- OE_MSG_PUB.set_msg_context();
730: -- No need to set the message context as the caller of this API is PO
731: -- and Message window is not applicable in Requesting organization
732:
733: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 741: OE_MSG_PUB.Add;

737: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
738: END IF;
739: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
740: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
741: OE_MSG_PUB.Add;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: IF P_internal_req_header_id is NULL THEN
745: IF l_debug_level > 0 THEN

Line 759: OE_MSG_PUB.Add;

755: IF l_req_hdr_id IS NULL THEN
756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
757: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
758: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
759: OE_MSG_PUB.Add;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: Exception
763: When No_Data_Found Then

Line 767: OE_MSG_PUB.Add;

763: When No_Data_Found Then
764: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
765: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
766: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
767: OE_MSG_PUB.Add;
768: RAISE FND_API.G_EXC_ERROR;
769: End;
770: ELSE
771: l_req_hdr_id := P_internal_req_header_id;

Line 828: OE_MSG_PUB.Add;

824: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');
825: END IF;
826: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');
827: -- There is no sales order line shipment on hold.
828: OE_MSG_PUB.Add;
829: X_return_status := FND_API.G_RET_STS_ERROR;
830:
831: When Too_Many_Rows Then
832: IF l_debug_level > 0 THEN

Line 837: OE_MSG_PUB.Add;

833: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;
834: END IF;
835: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');
836: -- There are many sales order line shipments eligible for hold release. This is not allowed.
837: OE_MSG_PUB.Add;
838: X_return_status := FND_API.G_RET_STS_ERROR;
839: End;
840:
841: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 841: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

837: OE_MSG_PUB.Add;
838: X_return_status := FND_API.G_RET_STS_ERROR;
839: End;
840:
841: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
842: -- Not resetting the message because it was never initialized
843: -- Same is the case in Exception block
844:
845: x_return_status := l_return_status;

Line 847: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

843: -- Same is the case in Exception block
844:
845: x_return_status := l_return_status;
846:
847: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
848: P_Data => x_msg_Data);
849:
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;

Line 856: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

852: END IF;
853:
854: Exception
855: WHEN FND_API.G_EXC_ERROR THEN
856: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
859: P_Data => x_msg_Data);
860: ROLLBACK TO Release_Hold_For_IReq;

Line 858: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

854: Exception
855: WHEN FND_API.G_EXC_ERROR THEN
856: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
859: P_Data => x_msg_Data);
860: ROLLBACK TO Release_Hold_For_IReq;
861:
862:

Line 864: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

860: ROLLBACK TO Release_Hold_For_IReq;
861:
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
867: P_Data => x_msg_Data);
868: ROLLBACK TO Release_Hold_For_IReq;

Line 866: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
867: P_Data => x_msg_Data);
868: ROLLBACK TO Release_Hold_For_IReq;
869:
870: WHEN OTHERS THEN

Line 872: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

868: ROLLBACK TO Release_Hold_For_IReq;
869:
870: WHEN OTHERS THEN
871: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
872: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
876: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

Line 874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

870: WHEN OTHERS THEN
871: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
872: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
876: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
877: END IF;
878: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');

871: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
872: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
876: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
877: END IF;
878: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
879: P_Data => x_msg_Data);

Line 878: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
876: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
877: END IF;
878: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
879: P_Data => x_msg_Data);
880: ROLLBACK TO Release_Hold_For_IReq;
881:
882: End Release_Hold_for_IReq;

Line 942: -- OE_MSG_PUB.set_msg_context();

938: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
939: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
940: END IF;
941:
942: -- OE_MSG_PUB.set_msg_context();
943: -- No need to set the message context as the caller of this API is PO
944: -- and Message window is not applicable in Requesting organization
945:
946: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 955: OE_MSG_PUB.Add;

951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( ' Invalid value for Requisition Header/Line',1);
953: END IF;
954: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_INFO');
955: OE_MSG_PUB.Add;
956: RAISE FND_API.G_EXC_ERROR;
957: END IF;
958:
959: IF P_internal_req_header_id is NOT NULL AND P_internal_req_line_id is NULL THEN

Line 1047: OE_MSG_PUB.Add;

1043: oe_debug_pub.add( ' Invalid value for Requisition Header',1);
1044: END IF;
1045: X_Cancel_Allowed := FALSE;
1046: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1047: OE_MSG_PUB.Add;
1048: RAISE FND_API.G_EXC_ERROR;
1049: End;
1050: END IF;
1051:

Line 1067: OE_MSG_PUB.Add;

1063: IF l_req_hdr_id IS NULL THEN
1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1066: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1067: OE_MSG_PUB.Add;
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: Exception
1071: When No_Data_Found Then

Line 1075: OE_MSG_PUB.Add;

1071: When No_Data_Found Then
1072: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1073: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1074: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1075: OE_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_ERROR;
1077: End;
1078: ELSE
1079: l_req_hdr_id := P_internal_req_header_id;

Line 1133: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1129: END IF;
1130: END IF;
1131: END IF;
1132:
1133: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1134: -- Not resetting the message because it was never initialized
1135: -- Same is the case in Exception block
1136:
1137: <>

Line 1151: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1147: END IF;
1148:
1149: x_return_status := l_return_status;
1150:
1151: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1152: P_Data => x_msg_Data);
1153:
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;

Line 1160: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1156: END IF;
1157:
1158: Exception
1159: WHEN FND_API.G_EXC_ERROR THEN
1160: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: X_Update_Allowed := FALSE;
1163: X_Cancel_Allowed := FALSE;
1164: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 1164: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1160: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: X_Update_Allowed := FALSE;
1163: X_Cancel_Allowed := FALSE;
1164: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1165: P_Data => x_msg_Data);
1166:
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 1168: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1164: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1165: P_Data => x_msg_Data);
1166:
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: X_Update_Allowed := FALSE;
1171: X_Cancel_Allowed := FALSE;
1172: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 1172: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1168: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: X_Update_Allowed := FALSE;
1171: X_Cancel_Allowed := FALSE;
1172: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1173: P_Data => x_msg_Data);
1174:
1175: WHEN OTHERS THEN
1176: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);

Line 1177: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1173: P_Data => x_msg_Data);
1174:
1175: WHEN OTHERS THEN
1176: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);
1177: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: X_Update_Allowed := FALSE;
1180: X_Cancel_Allowed := FALSE;
1181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1177: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: X_Update_Allowed := FALSE;
1180: X_Cancel_Allowed := FALSE;
1181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1182: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1183: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1184: END IF;
1185: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 1182: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');

1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: X_Update_Allowed := FALSE;
1180: X_Cancel_Allowed := FALSE;
1181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1182: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1183: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1184: END IF;
1185: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1186: P_Data => x_msg_Data);

Line 1185: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1182: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1183: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1184: END IF;
1185: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1186: P_Data => x_msg_Data);
1187: End Is_IReq_Changable;
1188:
1189:

Line 1285: -- OE_MSG_PUB.set_msg_context();

1281: oe_debug_pub.add( ' Not a line level cancellation',5);
1282: END IF;
1283: END IF;
1284:
1285: -- OE_MSG_PUB.set_msg_context();
1286: -- No need to set the message context as the caller of this API is PO
1287: -- and Message window is not applicable in Requesting organization
1288:
1289: OE_msg_PUB.Initialize;

Line 1289: OE_msg_PUB.Initialize;

1285: -- OE_MSG_PUB.set_msg_context();
1286: -- No need to set the message context as the caller of this API is PO
1287: -- and Message window is not applicable in Requesting organization
1288:
1289: OE_msg_PUB.Initialize;
1290:
1291: l_return_status := FND_API.G_RET_STS_SUCCESS;
1292:
1293: IF (NOT P_Cancel_ISO AND NOT P_Cancel_ISO_Lines AND

Line 1311: OE_MSG_PUB.Add;

1307: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;
1308: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;
1309: END IF;
1310: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');
1311: OE_MSG_PUB.Add;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314:
1315: IF P_Mode NOT IN ('V','P') THEN

Line 1321: OE_MSG_PUB.Add;

1317: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;
1318: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);
1319: END IF;
1320: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');
1321: OE_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;
1323: END IF;
1324:
1325: IF P_internal_req_header_id is NULL THEN

Line 1344: OE_MSG_PUB.Add;

1340: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1341: END IF;
1342: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1343: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1344: OE_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: Exception
1348: When No_Data_Found Then

Line 1354: OE_MSG_PUB.Add;

1350: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1351: END IF;
1352: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1353: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1354: OE_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;
1356: End;
1357: ELSE
1358: l_req_hdr_id := P_internal_req_header_id;

Line 1442: OE_MSG_PUB.set_msg_context

1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add(' Cancel FULL Order request',5);
1440: END IF;
1441:
1442: OE_MSG_PUB.set_msg_context
1443: ( p_entity_code => 'HEADER'
1444: , p_entity_id => l_order_header_id
1445: , p_header_id => l_order_header_id
1446: , p_line_id => null

Line 1487: OE_MSG_PUB.Reset_Msg_Context('HEADER');

1483: , x_return_status => l_return_status );
1484:
1485:
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1490: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1491: RAISE FND_API.G_EXC_ERROR;

Line 1490: OE_MSG_PUB.Reset_Msg_Context('HEADER');

1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1487: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1490: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: IF P_Mode = 'P' THEN -- Mode is Process

Line 1511: OE_MSG_PUB.Reset_Msg_Context('HEADER');

1507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( ' CANCELLATION UNEXPECTED FAILURE',1 ) ;
1510: END IF;
1511: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;

Line 1517: OE_MSG_PUB.Reset_Msg_Context('HEADER');

1513: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;
1516: END IF;
1517: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520: END IF; -- P_Mode = PROCESS
1521:

Line 1525: OE_MSG_PUB.Reset_Msg_Context('HEADER');

1521:
1522: OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can := FALSE;
1523: -- Resetting the global to FALSE, as processing is done.
1524:
1525: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1526:
1527: ELSIF l_count_of_lines > l_cancel_eligble_lin THEN
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add(' Cancel REMAINING Order request',5);

Line 1701: OE_MSG_PUB.set_msg_context

1697: IF l_debug_level > 0 THEN
1698: oe_debug_pub.add( ' Before calling Process_Line_Entity', 5 ) ;
1699: END IF;
1700:
1701: OE_MSG_PUB.set_msg_context
1702: ( p_entity_code => 'LINE'
1703: , p_entity_id => l_line_ids_rec.line_id
1704: , p_header_id => l_line_ids_rec.header_id
1705: , p_line_id => l_line_ids_rec.line_id

Line 1721: OE_MSG_PUB.Reset_Msg_Context('LINE');

1717: , p_Cancel => l_cancel_request
1718: , x_return_status => l_return_status
1719: );
1720:
1721: OE_MSG_PUB.Reset_Msg_Context('LINE');
1722:
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add( ' After calling Process_Line_Entity'||l_return_status, 5 ) ;
1725: END IF;

Line 1736: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1732:
1733: x_return_status := l_return_status;
1734: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1735:
1736: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1737: P_Data => x_msg_Data);
1738:
1739: IF l_debug_level > 0 THEN
1740: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;

Line 1745: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1741: END IF;
1742:
1743: Exception
1744: WHEN FND_API.G_EXC_ERROR THEN
1745: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1748: P_Data => x_msg_Data);
1749: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change

Line 1747: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1743: Exception
1744: WHEN FND_API.G_EXC_ERROR THEN
1745: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1746: x_return_status := FND_API.G_RET_STS_ERROR;
1747: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1748: P_Data => x_msg_Data);
1749: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1750: ROLLBACK TO Call_Process_Order_for_IReq;
1751:

Line 1753: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1749: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1750: ROLLBACK TO Call_Process_Order_for_IReq;
1751:
1752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1753: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1755: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1756: P_Data => x_msg_Data);
1757: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change

Line 1755: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1751:
1752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1753: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1755: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1756: P_Data => x_msg_Data);
1757: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1758: ROLLBACK TO Call_Process_Order_for_IReq;
1759:

Line 1762: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

1758: ROLLBACK TO Call_Process_Order_for_IReq;
1759:
1760: WHEN OTHERS THEN
1761: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1762: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1766: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

Line 1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1760: WHEN OTHERS THEN
1761: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1762: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1766: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1767: END IF;
1768: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');

1761: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1762: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1766: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1767: END IF;
1768: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1769: P_Data => x_msg_Data);

Line 1768: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1766: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1767: END IF;
1768: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1769: P_Data => x_msg_Data);
1770: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1771: ROLLBACK TO Call_Process_Order_for_IReq;
1772: