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.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on OKL_API

Line 28: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

24: -- History : 25-OCT-04 SECHAWLA - Created
25: -- End of comments
26: PROCEDURE validate_item_info(
27: p_api_version IN NUMBER,
28: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
29: p_asset_return_id IN NUMBER,
30: p_item_number IN VARCHAR2,
31: p_Item_Description IN VARCHAR2,
32: p_Item_Price IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

Line 32: p_Item_Price IN NUMBER DEFAULT OKL_API.G_MISS_NUM,

28: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
29: p_asset_return_id IN NUMBER,
30: p_item_number IN VARCHAR2,
31: p_Item_Description IN VARCHAR2,
32: p_Item_Price IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
33: p_quantity IN NUMBER DEFAULT 1,
34: x_inv_org_id OUT NOCOPY NUMBER,
35: x_inv_org_name OUT NOCOPY VARCHAR2,
36: x_subinv_code OUT NOCOPY VARCHAR2,

Line 152: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

148:
149:
150:
151:
152: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
153: G_PKG_NAME,
154: p_init_msg_list,
155: l_api_version,
156: p_api_version,

Line 161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

157: '_PVT',
158: x_return_status);
159:
160:
161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;

Line 162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

158: x_return_status);
159:
160:
161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:

Line 163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

159:
160:
161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:
167: SELECT SYSDATE INTO l_sysdate FROM DUAL;

Line 164: RAISE OKL_API.G_EXCEPTION_ERROR;

160:
161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:
167: SELECT SYSDATE INTO l_sysdate FROM DUAL;
168:

Line 178: OKL_API.set_message( p_app_name => 'OKL',

174: CLOSE l_mtlsystemitems_csr;
175:
176: IF l_item_cnt > 0 THEN
177: --Item number ITEM_NUMBER already exists in Inventory. Please enter another item number.
178: OKL_API.set_message( p_app_name => 'OKL',
179: p_msg_name => 'OKL_AM_ITEM_ALREADY_EXISTS',
180: p_token1 => 'ITEM_NUMBER',
181: p_token1_value => p_item_number);
182: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 182: x_return_status := OKL_API.G_RET_STS_ERROR;

178: OKL_API.set_message( p_app_name => 'OKL',
179: p_msg_name => 'OKL_AM_ITEM_ALREADY_EXISTS',
180: p_token1 => 'ITEM_NUMBER',
181: p_token1_value => p_item_number);
182: x_return_status := OKL_API.G_RET_STS_ERROR;
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;
185: END IF;
186:

Line 183: RAISE OKL_API.G_EXCEPTION_ERROR;

179: p_msg_name => 'OKL_AM_ITEM_ALREADY_EXISTS',
180: p_token1 => 'ITEM_NUMBER',
181: p_token1_value => p_item_number);
182: x_return_status := OKL_API.G_RET_STS_ERROR;
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;
185: END IF;
186:
187:

Line 188: IF p_item_price IS NULL OR p_item_price = OKL_API.G_MISS_NUM THEN

