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.AMS_LISTGENERATION_PUB dependencies on FND_MSG_PUB

Line 20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ListGeneration_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsplgnb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Generate_List

Line 21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_ListGeneration_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsplgnb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Generate_List
25: ( p_api_version IN NUMBER,

Line 22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsplgnb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Generate_List
25: ( p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

Line 50: FND_MSG_PUB.initialize;

46:
47: -- initialize the message list;
48: -- won't do it again when calling private API
49: IF FND_API.to_boolean(p_init_msg_list) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:
53: AMS_LISTGENERATION_PKG.Generate_List(
54: p_api_version => p_api_version,

Line 77: FND_MSG_PUB.count_and_get(

73: IF FND_API.to_boolean(p_commit) THEN
74: COMMIT;
75: END IF;
76: x_return_status := FND_API.g_ret_sts_success;
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.g_false,
79: p_count => x_msg_count,
80: p_data => x_msg_data
81: );

Line 88: FND_MSG_PUB.count_and_get(

84:
85: WHEN FND_API.g_exc_error THEN
86: ROLLBACK TO Generate_List_pub;
87: x_return_status := FND_API.g_ret_sts_error;
88: FND_MSG_PUB.count_and_get(
89: p_encoded => FND_API.g_false,
90: p_count => x_msg_count,
91: p_data => x_msg_data
92: );

Line 97: FND_MSG_PUB.count_and_get(

93:
94: WHEN FND_API.g_exc_unexpected_error THEN
95: ROLLBACK TO Generate_List_pub;
96: x_return_status := FND_API.g_ret_sts_unexp_error ;
97: FND_MSG_PUB.count_and_get(
98: p_encoded => FND_API.g_false,
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );

Line 108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

104: WHEN OTHERS THEN
105: ROLLBACK TO Generate_List_pub;
106: x_return_status := FND_API.g_ret_sts_unexp_error ;
107:
108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
109: THEN
110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
111: END IF;
112:

Line 110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

106: x_return_status := FND_API.g_ret_sts_unexp_error ;
107:
108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
109: THEN
110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
111: END IF;
112:
113: FND_MSG_PUB.count_and_get(
114: p_encoded => FND_API.g_false,

Line 113: FND_MSG_PUB.count_and_get(

109: THEN
110: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
111: END IF;
112:
113: FND_MSG_PUB.count_and_get(
114: p_encoded => FND_API.g_false,
115: p_count => x_msg_count,
116: p_data => x_msg_data
117: );

Line 151: FND_MSG_PUB.initialize;

147:
148: -- initialize the message list;
149: -- won't do it again when calling private API
150: IF FND_API.to_boolean(p_init_msg_list) THEN
151: FND_MSG_PUB.initialize;
152: END IF;
153:
154: AMS_LISTGENERATION_PKG.create_list_from_query(
155: p_api_version => p_api_version,

Line 185: FND_MSG_PUB.count_and_get(

181: IF FND_API.to_boolean(p_commit) THEN
182: COMMIT;
183: END IF;
184: x_return_status := FND_API.g_ret_sts_success;
185: FND_MSG_PUB.count_and_get(
186: p_encoded => FND_API.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data
189: );

Line 196: FND_MSG_PUB.count_and_get(

192:
193: WHEN FND_API.g_exc_error THEN
194: ROLLBACK TO create_list_from_query_pub;
195: x_return_status := FND_API.g_ret_sts_error;
196: FND_MSG_PUB.count_and_get(
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );

Line 205: FND_MSG_PUB.count_and_get(

201:
202: WHEN FND_API.g_exc_unexpected_error THEN
203: ROLLBACK TO create_list_from_query_pub;
204: x_return_status := FND_API.g_ret_sts_unexp_error ;
205: FND_MSG_PUB.count_and_get(
206: p_encoded => FND_API.g_false,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );

Line 216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

212: WHEN OTHERS THEN
213: ROLLBACK TO create_list_from_query_pub;
214: x_return_status := FND_API.g_ret_sts_unexp_error ;
215:
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
217: THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
219: END IF;
220:

Line 218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

214: x_return_status := FND_API.g_ret_sts_unexp_error ;
215:
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
217: THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
219: END IF;
220:
221: FND_MSG_PUB.count_and_get(
222: p_encoded => FND_API.g_false,

Line 221: FND_MSG_PUB.count_and_get(

217: THEN
218: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
219: END IF;
220:
221: FND_MSG_PUB.count_and_get(
222: p_encoded => FND_API.g_false,
223: p_count => x_msg_count,
224: p_data => x_msg_data
225: );

Line 263: FND_MSG_PUB.initialize;

259:
260: -- initialize the message list;
261: -- won't do it again when calling private API
262: IF FND_API.to_boolean(p_init_msg_list) THEN
263: FND_MSG_PUB.initialize;
264: END IF;
265:
266: AMS_LISTGENERATION_PKG.create_list_from_query(
267: p_api_version => p_api_version,

Line 299: FND_MSG_PUB.count_and_get(

295: IF FND_API.to_boolean(p_commit) THEN
296: COMMIT;
297: END IF;
298: x_return_status := FND_API.g_ret_sts_success;
299: FND_MSG_PUB.count_and_get(
300: p_encoded => FND_API.g_false,
301: p_count => x_msg_count,
302: p_data => x_msg_data
303: );

Line 310: FND_MSG_PUB.count_and_get(

306:
307: WHEN FND_API.g_exc_error THEN
308: ROLLBACK TO create_list_from_query_pub;
309: x_return_status := FND_API.g_ret_sts_error;
310: FND_MSG_PUB.count_and_get(
311: p_encoded => FND_API.g_false,
312: p_count => x_msg_count,
313: p_data => x_msg_data
314: );

Line 319: FND_MSG_PUB.count_and_get(

315:
316: WHEN FND_API.g_exc_unexpected_error THEN
317: ROLLBACK TO create_list_from_query_pub;
318: x_return_status := FND_API.g_ret_sts_unexp_error ;
319: FND_MSG_PUB.count_and_get(
320: p_encoded => FND_API.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data
323: );

Line 330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

326: WHEN OTHERS THEN
327: ROLLBACK TO create_list_from_query_pub;
328: x_return_status := FND_API.g_ret_sts_unexp_error ;
329:
330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
331: THEN
332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
333: END IF;
334:

Line 332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

328: x_return_status := FND_API.g_ret_sts_unexp_error ;
329:
330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
331: THEN
332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
333: END IF;
334:
335: FND_MSG_PUB.count_and_get(
336: p_encoded => FND_API.g_false,

Line 335: FND_MSG_PUB.count_and_get(

331: THEN
332: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
333: END IF;
334:
335: FND_MSG_PUB.count_and_get(
336: p_encoded => FND_API.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );