DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_UTIL

Line 78: QP_UTIL.Check_Source_System_Code

74: -- Check whether Source System Code matches
75: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
76: --dbms_output.put_line('Manoj - QPXLPRAB - list_header_id = ' || p_PRICING_ATTR_rec.list_header_id);
77: --dbms_output.put_line('Manoj - QPXLPRAB - list_line_id = ' || p_PRICING_ATTR_rec.list_line_id);
78: QP_UTIL.Check_Source_System_Code
79: (p_list_header_id => p_PRICING_ATTR_rec.list_header_id,
80: p_list_line_id => p_PRICING_ATTR_rec.list_line_id,
81: x_return_status => l_return_status
82: );

Line 440: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,

436:
437: IF p_PRICING_ATTR_rec.pricing_attr_value_from IS NOT NULL
438: THEN
439:
440: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
441: p_PRICING_ATTR_rec.pricing_attr_value_from);
442:
443: If (l_error_code <> 0) -- invalid value
444: Then

Line 465: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,

461:
462: IF p_PRICING_ATTR_rec.pricing_attr_value_to IS NOT NULL
463: THEN
464:
465: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
466: p_PRICING_ATTR_rec.pricing_attr_value_to);
467:
468: If (l_error_code <> 0) -- invalid value
469: Then

Line 555: l_qp_status := QP_UTIL.GET_QP_STATUS;

551: END IF;
552:
553: --- start bug2091362, bug2119287
554:
555: l_qp_status := QP_UTIL.GET_QP_STATUS;
556:
557: IF (fnd_profile.value('QP_ALLOW_DUPLICATE_MODIFIERS') <> 'Y' AND
558: (l_qp_status = 'S' or gsa_ind_cur.gsa_indicator = 'Y')) THEN
559: select start_date_active, end_date_active , list_header_id

Line 665: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'

661: OE_MSG_PUB.Add;
662:
663: END IF;
664:
665: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'
666: ,context =>p_PRICING_ATTR_rec.product_attribute_context
667: ,attribute =>p_PRICING_ATTR_rec.product_attribute
668: ,value =>p_PRICING_ATTR_rec.product_attr_value
669: ,application_short_name => 'QP'

