APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on FND_MSG_PUB

Line 16: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

12:
13: -- object_type
14: G_CLAIM_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'CLAM';
15:
16: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
17: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
18:
19: CURSOR g_site_trade_profile_csr(p_id in number) IS
20: SELECT trade_profile_id,

Line 17: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

13: -- object_type
14: G_CLAIM_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'CLAM';
15:
16: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
17: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
18:
19: CURSOR g_site_trade_profile_csr(p_id in number) IS
20: SELECT trade_profile_id,
21: cust_account_id,

Line 513: FND_MSG_PUB.count_and_get(

509: p_line_util_rec := l_line_util_rec;
510:
511:
512:
513: FND_MSG_PUB.count_and_get(
514: p_encoded => FND_API.g_false,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );

Line 527: FND_MSG_PUB.count_and_get (

523: EXCEPTION
524: WHEN FND_API.g_exc_error THEN
525: ROLLBACK TO Update_Fund_Utils;
526: x_return_status := FND_API.g_ret_sts_error;
527: FND_MSG_PUB.count_and_get (
528: p_encoded => FND_API.g_false
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data
531: );

Line 536: FND_MSG_PUB.count_and_get (

532:
533: WHEN FND_API.g_exc_unexpected_error THEN
534: ROLLBACK TO Update_Fund_Utils;
535: x_return_status := FND_API.g_ret_sts_unexp_error ;
536: FND_MSG_PUB.count_and_get (
537: p_encoded => FND_API.g_false
538: ,p_count => x_msg_count
539: ,p_data => x_msg_data
540: );

Line 545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

541:
542: WHEN OTHERS THEN
543: ROLLBACK TO Update_Fund_Utils;
544: x_return_status := FND_API.g_ret_sts_unexp_error ;
545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
547: END IF;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false

Line 546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

542: WHEN OTHERS THEN
543: ROLLBACK TO Update_Fund_Utils;
544: x_return_status := FND_API.g_ret_sts_unexp_error ;
545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
547: END IF;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false
550: ,p_count => x_msg_count

Line 548: FND_MSG_PUB.count_and_get(

544: x_return_status := FND_API.g_ret_sts_unexp_error ;
545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
547: END IF;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false
550: ,p_count => x_msg_count
551: ,p_data => x_msg_data
552: );

Line 1279: FND_MSG_PUB.initialize;

1275: OZF_Utility_PVT.debug_message(l_full_name||': start');
1276: END IF;
1277:
1278: IF FND_API.to_boolean(p_init_msg_list) THEN
1279: FND_MSG_PUB.initialize;
1280: END IF;
1281:
1282: IF NOT FND_API.compatible_api_call(
1283: l_api_version,

Line 1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1435:
1436: EXCEPTION
1437: WHEN OTHERS THEN
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1440: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_UTIZ_STMT_ERR');
1441: FND_MSG_PUB.add;
1442: END IF;
1443: END Get_Utiz_Sql_Stmt;

Line 1441: FND_MSG_PUB.add;

1437: WHEN OTHERS THEN
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1440: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_UTIZ_STMT_ERR');
1441: FND_MSG_PUB.add;
1442: END IF;
1443: END Get_Utiz_Sql_Stmt;
1444:
1445:

Line 1549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1545: x_return_status := FND_API.G_RET_STS_SUCCESS;
1546:
1547: IF p_cust_trade_profile.claim_currency is null OR
1548: p_cust_trade_profile.claim_currency = FND_API.G_MISS_CHAR THEN -- [BUG 4217781 FIXING]
1549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1550: OPEN csr_cust_name(l_cust_account_id);
1551: FETCH csr_cust_name INTO l_cust_name_num;
1552: CLOSE csr_cust_name;
1553:

Line 1556: FND_MSG_PUB.ADD;

1552: CLOSE csr_cust_name;
1553:
1554: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_CURRENCY_MISS');
1555: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
1556: FND_MSG_PUB.ADD;
1557: END IF;
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: END IF;
1560:

Line 1563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1559: END IF;
1560:
1561: IF p_cust_trade_profile.payment_method is null OR
1562: p_cust_trade_profile.payment_method = FND_API.G_MISS_CHAR THEN -- [BUG 4217781 FIXING]
1563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1564: OPEN csr_cust_name(l_cust_account_id);
1565: FETCH csr_cust_name INTO l_cust_name_num;
1566: CLOSE csr_cust_name;
1567:

Line 1570: FND_MSG_PUB.ADD;

1566: CLOSE csr_cust_name;
1567:
1568: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_PYMTHD_MISS');
1569: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
1570: FND_MSG_PUB.ADD;
1571: END IF;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: END IF;
1574:

Line 1578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1574:
1575: IF p_cust_trade_profile.payment_method = 'CHECK' THEN
1576: IF p_cust_trade_profile.vendor_id is NULL OR
1577: p_cust_trade_profile.vendor_site_id is NULL THEN
1578: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1579: OPEN csr_cust_name(l_cust_account_id);
1580: FETCH csr_cust_name INTO l_cust_name_num;
1581: CLOSE csr_cust_name;
1582:

Line 1585: FND_MSG_PUB.ADD;

1581: CLOSE csr_cust_name;
1582:
1583: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_VENDOR_MISS');
1584: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
1585: FND_MSG_PUB.ADD;
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: END IF;
1589: ELSIF p_cust_trade_profile.payment_method = 'CREDIT_MEMO' THEN

Line 1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: END IF;
1589: ELSIF p_cust_trade_profile.payment_method = 'CREDIT_MEMO' THEN
1590: IF p_cust_trade_profile.site_use_id is NULL THEN
1591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1592: OPEN csr_cust_name(l_cust_account_id);
1593: FETCH csr_cust_name INTO l_cust_name_num;
1594: CLOSE csr_cust_name;
1595:

Line 1598: FND_MSG_PUB.ADD;

1594: CLOSE csr_cust_name;
1595:
1596: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ATPY_SITEID_MISS');
1597: FND_MESSAGE.Set_Token('ID',l_cust_name_num);
1598: FND_MSG_PUB.ADD;
1599: END IF;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: END IF;
1602: END IF;

Line 1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1606: END IF;
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1611: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');
1612: FND_MSG_PUB.add;
1613: END IF;
1614: END Validate_Cust_Trade_Profile;

Line 1612: FND_MSG_PUB.add;

1608: WHEN OTHERS THEN
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1611: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ATPY_CUSTOMER_ERR');
1612: FND_MSG_PUB.add;
1613: END IF;
1614: END Validate_Cust_Trade_Profile;
1615:
1616: ---------------------------------------------------------------------

Line 1865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1861: x_return_status := FND_API.g_ret_sts_unexp_error ;
1862:
1863: WHEN OTHERS THEN
1864: x_return_status := FND_API.g_ret_sts_unexp_error ;
1865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1867: END IF;
1868:
1869: END Create_Fund_Adjustment;

Line 1866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1862:
1863: WHEN OTHERS THEN
1864: x_return_status := FND_API.g_ret_sts_unexp_error ;
1865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1867: END IF;
1868:
1869: END Create_Fund_Adjustment;
1870:

Line 1954: FND_MSG_PUB.initialize;

1950: OZF_Utility_PVT.debug_message(l_full_name||': start');
1951: END IF;
1952:
1953: IF FND_API.to_boolean(p_init_msg_list) THEN
1954: FND_MSG_PUB.initialize;
1955: END IF;
1956:
1957: IF NOT FND_API.compatible_api_call(
1958: l_api_version,

Line 1992: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1988: , X_Msg_Data => x_msg_data
1989: , X_access => l_access);
1990:
1991: IF l_access = 'N' THEN
1992: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1993: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1994: FND_MSG_PUB.add;
1995: END IF;
1996: RAISE FND_API.G_EXC_ERROR;

Line 1994: FND_MSG_PUB.add;

1990:
1991: IF l_access = 'N' THEN
1992: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1993: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1994: FND_MSG_PUB.add;
1995: END IF;
1996: RAISE FND_API.G_EXC_ERROR;
1997: END IF;
1998: EXIT;

Line 2119: FND_MSG_PUB.count_and_get(

2115: IF FND_API.to_boolean(p_commit) THEN
2116: COMMIT;
2117: END IF;
2118:
2119: FND_MSG_PUB.count_and_get(
2120: p_encoded => FND_API.g_false,
2121: p_count => x_msg_count,
2122: p_data => x_msg_data
2123: );

Line 2133: FND_MSG_PUB.count_and_get (

2129: EXCEPTION
2130: WHEN FND_API.g_exc_error THEN
2131: ROLLBACK TO Create_Line_Util_Tbl;
2132: x_return_status := FND_API.g_ret_sts_error;
2133: FND_MSG_PUB.count_and_get (
2134: p_encoded => FND_API.g_false
2135: ,p_count => x_msg_count
2136: ,p_data => x_msg_data
2137: );

Line 2142: FND_MSG_PUB.count_and_get (

2138:
2139: WHEN FND_API.g_exc_unexpected_error THEN
2140: ROLLBACK TO Create_Line_Util_Tbl;
2141: x_return_status := FND_API.g_ret_sts_unexp_error ;
2142: FND_MSG_PUB.count_and_get (
2143: p_encoded => FND_API.g_false
2144: ,p_count => x_msg_count
2145: ,p_data => x_msg_data
2146: );

Line 2151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2147:
2148: WHEN OTHERS THEN
2149: ROLLBACK TO Create_Line_Util_Tbl;
2150: x_return_status := FND_API.g_ret_sts_unexp_error ;
2151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2153: END IF;
2154: FND_MSG_PUB.count_and_get(
2155: p_encoded => FND_API.g_false

Line 2152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2148: WHEN OTHERS THEN
2149: ROLLBACK TO Create_Line_Util_Tbl;
2150: x_return_status := FND_API.g_ret_sts_unexp_error ;
2151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2153: END IF;
2154: FND_MSG_PUB.count_and_get(
2155: p_encoded => FND_API.g_false
2156: ,p_count => x_msg_count

Line 2154: FND_MSG_PUB.count_and_get(

2150: x_return_status := FND_API.g_ret_sts_unexp_error ;
2151: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2153: END IF;
2154: FND_MSG_PUB.count_and_get(
2155: p_encoded => FND_API.g_false
2156: ,p_count => x_msg_count
2157: ,p_data => x_msg_data
2158: );

Line 2269: FND_MSG_PUB.initialize;

2265: OZF_Utility_PVT.debug_message(l_full_name||': start');
2266: END IF;
2267:
2268: IF FND_API.to_boolean(p_init_msg_list) THEN
2269: FND_MSG_PUB.initialize;
2270: END IF;
2271:
2272: IF NOT FND_API.compatible_api_call(
2273: l_api_version,

Line 2303: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2299: , X_Msg_Data => x_msg_data
2300: , X_access => l_access);
2301:
2302: IF l_access = 'N' THEN
2303: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2304: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2305: FND_MSG_PUB.add;
2306: END IF;
2307: RAISE FND_API.G_EXC_ERROR;

Line 2305: FND_MSG_PUB.add;

2301:
2302: IF l_access = 'N' THEN
2303: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2304: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2305: FND_MSG_PUB.add;
2306: END IF;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309: END IF;

Line 2569: FND_MSG_PUB.count_and_get(

2565: IF FND_API.to_boolean(p_commit) THEN
2566: COMMIT;
2567: END IF;
2568:
2569: FND_MSG_PUB.count_and_get(
2570: p_encoded => FND_API.g_false,
2571: p_count => x_msg_count,
2572: p_data => x_msg_data
2573: );

Line 2583: FND_MSG_PUB.count_and_get (

2579: EXCEPTION
2580: WHEN FND_API.g_exc_error THEN
2581: ROLLBACK TO Create_Line_Util;
2582: x_return_status := FND_API.g_ret_sts_error;
2583: FND_MSG_PUB.count_and_get (
2584: p_encoded => FND_API.g_false
2585: ,p_count => x_msg_count
2586: ,p_data => x_msg_data
2587: );

Line 2592: FND_MSG_PUB.count_and_get (

2588:
2589: WHEN FND_API.g_exc_unexpected_error THEN
2590: ROLLBACK TO Create_Line_Util;
2591: x_return_status := FND_API.g_ret_sts_unexp_error ;
2592: FND_MSG_PUB.count_and_get (
2593: p_encoded => FND_API.g_false
2594: ,p_count => x_msg_count
2595: ,p_data => x_msg_data
2596: );

Line 2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2597:
2598: WHEN OTHERS THEN
2599: ROLLBACK TO Create_Line_Util;
2600: x_return_status := FND_API.g_ret_sts_unexp_error ;
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2602: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2603: END IF;
2604: FND_MSG_PUB.count_and_get(
2605: p_encoded => FND_API.g_false

Line 2602: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2598: WHEN OTHERS THEN
2599: ROLLBACK TO Create_Line_Util;
2600: x_return_status := FND_API.g_ret_sts_unexp_error ;
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2602: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2603: END IF;
2604: FND_MSG_PUB.count_and_get(
2605: p_encoded => FND_API.g_false
2606: ,p_count => x_msg_count

Line 2604: FND_MSG_PUB.count_and_get(

2600: x_return_status := FND_API.g_ret_sts_unexp_error ;
2601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2602: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2603: END IF;
2604: FND_MSG_PUB.count_and_get(
2605: p_encoded => FND_API.g_false
2606: ,p_count => x_msg_count
2607: ,p_data => x_msg_data
2608: );

Line 2672: FND_MSG_PUB.initialize;

2668: OZF_Utility_PVT.debug_message(l_full_name||': start');
2669: END IF;
2670:
2671: IF FND_API.to_boolean(p_init_msg_list) THEN
2672: FND_MSG_PUB.initialize;
2673: END IF;
2674:
2675: IF NOT FND_API.compatible_api_call(
2676: l_api_version,

Line 2709: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2705: , X_Msg_Data => x_msg_data
2706: , X_access => l_access);
2707:
2708: IF l_access = 'N' THEN
2709: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2710: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2711: FND_MSG_PUB.add;
2712: END IF;
2713: RAISE FND_API.G_EXC_ERROR;

Line 2711: FND_MSG_PUB.add;

2707:
2708: IF l_access = 'N' THEN
2709: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2710: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2711: FND_MSG_PUB.add;
2712: END IF;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;
2715: EXIT;

Line 2764: FND_MSG_PUB.count_and_get(

2760: IF FND_API.to_boolean(p_commit) THEN
2761: COMMIT;
2762: END IF;
2763:
2764: FND_MSG_PUB.count_and_get(
2765: p_encoded => FND_API.g_false,
2766: p_count => x_msg_count,
2767: p_data => x_msg_data
2768: );

Line 2778: FND_MSG_PUB.count_and_get (

2774: EXCEPTION
2775: WHEN FND_API.g_exc_error THEN
2776: ROLLBACK TO Update_Line_Util_Tbl;
2777: x_return_status := FND_API.g_ret_sts_error;
2778: FND_MSG_PUB.count_and_get (
2779: p_encoded => FND_API.g_false
2780: ,p_count => x_msg_count
2781: ,p_data => x_msg_data
2782: );

Line 2787: FND_MSG_PUB.count_and_get (

2783:
2784: WHEN FND_API.g_exc_unexpected_error THEN
2785: ROLLBACK TO Update_Line_Util_Tbl;
2786: x_return_status := FND_API.g_ret_sts_unexp_error ;
2787: FND_MSG_PUB.count_and_get (
2788: p_encoded => FND_API.g_false
2789: ,p_count => x_msg_count
2790: ,p_data => x_msg_data
2791: );

Line 2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2792:
2793: WHEN OTHERS THEN
2794: ROLLBACK TO Update_Line_Util_Tbl;
2795: x_return_status := FND_API.g_ret_sts_unexp_error ;
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.count_and_get(
2800: p_encoded => FND_API.g_false

Line 2797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2793: WHEN OTHERS THEN
2794: ROLLBACK TO Update_Line_Util_Tbl;
2795: x_return_status := FND_API.g_ret_sts_unexp_error ;
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.count_and_get(
2800: p_encoded => FND_API.g_false
2801: ,p_count => x_msg_count

Line 2799: FND_MSG_PUB.count_and_get(

2795: x_return_status := FND_API.g_ret_sts_unexp_error ;
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2797: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2798: END IF;
2799: FND_MSG_PUB.count_and_get(
2800: p_encoded => FND_API.g_false
2801: ,p_count => x_msg_count
2802: ,p_data => x_msg_data
2803: );

Line 2897: FND_MSG_PUB.initialize;

2893: OZF_Utility_PVT.debug_message(l_full_name||': start');
2894: END IF;
2895:
2896: IF FND_API.to_boolean(p_init_msg_list) THEN
2897: FND_MSG_PUB.initialize;
2898: END IF;
2899:
2900: IF NOT FND_API.compatible_api_call(
2901: l_api_version,

Line 2952: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2948: , X_Msg_Data => x_msg_data
2949: , X_access => l_access);
2950:
2951: IF l_access = 'N' THEN
2952: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2953: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2954: FND_MSG_PUB.add;
2955: END IF;
2956: RAISE FND_API.G_EXC_ERROR;

Line 2954: FND_MSG_PUB.add;

2950:
2951: IF l_access = 'N' THEN
2952: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2953: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2954: FND_MSG_PUB.add;
2955: END IF;
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;
2958: END IF;

Line 3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3087: WHERE claim_line_util_id = p_line_util_rec.claim_line_util_id;
3088: --AND object_version_number = p_line_util_rec.object_version_number;
3089:
3090: IF (SQL%NOTFOUND) THEN
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3092: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3093: FND_MSG_PUB.add;
3094: END IF;
3095: RAISE FND_API.g_exc_error;

Line 3093: FND_MSG_PUB.add;

3089:
3090: IF (SQL%NOTFOUND) THEN
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3092: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3093: FND_MSG_PUB.add;
3094: END IF;
3095: RAISE FND_API.g_exc_error;
3096: END IF;
3097:

Line 3106: FND_MSG_PUB.count_and_get(

3102: IF FND_API.to_boolean(p_commit) THEN
3103: COMMIT;
3104: END IF;
3105:
3106: FND_MSG_PUB.count_and_get(
3107: p_encoded => FND_API.g_false,
3108: p_count => x_msg_count,
3109: p_data => x_msg_data
3110: );

Line 3120: FND_MSG_PUB.count_and_get(

3116: EXCEPTION
3117: WHEN FND_API.g_exc_error THEN
3118: ROLLBACK TO Update_Line_Util;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: FND_MSG_PUB.count_and_get(
3121: p_encoded => FND_API.g_false,
3122: p_count => x_msg_count,
3123: p_data => x_msg_data
3124: );

Line 3129: FND_MSG_PUB.count_and_get(

3125:
3126: WHEN FND_API.g_exc_unexpected_error THEN
3127: ROLLBACK TO Update_Line_Util;
3128: x_return_status := FND_API.g_ret_sts_unexp_error ;
3129: FND_MSG_PUB.count_and_get(
3130: p_encoded => FND_API.g_false,
3131: p_count => x_msg_count,
3132: p_data => x_msg_data
3133: );

Line 3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3134:
3135: WHEN OTHERS THEN
3136: ROLLBACK TO Update_Line_Util;
3137: x_return_status := FND_API.g_ret_sts_unexp_error ;
3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3140: END IF;
3141: FND_MSG_PUB.count_and_get(
3142: p_encoded => FND_API.g_false,

Line 3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3135: WHEN OTHERS THEN
3136: ROLLBACK TO Update_Line_Util;
3137: x_return_status := FND_API.g_ret_sts_unexp_error ;
3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3140: END IF;
3141: FND_MSG_PUB.count_and_get(
3142: p_encoded => FND_API.g_false,
3143: p_count => x_msg_count,

Line 3141: FND_MSG_PUB.count_and_get(

3137: x_return_status := FND_API.g_ret_sts_unexp_error ;
3138: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3139: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3140: END IF;
3141: FND_MSG_PUB.count_and_get(
3142: p_encoded => FND_API.g_false,
3143: p_count => x_msg_count,
3144: p_data => x_msg_data
3145: );

Line 3213: FND_MSG_PUB.initialize;

3209: OZF_Utility_PVT.debug_message(l_full_name||': start');
3210: END IF;
3211:
3212: IF FND_API.to_boolean(p_init_msg_list) THEN
3213: FND_MSG_PUB.initialize;
3214: END IF;
3215:
3216: IF NOT FND_API.compatible_api_call(
3217: l_api_version,

Line 3307: FND_MSG_PUB.count_and_get(

3303: IF FND_API.to_boolean(p_commit) THEN
3304: COMMIT;
3305: END IF;
3306:
3307: FND_MSG_PUB.count_and_get(
3308: p_encoded => FND_API.g_false,
3309: p_count => x_msg_count,
3310: p_data => x_msg_data
3311: );

Line 3321: FND_MSG_PUB.count_and_get (

3317: EXCEPTION
3318: WHEN FND_API.g_exc_error THEN
3319: ROLLBACK TO Delete_All_Line_Util;
3320: x_return_status := FND_API.g_ret_sts_error;
3321: FND_MSG_PUB.count_and_get (
3322: p_encoded => FND_API.g_false
3323: ,p_count => x_msg_count
3324: ,p_data => x_msg_data
3325: );

Line 3330: FND_MSG_PUB.count_and_get (

3326:
3327: WHEN FND_API.g_exc_unexpected_error THEN
3328: ROLLBACK TO Delete_All_Line_Util;
3329: x_return_status := FND_API.g_ret_sts_unexp_error ;
3330: FND_MSG_PUB.count_and_get (
3331: p_encoded => FND_API.g_false
3332: ,p_count => x_msg_count
3333: ,p_data => x_msg_data
3334: );

Line 3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3335:
3336: WHEN OTHERS THEN
3337: ROLLBACK TO Delete_All_Line_Util;
3338: x_return_status := FND_API.g_ret_sts_unexp_error ;
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3340: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.count_and_get(
3343: p_encoded => FND_API.g_false

Line 3340: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3336: WHEN OTHERS THEN
3337: ROLLBACK TO Delete_All_Line_Util;
3338: x_return_status := FND_API.g_ret_sts_unexp_error ;
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3340: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.count_and_get(
3343: p_encoded => FND_API.g_false
3344: ,p_count => x_msg_count

Line 3342: FND_MSG_PUB.count_and_get(

3338: x_return_status := FND_API.g_ret_sts_unexp_error ;
3339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3340: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.count_and_get(
3343: p_encoded => FND_API.g_false
3344: ,p_count => x_msg_count
3345: ,p_data => x_msg_data
3346: );

Line 3413: FND_MSG_PUB.initialize;

3409: OZF_Utility_PVT.debug_message(l_full_name||': start');
3410: END IF;
3411:
3412: IF FND_API.to_boolean(p_init_msg_list) THEN
3413: FND_MSG_PUB.initialize;
3414: END IF;
3415:
3416: IF NOT FND_API.compatible_api_call(
3417: l_api_version,

Line 3450: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3446: , X_Msg_Data => x_msg_data
3447: , X_access => l_access);
3448:
3449: IF l_access = 'N' THEN
3450: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3451: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3452: FND_MSG_PUB.add;
3453: END IF;
3454: RAISE FND_API.G_EXC_ERROR;

Line 3452: FND_MSG_PUB.add;

3448:
3449: IF l_access = 'N' THEN
3450: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3451: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3452: FND_MSG_PUB.add;
3453: END IF;
3454: RAISE FND_API.G_EXC_ERROR;
3455: END IF;
3456: EXIT;

Line 3516: FND_MSG_PUB.count_and_get(

3512: IF FND_API.to_boolean(p_commit) THEN
3513: COMMIT;
3514: END IF;
3515:
3516: FND_MSG_PUB.count_and_get(
3517: p_encoded => FND_API.g_false,
3518: p_count => x_msg_count,
3519: p_data => x_msg_data
3520: );

Line 3530: FND_MSG_PUB.count_and_get (

3526: EXCEPTION
3527: WHEN FND_API.g_exc_error THEN
3528: ROLLBACK TO Delete_Line_Util_Tbl;
3529: x_return_status := FND_API.g_ret_sts_error;
3530: FND_MSG_PUB.count_and_get (
3531: p_encoded => FND_API.g_false
3532: ,p_count => x_msg_count
3533: ,p_data => x_msg_data
3534: );

Line 3539: FND_MSG_PUB.count_and_get (

3535:
3536: WHEN FND_API.g_exc_unexpected_error THEN
3537: ROLLBACK TO Delete_Line_Util_Tbl;
3538: x_return_status := FND_API.g_ret_sts_unexp_error ;
3539: FND_MSG_PUB.count_and_get (
3540: p_encoded => FND_API.g_false
3541: ,p_count => x_msg_count
3542: ,p_data => x_msg_data
3543: );

Line 3548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3544:
3545: WHEN OTHERS THEN
3546: ROLLBACK TO Delete_Line_Util_Tbl;
3547: x_return_status := FND_API.g_ret_sts_unexp_error ;
3548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3549: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3550: END IF;
3551: FND_MSG_PUB.count_and_get(
3552: p_encoded => FND_API.g_false

Line 3549: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3545: WHEN OTHERS THEN
3546: ROLLBACK TO Delete_Line_Util_Tbl;
3547: x_return_status := FND_API.g_ret_sts_unexp_error ;
3548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3549: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3550: END IF;
3551: FND_MSG_PUB.count_and_get(
3552: p_encoded => FND_API.g_false
3553: ,p_count => x_msg_count

Line 3551: FND_MSG_PUB.count_and_get(

3547: x_return_status := FND_API.g_ret_sts_unexp_error ;
3548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3549: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3550: END IF;
3551: FND_MSG_PUB.count_and_get(
3552: p_encoded => FND_API.g_false
3553: ,p_count => x_msg_count
3554: ,p_data => x_msg_data
3555: );

Line 3634: FND_MSG_PUB.initialize;

3630: OZF_Utility_PVT.debug_message(l_full_name||': start');
3631: END IF;
3632:
3633: IF FND_API.to_boolean(p_init_msg_list) THEN
3634: FND_MSG_PUB.initialize;
3635: END IF;
3636:
3637: IF NOT FND_API.compatible_api_call(
3638: l_api_version,

Line 3672: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3668: , X_Msg_Data => x_msg_data
3669: , X_access => l_access);
3670:
3671: IF l_access = 'N' THEN
3672: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3673: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3674: FND_MSG_PUB.add;
3675: END IF;
3676: RAISE FND_API.G_EXC_ERROR;

Line 3674: FND_MSG_PUB.add;

3670:
3671: IF l_access = 'N' THEN
3672: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3673: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3674: FND_MSG_PUB.add;
3675: END IF;
3676: RAISE FND_API.G_EXC_ERROR;
3677: END IF;
3678: END IF;

Line 3740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3736: WHERE claim_line_util_id = p_line_util_id
3737: AND object_version_number = p_object_version;
3738:
3739: IF (SQL%NOTFOUND) THEN
3740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3741: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3742: FND_MSG_PUB.add;
3743: END IF;
3744: RAISE FND_API.g_exc_error;

Line 3742: FND_MSG_PUB.add;

3738:
3739: IF (SQL%NOTFOUND) THEN
3740: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3741: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3742: FND_MSG_PUB.add;
3743: END IF;
3744: RAISE FND_API.g_exc_error;
3745: END IF;
3746:

Line 3752: FND_MSG_PUB.count_and_get(

3748: IF FND_API.to_boolean(p_commit) THEN
3749: COMMIT;
3750: END IF;
3751:
3752: FND_MSG_PUB.count_and_get(
3753: p_encoded => FND_API.g_false,
3754: p_count => x_msg_count,
3755: p_data => x_msg_data
3756: );

Line 3766: FND_MSG_PUB.count_and_get(

3762: EXCEPTION
3763: WHEN FND_API.g_exc_error THEN
3764: ROLLBACK TO Delete_Line_Util;
3765: x_return_status := FND_API.g_ret_sts_error;
3766: FND_MSG_PUB.count_and_get(
3767: p_encoded => FND_API.g_false,
3768: p_count => x_msg_count,
3769: p_data => x_msg_data
3770: );

Line 3775: FND_MSG_PUB.count_and_get(

3771:
3772: WHEN FND_API.g_exc_unexpected_error THEN
3773: ROLLBACK TO Delete_Line_Util;
3774: x_return_status := FND_API.g_ret_sts_unexp_error ;
3775: FND_MSG_PUB.count_and_get(
3776: p_encoded => FND_API.g_false,
3777: p_count => x_msg_count,
3778: p_data => x_msg_data
3779: );

Line 3784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3780:
3781: WHEN OTHERS THEN
3782: ROLLBACK TO Delete_Line_Util;
3783: x_return_status := FND_API.g_ret_sts_unexp_error ;
3784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3785: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3786: END IF;
3787: FND_MSG_PUB.count_and_get(
3788: p_encoded => FND_API.g_false,

Line 3785: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3781: WHEN OTHERS THEN
3782: ROLLBACK TO Delete_Line_Util;
3783: x_return_status := FND_API.g_ret_sts_unexp_error ;
3784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3785: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3786: END IF;
3787: FND_MSG_PUB.count_and_get(
3788: p_encoded => FND_API.g_false,
3789: p_count => x_msg_count,

Line 3787: FND_MSG_PUB.count_and_get(

3783: x_return_status := FND_API.g_ret_sts_unexp_error ;
3784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3785: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3786: END IF;
3787: FND_MSG_PUB.count_and_get(
3788: p_encoded => FND_API.g_false,
3789: p_count => x_msg_count,
3790: p_data => x_msg_data
3791: );

Line 3854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3850: OPEN csr_line_util(p_line_util_rec.claim_line_util_id);
3851: FETCH csr_line_util INTO l_line_util_rec;
3852: IF csr_line_util%NOTFOUND THEN
3853: CLOSE csr_line_util;
3854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3855: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3856: FND_MSG_PUB.add;
3857: END IF;
3858: RAISE FND_API.g_exc_error;

Line 3856: FND_MSG_PUB.add;

3852: IF csr_line_util%NOTFOUND THEN
3853: CLOSE csr_line_util;
3854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3855: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3856: FND_MSG_PUB.add;
3857: END IF;
3858: RAISE FND_API.g_exc_error;
3859: END IF;
3860: CLOSE csr_line_util;

Line 4126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4122: ,from_name => NULL
4123: ,to_name => NULL
4124: );
4125: IF l_requirement_value = -99999 THEN
4126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
4128: FND_MSG_PUB.add;
4129: END IF;
4130: RAISE FND_API.g_exc_error;

Line 4128: FND_MSG_PUB.add;

4124: );
4125: IF l_requirement_value = -99999 THEN
4126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4127: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
4128: FND_MSG_PUB.add;
4129: END IF;
4130: RAISE FND_API.g_exc_error;
4131: END IF;
4132:

Line 4245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4241: ,from_name => NULL
4242: ,to_name => NULL
4243: );
4244: IF l_requirement_value = -99999 THEN
4245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4246: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
4247: FND_MSG_PUB.add;
4248: END IF;
4249: RAISE FND_API.g_exc_error;

Line 4247: FND_MSG_PUB.add;

4243: );
4244: IF l_requirement_value = -99999 THEN
4245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4246: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
4247: FND_MSG_PUB.add;
4248: END IF;
4249: RAISE FND_API.g_exc_error;
4250: END IF;
4251:

Line 4432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4428: x_return_status := FND_API.g_ret_sts_unexp_error ;
4429: WHEN OTHERS THEN
4430: ROLLBACK TO Settle_Claim;
4431: x_return_status := FND_API.g_ret_sts_unexp_error ;
4432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4434: END IF;
4435: END Settle_Claim;
4436:

Line 4433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4429: WHEN OTHERS THEN
4430: ROLLBACK TO Settle_Claim;
4431: x_return_status := FND_API.g_ret_sts_unexp_error ;
4432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4434: END IF;
4435: END Settle_Claim;
4436:
4437:

Line 4537: FND_MSG_PUB.initialize;

4533: OZF_Utility_PVT.debug_message(l_full_name||': start');
4534: END IF;
4535:
4536: IF FND_API.to_boolean(p_init_msg_list) THEN
4537: FND_MSG_PUB.initialize;
4538: END IF;
4539:
4540: IF NOT FND_API.compatible_api_call(
4541: l_api_version,

Line 4678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4674: OPEN csr_uom_code(l_line_tbl(l_counter).item_id);
4675: FETCH csr_uom_code INTO l_line_tbl(l_counter).quantity_uom;
4676: IF csr_uom_code%NOTFOUND THEN
4677: CLOSE csr_uom_code;
4678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4679: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
4680: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
4681: FND_MSG_PUB.ADD;
4682: END IF;

Line 4681: FND_MSG_PUB.ADD;

4677: CLOSE csr_uom_code;
4678: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4679: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
4680: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
4681: FND_MSG_PUB.ADD;
4682: END IF;
4683: RAISE FND_API.g_exc_unexpected_error;
4684: END IF;
4685: CLOSE csr_uom_code;

Line 4719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4715: OPEN csr_uom_code(l_line_tbl(l_counter).item_id);
4716: FETCH csr_uom_code INTO l_line_tbl(l_counter).quantity_uom;
4717: IF csr_uom_code%NOTFOUND THEN
4718: CLOSE csr_uom_code;
4719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4720: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
4721: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
4722: FND_MSG_PUB.ADD;
4723: END IF;

Line 4722: FND_MSG_PUB.ADD;

4718: CLOSE csr_uom_code;
4719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4720: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
4721: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
4722: FND_MSG_PUB.ADD;
4723: END IF;
4724: RAISE FND_API.g_exc_unexpected_error;
4725: END IF;
4726: CLOSE csr_uom_code;

Line 4851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4847: OZF_Utility_PVT.debug_message('Created Form: ' || l_claim_rec.created_from);
4848: OZF_Utility_PVT.debug_message('Amount: ' || l_claim_rec.amount);
4849: END IF;
4850:
4851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4852: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_SCAN_DATA_ERROR');
4853: FND_MSG_PUB.ADD;
4854: END IF;
4855:

Line 4853: FND_MSG_PUB.ADD;

4849: END IF;
4850:
4851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4852: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_SCAN_DATA_ERROR');
4853: FND_MSG_PUB.ADD;
4854: END IF;
4855:
4856: RAISE FND_API.g_exc_unexpected_error;
4857: ELSE

Line 4858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4854: END IF;
4855:
4856: RAISE FND_API.g_exc_unexpected_error;
4857: ELSE
4858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4859: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_REM_AMOUNT_LT_ZERO');
4860: FND_MSG_PUB.ADD;
4861: END IF;
4862: RAISE FND_API.g_exc_unexpected_error;

Line 4860: FND_MSG_PUB.ADD;

4856: RAISE FND_API.g_exc_unexpected_error;
4857: ELSE
4858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4859: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_REM_AMOUNT_LT_ZERO');
4860: FND_MSG_PUB.ADD;
4861: END IF;
4862: RAISE FND_API.g_exc_unexpected_error;
4863: END IF;
4864:

Line 4873: FND_MSG_PUB.count_and_get(

4869: IF FND_API.to_boolean(p_commit) THEN
4870: COMMIT;
4871: END IF;
4872:
4873: FND_MSG_PUB.count_and_get(
4874: p_encoded => FND_API.g_false,
4875: p_count => x_msg_count,
4876: p_data => x_msg_data
4877: );

Line 4887: FND_MSG_PUB.count_and_get (

4883: EXCEPTION
4884: WHEN FND_API.g_exc_error THEN
4885: ROLLBACK TO Create_Claim_For_Accruals;
4886: x_return_status := FND_API.g_ret_sts_error;
4887: FND_MSG_PUB.count_and_get (
4888: p_encoded => FND_API.g_false
4889: ,p_count => x_msg_count
4890: ,p_data => x_msg_data
4891: );

Line 4896: FND_MSG_PUB.count_and_get (

4892:
4893: WHEN FND_API.g_exc_unexpected_error THEN
4894: ROLLBACK TO Create_Claim_For_Accruals;
4895: x_return_status := FND_API.g_ret_sts_unexp_error ;
4896: FND_MSG_PUB.count_and_get (
4897: p_encoded => FND_API.g_false
4898: ,p_count => x_msg_count
4899: ,p_data => x_msg_data
4900: );

Line 4905: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4901:
4902: WHEN OTHERS THEN
4903: ROLLBACK TO Create_Claim_For_Accruals;
4904: x_return_status := FND_API.g_ret_sts_unexp_error ;
4905: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4906: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4907: END IF;
4908: FND_MSG_PUB.count_and_get(
4909: p_encoded => FND_API.g_false

Line 4906: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4902: WHEN OTHERS THEN
4903: ROLLBACK TO Create_Claim_For_Accruals;
4904: x_return_status := FND_API.g_ret_sts_unexp_error ;
4905: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4906: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4907: END IF;
4908: FND_MSG_PUB.count_and_get(
4909: p_encoded => FND_API.g_false
4910: ,p_count => x_msg_count

Line 4908: FND_MSG_PUB.count_and_get(

4904: x_return_status := FND_API.g_ret_sts_unexp_error ;
4905: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4906: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4907: END IF;
4908: FND_MSG_PUB.count_and_get(
4909: p_encoded => FND_API.g_false
4910: ,p_count => x_msg_count
4911: ,p_data => x_msg_data
4912: );

Line 4974: FND_MSG_PUB.initialize;

4970: OZF_Utility_PVT.debug_message(l_full_name||': start');
4971: END IF;
4972:
4973: IF FND_API.to_boolean(p_init_msg_list) THEN
4974: FND_MSG_PUB.initialize;
4975: END IF;
4976:
4977: IF NOT FND_API.compatible_api_call(
4978: l_api_version,

Line 5036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5032: -- and raise error in other cases
5033: IF l_claim_rec.source_object_class = OZF_RESALE_COMMON_PVT.G_BATCH_OBJECT_CLASS THEN
5034: l_close_claim_flag := 'F';
5035: ELSE
5036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5037: OPEN csr_party_name(p_claim_rec.cust_account_id);
5038: FETCH csr_party_name INTO l_party_name;
5039: CLOSE csr_party_name;
5040:

Line 5043: FND_MSG_PUB.ADD;

5039: CLOSE csr_party_name;
5040:
5041: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_NO_TRADE_PROFILE');
5042: FND_MESSAGE.Set_Token('CUST_NAME', l_party_name);
5043: FND_MSG_PUB.ADD;
5044: END IF;
5045: RAISE FND_API.g_exc_unexpected_error;
5046: END IF;
5047: END IF;

Line 5097: FND_MSG_PUB.count_and_get(

5093: IF FND_API.to_boolean(p_commit) THEN
5094: COMMIT;
5095: END IF;
5096:
5097: FND_MSG_PUB.count_and_get(
5098: p_encoded => FND_API.g_false,
5099: p_count => x_msg_count,
5100: p_data => x_msg_data
5101: );

Line 5111: FND_MSG_PUB.count_and_get (

5107: EXCEPTION
5108: WHEN FND_API.g_exc_error THEN
5109: ROLLBACK TO Pay_Claim_For_Accruals;
5110: x_return_status := FND_API.g_ret_sts_error;
5111: FND_MSG_PUB.count_and_get (
5112: p_encoded => FND_API.g_false
5113: ,p_count => x_msg_count
5114: ,p_data => x_msg_data
5115: );

Line 5120: FND_MSG_PUB.count_and_get (

5116:
5117: WHEN FND_API.g_exc_unexpected_error THEN
5118: ROLLBACK TO Pay_Claim_For_Accruals;
5119: x_return_status := FND_API.g_ret_sts_unexp_error ;
5120: FND_MSG_PUB.count_and_get (
5121: p_encoded => FND_API.g_false
5122: ,p_count => x_msg_count
5123: ,p_data => x_msg_data
5124: );

Line 5129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5125:
5126: WHEN OTHERS THEN
5127: ROLLBACK TO Pay_Claim_For_Accruals;
5128: x_return_status := FND_API.g_ret_sts_unexp_error ;
5129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5131: END IF;
5132: FND_MSG_PUB.count_and_get(
5133: p_encoded => FND_API.g_false

Line 5130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5126: WHEN OTHERS THEN
5127: ROLLBACK TO Pay_Claim_For_Accruals;
5128: x_return_status := FND_API.g_ret_sts_unexp_error ;
5129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5131: END IF;
5132: FND_MSG_PUB.count_and_get(
5133: p_encoded => FND_API.g_false
5134: ,p_count => x_msg_count

Line 5132: FND_MSG_PUB.count_and_get(

5128: x_return_status := FND_API.g_ret_sts_unexp_error ;
5129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5131: END IF;
5132: FND_MSG_PUB.count_and_get(
5133: p_encoded => FND_API.g_false
5134: ,p_count => x_msg_count
5135: ,p_data => x_msg_data
5136: );

Line 5236: FND_MSG_PUB.initialize;

5232: OZF_Utility_PVT.debug_message(l_full_name||': start');
5233: END IF;
5234:
5235: IF FND_API.to_boolean(p_init_msg_list) THEN
5236: FND_MSG_PUB.initialize;
5237: END IF;
5238:
5239: IF NOT FND_API.compatible_api_call(
5240: l_api_version,

Line 5256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5252: OPEN csr_claim_info(p_claim_id);
5253: FETCH csr_claim_info INTO l_cust_account_id, l_total_amount,l_claim_class;
5254: IF csr_claim_info%NOTFOUND THEN
5255: CLOSE csr_claim_info;
5256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5257: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ID_NOT_EXIST');
5258: FND_MESSAGE.Set_Token('CLAIM_ID', p_claim_id);
5259: FND_MSG_PUB.ADD;
5260: END IF;

Line 5259: FND_MSG_PUB.ADD;

5255: CLOSE csr_claim_info;
5256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5257: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ID_NOT_EXIST');
5258: FND_MESSAGE.Set_Token('CLAIM_ID', p_claim_id);
5259: FND_MSG_PUB.ADD;
5260: END IF;
5261: RAISE FND_API.g_exc_unexpected_error;
5262: END IF;
5263: CLOSE csr_claim_info;

Line 5359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5355: OPEN csr_uom_code(l_line_tbl(l_counter).item_id);
5356: FETCH csr_uom_code INTO l_line_tbl(l_counter).quantity_uom;
5357: IF csr_uom_code%NOTFOUND THEN
5358: CLOSE csr_uom_code;
5359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5360: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
5361: FND_MESSAGE.Set_Token('ITEM_ID', l_product_id);
5362: FND_MSG_PUB.ADD;
5363: END IF;

Line 5362: FND_MSG_PUB.ADD;

5358: CLOSE csr_uom_code;
5359: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5360: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
5361: FND_MESSAGE.Set_Token('ITEM_ID', l_product_id);
5362: FND_MSG_PUB.ADD;
5363: END IF;
5364: RAISE FND_API.g_exc_unexpected_error;
5365: END IF;
5366: CLOSE csr_uom_code;

Line 5462: FND_MSG_PUB.count_and_get(

5458: IF FND_API.to_boolean(p_commit) THEN
5459: COMMIT;
5460: END IF;
5461:
5462: FND_MSG_PUB.count_and_get(
5463: p_encoded => FND_API.g_false,
5464: p_count => x_msg_count,
5465: p_data => x_msg_data
5466: );

Line 5476: FND_MSG_PUB.count_and_get (

5472: EXCEPTION
5473: WHEN FND_API.g_exc_error THEN
5474: ROLLBACK TO Asso_Accruals_To_Claim;
5475: x_return_status := FND_API.g_ret_sts_error;
5476: FND_MSG_PUB.count_and_get (
5477: p_encoded => FND_API.g_false
5478: ,p_count => x_msg_count
5479: ,p_data => x_msg_data
5480: );

Line 5485: FND_MSG_PUB.count_and_get (

5481:
5482: WHEN FND_API.g_exc_unexpected_error THEN
5483: ROLLBACK TO Asso_Accruals_To_Claim;
5484: x_return_status := FND_API.g_ret_sts_unexp_error ;
5485: FND_MSG_PUB.count_and_get (
5486: p_encoded => FND_API.g_false
5487: ,p_count => x_msg_count
5488: ,p_data => x_msg_data
5489: );

Line 5494: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5490:
5491: WHEN OTHERS THEN
5492: ROLLBACK TO Asso_Accruals_To_Claim;
5493: x_return_status := FND_API.g_ret_sts_unexp_error ;
5494: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5495: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5496: END IF;
5497: FND_MSG_PUB.count_and_get(
5498: p_encoded => FND_API.g_false

Line 5495: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5491: WHEN OTHERS THEN
5492: ROLLBACK TO Asso_Accruals_To_Claim;
5493: x_return_status := FND_API.g_ret_sts_unexp_error ;
5494: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5495: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5496: END IF;
5497: FND_MSG_PUB.count_and_get(
5498: p_encoded => FND_API.g_false
5499: ,p_count => x_msg_count

Line 5497: FND_MSG_PUB.count_and_get(

5493: x_return_status := FND_API.g_ret_sts_unexp_error ;
5494: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5495: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5496: END IF;
5497: FND_MSG_PUB.count_and_get(
5498: p_encoded => FND_API.g_false
5499: ,p_count => x_msg_count
5500: ,p_data => x_msg_data
5501: );

Line 5585: FND_MSG_PUB.initialize;

5581: OZF_Utility_PVT.debug_message(l_full_name||': start');
5582: END IF;
5583:
5584: IF FND_API.to_boolean(p_init_msg_list) THEN
5585: FND_MSG_PUB.initialize;
5586: END IF;
5587:
5588: IF NOT FND_API.compatible_api_call(
5589: l_api_version,

Line 5624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5620: ,l_funds_util_flt.prorate_earnings_flag;
5621:
5622: IF csr_line_info%NOTFOUND THEN
5623: CLOSE csr_line_info;
5624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5625: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5626: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5627: FND_MSG_PUB.ADD;
5628: END IF;

Line 5627: FND_MSG_PUB.ADD;

5623: CLOSE csr_line_info;
5624: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5625: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5626: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5627: FND_MSG_PUB.ADD;
5628: END IF;
5629: RAISE FND_API.g_exc_unexpected_error;
5630: END IF;
5631: CLOSE csr_line_info;

Line 5638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5634: FETCH csr_sum_util_amounts INTO l_funds_util_flt.old_total_amount;
5635:
5636: IF csr_sum_util_amounts%NOTFOUND THEN
5637: CLOSE csr_line_info;
5638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5639: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5640: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5641: FND_MSG_PUB.ADD;
5642: END IF;

Line 5641: FND_MSG_PUB.ADD;

5637: CLOSE csr_line_info;
5638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5639: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5640: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5641: FND_MSG_PUB.ADD;
5642: END IF;
5643: RAISE FND_API.g_exc_unexpected_error;
5644: END IF;
5645: CLOSE csr_sum_util_amounts;

Line 5652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5648: FETCH csr_sum_scan_units INTO l_funds_util_flt.old_total_units;
5649:
5650: IF csr_sum_scan_units%NOTFOUND THEN
5651: CLOSE csr_line_info;
5652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5653: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5654: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5655: FND_MSG_PUB.ADD;
5656: END IF;

Line 5655: FND_MSG_PUB.ADD;

5651: CLOSE csr_line_info;
5652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5653: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_LINEID_NOT_EXIST');
5654: FND_MESSAGE.Set_Token('LINE_ID', p_claim_line_id);
5655: FND_MSG_PUB.ADD;
5656: END IF;
5657: RAISE FND_API.g_exc_unexpected_error;
5658: END IF;
5659: CLOSE csr_sum_scan_units;

Line 5686: FND_MSG_PUB.count_and_get(

5682: IF FND_API.to_boolean(p_commit) THEN
5683: COMMIT;
5684: END IF;
5685:
5686: FND_MSG_PUB.count_and_get(
5687: p_encoded => FND_API.g_false,
5688: p_count => x_msg_count,
5689: p_data => x_msg_data
5690: );

Line 5700: FND_MSG_PUB.count_and_get (

5696: EXCEPTION
5697: WHEN FND_API.g_exc_error THEN
5698: ROLLBACK TO Asso_Accruals_To_Claim_Line;
5699: x_return_status := FND_API.g_ret_sts_error;
5700: FND_MSG_PUB.count_and_get (
5701: p_encoded => FND_API.g_false
5702: ,p_count => x_msg_count
5703: ,p_data => x_msg_data
5704: );

Line 5709: FND_MSG_PUB.count_and_get (

5705:
5706: WHEN FND_API.g_exc_unexpected_error THEN
5707: ROLLBACK TO Asso_Accruals_To_Claim_Line;
5708: x_return_status := FND_API.g_ret_sts_unexp_error ;
5709: FND_MSG_PUB.count_and_get (
5710: p_encoded => FND_API.g_false
5711: ,p_count => x_msg_count
5712: ,p_data => x_msg_data
5713: );

Line 5718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5714:
5715: WHEN OTHERS THEN
5716: ROLLBACK TO Asso_Accruals_To_Claim_Line;
5717: x_return_status := FND_API.g_ret_sts_unexp_error ;
5718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5720: END IF;
5721: FND_MSG_PUB.count_and_get(
5722: p_encoded => FND_API.g_false

Line 5719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5715: WHEN OTHERS THEN
5716: ROLLBACK TO Asso_Accruals_To_Claim_Line;
5717: x_return_status := FND_API.g_ret_sts_unexp_error ;
5718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5720: END IF;
5721: FND_MSG_PUB.count_and_get(
5722: p_encoded => FND_API.g_false
5723: ,p_count => x_msg_count

Line 5721: FND_MSG_PUB.count_and_get(

5717: x_return_status := FND_API.g_ret_sts_unexp_error ;
5718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5720: END IF;
5721: FND_MSG_PUB.count_and_get(
5722: p_encoded => FND_API.g_false
5723: ,p_count => x_msg_count
5724: ,p_data => x_msg_data
5725: );

Line 5904: FND_MSG_PUB.initialize;

5900: OZF_Utility_PVT.debug_message(l_full_name||': start');
5901: END IF;
5902:
5903: IF FND_API.to_boolean(p_init_msg_list) THEN
5904: FND_MSG_PUB.initialize;
5905: END IF;
5906:
5907: IF NOT FND_API.compatible_api_call(
5908: l_api_version,

Line 5956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5952: l_vendor_id := l_cust_trade_profile.vendor_id;
5953: l_vendor_site_id := l_cust_trade_profile.vendor_site_id;
5954: ELSE
5955: /*
5956: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5957: OPEN csr_party_name(l_cust_account_id);
5958: FETCH csr_party_name INTO l_party_name;
5959: CLOSE csr_party_name;
5960:

Line 5963: FND_MSG_PUB.ADD;

5959: CLOSE csr_party_name;
5960:
5961: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_NO_TRADE_PROFILE');
5962: FND_MESSAGE.Set_Token('CUST_NAME', l_party_name);
5963: FND_MSG_PUB.ADD;
5964: END IF;
5965: RAISE FND_API.g_exc_unexpected_error;
5966: */
5967: -- do not settle claim if trade profile does not exists

Line 6062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6058: ,from_name => NULL
6059: ,to_name => NULL
6060: );
6061: IF l_quantity = -99999 THEN
6062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6063: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
6064: FND_MSG_PUB.add;
6065: END IF;
6066: RAISE FND_API.g_exc_error;

Line 6064: FND_MSG_PUB.add;

6060: );
6061: IF l_quantity = -99999 THEN
6062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6063: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
6064: FND_MSG_PUB.add;
6065: END IF;
6066: RAISE FND_API.g_exc_error;
6067: END IF;
6068:

Line 6207: FND_MSG_PUB.count_and_get(

6203: IF FND_API.to_boolean(p_commit) THEN
6204: COMMIT;
6205: END IF;
6206:
6207: FND_MSG_PUB.count_and_get(
6208: p_encoded => FND_API.g_false,
6209: p_count => x_msg_count,
6210: p_data => x_msg_data
6211: );

Line 6221: FND_MSG_PUB.count_and_get (

6217: EXCEPTION
6218: WHEN FND_API.g_exc_error THEN
6219: ROLLBACK TO Initiate_Batch_Payment;
6220: x_return_status := FND_API.g_ret_sts_error;
6221: FND_MSG_PUB.count_and_get (
6222: p_encoded => FND_API.g_false
6223: ,p_count => x_msg_count
6224: ,p_data => x_msg_data
6225: );

Line 6230: FND_MSG_PUB.count_and_get (

6226:
6227: WHEN FND_API.g_exc_unexpected_error THEN
6228: ROLLBACK TO Initiate_Batch_Payment;
6229: x_return_status := FND_API.g_ret_sts_unexp_error ;
6230: FND_MSG_PUB.count_and_get (
6231: p_encoded => FND_API.g_false
6232: ,p_count => x_msg_count
6233: ,p_data => x_msg_data
6234: );

Line 6239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6235:
6236: WHEN OTHERS THEN
6237: ROLLBACK TO Initiate_Batch_Payment;
6238: x_return_status := FND_API.g_ret_sts_unexp_error ;
6239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6240: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6241: END IF;
6242: FND_MSG_PUB.count_and_get(
6243: p_encoded => FND_API.g_false

Line 6240: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6236: WHEN OTHERS THEN
6237: ROLLBACK TO Initiate_Batch_Payment;
6238: x_return_status := FND_API.g_ret_sts_unexp_error ;
6239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6240: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6241: END IF;
6242: FND_MSG_PUB.count_and_get(
6243: p_encoded => FND_API.g_false
6244: ,p_count => x_msg_count

Line 6242: FND_MSG_PUB.count_and_get(

6238: x_return_status := FND_API.g_ret_sts_unexp_error ;
6239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6240: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6241: END IF;
6242: FND_MSG_PUB.count_and_get(
6243: p_encoded => FND_API.g_false
6244: ,p_count => x_msg_count
6245: ,p_data => x_msg_data
6246: );

Line 6342: FND_MSG_PUB.initialize;

6338: OZF_Utility_PVT.debug_message(l_full_name||': start');
6339: END IF;
6340:
6341: IF FND_API.to_boolean(p_init_msg_list) THEN
6342: FND_MSG_PUB.initialize;
6343: END IF;
6344:
6345: IF NOT FND_API.compatible_api_call(
6346: l_api_version,

Line 6367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6363:
6364: IF l_adjustment_flag = 'N' THEN
6365: -- As of 15-JAN-2003, adjustment workflow is not supported. An error is raised
6366: -- if the offer is not auto-adjustable.
6367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6368: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_ADJUST_SCANUNIT');
6369: FND_MSG_PUB.add;
6370: END IF;
6371: x_return_status := FND_API.g_ret_sts_error;

Line 6369: FND_MSG_PUB.add;

6365: -- As of 15-JAN-2003, adjustment workflow is not supported. An error is raised
6366: -- if the offer is not auto-adjustable.
6367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6368: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_ADJUST_SCANUNIT');
6369: FND_MSG_PUB.add;
6370: END IF;
6371: x_return_status := FND_API.g_ret_sts_error;
6372: RETURN;
6373:

Line 6377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6373:
6374: /*
6375: -- Adjustment workflow can be invoked only when profile is set
6376: IF NVL(fnd_profile.value('OZF_CLAIM_SCAN_ADJUST_WORKFLOW'),'N') <> 'Y' THEN
6377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6378: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NO_ADJUST_WORKFLOW');
6379: FND_MSG_PUB.add;
6380: END IF;
6381: x_return_status := FND_API.g_ret_sts_error;

Line 6379: FND_MSG_PUB.add;

6375: -- Adjustment workflow can be invoked only when profile is set
6376: IF NVL(fnd_profile.value('OZF_CLAIM_SCAN_ADJUST_WORKFLOW'),'N') <> 'Y' THEN
6377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6378: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_NO_ADJUST_WORKFLOW');
6379: FND_MSG_PUB.add;
6380: END IF;
6381: x_return_status := FND_API.g_ret_sts_error;
6382: RETURN;
6383: END IF;

Line 6391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6387: FETCH csr_count_workflow INTO l_count_workflow;
6388: CLOSE csr_count_workflow;
6389:
6390: IF l_count_workflow > 0 THEN
6391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6392: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MULTI_ADJ_WORKFLOW');
6393: FND_MSG_PUB.add;
6394: END IF;
6395: x_return_status := FND_API.g_ret_sts_error;

Line 6393: FND_MSG_PUB.add;

6389:
6390: IF l_count_workflow > 0 THEN
6391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6392: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MULTI_ADJ_WORKFLOW');
6393: FND_MSG_PUB.add;
6394: END IF;
6395: x_return_status := FND_API.g_ret_sts_error;
6396: RETURN;
6397: END IF;

Line 6407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6403: IF p_funds_util_flt.activity_id IS NULL OR
6404: p_funds_util_flt.activity_type IS NULL OR
6405: p_funds_util_flt.activity_type <> 'OFFR'
6406: THEN
6407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6408: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NO_OFFER');
6409: FND_MSG_PUB.add;
6410: END IF;
6411: x_return_status := FND_API.g_ret_sts_error;

Line 6409: FND_MSG_PUB.add;

6405: p_funds_util_flt.activity_type <> 'OFFR'
6406: THEN
6407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6408: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NO_OFFER');
6409: FND_MSG_PUB.add;
6410: END IF;
6411: x_return_status := FND_API.g_ret_sts_error;
6412: RETURN;
6413: END IF;

Line 6444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6440: CLOSE csr_party_pay_unearned;
6441: END IF;
6442:
6443: IF l_un_earned_pay_allow_to = 'DISALLOW' THEN
6444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6445: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NOT_ALLOWED');
6446: FND_MSG_PUB.add;
6447: END IF;
6448: x_return_status := FND_API.g_ret_sts_error;

Line 6446: FND_MSG_PUB.add;

6442:
6443: IF l_un_earned_pay_allow_to = 'DISALLOW' THEN
6444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6445: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NOT_ALLOWED');
6446: FND_MSG_PUB.add;
6447: END IF;
6448: x_return_status := FND_API.g_ret_sts_error;
6449: RETURN;
6450: END IF;

Line 6465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6461:
6462: IF l_un_earned_pay_allow_to IS NULL OR
6463: l_un_earned_pay_allow_to = 'ALLOW_SELECTED'
6464: THEN
6465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6466: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NOT_ALLOWED');
6467: FND_MSG_PUB.add;
6468: END IF;
6469: x_return_status := FND_API.g_ret_sts_error;

Line 6467: FND_MSG_PUB.add;

6463: l_un_earned_pay_allow_to = 'ALLOW_SELECTED'
6464: THEN
6465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6466: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_NOT_ALLOWED');
6467: FND_MSG_PUB.add;
6468: END IF;
6469: x_return_status := FND_API.g_ret_sts_error;
6470: RETURN;
6471: END IF;

Line 6493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6489: l_over_paid_amount := p_funds_util_flt.total_amount - l_total_amt_remaining;
6490:
6491: IF l_over_paid_amount > l_threshold_amount THEN
6492: IF l_un_earned_pay_thold_flag IS NULL OR l_un_earned_pay_thold_flag <> 'T' THEN
6493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6494: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_OVER_THOLD');
6495: FND_MSG_PUB.add;
6496: END IF;
6497: x_return_status := FND_API.g_ret_sts_error;

Line 6495: FND_MSG_PUB.add;

6491: IF l_over_paid_amount > l_threshold_amount THEN
6492: IF l_un_earned_pay_thold_flag IS NULL OR l_un_earned_pay_thold_flag <> 'T' THEN
6493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6494: FND_MESSAGE.set_name('OZF', 'OZF_EARN_OVERPAY_OVER_THOLD');
6495: FND_MSG_PUB.add;
6496: END IF;
6497: x_return_status := FND_API.g_ret_sts_error;
6498: RETURN;
6499: END IF;

Line 6554: FND_MSG_PUB.initialize;

6550: OZF_Utility_PVT.debug_message(l_full_name||': start');
6551: END IF;
6552:
6553: IF FND_API.to_boolean(p_init_msg_list) THEN
6554: FND_MSG_PUB.initialize;
6555: END IF;
6556:
6557: IF NOT FND_API.compatible_api_call(
6558: l_api_version,

Line 6574: FND_MSG_PUB.count_and_get(

6570: IF FND_API.to_boolean(p_commit) THEN
6571: COMMIT;
6572: END IF;
6573:
6574: FND_MSG_PUB.count_and_get(
6575: p_encoded => FND_API.g_false,
6576: p_count => x_msg_count,
6577: p_data => x_msg_data
6578: );

Line 6588: FND_MSG_PUB.count_and_get (

6584: EXCEPTION
6585: WHEN FND_API.g_exc_error THEN
6586: ROLLBACK TO Create_Group_Line_Util;
6587: x_return_status := FND_API.g_ret_sts_error;
6588: FND_MSG_PUB.count_and_get (
6589: p_encoded => FND_API.g_false
6590: ,p_count => x_msg_count
6591: ,p_data => x_msg_data
6592: );

Line 6597: FND_MSG_PUB.count_and_get (

6593:
6594: WHEN FND_API.g_exc_unexpected_error THEN
6595: ROLLBACK TO Create_Group_Line_Util;
6596: x_return_status := FND_API.g_ret_sts_unexp_error ;
6597: FND_MSG_PUB.count_and_get (
6598: p_encoded => FND_API.g_false
6599: ,p_count => x_msg_count
6600: ,p_data => x_msg_data
6601: );

Line 6606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6602:
6603: WHEN OTHERS THEN
6604: ROLLBACK TO Create_Group_Line_Util;
6605: x_return_status := FND_API.g_ret_sts_unexp_error ;
6606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6607: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6608: END IF;
6609: FND_MSG_PUB.count_and_get(
6610: p_encoded => FND_API.g_false

Line 6607: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6603: WHEN OTHERS THEN
6604: ROLLBACK TO Create_Group_Line_Util;
6605: x_return_status := FND_API.g_ret_sts_unexp_error ;
6606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6607: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6608: END IF;
6609: FND_MSG_PUB.count_and_get(
6610: p_encoded => FND_API.g_false
6611: ,p_count => x_msg_count

Line 6609: FND_MSG_PUB.count_and_get(

6605: x_return_status := FND_API.g_ret_sts_unexp_error ;
6606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6607: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6608: END IF;
6609: FND_MSG_PUB.count_and_get(
6610: p_encoded => FND_API.g_false
6611: ,p_count => x_msg_count
6612: ,p_data => x_msg_data
6613: );

Line 6888: FND_MSG_PUB.initialize;

6884: OZF_Utility_PVT.debug_message(l_full_name||': start');
6885: END IF;
6886:
6887: IF FND_API.to_boolean(p_init_msg_list) THEN
6888: FND_MSG_PUB.initialize;
6889: END IF;
6890:
6891: IF NOT FND_API.compatible_api_call(
6892: l_api_version,

Line 6929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6925: OZF_Utility_PVT.debug_message(l_full_name||'G_CLAIM_CURRENCY '||G_CLAIM_CURRENCY);
6926: END IF;
6927:
6928: IF l_claim_status <> 'OPEN' THEN
6929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6930: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ASSO_NOT_OPEN');
6931: FND_MSG_PUB.add;
6932: END IF;
6933: RAISE FND_API.g_exc_error;

Line 6931: FND_MSG_PUB.add;

6927:
6928: IF l_claim_status <> 'OPEN' THEN
6929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6930: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ASSO_NOT_OPEN');
6931: FND_MSG_PUB.add;
6932: END IF;
6933: RAISE FND_API.g_exc_error;
6934: END IF;
6935:

Line 6959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6955: -- Allow association only in same currency as claim currency,
6956: -- or either accrual or claim currency must be in functional currency
6957: IF l_funds_util_flt.utiz_currency_code <> G_FUNCTIONAL_CURRENCY THEN
6958: IF l_funds_util_flt.utiz_currency_code is not null AND l_funds_util_flt.utiz_currency_code <> G_CLAIM_CURRENCY THEN
6959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6960: FND_MESSAGE.set_name('OZF', 'OZF_CROSS_CURR_UTILIZATION');
6961: FND_MSG_PUB.add;
6962: END IF;
6963: RAISE FND_API.g_exc_error;

Line 6961: FND_MSG_PUB.add;

6957: IF l_funds_util_flt.utiz_currency_code <> G_FUNCTIONAL_CURRENCY THEN
6958: IF l_funds_util_flt.utiz_currency_code is not null AND l_funds_util_flt.utiz_currency_code <> G_CLAIM_CURRENCY THEN
6959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6960: FND_MESSAGE.set_name('OZF', 'OZF_CROSS_CURR_UTILIZATION');
6961: FND_MSG_PUB.add;
6962: END IF;
6963: RAISE FND_API.g_exc_error;
6964: END IF;
6965: END IF;

Line 7069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7065: ,from_name => NULL
7066: ,to_name => NULL
7067: );
7068: IF l_util_quantity = -99999 THEN
7069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7070: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
7071: FND_MSG_PUB.add;
7072: END IF;
7073: RAISE FND_API.g_exc_error;

Line 7071: FND_MSG_PUB.add;

7067: );
7068: IF l_util_quantity = -99999 THEN
7069: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7070: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
7071: FND_MSG_PUB.add;
7072: END IF;
7073: RAISE FND_API.g_exc_error;
7074: END IF;
7075: ELSE

Line 7096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7092: ,from_name => NULL
7093: ,to_name => NULL
7094: );
7095: IF l_util_quantity = -99999 THEN
7096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7097: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
7098: FND_MSG_PUB.add;
7099: END IF;
7100: RAISE FND_API.g_exc_error;

Line 7098: FND_MSG_PUB.add;

7094: );
7095: IF l_util_quantity = -99999 THEN
7096: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7097: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CANT_CONVERT_UOM');
7098: FND_MSG_PUB.add;
7099: END IF;
7100: RAISE FND_API.g_exc_error;
7101: END IF;
7102: ELSE

Line 7169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7165: FETCH csr_offer_status INTO l_offer_status;
7166: CLOSE csr_offer_status;
7167:
7168: IF l_offer_status = 'COMPLETED' THEN
7169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7170: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ASSO_COMPLETE_OFFER');
7171: FND_MSG_PUB.add;
7172: END IF;
7173: RAISE FND_API.g_exc_error;

Line 7171: FND_MSG_PUB.add;

7167:
7168: IF l_offer_status = 'COMPLETED' THEN
7169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7170: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ASSO_COMPLETE_OFFER');
7171: FND_MSG_PUB.add;
7172: END IF;
7173: RAISE FND_API.g_exc_error;
7174: END IF;
7175: END IF;

Line 7388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7384: NULL;
7385: ELSE
7386: IF (l_cre_total_amount < 0 and l_total_amt_rem >0)
7387: THEN
7388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7389: FND_MESSAGE.set_name('OZF', 'OZF_ASSO_NEG_AMT');
7390: FND_MSG_PUB.add;
7391: END IF;
7392: RAISE FND_API.g_exc_error;

Line 7390: FND_MSG_PUB.add;

7386: IF (l_cre_total_amount < 0 and l_total_amt_rem >0)
7387: THEN
7388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7389: FND_MESSAGE.set_name('OZF', 'OZF_ASSO_NEG_AMT');
7390: FND_MSG_PUB.add;
7391: END IF;
7392: RAISE FND_API.g_exc_error;
7393: END IF;
7394: END IF;

Line 7425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7421: /* When amount remaining is 0, offer must be able to create accruals */
7422: IF l_funds_util_flt.offer_type IS NULL OR
7423: l_funds_util_flt.offer_type NOT IN ('ACCRUAL','DEAL','LUMPSUM','NET_ACCRUAL','VOLUME_OFFER', 'SCAN_DATA')
7424: THEN
7425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7426: FND_MESSAGE.set_name('OZF', 'OZF_EARN_AVAIL_AMT_ZERO');
7427: FND_MSG_PUB.add;
7428: END IF;
7429: RAISE FND_API.g_exc_error;

Line 7427: FND_MSG_PUB.add;

7423: l_funds_util_flt.offer_type NOT IN ('ACCRUAL','DEAL','LUMPSUM','NET_ACCRUAL','VOLUME_OFFER', 'SCAN_DATA')
7424: THEN
7425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7426: FND_MESSAGE.set_name('OZF', 'OZF_EARN_AVAIL_AMT_ZERO');
7427: FND_MSG_PUB.add;
7428: END IF;
7429: RAISE FND_API.g_exc_error;
7430: END IF;
7431: END IF;

Line 7855: FND_MSG_PUB.count_and_get(

7851: IF FND_API.to_boolean(p_commit) THEN
7852: COMMIT;
7853: END IF;
7854:
7855: FND_MSG_PUB.count_and_get(
7856: p_encoded => FND_API.g_false,
7857: p_count => x_msg_count,
7858: p_data => x_msg_data
7859: );

Line 7869: FND_MSG_PUB.count_and_get (

7865: EXCEPTION
7866: WHEN FND_API.g_exc_error THEN
7867: ROLLBACK TO Update_Group_Line_Util;
7868: x_return_status := FND_API.g_ret_sts_error;
7869: FND_MSG_PUB.count_and_get (
7870: p_encoded => FND_API.g_false
7871: ,p_count => x_msg_count
7872: ,p_data => x_msg_data
7873: );

Line 7878: FND_MSG_PUB.count_and_get (

7874:
7875: WHEN FND_API.g_exc_unexpected_error THEN
7876: ROLLBACK TO Update_Group_Line_Util;
7877: x_return_status := FND_API.g_ret_sts_unexp_error ;
7878: FND_MSG_PUB.count_and_get (
7879: p_encoded => FND_API.g_false
7880: ,p_count => x_msg_count
7881: ,p_data => x_msg_data
7882: );

Line 7887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

7883:
7884: WHEN OTHERS THEN
7885: ROLLBACK TO Update_Group_Line_Util;
7886: x_return_status := FND_API.g_ret_sts_unexp_error ;
7887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7888: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7889: END IF;
7890: FND_MSG_PUB.count_and_get(
7891: p_encoded => FND_API.g_false

Line 7888: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

7884: WHEN OTHERS THEN
7885: ROLLBACK TO Update_Group_Line_Util;
7886: x_return_status := FND_API.g_ret_sts_unexp_error ;
7887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7888: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7889: END IF;
7890: FND_MSG_PUB.count_and_get(
7891: p_encoded => FND_API.g_false
7892: ,p_count => x_msg_count

Line 7890: FND_MSG_PUB.count_and_get(

7886: x_return_status := FND_API.g_ret_sts_unexp_error ;
7887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7888: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7889: END IF;
7890: FND_MSG_PUB.count_and_get(
7891: p_encoded => FND_API.g_false
7892: ,p_count => x_msg_count
7893: ,p_data => x_msg_data
7894: );

Line 7957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7953: DELETE FROM ozf_claim_lines_util_all
7954: WHERE claim_line_util_id = p_line_util_rec.claim_line_util_id;
7955:
7956: IF (SQL%NOTFOUND) THEN
7957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7958: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
7959: FND_MSG_PUB.add;
7960: END IF;
7961: RAISE FND_API.g_exc_error;

Line 7959: FND_MSG_PUB.add;

7955:
7956: IF (SQL%NOTFOUND) THEN
7957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7958: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
7959: FND_MSG_PUB.add;
7960: END IF;
7961: RAISE FND_API.g_exc_error;
7962: END IF;
7963:

Line 7965: FND_MSG_PUB.count_and_get(

7961: RAISE FND_API.g_exc_error;
7962: END IF;
7963:
7964: -------------------- finish --------------------------
7965: FND_MSG_PUB.count_and_get(
7966: p_encoded => FND_API.g_false,
7967: p_count => x_msg_count,
7968: p_data => x_msg_data
7969: );

Line 7975: FND_MSG_PUB.count_and_get(

7971: EXCEPTION
7972: WHEN FND_API.g_exc_error THEN
7973: ROLLBACK TO Del_Line_Util_By_Group;
7974: x_return_status := FND_API.g_ret_sts_error;
7975: FND_MSG_PUB.count_and_get(
7976: p_encoded => FND_API.g_false,
7977: p_count => x_msg_count,
7978: p_data => x_msg_data
7979: );

Line 7984: FND_MSG_PUB.count_and_get(

7980:
7981: WHEN FND_API.g_exc_unexpected_error THEN
7982: ROLLBACK TO Del_Line_Util_By_Group;
7983: x_return_status := FND_API.g_ret_sts_unexp_error ;
7984: FND_MSG_PUB.count_and_get(
7985: p_encoded => FND_API.g_false,
7986: p_count => x_msg_count,
7987: p_data => x_msg_data
7988: );

Line 7993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

7989:
7990: WHEN OTHERS THEN
7991: ROLLBACK TO Del_Line_Util_By_Group;
7992: x_return_status := FND_API.g_ret_sts_unexp_error ;
7993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7995: END IF;
7996: FND_MSG_PUB.count_and_get(
7997: p_encoded => FND_API.g_false,

Line 7994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

7990: WHEN OTHERS THEN
7991: ROLLBACK TO Del_Line_Util_By_Group;
7992: x_return_status := FND_API.g_ret_sts_unexp_error ;
7993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7995: END IF;
7996: FND_MSG_PUB.count_and_get(
7997: p_encoded => FND_API.g_false,
7998: p_count => x_msg_count,

Line 7996: FND_MSG_PUB.count_and_get(

7992: x_return_status := FND_API.g_ret_sts_unexp_error ;
7993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
7994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7995: END IF;
7996: FND_MSG_PUB.count_and_get(
7997: p_encoded => FND_API.g_false,
7998: p_count => x_msg_count,
7999: p_data => x_msg_data
8000: );

Line 8124: FND_MSG_PUB.initialize;

8120: OZF_Utility_PVT.debug_message(l_full_name||': start');
8121: END IF;
8122:
8123: IF FND_API.to_boolean(p_init_msg_list) THEN
8124: FND_MSG_PUB.initialize;
8125: END IF;
8126:
8127: IF NOT FND_API.compatible_api_call(
8128: l_api_version,

Line 8452: FND_MSG_PUB.count_and_get(

8448: IF FND_API.to_boolean(p_commit) THEN
8449: COMMIT;
8450: END IF;
8451:
8452: FND_MSG_PUB.count_and_get(
8453: p_encoded => FND_API.g_false,
8454: p_count => x_msg_count,
8455: p_data => x_msg_data
8456: );

Line 8466: FND_MSG_PUB.count_and_get (

8462: EXCEPTION
8463: WHEN FND_API.g_exc_error THEN
8464: ROLLBACK TO Delete_Group_Line_Util;
8465: x_return_status := FND_API.g_ret_sts_error;
8466: FND_MSG_PUB.count_and_get (
8467: p_encoded => FND_API.g_false
8468: ,p_count => x_msg_count
8469: ,p_data => x_msg_data
8470: );

Line 8475: FND_MSG_PUB.count_and_get (

8471:
8472: WHEN FND_API.g_exc_unexpected_error THEN
8473: ROLLBACK TO Delete_Group_Line_Util;
8474: x_return_status := FND_API.g_ret_sts_unexp_error ;
8475: FND_MSG_PUB.count_and_get (
8476: p_encoded => FND_API.g_false
8477: ,p_count => x_msg_count
8478: ,p_data => x_msg_data
8479: );

Line 8484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

8480:
8481: WHEN OTHERS THEN
8482: ROLLBACK TO Delete_Group_Line_Util;
8483: x_return_status := FND_API.g_ret_sts_unexp_error ;
8484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8486: END IF;
8487: FND_MSG_PUB.count_and_get(
8488: p_encoded => FND_API.g_false

Line 8485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8481: WHEN OTHERS THEN
8482: ROLLBACK TO Delete_Group_Line_Util;
8483: x_return_status := FND_API.g_ret_sts_unexp_error ;
8484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8486: END IF;
8487: FND_MSG_PUB.count_and_get(
8488: p_encoded => FND_API.g_false
8489: ,p_count => x_msg_count

Line 8487: FND_MSG_PUB.count_and_get(

8483: x_return_status := FND_API.g_ret_sts_unexp_error ;
8484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8485: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8486: END IF;
8487: FND_MSG_PUB.count_and_get(
8488: p_encoded => FND_API.g_false
8489: ,p_count => x_msg_count
8490: ,p_data => x_msg_data
8491: );

Line 8579: FND_MSG_PUB.initialize;

8575: OZF_Utility_PVT.debug_message(l_full_name||': start');
8576: END IF;
8577:
8578: IF FND_API.to_boolean(p_init_msg_list) THEN
8579: FND_MSG_PUB.initialize;
8580: END IF;
8581:
8582: IF NOT FND_API.compatible_api_call(
8583: l_api_version,

Line 8689: FND_MSG_PUB.count_and_get(

8685: IF FND_API.to_boolean(p_commit) THEN
8686: COMMIT;
8687: END IF;
8688:
8689: FND_MSG_PUB.count_and_get(
8690: p_encoded => FND_API.g_false,
8691: p_count => x_msg_count,
8692: p_data => x_msg_data
8693: );

Line 8703: FND_MSG_PUB.count_and_get (

8699: EXCEPTION
8700: WHEN FND_API.g_exc_error THEN
8701: ROLLBACK TO Update_Dummy_Utilizations;
8702: x_return_status := FND_API.g_ret_sts_error;
8703: FND_MSG_PUB.count_and_get (
8704: p_encoded => FND_API.g_false
8705: ,p_count => x_msg_count
8706: ,p_data => x_msg_data
8707: );

Line 8712: FND_MSG_PUB.count_and_get (

8708:
8709: WHEN FND_API.g_exc_unexpected_error THEN
8710: ROLLBACK TO Update_Dummy_Utilizations;
8711: x_return_status := FND_API.g_ret_sts_unexp_error ;
8712: FND_MSG_PUB.count_and_get (
8713: p_encoded => FND_API.g_false
8714: ,p_count => x_msg_count
8715: ,p_data => x_msg_data
8716: );

Line 8721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

8717:
8718: WHEN OTHERS THEN
8719: ROLLBACK TO Update_Dummy_Utilizations;
8720: x_return_status := FND_API.g_ret_sts_unexp_error ;
8721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8723: END IF;
8724: FND_MSG_PUB.count_and_get(
8725: p_encoded => FND_API.g_false

Line 8722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8718: WHEN OTHERS THEN
8719: ROLLBACK TO Update_Dummy_Utilizations;
8720: x_return_status := FND_API.g_ret_sts_unexp_error ;
8721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8723: END IF;
8724: FND_MSG_PUB.count_and_get(
8725: p_encoded => FND_API.g_false
8726: ,p_count => x_msg_count

Line 8724: FND_MSG_PUB.count_and_get(

8720: x_return_status := FND_API.g_ret_sts_unexp_error ;
8721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
8722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8723: END IF;
8724: FND_MSG_PUB.count_and_get(
8725: p_encoded => FND_API.g_false
8726: ,p_count => x_msg_count
8727: ,p_data => x_msg_data
8728: );

Line 8855: FND_MSG_PUB.initialize;

8851: OZF_Utility_PVT.debug_message(l_full_name||': start');
8852: END IF;
8853:
8854: IF FND_API.to_boolean(p_init_msg_list) THEN
8855: FND_MSG_PUB.initialize;
8856: END IF;
8857:
8858: IF NOT FND_API.compatible_api_call(
8859: l_api_version,

Line 8942: FND_MSG_PUB.Add;

8938: -- error everytime if ams_act_products.adjustment_flag is 'N'.
8939: IF OZF_DEBUG_LOW_ON THEN
8940: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
8941: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Manual Adjust Over Utilization is not supported.');
8942: FND_MSG_PUB.Add;
8943: END IF;
8944:
8945: RAISE FND_API.g_exc_unexpected_error;
8946: --Invoke_Adjustment_Workflow();

Line 9062: FND_MSG_PUB.count_and_get(

9058: IF FND_API.to_boolean(p_commit) THEN
9059: COMMIT;
9060: END IF;
9061:
9062: FND_MSG_PUB.count_and_get(
9063: p_encoded => FND_API.g_false,
9064: p_count => x_msg_count,
9065: p_data => x_msg_data
9066: );

Line 9076: FND_MSG_PUB.count_and_get (

9072: EXCEPTION
9073: WHEN FND_API.g_exc_error THEN
9074: ROLLBACK TO Adjust_Fund_Utilization;
9075: x_return_status := FND_API.g_ret_sts_error;
9076: FND_MSG_PUB.count_and_get (
9077: p_encoded => FND_API.g_false
9078: ,p_count => x_msg_count
9079: ,p_data => x_msg_data
9080: );

Line 9085: FND_MSG_PUB.count_and_get (

9081:
9082: WHEN FND_API.g_exc_unexpected_error THEN
9083: ROLLBACK TO Adjust_Fund_Utilization;
9084: x_return_status := FND_API.g_ret_sts_unexp_error ;
9085: FND_MSG_PUB.count_and_get (
9086: p_encoded => FND_API.g_false
9087: ,p_count => x_msg_count
9088: ,p_data => x_msg_data
9089: );

Line 9094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

9090:
9091: WHEN OTHERS THEN
9092: ROLLBACK TO Adjust_Fund_Utilization;
9093: x_return_status := FND_API.g_ret_sts_unexp_error ;
9094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9096: END IF;
9097: FND_MSG_PUB.count_and_get(
9098: p_encoded => FND_API.g_false

Line 9095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

9091: WHEN OTHERS THEN
9092: ROLLBACK TO Adjust_Fund_Utilization;
9093: x_return_status := FND_API.g_ret_sts_unexp_error ;
9094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9096: END IF;
9097: FND_MSG_PUB.count_and_get(
9098: p_encoded => FND_API.g_false
9099: ,p_count => x_msg_count

Line 9097: FND_MSG_PUB.count_and_get(

9093: x_return_status := FND_API.g_ret_sts_unexp_error ;
9094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
9095: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9096: END IF;
9097: FND_MSG_PUB.count_and_get(
9098: p_encoded => FND_API.g_false
9099: ,p_count => x_msg_count
9100: ,p_data => x_msg_data
9101: );

Line 9873: FND_MSG_PUB.initialize;

9869: OZF_Utility_PVT.debug_message('p_ship_debit_type : '||p_ship_debit_type);
9870: END IF;
9871:
9872: IF FND_API.to_boolean(p_init_msg_list) THEN
9873: FND_MSG_PUB.initialize;
9874: END IF;
9875:
9876: IF NOT FND_API.compatible_api_call(
9877: l_api_version,

Line 10013: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10009: l_check := l_check + 1;
10010: END IF;
10011: END LOOP;
10012: IF l_check > 1 THEN
10013: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10014: FND_MESSAGE.Set_Name('OZF', 'OZF_DUP_CUST_ACCTS');
10015: FND_MESSAGE.Set_Token('CUST_ACCOUNT_ID', l_cust_util_tbl(i).cust_account_id);
10016: FND_MSG_PUB.ADD;
10017: END IF;

Line 10016: FND_MSG_PUB.ADD;

10012: IF l_check > 1 THEN
10013: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10014: FND_MESSAGE.Set_Name('OZF', 'OZF_DUP_CUST_ACCTS');
10015: FND_MESSAGE.Set_Token('CUST_ACCOUNT_ID', l_cust_util_tbl(i).cust_account_id);
10016: FND_MSG_PUB.ADD;
10017: END IF;
10018: RAISE FND_API.g_exc_unexpected_error;
10019: END IF;
10020: END LOOP;

Line 10164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10160: OPEN csr_uom_code(l_line_tbl(l_counter).item_id);
10161: FETCH csr_uom_code INTO l_line_tbl(l_counter).quantity_uom;
10162: IF csr_uom_code%NOTFOUND THEN
10163: CLOSE csr_uom_code;
10164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10165: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
10166: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
10167: FND_MSG_PUB.ADD;
10168: END IF;

Line 10167: FND_MSG_PUB.ADD;

10163: CLOSE csr_uom_code;
10164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10165: FND_MESSAGE.Set_Name('OZF', 'OZF_PRODUCT_UOM_MISSING');
10166: FND_MESSAGE.Set_Token('ITEM_ID', l_line_tbl(l_counter).item_id);
10167: FND_MSG_PUB.ADD;
10168: END IF;
10169: RAISE FND_API.g_exc_unexpected_error;
10170: END IF;
10171: CLOSE csr_uom_code;

Line 10183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10179: END LOOP;
10180:
10181: --Raise error, if no accrual exists, may happen for INTERNAL claims only
10182: IF l_counter = 1 THEN
10183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10184: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_NOT_EXISTS');
10185: FND_MSG_PUB.ADD;
10186: END IF;
10187: RAISE FND_API.g_exc_unexpected_error;

Line 10185: FND_MSG_PUB.ADD;

10181: --Raise error, if no accrual exists, may happen for INTERNAL claims only
10182: IF l_counter = 1 THEN
10183: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10184: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_NOT_EXISTS');
10185: FND_MSG_PUB.ADD;
10186: END IF;
10187: RAISE FND_API.g_exc_unexpected_error;
10188: END IF;
10189:

Line 10363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10359: END IF;
10360: ELSIF l_claim_rec.amount = 0 THEN
10361: --Raise error, if claim amount is zero. Claim header is not allowed with
10362: --zero amount.
10363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10364: FND_MESSAGE.Set_Name('OZF', 'OZF_EARN_AVAIL_AMT_ZERO');
10365: FND_MSG_PUB.ADD;
10366: END IF;
10367: RAISE FND_API.g_exc_unexpected_error;

Line 10365: FND_MSG_PUB.ADD;

10361: --Raise error, if claim amount is zero. Claim header is not allowed with
10362: --zero amount.
10363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10364: FND_MESSAGE.Set_Name('OZF', 'OZF_EARN_AVAIL_AMT_ZERO');
10365: FND_MSG_PUB.ADD;
10366: END IF;
10367: RAISE FND_API.g_exc_unexpected_error;
10368: ELSE
10369: --Raise error, if claim amount is negative.

Line 10370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10366: END IF;
10367: RAISE FND_API.g_exc_unexpected_error;
10368: ELSE
10369: --Raise error, if claim amount is negative.
10370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10371: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_AMOUNT_NEGATIVE');
10372: FND_MSG_PUB.ADD;
10373: END IF;
10374: RAISE FND_API.g_exc_unexpected_error;

Line 10372: FND_MSG_PUB.ADD;

10368: ELSE
10369: --Raise error, if claim amount is negative.
10370: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10371: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_AMOUNT_NEGATIVE');
10372: FND_MSG_PUB.ADD;
10373: END IF;
10374: RAISE FND_API.g_exc_unexpected_error;
10375: END IF;
10376:

Line 10413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

10409:
10410: END LOOP;
10411: ELSE
10412: --Raise error, if no accrual exists, may happen for INTERNAL claims only
10413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10414: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_NOT_EXISTS');
10415: FND_MSG_PUB.ADD;
10416: END IF;
10417: RAISE FND_API.g_exc_unexpected_error;

Line 10415: FND_MSG_PUB.ADD;

10411: ELSE
10412: --Raise error, if no accrual exists, may happen for INTERNAL claims only
10413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10414: FND_MESSAGE.Set_Name('OZF', 'OZF_ACCRUAL_NOT_EXISTS');
10415: FND_MSG_PUB.ADD;
10416: END IF;
10417: RAISE FND_API.g_exc_unexpected_error;
10418: END IF;
10419:

Line 10426: FND_MSG_PUB.count_and_get(

10422: IF FND_API.to_boolean(p_commit) THEN
10423: COMMIT;
10424: END IF;
10425:
10426: FND_MSG_PUB.count_and_get(
10427: p_encoded => FND_API.g_false,
10428: p_count => x_msg_count,
10429: p_data => x_msg_data
10430: );

Line 10440: FND_MSG_PUB.count_and_get (

10436: EXCEPTION
10437: WHEN FND_API.g_exc_error THEN
10438: ROLLBACK TO Initiate_SD_Payment;
10439: x_return_status := FND_API.g_ret_sts_error;
10440: FND_MSG_PUB.count_and_get (
10441: p_encoded => FND_API.g_false
10442: ,p_count => x_msg_count
10443: ,p_data => x_msg_data
10444: );

Line 10449: FND_MSG_PUB.count_and_get (

10445:
10446: WHEN FND_API.g_exc_unexpected_error THEN
10447: ROLLBACK TO Initiate_SD_Payment;
10448: x_return_status := FND_API.g_ret_sts_unexp_error ;
10449: FND_MSG_PUB.count_and_get (
10450: p_encoded => FND_API.g_false
10451: ,p_count => x_msg_count
10452: ,p_data => x_msg_data
10453: );

Line 10458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

10454:
10455: WHEN OTHERS THEN
10456: ROLLBACK TO Initiate_SD_Payment;
10457: x_return_status := FND_API.g_ret_sts_unexp_error ;
10458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10459: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10460: END IF;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false

Line 10459: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

10455: WHEN OTHERS THEN
10456: ROLLBACK TO Initiate_SD_Payment;
10457: x_return_status := FND_API.g_ret_sts_unexp_error ;
10458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10459: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10460: END IF;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false
10463: ,p_count => x_msg_count

Line 10461: FND_MSG_PUB.count_and_get(

10457: x_return_status := FND_API.g_ret_sts_unexp_error ;
10458: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
10459: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10460: END IF;
10461: FND_MSG_PUB.count_and_get(
10462: p_encoded => FND_API.g_false
10463: ,p_count => x_msg_count
10464: ,p_data => x_msg_data
10465: );