48:
49: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
50: p_parent_entity_name <> 'HZ_PARTIES' ) THEN
51:
52: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
53: fnd_message.set_token('P_ENTITY',p_entity_name);
54: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
55: FND_MSG_PUB.add;
56:
49: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
50: p_parent_entity_name <> 'HZ_PARTIES' ) THEN
51:
52: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
53: fnd_message.set_token('P_ENTITY',p_entity_name);
54: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
55: FND_MSG_PUB.add;
56:
57: x_return_status := fnd_api.g_ret_sts_error;
50: p_parent_entity_name <> 'HZ_PARTIES' ) THEN
51:
52: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
53: fnd_message.set_token('P_ENTITY',p_entity_name);
54: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
55: FND_MSG_PUB.add;
56:
57: x_return_status := fnd_api.g_ret_sts_error;
58:
91: x_return_status := fnd_api.g_ret_sts_error;
92: ROLLBACK TO TERR_PARTY_MERGE_PUB;
93:
94: WHEN OTHERS THEN
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('P_SQLCODE', SQLCODE);
97: fnd_message.set_token('P_SQLERRM', SQLERRM);
98: fnd_message.set_token('P_API_NAME', l_api_name);
99: FND_MSG_PUB.add;
92: ROLLBACK TO TERR_PARTY_MERGE_PUB;
93:
94: WHEN OTHERS THEN
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('P_SQLCODE', SQLCODE);
97: fnd_message.set_token('P_SQLERRM', SQLERRM);
98: fnd_message.set_token('P_API_NAME', l_api_name);
99: FND_MSG_PUB.add;
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
93:
94: WHEN OTHERS THEN
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('P_SQLCODE', SQLCODE);
97: fnd_message.set_token('P_SQLERRM', SQLERRM);
98: fnd_message.set_token('P_API_NAME', l_api_name);
99: FND_MSG_PUB.add;
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101: ROLLBACK TO TERR_PARTY_MERGE_PUB;
94: WHEN OTHERS THEN
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('P_SQLCODE', SQLCODE);
97: fnd_message.set_token('P_SQLERRM', SQLERRM);
98: fnd_message.set_token('P_API_NAME', l_api_name);
99: FND_MSG_PUB.add;
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101: ROLLBACK TO TERR_PARTY_MERGE_PUB;
102:
132:
133: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
134: p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
135:
136: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
137: fnd_message.set_token('P_ENTITY', p_entity_name);
138: fnd_message.set_token('P_PARENT_ENTITY', p_parent_entity_name);
139: FND_MSG_PUB.add;
140:
133: IF ( p_entity_name <> 'JTF_TERR_VALUES_ALL' OR
134: p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
135:
136: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
137: fnd_message.set_token('P_ENTITY', p_entity_name);
138: fnd_message.set_token('P_PARENT_ENTITY', p_parent_entity_name);
139: FND_MSG_PUB.add;
140:
141: x_return_status := fnd_api.g_ret_sts_error;
134: p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
135:
136: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
137: fnd_message.set_token('P_ENTITY', p_entity_name);
138: fnd_message.set_token('P_PARENT_ENTITY', p_parent_entity_name);
139: FND_MSG_PUB.add;
140:
141: x_return_status := fnd_api.g_ret_sts_error;
142:
175: x_return_status := fnd_api.g_ret_sts_error;
176: ROLLBACK TO TERR_PARTY_SITE_MERGE_PUB;
177:
178: WHEN OTHERS THEN
179: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
180: fnd_message.set_token('P_SQLCODE',SQLCODE);
181: fnd_message.set_token('P_SQLERRM',SQLERRM);
182: fnd_message.set_token('P_API_NAME', l_api_name);
183: FND_MSG_PUB.add;
176: ROLLBACK TO TERR_PARTY_SITE_MERGE_PUB;
177:
178: WHEN OTHERS THEN
179: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
180: fnd_message.set_token('P_SQLCODE',SQLCODE);
181: fnd_message.set_token('P_SQLERRM',SQLERRM);
182: fnd_message.set_token('P_API_NAME', l_api_name);
183: FND_MSG_PUB.add;
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
177:
178: WHEN OTHERS THEN
179: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
180: fnd_message.set_token('P_SQLCODE',SQLCODE);
181: fnd_message.set_token('P_SQLERRM',SQLERRM);
182: fnd_message.set_token('P_API_NAME', l_api_name);
183: FND_MSG_PUB.add;
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: ROLLBACK TO TERR_PARTY_SITE_MERGE_PUB;
178: WHEN OTHERS THEN
179: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
180: fnd_message.set_token('P_SQLCODE',SQLCODE);
181: fnd_message.set_token('P_SQLERRM',SQLERRM);
182: fnd_message.set_token('P_API_NAME', l_api_name);
183: FND_MSG_PUB.add;
184: x_return_status := fnd_api.g_ret_sts_unexp_error;
185: ROLLBACK TO TERR_PARTY_SITE_MERGE_PUB;
186: