APPS.CSD_LOGISTICS_UTIL dependencies on FND_PROFILE

Line 170: Fnd_Profile.value('CS_INV_VALIDATION_ORG')

166: AND m.enabled_flag = 'Y'
167: AND NVL(m.service_item_flag, 'N') = 'N'
168: AND m.serv_req_enabled_code = 'E'
169: AND m.organization_id =
170: Fnd_Profile.value('CS_INV_VALIDATION_ORG')
171: AND TRUNC(SYSDATE) BETWEEN
172: TRUNC(NVL(m.start_date_active, SYSDATE)) AND
173: TRUNC(NVL(m.end_date_active, SYSDATE));
174:

Line 277: AND organization_id = Fnd_Profile.value('CS_INV_VALIDATION_ORG')

273: SELECT revision
274: INTO l_revision
275: FROM mtl_item_revisions
276: WHERE inventory_item_id = p_inventory_item_id
277: AND organization_id = Fnd_Profile.value('CS_INV_VALIDATION_ORG')
278: AND revision = p_Revision;
279:
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN

Line 1000: AND Organization_Id = Fnd_Profile.value('CS_INV_VALIDATION_ORG');

996: SELECT Concatenated_Segments
997: INTO x_Concatenated_Segments
998: FROM mtl_system_items_kfv
999: WHERE Inventory_Item_Id = p_Inventory_item_Id
1000: AND Organization_Id = Fnd_Profile.value('CS_INV_VALIDATION_ORG');
1001:
1002: --SU:02/24: Following statement can be commented.
1003: --x_Concatenated_Segments := l_Concatenated_Segments;
1004:

Line 2164: C_STATEMENT_LEVEL CONSTANT NUMBER := 4; -- temporarily changed to 4 from 1 since the fnd profile can not be changed.

2160: ) IS
2161:
2162:
2163: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_logistics_util.upd_prodtxn_n_chrgline';
2164: C_STATEMENT_LEVEL CONSTANT NUMBER := 4; -- temporarily changed to 4 from 1 since the fnd profile can not be changed.
2165: C_EXCEPTION_LEVEL CONSTANT NUMBER := 4;
2166: l_tmp_char VARCHAR2(1) ;
2167: l_est_detail_id NUMBER;
2168: l_check VARCHAR2(1);

Line 2766: FND_PROFILE.PUT('CSD_UNIT_NUMBER', p_product_txn_rec.unit_number);

2762: 1);
2763:
2764: --taklam
2765: if (p_product_txn_rec.unit_number) is not null then
2766: FND_PROFILE.PUT('CSD_UNIT_NUMBER', p_product_txn_rec.unit_number);
2767: end if;
2768:
2769: Csd_Process_Pvt.PROCESS_SALES_ORDER(p_api_version => 1.0,
2770: p_commit => Fnd_Api.g_false,

Line 2781: FND_PROFILE.PUT('CSD_UNIT_NUMBER',null);

2777: x_msg_data => l_msg_data);
2778:
2779: --taklam
2780: if (p_product_txn_rec.unit_number) is not null then
2781: FND_PROFILE.PUT('CSD_UNIT_NUMBER',null);
2782: end if;
2783:
2784: IF NOT (l_return_status = Fnd_Api.G_RET_STS_SUCCESS)
2785: THEN

Line 3339: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE',

3335: Get_ItemAttributes(p_Inventory_Item_Id => p_Product_Txn_Rec.Inventory_Item_Id,
3336: p_inv_org_id => p_Product_Txn_Rec.inventory_org_id,
3337: x_ItemAttributes => l_ItemAttributes);
3338: -- Get the default pick rule id
3339: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE',
3340: l_auto_reserve_profile);
3341: if(l_auto_reserve_profile is null) then
3342: l_auto_reserve_profile := 'N';
3343: end if;

Line 3398: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',

3394: -- not have it.
3395: IF (p_product_txn_rec.picking_rule_id IS NULL)
3396: THEN
3397: -- Get the default pick rule id
3398: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',
3399: l_picking_rule_id);
3400:
3401: Debug('l_picking_rule_id =' || l_picking_rule_id,
3402: l_mod_name,