eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_HIERARCHY_V2PUB dependencies on FND_MESSAGE

Line 141: FND_MESSAGE.SET_NAME('AR', 'HZ_NON_HIER_REL_TYPE');

137: AND ROWNUM = 1;
138:
139: IF l_dummy <> 'Y' THEN
140: -- relationship type is not hierarchical, give error
141: FND_MESSAGE.SET_NAME('AR', 'HZ_NON_HIER_REL_TYPE');
142: FND_MSG_PUB.ADD;
143: x_return_status := fnd_api.g_ret_sts_error;
144: END IF;
145:

Line 149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: -- no relationship type record found, so error out NOCOPY
149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;

Line 150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');

146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: -- no relationship type record found, so error out NOCOPY
149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;
154: x_return_status := fnd_api.g_ret_sts_error;

Line 151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');

147: WHEN NO_DATA_FOUND THEN
148: -- no relationship type record found, so error out NOCOPY
149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;
154: x_return_status := fnd_api.g_ret_sts_error;
155: END;

Line 152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');

148: -- no relationship type record found, so error out NOCOPY
149: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
150: FND_MESSAGE.SET_TOKEN('FK', 'hierarchy_type');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_type');
152: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
153: FND_MSG_PUB.ADD;
154: x_return_status := fnd_api.g_ret_sts_error;
155: END;
156:

Line 169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

165: FROM fnd_objects fo
166: WHERE fo.obj_name = p_parent_table_name;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;

Line 170: fnd_message.set_token('FK', 'parent_table_name');

166: WHERE fo.obj_name = p_parent_table_name;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;

Line 171: fnd_message.set_token('COLUMN', 'obj_name');

167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END;

Line 172: fnd_message.set_token('TABLE', 'fnd_objects');

168: WHEN NO_DATA_FOUND THEN
169: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
170: fnd_message.set_token('FK', 'parent_table_name');
171: fnd_message.set_token('COLUMN', 'obj_name');
172: fnd_message.set_token('TABLE', 'fnd_objects');
173: fnd_msg_pub.add;
174: x_return_status := fnd_api.g_ret_sts_error;
175: END;
176: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 198: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

194: FROM FND_OBJECT_INSTANCE_SETS
195: WHERE INSTANCE_SET_NAME = p_parent_object_type;
196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN
198: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
199: fnd_message.set_token('FK', 'parent_object_type');
200: fnd_message.set_token('COLUMN', 'instance_set_name');
201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
202: fnd_msg_pub.add;

Line 199: fnd_message.set_token('FK', 'parent_object_type');

195: WHERE INSTANCE_SET_NAME = p_parent_object_type;
196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN
198: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
199: fnd_message.set_token('FK', 'parent_object_type');
200: fnd_message.set_token('COLUMN', 'instance_set_name');
201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
202: fnd_msg_pub.add;
203: x_return_status := fnd_api.g_ret_sts_error;

Line 200: fnd_message.set_token('COLUMN', 'instance_set_name');

196: EXCEPTION
197: WHEN NO_DATA_FOUND THEN
198: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
199: fnd_message.set_token('FK', 'parent_object_type');
200: fnd_message.set_token('COLUMN', 'instance_set_name');
201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
202: fnd_msg_pub.add;
203: x_return_status := fnd_api.g_ret_sts_error;
204: END;

Line 201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');

197: WHEN NO_DATA_FOUND THEN
198: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
199: fnd_message.set_token('FK', 'parent_object_type');
200: fnd_message.set_token('COLUMN', 'instance_set_name');
201: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
202: fnd_msg_pub.add;
203: x_return_status := fnd_api.g_ret_sts_error;
204: END;
205:

Line 227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

223: FROM fnd_objects fo
224: WHERE fo.obj_name = p_child_table_name;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
231: fnd_msg_pub.add;

Line 228: fnd_message.set_token('FK', 'child_table_name');

224: WHERE fo.obj_name = p_child_table_name;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
231: fnd_msg_pub.add;
232: x_return_status := fnd_api.g_ret_sts_error;

Line 229: fnd_message.set_token('COLUMN', 'obj_name');

225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
231: fnd_msg_pub.add;
232: x_return_status := fnd_api.g_ret_sts_error;
233: END;

Line 230: fnd_message.set_token('TABLE', 'fnd_objects');

226: WHEN NO_DATA_FOUND THEN
227: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
228: fnd_message.set_token('FK', 'child_table_name');
229: fnd_message.set_token('COLUMN', 'obj_name');
230: fnd_message.set_token('TABLE', 'fnd_objects');
231: fnd_msg_pub.add;
232: x_return_status := fnd_api.g_ret_sts_error;
233: END;
234:

