DBA Data[Home] [Help]

APPS.OZF_PRE_PROCESS_PVT dependencies on FND_MSG_PUB

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

17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ozf_pre_process_pvt';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvprsb.pls';
20:
21: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:

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

18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ozf_pre_process_pvt';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvprsb.pls';
20:
21: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: -- Processing global variables

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

19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvprsb.pls';
20:
21: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: -- Processing global variables
27: G_BATCH_STATUS VARCHAR2(30) := NULL;

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

20:
21: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
22: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
23: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
24: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
25:
26: -- Processing global variables
27: G_BATCH_STATUS VARCHAR2(30) := NULL;
28: G_BATCH_CURRENCY_CODE VARCHAR2(30) := NULL;

Line 160: fnd_msg_pub.Count_And_Get(

156: resultout := l_resultout;
157:
158: EXCEPTION
159: WHEN FND_API.G_EXC_ERROR THEN
160: fnd_msg_pub.Count_And_Get(
161: p_encoded => FND_API.G_TRUE
162: ,p_count => l_msg_count
163: ,p_data => l_msg_data);
164:

Line 168: fnd_msg_pub.Count_And_Get(

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

Line 176: fnd_msg_pub.Count_And_Get(

172:
173: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
174: raise;
175: WHEN OTHERS THEN
176: fnd_msg_pub.Count_And_Get(
177: p_encoded => FND_API.G_TRUE
178: ,p_count => l_msg_count
179: ,p_data => l_msg_data);
180:

Line 274: FND_MSG_PUB.Count_And_Get (

270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => l_msg_count,
277: p_data => l_msg_data
278: );

Line 282: FND_MSG_PUB.Count_And_Get (

278: );
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: -- Standard call to get message count and if count=1, get the message
282: FND_MSG_PUB.Count_And_Get (
283: p_encoded => FND_API.G_FALSE,
284: p_count => l_msg_count,
285: p_data => l_msg_data
286: );

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

285: p_data => l_msg_data
286: );
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message

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

287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get (
295: p_encoded => FND_API.G_FALSE,

Line 294: FND_MSG_PUB.Count_And_Get (

290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get (
295: p_encoded => FND_API.G_FALSE,
296: p_count => l_msg_count,
297: p_data => l_msg_data
298: );

Line 354: FND_MSG_PUB.initialize;

350:
351: -- Initialize message list if p_init_msg_list is set to TRUE.
352: IF FND_API.to_Boolean( p_init_msg_list )
353: THEN
354: FND_MSG_PUB.initialize;
355: END IF;
356:
357: IF OZF_DEBUG_HIGH_ON THEN
358: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': start');

Line 503: FND_MSG_PUB.Count_And_Get

499: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': end');
500: END IF;
501:
502: -- Standard call to get message count and if count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get
504: (p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507:

Line 518: FND_MSG_PUB.Count_And_Get (

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

Line 531: FND_MSG_PUB.Count_And_Get (

527: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
528: WHERE resale_batch_id = p_batch_id;
529:
530: -- Standard call to get message count and if count=1, get the message
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_msg_count,
534: p_data => x_msg_data);
535: WHEN OTHERS THEN

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

539: Update ozf_resale_batches
540: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
541: WHERE resale_batch_id = p_batch_id;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547: -- Standard call to get message count and if count=1, get the message

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

541: WHERE resale_batch_id = p_batch_id;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547: -- Standard call to get message count and if count=1, get the message
548: FND_MSG_PUB.Count_And_Get (
549: p_encoded => FND_API.G_FALSE,

Line 548: FND_MSG_PUB.Count_And_Get (

544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547: -- Standard call to get message count and if count=1, get the message
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 666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: WHEN OTHERS THEN
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: IF OZF_UNEXP_ERROR THEN
666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
667: END IF;
668: END Batch_Update;
669:
670: PROCEDURE Batch_Fetch

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

793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF OZF_UNEXP_ERROR THEN
797: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
798: END IF;
799: END Batch_Fetch;
800:
801: PROCEDURE Validate_Batch

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

1033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: IF OZF_UNEXP_ERROR THEN
1037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1038: END IF;
1039: END Validate_Batch;
1040:
1041: PROCEDURE Batch_Defaulting

Line 1305: FND_MSG_PUB.Count_And_Get (

1301: ozf_utility_pvt.debug_message(l_api_name||': End');
1302: END IF;
1303:
1304: --Standard call to get message count AND IF count=1, get the message
1305: FND_MSG_PUB.Count_And_Get (
1306: p_encoded => FND_API.G_FALSE,
1307: p_count => x_msg_count,
1308: p_data => x_msg_data
1309: );

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

1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316: WHEN OTHERS THEN
1317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1318: IF OZF_UNEXP_ERROR THEN
1319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1320: END IF;
1321: END Batch_Defaulting;
1322:
1323:

Line 1725: FND_MSG_PUB.Count_And_Get (

1721: EXCEPTION
1722: WHEN FND_API.G_EXC_ERROR THEN
1723: x_return_status := FND_API.G_RET_STS_ERROR;
1724: -- Standard call to get message count and if count=1, get the message
1725: FND_MSG_PUB.Count_And_Get (
1726: p_encoded => FND_API.G_FALSE,
1727: p_count => x_msg_count,
1728: p_data => x_msg_data
1729: );

Line 1733: FND_MSG_PUB.Count_And_Get (

1729: );
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: -- Standard call to get message count and if count=1, get the message
1733: FND_MSG_PUB.Count_And_Get (
1734: p_encoded => FND_API.G_FALSE,
1735: p_count => x_msg_count,
1736: p_data => x_msg_data
1737: );

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

1737: );
1738: WHEN OTHERS THEN
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1742: THEN
1743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1744: END IF;
1745: -- Standard call to get message count and if count=1, get the message

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

1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1742: THEN
1743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1744: END IF;
1745: -- Standard call to get message count and if count=1, get the message
1746: FND_MSG_PUB.Count_And_Get (
1747: p_encoded => FND_API.G_FALSE,

Line 1746: FND_MSG_PUB.Count_And_Get (

1742: THEN
1743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1744: END IF;
1745: -- Standard call to get message count and if count=1, get the message
1746: FND_MSG_PUB.Count_And_Get (
1747: p_encoded => FND_API.G_FALSE,
1748: p_count => x_msg_count,
1749: p_data => x_msg_data
1750: );

Line 1833: FND_MSG_PUB.Count_And_Get (

1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: -- Standard call to get message count and if count=1, get the message
1833: FND_MSG_PUB.Count_And_Get (
1834: p_encoded => FND_API.G_FALSE,
1835: p_count => x_msg_count,
1836: p_data => x_msg_data
1837: );

Line 1841: FND_MSG_PUB.Count_And_Get (

1837: );
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: -- Standard call to get message count and if count=1, get the message
1841: FND_MSG_PUB.Count_And_Get (
1842: p_encoded => FND_API.G_FALSE,
1843: p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );

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

1845: );
1846: WHEN OTHERS THEN
1847:
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1852: END IF;
1853: -- Standard call to get message count and if count=1, get the message

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

1847:
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1849: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1852: END IF;
1853: -- Standard call to get message count and if count=1, get the message
1854: FND_MSG_PUB.Count_And_Get (
1855: p_encoded => FND_API.G_FALSE,

Line 1854: FND_MSG_PUB.Count_And_Get (

1850: THEN
1851: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1852: END IF;
1853: -- Standard call to get message count and if count=1, get the message
1854: FND_MSG_PUB.Count_And_Get (
1855: p_encoded => FND_API.G_FALSE,
1856: p_count => x_msg_count,
1857: p_data => x_msg_data
1858: );

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

2029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2031: WHEN OTHERS THEN
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2036: END IF;
2037: END Lines_Bulk_Update;

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

2031: WHEN OTHERS THEN
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2034: THEN
2035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2036: END IF;
2037: END Lines_Bulk_Update;
2038:
2039:

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

2265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: WHEN OTHERS THEN
2268: IF OZF_UNEXP_ERROR THEN
2269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2270: END IF;
2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2272: END Line_Defaulting;
2273:

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

3037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3038: WHEN OTHERS THEN
3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3040: IF OZF_UNEXP_ERROR THEN
3041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3042: END IF;
3043: END Line_Validations;
3044:
3045:

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

3321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3322: WHEN OTHERS THEN
3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3324: IF OZF_UNEXP_ERROR THEN
3325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3326: END IF;
3327: END End_Cust_Party_Mapping;
3328:
3329:

Line 3563: FND_MSG_PUB.Count_And_Get (

3559: EXCEPTION
3560: WHEN FND_API.G_EXC_ERROR THEN
3561: x_return_status := FND_API.G_RET_STS_ERROR;
3562: -- Standard call to get message count and if count=1, get the message
3563: FND_MSG_PUB.Count_And_Get (
3564: p_encoded => FND_API.G_FALSE,
3565: p_count => x_msg_count,
3566: p_data => x_msg_data
3567: );

Line 3571: FND_MSG_PUB.Count_And_Get (

3567: );
3568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3570: -- Standard call to get message count and if count=1, get the message
3571: FND_MSG_PUB.Count_And_Get (
3572: p_encoded => FND_API.G_FALSE,
3573: p_count => x_msg_count,
3574: p_data => x_msg_data
3575: );

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

3575: );
3576: WHEN OTHERS THEN
3577:
3578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3579: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3580: THEN
3581: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3582: END IF;
3583: -- Standard call to get message count and if count=1, get the message

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

3577:
3578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3579: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3580: THEN
3581: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3582: END IF;
3583: -- Standard call to get message count and if count=1, get the message
3584: FND_MSG_PUB.Count_And_Get (
3585: p_encoded => FND_API.G_FALSE,

Line 3584: FND_MSG_PUB.Count_And_Get (

3580: THEN
3581: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3582: END IF;
3583: -- Standard call to get message count and if count=1, get the message
3584: FND_MSG_PUB.Count_And_Get (
3585: p_encoded => FND_API.G_FALSE,
3586: p_count => x_msg_count,
3587: p_data => x_msg_data
3588: );

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

3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957: WHEN OTHERS THEN
3958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3959: IF OZF_UNEXP_ERROR THEN
3960: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3961: END IF;
3962: END Line_Party_Validations;
3963:
3964:

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

4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063: WHEN OTHERS THEN
4064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4065: IF OZF_UNEXP_ERROR THEN
4066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4067: END IF;
4068: END Line_Currency_Price_Derivation;
4069:
4070: PROCEDURE Currency_Price_Derivation

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

4307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4308: WHEN OTHERS THEN
4309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4310: IF OZF_UNEXP_ERROR THEN
4311: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4312: END IF;
4313: END Currency_Price_Derivation;
4314:
4315:

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

4376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4377: WHEN OTHERS THEN
4378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4379: IF OZF_UNEXP_ERROR THEN
4380: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4381: END IF;
4382: END Get_Agreement_Name;
4383:
4384:

Line 4672: FND_MSG_PUB.Count_And_Get

4668: IF OZF_DEBUG_HIGH_ON THEN
4669: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
4670: END IF;
4671: -- Standard call to get message count and if count is 1, get message info.
4672: FND_MSG_PUB.Count_And_Get
4673: (p_count => x_msg_count,
4674: p_data => x_msg_data
4675: );
4676:

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

4681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4682: WHEN OTHERS THEN
4683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4684: IF OZF_UNEXP_ERROR THEN
4685: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4686: END IF;
4687:
4688: END Agreement_Default;
4689:

Line 4870: FND_MSG_PUB.Count_And_Get(

4866: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ': end');
4867: END IF;
4868:
4869: -- Standard call to get message count and if count is 1, get message info.
4870: FND_MSG_PUB.Count_And_Get(
4871: p_count => x_msg_count,
4872: p_data => x_msg_data
4873: );
4874:

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

4879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4880: WHEN OTHERS THEN
4881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4882: IF OZF_UNEXP_ERROR THEN
4883: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4884: END IF;
4885:
4886: END Product_Validations;
4887:

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

5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5100: WHEN OTHERS THEN
5101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5102: IF OZF_UNEXP_ERROR THEN
5103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5104: END IF;
5105: END UOM_Code_Mapping;
5106:
5107: --//Bugfix 12649013 - Added additional parameters to perform code mapping and added code to perform code mapping and validations.

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

5452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5453: WHEN OTHERS THEN
5454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5455: IF OZF_UNEXP_ERROR THEN
5456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5457: END IF;
5458: END Party_Mapping;
5459:
5460:

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

6378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6379: WHEN OTHERS THEN
6380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6381: IF OZF_UNEXP_ERROR THEN
6382: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6383: END IF;
6384: END Party_Validations;
6385:
6386:

Line 6494: FND_MSG_PUB.initialize;

6490:
6491: -- Initialize message list if p_init_msg_list is set to TRUE.
6492: IF FND_API.to_Boolean( p_init_msg_list )
6493: THEN
6494: FND_MSG_PUB.initialize;
6495: END IF;
6496:
6497: -- Debug Message
6498: IF OZF_DEBUG_HIGH_ON THEN

Line 6802: FND_MSG_PUB.Count_And_Get

6798: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
6799: END IF;
6800:
6801: -- Standard call to get message count and if count is 1, get message info.
6802: FND_MSG_PUB.Count_And_Get
6803: (p_count => x_msg_count,
6804: p_data => x_msg_data
6805: );
6806:

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

6811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6812: WHEN OTHERS THEN
6813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6814: IF OZF_UNEXP_ERROR THEN
6815: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6816: END IF;
6817:
6818: END DQM_Processing;
6819:

Line 6919: FND_MSG_PUB.Count_And_Get

6915: IF OZF_DEBUG_HIGH_ON THEN
6916: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
6917: END IF;
6918: -- Standard call to get message count and if count is 1, get message info.
6919: FND_MSG_PUB.Count_And_Get
6920: (p_count => x_msg_count,
6921: p_data => x_msg_data
6922: );
6923:

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

6929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6930: WHEN OTHERS THEN
6931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6932: IF OZF_UNEXP_ERROR THEN
6933: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6934: END IF;
6935:
6936: END Code_Conversion;
6937:

Line 7045: FND_MSG_PUB.add;

7041: IF p_party_id IS NULL AND
7042: p_party_site_id IS NULL
7043: THEN
7044: FND_MESSAGE.set_name('OZF', 'OZF_BATCH_PARTNER_NULL');
7045: FND_MSG_PUB.add;
7046: RAISE FND_API.G_EXC_ERROR;
7047: END IF;
7048:
7049: -- get customer account based on party site id

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

7071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7073: WHEN OTHERS THEN
7074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7075: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7076: THEN
7077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7078: END IF;
7079: END Get_Customer_Accnt_Id;

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

7073: WHEN OTHERS THEN
7074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7075: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7076: THEN
7077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7078: END IF;
7079: END Get_Customer_Accnt_Id;
7080:
7081: PROCEDURE Get_party_site_from_ECX

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

7127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7129: WHEN OTHERS THEN
7130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7131: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7132: THEN
7133: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7134: END IF;
7135:

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

7129: WHEN OTHERS THEN
7130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7131: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7132: THEN
7133: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7134: END IF;
7135:
7136: END Get_party_site_from_ECX;
7137:

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

7229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7231: WHEN OTHERS THEN
7232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7234: THEN
7235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7236: END IF;
7237:

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

7231: WHEN OTHERS THEN
7232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7234: THEN
7235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7236: END IF;
7237:
7238: END Chk_party_record_null;
7239:

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

7504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7506: WHEN OTHERS THEN
7507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7509: THEN
7510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7511: END IF;
7512:

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

7506: WHEN OTHERS THEN
7507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7509: THEN
7510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7511: END IF;
7512:
7513: END derive_party;
7514:

Line 7806: FND_MSG_PUB.Count_And_Get

7802: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
7803: END IF;
7804:
7805: -- Standard call to get message count and if count is 1, get message info.
7806: FND_MSG_PUB.Count_And_Get
7807: (p_count => x_msg_count,
7808: p_data => x_msg_data
7809: );
7810:

Line 7815: FND_MSG_PUB.Count_And_Get (

7811: EXCEPTION
7812: WHEN FND_API.G_EXC_ERROR THEN
7813: x_return_status := FND_API.G_RET_STS_ERROR;
7814: -- Standard call to get message count and if count=1, get the message
7815: FND_MSG_PUB.Count_And_Get (
7816: p_encoded => FND_API.G_FALSE,
7817: p_count => x_msg_count,
7818: p_data => x_msg_data
7819: );

Line 7823: FND_MSG_PUB.Count_And_Get (

7819: );
7820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7822: -- Standard call to get message count and if count=1, get the message
7823: FND_MSG_PUB.Count_And_Get (
7824: p_encoded => FND_API.G_FALSE,
7825: p_count => x_msg_count,
7826: p_data => x_msg_data
7827: );

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

7826: p_data => x_msg_data
7827: );
7828: WHEN OTHERS THEN
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7830: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7831: THEN
7832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7833: END IF;
7834: -- Standard call to get message count and if count=1, get the message

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

7828: WHEN OTHERS THEN
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7830: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7831: THEN
7832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7833: END IF;
7834: -- Standard call to get message count and if count=1, get the message
7835: FND_MSG_PUB.Count_And_Get (
7836: p_encoded => FND_API.G_FALSE,

Line 7835: FND_MSG_PUB.Count_And_Get (

7831: THEN
7832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7833: END IF;
7834: -- Standard call to get message count and if count=1, get the message
7835: FND_MSG_PUB.Count_And_Get (
7836: p_encoded => FND_API.G_FALSE,
7837: p_count => x_msg_count,
7838: p_data => x_msg_data
7839: );

Line 7967: FND_MSG_PUB.Count_And_Get

7963: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || ' end');
7964: END IF;
7965:
7966: -- Standard call to get message count and if count is 1, get message info.
7967: FND_MSG_PUB.Count_And_Get
7968: (p_count => x_msg_count,
7969: p_data => x_msg_data
7970: );
7971:

Line 7977: FND_MSG_PUB.Count_And_Get (

7973:
7974: WHEN FND_API.G_EXC_ERROR THEN
7975: x_return_status := FND_API.G_RET_STS_ERROR;
7976: -- Standard call to get message count and if count=1, get the message
7977: FND_MSG_PUB.Count_And_Get (
7978: p_encoded => FND_API.G_FALSE,
7979: p_count => x_msg_count,
7980: p_data => x_msg_data
7981: );

Line 7985: FND_MSG_PUB.Count_And_Get (

7981: );
7982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7984: -- Standard call to get message count and if count=1, get the message
7985: FND_MSG_PUB.Count_And_Get (
7986: p_encoded => FND_API.G_FALSE,
7987: p_count => x_msg_count,
7988: p_data => x_msg_data
7989: );

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

7989: );
7990: WHEN OTHERS THEN
7991:
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)
7994: THEN
7995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7996: END IF;
7997: -- Standard call to get message count and if count=1, get the message

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

7991:
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)
7994: THEN
7995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7996: END IF;
7997: -- Standard call to get message count and if count=1, get the message
7998: FND_MSG_PUB.Count_And_Get (
7999: p_encoded => FND_API.G_FALSE,

Line 7998: FND_MSG_PUB.Count_And_Get (

7994: THEN
7995: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7996: END IF;
7997: -- Standard call to get message count and if count=1, get the message
7998: FND_MSG_PUB.Count_And_Get (
7999: p_encoded => FND_API.G_FALSE,
8000: p_count => x_msg_count,
8001: p_data => x_msg_data
8002: );

Line 8113: fnd_msg_pub.Count_And_Get(

8109: return;
8110:
8111: EXCEPTION
8112: WHEN FND_API.G_EXC_ERROR THEN
8113: fnd_msg_pub.Count_And_Get(
8114: p_encoded => FND_API.G_TRUE
8115: ,p_count => l_msg_count
8116: ,p_data => l_msg_data);
8117:

Line 8121: fnd_msg_pub.Count_And_Get(

8117:
8118: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8119: raise;
8120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8121: fnd_msg_pub.Count_And_Get(
8122: p_encoded => FND_API.G_TRUE
8123: ,p_count => l_msg_count
8124: ,p_data => l_msg_data);
8125:

Line 8129: fnd_msg_pub.Count_And_Get(

8125:
8126: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8127: raise;
8128: WHEN OTHERS THEN
8129: fnd_msg_pub.Count_And_Get(
8130: p_encoded => FND_API.G_TRUE
8131: ,p_count => l_msg_count
8132: ,p_data => l_msg_data);
8133:

Line 8190: fnd_msg_pub.Count_And_Get(

8186: END IF;
8187: return;
8188: EXCEPTION
8189: WHEN FND_API.G_EXC_ERROR THEN
8190: fnd_msg_pub.Count_And_Get(
8191: p_encoded => FND_API.G_TRUE
8192: ,p_count => l_msg_count
8193: ,p_data => l_msg_data);
8194:

Line 8198: fnd_msg_pub.Count_And_Get(

8194:
8195: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8196: raise;
8197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8198: fnd_msg_pub.Count_And_Get(
8199: p_encoded => FND_API.G_TRUE
8200: ,p_count => l_msg_count
8201: ,p_data => l_msg_data);
8202:

Line 8206: fnd_msg_pub.Count_And_Get(

8202:
8203: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8204: raise;
8205: WHEN OTHERS THEN
8206: fnd_msg_pub.Count_And_Get(
8207: p_encoded => FND_API.G_TRUE
8208: ,p_count => l_msg_count
8209: ,p_data => l_msg_data);
8210:

Line 8287: fnd_msg_pub.Count_And_Get(

8283: resultout := l_resultout;
8284:
8285: EXCEPTION
8286: WHEN FND_API.G_EXC_ERROR THEN
8287: fnd_msg_pub.Count_And_Get(
8288: p_encoded => FND_API.G_TRUE
8289: ,p_count => l_msg_count
8290: ,p_data => l_msg_data);
8291:

Line 8295: fnd_msg_pub.Count_And_Get(

8291:
8292: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8293: raise;
8294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8295: fnd_msg_pub.Count_And_Get(
8296: p_encoded => FND_API.G_TRUE
8297: ,p_count => l_msg_count
8298: ,p_data => l_msg_data);
8299:

Line 8303: fnd_msg_pub.Count_And_Get(

8299:
8300: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8301: raise;
8302: WHEN OTHERS THEN
8303: fnd_msg_pub.Count_And_Get(
8304: p_encoded => FND_API.G_TRUE
8305: ,p_count => l_msg_count
8306: ,p_data => l_msg_data);
8307:

Line 8375: fnd_msg_pub.Count_And_Get(

8371: resultout := l_resultout;
8372:
8373: EXCEPTION
8374: WHEN FND_API.G_EXC_ERROR THEN
8375: fnd_msg_pub.Count_And_Get(
8376: p_encoded => FND_API.G_TRUE
8377: ,p_count => l_msg_count
8378: ,p_data => l_msg_data);
8379:

Line 8383: fnd_msg_pub.Count_And_Get(

8379:
8380: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8381: raise;
8382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8383: fnd_msg_pub.Count_And_Get(
8384: p_encoded => FND_API.G_TRUE
8385: ,p_count => l_msg_count
8386: ,p_data => l_msg_data);
8387:

Line 8391: fnd_msg_pub.Count_And_Get(

8387:
8388: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);
8389: raise;
8390: WHEN OTHERS THEN
8391: fnd_msg_pub.Count_And_Get(
8392: p_encoded => FND_API.G_TRUE
8393: ,p_count => l_msg_count
8394: ,p_data => l_msg_data);
8395:

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

8682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8684: WHEN OTHERS THEN
8685: IF OZF_UNEXP_ERROR THEN
8686: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8687: END IF;
8688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8689: END Insert_Resale_Log;
8690: