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 3325: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE',

3321: Get_ItemAttributes(p_Inventory_Item_Id => p_Product_Txn_Rec.Inventory_Item_Id,
3322: p_inv_org_id => p_Product_Txn_Rec.inventory_org_id,
3323: x_ItemAttributes => l_ItemAttributes);
3324: -- Get the default pick rule id
3325: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE',
3326: l_auto_reserve_profile);
3327: if(l_auto_reserve_profile is null) then
3328: l_auto_reserve_profile := 'N';
3329: end if;

Line 3384: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',

3380: -- not have it.
3381: IF (p_product_txn_rec.picking_rule_id IS NULL)
3382: THEN
3383: -- Get the default pick rule id
3384: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',
3385: l_picking_rule_id);
3386:
3387: Debug('l_picking_rule_id =' || l_picking_rule_id,
3388: l_mod_name,