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_ASSET_CREATION_PKG dependencies on CSE_ASSET_UTIL_PKG

Line 649: l_asset_description := cse_asset_util_pkg.asset_description(

645:
646: IF l_ind = 1 THEN
647:
648: -- asset description
649: l_asset_description := cse_asset_util_pkg.asset_description(
650: p_asset_attrib_rec => l_asset_attrib_rec,
651: x_error_msg => l_error_message,
652: x_return_status => l_return_status);
653: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 658: cse_asset_util_pkg.get_unit_cost(

654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: -- asset unit cost
658: cse_asset_util_pkg.get_unit_cost(
659: p_source_txn_type => l_source_type,
660: p_source_txn_id => l_source_txn_id, --Modified for bug 13524676
661: p_inventory_item_id => l_inst_tbl(l_ind).inventory_item_id,
662: p_organization_id => l_inst_tbl(l_ind).organization_id,

Line 675: cse_asset_util_pkg.asset_category(

671: debug(' asset_unit_cost : '||l_asset_unit_cost);
672:
673: -- asset category
674: l_asset_category_id :=
675: cse_asset_util_pkg.asset_category(
676: p_asset_attrib_rec => l_asset_attrib_rec,
677: x_error_msg => l_error_message,
678: x_return_status => l_return_status);
679:

Line 695: cse_asset_util_pkg.book_type(

691: WHERE category_id = l_asset_category_id;
692:
693: -- book type code
694: l_book_type_code :=
695: cse_asset_util_pkg.book_type(
696: p_asset_attrib_rec => l_asset_attrib_rec,
697: x_error_msg => l_error_message,
698: x_return_status => l_return_status);
699:

Line 729: cse_asset_util_pkg.date_place_in_service(

725: END IF;
726:
727: -- date placed in service
728: l_dpi :=
729: cse_asset_util_pkg.date_place_in_service(
730: p_asset_attrib_rec => l_asset_attrib_rec,
731: x_error_msg => l_error_message,
732: x_return_status => l_return_status);
733:

Line 739: cse_asset_util_pkg.asset_key(

735: RAISE fnd_api.g_exc_error;
736: END IF;
737:
738: l_asset_key_ccid :=
739: cse_asset_util_pkg.asset_key(
740: p_asset_attrib_rec => l_asset_attrib_rec,
741: x_error_msg => l_error_message,
742: x_return_status => l_return_status);
743:

Line 767: cse_asset_util_pkg.deprn_expense_ccid(

763: END IF;
764:
765: -- get deprn expense ccid
766: l_deprn_expense_ccid :=
767: cse_asset_util_pkg.deprn_expense_ccid(
768: p_asset_attrib_rec => l_asset_attrib_rec,
769: x_error_msg => l_error_message,
770: x_return_status => l_return_status);
771:

Line 778: cse_asset_util_pkg.payables_ccid(

774: END IF;
775:
776: -- payables ccid
777: l_payables_ccid :=
778: cse_asset_util_pkg.payables_ccid(
779: p_asset_attrib_rec => l_asset_attrib_rec,
780: x_error_msg => l_error_message,
781: x_return_status => l_return_status);
782:

Line 790: cse_asset_util_pkg.tag_number(

786: END IF;
787:
788: -- tag number
789: l_tag_number :=
790: cse_asset_util_pkg.tag_number(
791: p_asset_attrib_rec => l_asset_attrib_rec,
792: x_error_msg => l_error_message,
793: x_return_status => l_return_status);
794:

Line 802: cse_asset_util_pkg.manufacturer(

798:
799:
800: -- manufacturer
801: l_manufacturer_name :=
802: cse_asset_util_pkg.manufacturer(
803: p_asset_attrib_rec => l_asset_attrib_rec,
804: x_error_msg => l_error_message,
805: x_return_status => l_return_status);
806:

Line 813: cse_asset_util_pkg.employee(

809: END IF;
810:
811: -- employee
812: l_employee_id :=
813: cse_asset_util_pkg.employee(
814: p_asset_attrib_rec => l_asset_attrib_rec,
815: x_error_msg => l_error_message,
816: x_return_status => l_return_status);
817:

Line 824: cse_asset_util_pkg.search_method(

820: END IF;
821:
822: -- search method
823: l_search_method :=
824: cse_asset_util_pkg.search_method(
825: p_asset_attrib_rec => l_asset_attrib_rec,
826: x_error_msg => l_error_message,
827: x_return_status => l_return_status);
828:

Line 838: cse_asset_util_pkg.model_number(

834:
835: --Changes for bug#13859344
836: -- model number
837: l_model_number :=
838: cse_asset_util_pkg.model_number(
839: p_asset_attrib_rec => l_asset_attrib_rec,
840: x_error_msg => l_error_message,
841: x_return_status => l_return_status);
842:

Line 1705: cse_asset_util_pkg.insert_mass_add(

1701: l_p_mass_add_rec.merged_code := l_parent_merge_code;
1702: l_p_mass_add_rec.fixed_assets_cost := 0;
1703: l_p_mass_add_rec.payables_cost := 0;
1704:
1705: cse_asset_util_pkg.insert_mass_add(
1706: p_api_version => 1.0,
1707: p_commit => fnd_api.g_false,
1708: p_init_msg_list => fnd_api.g_true,
1709: p_mass_add_rec => l_p_mass_add_rec,

Line 1734: cse_asset_util_pkg.insert_mass_add(

1730: NVL( l_p_mass_add_rec.fixed_assets_units,0);
1731: l_c_mass_add_rec.payables_cost := p_instance_rec.asset_unit_cost *
1732: NVL(l_p_mass_add_rec.payables_units,0);
1733:
1734: cse_asset_util_pkg.insert_mass_add(
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_mass_add_rec => l_c_mass_add_rec,

Line 1856: cse_asset_util_pkg.insert_mass_add(

1852: l_c_mass_add_rec.posting_status := l_child_posting_status;
1853: l_c_mass_add_rec.split_merged_code := l_child_merge_code;
1854: l_c_mass_add_rec.merged_code := l_child_merge_code;
1855:
1856: cse_asset_util_pkg.insert_mass_add(
1857: p_api_version => 1.0,
1858: p_commit => fnd_api.g_false,
1859: p_init_msg_list => fnd_api.g_true,
1860: p_mass_add_rec => l_c_mass_add_rec,

Line 2114: cse_asset_util_pkg.insert_mass_add(

2110: l_mass_add_rec.date_placed_in_service := l_date_placed_inservice;
2111: l_mass_add_rec.asset_type := l_asset_type;
2112: END IF;
2113:
2114: cse_asset_util_pkg.insert_mass_add(
2115: p_api_version => 1.0,
2116: p_commit => fnd_api.g_false,
2117: p_init_msg_list => fnd_api.g_true,
2118: p_mass_add_rec => l_mass_add_rec,

Line 3194: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)

3190: AND NVL(assigned_to,-1) = NVL(p_asset_query_rec.employee_id,NVL(assigned_to,-1))
3191: AND date_ineffective IS NULL ;
3192:
3193: CURSOR asset_cost_cur IS
3194: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)
3195: Material_cost ,
3196: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))
3197: Non_Material_cost
3198: FROM fa_asset_invoices

Line 3196: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))

3192:
3193: CURSOR asset_cost_cur IS
3194: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)
3195: Material_cost ,
3196: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))
3197: Non_Material_cost
3198: FROM fa_asset_invoices
3199: WHERE date_ineffective IS NULL
3200: AND asset_id = p_asset_query_rec.asset_id

Line 3474: cse_asset_util_pkg.get_pending_retirements(p_asset_query_rec,

3470: ---08/28 changed to total_units instead of location_units
3471: ----p_asset_query_rec.current_units := l_location_units ;
3472: p_asset_query_rec.current_units := l_total_units ;
3473:
3474: cse_asset_util_pkg.get_pending_retirements(p_asset_query_rec,
3475: p_distribution_tbl,
3476: x_return_status,
3477: x_error_msg);
3478:

Line 3484: cse_asset_util_pkg.get_pending_adjustments(p_asset_query_rec,

3480: THEN
3481: RAISE e_error ;
3482: END IF;
3483:
3484: cse_asset_util_pkg.get_pending_adjustments(p_asset_query_rec,
3485: x_return_status,
3486: x_error_msg);
3487:
3488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 3608: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;

3604: IF p_mtl_percent <> 0 THEN
3605:
3606: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*p_mtl_percent ;
3607: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*p_mtl_percent ;
3608: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;
3609:
3610: cse_asset_util_pkg.insert_mass_add(
3611: 1.0,
3612: fnd_api.g_false,

Line 3610: cse_asset_util_pkg.insert_mass_add(

3606: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*p_mtl_percent ;
3607: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*p_mtl_percent ;
3608: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;
3609:
3610: cse_asset_util_pkg.insert_mass_add(
3611: 1.0,
3612: fnd_api.g_false,
3613: fnd_api.g_true,
3614: l_mass_add_rec,

Line 3630: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;

3626: IF p_mtl_percent <> 1 THEN
3627:
3628: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*(1 - p_mtl_percent) ;
3629: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*(1 - p_mtl_percent) ;
3630: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;
3631:
3632: cse_asset_util_pkg.insert_mass_add(
3633: 1.0,
3634: fnd_api.g_false,

Line 3632: cse_asset_util_pkg.insert_mass_add(

3628: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*(1 - p_mtl_percent) ;
3629: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*(1 - p_mtl_percent) ;
3630: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;
3631:
3632: cse_asset_util_pkg.insert_mass_add(
3633: 1.0,
3634: fnd_api.g_false,
3635: fnd_api.g_true,
3636: l_mass_add_rec,