DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on QP_UTIL

Line 1334: and QP_UTIL.validate_org_id(p_header_rec.orig_org_id(I)) = 'N') THEN

1330:
1331: /* for bug 4731613 moved this validation to attribute_header procedure
1332: --if orig_org_id is not null and it is not a valid org
1333: IF (p_header_rec.orig_org_id(I) is not null
1334: and QP_UTIL.validate_org_id(p_header_rec.orig_org_id(I)) = 'N') THEN
1335: p_header_rec.process_status_flag(I):=NULL;
1336: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
1337: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','orig_org_id');
1338: qp_bulk_msg.add(l_msg_rec);

Line 2704: p_qualifier_rec.qualifier_attribute(I):= QP_UTIL.Get_Attribute_Name(

2700: QP_BULK_MSG.ADD(l_msg_rec);
2701: /* ELSE
2702:
2703: BEGIN
2704: p_qualifier_rec.qualifier_attribute(I):= QP_UTIL.Get_Attribute_Name(
2705: p_application_short_name => 'QP',
2706: p_flexfield_name=> 'QP_ATTR_DEFNS_QUALIFIER',
2707: p_context_name =>p_qualifier_rec.qualifier_context(I),
2708: p_attribute_name=>p_qualifier_rec.qualifier_attribute_code(I));

Line 2810: QP_UTIL.validate_qp_flexfield(

2806: p_QUALIFIER_rec.qualifier_attribute(I)
2807: );
2808: END IF;
2809:
2810: QP_UTIL.validate_qp_flexfield(
2811: flexfield_name =>'QP_ATTR_DEFNS_QUALIFIER'
2812: ,context =>p_QUALIFIER_rec.qualifier_context(I)
2813: ,attribute =>p_QUALIFIER_rec.qualifier_attribute(I)
2814: -- Bug 5152088 Checking if Qualifier Attribute Value Code is valid

Line 3172: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_QUALIFIER'

3168: END IF;
3169:
3170: IF p_qualifier_rec.qualifier_precedence(I) IS NULL or
3171: p_qualifier_rec.qualifier_precedence(I) = 0 THEN
3172: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_QUALIFIER'
3173: ,context =>p_qualifier_rec.qualifier_context(I)
3174: ,attribute =>p_qualifier_rec.qualifier_attribute(I)
3175: ,value =>p_qualifier_rec.qualifier_attr_value(I)
3176: ,application_short_name => 'QP'

Line 3198: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_QUALIFIER',

3194: IF p_Qualifier_rec.qualifier_context(I) IS NOT NULL AND
3195: p_Qualifier_rec.qualifier_attribute(I) IS NOT NULL
3196: THEN
3197: qp_bulk_loader_pub.write_log('Context and Attribute OK ');
3198: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_QUALIFIER',
3199: p_Qualifier_rec.qualifier_context(I),
3200: l_context_type,
3201: l_error_code);
3202:

Line 3205: QP_UTIL.Get_Sourcing_Info(l_context_type,

3201: l_error_code);
3202:
3203: IF l_error_code = 0 THEN --successfully returned context_type
3204:
3205: QP_UTIL.Get_Sourcing_Info(l_context_type,
3206: p_Qualifier_rec.qualifier_context(I),
3207: p_Qualifier_rec.qualifier_attribute(I),
3208: l_sourcing_enabled,
3209: l_sourcing_status,

Line 3783: QP_UTIL.Get_Item_Cat_Info(

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:
3783: QP_UTIL.Get_Item_Cat_Info(
3784: p_PRICING_ATTR_rec.product_attr_value(I),
3785: l_pte_code,
3786: l_ss_code,
3787: l_fna_name,

Line 3807: QP_UTIL.GET_PROD_FLEX_PROPERTIES(p_pricing_attr_rec.product_attribute_context(I),

3803: END;
3804: END IF;
3805:
3806: ----- Getting product_attribute_datatype -----
3807: QP_UTIL.GET_PROD_FLEX_PROPERTIES(p_pricing_attr_rec.product_attribute_context(I),
3808: p_pricing_attr_rec.product_attribute(I),
3809: p_pricing_attr_rec.product_attr_value(I),
3810: l_datatype,
3811: l_precedence,

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

4033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'COMPARISON_OPERATOR_CODE');
4034: QP_BULK_MSG.ADD(l_msg_rec);
4035: END IF;
4036: ELSE
4037: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'
4038: ,context =>p_Pricing_Attr_rec.pricing_attribute_context(I)
4039: ,attribute =>p_Pricing_Attr_rec.pricing_attribute(I)
4040: ,value =>p_Pricing_Attr_rec.pricing_attr_value_from(I)
4041: ,application_short_name => 'QP'

Line 4092: l_error_code:=QP_UTIL.validate_num_date(p_Pricing_Attr_rec.pricing_attribute_datatype(I),

4088: QP_BULK_MSG.Add(l_msg_rec);
4089: END IF;
4090:
4091: --validation for canonical form
4092: l_error_code:=QP_UTIL.validate_num_date(p_Pricing_Attr_rec.pricing_attribute_datatype(I),
4093: p_Pricing_Attr_rec.pricing_attr_value_from(I));
4094: IF l_error_code <> 0 THEN
4095: p_pricing_attr_rec.process_status_flag(I):=NULL;
4096: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 4131: l_error_code:=QP_UTIL.validate_num_date(p_Pricing_Attr_rec.pricing_attribute_datatype(I),

4127: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM'));
4128: QP_BULK_MSG.Add(l_msg_rec);
4129: END IF;
4130:
4131: l_error_code:=QP_UTIL.validate_num_date(p_Pricing_Attr_rec.pricing_attribute_datatype(I),
4132: p_Pricing_Attr_rec.pricing_attr_value_to(I));
4133:
4134: IF l_error_code <> 0 THEN
4135: p_pricing_attr_rec.process_status_flag(I):=NULL;

Line 4974: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',

4970: IF p_pricing_attr_rec.process_status_flag(I)='P' --,'*') <> 'E'
4971: and p_pricing_attr_rec.pricing_attribute_context(I) IS NULL
4972: and p_pricing_attr_rec.pricing_attribute(I) IS NULL THEN
4973:
4974: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',
4975: p_Pricing_Attr_rec.product_attribute_context(I),
4976: l_context_type,
4977: l_error_code);
4978:

Line 4979: QP_UTIL.Get_Sourcing_Info(l_context_type,

4975: p_Pricing_Attr_rec.product_attribute_context(I),
4976: l_context_type,
4977: l_error_code);
4978:
4979: QP_UTIL.Get_Sourcing_Info(l_context_type,
4980: p_Pricing_Attr_rec.product_attribute_context(I),
4981: p_Pricing_Attr_rec.product_attribute(I),
4982: l_sourcing_enabled,
4983: l_sourcing_status,

Line 5018: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',

5014: IF p_pricing_attr_rec.process_status_flag(I)='P' --,'*') <> 'E'
5015: and p_pricing_attr_rec.pricing_attribute_context(I) IS NOT NULL
5016: and p_pricing_attr_rec.pricing_attribute(I) IS NOT NULL THEN
5017:
5018: QP_UTIL.Get_Context_Type('QP_ATTR_DEFNS_PRICING',
5019: p_Pricing_Attr_rec.pricing_attribute_context(I),
5020: l_context_type,
5021: l_error_code);
5022:

Line 5023: QP_UTIL.Get_Sourcing_Info(l_context_type,

5019: p_Pricing_Attr_rec.pricing_attribute_context(I),
5020: l_context_type,
5021: l_error_code);
5022:
5023: QP_UTIL.Get_Sourcing_Info(l_context_type,
5024: p_Pricing_Attr_rec.pricing_attribute_context(I),
5025: p_Pricing_Attr_rec.pricing_attribute(I),
5026: l_sourcing_enabled,
5027: l_sourcing_status,

Line 5663: AND QP_UTIL.validate_org_id(qpih.orig_org_id) = 'N';

5659: WHERE qpih.request_id = p_request_id
5660: AND qpih.process_status_flag ='P' --is null
5661: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5662: AND qpih.global_flag = 'N' and qpih.orig_org_id IS NOT NULL
5663: AND QP_UTIL.validate_org_id(qpih.orig_org_id) = 'N';
5664:
5665: --Bug#5208112 RAVI START
5666: -- 13. Validate Rounding Factor
5667: