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.OKE_DEFAULTING_PKG dependencies on OKE_API

Line 66: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

62: l_del_rec oke_deliverable_pvt.del_rec_type;
63: l_del_tbl oke_deliverable_pvt.del_tbl_type;
64: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DELIVERABLES';
65:
66: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
67: l_buy_or_sell VARCHAR2(1);
68: l_direction VARCHAR2(3);
69:
70: L_Inventory_Org_ID NUMBER;

Line 89: l_return_status := OKE_API.START_ACTIVITY(

85:
86: -- call START_ACTIVITY to create savepoint, check compatibility
87: -- and initialize message list
88:
89: l_return_status := OKE_API.START_ACTIVITY(
90: p_api_name => l_api_name,
91: p_init_msg_list => p_init_msg_list,
92: p_api_type => g_api_type,
93: x_return_status => l_return_status);

Line 96: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

92: p_api_type => g_api_type,
93: x_return_status => l_return_status);
94:
95:
96: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
97: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
99: raise OKE_API.G_EXCEPTION_ERROR;
100: End If;

Line 97: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

93: x_return_status => l_return_status);
94:
95:
96: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
97: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
99: raise OKE_API.G_EXCEPTION_ERROR;
100: End If;
101:

Line 98: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

94:
95:
96: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
97: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
99: raise OKE_API.G_EXCEPTION_ERROR;
100: End If;
101:
102: --

Line 99: raise OKE_API.G_EXCEPTION_ERROR;

95:
96: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
97: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
98: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
99: raise OKE_API.G_EXCEPTION_ERROR;
100: End If;
101:
102: --
103: -- Fetch buy_or_sell to determine defaulted direction for deliverables

Line 131: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

127: , X_Counter => X_Counter);
128:
129:
130:
131: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
132: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
134: raise OKE_API.G_EXCEPTION_ERROR;
135: End If;

Line 132: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

128:
129:
130:
131: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
132: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
134: raise OKE_API.G_EXCEPTION_ERROR;
135: End If;
136:

Line 133: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

129:
130:
131: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
132: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
134: raise OKE_API.G_EXCEPTION_ERROR;
135: End If;
136:
137:

Line 134: raise OKE_API.G_EXCEPTION_ERROR;

130:
131: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
132: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
133: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
134: raise OKE_API.G_EXCEPTION_ERROR;
135: End If;
136:
137:
138:

Line 150: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

146: , P_Direction => L_Direction
147: , P_Inventory_Org_ID => L_Inventory_Org_ID
148: , X_Counter => X_Counter);
149:
150: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
151: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
153: raise OKE_API.G_EXCEPTION_ERROR;
154: End If;

Line 151: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

147: , P_Inventory_Org_ID => L_Inventory_Org_ID
148: , X_Counter => X_Counter);
149:
150: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
151: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
153: raise OKE_API.G_EXCEPTION_ERROR;
154: End If;
155:

Line 152: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

148: , X_Counter => X_Counter);
149:
150: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
151: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
153: raise OKE_API.G_EXCEPTION_ERROR;
154: End If;
155:
156: END IF;

Line 153: raise OKE_API.G_EXCEPTION_ERROR;

149:
150: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
151: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
153: raise OKE_API.G_EXCEPTION_ERROR;
154: End If;
155:
156: END IF;
157:

Line 173: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

169: , P_Direction => L_Direction
170: , P_Inventory_Org_ID => L_Inventory_Org_ID
171: , X_Counter => X_Counter);
172:
173: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
174: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
176: raise OKE_API.G_EXCEPTION_ERROR;
177: End If;

Line 174: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

170: , P_Inventory_Org_ID => L_Inventory_Org_ID
171: , X_Counter => X_Counter);
172:
173: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
174: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
176: raise OKE_API.G_EXCEPTION_ERROR;
177: End If;
178:

Line 175: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

171: , X_Counter => X_Counter);
172:
173: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
174: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
176: raise OKE_API.G_EXCEPTION_ERROR;
177: End If;
178:
179: ELSE /* Header batch re-defaulting */

