DBA Data[Home] [Help]

APPS.QP_LIST_HEADERS_PVT dependencies on OE_MSG_PUB

Line 119: OE_MSG_PUB.Add;

115: l_return_status := FND_API.G_RET_STS_ERROR;
116: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
117: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
118: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
119: OE_MSG_PUB.Add;
120:
121: RAISE FND_API.G_EXC_ERROR;
122:
123: END IF;

Line 232: OE_MSG_PUB.Add;

228:
229: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
230:
231: FND_MESSAGE.SET_NAME('QP', 'QP_CANNOT_DELETE_PRICE_LIST');
232: OE_MSG_PUB.Add;
233:
234: RAISE FND_API.G_EXC_ERROR;
235:
236: /*QP_Price_List_Util.Delete_Row

Line 310: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

306: RAISE;
307:
308: WHEN OTHERS THEN
309:
310: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
311: THEN
312: oe_msg_pub.Add_Exc_Msg
313: ( G_PKG_NAME
314: , 'Price_List'

Line 312: oe_msg_pub.Add_Exc_Msg

308: WHEN OTHERS THEN
309:
310: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
311: THEN
312: oe_msg_pub.Add_Exc_Msg
313: ( G_PKG_NAME
314: , 'Price_List'
315: );
316: END IF;

Line 456: OE_MSG_PUB.Add;

452: l_return_status := FND_API.G_RET_STS_ERROR;
453: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
454: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
455: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
456: OE_MSG_PUB.Add;
457:
458: RAISE FND_API.G_EXC_ERROR;
459:
460: END IF;

Line 539: OE_MSG_PUB.Add;

535: l_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
537: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
538: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
539: OE_MSG_PUB.Add;
540:
541: RAISE FND_API.G_EXC_ERROR;
542:
543: END IF;

Line 753: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

749: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
751: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
752:
753: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: oe_msg_pub.Add_Exc_Msg
756: ( G_PKG_NAME
757: , 'Price_List_Lines'

Line 755: oe_msg_pub.Add_Exc_Msg

751: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
752:
753: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: oe_msg_pub.Add_Exc_Msg
756: ( G_PKG_NAME
757: , 'Price_List_Lines'
758: );
759: END IF;

Line 798: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

794: RAISE;
795:
796: WHEN OTHERS THEN
797:
798: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
799: THEN
800: oe_msg_pub.Add_Exc_Msg
801: ( G_PKG_NAME
802: , 'Price_List_Lines'

Line 800: oe_msg_pub.Add_Exc_Msg

796: WHEN OTHERS THEN
797:
798: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
799: THEN
800: oe_msg_pub.Add_Exc_Msg
801: ( G_PKG_NAME
802: , 'Price_List_Lines'
803: );
804: END IF;

Line 939: OE_MSG_PUB.Add;

935: l_return_status := FND_API.G_RET_STS_ERROR;
936: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
937: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
938: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
939: OE_MSG_PUB.Add;
940:
941: RAISE FND_API.G_EXC_ERROR;
942:
943: END IF;

Line 1025: OE_MSG_PUB.Add;

1021: l_return_status := FND_API.G_RET_STS_ERROR;
1022: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
1023: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
1024: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
1025: OE_MSG_PUB.Add;
1026:
1027: RAISE FND_API.G_EXC_ERROR;
1028:
1029: END IF;

Line 1117: oe_msg_pub.add;

1113: and l_QUALIFIERS_rec.QUALIFIER_ATTRIBUTE =
1114: 'QUALIFIER_ATTRIBUTE4') then
1115:
1116: fnd_message.set_name('QP', 'QP_BASIC_MOD_MULT_PLIST');
1117: oe_msg_pub.add;
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119:
1120: else null;
1121: end if;

Line 1140: oe_msg_pub.add;

1136: l_qualifiers_rec.qualifier_attr_value;
1137:
1138: IF v_count > 0 THEN
1139: fnd_message.set_name('QP', 'QP_SEC_PRL_COUNT');
1140: oe_msg_pub.add;
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;
1143: end if; -- l_qualifiers_rec.operation
1144: /* 1606695 */

Line 1177: OE_MSG_PUB.ADD;

1173: --fix for bug 1501138 not allow deletion of coupon qualifiers
1174:
1175: oe_debug_pub.add('1501138 not allow delete qual');
1176: FND_MESSAGE.SET_NAME('QP', 'QP_CANNOT_DELETE_THIS_QUAL');
1177: OE_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSE
1180:
1181: QP_Qualifiers_Util.Delete_Row

Line 1281: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1277: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1279: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1280:
1281: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1282: THEN
1283: oe_msg_pub.Add_Exc_Msg
1284: ( G_PKG_NAME
1285: , 'Qualifierss'

Line 1283: oe_msg_pub.Add_Exc_Msg

1279: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1280:
1281: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1282: THEN
1283: oe_msg_pub.Add_Exc_Msg
1284: ( G_PKG_NAME
1285: , 'Qualifierss'
1286: );
1287: END IF;

Line 1331: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1327: RAISE;
1328:
1329: WHEN OTHERS THEN
1330:
1331: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1332: THEN
1333: oe_msg_pub.Add_Exc_Msg
1334: ( G_PKG_NAME
1335: , 'Qualifierss'

Line 1333: oe_msg_pub.Add_Exc_Msg

1329: WHEN OTHERS THEN
1330:
1331: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1332: THEN
1333: oe_msg_pub.Add_Exc_Msg
1334: ( G_PKG_NAME
1335: , 'Qualifierss'
1336: );
1337: END IF;

Line 1506: OE_MSG_PUB.Add;

1502: l_return_status := FND_API.G_RET_STS_ERROR;
1503: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
1504: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
1505: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
1506: OE_MSG_PUB.Add;
1507:
1508: RAISE FND_API.G_EXC_ERROR;
1509:
1510: END IF;

Line 1596: OE_MSG_PUB.Add;

1592: l_return_status := FND_API.G_RET_STS_ERROR;
1593: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
1594: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
1595: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
1596: OE_MSG_PUB.Add;
1597:
1598: RAISE FND_API.G_EXC_ERROR;
1599:
1600: END IF;

Line 1756: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1752: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1754: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1755:
1756: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1757: THEN
1758: oe_msg_pub.Add_Exc_Msg
1759: ( G_PKG_NAME
1760: , 'Pricing_Attrs'

Line 1758: oe_msg_pub.Add_Exc_Msg

1754: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1755:
1756: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1757: THEN
1758: oe_msg_pub.Add_Exc_Msg
1759: ( G_PKG_NAME
1760: , 'Pricing_Attrs'
1761: );
1762: END IF;

Line 1803: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1799: RAISE;
1800:
1801: WHEN OTHERS THEN
1802:
1803: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1804: THEN
1805: oe_msg_pub.Add_Exc_Msg
1806: ( G_PKG_NAME
1807: , 'Pricing_Attrs'

Line 1805: oe_msg_pub.Add_Exc_Msg

1801: WHEN OTHERS THEN
1802:
1803: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1804: THEN
1805: oe_msg_pub.Add_Exc_Msg
1806: ( G_PKG_NAME
1807: , 'Pricing_Attrs'
1808: );
1809: END IF;

Line 1917: oe_msg_pub.initialize;

1913: oe_debug_Pub.add('process_Price_list 1');
1914: -- Initialize message list.
1915:
1916: IF FND_API.to_Boolean(p_init_msg_list) THEN
1917: oe_msg_pub.initialize;
1918: END IF;
1919:
1920: /* check for installation status ; if it's basic then this api
1921: is not available */

Line 1929: OE_MSG_PUB.Add;

1925: IF l_installed_status = 'N' THEN
1926:
1927: l_return_status := FND_API.G_RET_STS_ERROR;
1928: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
1929: OE_MSG_PUB.Add;
1930: RAISE FND_API.G_EXC_ERROR;
1931:
1932: END IF;
1933:

Line 2110: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2106:
2107: ELSE
2108: oe_debug_pub.add('process_Price_List 16');
2109:
2110: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2111: THEN
2112: oe_debug_pub.add('process_Price_List 17');
2113:
2114: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');

Line 2122: oe_msg_pub.Add;

2118: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
2119: oe_debug_pub.add('process_Price_List 20');
2120: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_PRICING_ATTR_rec.PRICE_LIST_LINE_index);
2121: oe_debug_pub.add('process_Price_List 21');
2122: oe_msg_pub.Add;
2123:
2124:
2125: END IF;
2126: END IF;

Line 2238: oe_msg_pub.Count_And_Get

2234:
2235: -- Get message count and data
2236: oe_debug_Pub.add('process_Price_list 11');
2237:
2238: oe_msg_pub.Count_And_Get
2239: ( p_count => x_msg_count
2240: , p_data => x_msg_data
2241: );
2242:

Line 2305: oe_msg_pub.Count_And_Get

2301: end if;
2302:
2303: -- Get message count and data
2304:
2305: oe_msg_pub.Count_And_Get
2306: ( p_count => x_msg_count
2307: , p_data => x_msg_data
2308: );
2309:

Line 2322: oe_msg_pub.Count_And_Get

2318: end if;
2319:
2320: -- Get message count and data
2321:
2322: oe_msg_pub.Count_And_Get
2323: ( p_count => x_msg_count
2324: , p_data => x_msg_data
2325: );
2326:

Line 2338: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2334: qp_delayed_requests_pvt.Clear_Request
2335: (x_return_status => l_return_status);
2336: end if;
2337:
2338: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2339: THEN
2340: oe_msg_pub.Add_Exc_Msg
2341: ( G_PKG_NAME
2342: , 'Process_Price_List'

Line 2340: oe_msg_pub.Add_Exc_Msg

2336: end if;
2337:
2338: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2339: THEN
2340: oe_msg_pub.Add_Exc_Msg
2341: ( G_PKG_NAME
2342: , 'Process_Price_List'
2343: );
2344: END IF;

Line 2348: oe_msg_pub.Count_And_Get

2344: END IF;
2345:
2346: -- Get message count and data
2347:
2348: oe_msg_pub.Count_And_Get
2349: ( p_count => x_msg_count
2350: , p_data => x_msg_data
2351: );
2352:

Line 2415: oe_msg_pub.initialize;

2411:
2412: -- Initialize message list.
2413:
2414: IF FND_API.to_Boolean(p_init_msg_list) THEN
2415: oe_msg_pub.initialize;
2416: END IF;
2417:
2418: -- Set Savepoint
2419:

Line 2520: oe_msg_pub.Count_And_Get

2516: x_return_status := FND_API.G_RET_STS_SUCCESS;
2517:
2518: -- Get message count and data
2519:
2520: oe_msg_pub.Count_And_Get
2521: ( p_count => x_msg_count
2522: , p_data => x_msg_data
2523: );
2524:

Line 2534: oe_msg_pub.Count_And_Get

2530: x_return_status := FND_API.G_RET_STS_ERROR;
2531:
2532: -- Get message count and data
2533:
2534: oe_msg_pub.Count_And_Get
2535: ( p_count => x_msg_count
2536: , p_data => x_msg_data
2537: );
2538:

Line 2549: oe_msg_pub.Count_And_Get

2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2546:
2547: -- Get message count and data
2548:
2549: oe_msg_pub.Count_And_Get
2550: ( p_count => x_msg_count
2551: , p_data => x_msg_data
2552: );
2553:

Line 2562: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2558: WHEN OTHERS THEN
2559:
2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2561:
2562: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2563: THEN
2564: oe_msg_pub.Add_Exc_Msg
2565: ( G_PKG_NAME
2566: , 'Lock_Price_List'

Line 2564: oe_msg_pub.Add_Exc_Msg

2560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2561:
2562: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2563: THEN
2564: oe_msg_pub.Add_Exc_Msg
2565: ( G_PKG_NAME
2566: , 'Lock_Price_List'
2567: );
2568: END IF;

Line 2572: oe_msg_pub.Count_And_Get

2568: END IF;
2569:
2570: -- Get message count and data
2571:
2572: oe_msg_pub.Count_And_Get
2573: ( p_count => x_msg_count
2574: , p_data => x_msg_data
2575: );
2576:

Line 2636: oe_msg_pub.initialize;

2632:
2633: -- Initialize message list.
2634:
2635: IF FND_API.to_Boolean(p_init_msg_list) THEN
2636: oe_msg_pub.initialize;
2637: END IF;
2638:
2639: -- Get PRICE_LIST ( parent = PRICE_LIST )
2640:

Line 2693: oe_msg_pub.Count_And_Get

2689: x_return_status := FND_API.G_RET_STS_SUCCESS;
2690:
2691: -- Get message count and data
2692:
2693: oe_msg_pub.Count_And_Get
2694: ( p_count => x_msg_count
2695: , p_data => x_msg_data
2696: );
2697:

Line 2707: oe_msg_pub.Count_And_Get

2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704:
2705: -- Get message count and data
2706:
2707: oe_msg_pub.Count_And_Get
2708: ( p_count => x_msg_count
2709: , p_data => x_msg_data
2710: );
2711:

Line 2718: oe_msg_pub.Count_And_Get

2714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2715:
2716: -- Get message count and data
2717:
2718: oe_msg_pub.Count_And_Get
2719: ( p_count => x_msg_count
2720: , p_data => x_msg_data
2721: );
2722:

Line 2727: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2723: WHEN OTHERS THEN
2724:
2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2726:
2727: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2728: THEN
2729: oe_msg_pub.Add_Exc_Msg
2730: ( G_PKG_NAME
2731: , 'Get_Price_List'

Line 2729: oe_msg_pub.Add_Exc_Msg

2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2726:
2727: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2728: THEN
2729: oe_msg_pub.Add_Exc_Msg
2730: ( G_PKG_NAME
2731: , 'Get_Price_List'
2732: );
2733: END IF;

Line 2737: oe_msg_pub.Count_And_Get

2733: END IF;
2734:
2735: -- Get message count and data
2736:
2737: oe_msg_pub.Count_And_Get
2738: ( p_count => x_msg_count
2739: , p_data => x_msg_data
2740: );
2741: