480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482:
483: -- Get message count and data
484: OE_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count
486: , p_data => x_msg_data
487: );
488:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497:
498: -- Get message count and data
499:
500: OE_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count
502: , p_data => x_msg_data
503: );
504:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510:
511: -- Get message count and data
512:
513: OE_MSG_PUB.Count_And_Get
514: ( p_count => x_msg_count
515: , p_data => x_msg_data
516: );
517:
520: OE_GLOBALS.G_UI_FLAG := FALSE;
521:
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523:
524: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
526: OE_MSG_PUB.Add_Exc_Msg
527: ( G_PKG_NAME
528: , 'Default_Attributes'
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
523:
524: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
526: OE_MSG_PUB.Add_Exc_Msg
527: ( G_PKG_NAME
528: , 'Default_Attributes'
529: );
530: END IF;
530: END IF;
531:
532: -- Get message count and data
533:
534: OE_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count
536: , p_data => x_msg_data
537: );
538:
1016: ELSE
1017:
1018: -- Unexpected error, unrecognized attribute
1019: stmt:=5;
1020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: OE_MSG_PUB.Add_Exc_Msg
1023: ( G_PKG_NAME
1024: , 'Change_Attributes'
1018: -- Unexpected error, unrecognized attribute
1019: stmt:=5;
1020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: OE_MSG_PUB.Add_Exc_Msg
1023: ( G_PKG_NAME
1024: , 'Change_Attributes'
1025: , 'Unrecognized attribute:'||p_attr_id
1026: );
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661:
1662:
1663: -- Get message count and data
1664: OE_MSG_PUB.Count_And_Get
1665: ( p_count => x_msg_count
1666: , p_data => x_msg_data
1667: );
1668:
1681: -- Get message count and data
1682:
1683: /* Msg is commented out nocopy for the bug #2485694 */
1684:
1685: /* OE_MSG_PUB.Add_Exc_Msg
1686: ( G_PKG_NAME
1687: , 'Change_Attributes'||stmt
1688: ); */
1689:
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( G_PKG_NAME|| 'CHANGE_ATTRIBUTES'||STMT , 1 ) ;
1692: END IF;
1693:
1694: OE_MSG_PUB.Count_And_Get
1695: ( p_count => x_msg_count
1696: , p_data => x_msg_data
1697: );
1698:
1712: -- Get message count and data
1713: IF l_debug_level > 0 THEN
1714: oe_debug_pub.add( 'STMT:'||STMT ) ;
1715: END IF;
1716: OE_MSG_PUB.Add_Exc_Msg
1717: ( G_PKG_NAME
1718: , 'Change_Attributes:'||stmt
1719: );
1720: OE_MSG_PUB.Count_And_Get
1716: OE_MSG_PUB.Add_Exc_Msg
1717: ( G_PKG_NAME
1718: , 'Change_Attributes:'||stmt
1719: );
1720: OE_MSG_PUB.Count_And_Get
1721: ( p_count => x_msg_count
1722: , p_data => x_msg_data
1723: );
1724:
1729: OE_GLOBALS.G_UI_FLAG := FALSE;
1730:
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1732:
1733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: OE_MSG_PUB.Add_Exc_Msg
1736: ( G_PKG_NAME
1737: , 'Change_Attributes:'||stmt
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1732:
1733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1734: THEN
1735: OE_MSG_PUB.Add_Exc_Msg
1736: ( G_PKG_NAME
1737: , 'Change_Attributes:'||stmt
1738: );
1739: END IF;
1739: END IF;
1740:
1741: -- Get message count and data
1742:
1743: OE_MSG_PUB.Count_And_Get
1744: ( p_count => x_msg_count
1745: , p_data => x_msg_data
1746: );
1747:
2039: x_return_status := FND_API.G_RET_STS_SUCCESS;
2040:
2041:
2042: -- Get message count and data
2043: OE_MSG_PUB.Count_And_Get
2044: ( p_count => x_msg_count
2045: , p_data => x_msg_data
2046: );
2047:
2058: x_return_status := FND_API.G_RET_STS_ERROR;
2059:
2060: -- Get message count and data
2061:
2062: OE_MSG_PUB.Count_And_Get
2063: ( p_count => x_msg_count
2064: , p_data => x_msg_data
2065: );
2066:
2073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2074:
2075: -- Get message count and data
2076:
2077: OE_MSG_PUB.Count_And_Get
2078: ( p_count => x_msg_count
2079: , p_data => x_msg_data
2080: );
2081:
2086: OE_GLOBALS.G_UI_FLAG := FALSE;
2087:
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2089:
2090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2091: THEN
2092: OE_MSG_PUB.Add_Exc_Msg
2093: ( G_PKG_NAME
2094: , 'Validate_And_Write'
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2089:
2090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2091: THEN
2092: OE_MSG_PUB.Add_Exc_Msg
2093: ( G_PKG_NAME
2094: , 'Validate_And_Write'
2095: );
2096: END IF;
2096: END IF;
2097:
2098: -- Get message count and data
2099:
2100: OE_MSG_PUB.Count_And_Get
2101: ( p_count => x_msg_count
2102: , p_data => x_msg_data
2103: );
2104:
2262: x_return_status := FND_API.G_RET_STS_SUCCESS;
2263:
2264:
2265: -- Get message count and data
2266: OE_MSG_PUB.Count_And_Get
2267: ( p_count => x_msg_count
2268: , p_data => x_msg_data
2269: );
2270:
2280:
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282:
2283: -- Get message count and data
2284: OE_MSG_PUB.Count_And_Get
2285: ( p_count => x_msg_count
2286: , p_data => x_msg_data
2287: );
2288:
2292:
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2294:
2295: -- Get message count and data
2296: OE_MSG_PUB.Count_And_Get
2297: ( p_count => x_msg_count
2298: , p_data => x_msg_data
2299: );
2300:
2303: OE_GLOBALS.G_UI_FLAG := FALSE;
2304:
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2306:
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2308: THEN
2309: OE_MSG_PUB.Add_Exc_Msg
2310: ( G_PKG_NAME
2311: , 'Delete_Row'
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2306:
2307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2308: THEN
2309: OE_MSG_PUB.Add_Exc_Msg
2310: ( G_PKG_NAME
2311: , 'Delete_Row'
2312: );
2313: END IF;
2312: );
2313: END IF;
2314:
2315: -- Get message count and data
2316: OE_MSG_PUB.Count_And_Get
2317: ( p_count => x_msg_count
2318: , p_data => x_msg_data
2319: );
2320:
2418: END IF;
2419:
2420: x_return_status := FND_API.G_RET_STS_SUCCESS;
2421: -- 16581325 start Get message count and data
2422: OE_MSG_PUB.Count_And_Get
2423: ( p_count => x_msg_count
2424: , p_data => x_msg_data
2425: );
2426: --16581325 end
2517: x_return_status := FND_API.G_RET_STS_SUCCESS;
2518:
2519: -- Get message count and data
2520:
2521: OE_MSG_PUB.Count_And_Get
2522: ( p_count => x_msg_count
2523: , p_data => x_msg_data
2524: );
2525:
2536: x_return_status := FND_API.G_RET_STS_ERROR;
2537:
2538: -- Get message count and data
2539:
2540: OE_MSG_PUB.Count_And_Get
2541: ( p_count => x_msg_count
2542: , p_data => x_msg_data
2543: );
2544:
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2550:
2551: -- Get message count and data
2552:
2553: OE_MSG_PUB.Count_And_Get
2554: ( p_count => x_msg_count
2555: , p_data => x_msg_data
2556: );
2557:
2560: OE_GLOBALS.G_UI_FLAG := FALSE;
2561:
2562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2563:
2564: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2565: THEN
2566: OE_MSG_PUB.Add_Exc_Msg
2567: ( G_PKG_NAME
2568: , 'Process_Entity'
2562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2563:
2564: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2565: THEN
2566: OE_MSG_PUB.Add_Exc_Msg
2567: ( G_PKG_NAME
2568: , 'Process_Entity'
2569: );
2570: END IF;
2570: END IF;
2571:
2572: -- Get message count and data
2573:
2574: OE_MSG_PUB.Count_And_Get
2575: ( p_count => x_msg_count
2576: , p_data => x_msg_data
2577: );
2578:
2638: x_return_status := l_return_status;
2639:
2640:
2641: -- Get message count and data
2642: OE_MSG_PUB.Count_And_Get
2643: ( p_count => x_msg_count
2644: , p_data => x_msg_data
2645: );
2646:
2651: EXCEPTION
2652:
2653: WHEN OTHERS THEN
2654:
2655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: OE_MSG_PUB.Add_Exc_Msg
2658: ( G_PKG_NAME
2659: , 'Lock_Row'
2653: WHEN OTHERS THEN
2654:
2655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: OE_MSG_PUB.Add_Exc_Msg
2658: ( G_PKG_NAME
2659: , 'Lock_Row'
2660: );
2661: END IF;
2663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2664:
2665: -- Get message count and data
2666:
2667: OE_MSG_PUB.Count_And_Get
2668: ( p_count => x_msg_count
2669: , p_data => x_msg_data
2670: );
2671: