APPS.QA_VENDORMERGE_GRP dependencies on FND_API

Line 64: IF NOT fnd_api.compatible_API_call(l_api_version, nvl(p_api_version,

60: -- Standard Start of API savepoint
61: SAVEPOINT qa_VendorMerge_grp;
62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_API_call(l_api_version, nvl(p_api_version,
65: 1.0), l_api_name, g_pkg_name) THEN
66: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:

Line 66: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

62:
63: -- Standard call to check for call compatibility.
64: IF NOT fnd_api.compatible_API_call(l_api_version, nvl(p_api_version,
65: 1.0), l_api_name, g_pkg_name) THEN
66: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: --
70: -- Standard call to reset message stack if needed.

Line 73: IF p_init_msg_list = fnd_api.G_TRUE THEN

69: --
70: -- Standard call to reset message stack if needed.
71: -- NULL is intentionally treated as false by this statement.
72: --
73: IF p_init_msg_list = fnd_api.G_TRUE THEN
74: fnd_msg_pub.initialize;
75: END IF;
76:
77: -- Perform actual update to database table.

Line 83: IF p_commit = fnd_api.G_TRUE THEN

79: p_from_vendor_id => p_dup_vendor_id,
80: p_to_vendor_id => p_vendor_id);
81:
82: -- NULL is intentionally treated as false by this statement.
83: IF p_commit = fnd_api.G_TRUE THEN
84: COMMIT;
85: END IF;
86:
87: p_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 87: p_return_status := fnd_api.G_RET_STS_SUCCESS;

83: IF p_commit = fnd_api.G_TRUE THEN
84: COMMIT;
85: END IF;
86:
87: p_return_status := fnd_api.G_RET_STS_SUCCESS;
88:
89: EXCEPTION
90: WHEN fnd_api.G_EXC_ERROR THEN
91: ROLLBACK TO qa_VendorMerge_grp;

Line 90: WHEN fnd_api.G_EXC_ERROR THEN

86:
87: p_return_status := fnd_api.G_RET_STS_SUCCESS;
88:
89: EXCEPTION
90: WHEN fnd_api.G_EXC_ERROR THEN
91: ROLLBACK TO qa_VendorMerge_grp;
92: p_return_status := fnd_api.G_RET_STS_ERROR;
93: fnd_msg_pub.count_and_get(
94: p_count => p_msg_count,

Line 92: p_return_status := fnd_api.G_RET_STS_ERROR;

88:
89: EXCEPTION
90: WHEN fnd_api.G_EXC_ERROR THEN
91: ROLLBACK TO qa_VendorMerge_grp;
92: p_return_status := fnd_api.G_RET_STS_ERROR;
93: fnd_msg_pub.count_and_get(
94: p_count => p_msg_count,
95: p_data => p_msg_data);
96:

Line 97: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

93: fnd_msg_pub.count_and_get(
94: p_count => p_msg_count,
95: p_data => p_msg_data);
96:
97: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
98: ROLLBACK TO qa_VendorMerge_grp;
99: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
100: fnd_msg_pub.count_and_get(
101: p_count => p_msg_count,

Line 99: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

95: p_data => p_msg_data);
96:
97: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN
98: ROLLBACK TO qa_VendorMerge_grp;
99: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
100: fnd_msg_pub.count_and_get(
101: p_count => p_msg_count,
102: p_data => p_msg_data);
103:

Line 106: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

102: p_data => p_msg_data);
103:
104: WHEN OTHERS THEN
105: ROLLBACK TO qa_VendorMerge_grp;
106: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
107: fnd_msg_pub.count_and_get(
108: p_count => p_msg_count,
109: p_data => p_msg_data);
110: