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_MSG_PUB

Line 142: FND_MSG_PUB.ADD;

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:
146: EXCEPTION

Line 153: FND_MSG_PUB.ADD;

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:
157: -----------------------------

Line 173: fnd_msg_pub.add;

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
177: hz_utility_v2pub.debug(p_message=>'parent_table_name has foreign key fnd_objects.obj_name. ' ||

Line 202: fnd_msg_pub.add;

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:
206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 231: fnd_msg_pub.add;

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:
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 261: fnd_msg_pub.add;

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
265: hz_utility_v2pub.debug(p_message=>'child_object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

Line 285: FND_MSG_PUB.ADD;

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
289: hz_utility_v2pub.debug(p_message=>'p_no_of_records should be between 1 and 100 .' ||

Line 349: FND_MSG_PUB.initialize;

345: END IF;
346:
347: --Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: --Initialize API return status to success.
353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 390: FND_MSG_PUB.Count_And_Get(

386: -- return the result
387: x_result := l_result;
388:
389: --Standard call to get message count and if count is 1, get message info.
390: FND_MSG_PUB.Count_And_Get(
391: p_encoded => FND_API.G_FALSE,
392: p_count => x_msg_count,
393: p_data => x_msg_data );
394:

Line 416: FND_MSG_PUB.Count_And_Get(

412: WHEN FND_API.G_EXC_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: x_result := 'N';
415:
416: FND_MSG_PUB.Count_And_Get(
417: p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data );
420:

Line 441: FND_MSG_PUB.Count_And_Get(

437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: x_result := 'N';
440:
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data );
445:

Line 468: FND_MSG_PUB.ADD;

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,
472: p_count => x_msg_count,

Line 470: FND_MSG_PUB.Count_And_Get(

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,
472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:

Line 529: FND_MSG_PUB.initialize;

525: END IF;
526:
527: --Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean(p_init_msg_list) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: --Initialize API return status to success.
533: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 578: FND_MSG_PUB.Count_And_Get(

574: x_level_number := -1;
575: END IF;
576:
577: --Standard call to get message count and if count is 1, get message info.
578: FND_MSG_PUB.Count_And_Get(
579: p_encoded => FND_API.G_FALSE,
580: p_count => x_msg_count,
581: p_data => x_msg_data );
582:

Line 605: FND_MSG_PUB.Count_And_Get(

601: x_return_status := FND_API.G_RET_STS_ERROR;
602: x_result := 'N';
603: x_level_number := -1;
604:
605: FND_MSG_PUB.Count_And_Get(
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data );
609:

Line 631: FND_MSG_PUB.Count_And_Get(

627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_result := 'N';
629: x_level_number := -1;
630:
631: FND_MSG_PUB.Count_And_Get(
632: p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data );
635:

Line 659: FND_MSG_PUB.ADD;

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,
663: p_count => x_msg_count,

Line 661: FND_MSG_PUB.Count_And_Get(

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,
663: p_count => x_msg_count,
664: p_data => x_msg_data );
665:

Line 758: FND_MSG_PUB.initialize;

754: END IF;
755:
756: --Initialize message list if p_init_msg_list is set to TRUE.
757: IF FND_API.to_Boolean(p_init_msg_list) THEN
758: FND_MSG_PUB.initialize;
759: END IF;
760:
761: --Initialize API return status to success.
762: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 825: FND_MSG_PUB.Count_And_Get(

821:
822: CLOSE c1;
823:
824: --Standard call to get message count and if count is 1, get message info.
825: FND_MSG_PUB.Count_And_Get(
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data );
829:

Line 850: FND_MSG_PUB.Count_And_Get(

846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849:
850: FND_MSG_PUB.Count_And_Get(
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data );
854:

Line 874: FND_MSG_PUB.Count_And_Get(

870:
871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874: FND_MSG_PUB.Count_And_Get(
875: p_encoded => FND_API.G_FALSE,
876: p_count => x_msg_count,
877: p_data => x_msg_data );
878:

Line 900: FND_MSG_PUB.ADD;

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,
904: p_count => x_msg_count,

Line 902: FND_MSG_PUB.Count_And_Get(

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,
904: p_count => x_msg_count,
905: p_data => x_msg_data );
906:

Line 999: FND_MSG_PUB.initialize;

995: END IF;
996:
997: --Initialize message list if p_init_msg_list is set to TRUE.
998: IF FND_API.to_Boolean(p_init_msg_list) THEN
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002: --Initialize API return status to success.
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1066: FND_MSG_PUB.Count_And_Get(

1062:
1063: CLOSE c1;
1064:
1065: --Standard call to get message count and if count is 1, get message info.
1066: FND_MSG_PUB.Count_And_Get(
1067: p_encoded => FND_API.G_FALSE,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data );
1070:

Line 1091: FND_MSG_PUB.Count_And_Get(

1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090:
1091: FND_MSG_PUB.Count_And_Get(
1092: p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => x_msg_data );
1095:

Line 1115: FND_MSG_PUB.Count_And_Get(

1111:
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114:
1115: FND_MSG_PUB.Count_And_Get(
1116: p_encoded => FND_API.G_FALSE,
1117: p_count => x_msg_count,
1118: p_data => x_msg_data );
1119:

Line 1141: FND_MSG_PUB.ADD;

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,
1145: p_count => x_msg_count,

Line 1143: FND_MSG_PUB.Count_And_Get(

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,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data );
1147:

Line 1257: FND_MSG_PUB.initialize;

1253: END IF;
1254:
1255: --Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean(p_init_msg_list) THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: --Initialize API return status to success.
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1342: FND_MSG_PUB.Count_And_Get(

1338:
1339: END IF;
1340:
1341: --Standard call to get message count and if count is 1, get message info.
1342: FND_MSG_PUB.Count_And_Get(
1343: p_encoded => FND_API.G_FALSE,
1344: p_count => x_msg_count,
1345: p_data => x_msg_data );
1346:

Line 1367: FND_MSG_PUB.Count_And_Get(

1363: EXCEPTION
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366:
1367: FND_MSG_PUB.Count_And_Get(
1368: p_encoded => FND_API.G_FALSE,
1369: p_count => x_msg_count,
1370: p_data => x_msg_data );
1371:

Line 1391: FND_MSG_PUB.Count_And_Get(

1387:
1388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390:
1391: FND_MSG_PUB.Count_And_Get(
1392: p_encoded => FND_API.G_FALSE,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:

Line 1417: FND_MSG_PUB.ADD;

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,
1421: p_count => x_msg_count,

Line 1419: FND_MSG_PUB.Count_And_Get(

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,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data );
1423: