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 22: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM

18: IS
19: l_count NUMBER := 0;
20: BEGIN
21:
22: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM
23: OR p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL
24: THEN
25: SELECT 1 INTO l_count
26: FROM DUAL

Line 35: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =

31: AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
32: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute
33: AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
34: AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
35: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
36: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
37: AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );
38: ELSE
39: SELECT 1 INTO l_count

Line 36: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)

32: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute
33: AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
34: AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
35: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
36: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
37: AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );
38: ELSE
39: SELECT 1 INTO l_count
40: FROM DUAL

Line 49: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =

45: AND qualifier_context = p_QUALIFIERS_rec.qualifier_context
46: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute
47: AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
48: AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
49: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
50: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
51: AND qualifier_rule_id is null
52: AND list_line_id = p_QUALIFIERS_rec.list_line_id
53: AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );

Line 50: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)

46: AND qualifier_attribute = p_QUALIFIERS_rec.qualifier_attribute
47: AND qualifier_attr_value = p_QUALIFIERS_rec.qualifier_attr_value
48: AND COMPARISON_OPERATOR_CODE = p_QUALIFIERS_rec.comparison_operator_code
49: AND nvl(QUALIFIER_ATTR_VALUE_TO,FND_API.G_MISS_NUM) =
50: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
51: AND qualifier_rule_id is null
52: AND list_line_id = p_QUALIFIERS_rec.list_line_id
53: AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );
54: END IF;

Line 73: RAISE FND_API.G_EXC_ERROR;

69: , 'Check_Duplicate_Qualifier'
70: );
71: END IF;
72:
73: RAISE FND_API.G_EXC_ERROR;
74:
75: END Check_Duplicate_Qualifier;
76:
77:

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

163: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
164: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
165: )
166: IS
167: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
168: l_qualifier_id NUMBER;
169: l_qualifier_rule_id NUMBER;
170: l_comparison_operator_code VARCHAR2(30);
171: l_error_code NUMBER;

Line 227: l_return_status := FND_API.G_RET_STS_ERROR;

223:
224: IF p_QUALIFIERS_rec.qualifier_id IS NULL
225: THEN
226:
227: l_return_status := FND_API.G_RET_STS_ERROR;
228:
229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
230: THEN
231:

Line 257: l_return_status := FND_API.G_RET_STS_ERROR;

253:
254: IF p_QUALIFIERS_rec.qualifier_grouping_no IS NULL
255: THEN
256:
257: l_return_status := FND_API.G_RET_STS_ERROR;
258:
259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
260: THEN
261:

Line 289: l_return_status := FND_API.G_RET_STS_ERROR;

285: IF p_QUALIFIERS_rec.comparison_operator_code <> 'BETWEEN' AND
286: p_QUALIFIERS_rec.qualifier_attr_value IS NULL
287: THEN
288:
289: l_return_status := FND_API.G_RET_STS_ERROR;
290:
291: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
292: THEN
293:

Line 317: l_return_status := FND_API.G_RET_STS_ERROR;

313:
314: IF p_QUALIFIERS_rec.qualifier_attribute IS NULL
315: THEN
316:
317: l_return_status := FND_API.G_RET_STS_ERROR;
318:
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
320: THEN
321:

Line 344: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 369: l_return_status := FND_API.G_RET_STS_ERROR;

365: IF p_QUALIFIERS_rec.comparison_operator_code IS NULL
366:
367: THEN
368:
369: l_return_status := FND_API.G_RET_STS_ERROR;
370:
371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373:

Line 395: l_return_status := FND_API.G_RET_STS_ERROR;

391: IF p_QUALIFIERS_rec.list_line_id IS NULL
392:
393: THEN
394:
395: l_return_status := FND_API.G_RET_STS_ERROR;
396:
397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
398: THEN
399:

Line 414: l_return_status := FND_API.G_RET_STS_ERROR;

410:
411: IF p_QUALIFIERS_rec.excluder_flag IS NULL
412: THEN
413:
414: l_return_status := FND_API.G_RET_STS_ERROR;
415:
416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
417: THEN
418:

Line 436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

432: -- Return Error if a required attribute is missing.
433:
434:
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437:
438: RAISE FND_API.G_EXC_ERROR;
439:
440: END IF;

Line 438: RAISE FND_API.G_EXC_ERROR;

434:
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437:
438: RAISE FND_API.G_EXC_ERROR;
439:
440: END IF;
441:
442:

Line 448: l_return_status := FND_API.G_RET_STS_ERROR;

444:
445: IF Check_Duplicate_Qualifier(p_QUALIFIERS_rec)
446: THEN
447:
448: l_return_status := FND_API.G_RET_STS_ERROR;
449:
450: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
451: THEN
452:

Line 499: l_return_status := FND_API.G_RET_STS_ERROR;

495: p_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10' AND
496: l_list_type_code in ('PRL', 'AGR')
497: -- Qualifier Attr 'Order Amount' under the 'Volume' Qualfier context
498: THEN
499: l_return_status := FND_API.G_RET_STS_ERROR;
500:
501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

505: OE_MSG_PUB.Add;
506: END IF;
507: END IF;
508:
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: -- Validate start_date active and end_date active

Line 510: RAISE FND_API.G_EXC_ERROR;

506: END IF;
507: END IF;
508:
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: -- Validate start_date active and end_date active
514: --end date active must be greater than start date active

Line 529: l_return_status := FND_API.G_RET_STS_ERROR;

525: p_QUALIFIERS_rec.start_date_active ) <
526: nvl(p_QUALIFIERS_rec.start_date_active,
527: p_QUALIFIERS_rec.end_date_active)
528: THEN
529: l_return_status := FND_API.G_RET_STS_ERROR;
530:
531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533:

Line 558: l_return_status := FND_API.G_RET_STS_ERROR;

554: IF UPPER(p_QUALIFIERS_rec.comparison_operator_code) = 'BETWEEN' AND
555: (p_QUALIFIERS_rec.qualifier_attr_value_to IS NULL OR
556: p_QUALIFIERS_rec.qualifier_attr_value IS NULL)
557: THEN
558: l_return_status := FND_API.G_RET_STS_ERROR;
559:
560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
561: THEN
562:

Line 579: l_return_status := FND_API.G_RET_STS_ERROR;

575: l_error_code:=QP_UTIL.validate_num_date(p_QUALIFIERS_rec.qualifier_datatype,
576: p_QUALIFIERS_rec.qualifier_attr_value_to);
577: IF l_error_code <> 0 THEN
578:
579: l_return_status := FND_API.G_RET_STS_ERROR;
580:
581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
582: THEN
583: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 608: l_return_status := FND_API.G_RET_STS_ERROR;

604: If Check_Duplicate_start_date(p_QUALIFIERS_rec.qualifier_grouping_no,
605: p_QUALIFIERS_rec.start_date_active,
606: p_QUALIFIERS_rec.qualifier_rule_id,
607: p_QUALIFIERS_rec.qualifier_id) THEN
608: l_return_status := FND_API.G_RET_STS_ERROR;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
611: Then
612: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');

Line 623: l_return_status := FND_API.G_RET_STS_ERROR;

619: If Check_Duplicate_end_date(p_QUALIFIERS_rec.qualifier_grouping_no,
620: p_QUALIFIERS_rec.end_date_active,
621: p_QUALIFIERS_rec.qualifier_rule_id,
622: p_QUALIFIERS_rec.qualifier_id) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;
624:
625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
626: Then
627: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');

Line 665: l_return_status := FND_API.G_RET_STS_ERROR;

661: If SQL%NOTFOUND
662: Then
663: null;
664: Else
665: l_return_status := FND_API.G_RET_STS_ERROR;
666: --dbms_output.put_line('entity validation for duplicaet id '||l_return_status);
667:
668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN

Line 700: l_return_status := FND_API.G_RET_STS_ERROR;

696:
697: If SQL%NOTFOUND
698: Then
699:
700: l_return_status := FND_API.G_RET_STS_ERROR;
701:
702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
703: THEN
704:

Line 731: l_return_status := FND_API.G_RET_STS_ERROR;

727: IF fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value_to) <
728: fnd_date.canonical_to_date(p_QUALIFIERS_rec.qualifier_attr_value)
729: THEN
730:
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
734: THEN
735: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');

Line 759: l_return_status := FND_API.G_RET_STS_ERROR;

755: );
756:
757: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
758: Then
759: l_return_status := FND_API.G_RET_STS_ERROR;
760:
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763:

Line 781: l_return_status := FND_API.G_RET_STS_ERROR;

777:
778:
779: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
780: Then
781: l_return_status := FND_API.G_RET_STS_ERROR;
782:
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785:

Line 805: l_return_status := FND_API.G_RET_STS_ERROR;

801: IF p_QUALIFIERS_rec.comparison_operator_code = '=' Then
802:
803: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
804: Then
805: l_return_status := FND_API.G_RET_STS_ERROR;
806:
807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809:

Line 847: l_return_status := FND_API.G_RET_STS_ERROR;

843: IF SQL%NOTFOUND
844: THEN
845:
846: oe_debug_pub.add('customer GSA not found');
847: l_return_status := FND_API.G_RET_STS_ERROR;
848:
849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
850: THEN
851:

Line 861: l_return_status := FND_API.G_RET_STS_ERROR;

857: ELSIF nvl(l_customer_gsa_indicator,'N') <> 'Y'
858: THEN
859:
860: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
861: l_return_status := FND_API.G_RET_STS_ERROR;
862:
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
864: THEN
865:

Line 894: l_return_status := FND_API.G_RET_STS_ERROR;

890: oe_debug_pub.add('n precede '||l_precedence);
891:
892: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
893: Then
894: l_return_status := FND_API.G_RET_STS_ERROR;
895:
896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
898:

Line 916: l_return_status := FND_API.G_RET_STS_ERROR;

912:
913:
914: If p_QUALIFIERS_rec.qualifier_datatype <> l_datatype --- invalid qualifier datatype
915: Then
916: l_return_status := FND_API.G_RET_STS_ERROR;
917:
918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
919: THEN
920: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 941: l_return_status := FND_API.G_RET_STS_ERROR;

937: l_error_code:=QP_UTIL.validate_num_date(p_QUALIFIERS_rec.qualifier_datatype,
938: p_QUALIFIERS_rec.qualifier_attr_value);
939: IF l_error_code <> 0 THEN
940:
941: l_return_status := FND_API.G_RET_STS_ERROR;
942:
943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
944: THEN
945: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 969: l_return_status := FND_API.G_RET_STS_ERROR;

965: WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id;
966:
967: If SQL%NOTFOUND
968: Then
969: l_return_status := FND_API.G_RET_STS_ERROR;
970:
971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
972: THEN
973: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 995: l_return_status := FND_API.G_RET_STS_ERROR;

991: WHERE qualifier_rule_id = p_QUALIFIERS_rec.created_from_rule_id;
992:
993: If SQL%NOTFOUND
994: Then
995: l_return_status := FND_API.G_RET_STS_ERROR;
996:
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 1020: l_return_status := FND_API.G_RET_STS_ERROR;

1016: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id;
1017:
1018: If SQL%NOTFOUND
1019: Then
1020: l_return_status := FND_API.G_RET_STS_ERROR;
1021:
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 1045: l_return_status := FND_API.G_RET_STS_ERROR;

1041: WHERE list_line_id = p_QUALIFIERS_rec.list_line_id;
1042:
1043: If SQL%NOTFOUND
1044: Then
1045: l_return_status := FND_API.G_RET_STS_ERROR;
1046:
1047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1048: THEN
1049: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

Line 1058: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1054: End If;
1055: END IF; */
1056:
1057:
1058: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1059:
1060: RAISE FND_API.G_EXC_ERROR;
1061:
1062: END IF;

Line 1060: RAISE FND_API.G_EXC_ERROR;

1056:
1057:
1058: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1059:
1060: RAISE FND_API.G_EXC_ERROR;
1061:
1062: END IF;
1063:
1064: --- start bug2091362

Line 1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1083: , p_request_Type => QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1084: , x_return_status => l_return_status
1085: );
1086:
1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1088:
1089: oe_debug_pub.add('failed in logging a delayed request ');
1090:
1091: RAISE FND_API.G_EXC_ERROR;

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1088:
1089: oe_debug_pub.add('failed in logging a delayed request ');
1090:
1091: RAISE FND_API.G_EXC_ERROR;
1092:
1093: END IF;
1094:
1095: /* After deleting request if any log a new request to check duplicate modifier list lines with product attribute */

Line 1120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1116: , p_param6 => NULL
1117: , x_return_status => l_return_status
1118: );
1119:
1120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1121:
1122: oe_debug_pub.add('failed in logging a delayed request ');
1123:
1124: RAISE FND_API.G_EXC_ERROR;

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1121:
1122: oe_debug_pub.add('failed in logging a delayed request ');
1123:
1124: RAISE FND_API.G_EXC_ERROR;
1125:
1126: END IF;
1127:
1128: ELSE

Line 1151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1147: , p_param6 => p_product_attr_value
1148: , x_return_status => l_return_status
1149: );
1150:
1151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1152:
1153: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1154:
1155: RAISE FND_API.G_EXC_ERROR;

Line 1155: RAISE FND_API.G_EXC_ERROR;

1151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1152:
1153: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1154:
1155: RAISE FND_API.G_EXC_ERROR;
1156:
1157: END IF;
1158: END IF;
1159: oe_debug_pub.add('after logging delayed request from qualfiers ');

Line 1236: l_return_status := FND_API.G_RET_STS_ERROR;

1232: ,p_Qualifiers_rec.qualifier_context
1233: ,p_Qualifiers_rec.qualifier_attribute
1234: );
1235: IF l_segment_level = 'ORDER' THEN
1236: l_return_status := FND_API.G_RET_STS_ERROR;
1237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1238: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1239: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1240: p_attribute => p_Qualifiers_rec.qualifier_attribute,

Line 1277: l_return_status := FND_API.G_RET_STS_ERROR;

1273: if ((l_modifier_level_code in ('LINE', 'LINEGROUP') and l_segment_level = 'ORDER')
1274: OR
1275: (l_modifier_level_code = 'ORDER' and l_segment_level = 'LINE')) then
1276:
1277: l_return_status := FND_API.G_RET_STS_ERROR;
1278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1279: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1280: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1281: p_attribute => p_Qualifiers_rec.qualifier_attribute,

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: x_return_status := l_return_status;
1303:
1304: EXCEPTION
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307:
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1308: x_return_status := FND_API.G_RET_STS_ERROR;

1304: EXCEPTION
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307:
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1306: WHEN FND_API.G_EXC_ERROR THEN
1307:
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313:
1314: WHEN OTHERS THEN

Line 1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313:
1314: WHEN OTHERS THEN
1315:
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313:
1314: WHEN OTHERS THEN
1315:
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1319: THEN
1320: OE_MSG_PUB.Add_Exc_Msg

Line 1339: x_return_status := FND_API.G_RET_STS_SUCCESS;

1335: )
1336: IS
1337: BEGIN
1338:
1339: x_return_status := FND_API.G_RET_STS_SUCCESS;
1340:
1341: -- Validate QUALIFIERS attributes
1342:
1343:

Line 1356: x_return_status := FND_API.G_RET_STS_ERROR;

1352: THEN
1353:
1354: --dbms_output.put_line(' inside if not null comparison operator');
1355: IF NOT QP_Validate.Comparison_Operator(p_QUALIFIERS_rec.comparison_operator_code) THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: END IF;
1358: END IF;
1359:
1360:

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR;

1368: p_old_QUALIFIERS_rec.created_by OR
1369: p_old_QUALIFIERS_rec.created_by IS NULL )
1370: THEN
1371: IF NOT QP_Validate.Created_By(p_QUALIFIERS_rec.created_by) THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374: END IF;
1375: --dbms_output.put_line('status is '||x_return_status);
1376:

Line 1387: x_return_status := FND_API.G_RET_STS_ERROR;

1383: p_old_QUALIFIERS_rec.created_from_rule_id OR
1384: p_old_QUALIFIERS_rec.created_from_rule_id IS NULL )
1385: THEN
1386: IF NOT QP_Validate.Created_From_Rule(p_QUALIFIERS_rec.created_from_rule_id) THEN
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: END IF;
1389: END IF;
1390:
1391: --dbms_output.put_line(' created from status is '||x_return_status);

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399: p_old_QUALIFIERS_rec.creation_date OR
1400: p_old_QUALIFIERS_rec.creation_date IS NULL )
1401: THEN
1402: IF NOT QP_Validate.Creation_Date(p_QUALIFIERS_rec.creation_date) THEN
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: END IF;
1405: END IF;
1406: --dbms_output.put_line('status is '||x_return_status);
1407:

Line 1418: x_return_status := FND_API.G_RET_STS_ERROR;

1414: p_old_QUALIFIERS_rec.end_date_active OR
1415: p_old_QUALIFIERS_rec.end_date_active IS NULL )
1416: THEN
1417: IF NOT QP_Validate.End_Date_Active(p_QUALIFIERS_rec.end_date_active) THEN
1418: x_return_status := FND_API.G_RET_STS_ERROR;
1419: END IF;
1420: END IF;
1421: --dbms_output.put_line('end adate status is '||x_return_status);
1422:

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: p_old_QUALIFIERS_rec.excluder_flag OR
1430: p_old_QUALIFIERS_rec.excluder_flag IS NULL )
1431: THEN
1432: IF NOT QP_Validate.Excluder(p_QUALIFIERS_rec.excluder_flag) THEN
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: END IF;
1435: END IF;
1436: --dbms_output.put_line(' excluder flag status is '||x_return_status);
1437:

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

1444: p_old_QUALIFIERS_rec.last_updated_by OR
1445: p_old_QUALIFIERS_rec.last_updated_by IS NULL )
1446: THEN
1447: IF NOT QP_Validate.Last_Updated_By(p_QUALIFIERS_rec.last_updated_by) THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: END IF;
1450: END IF;
1451: --dbms_output.put_line('status is '||x_return_status);
1452:

Line 1463: x_return_status := FND_API.G_RET_STS_ERROR;

1459: p_old_QUALIFIERS_rec.last_update_date OR
1460: p_old_QUALIFIERS_rec.last_update_date IS NULL )
1461: THEN
1462: IF NOT QP_Validate.Last_Update_Date(p_QUALIFIERS_rec.last_update_date) THEN
1463: x_return_status := FND_API.G_RET_STS_ERROR;
1464: END IF;
1465: END IF;
1466: --dbms_output.put_line('status is '||x_return_status);
1467:

Line 1478: x_return_status := FND_API.G_RET_STS_ERROR;

1474: p_old_QUALIFIERS_rec.last_update_login OR
1475: p_old_QUALIFIERS_rec.last_update_login IS NULL )
1476: THEN
1477: IF NOT QP_Validate.Last_Update_Login(p_QUALIFIERS_rec.last_update_login) THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: END IF;
1480: END IF;
1481: --dbms_output.put_line('status is '||x_return_status);
1482:

Line 1493: x_return_status := FND_API.G_RET_STS_ERROR;

1489: p_old_QUALIFIERS_rec.list_header_id OR
1490: p_old_QUALIFIERS_rec.list_header_id IS NULL )
1491: THEN
1492: IF NOT QP_Validate.List_Header(p_QUALIFIERS_rec.list_header_id) THEN
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: END IF;
1495: END IF;
1496: --dbms_output.put_line('status is '||x_return_status);
1497:

Line 1508: x_return_status := FND_API.G_RET_STS_ERROR;

1504: p_old_QUALIFIERS_rec.list_line_id OR
1505: p_old_QUALIFIERS_rec.list_line_id IS NULL )
1506: THEN
1507: IF NOT QP_Validate.List_Line(p_QUALIFIERS_rec.list_line_id) THEN
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509: END IF;
1510: END IF;
1511: --dbms_output.put_line('status is '||x_return_status);
1512:

Line 1524: x_return_status := FND_API.G_RET_STS_ERROR;

1520: p_old_QUALIFIERS_rec.program_application_id OR
1521: p_old_QUALIFIERS_rec.program_application_id IS NULL )
1522: THEN
1523: IF NOT QP_Validate.Program_Application(p_QUALIFIERS_rec.program_application_id) THEN
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: END IF;
1526: END IF;
1527: --dbms_output.put_line('status is '||x_return_status);
1528:

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536: p_old_QUALIFIERS_rec.program_id OR
1537: p_old_QUALIFIERS_rec.program_id IS NULL )
1538: THEN
1539: IF NOT QP_Validate.Program(p_QUALIFIERS_rec.program_id) THEN
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: END IF;
1542: END IF;
1543: --dbms_output.put_line('status is '||x_return_status);
1544:

Line 1555: x_return_status := FND_API.G_RET_STS_ERROR;

1551: p_old_QUALIFIERS_rec.program_update_date OR
1552: p_old_QUALIFIERS_rec.program_update_date IS NULL )
1553: THEN
1554: IF NOT QP_Validate.Program_Update_Date(p_QUALIFIERS_rec.program_update_date) THEN
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: END IF;
1557: END IF;
1558: --dbms_output.put_line('status is '||x_return_status);
1559:

Line 1570: x_return_status := FND_API.G_RET_STS_ERROR;

1566: p_old_QUALIFIERS_rec.qualifier_attribute OR
1567: p_old_QUALIFIERS_rec.qualifier_attribute IS NULL )
1568: THEN
1569: IF NOT QP_Validate.Qualifier_Attribute(p_QUALIFIERS_rec.qualifier_attribute) THEN
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: END IF;
1572: END IF;
1573: --dbms_output.put_line(' attribute status is '||x_return_status);
1574:

Line 1585: x_return_status := FND_API.G_RET_STS_ERROR;

1581: p_old_QUALIFIERS_rec.qualifier_attr_value OR
1582: p_old_QUALIFIERS_rec.qualifier_attr_value IS NULL )
1583: THEN
1584: IF NOT QP_Validate.Qualifier_Attr_Value(p_QUALIFIERS_rec.qualifier_attr_value) THEN
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: END IF;
1587: END IF;
1588: --dbms_output.put_line(' attr value status is '||x_return_status);
1589:

Line 1600: x_return_status := FND_API.G_RET_STS_ERROR;

1596: p_old_QUALIFIERS_rec.qualifier_attr_value_to OR
1597: p_old_QUALIFIERS_rec.qualifier_attr_value_to IS NULL )
1598: THEN
1599: IF NOT QP_Validate.Qualifier_Attr_Value_to(p_QUALIFIERS_rec.qualifier_attr_value_to) THEN
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: END IF;
1602: END IF;
1603: --dbms_output.put_line(' attr_value to status is '||x_return_status);
1604:

Line 1616: x_return_status := FND_API.G_RET_STS_ERROR;

1612: p_old_QUALIFIERS_rec.qualifier_context OR
1613: p_old_QUALIFIERS_rec.qualifier_context IS NULL )
1614: THEN
1615: IF NOT QP_Validate.Qualifier_Context(p_QUALIFIERS_rec.qualifier_context) THEN
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: END IF;
1618: END IF;
1619: --dbms_output.put_line(' context status is '||x_return_status);
1620:

Line 1631: x_return_status := FND_API.G_RET_STS_ERROR;

1627: p_old_QUALIFIERS_rec.qualifier_datatype OR
1628: p_old_QUALIFIERS_rec.qualifier_datatype IS NULL )
1629: THEN
1630: IF NOT QP_Validate.Qualifier_Datatype(p_QUALIFIERS_rec.qualifier_datatype) THEN
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: END IF;
1633: END IF;
1634: --dbms_output.put_line(' data type status is '||x_return_status);
1635:

Line 1642: x_return_status := FND_API.G_RET_STS_ERROR;

1638: p_old_QUALIFIERS_rec.qualifier_date_format OR
1639: p_old_QUALIFIERS_rec.qualifier_date_format IS NULL )
1640: THEN
1641: IF NOT QP_Validate.Qualifier_Date_Format(p_QUALIFIERS_rec.qualifier_date_format) THEN
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: END IF;
1644: END IF;*/
1645:
1646:

Line 1659: x_return_status := FND_API.G_RET_STS_ERROR;

1655: p_old_QUALIFIERS_rec.qualifier_grouping_no OR
1656: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1 )
1657: THEN
1658: IF NOT QP_Validate.Qualifier_Grouping_No(p_QUALIFIERS_rec.qualifier_grouping_no) THEN
1659: x_return_status := FND_API.G_RET_STS_ERROR;
1660: END IF;
1661: END IF;
1662: --dbms_output.put_line(' gropuing status is '||x_return_status);
1663:

Line 1674: x_return_status := FND_API.G_RET_STS_ERROR;

1670: p_old_QUALIFIERS_rec.qualifier_id OR
1671: p_old_QUALIFIERS_rec.qualifier_id IS NULL )
1672: THEN
1673: IF NOT QP_Validate.Qualifier(p_QUALIFIERS_rec.qualifier_id) THEN
1674: x_return_status := FND_API.G_RET_STS_ERROR;
1675: END IF;
1676: END IF;
1677: --dbms_output.put_line(' qualiifer id status is '||x_return_status);
1678:

Line 1688: x_return_status := FND_API.G_RET_STS_ERROR;

1684: p_old_QUALIFIERS_rec.qualifier_number_format OR
1685: p_old_QUALIFIERS_rec.qualifier_number_format IS NULL )
1686: THEN
1687: IF NOT QP_Validate.Qualifier_Number_Format(p_QUALIFIERS_rec.qualifier_number_format) THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: END IF;
1690: END IF;*/
1691:
1692:

Line 1702: x_return_status := FND_API.G_RET_STS_ERROR;

1698: p_old_QUALIFIERS_rec.qualifier_precedence OR
1699: p_old_QUALIFIERS_rec.qualifier_precedence IS NULL )
1700: THEN
1701: IF NOT QP_Validate.Qualifier_Precedence(p_QUALIFIERS_rec.qualifier_precedence) THEN
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: END IF;
1704: END IF;
1705: --dbms_output.put_line(' precedence status is '||x_return_status);
1706:

Line 1720: x_return_status := FND_API.G_RET_STS_ERROR;

1716: p_old_QUALIFIERS_rec.qualifier_rule_id OR
1717: p_old_QUALIFIERS_rec.qualifier_rule_id IS NULL )
1718: THEN
1719: IF NOT QP_Validate.Qualifier_Rule(p_QUALIFIERS_rec.qualifier_rule_id) THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: END IF;
1722: END IF;
1723: --dbms_output.put_line(' qualifier rule id status is '||x_return_status);
1724:

Line 1734: x_return_status := FND_API.G_RET_STS_ERROR;

1730: p_old_QUALIFIERS_rec.request_id OR
1731: p_old_QUALIFIERS_rec.request_id IS NULL )
1732: THEN
1733: IF NOT QP_Validate.Request(p_QUALIFIERS_rec.request_id) THEN
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: END IF;
1736: END IF;
1737: --dbms_output.put_line('status is '||x_return_status);
1738:

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: p_old_QUALIFIERS_rec.start_date_active OR
1745: p_old_QUALIFIERS_rec.start_date_active IS NULL )
1746: THEN
1747: IF NOT QP_Validate.Start_Date_Active(p_QUALIFIERS_rec.start_date_active) THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: END IF;
1750: END IF;
1751: --dbms_output.put_line('status is '||x_return_status);
1752: -- Added for TCA

Line 1759: x_return_status := FND_API.G_RET_STS_ERROR;

1755: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag OR
1756: p_old_QUALIFIERS_rec.qualify_hier_descendent_flag IS NULL )
1757: THEN
1758: IF NOT QP_Validate.Qualify_Hier_Descendent_Flag(p_QUALIFIERS_rec.qualify_hier_descendent_flag) THEN
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: END IF;
1761: END IF;
1762:
1763:

Line 1903: x_return_status := FND_API.G_RET_STS_ERROR;

1899: -- Validate descriptive flexfield.
1900:
1901: --dbms_output.put_line('validating flex ');
1902: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: END IF;
1905: --dbms_output.put_line('status is '||x_return_status);
1906:
1907: END IF;

Line 1913: WHEN FND_API.G_EXC_ERROR THEN

1909: -- Done validating attributes
1910:
1911: EXCEPTION
1912:
1913: WHEN FND_API.G_EXC_ERROR THEN
1914:
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1915: x_return_status := FND_API.G_RET_STS_ERROR;

1911: EXCEPTION
1912:
1913: WHEN FND_API.G_EXC_ERROR THEN
1914:
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1918:
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1913: WHEN FND_API.G_EXC_ERROR THEN
1914:
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1918:
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920:
1921: WHEN OTHERS THEN

Line 1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1918:
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920:
1921: WHEN OTHERS THEN
1922:
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920:
1921: WHEN OTHERS THEN
1922:
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924:
1925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: OE_MSG_PUB.Add_Exc_Msg

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

1938: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1939: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1940: )
1941: IS
1942: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1943: BEGIN
1944:
1945: -- Validate entity delete.
1946:

Line 1962: WHEN FND_API.G_EXC_ERROR THEN

1958: x_return_status := l_return_status;
1959:
1960: EXCEPTION
1961:
1962: WHEN FND_API.G_EXC_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965:
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1964: x_return_status := FND_API.G_RET_STS_ERROR;

1960: EXCEPTION
1961:
1962: WHEN FND_API.G_EXC_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965:
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1962: WHEN FND_API.G_EXC_ERROR THEN
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965:
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969:
1970: WHEN OTHERS THEN

Line 1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965:
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969:
1970: WHEN OTHERS THEN
1971:
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969:
1970: WHEN OTHERS THEN
1971:
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973:
1974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1975: THEN
1976: OE_MSG_PUB.Add_Exc_Msg