DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PUB dependencies on FND_MSG_PUB

Line 66: fnd_msg_pub.initialize;

62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: IF fnd_api.to_boolean(p_init_msg_list) THEN
66: fnd_msg_pub.initialize;
67: END IF;
68:
69: --Put in all the Validations here
70:

Line 102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

98: IF fnd_api.to_boolean(p_commit) THEN
99: COMMIT WORK;
100: END IF;
101:
102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
103:
104: EXCEPTION
105: WHEN fnd_api.g_exc_unexpected_error THEN
106: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

106: --DBMS_OUTPUT.put_line (' ========================================== ');
107: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
108: ROLLBACK TO create_rs_resource_roles_pub;
109: x_return_status := fnd_api.g_ret_sts_unexp_error;
110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
111: WHEN OTHERS THEN
112: --DBMS_OUTPUT.put_line (' ========================================== ');
113: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Role Pub ============= ');
114: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 117: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

113: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Role Pub ============= ');
114: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
115: ROLLBACK TO create_rs_resource_roles_pub;
116: x_return_status := fnd_api.g_ret_sts_unexp_error;
117: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
118:
119: END create_rs_resource_roles;
120:
121: --Procedure to update the resource Roles based on input values passed by calling routines

Line 167: fnd_msg_pub.initialize;

163: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
164: RAISE fnd_api.g_exc_unexpected_error;
165: END IF;
166: IF fnd_api.to_boolean(p_init_msg_list) THEN
167: fnd_msg_pub.initialize;
168: END IF;
169:
170: --Put Validations here
171:

Line 204: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

200: IF fnd_api.to_boolean(p_commit) THEN
201: COMMIT WORK;
202: END IF;
203:
204: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
205:
206: EXCEPTION
207: WHEN fnd_api.g_exc_unexpected_error THEN
208: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 212: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

208: --DBMS_OUTPUT.put_line (' ========================================== ');
209: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
210: ROLLBACK TO update_rs_resource_roles_pub;
211: x_return_status := fnd_api.g_ret_sts_unexp_error;
212: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
213: WHEN OTHERS THEN
214: --DBMS_OUTPUT.put_line (' ========================================== ');
215: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub ============= ');
216: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

215: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub ============= ');
216: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
217: ROLLBACK TO update_rs_resource_roles_pub;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220:
221: END update_rs_resource_roles;
222:
223:

Line 252: fnd_msg_pub.initialize;

248: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
249: RAISE fnd_api.g_exc_unexpected_error;
250: END IF;
251: IF fnd_api.to_boolean(p_init_msg_list) THEN
252: fnd_msg_pub.initialize;
253: END IF;
254:
255: --Put all Validations here
256:

Line 280: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

276: IF fnd_api.to_boolean(p_commit) THEN
277: COMMIT WORK;
278: END IF;
279:
280: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN fnd_api.g_exc_unexpected_error THEN
284: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 288: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

284: --DBMS_OUTPUT.put_line (' ========================================== ');
285: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
286: ROLLBACK TO delete_rs_resource_roles_pub;
287: x_return_status := fnd_api.g_ret_sts_unexp_error;
288: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
289: WHEN OTHERS THEN
290: --DBMS_OUTPUT.put_line (' ========================================== ');
291: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Role Pub ============= ');
292: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 295: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

291: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Role Pub ============= ');
292: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
293: ROLLBACK TO delete_rs_resource_roles_pub;
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
296:
297: END delete_rs_resource_roles;
298:
299: END jtf_rs_roles_pub;