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 1286: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1282: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1284: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1285:
1286: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1287: THEN
1288: oe_msg_pub.Add_Exc_Msg
1289: ( G_PKG_NAME
1290: , 'Qualifierss'

Line 1288: oe_msg_pub.Add_Exc_Msg

1284: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1285:
1286: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1287: THEN
1288: oe_msg_pub.Add_Exc_Msg
1289: ( G_PKG_NAME
1290: , 'Qualifierss'
1291: );
1292: END IF;

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

1332: RAISE;
1333:
1334: WHEN OTHERS THEN
1335:
1336: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1337: THEN
1338: oe_msg_pub.Add_Exc_Msg
1339: ( G_PKG_NAME
1340: , 'Qualifierss'

Line 1338: oe_msg_pub.Add_Exc_Msg

1334: WHEN OTHERS THEN
1335:
1336: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1337: THEN
1338: oe_msg_pub.Add_Exc_Msg
1339: ( G_PKG_NAME
1340: , 'Qualifierss'
1341: );
1342: END IF;

Line 1511: OE_MSG_PUB.Add;

1507: l_return_status := FND_API.G_RET_STS_ERROR;
1508: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
1509: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
1510: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
1511: OE_MSG_PUB.Add;
1512:
1513: RAISE FND_API.G_EXC_ERROR;
1514:
1515: END IF;

Line 1601: OE_MSG_PUB.Add;

1597: l_return_status := FND_API.G_RET_STS_ERROR;
1598: FND_MESSAGE.SET_NAME('QP', 'QP_PTE_SS_CODE_MISMATCH');
1599: FND_MESSAGE.SET_TOKEN('SOURCE_SYSTEM',l_saved_source_system_code);
1600: FND_MESSAGE.SET_TOKEN('PTE_CODE',l_saved_pte_code);
1601: OE_MSG_PUB.Add;
1602:
1603: RAISE FND_API.G_EXC_ERROR;
1604:
1605: END IF;

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

1757: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1759: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1760:
1761: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1762: THEN
1763: oe_msg_pub.Add_Exc_Msg
1764: ( G_PKG_NAME
1765: , 'Pricing_Attrs'

Line 1763: oe_msg_pub.Add_Exc_Msg

1759: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1760:
1761: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1762: THEN
1763: oe_msg_pub.Add_Exc_Msg
1764: ( G_PKG_NAME
1765: , 'Pricing_Attrs'
1766: );
1767: END IF;

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

1804: RAISE;
1805:
1806: WHEN OTHERS THEN
1807:
1808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: oe_msg_pub.Add_Exc_Msg
1811: ( G_PKG_NAME
1812: , 'Pricing_Attrs'

Line 1810: oe_msg_pub.Add_Exc_Msg

1806: WHEN OTHERS THEN
1807:
1808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1809: THEN
1810: oe_msg_pub.Add_Exc_Msg
1811: ( G_PKG_NAME
1812: , 'Pricing_Attrs'
1813: );
1814: END IF;

Line 1922: oe_msg_pub.initialize;

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

Line 1934: OE_MSG_PUB.Add;

1930: IF l_installed_status = 'N' THEN
1931:
1932: l_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
1934: OE_MSG_PUB.Add;
1935: RAISE FND_API.G_EXC_ERROR;
1936:
1937: END IF;
1938:

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

2111:
2112: ELSE
2113: oe_debug_pub.add('process_Price_List 16');
2114:
2115: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2116: THEN
2117: oe_debug_pub.add('process_Price_List 17');
2118:
2119: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');

Line 2127: oe_msg_pub.Add;

2123: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
2124: oe_debug_pub.add('process_Price_List 20');
2125: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_PRICING_ATTR_rec.PRICE_LIST_LINE_index);
2126: oe_debug_pub.add('process_Price_List 21');
2127: oe_msg_pub.Add;
2128:
2129:
2130: END IF;
2131: END IF;

Line 2243: oe_msg_pub.Count_And_Get

2239:
2240: -- Get message count and data
2241: oe_debug_Pub.add('process_Price_list 11');
2242:
2243: oe_msg_pub.Count_And_Get
2244: ( p_count => x_msg_count
2245: , p_data => x_msg_data
2246: );
2247:

Line 2310: oe_msg_pub.Count_And_Get

2306: end if;
2307:
2308: -- Get message count and data
2309:
2310: oe_msg_pub.Count_And_Get
2311: ( p_count => x_msg_count
2312: , p_data => x_msg_data
2313: );
2314:

Line 2327: oe_msg_pub.Count_And_Get

2323: end if;
2324:
2325: -- Get message count and data
2326:
2327: oe_msg_pub.Count_And_Get
2328: ( p_count => x_msg_count
2329: , p_data => x_msg_data
2330: );
2331:

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

2339: qp_delayed_requests_pvt.Clear_Request
2340: (x_return_status => l_return_status);
2341: end if;
2342:
2343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: oe_msg_pub.Add_Exc_Msg
2346: ( G_PKG_NAME
2347: , 'Process_Price_List'

Line 2345: oe_msg_pub.Add_Exc_Msg

2341: end if;
2342:
2343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: oe_msg_pub.Add_Exc_Msg
2346: ( G_PKG_NAME
2347: , 'Process_Price_List'
2348: );
2349: END IF;

Line 2353: oe_msg_pub.Count_And_Get

2349: END IF;
2350:
2351: -- Get message count and data
2352:
2353: oe_msg_pub.Count_And_Get
2354: ( p_count => x_msg_count
2355: , p_data => x_msg_data
2356: );
2357:

Line 2420: oe_msg_pub.initialize;

2416:
2417: -- Initialize message list.
2418:
2419: IF FND_API.to_Boolean(p_init_msg_list) THEN
2420: oe_msg_pub.initialize;
2421: END IF;
2422:
2423: -- Set Savepoint
2424:

Line 2525: oe_msg_pub.Count_And_Get

2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2522:
2523: -- Get message count and data
2524:
2525: oe_msg_pub.Count_And_Get
2526: ( p_count => x_msg_count
2527: , p_data => x_msg_data
2528: );
2529:

Line 2539: oe_msg_pub.Count_And_Get

2535: x_return_status := FND_API.G_RET_STS_ERROR;
2536:
2537: -- Get message count and data
2538:
2539: oe_msg_pub.Count_And_Get
2540: ( p_count => x_msg_count
2541: , p_data => x_msg_data
2542: );
2543:

Line 2554: oe_msg_pub.Count_And_Get

2550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2551:
2552: -- Get message count and data
2553:
2554: oe_msg_pub.Count_And_Get
2555: ( p_count => x_msg_count
2556: , p_data => x_msg_data
2557: );
2558:

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

2563: WHEN OTHERS THEN
2564:
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2568: THEN
2569: oe_msg_pub.Add_Exc_Msg
2570: ( G_PKG_NAME
2571: , 'Lock_Price_List'

Line 2569: oe_msg_pub.Add_Exc_Msg

2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2568: THEN
2569: oe_msg_pub.Add_Exc_Msg
2570: ( G_PKG_NAME
2571: , 'Lock_Price_List'
2572: );
2573: END IF;

Line 2577: oe_msg_pub.Count_And_Get

2573: END IF;
2574:
2575: -- Get message count and data
2576:
2577: oe_msg_pub.Count_And_Get
2578: ( p_count => x_msg_count
2579: , p_data => x_msg_data
2580: );
2581:

Line 2641: oe_msg_pub.initialize;

2637:
2638: -- Initialize message list.
2639:
2640: IF FND_API.to_Boolean(p_init_msg_list) THEN
2641: oe_msg_pub.initialize;
2642: END IF;
2643:
2644: -- Get PRICE_LIST ( parent = PRICE_LIST )
2645:

Line 2698: oe_msg_pub.Count_And_Get

2694: x_return_status := FND_API.G_RET_STS_SUCCESS;
2695:
2696: -- Get message count and data
2697:
2698: oe_msg_pub.Count_And_Get
2699: ( p_count => x_msg_count
2700: , p_data => x_msg_data
2701: );
2702:

Line 2712: oe_msg_pub.Count_And_Get

2708: x_return_status := FND_API.G_RET_STS_ERROR;
2709:
2710: -- Get message count and data
2711:
2712: oe_msg_pub.Count_And_Get
2713: ( p_count => x_msg_count
2714: , p_data => x_msg_data
2715: );
2716:

Line 2723: oe_msg_pub.Count_And_Get

2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2720:
2721: -- Get message count and data
2722:
2723: oe_msg_pub.Count_And_Get
2724: ( p_count => x_msg_count
2725: , p_data => x_msg_data
2726: );
2727:

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

2728: WHEN OTHERS THEN
2729:
2730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2731:
2732: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2733: THEN
2734: oe_msg_pub.Add_Exc_Msg
2735: ( G_PKG_NAME
2736: , 'Get_Price_List'

Line 2734: oe_msg_pub.Add_Exc_Msg

2730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2731:
2732: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2733: THEN
2734: oe_msg_pub.Add_Exc_Msg
2735: ( G_PKG_NAME
2736: , 'Get_Price_List'
2737: );
2738: END IF;

Line 2742: oe_msg_pub.Count_And_Get

2738: END IF;
2739:
2740: -- Get message count and data
2741:
2742: oe_msg_pub.Count_And_Get
2743: ( p_count => x_msg_count
2744: , p_data => x_msg_data
2745: );
2746: