APPS.CAC_SYNC_CONTACT_PREF_PVT dependencies on FND_MSG_PUB

Line 36: fnd_msg_pub.initialize;

32:
33: IF p_init_msg_list IS NULL OR
34: fnd_api.to_boolean (p_init_msg_list)
35: THEN
36: fnd_msg_pub.initialize;
37: END IF;
38:
39: -- Check if the given contact_party_id exists
40: OPEN c_preference;

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

77: AND module = p_module
78: AND value_number = p_value_number;
79: END IF;
80:
81: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
82:
83: EXCEPTION
84: WHEN fnd_api.g_exc_unexpected_error THEN
85: ROLLBACK TO create_contact_preference_sv;

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

83: EXCEPTION
84: WHEN fnd_api.g_exc_unexpected_error THEN
85: ROLLBACK TO create_contact_preference_sv;
86: x_return_status := fnd_api.g_ret_sts_unexp_error;
87: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
88: IF c_preference%ISOPEN THEN
89: CLOSE c_preference;
90: END IF;
91:

Line 96: fnd_msg_pub.add;

92: WHEN OTHERS THEN
93: ROLLBACK TO create_contact_preference_sv;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: IF c_preference%ISOPEN THEN
100: CLOSE c_preference;

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

94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: IF c_preference%ISOPEN THEN
100: CLOSE c_preference;
101: END IF;
102: END CREATE_CONTACT_PREFERENCE;

Line 124: fnd_msg_pub.initialize;

120:
121: IF p_init_msg_list IS NULL OR
122: fnd_api.to_boolean (p_init_msg_list)
123: THEN
124: fnd_msg_pub.initialize;
125: END IF;
126:
127: hz_preference_pub.remove
128: ( p_party_id => p_party_id

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

140: x_return_status := fnd_api.g_ret_sts_unexp_error;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;
143:
144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
145:
146: EXCEPTION
147: WHEN fnd_api.g_exc_unexpected_error THEN
148: ROLLBACK TO delete_contact_preference_sv;

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

146: EXCEPTION
147: WHEN fnd_api.g_exc_unexpected_error THEN
148: ROLLBACK TO delete_contact_preference_sv;
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 156: fnd_msg_pub.add;

152: WHEN OTHERS THEN
153: ROLLBACK TO delete_contact_preference_sv;
154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
159:
160: END DELETE_CONTACT_PREFERENCE;

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

154: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
155: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
156: fnd_msg_pub.add;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
159:
160: END DELETE_CONTACT_PREFERENCE;
161:
162: END CAC_SYNC_CONTACT_PREF_PVT;