DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on FND_PROFILE

Line 5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');

5820: l_contracts_status VARCHAR2(3);
5821: l_account_id NUMBER;
5822: l_party_id NUMBER;
5823: l_party_src_tbl VARCHAR2(30);
5824: l_version_label VARCHAR2(30) := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
5825: l_temp_party_tbl csi_datastructures_pub.party_tbl;
5826: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
5827: l_temp_org_tbl csi_datastructures_pub.organization_units_tbl;
5828: l_temp_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5911: l_instance_status VARCHAR2(50) := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

5907: l_error_array dbms_sql.Varchar2_Table;
5908: l_num_of_rows NUMBER;
5909: l_upd_stmt VARCHAR2(2000);
5910: l_dummy NUMBER;
5911: l_instance_status VARCHAR2(50) := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
5912: l_status_id NUMBER;
5913: l_owner_party_id NUMBER;
5914: l_vld_organization_id NUMBER;
5915: l_location_id NUMBER;

Line 5985: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');

5981: l_txn_ctr NUMBER;
5982: l_valid_flag VARCHAR2(1);
5983: l_ctr_exists_flag VARCHAR2(1);
5984: l_ctr_instantiate VARCHAR2(1);
5985: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');
5986: l_ctr_grp_id_template NUMBER;
5987: l_ctr_grp_id_instance NUMBER;
5988: l_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
5989: l_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;

Line 6037: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

6033: -- Initialize API return status to success
6034: x_return_status := FND_API.G_RET_STS_SUCCESS;
6035:
6036: -- Check the profile option debug_level for debug message reporting
6037: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6038:
6039: -- If debug_level = 1 then dump the procedure name
6040: IF (l_debug_level > 0) THEN
6041: csi_gen_utility_pvt.put_line( 'create_item_instance');

Line 8540: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

8536: -- Initialize API return status to success
8537: x_return_status := FND_API.G_RET_STS_SUCCESS;
8538:
8539: -- Check the profile option debug_level for debug message reporting
8540: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
8541:
8542: -- If debug_level = 1 then dump the procedure name
8543: IF (l_debug_level > 0) THEN
8544: csi_gen_utility_pvt.put_line( 'update_item_instance');

Line 9844: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

9840: -- Initialize API return status to success
9841: x_return_status := FND_API.G_RET_STS_SUCCESS;
9842:
9843: -- Check the profile option debug_level for debug message reporting
9844: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
9845:
9846: -- If debug_level = 1 then dump the procedure name
9847: IF (l_debug_level > 0) THEN
9848: csi_gen_utility_pvt.put_line( 'expire_item_instance');

Line 10679: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

10675: END IF;
10676: -- Initialize API return status to success
10677: x_return_status := FND_API.G_RET_STS_SUCCESS;
10678: -- Check the profile option debug_level for debug message reporting
10679: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
10680: -- If debug_level = 1 then dump the procedure name
10681: IF (l_debug_level > 0) THEN
10682: csi_gen_utility_pvt.put_line( 'explode_bom (Group)');
10683: END IF;

Line 10691: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');

10687: -- If Y => Shipping/Warehouse Org will be used for BOM child component
10688: -- validation and creation
10689: -- If N => Item validation Org will be used for BOM child component
10690: -- validation and creation
10691: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');
10692: csi_gen_utility_pvt.put_line('Group Explode BOM - l_bom_expl_org_flag - ' || l_bom_expl_org_flag);
10693:
10694: IF p_source_instance_tbl.count > 0 THEN
10695: FOR src_rec in p_source_instance_tbl.FIRST .. p_source_instance_tbl.LAST LOOP

Line 11130: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

11126: -- Initialize API return status to success
11127: x_return_status := FND_API.G_RET_STS_SUCCESS;
11128:
11129: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
11130: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
11131:
11132: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
11133: IF (l_csi_debug_level > 0) THEN
11134: csi_gen_utility_pvt.put_line( 'lock_item_instances');

Line 11256: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

11252: -- Initialize API return status to success
11253: x_return_status := FND_API.G_RET_STS_SUCCESS;
11254:
11255: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
11256: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
11257:
11258: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
11259: IF (l_csi_debug_level > 0) THEN
11260: csi_gen_utility_pvt.put_line( 'unlock_item_instances');