Line 735: QP_UTIL.Get_Item_Cat_Info(

731: FROM qp_list_headers_b h, qp_list_lines l
732: WHERE l.list_line_id = p_PRICING_ATTR_rec.list_line_id
733: AND l.list_header_id = h.list_header_id;
734:
735: QP_UTIL.Get_Item_Cat_Info(
736: p_PRICING_ATTR_rec.product_attr_value,
737: l_pte_code,
738: l_ss_code,
739: l_fna_name,

Line 764: l_return_status := QP_UTIL.Validate_Item(p_PRICING_ATTR_rec.product_attribute_context,

760:
761: oe_debug_pub.add('end attribute ');
762:
763: --fix for bug 5507953
764: l_return_status := QP_UTIL.Validate_Item(p_PRICING_ATTR_rec.product_attribute_context,
765: p_PRICING_ATTR_rec.product_attribute,
766: p_PRICING_ATTR_rec.product_attr_value);
767:
768: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL

Line 775: l_organization_id := QP_UTIL.Get_Item_Validation_Org;

771: IF p_PRICING_ATTR_rec.product_attribute_context = 'ITEM' -- Item Number
772: AND p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE1'
773: THEN
774: oe_debug_pub.add('IIIITTTTEEEEMMMM');
775: l_organization_id := QP_UTIL.Get_Item_Validation_Org;
776:
777: BEGIN
778:
779: select distinct uom_code

Line 1117: QP_UTIL.validate_context_code(p_flexfield_name => 'QP_ATTR_DEFNS_PRICING'

1113:
1114: IF p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL
1115: THEN
1116:
1117: QP_UTIL.validate_context_code(p_flexfield_name => 'QP_ATTR_DEFNS_PRICING'
1118: ,p_application_short_name => 'QP'
1119: ,p_context_name => p_PRICING_ATTR_rec.pricing_attribute_context
1120: ,p_error_code => l_error_code);
1121:

Line 1154: QP_UTIL.validate_attribute_name(p_application_short_name => 'QP'

1150: IF p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL
1151: AND p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL
1152: THEN
1153:
1154: QP_UTIL.validate_attribute_name(p_application_short_name => 'QP'
1155: ,p_flexfield_name => 'QP_ATTR_DEFNS_PRICING'
1156: ,p_context_name => p_PRICING_ATTR_rec.pricing_attribute_context
1157: ,p_attribute_name => p_PRICING_ATTR_rec.pricing_attribute
1158: ,p_error_code => l_error_code);

Line 1195: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'

1191: IF p_PRICING_ATTR_rec.pricing_attr_value_from IS NOT NULL
1192: AND p_PRICING_ATTR_rec.comparison_operator_code = '='
1193: THEN
1194:
1195: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'
1196: ,context =>p_PRICING_ATTR_rec.pricing_attribute_context
1197: ,attribute =>p_PRICING_ATTR_rec.pricing_attribute
1198: ,value =>p_PRICING_ATTR_rec.pricing_attr_value_from
1199: ,application_short_name => 'QP'

Line 1251: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,

1247:
1248: oe_debug_pub.add('pricing attr value to = '|| p_PRICING_ATTR_rec.pricing_attr_value_to);
1249: oe_debug_pub.add('pricing attr datatype = '|| p_PRICING_ATTR_rec.pricing_attribute_datatype);
1250:
1251: l_error_code := QP_UTIL.validate_num_date(p_PRICING_ATTR_rec.pricing_attribute_datatype,
1252: p_PRICING_ATTR_rec.pricing_attr_value_to);
1253:
1254: oe_debug_pub.add('to error = '||to_char(l_error_code));
1255: If (l_error_code = 9) -- invalid value

Line 1271: l_qp_status := QP_UTIL.GET_QP_STATUS;

1267: End If;
1268:
1269: END IF;
1270:
1271: l_qp_status := QP_UTIL.GET_QP_STATUS;
1272:
1273: -- For bug 2363065, raise the error in basic pricing if not called from FTE
1274: IF (p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL
1275: AND p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL

Line 1333: IF qp_util.attrmgr_installed = 'Y' THEN

1329: --or if its sourcing_status is not 'Y', i.e., the build sourcing conc.
1330: --program has to be run.
1331:
1332: oe_debug_pub.add('Here 0000');
1333: IF qp_util.attrmgr_installed = 'Y' THEN
1334: oe_debug_pub.add('Here 1111');
1335: IF p_Pricing_Attr_rec.product_attribute_context IS NOT NULL AND
1336: p_Pricing_Attr_rec.product_attribute IS NOT NULL
1337: THEN

Line 1339: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',

1335: IF p_Pricing_Attr_rec.product_attribute_context IS NOT NULL AND
1336: p_Pricing_Attr_rec.product_attribute IS NOT NULL
1337: THEN
1338: oe_debug_pub.add('Here 2222');
1339: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',
1340: p_Pricing_Attr_rec.product_attribute_context,
1341: l_context_type,
1342: l_error_code);
1343:

Line 1347: QP_UTIL.Get_Sourcing_Info(l_context_type,

1343:
1344: IF l_error_code = 0 THEN --successfully returned context_type
1345:
1346: oe_debug_pub.add('Here 3333');
1347: QP_UTIL.Get_Sourcing_Info(l_context_type,
1348: p_Pricing_Attr_rec.product_attribute_context,
1349: p_Pricing_Attr_rec.product_attribute,
1350: l_sourcing_enabled,
1351: l_sourcing_status,

Line 1390: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',

1386:
1387: IF p_Pricing_Attr_rec.pricing_attribute_context IS NOT NULL AND
1388: p_Pricing_Attr_rec.pricing_attribute IS NOT NULL
1389: THEN
1390: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',
1391: p_Pricing_Attr_rec.pricing_attribute_context,
1392: l_context_type,
1393: l_error_code);
1394:

Line 1397: QP_UTIL.Get_Sourcing_Info(l_context_type,

1393: l_error_code);
1394:
1395: IF l_error_code = 0 THEN --successfully returned context_type
1396:
1397: QP_UTIL.Get_Sourcing_Info(l_context_type,
1398: p_Pricing_Attr_rec.pricing_attribute_context,
1399: p_Pricing_Attr_rec.pricing_attribute,
1400: l_sourcing_enabled,
1401: l_sourcing_status,

Line 1434: END IF; --qp_util.attrmgr_installed = 'Y'

1430: END IF; --l_error_code = 0
1431:
1432: END IF;--If pricing_attribute_context and pricing_attribute are NOT NULL
1433:
1434: END IF; --qp_util.attrmgr_installed = 'Y'
1435:
1436: -- Done validating entity
1437:
1438: x_return_status := l_return_status;

Line 1924: QP_UTIL.Check_Source_System_Code

1920:
1921: NULL;
1922: -- Check whether Source System Code matches
1923: -- mkarya for bug 1728764, Prevent update of Trade Management Data in QP
1924: QP_UTIL.Check_Source_System_Code
1925: (p_list_header_id => p_PRICING_ATTR_rec.list_header_id,
1926: p_list_line_id => p_PRICING_ATTR_rec.list_line_id,
1927: x_return_status => l_return_status
1928: );