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:
1014: ELSE
1015:
1016: -- Unexpected error, unrecognized attribute
1017: stmt:=5;
1018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1019: THEN
1020: OE_MSG_PUB.Add_Exc_Msg
1021: ( G_PKG_NAME
1022: , 'Change_Attributes'
1016: -- Unexpected error, unrecognized attribute
1017: stmt:=5;
1018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1019: THEN
1020: OE_MSG_PUB.Add_Exc_Msg
1021: ( G_PKG_NAME
1022: , 'Change_Attributes'
1023: , 'Unrecognized attribute:'||p_attr_id
1024: );
1658: x_return_status := FND_API.G_RET_STS_SUCCESS;
1659:
1660:
1661: -- Get message count and data
1662: OE_MSG_PUB.Count_And_Get
1663: ( p_count => x_msg_count
1664: , p_data => x_msg_data
1665: );
1666:
1679: -- Get message count and data
1680:
1681: /* Msg is commented out nocopy for the bug #2485694 */
1682:
1683: /* OE_MSG_PUB.Add_Exc_Msg
1684: ( G_PKG_NAME
1685: , 'Change_Attributes'||stmt
1686: ); */
1687:
1688: IF l_debug_level > 0 THEN
1689: oe_debug_pub.add( G_PKG_NAME|| 'CHANGE_ATTRIBUTES'||STMT , 1 ) ;
1690: END IF;
1691:
1692: OE_MSG_PUB.Count_And_Get
1693: ( p_count => x_msg_count
1694: , p_data => x_msg_data
1695: );
1696:
1710: -- Get message count and data
1711: IF l_debug_level > 0 THEN
1712: oe_debug_pub.add( 'STMT:'||STMT ) ;
1713: END IF;
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Change_Attributes:'||stmt
1717: );
1718: OE_MSG_PUB.Count_And_Get
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Change_Attributes:'||stmt
1717: );
1718: OE_MSG_PUB.Count_And_Get
1719: ( p_count => x_msg_count
1720: , p_data => x_msg_data
1721: );
1722:
1727: OE_GLOBALS.G_UI_FLAG := FALSE;
1728:
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730:
1731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: THEN
1733: OE_MSG_PUB.Add_Exc_Msg
1734: ( G_PKG_NAME
1735: , 'Change_Attributes:'||stmt
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730:
1731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: THEN
1733: OE_MSG_PUB.Add_Exc_Msg
1734: ( G_PKG_NAME
1735: , 'Change_Attributes:'||stmt
1736: );
1737: END IF;
1737: END IF;
1738:
1739: -- Get message count and data
1740:
1741: OE_MSG_PUB.Count_And_Get
1742: ( p_count => x_msg_count
1743: , p_data => x_msg_data
1744: );
1745:
2022: x_return_status := FND_API.G_RET_STS_SUCCESS;
2023:
2024:
2025: -- Get message count and data
2026: OE_MSG_PUB.Count_And_Get
2027: ( p_count => x_msg_count
2028: , p_data => x_msg_data
2029: );
2030:
2041: x_return_status := FND_API.G_RET_STS_ERROR;
2042:
2043: -- Get message count and data
2044:
2045: OE_MSG_PUB.Count_And_Get
2046: ( p_count => x_msg_count
2047: , p_data => x_msg_data
2048: );
2049:
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2057:
2058: -- Get message count and data
2059:
2060: OE_MSG_PUB.Count_And_Get
2061: ( p_count => x_msg_count
2062: , p_data => x_msg_data
2063: );
2064:
2069: OE_GLOBALS.G_UI_FLAG := FALSE;
2070:
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2072:
2073: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2074: THEN
2075: OE_MSG_PUB.Add_Exc_Msg
2076: ( G_PKG_NAME
2077: , 'Validate_And_Write'
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2072:
2073: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2074: THEN
2075: OE_MSG_PUB.Add_Exc_Msg
2076: ( G_PKG_NAME
2077: , 'Validate_And_Write'
2078: );
2079: END IF;
2079: END IF;
2080:
2081: -- Get message count and data
2082:
2083: OE_MSG_PUB.Count_And_Get
2084: ( p_count => x_msg_count
2085: , p_data => x_msg_data
2086: );
2087:
2245: x_return_status := FND_API.G_RET_STS_SUCCESS;
2246:
2247:
2248: -- Get message count and data
2249: OE_MSG_PUB.Count_And_Get
2250: ( p_count => x_msg_count
2251: , p_data => x_msg_data
2252: );
2253:
2263:
2264: x_return_status := FND_API.G_RET_STS_ERROR;
2265:
2266: -- Get message count and data
2267: OE_MSG_PUB.Count_And_Get
2268: ( p_count => x_msg_count
2269: , p_data => x_msg_data
2270: );
2271:
2275:
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2277:
2278: -- Get message count and data
2279: OE_MSG_PUB.Count_And_Get
2280: ( p_count => x_msg_count
2281: , p_data => x_msg_data
2282: );
2283:
2286: OE_GLOBALS.G_UI_FLAG := FALSE;
2287:
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289:
2290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: OE_MSG_PUB.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Delete_Row'
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2289:
2290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: OE_MSG_PUB.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Delete_Row'
2295: );
2296: END IF;
2295: );
2296: END IF;
2297:
2298: -- Get message count and data
2299: OE_MSG_PUB.Count_And_Get
2300: ( p_count => x_msg_count
2301: , p_data => x_msg_data
2302: );
2303:
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;
2495:
2496: -- Get message count and data
2497:
2498: OE_MSG_PUB.Count_And_Get
2499: ( p_count => x_msg_count
2500: , p_data => x_msg_data
2501: );
2502:
2513: x_return_status := FND_API.G_RET_STS_ERROR;
2514:
2515: -- Get message count and data
2516:
2517: OE_MSG_PUB.Count_And_Get
2518: ( p_count => x_msg_count
2519: , p_data => x_msg_data
2520: );
2521:
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2527:
2528: -- Get message count and data
2529:
2530: OE_MSG_PUB.Count_And_Get
2531: ( p_count => x_msg_count
2532: , p_data => x_msg_data
2533: );
2534:
2537: OE_GLOBALS.G_UI_FLAG := FALSE;
2538:
2539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2540:
2541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2542: THEN
2543: OE_MSG_PUB.Add_Exc_Msg
2544: ( G_PKG_NAME
2545: , 'Process_Entity'
2539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2540:
2541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2542: THEN
2543: OE_MSG_PUB.Add_Exc_Msg
2544: ( G_PKG_NAME
2545: , 'Process_Entity'
2546: );
2547: END IF;
2547: END IF;
2548:
2549: -- Get message count and data
2550:
2551: OE_MSG_PUB.Count_And_Get
2552: ( p_count => x_msg_count
2553: , p_data => x_msg_data
2554: );
2555:
2615: x_return_status := l_return_status;
2616:
2617:
2618: -- Get message count and data
2619: OE_MSG_PUB.Count_And_Get
2620: ( p_count => x_msg_count
2621: , p_data => x_msg_data
2622: );
2623:
2628: EXCEPTION
2629:
2630: WHEN OTHERS THEN
2631:
2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633: THEN
2634: OE_MSG_PUB.Add_Exc_Msg
2635: ( G_PKG_NAME
2636: , 'Lock_Row'
2630: WHEN OTHERS THEN
2631:
2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633: THEN
2634: OE_MSG_PUB.Add_Exc_Msg
2635: ( G_PKG_NAME
2636: , 'Lock_Row'
2637: );
2638: END IF;
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641:
2642: -- Get message count and data
2643:
2644: OE_MSG_PUB.Count_And_Get
2645: ( p_count => x_msg_count
2646: , p_data => x_msg_data
2647: );
2648: