DBA Data[Home] [Help]

APPS.JTF_RS_TABLE_ATTRIBUTES_PUB dependencies on FND_MSG_PUB

Line 81: FND_MSG_PUB.Initialize;

77:
78: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
79: IF FND_API.To_boolean(P_INIT_MSG_LIST)
80: THEN
81: FND_MSG_PUB.Initialize;
82: END IF;
83:
84: JTF_RS_TABLE_ATTRIBUTES_PVT.CREATE_TABLE_ATTRIBUTE(
85: P_API_VERSION => l_api_version,

Line 125: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

121: THEN
122: COMMIT WORK;
123: END IF;
124:
125: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
126:
127: EXCEPTION
128: WHEN fnd_api.g_exc_unexpected_error
129: THEN

Line 132: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

128: WHEN fnd_api.g_exc_unexpected_error
129: THEN
130:
131: ROLLBACK TO TABLE_ATTRIBUTE_SP;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
133: WHEN fnd_api.g_exc_error
134: THEN
135: ROLLBACK TO TABLE_ATTRIBUTE_SP;
136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

132: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
133: WHEN fnd_api.g_exc_error
134: THEN
135: ROLLBACK TO TABLE_ATTRIBUTE_SP;
136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
137: WHEN OTHERS
138: THEN
139: ROLLBACK TO ROLE_RELATE_SP;
140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 144: FND_MSG_PUB.add;

140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
147:
148: END create_table_attribute;

Line 146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
147:
148: END create_table_attribute;
149:
150:

Line 217: FND_MSG_PUB.Initialize;

213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
215: IF FND_API.To_boolean(P_INIT_MSG_LIST)
216: THEN
217: FND_MSG_PUB.Initialize;
218: END IF;
219:
220: JTF_RS_TABLE_ATTRIBUTES_PVT.UPDATE_TABLE_ATTRIBUTE(
221: P_API_VERSION => l_api_version,

Line 261: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

257: THEN
258: COMMIT WORK;
259: END IF;
260:
261: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
262:
263: EXCEPTION
264: WHEN fnd_api.g_exc_error
265: THEN

Line 267: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

263: EXCEPTION
264: WHEN fnd_api.g_exc_error
265: THEN
266: ROLLBACK TO TABLE_ATTRIBUTE_SP;
267: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
268:
269: WHEN fnd_api.g_exc_unexpected_error
270: THEN
271: ROLLBACK TO TABLE_ATTRIBUTE_SP;

Line 273: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

269: WHEN fnd_api.g_exc_unexpected_error
270: THEN
271: ROLLBACK TO TABLE_ATTRIBUTE_SP;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
274: WHEN OTHERS
275: THEN
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;
277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 281: FND_MSG_PUB.add;

277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284: END update_table_attribute;
285:

Line 283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284: END update_table_attribute;
285:
286:
287: /* Procedure to delete the table attributes. */

Line 330: FND_MSG_PUB.Initialize;

326:
327: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
328: IF FND_API.To_boolean(P_INIT_MSG_LIST)
329: THEN
330: FND_MSG_PUB.Initialize;
331: END IF;
332:
333:
334: JTF_RS_TABLE_ATTRIBUTES_PVT.DELETE_TABLE_ATTRIBUTE

Line 354: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

350: THEN
351: COMMIT WORK;
352: END IF;
353:
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
355:
356: EXCEPTION
357: WHEN fnd_api.g_exc_unexpected_error
358: THEN

Line 360: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

356: EXCEPTION
357: WHEN fnd_api.g_exc_unexpected_error
358: THEN
359: ROLLBACK TO TABLE_ATTRIBUTE_SP;
360: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
361: WHEN fnd_api.g_exc_error
362: THEN
363: ROLLBACK TO TABLE_ATTRIBUTE_SP;
364: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 364: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

360: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
361: WHEN fnd_api.g_exc_error
362: THEN
363: ROLLBACK TO TABLE_ATTRIBUTE_SP;
364: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
365: WHEN OTHERS
366: THEN
367: ROLLBACK TO TABLE_ATTRIBUTE_SP;
368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 372: FND_MSG_PUB.add;

368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
375:
376: END delete_table_attribute;

Line 374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
375:
376: END delete_table_attribute;
377:
378: END jtf_rs_table_attributes_pub;