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 154: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

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

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

Line 164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 166: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 184: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 185: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 191: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 198: RAISE okl_api.G_EXCEPTION_ERROR;

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

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

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

Line 202: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 209: RAISE okl_api.G_EXCEPTION_ERROR;

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

Line 218: OKL_API.set_message(

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

Line 221: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 222: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 229: OKL_API.set_message(

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

Line 232: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 244: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 251: RAISE okl_api.G_EXCEPTION_ERROR;

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

Line 264: OKL_API.set_message(

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

Line 267: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 268: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 280: OKL_API.set_message(

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

Line 283: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 284: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 291: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 297: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 308: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 314: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 339: IF x_return_status = OKL_API.G_RET_STS_ERROR THEN

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

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

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

Line 344: RAISE okl_api.G_EXCEPTION_ERROR;

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

Line 345: ELSIF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 346: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 350: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 357: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 368: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 377: RAISE OKL_API.G_EXCEPTION_ERROR;

373: p_token1_value => 'ORDER',
374: p_token2 => 'NAME',
375: p_token2_value => l_order_name
376: );
377: RAISE OKL_API.G_EXCEPTION_ERROR;
378: END IF;
379:
380: IF l_def_outbound_line_type_id IS NULL THEN
381: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 381: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 388: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 398: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 407: RAISE OKL_API.G_EXCEPTION_ERROR;

403: p_token1_value => 'LINE',
404: p_token2 => 'NAME',
405: p_token2_value => l_line_name
406: );
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409:
410: IF l_order_warehouse_id <> l_line_warehouse_id THEN
411: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 411: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 420: RAISE OKL_API.G_EXCEPTION_ERROR;

416: p_token1_value => l_order_name,
417: p_token2 => 'LINE_TYPE',
418: p_token2_value => l_line_name
419: );
420: RAISE OKL_API.G_EXCEPTION_ERROR;
421: END IF;
422:
423: IF l_inv_org_id <> l_order_warehouse_id THEN
424: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 424: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 429: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 438: WHEN OKL_API.G_EXCEPTION_ERROR THEN

434: END IF;
435: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
436:
437: EXCEPTION
438: WHEN OKL_API.G_EXCEPTION_ERROR THEN
439: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
440: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info',
441: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
442: END IF;

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

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

Line 475: x_return_status := OKL_API.HANDLE_EXCEPTIONS

471:
472: IF l_mtltemplates_csr%ISOPEN THEN
473: CLOSE l_mtltemplates_csr;
474: END IF;
475: x_return_status := OKL_API.HANDLE_EXCEPTIONS
476: (
477: l_api_name,
478: G_PKG_NAME,
479: 'OKL_API.G_RET_STS_ERROR',

Line 479: 'OKL_API.G_RET_STS_ERROR',

475: x_return_status := OKL_API.HANDLE_EXCEPTIONS
476: (
477: l_api_name,
478: G_PKG_NAME,
479: 'OKL_API.G_RET_STS_ERROR',
480: x_msg_count,
481: x_msg_data,
482: '_PVT'
483: );

Line 484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

480: x_msg_count,
481: x_msg_data,
482: '_PVT'
483: );
484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
485:
486: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
487: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.validate_item_info.',
488: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

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

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

Line 520: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

516:
517: IF l_mtltemplates_csr%ISOPEN THEN
518: CLOSE l_mtltemplates_csr;
519: END IF;
520: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
521: (
522: l_api_name,
523: G_PKG_NAME,
524: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 524: 'OKL_API.G_RET_STS_UNEXP_ERROR',

520: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
521: (
522: l_api_name,
523: G_PKG_NAME,
524: 'OKL_API.G_RET_STS_UNEXP_ERROR',
525: x_msg_count,
526: x_msg_data,
527: '_PVT'
528: );

Line 564: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

560:
561: IF l_mtltemplates_csr%ISOPEN THEN
562: CLOSE l_mtltemplates_csr;
563: END IF;
564: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
565: (
566: l_api_name,
567: G_PKG_NAME,
568: 'OTHERS',

Line 600: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

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

698:
699:
700:
701:
702: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
703: G_PKG_NAME,
704: p_init_msg_list,
705: l_api_version,
706: p_api_version,

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

707: '_PVT',
708: x_return_status);
709:
710:
711: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
712: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
713: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
714: RAISE OKL_API.G_EXCEPTION_ERROR;
715: END IF;

Line 712: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

708: x_return_status);
709:
710:
711: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
712: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
713: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
714: RAISE OKL_API.G_EXCEPTION_ERROR;
715: END IF;
716:

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

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

Line 714: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 723: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 728: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 731: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 736: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

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

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

Line 810: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

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

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

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

817: p_token2_value => p_organization_name);
818: RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Added
819: END IF;
820:
821: --RAISE OKL_API.G_EXCEPTION_ERROR; --SECHAWLA 19-MAY-04 3634514 : Commented out
822: END IF;
823: CLOSE l_mtlsecinv_csr;
824:
825:

Line 850: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 855: RAISE okl_api.G_EXCEPTION_ERROR;

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

Line 926: l_commit := okl_api.g_FALSE;

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

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

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

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

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

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

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

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

978: p_token1 => 'TRX_ID',
979: p_token1_value => x_Error_tbl(i).TRANSACTION_ID
980: );
981: -- Error : Unique Id = UNIQUE_ID
982: OKL_API.set_message( p_app_name => 'OKL',
983: p_msg_name => 'OKL_AM_RMK_UNIQUE_ID',
984: p_token1 => 'UNIQUE_ID',
985: p_token1_value => x_Error_tbl(i).UNIQUE_ID
986: );

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

984: p_token1 => 'UNIQUE_ID',
985: p_token1_value => x_Error_tbl(i).UNIQUE_ID
986: );
987: -- Error : Table Name = TABLE_NAME
988: OKL_API.set_message( p_app_name => 'OKL',
989: p_msg_name => 'OKL_AM_RMK_TABLE_NAME',
990: p_token1 => 'TABLE_NAME',
991: p_token1_value => x_Error_tbl(i).TABLE_NAME
992: );

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

991: p_token1_value => x_Error_tbl(i).TABLE_NAME
992: );
993:
994: --Error : Column Name = COLUMN_NAME
995: OKL_API.set_message( p_app_name => 'OKL',
996: p_msg_name => 'OKL_AM_RMK_COLUMN_NAME',
997: p_token1 => 'COLUMN_NAME',
998: p_token1_value => x_Error_tbl(i).COLUMN_NAME
999: );

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

998: p_token1_value => x_Error_tbl(i).COLUMN_NAME
999: );
1000:
1001: --Error : Message Name = MSG_NAME
1002: OKL_API.set_message( p_app_name => 'OKL',
1003: p_msg_name => 'OKL_AM_RMK_MSG_NAME',
1004: p_token1 => 'MSG_NAME',
1005: p_token1_value => x_Error_tbl(i).MESSAGE_NAME
1006: );

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

1005: p_token1_value => x_Error_tbl(i).MESSAGE_NAME
1006: );
1007:
1008: -- Error : Message Text = MSG_TEXT
1009: OKL_API.set_message( p_app_name => 'OKL',
1010: p_msg_name => 'OKL_AM_RMK_MSG_TEXT',
1011: p_token1 => 'MSG_TEXT',
1012: p_token1_value => x_Error_tbl(i).MESSAGE_TEXT
1013: );

Line 1016: RAISE OKL_API.G_EXCEPTION_ERROR;

1012: p_token1_value => x_Error_tbl(i).MESSAGE_TEXT
1013: );
1014:
1015: END LOOP;
1016: RAISE OKL_API.G_EXCEPTION_ERROR;
1017: END IF;
1018:
1019: -----------
1020:

Line 1044: p_init_msg_list => OKL_API.G_FALSE,

1040:
1041: -- call update of tapi
1042: OKL_ASSET_RETURNS_PUB.update_asset_returns(
1043: p_api_version => p_api_version,
1044: p_init_msg_list => OKL_API.G_FALSE,
1045: x_return_status => x_return_status,
1046: x_msg_count => x_msg_count,
1047: x_msg_data => x_msg_data,
1048: p_artv_rec => lp_artv_rec,

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

1053: 'after OKL_ASSET_RETURNS_PUB.update_asset_returns'||x_return_status);
1054:
1055: END IF;
1056:
1057: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;

Line 1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

1055: END IF;
1056:
1057: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: -------
1063:

Line 1060: RAISE OKL_API.G_EXCEPTION_ERROR;

1056:
1057: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1058: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1059: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1060: RAISE OKL_API.G_EXCEPTION_ERROR;
1061: END IF;
1062: -------
1063:
1064: x_New_Item_Number := l_new_item_number;

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

1071: 'x_New_Item_Id..'||x_New_Item_Id);
1072:
1073: END IF;
1074:
1075: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1076:
1077: EXCEPTION
1078: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1079:

Line 1078: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1074:
1075: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1076:
1077: EXCEPTION
1078: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1079:
1080: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_item',
1082: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

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

Line 1097: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1093: IF l_seqnextval_csr%ISOPEN THEN
1094: CLOSE l_seqnextval_csr;
1095: END IF;
1096:
1097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1098: (
1099: l_api_name,
1100: G_PKG_NAME,
1101: 'OKL_API.G_RET_STS_ERROR',

Line 1101: 'OKL_API.G_RET_STS_ERROR',

1097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1098: (
1099: l_api_name,
1100: G_PKG_NAME,
1101: 'OKL_API.G_RET_STS_ERROR',
1102: x_msg_count,
1103: x_msg_data,
1104: '_PVT'
1105: );

Line 1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1102: x_msg_count,
1103: x_msg_data,
1104: '_PVT'
1105: );
1106: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1107: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_inv_item',
1109: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1110: END IF;

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

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

Line 1123: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1119:
1120: IF l_seqnextval_csr%ISOPEN THEN
1121: CLOSE l_seqnextval_csr;
1122: END IF;
1123: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1124: (
1125: l_api_name,
1126: G_PKG_NAME,
1127: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1127: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1123: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1124: (
1125: l_api_name,
1126: G_PKG_NAME,
1127: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1128: x_msg_count,
1129: x_msg_data,
1130: '_PVT'
1131: );

Line 1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1147: IF l_seqnextval_csr%ISOPEN THEN
1148: CLOSE l_seqnextval_csr;
1149: END IF;
1150:
1151: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,
1155: 'OTHERS',

Line 1182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

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

1224: END IF;
1225:
1226:
1227:
1228: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1229: G_PKG_NAME,
1230: p_init_msg_list,
1231: l_api_version,
1232: p_api_version,

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

1233: '_PVT',
1234: x_return_status);
1235:
1236:
1237: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1239: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_ERROR;
1241: END IF;

Line 1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1234: x_return_status);
1235:
1236:
1237: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1238: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1239: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_ERROR;
1241: END IF;
1242:

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

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

Line 1240: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 1300: x_return_status := okl_api.g_RET_STS_SUCCESS;

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

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

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

Line 1308: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

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

1307: EXCEPTION
1308: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1309: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1310: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1311: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1312: END IF;
1313:
1314: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1315: (

Line 1314: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1310: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1311: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1312: END IF;
1313:
1314: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,
1318: 'OKL_API.G_RET_STS_ERROR',

Line 1318: 'OKL_API.G_RET_STS_ERROR',

1314: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,
1318: 'OKL_API.G_RET_STS_ERROR',
1319: x_msg_count,
1320: x_msg_data,
1321: '_PVT'
1322: );

Line 1323: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1322: );
1323: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1324: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1326: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1327: END IF;
1328:
1329: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1330: (

Line 1329: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1325: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.create_inv_misc_receipt',
1326: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1327: END IF;
1328:
1329: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1333: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1329: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1334: x_msg_count,
1335: x_msg_data,
1336: '_PVT'
1337: );

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

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

Line 1352: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1348: p_token1_value => sqlcode,
1349: p_token2 => g_sqlerrm_token,
1350: p_token2_value => sqlerrm);
1351:
1352: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1353: (
1354: l_api_name,
1355: G_PKG_NAME,
1356: 'OTHERS',

Line 1378: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1374: -- End of comments
1375:
1376: PROCEDURE Create_Item_Price_List
1377: ( p_api_version IN NUMBER
1378: , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1379: , p_Price_List_id IN NUMBER
1380: , p_Item_Id IN NUMBER
1381: , p_Item_Price IN NUMBER
1382: , x_return_status OUT NOCOPY VARCHAR2

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

1444:
1445: END IF;
1446:
1447:
1448: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1449: G_PKG_NAME,
1450: p_init_msg_list,
1451: l_api_version,
1452: p_api_version,

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

1453: '_PVT',
1454: x_return_status);
1455:
1456:
1457: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;

Line 1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1454: x_return_status);
1455:
1456:
1457: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:

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

1455:
1456:
1457: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: gpr_price_list_rec.list_header_id := p_Price_List_id;

Line 1460: RAISE OKL_API.G_EXCEPTION_ERROR;

1456:
1457: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: gpr_price_list_rec.list_header_id := p_Price_List_id;
1464: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

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

1465:
1466: -- 2-JUL-10 SECHAWLA 9874446 : commented out the org population
1467: --gpr_price_list_rec.org_id := mo_global.get_current_org_id(); --CDUBEY l_authoring_org_id added for MOAC
1468:
1469: gpr_price_list_line_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1470: gpr_price_list_line_tbl(1).list_line_type_code := 'PLL';
1471: gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
1472: gpr_price_list_line_tbl(1).operand := p_Item_Price;
1473: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';

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

1472: gpr_price_list_line_tbl(1).operand := p_Item_Price;
1473: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';
1474:
1475:
1476: gpr_pricing_attr_tbl(1).pricing_attribute_id := okl_api.G_MISS_NUM;
1477: gpr_pricing_attr_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1478: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
1479: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
1480: gpr_pricing_attr_tbl(1).PRODUCT_ATTR_VALUE := to_char(p_Item_Id);

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

1473: gpr_price_list_line_tbl(1).arithmetic_operator := 'UNIT_PRICE';
1474:
1475:
1476: gpr_pricing_attr_tbl(1).pricing_attribute_id := okl_api.G_MISS_NUM;
1477: gpr_pricing_attr_tbl(1).list_line_id := okl_api.G_MISS_NUM;
1478: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
1479: gpr_pricing_attr_tbl(1).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
1480: gpr_pricing_attr_tbl(1).PRODUCT_ATTR_VALUE := to_char(p_Item_Id);
1481: gpr_pricing_attr_tbl(1).PRODUCT_UOM_CODE := 'EA';

Line 1495: , p_init_msg_list => okl_api.G_FALSE

1491: END IF;
1492:
1493: QP_PRICE_LIST_PUB.Process_Price_List
1494: ( p_api_version_number => p_api_version
1495: , p_init_msg_list => okl_api.G_FALSE
1496: , p_return_values => okl_api.G_FALSE
1497: , p_commit => okl_api.G_FALSE
1498: , x_return_status => x_return_status
1499: , x_msg_count => l_msg_count

Line 1496: , p_return_values => okl_api.G_FALSE

1492:
1493: QP_PRICE_LIST_PUB.Process_Price_List
1494: ( p_api_version_number => p_api_version
1495: , p_init_msg_list => okl_api.G_FALSE
1496: , p_return_values => okl_api.G_FALSE
1497: , p_commit => okl_api.G_FALSE
1498: , x_return_status => x_return_status
1499: , x_msg_count => l_msg_count
1500: , x_msg_data => l_msg_data

Line 1497: , p_commit => okl_api.G_FALSE

1493: QP_PRICE_LIST_PUB.Process_Price_List
1494: ( p_api_version_number => p_api_version
1495: , p_init_msg_list => okl_api.G_FALSE
1496: , p_return_values => okl_api.G_FALSE
1497: , p_commit => okl_api.G_FALSE
1498: , x_return_status => x_return_status
1499: , x_msg_count => l_msg_count
1500: , x_msg_data => l_msg_data
1501: , p_PRICE_LIST_rec => gpr_price_list_rec

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

1516: 'after QP_PRICE_LIST_PUB.Process_Price_List call status'||x_return_status);
1517: END IF;
1518:
1519: -- SECHAWLA 08-DEC-04 4047159 : added the following message
1520: IF ( x_return_status <> okl_api.G_RET_STS_SUCCESS ) THEN
1521: OPEN l_qplisthdr_csr(p_Price_List_id) ;
1522: FETCH l_qplisthdr_csr INTO l_pricelist_name;
1523: CLOSE l_qplisthdr_csr;
1524:

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

1526: FETCH l_mtlsystemitems_b INTO l_item_number;
1527: CLOSE l_mtlsystemitems_b;
1528:
1529: -- Error assigning item ITEM_NUMBER to price list PRICE_LIST.
1530: OKL_API.set_message( p_app_name => 'OKL',
1531: p_msg_name => 'OKL_AM_RMK_PL_FAILED',
1532: p_token1 => 'ITEM_NUMBER',
1533: p_token1_value => l_item_number,
1534: p_token2 => 'PRICE_LIST',

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

1535: p_token2_value => l_pricelist_name);
1536: END IF;
1537:
1538:
1539: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;

Line 1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1536: END IF;
1537:
1538:
1539: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544:

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

1537:
1538:
1539: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544:
1545:

Line 1542: RAISE OKL_API.G_EXCEPTION_ERROR;

1538:
1539: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544:
1545:
1546: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1548: END IF;
1549:
1550: -- return status of the above procedure call becomes the return status of the current procedure which is then
1551: -- handled in the calling procedure
1552: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1553:
1554: EXCEPTION
1555: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1556:

Line 1555: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1551: -- handled in the calling procedure
1552: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1553:
1554: EXCEPTION
1555: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1556:
1557: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1559: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

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

1555: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1556:
1557: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1559: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1560: END IF;
1561:
1562: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1563: (

Line 1562: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1559: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1560: END IF;
1561:
1562: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,
1566: 'OKL_API.G_RET_STS_ERROR',

Line 1566: 'OKL_API.G_RET_STS_ERROR',

1562: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,
1566: 'OKL_API.G_RET_STS_ERROR',
1567: x_msg_count,
1568: x_msg_data,
1569: '_PVT'
1570: );

Line 1571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1567: x_msg_count,
1568: x_msg_data,
1569: '_PVT'
1570: );
1571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1572:
1573: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1575: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

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

1571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1572:
1573: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1575: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1576: END IF;
1577:
1578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1579: (

Line 1578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1574: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List',
1575: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1576: END IF;
1577:
1578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1579: (
1580: l_api_name,
1581: G_PKG_NAME,
1582: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1582: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1578: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1579: (
1580: l_api_name,
1581: G_PKG_NAME,
1582: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1583: x_msg_count,
1584: x_msg_data,
1585: '_PVT'
1586: );

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

1588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1589: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_AM_CUSTOM_RMK_ASSET_PVT.Create_Item_Price_List ',
1590: 'EXCEPTION :'||sqlerrm);
1591: END IF;
1592: OKL_API.set_message(p_app_name => 'OKC',
1593: p_msg_name => g_unexpected_error,
1594: p_token1 => g_sqlcode_token,
1595: p_token1_value => sqlcode,
1596: p_token2 => g_sqlerrm_token,

Line 1599: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1595: p_token1_value => sqlcode,
1596: p_token2 => g_sqlerrm_token,
1597: p_token2_value => sqlerrm);
1598: -- unexpected error
1599: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1600: (
1601: l_api_name,
1602: G_PKG_NAME,
1603: 'OTHERS',