APPS.QP_MODIFIERS_PVT dependencies on FND_API

Line 102: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

98: );
99:
100: -- Set record return status.
101:
102: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --added for moac for BSA --fix for bug 4748511
105: if l_MODIFIER_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)
106: and l_control_rec.called_from_ui = 'N'

Line 122: l_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;

118: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
119:
120: oe_debug_pub.add('Private 01');
121: --dbms_output.put_line('Private 01');
122: l_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;
123:
124: -- Set missing old record elements to NULL.
125:
126: l_old_MODIFIER_LIST_rec :=

Line 136: l_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;

132: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
133: THEN
134: OE_Debug_Pub.add('update on header');
135: --dbms_output.put_line('update on header');
136: l_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;
137:
138: -- Query Old if missing
139:
140: IF l_old_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM

Line 140: IF l_old_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM

136: l_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;
137:
138: -- Query Old if missing
139:
140: IF l_old_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM
141: THEN
142:
143: OE_Debug_Pub.add('query'||to_char(l_modifier_list_rec.list_header_id));
144: --dbms_output.put_line('query'||to_char(l_modifier_list_rec.list_header_id));

Line 185: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

181: OR l_control_rec.change_attributes
182: THEN
183:
184: oe_debug_pub.add('if Private 03');
185: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
186:
187: oe_debug_pub.add('2if Private 03');
188: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
189: QP_Validate_Modifier_List.Attributes

Line 196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

192: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
193: );
194:
195: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: );
194:
195: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:

Line 198: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

194:
195: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: END IF;

Line 199: RAISE FND_API.G_EXC_ERROR;

195: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
196: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: END IF;
203:

Line 280: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

276: null;
277:
278: END IF;
279:
280: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;

Line 281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

277:
278: END IF;
279:
280: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:

Line 282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

278: END IF;
279:
280: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: END IF;

Line 283: RAISE FND_API.G_EXC_ERROR;

279:
280: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
283: RAISE FND_API.G_EXC_ERROR;
284: END IF;
285:
286: END IF;
287:

Line 298: RAISE FND_API.G_EXC_ERROR;

294:
295: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_MODIFIER');
296: OE_MSG_PUB.Add;
297:
298: RAISE FND_API.G_EXC_ERROR;
299: /*
300: QP_Modifier_List_Util.Delete_Row
301: ( p_list_header_id => l_MODIFIER_LIST_rec.list_header_id
302: );

Line 342: WHEN FND_API.G_EXC_ERROR THEN

338: oe_debug_pub.add('END modifier list in Private');
339: --dbms_output.put_line('END modifier list in Private');
340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343:
344: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
345: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
346: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;

Line 344: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

340: EXCEPTION
341:
342: WHEN FND_API.G_EXC_ERROR THEN
343:
344: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
345: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
346: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
347:
348: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

356: end if;
357:
358: RAISE;
359:
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361:
362: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
364: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;

Line 362: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

358: RAISE;
359:
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361:
362: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
364: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
365:
366: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 387: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

383: , 'Modifier_List'
384: );
385: END IF;
386:
387: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
389: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
390:
391: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
397: x_return_status => l_return_status );
398: end if;
399:
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401:
402: END Modifier_List;
403:
404: -- Modifierss

Line 481: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

477: );
478:
479: -- Set record return status.
480:
481: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: -- Prepare record.
484:
485: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 487: l_MODIFIERS_rec.db_flag := FND_API.G_FALSE;

483: -- Prepare record.
484:
485: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
486:
487: l_MODIFIERS_rec.db_flag := FND_API.G_FALSE;
488:
489: -- Set missing old record elements to NULL.
490:
491: l_old_MODIFIERS_rec :=

Line 498: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;

494: ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
495: OR l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
496: THEN
497:
498: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
499:
500: -- Query Old if missing
501:
502: IF l_old_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM

Line 502: IF l_old_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM

498: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
499:
500: -- Query Old if missing
501:
502: IF l_old_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM
503: THEN
504:
505: l_old_MODIFIERS_rec := QP_Modifiers_Util.Query_Row
506: ( p_list_line_id => l_MODIFIERS_rec.list_line_id

Line 537: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

533: IF l_control_rec.default_attributes
534: OR l_control_rec.change_attributes
535: THEN
536:
537: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
538:
539: QP_Validate_Modifiers.Attributes
540: ( x_return_status => l_return_status
541: , p_MODIFIERS_rec => l_MODIFIERS_rec

Line 545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

541: , p_MODIFIERS_rec => l_MODIFIERS_rec
542: , p_old_MODIFIERS_rec => l_old_MODIFIERS_rec
543: );
544:
545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

542: , p_old_MODIFIERS_rec => l_old_MODIFIERS_rec
543: );
544:
545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550:

Line 547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

543: );
544:
545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550:
551: END IF;

Line 548: RAISE FND_API.G_EXC_ERROR;

544:
545: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550:
551: END IF;
552:

Line 620: AND (l_MODIFIERS_rec.modifier_parent_index <> FND_API.G_MISS_NUM)

616:
617: --dbms_output.put_line('before if');
618:
619: IF ((l_MODIFIERS_rec.modifier_parent_index IS NOT NULL)
620: AND (l_MODIFIERS_rec.modifier_parent_index <> FND_API.G_MISS_NUM)
621: AND l_MODIFIERS_rec.list_line_type_code not in ('PBH', 'OID','PRG')
622: AND l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_type_code IN ('PBH', 'OID', 'PRG')) THEN
623:
624: --dbms_output.put_line('inside if');

Line 639: l_MODIFIERS_rec.modifier_parent_index = FND_API.G_MISS_NUM THEN

635: l_MODIFIERS_rec.rltd_modifier_grp_type := 'COUPON';
636: l_MODIFIERS_rec.from_rltd_modifier_id := l_MODIFIERS_rec.list_line_id;
637:
638: ELSIF l_MODIFIERS_rec.modifier_parent_index IS NULL OR
639: l_MODIFIERS_rec.modifier_parent_index = FND_API.G_MISS_NUM THEN
640: --added this else clause for CRM requirement bug 1615344
641:
642: --dbms_output.put_line('inside elsif');
643: l_MODIFIERS_rec.to_rltd_modifier_id := l_MODIFIERS_rec.list_line_id;

Line 659: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

655:
656: END IF;
657:
658: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
659: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: END IF;

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: END IF;
657:
658: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
659: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: END IF;
664:

Line 661: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

657:
658: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
659: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: END IF;
664:
665: END IF;

Line 662: RAISE FND_API.G_EXC_ERROR;

658: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
659: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;
663: END IF;
664:
665: END IF;
666:

Line 689: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM

685:
686: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
687:
688: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
689: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
690: AND l_MODIFIERS_rec.list_line_type_code <> 'PMR'
691:
692: THEN
693:

Line 697: RAISE FND_API.G_EXC_ERROR;

693:
694: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_MODIFIER_LIST');
695: OE_MSG_PUB.Add;
696:
697: RAISE FND_API.G_EXC_ERROR;
698: ELSE
699:
700: oe_debug_pub.add('just before deleteee');
701: QP_Modifiers_Util.Delete_Row

Line 821: AND (l_MODIFIERS_rec.modifier_parent_index <> FND_API.G_MISS_NUM)

817:
818:
819:
820: IF ((l_MODIFIERS_rec.modifier_parent_index IS NOT NULL)
821: AND (l_MODIFIERS_rec.modifier_parent_index <> FND_API.G_MISS_NUM)
822: AND l_MODIFIERS_rec.list_line_type_code not in ('PBH', 'OID','PRG')
823: AND l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_type_code IN ('PBH', 'OID', 'PRG')) THEN
824:
825: --dbms_output.put_line('inside if');

Line 919: WHEN FND_API.G_EXC_ERROR THEN

915:
916:
917: EXCEPTION
918:
919: WHEN FND_API.G_EXC_ERROR THEN
920:
921: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
922: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
923: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;

Line 921: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

917: EXCEPTION
918:
919: WHEN FND_API.G_EXC_ERROR THEN
920:
921: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
922: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
923: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
924:
925: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

948:
949: -- mkarya for bug 1728764, so that the exception is handled by the calling function.
950: RAISE;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953:
954: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
956: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;

Line 954: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

950: RAISE;
951:
952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
953:
954: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
956: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
957:
958: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

978: p_entity_id => l_MODIFIERS_rec.list_line_id,
979: x_return_status => l_return_status );
980: end if;
981:
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983:
984: WHEN OTHERS THEN
985:
986: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 986: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983:
984: WHEN OTHERS THEN
985:
986: l_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
988: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
989:
990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1018: p_entity_id => l_MODIFIERS_rec.list_line_id,
1019: x_return_status => l_return_status );
1020: end if;
1021:
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023:
1024: END;
1025: END LOOP;
1026:

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031:
1032: oe_debug_pub.add('END modifierss in Private');
1033: EXCEPTION
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036:
1037: RAISE;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: WHEN FND_API.G_EXC_ERROR THEN
1036:
1037: RAISE;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040:
1041:
1042: RAISE;
1043:

Line 1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1051: );
1052: END IF;
1053:
1054:
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056:
1057: END Modifierss;
1058:
1059: -- Qualifierss

Line 1107: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1103: );
1104:
1105: -- Set record return status.
1106:
1107: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1108:
1109: -- Prepare record.
1110:
1111: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1114: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;

1110:
1111: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1112:
1113: oe_debug_pub.add('test01');
1114: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
1115:
1116: -- Set missing old record elements to NULL.
1117:
1118: l_old_QUALIFIERS_rec :=

Line 1125: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

1121: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1122: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
1123: THEN
1124:
1125: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1126:
1127: -- Query Old if missing
1128:
1129: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM

Line 1129: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM

1125: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1126:
1127: -- Query Old if missing
1128:
1129: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
1130: THEN
1131:
1132: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
1133: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id

Line 1161: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1157: IF l_control_rec.default_attributes
1158: OR l_control_rec.change_attributes
1159: THEN
1160:
1161: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1162:
1163: oe_debug_pub.add('before validate qual');
1164: QP_Validate_Qualifiers.Attributes
1165: ( x_return_status => l_return_status

Line 1171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1167: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1168: );
1169:
1170: oe_debug_pub.add('after validate qual');
1171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: );
1169:
1170: oe_debug_pub.add('after validate qual');
1171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:

Line 1173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1169:
1170: oe_debug_pub.add('after validate qual');
1171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: END IF;

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: oe_debug_pub.add('after validate qual');
1171: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: END IF;
1178:

Line 1248: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1244:
1245: END IF;
1246: oe_debug_pub.add('after entity validate');
1247:
1248: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;

Line 1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1245: END IF;
1246: oe_debug_pub.add('after entity validate');
1247:
1248: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253: oe_debug_pub.add('after entity validate end if');

Line 1250: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1246: oe_debug_pub.add('after entity validate');
1247:
1248: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253: oe_debug_pub.add('after entity validate end if');
1254:

Line 1251: RAISE FND_API.G_EXC_ERROR;

1247:
1248: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253: oe_debug_pub.add('after entity validate end if');
1254:
1255: END IF;

Line 1315: WHEN FND_API.G_EXC_ERROR THEN

1311:
1312:
1313: EXCEPTION
1314:
1315: WHEN FND_API.G_EXC_ERROR THEN
1316:
1317: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1318: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1319: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;

Line 1317: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;

1313: EXCEPTION
1314:
1315: WHEN FND_API.G_EXC_ERROR THEN
1316:
1317: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1318: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1319: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1320:
1321: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1339:
1340: -- mkarya for bug 1728764, so that the exception is handled by the calling function.
1341: RAISE;
1342:
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344:
1345: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1347: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;

Line 1345: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341: RAISE;
1342:
1343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1344:
1345: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1347: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1348:
1349: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1364: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1365: x_return_status => l_return_status );
1366: end if;
1367:
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369:
1370: WHEN OTHERS THEN
1371:
1372: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1372: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369:
1370: WHEN OTHERS THEN
1371:
1372: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1374: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1375:
1376: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1399: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1400: x_return_status => l_return_status );
1401: end if;
1402:
1403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1404:
1405: oe_debug_pub.add('exp loop ');
1406: END;
1407: END LOOP;

Line 1417: WHEN FND_API.G_EXC_ERROR THEN

1413:
1414: oe_debug_pub.add('END qualifierss in Private');
1415: EXCEPTION
1416:
1417: WHEN FND_API.G_EXC_ERROR THEN
1418:
1419: RAISE;
1420:
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1417: WHEN FND_API.G_EXC_ERROR THEN
1418:
1419: RAISE;
1420:
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422:
1423:
1424: RAISE;
1425:

Line 1437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1433: );
1434: END IF;
1435:
1436:
1437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438:
1439: oe_debug_pub.add('EXP qualifierss in Private');
1440: END Qualifierss;
1441:

Line 1502: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1498: );
1499:
1500: -- Set record return status.
1501:
1502: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1503:
1504: -- Prepare record.
1505:
1506: oe_debug_pub.add('oper = '|| l_PRICING_ATTR_rec.operation );

Line 1510: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;

1506: oe_debug_pub.add('oper = '|| l_PRICING_ATTR_rec.operation );
1507:
1508: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1509:
1510: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
1511:
1512: -- Set missing old record elements to NULL.
1513:
1514: l_old_PRICING_ATTR_rec :=

Line 1521: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

1517: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1518: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1519: THEN
1520:
1521: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1522:
1523: -- Query Old if missing
1524:
1525: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM

Line 1525: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM

1521: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1522:
1523: -- Query Old if missing
1524:
1525: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
1526: THEN
1527:
1528: oe_debug_pub.add('before query');
1529: l_old_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row

Line 1610: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1606: IF l_control_rec.default_attributes
1607: OR l_control_rec.change_attributes
1608: THEN
1609:
1610: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1611:
1612: QP_Validate_Pricing_Attr.Attributes
1613: ( x_return_status => l_return_status
1614: , p_PRICING_ATTR_rec => l_PRICING_ATTR_rec

Line 1618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1614: , p_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1615: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1616: );
1617:
1618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;

Line 1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1615: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1616: );
1617:
1618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:

Line 1620: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1616: );
1617:
1618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: END IF;

Line 1621: RAISE FND_API.G_EXC_ERROR;

1617:
1618: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: END IF;
1625:

Line 1695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1691: null;
1692:
1693: END IF;
1694:
1695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;

Line 1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1692:
1693: END IF;
1694:
1695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:

Line 1697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1693: END IF;
1694:
1695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: END IF;

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694:
1695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: END IF;
1702:

Line 1742: RAISE FND_API.G_EXC_ERROR;

1738: AND ROWNUM = 1;
1739:
1740: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_DETAIL_LINES');
1741: OE_MSG_PUB.Add;
1742: RAISE FND_API.G_EXC_ERROR;
1743:
1744:
1745: Exception
1746:

Line 1828: WHEN FND_API.G_EXC_ERROR THEN

1824:
1825: WHEN NO_DATA_FOUND THEN
1826: null;
1827:
1828: WHEN FND_API.G_EXC_ERROR THEN
1829:
1830: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1831: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1832: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;

Line 1830: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

1826: null;
1827:
1828: WHEN FND_API.G_EXC_ERROR THEN
1829:
1830: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1831: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1832: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1833:
1834: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);

Line 1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1859:
1860: -- mkarya for bug 1728764, so that the exception is handled by the calling function.
1861: RAISE;
1862:
1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1864:
1865: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1867: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;

Line 1865: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1861: RAISE;
1862:
1863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1864:
1865: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1867: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1868:
1869: -- mkarya If process_modifiers has been called from public package, then ONLY call

Line 1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1889: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1890: x_return_status => l_return_status );
1891: end if;
1892:
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894:
1895: WHEN OTHERS THEN
1896:
1897: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1897: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894:
1895: WHEN OTHERS THEN
1896:
1897: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1899: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1900:
1901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1929: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1930: x_return_status => l_return_status );
1931: end if;
1932:
1933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1934:
1935: END;
1936: END LOOP;
1937:

Line 1946: WHEN FND_API.G_EXC_ERROR THEN

1942:
1943: oe_debug_pub.add('END pricing_attrs in Private');
1944: EXCEPTION
1945:
1946: WHEN FND_API.G_EXC_ERROR THEN
1947:
1948: RAISE;
1949:
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1946: WHEN FND_API.G_EXC_ERROR THEN
1947:
1948: RAISE;
1949:
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951:
1952:
1953: RAISE;
1954:

Line 1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1962: );
1963: END IF;
1964:
1965:
1966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1967:
1968: END Pricing_Attrs;
1969:
1970: -- Start of Comments

Line 1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1984: -- End of Comments
1985:
1986: PROCEDURE Process_Modifiers
1987: ( p_api_version_number IN NUMBER
1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1992: QP_GLOBALS.G_MISS_CONTROL_REC

Line 1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1985:
1986: PROCEDURE Process_Modifiers
1987: ( p_api_version_number IN NUMBER
1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1992: QP_GLOBALS.G_MISS_CONTROL_REC
1993: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1986: PROCEDURE Process_Modifiers
1987: ( p_api_version_number IN NUMBER
1988: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1989: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1990: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1991: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1992: QP_GLOBALS.G_MISS_CONTROL_REC
1993: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1994: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 2056: IF NOT FND_API.Compatible_API_Call

2052: oe_debug_pub.add('BEGIN process_modifiers in Private');
2053: --dbms_output.put_line('BEGIN process_modifiers in Private');
2054: -- Standard call to check for call compatibility
2055:
2056: IF NOT FND_API.Compatible_API_Call
2057: ( l_api_version_number
2058: , p_api_version_number
2059: , l_api_name
2060: , G_PKG_NAME

Line 2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2059: , l_api_name
2060: , G_PKG_NAME
2061: )
2062: THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064: END IF;
2065:
2066: -- Initialize message list.
2067:

Line 2068: IF FND_API.to_Boolean(p_init_msg_list) THEN

2064: END IF;
2065:
2066: -- Initialize message list.
2067:
2068: IF FND_API.to_Boolean(p_init_msg_list) THEN
2069: OE_MSG_PUB.initialize;
2070: END IF;
2071:
2072: -- BOI not available when QP not installed

Line 2079: l_return_status := FND_API.G_RET_STS_ERROR;

2075:
2076: IF l_qp_status = 'N'
2077: THEN
2078:
2079: l_return_status := FND_API.G_RET_STS_ERROR;
2080: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
2081: OE_MSG_PUB.Add;
2082: RAISE FND_API.G_EXC_ERROR;
2083:

Line 2082: RAISE FND_API.G_EXC_ERROR;

2078:
2079: l_return_status := FND_API.G_RET_STS_ERROR;
2080: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
2081: OE_MSG_PUB.Add;
2082: RAISE FND_API.G_EXC_ERROR;
2083:
2084: END IF;
2085:
2086: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

Line 2142: ,p_delete => FND_API.G_TRUE

2138:
2139: -- FOR QUALIFICATION_IND
2140: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2141: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
2142: ,p_delete => FND_API.G_TRUE
2143: ,x_return_status => l_return_status
2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2141: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
2142: ,p_delete => FND_API.G_TRUE
2143: ,x_return_status => l_return_status
2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;

Line 2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2142: ,p_delete => FND_API.G_TRUE
2143: ,x_return_status => l_return_status
2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: -- NULL;

Line 2147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2143: ,x_return_status => l_return_status
2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: -- NULL;
2151:

Line 2148: RAISE FND_API.G_EXC_ERROR;

2144: );
2145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: END IF;
2150: -- NULL;
2151:
2152: END IF;

Line 2164: l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)

2160: l_MODIFIERS_rec := l_MODIFIERS_tbl(I);
2161:
2162: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2163: AND (l_MODIFIERS_rec.list_header_id IS NULL OR
2164: l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2165: THEN
2166:
2167: -- Copy parent_id.
2168:

Line 2199: ,p_delete => FND_API.G_TRUE

2195:
2196: -- FOR QUALIFICATION_IND
2197: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2198: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2199: ,p_delete => FND_API.G_TRUE
2200: ,x_return_status => l_return_status
2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2198: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2199: ,p_delete => FND_API.G_TRUE
2200: ,x_return_status => l_return_status
2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;

Line 2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2199: ,p_delete => FND_API.G_TRUE
2200: ,x_return_status => l_return_status
2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;
2207:

Line 2204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2200: ,x_return_status => l_return_status
2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;
2207:
2208: END IF;

Line 2205: RAISE FND_API.G_EXC_ERROR;

2201: );
2202: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;
2207:
2208: END IF;
2209:

Line 2220: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)

2216: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2217:
2218: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2219: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2220: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2221: THEN
2222:
2223: oe_debug_pub.add('here3');
2224: -- Copy parent_id.

Line 2254: ,p_delete => FND_API.G_TRUE

2250: oe_debug_pub.add('here5');
2251: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2252: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2253: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2254: ,p_delete => FND_API.G_TRUE
2255: ,x_return_status => l_return_status
2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2253: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2254: ,p_delete => FND_API.G_TRUE
2255: ,x_return_status => l_return_status
2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;

Line 2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2254: ,p_delete => FND_API.G_TRUE
2255: ,x_return_status => l_return_status
2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:

Line 2259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2255: ,x_return_status => l_return_status
2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: NULL;

Line 2260: RAISE FND_API.G_EXC_ERROR;

2256: );
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2259: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: NULL;
2264:

Line 2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)

2272:
2273: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2274: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2275: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2277: THEN
2278:
2279: oe_debug_pub.add('here6');
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');

Line 2332: ,p_delete => FND_API.G_TRUE

2328:
2329:
2330: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2331: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2332: ,p_delete => FND_API.G_TRUE
2333: ,x_return_status => l_return_status
2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2331: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2332: ,p_delete => FND_API.G_TRUE
2333: ,x_return_status => l_return_status
2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;

Line 2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2332: ,p_delete => FND_API.G_TRUE
2333: ,x_return_status => l_return_status
2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340: -- NULL;

Line 2337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2333: ,x_return_status => l_return_status
2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340: -- NULL;
2341:

Line 2338: RAISE FND_API.G_EXC_ERROR;

2334: );
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2337: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340: -- NULL;
2341:
2342: END IF;

Line 2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2352: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2353: (
2354: x_return_status => l_return_status
2355: );
2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;

Line 2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2353: (
2354: x_return_status => l_return_status
2355: );
2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;
2361: /*

Line 2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2354: x_return_status => l_return_status
2355: );
2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;
2361: /*
2362: oe_debug_pub.add('calling process_request');

Line 2359: RAISE FND_API.G_EXC_ERROR;

2355: );
2356: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;
2361: /*
2362: oe_debug_pub.add('calling process_request');
2363: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

Line 2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2364: x_return_status=>l_return_status);
2365:
2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2367:
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: END IF;

Line 2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2365:
2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2367:
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: END IF;
2373:

Line 2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2367:
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: END IF;
2373:
2374: */

Line 2371: RAISE FND_API.G_EXC_ERROR;

2367:
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2371: RAISE FND_API.G_EXC_ERROR;
2372: END IF;
2373:
2374: */
2375: NULL;

Line 2400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2396: (
2397: x_return_status => l_return_status
2398: );
2399:
2400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;

Line 2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2397: x_return_status => l_return_status
2398: );
2399:
2400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405: oe_debug_pub.add('After processing delayed request for duplicate modifiers');

Line 2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2398: );
2399:
2400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2406:

Line 2403: RAISE FND_API.G_EXC_ERROR;

2399:
2400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2406:
2407: END IF;

Line 2452: x_return_status := FND_API.G_RET_STS_SUCCESS;

2448: END IF;
2449:
2450: -- Derive return status.
2451:
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456: END IF;

Line 2454: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN

2450: -- Derive return status.
2451:
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456: END IF;
2457:
2458: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP

Line 2455: x_return_status := FND_API.G_RET_STS_ERROR;

2451:
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456: END IF;
2457:
2458: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP
2459:

Line 2460: IF l_MODIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2456: END IF;
2457:
2458: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP
2459:
2460: IF l_MODIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: END IF;
2463:
2464: END LOOP;

Line 2461: x_return_status := FND_API.G_RET_STS_ERROR;

2457:
2458: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP
2459:
2460: IF l_MODIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2461: x_return_status := FND_API.G_RET_STS_ERROR;
2462: END IF;
2463:
2464: END LOOP;
2465:

Line 2468: IF l_QUALIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2464: END LOOP;
2465:
2466: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2467:
2468: IF l_QUALIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2469: x_return_status := FND_API.G_RET_STS_ERROR;
2470: END IF;
2471:
2472: END LOOP;

Line 2469: x_return_status := FND_API.G_RET_STS_ERROR;

2465:
2466: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2467:
2468: IF l_QUALIFIERS_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2469: x_return_status := FND_API.G_RET_STS_ERROR;
2470: END IF;
2471:
2472: END LOOP;
2473:

Line 2476: IF l_PRICING_ATTR_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2472: END LOOP;
2473:
2474: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2475:
2476: IF l_PRICING_ATTR_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: END IF;
2479:
2480: END LOOP;

Line 2477: x_return_status := FND_API.G_RET_STS_ERROR;

2473:
2474: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2475:
2476: IF l_PRICING_ATTR_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: END IF;
2479:
2480: END LOOP;
2481:

Line 2495: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)

2491: IF ( p_control_rec.write_to_db --Bug#3309455
2492: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2493: AND x_MODIFIER_LIST_rec.list_source_code = 'BSO'
2494: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2495: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2496: )
2497: THEN
2498: oe_debug_pub.add('inside create qualifier for blanket modifier');
2499:

Line 2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2519: , p_operation => QP_GLOBALS.G_OPR_CREATE
2520: , x_return_status => l_return_status
2521: );
2522:
2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');

Line 2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2521: );
2522:
2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;

Line 2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2522:
2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530: END IF;

Line 2528: RAISE FND_API.G_EXC_ERROR;

2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530: END IF;
2531:
2532: END IF;

Line 2538: WHEN FND_API.G_EXC_ERROR THEN

2534: oe_debug_pub.add('END process_modifiers in Private');
2535:
2536: EXCEPTION
2537:
2538: WHEN FND_API.G_EXC_ERROR THEN
2539:
2540: x_return_status := FND_API.G_RET_STS_ERROR;
2541: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2542: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);

Line 2540: x_return_status := FND_API.G_RET_STS_ERROR;

2536: EXCEPTION
2537:
2538: WHEN FND_API.G_EXC_ERROR THEN
2539:
2540: x_return_status := FND_API.G_RET_STS_ERROR;
2541: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2542: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2543: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2544: if p_control_rec.called_from_ui = 'N' then

Line 2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2552: ( p_count => x_msg_count
2553: , p_data => x_msg_data
2554: );
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557:
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2559:
2560: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request

Line 2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2554: );
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557:
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2559:
2560: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2561: if p_control_rec.called_from_ui = 'N' then
2562: qp_delayed_requests_pvt.Clear_Request

Line 2574: x_return_status := FND_API.G_RET_STS_SUCCESS;

2570: , p_data => x_msg_data
2571: );
2572:
2573: WHEN NO_UPDATE_PRIVILEGE THEN
2574: x_return_status := FND_API.G_RET_STS_SUCCESS;
2575:
2576: -- Get message count and data
2577:
2578: oe_msg_pub.Count_And_Get

Line 2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2581: );
2582:
2583: WHEN OTHERS THEN
2584:
2585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2586:
2587: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2588: if p_control_rec.called_from_ui = 'N' then
2589: qp_delayed_requests_pvt.Clear_Request

Line 2629: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2625: -- End of Comments
2626:
2627: PROCEDURE Lock_Modifiers
2628: ( p_api_version_number IN NUMBER
2629: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2630: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2631: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2632: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

2645: )
2646: IS
2647: l_api_version_number CONSTANT NUMBER := 1.0;
2648: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2649: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2650: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2651: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2652: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2653: BEGIN

Line 2658: IF NOT FND_API.Compatible_API_Call

2654:
2655: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2656: -- Standard call to check for call compatibility
2657:
2658: IF NOT FND_API.Compatible_API_Call
2659: ( l_api_version_number
2660: , p_api_version_number
2661: , l_api_name
2662: , G_PKG_NAME

Line 2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2661: , l_api_name
2662: , G_PKG_NAME
2663: )
2664: THEN
2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;
2667:
2668: -- Initialize message list.
2669:

Line 2670: IF FND_API.to_Boolean(p_init_msg_list) THEN

2666: END IF;
2667:
2668: -- Initialize message list.
2669:
2670: IF FND_API.to_Boolean(p_init_msg_list) THEN
2671: OE_MSG_PUB.initialize;
2672: END IF;
2673:
2674: -- Set Savepoint

Line 2688: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2684: , x_MODIFIER_LIST_rec => x_MODIFIER_LIST_rec
2685: , x_return_status => l_return_status
2686: );
2687:
2688: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2691: RAISE FND_API.G_EXC_ERROR;
2692: END IF;

Line 2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2685: , x_return_status => l_return_status
2686: );
2687:
2688: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2691: RAISE FND_API.G_EXC_ERROR;
2692: END IF;
2693:

Line 2690: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2686: );
2687:
2688: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2691: RAISE FND_API.G_EXC_ERROR;
2692: END IF;
2693:
2694:

Line 2691: RAISE FND_API.G_EXC_ERROR;

2687:
2688: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2690: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2691: RAISE FND_API.G_EXC_ERROR;
2692: END IF;
2693:
2694:
2695: END IF;

Line 2709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2705: , x_MODIFIERS_rec => l_MODIFIERS_rec
2706: , x_return_status => l_return_status
2707: );
2708:
2709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;

Line 2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2706: , x_return_status => l_return_status
2707: );
2708:
2709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;
2714:

Line 2711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2707: );
2708:
2709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;
2714:
2715: x_MODIFIERS_tbl(I) := l_MODIFIERS_rec;

Line 2712: RAISE FND_API.G_EXC_ERROR;

2708:
2709: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2712: RAISE FND_API.G_EXC_ERROR;
2713: END IF;
2714:
2715: x_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
2716:

Line 2733: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2729: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
2730: , x_return_status => l_return_status
2731: );
2732:
2733: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;

Line 2734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2730: , x_return_status => l_return_status
2731: );
2732:
2733: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:

Line 2735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2731: );
2732:
2733: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2739: x_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;

Line 2736: RAISE FND_API.G_EXC_ERROR;

2732:
2733: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2735: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2736: RAISE FND_API.G_EXC_ERROR;
2737: END IF;
2738:
2739: x_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
2740:

Line 2757: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2753: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2754: , x_return_status => l_return_status
2755: );
2756:
2757: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2759: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2760: RAISE FND_API.G_EXC_ERROR;
2761: END IF;

Line 2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2754: , x_return_status => l_return_status
2755: );
2756:
2757: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2759: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2760: RAISE FND_API.G_EXC_ERROR;
2761: END IF;
2762:

Line 2759: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2755: );
2756:
2757: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2759: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2760: RAISE FND_API.G_EXC_ERROR;
2761: END IF;
2762:
2763: x_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;

Line 2760: RAISE FND_API.G_EXC_ERROR;

2756:
2757: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2759: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2760: RAISE FND_API.G_EXC_ERROR;
2761: END IF;
2762:
2763: x_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
2764:

Line 2771: x_return_status := FND_API.G_RET_STS_SUCCESS;

2767: END LOOP;
2768:
2769: -- Set return status
2770:
2771: x_return_status := FND_API.G_RET_STS_SUCCESS;
2772:
2773: -- Get message count and data
2774:
2775: OE_MSG_PUB.Count_And_Get

Line 2784: WHEN FND_API.G_EXC_ERROR THEN

2780: oe_debug_pub.add('END lock_modifiers in Private');
2781:
2782: EXCEPTION
2783:
2784: WHEN FND_API.G_EXC_ERROR THEN
2785:
2786: x_return_status := FND_API.G_RET_STS_ERROR;
2787:
2788: -- Get message count and data

Line 2786: x_return_status := FND_API.G_RET_STS_ERROR;

2782: EXCEPTION
2783:
2784: WHEN FND_API.G_EXC_ERROR THEN
2785:
2786: x_return_status := FND_API.G_RET_STS_ERROR;
2787:
2788: -- Get message count and data
2789:
2790: OE_MSG_PUB.Count_And_Get

Line 2799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2795: -- Rollback
2796:
2797: ROLLBACK TO Lock_Modifiers_PVT;
2798:
2799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2800:
2801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2802:
2803: -- Get message count and data

Line 2801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2797: ROLLBACK TO Lock_Modifiers_PVT;
2798:
2799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2800:
2801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2802:
2803: -- Get message count and data
2804:
2805: OE_MSG_PUB.Count_And_Get

Line 2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2812: ROLLBACK TO Lock_Modifiers_PVT;
2813:
2814: WHEN OTHERS THEN
2815:
2816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2817:
2818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: OE_MSG_PUB.Add_Exc_Msg

Line 2857: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2853: -- End of Comments
2854:
2855: PROCEDURE Get_Modifiers
2856: ( p_api_version_number IN NUMBER
2857: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2858: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2859: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2860: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2861: , p_list_header_id IN NUMBER

Line 2880: IF NOT FND_API.Compatible_API_Call

2876:
2877: oe_debug_pub.add('BEGIN get_modifiers in Private');
2878: -- Standard call to check for call compatibility
2879:
2880: IF NOT FND_API.Compatible_API_Call
2881: ( l_api_version_number
2882: , p_api_version_number
2883: , l_api_name
2884: , G_PKG_NAME

Line 2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2883: , l_api_name
2884: , G_PKG_NAME
2885: )
2886: THEN
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888: END IF;
2889:
2890: -- Initialize message list.
2891:

Line 2892: IF FND_API.to_Boolean(p_init_msg_list) THEN

2888: END IF;
2889:
2890: -- Initialize message list.
2891:
2892: IF FND_API.to_Boolean(p_init_msg_list) THEN
2893: OE_MSG_PUB.initialize;
2894: END IF;
2895:
2896: -- Get MODIFIER_LIST ( parent = MODIFIER_LIST )

Line 2945: x_return_status := FND_API.G_RET_STS_SUCCESS;

2941: x_PRICING_ATTR_tbl := l_x_PRICING_ATTR_tbl;
2942:
2943: -- Set return status
2944:
2945: x_return_status := FND_API.G_RET_STS_SUCCESS;
2946:
2947: -- Get message count and data
2948:
2949: OE_MSG_PUB.Count_And_Get

Line 2957: WHEN FND_API.G_EXC_ERROR THEN

2953:
2954:
2955: EXCEPTION
2956:
2957: WHEN FND_API.G_EXC_ERROR THEN
2958:
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960:
2961: -- Get message count and data

Line 2959: x_return_status := FND_API.G_RET_STS_ERROR;

2955: EXCEPTION
2956:
2957: WHEN FND_API.G_EXC_ERROR THEN
2958:
2959: x_return_status := FND_API.G_RET_STS_ERROR;
2960:
2961: -- Get message count and data
2962:
2963: OE_MSG_PUB.Count_And_Get

Line 2968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2964: ( p_count => x_msg_count
2965: , p_data => x_msg_data
2966: );
2967:
2968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2969:
2970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2971:
2972: -- Get message count and data

Line 2970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2966: );
2967:
2968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2969:
2970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2971:
2972: -- Get message count and data
2973:
2974: OE_MSG_PUB.Count_And_Get

Line 2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2977: );
2978:
2979: WHEN OTHERS THEN
2980:
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982:
2983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2984: THEN
2985: OE_MSG_PUB.Add_Exc_Msg