DBA Data[Home] [Help]

APPS.OZF_PRE_PROCESS_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_pre_process_pvt';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvprsb.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_pre_process_pvt';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvprsb.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: -- Processing global variables

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(12) := 'ozfvprsb.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: -- Processing global variables
19: G_BATCH_STATUS VARCHAR2(30) := NULL;

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: -- Processing global variables
19: G_BATCH_STATUS VARCHAR2(30) := NULL;
20: G_BATCH_CURRENCY_CODE VARCHAR2(30) := NULL;

Line 151: fnd_msg_pub.Count_And_Get(

147: resultout := l_resultout;
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: fnd_msg_pub.Count_And_Get(
152: p_encoded => FND_API.G_TRUE
153: ,p_count => l_msg_count
154: ,p_data => l_msg_data);
155:

Line 159: fnd_msg_pub.Count_And_Get(

155:
156: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
157: raise;
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: fnd_msg_pub.Count_And_Get(
160: p_encoded => FND_API.G_TRUE
161: ,p_count => l_msg_count
162: ,p_data => l_msg_data);
163:

Line 167: fnd_msg_pub.Count_And_Get(

163:
164: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
165: raise;
166: WHEN OTHERS THEN
167: fnd_msg_pub.Count_And_Get(
168: p_encoded => FND_API.G_TRUE
169: ,p_count => l_msg_count
170: ,p_data => l_msg_data);
171:

Line 261: FND_MSG_PUB.Count_And_Get (

257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => l_msg_count,
264: p_data => l_msg_data
265: );

Line 269: FND_MSG_PUB.Count_And_Get (

265: );
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => l_msg_count,
272: p_data => l_msg_data
273: );

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

272: p_data => l_msg_data
273: );
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message

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

274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,

Line 281: FND_MSG_PUB.Count_And_Get (

277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,
283: p_count => l_msg_count,
284: p_data => l_msg_data
285: );

Line 341: FND_MSG_PUB.initialize;

337:
338: -- Initialize message list if p_init_msg_list is set to TRUE.
339: IF FND_API.to_Boolean( p_init_msg_list )
340: THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: IF OZF_DEBUG_HIGH_ON THEN
345: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': start');

Line 489: FND_MSG_PUB.Count_And_Get

485: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': end');
486: END IF;
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get
490: (p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493:

Line 504: FND_MSG_PUB.Count_And_Get (

500: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
501: WHERE resale_batch_id = p_batch_id;
502:
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data);
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 517: FND_MSG_PUB.Count_And_Get (

513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
514: WHERE resale_batch_id = p_batch_id;
515:
516: -- Standard call to get message count and if count=1, get the message
517: FND_MSG_PUB.Count_And_Get (
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: WHEN OTHERS THEN

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

525: Update ozf_resale_batches
526: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
527: WHERE resale_batch_id = p_batch_id;
528:
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message

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

527: WHERE resale_batch_id = p_batch_id;
528:
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,

Line 534: FND_MSG_PUB.Count_And_Get (

530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:

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

648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: WHEN OTHERS THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF OZF_UNEXP_ERROR THEN
652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
653: END IF;
654: END Batch_Update;
655:
656: PROCEDURE Batch_Fetch

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

774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: WHEN OTHERS THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF OZF_UNEXP_ERROR THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: END Batch_Fetch;
781:
782: PROCEDURE Validate_Batch

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

1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: WHEN OTHERS THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: IF OZF_UNEXP_ERROR THEN
1018: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1019: END IF;
1020: END Validate_Batch;
1021:
1022: PROCEDURE Batch_Defaulting

Line 1286: FND_MSG_PUB.Count_And_Get (

1282: ozf_utility_pvt.debug_message(l_api_name||': End');
1283: END IF;
1284:
1285: --Standard call to get message count AND IF count=1, get the message
1286: FND_MSG_PUB.Count_And_Get (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data
1290: );

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

1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297: WHEN OTHERS THEN
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: IF OZF_UNEXP_ERROR THEN
1300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1301: END IF;
1302: END Batch_Defaulting;
1303:
1304:

Line 1696: FND_MSG_PUB.Count_And_Get (

1692: EXCEPTION
1693: WHEN FND_API.G_EXC_ERROR THEN
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695: -- Standard call to get message count and if count=1, get the message
1696: FND_MSG_PUB.Count_And_Get (
1697: p_encoded => FND_API.G_FALSE,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data
1700: );

Line 1704: FND_MSG_PUB.Count_And_Get (

1700: );
1701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: -- Standard call to get message count and if count=1, get the message
1704: FND_MSG_PUB.Count_And_Get (
1705: p_encoded => FND_API.G_FALSE,
1706: p_count => x_msg_count,
1707: p_data => x_msg_data
1708: );

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

1708: );
1709: WHEN OTHERS THEN
1710:
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1712: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1713: THEN
1714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1715: END IF;
1716: -- Standard call to get message count and if count=1, get the message

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

1710:
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1712: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1713: THEN
1714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1715: END IF;
1716: -- Standard call to get message count and if count=1, get the message
1717: FND_MSG_PUB.Count_And_Get (
1718: p_encoded => FND_API.G_FALSE,

Line 1717: FND_MSG_PUB.Count_And_Get (

1713: THEN
1714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1715: END IF;
1716: -- Standard call to get message count and if count=1, get the message
1717: FND_MSG_PUB.Count_And_Get (
1718: p_encoded => FND_API.G_FALSE,
1719: p_count => x_msg_count,
1720: p_data => x_msg_data
1721: );

Line 1800: FND_MSG_PUB.Count_And_Get (

1796: EXCEPTION
1797: WHEN FND_API.G_EXC_ERROR THEN
1798: x_return_status := FND_API.G_RET_STS_ERROR;
1799: -- Standard call to get message count and if count=1, get the message
1800: FND_MSG_PUB.Count_And_Get (
1801: p_encoded => FND_API.G_FALSE,
1802: p_count => x_msg_count,
1803: p_data => x_msg_data
1804: );

Line 1808: FND_MSG_PUB.Count_And_Get (

1804: );
1805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1807: -- Standard call to get message count and if count=1, get the message
1808: FND_MSG_PUB.Count_And_Get (
1809: p_encoded => FND_API.G_FALSE,
1810: p_count => x_msg_count,
1811: p_data => x_msg_data
1812: );

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

1812: );
1813: WHEN OTHERS THEN
1814:
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1819: END IF;
1820: -- Standard call to get message count and if count=1, get the message

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

1814:
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1819: END IF;
1820: -- Standard call to get message count and if count=1, get the message
1821: FND_MSG_PUB.Count_And_Get (
1822: p_encoded => FND_API.G_FALSE,

Line 1821: FND_MSG_PUB.Count_And_Get (

1817: THEN
1818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1819: END IF;
1820: -- Standard call to get message count and if count=1, get the message
1821: FND_MSG_PUB.Count_And_Get (
1822: p_encoded => FND_API.G_FALSE,
1823: p_count => x_msg_count,
1824: p_data => x_msg_data
1825: );

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

1995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1997: WHEN OTHERS THEN
1998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2000: THEN
2001: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2002: END IF;
2003: END Lines_Bulk_Update;

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

1997: WHEN OTHERS THEN
1998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2000: THEN
2001: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2002: END IF;
2003: END Lines_Bulk_Update;
2004:
2005: PROCEDURE Line_Defaulting

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

2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: WHEN OTHERS THEN
2186: IF OZF_UNEXP_ERROR THEN
2187: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2188: END IF;
2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: END Line_Defaulting;
2191:

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

2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2868: WHEN OTHERS THEN
2869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2870: IF OZF_UNEXP_ERROR THEN
2871: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2872: END IF;
2873: END Line_Validations;
2874:
2875:

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

3068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3071: IF OZF_UNEXP_ERROR THEN
3072: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3073: END IF;
3074: END End_Cust_Party_Mapping;
3075:
3076:

Line 3234: FND_MSG_PUB.Count_And_Get (

3230: EXCEPTION
3231: WHEN FND_API.G_EXC_ERROR THEN
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: -- Standard call to get message count and if count=1, get the message
3234: FND_MSG_PUB.Count_And_Get (
3235: p_encoded => FND_API.G_FALSE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data
3238: );

Line 3242: FND_MSG_PUB.Count_And_Get (

3238: );
3239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3241: -- Standard call to get message count and if count=1, get the message
3242: FND_MSG_PUB.Count_And_Get (
3243: p_encoded => FND_API.G_FALSE,
3244: p_count => x_msg_count,
3245: p_data => x_msg_data
3246: );

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

3246: );
3247: WHEN OTHERS THEN
3248:
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3250: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3251: THEN
3252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3253: END IF;
3254: -- Standard call to get message count and if count=1, get the message

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

3248:
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3250: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3251: THEN
3252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3253: END IF;
3254: -- Standard call to get message count and if count=1, get the message
3255: FND_MSG_PUB.Count_And_Get (
3256: p_encoded => FND_API.G_FALSE,

Line 3255: FND_MSG_PUB.Count_And_Get (

3251: THEN
3252: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3253: END IF;
3254: -- Standard call to get message count and if count=1, get the message
3255: FND_MSG_PUB.Count_And_Get (
3256: p_encoded => FND_API.G_FALSE,
3257: p_count => x_msg_count,
3258: p_data => x_msg_data
3259: );

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

3628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3629: WHEN OTHERS THEN
3630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3631: IF OZF_UNEXP_ERROR THEN
3632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3633: END IF;
3634: END Line_Party_Validations;
3635:
3636:

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

3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: WHEN OTHERS THEN
3736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3737: IF OZF_UNEXP_ERROR THEN
3738: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3739: END IF;
3740: END Line_Currency_Price_Derivation;
3741:
3742: PROCEDURE Currency_Price_Derivation

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

3979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3980: WHEN OTHERS THEN
3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3982: IF OZF_UNEXP_ERROR THEN
3983: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3984: END IF;
3985: END Currency_Price_Derivation;
3986:
3987:

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

4048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4049: WHEN OTHERS THEN
4050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4051: IF OZF_UNEXP_ERROR THEN
4052: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4053: END IF;
4054: END Get_Agreement_Name;
4055:
4056:

Line 4337: FND_MSG_PUB.Count_And_Get

4333: IF OZF_DEBUG_HIGH_ON THEN
4334: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
4335: END IF;
4336: -- Standard call to get message count and if count is 1, get message info.
4337: FND_MSG_PUB.Count_And_Get
4338: (p_count => x_msg_count,
4339: p_data => x_msg_data
4340: );
4341:

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

4346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4347: WHEN OTHERS THEN
4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4349: IF OZF_UNEXP_ERROR THEN
4350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4351: END IF;
4352:
4353: END Agreement_Default;
4354:

Line 4535: FND_MSG_PUB.Count_And_Get(

4531: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': end');
4532: END IF;
4533:
4534: -- Standard call to get message count and if count is 1, get message info.
4535: FND_MSG_PUB.Count_And_Get(
4536: p_count => x_msg_count,
4537: p_data => x_msg_data
4538: );
4539:

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

4544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4545: WHEN OTHERS THEN
4546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4547: IF OZF_UNEXP_ERROR THEN
4548: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4549: END IF;
4550:
4551: END Product_Validations;
4552:

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

4764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4765: WHEN OTHERS THEN
4766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4767: IF OZF_UNEXP_ERROR THEN
4768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4769: END IF;
4770: END UOM_Code_Mapping;
4771:
4772: PROCEDURE Party_Mapping

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

5011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5012: WHEN OTHERS THEN
5013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5014: IF OZF_UNEXP_ERROR THEN
5015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5016: END IF;
5017: END Party_Mapping;
5018:
5019:

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

5925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5926: WHEN OTHERS THEN
5927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5928: IF OZF_UNEXP_ERROR THEN
5929: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5930: END IF;
5931: END Party_Validations;
5932:
5933:

Line 6041: FND_MSG_PUB.initialize;

6037:
6038: -- Initialize message list if p_init_msg_list is set to TRUE.
6039: IF FND_API.to_Boolean( p_init_msg_list )
6040: THEN
6041: FND_MSG_PUB.initialize;
6042: END IF;
6043:
6044: -- Debug Message
6045: IF OZF_DEBUG_HIGH_ON THEN

Line 6349: FND_MSG_PUB.Count_And_Get

6345: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
6346: END IF;
6347:
6348: -- Standard call to get message count and if count is 1, get message info.
6349: FND_MSG_PUB.Count_And_Get
6350: (p_count => x_msg_count,
6351: p_data => x_msg_data
6352: );
6353:

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

6358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6359: WHEN OTHERS THEN
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361: IF OZF_UNEXP_ERROR THEN
6362: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6363: END IF;
6364:
6365: END DQM_Processing;
6366:

Line 6466: FND_MSG_PUB.Count_And_Get

6462: IF OZF_DEBUG_HIGH_ON THEN
6463: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
6464: END IF;
6465: -- Standard call to get message count and if count is 1, get message info.
6466: FND_MSG_PUB.Count_And_Get
6467: (p_count => x_msg_count,
6468: p_data => x_msg_data
6469: );
6470:

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

6476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6477: WHEN OTHERS THEN
6478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6479: IF OZF_UNEXP_ERROR THEN
6480: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6481: END IF;
6482:
6483: END Code_Conversion;
6484:

Line 6592: FND_MSG_PUB.add;

6588: IF p_party_id IS NULL AND
6589: p_party_site_id IS NULL
6590: THEN
6591: FND_MESSAGE.set_name('OZF', 'OZF_BATCH_PARTNER_NULL');
6592: FND_MSG_PUB.add;
6593: RAISE FND_API.G_EXC_ERROR;
6594: END IF;
6595:
6596: -- get customer account based on party site id

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

6618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6620: WHEN OTHERS THEN
6621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6623: THEN
6624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6625: END IF;
6626: END Get_Customer_Accnt_Id;

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

6620: WHEN OTHERS THEN
6621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6623: THEN
6624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6625: END IF;
6626: END Get_Customer_Accnt_Id;
6627:
6628: PROCEDURE Get_party_site_from_ECX

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

6674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6676: WHEN OTHERS THEN
6677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6679: THEN
6680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6681: END IF;
6682:

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

6676: WHEN OTHERS THEN
6677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6679: THEN
6680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6681: END IF;
6682:
6683: END Get_party_site_from_ECX;
6684:

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

6776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6778: WHEN OTHERS THEN
6779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6780: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6781: THEN
6782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6783: END IF;
6784:

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

6778: WHEN OTHERS THEN
6779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6780: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6781: THEN
6782: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6783: END IF;
6784:
6785: END Chk_party_record_null;
6786:

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

7048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7050: WHEN OTHERS THEN
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7053: THEN
7054: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7055: END IF;
7056:

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

7050: WHEN OTHERS THEN
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7053: THEN
7054: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7055: END IF;
7056:
7057: END derive_party;
7058:

Line 7341: FND_MSG_PUB.Count_And_Get

7337: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
7338: END IF;
7339:
7340: -- Standard call to get message count and if count is 1, get message info.
7341: FND_MSG_PUB.Count_And_Get
7342: (p_count => x_msg_count,
7343: p_data => x_msg_data
7344: );
7345:

Line 7350: FND_MSG_PUB.Count_And_Get (

7346: EXCEPTION
7347: WHEN FND_API.G_EXC_ERROR THEN
7348: x_return_status := FND_API.G_RET_STS_ERROR;
7349: -- Standard call to get message count and if count=1, get the message
7350: FND_MSG_PUB.Count_And_Get (
7351: p_encoded => FND_API.G_FALSE,
7352: p_count => x_msg_count,
7353: p_data => x_msg_data
7354: );

Line 7358: FND_MSG_PUB.Count_And_Get (

7354: );
7355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7357: -- Standard call to get message count and if count=1, get the message
7358: FND_MSG_PUB.Count_And_Get (
7359: p_encoded => FND_API.G_FALSE,
7360: p_count => x_msg_count,
7361: p_data => x_msg_data
7362: );

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

7361: p_data => x_msg_data
7362: );
7363: WHEN OTHERS THEN
7364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7366: THEN
7367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7368: END IF;
7369: -- Standard call to get message count and if count=1, get the message

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

7363: WHEN OTHERS THEN
7364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7365: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7366: THEN
7367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7368: END IF;
7369: -- Standard call to get message count and if count=1, get the message
7370: FND_MSG_PUB.Count_And_Get (
7371: p_encoded => FND_API.G_FALSE,

Line 7370: FND_MSG_PUB.Count_And_Get (

7366: THEN
7367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7368: END IF;
7369: -- Standard call to get message count and if count=1, get the message
7370: FND_MSG_PUB.Count_And_Get (
7371: p_encoded => FND_API.G_FALSE,
7372: p_count => x_msg_count,
7373: p_data => x_msg_data
7374: );

Line 7500: FND_MSG_PUB.Count_And_Get

7496: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
7497: END IF;
7498:
7499: -- Standard call to get message count and if count is 1, get message info.
7500: FND_MSG_PUB.Count_And_Get
7501: (p_count => x_msg_count,
7502: p_data => x_msg_data
7503: );
7504:

Line 7510: FND_MSG_PUB.Count_And_Get (

7506:
7507: WHEN FND_API.G_EXC_ERROR THEN
7508: x_return_status := FND_API.G_RET_STS_ERROR;
7509: -- Standard call to get message count and if count=1, get the message
7510: FND_MSG_PUB.Count_And_Get (
7511: p_encoded => FND_API.G_FALSE,
7512: p_count => x_msg_count,
7513: p_data => x_msg_data
7514: );

Line 7518: FND_MSG_PUB.Count_And_Get (

7514: );
7515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7517: -- Standard call to get message count and if count=1, get the message
7518: FND_MSG_PUB.Count_And_Get (
7519: p_encoded => FND_API.G_FALSE,
7520: p_count => x_msg_count,
7521: p_data => x_msg_data
7522: );

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

7522: );
7523: WHEN OTHERS THEN
7524:
7525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7526: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7529: END IF;
7530: -- Standard call to get message count and if count=1, get the message

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

7524:
7525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7526: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7529: END IF;
7530: -- Standard call to get message count and if count=1, get the message
7531: FND_MSG_PUB.Count_And_Get (
7532: p_encoded => FND_API.G_FALSE,

Line 7531: FND_MSG_PUB.Count_And_Get (

7527: THEN
7528: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7529: END IF;
7530: -- Standard call to get message count and if count=1, get the message
7531: FND_MSG_PUB.Count_And_Get (
7532: p_encoded => FND_API.G_FALSE,
7533: p_count => x_msg_count,
7534: p_data => x_msg_data
7535: );

Line 7646: fnd_msg_pub.Count_And_Get(

7642: return;
7643:
7644: EXCEPTION
7645: WHEN FND_API.G_EXC_ERROR THEN
7646: fnd_msg_pub.Count_And_Get(
7647: p_encoded => FND_API.G_TRUE
7648: ,p_count => l_msg_count
7649: ,p_data => l_msg_data);
7650:

Line 7654: fnd_msg_pub.Count_And_Get(

7650:
7651: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7652: raise;
7653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7654: fnd_msg_pub.Count_And_Get(
7655: p_encoded => FND_API.G_TRUE
7656: ,p_count => l_msg_count
7657: ,p_data => l_msg_data);
7658:

Line 7662: fnd_msg_pub.Count_And_Get(

7658:
7659: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7660: raise;
7661: WHEN OTHERS THEN
7662: fnd_msg_pub.Count_And_Get(
7663: p_encoded => FND_API.G_TRUE
7664: ,p_count => l_msg_count
7665: ,p_data => l_msg_data);
7666:

Line 7723: fnd_msg_pub.Count_And_Get(

7719: END IF;
7720: return;
7721: EXCEPTION
7722: WHEN FND_API.G_EXC_ERROR THEN
7723: fnd_msg_pub.Count_And_Get(
7724: p_encoded => FND_API.G_TRUE
7725: ,p_count => l_msg_count
7726: ,p_data => l_msg_data);
7727:

Line 7731: fnd_msg_pub.Count_And_Get(

7727:
7728: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7729: raise;
7730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7731: fnd_msg_pub.Count_And_Get(
7732: p_encoded => FND_API.G_TRUE
7733: ,p_count => l_msg_count
7734: ,p_data => l_msg_data);
7735:

Line 7739: fnd_msg_pub.Count_And_Get(

7735:
7736: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7737: raise;
7738: WHEN OTHERS THEN
7739: fnd_msg_pub.Count_And_Get(
7740: p_encoded => FND_API.G_TRUE
7741: ,p_count => l_msg_count
7742: ,p_data => l_msg_data);
7743:

Line 7820: fnd_msg_pub.Count_And_Get(

7816: resultout := l_resultout;
7817:
7818: EXCEPTION
7819: WHEN FND_API.G_EXC_ERROR THEN
7820: fnd_msg_pub.Count_And_Get(
7821: p_encoded => FND_API.G_TRUE
7822: ,p_count => l_msg_count
7823: ,p_data => l_msg_data);
7824:

Line 7828: fnd_msg_pub.Count_And_Get(

7824:
7825: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7826: raise;
7827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7828: fnd_msg_pub.Count_And_Get(
7829: p_encoded => FND_API.G_TRUE
7830: ,p_count => l_msg_count
7831: ,p_data => l_msg_data);
7832:

Line 7836: fnd_msg_pub.Count_And_Get(

7832:
7833: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7834: raise;
7835: WHEN OTHERS THEN
7836: fnd_msg_pub.Count_And_Get(
7837: p_encoded => FND_API.G_TRUE
7838: ,p_count => l_msg_count
7839: ,p_data => l_msg_data);
7840:

Line 7908: fnd_msg_pub.Count_And_Get(

7904: resultout := l_resultout;
7905:
7906: EXCEPTION
7907: WHEN FND_API.G_EXC_ERROR THEN
7908: fnd_msg_pub.Count_And_Get(
7909: p_encoded => FND_API.G_TRUE
7910: ,p_count => l_msg_count
7911: ,p_data => l_msg_data);
7912:

Line 7916: fnd_msg_pub.Count_And_Get(

7912:
7913: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7914: raise;
7915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7916: fnd_msg_pub.Count_And_Get(
7917: p_encoded => FND_API.G_TRUE
7918: ,p_count => l_msg_count
7919: ,p_data => l_msg_data);
7920:

Line 7924: fnd_msg_pub.Count_And_Get(

7920:
7921: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
7922: raise;
7923: WHEN OTHERS THEN
7924: fnd_msg_pub.Count_And_Get(
7925: p_encoded => FND_API.G_TRUE
7926: ,p_count => l_msg_count
7927: ,p_data => l_msg_data);
7928:

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

8171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8173: WHEN OTHERS THEN
8174: IF OZF_UNEXP_ERROR THEN
8175: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8176: END IF;
8177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8178: END Insert_Resale_Log;
8179: