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_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 111: OR l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR)

107: and l_MODIFIER_LIST_rec.list_source_code IS NOT NULL
108: --bug14758481
109: --and l_MODIFIER_LIST_rec.global_flag = 'N'
110: and (NVL(l_MODIFIER_LIST_rec.global_flag,'N') = 'N'
111: OR l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR)
112: and nvl(QP_SECURITY.security_on, 'N') = 'N' then
113: l_MODIFIER_LIST_rec.global_flag := 'Y';
114: l_MODIFIER_LIST_rec.org_id := null;
115: end if;

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

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

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

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

Line 143: IF l_old_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM

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

Line 188: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

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

Line 199: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 202: RAISE FND_API.G_EXC_ERROR;

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

Line 283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 286: RAISE FND_API.G_EXC_ERROR;

282:
283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: END IF;
290:

Line 301: RAISE FND_API.G_EXC_ERROR;

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

Line 345: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

359: end if;
360:
361: RAISE;
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364:
365: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
367: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;

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

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

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

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

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

Line 505: IF l_old_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM

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

Line 540: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

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

Line 548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 551: RAISE FND_API.G_EXC_ERROR;

547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: END IF;
555:

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

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

Line 642: l_MODIFIERS_rec.modifier_parent_index = FND_API.G_MISS_NUM THEN

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

Line 662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 665: RAISE FND_API.G_EXC_ERROR;

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

Line 692: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM

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

Line 700: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 922: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1038: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1038: WHEN FND_API.G_EXC_ERROR THEN
1039:
1040: RAISE;
1041:
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043:
1044:
1045: RAISE;
1046:

Line 1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1054: );
1055: END IF;
1056:
1057:
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059:
1060: END Modifierss;
1061:
1062: -- Qualifierss

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

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

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

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

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

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

Line 1132: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM

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

Line 1164: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

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

Line 1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1177: RAISE FND_API.G_EXC_ERROR;

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

Line 1251: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1253: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1254: RAISE FND_API.G_EXC_ERROR;

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

Line 1318: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1420: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1420: WHEN FND_API.G_EXC_ERROR THEN
1421:
1422: RAISE;
1423:
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425:
1426:
1427: RAISE;
1428:

Line 1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

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

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

Line 1528: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM

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

Line 1613: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

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

Line 1621: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1624: RAISE FND_API.G_EXC_ERROR;

1620:
1621: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:
1627: END IF;
1628:

Line 1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697:
1698: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: END IF;
1703:
1704: END IF;
1705:

Line 1745: RAISE FND_API.G_EXC_ERROR;

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

Line 1831: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1949: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1949: WHEN FND_API.G_EXC_ERROR THEN
1950:
1951: RAISE;
1952:
1953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1954:
1955:
1956: RAISE;
1957:

Line 1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1965: );
1966: END IF;
1967:
1968:
1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1970:
1971: END Pricing_Attrs;
1972:
1973: -- Start of Comments

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

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

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

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

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

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

Line 2059: IF NOT FND_API.Compatible_API_Call

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

Line 2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2062: , l_api_name
2063: , G_PKG_NAME
2064: )
2065: THEN
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: -- Initialize message list.
2070:

Line 2071: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 2082: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2085: RAISE FND_API.G_EXC_ERROR;

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

Line 2145: ,p_delete => FND_API.G_TRUE

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

Line 2148: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2150: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2151: RAISE FND_API.G_EXC_ERROR;

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

Line 2167: l_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)

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

Line 2206: ,p_delete => FND_API.G_TRUE

2202:
2203: -- FOR QUALIFICATION_IND
2204: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2205: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2206: ,p_delete => FND_API.G_TRUE
2207: ,x_return_status => l_return_status
2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2205: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2206: ,p_delete => FND_API.G_TRUE
2207: ,x_return_status => l_return_status
2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;

Line 2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2206: ,p_delete => FND_API.G_TRUE
2207: ,x_return_status => l_return_status
2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214:

Line 2211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2207: ,x_return_status => l_return_status
2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214:
2215: END IF;

Line 2212: RAISE FND_API.G_EXC_ERROR;

2208: );
2209: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214:
2215: END IF;
2216:

Line 2227: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)

2223: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2224:
2225: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2226: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2227: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2228: THEN
2229:
2230: oe_debug_pub.add('here3');
2231: -- Copy parent_id.

Line 2261: ,p_delete => FND_API.G_TRUE

2257: oe_debug_pub.add('here5');
2258: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2259: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2261: ,p_delete => FND_API.G_TRUE
2262: ,x_return_status => l_return_status
2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2261: ,p_delete => FND_API.G_TRUE
2262: ,x_return_status => l_return_status
2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;

Line 2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2261: ,p_delete => FND_API.G_TRUE
2262: ,x_return_status => l_return_status
2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269:

Line 2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2262: ,x_return_status => l_return_status
2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269:
2270: NULL;

Line 2267: RAISE FND_API.G_EXC_ERROR;

2263: );
2264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: END IF;
2269:
2270: NULL;
2271:

Line 2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)

2279:
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2282: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2284: THEN
2285:
2286: oe_debug_pub.add('here6');
2287: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');

Line 2339: ,p_delete => FND_API.G_TRUE

2335:
2336:
2337: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2338: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2339: ,p_delete => FND_API.G_TRUE
2340: ,x_return_status => l_return_status
2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2338: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2339: ,p_delete => FND_API.G_TRUE
2340: ,x_return_status => l_return_status
2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;

Line 2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2339: ,p_delete => FND_API.G_TRUE
2340: ,x_return_status => l_return_status
2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: -- NULL;

Line 2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2340: ,x_return_status => l_return_status
2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: -- NULL;
2348:

Line 2345: RAISE FND_API.G_EXC_ERROR;

2341: );
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: -- NULL;
2348:
2349: END IF;

Line 2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2359: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2360: (
2361: x_return_status => l_return_status
2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;

Line 2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2360: (
2361: x_return_status => l_return_status
2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*

Line 2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2361: x_return_status => l_return_status
2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*
2369: oe_debug_pub.add('calling process_request');

Line 2366: RAISE FND_API.G_EXC_ERROR;

2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*
2369: oe_debug_pub.add('calling process_request');
2370: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,

Line 2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2371: x_return_status=>l_return_status);
2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:
2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2378: RAISE FND_API.G_EXC_ERROR;
2379: END IF;

Line 2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:
2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2378: RAISE FND_API.G_EXC_ERROR;
2379: END IF;
2380:

Line 2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:
2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2378: RAISE FND_API.G_EXC_ERROR;
2379: END IF;
2380:
2381: */

Line 2378: RAISE FND_API.G_EXC_ERROR;

2374:
2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2378: RAISE FND_API.G_EXC_ERROR;
2379: END IF;
2380:
2381: */
2382: NULL;

Line 2407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2403: (
2404: x_return_status => l_return_status
2405: );
2406:
2407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;

Line 2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2404: x_return_status => l_return_status
2405: );
2406:
2407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: oe_debug_pub.add('After processing delayed request for duplicate modifiers');

Line 2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2405: );
2406:
2407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2413:

Line 2410: RAISE FND_API.G_EXC_ERROR;

2406:
2407: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2413:
2414: END IF;

Line 2459: x_return_status := FND_API.G_RET_STS_SUCCESS;

2455: END IF;
2456:
2457: -- Derive return status.
2458:
2459: x_return_status := FND_API.G_RET_STS_SUCCESS;
2460:
2461: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: END IF;

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

2457: -- Derive return status.
2458:
2459: x_return_status := FND_API.G_RET_STS_SUCCESS;
2460:
2461: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: END IF;
2464:
2465: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP

Line 2462: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 2468: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 2476: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

2479: END LOOP;
2480:
2481: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2482:
2483: IF l_PRICING_ATTR_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2484: x_return_status := FND_API.G_RET_STS_ERROR;
2485: END IF;
2486:
2487: END LOOP;

Line 2484: x_return_status := FND_API.G_RET_STS_ERROR;

2480:
2481: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2482:
2483: IF l_PRICING_ATTR_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2484: x_return_status := FND_API.G_RET_STS_ERROR;
2485: END IF;
2486:
2487: END LOOP;
2488:

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

2498: IF ( p_control_rec.write_to_db --Bug#3309455
2499: AND x_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2500: AND x_MODIFIER_LIST_rec.list_source_code = 'BSO'
2501: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2502: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2503: )
2504: THEN
2505: oe_debug_pub.add('inside create qualifier for blanket modifier');
2506:

Line 2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2526: , p_operation => QP_GLOBALS.G_OPR_CREATE
2527: , x_return_status => l_return_status
2528: );
2529:
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');

Line 2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2528: );
2529:
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2535: RAISE FND_API.G_EXC_ERROR;
2536: END IF;

Line 2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2529:
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2535: RAISE FND_API.G_EXC_ERROR;
2536: END IF;
2537: END IF;

Line 2535: RAISE FND_API.G_EXC_ERROR;

2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2535: RAISE FND_API.G_EXC_ERROR;
2536: END IF;
2537: END IF;
2538:
2539: END IF;

Line 2545: WHEN FND_API.G_EXC_ERROR THEN

2541: oe_debug_pub.add('END process_modifiers in Private');
2542:
2543: EXCEPTION
2544:
2545: WHEN FND_API.G_EXC_ERROR THEN
2546:
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2549: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);

Line 2547: x_return_status := FND_API.G_RET_STS_ERROR;

2543: EXCEPTION
2544:
2545: WHEN FND_API.G_EXC_ERROR THEN
2546:
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2549: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2550: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2551: if p_control_rec.called_from_ui = 'N' then

Line 2563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2559: ( p_count => x_msg_count
2560: , p_data => x_msg_data
2561: );
2562:
2563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2564:
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request

Line 2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2561: );
2562:
2563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2564:
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2568: if p_control_rec.called_from_ui = 'N' then
2569: qp_delayed_requests_pvt.Clear_Request

Line 2581: x_return_status := FND_API.G_RET_STS_SUCCESS;

2577: , p_data => x_msg_data
2578: );
2579:
2580: WHEN NO_UPDATE_PRIVILEGE THEN
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;
2582:
2583: -- Get message count and data
2584:
2585: oe_msg_pub.Count_And_Get

Line 2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2588: );
2589:
2590: WHEN OTHERS THEN
2591:
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593:
2594: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2595: if p_control_rec.called_from_ui = 'N' then
2596: qp_delayed_requests_pvt.Clear_Request

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

2632: -- End of Comments
2633:
2634: PROCEDURE Lock_Modifiers
2635: ( p_api_version_number IN NUMBER
2636: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2637: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2638: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2639: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

2652: )
2653: IS
2654: l_api_version_number CONSTANT NUMBER := 1.0;
2655: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2656: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2657: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2658: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2659: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2660: BEGIN

Line 2665: IF NOT FND_API.Compatible_API_Call

2661:
2662: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2663: -- Standard call to check for call compatibility
2664:
2665: IF NOT FND_API.Compatible_API_Call
2666: ( l_api_version_number
2667: , p_api_version_number
2668: , l_api_name
2669: , G_PKG_NAME

Line 2672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2668: , l_api_name
2669: , G_PKG_NAME
2670: )
2671: THEN
2672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2673: END IF;
2674:
2675: -- Initialize message list.
2676:

Line 2677: IF FND_API.to_Boolean(p_init_msg_list) THEN

2673: END IF;
2674:
2675: -- Initialize message list.
2676:
2677: IF FND_API.to_Boolean(p_init_msg_list) THEN
2678: OE_MSG_PUB.initialize;
2679: END IF;
2680:
2681: -- Set Savepoint

Line 2695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2691: , x_MODIFIER_LIST_rec => x_MODIFIER_LIST_rec
2692: , x_return_status => l_return_status
2693: );
2694:
2695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;

Line 2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2692: , x_return_status => l_return_status
2693: );
2694:
2695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700:

Line 2697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2693: );
2694:
2695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700:
2701:

Line 2698: RAISE FND_API.G_EXC_ERROR;

2694:
2695: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2697: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700:
2701:
2702: END IF;

Line 2716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2712: , x_MODIFIERS_rec => l_MODIFIERS_rec
2713: , x_return_status => l_return_status
2714: );
2715:
2716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;

Line 2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2713: , x_return_status => l_return_status
2714: );
2715:
2716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721:

Line 2718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2714: );
2715:
2716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721:
2722: x_MODIFIERS_tbl(I) := l_MODIFIERS_rec;

Line 2719: RAISE FND_API.G_EXC_ERROR;

2715:
2716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721:
2722: x_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
2723:

Line 2740: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2736: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
2737: , x_return_status => l_return_status
2738: );
2739:
2740: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;

Line 2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2737: , x_return_status => l_return_status
2738: );
2739:
2740: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:

Line 2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2738: );
2739:
2740: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:
2746: x_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;

Line 2743: RAISE FND_API.G_EXC_ERROR;

2739:
2740: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:
2746: x_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
2747:

Line 2764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2760: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec
2761: , x_return_status => l_return_status
2762: );
2763:
2764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;

Line 2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2761: , x_return_status => l_return_status
2762: );
2763:
2764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;
2769:

Line 2766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2762: );
2763:
2764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;
2769:
2770: x_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;

Line 2767: RAISE FND_API.G_EXC_ERROR;

2763:
2764: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2767: RAISE FND_API.G_EXC_ERROR;
2768: END IF;
2769:
2770: x_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
2771:

Line 2778: x_return_status := FND_API.G_RET_STS_SUCCESS;

2774: END LOOP;
2775:
2776: -- Set return status
2777:
2778: x_return_status := FND_API.G_RET_STS_SUCCESS;
2779:
2780: -- Get message count and data
2781:
2782: OE_MSG_PUB.Count_And_Get

Line 2791: WHEN FND_API.G_EXC_ERROR THEN

2787: oe_debug_pub.add('END lock_modifiers in Private');
2788:
2789: EXCEPTION
2790:
2791: WHEN FND_API.G_EXC_ERROR THEN
2792:
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794:
2795: -- Get message count and data

Line 2793: x_return_status := FND_API.G_RET_STS_ERROR;

2789: EXCEPTION
2790:
2791: WHEN FND_API.G_EXC_ERROR THEN
2792:
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794:
2795: -- Get message count and data
2796:
2797: OE_MSG_PUB.Count_And_Get

Line 2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2802: -- Rollback
2803:
2804: ROLLBACK TO Lock_Modifiers_PVT;
2805:
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807:
2808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2809:
2810: -- Get message count and data

Line 2808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2804: ROLLBACK TO Lock_Modifiers_PVT;
2805:
2806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2807:
2808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2809:
2810: -- Get message count and data
2811:
2812: OE_MSG_PUB.Count_And_Get

Line 2823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2819: ROLLBACK TO Lock_Modifiers_PVT;
2820:
2821: WHEN OTHERS THEN
2822:
2823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2826: THEN
2827: OE_MSG_PUB.Add_Exc_Msg

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

2860: -- End of Comments
2861:
2862: PROCEDURE Get_Modifiers
2863: ( p_api_version_number IN NUMBER
2864: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2865: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2866: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2867: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2868: , p_list_header_id IN NUMBER

Line 2887: IF NOT FND_API.Compatible_API_Call

2883:
2884: oe_debug_pub.add('BEGIN get_modifiers in Private');
2885: -- Standard call to check for call compatibility
2886:
2887: IF NOT FND_API.Compatible_API_Call
2888: ( l_api_version_number
2889: , p_api_version_number
2890: , l_api_name
2891: , G_PKG_NAME

Line 2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2890: , l_api_name
2891: , G_PKG_NAME
2892: )
2893: THEN
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: END IF;
2896:
2897: -- Initialize message list.
2898:

Line 2899: IF FND_API.to_Boolean(p_init_msg_list) THEN

2895: END IF;
2896:
2897: -- Initialize message list.
2898:
2899: IF FND_API.to_Boolean(p_init_msg_list) THEN
2900: OE_MSG_PUB.initialize;
2901: END IF;
2902:
2903: -- Get MODIFIER_LIST ( parent = MODIFIER_LIST )

Line 2952: x_return_status := FND_API.G_RET_STS_SUCCESS;

2948: x_PRICING_ATTR_tbl := l_x_PRICING_ATTR_tbl;
2949:
2950: -- Set return status
2951:
2952: x_return_status := FND_API.G_RET_STS_SUCCESS;
2953:
2954: -- Get message count and data
2955:
2956: OE_MSG_PUB.Count_And_Get

Line 2964: WHEN FND_API.G_EXC_ERROR THEN

2960:
2961:
2962: EXCEPTION
2963:
2964: WHEN FND_API.G_EXC_ERROR THEN
2965:
2966: x_return_status := FND_API.G_RET_STS_ERROR;
2967:
2968: -- Get message count and data

Line 2966: x_return_status := FND_API.G_RET_STS_ERROR;

2962: EXCEPTION
2963:
2964: WHEN FND_API.G_EXC_ERROR THEN
2965:
2966: x_return_status := FND_API.G_RET_STS_ERROR;
2967:
2968: -- Get message count and data
2969:
2970: OE_MSG_PUB.Count_And_Get

Line 2975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2971: ( p_count => x_msg_count
2972: , p_data => x_msg_data
2973: );
2974:
2975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2976:
2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2978:
2979: -- Get message count and data

Line 2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2973: );
2974:
2975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2976:
2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2978:
2979: -- Get message count and data
2980:
2981: OE_MSG_PUB.Count_And_Get

Line 2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2984: );
2985:
2986: WHEN OTHERS THEN
2987:
2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2989:
2990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2991: THEN
2992: OE_MSG_PUB.Add_Exc_Msg