DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on FND_PROFILE

Line 148: If ( fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'Y') then

144: -- If the Owner party <> Entered Party and if the
145: -- Change IB Owner profile is set to Yes then
146: -- Change the IB Owner.
147: If ( l_owner_party_id <> p_party_id ) then
148: If ( fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'Y') then
149: x_warning_flag := 'Y';
150: x_warning_reason_code := 'CHANGE_IB_OWNER';
151: x_internal_sr_flag := 'N';
152: x_change_owner_flag := 'Y';

Line 303: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');

299: Close c_ship_to_site;
300:
301: -- Assign / Initialize the Service request Rec
302: l_service_request_rec.request_date := sysdate;
303: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
307: l_service_request_rec.closed_date := null;

Line 304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');

300:
301: -- Assign / Initialize the Service request Rec
302: l_service_request_rec.request_date := sysdate;
303: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
307: l_service_request_rec.closed_date := null;
308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');

Line 305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');

301: -- Assign / Initialize the Service request Rec
302: l_service_request_rec.request_date := sysdate;
303: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
307: l_service_request_rec.closed_date := null;
308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
309: l_service_request_rec.owner_group_id := NULL;

Line 306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');

302: l_service_request_rec.request_date := sysdate;
303: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
307: l_service_request_rec.closed_date := null;
308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
309: l_service_request_rec.owner_group_id := NULL;
310: l_service_request_rec.publish_flag := '';

Line 308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');

304: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
305: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
306: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
307: l_service_request_rec.closed_date := null;
308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
309: l_service_request_rec.owner_group_id := NULL;
310: l_service_request_rec.publish_flag := '';
311: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
312: l_service_request_rec.caller_type := l_party_type;

Line 311: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');

307: l_service_request_rec.closed_date := null;
308: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
309: l_service_request_rec.owner_group_id := NULL;
310: l_service_request_rec.publish_flag := '';
311: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
312: l_service_request_rec.caller_type := l_party_type;
313: l_service_request_rec.customer_id := p_bulk_receive_rec.party_id;
314: l_service_request_rec.customer_number := null;
315: l_service_request_rec.customer_product_id := null;

Line 338: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');

334: l_service_request_rec.contact_point_type := null;
335: l_service_request_rec.primary_flag := null;
336: l_service_request_rec.contact_type := null;
337: l_service_request_rec.sr_creation_channel := 'PHONE';
338: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');
339:
340:
341: -- Call the Service Request API
342: CSD_PROCESS_PVT.process_service_request

Line 660: --l_repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');

656:
657: End if;
658:
659: -- swai: bug 7657379 use defaulting rules to get the repair type
660: --l_repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');
661: l_repair_type_id := get_bulk_rcv_def_repair_type (
662: p_incident_id => l_blkrcv_rec.incident_id,
663: p_ro_inventory_item_id => l_blkrcv_rec.inventory_item_id);
664:

Line 675: -- l_repln_rec.currency_code := CSD_CHARGE_LINE_UTIL.GET_PLCURRCODE(fnd_profile.value('CSD_DEFAULT_PRICE_LIST'));

671:
672: -- Fix for bug#6082836
673: -- Derive the Currency code
674: --If ( l_repair_type_pl is null ) then
675: -- l_repln_rec.currency_code := CSD_CHARGE_LINE_UTIL.GET_PLCURRCODE(fnd_profile.value('CSD_DEFAULT_PRICE_LIST'));
676: --Else
677: -- l_repln_rec.currency_code := CSD_CHARGE_LINE_UTIL.GET_PLCURRCODE(l_repair_type_pl);
678: --End if;
679:

Line 692: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);

688: Open c_get_install_site_use_id(l_instance_id);
689: Fetch c_get_install_site_use_id into l_install_site_use_id;
690: Close c_get_install_site_use_id;
691:
692: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
693:
694: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
695: p_api_version_number => 1.0,
696: p_init_msg_list => fnd_api.g_false,

Line 786: -- l_repln_rec.inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');

782: --
783: -- Inventory org id
784: --
785: -- swai: bug 7657379 - use defaulting rules to get the inventory org
786: -- l_repln_rec.inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
787: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
788:
789: --
790: -- Initialize / Assign the values to Repair Rec type

Line 801: -- l_repln_rec.repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');

797: l_repln_rec.quantity := l_blkrcv_rec.quantity;
798: l_repln_rec.auto_process_rma := 'Y';
799: l_repln_rec.approval_required_flag := 'Y';
800: l_repln_rec.repair_type_id := l_repair_type_id; -- swai: bug 7657379
801: -- l_repln_rec.repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');
802: l_repln_rec.repair_group_id := null;
803: l_repln_rec.item_revision := l_revision;
804: l_repln_rec.repair_mode := l_repair_mode;
805:

Line 1287: --l_rcv_rec_tbl(i).subinventory := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');

1283: l_rcv_rec_tbl(i).item_revision := null;
1284: l_rcv_rec_tbl(i).to_organization_id := l_org_id;
1285: l_rcv_rec_tbl(i).destination_type_code := null;
1286: -- swai: bug 7663674
1287: --l_rcv_rec_tbl(i).subinventory := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');
1288: l_rcv_rec_tbl(i).subinventory := get_bulk_rcv_def_sub_inv( p_bulk_autorcv_tbl(l_tbl_id).repair_line_id);
1289: l_rcv_rec_tbl(i).locator_id := null;
1290: l_rcv_rec_tbl(i).deliver_to_location_id := null;
1291: l_rcv_rec_tbl(i).requisition_number := null;

Line 1866: l_repair_type_id := to_number(fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE'));

1862: (l_default_rule_id is not null)
1863: then
1864: l_repair_type_id := l_default_val_num;
1865: else
1866: l_repair_type_id := to_number(fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE'));
1867: end if;
1868:
1869: return l_repair_type_id;
1870:

Line 1924: l_rma_subinv := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');

1920: (l_default_rule_id is not null)
1921: then
1922: l_rma_subinv := l_default_val_str;
1923: else
1924: l_rma_subinv := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');
1925: end if;
1926:
1927: return l_rma_subinv;
1928: