DBA Data[Home] [Help]

APPS.CST_PERENDACCRUALS_PVT dependencies on FND_MSG_PUB

Line 718: FND_MSG_PUB.initialize;

714: END IF;
715:
716: -- Initialize message list if p_init_msg_list is set to TRUE
717: IF FND_API.to_Boolean( p_init_msg_list ) THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720:
721: -- Initialize API return status to success
722: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1311: FND_MSG_PUB.Count_And_Get

1307: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,'Create_PerEndAccruals >>');
1308: END IF;
1309:
1310: -- Get message count and if 1, return message data.
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315:

Line 1335: FND_MSG_PUB.Count_And_Get

1331: l_msg_data
1332: );
1333: END IF;
1334:
1335: FND_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count,
1337: p_data => x_msg_data
1338: );
1339:

Line 1353: IF FND_MSG_PUB.Check_Msg_Level

1349: SQLERRM
1350: );
1351: END IF;
1352:
1353: IF FND_MSG_PUB.Check_Msg_Level
1354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1355: THEN
1356: FND_MSG_PUB.Add_Exc_Msg
1357: ( G_PKG_NAME,

Line 1354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1350: );
1351: END IF;
1352:
1353: IF FND_MSG_PUB.Check_Msg_Level
1354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1355: THEN
1356: FND_MSG_PUB.Add_Exc_Msg
1357: ( G_PKG_NAME,
1358: l_api_name,

Line 1356: FND_MSG_PUB.Add_Exc_Msg

1352:
1353: IF FND_MSG_PUB.Check_Msg_Level
1354: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1355: THEN
1356: FND_MSG_PUB.Add_Exc_Msg
1357: ( G_PKG_NAME,
1358: l_api_name,
1359: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
1360: );

Line 1363: FND_MSG_PUB.Count_And_Get

1359: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
1360: );
1361: END IF;
1362:
1363: FND_MSG_PUB.Count_And_Get
1364: ( p_count => x_msg_count,
1365: p_data => x_msg_data
1366: );
1367:

Line 1486: FND_MSG_PUB.initialize;

1482: END IF;
1483:
1484: -- Initialize message list if p_init_msg_list is set to TRUE.
1485: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1486: FND_MSG_PUB.initialize;
1487: END IF;
1488:
1489: -- Initialize API return status to success
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1502: FND_MSG_PUB.Add_Exc_Msg (

1498:
1499: l_stmt_num := 60;
1500: -- Checking values so that there will not be any division by zero cases later
1501: IF (p_shipment_qty <= 0 OR p_dist_qty <= 0) THEN
1502: FND_MSG_PUB.Add_Exc_Msg (
1503: G_PKG_NAME,
1504: l_api_name,
1505: 'Shipment Id :' || x_accrual_rec.shipment_id || ',' ||
1506: 'Distribution Id :' || x_accrual_rec.distribution_id || ',' ||

Line 1910: FND_MSG_PUB.Count_And_Get

1906: );
1907: END IF;
1908:
1909: -- Get message count and if 1, return message data.
1910: FND_MSG_PUB.Count_And_Get
1911: ( p_count => x_msg_count,
1912: p_data => x_msg_data
1913: );
1914:

Line 1929: FND_MSG_PUB.Count_And_Get

1925: l_msg_data
1926: );
1927: END IF;
1928:
1929: FND_MSG_PUB.Count_And_Get
1930: ( p_count => x_msg_count,
1931: p_data => x_msg_data
1932: );
1933:

Line 1946: IF FND_MSG_PUB.Check_Msg_Level

1942: SQLERRM
1943: );
1944: END IF;
1945:
1946: IF FND_MSG_PUB.Check_Msg_Level
1947: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1948: THEN
1949: FND_MSG_PUB.Add_Exc_Msg
1950: ( G_PKG_NAME,

Line 1947: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1943: );
1944: END IF;
1945:
1946: IF FND_MSG_PUB.Check_Msg_Level
1947: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1948: THEN
1949: FND_MSG_PUB.Add_Exc_Msg
1950: ( G_PKG_NAME,
1951: l_api_name,

Line 1949: FND_MSG_PUB.Add_Exc_Msg

1945:
1946: IF FND_MSG_PUB.Check_Msg_Level
1947: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1948: THEN
1949: FND_MSG_PUB.Add_Exc_Msg
1950: ( G_PKG_NAME,
1951: l_api_name,
1952: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
1953: );

Line 1956: FND_MSG_PUB.Count_And_Get

1952: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
1953: );
1954: END IF;
1955:
1956: FND_MSG_PUB.Count_And_Get
1957: ( p_count => x_msg_count,
1958: p_data => x_msg_data
1959: );
1960:

Line 2039: FND_MSG_PUB.initialize;

2035: END IF;
2036:
2037: -- Initialize message list if p_init_msg_list is set to TRUE.
2038: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2039: FND_MSG_PUB.initialize;
2040: END IF;
2041:
2042: -- Initialize API return status to success
2043: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2097: FND_MSG_PUB.Count_And_Get

2093: );
2094: END IF;
2095:
2096: -- Get message count and if 1, return message data.
2097: FND_MSG_PUB.Count_And_Get
2098: ( p_count => x_msg_count,
2099: p_data => x_msg_data
2100: );
2101:

Line 2116: FND_MSG_PUB.Count_And_Get

2112: l_msg_data
2113: );
2114: END IF;
2115:
2116: FND_MSG_PUB.Count_And_Get
2117: ( p_count => x_msg_count,
2118: p_data => x_msg_data
2119: );
2120:

Line 2133: IF FND_MSG_PUB.Check_Msg_Level

2129: SQLERRM
2130: );
2131: END IF;
2132:
2133: IF FND_MSG_PUB.Check_Msg_Level
2134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg
2137: ( G_PKG_NAME,

Line 2134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2130: );
2131: END IF;
2132:
2133: IF FND_MSG_PUB.Check_Msg_Level
2134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg
2137: ( G_PKG_NAME,
2138: l_api_name,

Line 2136: FND_MSG_PUB.Add_Exc_Msg

2132:
2133: IF FND_MSG_PUB.Check_Msg_Level
2134: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2135: THEN
2136: FND_MSG_PUB.Add_Exc_Msg
2137: ( G_PKG_NAME,
2138: l_api_name,
2139: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2140: );

Line 2143: FND_MSG_PUB.Count_And_Get

2139: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2140: );
2141: END IF;
2142:
2143: FND_MSG_PUB.Count_And_Get
2144: ( p_count => x_msg_count,
2145: p_data => x_msg_data
2146: );
2147:

Line 2273: FND_MSG_PUB.initialize;

2269: END IF;
2270:
2271: -- Initialize message list if p_init_msg_list is set to TRUE.
2272: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2273: FND_MSG_PUB.initialize;
2274: END IF;
2275:
2276: -- Initialize API return status to success
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2485: FND_MSG_PUB.Count_And_Get

2481: );
2482: END IF;
2483:
2484: -- Get message count and if 1, return message data.
2485: FND_MSG_PUB.Count_And_Get
2486: ( p_count => x_msg_count,
2487: p_data => x_msg_data
2488: );
2489:

Line 2496: FND_MSG_PUB.Count_And_Get

2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493:
2494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2495:
2496: FND_MSG_PUB.Count_And_Get
2497: ( p_count => x_msg_count,
2498: p_data => x_msg_data
2499: );
2500:

Line 2513: IF FND_MSG_PUB.Check_Msg_Level

2509: SQLERRM
2510: );
2511: END IF;
2512:
2513: IF FND_MSG_PUB.Check_Msg_Level
2514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2515: THEN
2516: FND_MSG_PUB.Add_Exc_Msg
2517: ( G_PKG_NAME,

Line 2514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2510: );
2511: END IF;
2512:
2513: IF FND_MSG_PUB.Check_Msg_Level
2514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2515: THEN
2516: FND_MSG_PUB.Add_Exc_Msg
2517: ( G_PKG_NAME,
2518: l_api_name,

Line 2516: FND_MSG_PUB.Add_Exc_Msg

2512:
2513: IF FND_MSG_PUB.Check_Msg_Level
2514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2515: THEN
2516: FND_MSG_PUB.Add_Exc_Msg
2517: ( G_PKG_NAME,
2518: l_api_name,
2519: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2520: );

Line 2523: FND_MSG_PUB.Count_And_Get

2519: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2520: );
2521: END IF;
2522:
2523: FND_MSG_PUB.Count_And_Get
2524: ( p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );
2527:

Line 2596: FND_MSG_PUB.initialize;

2592: END IF;
2593:
2594: -- Initialize message list if p_init_msg_list is set to TRUE.
2595: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2596: FND_MSG_PUB.initialize;
2597: END IF;
2598:
2599: -- Initialize API return status to success
2600: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2682: FND_MSG_PUB.Count_And_Get

2678: );
2679: END IF;
2680:
2681: -- Get message count and if 1, return message data.
2682: FND_MSG_PUB.Count_And_Get
2683: ( p_count => x_msg_count,
2684: p_data => x_msg_data
2685: );
2686:

Line 2693: FND_MSG_PUB.Count_And_Get

2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690:
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2692:
2693: FND_MSG_PUB.Count_And_Get
2694: ( p_count => x_msg_count,
2695: p_data => x_msg_data
2696: );
2697:

Line 2709: IF FND_MSG_PUB.Check_Msg_Level

2705: SQLERRM
2706: );
2707: END IF;
2708:
2709: IF FND_MSG_PUB.Check_Msg_Level
2710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg
2713: ( G_PKG_NAME,

Line 2710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2706: );
2707: END IF;
2708:
2709: IF FND_MSG_PUB.Check_Msg_Level
2710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg
2713: ( G_PKG_NAME,
2714: l_api_name,

Line 2712: FND_MSG_PUB.Add_Exc_Msg

2708:
2709: IF FND_MSG_PUB.Check_Msg_Level
2710: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2711: THEN
2712: FND_MSG_PUB.Add_Exc_Msg
2713: ( G_PKG_NAME,
2714: l_api_name,
2715: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2716: );

Line 2719: FND_MSG_PUB.Count_And_Get

2715: '(' || TO_CHAR(l_stmt_num) || ') : ' || SUBSTRB (SQLERRM , 1 , 230)
2716: );
2717: END IF;
2718:
2719: FND_MSG_PUB.Count_And_Get
2720: ( p_count => x_msg_count,
2721: p_data => x_msg_data
2722: );
2723: