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 981: l_return_status := OKE_API.START_ACTIVITY(

977: New_L_Rec New_L_C%ROWTYPE;
978:
979: BEGIN
980:
981: l_return_status := OKE_API.START_ACTIVITY(
982: p_api_name => l_api_name,
983: p_init_msg_list => p_initiate_msg_list,
984: p_api_type => g_api_type,
985: x_return_status => l_return_status);

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

984: p_api_type => g_api_type,
985: x_return_status => l_return_status);
986:
987:
988: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
989: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
991: raise OKE_API.G_EXCEPTION_ERROR;
992: End If;

Line 989: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

985: x_return_status => l_return_status);
986:
987:
988: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
989: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
991: raise OKE_API.G_EXCEPTION_ERROR;
992: End If;
993:

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

986:
987:
988: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
989: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
991: raise OKE_API.G_EXCEPTION_ERROR;
992: End If;
993:
994: OPEN New_L_C(P_Line_ID);

Line 991: raise OKE_API.G_EXCEPTION_ERROR;

987:
988: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
989: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
990: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
991: raise OKE_API.G_EXCEPTION_ERROR;
992: End If;
993:
994: OPEN New_L_C(P_Line_ID);
995: FETCH New_L_C INTO New_L_Rec;

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

1090: p_del_rec => l_del_rec,
1091: x_del_rec => x_del_rec);
1092:
1093:
1094: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1095: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1097: raise OKE_API.G_EXCEPTION_ERROR;
1098: End If;

Line 1095: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1091: x_del_rec => x_del_rec);
1092:
1093:
1094: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1095: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1097: raise OKE_API.G_EXCEPTION_ERROR;
1098: End If;
1099:

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

1092:
1093:
1094: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1095: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1097: raise OKE_API.G_EXCEPTION_ERROR;
1098: End If;
1099:
1100: X_Counter := 1;

Line 1097: raise OKE_API.G_EXCEPTION_ERROR;

1093:
1094: If (x_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1095: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1097: raise OKE_API.G_EXCEPTION_ERROR;
1098: End If;
1099:
1100: X_Counter := 1;
1101: X_Return_Status := L_Return_Status;

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

1100: X_Counter := 1;
1101: X_Return_Status := L_Return_Status;
1102:
1103: -- end activity
1104: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1105: x_msg_data => x_msg_data);
1106:
1107: EXCEPTION
1108: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1108: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1104: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1105: x_msg_data => x_msg_data);
1106:
1107: EXCEPTION
1108: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1109:
1110: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1111: (
1112: l_api_name,

Line 1110: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1106:
1107: EXCEPTION
1108: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1109:
1110: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1111: (
1112: l_api_name,
1113: G_PKG_NAME,
1114: 'OKE_API.G_RET_STS_ERROR',

Line 1114: 'OKE_API.G_RET_STS_ERROR',

1110: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1111: (
1112: l_api_name,
1113: G_PKG_NAME,
1114: 'OKE_API.G_RET_STS_ERROR',
1115: x_msg_count,
1116: x_msg_data,
1117: g_api_type
1118: );

Line 1119: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1115: x_msg_count,
1116: x_msg_data,
1117: g_api_type
1118: );
1119: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1120:
1121: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1122: (
1123: l_api_name,

Line 1121: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1117: g_api_type
1118: );
1119: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1120:
1121: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1122: (
1123: l_api_name,
1124: G_PKG_NAME,
1125: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1125: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1121: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1122: (
1123: l_api_name,
1124: G_PKG_NAME,
1125: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1126: x_msg_count,
1127: x_msg_data,
1128: g_api_type
1129: );

Line 1132: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1128: g_api_type
1129: );
1130: WHEN OTHERS THEN
1131:
1132: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OTHERS',

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

1151: , X_Counter OUT NOCOPY NUMBER) IS
1152:
1153: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1154: L_Api_Verson CONSTANT NUMBER := 1;
1155: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1211: l_return_status := OKE_API.START_ACTIVITY(

1207:
1208:
1209: BEGIN
1210:
1211: l_return_status := OKE_API.START_ACTIVITY(
1212: p_api_name => l_api_name,
1213: p_init_msg_list => p_init_msg_list,
1214: p_api_type => g_api_type,
1215: x_return_status => l_return_status);

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

1213: p_init_msg_list => p_init_msg_list,
1214: p_api_type => g_api_type,
1215: x_return_status => l_return_status);
1216:
1217: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1220: raise OKE_API.G_EXCEPTION_ERROR;
1221: End If;

Line 1218: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1214: p_api_type => g_api_type,
1215: x_return_status => l_return_status);
1216:
1217: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1220: raise OKE_API.G_EXCEPTION_ERROR;
1221: End If;
1222:

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

1215: x_return_status => l_return_status);
1216:
1217: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1220: raise OKE_API.G_EXCEPTION_ERROR;
1221: End If;
1222:
1223: L_Counter := 0;

Line 1220: raise OKE_API.G_EXCEPTION_ERROR;

1216:
1217: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1218: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1219: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1220: raise OKE_API.G_EXCEPTION_ERROR;
1221: End If;
1222:
1223: L_Counter := 0;
1224:

Line 1238: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN

1234: , P_Direction => P_Direction
1235: , P_Inventory_Org_ID => P_Inventory_Org_ID
1236: , X_Counter => X_Counter);
1237:
1238: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1239: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1240: L_Return_Status := X_Return_Status;
1241: END IF;
1242: END IF;

Line 1239: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN

1235: , P_Inventory_Org_ID => P_Inventory_Org_ID
1236: , X_Counter => X_Counter);
1237:
1238: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1239: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1240: L_Return_Status := X_Return_Status;
1241: END IF;
1242: END IF;
1243:

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

1248: X_Return_Status := L_Return_Status;
1249: X_Counter := L_Counter;
1250:
1251: -- end activity
1252: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1253: x_msg_data => x_msg_data);
1254:
1255:
1256: EXCEPTION

Line 1257: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1253: x_msg_data => x_msg_data);
1254:
1255:
1256: EXCEPTION
1257: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1258:
1259: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1260: (
1261: l_api_name,

Line 1259: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1255:
1256: EXCEPTION
1257: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1258:
1259: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1260: (
1261: l_api_name,
1262: G_PKG_NAME,
1263: 'OKE_API.G_RET_STS_ERROR',

Line 1263: 'OKE_API.G_RET_STS_ERROR',

1259: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1260: (
1261: l_api_name,
1262: G_PKG_NAME,
1263: 'OKE_API.G_RET_STS_ERROR',
1264: x_msg_count,
1265: x_msg_data,
1266: g_api_type
1267: );

Line 1268: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1264: x_msg_count,
1265: x_msg_data,
1266: g_api_type
1267: );
1268: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1269:
1270: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,

Line 1270: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1266: g_api_type
1267: );
1268: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1269:
1270: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,
1274: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1274: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1270: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1271: (
1272: l_api_name,
1273: G_PKG_NAME,
1274: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1275: x_msg_count,
1276: x_msg_data,
1277: g_api_type
1278: );

Line 1281: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1277: g_api_type
1278: );
1279: WHEN OTHERS THEN
1280:
1281: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1282: (
1283: l_api_name,
1284: G_PKG_NAME,
1285: 'OTHERS',

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

1301: , X_Counter OUT NOCOPY NUMBER) IS
1302:
1303: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1304: L_Api_Version CONSTANT NUMBER := 1;
1305: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1369: l_return_status := OKE_API.START_ACTIVITY(

1365: Update_L_Rec Update_L_C%ROWTYPE;
1366:
1367: BEGIN
1368:
1369: l_return_status := OKE_API.START_ACTIVITY(
1370: p_api_name => l_api_name,
1371: p_init_msg_list => p_init_msg_list,
1372: p_api_type => g_api_type,
1373: x_return_status => l_return_status);

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

1465: p_del_rec => l_del_rec,
1466: x_del_rec => x_del_rec);
1467:
1468:
1469: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1470: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1472: raise OKE_API.G_EXCEPTION_ERROR;
1473: End If;

Line 1470: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1466: x_del_rec => x_del_rec);
1467:
1468:
1469: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1470: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1472: raise OKE_API.G_EXCEPTION_ERROR;
1473: End If;
1474:

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

1467:
1468:
1469: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1470: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1472: raise OKE_API.G_EXCEPTION_ERROR;
1473: End If;
1474:
1475: -- If planning is initiated, update MDS as well

Line 1472: raise OKE_API.G_EXCEPTION_ERROR;

1468:
1469: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1470: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1472: raise OKE_API.G_EXCEPTION_ERROR;
1473: End If;
1474:
1475: -- If planning is initiated, update MDS as well
1476:

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

1484: , X_Return_Status => L_Return_Status);
1485:
1486: END IF;
1487:
1488: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1489: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1491: raise OKE_API.G_EXCEPTION_ERROR;
1492: End If; */

Line 1489: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1485:
1486: END IF;
1487:
1488: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1489: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1491: raise OKE_API.G_EXCEPTION_ERROR;
1492: End If; */
1493:

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

1486: END IF;
1487:
1488: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1489: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1491: raise OKE_API.G_EXCEPTION_ERROR;
1492: End If; */
1493:
1494: X_Return_Status := L_Return_Status;

Line 1491: raise OKE_API.G_EXCEPTION_ERROR;

1487:
1488: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1489: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1490: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1491: raise OKE_API.G_EXCEPTION_ERROR;
1492: End If; */
1493:
1494: X_Return_Status := L_Return_Status;
1495: X_Counter := 1;

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

1494: X_Return_Status := L_Return_Status;
1495: X_Counter := 1;
1496:
1497: -- end activity
1498: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1499: x_msg_data => x_msg_data);
1500: EXCEPTION
1501: when OKE_API.G_EXCEPTION_ERROR then
1502: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 1501: when OKE_API.G_EXCEPTION_ERROR then

1497: -- end activity
1498: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1499: x_msg_data => x_msg_data);
1500: EXCEPTION
1501: when OKE_API.G_EXCEPTION_ERROR then
1502: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1503: p_api_name => l_api_name,
1504: p_pkg_name => g_pkg_name,
1505: p_exc_name => 'OKE_API.G_RET_STS_ERROR',

Line 1502: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1498: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1499: x_msg_data => x_msg_data);
1500: EXCEPTION
1501: when OKE_API.G_EXCEPTION_ERROR then
1502: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1503: p_api_name => l_api_name,
1504: p_pkg_name => g_pkg_name,
1505: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1506: x_msg_count => x_msg_count,

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

1501: when OKE_API.G_EXCEPTION_ERROR then
1502: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1503: p_api_name => l_api_name,
1504: p_pkg_name => g_pkg_name,
1505: p_exc_name => 'OKE_API.G_RET_STS_ERROR',
1506: x_msg_count => x_msg_count,
1507: x_msg_data => x_msg_data,
1508: p_api_type => g_api_type);
1509:

Line 1510: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then

1506: x_msg_count => x_msg_count,
1507: x_msg_data => x_msg_data,
1508: p_api_type => g_api_type);
1509:
1510: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1511: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1512: p_api_name => l_api_name,
1513: p_pkg_name => g_pkg_name,
1514: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1511: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1507: x_msg_data => x_msg_data,
1508: p_api_type => g_api_type);
1509:
1510: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1511: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1512: p_api_name => l_api_name,
1513: p_pkg_name => g_pkg_name,
1514: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1515: x_msg_count => x_msg_count,

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

1510: when OKE_API.G_EXCEPTION_UNEXPECTED_ERROR then
1511: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1512: p_api_name => l_api_name,
1513: p_pkg_name => g_pkg_name,
1514: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR',
1515: x_msg_count => x_msg_count,
1516: x_msg_data => x_msg_data,
1517: p_api_type => g_api_type);
1518:

Line 1520: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

1516: x_msg_data => x_msg_data,
1517: p_api_type => g_api_type);
1518:
1519: when OTHERS then
1520: x_return_status := OKE_API.HANDLE_EXCEPTIONS(
1521: p_api_name => l_api_name,
1522: p_pkg_name => g_pkg_name,
1523: p_exc_name => 'OTHERS',
1524: x_msg_count => x_msg_count,

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

1537: , X_Counter OUT NOCOPY NUMBER) IS
1538:
1539: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1540: L_Api_Verson CONSTANT NUMBER := 1;
1541: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

Line 1590: l_return_status := OKE_API.START_ACTIVITY(

1586: HAVING count(*)=1;
1587:
1588: BEGIN
1589:
1590: l_return_status := OKE_API.START_ACTIVITY(
1591: p_api_name => l_api_name,
1592: p_init_msg_list => p_init_msg_list,
1593: p_api_type => g_api_type,
1594: x_return_status => l_return_status);

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

1592: p_init_msg_list => p_init_msg_list,
1593: p_api_type => g_api_type,
1594: x_return_status => l_return_status);
1595:
1596: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1597: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1598: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1599: raise OKE_API.G_EXCEPTION_ERROR;
1600: End If;

Line 1597: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1593: p_api_type => g_api_type,
1594: x_return_status => l_return_status);
1595:
1596: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1597: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1598: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1599: raise OKE_API.G_EXCEPTION_ERROR;
1600: End If;
1601:

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

1594: x_return_status => l_return_status);
1595:
1596: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1597: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1598: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1599: raise OKE_API.G_EXCEPTION_ERROR;
1600: End If;
1601:
1602: L_Counter := 0;

Line 1599: raise OKE_API.G_EXCEPTION_ERROR;

1595:
1596: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
1597: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1598: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
1599: raise OKE_API.G_EXCEPTION_ERROR;
1600: End If;
1601:
1602: L_Counter := 0;
1603:

Line 1627: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN

1623: , P_Direction => P_Direction
1624: , P_Inventory_Org_ID => P_Inventory_Org_ID
1625: , X_Counter => X_Counter);
1626:
1627: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1628: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1629: L_Return_Status := X_Return_Status;
1630: END IF;
1631: ELSE

Line 1628: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN

1624: , P_Inventory_Org_ID => P_Inventory_Org_ID
1625: , X_Counter => X_Counter);
1626:
1627: IF L_Return_Status <> OKE_API.G_Ret_Sts_Success THEN
1628: IF L_Return_Status <> OKE_API.G_Ret_Sts_Unexp_Error THEN
1629: L_Return_Status := X_Return_Status;
1630: END IF;
1631: ELSE
1632: UPDATE oke_k_lines

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

1810: X_Return_Status := L_Return_Status;
1811: X_Counter := L_Counter;
1812:
1813: -- end activity
1814: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1815: x_msg_data => x_msg_data);
1816:
1817: EXCEPTION
1818: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1818: WHEN OKE_API.G_EXCEPTION_ERROR THEN

1814: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1815: x_msg_data => x_msg_data);
1816:
1817: EXCEPTION
1818: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1819:
1820: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1821: (
1822: l_api_name,

Line 1820: x_return_status := OKE_API.HANDLE_EXCEPTIONS

1816:
1817: EXCEPTION
1818: WHEN OKE_API.G_EXCEPTION_ERROR THEN
1819:
1820: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1821: (
1822: l_api_name,
1823: G_PKG_NAME,
1824: 'OKE_API.G_RET_STS_ERROR',

Line 1824: 'OKE_API.G_RET_STS_ERROR',

1820: x_return_status := OKE_API.HANDLE_EXCEPTIONS
1821: (
1822: l_api_name,
1823: G_PKG_NAME,
1824: 'OKE_API.G_RET_STS_ERROR',
1825: x_msg_count,
1826: x_msg_data,
1827: g_api_type
1828: );

Line 1829: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1825: x_msg_count,
1826: x_msg_data,
1827: g_api_type
1828: );
1829: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1830:
1831: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,

Line 1831: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1827: g_api_type
1828: );
1829: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1830:
1831: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 1835: 'OKE_API.G_RET_STS_UNEXP_ERROR',

1831: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKE_API.G_RET_STS_UNEXP_ERROR',
1836: x_msg_count,
1837: x_msg_data,
1838: g_api_type
1839: );

Line 1842: x_return_status :=OKE_API.HANDLE_EXCEPTIONS

1838: g_api_type
1839: );
1840: WHEN OTHERS THEN
1841:
1842: x_return_status :=OKE_API.HANDLE_EXCEPTIONS
1843: (
1844: l_api_name,
1845: G_PKG_NAME,
1846: 'OTHERS',

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

1958: END IF;
1959:
1960: IF L_Msg IS NOT NULL THEN
1961:
1962: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_NOT_VALID', 'TOKEN1', L_Line_Number, 'TOKEN2', L_Msg);
1963:
1964: -- FND_MESSAGE.Set_Name('OKE','OKE_KAUWB_MDS_NOT_VALID');
1965: -- FND_MESSAGE.Set_Token('TOKEN1', L_Line_Number);
1966: -- FND_MESSAGE.Set_Token('TOKEN2', L_Msg);

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

1969: RETURN FALSE;
1970:
1971: ELSE
1972:
1973: -- OKE_API.Set_Message('OKE', 'OKE_KAUWB_MDS_UPDATED', 'TOKEN1', L_Line_Number);
1974:
1975: -- FND_MESSAGE.Set_Name('OKE', 'OKE_KAUWB_MDS_UPDATED');
1976: -- X_Mps_S := FND_MESSAGE.Get;
1977: X_Mps_S := 'S';