DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on FND_API

Line 1715: x_return_status := FND_API.G_RET_STS_SUCCESS;

1711: ,l_routine || '<'
1712: );
1713: END IF;
1714:
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: -- Standard call to check for call compatibility
1718: IF NOT FND_API.Compatible_API_Call
1719: ( L_API_VERSION_NUMBER

Line 1718: IF NOT FND_API.Compatible_API_Call

1714:
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: -- Standard call to check for call compatibility
1718: IF NOT FND_API.Compatible_API_Call
1719: ( L_API_VERSION_NUMBER
1720: , p_api_version_number
1721: , L_API_NAME
1722: , G_PKG_NAME

Line 1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1721: , L_API_NAME
1722: , G_PKG_NAME
1723: )
1724: THEN
1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: END IF;
1727:
1728: -- Initialize message stack if required
1729: IF FND_API.to_Boolean(p_init_msg_list)

Line 1729: IF FND_API.to_Boolean(p_init_msg_list)

1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: END IF;
1727:
1728: -- Initialize message stack if required
1729: IF FND_API.to_Boolean(p_init_msg_list)
1730: THEN
1731: FND_MSG_PUB.initialize;
1732: END IF;
1733:

Line 1819: WHEN FND_API.G_EXC_ERROR THEN

1815: END IF;
1816:
1817: EXCEPTION
1818:
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821: -- Get message count and data
1822: FND_MSG_PUB.Count_And_Get
1823: ( p_count => x_msg_count

Line 1820: x_return_status := FND_API.G_RET_STS_ERROR;

1816:
1817: EXCEPTION
1818:
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821: -- Get message count and data
1822: FND_MSG_PUB.Count_And_Get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data

Line 1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1822: FND_MSG_PUB.Count_And_Get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data
1825: );
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: -- Get message count and data
1829: FND_MSG_PUB.Count_And_Get
1830: ( p_count => x_msg_count

Line 1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data
1825: );
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: -- Get message count and data
1829: FND_MSG_PUB.Count_And_Get
1830: ( p_count => x_msg_count
1831: , p_data => x_msg_data

Line 1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1830: ( p_count => x_msg_count
1831: , p_data => x_msg_data
1832: );
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1836: THEN
1837: FND_MSG_PUB.Add_Exc_Msg
1838: ( G_PKG_NAME

Line 2548: x_return_status := FND_API.G_RET_STS_SUCCESS;

2544: ,l_routine || '<'
2545: );
2546: END IF;
2547:
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;
2549:
2550: INSERT INTO
2551: CST_MGD_INFL_ADJ_PER_STATUSES(
2552: Organization_ID

Line 2590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2586:
2587: EXCEPTION
2588:
2589: WHEN OTHERS THEN
2590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2591: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2592: THEN
2593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2594: , 'Create_Infl_Period_Status'

Line 2621: x_return_status := FND_API.G_RET_STS_SUCCESS;

2617: )
2618: IS
2619: BEGIN
2620:
2621: x_return_status := FND_API.G_RET_STS_SUCCESS;
2622:
2623: UPDATE CST_MGD_INFL_ADJ_PER_STATUSES
2624: SET Status = 'FINAL'
2625: , Last_Update_Date = SYSDATE

Line 2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2636:
2637: EXCEPTION
2638:
2639: WHEN OTHERS THEN
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2642: THEN
2643: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2644: , 'Create_Period_Status'

Line 2666: x_return_status := FND_API.G_RET_STS_SUCCESS;

2662: )
2663: IS
2664: BEGIN
2665:
2666: x_return_status := FND_API.G_RET_STS_SUCCESS;
2667:
2668: -- Validate historical inflation adjustment attributes
2669: IF (p_historical_infl_adj_rec.country_code IS NULL)
2670: OR

Line 2673: x_return_status := FND_API.G_RET_STS_ERROR;

2669: IF (p_historical_infl_adj_rec.country_code IS NULL)
2670: OR
2671: (LENGTH(p_historical_infl_adj_rec.country_code) <> 2)
2672: THEN
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: END IF;
2675:
2676: IF (p_historical_infl_adj_rec.organization_id IS NULL)
2677: THEN

Line 2678: x_return_status := FND_API.G_RET_STS_ERROR;

2674: END IF;
2675:
2676: IF (p_historical_infl_adj_rec.organization_id IS NULL)
2677: THEN
2678: x_return_status := FND_API.G_RET_STS_ERROR;
2679: END IF;
2680:
2681: IF (p_historical_infl_adj_rec.acct_period_id IS NULL)
2682: THEN

Line 2683: x_return_status := FND_API.G_RET_STS_ERROR;

2679: END IF;
2680:
2681: IF (p_historical_infl_adj_rec.acct_period_id IS NULL)
2682: THEN
2683: x_return_status := FND_API.G_RET_STS_ERROR;
2684: END IF;
2685:
2686: IF (p_historical_infl_adj_rec.inventory_item_id IS NULL)
2687: THEN

Line 2688: x_return_status := FND_API.G_RET_STS_ERROR;

2684: END IF;
2685:
2686: IF (p_historical_infl_adj_rec.inventory_item_id IS NULL)
2687: THEN
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689: END IF;
2690:
2691: IF (p_historical_infl_adj_rec.begin_qty IS NULL)
2692: -- OR

Line 2695: x_return_status := FND_API.G_RET_STS_ERROR;

2691: IF (p_historical_infl_adj_rec.begin_qty IS NULL)
2692: -- OR
2693: -- (p_historical_infl_adj_rec.begin_qty < 0)
2694: THEN
2695: x_return_status := FND_API.G_RET_STS_ERROR;
2696: END IF;
2697:
2698: IF (p_historical_infl_adj_rec.begin_cost IS NULL)
2699: -- OR

Line 2702: x_return_status := FND_API.G_RET_STS_ERROR;

2698: IF (p_historical_infl_adj_rec.begin_cost IS NULL)
2699: -- OR
2700: -- (p_historical_infl_adj_rec.begin_cost < 0)
2701: THEN
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703: END IF;
2704:
2705: IF (p_historical_infl_adj_rec.begin_inflation_adj IS NULL)
2706: -- OR

Line 2709: x_return_status := FND_API.G_RET_STS_ERROR;

2705: IF (p_historical_infl_adj_rec.begin_inflation_adj IS NULL)
2706: -- OR
2707: -- (p_historical_infl_adj_rec.begin_inflation_adj < 0)
2708: THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: END IF;
2711:
2712: EXCEPTION
2713:

Line 2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2711:
2712: EXCEPTION
2713:
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2716: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2717: THEN
2718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2719: , 'Validate_Hist_Attributes'