APPS.CAC_NOTE_PURGE_PVT dependencies on FND_API

Line 26: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

22: +======================================================================*/
23:
24: Procedure purge_notes(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
27: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 27: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

23:
24: Procedure purge_notes(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
27: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: p_processing_set_id IN NUMBER,

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63:
64: BEGIN
65:
66: SAVEPOINT purge_notes;
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: IF NOT fnd_api.compatible_api_call (
70: l_api_version,
71: p_api_version,

Line 69: IF NOT fnd_api.compatible_api_call (

65:
66: SAVEPOINT purge_notes;
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: IF NOT fnd_api.compatible_api_call (
70: l_api_version,
71: p_api_version,
72: l_api_name,
73: g_pkg_name

Line 76: RAISE fnd_api.g_exc_unexpected_error;

72: l_api_name,
73: g_pkg_name
74: )
75: THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78:
79: IF fnd_api.to_boolean (p_init_msg_list)
80: THEN

Line 79: IF fnd_api.to_boolean (p_init_msg_list)

75: THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78:
79: IF fnd_api.to_boolean (p_init_msg_list)
80: THEN
81: fnd_msg_pub.initialize;
82: END IF;
83:

Line 139: IF fnd_api.to_boolean(p_commit)

135: Delete JTF_NOTE_CONTEXTS
136: Where jtf_note_id = l_tab_note_contx_id(j);
137: END IF;
138:
139: IF fnd_api.to_boolean(p_commit)
140: THEN
141: COMMIT WORK;
142: END IF;
143:

Line 145: WHEN fnd_api.g_exc_unexpected_error

141: COMMIT WORK;
142: END IF;
143:
144: EXCEPTION
145: WHEN fnd_api.g_exc_unexpected_error
146: THEN
147: ROLLBACK TO purge_notes;
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: fnd_msg_pub.count_and_get (

Line 148: x_return_status := fnd_api.g_ret_sts_unexp_error;

144: EXCEPTION
145: WHEN fnd_api.g_exc_unexpected_error
146: THEN
147: ROLLBACK TO purge_notes;
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: fnd_msg_pub.count_and_get (
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );

Line 161: x_return_status := fnd_api.g_ret_sts_unexp_error;

157: fnd_message.set_name ('JTF', 'CAC_NOTE_UNKNOWN_ERROR');
158: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
159: fnd_msg_pub.add;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: fnd_msg_pub.count_and_get (
163: p_count => x_msg_count,
164: p_data => x_msg_data
165: );