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

APPS.OZF_RESALE_WF_PVT dependencies on FND_MSG_PUB

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

9: -- END of Comments
10:
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvrwfb.pls';
12:
13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON 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 BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.g_msg_lvl_debug_low);

10:
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvrwfb.pls';
12:
13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON 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: ---------------------------------------------------------------------

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

11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvrwfb.pls';
12:
13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON 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: ---------------------------------------------------------------------
19: -- PROCEDURE

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 BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON 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: ---------------------------------------------------------------------
19: -- PROCEDURE
20: -- Handle_Error

Line 56: FND_MSG_PUB.get(

52: itemkey => p_itemkey,
53: aname => G_WF_ATTR_BATCH_ID);
54:
55: FOR i IN 1..p_msg_count LOOP
56: FND_MSG_PUB.get(
57: p_msg_index => p_msg_count - i +1 ,
58: p_encoded => FND_API.g_false,
59: p_data => l_msg_data,
60: p_msg_index_out => l_msg_index

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

80: avalue => l_final_msg );
81: EXCEPTION
82: WHEN OTHERS THEN
83: IF OZF_UNEXP_ERROR THEN
84: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
85: END IF;
86: RAISE;
87: END Handle_Error;
88:

Line 236: FND_MSG_PUB.Count_And_Get (

232: resultout := l_resultout;
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => l_msg_count,
239: p_data => l_msg_data
240: );

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

249: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
250: RAISE;
251: WHEN OTHERS THEN
252: IF OZF_UNEXP_ERROR THEN
253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
254: END IF;
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => l_msg_count,

Line 255: FND_MSG_PUB.Count_And_Get (

251: WHEN OTHERS THEN
252: IF OZF_UNEXP_ERROR THEN
253: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
254: END IF;
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => l_msg_count,
258: p_data => l_msg_data
259: );

Line 365: FND_MSG_PUB.Count_And_Get (

361: resultout := l_resultout;
362:
363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: FND_MSG_PUB.Count_And_Get (
366: p_encoded => FND_API.G_FALSE,
367: p_count => l_msg_count,
368: p_data => l_msg_data
369: );

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

378: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
379: RAISE;
380: WHEN OTHERS THEN
381: IF OZF_UNEXP_ERROR THEN
382: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
383: END IF;
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => l_msg_count,

Line 384: FND_MSG_PUB.Count_And_Get (

380: WHEN OTHERS THEN
381: IF OZF_UNEXP_ERROR THEN
382: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
383: END IF;
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => l_msg_count,
387: p_data => l_msg_data
388: );

Line 520: FND_MSG_PUB.Count_And_Get (

516: resultout := l_resultout;
517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => l_msg_count,
523: p_data => l_msg_data
524: );

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

533: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
534: RAISE;
535: WHEN OTHERS THEN
536: IF OZF_UNEXP_ERROR THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => l_msg_count,

Line 539: FND_MSG_PUB.Count_And_Get (

535: WHEN OTHERS THEN
536: IF OZF_UNEXP_ERROR THEN
537: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
538: END IF;
539: FND_MSG_PUB.Count_And_Get (
540: p_encoded => FND_API.G_FALSE,
541: p_count => l_msg_count,
542: p_data => l_msg_data
543: );

Line 658: FND_MSG_PUB.Count_And_Get (

654: resultout := l_resultout;
655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_ERROR THEN
658: FND_MSG_PUB.Count_And_Get (
659: p_encoded => FND_API.G_FALSE,
660: p_count => l_msg_count,
661: p_data => l_msg_data
662: );

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

671: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
672: RAISE;
673: WHEN OTHERS THEN
674: IF OZF_UNEXP_ERROR THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
676: END IF;
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => l_msg_count,

Line 677: FND_MSG_PUB.Count_And_Get (

673: WHEN OTHERS THEN
674: IF OZF_UNEXP_ERROR THEN
675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
676: END IF;
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => l_msg_count,
680: p_data => l_msg_data
681: );

Line 788: FND_MSG_PUB.Count_And_Get (

784: resultout := l_resultout;
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: FND_MSG_PUB.Count_And_Get (
789: p_encoded => FND_API.G_FALSE,
790: p_count => l_msg_count,
791: p_data => l_msg_data
792: );

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

801: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
802: RAISE;
803: WHEN OTHERS THEN
804: IF OZF_UNEXP_ERROR THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => l_msg_count,

Line 807: FND_MSG_PUB.Count_And_Get (

803: WHEN OTHERS THEN
804: IF OZF_UNEXP_ERROR THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => l_msg_count,
810: p_data => l_msg_data
811: );

Line 878: FND_MSG_PUB.initialize;

874: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
875: END IF;
876: IF (funcmode = 'RUN') THEN
877: -- Clear the error stack for one time
878: FND_MSG_PUB.initialize;
879:
880: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
881: itemtype => itemtype,
882: itemkey => itemkey,

Line 962: FND_MSG_PUB.Count_And_Get (

958: END IF;
959: --
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: FND_MSG_PUB.Count_And_Get (
963: p_encoded => FND_API.G_FALSE,
964: p_count => l_msg_count,
965: p_data => l_msg_data
966: );

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

975: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
976: RAISE;
977: WHEN OTHERS THEN
978: IF OZF_UNEXP_ERROR THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (
982: p_encoded => FND_API.G_FALSE,
983: p_count => l_msg_count,

Line 981: FND_MSG_PUB.Count_And_Get (

977: WHEN OTHERS THEN
978: IF OZF_UNEXP_ERROR THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (
982: p_encoded => FND_API.G_FALSE,
983: p_count => l_msg_count,
984: p_data => l_msg_data
985: );

Line 1095: FND_MSG_PUB.Count_And_Get (

1091: resultout := l_resultout;
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => l_msg_count,
1098: p_data => l_msg_data
1099: );

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

1109: resultout := 'COMPLETE:ERROR';
1110: RETURN;
1111: WHEN OTHERS THEN
1112: IF OZF_UNEXP_ERROR THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get (
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => l_msg_count,

Line 1115: FND_MSG_PUB.Count_And_Get (

1111: WHEN OTHERS THEN
1112: IF OZF_UNEXP_ERROR THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1114: END IF;
1115: FND_MSG_PUB.Count_And_Get (
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => l_msg_count,
1118: p_data => l_msg_data
1119: );

Line 1228: FND_MSG_PUB.Count_And_Get (

1224: resultout := l_resultout;
1225:
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => l_msg_count,
1231: p_data => l_msg_data
1232: );

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

1242: resultout := 'COMPLETE:ERROR';
1243: RETURN;
1244: WHEN OTHERS THEN
1245: IF OZF_UNEXP_ERROR THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: FND_MSG_PUB.Count_And_Get (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => l_msg_count,

Line 1248: FND_MSG_PUB.Count_And_Get (

1244: WHEN OTHERS THEN
1245: IF OZF_UNEXP_ERROR THEN
1246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1247: END IF;
1248: FND_MSG_PUB.Count_And_Get (
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => l_msg_count,
1251: p_data => l_msg_data
1252: );

Line 1360: FND_MSG_PUB.Count_And_Get (

1356: resultout := l_resultout;
1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: FND_MSG_PUB.Count_And_Get (
1361: p_encoded => FND_API.G_FALSE,
1362: p_count => l_msg_count,
1363: p_data => l_msg_data
1364: );

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

1374: resultout := 'COMPLETE:ERROR';
1375: RETURN;
1376: WHEN OTHERS THEN
1377: IF OZF_UNEXP_ERROR THEN
1378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get (
1381: p_encoded => FND_API.G_FALSE,
1382: p_count => l_msg_count,

Line 1380: FND_MSG_PUB.Count_And_Get (

1376: WHEN OTHERS THEN
1377: IF OZF_UNEXP_ERROR THEN
1378: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get (
1381: p_encoded => FND_API.G_FALSE,
1382: p_count => l_msg_count,
1383: p_data => l_msg_data
1384: );

Line 1461: FND_MSG_PUB.Count_And_Get (

1457: resultout := l_resultout;
1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: FND_MSG_PUB.Count_And_Get (
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => l_msg_count,
1464: p_data => l_msg_data
1465: );

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

1475: resultout := 'COMPLETE:ERROR';
1476: RETURN;
1477: WHEN OTHERS THEN
1478: IF OZF_UNEXP_ERROR THEN
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1480: END IF;
1481: FND_MSG_PUB.Count_And_Get (
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => l_msg_count,

Line 1481: FND_MSG_PUB.Count_And_Get (

1477: WHEN OTHERS THEN
1478: IF OZF_UNEXP_ERROR THEN
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1480: END IF;
1481: FND_MSG_PUB.Count_And_Get (
1482: p_encoded => FND_API.G_FALSE,
1483: p_count => l_msg_count,
1484: p_data => l_msg_data
1485: );

Line 1595: FND_MSG_PUB.Count_And_Get (

1591: resultout := l_resultout;
1592:
1593: EXCEPTION
1594: WHEN FND_API.G_EXC_ERROR THEN
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => l_msg_count,
1598: p_data => l_msg_data
1599: );

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

1609: resultout := 'COMPLETE:ERROR';
1610: RETURN;
1611: WHEN OTHERS THEN
1612: IF OZF_UNEXP_ERROR THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: FND_MSG_PUB.Count_And_Get (
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => l_msg_count,

Line 1615: FND_MSG_PUB.Count_And_Get (

1611: WHEN OTHERS THEN
1612: IF OZF_UNEXP_ERROR THEN
1613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1614: END IF;
1615: FND_MSG_PUB.Count_And_Get (
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => l_msg_count,
1618: p_data => l_msg_data
1619: );

Line 1728: FND_MSG_PUB.Count_And_Get (

1724: resultout := l_resultout;
1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: FND_MSG_PUB.Count_And_Get (
1729: p_encoded => FND_API.G_FALSE,
1730: p_count => l_msg_count,
1731: p_data => l_msg_data
1732: );

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

1742: resultout := 'COMPLETE:ERROR';
1743: RETURN;
1744: WHEN OTHERS THEN
1745: IF OZF_UNEXP_ERROR THEN
1746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1747: END IF;
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => l_msg_count,

Line 1748: FND_MSG_PUB.Count_And_Get (

1744: WHEN OTHERS THEN
1745: IF OZF_UNEXP_ERROR THEN
1746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1747: END IF;
1748: FND_MSG_PUB.Count_And_Get (
1749: p_encoded => FND_API.G_FALSE,
1750: p_count => l_msg_count,
1751: p_data => l_msg_data
1752: );

Line 1863: FND_MSG_PUB.Count_And_Get (

1859: resultout := l_resultout;
1860:
1861: EXCEPTION
1862: WHEN FND_API.G_EXC_ERROR THEN
1863: FND_MSG_PUB.Count_And_Get (
1864: p_encoded => FND_API.G_FALSE,
1865: p_count => l_msg_count,
1866: p_data => l_msg_data
1867: );

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

1877: resultout := 'COMPLETE:ERROR';
1878: RETURN;
1879: WHEN OTHERS THEN
1880: IF OZF_UNEXP_ERROR THEN
1881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1882: END IF;
1883: FND_MSG_PUB.Count_And_Get (
1884: p_encoded => FND_API.G_FALSE,
1885: p_count => l_msg_count,

Line 1883: FND_MSG_PUB.Count_And_Get (

1879: WHEN OTHERS THEN
1880: IF OZF_UNEXP_ERROR THEN
1881: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1882: END IF;
1883: FND_MSG_PUB.Count_And_Get (
1884: p_encoded => FND_API.G_FALSE,
1885: p_count => l_msg_count,
1886: p_data => l_msg_data
1887: );

Line 1998: FND_MSG_PUB.Count_And_Get (

1994: resultout := l_resultout;
1995:
1996: EXCEPTION
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: FND_MSG_PUB.Count_And_Get (
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => l_msg_count,
2001: p_data => l_msg_data
2002: );

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

2012: resultout := 'COMPLETE:ERROR';
2013: RETURN;
2014: WHEN OTHERS THEN
2015: IF OZF_UNEXP_ERROR THEN
2016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2017: END IF;
2018: FND_MSG_PUB.Count_And_Get (
2019: p_encoded => FND_API.G_FALSE,
2020: p_count => l_msg_count,

Line 2018: FND_MSG_PUB.Count_And_Get (

2014: WHEN OTHERS THEN
2015: IF OZF_UNEXP_ERROR THEN
2016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2017: END IF;
2018: FND_MSG_PUB.Count_And_Get (
2019: p_encoded => FND_API.G_FALSE,
2020: p_count => l_msg_count,
2021: p_data => l_msg_data
2022: );

Line 2146: FND_MSG_PUB.Count_And_Get (

2142: RETURN;
2143: --
2144: EXCEPTION
2145: WHEN FND_API.G_EXC_ERROR THEN
2146: FND_MSG_PUB.Count_And_Get (
2147: p_encoded => FND_API.G_FALSE,
2148: p_count => l_msg_count,
2149: p_data => l_msg_data
2150: );

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

2159: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2160: RAISE;
2161: WHEN OTHERS THEN
2162: IF OZF_UNEXP_ERROR THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
2165: FND_MSG_PUB.Count_And_Get (
2166: p_encoded => FND_API.G_FALSE,
2167: p_count => l_msg_count,

Line 2165: FND_MSG_PUB.Count_And_Get (

2161: WHEN OTHERS THEN
2162: IF OZF_UNEXP_ERROR THEN
2163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2164: END IF;
2165: FND_MSG_PUB.Count_And_Get (
2166: p_encoded => FND_API.G_FALSE,
2167: p_count => l_msg_count,
2168: p_data => l_msg_data
2169: );

Line 2357: FND_MSG_PUB.Count_And_Get (

2353: RETURN;
2354: --
2355: EXCEPTION
2356: WHEN FND_API.G_EXC_ERROR THEN
2357: FND_MSG_PUB.Count_And_Get (
2358: p_encoded => FND_API.G_FALSE,
2359: p_count => l_msg_count,
2360: p_data => l_msg_data
2361: );

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

2370: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2371: RAISE;
2372: WHEN OTHERS THEN
2373: IF OZF_UNEXP_ERROR THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2375: END IF;
2376: FND_MSG_PUB.Count_And_Get (
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => l_msg_count,

Line 2376: FND_MSG_PUB.Count_And_Get (

2372: WHEN OTHERS THEN
2373: IF OZF_UNEXP_ERROR THEN
2374: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2375: END IF;
2376: FND_MSG_PUB.Count_And_Get (
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => l_msg_count,
2379: p_data => l_msg_data
2380: );

Line 2487: FND_MSG_PUB.Count_And_Get (

2483: RETURN;
2484: --
2485: EXCEPTION
2486: WHEN FND_API.G_EXC_ERROR THEN
2487: FND_MSG_PUB.Count_And_Get (
2488: p_encoded => FND_API.G_FALSE,
2489: p_count => l_msg_count,
2490: p_data => l_msg_data
2491: );

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

2500: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2501: RAISE;
2502: WHEN OTHERS THEN
2503: IF OZF_UNEXP_ERROR THEN
2504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2505: END IF;
2506: FND_MSG_PUB.Count_And_Get (
2507: p_encoded => FND_API.G_FALSE,
2508: p_count => l_msg_count,

Line 2506: FND_MSG_PUB.Count_And_Get (

2502: WHEN OTHERS THEN
2503: IF OZF_UNEXP_ERROR THEN
2504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2505: END IF;
2506: FND_MSG_PUB.Count_And_Get (
2507: p_encoded => FND_API.G_FALSE,
2508: p_count => l_msg_count,
2509: p_data => l_msg_data
2510: );

Line 2729: FND_MSG_PUB.Count_And_Get (

2725: RETURN;
2726: --
2727: EXCEPTION
2728: WHEN FND_API.G_EXC_ERROR THEN
2729: FND_MSG_PUB.Count_And_Get (
2730: p_encoded => FND_API.G_FALSE,
2731: p_count => l_msg_count,
2732: p_data => l_msg_data
2733: );

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

2742: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2743: RAISE;
2744: WHEN OTHERS THEN
2745: IF OZF_UNEXP_ERROR THEN
2746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2747: END IF;
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => l_msg_count,

Line 2748: FND_MSG_PUB.Count_And_Get (

2744: WHEN OTHERS THEN
2745: IF OZF_UNEXP_ERROR THEN
2746: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2747: END IF;
2748: FND_MSG_PUB.Count_And_Get (
2749: p_encoded => FND_API.G_FALSE,
2750: p_count => l_msg_count,
2751: p_data => l_msg_data
2752: );

Line 2877: FND_MSG_PUB.Count_And_Get (

2873: resultout := l_resultout;
2874:
2875: EXCEPTION
2876: WHEN FND_API.G_EXC_ERROR THEN
2877: FND_MSG_PUB.Count_And_Get (
2878: p_encoded => FND_API.G_FALSE,
2879: p_count => l_msg_count,
2880: p_data => l_msg_data
2881: );

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

2891: resultout := 'COMPLETE:ERROR';
2892: RETURN;
2893: WHEN OTHERS THEN
2894: IF OZF_UNEXP_ERROR THEN
2895: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2896: END IF;
2897: FND_MSG_PUB.Count_And_Get (
2898: p_encoded => FND_API.G_FALSE,
2899: p_count => l_msg_count,

Line 2897: FND_MSG_PUB.Count_And_Get (

2893: WHEN OTHERS THEN
2894: IF OZF_UNEXP_ERROR THEN
2895: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2896: END IF;
2897: FND_MSG_PUB.Count_And_Get (
2898: p_encoded => FND_API.G_FALSE,
2899: p_count => l_msg_count,
2900: p_data => l_msg_data
2901: );

Line 3021: FND_MSG_PUB.Count_And_Get (

3017: resultout := l_resultout;
3018:
3019: EXCEPTION
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: FND_MSG_PUB.Count_And_Get (
3022: p_encoded => FND_API.G_FALSE,
3023: p_count => l_msg_count,
3024: p_data => l_msg_data
3025: );

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

3035: resultout := 'COMPLETE:ERROR';
3036: RETURN;
3037: WHEN OTHERS THEN
3038: IF OZF_UNEXP_ERROR THEN
3039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3040: END IF;
3041: FND_MSG_PUB.Count_And_Get (
3042: p_encoded => FND_API.G_FALSE,
3043: p_count => l_msg_count,

Line 3041: FND_MSG_PUB.Count_And_Get (

3037: WHEN OTHERS THEN
3038: IF OZF_UNEXP_ERROR THEN
3039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3040: END IF;
3041: FND_MSG_PUB.Count_And_Get (
3042: p_encoded => FND_API.G_FALSE,
3043: p_count => l_msg_count,
3044: p_data => l_msg_data
3045: );

Line 3166: FND_MSG_PUB.Count_And_Get (

3162: resultout := l_resultout;
3163:
3164: EXCEPTION
3165: WHEN FND_API.G_EXC_ERROR THEN
3166: FND_MSG_PUB.Count_And_Get (
3167: p_encoded => FND_API.G_FALSE,
3168: p_count => l_msg_count,
3169: p_data => l_msg_data
3170: );

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

3180: l_resultout := 'COMPLETE:ERROR';
3181: RETURN;
3182: WHEN OTHERS THEN
3183: IF OZF_UNEXP_ERROR THEN
3184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3185: END IF;
3186: FND_MSG_PUB.Count_And_Get (
3187: p_encoded => FND_API.G_FALSE,
3188: p_count => l_msg_count,

Line 3186: FND_MSG_PUB.Count_And_Get (

3182: WHEN OTHERS THEN
3183: IF OZF_UNEXP_ERROR THEN
3184: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3185: END IF;
3186: FND_MSG_PUB.Count_And_Get (
3187: p_encoded => FND_API.G_FALSE,
3188: p_count => l_msg_count,
3189: p_data => l_msg_data
3190: );

Line 3310: FND_MSG_PUB.Count_And_Get (

3306: resultout := l_resultout;
3307:
3308: EXCEPTION
3309: WHEN FND_API.G_EXC_ERROR THEN
3310: FND_MSG_PUB.Count_And_Get (
3311: p_encoded => FND_API.G_FALSE,
3312: p_count => l_msg_count,
3313: p_data => l_msg_data
3314: );

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

3324: l_resultout := 'COMPLETE:ERROR';
3325: RETURN;
3326: WHEN OTHERS THEN
3327: IF OZF_UNEXP_ERROR THEN
3328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3329: END IF;
3330: FND_MSG_PUB.Count_And_Get (
3331: p_encoded => FND_API.G_FALSE,
3332: p_count => l_msg_count,

Line 3330: FND_MSG_PUB.Count_And_Get (

3326: WHEN OTHERS THEN
3327: IF OZF_UNEXP_ERROR THEN
3328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3329: END IF;
3330: FND_MSG_PUB.Count_And_Get (
3331: p_encoded => FND_API.G_FALSE,
3332: p_count => l_msg_count,
3333: p_data => l_msg_data
3334: );

Line 3455: FND_MSG_PUB.Count_And_Get (

3451: resultout := l_resultout;
3452:
3453: EXCEPTION
3454: WHEN FND_API.G_EXC_ERROR THEN
3455: FND_MSG_PUB.Count_And_Get (
3456: p_encoded => FND_API.G_FALSE,
3457: p_count => l_msg_count,
3458: p_data => l_msg_data
3459: );

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

3469: l_resultout := 'COMPLETE:ERROR';
3470: RETURN;
3471: WHEN OTHERS THEN
3472: IF OZF_UNEXP_ERROR THEN
3473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3474: END IF;
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => l_msg_count,

Line 3475: FND_MSG_PUB.Count_And_Get (

3471: WHEN OTHERS THEN
3472: IF OZF_UNEXP_ERROR THEN
3473: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3474: END IF;
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => l_msg_count,
3478: p_data => l_msg_data
3479: );

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

3606:
3607:
3608: EXCEPTION
3609: WHEN FND_API.G_EXC_ERROR THEN
3610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3611: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3612: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3613: FND_MSG_PUB.Add;
3614: END IF;

Line 3613: FND_MSG_PUB.Add;

3609: WHEN FND_API.G_EXC_ERROR THEN
3610: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3611: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3612: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3613: FND_MSG_PUB.Add;
3614: END IF;
3615: RAISE;
3616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

3613: FND_MSG_PUB.Add;
3614: END IF;
3615: RAISE;
3616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3618: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3619: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3620: FND_MSG_PUB.Add;
3621: END IF;

Line 3620: FND_MSG_PUB.Add;

3616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3618: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3619: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3620: FND_MSG_PUB.Add;
3621: END IF;
3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3620: FND_MSG_PUB.Add;
3621: END IF;
3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3625: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3626: END IF;
3627: RAISE;
3628: END Start_Data_Process;

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

3621: END IF;
3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3625: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3626: END IF;
3627: RAISE;
3628: END Start_Data_Process;
3629:

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

3742:
3743:
3744: EXCEPTION
3745: WHEN FND_API.G_EXC_ERROR THEN
3746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3747: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3748: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3749: FND_MSG_PUB.Add;
3750: END IF;

Line 3749: FND_MSG_PUB.Add;

3745: WHEN FND_API.G_EXC_ERROR THEN
3746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3747: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3748: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3749: FND_MSG_PUB.Add;
3750: END IF;
3751: RAISE;
3752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

3749: FND_MSG_PUB.Add;
3750: END IF;
3751: RAISE;
3752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3754: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3755: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3756: FND_MSG_PUB.Add;
3757: END IF;

Line 3756: FND_MSG_PUB.Add;

3752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3754: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3755: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3756: FND_MSG_PUB.Add;
3757: END IF;
3758: RAISE;
3759: WHEN OTHERS THEN
3760: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 3760: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3756: FND_MSG_PUB.Add;
3757: END IF;
3758: RAISE;
3759: WHEN OTHERS THEN
3760: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3761: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3762: END IF;
3763: RAISE;
3764: END Start_Batch_Payment;

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

3757: END IF;
3758: RAISE;
3759: WHEN OTHERS THEN
3760: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3761: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3762: END IF;
3763: RAISE;
3764: END Start_Batch_Payment;
3765: