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_ASSET_RELOCATION_PVT dependencies on OKL_API

Line 40: p_ialo_tbl(l_loop_counter).p_instance_id = OKL_API.G_MISS_NUM THEN

36: l_loop_counter := p_ialo_tbl.FIRST;
37: LOOP
38:
39: IF p_ialo_tbl(l_loop_counter).p_instance_id IS NULL OR
40: p_ialo_tbl(l_loop_counter).p_instance_id = OKL_API.G_MISS_NUM THEN
41:
42: x_return_status := OKL_API.G_RET_STS_ERROR;
43: -- asset_id is required
44: OKC_API.set_message( p_app_name => 'OKC',

Line 42: x_return_status := OKL_API.G_RET_STS_ERROR;

38:
39: IF p_ialo_tbl(l_loop_counter).p_instance_id IS NULL OR
40: p_ialo_tbl(l_loop_counter).p_instance_id = OKL_API.G_MISS_NUM THEN
41:
42: x_return_status := OKL_API.G_RET_STS_ERROR;
43: -- asset_id is required
44: OKC_API.set_message( p_app_name => 'OKC',
45: p_msg_name => G_REQUIRED_VALUE,
46: p_token1 => G_COL_NAME_TOKEN,

Line 52: p_ialo_tbl(l_loop_counter).p_location_id = OKL_API.G_MISS_NUM THEN

48: RAISE OKC_API.G_EXCEPTION_ERROR;
49: END IF;
50:
51: IF p_ialo_tbl(l_loop_counter).p_location_id IS NULL OR
52: p_ialo_tbl(l_loop_counter).p_location_id = OKL_API.G_MISS_NUM THEN
53:
54: x_return_status := OKL_API.G_RET_STS_ERROR;
55: -- asset_id is required
56: OKC_API.set_message( p_app_name => 'OKC',

Line 54: x_return_status := OKL_API.G_RET_STS_ERROR;

50:
51: IF p_ialo_tbl(l_loop_counter).p_location_id IS NULL OR
52: p_ialo_tbl(l_loop_counter).p_location_id = OKL_API.G_MISS_NUM THEN
53:
54: x_return_status := OKL_API.G_RET_STS_ERROR;
55: -- asset_id is required
56: OKC_API.set_message( p_app_name => 'OKC',
57: p_msg_name => G_REQUIRED_VALUE,
58: p_token1 => G_COL_NAME_TOKEN,

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

68: p_instance_id => p_ialo_tbl(l_loop_counter).p_instance_id,
69: p_location_id => p_ialo_tbl(l_loop_counter).p_location_id,
70: p_install_location_id => p_ialo_tbl(l_loop_counter).p_install_location_id);
71:
72: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
74: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
75: RAISE OKL_API.G_EXCEPTION_ERROR;
76: END IF;

Line 73: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

69: p_location_id => p_ialo_tbl(l_loop_counter).p_location_id,
70: p_install_location_id => p_ialo_tbl(l_loop_counter).p_install_location_id);
71:
72: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
74: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
75: RAISE OKL_API.G_EXCEPTION_ERROR;
76: END IF;
77:

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

70: p_install_location_id => p_ialo_tbl(l_loop_counter).p_install_location_id);
71:
72: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
74: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
75: RAISE OKL_API.G_EXCEPTION_ERROR;
76: END IF;
77:
78: EXIT WHEN (l_loop_counter = p_ialo_tbl.LAST);

Line 75: RAISE OKL_API.G_EXCEPTION_ERROR;

71:
72: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
73: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
74: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
75: RAISE OKL_API.G_EXCEPTION_ERROR;
76: END IF;
77:
78: EXIT WHEN (l_loop_counter = p_ialo_tbl.LAST);
79: l_loop_counter := p_ialo_tbl.NEXT(l_loop_counter );

Line 89: Okl_api.set_message( p_app_name => g_app_name

85:
86: EXCEPTION
87:
88: WHEN OTHERS THEN
89: Okl_api.set_message( p_app_name => g_app_name
90: , p_msg_name => g_unexpected_error
91: , p_token1 => g_sqlcode_token
92: , p_token1_value => SQLCODE
93: , p_token2 => g_sqlerrm_token

Line 96: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

92: , p_token1_value => SQLCODE
93: , p_token2 => g_sqlerrm_token
94: , p_token2_value => SQLERRM
95: ) ;
96: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
97:
98: END Relocate_Installed_Item;
99:
100:

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

132: x_return_status => x_return_status,
133: p_assets_tbl => p_falo_tbl );
134:
135:
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;

Line 137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

133: p_assets_tbl => p_falo_tbl );
134:
135:
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141:

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

134:
135:
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141:
142: x_return_status := l_return_status;

Line 139: RAISE OKL_API.G_EXCEPTION_ERROR;

135:
136: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
138: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_ERROR;
140: END IF;
141:
142: x_return_status := l_return_status;
143:

Line 147: Okl_api.set_message( p_app_name => g_app_name

143:
144: EXCEPTION
145:
146: WHEN OTHERS THEN
147: Okl_api.set_message( p_app_name => g_app_name
148: , p_msg_name => g_unexpected_error
149: , p_token1 => g_sqlcode_token
150: , p_token1_value => SQLCODE
151: , p_token2 => g_sqlerrm_token

Line 154: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

150: , p_token1_value => SQLCODE
151: , p_token2 => g_sqlerrm_token
152: , p_token2_value => SQLERRM
153: ) ;
154: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
155:
156: END Relocate_Fixed_Asset;
157:
158: ---------------------------------------------------------------------------

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

236:
237:
238: BEGIN
239:
240: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
241: G_PKG_NAME,
242: p_init_msg_list,
243: l_api_version,
244: p_api_version,

Line 259: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

255:
256: okl_am_util_pvt.get_transaction_id(p_try_name => 'Asset Relocation',
257: x_return_status => x_return_status,
258: x_try_id => l_try_id);
259: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
260: -- Unable to find a transaction type for this transaction .
261: OKL_API.set_message(p_app_name => 'OKL',
262: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
263: p_token1 => 'TRY_NAME',

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

257: x_return_status => x_return_status,
258: x_try_id => l_try_id);
259: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
260: -- Unable to find a transaction type for this transaction .
261: OKL_API.set_message(p_app_name => 'OKL',
262: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
263: p_token1 => 'TRY_NAME',
264: p_token1_value => 'Asset Relocation');
265: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 275: IF p_assets_tbl(i).p_cle_id IS NULL OR p_assets_tbl(i).p_cle_id = okl_api.G_MISS_NUM THEN

271: i := p_assets_tbl.FIRST;
272: -- loop thru all the records in the input table, validate the data and then call FA transfer
273: -- API to relocate the asset
274: LOOP
275: IF p_assets_tbl(i).p_cle_id IS NULL OR p_assets_tbl(i).p_cle_id = okl_api.G_MISS_NUM THEN
276:
277: x_return_status := OKL_API.G_RET_STS_ERROR;
278: -- cle_id is required
279: OKC_API.set_message( p_app_name => 'OKC',

Line 277: x_return_status := OKL_API.G_RET_STS_ERROR;

273: -- API to relocate the asset
274: LOOP
275: IF p_assets_tbl(i).p_cle_id IS NULL OR p_assets_tbl(i).p_cle_id = okl_api.G_MISS_NUM THEN
276:
277: x_return_status := OKL_API.G_RET_STS_ERROR;
278: -- cle_id is required
279: OKC_API.set_message( p_app_name => 'OKC',
280: p_msg_name => G_REQUIRED_VALUE,
281: p_token1 => G_COL_NAME_TOKEN,

Line 286: IF p_assets_tbl(i).p_asset_id IS NULL OR p_assets_tbl(i).p_asset_id = okl_api.G_MISS_NUM THEN

282: p_token1_value => 'CLE_ID');
283: RAISE OKC_API.G_EXCEPTION_ERROR;
284: END IF;
285:
286: IF p_assets_tbl(i).p_asset_id IS NULL OR p_assets_tbl(i).p_asset_id = okl_api.G_MISS_NUM THEN
287:
288: x_return_status := OKL_API.G_RET_STS_ERROR;
289: -- asset_id is required
290: OKC_API.set_message( p_app_name => 'OKC',

Line 288: x_return_status := OKL_API.G_RET_STS_ERROR;

284: END IF;
285:
286: IF p_assets_tbl(i).p_asset_id IS NULL OR p_assets_tbl(i).p_asset_id = okl_api.G_MISS_NUM THEN
287:
288: x_return_status := OKL_API.G_RET_STS_ERROR;
289: -- asset_id is required
290: OKC_API.set_message( p_app_name => 'OKC',
291: p_msg_name => G_REQUIRED_VALUE,
292: p_token1 => G_COL_NAME_TOKEN,

Line 299: x_return_status := OKL_API.G_RET_STS_ERROR;

295: END IF;
296:
297: IF p_assets_tbl(i).p_asset_number IS NULL THEN
298:
299: x_return_status := OKL_API.G_RET_STS_ERROR;
300: -- asset_number is required
301: OKC_API.set_message( p_app_name => 'OKC',
302: p_msg_name => G_REQUIRED_VALUE,
303: p_token1 => G_COL_NAME_TOKEN,

Line 310: x_return_status := OKL_API.G_RET_STS_ERROR;

306: END IF;
307:
308: IF p_assets_tbl(i).p_corporate_book IS NULL THEN
309:
310: x_return_status := OKL_API.G_RET_STS_ERROR;
311: -- corporate_book is required
312: OKC_API.set_message( p_app_name => 'OKC',
313: p_msg_name => G_REQUIRED_VALUE,
314: p_token1 => G_COL_NAME_TOKEN,

Line 319: IF p_assets_tbl(i).p_current_units IS NULL OR p_assets_tbl(i).p_current_units = okl_api.G_MISS_NUM THEN

315: p_token1_value => 'CORPORATE_BOOK');
316: RAISE OKC_API.G_EXCEPTION_ERROR;
317: END IF;
318:
319: IF p_assets_tbl(i).p_current_units IS NULL OR p_assets_tbl(i).p_current_units = okl_api.G_MISS_NUM THEN
320:
321: x_return_status := OKL_API.G_RET_STS_ERROR;
322: -- current_units is required
323: OKC_API.set_message( p_app_name => 'OKC',

Line 321: x_return_status := OKL_API.G_RET_STS_ERROR;

317: END IF;
318:
319: IF p_assets_tbl(i).p_current_units IS NULL OR p_assets_tbl(i).p_current_units = okl_api.G_MISS_NUM THEN
320:
321: x_return_status := OKL_API.G_RET_STS_ERROR;
322: -- current_units is required
323: OKC_API.set_message( p_app_name => 'OKC',
324: p_msg_name => G_REQUIRED_VALUE,
325: p_token1 => G_COL_NAME_TOKEN,

Line 330: IF p_assets_tbl(i).p_distribution_id IS NULL OR p_assets_tbl(i).p_distribution_id = okl_api.G_MISS_NUM THEN

326: p_token1_value => 'CURRENT_UNITS');
327: RAISE OKC_API.G_EXCEPTION_ERROR;
328: END IF;
329:
330: IF p_assets_tbl(i).p_distribution_id IS NULL OR p_assets_tbl(i).p_distribution_id = okl_api.G_MISS_NUM THEN
331:
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: -- Distribution Id is required
334: OKC_API.set_message( p_app_name => 'OKC',

Line 332: x_return_status := OKL_API.G_RET_STS_ERROR;

328: END IF;
329:
330: IF p_assets_tbl(i).p_distribution_id IS NULL OR p_assets_tbl(i).p_distribution_id = okl_api.G_MISS_NUM THEN
331:
332: x_return_status := OKL_API.G_RET_STS_ERROR;
333: -- Distribution Id is required
334: OKC_API.set_message( p_app_name => 'OKC',
335: p_msg_name => G_REQUIRED_VALUE,
336: p_token1 => G_COL_NAME_TOKEN,

Line 341: IF p_assets_tbl(i).p_units_assigned IS NULL OR p_assets_tbl(i).p_units_assigned = okl_api.G_MISS_NUM THEN

337: p_token1_value => 'DISTRIBUTION_ID');
338: RAISE OKC_API.G_EXCEPTION_ERROR;
339: END IF;
340:
341: IF p_assets_tbl(i).p_units_assigned IS NULL OR p_assets_tbl(i).p_units_assigned = okl_api.G_MISS_NUM THEN
342:
343: x_return_status := OKL_API.G_RET_STS_ERROR;
344: -- Units Assigned is required
345: OKC_API.set_message( p_app_name => 'OKC',

Line 343: x_return_status := OKL_API.G_RET_STS_ERROR;

339: END IF;
340:
341: IF p_assets_tbl(i).p_units_assigned IS NULL OR p_assets_tbl(i).p_units_assigned = okl_api.G_MISS_NUM THEN
342:
343: x_return_status := OKL_API.G_RET_STS_ERROR;
344: -- Units Assigned is required
345: OKC_API.set_message( p_app_name => 'OKC',
346: p_msg_name => G_REQUIRED_VALUE,
347: p_token1 => G_COL_NAME_TOKEN,

Line 352: IF p_assets_tbl(i).p_code_combination_id IS NULL OR p_assets_tbl(i).p_code_combination_id = okl_api.G_MISS_NUM THEN

348: p_token1_value => 'UNITS_ASSIGNED');
349: RAISE OKC_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: IF p_assets_tbl(i).p_code_combination_id IS NULL OR p_assets_tbl(i).p_code_combination_id = okl_api.G_MISS_NUM THEN
353:
354: x_return_status := OKL_API.G_RET_STS_ERROR;
355: -- Code Combination Id is required
356: OKC_API.set_message( p_app_name => 'OKC',

Line 354: x_return_status := OKL_API.G_RET_STS_ERROR;

350: END IF;
351:
352: IF p_assets_tbl(i).p_code_combination_id IS NULL OR p_assets_tbl(i).p_code_combination_id = okl_api.G_MISS_NUM THEN
353:
354: x_return_status := OKL_API.G_RET_STS_ERROR;
355: -- Code Combination Id is required
356: OKC_API.set_message( p_app_name => 'OKC',
357: p_msg_name => G_REQUIRED_VALUE,
358: p_token1 => G_COL_NAME_TOKEN,

Line 363: IF p_assets_tbl(i).p_old_location_id IS NULL OR p_assets_tbl(i).p_old_location_id = okl_api.G_MISS_NUM THEN

359: p_token1_value => 'CODE_COMBINATION_ID');
360: RAISE OKC_API.G_EXCEPTION_ERROR;
361: END IF;
362:
363: IF p_assets_tbl(i).p_old_location_id IS NULL OR p_assets_tbl(i).p_old_location_id = okl_api.G_MISS_NUM THEN
364:
365: x_return_status := OKL_API.G_RET_STS_ERROR;
366: -- Old Location Id is required
367: OKC_API.set_message( p_app_name => 'OKC',

Line 365: x_return_status := OKL_API.G_RET_STS_ERROR;

361: END IF;
362:
363: IF p_assets_tbl(i).p_old_location_id IS NULL OR p_assets_tbl(i).p_old_location_id = okl_api.G_MISS_NUM THEN
364:
365: x_return_status := OKL_API.G_RET_STS_ERROR;
366: -- Old Location Id is required
367: OKC_API.set_message( p_app_name => 'OKC',
368: p_msg_name => G_REQUIRED_VALUE,
369: p_token1 => G_COL_NAME_TOKEN,

Line 374: IF p_assets_tbl(i).p_new_location_id IS NULL OR p_assets_tbl(i).p_new_location_id = okl_api.G_MISS_NUM THEN

370: p_token1_value => 'OLD_LOCATION_ID');
371: RAISE OKC_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: IF p_assets_tbl(i).p_new_location_id IS NULL OR p_assets_tbl(i).p_new_location_id = okl_api.G_MISS_NUM THEN
375: x_return_status := OKL_API.G_RET_STS_ERROR;
376: -- New Location Id is required
377: OKC_API.set_message( p_app_name => 'OKC',
378: p_msg_name => G_REQUIRED_VALUE,

Line 375: x_return_status := OKL_API.G_RET_STS_ERROR;

371: RAISE OKC_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: IF p_assets_tbl(i).p_new_location_id IS NULL OR p_assets_tbl(i).p_new_location_id = okl_api.G_MISS_NUM THEN
375: x_return_status := OKL_API.G_RET_STS_ERROR;
376: -- New Location Id is required
377: OKC_API.set_message( p_app_name => 'OKC',
378: p_msg_name => G_REQUIRED_VALUE,
379: p_token1 => G_COL_NAME_TOKEN,

Line 385: x_return_status := OKL_API.G_RET_STS_ERROR;

381: RAISE OKC_API.G_EXCEPTION_ERROR;
382: END IF;
383:
384: IF p_assets_tbl(i).p_new_location_id = p_assets_tbl(i).p_old_location_id THEN
385: x_return_status := OKL_API.G_RET_STS_ERROR;
386: -- Can not create identical distributions. New Location Id should be different from the
387: -- Old Distribution Id
388: OKL_API.set_message( p_app_name => 'OKL',
389: p_msg_name => 'OKL_AM_IDENTICAL_DIST_LINES');

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

384: IF p_assets_tbl(i).p_new_location_id = p_assets_tbl(i).p_old_location_id THEN
385: x_return_status := OKL_API.G_RET_STS_ERROR;
386: -- Can not create identical distributions. New Location Id should be different from the
387: -- Old Distribution Id
388: OKL_API.set_message( p_app_name => 'OKL',
389: p_msg_name => 'OKL_AM_IDENTICAL_DIST_LINES');
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: END IF;
392:

Line 390: RAISE OKL_API.G_EXCEPTION_ERROR;

386: -- Can not create identical distributions. New Location Id should be different from the
387: -- Old Distribution Id
388: OKL_API.set_message( p_app_name => 'OKL',
389: p_msg_name => 'OKL_AM_IDENTICAL_DIST_LINES');
390: RAISE OKL_API.G_EXCEPTION_ERROR;
391: END IF;
392:
393: OPEN l_location_csr(p_assets_tbl(i).p_new_location_id, l_sysdate);
394: FETCH l_location_csr INTO l_ret;

Line 397: x_return_status := OKL_API.G_RET_STS_ERROR;

393: OPEN l_location_csr(p_assets_tbl(i).p_new_location_id, l_sysdate);
394: FETCH l_location_csr INTO l_ret;
395:
396: IF l_location_csr%NOTFOUND THEN
397: x_return_status := OKL_API.G_RET_STS_ERROR;
398: -- New Location Id is Invalid
399: OKC_API.set_message( p_app_name => 'OKC',
400: p_msg_name => G_INVALID_VALUE,
401: p_token1 => G_COL_NAME_TOKEN,

Line 435: x_return_status := OKL_API.G_RET_STS_ERROR; -- sechawla 19-dec-2005 4895439 : added

431:
432: -- Depreciation has already been run for the asset ASSET_NUMBER in either corporate book or
433: -- one or more tax books. Can not perform relocation.
434:
435: x_return_status := OKL_API.G_RET_STS_ERROR; -- sechawla 19-dec-2005 4895439 : added
436:
437: OKL_API.set_message( p_app_name => 'OKL',
438: p_msg_name => 'OKL_AM_DEPRN_RAN_ALREADY',
439: p_token1 => 'ASSET_NUMBER',

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

433: -- one or more tax books. Can not perform relocation.
434:
435: x_return_status := OKL_API.G_RET_STS_ERROR; -- sechawla 19-dec-2005 4895439 : added
436:
437: OKL_API.set_message( p_app_name => 'OKL',
438: p_msg_name => 'OKL_AM_DEPRN_RAN_ALREADY',
439: p_token1 => 'ASSET_NUMBER',
440: p_token1_value => p_assets_tbl(i).p_asset_number);
441:

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

612: i := p_assets_tbl.NEXT(i);
613: END LOOP;
614: ELSE
615: -- There were no Asset Relocation transactions to process.
616: OKL_API.set_message(p_app_name => 'OKL',
617: p_msg_name => 'OKL_AM_NO_RELOC_TRX');
618: END IF; -- if assets_tbl.count > 0
619:
620: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 798: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

794: l_pricing_attrib_tbl pricing_attribs_tbl;
795: l_org_assignments_tbl organization_units_tbl;
796: l_asset_assignment_tbl instance_asset_tbl;
797:
798: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
799: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
800:
801: l_api_name CONSTANT VARCHAR2(30) := 'change_item_location';
802: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 799: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

795: l_org_assignments_tbl organization_units_tbl;
796: l_asset_assignment_tbl instance_asset_tbl;
797:
798: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
799: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
800:
801: l_api_name CONSTANT VARCHAR2(30) := 'change_item_location';
802: l_api_version CONSTANT NUMBER := G_API_VERSION;
803: l_msg_count NUMBER := FND_API.G_MISS_NUM;

Line 812: l_return_status := OKL_API.START_ACTIVITY (

808: -- ***************************************************************
809: -- Check API version, initialize message list and create savepoint
810: -- ***************************************************************
811:
812: l_return_status := OKL_API.START_ACTIVITY (
813: l_api_name,
814: G_PKG_NAME,
815: p_init_msg_list,
816: l_api_version,

Line 821: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

817: p_api_version,
818: '_PVT',
819: x_return_status);
820:
821: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;

Line 822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

818: '_PVT',
819: x_return_status);
820:
821: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:

Line 823: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

819: x_return_status);
820:
821: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827: -- ************************

Line 824: RAISE OKL_API.G_EXCEPTION_ERROR;

820:
821: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827: -- ************************
828: -- Get Item Instance record

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

845: x_return_status => l_return_status,
846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data);
848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: ELSIF (NVL (l_instance_header_tbl.COUNT, 0) <> 1) THEN

Line 850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data);
848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: ELSIF (NVL (l_instance_header_tbl.COUNT, 0) <> 1) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

847: x_msg_data => l_msg_data);
848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: ELSIF (NVL (l_instance_header_tbl.COUNT, 0) <> 1) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: END IF;

Line 852: RAISE OKL_API.G_EXCEPTION_ERROR;

848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: ELSIF (NVL (l_instance_header_tbl.COUNT, 0) <> 1) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: END IF;
856:

Line 854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: ELSIF (NVL (l_instance_header_tbl.COUNT, 0) <> 1) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: END IF;
856:
857: -- *************************************
858: -- Initialize parameters to be passed in

Line 869: OR (p_location_id = OKL_API.G_MISS_NUM) THEN

865: l_instance_rec.quantity :=
866: l_instance_header_tbl(1).quantity;
867:
868: IF (p_location_id IS NULL)
869: OR (p_location_id = OKL_API.G_MISS_NUM) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: ELSE
872: -- GKADARKA - fixes for bug 3569441
873: IF (l_instance_header_tbl(1).location_type_code = 'HZ_LOCATIONS') THEN

Line 870: RAISE OKL_API.G_EXCEPTION_ERROR;

866: l_instance_header_tbl(1).quantity;
867:
868: IF (p_location_id IS NULL)
869: OR (p_location_id = OKL_API.G_MISS_NUM) THEN
870: RAISE OKL_API.G_EXCEPTION_ERROR;
871: ELSE
872: -- GKADARKA - fixes for bug 3569441
873: IF (l_instance_header_tbl(1).location_type_code = 'HZ_LOCATIONS') THEN
874: l_instance_rec.location_id := p_location_id;

Line 884: OR (p_install_location_id = OKL_API.G_MISS_NUM) THEN

880: --l_instance_rec.location_id := p_location_id;
881: END IF;
882:
883: IF (p_install_location_id IS NULL)
884: OR (p_install_location_id = OKL_API.G_MISS_NUM) THEN
885: NULL;
886: ELSE
887: --- GKADARKA - fixes for bug 3569441 - Start
888:

Line 921: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

917: x_return_status => l_return_status,
918: x_msg_count => l_msg_count,
919: x_msg_data => l_msg_data);
920:
921: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
924: RAISE OKL_API.G_EXCEPTION_ERROR;
925: END IF;

Line 922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

918: x_msg_count => l_msg_count,
919: x_msg_data => l_msg_data);
920:
921: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
924: RAISE OKL_API.G_EXCEPTION_ERROR;
925: END IF;
926:

Line 923: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

919: x_msg_data => l_msg_data);
920:
921: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
924: RAISE OKL_API.G_EXCEPTION_ERROR;
925: END IF;
926:
927: -- **************

Line 924: RAISE OKL_API.G_EXCEPTION_ERROR;

920:
921: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
923: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
924: RAISE OKL_API.G_EXCEPTION_ERROR;
925: END IF;
926:
927: -- **************
928: -- Return results

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

929: -- **************
930:
931: x_return_status := l_overall_status;
932:
933: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
934:
935: EXCEPTION
936:
937: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 937: WHEN OKL_API.G_EXCEPTION_ERROR THEN

933: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
934:
935: EXCEPTION
936:
937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
938: x_return_status := OKL_API.HANDLE_EXCEPTIONS
939: (
940: l_api_name,
941: G_PKG_NAME,

Line 938: x_return_status := OKL_API.HANDLE_EXCEPTIONS

934:
935: EXCEPTION
936:
937: WHEN OKL_API.G_EXCEPTION_ERROR THEN
938: x_return_status := OKL_API.HANDLE_EXCEPTIONS
939: (
940: l_api_name,
941: G_PKG_NAME,
942: 'OKL_API.G_RET_STS_ERROR',

Line 942: 'OKL_API.G_RET_STS_ERROR',

938: x_return_status := OKL_API.HANDLE_EXCEPTIONS
939: (
940: l_api_name,
941: G_PKG_NAME,
942: 'OKL_API.G_RET_STS_ERROR',
943: x_msg_count,
944: x_msg_data,
945: '_PVT'
946: );

Line 948: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

944: x_msg_data,
945: '_PVT'
946: );
947:
948: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
949: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
950: (
951: l_api_name,
952: G_PKG_NAME,

Line 949: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

945: '_PVT'
946: );
947:
948: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
949: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
950: (
951: l_api_name,
952: G_PKG_NAME,
953: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 953: 'OKL_API.G_RET_STS_UNEXP_ERROR',

949: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
950: (
951: l_api_name,
952: G_PKG_NAME,
953: 'OKL_API.G_RET_STS_UNEXP_ERROR',
954: x_msg_count,
955: x_msg_data,
956: '_PVT'
957: );

Line 961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

957: );
958:
959: WHEN OTHERS THEN
960:
961: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
962: (
963: l_api_name,
964: G_PKG_NAME,
965: 'OTHERS',