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 958: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');

954: select fnd_date.date_to_canonical(TRUNC(SYSDATE))
955: into l_start_date_active
956: from DUAL;
957:
958: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
959: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
960:
961: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
962: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);

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

955: into l_start_date_active
956: from DUAL;
957:
958: l_qp_pte := FND_PROFILE.VALUE('QP_PRICING_TRANSACTION_ENTITY');
959: l_qp_source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
960:
961: l_header_flex_enabled := get_flex_enabled_flag('QP_LIST_HEADERS');
962: qp_bulk_loader_pub.write_log('Flex enabled '||l_header_flex_enabled);
963:

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

1104: END IF;
1105: END IF;
1106:
1107: --curency_header_id (conditionally required)
1108: If NVL(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'
1109: AND p_header_rec.currency_header_id(I) IS NULL
1110: THEN
1111:
1112: p_header_rec.process_status_flag(I):=NULL;

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

1200: END IF;
1201: -- Bug 4929691 END RAVI (5207598,5207612)
1202:
1203: -- Rounding factor value check
1204: l_unit_precision_type := FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
1205: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
1206:
1207: IF p_header_rec.currency_code(I) is not null THEN
1208: BEGIN

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

1201: -- Bug 4929691 END RAVI (5207598,5207612)
1202:
1203: -- Rounding factor value check
1204: l_unit_precision_type := FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
1205: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
1206:
1207: IF p_header_rec.currency_code(I) is not null THEN
1208: BEGIN
1209: SELECT -1*PRECISION, -1*EXTENDED_PRECISION

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

1529:
1530: --Defaulting
1531: -- Basic_Pricing_Condition
1532: IF (QP_BULK_LOADER_PUB.GET_QP_STATUS <> 'I' OR
1533: FND_PROFILE.VALUE('QP_MULTI_CURRENCY_INSTALLED') = 'N')
1534: AND p_header_rec.currency_header_id(I) IS NOT NULL THEN
1535: -- No multi currency in Basic Pricing
1536: p_header_rec.currency_header_id(I) := NULL;
1537: END IF;

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

1869: and qipa.request_id = p_line_rec.request_id(I)
1870: and qipa.product_attribute_context = 'ITEM'
1871: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
1872: and msiv.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
1873: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
1874: and msiv.service_item_flag = 'Y'
1875: and qipa.interface_action_code in ('INSERT','UPDATE');
1876: exception
1877: when NO_DATA_FOUND then

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

1887: and qpa.orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
1888: and qpa.product_attribute_context = 'ITEM'
1889: and qpa.product_attribute = 'PRICING_ATTRIBUTE1'
1890: and msiv.inventory_item_id = to_number(qpa.PRODUCT_ATTR_VALUE)
1891: and msiv.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
1892: and msiv.service_item_flag = 'Y'
1893: and qpa.orig_sys_pricing_attr_ref not in (
1894: select qpa.orig_sys_pricing_attr_ref
1895: from qp_interface_pricing_attribs qipa

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

3604: qp_number.canonical_to_number(pb.pricing_attr_value_to));
3605:
3606: BEGIN
3607: qp_bulk_loader_pub.write_log('Entering Entity pricing attribute validation');
3608: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
3609:
3610: FOR I IN 1..p_pricing_attr_rec.orig_sys_pricing_attr_ref.COUNT
3611: LOOP
3612:

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

3656: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3657: and qipa.product_attribute_context = 'ITEM'
3658: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
3659: and msi.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
3660: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
3661: and msi.purchasing_enabled_flag = 'Y'
3662: and qipa.interface_action_code in ('INSERT','UPDATE');
3663: Exception
3664: when NO_DATA_FOUND then

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

3672: and qipa.request_id = P_PRICING_ATTR_REC.REQUEST_ID(I)
3673: and qipa.product_attribute_context = 'ITEM'
3674: and qipa.product_attribute = 'PRICING_ATTRIBUTE1'
3675: and msi.inventory_item_id = to_number(qipa.PRODUCT_ATTR_VALUE)
3676: and msi.organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
3677: and msi.CUSTOMER_ORDER_flag = 'Y'
3678: and qipa.interface_action_code in ('INSERT','UPDATE');
3679: Exception
3680: when NO_DATA_FOUND then

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

3773: IF p_PRICING_ATTR_rec.product_attribute_context(I) = 'ITEM' AND
3774: p_PRICING_ATTR_rec.product_attribute(I) = 'PRICING_ATTRIBUTE2' THEN
3775: BEGIN
3776:
3777: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3778: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3779: INTO l_pte_code, l_ss_code
3780: FROM qp_interface_list_headers
3781: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);

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

3774: p_PRICING_ATTR_rec.product_attribute(I) = 'PRICING_ATTRIBUTE2' THEN
3775: BEGIN
3776:
3777: SELECT nvl(pte_code, fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY')),
3778: nvl(source_system_code, fnd_profile.value('QP_SOURCE_SYSTEM_CODE'))
3779: INTO l_pte_code, l_ss_code
3780: FROM qp_interface_list_headers
3781: WHERE orig_sys_header_ref = p_PRICING_ATTR_rec.orig_sys_header_ref(I);
3782:

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

5633: WHERE qpih.request_id = p_request_id
5634: AND qpih.process_status_flag ='P' --is null
5635: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5636: -- Bug 5416556 RAVI
5637: --Only Price Lists with source system code equal to FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') should be updated.
5638: AND qpih.source_system_code <> FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
5639:
5640: --for bug 4731613 moved this validation to attribute_header procedure
5641: -- 12. Validate Orig_Org_Id

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

5634: AND qpih.process_status_flag ='P' --is null
5635: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5636: -- Bug 5416556 RAVI
5637: --Only Price Lists with source system code equal to FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE') should be updated.
5638: AND qpih.source_system_code <> FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
5639:
5640: --for bug 4731613 moved this validation to attribute_header procedure
5641: -- 12. Validate Orig_Org_Id
5642:

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

5742:
5743: BEGIN
5744:
5745: qp_bulk_loader_pub.write_log('Entering Attribute qualifier validation');
5746: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
5747: --1. Comparison Operator
5748:
5749: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
5750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','COMPARISON OPERATOR');

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

6002:
6003: BEGIN
6004:
6005: qp_bulk_loader_pub.write_log('Entering Attribute line validation');
6006: FND_PROFILE.GET('QP_PRICING_TRANSACTION_ENTITY',l_pte_code);
6007:
6008: -- 1. LIST LINE TYPE CODE
6009: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
6010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST_LINE_TYPE_CODE');