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_QUOTA_THRESHOLD_PVT dependencies on FND_MSG_PUB

Line 26: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

22: -- ===============================================================
23:
24: G_PKG_NAME CONSTANT VARCHAR2(30) :='OZF_QUOTA_THRESHOLD_PVT';
25: G_FILE_NAME CONSTANT VARCHAR2(20) :='ozfvqtrb.pls';
26: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
27: --G_DEBUG BOOLEAN := TRUE;
28: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
29:
30: -----------------------------------------------------------------------

Line 107: FND_MSG_PUB.Count_And_Get (

103:
104: WHEN FND_API.G_EXC_ERROR THEN
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: -- Standard call to get message count and if count=1, get the message
107: FND_MSG_PUB.Count_And_Get (
108: p_encoded => FND_API.G_FALSE,
109: p_count => x_msg_count,
110: p_data => x_msg_data
111: );

Line 116: FND_MSG_PUB.Count_And_Get (

112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: -- Standard call to get message count and if count=1, get the message
116: FND_MSG_PUB.Count_And_Get (
117: p_encoded => FND_API.G_FALSE,
118: p_count => x_msg_count,
119: p_data => x_msg_data
120: );

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

120: );
121:
122: WHEN OTHERS THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message

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

122: WHEN OTHERS THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,

Line 129: FND_MSG_PUB.Count_And_Get (

125: THEN
126: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
127: END IF;
128: -- Standard call to get message count and if count=1, get the message
129: FND_MSG_PUB.Count_And_Get (
130: p_encoded => FND_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data
133: );

Line 1009: FND_MSG_PUB.initialize;

1005:
1006: -- Initialize message list if p_init_msg_list is set to TRUE.
1007: IF FND_API.to_Boolean( p_init_msg_list )
1008: THEN
1009: FND_MSG_PUB.initialize;
1010: END IF;
1011:
1012: -- Debug Message
1013: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1047: FND_MSG_PUB.Count_And_Get

1043:
1044: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1045:
1046: -- Standard call to get message count and if count is 1, get message info.
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,
1049: p_data => x_msg_data
1050: );
1051:

Line 1057: FND_MSG_PUB.Count_And_Get (

1053:
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_MSG_PUB.Count_And_Get (
1058: p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );

Line 1066: FND_MSG_PUB.Count_And_Get (

1062:
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: -- Standard call to get message count and if count=1, get the message
1066: FND_MSG_PUB.Count_And_Get (
1067: p_encoded => FND_API.G_FALSE,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );

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

1070: );
1071:
1072: WHEN OTHERS THEN
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1077: END IF;
1078: -- Standard call to get message count and if count=1, get the message

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

1072: WHEN OTHERS THEN
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1077: END IF;
1078: -- Standard call to get message count and if count=1, get the message
1079: FND_MSG_PUB.Count_And_Get (
1080: p_encoded => FND_API.G_FALSE,

Line 1079: FND_MSG_PUB.Count_And_Get (

1075: THEN
1076: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1077: END IF;
1078: -- Standard call to get message count and if count=1, get the message
1079: FND_MSG_PUB.Count_And_Get (
1080: p_encoded => FND_API.G_FALSE,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );

Line 1151: FND_MSG_PUB.initialize;

1147:
1148: -- Initialize message list if p_init_msg_list is set to TRUE.
1149: IF FND_API.to_Boolean( p_init_msg_list )
1150: THEN
1151: FND_MSG_PUB.initialize;
1152: END IF;
1153:
1154: -- Debug Message
1155: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1205: FND_MSG_PUB.Count_And_Get

1201: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
1202: END IF;
1203:
1204: -- Standard call to get message count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,
1207: p_data => x_msg_data
1208: );
1209: EXCEPTION

Line 1214: FND_MSG_PUB.Count_And_Get (

1210:
1211: WHEN FND_API.G_EXC_ERROR THEN
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );

Line 1223: FND_MSG_PUB.Count_And_Get (

1219:
1220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1227: );

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

1227: );
1228:
1229: WHEN OTHERS THEN
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1232: THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message

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

1229: WHEN OTHERS THEN
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1232: THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,

Line 1236: FND_MSG_PUB.Count_And_Get (

1232: THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data
1240: );

Line 1287: FND_MSG_PUB.initialize;

1283:
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list )
1286: THEN
1287: FND_MSG_PUB.initialize;
1288: END IF;
1289:
1290: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1291:

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

1393: l_ignore := DBMS_SQL.execute(l_ins_csr);
1394:
1395: WHEN OTHERS THEN
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1398: THEN
1399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1400: END IF;
1401: -- Standard call to get message count and if count=1, get the message

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

1395: WHEN OTHERS THEN
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1398: THEN
1399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1400: END IF;
1401: -- Standard call to get message count and if count=1, get the message
1402: FND_MSG_PUB.Count_And_Get (
1403: p_encoded => FND_API.G_FALSE,

Line 1402: FND_MSG_PUB.Count_And_Get (

1398: THEN
1399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1400: END IF;
1401: -- Standard call to get message count and if count=1, get the message
1402: FND_MSG_PUB.Count_And_Get (
1403: p_encoded => FND_API.G_FALSE,
1404: p_count => x_msg_count,
1405: p_data => x_msg_data
1406: );

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

1490: l_ignore := DBMS_SQL.execute(l_ins_csr);
1491:
1492: WHEN OTHERS THEN
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1497: END IF;
1498: -- Standard call to get message count and if count=1, get the message

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

1492: WHEN OTHERS THEN
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1495: THEN
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1497: END IF;
1498: -- Standard call to get message count and if count=1, get the message
1499: FND_MSG_PUB.Count_And_Get (
1500: p_encoded => FND_API.G_FALSE,

Line 1499: FND_MSG_PUB.Count_And_Get (

1495: THEN
1496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1497: END IF;
1498: -- Standard call to get message count and if count=1, get the message
1499: FND_MSG_PUB.Count_And_Get (
1500: p_encoded => FND_API.G_FALSE,
1501: p_count => x_msg_count,
1502: p_data => x_msg_data
1503: );

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

1564: FND_FILE.PUT_LINE(FND_FILE.LOG,'QUOTA EXCEPTION : '|| SUBSTR(SQLERRM, 1, 2000));
1565:
1566: WHEN OTHERS THEN
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1569: THEN
1570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1571: END IF;
1572: -- Standard call to get message count and if count=1, get the message

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

1566: WHEN OTHERS THEN
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1569: THEN
1570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1571: END IF;
1572: -- Standard call to get message count and if count=1, get the message
1573: FND_MSG_PUB.Count_And_Get (
1574: p_encoded => FND_API.G_FALSE,

Line 1573: FND_MSG_PUB.Count_And_Get (

1569: THEN
1570: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1571: END IF;
1572: -- Standard call to get message count and if count=1, get the message
1573: FND_MSG_PUB.Count_And_Get (
1574: p_encoded => FND_API.G_FALSE,
1575: p_count => x_msg_count,
1576: p_data => x_msg_data
1577: );

Line 1586: FND_MSG_PUB.Count_And_Get

1582:
1583: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1584:
1585: -- Standard call to get message count and if count is 1, get message info.
1586: FND_MSG_PUB.Count_And_Get
1587: (p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );
1590: EXCEPTION

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

1589: );
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1594: THEN
1595: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1596: END IF;
1597: -- Standard call to get message count and if count=1, get the message

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

1591: WHEN OTHERS THEN
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1594: THEN
1595: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1596: END IF;
1597: -- Standard call to get message count and if count=1, get the message
1598: FND_MSG_PUB.Count_And_Get (
1599: p_encoded => FND_API.G_FALSE,

Line 1598: FND_MSG_PUB.Count_And_Get (

1594: THEN
1595: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1596: END IF;
1597: -- Standard call to get message count and if count=1, get the message
1598: FND_MSG_PUB.Count_And_Get (
1599: p_encoded => FND_API.G_FALSE,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data
1602: );