Line 257: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

253: FROM FND_OBJECT_INSTANCE_SETS
254: WHERE INSTANCE_SET_NAME = p_child_object_type;
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
258: fnd_message.set_token('FK', 'child_object_type');
259: fnd_message.set_token('COLUMN', 'instance_set_name');
260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
261: fnd_msg_pub.add;

Line 258: fnd_message.set_token('FK', 'child_object_type');

254: WHERE INSTANCE_SET_NAME = p_child_object_type;
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
258: fnd_message.set_token('FK', 'child_object_type');
259: fnd_message.set_token('COLUMN', 'instance_set_name');
260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
261: fnd_msg_pub.add;
262: x_return_status := fnd_api.g_ret_sts_error;

Line 259: fnd_message.set_token('COLUMN', 'instance_set_name');

255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
258: fnd_message.set_token('FK', 'child_object_type');
259: fnd_message.set_token('COLUMN', 'instance_set_name');
260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
261: fnd_msg_pub.add;
262: x_return_status := fnd_api.g_ret_sts_error;
263: END;

Line 260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');

256: WHEN NO_DATA_FOUND THEN
257: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
258: fnd_message.set_token('FK', 'child_object_type');
259: fnd_message.set_token('COLUMN', 'instance_set_name');
260: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
261: fnd_msg_pub.add;
262: x_return_status := fnd_api.g_ret_sts_error;
263: END;
264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );

277: IF p_no_of_records > 100 OR
278: p_no_of_records < 1 OR
279: p_no_of_records IS NULL
280: THEN
281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');
283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );
284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
285: FND_MSG_PUB.ADD;

Line 282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');

278: p_no_of_records < 1 OR
279: p_no_of_records IS NULL
280: THEN
281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');
283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );
284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
285: FND_MSG_PUB.ADD;
286: x_return_status := FND_API.G_RET_STS_ERROR;

Line 283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );

279: p_no_of_records IS NULL
280: THEN
281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');
283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );
284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
285: FND_MSG_PUB.ADD;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287:

Line 284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );

280: THEN
281: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_VALUE_BETWEEN' );
282: FND_MESSAGE.SET_TOKEN( 'COLUMN','p_no_of_records');
283: FND_MESSAGE.SET_TOKEN( 'VALUE1', '1' );
284: FND_MESSAGE.SET_TOKEN( 'VALUE2', '100' );
285: FND_MSG_PUB.ADD;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287:
288: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

462: WHEN OTHERS THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: x_result := 'N';
465:
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
467: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(

Line 467: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: x_result := 'N';
465:
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
467: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,

Line 657: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_result := 'N';
655: x_level_number := -1;
656:
657: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
658: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
659: FND_MSG_PUB.ADD;
660:
661: FND_MSG_PUB.Count_And_Get(

Line 658: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

654: x_result := 'N';
655: x_level_number := -1;
656:
657: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
658: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
659: FND_MSG_PUB.ADD;
660:
661: FND_MSG_PUB.Count_And_Get(
662: p_encoded => FND_API.G_FALSE,

Line 898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

894:
895: WHEN OTHERS THEN
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897:
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
899: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
900: FND_MSG_PUB.ADD;
901:
902: FND_MSG_PUB.Count_And_Get(

Line 899: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

895: WHEN OTHERS THEN
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897:
898: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
899: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
900: FND_MSG_PUB.ADD;
901:
902: FND_MSG_PUB.Count_And_Get(
903: p_encoded => FND_API.G_FALSE,

Line 1139: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

1135:
1136: WHEN OTHERS THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138:
1139: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1140: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1141: FND_MSG_PUB.ADD;
1142:
1143: FND_MSG_PUB.Count_And_Get(

Line 1140: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

1136: WHEN OTHERS THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138:
1139: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1140: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1141: FND_MSG_PUB.ADD;
1142:
1143: FND_MSG_PUB.Count_And_Get(
1144: p_encoded => FND_API.G_FALSE,

Line 1415: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

1411:
1412: WHEN OTHERS THEN
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414:
1415: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1416: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1417: FND_MSG_PUB.ADD;
1418:
1419: FND_MSG_PUB.Count_And_Get(

Line 1416: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

1412: WHEN OTHERS THEN
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414:
1415: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1416: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1417: FND_MSG_PUB.ADD;
1418:
1419: FND_MSG_PUB.Count_And_Get(
1420: p_encoded => FND_API.G_FALSE,