eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_RESALE_COMMON_PVT dependencies on FND_MSG_PUB

Line 13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_COMMON_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
15: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
16: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
17:

Line 14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_COMMON_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
15: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
16: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
17:
18: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';

Line 15: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);

11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
15: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
16: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
17:
18: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';
19: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';

Line 16: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);

12:
13: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
15: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
16: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
17:
18: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';
19: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';
20: G_TP_ACCRUAL_UTIL_TYPE CONSTANT VARCHAR2(30) :='ADJUSTMENT';

Line 124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: WHEN OTHERS THEN
123: IF OZF_UNEXP_ERROR THEN
124: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
125: END IF;
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
127: END Insert_Resale_Log;
128:

Line 207: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: WHEN OTHERS THEN
206: IF OZF_UNEXP_ERROR THEN
207: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
208: END IF;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: END Bulk_Insert_Resale_Log;
211:

Line 361: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: WHEN OTHERS THEN
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF OZF_UNEXP_ERROR THEN
361: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
362: END IF;
363: END Log_Null_Values;
364:
365: ---------------------------------------------------------------------

Line 519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: WHEN OTHERS THEN
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF OZF_UNEXP_ERROR THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
521: END Log_Invalid_Values;
522:
523: ---------------------------------------------------------------------

Line 572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

568: AND c.resale_id_type = 'IFACE');
569: EXCEPTION
570: WHEN OTHERS THEN
571: IF OZF_UNEXP_ERROR THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: END;
576: --

Line 587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: WHEN OTHERS THEN
586: IF OZF_UNEXP_ERROR THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
588: END IF;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: END Bulk_Dispute_Line;
591:

Line 681: FND_MSG_PUB.initialize;

677: END IF;
678:
679: --Initialize message if p_init_msg_list IS TRUE.
680: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
681: FND_MSG_PUB.initialize;
682: END IF;
683:
684: -- Debug Message
685: IF OZF_DEBUG_HIGH_ON THEN

Line 816: FND_MSG_PUB.Count_and_Get (

812: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
813: END IF;
814:
815: --Standard call to get message count AND if count=1, get the message
816: FND_MSG_PUB.Count_and_Get (
817: p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data
820: );

Line 826: FND_MSG_PUB.Count_and_Get (

822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO Update_Batch_Calculations;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: -- Standard call to get message count AND IF count=1, get the message
826: FND_MSG_PUB.Count_and_Get (
827: p_encoded => FND_API.G_FALSE,
828: p_count => x_msg_count,
829: p_data => x_msg_data
830: );

Line 835: FND_MSG_PUB.Count_and_Get (

831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO Update_Batch_Calculations;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count AND IF count=1, get the message
835: FND_MSG_PUB.Count_and_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );

Line 844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

840: WHEN OTHERS THEN
841: ROLLBACK TO Update_Batch_Calculations;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: IF OZF_UNEXP_ERROR THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count AND IF count=1, get the message
847: FND_MSG_PUB.Count_and_Get (
848: p_encoded => FND_API.G_FALSE,

Line 847: FND_MSG_PUB.Count_and_Get (

843: IF OZF_UNEXP_ERROR THEN
844: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
845: END IF;
846: -- Standard call to get message count AND IF count=1, get the message
847: FND_MSG_PUB.Count_and_Get (
848: p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: );

Line 1064: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1060: WHERE resale_line_int_id = p_resale_line_int_rec.resale_line_int_id;
1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: IF OZF_UNEXP_ERROR THEN
1064: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1065: END IF;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:

Line 1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1080: WHEN OTHERS THEN
1081: ROLLBACK TO Update_Line_Calculations;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF OZF_UNEXP_ERROR THEN
1084: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1085: END IF;
1086: END Update_Line_Calculations;
1087:
1088: ---------------------------------------------------------------------

Line 1447: FND_MSG_PUB.initialize;

1443: END IF;
1444:
1445: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
1446: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
1447: FND_MSG_PUB.initialize;
1448: END IF;
1449:
1450: -- Debug Message
1451: IF OZF_DEBUG_HIGH_ON THEN

Line 1566: FND_MSG_PUB.Count_And_Get (

1562: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1563: END IF;
1564:
1565: --Standard call to get message count AND IF count=1, get the message
1566: FND_MSG_PUB.Count_And_Get (
1567: p_encoded => FND_API.G_FALSE,
1568: p_count => x_msg_count,
1569: p_data => x_msg_data
1570: );

Line 1575: FND_MSG_PUB.Count_And_Get (

1571: EXCEPTION
1572: WHEN FND_API.G_EXC_ERROR THEN
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: -- Standard call to get message count AND IF count=1, get the message
1575: FND_MSG_PUB.Count_And_Get (
1576: p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data
1579: );

Line 1583: FND_MSG_PUB.Count_And_Get (

1579: );
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: -- Standard call to get message count AND IF count=1, get the message
1583: FND_MSG_PUB.Count_And_Get (
1584: p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data
1587: );

Line 1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1587: );
1588: WHEN OTHERS THEN
1589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1590: IF OZF_UNEXP_ERROR THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count AND IF count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,

Line 1594: FND_MSG_PUB.Count_And_Get (

1590: IF OZF_UNEXP_ERROR THEN
1591: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1592: END IF;
1593: -- Standard call to get message count AND IF count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );

Line 1679: FND_MSG_PUB.initialize;

1675: END IF;
1676:
1677: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
1678: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
1679: FND_MSG_PUB.initialize;
1680: END IF;
1681:
1682: -- Debug Message
1683: IF OZF_DEBUG_HIGH_ON THEN

Line 1804: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1800: --
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: IF OZF_UNEXP_ERROR THEN
1804: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1805: END IF;
1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1807: END;
1808: */

Line 1818: FND_MSG_PUB.Count_And_Get (

1814: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1815: END IF;
1816:
1817: --Standard call to get message count AND IF count=1, get the message
1818: FND_MSG_PUB.Count_And_Get (
1819: p_encoded => FND_API.G_FALSE,
1820: p_count => x_msg_count,
1821: p_data => x_msg_data
1822: );

Line 1829: FND_MSG_PUB.Count_And_Get (

1825: WHEN FND_API.G_EXC_ERROR THEN
1826: ROLLBACK TO Update_Duplicates;
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828: -- Standard call to get message count AND IF count=1, get the message
1829: FND_MSG_PUB.Count_And_Get (
1830: p_encoded => FND_API.G_FALSE,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data
1833: );

Line 1838: FND_MSG_PUB.Count_And_Get (

1834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1835: ROLLBACK TO Update_Duplicates;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: -- Standard call to get message count AND IF count=1, get the message
1838: FND_MSG_PUB.Count_And_Get (
1839: p_encoded => FND_API.G_FALSE,
1840: p_count => x_msg_count,
1841: p_data => x_msg_data
1842: );

Line 1847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1843: WHEN OTHERS THEN
1844: ROLLBACK TO Update_Duplicates;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: IF OZF_UNEXP_ERROR THEN
1847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1848: END IF;
1849: -- Standard call to get message count AND IF count=1, get the message
1850: FND_MSG_PUB.Count_And_Get (
1851: p_encoded => FND_API.G_FALSE,

Line 1850: FND_MSG_PUB.Count_And_Get (

1846: IF OZF_UNEXP_ERROR THEN
1847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1848: END IF;
1849: -- Standard call to get message count AND IF count=1, get the message
1850: FND_MSG_PUB.Count_And_Get (
1851: p_encoded => FND_API.G_FALSE,
1852: p_count => x_msg_count,
1853: p_data => x_msg_data
1854: );

Line 1938: FND_MSG_PUB.initialize;

1934: END IF;
1935:
1936: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
1937: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
1938: FND_MSG_PUB.initialize;
1939: END IF;
1940:
1941: -- Debug Message
1942: IF OZF_DEBUG_HIGH_ON THEN

Line 2220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2216: WHERE resale_batch_id = p_resale_batch_id;
2217: EXCEPTION
2218: WHEN OTHERS THEN
2219: IF OZF_UNEXP_ERROR THEN
2220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2221: END IF;
2222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2223: END;
2224: END IF;

Line 2232: FND_MSG_PUB.Count_And_Get (

2228: OZF_UTILITY_PVT.debug_message(l_full_name||': END');
2229: END IF;
2230:
2231: --Standard call to get message count AND IF count=1, get the message
2232: FND_MSG_PUB.Count_And_Get (
2233: p_encoded => FND_API.G_FALSE,
2234: p_count => x_msg_count,
2235: p_data => x_msg_data
2236: );

Line 2242: FND_MSG_PUB.Count_And_Get (

2238: EXCEPTION
2239: WHEN FND_API.G_EXC_ERROR THEN
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: -- Standard call to get message count AND IF count=1, get the message
2242: FND_MSG_PUB.Count_And_Get (
2243: p_encoded => FND_API.G_FALSE,
2244: p_count => x_msg_count,
2245: p_data => x_msg_data
2246: );

Line 2250: FND_MSG_PUB.Count_And_Get (

2246: );
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2249: -- Standard call to get message count AND IF count=1, get the message
2250: FND_MSG_PUB.Count_And_Get (
2251: p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count,
2253: p_data => x_msg_data
2254: );

Line 2258: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2254: );
2255: WHEN OTHERS THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: IF OZF_UNEXP_ERROR THEN
2258: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2259: END IF;
2260: -- Standard call to get message count AND IF count=1, get the message
2261: FND_MSG_PUB.Count_And_Get (
2262: p_encoded => FND_API.G_FALSE,

Line 2261: FND_MSG_PUB.Count_And_Get (

2257: IF OZF_UNEXP_ERROR THEN
2258: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2259: END IF;
2260: -- Standard call to get message count AND IF count=1, get the message
2261: FND_MSG_PUB.Count_And_Get (
2262: p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data
2265: );

Line 2309: FND_MSG_PUB.initialize;

2305: END IF;
2306:
2307: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2308: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2309: FND_MSG_PUB.initialize;
2310: END IF;
2311:
2312: -- Debug Message
2313: IF OZF_DEBUG_HIGH_ON THEN

Line 2363: FND_MSG_PUB.Count_And_Get (

2359: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2360: END IF;
2361:
2362: --Standard call to get message count AND IF count=1, get the message
2363: FND_MSG_PUB.Count_And_Get (
2364: p_encoded => FND_API.G_FALSE,
2365: p_count => x_msg_count,
2366: p_data => x_msg_data
2367: );

Line 2372: FND_MSG_PUB.Count_And_Get (

2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: x_return_status := FND_API.G_RET_STS_ERROR;
2371: -- Standard call to get message count AND IF count=1, get the message
2372: FND_MSG_PUB.Count_And_Get (
2373: p_encoded => FND_API.G_FALSE,
2374: p_count => x_msg_count,
2375: p_data => x_msg_data
2376: );

Line 2380: FND_MSG_PUB.Count_And_Get (

2376: );
2377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: -- Standard call to get message count AND IF count=1, get the message
2380: FND_MSG_PUB.Count_And_Get (
2381: p_encoded => FND_API.G_FALSE,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data
2384: );

Line 2388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2384: );
2385: WHEN OTHERS THEN
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387: IF OZF_UNEXP_ERROR THEN
2388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2389: END IF;
2390: -- Standard call to get message count AND IF count=1, get the message
2391: FND_MSG_PUB.Count_And_Get (
2392: p_encoded => FND_API.G_FALSE,

Line 2391: FND_MSG_PUB.Count_And_Get (

2387: IF OZF_UNEXP_ERROR THEN
2388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2389: END IF;
2390: -- Standard call to get message count AND IF count=1, get the message
2391: FND_MSG_PUB.Count_And_Get (
2392: p_encoded => FND_API.G_FALSE,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data
2395: );

Line 2634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2630: WHEN OTHERS THEN
2631: ROLLBACK TO IDSM_Create_Utiz_Rec;
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2633: IF OZF_UNEXP_ERROR THEN
2634: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2635: END IF;
2636: END Create_Utilization_record;
2637:
2638: ---------------------------------------------------------------------

Line 2698: FND_MSG_PUB.initialize;

2694: END IF;
2695:
2696: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2697: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2698: FND_MSG_PUB.initialize;
2699: END IF;
2700:
2701: -- Debug Message
2702: IF OZF_DEBUG_HIGH_ON THEN

Line 2790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2786: --
2787: EXCEPTION
2788: WHEN OTHERS THEN
2789: IF OZF_UNEXP_ERROR THEN
2790: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2791: END IF;
2792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2793: END;
2794:

Line 2862: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2858:
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: IF OZF_UNEXP_ERROR THEN
2862: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2863: END IF;
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END;
2866: END IF;

Line 2874: FND_MSG_PUB.Count_And_Get (

2870: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2871: END IF;
2872:
2873: --Standard call to get message count AND IF count=1, get the message
2874: FND_MSG_PUB.Count_And_Get (
2875: p_encoded => FND_API.G_FALSE,
2876: p_count => x_msg_count,
2877: p_data => x_msg_data
2878: );

Line 2884: FND_MSG_PUB.Count_And_Get (

2880: WHEN FND_API.G_EXC_ERROR THEN
2881: ROLLBACK TO Create_Adj_And_Utilization;
2882: x_return_status := FND_API.G_RET_STS_ERROR;
2883: -- Standard call to get message count AND IF count=1, get the message
2884: FND_MSG_PUB.Count_And_Get (
2885: p_encoded => FND_API.G_FALSE,
2886: p_count => x_msg_count,
2887: p_data => x_msg_data
2888: );

Line 2893: FND_MSG_PUB.Count_And_Get (

2889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2890: ROLLBACK TO Create_Adj_And_Utilization;
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892: -- Standard call to get message count AND IF count=1, get the message
2893: FND_MSG_PUB.Count_And_Get (
2894: p_encoded => FND_API.G_FALSE,
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2897: );

Line 2902: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2898: WHEN OTHERS THEN
2899: ROLLBACK TO Create_Adj_And_Utilization;
2900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: IF OZF_UNEXP_ERROR THEN
2902: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2903: END IF;
2904: -- Standard call to get message count AND IF count=1, get the message
2905: FND_MSG_PUB.Count_And_Get (
2906: p_encoded => FND_API.G_FALSE,

Line 2905: FND_MSG_PUB.Count_And_Get (

2901: IF OZF_UNEXP_ERROR THEN
2902: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2903: END IF;
2904: -- Standard call to get message count AND IF count=1, get the message
2905: FND_MSG_PUB.Count_And_Get (
2906: p_encoded => FND_API.G_FALSE,
2907: p_count => x_msg_count,
2908: p_data => x_msg_data
2909: );

Line 2998: FND_MSG_PUB.initialize;

2994: END IF;
2995:
2996: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2997: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2998: FND_MSG_PUB.initialize;
2999: END IF;
3000:
3001: -- Debug Message
3002: IF OZF_DEBUG_HIGH_ON THEN

Line 3219: FND_MSG_PUB.Count_And_Get (

3215: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3216: END IF;
3217:
3218: --Standard call to get message count AND IF count=1, get the message
3219: FND_MSG_PUB.Count_And_Get (
3220: p_encoded => FND_API.G_FALSE,
3221: p_count => x_msg_count,
3222: p_data => x_msg_data
3223: );

Line 3229: FND_MSG_PUB.Count_And_Get (

3225: WHEN FND_API.G_EXC_ERROR THEN
3226: ROLLBACK TO IDSM_Create_Utilization;
3227: x_return_status := FND_API.G_RET_STS_ERROR;
3228: -- Standard call to get message count AND IF count=1, get the message
3229: FND_MSG_PUB.Count_And_Get (
3230: p_encoded => FND_API.G_FALSE,
3231: p_count => x_msg_count,
3232: p_data => x_msg_data
3233: );

Line 3238: FND_MSG_PUB.Count_And_Get (

3234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3235: ROLLBACK TO IDSM_Create_Utilization;
3236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3237: -- Standard call to get message count AND IF count=1, get the message
3238: FND_MSG_PUB.Count_And_Get (
3239: p_encoded => FND_API.G_FALSE,
3240: p_count => x_msg_count,
3241: p_data => x_msg_data
3242: );

Line 3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3243: WHEN OTHERS THEN
3244: ROLLBACK TO IDSM_Create_Utilization;
3245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3246: IF OZF_UNEXP_ERROR THEN
3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3248: END IF;
3249: -- Standard call to get message count AND IF count=1, get the message
3250: FND_MSG_PUB.Count_And_Get (
3251: p_encoded => FND_API.G_FALSE,

Line 3250: FND_MSG_PUB.Count_And_Get (

3246: IF OZF_UNEXP_ERROR THEN
3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3248: END IF;
3249: -- Standard call to get message count AND IF count=1, get the message
3250: FND_MSG_PUB.Count_And_Get (
3251: p_encoded => FND_API.G_FALSE,
3252: p_count => x_msg_count,
3253: p_data => x_msg_data
3254: );

Line 3330: FND_MSG_PUB.initialize;

3326: END IF;
3327:
3328: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3329: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
3330: FND_MSG_PUB.initialize;
3331: END IF;
3332:
3333: -- Initialize API return status to sucess
3334: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3396: FND_MSG_PUB.Count_And_Get (

3392: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3393: END IF;
3394:
3395: --Standard call to get message count AND IF count=1, get the message
3396: FND_MSG_PUB.Count_And_Get (
3397: p_encoded => FND_API.G_FALSE,
3398: p_count => x_msg_count,
3399: p_data => x_msg_data
3400: );

Line 3406: FND_MSG_PUB.Count_And_Get (

3402: WHEN FND_API.G_EXC_ERROR THEN
3403: ROLLBACK TO Create_Sales_Transaction;
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: -- Standard call to get message count AND IF count=1, get the message
3406: FND_MSG_PUB.Count_And_Get (
3407: p_encoded => FND_API.G_FALSE,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );

Line 3415: FND_MSG_PUB.Count_And_Get (

3411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3412: ROLLBACK TO Create_Sales_Transaction;
3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3414: -- Standard call to get message count AND IF count=1, get the message
3415: FND_MSG_PUB.Count_And_Get (
3416: p_encoded => FND_API.G_FALSE,
3417: p_count => x_msg_count,
3418: p_data => x_msg_data
3419: );

Line 3424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3420: WHEN OTHERS THEN
3421: ROLLBACK TO Create_Sales_Transaction;
3422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3423: IF OZF_UNEXP_ERROR THEN
3424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3425: END IF;
3426: -- Standard call to get message count AND IF count=1, get the message
3427: FND_MSG_PUB.Count_And_Get (
3428: p_encoded => FND_API.G_FALSE,

Line 3427: FND_MSG_PUB.Count_And_Get (

3423: IF OZF_UNEXP_ERROR THEN
3424: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3425: END IF;
3426: -- Standard call to get message count AND IF count=1, get the message
3427: FND_MSG_PUB.Count_And_Get (
3428: p_encoded => FND_API.G_FALSE,
3429: p_count => x_msg_count,
3430: p_data => x_msg_data
3431: );

Line 3492: FND_MSG_PUB.initialize;

3488: END IF;
3489:
3490: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3491: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
3492: FND_MSG_PUB.initialize;
3493: END IF;
3494:
3495: -- Initialize API return status to sucess
3496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3607: FND_MSG_PUB.Count_And_Get (

3603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3604: END IF;
3605:
3606: --Standard call to get message count AND IF count=1, get the message
3607: FND_MSG_PUB.Count_And_Get (
3608: p_encoded => FND_API.G_FALSE,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data
3611: );

Line 3617: FND_MSG_PUB.Count_And_Get (

3613: WHEN FND_API.G_EXC_ERROR THEN
3614: ROLLBACK TO Insert_Resale_Header;
3615: x_return_status := FND_API.G_RET_STS_ERROR;
3616: -- Standard call to get message count AND IF count=1, get the message
3617: FND_MSG_PUB.Count_And_Get (
3618: p_encoded => FND_API.G_FALSE,
3619: p_count => x_msg_count,
3620: p_data => x_msg_data
3621: );

Line 3626: FND_MSG_PUB.Count_And_Get (

3622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3623: ROLLBACK TO Insert_Resale_Header;
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: -- Standard call to get message count AND IF count=1, get the message
3626: FND_MSG_PUB.Count_And_Get (
3627: p_encoded => FND_API.G_FALSE,
3628: p_count => x_msg_count,
3629: p_data => x_msg_data
3630: );

Line 3635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3631: WHEN OTHERS THEN
3632: ROLLBACK TO Insert_Resale_Header;
3633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3634: IF OZF_UNEXP_ERROR THEN
3635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3636: END IF;
3637: -- Standard call to get message count AND IF count=1, get the message
3638: FND_MSG_PUB.Count_And_Get (
3639: p_encoded => FND_API.G_FALSE,

Line 3638: FND_MSG_PUB.Count_And_Get (

3634: IF OZF_UNEXP_ERROR THEN
3635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3636: END IF;
3637: -- Standard call to get message count AND IF count=1, get the message
3638: FND_MSG_PUB.Count_And_Get (
3639: p_encoded => FND_API.G_FALSE,
3640: p_count => x_msg_count,
3641: p_data => x_msg_data
3642: );

Line 3705: FND_MSG_PUB.initialize;

3701: END IF;
3702:
3703: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3704: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
3705: FND_MSG_PUB.initialize;
3706: END IF;
3707:
3708: -- Initialize API return status to sucess
3709: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3918: FND_MSG_PUB.Count_And_Get (

3914: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3915: END IF;
3916:
3917: --Standard call to get message count AND IF count=1, get the message
3918: FND_MSG_PUB.Count_And_Get (
3919: p_encoded => FND_API.G_FALSE,
3920: p_count => x_msg_count,
3921: p_data => x_msg_data
3922: );

Line 3929: FND_MSG_PUB.Count_And_Get (

3925: WHEN FND_API.G_EXC_ERROR THEN
3926: ROLLBACK TO Insert_Resale_Line;
3927: x_return_status := FND_API.G_RET_STS_ERROR;
3928: -- Standard call to get message count AND IF count=1, get the message
3929: FND_MSG_PUB.Count_And_Get (
3930: p_encoded => FND_API.G_FALSE,
3931: p_count => x_msg_count,
3932: p_data => x_msg_data
3933: );

Line 3938: FND_MSG_PUB.Count_And_Get (

3934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3935: ROLLBACK TO Insert_Resale_Line;
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3937: -- Standard call to get message count AND IF count=1, get the message
3938: FND_MSG_PUB.Count_And_Get (
3939: p_encoded => FND_API.G_FALSE,
3940: p_count => x_msg_count,
3941: p_data => x_msg_data
3942: );

Line 3947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3943: WHEN OTHERS THEN
3944: ROLLBACK TO Insert_Resale_Line;
3945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3946: IF OZF_UNEXP_ERROR THEN
3947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3948: END IF;
3949: -- Standard call to get message count AND IF count=1, get the message
3950: FND_MSG_PUB.Count_And_Get (
3951: p_encoded => FND_API.G_FALSE,

Line 3950: FND_MSG_PUB.Count_And_Get (

3946: IF OZF_UNEXP_ERROR THEN
3947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3948: END IF;
3949: -- Standard call to get message count AND IF count=1, get the message
3950: FND_MSG_PUB.Count_And_Get (
3951: p_encoded => FND_API.G_FALSE,
3952: p_count => x_msg_count,
3953: p_data => x_msg_data
3954: );

Line 4015: FND_MSG_PUB.initialize;

4011: END IF;
4012:
4013: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4014: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4015: FND_MSG_PUB.initialize;
4016: END IF;
4017:
4018: -- Initialize API return status to sucess
4019: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4075: FND_MSG_PUB.Count_And_Get (

4071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4072: END IF;
4073:
4074: --Standard call to get message count AND IF count=1, get the message
4075: FND_MSG_PUB.Count_And_Get (
4076: p_encoded => FND_API.G_FALSE,
4077: p_count => x_msg_count,
4078: p_data => x_msg_data
4079: );

Line 4085: FND_MSG_PUB.Count_And_Get (

4081: WHEN FND_API.G_EXC_ERROR THEN
4082: ROLLBACK TO Insert_Resale_Line_Mapping;
4083: x_return_status := FND_API.G_RET_STS_ERROR;
4084: -- Standard call to get message count AND IF count=1, get the message
4085: FND_MSG_PUB.Count_And_Get (
4086: p_encoded => FND_API.G_FALSE,
4087: p_count => x_msg_count,
4088: p_data => x_msg_data
4089: );

Line 4094: FND_MSG_PUB.Count_And_Get (

4090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4091: ROLLBACK TO Insert_Resale_Line_Mapping;
4092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4093: -- Standard call to get message count AND IF count=1, get the message
4094: FND_MSG_PUB.Count_And_Get (
4095: p_encoded => FND_API.G_FALSE,
4096: p_count => x_msg_count,
4097: p_data => x_msg_data
4098: );

Line 4103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4099: WHEN OTHERS THEN
4100: ROLLBACK TO Insert_Resale_Line_Mapping;
4101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4102: IF OZF_UNEXP_ERROR THEN
4103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4104: END IF;
4105: -- Standard call to get message count AND IF count=1, get the message
4106: FND_MSG_PUB.Count_And_Get (
4107: p_encoded => FND_API.G_FALSE,

Line 4106: FND_MSG_PUB.Count_And_Get (

4102: IF OZF_UNEXP_ERROR THEN
4103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4104: END IF;
4105: -- Standard call to get message count AND IF count=1, get the message
4106: FND_MSG_PUB.Count_And_Get (
4107: p_encoded => FND_API.G_FALSE,
4108: p_count => x_msg_count,
4109: p_data => x_msg_data
4110: );

Line 4165: FND_MSG_PUB.initialize;

4161: END IF;
4162:
4163: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4164: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4165: FND_MSG_PUB.initialize;
4166: END IF;
4167:
4168: -- Initialize API return status to sucess
4169: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4192: FND_MSG_PUB.Count_And_Get (

4188: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4189: END IF;
4190:
4191: --Standard call to get message count AND IF count=1, get the message
4192: FND_MSG_PUB.Count_And_Get (
4193: p_encoded => FND_API.G_FALSE,
4194: p_count => x_msg_count,
4195: p_data => x_msg_data
4196: );

Line 4202: FND_MSG_PUB.Count_And_Get (

4198: WHEN FND_API.G_EXC_ERROR THEN
4199: ROLLBACK TO Delete_Log;
4200: x_return_status := FND_API.G_RET_STS_ERROR;
4201: -- Standard call to get message count AND IF count=1, get the message
4202: FND_MSG_PUB.Count_And_Get (
4203: p_encoded => FND_API.G_FALSE,
4204: p_count => x_msg_count,
4205: p_data => x_msg_data
4206: );

Line 4211: FND_MSG_PUB.Count_And_Get (

4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: ROLLBACK TO Delete_Log;
4209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4210: -- Standard call to get message count AND IF count=1, get the message
4211: FND_MSG_PUB.Count_And_Get (
4212: p_encoded => FND_API.G_FALSE,
4213: p_count => x_msg_count,
4214: p_data => x_msg_data
4215: );

Line 4220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4216: WHEN OTHERS THEN
4217: ROLLBACK TO Delete_Log;
4218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4219: IF OZF_UNEXP_ERROR THEN
4220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4221: END IF;
4222: -- Standard call to get message count AND IF count=1, get the message
4223: FND_MSG_PUB.Count_And_Get (
4224: p_encoded => FND_API.G_FALSE,

Line 4223: FND_MSG_PUB.Count_And_Get (

4219: IF OZF_UNEXP_ERROR THEN
4220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4221: END IF;
4222: -- Standard call to get message count AND IF count=1, get the message
4223: FND_MSG_PUB.Count_And_Get (
4224: p_encoded => FND_API.G_FALSE,
4225: p_count => x_msg_count,
4226: p_data => x_msg_data
4227: );

Line 4292: FND_MSG_PUB.initialize;

4288: END IF;
4289:
4290: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4291: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4292: FND_MSG_PUB.initialize;
4293: END IF;
4294:
4295: -- Debug Message
4296: IF OZF_DEBUG_HIGH_ON THEN

Line 4482: FND_MSG_PUB.Count_And_Get (

4478: IF OZF_DEBUG_HIGH_ON THEN
4479: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4480: END IF;
4481: --Standard call to get message count AND IF count=1, get the message
4482: FND_MSG_PUB.Count_And_Get (
4483: p_encoded => FND_API.G_FALSE,
4484: p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:

Line 4491: FND_MSG_PUB.Count_And_Get (

4487: EXCEPTION
4488: WHEN FND_API.G_EXC_ERROR THEN
4489: x_return_status := FND_API.G_RET_STS_ERROR;
4490: -- Standard call to get message count and if count=1, get the message
4491: FND_MSG_PUB.Count_And_Get (
4492: p_encoded => FND_API.G_FALSE,
4493: p_count => x_msg_count,
4494: p_data => x_msg_data
4495: );

Line 4499: FND_MSG_PUB.Count_And_Get (

4495: );
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4498: -- Standard call to get message count and if count=1, get the message
4499: FND_MSG_PUB.Count_And_Get (
4500: p_encoded => FND_API.G_FALSE,
4501: p_count => x_msg_count,
4502: p_data => x_msg_data
4503: );

Line 4508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4504: WHEN OTHERS THEN
4505: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
4506:
4507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN
4510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4511: END IF;
4512: -- Standard call to get message count and if count=1, get the message

Line 4510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4506:
4507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN
4510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4511: END IF;
4512: -- Standard call to get message count and if count=1, get the message
4513: FND_MSG_PUB.Count_And_Get (
4514: p_encoded => FND_API.G_FALSE,

Line 4513: FND_MSG_PUB.Count_And_Get (

4509: THEN
4510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4511: END IF;
4512: -- Standard call to get message count and if count=1, get the message
4513: FND_MSG_PUB.Count_And_Get (
4514: p_encoded => FND_API.G_FALSE,
4515: p_count => x_msg_count,
4516: p_data => x_msg_data
4517: );

Line 4574: FND_MSG_PUB.initialize;

4570: END IF;
4571:
4572: --Initialize message list if p_init_msg_list is TRUE.
4573: IF FND_API.To_Boolean (p_init_msg_list) THEN
4574: FND_MSG_PUB.initialize;
4575: END IF;
4576:
4577: x_return_status := FND_API.G_RET_STS_SUCCESS;
4578:

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

4577: x_return_status := FND_API.G_RET_STS_SUCCESS;
4578:
4579: IF p_caller_type = 'IFACE' AND
4580: p_resale_line_int_rec.resale_line_int_id IS NULL THEN
4581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4582: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_INT_RECD_NULL');
4583: FND_MSG_PUB.add;
4584: END IF;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4583: FND_MSG_PUB.add;

4579: IF p_caller_type = 'IFACE' AND
4580: p_resale_line_int_rec.resale_line_int_id IS NULL THEN
4581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4582: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_INT_RECD_NULL');
4583: FND_MSG_PUB.add;
4584: END IF;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: END IF;
4587:

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

4586: END IF;
4587:
4588: IF p_caller_type = 'RESALE' AND
4589: p_resale_line_rec.resale_line_id IS NULL THEN
4590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4591: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_RECD_NULL');
4592: FND_MSG_PUB.add;
4593: END IF;
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4592: FND_MSG_PUB.add;

4588: IF p_caller_type = 'RESALE' AND
4589: p_resale_line_rec.resale_line_id IS NULL THEN
4590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4591: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_RECD_NULL');
4592: FND_MSG_PUB.add;
4593: END IF;
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: END IF;
4596:

Line 4721: FND_MSG_PUB.Count_And_Get (

4717: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_REC.line_attribute15 := p_resale_line_rec.line_attribute15;
4718: END IF;
4719:
4720:
4721: FND_MSG_PUB.Count_And_Get (
4722: p_encoded => FND_API.G_FALSE,
4723: p_count => x_msg_count,
4724: p_data => x_msg_data
4725: );

Line 4734: FND_MSG_PUB.Count_And_Get (

4730: END IF;
4731: EXCEPTION
4732: WHEN FND_API.G_EXC_ERROR THEN
4733: x_return_status := FND_API.G_RET_STS_ERROR;
4734: FND_MSG_PUB.Count_And_Get (
4735: p_encoded => FND_API.G_FALSE,
4736: p_count => x_msg_count,
4737: p_data => x_msg_data
4738: );

Line 4741: FND_MSG_PUB.Count_And_Get (

4737: p_data => x_msg_data
4738: );
4739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4741: FND_MSG_PUB.Count_And_Get (
4742: p_encoded => FND_API.G_FALSE,
4743: p_count => x_msg_count,
4744: p_data => x_msg_data
4745: );

Line 4748: FND_MSG_PUB.Count_And_Get (

4744: p_data => x_msg_data
4745: );
4746: WHEN OTHERS THEN
4747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4748: FND_MSG_PUB.Count_And_Get (
4749: p_encoded => FND_API.G_FALSE,
4750: p_count => x_msg_count,
4751: p_data => x_msg_data
4752: );