100: x_result := l_s28;
101:
102: Exception
103: when others then
104: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
105: THEN
106: OE_MSG_PUB.Add_Exc_Msg
107: (
108: G_PKG_NAME,
102: Exception
103: when others then
104: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
105: THEN
106: OE_MSG_PUB.Add_Exc_Msg
107: (
108: G_PKG_NAME,
109: 'Get_Schedule_Status'
110: );
151: END IF;
152:
153: EXCEPTION
154: when others then
155: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: OE_MSG_PUB.Add_Exc_Msg
158: (
159: G_PKG_NAME,
153: EXCEPTION
154: when others then
155: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: OE_MSG_PUB.Add_Exc_Msg
158: (
159: G_PKG_NAME,
160: 'Get_Schedule_Status'
161: );
188: x_result := l_s27;
189:
190: EXCEPTION
191: when others then
192: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg
195: (
196: G_PKG_NAME,
190: EXCEPTION
191: when others then
192: IF OE_MSG_PUB.CHeck_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg
195: (
196: G_PKG_NAME,
197: 'Get_Cancelled_Status'
198: );