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 142: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: IF OZF_UNEXP_ERROR THEN
142: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
143: END IF;
144: RAISE;
145: END Re_Initilize_Context;
146: ---------------------------------------------------------------------

Line 300: FND_MSG_PUB.Count_And_Get (

296: resultout := l_resultout;
297:
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: FND_MSG_PUB.Count_And_Get (
301: p_encoded => FND_API.G_FALSE,
302: p_count => l_msg_count,
303: p_data => l_msg_data
304: );

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

313: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
314: RAISE;
315: WHEN OTHERS THEN
316: IF OZF_UNEXP_ERROR THEN
317: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
318: END IF;
319: FND_MSG_PUB.Count_And_Get (
320: p_encoded => FND_API.G_FALSE,
321: p_count => l_msg_count,

Line 319: FND_MSG_PUB.Count_And_Get (

315: WHEN OTHERS THEN
316: IF OZF_UNEXP_ERROR THEN
317: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
318: END IF;
319: FND_MSG_PUB.Count_And_Get (
320: p_encoded => FND_API.G_FALSE,
321: p_count => l_msg_count,
322: p_data => l_msg_data
323: );

Line 436: FND_MSG_PUB.Count_And_Get (

432: resultout := l_resultout;
433:
434: EXCEPTION
435: WHEN FND_API.G_EXC_ERROR THEN
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE,
438: p_count => l_msg_count,
439: p_data => l_msg_data
440: );

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

449: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
450: RAISE;
451: WHEN OTHERS THEN
452: IF OZF_UNEXP_ERROR THEN
453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
454: END IF;
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => l_msg_count,

Line 455: FND_MSG_PUB.Count_And_Get (

451: WHEN OTHERS THEN
452: IF OZF_UNEXP_ERROR THEN
453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
454: END IF;
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => l_msg_count,
458: p_data => l_msg_data
459: );

Line 592: FND_MSG_PUB.Count_And_Get (

588: resultout := l_resultout;
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: FND_MSG_PUB.Count_And_Get (
593: p_encoded => FND_API.G_FALSE,
594: p_count => l_msg_count,
595: p_data => l_msg_data
596: );

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

605: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
606: RAISE;
607: WHEN OTHERS THEN
608: IF OZF_UNEXP_ERROR THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
610: END IF;
611: FND_MSG_PUB.Count_And_Get (
612: p_encoded => FND_API.G_FALSE,
613: p_count => l_msg_count,

Line 611: FND_MSG_PUB.Count_And_Get (

607: WHEN OTHERS THEN
608: IF OZF_UNEXP_ERROR THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
610: END IF;
611: FND_MSG_PUB.Count_And_Get (
612: p_encoded => FND_API.G_FALSE,
613: p_count => l_msg_count,
614: p_data => l_msg_data
615: );

Line 731: FND_MSG_PUB.Count_And_Get (

727: resultout := l_resultout;
728:
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: FND_MSG_PUB.Count_And_Get (
732: p_encoded => FND_API.G_FALSE,
733: p_count => l_msg_count,
734: p_data => l_msg_data
735: );

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

744: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
745: RAISE;
746: WHEN OTHERS THEN
747: IF OZF_UNEXP_ERROR THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,
752: p_count => l_msg_count,

Line 750: FND_MSG_PUB.Count_And_Get (

746: WHEN OTHERS THEN
747: IF OZF_UNEXP_ERROR THEN
748: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
749: END IF;
750: FND_MSG_PUB.Count_And_Get (
751: p_encoded => FND_API.G_FALSE,
752: p_count => l_msg_count,
753: p_data => l_msg_data
754: );

Line 862: FND_MSG_PUB.Count_And_Get (

858: resultout := l_resultout;
859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: FND_MSG_PUB.Count_And_Get (
863: p_encoded => FND_API.G_FALSE,
864: p_count => l_msg_count,
865: p_data => l_msg_data
866: );

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

875: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
876: RAISE;
877: WHEN OTHERS THEN
878: IF OZF_UNEXP_ERROR THEN
879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => l_msg_count,

Line 881: FND_MSG_PUB.Count_And_Get (

877: WHEN OTHERS THEN
878: IF OZF_UNEXP_ERROR THEN
879: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => l_msg_count,
884: p_data => l_msg_data
885: );

Line 952: FND_MSG_PUB.initialize;

948: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
949: END IF;
950: IF (funcmode = 'RUN') THEN
951: -- Clear the error stack for one time
952: FND_MSG_PUB.initialize;
953:
954: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
955: itemtype => itemtype,
956: itemkey => itemkey,

Line 1036: FND_MSG_PUB.Count_And_Get (

1032: END IF;
1033: --
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: FND_MSG_PUB.Count_And_Get (
1037: p_encoded => FND_API.G_FALSE,
1038: p_count => l_msg_count,
1039: p_data => l_msg_data
1040: );

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

1049: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
1050: RAISE;
1051: WHEN OTHERS THEN
1052: IF OZF_UNEXP_ERROR THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: FND_MSG_PUB.Count_And_Get (
1056: p_encoded => FND_API.G_FALSE,
1057: p_count => l_msg_count,

Line 1055: FND_MSG_PUB.Count_And_Get (

1051: WHEN OTHERS THEN
1052: IF OZF_UNEXP_ERROR THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: FND_MSG_PUB.Count_And_Get (
1056: p_encoded => FND_API.G_FALSE,
1057: p_count => l_msg_count,
1058: p_data => l_msg_data
1059: );

Line 1170: FND_MSG_PUB.Count_And_Get (

1166: resultout := l_resultout;
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => l_msg_count,
1173: p_data => l_msg_data
1174: );

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

1184: resultout := 'COMPLETE:ERROR';
1185: RETURN;
1186: WHEN OTHERS THEN
1187: IF OZF_UNEXP_ERROR THEN
1188: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1189: END IF;
1190: FND_MSG_PUB.Count_And_Get (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => l_msg_count,

Line 1190: FND_MSG_PUB.Count_And_Get (

1186: WHEN OTHERS THEN
1187: IF OZF_UNEXP_ERROR THEN
1188: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1189: END IF;
1190: FND_MSG_PUB.Count_And_Get (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => l_msg_count,
1193: p_data => l_msg_data
1194: );

Line 1333: FND_MSG_PUB.Count_And_Get (

1329: resultout := l_resultout;
1330:
1331: EXCEPTION
1332: WHEN FND_API.G_EXC_ERROR THEN
1333: FND_MSG_PUB.Count_And_Get (
1334: p_encoded => FND_API.G_FALSE,
1335: p_count => l_msg_count,
1336: p_data => l_msg_data
1337: );

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

1347: resultout := 'COMPLETE:ERROR';
1348: RETURN;
1349: WHEN OTHERS THEN
1350: IF OZF_UNEXP_ERROR THEN
1351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1352: END IF;
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => l_msg_count,

Line 1353: FND_MSG_PUB.Count_And_Get (

1349: WHEN OTHERS THEN
1350: IF OZF_UNEXP_ERROR THEN
1351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1352: END IF;
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => l_msg_count,
1356: p_data => l_msg_data
1357: );

Line 1472: FND_MSG_PUB.Count_And_Get (

1468: resultout := l_resultout;
1469:
1470: EXCEPTION
1471: WHEN FND_API.G_EXC_ERROR THEN
1472: FND_MSG_PUB.Count_And_Get (
1473: p_encoded => FND_API.G_FALSE,
1474: p_count => l_msg_count,
1475: p_data => l_msg_data
1476: );

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

1486: resultout := 'COMPLETE:ERROR';
1487: RETURN;
1488: WHEN OTHERS THEN
1489: IF OZF_UNEXP_ERROR THEN
1490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1491: END IF;
1492: FND_MSG_PUB.Count_And_Get (
1493: p_encoded => FND_API.G_FALSE,
1494: p_count => l_msg_count,

Line 1492: FND_MSG_PUB.Count_And_Get (

1488: WHEN OTHERS THEN
1489: IF OZF_UNEXP_ERROR THEN
1490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1491: END IF;
1492: FND_MSG_PUB.Count_And_Get (
1493: p_encoded => FND_API.G_FALSE,
1494: p_count => l_msg_count,
1495: p_data => l_msg_data
1496: );

Line 1580: FND_MSG_PUB.Count_And_Get (

1576: resultout := l_resultout;
1577:
1578: EXCEPTION
1579: WHEN FND_API.G_EXC_ERROR THEN
1580: FND_MSG_PUB.Count_And_Get (
1581: p_encoded => FND_API.G_FALSE,
1582: p_count => l_msg_count,
1583: p_data => l_msg_data
1584: );

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

1594: resultout := 'COMPLETE:ERROR';
1595: RETURN;
1596: WHEN OTHERS THEN
1597: IF OZF_UNEXP_ERROR THEN
1598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get (
1601: p_encoded => FND_API.G_FALSE,
1602: p_count => l_msg_count,

Line 1600: FND_MSG_PUB.Count_And_Get (

1596: WHEN OTHERS THEN
1597: IF OZF_UNEXP_ERROR THEN
1598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get (
1601: p_encoded => FND_API.G_FALSE,
1602: p_count => l_msg_count,
1603: p_data => l_msg_data
1604: );

Line 1715: FND_MSG_PUB.Count_And_Get (

1711: resultout := l_resultout;
1712:
1713: EXCEPTION
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: FND_MSG_PUB.Count_And_Get (
1716: p_encoded => FND_API.G_FALSE,
1717: p_count => l_msg_count,
1718: p_data => l_msg_data
1719: );

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

1729: resultout := 'COMPLETE:ERROR';
1730: RETURN;
1731: WHEN OTHERS THEN
1732: IF OZF_UNEXP_ERROR THEN
1733: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1734: END IF;
1735: FND_MSG_PUB.Count_And_Get (
1736: p_encoded => FND_API.G_FALSE,
1737: p_count => l_msg_count,

Line 1735: FND_MSG_PUB.Count_And_Get (

1731: WHEN OTHERS THEN
1732: IF OZF_UNEXP_ERROR THEN
1733: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1734: END IF;
1735: FND_MSG_PUB.Count_And_Get (
1736: p_encoded => FND_API.G_FALSE,
1737: p_count => l_msg_count,
1738: p_data => l_msg_data
1739: );

Line 1849: FND_MSG_PUB.Count_And_Get (

1845: resultout := l_resultout;
1846:
1847: EXCEPTION
1848: WHEN FND_API.G_EXC_ERROR THEN
1849: FND_MSG_PUB.Count_And_Get (
1850: p_encoded => FND_API.G_FALSE,
1851: p_count => l_msg_count,
1852: p_data => l_msg_data
1853: );

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

1863: resultout := 'COMPLETE:ERROR';
1864: RETURN;
1865: WHEN OTHERS THEN
1866: IF OZF_UNEXP_ERROR THEN
1867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1868: END IF;
1869: FND_MSG_PUB.Count_And_Get (
1870: p_encoded => FND_API.G_FALSE,
1871: p_count => l_msg_count,

Line 1869: FND_MSG_PUB.Count_And_Get (

1865: WHEN OTHERS THEN
1866: IF OZF_UNEXP_ERROR THEN
1867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1868: END IF;
1869: FND_MSG_PUB.Count_And_Get (
1870: p_encoded => FND_API.G_FALSE,
1871: p_count => l_msg_count,
1872: p_data => l_msg_data
1873: );

Line 1985: FND_MSG_PUB.Count_And_Get (

1981: resultout := l_resultout;
1982:
1983: EXCEPTION
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: FND_MSG_PUB.Count_And_Get (
1986: p_encoded => FND_API.G_FALSE,
1987: p_count => l_msg_count,
1988: p_data => l_msg_data
1989: );

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

1999: resultout := 'COMPLETE:ERROR';
2000: RETURN;
2001: WHEN OTHERS THEN
2002: IF OZF_UNEXP_ERROR THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: FND_MSG_PUB.Count_And_Get (
2006: p_encoded => FND_API.G_FALSE,
2007: p_count => l_msg_count,

Line 2005: FND_MSG_PUB.Count_And_Get (

2001: WHEN OTHERS THEN
2002: IF OZF_UNEXP_ERROR THEN
2003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2004: END IF;
2005: FND_MSG_PUB.Count_And_Get (
2006: p_encoded => FND_API.G_FALSE,
2007: p_count => l_msg_count,
2008: p_data => l_msg_data
2009: );

Line 2121: FND_MSG_PUB.Count_And_Get (

2117: resultout := l_resultout;
2118:
2119: EXCEPTION
2120: WHEN FND_API.G_EXC_ERROR THEN
2121: FND_MSG_PUB.Count_And_Get (
2122: p_encoded => FND_API.G_FALSE,
2123: p_count => l_msg_count,
2124: p_data => l_msg_data
2125: );

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

2135: resultout := 'COMPLETE:ERROR';
2136: RETURN;
2137: WHEN OTHERS THEN
2138: IF OZF_UNEXP_ERROR THEN
2139: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2140: END IF;
2141: FND_MSG_PUB.Count_And_Get (
2142: p_encoded => FND_API.G_FALSE,
2143: p_count => l_msg_count,

Line 2141: FND_MSG_PUB.Count_And_Get (

2137: WHEN OTHERS THEN
2138: IF OZF_UNEXP_ERROR THEN
2139: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2140: END IF;
2141: FND_MSG_PUB.Count_And_Get (
2142: p_encoded => FND_API.G_FALSE,
2143: p_count => l_msg_count,
2144: p_data => l_msg_data
2145: );

Line 2269: FND_MSG_PUB.Count_And_Get (

2265: RETURN;
2266: --
2267: EXCEPTION
2268: WHEN FND_API.G_EXC_ERROR THEN
2269: FND_MSG_PUB.Count_And_Get (
2270: p_encoded => FND_API.G_FALSE,
2271: p_count => l_msg_count,
2272: p_data => l_msg_data
2273: );

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

2282: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2283: RAISE;
2284: WHEN OTHERS THEN
2285: IF OZF_UNEXP_ERROR THEN
2286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2287: END IF;
2288: FND_MSG_PUB.Count_And_Get (
2289: p_encoded => FND_API.G_FALSE,
2290: p_count => l_msg_count,

Line 2288: FND_MSG_PUB.Count_And_Get (

2284: WHEN OTHERS THEN
2285: IF OZF_UNEXP_ERROR THEN
2286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2287: END IF;
2288: FND_MSG_PUB.Count_And_Get (
2289: p_encoded => FND_API.G_FALSE,
2290: p_count => l_msg_count,
2291: p_data => l_msg_data
2292: );

Line 2562: FND_MSG_PUB.Count_And_Get (

2558: RETURN;
2559: --
2560: EXCEPTION
2561: WHEN FND_API.G_EXC_ERROR THEN
2562: FND_MSG_PUB.Count_And_Get (
2563: p_encoded => FND_API.G_FALSE,
2564: p_count => l_msg_count,
2565: p_data => l_msg_data
2566: );

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

2575: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2576: RAISE;
2577: WHEN OTHERS THEN
2578: IF OZF_UNEXP_ERROR THEN
2579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2580: END IF;
2581: FND_MSG_PUB.Count_And_Get (
2582: p_encoded => FND_API.G_FALSE,
2583: p_count => l_msg_count,

Line 2581: FND_MSG_PUB.Count_And_Get (

2577: WHEN OTHERS THEN
2578: IF OZF_UNEXP_ERROR THEN
2579: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2580: END IF;
2581: FND_MSG_PUB.Count_And_Get (
2582: p_encoded => FND_API.G_FALSE,
2583: p_count => l_msg_count,
2584: p_data => l_msg_data
2585: );

Line 2693: FND_MSG_PUB.Count_And_Get (

2689: RETURN;
2690: --
2691: EXCEPTION
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: FND_MSG_PUB.Count_And_Get (
2694: p_encoded => FND_API.G_FALSE,
2695: p_count => l_msg_count,
2696: p_data => l_msg_data
2697: );

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

2706: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2707: RAISE;
2708: WHEN OTHERS THEN
2709: IF OZF_UNEXP_ERROR THEN
2710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2711: END IF;
2712: FND_MSG_PUB.Count_And_Get (
2713: p_encoded => FND_API.G_FALSE,
2714: p_count => l_msg_count,

Line 2712: FND_MSG_PUB.Count_And_Get (

2708: WHEN OTHERS THEN
2709: IF OZF_UNEXP_ERROR THEN
2710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2711: END IF;
2712: FND_MSG_PUB.Count_And_Get (
2713: p_encoded => FND_API.G_FALSE,
2714: p_count => l_msg_count,
2715: p_data => l_msg_data
2716: );

Line 2936: FND_MSG_PUB.Count_And_Get (

2932: RETURN;
2933: --
2934: EXCEPTION
2935: WHEN FND_API.G_EXC_ERROR THEN
2936: FND_MSG_PUB.Count_And_Get (
2937: p_encoded => FND_API.G_FALSE,
2938: p_count => l_msg_count,
2939: p_data => l_msg_data
2940: );

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

2949: WF_CORE.context( G_PKG_NAME,l_api_name,itemtype,itemkey,actid,l_error_msg);
2950: RAISE;
2951: WHEN OTHERS THEN
2952: IF OZF_UNEXP_ERROR THEN
2953: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2954: END IF;
2955: FND_MSG_PUB.Count_And_Get (
2956: p_encoded => FND_API.G_FALSE,
2957: p_count => l_msg_count,

Line 2955: FND_MSG_PUB.Count_And_Get (

2951: WHEN OTHERS THEN
2952: IF OZF_UNEXP_ERROR THEN
2953: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2954: END IF;
2955: FND_MSG_PUB.Count_And_Get (
2956: p_encoded => FND_API.G_FALSE,
2957: p_count => l_msg_count,
2958: p_data => l_msg_data
2959: );

Line 3085: FND_MSG_PUB.Count_And_Get (

3081: resultout := l_resultout;
3082:
3083: EXCEPTION
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: FND_MSG_PUB.Count_And_Get (
3086: p_encoded => FND_API.G_FALSE,
3087: p_count => l_msg_count,
3088: p_data => l_msg_data
3089: );

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

3099: resultout := 'COMPLETE:ERROR';
3100: RETURN;
3101: WHEN OTHERS THEN
3102: IF OZF_UNEXP_ERROR THEN
3103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3104: END IF;
3105: FND_MSG_PUB.Count_And_Get (
3106: p_encoded => FND_API.G_FALSE,
3107: p_count => l_msg_count,

Line 3105: FND_MSG_PUB.Count_And_Get (

3101: WHEN OTHERS THEN
3102: IF OZF_UNEXP_ERROR THEN
3103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3104: END IF;
3105: FND_MSG_PUB.Count_And_Get (
3106: p_encoded => FND_API.G_FALSE,
3107: p_count => l_msg_count,
3108: p_data => l_msg_data
3109: );

Line 3229: FND_MSG_PUB.Count_And_Get (

3225: resultout := l_resultout;
3226:
3227: EXCEPTION
3228: WHEN FND_API.G_EXC_ERROR THEN
3229: FND_MSG_PUB.Count_And_Get (
3230: p_encoded => FND_API.G_FALSE,
3231: p_count => l_msg_count,
3232: p_data => l_msg_data
3233: );

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

3243: resultout := 'COMPLETE:ERROR';
3244: RETURN;
3245: WHEN OTHERS THEN
3246: IF OZF_UNEXP_ERROR THEN
3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3248: END IF;
3249: FND_MSG_PUB.Count_And_Get (
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => l_msg_count,

Line 3249: FND_MSG_PUB.Count_And_Get (

3245: WHEN OTHERS THEN
3246: IF OZF_UNEXP_ERROR THEN
3247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3248: END IF;
3249: FND_MSG_PUB.Count_And_Get (
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => l_msg_count,
3252: p_data => l_msg_data
3253: );

Line 3375: FND_MSG_PUB.Count_And_Get (

3371: resultout := l_resultout;
3372:
3373: EXCEPTION
3374: WHEN FND_API.G_EXC_ERROR THEN
3375: FND_MSG_PUB.Count_And_Get (
3376: p_encoded => FND_API.G_FALSE,
3377: p_count => l_msg_count,
3378: p_data => l_msg_data
3379: );

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

3389: l_resultout := 'COMPLETE:ERROR';
3390: RETURN;
3391: WHEN OTHERS THEN
3392: IF OZF_UNEXP_ERROR THEN
3393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3394: END IF;
3395: FND_MSG_PUB.Count_And_Get (
3396: p_encoded => FND_API.G_FALSE,
3397: p_count => l_msg_count,

Line 3395: FND_MSG_PUB.Count_And_Get (

3391: WHEN OTHERS THEN
3392: IF OZF_UNEXP_ERROR THEN
3393: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3394: END IF;
3395: FND_MSG_PUB.Count_And_Get (
3396: p_encoded => FND_API.G_FALSE,
3397: p_count => l_msg_count,
3398: p_data => l_msg_data
3399: );

Line 3520: FND_MSG_PUB.Count_And_Get (

3516: resultout := l_resultout;
3517:
3518: EXCEPTION
3519: WHEN FND_API.G_EXC_ERROR THEN
3520: FND_MSG_PUB.Count_And_Get (
3521: p_encoded => FND_API.G_FALSE,
3522: p_count => l_msg_count,
3523: p_data => l_msg_data
3524: );

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

3534: l_resultout := 'COMPLETE:ERROR';
3535: RETURN;
3536: WHEN OTHERS THEN
3537: IF OZF_UNEXP_ERROR THEN
3538: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3539: END IF;
3540: FND_MSG_PUB.Count_And_Get (
3541: p_encoded => FND_API.G_FALSE,
3542: p_count => l_msg_count,

Line 3540: FND_MSG_PUB.Count_And_Get (

3536: WHEN OTHERS THEN
3537: IF OZF_UNEXP_ERROR THEN
3538: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3539: END IF;
3540: FND_MSG_PUB.Count_And_Get (
3541: p_encoded => FND_API.G_FALSE,
3542: p_count => l_msg_count,
3543: p_data => l_msg_data
3544: );

Line 3666: FND_MSG_PUB.Count_And_Get (

3662: resultout := l_resultout;
3663:
3664: EXCEPTION
3665: WHEN FND_API.G_EXC_ERROR THEN
3666: FND_MSG_PUB.Count_And_Get (
3667: p_encoded => FND_API.G_FALSE,
3668: p_count => l_msg_count,
3669: p_data => l_msg_data
3670: );

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

3680: l_resultout := 'COMPLETE:ERROR';
3681: RETURN;
3682: WHEN OTHERS THEN
3683: IF OZF_UNEXP_ERROR THEN
3684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3685: END IF;
3686: FND_MSG_PUB.Count_And_Get (
3687: p_encoded => FND_API.G_FALSE,
3688: p_count => l_msg_count,

Line 3686: FND_MSG_PUB.Count_And_Get (

3682: WHEN OTHERS THEN
3683: IF OZF_UNEXP_ERROR THEN
3684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3685: END IF;
3686: FND_MSG_PUB.Count_And_Get (
3687: p_encoded => FND_API.G_FALSE,
3688: p_count => l_msg_count,
3689: p_data => l_msg_data
3690: );

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

3936: END IF; -- IF l_batch_process_mode = 'SYNC' THEN
3937:
3938: EXCEPTION
3939: WHEN FND_API.G_EXC_ERROR THEN
3940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3941: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3942: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3943: FND_MSG_PUB.Add;
3944: END IF;

Line 3943: FND_MSG_PUB.Add;

3939: WHEN FND_API.G_EXC_ERROR THEN
3940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3941: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3942: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3943: FND_MSG_PUB.Add;
3944: END IF;
3945: RAISE;
3946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3947: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

3943: FND_MSG_PUB.Add;
3944: END IF;
3945: RAISE;
3946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3947: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3948: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3949: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3950: FND_MSG_PUB.Add;
3951: END IF;

Line 3950: FND_MSG_PUB.Add;

3946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3947: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3948: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
3949: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
3950: FND_MSG_PUB.Add;
3951: END IF;
3952: RAISE;
3953: WHEN OTHERS THEN
3954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

3950: FND_MSG_PUB.Add;
3951: END IF;
3952: RAISE;
3953: WHEN OTHERS THEN
3954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3955: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3956: END IF;
3957: RAISE;
3958: END Start_Data_Process;

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

3951: END IF;
3952: RAISE;
3953: WHEN OTHERS THEN
3954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3955: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3956: END IF;
3957: RAISE;
3958: END Start_Data_Process;
3959:

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

4172:
4173:
4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4177: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4178: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
4179: FND_MSG_PUB.Add;
4180: END IF;

Line 4179: FND_MSG_PUB.Add;

4175: WHEN FND_API.G_EXC_ERROR THEN
4176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4177: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4178: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
4179: FND_MSG_PUB.Add;
4180: END IF;
4181: RAISE;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

4179: FND_MSG_PUB.Add;
4180: END IF;
4181: RAISE;
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4184: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4185: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
4186: FND_MSG_PUB.Add;
4187: END IF;

Line 4186: FND_MSG_PUB.Add;

4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4184: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4185: FND_MESSAGE.Set_Token('TEXT',G_PKG_NAME||'.'||l_api_name||': Error');
4186: FND_MSG_PUB.Add;
4187: END IF;
4188: RAISE;
4189: WHEN OTHERS THEN
4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

4186: FND_MSG_PUB.Add;
4187: END IF;
4188: RAISE;
4189: WHEN OTHERS THEN
4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4192: END IF;
4193: RAISE;
4194: END Start_Batch_Payment;

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

4187: END IF;
4188: RAISE;
4189: WHEN OTHERS THEN
4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4192: END IF;
4193: RAISE;
4194: END Start_Batch_Payment;
4195: