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_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 116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

112: WHEN OTHERS THEN
113:
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115:
116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
117: THEN
118: OE_MSG_PUB.Add_Exc_Msg
119: ( G_PKG_NAME
120: , 'Maintain_List_Header_Phases');

Line 118: OE_MSG_PUB.Add_Exc_Msg

114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115:
116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
117: THEN
118: OE_MSG_PUB.Add_Exc_Msg
119: ( G_PKG_NAME
120: , 'Maintain_List_Header_Phases');
121: END IF;
122:

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

178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: OE_MSG_PUB.Add_Exc_Msg
184: ( G_PKG_NAME
185: , 'QP_Delayed_Requests_Util');
186: END IF;

Line 183: OE_MSG_PUB.Add_Exc_Msg

179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: OE_MSG_PUB.Add_Exc_Msg
184: ( G_PKG_NAME
185: , 'QP_Delayed_Requests_Util');
186: END IF;
187: END Update_Qualifier_Status;

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

216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: OE_MSG_PUB.Add_Exc_Msg
222: ( G_PKG_NAME
223: , 'QP_Delayed_Requests_Util');
224: END IF;

Line 221: OE_MSG_PUB.Add_Exc_Msg

217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: OE_MSG_PUB.Add_Exc_Msg
222: ( G_PKG_NAME
223: , 'QP_Delayed_Requests_Util');
224: END IF;
225: END Create_Security_Privilege;

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

278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
283: OE_MSG_PUB.Add_Exc_Msg
284: ( G_PKG_NAME
285: , 'QP_Delayed_Requests_Util');
286: END IF;

Line 283: OE_MSG_PUB.Add_Exc_Msg

279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
283: OE_MSG_PUB.Add_Exc_Msg
284: ( G_PKG_NAME
285: , 'QP_Delayed_Requests_Util');
286: END IF;
287: END Update_Attribute_Status;

Line 326: oe_msg_pub.Add;

322:
323: oe_debug_pub.add('Ren: check_duplicate_modifiers status is false ');
324:
325: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_LINES');
326: oe_msg_pub.Add;
327:
328: RAISE FND_API.G_EXC_ERROR;
329:
330: END IF;

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

347: WHEN OTHERS THEN
348:
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350:
351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: OE_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'Check_duplicate_Modifier_lines');

Line 353: OE_MSG_PUB.Add_Exc_Msg

349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350:
351: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: OE_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'Check_duplicate_Modifier_lines');
356: END IF;
357:

Line 403: oe_msg_pub.Add;

399:
400: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
401:
402: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
403: oe_msg_pub.Add;
404:
405: RAISE FND_API.G_EXC_ERROR;
406:
407: ELSIF l_effdates = FALSE then

Line 429: oe_msg_pub.Add;

425: ELSE
426: FND_MESSAGE.SET_TOKEN('ENDDATE', x_dup_edate);
427: END IF;
428:
429: oe_msg_pub.Add;
430:
431: RAISE FND_API.G_EXC_ERROR;
432:
433: ELSE

Line 438: oe_msg_pub.Add;

434:
435: oe_debug_pub.add('Ren: check_duplicate_lines status is false ');
436:
437: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_LIST_LINES');
438: oe_msg_pub.Add;
439:
440: RAISE FND_API.G_EXC_ERROR;
441:
442: END IF;

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

459: WHEN OTHERS THEN
460:
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462:
463: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: OE_MSG_PUB.Add_Exc_Msg
466: ( G_PKG_NAME
467: , 'check_duplicate_list_lines');

Line 465: OE_MSG_PUB.Add_Exc_Msg

461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462:
463: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
464: THEN
465: OE_MSG_PUB.Add_Exc_Msg
466: ( G_PKG_NAME
467: , 'check_duplicate_list_lines');
468: END IF;
469:

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

555: oe_debug_pub.add('status is more than 1');
556: --dbms_output.put_line('status is more than 1');
557: x_return_status := FND_API.G_RET_STS_ERROR;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
560: THEN
561: IF p_list_line_type_code = 'PBH' THEN
562: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
563: --OE_MSG_PUB.Add;

Line 563: --OE_MSG_PUB.Add;

559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
560: THEN
561: IF p_list_line_type_code = 'PBH' THEN
562: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
563: --OE_MSG_PUB.Add;
564: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
565: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
566: --OE_MSG_PUB.Add;
567: END IF;

Line 566: --OE_MSG_PUB.Add;

562: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_PBH');
563: --OE_MSG_PUB.Add;
564: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
565: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
566: --OE_MSG_PUB.Add;
567: END IF;
568: OE_MSG_PUB.Add;
569: END IF;
570: RAISE NO_CHILD_EXCEPTION;

Line 568: OE_MSG_PUB.Add;

564: ELSIF p_list_line_type_code IN ('OID' ,'PRG') THEN
565: fnd_message.set_name('QP', 'QP_NO_CHILD_FOR_OID_PRG');
566: --OE_MSG_PUB.Add;
567: END IF;
568: OE_MSG_PUB.Add;
569: END IF;
570: RAISE NO_CHILD_EXCEPTION;
571: END IF;
572:

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

598: WHEN OTHERS THEN
599:
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: OE_MSG_PUB.Add_Exc_Msg
605: ( G_PKG_NAME
606: , 'QP_Delayed_Requests_Util'

Line 604: OE_MSG_PUB.Add_Exc_Msg

600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
603: THEN
604: OE_MSG_PUB.Add_Exc_Msg
605: ( G_PKG_NAME
606: , 'QP_Delayed_Requests_Util'
607: );
608: END IF;

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

681: --Raise OVERLAPPING_BREAKS_EXCEPTION;
682:
683: /* x_return_status := FND_API.G_RET_STS_ERROR; */ --Bug No: 7321885
684:
685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
686: THEN
687:
688: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
689: OE_MSG_PUB.Add;

Line 689: OE_MSG_PUB.Add;

685: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
686: THEN
687:
688: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
689: OE_MSG_PUB.Add;
690: END IF;
691: Raise OVERLAPPING_BREAKS_EXCEPTION;
692: END IF;
693:

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

714:
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716:
717: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: OE_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME
722: , 'QP_Delayed_Requests_Util'

Line 720: OE_MSG_PUB.Add_Exc_Msg

716:
717: oe_debug_pub.add('overlapping breaks error '||substr(sqlerrm,1,100));
718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: OE_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME
722: , 'QP_Delayed_Requests_Util'
723: );
724: END IF;

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

791:
792: IF l_status IS NOT NULL THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794:
795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
796: THEN
797: IF l_status = 'FROM_NOT_LESS_THAN_TO' THEN
798: fnd_message.set_name('QP', 'QP_INCORRECT_BREAK_VALUES');
799: ELSIF l_status = 'NON_ZERO_FIRST_VALUE' THEN

Line 807: OE_MSG_PUB.Add;

803: ELSIF l_status = 'OVERLAP' THEN
804: fnd_message.set_name('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
805: END IF;
806:
807: OE_MSG_PUB.Add;
808: Raise CONTINUOUS_BREAKS_EXCEPTION;
809: END IF;
810: END IF;
811:

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

831:
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833:
834: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'QP_Delayed_Requests_Util'

Line 837: OE_MSG_PUB.Add_Exc_Msg

833:
834: oe_debug_pub.add('continuous breaks error '||substr(sqlerrm,1,100));
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'QP_Delayed_Requests_Util'
840: );
841: END IF;

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

949:
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951:
952: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
954: THEN
955: OE_MSG_PUB.Add_Exc_Msg
956: ( G_PKG_NAME
957: , 'QP_Delayed_Requests_Util'

Line 955: OE_MSG_PUB.Add_Exc_Msg

951:
952: oe_debug_pub.add('upgrade breaks error '||substr(sqlerrm,1,100));
953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
954: THEN
955: OE_MSG_PUB.Add_Exc_Msg
956: ( G_PKG_NAME
957: , 'QP_Delayed_Requests_Util'
958: );
959: END IF;

Line 990: oe_msg_pub.Add;

986: WHEN e_mult_price_break_attrs THEN
987:
988: oe_debug_pub.add('In relevant exception ');
989: FND_MESSAGE.SET_NAME('QP','QP_MULT_PRICE_BREAK_ATTRS');
990: oe_msg_pub.Add;
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993:
994: WHEN FND_API.G_EXC_ERROR THEN

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

1002: WHEN OTHERS THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005:
1006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: OE_MSG_PUB.Add_Exc_Msg
1009: ( G_PKG_NAME
1010: , 'Check_Mult_Price_Break_Attrs'

Line 1008: OE_MSG_PUB.Add_Exc_Msg

1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005:
1006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: OE_MSG_PUB.Add_Exc_Msg
1009: ( G_PKG_NAME
1010: , 'Check_Mult_Price_Break_Attrs'
1011: );
1012: END IF;

Line 1086: oe_msg_pub.Add;

1082: 'qualifier_rule_id = ' || p_qualifier_rule_id ||
1083: 'and qualifier_grouping_no = ' || l_qualifier_grouping_no);
1084:
1085: FND_MESSAGE.SET_NAME('QP','QP_MIXED_QUAL_SEG_LEVELS');
1086: oe_msg_pub.Add;
1087:
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089:
1090: WHEN FND_API.G_EXC_ERROR THEN

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

1098: WHEN OTHERS THEN
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101:
1102: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104:
1105: OE_MSG_PUB.Add_Exc_Msg
1106: ( G_PKG_NAME

Line 1105: OE_MSG_PUB.Add_Exc_Msg

1101:
1102: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104:
1105: OE_MSG_PUB.Add_Exc_Msg
1106: ( G_PKG_NAME
1107: , 'Check_Mixed_Qual_Seg_Levels'
1108: );
1109: END IF;

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

1142: --dbms_output.put_line('status is duplicate');
1143:
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145:
1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1147: THEN
1148:
1149: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
1150: OE_MSG_PUB.Add;

Line 1150: OE_MSG_PUB.Add;

1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1147: THEN
1148:
1149: fnd_message.set_name('ONT', 'OE_DIS_DUPLICATE_LIN_DISC');
1150: OE_MSG_PUB.Add;
1151: END IF;
1152: RAISE MULTIPLE_PRICE_LIST_EXCEPTION;
1153: END IF;
1154:

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

1171: WHEN OTHERS THEN
1172:
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174:
1175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: OE_MSG_PUB.Add_Exc_Msg
1178: ( G_PKG_NAME
1179: , 'QP_Delayed_Requests_Util'

Line 1177: OE_MSG_PUB.Add_Exc_Msg

1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174:
1175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1176: THEN
1177: OE_MSG_PUB.Add_Exc_Msg
1178: ( G_PKG_NAME
1179: , 'QP_Delayed_Requests_Util'
1180: );
1181: END IF;

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

1213:
1214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1215:
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME
1221: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');

Line 1219: OE_MSG_PUB.Add_Exc_Msg

1215:
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME
1221: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');
1222: END IF;
1223:

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

1224: WHEN OTHERS THEN
1225:
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227:
1228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1229: THEN
1230: OE_MSG_PUB.Add_Exc_Msg
1231: ( G_PKG_NAME
1232: , 'Update_Qualification_Ind');

Line 1230: OE_MSG_PUB.Add_Exc_Msg

1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227:
1228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1229: THEN
1230: OE_MSG_PUB.Add_Exc_Msg
1231: ( G_PKG_NAME
1232: , 'Update_Qualification_Ind');
1233: END IF;
1234:

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

1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Maintain_Factor_List_Attrs');

Line 1273: OE_MSG_PUB.Add_Exc_Msg

1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Maintain_Factor_List_Attrs');
1276: END IF;
1277:

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

1429: WHEN OTHERS THEN
1430:
1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: OE_MSG_PUB.Add_Exc_Msg
1436: ( G_PKG_NAME
1437: , 'Update_Qualification_Ind');

Line 1435: OE_MSG_PUB.Add_Exc_Msg

1431: x_return_status := FND_API.G_RET_STS_ERROR;
1432:
1433: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: OE_MSG_PUB.Add_Exc_Msg
1436: ( G_PKG_NAME
1437: , 'Update_Qualification_Ind');
1438: END IF;
1439:

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

1539: EXCEPTION
1540: WHEN Phase_Exception THEN
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542:
1543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1544: OE_MSG_PUB.Add_Exc_Msg
1545: ( G_PKG_NAME
1546: , 'Update_Pricing_Phase');
1547: END IF;

Line 1544: OE_MSG_PUB.Add_Exc_Msg

1540: WHEN Phase_Exception THEN
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542:
1543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1544: OE_MSG_PUB.Add_Exc_Msg
1545: ( G_PKG_NAME
1546: , 'Update_Pricing_Phase');
1547: END IF;
1548: WHEN FND_API.G_EXC_ERROR THEN

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

1550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: WHEN OTHERS THEN
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1555: OE_MSG_PUB.Add_Exc_Msg
1556: ( G_PKG_NAME
1557: , 'Update_Pricing_Phase');
1558: END IF;

Line 1555: OE_MSG_PUB.Add_Exc_Msg

1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: WHEN OTHERS THEN
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1555: OE_MSG_PUB.Add_Exc_Msg
1556: ( G_PKG_NAME
1557: , 'Update_Pricing_Phase');
1558: END IF;
1559: END Update_Limits_Columns;

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

1695: WHEN OTHERS THEN
1696:
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1700: THEN
1701: OE_MSG_PUB.Add_Exc_Msg
1702: ( G_PKG_NAME
1703: , 'Update_Qualification_Ind');

Line 1701: OE_MSG_PUB.Add_Exc_Msg

1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1700: THEN
1701: OE_MSG_PUB.Add_Exc_Msg
1702: ( G_PKG_NAME
1703: , 'Update_Qualification_Ind');
1704: END IF;
1705:

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

1824: WHEN OTHERS THEN
1825:
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1829: THEN
1830: OE_MSG_PUB.Add_Exc_Msg
1831: ( G_PKG_NAME
1832: , 'Update_Child_Break_Lines');

Line 1830: OE_MSG_PUB.Add_Exc_Msg

1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1829: THEN
1830: OE_MSG_PUB.Add_Exc_Msg
1831: ( G_PKG_NAME
1832: , 'Update_Child_Break_Lines');
1833: END IF;
1834:

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

1887: EXCEPTION
1888:
1889: WHEN OTHERS THEN
1890:
1891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1892: THEN
1893: OE_MSG_PUB.Add_Exc_Msg
1894: ( G_PKG_NAME
1895: , 'Update_Child_Pricing_Attr'

Line 1893: OE_MSG_PUB.Add_Exc_Msg

1889: WHEN OTHERS THEN
1890:
1891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1892: THEN
1893: OE_MSG_PUB.Add_Exc_Msg
1894: ( G_PKG_NAME
1895: , 'Update_Child_Pricing_Attr'
1896: );
1897: END IF;

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

1958: WHEN OTHERS THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1963: THEN
1964: OE_MSG_PUB.Add_Exc_Msg
1965: ( G_PKG_NAME
1966: , 'Update_Pricing_Attr_Phase');

Line 1964: OE_MSG_PUB.Add_Exc_Msg

1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1963: THEN
1964: OE_MSG_PUB.Add_Exc_Msg
1965: ( G_PKG_NAME
1966: , 'Update_Pricing_Attr_Phase');
1967: END IF;
1968:

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

2041: WHEN Phase_Exception THEN
2042:
2043: x_return_status := FND_API.G_RET_STS_ERROR;
2044:
2045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2046: OE_MSG_PUB.Add_Exc_Msg
2047: ( G_PKG_NAME
2048: , 'Update_Pricing_Phase');
2049: END IF;

Line 2046: OE_MSG_PUB.Add_Exc_Msg

2042:
2043: x_return_status := FND_API.G_RET_STS_ERROR;
2044:
2045: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2046: OE_MSG_PUB.Add_Exc_Msg
2047: ( G_PKG_NAME
2048: , 'Update_Pricing_Phase');
2049: END IF;
2050:

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

2059: WHEN OTHERS THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2064: OE_MSG_PUB.Add_Exc_Msg
2065: ( G_PKG_NAME
2066: , 'Update_Pricing_Phase');
2067: END IF;

Line 2064: OE_MSG_PUB.Add_Exc_Msg

2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2064: OE_MSG_PUB.Add_Exc_Msg
2065: ( G_PKG_NAME
2066: , 'Update_Pricing_Phase');
2067: END IF;
2068: END Update_Pricing_Phase;

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

2125: WHEN OTHERS THEN
2126:
2127: x_return_status := FND_API.G_RET_STS_ERROR;
2128:
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2130: OE_MSG_PUB.Add_Exc_Msg
2131: ( G_PKG_NAME
2132: , 'Update_Pricing_Phase');
2133: END IF;

Line 2130: OE_MSG_PUB.Add_Exc_Msg

2126:
2127: x_return_status := FND_API.G_RET_STS_ERROR;
2128:
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2130: OE_MSG_PUB.Add_Exc_Msg
2131: ( G_PKG_NAME
2132: , 'Update_Pricing_Phase');
2133: END IF;
2134: END Update_manual_modifier_flag;

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

2166: oe_debug_pub.add('l_first_selling_rounding = '||l_first_selling_rounding);
2167: if selling_rounding_rec.selling_rounding_factor <> l_first_selling_rounding then
2168: oe_debug_pub.add('selling_rounding_factor NOT EQUAL ');
2169:
2170: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2171: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2172: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);
2173: OE_MSG_PUB.Add;
2174: END IF;

Line 2173: OE_MSG_PUB.Add;

2169:
2170: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2171: fnd_message.set_name('QP', 'QP_SELLING_ROUNDING_NOT_SAME');
2172: fnd_message.set_token('CURRENCY_CODE', p_to_currency_code);
2173: OE_MSG_PUB.Add;
2174: END IF;
2175:
2176: raise FND_API.G_EXC_ERROR;
2177: end if;

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

2192: WHEN OTHERS THEN
2193:
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195:
2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2197: OE_MSG_PUB.Add_Exc_Msg
2198: ( G_PKG_NAME
2199: , 'Validate_Selling_Rounding');
2200: END IF;

Line 2197: OE_MSG_PUB.Add_Exc_Msg

2193:
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195:
2196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2197: OE_MSG_PUB.Add_Exc_Msg
2198: ( G_PKG_NAME
2199: , 'Validate_Selling_Rounding');
2200: END IF;
2201: END Validate_Selling_Rounding;

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

2238: l_final_segment_level := 'LINE';
2239: elsif l_current_segment_level = 'BOTH' then
2240: l_final_segment_level := 'LINE_BOTH';
2241: elsif l_current_segment_level = 'ORDER' then
2242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2243: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2244: -- qualifier grouping no ?. Please make sure that all the segments should be either
2245: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2246: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2249: OE_MSG_PUB.Add;

2245: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2246: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2247: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2248: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2249: OE_MSG_PUB.Add;
2250: END IF;
2251: raise FND_API.G_EXC_ERROR;
2252: end if;
2253:

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

2256: l_final_segment_level := 'ORDER';
2257: elsif l_current_segment_level = 'BOTH' then
2258: l_final_segment_level := 'ORDER_BOTH';
2259: elsif l_current_segment_level = 'LINE' then
2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2261: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2262: -- qualifier grouping no ?. Please make sure that all the segments should be either
2263: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2264: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2267: OE_MSG_PUB.Add;

2263: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2264: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2265: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2266: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2267: OE_MSG_PUB.Add;
2268: END IF;
2269: raise FND_API.G_EXC_ERROR;
2270: end if;
2271:

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

2281: elsif l_final_segment_level = 'LINE_BOTH' then
2282: if l_current_segment_level in ('LINE', 'BOTH') then
2283: l_final_segment_level := 'LINE_BOTH';
2284: elsif l_current_segment_level = 'ORDER' then
2285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2286: -- There is a mix of 'LINE' and 'ORDER' segment level for list line id ? and
2287: -- qualifier grouping no ?. Please make sure that all the segments should be either
2288: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2289: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');

Line 2292: OE_MSG_PUB.Add;

2288: -- of level LINE/BOTH or ORDER/BOTH for a given list line id and qualifier grouping no
2289: fnd_message.set_name('QP', 'QP_MIXED_SEGMENT_LEVELS');
2290: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
2291: fnd_message.set_token('QUALIFIER_GRP_NO', p_qualifier_grouping_no);
2292: OE_MSG_PUB.Add;
2293: END IF;
2294: raise FND_API.G_EXC_ERROR;
2295: end if;
2296:

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

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

Line 2308: OE_MSG_PUB.Add;

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

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

2328: WHEN OTHERS THEN
2329:
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331:
2332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2333: OE_MSG_PUB.Add_Exc_Msg
2334: ( G_PKG_NAME
2335: , 'Check_Segment_Level_in_Group');
2336: END IF;

Line 2333: OE_MSG_PUB.Add_Exc_Msg

2329:
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331:
2332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2333: OE_MSG_PUB.Add_Exc_Msg
2334: ( G_PKG_NAME
2335: , 'Check_Segment_Level_in_Group');
2336: END IF;
2337: END Check_Segment_Level_in_Group;

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

2416: if l_header_qual_exists = 'Y' then
2417: if l_line_modifier_exists = 'Y' and l_qual_exist_for_line_modifier = 'N' then
2418: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2419: will not be applied to an order as no header qualifier exist');
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2421: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2422: OE_MSG_PUB.Add;
2423: END IF;
2424: --raise FND_API.G_EXC_ERROR;

Line 2422: OE_MSG_PUB.Add;

2418: oe_debug_pub.add('mkarya - Modifier Lines of level ''LINE'' or ''LINEGROUP''
2419: will not be applied to an order as no header qualifier exist');
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2421: fnd_message.set_name('QP', 'QP_NO_HEADER_QUAL_FOR_LINE');
2422: OE_MSG_PUB.Add;
2423: END IF;
2424: --raise FND_API.G_EXC_ERROR;
2425: end if;
2426:

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

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

Line 2432: OE_MSG_PUB.Add;

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

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

2450: WHEN OTHERS THEN
2451:
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453:
2454: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2455: OE_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Check_Line_for_Header_Qual');
2458: END IF;

Line 2455: OE_MSG_PUB.Add_Exc_Msg

2451:
2452: x_return_status := FND_API.G_RET_STS_ERROR;
2453:
2454: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2455: OE_MSG_PUB.Add_Exc_Msg
2456: ( G_PKG_NAME
2457: , 'Check_Line_for_Header_Qual');
2458: END IF;
2459: END Check_Line_for_Header_Qual;

Line 2817: OE_MSG_PUB.Add_Exc_Msg

2813: END IF;
2814:
2815: EXCEPTION
2816: WHEN procedure_error THEN
2817: OE_MSG_PUB.Add_Exc_Msg
2818: ( G_PKG_NAME
2819: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2820:
2821: WHEN FND_API.G_EXC_ERROR THEN

Line 2823: OE_MSG_PUB.Add_Exc_Msg

2819: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2820:
2821: WHEN FND_API.G_EXC_ERROR THEN
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: OE_MSG_PUB.Add_Exc_Msg
2824: ( G_PKG_NAME
2825: , l_return_status_text);
2826:
2827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2829: OE_MSG_PUB.Add_Exc_Msg

2825: , l_return_status_text);
2826:
2827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: OE_MSG_PUB.Add_Exc_Msg
2830: ( G_PKG_NAME
2831: , l_return_status_text);
2832:
2833: WHEN OTHERS THEN

Line 2835: OE_MSG_PUB.Add_Exc_Msg

2831: , l_return_status_text);
2832:
2833: WHEN OTHERS THEN
2834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2835: OE_MSG_PUB.Add_Exc_Msg
2836: ( G_PKG_NAME
2837: , l_return_status_text);
2838: END HVOP_Pricing_Setup;
2839:

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

2933:
2934: WHEN NO_DATA_FOUND THEN
2935:
2936: -- If no data was found, we add a warning message to the stack.
2937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2938:
2939: select pte_code, application_short_name
2940: into l_pte_code, l_ss_code
2941: from qp_pte_source_systems

Line 2947: OE_MSG_PUB.Add;

2943:
2944: FND_MESSAGE.set_name('QP', 'QP_NO_FUNC_AREA_WITHIN_PTE');
2945: FND_MESSAGE.set_token('PTE', l_pte_code);
2946: FND_MESSAGE.set_token('SS', l_ss_code);
2947: OE_MSG_PUB.Add;
2948: END IF;
2949:
2950:
2951: -- As this is a WARNING message, we still return success