DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on FND_PROFILE

Line 1615: If (fnd_profile.value('CSD_PROCESS_AUTO_PICK_RELEASE') = 'S') then

1611: --'A' means "All ship lines in an order",
1612: --'S' menas "Selected ship line only"
1613: --if the profile value set to "Selected ship line only", then pass the delivery_detail_id
1614: --else it will pass null value to delivery_detail_id.
1615: If (fnd_profile.value('CSD_PROCESS_AUTO_PICK_RELEASE') = 'S') then
1616: open get_delivery_detail_id(p_order_rec.order_header_id, p_order_rec.order_line_id);
1617: fetch get_delivery_detail_id into l_delivery_detail_id;
1618: close get_delivery_detail_id;
1619: End if;

Line 2642: l_no_contract_bp_vldn := NVL(Fnd_Profile.value('CSD_NO_CONTRACT_BP_VLDN'),

2638: Fnd_Api.G_MISS_NUM
2639: THEN
2640: BEGIN
2641: --Bug fix for 3399883 [
2642: l_no_contract_bp_vldn := NVL(Fnd_Profile.value('CSD_NO_CONTRACT_BP_VLDN'),
2643: 'N');
2644:
2645: IF (l_no_contract_bp_vldn = 'Y')
2646: THEN

Line 2877: (nvl(fnd_profile.value('CSD_DEFAULT_SR_ACCT_ADDR_FOR_LOGISTICS'), 'N') = 'Y'))

2873: x_product_txn_rec.line_category_code := l_line_category_code;
2874:
2875: -- swai bug 7572247/7628204: default account primary bill-to and ship to
2876: IF ((l_incident_id is not NULL) AND
2877: (nvl(fnd_profile.value('CSD_DEFAULT_SR_ACCT_ADDR_FOR_LOGISTICS'), 'N') = 'Y'))
2878: THEN
2879:
2880: IF ((nvl(x_product_txn_rec.bill_to_account_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) AND
2881: (nvl(x_product_txn_rec.invoice_to_org_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM))

Line 3103: FND_PROFILE.PUT('CSD_UNIT_NUMBER', x_product_txn_rec.unit_number);

3099: 1);
3100:
3101: --taklam
3102: if (x_product_txn_rec.unit_number) is not null then
3103: FND_PROFILE.PUT('CSD_UNIT_NUMBER', x_product_txn_rec.unit_number);
3104: end if;
3105:
3106: PROCESS_SALES_ORDER(p_api_version => 1.0,
3107: p_commit => Fnd_Api.g_false,

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

3113: x_msg_count => x_msg_count,
3114: x_msg_data => x_msg_data);
3115:
3116: if (x_product_txn_rec.unit_number) is not null then
3117: FND_PROFILE.PUT('CSD_UNIT_NUMBER', null);
3118: end if;
3119:
3120: Debug('x_return_status from process_sales_order =' ||
3121: x_return_status,

Line 3562: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE', l_auto_reserve_profile);

3558: CSD_LOGISTICS_UTIL.Get_ItemAttributes(p_Inventory_Item_Id => x_Product_Txn_Rec.Inventory_Item_Id,
3559: p_inv_org_id => x_Product_Txn_Rec.inventory_org_id,
3560: x_ItemAttributes => l_ItemAttributes);
3561: -- Get the default pick rule id
3562: Fnd_Profile.Get('CSD_AUTO_SRL_RESERVE', l_auto_reserve_profile);
3563: if(l_auto_reserve_profile is null) then
3564: l_auto_reserve_profile := 'N';
3565: end if;
3566:

Line 3622: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',

3618: -- not have it.
3619: IF (x_product_txn_rec.picking_rule_id IS NULL)
3620: THEN
3621: -- Get the default pick rule id
3622: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',
3623: l_picking_rule_id);
3624:
3625: ELSE
3626:

Line 4113: IF Fnd_Profile.value('CSD_DEBUG_LEVEL') > 5

4109: p_api_name => l_api_name);
4110:
4111: -- Dump the IN parameters in the log file
4112: -- if the debug level > 5
4113: IF Fnd_Profile.value('CSD_DEBUG_LEVEL') > 5
4114: THEN
4115: Csd_Gen_Utility_Pvt.dump_prod_txn_rec(p_prod_txn_rec => x_product_txn_rec);
4116: END IF;
4117:

Line 5157: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');

5153: THEN
5154: Csd_Gen_Utility_Pvt.ADD('Build the product txn table');
5155: END IF;
5156:
5157: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
5158: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');
5159:
5160: l_ro_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
5161: l_ro_add_to_order_flag := nvl(l_ro_add_to_order_flag, 'N');

Line 5160: l_ro_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');

5156:
5157: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
5158: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');
5159:
5160: l_ro_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
5161: l_ro_add_to_order_flag := nvl(l_ro_add_to_order_flag, 'N');
5162:
5163: Csd_Process_Util.BUILD_PROD_TXN_TBL(p_repair_line_id => p_repair_line_id,
5164: x_prod_txn_tbl => x_prod_txn_tbl,

Line 7247: l_prof_value := NVL(Fnd_Profile.value('CSD_CLOSE_SR'), 'N');

7243:
7244: (p_pkg_name => G_PKG_NAME, p_api_name => l_api_name);
7245: END IF;
7246:
7247: l_prof_value := NVL(Fnd_Profile.value('CSD_CLOSE_SR'), 'N');
7248: --------------------------------------------
7249: -- Check whether status has to updated for
7250: -- a group / Repair Order
7251: --------------------------------------------

Line 8488: Fnd_Profile.get('csd_pick_release_rule_defect_subinv',

8484: THEN
8485: IF x_product_txn_rec.Action_Type =
8486: C_ACTION_TYPE_MOVE_IN
8487: THEN
8488: Fnd_Profile.get('csd_pick_release_rule_defect_subinv',
8489: l_picking_rule_id);
8490: ELSIF x_product_txn_rec.Action_Type =
8491: C_ACTION_TYPE_MOVE_OUT
8492: THEN

Line 8493: Fnd_Profile.get('csd_pick_release_rule_usable_subinv',

8489: l_picking_rule_id);
8490: ELSIF x_product_txn_rec.Action_Type =
8491: C_ACTION_TYPE_MOVE_OUT
8492: THEN
8493: Fnd_Profile.get('csd_pick_release_rule_usable_subinv',
8494: l_picking_rule_id);
8495: END IF;
8496: ELSE
8497: l_picking_rule_id := x_product_txn_rec.picking_rule_id;

Line 8499: -- fnd_profile.get('csd_def_pick_release_rule',l_picking_rule_id);

8495: END IF;
8496: ELSE
8497: l_picking_rule_id := x_product_txn_rec.picking_rule_id;
8498: END IF;
8499: -- fnd_profile.get('csd_def_pick_release_rule',l_picking_rule_id);
8500: IF l_Statement_level >= l_debug_level
8501: THEN
8502: Fnd_Log.string(l_Statement_level,
8503: l_module_name,