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.

[Home] [Help]

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on OE_MSG_PUB

Line 44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

40: oe_debug_pub.add('status is duplicate');
41: --dbms_output.put_line('status is duplicate');
42: x_return_status := FND_API.G_RET_STS_ERROR;
43:
44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
45: THEN
46:
47: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
48: OE_MSG_PUB.Add;

Line 48: OE_MSG_PUB.Add;

44: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
45: THEN
46:
47: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
48: OE_MSG_PUB.Add;
49: END IF;
50: RAISE DUPLICATE_DISCOUNT;
51: END IF;
52:

Line 73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

69: WHEN OTHERS THEN
70:
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME
77: , 'QP_Delayed_Requests_Util'

Line 75: OE_MSG_PUB.Add_Exc_Msg

71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72:
73: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
74: THEN
75: OE_MSG_PUB.Add_Exc_Msg
76: ( G_PKG_NAME
77: , 'QP_Delayed_Requests_Util'
78: );
79: END IF;

Line 124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

120: WHEN OTHERS THEN
121:
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: OE_MSG_PUB.Add_Exc_Msg
127: ( G_PKG_NAME
128: , 'Maintain_List_Header_Phases');

Line 126: OE_MSG_PUB.Add_Exc_Msg

122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: OE_MSG_PUB.Add_Exc_Msg
127: ( G_PKG_NAME
128: , 'Maintain_List_Header_Phases');
129: END IF;
130:

Line 190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'QP_Delayed_Requests_Util');
194: END IF;

Line 191: OE_MSG_PUB.Add_Exc_Msg

187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: WHEN OTHERS THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'QP_Delayed_Requests_Util');
194: END IF;
195: END Update_Qualifier_Status;

Line 228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: OE_MSG_PUB.Add_Exc_Msg
230: ( G_PKG_NAME
231: , 'QP_Delayed_Requests_Util');
232: END IF;

Line 229: OE_MSG_PUB.Add_Exc_Msg

225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
229: OE_MSG_PUB.Add_Exc_Msg
230: ( G_PKG_NAME
231: , 'QP_Delayed_Requests_Util');
232: END IF;
233: END Create_Security_Privilege;

Line 290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: OE_MSG_PUB.Add_Exc_Msg
292: ( G_PKG_NAME
293: , 'QP_Delayed_Requests_Util');
294: END IF;

Line 291: OE_MSG_PUB.Add_Exc_Msg

287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
291: OE_MSG_PUB.Add_Exc_Msg
292: ( G_PKG_NAME
293: , 'QP_Delayed_Requests_Util');
294: END IF;
295: END Update_Attribute_Status;

Line 334: oe_msg_pub.Add;

330:
331: oe_debug_pub.add('Ren: check_duplicate_modifiers status is false ');
332:
333: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_LINES');
334: oe_msg_pub.Add;
335:
336: RAISE FND_API.G_EXC_ERROR;
337:
338: END IF;

Line 359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

355: WHEN OTHERS THEN
356:
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: OE_MSG_PUB.Add_Exc_Msg
362: ( G_PKG_NAME
363: , 'Check_duplicate_Modifier_lines');

Line 361: OE_MSG_PUB.Add_Exc_Msg

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN
361: OE_MSG_PUB.Add_Exc_Msg
362: ( G_PKG_NAME
363: , 'Check_duplicate_Modifier_lines');
364: END IF;
365:

Line 411: oe_msg_pub.Add;

407:
408: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
409:
410: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
411: oe_msg_pub.Add;
412:
413: RAISE FND_API.G_EXC_ERROR;
414:
415: ELSIF l_effdates = FALSE then

Line 437: oe_msg_pub.Add;

433: ELSE
434: FND_MESSAGE.SET_TOKEN('ENDDATE', x_dup_edate);
435: END IF;
436:
437: oe_msg_pub.Add;
438:
439: RAISE FND_API.G_EXC_ERROR;
440:
441: ELSE

Line 446: oe_msg_pub.Add;

442:
443: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
444:
445: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
446: oe_msg_pub.Add;
447:
448: RAISE FND_API.G_EXC_ERROR;
449:
450: END IF;

Line 471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

467: WHEN OTHERS THEN
468:
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'check_duplicate_list_lines');

Line 473: OE_MSG_PUB.Add_Exc_Msg

469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470:
471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: OE_MSG_PUB.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'check_duplicate_list_lines');
476: END IF;
477:

Line 567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

563: oe_debug_pub.add('status is more than 1');
564: --dbms_output.put_line('status is more than 1');
565: x_return_status := FND_API.G_RET_STS_ERROR;
566:
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
568: THEN
569: IF p_list_line_type_code = 'PBH' THEN
570: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
571: --OE_MSG_PUB.Add;

Line 571: --OE_MSG_PUB.Add;

567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
568: THEN
569: IF p_list_line_type_code = 'PBH' THEN
570: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
571: --OE_MSG_PUB.Add;
572: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
573: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
574: --OE_MSG_PUB.Add;
575: END IF;

Line 574: --OE_MSG_PUB.Add;

570: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
571: --OE_MSG_PUB.Add;
572: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
573: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
574: --OE_MSG_PUB.Add;
575: END IF;
576: OE_MSG_PUB.Add;
577: END IF;
578: RAISE NO_CHILD_EXCEPTION;

Line 576: OE_MSG_PUB.Add;

572: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
573: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
574: --OE_MSG_PUB.Add;
575: END IF;
576: OE_MSG_PUB.Add;
577: END IF;
578: RAISE NO_CHILD_EXCEPTION;
579: END IF;
580:

Line 610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

606: WHEN OTHERS THEN
607:
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: ( G_PKG_NAME
614: , 'QP_Delayed_Requests_Util'

Line 612: OE_MSG_PUB.Add_Exc_Msg

608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg
613: ( G_PKG_NAME
614: , 'QP_Delayed_Requests_Util'
615: );
616: END IF;

Line 693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

689: --Raise OVERLAPPING_BREAKS_EXCEPTION;
690:
691: /* x_return_status := FND_API.G_RET_STS_ERROR; */ --Bug No: 7321885
692:
693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695:
696: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
697: OE_MSG_PUB.Add;

Line 697: OE_MSG_PUB.Add;

693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695:
696: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
697: OE_MSG_PUB.Add;
698: END IF;
699: Raise OVERLAPPING_BREAKS_EXCEPTION;
700: END IF;
701:

Line 726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

722:
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN
728: OE_MSG_PUB.Add_Exc_Msg
729: ( G_PKG_NAME
730: , 'QP_Delayed_Requests_Util'

Line 728: OE_MSG_PUB.Add_Exc_Msg

724:
725: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
726: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN
728: OE_MSG_PUB.Add_Exc_Msg
729: ( G_PKG_NAME
730: , 'QP_Delayed_Requests_Util'
731: );
732: END IF;

Line 803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

799:
800: IF l_status IS NOT NULL THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802:
803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
804: THEN
805: IF l_status = 'FROM_NOT_LESS_THAN_TO' THEN
806: fnd_message.set_name('QP', 'QP_INCORRECT_BREAK_VALUES');
807: ELSIF l_status = 'NON_ZERO_FIRST_VALUE' THEN

Line 815: OE_MSG_PUB.Add;

811: ELSIF l_status = 'OVERLAP' THEN
812: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
813: END IF;
814:
815: OE_MSG_PUB.Add;
816: Raise CONTINUOUS_BREAKS_EXCEPTION;
817: END IF;
818: END IF;
819:

Line 843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

839:
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'QP_Delayed_Requests_Util'

Line 845: OE_MSG_PUB.Add_Exc_Msg

841:
842: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
844: THEN
845: OE_MSG_PUB.Add_Exc_Msg
846: ( G_PKG_NAME
847: , 'QP_Delayed_Requests_Util'
848: );
849: END IF;

Line 961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

957:
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: OE_MSG_PUB.Add_Exc_Msg
964: ( G_PKG_NAME
965: , 'QP_Delayed_Requests_Util'

Line 963: OE_MSG_PUB.Add_Exc_Msg

959:
960: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
962: THEN
963: OE_MSG_PUB.Add_Exc_Msg
964: ( G_PKG_NAME
965: , 'QP_Delayed_Requests_Util'
966: );
967: END IF;

Line 998: oe_msg_pub.Add;

994: WHEN e_mult_price_break_attrs THEN
995:
996: oe_debug_pub.add('In relevant exception ');
997: FND_MESSAGE.SET_NAME('QP','QP_MULT_PRICE_BREAK_ATTRS');
998: oe_msg_pub.Add;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001:
1002: WHEN FND_API.G_EXC_ERROR THEN

Line 1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1010: WHEN OTHERS THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: OE_MSG_PUB.Add_Exc_Msg
1017: ( G_PKG_NAME
1018: , 'Check_Mult_Price_Break_Attrs'

Line 1016: OE_MSG_PUB.Add_Exc_Msg

1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013:
1014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: OE_MSG_PUB.Add_Exc_Msg
1017: ( G_PKG_NAME
1018: , 'Check_Mult_Price_Break_Attrs'
1019: );
1020: END IF;

Line 1094: oe_msg_pub.Add;

1090: 'qualifier_rule_id = ' || p_qualifier_rule_id ||
1091: 'and qualifier_grouping_no = ' || l_qualifier_grouping_no);
1092:
1093: FND_MESSAGE.SET_NAME('QP','QP_MIXED_QUAL_SEG_LEVELS');
1094: oe_msg_pub.Add;
1095:
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097:
1098: WHEN FND_API.G_EXC_ERROR THEN

Line 1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1106: WHEN OTHERS THEN
1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112:
1113: OE_MSG_PUB.Add_Exc_Msg
1114: ( G_PKG_NAME

Line 1113: OE_MSG_PUB.Add_Exc_Msg

1109:
1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112:
1113: OE_MSG_PUB.Add_Exc_Msg
1114: ( G_PKG_NAME
1115: , 'Check_Mixed_Qual_Seg_Levels'
1116: );
1117: END IF;

Line 1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1150: --dbms_output.put_line('status is duplicate');
1151:
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1155: THEN
1156:
1157: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
1158: OE_MSG_PUB.Add;

Line 1158: OE_MSG_PUB.Add;

1154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1155: THEN
1156:
1157: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
1158: OE_MSG_PUB.Add;
1159: END IF;
1160: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1161: END IF;
1162:

Line 1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1179: WHEN OTHERS THEN
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182:
1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1184: THEN
1185: OE_MSG_PUB.Add_Exc_Msg
1186: ( G_PKG_NAME
1187: , 'QP_Delayed_Requests_Util'

Line 1185: OE_MSG_PUB.Add_Exc_Msg

1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182:
1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1184: THEN
1185: OE_MSG_PUB.Add_Exc_Msg
1186: ( G_PKG_NAME
1187: , 'QP_Delayed_Requests_Util'
1188: );
1189: END IF;

Line 1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME
1229: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');

Line 1227: OE_MSG_PUB.Add_Exc_Msg

1223:
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME
1229: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');
1230: END IF;
1231:

Line 1236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1232: WHEN OTHERS THEN
1233:
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: OE_MSG_PUB.Add_Exc_Msg
1239: ( G_PKG_NAME
1240: , 'Update_Qualification_Ind');

Line 1238: OE_MSG_PUB.Add_Exc_Msg

1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: THEN
1238: OE_MSG_PUB.Add_Exc_Msg
1239: ( G_PKG_NAME
1240: , 'Update_Qualification_Ind');
1241: END IF;
1242:

Line 1279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: OE_MSG_PUB.Add_Exc_Msg
1282: ( G_PKG_NAME
1283: , 'Maintain_Factor_List_Attrs');

Line 1281: OE_MSG_PUB.Add_Exc_Msg

1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1280: THEN
1281: OE_MSG_PUB.Add_Exc_Msg
1282: ( G_PKG_NAME
1283: , 'Maintain_Factor_List_Attrs');
1284: END IF;
1285:

Line 1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1437: WHEN OTHERS THEN
1438:
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg
1444: ( G_PKG_NAME
1445: , 'Update_Qualification_Ind');

Line 1443: OE_MSG_PUB.Add_Exc_Msg

1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: OE_MSG_PUB.Add_Exc_Msg
1444: ( G_PKG_NAME
1445: , 'Update_Qualification_Ind');
1446: END IF;
1447:

Line 1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1547: EXCEPTION
1548: WHEN Phase_Exception THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME
1554: , 'Update_Pricing_Phase');
1555: END IF;

Line 1552: OE_MSG_PUB.Add_Exc_Msg

1548: WHEN Phase_Exception THEN
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME
1554: , 'Update_Pricing_Phase');
1555: END IF;
1556: WHEN FND_API.G_EXC_ERROR THEN

Line 1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: OE_MSG_PUB.Add_Exc_Msg
1564: ( G_PKG_NAME
1565: , 'Update_Pricing_Phase');
1566: END IF;

Line 1563: OE_MSG_PUB.Add_Exc_Msg

1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: WHEN OTHERS THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: OE_MSG_PUB.Add_Exc_Msg
1564: ( G_PKG_NAME
1565: , 'Update_Pricing_Phase');
1566: END IF;
1567: END Update_Limits_Columns;

Line 1707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1703: WHEN OTHERS THEN
1704:
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706:
1707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: OE_MSG_PUB.Add_Exc_Msg
1710: ( G_PKG_NAME
1711: , 'Update_Qualification_Ind');

Line 1709: OE_MSG_PUB.Add_Exc_Msg

1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706:
1707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: OE_MSG_PUB.Add_Exc_Msg
1710: ( G_PKG_NAME
1711: , 'Update_Qualification_Ind');
1712: END IF;
1713:

Line 1836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1832: WHEN OTHERS THEN
1833:
1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835:
1836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: OE_MSG_PUB.Add_Exc_Msg
1839: ( G_PKG_NAME
1840: , 'Update_Child_Break_Lines');

Line 1838: OE_MSG_PUB.Add_Exc_Msg

1834: x_return_status := FND_API.G_RET_STS_ERROR;
1835:
1836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1837: THEN
1838: OE_MSG_PUB.Add_Exc_Msg
1839: ( G_PKG_NAME
1840: , 'Update_Child_Break_Lines');
1841: END IF;
1842:

Line 1899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1895: EXCEPTION
1896:
1897: WHEN OTHERS THEN
1898:
1899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1900: THEN
1901: OE_MSG_PUB.Add_Exc_Msg
1902: ( G_PKG_NAME
1903: , 'Update_Child_Pricing_Attr'

Line 1901: OE_MSG_PUB.Add_Exc_Msg

1897: WHEN OTHERS THEN
1898:
1899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1900: THEN
1901: OE_MSG_PUB.Add_Exc_Msg
1902: ( G_PKG_NAME
1903: , 'Update_Child_Pricing_Attr'
1904: );
1905: END IF;

Line 1970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1966: WHEN OTHERS THEN
1967:
1968: x_return_status := FND_API.G_RET_STS_ERROR;
1969:
1970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: OE_MSG_PUB.Add_Exc_Msg
1973: ( G_PKG_NAME
1974: , 'Update_Pricing_Attr_Phase');

Line 1972: OE_MSG_PUB.Add_Exc_Msg

1968: x_return_status := FND_API.G_RET_STS_ERROR;
1969:
1970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1971: THEN
1972: OE_MSG_PUB.Add_Exc_Msg
1973: ( G_PKG_NAME
1974: , 'Update_Pricing_Attr_Phase');
1975: END IF;
1976:

Line 2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2049: WHEN Phase_Exception THEN
2050:
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2054: OE_MSG_PUB.Add_Exc_Msg
2055: ( G_PKG_NAME
2056: , 'Update_Pricing_Phase');
2057: END IF;

Line 2054: OE_MSG_PUB.Add_Exc_Msg

2050:
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2054: OE_MSG_PUB.Add_Exc_Msg
2055: ( G_PKG_NAME
2056: , 'Update_Pricing_Phase');
2057: END IF;
2058:

Line 2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2067: WHEN OTHERS THEN
2068:
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070:
2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'Update_Pricing_Phase');
2075: END IF;

Line 2072: OE_MSG_PUB.Add_Exc_Msg

2068:
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070:
2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'Update_Pricing_Phase');
2075: END IF;
2076: END Update_Pricing_Phase;

Line 2140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2136: WHEN OTHERS THEN
2137:
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2141: OE_MSG_PUB.Add_Exc_Msg
2142: ( G_PKG_NAME
2143: , 'Update_Pricing_Phase');
2144: END IF;

Line 2141: OE_MSG_PUB.Add_Exc_Msg

2137:
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2141: OE_MSG_PUB.Add_Exc_Msg
2142: ( G_PKG_NAME
2143: , 'Update_Pricing_Phase');
2144: END IF;
2145: END Update_manual_modifier_flag;

Line 2181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2177: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2178: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2179: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2180:
2181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2182: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2183: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);
2184: OE_MSG_PUB.Add;
2185: END IF;

Line 2184: OE_MSG_PUB.Add;

2180:
2181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2182: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2183: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);
2184: OE_MSG_PUB.Add;
2185: END IF;
2186:
2187: raise FND_API.G_EXC_ERROR;
2188: end if;

Line 2207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2203: WHEN OTHERS THEN
2204:
2205: x_return_status := FND_API.G_RET_STS_ERROR;
2206:
2207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: OE_MSG_PUB.Add_Exc_Msg
2209: ( G_PKG_NAME
2210: , 'Validate_Selling_Rounding');
2211: END IF;

Line 2208: OE_MSG_PUB.Add_Exc_Msg

2204:
2205: x_return_status := FND_API.G_RET_STS_ERROR;
2206:
2207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2208: OE_MSG_PUB.Add_Exc_Msg
2209: ( G_PKG_NAME
2210: , 'Validate_Selling_Rounding');
2211: END IF;
2212: END Validate_Selling_Rounding;

Line 2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2249: l_final_segment_level := 'LINE';
2250: elsif l_current_segment_level = 'BOTH' then
2251: l_final_segment_level := 'LINE_BOTH';
2252: elsif l_current_segment_level = 'ORDER' then
2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2254: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2255: -- qualifier grouping no ?. Please make sure that all the segments should be either
2256: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2257: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2260: OE_MSG_PUB.Add;

2256: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2257: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2258: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2259: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2260: OE_MSG_PUB.Add;
2261: END IF;
2262: raise FND_API.G_EXC_ERROR;
2263: end if;
2264:

Line 2271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2267: l_final_segment_level := 'ORDER';
2268: elsif l_current_segment_level = 'BOTH' then
2269: l_final_segment_level := 'ORDER_BOTH';
2270: elsif l_current_segment_level = 'LINE' then
2271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2272: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2273: -- qualifier grouping no ?. Please make sure that all the segments should be either
2274: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2275: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2278: OE_MSG_PUB.Add;

2274: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2275: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2276: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2277: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2278: OE_MSG_PUB.Add;
2279: END IF;
2280: raise FND_API.G_EXC_ERROR;
2281: end if;
2282:

Line 2296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2292: elsif l_final_segment_level = 'LINE_BOTH' then
2293: if l_current_segment_level in ('LINE', 'BOTH') then
2294: l_final_segment_level := 'LINE_BOTH';
2295: elsif l_current_segment_level = 'ORDER' then
2296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2297: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2298: -- qualifier grouping no ?. Please make sure that all the segments should be either
2299: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2300: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2303: OE_MSG_PUB.Add;

2299: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2300: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2301: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2302: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2303: OE_MSG_PUB.Add;
2304: END IF;
2305: raise FND_API.G_EXC_ERROR;
2306: end if;
2307:

Line 2312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2308: elsif l_final_segment_level = 'ORDER_BOTH' then
2309: if l_current_segment_level in ('ORDER', 'BOTH') then
2310: l_final_segment_level := 'ORDER_BOTH';
2311: elsif l_current_segment_level = 'LINE' then
2312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2313: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2314: -- qualifier grouping no ?. Please make sure that all the segments should be either
2315: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2316: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2319: OE_MSG_PUB.Add;

2315: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2316: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2317: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2318: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2319: OE_MSG_PUB.Add;
2320: END IF;
2321: raise FND_API.G_EXC_ERROR;
2322: end if;
2323:

Line 2343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2339: WHEN OTHERS THEN
2340:
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342:
2343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2344: OE_MSG_PUB.Add_Exc_Msg
2345: ( G_PKG_NAME
2346: , 'Check_Segment_Level_in_Group');
2347: END IF;

Line 2344: OE_MSG_PUB.Add_Exc_Msg

2340:
2341: x_return_status := FND_API.G_RET_STS_ERROR;
2342:
2343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2344: OE_MSG_PUB.Add_Exc_Msg
2345: ( G_PKG_NAME
2346: , 'Check_Segment_Level_in_Group');
2347: END IF;
2348: END Check_Segment_Level_in_Group;

Line 2431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2427: if l_header_qual_exists = 'Y' then
2428: if l_line_modifier_exists = 'Y' and l_qual_exist_for_line_modifier = 'N' then
2429: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2430: will not be applied to an order as no header qualifier exist');
2431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2432: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2433: OE_MSG_PUB.Add;
2434: END IF;
2435: --raise FND_API.G_EXC_ERROR;

Line 2433: OE_MSG_PUB.Add;

2429: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2430: will not be applied to an order as no header qualifier exist');
2431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2432: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2433: OE_MSG_PUB.Add;
2434: END IF;
2435: --raise FND_API.G_EXC_ERROR;
2436: end if;
2437:

Line 2441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2437:
2438: if l_order_modifier_exists = 'Y' and l_qual_exist_for_ord_modifier = 'N' then
2439: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied
2440: to an order as no header qualifier exist');
2441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2442: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_ORD');
2443: OE_MSG_PUB.Add;
2444: END IF;
2445: --raise FND_API.G_EXC_ERROR;

Line 2443: OE_MSG_PUB.Add;

2439: oe_debug_pub.add('mkarya - Modifier Lines of level ''ORDER'' will not be applied
2440: to an order as no header qualifier exist');
2441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2442: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_ORD');
2443: OE_MSG_PUB.Add;
2444: END IF;
2445: --raise FND_API.G_EXC_ERROR;
2446: end if;
2447:

Line 2465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2461: WHEN OTHERS THEN
2462:
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464:
2465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2466: OE_MSG_PUB.Add_Exc_Msg
2467: ( G_PKG_NAME
2468: , 'Check_Line_for_Header_Qual');
2469: END IF;

Line 2466: OE_MSG_PUB.Add_Exc_Msg

2462:
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464:
2465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2466: OE_MSG_PUB.Add_Exc_Msg
2467: ( G_PKG_NAME
2468: , 'Check_Line_for_Header_Qual');
2469: END IF;
2470: END Check_Line_for_Header_Qual;

Line 2828: OE_MSG_PUB.Add_Exc_Msg

2824: END IF;
2825:
2826: EXCEPTION
2827: WHEN procedure_error THEN
2828: OE_MSG_PUB.Add_Exc_Msg
2829: ( G_PKG_NAME
2830: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2831:
2832: WHEN FND_API.G_EXC_ERROR THEN

Line 2834: OE_MSG_PUB.Add_Exc_Msg

2830: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2831:
2832: WHEN FND_API.G_EXC_ERROR THEN
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: OE_MSG_PUB.Add_Exc_Msg
2835: ( G_PKG_NAME
2836: , l_return_status_text);
2837:
2838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2840: OE_MSG_PUB.Add_Exc_Msg

2836: , l_return_status_text);
2837:
2838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2840: OE_MSG_PUB.Add_Exc_Msg
2841: ( G_PKG_NAME
2842: , l_return_status_text);
2843:
2844: WHEN OTHERS THEN

Line 2846: OE_MSG_PUB.Add_Exc_Msg

2842: , l_return_status_text);
2843:
2844: WHEN OTHERS THEN
2845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2846: OE_MSG_PUB.Add_Exc_Msg
2847: ( G_PKG_NAME
2848: , l_return_status_text);
2849: END HVOP_Pricing_Setup;
2850:

Line 2972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

2968:
2969: WHEN NO_DATA_FOUND THEN
2970:
2971: -- If no data was found, we add a warning message to the stack.
2972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2973:
2974: select pte_code, application_short_name
2975: into l_pte_code, l_ss_code
2976: from qp_pte_source_systems

Line 2982: OE_MSG_PUB.Add;

2978:
2979: FND_MESSAGE.set_name('QP', 'QP_NO_FUNC_AREA_WITHIN_PTE');
2980: FND_MESSAGE.set_token('PTE', l_pte_code);
2981: FND_MESSAGE.set_token('SS', l_ss_code);
2982: OE_MSG_PUB.Add;
2983: END IF;
2984:
2985:
2986: -- As this is a WARNING message, we still return success