[Home] [Help]
5817: l_contracts_status VARCHAR2(3);
5818: l_account_id NUMBER;
5819: l_party_id NUMBER;
5820: l_party_src_tbl VARCHAR2(30);
5821: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5822: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5823: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5824: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5825: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5904: l_error_array dbms_sql.Varchar2_Table;
5905: l_num_of_rows NUMBER;
5906: l_upd_stmt VARCHAR2(2000);
5907: l_dummy NUMBER;
5908: l_instance_status VARCHAR2(50) := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
5909: l_status_id NUMBER;
5910: l_owner_party_id NUMBER;
5911: l_vld_organization_id NUMBER;
5912: l_location_id NUMBER;
5947: l_txn_ctr NUMBER;
5948: l_valid_flag VARCHAR2(1);
5949: l_ctr_exists_flag VARCHAR2(1);
5950: l_ctr_instantiate VARCHAR2(1);
5951: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');
5952: l_ctr_grp_id_template NUMBER;
5953: l_ctr_grp_id_instance NUMBER;
5954: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
5955: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
5999: -- Initialize API return status to success
6000: x_return_status := FND_API.G_RET_STS_SUCCESS;
6001:
6002: -- Check the profile option debug_level for debug message reporting
6003: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6004:
6005: -- If debug_level = 1 then dump the procedure name
6006: IF (l_debug_level > 0) THEN
6007: csi_gen_utility_pvt.put_line( 'create_item_instance');
7999: -- Initialize API return status to success
8000: x_return_status := FND_API.G_RET_STS_SUCCESS;
8001:
8002: -- Check the profile option debug_level for debug message reporting
8003: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
8004:
8005: -- If debug_level = 1 then dump the procedure name
8006: IF (l_debug_level > 0) THEN
8007: csi_gen_utility_pvt.put_line( 'update_item_instance');
9285: -- Initialize API return status to success
9286: x_return_status := FND_API.G_RET_STS_SUCCESS;
9287:
9288: -- Check the profile option debug_level for debug message reporting
9289: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
9290:
9291: -- If debug_level = 1 then dump the procedure name
9292: IF (l_debug_level > 0) THEN
9293: csi_gen_utility_pvt.put_line( 'expire_item_instance');
10119: END IF;
10120: -- Initialize API return status to success
10121: x_return_status := FND_API.G_RET_STS_SUCCESS;
10122: -- Check the profile option debug_level for debug message reporting
10123: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10124: -- If debug_level = 1 then dump the procedure name
10125: IF (l_debug_level > 0) THEN
10126: csi_gen_utility_pvt.put_line( 'explode_bom (Group)');
10127: END IF;
10551: -- Initialize API return status to success
10552: x_return_status := FND_API.G_RET_STS_SUCCESS;
10553:
10554: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
10555: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10556:
10557: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
10558: IF (l_csi_debug_level > 0) THEN
10559: csi_gen_utility_pvt.put_line( 'lock_item_instances');
10677: -- Initialize API return status to success
10678: x_return_status := FND_API.G_RET_STS_SUCCESS;
10679:
10680: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
10681: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10682:
10683: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
10684: IF (l_csi_debug_level > 0) THEN
10685: csi_gen_utility_pvt.put_line( 'unlock_item_instances');