184: END IF;
185: END IF;
186:
187:
188: IF p_item_price IS NULL OR p_item_price = OKL_API.G_MISS_NUM THEN
189: x_return_status := OKL_API.G_RET_STS_ERROR;
190: --Item Price is required
191: OKC_API.set_message( p_app_name => 'OKC',
192: p_msg_name => G_REQUIRED_VALUE,

Line 189: x_return_status := OKL_API.G_RET_STS_ERROR;

185: END IF;
186:
187:
188: IF p_item_price IS NULL OR p_item_price = OKL_API.G_MISS_NUM THEN
189: x_return_status := OKL_API.G_RET_STS_ERROR;
190: --Item Price is required
191: OKC_API.set_message( p_app_name => 'OKC',
192: p_msg_name => G_REQUIRED_VALUE,
193: p_token1 => G_COL_NAME_TOKEN,

Line 196: RAISE okl_api.G_EXCEPTION_ERROR;

192: p_msg_name => G_REQUIRED_VALUE,
193: p_token1 => G_COL_NAME_TOKEN,
194: p_token1_value => 'ITEM_PRICE');
195:
196: RAISE okl_api.G_EXCEPTION_ERROR;
197: END IF;
198:
199: IF p_quantity IS NULL OR p_quantity = OKL_API.G_MISS_NUM THEN
200: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 199: IF p_quantity IS NULL OR p_quantity = OKL_API.G_MISS_NUM THEN

195:
196: RAISE okl_api.G_EXCEPTION_ERROR;
197: END IF;
198:
199: IF p_quantity IS NULL OR p_quantity = OKL_API.G_MISS_NUM THEN
200: x_return_status := OKL_API.G_RET_STS_ERROR;
201: --Item Quantity is required
202: OKC_API.set_message( p_app_name => 'OKC',
203: p_msg_name => G_REQUIRED_VALUE,

Line 200: x_return_status := OKL_API.G_RET_STS_ERROR;

196: RAISE okl_api.G_EXCEPTION_ERROR;
197: END IF;
198:
199: IF p_quantity IS NULL OR p_quantity = OKL_API.G_MISS_NUM THEN
200: x_return_status := OKL_API.G_RET_STS_ERROR;
201: --Item Quantity is required
202: OKC_API.set_message( p_app_name => 'OKC',
203: p_msg_name => G_REQUIRED_VALUE,
204: p_token1 => G_COL_NAME_TOKEN,

Line 207: RAISE okl_api.G_EXCEPTION_ERROR;

203: p_msg_name => G_REQUIRED_VALUE,
204: p_token1 => G_COL_NAME_TOKEN,
205: p_token1_value => 'ITEM_QUANTITY');
206:
207: RAISE okl_api.G_EXCEPTION_ERROR;
208: END IF;
209:
210: -- SECHAWLA 05-OCT-04 3924244 : Migrated profiles to setups
211: -- Check the remarketing flow setup

Line 216: OKL_API.set_message(

212: OPEN l_systemparamsall_csr;
213: FETCH l_systemparamsall_csr INTO l_inv_org_id, l_subinv_code, l_price_list_id, l_item_template_id;
214: IF l_systemparamsall_csr%NOTFOUND THEN
215: -- Remarketing options are not setup for this operating unit.
216: OKL_API.set_message(
217: p_app_name => 'OKL',
218: p_msg_name => 'OKL_AM_NO_REMK_SETUP');
219: x_return_status := OKL_API.G_RET_STS_ERROR;
220: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 219: x_return_status := OKL_API.G_RET_STS_ERROR;

215: -- Remarketing options are not setup for this operating unit.
216: OKL_API.set_message(
217: p_app_name => 'OKL',
218: p_msg_name => 'OKL_AM_NO_REMK_SETUP');
219: x_return_status := OKL_API.G_RET_STS_ERROR;
220: RAISE OKL_API.G_EXCEPTION_ERROR;
221: END IF;
222: CLOSE l_systemparamsall_csr;
223:

Line 220: RAISE OKL_API.G_EXCEPTION_ERROR;

216: OKL_API.set_message(
217: p_app_name => 'OKL',
218: p_msg_name => 'OKL_AM_NO_REMK_SETUP');
219: x_return_status := OKL_API.G_RET_STS_ERROR;
220: RAISE OKL_API.G_EXCEPTION_ERROR;
221: END IF;
222: CLOSE l_systemparamsall_csr;
223:
224:

Line 227: OKL_API.set_message(

223:
224:
225: IF l_inv_org_id IS NULL THEN
226: -- Remarketing Inventory Organization is not setup for this operating unit.
227: OKL_API.set_message(
228: p_app_name => 'OKL',
229: p_msg_name => 'OKL_AM_NO_REMK_ORG');
230: x_return_status := OKL_API.G_RET_STS_ERROR;
231: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 230: x_return_status := OKL_API.G_RET_STS_ERROR;

226: -- Remarketing Inventory Organization is not setup for this operating unit.
227: OKL_API.set_message(
228: p_app_name => 'OKL',
229: p_msg_name => 'OKL_AM_NO_REMK_ORG');
230: x_return_status := OKL_API.G_RET_STS_ERROR;
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: ELSE
233: x_inv_org_id := l_inv_org_id;
234: END IF;

Line 231: RAISE OKL_API.G_EXCEPTION_ERROR;

227: OKL_API.set_message(
228: p_app_name => 'OKL',
229: p_msg_name => 'OKL_AM_NO_REMK_ORG');
230: x_return_status := OKL_API.G_RET_STS_ERROR;
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: ELSE
233: x_inv_org_id := l_inv_org_id;
234: END IF;
235: -- SECHAWLA 05-OCT-04 3924244 : Migrated profiles to setups

Line 242: x_return_status := OKL_API.G_RET_STS_ERROR;

238:
239: OPEN l_mtlorgcsr(l_inv_org_id);
240: FETCH l_mtlorgcsr INTO l_temp_org_name;
241: IF l_mtlorgcsr%NOTFOUND THEN
242: x_return_status := OKL_API.G_RET_STS_ERROR;
243:
244: OKC_API.set_message( p_app_name => 'OKC',
245: p_msg_name => G_INVALID_VALUE,
246: p_token1 => G_COL_NAME_TOKEN,

Line 249: RAISE okl_api.G_EXCEPTION_ERROR;

245: p_msg_name => G_INVALID_VALUE,
246: p_token1 => G_COL_NAME_TOKEN,
247: p_token1_value => 'Remarketing Inventory Organization');
248:
249: RAISE okl_api.G_EXCEPTION_ERROR;
250: END IF;
251: CLOSE l_mtlorgcsr;
252:
253:

Line 262: OKL_API.set_message(

258: IF l_subinv_code IS NULL THEN
259:
260: -- SECHAWLA 05-OCT-04 3924244 : Migrated remarketing profiles to setups
261: -- Remarketing Subinventory is not setup for this operating unit.
262: OKL_API.set_message(
263: p_app_name => 'OKL',
264: p_msg_name => 'OKL_AM_NO_REMK_SUBINV');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 265: x_return_status := OKL_API.G_RET_STS_ERROR;

261: -- Remarketing Subinventory is not setup for this operating unit.
262: OKL_API.set_message(
263: p_app_name => 'OKL',
264: p_msg_name => 'OKL_AM_NO_REMK_SUBINV');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: ELSE
268: x_subinv_code := l_subinv_code;
269: END IF;

Line 266: RAISE OKL_API.G_EXCEPTION_ERROR;

262: OKL_API.set_message(
263: p_app_name => 'OKL',
264: p_msg_name => 'OKL_AM_NO_REMK_SUBINV');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: ELSE
268: x_subinv_code := l_subinv_code;
269: END IF;
270:

Line 278: OKL_API.set_message(

274:
275: -- SECHAWLA 05-OCT-04 3924244 : Migrated remarketing profiles to setups
276:
277: -- Remarketing Price List is not setup for this operating unit.
278: OKL_API.set_message(
279: p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_NO_REMK_PRICE_LIST');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 281: x_return_status := OKL_API.G_RET_STS_ERROR;

277: -- Remarketing Price List is not setup for this operating unit.
278: OKL_API.set_message(
279: p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_NO_REMK_PRICE_LIST');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: RAISE OKL_API.G_EXCEPTION_ERROR;
283: END IF;
284:
285:

Line 282: RAISE OKL_API.G_EXCEPTION_ERROR;

278: OKL_API.set_message(
279: p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_NO_REMK_PRICE_LIST');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: RAISE OKL_API.G_EXCEPTION_ERROR;
283: END IF;
284:
285:
286: OPEN l_qplisthdr_csr(l_price_list_id);

Line 289: x_return_status := OKL_API.G_RET_STS_ERROR;

285:
286: OPEN l_qplisthdr_csr(l_price_list_id);
287: FETCH l_qplisthdr_csr INTO l_pricelist_exists;
288: IF l_qplisthdr_csr%NOTFOUND THEN
289: x_return_status := OKL_API.G_RET_STS_ERROR;
290: -- SECHAWLA 05-OCT-04 3924244 : Migrated remarketing profiles to setups
291: OKC_API.set_message( p_app_name => 'OKC',
292: p_msg_name => G_INVALID_VALUE,
293: p_token1 => G_COL_NAME_TOKEN,

Line 295: RAISE OKL_API.G_EXCEPTION_ERROR;

291: OKC_API.set_message( p_app_name => 'OKC',
292: p_msg_name => G_INVALID_VALUE,
293: p_token1 => G_COL_NAME_TOKEN,
294: p_token1_value => 'Remarketing Price List');
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297: CLOSE l_qplisthdr_csr;
298:
299: x_price_list_id := l_price_list_id ;

Line 306: x_return_status := OKL_API.G_RET_STS_ERROR;

302: IF l_item_template_id IS NOT NULL THEN
303: OPEN l_mtltemplates_csr(l_item_template_id, l_inv_org_id);
304: FETCH l_mtltemplates_csr INTO l_template_name;
305: IF l_mtltemplates_csr%NOTFOUND THEN
306: x_return_status := OKL_API.G_RET_STS_ERROR;
307: -- SECHAWLA 05-OCT-04 3924244 : Migrated remarketing profiles to setups
308: OKC_API.set_message( p_app_name => 'OKC',
309: p_msg_name => G_INVALID_VALUE,
310: p_token1 => G_COL_NAME_TOKEN,

Line 312: RAISE OKL_API.G_EXCEPTION_ERROR;

308: OKC_API.set_message( p_app_name => 'OKC',
309: p_msg_name => G_INVALID_VALUE,
310: p_token1 => G_COL_NAME_TOKEN,
311: p_token1_value => 'Item Template');
312: RAISE OKL_API.G_EXCEPTION_ERROR;
313: END IF;
314: CLOSE l_mtltemplates_csr;
315: END IF;
316:

Line 335: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN

331: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
332: p_profile_option_name => 'ASO_ORDER_TYPE_ID',
333: x_return_status => x_return_status);
334:
335: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
336: --Remarketing Order Type profile is missing.
337: OKL_API.set_message( p_app_name => 'OKL',
338: p_msg_name => 'OKL_AM_NO_ORDER_TYPE_PROFILE'
339: );

Line 337: OKL_API.set_message( p_app_name => 'OKL',

333: x_return_status => x_return_status);
334:
335: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN
336: --Remarketing Order Type profile is missing.
337: OKL_API.set_message( p_app_name => 'OKL',
338: p_msg_name => 'OKL_AM_NO_ORDER_TYPE_PROFILE'
339: );
340: RAISE okl_api.G_EXCEPTION_ERROR;
341: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 340: RAISE okl_api.G_EXCEPTION_ERROR;

336: --Remarketing Order Type profile is missing.
337: OKL_API.set_message( p_app_name => 'OKL',
338: p_msg_name => 'OKL_AM_NO_ORDER_TYPE_PROFILE'
339: );
340: RAISE okl_api.G_EXCEPTION_ERROR;
341: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: END IF;
344: -- SECHAWLA Bug# 2679812 -- end new code

Line 341: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

337: OKL_API.set_message( p_app_name => 'OKL',
338: p_msg_name => 'OKL_AM_NO_ORDER_TYPE_PROFILE'
339: );
340: RAISE okl_api.G_EXCEPTION_ERROR;
341: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: END IF;
344: -- SECHAWLA Bug# 2679812 -- end new code
345:

Line 342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

338: p_msg_name => 'OKL_AM_NO_ORDER_TYPE_PROFILE'
339: );
340: RAISE okl_api.G_EXCEPTION_ERROR;
341: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: END IF;
344: -- SECHAWLA Bug# 2679812 -- end new code
345:
346: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 346: x_return_status := OKL_API.G_RET_STS_ERROR;

342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
343: END IF;
344: -- SECHAWLA Bug# 2679812 -- end new code
345:
346: x_return_status := OKL_API.G_RET_STS_ERROR;
347: -- Profile value not defined
348: OKL_API.set_message( p_app_name => 'OKL',
349: p_msg_name => 'OKL_AM_RMK_NO_PROFILE_VALUE',
350: p_token1 => 'PROFILE',

Line 348: OKL_API.set_message( p_app_name => 'OKL',

344: -- SECHAWLA Bug# 2679812 -- end new code
345:
346: x_return_status := OKL_API.G_RET_STS_ERROR;
347: -- Profile value not defined
348: OKL_API.set_message( p_app_name => 'OKL',
349: p_msg_name => 'OKL_AM_RMK_NO_PROFILE_VALUE',
350: p_token1 => 'PROFILE',
351: p_token1_value => l_user_profile_name -- modified to display user profile option
352: );

Line 353: RAISE OKL_API.G_EXCEPTION_ERROR;

349: p_msg_name => 'OKL_AM_RMK_NO_PROFILE_VALUE',
350: p_token1 => 'PROFILE',
351: p_token1_value => l_user_profile_name -- modified to display user profile option
352: );
353: RAISE OKL_API.G_EXCEPTION_ERROR;
354: END IF;
355:
356: -- get the warehouse and the Line Type for the Default Order Type
357: OPEN l_oetranstypesall_csr(l_default_order_type_id);

Line 364: x_return_status := OKL_API.G_RET_STS_ERROR;

360: CLOSE l_oetranstypesall_csr;
361:
362:
363: IF l_order_warehouse_id IS NULL THEN
364: x_return_status := OKL_API.G_RET_STS_ERROR;
365: -- Warehouse not defined for this Order Type
366: OKL_API.set_message( p_app_name => 'OKL',
367: p_msg_name => 'OKL_AM_RMK_NO_WAREHOUSE',
368: p_token1 => 'TYPE',

Line 366: OKL_API.set_message( p_app_name => 'OKL',

362:
363: IF l_order_warehouse_id IS NULL THEN
364: x_return_status := OKL_API.G_RET_STS_ERROR;
365: -- Warehouse not defined for this Order Type
366: OKL_API.set_message( p_app_name => 'OKL',
367: p_msg_name => 'OKL_AM_RMK_NO_WAREHOUSE',
368: p_token1 => 'TYPE',
369: p_token1_value => 'ORDER',
370: p_token2 => 'NAME',

Line 373: RAISE OKL_API.G_EXCEPTION_ERROR;

369: p_token1_value => 'ORDER',
370: p_token2 => 'NAME',
371: p_token2_value => l_order_name
372: );
373: RAISE OKL_API.G_EXCEPTION_ERROR;
374: END IF;
375:
376: IF l_def_outbound_line_type_id IS NULL THEN
377: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 377: x_return_status := OKL_API.G_RET_STS_ERROR;

373: RAISE OKL_API.G_EXCEPTION_ERROR;
374: END IF;
375:
376: IF l_def_outbound_line_type_id IS NULL THEN
377: x_return_status := OKL_API.G_RET_STS_ERROR;
378: -- Line Type not defined for this Order Type
379: OKL_API.set_message( p_app_name => 'OKL',
380: p_msg_name => 'OKL_AM_RMK_NO_LINE_TYPE',
381: p_token1 => 'ORDER_TYPE',

Line 379: OKL_API.set_message( p_app_name => 'OKL',

375:
376: IF l_def_outbound_line_type_id IS NULL THEN
377: x_return_status := OKL_API.G_RET_STS_ERROR;
378: -- Line Type not defined for this Order Type
379: OKL_API.set_message( p_app_name => 'OKL',
380: p_msg_name => 'OKL_AM_RMK_NO_LINE_TYPE',
381: p_token1 => 'ORDER_TYPE',
382: p_token1_value => l_order_name
383: );

Line 384: RAISE OKL_API.G_EXCEPTION_ERROR;

380: p_msg_name => 'OKL_AM_RMK_NO_LINE_TYPE',
381: p_token1 => 'ORDER_TYPE',
382: p_token1_value => l_order_name
383: );
384: RAISE OKL_API.G_EXCEPTION_ERROR;
385: END IF;
386:
387: -- get the warehouse for the Line type corresponding to the Default Order Type
388: OPEN l_oetranstypesall_csr(l_def_outbound_line_type_id);

Line 394: x_return_status := OKL_API.G_RET_STS_ERROR;

390: -- This fetch will definitely find the record in oe_transaction_types_all
391: CLOSE l_oetranstypesall_csr;
392:
393: IF l_line_warehouse_id IS NULL THEN
394: x_return_status := OKL_API.G_RET_STS_ERROR;
395: -- Warehouse not defined for this Line Type
396: OKL_API.set_message( p_app_name => 'OKL',
397: p_msg_name => 'OKL_AM_RMK_NO_WAREHOUSE',
398: p_token1 => 'TYPE',

Line 396: OKL_API.set_message( p_app_name => 'OKL',

392:
393: IF l_line_warehouse_id IS NULL THEN
394: x_return_status := OKL_API.G_RET_STS_ERROR;
395: -- Warehouse not defined for this Line Type
396: OKL_API.set_message( p_app_name => 'OKL',
397: p_msg_name => 'OKL_AM_RMK_NO_WAREHOUSE',
398: p_token1 => 'TYPE',
399: p_token1_value => 'LINE',
400: p_token2 => 'NAME',

Line 403: RAISE OKL_API.G_EXCEPTION_ERROR;

399: p_token1_value => 'LINE',
400: p_token2 => 'NAME',
401: p_token2_value => l_line_name
402: );
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: IF l_order_warehouse_id <> l_line_warehouse_id THEN
407: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 407: x_return_status := OKL_API.G_RET_STS_ERROR;

403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: IF l_order_warehouse_id <> l_line_warehouse_id THEN
407: x_return_status := OKL_API.G_RET_STS_ERROR;
408: -- Warehouses for the Order Type ORDER_TYPE and Line Type LINE_TYPE do not match.
409: OKL_API.set_message( p_app_name => 'OKL',
410: p_msg_name => 'OKL_AM_RMK_WHS_MISMATCH',
411: p_token1 => 'ORDER_TYPE',

Line 409: OKL_API.set_message( p_app_name => 'OKL',

405:
406: IF l_order_warehouse_id <> l_line_warehouse_id THEN
407: x_return_status := OKL_API.G_RET_STS_ERROR;
408: -- Warehouses for the Order Type ORDER_TYPE and Line Type LINE_TYPE do not match.
409: OKL_API.set_message( p_app_name => 'OKL',
410: p_msg_name => 'OKL_AM_RMK_WHS_MISMATCH',
411: p_token1 => 'ORDER_TYPE',
412: p_token1_value => l_order_name,
413: p_token2 => 'LINE_TYPE',

Line 416: RAISE OKL_API.G_EXCEPTION_ERROR;

412: p_token1_value => l_order_name,
413: p_token2 => 'LINE_TYPE',
414: p_token2_value => l_line_name
415: );
416: RAISE OKL_API.G_EXCEPTION_ERROR;
417: END IF;
418:
419: IF l_inv_org_id <> l_order_warehouse_id THEN
420: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 420: x_return_status := OKL_API.G_RET_STS_ERROR;

416: RAISE OKL_API.G_EXCEPTION_ERROR;
417: END IF;
418:
419: IF l_inv_org_id <> l_order_warehouse_id THEN
420: x_return_status := OKL_API.G_RET_STS_ERROR;
421: -- Shipping organization should be the same as the inventory item organization.
422: OKL_API.set_message( p_app_name => 'OKL',
423: p_msg_name => 'OKL_AM_RMK_INVALID_WHS'
424: );

Line 422: OKL_API.set_message( p_app_name => 'OKL',

418:
419: IF l_inv_org_id <> l_order_warehouse_id THEN
420: x_return_status := OKL_API.G_RET_STS_ERROR;
421: -- Shipping organization should be the same as the inventory item organization.
422: OKL_API.set_message( p_app_name => 'OKL',
423: p_msg_name => 'OKL_AM_RMK_INVALID_WHS'
424: );
425: RAISE OKL_API.G_EXCEPTION_ERROR;
426: END IF;

Line 425: RAISE OKL_API.G_EXCEPTION_ERROR;

421: -- Shipping organization should be the same as the inventory item organization.
422: OKL_API.set_message( p_app_name => 'OKL',
423: p_msg_name => 'OKL_AM_RMK_INVALID_WHS'
424: );
425: RAISE OKL_API.G_EXCEPTION_ERROR;
426: END IF;
427:
428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info.','End(-)');

Line 431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

427:
428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info.','End(-)');
430: END IF;
431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
432:
433: EXCEPTION
434: WHEN OKL_API.G_EXCEPTION_ERROR THEN
435: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 434: WHEN OKL_API.G_EXCEPTION_ERROR THEN

430: END IF;
431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
432:
433: EXCEPTION
434: WHEN OKL_API.G_EXCEPTION_ERROR THEN
435: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info',
437: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
438: END IF;

Line 437: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

433: EXCEPTION
434: WHEN OKL_API.G_EXCEPTION_ERROR THEN
435: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info',
437: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
438: END IF;
439:
440: IF l_mtlsystemitems_csr%ISOPEN THEN
441: CLOSE l_mtlsystemitems_csr;

Line 471: x_return_status := OKL_API.HANDLE_EXCEPTIONS

467:
468: IF l_mtltemplates_csr%ISOPEN THEN
469: CLOSE l_mtltemplates_csr;
470: END IF;
471: x_return_status := OKL_API.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'OKL_API.G_RET_STS_ERROR',

Line 475: 'OKL_API.G_RET_STS_ERROR',

471: x_return_status := OKL_API.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'OKL_API.G_RET_STS_ERROR',
476: x_msg_count,
477: x_msg_data,
478: '_PVT'
479: );

Line 480: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

476: x_msg_count,
477: x_msg_data,
478: '_PVT'
479: );
480: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
481:
482: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info.',
484: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 484: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

480: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
481:
482: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info.',
484: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
485: END IF;
486:
487: IF l_mtlsystemitems_csr%ISOPEN THEN
488: CLOSE l_mtlsystemitems_csr;

Line 516: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

512:
513: IF l_mtltemplates_csr%ISOPEN THEN
514: CLOSE l_mtltemplates_csr;
515: END IF;
516: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
517: (
518: l_api_name,
519: G_PKG_NAME,
520: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 520: 'OKL_API.G_RET_STS_UNEXP_ERROR',

516: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
517: (
518: l_api_name,
519: G_PKG_NAME,
520: 'OKL_API.G_RET_STS_UNEXP_ERROR',
521: x_msg_count,
522: x_msg_data,
523: '_PVT'
524: );

Line 560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

556:
557: IF l_mtltemplates_csr%ISOPEN THEN
558: CLOSE l_mtltemplates_csr;
559: END IF;
560: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,
564: 'OTHERS',

Line 596: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

592: -- History : 25-OCT-04 SECHAWLA - Created
593: -- End of comments
594: PROCEDURE create_inv_item
595: ( p_api_version IN NUMBER,
596: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
597: p_asset_return_id IN NUMBER,
598: p_Organization_Id IN NUMBER,
599: p_organization_name IN VARCHAR2 -- remk org name
600: , p_Item_Description IN VARCHAR2

Line 698: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

694:
695:
696:
697:
698: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
699: G_PKG_NAME,
700: p_init_msg_list,
701: l_api_version,
702: p_api_version,

Line 707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

703: '_PVT',
704: x_return_status);
705:
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;

Line 708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

704: x_return_status);
705:
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:

Line 709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

705:
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:
713: -- SECHAWLA Bug# 2679812 : Get the Master Org for the Inv Org

Line 710: RAISE OKL_API.G_EXCEPTION_ERROR;

706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:
713: -- SECHAWLA Bug# 2679812 : Get the Master Org for the Inv Org
714: OPEN l_mtlparam_csr(p_organization_id);

Line 719: x_return_status := OKL_API.G_RET_STS_ERROR;

715:
716: -- SECAHWLA 08-MAR-04 3492490 : Added master org name
717: FETCH l_mtlparam_csr INTO l_master_org_id, l_master_org_name;
718: IF l_mtlparam_csr%NOTFOUND THEN
719: x_return_status := OKL_API.G_RET_STS_ERROR;
720: -- Inventory organization is not set up in MTL Parameters.
721: OKL_API.set_message( p_app_name => 'OKL',
722: p_msg_name => 'OKL_AM_NO_ORG_PARAM'
723: );

Line 721: OKL_API.set_message( p_app_name => 'OKL',

717: FETCH l_mtlparam_csr INTO l_master_org_id, l_master_org_name;
718: IF l_mtlparam_csr%NOTFOUND THEN
719: x_return_status := OKL_API.G_RET_STS_ERROR;
720: -- Inventory organization is not set up in MTL Parameters.
721: OKL_API.set_message( p_app_name => 'OKL',
722: p_msg_name => 'OKL_AM_NO_ORG_PARAM'
723: );
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;

Line 724: RAISE OKL_API.G_EXCEPTION_ERROR;

720: -- Inventory organization is not set up in MTL Parameters.
721: OKL_API.set_message( p_app_name => 'OKL',
722: p_msg_name => 'OKL_AM_NO_ORG_PARAM'
723: );
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726: IF l_master_org_id IS NULL THEN
727: x_return_status := OKL_API.G_RET_STS_ERROR;
728: -- Master organization is not defined for inventory organization.

Line 727: x_return_status := OKL_API.G_RET_STS_ERROR;

723: );
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726: IF l_master_org_id IS NULL THEN
727: x_return_status := OKL_API.G_RET_STS_ERROR;
728: -- Master organization is not defined for inventory organization.
729: OKL_API.set_message( p_app_name => 'OKL',
730: p_msg_name => 'OKL_AM_NO_MASTER_ORG'
731: );

Line 729: OKL_API.set_message( p_app_name => 'OKL',

725: END IF;
726: IF l_master_org_id IS NULL THEN
727: x_return_status := OKL_API.G_RET_STS_ERROR;
728: -- Master organization is not defined for inventory organization.
729: OKL_API.set_message( p_app_name => 'OKL',
730: p_msg_name => 'OKL_AM_NO_MASTER_ORG'
731: );
732: RAISE OKL_API.G_EXCEPTION_ERROR;
733: END IF;

Line 732: RAISE OKL_API.G_EXCEPTION_ERROR;

728: -- Master organization is not defined for inventory organization.
729: OKL_API.set_message( p_app_name => 'OKL',
730: p_msg_name => 'OKL_AM_NO_MASTER_ORG'
731: );
732: RAISE OKL_API.G_EXCEPTION_ERROR;
733: END IF;
734: CLOSE l_mtlparam_csr;
735:
736: -- SECHAWLA Bug# 2679812 :

Line 785: -- x_return_status := OKL_API.G_RET_STS_ERROR;

781:
782: OPEN l_mtlsecinv_csr(l_current_org , p_subinventory );
783: FETCH l_mtlsecinv_csr INTO l_temp;
784: IF l_mtlsecinv_csr%NOTFOUND THEN
785: -- x_return_status := OKL_API.G_RET_STS_ERROR;
786:
787: IF (p_organization_id <> l_master_org_id AND i = 1 )THEN
788: /* SECHAWLA 19-MAY-04 3634514 : Commented out
789: --Subinventory SUBINVENTORY is not defined for the organization MASTER_ORG, which is the Master organization of the Remarketing Inventory organization CHILD_ORG.

Line 790: OKL_API.set_message(p_app_name => 'OKL',

786:
787: IF (p_organization_id <> l_master_org_id AND i = 1 )THEN
788: /* SECHAWLA 19-MAY-04 3634514 : Commented out
789: --Subinventory SUBINVENTORY is not defined for the organization MASTER_ORG, which is the Master organization of the Remarketing Inventory organization CHILD_ORG.
790: OKL_API.set_message(p_app_name => 'OKL',
791: p_msg_name => 'OKL_AM_RMK_MST_ORG_SUBINV',
792: p_token1 => 'SUBINVENTORY',
793: p_token1_value => l_subinv_code,
794: p_token2 => 'MASTER_ORG',

Line 806: x_return_status := OKL_API.G_RET_STS_ERROR;

802:
803: END IF;
804: NULL;
805: ELSE
806: x_return_status := OKL_API.G_RET_STS_ERROR;
807: --Subinventory SUBINVENTORY is invalid for the organization ORGANIZATION.
808: OKL_API.set_message(p_app_name => 'OKL',
809: p_msg_name => 'OKL_AM_RMK_ORG_SUBINV',
810: p_token1 => 'SUBINVENTORY',

Line 808: OKL_API.set_message(p_app_name => 'OKL',

804: NULL;
805: ELSE
806: x_return_status := OKL_API.G_RET_STS_ERROR;
807: --Subinventory SUBINVENTORY is invalid for the organization ORGANIZATION.
808: OKL_API.set_message(p_app_name => 'OKL',
809: p_msg_name => 'OKL_AM_RMK_ORG_SUBINV',
810: p_token1 => 'SUBINVENTORY',
811: p_token1_value => p_subinventory,
812: p_token2 => 'ORGANIZATION',

Line 814: RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Added

810: p_token1 => 'SUBINVENTORY',
811: p_token1_value => p_subinventory,
812: p_token2 => 'ORGANIZATION',
813: p_token2_value => p_organization_name);
814: RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Added
815: END IF;
816:
817: --RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Commented out
818: END IF;

Line 817: --RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Commented out

813: p_token2_value => p_organization_name);
814: RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Added
815: END IF;
816:
817: --RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Commented out
818: END IF;
819: CLOSE l_mtlsecinv_csr;
820:
821:

Line 846: x_return_status := OKL_API.G_RET_STS_ERROR;

842: --in the master org yet.
843: OPEN l_seqnextval_csr;
844: FETCH l_seqnextval_csr INTO l_Item_Number;
845: IF l_seqnextval_csr%NOTFOUND THEN
846: x_return_status := OKL_API.G_RET_STS_ERROR;
847: -- Failed to create sequence for Item Number
848: OKL_API.set_message( p_app_name => 'OKL',
849: p_msg_name => 'OKL_AM_RMK_NO_ITEM_NUM_SEQ'
850: );

Line 848: OKL_API.set_message( p_app_name => 'OKL',

844: FETCH l_seqnextval_csr INTO l_Item_Number;
845: IF l_seqnextval_csr%NOTFOUND THEN
846: x_return_status := OKL_API.G_RET_STS_ERROR;
847: -- Failed to create sequence for Item Number
848: OKL_API.set_message( p_app_name => 'OKL',
849: p_msg_name => 'OKL_AM_RMK_NO_ITEM_NUM_SEQ'
850: );
851: RAISE okl_api.G_EXCEPTION_ERROR;
852: END IF;

Line 851: RAISE okl_api.G_EXCEPTION_ERROR;

847: -- Failed to create sequence for Item Number
848: OKL_API.set_message( p_app_name => 'OKL',
849: p_msg_name => 'OKL_AM_RMK_NO_ITEM_NUM_SEQ'
850: );
851: RAISE okl_api.G_EXCEPTION_ERROR;
852: END IF;
853: CLOSE l_seqnextval_csr;
854: --SECHAWLA 14-MAR-03 : Prefixed the sequence generated item number with 'OKL' to prevent duplicate
855: -- item numbers within the same org, incase an external application has already created an item with same

Line 922: l_commit := okl_api.g_FALSE;

918: END IF;
919: -- SECHAWLA Bug# 2620853 : Distribution accout id is not stored, as it is optional
920: -- l_Item_rec.ENCUMBRANCE_ACCOUNT := p_distribution_acct_id;
921:
922: l_commit := okl_api.g_FALSE;
923:
924: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item.',
926: 'before INV_Item_GRP.create_item'||x_return_status);

Line 955: IF ( x_return_status = okl_api.G_RET_STS_SUCCESS ) THEN

951: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item.',
952: 'after INV_Item_GRP.create_item'||x_return_status);
953:
954: END IF;
955: IF ( x_return_status = okl_api.G_RET_STS_SUCCESS ) THEN
956: l_New_Item_Number := x_item_rec.ITEM_NUMBER;
957: l_New_Item_Id := x_item_rec.INVENTORY_ITEM_ID;
958: ELSE
959:

Line 962: OKL_API.set_message( p_app_name => 'OKL',

958: ELSE
959:
960: -- SECHAWLA 08-DEC-04 4047159 : added the following message
961: -- Error creating inventory item ITEM_NUMBER in organization ORG_NAME.
962: OKL_API.set_message( p_app_name => 'OKL',
963: p_msg_name => 'OKL_AM_RMK_ITEM_FAILED',
964: p_token1 => 'ITEM_NUMBER',
965: p_token1_value => l_Item_rec.ITEM_NUMBER,
966: p_token2 => 'ORG_NAME',

Line 972: OKL_API.set_message( p_app_name => 'OKL',

968:
969: -- display the error messages from the x_error_tbl table
970: FOR i IN 1 .. x_Error_tbl.COUNT LOOP
971: -- Error: Transaction Id = TRX_ID
972: OKL_API.set_message( p_app_name => 'OKL',
973: p_msg_name => 'OKL_AM_RMK_TRANS_ID',
974: p_token1 => 'TRX_ID',
975: p_token1_value => x_Error_tbl(i).TRANSACTION_ID
976: );

Line 978: OKL_API.set_message( p_app_name => 'OKL',

974: p_token1 => 'TRX_ID',
975: p_token1_value => x_Error_tbl(i).TRANSACTION_ID
976: );
977: -- Error : Unique Id = UNIQUE_ID
978: OKL_API.set_message( p_app_name => 'OKL',
979: p_msg_name => 'OKL_AM_RMK_UNIQUE_ID',
980: p_token1 => 'UNIQUE_ID',
981: p_token1_value => x_Error_tbl(i).UNIQUE_ID
982: );

Line 984: OKL_API.set_message( p_app_name => 'OKL',

980: p_token1 => 'UNIQUE_ID',
981: p_token1_value => x_Error_tbl(i).UNIQUE_ID
982: );
983: -- Error : Table Name = TABLE_NAME
984: OKL_API.set_message( p_app_name => 'OKL',
985: p_msg_name => 'OKL_AM_RMK_TABLE_NAME',
986: p_token1 => 'TABLE_NAME',
987: p_token1_value => x_Error_tbl(i).TABLE_NAME
988: );

Line 991: OKL_API.set_message( p_app_name => 'OKL',

987: p_token1_value => x_Error_tbl(i).TABLE_NAME
988: );
989:
990: --Error : Column Name = COLUMN_NAME
991: OKL_API.set_message( p_app_name => 'OKL',
992: p_msg_name => 'OKL_AM_RMK_COLUMN_NAME',
993: p_token1 => 'COLUMN_NAME',
994: p_token1_value => x_Error_tbl(i).COLUMN_NAME
995: );

Line 998: OKL_API.set_message( p_app_name => 'OKL',

994: p_token1_value => x_Error_tbl(i).COLUMN_NAME
995: );
996:
997: --Error : Message Name = MSG_NAME
998: OKL_API.set_message( p_app_name => 'OKL',
999: p_msg_name => 'OKL_AM_RMK_MSG_NAME',
1000: p_token1 => 'MSG_NAME',
1001: p_token1_value => x_Error_tbl(i).MESSAGE_NAME
1002: );

Line 1005: OKL_API.set_message( p_app_name => 'OKL',

1001: p_token1_value => x_Error_tbl(i).MESSAGE_NAME
1002: );
1003:
1004: -- Error : Message Text = MSG_TEXT
1005: OKL_API.set_message( p_app_name => 'OKL',
1006: p_msg_name => 'OKL_AM_RMK_MSG_TEXT',
1007: p_token1 => 'MSG_TEXT',
1008: p_token1_value => x_Error_tbl(i).MESSAGE_TEXT
1009: );

Line 1012: RAISE OKL_API.G_EXCEPTION_ERROR;

1008: p_token1_value => x_Error_tbl(i).MESSAGE_TEXT
1009: );
1010:
1011: END LOOP;
1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1014:
1015: -----------
1016:

Line 1040: p_init_msg_list => OKL_API.G_FALSE,

1036:
1037: -- call update of tapi
1038: OKL_ASSET_RETURNS_PUB.update_asset_returns(
1039: p_api_version => p_api_version,
1040: p_init_msg_list => OKL_API.G_FALSE,
1041: x_return_status => x_return_status,
1042: x_msg_count => x_msg_count,
1043: x_msg_data => x_msg_data,
1044: p_artv_rec => lp_artv_rec,

Line 1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1049: 'after OKL_ASSET_RETURNS_PUB.update_asset_returns'||x_return_status);
1050:
1051: END IF;
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;

Line 1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1050:
1051: END IF;
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058: -------

Line 1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1051: END IF;
1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058: -------
1059:

Line 1056: RAISE OKL_API.G_EXCEPTION_ERROR;

1052:
1053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1056: RAISE OKL_API.G_EXCEPTION_ERROR;
1057: END IF;
1058: -------
1059:
1060: x_New_Item_Number := l_new_item_number;

Line 1071: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1067: 'x_New_Item_Id..'||x_New_Item_Id);
1068:
1069: END IF;
1070:
1071: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1072:
1073: EXCEPTION
1074: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1075:

Line 1074: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1070:
1071: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1072:
1073: EXCEPTION
1074: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1075:
1076: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item',
1078: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

Line 1078: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

1074: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1075:
1076: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1077: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item',
1078: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1079: END IF;
1080:
1081: IF l_mtlsecinv_csr%ISOPEN THEN
1082: CLOSE l_mtlsecinv_csr;

Line 1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1089: IF l_seqnextval_csr%ISOPEN THEN
1090: CLOSE l_seqnextval_csr;
1091: END IF;
1092:
1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1094: (
1095: l_api_name,
1096: G_PKG_NAME,
1097: 'OKL_API.G_RET_STS_ERROR',

Line 1097: 'OKL_API.G_RET_STS_ERROR',

1093: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1094: (
1095: l_api_name,
1096: G_PKG_NAME,
1097: 'OKL_API.G_RET_STS_ERROR',
1098: x_msg_count,
1099: x_msg_data,
1100: '_PVT'
1101: );

Line 1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1098: x_msg_count,
1099: x_msg_data,
1100: '_PVT'
1101: );
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1103: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_inv_item',
1105: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1106: END IF;

Line 1105: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1101: );
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1103: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_inv_item',
1105: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1106: END IF;
1107:
1108: IF l_mtlsecinv_csr%ISOPEN THEN
1109: CLOSE l_mtlsecinv_csr;

Line 1119: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1115:
1116: IF l_seqnextval_csr%ISOPEN THEN
1117: CLOSE l_seqnextval_csr;
1118: END IF;
1119: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1123: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1119: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1124: x_msg_count,
1125: x_msg_data,
1126: '_PVT'
1127: );

Line 1147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1143: IF l_seqnextval_csr%ISOPEN THEN
1144: CLOSE l_seqnextval_csr;
1145: END IF;
1146:
1147: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,
1151: 'OTHERS',

Line 1178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1174: -- End of comments
1175:
1176: PROCEDURE create_inv_misc_receipt(
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1179: p_Inventory_Item_id IN NUMBER
1180: , p_Subinv_Code IN VARCHAR2
1181: , p_Organization_Id IN NUMBER
1182: -- SECHAWLA Bug# 2620853 : Distribution accout id is not required

Line 1224: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1220: END IF;
1221:
1222:
1223:
1224: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1225: G_PKG_NAME,
1226: p_init_msg_list,
1227: l_api_version,
1228: p_api_version,

Line 1233: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1229: '_PVT',
1230: x_return_status);
1231:
1232:
1233: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1236: RAISE OKL_API.G_EXCEPTION_ERROR;
1237: END IF;

Line 1234: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1230: x_return_status);
1231:
1232:
1233: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1236: RAISE OKL_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:

Line 1235: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1231:
1232:
1233: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1236: RAISE OKL_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:
1239: -- There is a direct insert into the table here as there is no TAPI with insert procedure to insert into

Line 1236: RAISE OKL_API.G_EXCEPTION_ERROR;

1232:
1233: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1234: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1235: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1236: RAISE OKL_API.G_EXCEPTION_ERROR;
1237: END IF;
1238:
1239: -- There is a direct insert into the table here as there is no TAPI with insert procedure to insert into
1240: -- mtl_transactions_interface

Line 1296: x_return_status := okl_api.g_RET_STS_SUCCESS;

1292: 0, /* transaction_source_id */
1293: 'LEASE', /* transaction_source_name */
1294: '' /* expenditure_type */
1295: );
1296: x_return_status := okl_api.g_RET_STS_SUCCESS;
1297:
1298: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt ','End(-)');
1300: END IF;

Line 1302: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1298: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt ','End(-)');
1300: END IF;
1301:
1302: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1303: EXCEPTION
1304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1305: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',

Line 1304: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1300: END IF;
1301:
1302: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1303: EXCEPTION
1304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1305: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1307: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1308: END IF;

Line 1307: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

1303: EXCEPTION
1304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1305: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1307: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1308: END IF;
1309:
1310: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1311: (

Line 1310: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1306: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1307: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1308: END IF;
1309:
1310: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1311: (
1312: l_api_name,
1313: G_PKG_NAME,
1314: 'OKL_API.G_RET_STS_ERROR',

Line 1314: 'OKL_API.G_RET_STS_ERROR',

1310: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1311: (
1312: l_api_name,
1313: G_PKG_NAME,
1314: 'OKL_API.G_RET_STS_ERROR',
1315: x_msg_count,
1316: x_msg_data,
1317: '_PVT'
1318: );

Line 1319: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1315: x_msg_count,
1316: x_msg_data,
1317: '_PVT'
1318: );
1319: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1320: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1322: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1323: END IF;

Line 1322: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1318: );
1319: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1320: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1322: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1323: END IF;
1324:
1325: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1326: (

Line 1325: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1321: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1322: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1323: END IF;
1324:
1325: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1329: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1325: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1330: x_msg_count,
1331: x_msg_data,
1332: '_PVT'
1333: );

Line 1341: OKL_API.set_message(p_app_name => 'OKC',

1337: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt ',
1338: 'EXCEPTION :'||sqlerrm);
1339: END IF;
1340: -- SECHAWLA 16-JAN-03 Bug # 2754280 : Changed the app name from OKL to OKC
1341: OKL_API.set_message(p_app_name => 'OKC',
1342: p_msg_name => g_unexpected_error,
1343: p_token1 => g_sqlcode_token,
1344: p_token1_value => sqlcode,
1345: p_token2 => g_sqlerrm_token,

Line 1348: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1344: p_token1_value => sqlcode,
1345: p_token2 => g_sqlerrm_token,
1346: p_token2_value => sqlerrm);
1347:
1348: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1349: (
1350: l_api_name,
1351: G_PKG_NAME,
1352: 'OTHERS',

Line 1374: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1370: -- End of comments
1371:
1372: PROCEDURE Create_Item_Price_List
1373: ( p_api_version IN NUMBER
1374: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1375: , p_Price_List_id IN NUMBER
1376: , p_Item_Id IN NUMBER
1377: , p_Item_Price IN NUMBER
1378: , x_return_status OUT NOCOPY VARCHAR2

Line 1444: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1440:
1441: END IF;
1442:
1443:
1444: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1445: G_PKG_NAME,
1446: p_init_msg_list,
1447: l_api_version,
1448: p_api_version,

Line 1453: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1449: '_PVT',
1450: x_return_status);
1451:
1452:
1453: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1455: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;

Line 1454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1450: x_return_status);
1451:
1452:
1453: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1455: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458:

Line 1455: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1451:
1452:
1453: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1455: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458:
1459: gpr_price_list_rec.list_header_id := p_Price_List_id;

Line 1456: RAISE OKL_API.G_EXCEPTION_ERROR;

1452:
1453: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1455: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1456: RAISE OKL_API.G_EXCEPTION_ERROR;
1457: END IF;
1458:
1459: gpr_price_list_rec.list_header_id := p_Price_List_id;
1460: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line 1463: gpr_price_list_line_tbl(1).list_line_id := okl_api.G_MISS_NUM;

1459: gpr_price_list_rec.list_header_id := p_Price_List_id;
1460: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1461: gpr_price_list_rec.org_id := mo_global.get_current_org_id(); --CDUBEY l_authoring_org_id added for MOAC
1462:
1463: gpr_price_list_line_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1464: gpr_price_list_line_tbl(1).list_line_type_code := 'PLL';
1465: gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
1466: gpr_price_list_line_tbl(1).operand := p_Item_Price;
1467: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';

Line 1470: gpr_pricing_attr_tbl(1).pricing_attribute_id := okl_api.G_MISS_NUM;

1466: gpr_price_list_line_tbl(1).operand := p_Item_Price;
1467: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';
1468:
1469:
1470: gpr_pricing_attr_tbl(1).pricing_attribute_id := okl_api.G_MISS_NUM;
1471: gpr_pricing_attr_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1472: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
1473: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
1474: gpr_pricing_attr_tbl(1).PRODUCT_ATTR_VALUE := to_char(p_Item_Id);

Line 1471: gpr_pricing_attr_tbl(1).list_line_id := okl_api.G_MISS_NUM;

1467: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';
1468:
1469:
1470: gpr_pricing_attr_tbl(1).pricing_attribute_id := okl_api.G_MISS_NUM;
1471: gpr_pricing_attr_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1472: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
1473: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
1474: gpr_pricing_attr_tbl(1).PRODUCT_ATTR_VALUE := to_char(p_Item_Id);
1475: gpr_pricing_attr_tbl(1).PRODUCT_UOM_CODE := 'EA';

Line 1489: , p_init_msg_list => okl_api.G_FALSE

1485: END IF;
1486:
1487: QP_PRICE_LIST_PUB.Process_Price_List
1488: ( p_api_version_number => p_api_version
1489: , p_init_msg_list => okl_api.G_FALSE
1490: , p_return_values => okl_api.G_FALSE
1491: , p_commit => okl_api.G_FALSE
1492: , x_return_status => x_return_status
1493: , x_msg_count => l_msg_count

Line 1490: , p_return_values => okl_api.G_FALSE

1486:
1487: QP_PRICE_LIST_PUB.Process_Price_List
1488: ( p_api_version_number => p_api_version
1489: , p_init_msg_list => okl_api.G_FALSE
1490: , p_return_values => okl_api.G_FALSE
1491: , p_commit => okl_api.G_FALSE
1492: , x_return_status => x_return_status
1493: , x_msg_count => l_msg_count
1494: , x_msg_data => l_msg_data

Line 1491: , p_commit => okl_api.G_FALSE

1487: QP_PRICE_LIST_PUB.Process_Price_List
1488: ( p_api_version_number => p_api_version
1489: , p_init_msg_list => okl_api.G_FALSE
1490: , p_return_values => okl_api.G_FALSE
1491: , p_commit => okl_api.G_FALSE
1492: , x_return_status => x_return_status
1493: , x_msg_count => l_msg_count
1494: , x_msg_data => l_msg_data
1495: , p_PRICE_LIST_rec => gpr_price_list_rec

Line 1514: IF ( x_return_status <> okl_api.G_RET_STS_SUCCESS ) THEN

1510: 'after QP_PRICE_LIST_PUB.Process_Price_List call status'||x_return_status);
1511: END IF;
1512:
1513: -- SECHAWLA 08-DEC-04 4047159 : added the following message
1514: IF ( x_return_status <> okl_api.G_RET_STS_SUCCESS ) THEN
1515: OPEN l_qplisthdr_csr(p_Price_List_id) ;
1516: FETCH l_qplisthdr_csr INTO l_pricelist_name;
1517: CLOSE l_qplisthdr_csr;
1518:

Line 1524: OKL_API.set_message( p_app_name => 'OKL',

1520: FETCH l_mtlsystemitems_b INTO l_item_number;
1521: CLOSE l_mtlsystemitems_b;
1522:
1523: -- Error assigning item ITEM_NUMBER to price list PRICE_LIST.
1524: OKL_API.set_message( p_app_name => 'OKL',
1525: p_msg_name => 'OKL_AM_RMK_PL_FAILED',
1526: p_token1 => 'ITEM_NUMBER',
1527: p_token1_value => l_item_number,
1528: p_token2 => 'PRICE_LIST',

Line 1533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1529: p_token2_value => l_pricelist_name);
1530: END IF;
1531:
1532:
1533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;

Line 1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1530: END IF;
1531:
1532:
1533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:

Line 1535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1531:
1532:
1533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:
1539:

Line 1536: RAISE OKL_API.G_EXCEPTION_ERROR;

1532:
1533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: RAISE OKL_API.G_EXCEPTION_ERROR;
1537: END IF;
1538:
1539:
1540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1546: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1542: END IF;
1543:
1544: -- return status of the above procedure call becomes the return status of the current procedure which is then
1545: -- handled in the calling procedure
1546: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1547:
1548: EXCEPTION
1549: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1550:

Line 1549: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1545: -- handled in the calling procedure
1546: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1547:
1548: EXCEPTION
1549: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1550:
1551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1553: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

Line 1553: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

1549: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1550:
1551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1553: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1554: END IF;
1555:
1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (

Line 1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1552: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1553: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1554: END IF;
1555:
1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKL_API.G_RET_STS_ERROR',

Line 1560: 'OKL_API.G_RET_STS_ERROR',

1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKL_API.G_RET_STS_ERROR',
1561: x_msg_count,
1562: x_msg_data,
1563: '_PVT'
1564: );

Line 1565: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1561: x_msg_count,
1562: x_msg_data,
1563: '_PVT'
1564: );
1565: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1566:
1567: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1569: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 1569: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1565: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1566:
1567: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1569: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1570: END IF;
1571:
1572: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1573: (

Line 1572: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1568: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1569: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1570: END IF;
1571:
1572: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,
1576: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1576: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1572: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,
1576: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1577: x_msg_count,
1578: x_msg_data,
1579: '_PVT'
1580: );

Line 1586: OKL_API.set_message(p_app_name => 'OKC',

1582: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1583: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List ',
1584: 'EXCEPTION :'||sqlerrm);
1585: END IF;
1586: OKL_API.set_message(p_app_name => 'OKC',
1587: p_msg_name => g_unexpected_error,
1588: p_token1 => g_sqlcode_token,
1589: p_token1_value => sqlcode,
1590: p_token2 => g_sqlerrm_token,

Line 1593: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1589: p_token1_value => sqlcode,
1590: p_token2 => g_sqlerrm_token,
1591: p_token2_value => sqlerrm);
1592: -- unexpected error
1593: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1594: (
1595: l_api_name,
1596: G_PKG_NAME,
1597: 'OTHERS',