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_REGISTRY_VALIDATE_V2PUB dependencies on FND_OBJECT_INSTANCE_SETS

Line 12472: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name

12468: p_msg_level=>fnd_log.level_statement);
12469: END IF;
12470:
12471:
12472: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name
12473: IF p_relationship_type_rec.subject_type IS NOT NULL
12474: AND
12475: p_relationship_type_rec.subject_type <> fnd_api.g_miss_char
12476: THEN

Line 12480: FROM FND_OBJECT_INSTANCE_SETS

12476: THEN
12477: BEGIN
12478: SELECT 'Y'
12479: INTO l_dummy
12480: FROM FND_OBJECT_INSTANCE_SETS
12481: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.subject_type;
12482: EXCEPTION
12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

12483: WHEN NO_DATA_FOUND THEN
12484: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12485: fnd_message.set_token('FK', 'subject_type');
12486: fnd_message.set_token('COLUMN', 'instance_set_name');
12487: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12488: fnd_msg_pub.add;
12489: x_return_status := fnd_api.g_ret_sts_error;
12490: END;
12491:

Line 12494: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

12490: END;
12491:
12492: /*IF g_debug THEN
12493: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12494: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12495: 'x_return_status = ' || x_return_status, l_debug_prefix);
12496: END IF;
12497: */
12498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 12500: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

12496: END IF;
12497: */
12498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
12499: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12500: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12501: 'x_return_status = ' || x_return_status,
12502: p_msg_level=>fnd_log.level_statement);
12503: END IF;
12504:

Line 12555: -- object_type has foreign key fnd_object_instance_sets.instance_set_name

12551: p_msg_level=>fnd_log.level_statement);
12552: END IF;
12553:
12554:
12555: -- object_type has foreign key fnd_object_instance_sets.instance_set_name
12556: IF p_relationship_type_rec.object_type IS NOT NULL
12557: AND
12558: p_relationship_type_rec.object_type <> fnd_api.g_miss_char
12559: THEN

Line 12563: FROM FND_OBJECT_INSTANCE_SETS

12559: THEN
12560: BEGIN
12561: SELECT 'Y'
12562: INTO l_dummy
12563: FROM FND_OBJECT_INSTANCE_SETS
12564: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.object_type;
12565: EXCEPTION
12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

12566: WHEN NO_DATA_FOUND THEN
12567: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12568: fnd_message.set_token('FK', 'object_type');
12569: fnd_message.set_token('COLUMN', 'instance_set_name');
12570: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12571: fnd_msg_pub.add;
12572: x_return_status := fnd_api.g_ret_sts_error;
12573: END;
12574:

Line 12577: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

12573: END;
12574:
12575: /*IF g_debug THEN
12576: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12577: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12578: 'x_return_status = ' || x_return_status, l_debug_prefix);
12579: END IF;
12580: */
12581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 12583: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

12579: END IF;
12580: */
12581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
12582: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12583: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12584: 'x_return_status = ' || x_return_status,
12585: p_msg_level=>fnd_log.level_statement);
12586: END IF;
12587:

Line 13804: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name

13800: p_msg_level=>fnd_log.level_statement);
13801: END IF;
13802: END IF;
13803:
13804: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name
13805: -- do not need to check during update because subject_type is
13806: -- non-updateable.
13807: IF p_create_update_flag = 'C'
13808: AND p_relationship_rec.subject_type IS NOT NULL

Line 13814: FROM fnd_object_instance_sets fois

13810: THEN
13811: BEGIN
13812: SELECT 'Y'
13813: INTO l_dummy
13814: FROM fnd_object_instance_sets fois
13815: WHERE fois.instance_set_name = p_relationship_rec.subject_type;
13816: EXCEPTION
13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13817: WHEN NO_DATA_FOUND THEN
13818: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13819: fnd_message.set_token('FK', 'subject_type');
13820: fnd_message.set_token('COLUMN', 'instance_set_name');
13821: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13822: fnd_msg_pub.add;
13823: x_return_status := fnd_api.g_ret_sts_error;
13824: END;
13825:

Line 13828: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

13824: END;
13825:
13826: /*IF g_debug THEN
13827: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13828: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
13829: 'x_return_status = ' || x_return_status,
13830: l_debug_prefix
13831: );
13832: END IF;

Line 13836: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

13832: END IF;
13833: */
13834: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13835: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13836: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
13837: 'x_return_status = ' || x_return_status,
13838: p_msg_level=>fnd_log.level_statement);
13839: END IF;
13840:

Line 14062: -- object_type has foreign key fnd_object_instance_sets.instance_set_name

14058: END IF;
14059:
14060: END IF;
14061:
14062: -- object_type has foreign key fnd_object_instance_sets.instance_set_name
14063: -- do not need to check during update because object_type is
14064: -- non-updateable.
14065: IF p_create_update_flag = 'C'
14066: AND p_relationship_rec.object_type IS NOT NULL

Line 14072: FROM fnd_object_instance_sets fois

14068: THEN
14069: BEGIN
14070: SELECT 'Y'
14071: INTO l_dummy
14072: FROM fnd_object_instance_sets fois
14073: WHERE fois.instance_set_name = p_relationship_rec.object_type;
14074: EXCEPTION
14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

14075: WHEN NO_DATA_FOUND THEN
14076: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14077: fnd_message.set_token('FK', 'object_type');
14078: fnd_message.set_token('COLUMN', 'instance_set_name');
14079: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14080: fnd_msg_pub.add;
14081: x_return_status := fnd_api.g_ret_sts_error;
14082: END;
14083:

Line 14086: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

14082: END;
14083:
14084: /*IF g_debug THEN
14085: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14086: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
14087: 'x_return_status = ' || x_return_status,
14088: l_debug_prefix
14089: );
14090: END IF;

Line 14094: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||

14090: END IF;
14091: */
14092: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
14093: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14094: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
14095: 'x_return_status = ' || x_return_status,
14096: p_msg_level=>fnd_log.level_statement);
14097: END IF;
14098: