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_VALIDATE_QUALIFIERS dependencies on FND_API

Line 98: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

94: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
95: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
96: )
97: IS
98: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
99: l_qualifier_id NUMBER;
100: l_qualifier_rule_id NUMBER;
101: l_comparison_operator_code VARCHAR2(30);
102: l_error_code NUMBER;

Line 158: l_return_status := FND_API.G_RET_STS_ERROR;

154:
155: IF p_QUALIFIERS_rec.qualifier_id IS NULL
156: THEN
157:
158: l_return_status := FND_API.G_RET_STS_ERROR;
159:
160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
161: THEN
162:

Line 188: l_return_status := FND_API.G_RET_STS_ERROR;

184:
185: IF p_QUALIFIERS_rec.qualifier_grouping_no IS NULL
186: THEN
187:
188: l_return_status := FND_API.G_RET_STS_ERROR;
189:
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
191: THEN
192:

Line 220: l_return_status := FND_API.G_RET_STS_ERROR;

216: IF p_QUALIFIERS_rec.comparison_operator_code <> 'BETWEEN' AND
217: p_QUALIFIERS_rec.qualifier_attr_value IS NULL
218: THEN
219:
220: l_return_status := FND_API.G_RET_STS_ERROR;
221:
222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224:

Line 248: l_return_status := FND_API.G_RET_STS_ERROR;

244:
245: IF p_QUALIFIERS_rec.qualifier_attribute IS NULL
246: THEN
247:
248: l_return_status := FND_API.G_RET_STS_ERROR;
249:
250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252:

Line 275: l_return_status := FND_API.G_RET_STS_ERROR;

271:
272: IF p_QUALIFIERS_rec.qualifier_context IS NULL
273: THEN
274:
275: l_return_status := FND_API.G_RET_STS_ERROR;
276:
277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
278: THEN
279:

Line 300: l_return_status := FND_API.G_RET_STS_ERROR;

296: IF p_QUALIFIERS_rec.comparison_operator_code IS NULL
297:
298: THEN
299:
300: l_return_status := FND_API.G_RET_STS_ERROR;
301:
302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
303: THEN
304:

Line 326: l_return_status := FND_API.G_RET_STS_ERROR;

322: IF p_QUALIFIERS_rec.list_line_id IS NULL
323:
324: THEN
325:
326: l_return_status := FND_API.G_RET_STS_ERROR;
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
329: THEN
330:

Line 345: l_return_status := FND_API.G_RET_STS_ERROR;

341:
342: IF p_QUALIFIERS_rec.excluder_flag IS NULL
343: THEN
344:
345: l_return_status := FND_API.G_RET_STS_ERROR;
346:
347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
348: THEN
349:

Line 367: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

363: -- Return Error if a required attribute is missing.
364:
365:
366:
367: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
368:
369: RAISE FND_API.G_EXC_ERROR;
370:
371: END IF;

Line 369: RAISE FND_API.G_EXC_ERROR;

365:
366:
367: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
368:
369: RAISE FND_API.G_EXC_ERROR;
370:
371: END IF;
372:
373: --

Line 399: l_return_status := FND_API.G_RET_STS_ERROR;

395: p_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10' AND
396: l_list_type_code in ('PRL', 'AGR')
397: -- Qualifier Attr 'Order Amount' under the 'Volume' Qualfier context
398: THEN
399: l_return_status := FND_API.G_RET_STS_ERROR;
400:
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
402: THEN
403: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

405: OE_MSG_PUB.Add;
406: END IF;
407: END IF;
408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: -- Validate start_date active and end_date active

Line 410: RAISE FND_API.G_EXC_ERROR;

406: END IF;
407: END IF;
408:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: -- Validate start_date active and end_date active
414: --end date active must be greater than start date active

Line 429: l_return_status := FND_API.G_RET_STS_ERROR;

425: p_QUALIFIERS_rec.start_date_active ) <
426: nvl(p_QUALIFIERS_rec.start_date_active,
427: p_QUALIFIERS_rec.end_date_active)
428: THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;
430:
431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433:

Line 458: l_return_status := FND_API.G_RET_STS_ERROR;

454: IF UPPER(p_QUALIFIERS_rec.comparison_operator_code) = 'BETWEEN' AND
455: (p_QUALIFIERS_rec.qualifier_attr_value_to IS NULL OR
456: p_QUALIFIERS_rec.qualifier_attr_value IS NULL)
457: THEN
458: l_return_status := FND_API.G_RET_STS_ERROR;
459:
460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
461: THEN
462:

Line 479: l_return_status := FND_API.G_RET_STS_ERROR;

475: l_error_code:=QP_UTIL.validate_num_date(p_QUALIFIERS_rec.qualifier_datatype,
476: p_QUALIFIERS_rec.qualifier_attr_value_to);
477: IF l_error_code <> 0 THEN
478:
479: l_return_status := FND_API.G_RET_STS_ERROR;
480:
481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482: THEN
483: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 508: l_return_status := FND_API.G_RET_STS_ERROR;

504: If Check_Duplicate_start_date(p_QUALIFIERS_rec.qualifier_grouping_no,
505: p_QUALIFIERS_rec.start_date_active,
506: p_QUALIFIERS_rec.qualifier_rule_id,
507: p_QUALIFIERS_rec.qualifier_id) THEN
508: l_return_status := FND_API.G_RET_STS_ERROR;
509:
510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
511: Then
512: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');

Line 523: l_return_status := FND_API.G_RET_STS_ERROR;

519: If Check_Duplicate_end_date(p_QUALIFIERS_rec.qualifier_grouping_no,
520: p_QUALIFIERS_rec.end_date_active,
521: p_QUALIFIERS_rec.qualifier_rule_id,
522: p_QUALIFIERS_rec.qualifier_id) THEN
523: l_return_status := FND_API.G_RET_STS_ERROR;
524:
525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
526: Then
527: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');

Line 565: l_return_status := FND_API.G_RET_STS_ERROR;

561: If SQL%NOTFOUND
562: Then
563: null;
564: Else
565: l_return_status := FND_API.G_RET_STS_ERROR;
566: --dbms_output.put_line('entity validation for duplicaet id '||l_return_status);
567:
568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
569: THEN

Line 600: l_return_status := FND_API.G_RET_STS_ERROR;

596:
597: If SQL%NOTFOUND
598: Then
599:
600: l_return_status := FND_API.G_RET_STS_ERROR;
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
603: THEN
604:

Line 631: l_return_status := FND_API.G_RET_STS_ERROR;

627: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
628: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
629: THEN
630:
631: l_return_status := FND_API.G_RET_STS_ERROR;
632:
633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
634: THEN
635: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');

Line 659: l_return_status := FND_API.G_RET_STS_ERROR;

655: );
656:
657: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
658: Then
659: l_return_status := FND_API.G_RET_STS_ERROR;
660:
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663:

Line 681: l_return_status := FND_API.G_RET_STS_ERROR;

677:
678:
679: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
680: Then
681: l_return_status := FND_API.G_RET_STS_ERROR;
682:
683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
684: THEN
685:

Line 705: l_return_status := FND_API.G_RET_STS_ERROR;

701: IF p_QUALIFIERS_rec.comparison_operator_code = '=' Then
702:
703: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
704: Then
705: l_return_status := FND_API.G_RET_STS_ERROR;
706:
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
708: THEN
709:

Line 747: l_return_status := FND_API.G_RET_STS_ERROR;

743: IF SQL%NOTFOUND
744: THEN
745:
746: oe_debug_pub.add('customer GSA not found');
747: l_return_status := FND_API.G_RET_STS_ERROR;
748:
749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
750: THEN
751:

Line 761: l_return_status := FND_API.G_RET_STS_ERROR;

757: ELSIF nvl(l_customer_gsa_indicator,'N') <> 'Y'
758: THEN
759:
760: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
761: l_return_status := FND_API.G_RET_STS_ERROR;
762:
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765:

Line 794: l_return_status := FND_API.G_RET_STS_ERROR;

790: oe_debug_pub.add('n precede '||l_precedence);
791:
792: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
793: Then
794: l_return_status := FND_API.G_RET_STS_ERROR;
795:
796: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
797: THEN
798:

Line 816: l_return_status := FND_API.G_RET_STS_ERROR;

812:
813:
814: If p_QUALIFIERS_rec.qualifier_datatype <> l_datatype --- invalid qualifier datatype
815: Then
816: l_return_status := FND_API.G_RET_STS_ERROR;
817:
818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 841: l_return_status := FND_API.G_RET_STS_ERROR;

837: l_error_code:=QP_UTIL.validate_num_date(p_QUALIFIERS_rec.qualifier_datatype,
838: p_QUALIFIERS_rec.qualifier_attr_value);
839: IF l_error_code <> 0 THEN
840:
841: l_return_status := FND_API.G_RET_STS_ERROR;
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
844: THEN
845: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 869: l_return_status := FND_API.G_RET_STS_ERROR;

865: WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id;
866:
867: If SQL%NOTFOUND
868: Then
869: l_return_status := FND_API.G_RET_STS_ERROR;
870:
871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 895: l_return_status := FND_API.G_RET_STS_ERROR;

891: WHERE qualifier_rule_id = p_QUALIFIERS_rec.created_from_rule_id;
892:
893: If SQL%NOTFOUND
894: Then
895: l_return_status := FND_API.G_RET_STS_ERROR;
896:
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
898: THEN
899: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 920: l_return_status := FND_API.G_RET_STS_ERROR;

916: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id;
917:
918: If SQL%NOTFOUND
919: Then
920: l_return_status := FND_API.G_RET_STS_ERROR;
921:
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 945: l_return_status := FND_API.G_RET_STS_ERROR;

941: WHERE list_line_id = p_QUALIFIERS_rec.list_line_id;
942:
943: If SQL%NOTFOUND
944: Then
945: l_return_status := FND_API.G_RET_STS_ERROR;
946:
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
948: THEN
949: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 958: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

954: End If;
955: END IF; */
956:
957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
959:
960: RAISE FND_API.G_EXC_ERROR;
961:
962: END IF;

Line 960: RAISE FND_API.G_EXC_ERROR;

956:
957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
959:
960: RAISE FND_API.G_EXC_ERROR;
961:
962: END IF;
963:
964: --- start bug2091362

Line 987: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

983: , p_request_Type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
984: , x_return_status => l_return_status
985: );
986:
987: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
988:
989: oe_debug_pub.add('failed in logging a delayed request ');
990:
991: RAISE FND_API.G_EXC_ERROR;

Line 991: RAISE FND_API.G_EXC_ERROR;

987: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
988:
989: oe_debug_pub.add('failed in logging a delayed request ');
990:
991: RAISE FND_API.G_EXC_ERROR;
992:
993: END IF;
994:
995: /* After deleting request if any log a new request to check duplicate modifier list lines with product attribute */

Line 1020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1016: , p_param6 => NULL
1017: , x_return_status => l_return_status
1018: );
1019:
1020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1021:
1022: oe_debug_pub.add('failed in logging a delayed request ');
1023:
1024: RAISE FND_API.G_EXC_ERROR;

Line 1024: RAISE FND_API.G_EXC_ERROR;

1020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1021:
1022: oe_debug_pub.add('failed in logging a delayed request ');
1023:
1024: RAISE FND_API.G_EXC_ERROR;
1025:
1026: END IF;
1027:
1028: ELSE

Line 1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1047: , p_param6 => p_product_attr_value
1048: , x_return_status => l_return_status
1049: );
1050:
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052:
1053: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1054:
1055: RAISE FND_API.G_EXC_ERROR;

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052:
1053: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1054:
1055: RAISE FND_API.G_EXC_ERROR;
1056:
1057: END IF;
1058: END IF;
1059: oe_debug_pub.add('after logging delayed request from qualfiers ');

Line 1136: l_return_status := FND_API.G_RET_STS_ERROR;

1132: ,p_Qualifiers_rec.qualifier_context
1133: ,p_Qualifiers_rec.qualifier_attribute
1134: );
1135: IF l_segment_level = 'ORDER' THEN
1136: l_return_status := FND_API.G_RET_STS_ERROR;
1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1138: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1139: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1140: p_attribute => p_Qualifiers_rec.qualifier_attribute,

Line 1177: l_return_status := FND_API.G_RET_STS_ERROR;

1173: if ((l_modifier_level_code in ('LINE', 'LINEGROUP') and l_segment_level = 'ORDER')
1174: OR
1175: (l_modifier_level_code = 'ORDER' and l_segment_level = 'LINE')) then
1176:
1177: l_return_status := FND_API.G_RET_STS_ERROR;
1178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1179: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1180: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1181: p_attribute => p_Qualifiers_rec.qualifier_attribute,

Line 1206: WHEN FND_API.G_EXC_ERROR THEN

1202: x_return_status := l_return_status;
1203:
1204: EXCEPTION
1205:
1206: WHEN FND_API.G_EXC_ERROR THEN
1207:
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1208: x_return_status := FND_API.G_RET_STS_ERROR;

1204: EXCEPTION
1205:
1206: WHEN FND_API.G_EXC_ERROR THEN
1207:
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211:
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1206: WHEN FND_API.G_EXC_ERROR THEN
1207:
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211:
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213:
1214: WHEN OTHERS THEN

Line 1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211:
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213:
1214: WHEN OTHERS THEN
1215:
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1213:
1214: WHEN OTHERS THEN
1215:
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: OE_MSG_PUB.Add_Exc_Msg

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

1235: )
1236: IS
1237: BEGIN
1238:
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: -- Validate QUALIFIERS attributes
1242:
1243:

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: THEN
1253:
1254: --dbms_output.put_line(' inside if not null comparison operator');
1255: IF NOT QP_Validate.Comparison_Operator(p_QUALIFIERS_rec.comparison_operator_code) THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258: END IF;
1259:
1260:

Line 1272: x_return_status := FND_API.G_RET_STS_ERROR;

1268: p_old_QUALIFIERS_rec.created_by OR
1269: p_old_QUALIFIERS_rec.created_by IS NULL )
1270: THEN
1271: IF NOT QP_Validate.Created_By(p_QUALIFIERS_rec.created_by) THEN
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: END IF;
1274: END IF;
1275: --dbms_output.put_line('status is '||x_return_status);
1276:

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

1283: p_old_QUALIFIERS_rec.created_from_rule_id OR
1284: p_old_QUALIFIERS_rec.created_from_rule_id IS NULL )
1285: THEN
1286: IF NOT QP_Validate.Created_From_Rule(p_QUALIFIERS_rec.created_from_rule_id) THEN
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: END IF;
1289: END IF;
1290:
1291: --dbms_output.put_line(' created from status is '||x_return_status);

Line 1303: x_return_status := FND_API.G_RET_STS_ERROR;

1299: p_old_QUALIFIERS_rec.creation_date OR
1300: p_old_QUALIFIERS_rec.creation_date IS NULL )
1301: THEN
1302: IF NOT QP_Validate.Creation_Date(p_QUALIFIERS_rec.creation_date) THEN
1303: x_return_status := FND_API.G_RET_STS_ERROR;
1304: END IF;
1305: END IF;
1306: --dbms_output.put_line('status is '||x_return_status);
1307:

Line 1318: x_return_status := FND_API.G_RET_STS_ERROR;

1314: p_old_QUALIFIERS_rec.end_date_active OR
1315: p_old_QUALIFIERS_rec.end_date_active IS NULL )
1316: THEN
1317: IF NOT QP_Validate.End_Date_Active(p_QUALIFIERS_rec.end_date_active) THEN
1318: x_return_status := FND_API.G_RET_STS_ERROR;
1319: END IF;
1320: END IF;
1321: --dbms_output.put_line('end adate status is '||x_return_status);
1322:

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: p_old_QUALIFIERS_rec.excluder_flag OR
1330: p_old_QUALIFIERS_rec.excluder_flag IS NULL )
1331: THEN
1332: IF NOT QP_Validate.Excluder(p_QUALIFIERS_rec.excluder_flag) THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: END IF;
1335: END IF;
1336: --dbms_output.put_line(' excluder flag status is '||x_return_status);
1337:

Line 1348: x_return_status := FND_API.G_RET_STS_ERROR;

1344: p_old_QUALIFIERS_rec.last_updated_by OR
1345: p_old_QUALIFIERS_rec.last_updated_by IS NULL )
1346: THEN
1347: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: END IF;
1350: END IF;
1351: --dbms_output.put_line('status is '||x_return_status);
1352:

Line 1363: x_return_status := FND_API.G_RET_STS_ERROR;

1359: p_old_QUALIFIERS_rec.last_update_date OR
1360: p_old_QUALIFIERS_rec.last_update_date IS NULL )
1361: THEN
1362: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: END IF;
1365: END IF;
1366: --dbms_output.put_line('status is '||x_return_status);
1367:

Line 1378: x_return_status := FND_API.G_RET_STS_ERROR;

1374: p_old_QUALIFIERS_rec.last_update_login OR
1375: p_old_QUALIFIERS_rec.last_update_login IS NULL )
1376: THEN
1377: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: END IF;
1380: END IF;
1381: --dbms_output.put_line('status is '||x_return_status);
1382:

Line 1393: x_return_status := FND_API.G_RET_STS_ERROR;

1389: p_old_QUALIFIERS_rec.list_header_id OR
1390: p_old_QUALIFIERS_rec.list_header_id IS NULL )
1391: THEN
1392: IF NOT QP_Validate.List_Header(p_QUALIFIERS_rec.list_header_id) THEN
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: END IF;
1395: END IF;
1396: --dbms_output.put_line('status is '||x_return_status);
1397:

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404: p_old_QUALIFIERS_rec.list_line_id OR
1405: p_old_QUALIFIERS_rec.list_line_id IS NULL )
1406: THEN
1407: IF NOT QP_Validate.List_Line(p_QUALIFIERS_rec.list_line_id) THEN
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END IF;
1410: END IF;
1411: --dbms_output.put_line('status is '||x_return_status);
1412:

Line 1424: x_return_status := FND_API.G_RET_STS_ERROR;

1420: p_old_QUALIFIERS_rec.program_application_id OR
1421: p_old_QUALIFIERS_rec.program_application_id IS NULL )
1422: THEN
1423: IF NOT QP_Validate.Program_Application(p_QUALIFIERS_rec.program_application_id) THEN
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426: END IF;
1427: --dbms_output.put_line('status is '||x_return_status);
1428:

Line 1440: x_return_status := FND_API.G_RET_STS_ERROR;

1436: p_old_QUALIFIERS_rec.program_id OR
1437: p_old_QUALIFIERS_rec.program_id IS NULL )
1438: THEN
1439: IF NOT QP_Validate.Program(p_QUALIFIERS_rec.program_id) THEN
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: END IF;
1442: END IF;
1443: --dbms_output.put_line('status is '||x_return_status);
1444:

Line 1455: x_return_status := FND_API.G_RET_STS_ERROR;

1451: p_old_QUALIFIERS_rec.program_update_date OR
1452: p_old_QUALIFIERS_rec.program_update_date IS NULL )
1453: THEN
1454: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: END IF;
1457: END IF;
1458: --dbms_output.put_line('status is '||x_return_status);
1459:

Line 1470: x_return_status := FND_API.G_RET_STS_ERROR;

1466: p_old_QUALIFIERS_rec.qualifier_attribute OR
1467: p_old_QUALIFIERS_rec.qualifier_attribute IS NULL )
1468: THEN
1469: IF NOT QP_Validate.Qualifier_Attribute(p_QUALIFIERS_rec.qualifier_attribute) THEN
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: END IF;
1472: END IF;
1473: --dbms_output.put_line(' attribute status is '||x_return_status);
1474:

Line 1485: x_return_status := FND_API.G_RET_STS_ERROR;

1481: p_old_QUALIFIERS_rec.qualifier_attr_value OR
1482: p_old_QUALIFIERS_rec.qualifier_attr_value IS NULL )
1483: THEN
1484: IF NOT QP_Validate.Qualifier_Attr_Value(p_QUALIFIERS_rec.qualifier_attr_value) THEN
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487: END IF;
1488: --dbms_output.put_line(' attr value status is '||x_return_status);
1489:

Line 1500: x_return_status := FND_API.G_RET_STS_ERROR;

1496: p_old_QUALIFIERS_rec.qualifier_attr_value_to OR
1497: p_old_QUALIFIERS_rec.qualifier_attr_value_to IS NULL )
1498: THEN
1499: IF NOT QP_Validate.Qualifier_Attr_Value_to(p_QUALIFIERS_rec.qualifier_attr_value_to) THEN
1500: x_return_status := FND_API.G_RET_STS_ERROR;
1501: END IF;
1502: END IF;
1503: --dbms_output.put_line(' attr_value to status is '||x_return_status);
1504:

Line 1516: x_return_status := FND_API.G_RET_STS_ERROR;

1512: p_old_QUALIFIERS_rec.qualifier_context OR
1513: p_old_QUALIFIERS_rec.qualifier_context IS NULL )
1514: THEN
1515: IF NOT QP_Validate.Qualifier_Context(p_QUALIFIERS_rec.qualifier_context) THEN
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: END IF;
1518: END IF;
1519: --dbms_output.put_line(' context status is '||x_return_status);
1520:

Line 1531: x_return_status := FND_API.G_RET_STS_ERROR;

1527: p_old_QUALIFIERS_rec.qualifier_datatype OR
1528: p_old_QUALIFIERS_rec.qualifier_datatype IS NULL )
1529: THEN
1530: IF NOT QP_Validate.Qualifier_Datatype(p_QUALIFIERS_rec.qualifier_datatype) THEN
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: END IF;
1533: END IF;
1534: --dbms_output.put_line(' data type status is '||x_return_status);
1535:

Line 1542: x_return_status := FND_API.G_RET_STS_ERROR;

1538: p_old_QUALIFIERS_rec.qualifier_date_format OR
1539: p_old_QUALIFIERS_rec.qualifier_date_format IS NULL )
1540: THEN
1541: IF NOT QP_Validate.Qualifier_Date_Format(p_QUALIFIERS_rec.qualifier_date_format) THEN
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: END IF;
1544: END IF;*/
1545:
1546:

Line 1559: x_return_status := FND_API.G_RET_STS_ERROR;

1555: p_old_QUALIFIERS_rec.qualifier_grouping_no OR
1556: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1 )
1557: THEN
1558: IF NOT QP_Validate.Qualifier_Grouping_No(p_QUALIFIERS_rec.qualifier_grouping_no) THEN
1559: x_return_status := FND_API.G_RET_STS_ERROR;
1560: END IF;
1561: END IF;
1562: --dbms_output.put_line(' gropuing status is '||x_return_status);
1563:

Line 1574: x_return_status := FND_API.G_RET_STS_ERROR;

1570: p_old_QUALIFIERS_rec.qualifier_id OR
1571: p_old_QUALIFIERS_rec.qualifier_id IS NULL )
1572: THEN
1573: IF NOT QP_Validate.Qualifier(p_QUALIFIERS_rec.qualifier_id) THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: END IF;
1576: END IF;
1577: --dbms_output.put_line(' qualiifer id status is '||x_return_status);
1578:

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR;

1584: p_old_QUALIFIERS_rec.qualifier_number_format OR
1585: p_old_QUALIFIERS_rec.qualifier_number_format IS NULL )
1586: THEN
1587: IF NOT QP_Validate.Qualifier_Number_Format(p_QUALIFIERS_rec.qualifier_number_format) THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590: END IF;*/
1591:
1592:

Line 1602: x_return_status := FND_API.G_RET_STS_ERROR;

1598: p_old_QUALIFIERS_rec.qualifier_precedence OR
1599: p_old_QUALIFIERS_rec.qualifier_precedence IS NULL )
1600: THEN
1601: IF NOT QP_Validate.Qualifier_Precedence(p_QUALIFIERS_rec.qualifier_precedence) THEN
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: END IF;
1605: --dbms_output.put_line(' precedence status is '||x_return_status);
1606:

Line 1620: x_return_status := FND_API.G_RET_STS_ERROR;

1616: p_old_QUALIFIERS_rec.qualifier_rule_id OR
1617: p_old_QUALIFIERS_rec.qualifier_rule_id IS NULL )
1618: THEN
1619: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIERS_rec.qualifier_rule_id) THEN
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: END IF;
1622: END IF;
1623: --dbms_output.put_line(' qualifier rule id status is '||x_return_status);
1624:

Line 1634: x_return_status := FND_API.G_RET_STS_ERROR;

1630: p_old_QUALIFIERS_rec.request_id OR
1631: p_old_QUALIFIERS_rec.request_id IS NULL )
1632: THEN
1633: IF NOT QP_Validate.Request(p_QUALIFIERS_rec.request_id) THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: END IF;
1636: END IF;
1637: --dbms_output.put_line('status is '||x_return_status);
1638:

Line 1648: x_return_status := FND_API.G_RET_STS_ERROR;

1644: p_old_QUALIFIERS_rec.start_date_active OR
1645: p_old_QUALIFIERS_rec.start_date_active IS NULL )
1646: THEN
1647: IF NOT QP_Validate.Start_Date_Active(p_QUALIFIERS_rec.start_date_active) THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: END IF;
1650: END IF;
1651: --dbms_output.put_line('status is '||x_return_status);
1652: -- Added for TCA

Line 1659: x_return_status := FND_API.G_RET_STS_ERROR;

1655: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag OR
1656: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag IS NULL )
1657: THEN
1658: IF NOT QP_Validate.Qualify_Hier_Descendent_Flag(p_QUALIFIERS_rec.qualify_hier_descendent_flag) THEN
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: END IF;
1661: END IF;
1662:
1663:

Line 1803: x_return_status := FND_API.G_RET_STS_ERROR;

1799: -- Validate descriptive flexfield.
1800:
1801: --dbms_output.put_line('validating flex ');
1802: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1803: x_return_status := FND_API.G_RET_STS_ERROR;
1804: END IF;
1805: --dbms_output.put_line('status is '||x_return_status);
1806:
1807: END IF;

Line 1813: WHEN FND_API.G_EXC_ERROR THEN

1809: -- Done validating attributes
1810:
1811: EXCEPTION
1812:
1813: WHEN FND_API.G_EXC_ERROR THEN
1814:
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816:
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1815: x_return_status := FND_API.G_RET_STS_ERROR;

1811: EXCEPTION
1812:
1813: WHEN FND_API.G_EXC_ERROR THEN
1814:
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816:
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1813: WHEN FND_API.G_EXC_ERROR THEN
1814:
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816:
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820:
1821: WHEN OTHERS THEN

Line 1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816:
1817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820:
1821: WHEN OTHERS THEN
1822:
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820:
1821: WHEN OTHERS THEN
1822:
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1826: THEN
1827: OE_MSG_PUB.Add_Exc_Msg

Line 1842: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1838: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1839: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1840: )
1841: IS
1842: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1843: BEGIN
1844:
1845: -- Validate entity delete.
1846:

Line 1862: WHEN FND_API.G_EXC_ERROR THEN

1858: x_return_status := l_return_status;
1859:
1860: EXCEPTION
1861:
1862: WHEN FND_API.G_EXC_ERROR THEN
1863:
1864: x_return_status := FND_API.G_RET_STS_ERROR;
1865:
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1864: x_return_status := FND_API.G_RET_STS_ERROR;

1860: EXCEPTION
1861:
1862: WHEN FND_API.G_EXC_ERROR THEN
1863:
1864: x_return_status := FND_API.G_RET_STS_ERROR;
1865:
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1867:
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1862: WHEN FND_API.G_EXC_ERROR THEN
1863:
1864: x_return_status := FND_API.G_RET_STS_ERROR;
1865:
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1867:
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1869:
1870: WHEN OTHERS THEN

Line 1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1864: x_return_status := FND_API.G_RET_STS_ERROR;
1865:
1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1867:
1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1869:
1870: WHEN OTHERS THEN
1871:
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1869:
1870: WHEN OTHERS THEN
1871:
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: OE_MSG_PUB.Add_Exc_Msg