DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_VALUES_PUB dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.initialize;

54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57: IF fnd_api.to_boolean(p_init_msg_list) THEN
58: fnd_msg_pub.initialize;
59: END IF;
60:
61: --Put in all the Validations here
62:

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

110: END IF;
111:
112: x_resource_param_value_id := l_resource_param_value_id;
113:
114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
115:
116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error THEN
118: --DBMS_OUTPUT.put_line (' ========================================== ');

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

118: --DBMS_OUTPUT.put_line (' ========================================== ');
119: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
120: ROLLBACK TO create_rs_resource_values_pub;
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
123: WHEN OTHERS THEN
124: --DBMS_OUTPUT.put_line (' ========================================== ');
125: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Values Pub ==============');
126: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

125: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Values Pub ==============');
126: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
127: ROLLBACK TO create_rs_resource_values_pub;
128: x_return_status := fnd_api.g_ret_sts_unexp_error;
129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
130:
131: END create_rs_resource_values;
132:
133: --Procedure to Update Resource Values based on the input values passed by the calling routines

Line 171: fnd_msg_pub.initialize;

167: RAISE fnd_api.g_exc_unexpected_error;
168: END IF;
169:
170: IF fnd_api.to_boolean(p_init_msg_list) THEN
171: fnd_msg_pub.initialize;
172: END IF;
173:
174: --Put all Validations here
175:

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

243: END IF;
244: IF fnd_api.to_boolean(p_commit) THEN
245: COMMIT WORK;
246: END IF;
247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
248:
249: EXCEPTION
250: WHEN fnd_api.g_exc_unexpected_error THEN
251: --DBMS_OUTPUT.put_line (' ========================================== ');

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

251: --DBMS_OUTPUT.put_line (' ========================================== ');
252: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
253: ROLLBACK TO update_rs_resource_values_pub;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
256: WHEN OTHERS THEN
257: --DBMS_OUTPUT.put_line (' ========================================== ');
258: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Values Pub ============= ');
259: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

258: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Values Pub ============= ');
259: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
260: ROLLBACK TO update_rs_resource_values_pub;
261: x_return_status := fnd_api.g_ret_sts_unexp_error;
262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
263:
264: END update_rs_resource_values;
265:
266: /* Procedure to Delete Resource Values based on the

Line 295: fnd_msg_pub.initialize;

291: RAISE fnd_api.g_exc_unexpected_error;
292: END IF;
293:
294: IF fnd_api.to_boolean(p_init_msg_list) THEN
295: fnd_msg_pub.initialize;
296: END IF;
297:
298: --Put all Validations here
299:

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

316: END IF;
317: IF fnd_api.to_boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
321:
322: EXCEPTION
323: WHEN fnd_api.g_exc_unexpected_error THEN
324: --DBMS_OUTPUT.put_line (' ========================================== ');

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

324: --DBMS_OUTPUT.put_line (' ========================================== ');
325: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
326: ROLLBACK TO delete_rs_resource_values_pub;
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
329: WHEN OTHERS THEN
330: --DBMS_OUTPUT.put_line (' ========================================== ');
331: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Values Pub ============= ');
332: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

331: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Values Pub ============= ');
332: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
333: ROLLBACK TO delete_rs_resource_values_pub;
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
336:
337: END delete_rs_resource_values;
338:
339: /* Procedure to Delete all Resource Values based on the

Line 368: fnd_msg_pub.initialize;

364: RAISE fnd_api.g_exc_unexpected_error;
365: END IF;
366:
367: IF fnd_api.to_boolean(p_init_msg_list) THEN
368: fnd_msg_pub.initialize;
369: END IF;
370:
371: --Put all Validations here
372:

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

388: END IF;
389: IF fnd_api.to_boolean(p_commit) THEN
390: COMMIT WORK;
391: END IF;
392: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
393:
394: EXCEPTION
395: WHEN fnd_api.g_exc_unexpected_error THEN
396: --DBMS_OUTPUT.put_line (' ========================================== ');

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

396: --DBMS_OUTPUT.put_line (' ========================================== ');
397: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
398: ROLLBACK TO delete_all_rs_values_pub;
399: x_return_status := fnd_api.g_ret_sts_unexp_error;
400: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
401: WHEN OTHERS THEN
402: --DBMS_OUTPUT.put_line (' ========================================== ');
403: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete All Resource Values Pub =============');
404: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

403: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete All Resource Values Pub =============');
404: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
405: ROLLBACK TO delete_all_rs_values_pub;
406: x_return_status := fnd_api.g_ret_sts_unexp_error;
407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
408:
409: END delete_all_rs_resource_values;
410:
411: /* Procedure to Get Resource Values based on the

Line 448: fnd_msg_pub.initialize;

444: RAISE fnd_api.g_exc_unexpected_error;
445: END IF;
446:
447: IF fnd_api.to_boolean(p_init_msg_list) THEN
448: fnd_msg_pub.initialize;
449: END IF;
450:
451: --Put all Validations here
452:

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

499: END IF;
500: IF fnd_api.to_boolean(p_commit) THEN
501: COMMIT WORK;
502: END IF;
503: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
504:
505: EXCEPTION
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: --DBMS_OUTPUT.put_line (' ========================================== ');

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

507: --DBMS_OUTPUT.put_line (' ========================================== ');
508: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
509: ROLLBACK TO get_rs_resource_values_pub;
510: x_return_status := fnd_api.g_ret_sts_unexp_error;
511: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
512: WHEN OTHERS THEN
513: --DBMS_OUTPUT.put_line (' ========================================== ');
514: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Values Pub =============');
515: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

514: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Values Pub =============');
515: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
516: ROLLBACK TO get_rs_resource_values_pub;
517: x_return_status := fnd_api.g_ret_sts_unexp_error;
518: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
519:
520: END get_rs_resource_values;
521:
522: --Procedure to Get Resource Param List for the given Application Id and Param Type

Line 550: fnd_msg_pub.initialize;

546: RAISE fnd_api.g_exc_unexpected_error;
547: END IF;
548:
549: IF fnd_api.to_boolean(p_init_msg_list) THEN
550: fnd_msg_pub.initialize;
551: END IF;
552:
553: --Put all Validations here
554:

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

572: END IF;
573: IF fnd_api.to_boolean(p_commit) THEN
574: COMMIT WORK;
575: END IF;
576: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
577:
578: EXCEPTION
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: --DBMS_OUTPUT.put_line (' ========================================== ');

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

580: --DBMS_OUTPUT.put_line (' ========================================== ');
581: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
582: ROLLBACK TO get_rs_param_list_pub;
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
585: WHEN OTHERS THEN
586: --DBMS_OUTPUT.put_line (' ========================================== ');
587: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Param List Pub =============');
588: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

587: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Param List Pub =============');
588: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
589: ROLLBACK TO get_rs_param_list_pub;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
592:
593: END get_rs_resource_param_list;
594:
595: End JTF_RS_RESOURCE_VALUES_PUB;