44: END IF;
45:
46: Exception
47: when others then
48: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
49: THEN
50: OE_MSG_PUB.Add_Exc_Msg
51: (
52: G_PKG_NAME,
46: Exception
47: when others then
48: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
49: THEN
50: OE_MSG_PUB.Add_Exc_Msg
51: (
52: G_PKG_NAME,
53: 'Get_Cancelled_Status'
54: );
93: END IF;
94:
95: Exception
96: when others then
97: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
98: THEN
99: OE_MSG_PUB.Add_Exc_Msg
100: (
101: G_PKG_NAME,
95: Exception
96: when others then
97: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
98: THEN
99: OE_MSG_PUB.Add_Exc_Msg
100: (
101: G_PKG_NAME,
102: 'Get_Cancelled_Status'
103: );
143: END IF;
144:
145: Exception
146: when others then
147: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: OE_MSG_PUB.Add_Exc_Msg
150: (
151: G_PKG_NAME,
145: Exception
146: when others then
147: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: OE_MSG_PUB.Add_Exc_Msg
150: (
151: G_PKG_NAME,
152: 'Get_Closed_Status'
153: );
192: END IF;
193:
194: Exception
195: when others then
196: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: OE_MSG_PUB.Add_Exc_Msg
199: (
200: G_PKG_NAME,
194: Exception
195: when others then
196: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: OE_MSG_PUB.Add_Exc_Msg
199: (
200: G_PKG_NAME,
201: 'Get_Closed_Status'
202: );
229: Get_Purchase_Release_Status(p_line_id => p_line_id, x_result => x_result, x_result_date => l_result_date);
230:
231: Exception
232: when others then
233: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: OE_MSG_PUB.Add_Exc_Msg
236: (
237: G_PKG_NAME,
231: Exception
232: when others then
233: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: OE_MSG_PUB.Add_Exc_Msg
236: (
237: G_PKG_NAME,
238: 'Get_Purchase_Release_Status'
239: );
291: x_result_date := null;
292:
293:
294: WHEN OTHERS THEN
295: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: OE_MSG_PUB.Add_Exc_Msg
298: (
299: G_PKG_NAME,
293:
294: WHEN OTHERS THEN
295: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: OE_MSG_PUB.Add_Exc_Msg
298: (
299: G_PKG_NAME,
300: 'Get_Purchase_Release_Status'
301: );
342: END IF;
343:
344: Exception
345: when others then
346: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: OE_MSG_PUB.Add_Exc_Msg
349: (
350: G_PKG_NAME,
344: Exception
345: when others then
346: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
347: THEN
348: OE_MSG_PUB.Add_Exc_Msg
349: (
350: G_PKG_NAME,
351: 'Get_Ship_Status'
352: );
408:
409:
410: Exception
411: when others then
412: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: OE_MSG_PUB.Add_Exc_Msg
415: (
416: G_PKG_NAME,
410: Exception
411: when others then
412: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: OE_MSG_PUB.Add_Exc_Msg
415: (
416: G_PKG_NAME,
417: 'Get_Ship_Status'
418: );
459: -- and return N when line is not picked and P when the line is partially picked.
460:
461: Exception
462: when others then
463: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: OE_MSG_PUB.Add_Exc_Msg
466: (
467: G_PKG_NAME,
461: Exception
462: when others then
463: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: OE_MSG_PUB.Add_Exc_Msg
466: (
467: G_PKG_NAME,
468: 'Get_Pick_Status'
469: );
546: x_picked_quantity := l_picked_quantity;
547:
548: Exception
549: when others then
550: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN
552: OE_MSG_PUB.Add_Exc_Msg
553: (
554: G_PKG_NAME,
548: Exception
549: when others then
550: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN
552: OE_MSG_PUB.Add_Exc_Msg
553: (
554: G_PKG_NAME,
555: 'Get_Pick_Status'
556: );
594: END IF;
595:
596: Exception
597: when others then
598: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: OE_MSG_PUB.Add_Exc_Msg
601: (
602: G_PKG_NAME,
596: Exception
597: when others then
598: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: OE_MSG_PUB.Add_Exc_Msg
601: (
602: G_PKG_NAME,
603: 'Get_Received_Status'
604: );
643: END IF;
644:
645: Exception
646: when others then
647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
648: THEN
649: OE_MSG_PUB.Add_Exc_Msg
650: (
651: G_PKG_NAME,
645: Exception
646: when others then
647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
648: THEN
649: OE_MSG_PUB.Add_Exc_Msg
650: (
651: G_PKG_NAME,
652: 'Get_Received_Status'
653: );
692: END IF;
693:
694: Exception
695: when others then
696: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
697: THEN
698: OE_MSG_PUB.Add_Exc_Msg
699: (
700: G_PKG_NAME,
694: Exception
695: when others then
696: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
697: THEN
698: OE_MSG_PUB.Add_Exc_Msg
699: (
700: G_PKG_NAME,
701: 'Get_Invoiced_Status'
702: );
761: END IF;
762:
763: Exception
764: when others then
765: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
767: OE_MSG_PUB.Add_Exc_Msg
768: (
769: G_PKG_NAME,
763: Exception
764: when others then
765: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
766: THEN
767: OE_MSG_PUB.Add_Exc_Msg
768: (
769: G_PKG_NAME,
770: 'Get_Invoiced_Status'
771: );