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.

APPS.QP_BULK_VALIDATE dependencies on FND_PROFILE

Line 1114: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');

1110: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
1111: into l_start_date_active
1112: from DUAL;
1113:
1114: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
1115: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
1116:
1117: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
1118: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);

Line 1115: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');

1111: into l_start_date_active
1112: from DUAL;
1113:
1114: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
1115: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
1116:
1117: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
1118: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);
1119:

Line 1264: If NVL(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'

1260: END IF;
1261: END IF;
1262:
1263: --curency_header_id (conditionally required)
1264: If NVL(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'
1265: AND p_header_rec.currency_header_id(I) IS NULL
1266: THEN
1267:
1268: p_header_rec.process_status_flag(I):=NULL;

Line 1360: l_unit_precision_type := FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');

1356: END IF;
1357: -- Bug 4929691 END RAVI (5207598,5207612)
1358:
1359: -- Rounding factor value check
1360: l_unit_precision_type := FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
1361: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
1362:
1363: IF p_header_rec.currency_code(I) is not null THEN
1364: BEGIN

Line 1361: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');

1357: -- Bug 4929691 END RAVI (5207598,5207612)
1358:
1359: -- Rounding factor value check
1360: l_unit_precision_type := FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
1361: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
1362:
1363: IF p_header_rec.currency_code(I) is not null THEN
1364: BEGIN
1365: SELECT -1*PRECISION, -1*EXTENDED_PRECISION

Line 1689: FND_PROFILE.VALUE('QP_MULTI_CURRENCY_INSTALLED') = 'N')

1685:
1686: --Defaulting
1687: -- Basic_Pricing_Condition
1688: IF (QP_BULK_LOADER_PUB.GET_QP_STATUS <> 'I' OR
1689: FND_PROFILE.VALUE('QP_MULTI_CURRENCY_INSTALLED') = 'N')
1690: AND p_header_rec.currency_header_id(I) IS NOT NULL THEN
1691: -- No multi currency in Basic Pricing
1692: p_header_rec.currency_header_id(I) := NULL;
1693: END IF;

Line 2029: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

2025: and qipa.request_id = p_line_rec.request_id(I)
2026: and qipa.product_attribute_context = 'ITEM'
2027: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
2028: and msiv.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
2029: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
2030: and msiv.service_item_flag = 'Y'
2031: and qipa.interface_action_code in ('INSERT','UPDATE');
2032: exception
2033: when NO_DATA_FOUND then

Line 2047: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

2043: and qpa.orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
2044: and qpa.product_attribute_context = 'ITEM'
2045: and qpa.product_attribute = 'PRICING_ATTRIBUTE1'
2046: and msiv.inventory_item_id = to_number(qpa.PRODUCT_ATTR_VALUE)
2047: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
2048: and msiv.service_item_flag = 'Y'
2049: and qpa.orig_sys_pricing_attr_ref not in (
2050: select qpa.orig_sys_pricing_attr_ref
2051: from qp_interface_pricing_attribs qipa

Line 3720: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

3716: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3717:
3718: BEGIN
3719: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');
3720: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
3721:
3722: FOR I IN 1..p_pricing_attr_rec.orig_sys_pricing_attr_ref.COUNT
3723: LOOP
3724:

Line 3772: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

3768: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3769: and qipa.product_attribute_context = 'ITEM'
3770: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
3771: and msi.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
3772: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
3773: and msi.purchasing_enabled_flag = 'Y'
3774: and qipa.interface_action_code in ('INSERT','UPDATE');
3775: Exception
3776: when NO_DATA_FOUND then

Line 3788: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')

3784: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3785: and qipa.product_attribute_context = 'ITEM'
3786: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
3787: and msi.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
3788: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
3789: and msi.CUSTOMER_ORDER_flag = 'Y'
3790: and qipa.interface_action_code in ('INSERT','UPDATE');
3791: Exception
3792: when NO_DATA_FOUND then

Line 3889: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),

3885: IF p_PRICING_ATTR_rec.product_attribute_context(I) = 'ITEM' AND
3886: p_PRICING_ATTR_rec.product_attribute(I) = 'PRICING_ATTRIBUTE2' THEN
3887: BEGIN
3888:
3889: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3890: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3891: INTO l_pte_code, l_ss_code
3892: FROM qp_interface_list_headers
3893: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);

Line 3890: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))

3886: p_PRICING_ATTR_rec.product_attribute(I) = 'PRICING_ATTRIBUTE2' THEN
3887: BEGIN
3888:
3889: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3890: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3891: INTO l_pte_code, l_ss_code
3892: FROM qp_interface_list_headers
3893: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);
3894:

Line 5649: --Only Price Lists with source system code equal to FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') should be updated.

5645: WHERE qpih.request_id = p_request_id
5646: AND qpih.process_status_flag ='P' --is null
5647: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5648: -- Bug 5416556 RAVI
5649: --Only Price Lists with source system code equal to FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') should be updated.
5650: AND qpih.source_system_code <> FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
5651:
5652: --for bug 4731613 moved this validation to attribute_header procedure
5653: -- 12. Validate Orig_Org_Id

Line 5650: AND qpih.source_system_code <> FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');

5646: AND qpih.process_status_flag ='P' --is null
5647: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5648: -- Bug 5416556 RAVI
5649: --Only Price Lists with source system code equal to FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') should be updated.
5650: AND qpih.source_system_code <> FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
5651:
5652: --for bug 4731613 moved this validation to attribute_header procedure
5653: -- 12. Validate Orig_Org_Id
5654:

Line 5758: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

5754:
5755: BEGIN
5756:
5757: qp_bulk_loader_pub.write_log('Entering Attribute qualifier validation');
5758: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
5759: --1. Comparison Operator
5760:
5761: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','COMPARISON OPERATOR');

Line 6018: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);

6014:
6015: BEGIN
6016:
6017: qp_bulk_loader_pub.write_log('Entering Attribute line validation');
6018: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
6019:
6020: -- 1. LIST LINE TYPE CODE
6021: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6022: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST_LINE_TYPE_CODE');