DBA Data[Home] [Help]

APPS.JTF_TERR_MERGE_PUB dependencies on FND_MESSAGE

Line 52: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');

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:

Line 53: fnd_message.set_token('P_ENTITY',p_entity_name);

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;

Line 54: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

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:

Line 95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 96: fnd_message.set_token('P_SQLCODE', SQLCODE);

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;

Line 97: fnd_message.set_token('P_SQLERRM', SQLERRM);

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;

Line 98: fnd_message.set_token('P_API_NAME', l_api_name);

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:

Line 136: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');

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:

Line 137: fnd_message.set_token('P_ENTITY', p_entity_name);

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;

Line 138: fnd_message.set_token('P_PARENT_ENTITY', p_parent_entity_name);

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:

Line 179: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 180: fnd_message.set_token('P_SQLCODE',SQLCODE);

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;

Line 181: fnd_message.set_token('P_SQLERRM',SQLERRM);

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;

Line 182: fnd_message.set_token('P_API_NAME', l_api_name);

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: