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.CSE_IPA_TRANS_PKG dependencies on FND_API

Line 26: x_return_status := fnd_api.g_ret_sts_success;

22: IS
23: l_error_message VARCHAR2(2000);
24: BEGIN
25:
26: x_return_status := fnd_api.g_ret_sts_success;
27: x_error_message := null;
28:
29: IF NOT p_nl_pa_interface_tbl.COUNT = 0 THEN
30: FOR i IN p_nl_pa_interface_tbl.FIRST .. p_nl_pa_interface_tbl.LAST

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
219: fnd_message.set_token('ERR_MSG', sqlerrm);
220: l_error_message := fnd_message.get;
221: x_error_message := l_error_message;
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: END populate_pa_interface;
224:
225: PROCEDURE get_fa_asset_category (
226: p_item_id IN NUMBER,

Line 248: x_return_status := fnd_api.g_ret_sts_success;

244:
245:
246: BEGIN
247:
248: x_return_status := fnd_api.g_ret_sts_success;
249: x_error_message := null;
250: x_asset_category_id := null;
251:
252: l_asset_attrib_rec.transaction_id := p_transaction_id ;

Line 275: RAISE fnd_api.g_exc_error ;

271:
272: IF l_asset_category_id is null THEN
273: fnd_message.set_name('CSE', 'CSE_ASSET_CAT_ERROR');
274: fnd_msg_pub.add;
275: RAISE fnd_api.g_exc_error ;
276: END IF;
277:
278: debug(' asset_category_id : '||l_asset_category_id);
279:

Line 288: IF l_return_status <> fnd_api.g_ret_sts_success THEN

284: x_concat_segments => l_con_asset_category,
285: x_return_status => l_return_status,
286: x_error_message => l_error_message);
287:
288: IF l_return_status <> fnd_api.g_ret_sts_success THEN
289: RAISE fnd_api.g_exc_error ;
290: END IF;
291:
292: debug(' asset_category : '||l_con_asset_category);

Line 289: RAISE fnd_api.g_exc_error ;

285: x_return_status => l_return_status,
286: x_error_message => l_error_message);
287:
288: IF l_return_status <> fnd_api.g_ret_sts_success THEN
289: RAISE fnd_api.g_exc_error ;
290: END IF;
291:
292: debug(' asset_category : '||l_con_asset_category);
293:

Line 322: IF l_return_status <> fnd_api.g_ret_sts_success THEN

318: x_combine_segments => l_asset_category,
319: x_return_status => l_return_status,
320: x_error_message => l_error_message);
321:
322: IF l_return_status <> fnd_api.g_ret_sts_success THEN
323: RAISE fnd_api.g_exc_error ;
324: END IF;
325:
326: x_asset_category_id := l_asset_category_id;

Line 323: RAISE fnd_api.g_exc_error ;

319: x_return_status => l_return_status,
320: x_error_message => l_error_message);
321:
322: IF l_return_status <> fnd_api.g_ret_sts_success THEN
323: RAISE fnd_api.g_exc_error ;
324: END IF;
325:
326: x_asset_category_id := l_asset_category_id;
327: x_asset_category := l_asset_category;

Line 331: WHEN fnd_api.g_exc_error THEN

327: x_asset_category := l_asset_category;
328:
329: EXCEPTION
330:
331: WHEN fnd_api.g_exc_error THEN
332: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
333: x_return_status := l_return_status;
334:
335: WHEN OTHERS THEN

Line 340: x_return_status := fnd_api.g_ret_sts_unexp_error;

336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
337: fnd_message.set_token('ERR_MSG', sqlerrm);
338: fnd_msg_pub.add;
339: x_error_message := cse_util_pkg.dump_error_stack;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: END get_fa_asset_category;
342:
343: PROCEDURE get_fa_location_segment (
344: p_fa_location_id IN NUMBER,

Line 359: x_return_status := fnd_api.g_ret_sts_success;

355: asset_loc_exp EXCEPTION;
356: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec ;
357: BEGIN
358:
359: x_return_status := fnd_api.g_ret_sts_success;
360: x_error_message := null;
361:
362: l_location_id := NULL;
363: l_asset_attrib_rec.transaction_id := p_transaction_id ;

Line 386: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN

382: X_concat_segments => l_con_fa_location,
383: x_return_status => l_return_status,
384: x_error_message => l_error_message);
385:
386: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
387: RAISE asset_loc_exp;
388: END IF;
389:
390: debug(' location_segment : '||l_con_fa_location);

Line 401: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN

397: x_combine_segments=> x_fa_location,
398: x_return_status => l_return_status,
399: x_error_message => l_error_message);
400:
401: IF NOT(l_return_status = fnd_api.g_ret_sts_success) THEN
402: RAISE asset_loc_exp;
403: END IF;
404:
405: EXCEPTION

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

410: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
411: fnd_message.set_token('ERR_MSG', sqlerrm);
412: l_error_message := fnd_message.get;
413: x_error_message :=l_error_message;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: END get_fa_location_segment;
416:
417: PROCEDURE get_product_name (
418: p_project_id IN NUMBER,

Line 438: x_return_status := fnd_api.g_ret_sts_success;

434: l_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec ;
435:
436: BEGIN
437:
438: x_return_status := fnd_api.g_ret_sts_success;
439: x_error_message := null;
440: l_product_name := null;
441:
442: l_asset_attrib_rec.transaction_id := p_transaction_id ;

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

462: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
463: fnd_message.set_token('ERR_MSG', sqlerrm);
464: l_error_message := fnd_message.get;
465: x_error_message :=l_error_message;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: END get_product_name;
468:
469: PROCEDURE get_grouping_attribute(
470: p_item_id IN NUMBER,

Line 490: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

486: l_grp_asset_location VARCHAR2(150);
487: l_grp_asset_category VARCHAR2(150);
488: l_product_name VARCHAR2(150);
489: grouping_attr_exp EXCEPTION;
490: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
491: l_Error_Message VARCHAR2(2000);
492:
493: BEGIN
494:

Line 495: x_return_status := fnd_api.g_ret_sts_success;

491: l_Error_Message VARCHAR2(2000);
492:
493: BEGIN
494:
495: x_return_status := fnd_api.g_ret_sts_success;
496:
497: get_fa_asset_category(
498: p_item_id => p_item_id,
499: p_inv_master_org_id => p_organization_id,

Line 506: IF l_return_status <> fnd_api.g_ret_sts_success THEN

502: x_asset_category => l_asset_category,
503: x_return_status => l_return_status,
504: x_error_message => l_error_message);
505:
506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
507: RAISE fnd_api.g_exc_error ;
508: END IF;
509:
510: get_fa_location_segment (

Line 507: RAISE fnd_api.g_exc_error ;

503: x_return_status => l_return_status,
504: x_error_message => l_error_message);
505:
506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
507: RAISE fnd_api.g_exc_error ;
508: END IF;
509:
510: get_fa_location_segment (
511: p_fa_location_id => p_fa_location_id,

Line 517: IF l_return_status <> fnd_api.g_ret_sts_success THEN

513: x_fa_location => l_fa_location,
514: x_return_status => l_return_status,
515: x_error_message => l_error_message);
516:
517: IF l_return_status <> fnd_api.g_ret_sts_success THEN
518: RAISE grouping_attr_exp;
519: END IF;
520:
521: get_product_name (

Line 528: IF l_return_status <> fnd_api.g_ret_sts_success THEN

524: x_product_name => l_product_name,
525: x_return_status => l_return_status,
526: x_error_message => l_error_message);
527:
528: IF l_return_status <> fnd_api.g_ret_sts_success THEN
529: RAISE grouping_attr_exp;
530: END IF;
531:
532: --get attribute 8,9,10

Line 578: RAISE fnd_api.g_exc_error;

574: fnd_message.set_name('CSE', 'CSE_CRL_GRP_NOT_FOUND');
575: fnd_message.set_token('ORG_ID', p_org_id);
576: fnd_msg_pub.add;
577: l_error_message := cse_util_pkg.dump_error_stack;
578: RAISE fnd_api.g_exc_error;
579: END;
580:
581: EXCEPTION
582: WHEN fnd_api.g_exc_error THEN

Line 582: WHEN fnd_api.g_exc_error THEN

578: RAISE fnd_api.g_exc_error;
579: END;
580:
581: EXCEPTION
582: WHEN fnd_api.g_exc_error THEN
583: x_error_message := l_error_message;
584: x_return_status := l_return_status;
585: WHEN OTHERS THEN
586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

Line 590: x_return_status := fnd_api.g_ret_sts_unexp_error;

586: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
587: fnd_message.set_token('ERR_MSG', sqlerrm);
588: l_error_message := fnd_message.get;
589: x_error_message := l_error_message;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: END get_grouping_attribute;
592:
593: END cse_ipa_trans_pkg;