Line 176: raise OKE_API.G_EXCEPTION_ERROR;

172:
173: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
174: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
176: raise OKE_API.G_EXCEPTION_ERROR;
177: End If;
178:
179: ELSE /* Header batch re-defaulting */
180:

Line 192: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

188: , P_Direction => L_Direction
189: , P_Inventory_Org_ID => L_Inventory_Org_ID
190: , X_Counter => L_Counter);
191:
192: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
193: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
195: raise OKE_API.G_EXCEPTION_ERROR;
196: End If;

Line 193: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

189: , P_Inventory_Org_ID => L_Inventory_Org_ID
190: , X_Counter => L_Counter);
191:
192: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
193: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
195: raise OKE_API.G_EXCEPTION_ERROR;
196: End If;
197:

Line 194: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

190: , X_Counter => L_Counter);
191:
192: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
193: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
195: raise OKE_API.G_EXCEPTION_ERROR;
196: End If;
197:
198:

Line 195: raise OKE_API.G_EXCEPTION_ERROR;

191:
192: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
193: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
195: raise OKE_API.G_EXCEPTION_ERROR;
196: End If;
197:
198:
199:

Line 211: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

207: , P_Direction => L_Direction
208: , P_Inventory_Org_ID => L_Inventory_Org_ID
209: , X_Counter => L_Counter);
210:
211: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
212: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
214: raise OKE_API.G_EXCEPTION_ERROR;
215: End If;

Line 212: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

208: , P_Inventory_Org_ID => L_Inventory_Org_ID
209: , X_Counter => L_Counter);
210:
211: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
212: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
214: raise OKE_API.G_EXCEPTION_ERROR;
215: End If;
216:

Line 213: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

209: , X_Counter => L_Counter);
210:
211: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
212: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
214: raise OKE_API.G_EXCEPTION_ERROR;
215: End If;
216:
217: L_Total_Counter := L_Total_Counter + L_Counter;

Line 214: raise OKE_API.G_EXCEPTION_ERROR;

210:
211: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
212: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
214: raise OKE_API.G_EXCEPTION_ERROR;
215: End If;
216:
217: L_Total_Counter := L_Total_Counter + L_Counter;
218:

Line 228: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

224:
225: X_Return_Status := L_Return_Status;
226:
227: -- end activity
228: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKE_API.G_EXCEPTION_ERROR then
232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 231: when OKE_API.G_EXCEPTION_ERROR then

227: -- end activity
228: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKE_API.G_EXCEPTION_ERROR then
232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

228: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data);
230: EXCEPTION
231: when OKE_API.G_EXCEPTION_ERROR then
232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,

Line 235: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

231: when OKE_API.G_EXCEPTION_ERROR then
232: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
233: p_api_name => l_api_name,
234: p_pkg_name => g_pkg_name,
235: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:

Line 240: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:
240: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 241: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

237: x_msg_data => x_msg_data,
238: p_api_type => g_api_type);
239:
240: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count => x_msg_count,

Line 244: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

240: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
241: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
242: p_api_name => l_api_name,
243: p_pkg_name => g_pkg_name,
244: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
245: x_msg_count => x_msg_count,
246: x_msg_data => x_msg_data,
247: p_api_type => g_api_type);
248:

Line 250: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

246: x_msg_data => x_msg_data,
247: p_api_type => g_api_type);
248:
249: when OTHERS then
250: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
251: p_api_name => l_api_name,
252: p_pkg_name => g_pkg_name,
253: p_exc_name => 'OTHERS',
254: x_msg_count => x_msg_count,

Line 928: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

924: , X_Counter OUT NOCOPY NUMBER) IS
925:
926: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
927: L_Api_Version CONSTANT NUMBER := 1;
928: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
929: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
930: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
931: L_Ship_From_Org_ID NUMBER;
932: L_Ship_From_Location_ID NUMBER;

Line 991: l_return_status := OKE_API.START_ACTIVITY(

987: New_L_Rec New_L_C%ROWTYPE;
988:
989: BEGIN
990:
991: l_return_status := OKE_API.START_ACTIVITY(
992: p_api_name => l_api_name,
993: p_init_msg_list => p_initiate_msg_list,
994: p_api_type => g_api_type,
995: x_return_status => l_return_status);

Line 998: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

994: p_api_type => g_api_type,
995: x_return_status => l_return_status);
996:
997:
998: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
999: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1001: raise OKE_API.G_EXCEPTION_ERROR;
1002: End If;

Line 999: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

995: x_return_status => l_return_status);
996:
997:
998: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
999: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1001: raise OKE_API.G_EXCEPTION_ERROR;
1002: End If;
1003:

Line 1000: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

996:
997:
998: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
999: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1001: raise OKE_API.G_EXCEPTION_ERROR;
1002: End If;
1003:
1004: OPEN New_L_C(P_Line_ID);

Line 1001: raise OKE_API.G_EXCEPTION_ERROR;

997:
998: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
999: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1000: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1001: raise OKE_API.G_EXCEPTION_ERROR;
1002: End If;
1003:
1004: OPEN New_L_C(P_Line_ID);
1005: FETCH New_L_C INTO New_L_Rec;

Line 1116: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1112: p_del_rec => l_del_rec,
1113: x_del_rec => x_del_rec);
1114:
1115:
1116: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1117: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1119: raise OKE_API.G_EXCEPTION_ERROR;
1120: End If;

Line 1117: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1113: x_del_rec => x_del_rec);
1114:
1115:
1116: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1117: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1119: raise OKE_API.G_EXCEPTION_ERROR;
1120: End If;
1121:

Line 1118: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1114:
1115:
1116: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1117: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1119: raise OKE_API.G_EXCEPTION_ERROR;
1120: End If;
1121:
1122: X_Counter := 1;

Line 1119: raise OKE_API.G_EXCEPTION_ERROR;

1115:
1116: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1117: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1118: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1119: raise OKE_API.G_EXCEPTION_ERROR;
1120: End If;
1121:
1122: X_Counter := 1;
1123: X_Return_Status := L_Return_Status;

Line 1126: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

1122: X_Counter := 1;
1123: X_Return_Status := L_Return_Status;
1124:
1125: -- end activity
1126: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data);
1128:
1129: EXCEPTION
1130: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1130: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1126: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1127: x_msg_data => x_msg_data);
1128:
1129: EXCEPTION
1130: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1131:
1132: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,

Line 1132: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1128:
1129: EXCEPTION
1130: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1131:
1132: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKE_API.G_RET_STS_ERROR',

Line 1136: 'OKE_API.G_RET_STS_ERROR',

1132: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKE_API.G_RET_STS_ERROR',
1137: x_msg_count,
1138: x_msg_data,
1139: g_api_type
1140: );

Line 1141: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1137: x_msg_count,
1138: x_msg_data,
1139: g_api_type
1140: );
1141: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142:
1143: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1144: (
1145: l_api_name,

Line 1143: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1139: g_api_type
1140: );
1141: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142:
1143: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1144: (
1145: l_api_name,
1146: G_PKG_NAME,
1147: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1147: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1143: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1144: (
1145: l_api_name,
1146: G_PKG_NAME,
1147: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1148: x_msg_count,
1149: x_msg_data,
1150: g_api_type
1151: );

Line 1154: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1150: g_api_type
1151: );
1152: WHEN OTHERS THEN
1153:
1154: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1155: (
1156: l_api_name,
1157: G_PKG_NAME,
1158: 'OTHERS',

Line 1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1173: , X_Counter OUT NOCOPY NUMBER) IS
1174:
1175: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1176: L_Api_Verson CONSTANT NUMBER := 1;
1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1233: l_return_status := OKE_API.START_ACTIVITY(

1229:
1230:
1231: BEGIN
1232:
1233: l_return_status := OKE_API.START_ACTIVITY(
1234: p_api_name => l_api_name,
1235: p_init_msg_list => p_init_msg_list,
1236: p_api_type => g_api_type,
1237: x_return_status => l_return_status);

Line 1239: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1235: p_init_msg_list => p_init_msg_list,
1236: p_api_type => g_api_type,
1237: x_return_status => l_return_status);
1238:
1239: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1242: raise OKE_API.G_EXCEPTION_ERROR;
1243: End If;

Line 1240: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1236: p_api_type => g_api_type,
1237: x_return_status => l_return_status);
1238:
1239: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1242: raise OKE_API.G_EXCEPTION_ERROR;
1243: End If;
1244:

Line 1241: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1237: x_return_status => l_return_status);
1238:
1239: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1242: raise OKE_API.G_EXCEPTION_ERROR;
1243: End If;
1244:
1245: L_Counter := 0;

Line 1242: raise OKE_API.G_EXCEPTION_ERROR;

1238:
1239: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1240: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1242: raise OKE_API.G_EXCEPTION_ERROR;
1243: End If;
1244:
1245: L_Counter := 0;
1246:

Line 1260: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN

1256: , P_Direction => P_Direction
1257: , P_Inventory_Org_ID => P_Inventory_Org_ID
1258: , X_Counter => X_Counter);
1259:
1260: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1261: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1262: L_Return_Status := X_Return_Status;
1263: END IF;
1264: END IF;

Line 1261: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN

1257: , P_Inventory_Org_ID => P_Inventory_Org_ID
1258: , X_Counter => X_Counter);
1259:
1260: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1261: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1262: L_Return_Status := X_Return_Status;
1263: END IF;
1264: END IF;
1265:

Line 1274: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

1270: X_Return_Status := L_Return_Status;
1271: X_Counter := L_Counter;
1272:
1273: -- end activity
1274: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1275: x_msg_data => x_msg_data);
1276:
1277:
1278: EXCEPTION

Line 1279: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1275: x_msg_data => x_msg_data);
1276:
1277:
1278: EXCEPTION
1279: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1280:
1281: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,

Line 1281: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1277:
1278: EXCEPTION
1279: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1280:
1281: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,
1285: 'OKE_API.G_RET_STS_ERROR',

Line 1285: 'OKE_API.G_RET_STS_ERROR',

1281: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,
1285: 'OKE_API.G_RET_STS_ERROR',
1286: x_msg_count,
1287: x_msg_data,
1288: g_api_type
1289: );

Line 1290: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1286: x_msg_count,
1287: x_msg_data,
1288: g_api_type
1289: );
1290: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1291:
1292: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,

Line 1292: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1288: g_api_type
1289: );
1290: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1291:
1292: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1296: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1292: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: g_api_type
1300: );

Line 1303: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1299: g_api_type
1300: );
1301: WHEN OTHERS THEN
1302:
1303: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OTHERS',

Line 1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1323: , X_Counter OUT NOCOPY NUMBER) IS
1324:
1325: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1326: L_Api_Version CONSTANT NUMBER := 1;
1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1391: l_return_status := OKE_API.START_ACTIVITY(

1387: Update_L_Rec Update_L_C%ROWTYPE;
1388:
1389: BEGIN
1390:
1391: l_return_status := OKE_API.START_ACTIVITY(
1392: p_api_name => l_api_name,
1393: p_init_msg_list => p_init_msg_list,
1394: p_api_type => g_api_type,
1395: x_return_status => l_return_status);

Line 1491: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1487: p_del_rec => l_del_rec,
1488: x_del_rec => x_del_rec);
1489:
1490:
1491: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1492: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1494: raise OKE_API.G_EXCEPTION_ERROR;
1495: End If;

Line 1492: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1488: x_del_rec => x_del_rec);
1489:
1490:
1491: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1492: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1494: raise OKE_API.G_EXCEPTION_ERROR;
1495: End If;
1496:

Line 1493: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1489:
1490:
1491: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1492: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1494: raise OKE_API.G_EXCEPTION_ERROR;
1495: End If;
1496:
1497: -- If planning is initiated, update MDS as well

Line 1494: raise OKE_API.G_EXCEPTION_ERROR;

1490:
1491: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1492: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1493: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1494: raise OKE_API.G_EXCEPTION_ERROR;
1495: End If;
1496:
1497: -- If planning is initiated, update MDS as well
1498:

Line 1510: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1506: , X_Return_Status => L_Return_Status);
1507:
1508: END IF;
1509:
1510: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1511: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1512: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1513: raise OKE_API.G_EXCEPTION_ERROR;
1514: End If; */

Line 1511: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1507:
1508: END IF;
1509:
1510: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1511: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1512: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1513: raise OKE_API.G_EXCEPTION_ERROR;
1514: End If; */
1515:

Line 1512: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1508: END IF;
1509:
1510: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1511: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1512: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1513: raise OKE_API.G_EXCEPTION_ERROR;
1514: End If; */
1515:
1516: X_Return_Status := L_Return_Status;

Line 1513: raise OKE_API.G_EXCEPTION_ERROR;

1509:
1510: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1511: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1512: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1513: raise OKE_API.G_EXCEPTION_ERROR;
1514: End If; */
1515:
1516: X_Return_Status := L_Return_Status;
1517: X_Counter := 1;

Line 1520: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

1516: X_Return_Status := L_Return_Status;
1517: X_Counter := 1;
1518:
1519: -- end activity
1520: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data);
1522: EXCEPTION
1523: when OKE_API.G_EXCEPTION_ERROR then
1524: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1523: when OKE_API.G_EXCEPTION_ERROR then

1519: -- end activity
1520: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data);
1522: EXCEPTION
1523: when OKE_API.G_EXCEPTION_ERROR then
1524: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1525: p_api_name => l_api_name,
1526: p_pkg_name => g_pkg_name,
1527: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1524: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1520: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data);
1522: EXCEPTION
1523: when OKE_API.G_EXCEPTION_ERROR then
1524: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1525: p_api_name => l_api_name,
1526: p_pkg_name => g_pkg_name,
1527: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1528: x_msg_count => x_msg_count,

Line 1527: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

1523: when OKE_API.G_EXCEPTION_ERROR then
1524: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1525: p_api_name => l_api_name,
1526: p_pkg_name => g_pkg_name,
1527: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1528: x_msg_count => x_msg_count,
1529: x_msg_data => x_msg_data,
1530: p_api_type => g_api_type);
1531:

Line 1532: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1528: x_msg_count => x_msg_count,
1529: x_msg_data => x_msg_data,
1530: p_api_type => g_api_type);
1531:
1532: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1533: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1534: p_api_name => l_api_name,
1535: p_pkg_name => g_pkg_name,
1536: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1533: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1529: x_msg_data => x_msg_data,
1530: p_api_type => g_api_type);
1531:
1532: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1533: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1534: p_api_name => l_api_name,
1535: p_pkg_name => g_pkg_name,
1536: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1537: x_msg_count => x_msg_count,

Line 1536: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

1532: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1533: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1534: p_api_name => l_api_name,
1535: p_pkg_name => g_pkg_name,
1536: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1537: x_msg_count => x_msg_count,
1538: x_msg_data => x_msg_data,
1539: p_api_type => g_api_type);
1540:

Line 1542: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1538: x_msg_data => x_msg_data,
1539: p_api_type => g_api_type);
1540:
1541: when OTHERS then
1542: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1543: p_api_name => l_api_name,
1544: p_pkg_name => g_pkg_name,
1545: p_exc_name => 'OTHERS',
1546: x_msg_count => x_msg_count,

Line 1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

1559: , X_Counter OUT NOCOPY NUMBER) IS
1560:
1561: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1562: L_Api_Verson CONSTANT NUMBER := 1;
1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1612: l_return_status := OKE_API.START_ACTIVITY(

1608: HAVING count(*)=1;
1609:
1610: BEGIN
1611:
1612: l_return_status := OKE_API.START_ACTIVITY(
1613: p_api_name => l_api_name,
1614: p_init_msg_list => p_init_msg_list,
1615: p_api_type => g_api_type,
1616: x_return_status => l_return_status);

Line 1618: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

1614: p_init_msg_list => p_init_msg_list,
1615: p_api_type => g_api_type,
1616: x_return_status => l_return_status);
1617:
1618: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1619: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1621: raise OKE_API.G_EXCEPTION_ERROR;
1622: End If;

Line 1619: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1615: p_api_type => g_api_type,
1616: x_return_status => l_return_status);
1617:
1618: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1619: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1621: raise OKE_API.G_EXCEPTION_ERROR;
1622: End If;
1623:

Line 1620: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

1616: x_return_status => l_return_status);
1617:
1618: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1619: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1621: raise OKE_API.G_EXCEPTION_ERROR;
1622: End If;
1623:
1624: L_Counter := 0;

Line 1621: raise OKE_API.G_EXCEPTION_ERROR;

1617:
1618: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1619: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1620: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1621: raise OKE_API.G_EXCEPTION_ERROR;
1622: End If;
1623:
1624: L_Counter := 0;
1625:

Line 1649: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN

1645: , P_Direction => P_Direction
1646: , P_Inventory_Org_ID => P_Inventory_Org_ID
1647: , X_Counter => X_Counter);
1648:
1649: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1650: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1651: L_Return_Status := X_Return_Status;
1652: END IF;
1653: ELSE

Line 1650: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN

1646: , P_Inventory_Org_ID => P_Inventory_Org_ID
1647: , X_Counter => X_Counter);
1648:
1649: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1650: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1651: L_Return_Status := X_Return_Status;
1652: END IF;
1653: ELSE
1654: UPDATE oke_k_lines

Line 1836: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,

1832: X_Return_Status := L_Return_Status;
1833: X_Counter := L_Counter;
1834:
1835: -- end activity
1836: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1837: x_msg_data => x_msg_data);
1838:
1839: EXCEPTION
1840: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1840: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1836: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1837: x_msg_data => x_msg_data);
1838:
1839: EXCEPTION
1840: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1841:
1842: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1843: (
1844: l_api_name,

Line 1842: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1838:
1839: EXCEPTION
1840: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1841:
1842: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1843: (
1844: l_api_name,
1845: G_PKG_NAME,
1846: 'OKE_API.G_RET_STS_ERROR',

Line 1846: 'OKE_API.G_RET_STS_ERROR',

1842: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1843: (
1844: l_api_name,
1845: G_PKG_NAME,
1846: 'OKE_API.G_RET_STS_ERROR',
1847: x_msg_count,
1848: x_msg_data,
1849: g_api_type
1850: );

Line 1851: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1847: x_msg_count,
1848: x_msg_data,
1849: g_api_type
1850: );
1851: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1852:
1853: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,

Line 1853: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1849: g_api_type
1850: );
1851: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1852:
1853: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1857: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1853: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1858: x_msg_count,
1859: x_msg_data,
1860: g_api_type
1861: );

Line 1864: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1860: g_api_type
1861: );
1862: WHEN OTHERS THEN
1863:
1864: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1865: (
1866: l_api_name,
1867: G_PKG_NAME,
1868: 'OTHERS',

Line 1984: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_NOT_VALID', 'TOKEN1', L_Line_Number, 'TOKEN2', L_Msg);

1980: END IF;
1981:
1982: IF L_Msg IS NOT NULL THEN
1983:
1984: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_NOT_VALID', 'TOKEN1', L_Line_Number, 'TOKEN2', L_Msg);
1985:
1986: -- FND_MESSAGE.Set_Name('OKE','OKE_KAUWB_MDS_NOT_VALID');
1987: -- FND_MESSAGE.Set_Token('TOKEN1', L_Line_Number);
1988: -- FND_MESSAGE.Set_Token('TOKEN2', L_Msg);

Line 1995: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_UPDATED', 'TOKEN1', L_Line_Number);

1991: RETURN FALSE;
1992:
1993: ELSE
1994:
1995: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_UPDATED', 'TOKEN1', L_Line_Number);
1996:
1997: -- FND_MESSAGE.Set_Name('OKE', 'OKE_KAUWB_MDS_UPDATED');
1998: -- X_Mps_S := FND_MESSAGE.Get;
1999: X_Mps_S := 'S';