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:
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
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;
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;
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:
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:
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:
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: );
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: );
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
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,
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: );
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');
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:
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
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
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
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,
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:
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
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
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
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: );
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:
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: );
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: );
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
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,
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: );
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: );
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: );
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
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,
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: );
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;
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:
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:
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:
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:
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: );
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: );
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
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,
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: );
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:
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
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:
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:
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:
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:
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:
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:
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.
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:
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:
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
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:
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:
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:
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:
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
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;
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
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:
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:
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:
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:
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:
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:
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:
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: );
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: );
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
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,
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: );
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:
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: );
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: );
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
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,
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: );
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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: