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.POS_PUB_HISTORY_BO_PKG dependencies on FND_API

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62: l_api_name CONSTANT VARCHAR2(30) := 'get_published_suppliers';
63: l_api_version CONSTANT NUMBER := 1.0;
64:
65: BEGIN
66: x_return_status := fnd_api.g_ret_sts_success;
67: x_msg_data := '';
68:
69: -- Standard call to check for call compatibility.
70: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 70: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

66: x_return_status := fnd_api.g_ret_sts_success;
67: x_msg_data := '';
68:
69: -- Standard call to check for call compatibility.
70: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
71: l_api_name, g_pkg_name) THEN
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:

Line 72: RAISE fnd_api.g_exc_unexpected_error;

68:
69: -- Standard call to check for call compatibility.
70: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
71: l_api_name, g_pkg_name) THEN
72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN

Line 76: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN

72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN
77: fnd_msg_pub.initialize;
78: END IF;
79:
80: IF (p_party_id IS NULL OR p_party_id = 0) THEN

Line 127: RAISE fnd_api.g_exc_error;

123: -- So we add a rowcount check.
124: --
125: IF sql%rowcount = 0 THEN
126: add_no_data_found_message(g_pkg_name, l_api_name);
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130: x_pos_pub_history_bo_tbl := l_pos_pub_history_bo_tbl;
131:

Line 133: WHEN fnd_api.g_exc_error THEN

129:
130: x_pos_pub_history_bo_tbl := l_pos_pub_history_bo_tbl;
131:
132: EXCEPTION
133: WHEN fnd_api.g_exc_error THEN
134: x_return_status := fnd_api.g_ret_sts_error;
135: fnd_msg_pub.count_and_get(
136: p_count => x_msg_count,
137: p_data => x_msg_data);

Line 134: x_return_status := fnd_api.g_ret_sts_error;

130: x_pos_pub_history_bo_tbl := l_pos_pub_history_bo_tbl;
131:
132: EXCEPTION
133: WHEN fnd_api.g_exc_error THEN
134: x_return_status := fnd_api.g_ret_sts_error;
135: fnd_msg_pub.count_and_get(
136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:

Line 139: WHEN fnd_api.g_exc_unexpected_error THEN

135: fnd_msg_pub.count_and_get(
136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: fnd_msg_pub.count_and_get(
142: p_count => x_msg_count,
143: p_data => x_msg_data);

Line 140: x_return_status := fnd_api.g_ret_sts_unexp_error;

136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN fnd_api.g_exc_unexpected_error THEN
140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: fnd_msg_pub.count_and_get(
142: p_count => x_msg_count,
143: p_data => x_msg_data);
144:

Line 146: x_return_status := fnd_api.g_ret_sts_unexp_error;

142: p_count => x_msg_count,
143: p_data => x_msg_data);
144:
145: WHEN OTHERS THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(
149: p_pkg_name => g_pkg_name,
150: p_procedure_name => l_api_name,

Line 311: x_return_status := fnd_api.g_ret_sts_success;

307: l_api_name CONSTANT VARCHAR2(30) := 'create_publication_response';
308: l_api_version CONSTANT NUMBER := 1.0;
309:
310: BEGIN
311: x_return_status := fnd_api.g_ret_sts_success;
312: x_msg_data := '';
313:
314: -- Standard call to check for call compatibility.
315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

311: x_return_status := fnd_api.g_ret_sts_success;
312: x_msg_data := '';
313:
314: -- Standard call to check for call compatibility.
315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
316: l_api_name, g_pkg_name) THEN
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319:

Line 317: RAISE fnd_api.g_exc_unexpected_error;

313:
314: -- Standard call to check for call compatibility.
315: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
316: l_api_name, g_pkg_name) THEN
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN

Line 321: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN

317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319:
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF fnd_api.to_boolean(nvl(p_init_msg_list, fnd_api.g_true)) THEN
322: fnd_msg_pub.initialize;
323: END IF;
324:
325: -- Verify required fields

Line 331: RAISE fnd_api.g_exc_error;

327: p_response_process_id IS NULL OR
328: p_event_id IS NULL OR
329: p_party_id IS NULL THEN
330: add_no_data_found_message(g_pkg_name, l_api_name);
331: RAISE fnd_api.g_exc_error;
332: END IF;
333:
334: -- Event and Party IDs must exist in parent table
335: IF NOT exists_event_party(p_event_id, p_party_id) THEN

Line 337: RAISE fnd_api.g_exc_error;

333:
334: -- Event and Party IDs must exist in parent table
335: IF NOT exists_event_party(p_event_id, p_party_id) THEN
336: add_no_data_found_message(g_pkg_name, l_api_name);
337: RAISE fnd_api.g_exc_error;
338: END IF;
339:
340: -- Target System + Response ID must be unique
341: IF exists_target_response(p_target_system, p_response_process_id) THEN

Line 343: RAISE fnd_api.g_exc_error;

339:
340: -- Target System + Response ID must be unique
341: IF exists_target_response(p_target_system, p_response_process_id) THEN
342: add_unique_constraint_message(g_pkg_name, l_api_name);
343: RAISE fnd_api.g_exc_error;
344: END IF;
345:
346: create_response_private(
347: p_target_system,

Line 357: IF fnd_api.to_boolean(nvl(p_commit, fnd_api.g_false)) THEN

353: p_party_id,
354: p_message
355: );
356:
357: IF fnd_api.to_boolean(nvl(p_commit, fnd_api.g_false)) THEN
358: COMMIT;
359: END IF;
360:
361: EXCEPTION

Line 362: WHEN fnd_api.g_exc_error THEN

358: COMMIT;
359: END IF;
360:
361: EXCEPTION
362: WHEN fnd_api.g_exc_error THEN
363: x_return_status := fnd_api.g_ret_sts_error;
364: fnd_msg_pub.count_and_get(
365: p_count => x_msg_count,
366: p_data => x_msg_data);

Line 363: x_return_status := fnd_api.g_ret_sts_error;

359: END IF;
360:
361: EXCEPTION
362: WHEN fnd_api.g_exc_error THEN
363: x_return_status := fnd_api.g_ret_sts_error;
364: fnd_msg_pub.count_and_get(
365: p_count => x_msg_count,
366: p_data => x_msg_data);
367:

Line 368: WHEN fnd_api.g_exc_unexpected_error THEN

364: fnd_msg_pub.count_and_get(
365: p_count => x_msg_count,
366: p_data => x_msg_data);
367:
368: WHEN fnd_api.g_exc_unexpected_error THEN
369: x_return_status := fnd_api.g_ret_sts_unexp_error;
370: fnd_msg_pub.count_and_get(
371: p_count => x_msg_count,
372: p_data => x_msg_data);

Line 369: x_return_status := fnd_api.g_ret_sts_unexp_error;

365: p_count => x_msg_count,
366: p_data => x_msg_data);
367:
368: WHEN fnd_api.g_exc_unexpected_error THEN
369: x_return_status := fnd_api.g_ret_sts_unexp_error;
370: fnd_msg_pub.count_and_get(
371: p_count => x_msg_count,
372: p_data => x_msg_data);
373:

Line 375: x_return_status := fnd_api.g_ret_sts_unexp_error;

371: p_count => x_msg_count,
372: p_data => x_msg_data);
373:
374: WHEN OTHERS THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
377: fnd_msg_pub.add_exc_msg(
378: p_pkg_name => g_pkg_name,
379: p_procedure_name => l_api_name,