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 84: OE_MSG_PUB.Add;

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

Line 94: OE_MSG_PUB.Add;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 509: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 520: OE_MSG_PUB.Add_Exc_Msg

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

Line 590: -- OE_MSG_PUB.set_msg_context();

586: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
587: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
588: END IF;
589:
590: -- OE_MSG_PUB.set_msg_context();
591: -- No need to set the message context as the caller of this API is PO
592: -- and Message window is not applicable in Requesting organization
593:
594: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 602: OE_MSG_PUB.Add;

598: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
599: END IF;
600: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
601: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');
602: OE_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605: IF P_internal_req_header_id is NULL THEN
606: IF l_debug_level > 0 THEN

Line 620: OE_MSG_PUB.Add;

616: IF l_req_hdr_id IS NULL THEN
617: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
618: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
619: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
620: OE_MSG_PUB.Add;
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: Exception
624: When No_Data_Found Then

Line 628: OE_MSG_PUB.Add;

624: When No_Data_Found Then
625: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
626: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
627: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
628: OE_MSG_PUB.Add;
629: RAISE FND_API.G_EXC_ERROR;
630: End;
631: ELSE
632: l_req_hdr_id := P_internal_req_header_id;

Line 674: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

670: END IF;
671:
672: x_return_status := l_return_status;
673:
674: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
675: P_Count => x_msg_Count,
676: P_Data => x_msg_Data);
677:
678: IF l_debug_level > 0 THEN

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

684: oe_Debug_pub.setdebuglevel(0);
685:
686: Exception
687: WHEN FND_API.G_EXC_ERROR THEN
688: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
691: P_Count => x_msg_Count,
692: P_Data => x_msg_Data);

Line 690: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

686: Exception
687: WHEN FND_API.G_EXC_ERROR THEN
688: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
691: P_Count => x_msg_Count,
692: P_Data => x_msg_Data);
693: ROLLBACK TO Apply_Hold_For_IReq;
694:

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

697: oe_Debug_pub.setdebuglevel(0);
698: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
704: P_Count => x_msg_Count,
705: P_Data => x_msg_Data);

Line 703: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

699:
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
704: P_Count => x_msg_Count,
705: P_Data => x_msg_Data);
706: ROLLBACK TO Apply_Hold_For_IReq;
707:

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

711: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
712:
713: WHEN OTHERS THEN
714: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

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

713: WHEN OTHERS THEN
714: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
720: END IF;
721: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

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

714: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
720: END IF;
721: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
722: P_Count => x_msg_Count,

Line 721: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
720: END IF;
721: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
722: P_Count => x_msg_Count,
723: P_Data => x_msg_Data);
724: ROLLBACK TO Apply_Hold_For_IReq;
725:

Line 795: -- OE_MSG_PUB.set_msg_context();

791: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
792: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
793: END IF;
794:
795: -- OE_MSG_PUB.set_msg_context();
796: -- No need to set the message context as the caller of this API is PO
797: -- and Message window is not applicable in Requesting organization
798:
799: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 807: OE_MSG_PUB.Add;

803: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
804: END IF;
805: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
806: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
807: OE_MSG_PUB.Add;
808: RAISE FND_API.G_EXC_ERROR;
809: END IF;
810: IF P_internal_req_header_id is NULL THEN
811: IF l_debug_level > 0 THEN

Line 825: OE_MSG_PUB.Add;

821: IF l_req_hdr_id IS NULL THEN
822: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
823: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
824: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
825: OE_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828: Exception
829: When No_Data_Found Then

Line 833: OE_MSG_PUB.Add;

829: When No_Data_Found Then
830: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
831: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
832: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
833: OE_MSG_PUB.Add;
834: RAISE FND_API.G_EXC_ERROR;
835: End;
836: ELSE
837: l_req_hdr_id := P_internal_req_header_id;

Line 896: OE_MSG_PUB.Add;

892: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');
893: END IF;
894: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');
895: -- There is no sales order line shipment on hold.
896: OE_MSG_PUB.Add;
897: X_return_status := FND_API.G_RET_STS_ERROR;
898:
899: When Too_Many_Rows Then
900: IF l_debug_level > 0 THEN

Line 905: OE_MSG_PUB.Add;

901: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;
902: END IF;
903: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');
904: -- There are many sales order line shipments eligible for hold release. This is not allowed.
905: OE_MSG_PUB.Add;
906: X_return_status := FND_API.G_RET_STS_ERROR;
907: End;
908:
909: -- OE_MSG_PUB.Reset_Msg_Context('LINE');

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

905: OE_MSG_PUB.Add;
906: X_return_status := FND_API.G_RET_STS_ERROR;
907: End;
908:
909: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
910: -- Not resetting the message because it was never initialized
911: -- Same is the case in Exception block
912:
913: x_return_status := l_return_status;

Line 915: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

911: -- Same is the case in Exception block
912:
913: x_return_status := l_return_status;
914:
915: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
916: P_Count => x_msg_Count,
917: P_Data => x_msg_Data);
918:
919: IF l_debug_level > 0 THEN

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

926:
927:
928: Exception
929: WHEN FND_API.G_EXC_ERROR THEN
930: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
933: P_Count => x_msg_Count,
934: P_Data => x_msg_Data);

Line 932: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

928: Exception
929: WHEN FND_API.G_EXC_ERROR THEN
930: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
933: P_Count => x_msg_Count,
934: P_Data => x_msg_Data);
935: ROLLBACK TO Release_Hold_For_IReq;
936:

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

940: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
941:
942:
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
947: P_Count => x_msg_Count,
948: P_Data => x_msg_Data);

Line 946: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

942:
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
947: P_Count => x_msg_Count,
948: P_Data => x_msg_Data);
949: ROLLBACK TO Release_Hold_For_IReq;
950:

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

954: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
955:
956: WHEN OTHERS THEN
957: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

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

956: WHEN OTHERS THEN
957: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
963: END IF;
964: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

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

957: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
963: END IF;
964: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
965: P_Count => x_msg_Count,

Line 964: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
963: END IF;
964: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
965: P_Count => x_msg_Count,
966: P_Data => x_msg_Data);
967: ROLLBACK TO Release_Hold_For_IReq;
968:

Line 1053: -- OE_MSG_PUB.set_msg_context();

1049: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
1050: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
1051: END IF;
1052:
1053: -- OE_MSG_PUB.set_msg_context();
1054: -- No need to set the message context as the caller of this API is PO
1055: -- and Message window is not applicable in Requesting organization
1056:
1057: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1066: OE_MSG_PUB.Add;

1062: IF l_debug_level > 0 THEN
1063: oe_debug_pub.add( ' Invalid value for Requisition Header/Line',1);
1064: END IF;
1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_INFO');
1066: OE_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068: END IF;
1069:
1070: IF P_internal_req_header_id is NOT NULL AND P_internal_req_line_id is NULL THEN

Line 1158: OE_MSG_PUB.Add;

1154: oe_debug_pub.add( ' Invalid value for Requisition Header',1);
1155: END IF;
1156: X_Cancel_Allowed := FALSE;
1157: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1158: OE_MSG_PUB.Add;
1159: RAISE FND_API.G_EXC_ERROR;
1160: End;
1161: END IF;
1162:

Line 1178: OE_MSG_PUB.Add;

1174: IF l_req_hdr_id IS NULL THEN
1175: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1176: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1177: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1178: OE_MSG_PUB.Add;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: Exception
1182: When No_Data_Found Then

Line 1186: OE_MSG_PUB.Add;

1182: When No_Data_Found Then
1183: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1184: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1185: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1186: OE_MSG_PUB.Add;
1187: RAISE FND_API.G_EXC_ERROR;
1188: End;
1189: ELSE
1190: l_req_hdr_id := P_internal_req_header_id;

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

1240: END IF;
1241: END IF;
1242: END IF;
1243:
1244: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1245: -- Not resetting the message because it was never initialized
1246: -- Same is the case in Exception block
1247:
1248: <>

Line 1262: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1258: END IF;
1259:
1260: x_return_status := l_return_status;
1261:
1262: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1263: P_Count => x_msg_Count,
1264: P_Data => x_msg_Data);
1265:
1266: IF l_debug_level > 0 THEN

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

1272: oe_Debug_pub.setdebuglevel(0);
1273:
1274: Exception
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: X_Update_Allowed := FALSE;
1279: X_Cancel_Allowed := FALSE;
1280: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

Line 1280: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1276: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: X_Update_Allowed := FALSE;
1279: X_Cancel_Allowed := FALSE;
1280: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1281: P_Count => x_msg_Count,
1282: P_Data => x_msg_Data);
1283:
1284: -- Added for 8583903

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

1285: oe_debug_pub.debug_off;
1286: oe_Debug_pub.setdebuglevel(0);
1287:
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1289: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: X_Update_Allowed := FALSE;
1292: X_Cancel_Allowed := FALSE;
1293: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

Line 1293: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1289: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: X_Update_Allowed := FALSE;
1292: X_Cancel_Allowed := FALSE;
1293: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1294: P_Count => x_msg_Count,
1295: P_Data => x_msg_Data);
1296:
1297: -- Added 8583903

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

1299: oe_Debug_pub.setdebuglevel(0);
1300:
1301: WHEN OTHERS THEN
1302: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);
1303: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: X_Update_Allowed := FALSE;
1306: X_Cancel_Allowed := FALSE;
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1303: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: X_Update_Allowed := FALSE;
1306: X_Cancel_Allowed := FALSE;
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1308: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1309: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1310: END IF;
1311: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

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

1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: X_Update_Allowed := FALSE;
1306: X_Cancel_Allowed := FALSE;
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1308: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1309: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1310: END IF;
1311: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1312: P_Count => x_msg_Count,

Line 1311: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1308: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1309: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1310: END IF;
1311: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1312: P_Count => x_msg_Count,
1313: P_Data => x_msg_Data);
1314:
1315: -- Added for 8583903

Line 1436: -- OE_MSG_PUB.set_msg_context();

1432: oe_debug_pub.add( ' Not a line level cancellation',5);
1433: END IF;
1434: END IF;
1435:
1436: -- OE_MSG_PUB.set_msg_context();
1437: -- No need to set the message context as the caller of this API is PO
1438: -- and Message window is not applicable in Requesting organization
1439:
1440: OE_msg_PUB.Initialize;

Line 1440: OE_msg_PUB.Initialize;

1436: -- OE_MSG_PUB.set_msg_context();
1437: -- No need to set the message context as the caller of this API is PO
1438: -- and Message window is not applicable in Requesting organization
1439:
1440: OE_msg_PUB.Initialize;
1441:
1442: l_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: IF (NOT P_Cancel_ISO AND NOT P_Cancel_ISO_Lines AND

Line 1462: OE_MSG_PUB.Add;

1458: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;
1459: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;
1460: END IF;
1461: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');
1462: OE_MSG_PUB.Add;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: IF P_Mode NOT IN ('V','P') THEN

Line 1472: OE_MSG_PUB.Add;

1468: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;
1469: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);
1470: END IF;
1471: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');
1472: OE_MSG_PUB.Add;
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475:
1476: IF P_internal_req_header_id is NULL THEN

Line 1495: OE_MSG_PUB.Add;

1491: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1492: END IF;
1493: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1494: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1495: OE_MSG_PUB.Add;
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498: Exception
1499: When No_Data_Found Then

Line 1505: OE_MSG_PUB.Add;

1501: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1502: END IF;
1503: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1504: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1505: OE_MSG_PUB.Add;
1506: RAISE FND_API.G_EXC_ERROR;
1507: End;
1508: ELSE
1509: l_req_hdr_id := P_internal_req_header_id;

Line 1593: OE_MSG_PUB.set_msg_context

1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add(' Cancel FULL Order request',5);
1591: END IF;
1592:
1593: OE_MSG_PUB.set_msg_context
1594: ( p_entity_code => 'HEADER'
1595: , p_entity_id => l_order_header_id
1596: , p_header_id => l_order_header_id
1597: , p_line_id => null

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

1634: , x_return_status => l_return_status );
1635:
1636:
1637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1638: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1641: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1642: RAISE FND_API.G_EXC_ERROR;

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

1637: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1638: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1641: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: IF P_Mode = 'P' THEN -- Mode is Process

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

1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1659: IF l_debug_level > 0 THEN
1660: oe_debug_pub.add( ' CANCELLATION UNEXPECTED FAILURE',1 ) ;
1661: END IF;
1662: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;

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

1664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;
1667: END IF;
1668: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;
1671: END IF; -- P_Mode = PROCESS
1672:

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

1672:
1673: OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can := FALSE;
1674: -- Resetting the global to FALSE, as processing is done.
1675:
1676: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1677:
1678: ELSIF l_count_of_lines > l_cancel_eligble_lin THEN
1679: IF l_debug_level > 0 THEN
1680: oe_debug_pub.add(' Cancel REMAINING Order request',5);

Line 1852: OE_MSG_PUB.set_msg_context

1848: IF l_debug_level > 0 THEN
1849: oe_debug_pub.add( ' Before calling Process_Line_Entity', 5 ) ;
1850: END IF;
1851:
1852: OE_MSG_PUB.set_msg_context
1853: ( p_entity_code => 'LINE'
1854: , p_entity_id => l_line_ids_rec.line_id
1855: , p_header_id => l_line_ids_rec.header_id
1856: , p_line_id => l_line_ids_rec.line_id

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

1868: , p_Cancel => l_cancel_request
1869: , x_return_status => l_return_status
1870: );
1871:
1872: OE_MSG_PUB.Reset_Msg_Context('LINE');
1873:
1874: IF l_debug_level > 0 THEN
1875: oe_debug_pub.add( ' After calling Process_Line_Entity'||l_return_status, 5 ) ;
1876: END IF;

Line 1887: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1883:
1884: x_return_status := l_return_status;
1885: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1886:
1887: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1888: P_Count => x_msg_Count,
1889: P_Data => x_msg_Data);
1890:
1891: IF l_debug_level > 0 THEN

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

1897: oe_Debug_pub.setdebuglevel(0);
1898:
1899: Exception
1900: WHEN FND_API.G_EXC_ERROR THEN
1901: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1902: x_return_status := FND_API.G_RET_STS_ERROR;
1903: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1904: P_Count => x_msg_Count,
1905: P_Data => x_msg_Data);

Line 1903: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1899: Exception
1900: WHEN FND_API.G_EXC_ERROR THEN
1901: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1902: x_return_status := FND_API.G_RET_STS_ERROR;
1903: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1904: P_Count => x_msg_Count,
1905: P_Data => x_msg_Data);
1906: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1907: ROLLBACK TO Call_Process_Order_for_IReq;

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

1910: oe_debug_pub.debug_off;
1911: oe_Debug_pub.setdebuglevel(0);
1912:
1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1914: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1916: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1917: P_Count => x_msg_Count,
1918: P_Data => x_msg_Data);

Line 1916: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1912:
1913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1914: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1916: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1917: P_Count => x_msg_Count,
1918: P_Data => x_msg_Data);
1919: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1920: ROLLBACK TO Call_Process_Order_for_IReq;

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

1924: oe_Debug_pub.setdebuglevel(0);
1925:
1926: WHEN OTHERS THEN
1927: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1928: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

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

1926: WHEN OTHERS THEN
1927: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1928: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1933: END IF;
1934: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

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

1927: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1928: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1933: END IF;
1934: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1935: P_Count => x_msg_Count,

Line 1934: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154

1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1933: END IF;
1934: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1935: P_Count => x_msg_Count,
1936: P_Data => x_msg_Data);
1937: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1938: ROLLBACK TO Call_Process_Order_for_IReq;