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 629: l_asset_description := cse_asset_util_pkg.asset_description(

625:
626: IF l_ind = 1 THEN
627:
628: -- asset description
629: l_asset_description := cse_asset_util_pkg.asset_description(
630: p_asset_attrib_rec => l_asset_attrib_rec,
631: x_error_msg => l_error_message,
632: x_return_status => l_return_status);
633: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 638: cse_asset_util_pkg.get_unit_cost(

634: RAISE fnd_api.g_exc_error;
635: END IF;
636:
637: -- asset unit cost
638: cse_asset_util_pkg.get_unit_cost(
639: p_source_txn_type => l_source_type,
640: p_source_txn_id => l_inst_tbl(l_ind).rcv_txn_id,
641: p_inventory_item_id => l_inst_tbl(l_ind).inventory_item_id,
642: p_organization_id => l_inst_tbl(l_ind).organization_id,

Line 655: cse_asset_util_pkg.asset_category(

651: debug(' asset_unit_cost : '||l_asset_unit_cost);
652:
653: -- asset category
654: l_asset_category_id :=
655: cse_asset_util_pkg.asset_category(
656: p_asset_attrib_rec => l_asset_attrib_rec,
657: x_error_msg => l_error_message,
658: x_return_status => l_return_status);
659:

Line 675: cse_asset_util_pkg.book_type(

671: WHERE category_id = l_asset_category_id;
672:
673: -- book type code
674: l_book_type_code :=
675: cse_asset_util_pkg.book_type(
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 709: cse_asset_util_pkg.date_place_in_service(

705: END IF;
706:
707: -- date placed in service
708: l_dpi :=
709: cse_asset_util_pkg.date_place_in_service(
710: p_asset_attrib_rec => l_asset_attrib_rec,
711: x_error_msg => l_error_message,
712: x_return_status => l_return_status);
713:

Line 719: cse_asset_util_pkg.asset_key(

715: RAISE fnd_api.g_exc_error;
716: END IF;
717:
718: l_asset_key_ccid :=
719: cse_asset_util_pkg.asset_key(
720: p_asset_attrib_rec => l_asset_attrib_rec,
721: x_error_msg => l_error_message,
722: x_return_status => l_return_status);
723:

Line 747: cse_asset_util_pkg.deprn_expense_ccid(

743: END IF;
744:
745: -- get deprn expense ccid
746: l_deprn_expense_ccid :=
747: cse_asset_util_pkg.deprn_expense_ccid(
748: p_asset_attrib_rec => l_asset_attrib_rec,
749: x_error_msg => l_error_message,
750: x_return_status => l_return_status);
751:

Line 758: cse_asset_util_pkg.payables_ccid(

754: END IF;
755:
756: -- payables ccid
757: l_payables_ccid :=
758: cse_asset_util_pkg.payables_ccid(
759: p_asset_attrib_rec => l_asset_attrib_rec,
760: x_error_msg => l_error_message,
761: x_return_status => l_return_status);
762:

Line 770: cse_asset_util_pkg.tag_number(

766: END IF;
767:
768: -- tag number
769: l_tag_number :=
770: cse_asset_util_pkg.tag_number(
771: p_asset_attrib_rec => l_asset_attrib_rec,
772: x_error_msg => l_error_message,
773: x_return_status => l_return_status);
774:

Line 781: cse_asset_util_pkg.model_number(

777: END IF;
778:
779: -- model number
780: l_model_number :=
781: cse_asset_util_pkg.model_number(
782: p_asset_attrib_rec => l_asset_attrib_rec,
783: x_error_msg => l_error_message,
784: x_return_status => l_return_status);
785:

Line 792: cse_asset_util_pkg.manufacturer(

788: END IF;
789:
790: -- manufacturer
791: l_manufacturer_name :=
792: cse_asset_util_pkg.manufacturer(
793: p_asset_attrib_rec => l_asset_attrib_rec,
794: x_error_msg => l_error_message,
795: x_return_status => l_return_status);
796:

Line 803: cse_asset_util_pkg.employee(

799: END IF;
800:
801: -- employee
802: l_employee_id :=
803: cse_asset_util_pkg.employee(
804: p_asset_attrib_rec => l_asset_attrib_rec,
805: x_error_msg => l_error_message,
806: x_return_status => l_return_status);
807:

Line 814: cse_asset_util_pkg.search_method(

810: END IF;
811:
812: -- search method
813: l_search_method :=
814: cse_asset_util_pkg.search_method(
815: p_asset_attrib_rec => l_asset_attrib_rec,
816: x_error_msg => l_error_message,
817: x_return_status => l_return_status);
818:

Line 1631: cse_asset_util_pkg.insert_mass_add(

1627: l_p_mass_add_rec.merged_code := l_parent_merge_code;
1628: l_p_mass_add_rec.fixed_assets_cost := 0;
1629: l_p_mass_add_rec.payables_cost := 0;
1630:
1631: cse_asset_util_pkg.insert_mass_add(
1632: p_api_version => 1.0,
1633: p_commit => fnd_api.g_false,
1634: p_init_msg_list => fnd_api.g_true,
1635: p_mass_add_rec => l_p_mass_add_rec,

Line 1660: cse_asset_util_pkg.insert_mass_add(

1656: NVL( l_p_mass_add_rec.fixed_assets_units,0);
1657: l_c_mass_add_rec.payables_cost := p_instance_rec.asset_unit_cost *
1658: NVL(l_p_mass_add_rec.payables_units,0);
1659:
1660: cse_asset_util_pkg.insert_mass_add(
1661: p_api_version => 1.0,
1662: p_commit => fnd_api.g_false,
1663: p_init_msg_list => fnd_api.g_true,
1664: p_mass_add_rec => l_c_mass_add_rec,

Line 1747: cse_asset_util_pkg.insert_mass_add(

1743: l_c_mass_add_rec.posting_status := l_child_posting_status;
1744: l_c_mass_add_rec.split_merged_code := l_child_merge_code;
1745: l_c_mass_add_rec.merged_code := l_child_merge_code;
1746:
1747: cse_asset_util_pkg.insert_mass_add(
1748: p_api_version => 1.0,
1749: p_commit => fnd_api.g_false,
1750: p_init_msg_list => fnd_api.g_true,
1751: p_mass_add_rec => l_c_mass_add_rec,

Line 1970: cse_asset_util_pkg.insert_mass_add(

1966: WHERE asset_id = p_asset_id
1967: AND book_type_code = p_instance_rec.book_type_code
1968: AND date_ineffective is null;
1969:
1970: cse_asset_util_pkg.insert_mass_add(
1971: p_api_version => 1.0,
1972: p_commit => fnd_api.g_false,
1973: p_init_msg_list => fnd_api.g_true,
1974: p_mass_add_rec => l_mass_add_rec,

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

2854: AND NVL(assigned_to,-1) = NVL(p_asset_query_rec.employee_id,NVL(assigned_to,-1))
2855: AND date_ineffective IS NULL ;
2856:
2857: CURSOR asset_cost_cur IS
2858: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)
2859: Material_cost ,
2860: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))
2861: Non_Material_cost
2862: FROM fa_asset_invoices

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

2856:
2857: CURSOR asset_cost_cur IS
2858: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)
2859: Material_cost ,
2860: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))
2861: Non_Material_cost
2862: FROM fa_asset_invoices
2863: WHERE date_ineffective IS NULL
2864: AND asset_id = p_asset_query_rec.asset_id

Line 3138: cse_asset_util_pkg.get_pending_retirements(p_asset_query_rec,

3134: ---08/28 changed to total_units instead of location_units
3135: ----p_asset_query_rec.current_units := l_location_units ;
3136: p_asset_query_rec.current_units := l_total_units ;
3137:
3138: cse_asset_util_pkg.get_pending_retirements(p_asset_query_rec,
3139: p_distribution_tbl,
3140: x_return_status,
3141: x_error_msg);
3142:

Line 3148: cse_asset_util_pkg.get_pending_adjustments(p_asset_query_rec,

3144: THEN
3145: RAISE e_error ;
3146: END IF;
3147:
3148: cse_asset_util_pkg.get_pending_adjustments(p_asset_query_rec,
3149: x_return_status,
3150: x_error_msg);
3151:
3152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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

3268: IF p_mtl_percent <> 0 THEN
3269:
3270: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*p_mtl_percent ;
3271: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*p_mtl_percent ;
3272: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;
3273:
3274: cse_asset_util_pkg.insert_mass_add(
3275: 1.0,
3276: fnd_api.g_false,

Line 3274: cse_asset_util_pkg.insert_mass_add(

3270: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*p_mtl_percent ;
3271: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*p_mtl_percent ;
3272: l_mass_add_rec.attribute14 := cse_asset_util_pkg.G_MTL_INDICATOR ;
3273:
3274: cse_asset_util_pkg.insert_mass_add(
3275: 1.0,
3276: fnd_api.g_false,
3277: fnd_api.g_true,
3278: l_mass_add_rec,

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

3290: IF p_mtl_percent <> 1 THEN
3291:
3292: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*(1 - p_mtl_percent) ;
3293: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*(1 - p_mtl_percent) ;
3294: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;
3295:
3296: cse_asset_util_pkg.insert_mass_add(
3297: 1.0,
3298: fnd_api.g_false,

Line 3296: cse_asset_util_pkg.insert_mass_add(

3292: l_mass_add_rec.fixed_assets_cost := p_mass_add_rec.fixed_assets_cost*(1 - p_mtl_percent) ;
3293: l_mass_add_rec.payables_cost := p_mass_add_rec.payables_cost*(1 - p_mtl_percent) ;
3294: l_mass_add_rec.attribute14 := cse_asset_util_pkg.g_non_mtl_indicator;
3295:
3296: cse_asset_util_pkg.insert_mass_add(
3297: 1.0,
3298: fnd_api.g_false,
3299: fnd_api.g_true,
3300: l_mass_add_rec,