DBA Data[Home] [Help]

APPS.JTF_TASK_AUDITS_PVT dependencies on FND_MSG_PUB

Line 361: fnd_msg_pub.initialize;

357:
358: -- Initialize message list if requested
359: IF fnd_api.to_boolean (p_init_msg_list)
360: THEN
361: fnd_msg_pub.initialize;
362: END IF;
363:
364: -- Initialize return status to SUCCESS
365: x_return_status := fnd_api.g_ret_sts_success;

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

1154: COMMIT WORK;
1155: END IF;
1156:
1157:
1158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1159: EXCEPTION
1160: WHEN fnd_api.g_exc_error
1161: THEN
1162: ROLLBACK TO process_task_audit_pvt;

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

1160: WHEN fnd_api.g_exc_error
1161: THEN
1162: ROLLBACK TO process_task_audit_pvt;
1163: x_return_status := fnd_api.g_ret_sts_error;
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: WHEN fnd_api.g_exc_unexpected_error
1166: THEN
1167: ROLLBACK TO process_task_audit_pvt;
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1165: WHEN fnd_api.g_exc_unexpected_error
1166: THEN
1167: ROLLBACK TO process_task_audit_pvt;
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;
1169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1170: WHEN OTHERS
1171: THEN
1172: ROLLBACK TO process_task_audit_pvt;
1173: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1175: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1171: THEN
1172: ROLLBACK TO process_task_audit_pvt;
1173: x_return_status := fnd_api.g_ret_sts_unexp_error;
1174:
1175: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1176: THEN
1177: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1178: END IF;
1179:

Line 1177: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1173: x_return_status := fnd_api.g_ret_sts_unexp_error;
1174:
1175: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1176: THEN
1177: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1178: END IF;
1179:
1180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1181: END;

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

1176: THEN
1177: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1178: END IF;
1179:
1180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1181: END;
1182:
1183: PROCEDURE create_task_audits (
1184: p_api_version IN NUMBER,

Line 1510: fnd_msg_pub.initialize;

1506: END IF;
1507:
1508: IF fnd_api.to_boolean (p_init_msg_list)
1509: THEN
1510: fnd_msg_pub.initialize;
1511: END IF;
1512:
1513: x_return_status := fnd_api.g_ret_sts_success;
1514:

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

1780: THEN
1781: COMMIT WORK;
1782: END IF;
1783:
1784: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: EXCEPTION
1786: WHEN fnd_api.g_exc_error
1787: THEN
1788: ROLLBACK TO process_task_audit_pvt;

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

1786: WHEN fnd_api.g_exc_error
1787: THEN
1788: ROLLBACK TO process_task_audit_pvt;
1789: x_return_status := fnd_api.g_ret_sts_error;
1790: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1791: WHEN fnd_api.g_exc_unexpected_error
1792: THEN
1793: ROLLBACK TO process_task_audit_pvt;
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1791: WHEN fnd_api.g_exc_unexpected_error
1792: THEN
1793: ROLLBACK TO process_task_audit_pvt;
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1796: WHEN OTHERS
1797: THEN
1798: ROLLBACK TO process_task_audit_pvt;
1799: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1797: THEN
1798: ROLLBACK TO process_task_audit_pvt;
1799: x_return_status := fnd_api.g_ret_sts_unexp_error;
1800:
1801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1802: THEN
1803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1804: END IF;
1805:

Line 1803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1799: x_return_status := fnd_api.g_ret_sts_unexp_error;
1800:
1801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1802: THEN
1803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1804: END IF;
1805:
1806: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1807: END;

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

1802: THEN
1803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1804: END IF;
1805:
1806: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1807: END;
1808:
1809: procedure INSERT_ROW (
1810: X_ROWID in out NOCOPY VARCHAR2,