eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on FND_PROFILE

Line 534: l_crt_inst_party_relation VARCHAR2(30) := fnd_profile.value('CSD_DEF_INST_PTY_RELTN');

530: c_non_serialized CONSTANT Number := 1;
531: c_ib CONSTANT Varchar2(1) := 'Y';
532: c_non_ib CONSTANT Varchar2(1) := 'N';
533:
534: l_crt_inst_party_relation VARCHAR2(30) := fnd_profile.value('CSD_DEF_INST_PTY_RELTN');
535: l_relationship VARCHAR2(30);
536: l_check_owner BOOLEAN := FALSE;
537: x_msg_count NUMBER;
538: x_msg_data VARCHAR2(2000);

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

667: -- If the Owner party <> Entered Party and if the
668: -- Change IB Owner profile is set to Yes then
669: -- Change the IB Owner.
670: If ( l_owner_party_id <> p_party_id ) AND l_check_owner then
671: If ( fnd_profile.value('CSD_BLK_RCV_CHG_IB_OWNER') = 'Y') then
672: x_warning_flag := 'Y';
673: x_warning_reason_code := 'CHANGE_IB_OWNER';
674: x_internal_sr_flag := 'N';
675: x_change_owner_flag := 'Y';

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

822: Close c_ship_to_site;
823:
824: -- Assign / Initialize the Service request Rec
825: l_service_request_rec.request_date := sysdate;
826: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
827: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
828: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
829: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
830: l_service_request_rec.closed_date := null;

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

823:
824: -- Assign / Initialize the Service request Rec
825: l_service_request_rec.request_date := sysdate;
826: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
827: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
828: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
829: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
830: l_service_request_rec.closed_date := null;
831: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');

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

824: -- Assign / Initialize the Service request Rec
825: l_service_request_rec.request_date := sysdate;
826: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
827: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
828: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
829: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
830: l_service_request_rec.closed_date := null;
831: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
832: l_service_request_rec.owner_group_id := NULL;

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

825: l_service_request_rec.request_date := sysdate;
826: l_service_request_rec.type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_TYPE');
827: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
828: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
829: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
830: l_service_request_rec.closed_date := null;
831: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
832: l_service_request_rec.owner_group_id := NULL;
833: l_service_request_rec.publish_flag := '';

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

827: l_service_request_rec.status_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_STATUS');
828: l_service_request_rec.severity_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SEVERITY');
829: l_service_request_rec.urgency_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_URGENCY');
830: l_service_request_rec.closed_date := null;
831: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
832: l_service_request_rec.owner_group_id := NULL;
833: l_service_request_rec.publish_flag := '';
834: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
835: l_service_request_rec.caller_type := l_party_type;

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

830: l_service_request_rec.closed_date := null;
831: l_service_request_rec.owner_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_OWNER');
832: l_service_request_rec.owner_group_id := NULL;
833: l_service_request_rec.publish_flag := '';
834: l_service_request_rec.summary := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SR_SUMMARY');
835: l_service_request_rec.caller_type := l_party_type;
836: l_service_request_rec.customer_id := p_bulk_receive_rec.party_id;
837: l_service_request_rec.customer_number := null;
838: l_service_request_rec.customer_product_id := null;

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

857: l_service_request_rec.contact_point_type := null;
858: l_service_request_rec.primary_flag := null;
859: l_service_request_rec.contact_type := null;
860: l_service_request_rec.sr_creation_channel := 'PHONE';
861: l_service_request_rec.resource_type := FND_PROFILE.value('CS_SR_DEFAULT_OWNER_TYPE');
862:
863:
864: -- Call the Service Request API
865: CSD_PROCESS_PVT.process_service_request

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

1199:
1200: End if;
1201:
1202: -- swai: bug 7657379 use defaulting rules to get the repair type
1203: --l_repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');
1204: l_repair_type_id := get_bulk_rcv_def_repair_type (
1205: p_incident_id => l_blkrcv_rec.incident_id,
1206: p_ro_inventory_item_id => l_blkrcv_rec.inventory_item_id);
1207:

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

1214:
1215: -- Fix for bug#6082836
1216: -- Derive the Currency code
1217: --If ( l_repair_type_pl is null ) then
1218: -- l_repln_rec.currency_code := CSD_CHARGE_LINE_UTIL.GET_PLCURRCODE(fnd_profile.value('CSD_DEFAULT_PRICE_LIST'));
1219: --Else
1220: -- l_repln_rec.currency_code := CSD_CHARGE_LINE_UTIL.GET_PLCURRCODE(l_repair_type_pl);
1221: --End if;
1222:

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

1231: Open c_get_install_site_use_id(l_instance_id);
1232: Fetch c_get_install_site_use_id into l_install_site_use_id;
1233: Close c_get_install_site_use_id;
1234:
1235: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
1236:
1237: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
1238: p_api_version_number => 1.0,
1239: p_init_msg_list => fnd_api.g_false,

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

1325: --
1326: -- Inventory org id
1327: --
1328: -- swai: bug 7657379 - use defaulting rules to get the inventory org
1329: -- l_repln_rec.inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
1330: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
1331:
1332: --
1333: -- Initialize / Assign the values to Repair Rec type

Line 1339: l_repln_rec.resource_group := fnd_profile.value('CSD_DEFAULT_REPAIR_ORG');

1335:
1336: -- bug#13006845 --13734356
1337: -- Default Repair Org
1338: --
1339: l_repln_rec.resource_group := fnd_profile.value('CSD_DEFAULT_REPAIR_ORG');
1340: -- bug#13006845 --13734356
1341:
1342: l_repln_rec.incident_id := l_blkrcv_rec.incident_id;
1343: l_repln_rec.inventory_item_id := l_blkrcv_rec.inventory_item_id;

Line 1349: l_repln_rec.approval_required_flag := NVL(fnd_profile.value('CSD_CUST_APPROVAL_REQD'),'N');

1345: l_repln_rec.unit_of_measure := l_uom_code;
1346: l_repln_rec.serial_number := l_blkrcv_rec.serial_number;
1347: l_repln_rec.quantity := l_blkrcv_rec.quantity;
1348: l_repln_rec.auto_process_rma := 'Y';
1349: l_repln_rec.approval_required_flag := NVL(fnd_profile.value('CSD_CUST_APPROVAL_REQD'),'N');
1350: l_repln_rec.repair_type_id := l_repair_type_id; -- swai: bug 7657379
1351: -- l_repln_rec.repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');
1352: l_repln_rec.repair_group_id := null;
1353: l_repln_rec.item_revision := l_revision;

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

1347: l_repln_rec.quantity := l_blkrcv_rec.quantity;
1348: l_repln_rec.auto_process_rma := 'Y';
1349: l_repln_rec.approval_required_flag := NVL(fnd_profile.value('CSD_CUST_APPROVAL_REQD'),'N');
1350: l_repln_rec.repair_type_id := l_repair_type_id; -- swai: bug 7657379
1351: -- l_repln_rec.repair_type_id := fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE');
1352: l_repln_rec.repair_group_id := null;
1353: l_repln_rec.item_revision := l_revision;
1354: l_repln_rec.repair_mode := l_repair_mode;
1355:

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

1883: l_rcv_rec_tbl(i).item_revision := p_bulk_autorcv_tbl(l_tbl_id).item_revision;
1884: l_rcv_rec_tbl(i).to_organization_id := l_org_id;
1885: l_rcv_rec_tbl(i).destination_type_code := null;
1886: -- swai: bug 7663674
1887: --l_rcv_rec_tbl(i).subinventory := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');
1888: l_rcv_rec_tbl(i).subinventory := get_bulk_rcv_def_sub_inv( p_bulk_autorcv_tbl(l_tbl_id).repair_line_id);
1889: --l_rcv_rec_tbl(i).locator_id := null;
1890: l_rcv_rec_tbl(i).deliver_to_location_id := null;
1891: l_rcv_rec_tbl(i).requisition_number := null;

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

2535: (l_default_rule_id is not null)
2536: then
2537: l_repair_type_id := l_default_val_num;
2538: else
2539: l_repair_type_id := to_number(fnd_profile.value('CSD_BLK_RCV_DEFAULT_REPAIR_TYPE'));
2540: end if;
2541:
2542: return l_repair_type_id;
2543:

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

2593: (l_default_rule_id is not null)
2594: then
2595: l_rma_subinv := l_default_val_str;
2596: else
2597: l_rma_subinv := fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV');
2598: end if;
2599:
2600: return l_rma_subinv;
2601:

Line 3211: l_add_to_order_ro varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');

3207: ) IS
3208:
3209: l_prod_txn_rec CSD_PROCESS_PVT.PRODUCT_TXN_REC;
3210: l_add_to_order boolean default false;
3211: l_add_to_order_ro varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
3212: l_add_to_order_sr varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
3213:
3214: l_add_to_order_id number default p_order_header_id;
3215:

Line 3212: l_add_to_order_sr varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');

3208:
3209: l_prod_txn_rec CSD_PROCESS_PVT.PRODUCT_TXN_REC;
3210: l_add_to_order boolean default false;
3211: l_add_to_order_ro varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
3212: l_add_to_order_sr varchar2(2) default fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
3213:
3214: l_add_to_order_id number default p_order_header_id;
3215:
3216: BEGIN

Line 3401: and organization_id = FND_PROFILE.VALUE('ORG_ID');

3397: select serial_number_control_code
3398: into x_sr_ro_rma_tbl(i).serial_control_flag
3399: from mtl_system_items_b
3400: where inventory_item_id = x_sr_ro_rma_tbl(i).inventory_item_id
3401: and organization_id = FND_PROFILE.VALUE('ORG_ID');
3402: -- cache the serial flag for this inventory item id.
3403: g_serial_control_flag(x_sr_ro_rma_tbl(i).inventory_item_id) := x_sr_ro_rma_tbl(i).serial_control_flag;
3404: exception
3405: when no_data_found then

Line 3891: l_add_to_order_ro varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');

3887: l_order_line_id number := px_order_line_id;
3888: l_check_loaner varchar2(2) := 'N';
3889:
3890: l_add_to_order boolean := false;
3891: l_add_to_order_ro varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
3892: l_add_to_order_sr varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
3893:
3894: begin
3895:

Line 3892: l_add_to_order_sr varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');

3888: l_check_loaner varchar2(2) := 'N';
3889:
3890: l_add_to_order boolean := false;
3891: l_add_to_order_ro varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_RO');
3892: l_add_to_order_sr varchar2(2) := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
3893:
3894: begin
3895:
3896: savepoint pre_process_rma;