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 12482: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name

12478: p_msg_level=>fnd_log.level_statement);
12479: END IF;
12480:
12481:
12482: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name
12483: IF p_relationship_type_rec.subject_type IS NOT NULL
12484: AND
12485: p_relationship_type_rec.subject_type <> fnd_api.g_miss_char
12486: THEN

Line 12490: FROM FND_OBJECT_INSTANCE_SETS

12486: THEN
12487: BEGIN
12488: SELECT 'Y'
12489: INTO l_dummy
12490: FROM FND_OBJECT_INSTANCE_SETS
12491: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.subject_type;
12492: EXCEPTION
12493: WHEN NO_DATA_FOUND THEN
12494: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

12493: WHEN NO_DATA_FOUND THEN
12494: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12495: fnd_message.set_token('FK', 'subject_type');
12496: fnd_message.set_token('COLUMN', 'instance_set_name');
12497: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12498: fnd_msg_pub.add;
12499: x_return_status := fnd_api.g_ret_sts_error;
12500: END;
12501:

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

12500: END;
12501:
12502: /*IF g_debug THEN
12503: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12504: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12505: 'x_return_status = ' || x_return_status, l_debug_prefix);
12506: END IF;
12507: */
12508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

12506: END IF;
12507: */
12508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
12509: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12510: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12511: 'x_return_status = ' || x_return_status,
12512: p_msg_level=>fnd_log.level_statement);
12513: END IF;
12514:

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

12561: p_msg_level=>fnd_log.level_statement);
12562: END IF;
12563:
12564:
12565: -- object_type has foreign key fnd_object_instance_sets.instance_set_name
12566: IF p_relationship_type_rec.object_type IS NOT NULL
12567: AND
12568: p_relationship_type_rec.object_type <> fnd_api.g_miss_char
12569: THEN

Line 12573: FROM FND_OBJECT_INSTANCE_SETS

12569: THEN
12570: BEGIN
12571: SELECT 'Y'
12572: INTO l_dummy
12573: FROM FND_OBJECT_INSTANCE_SETS
12574: WHERE INSTANCE_SET_NAME = p_relationship_type_rec.object_type;
12575: EXCEPTION
12576: WHEN NO_DATA_FOUND THEN
12577: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

12576: WHEN NO_DATA_FOUND THEN
12577: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
12578: fnd_message.set_token('FK', 'object_type');
12579: fnd_message.set_token('COLUMN', 'instance_set_name');
12580: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
12581: fnd_msg_pub.add;
12582: x_return_status := fnd_api.g_ret_sts_error;
12583: END;
12584:

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

12583: END;
12584:
12585: /*IF g_debug THEN
12586: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12587: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12588: 'x_return_status = ' || x_return_status, l_debug_prefix);
12589: END IF;
12590: */
12591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

12589: END IF;
12590: */
12591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
12592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
12593: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
12594: 'x_return_status = ' || x_return_status,
12595: p_msg_level=>fnd_log.level_statement);
12596: END IF;
12597:

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

13810: p_msg_level=>fnd_log.level_statement);
13811: END IF;
13812: END IF;
13813:
13814: -- subject_type has foreign key fnd_object_instance_sets.instance_set_name
13815: -- do not need to check during update because subject_type is
13816: -- non-updateable.
13817: IF p_create_update_flag = 'C'
13818: AND p_relationship_rec.subject_type IS NOT NULL

Line 13824: FROM fnd_object_instance_sets fois

13820: THEN
13821: BEGIN
13822: SELECT 'Y'
13823: INTO l_dummy
13824: FROM fnd_object_instance_sets fois
13825: WHERE fois.instance_set_name = p_relationship_rec.subject_type;
13826: EXCEPTION
13827: WHEN NO_DATA_FOUND THEN
13828: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13827: WHEN NO_DATA_FOUND THEN
13828: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13829: fnd_message.set_token('FK', 'subject_type');
13830: fnd_message.set_token('COLUMN', 'instance_set_name');
13831: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
13832: fnd_msg_pub.add;
13833: x_return_status := fnd_api.g_ret_sts_error;
13834: END;
13835:

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

13834: END;
13835:
13836: /*IF g_debug THEN
13837: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13838: 'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
13839: 'x_return_status = ' || x_return_status,
13840: l_debug_prefix
13841: );
13842: END IF;

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

13842: END IF;
13843: */
13844: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13845: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13846: p_message=>'subject_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
13847: 'x_return_status = ' || x_return_status,
13848: p_msg_level=>fnd_log.level_statement);
13849: END IF;
13850:

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

14068: END IF;
14069:
14070: END IF;
14071:
14072: -- object_type has foreign key fnd_object_instance_sets.instance_set_name
14073: -- do not need to check during update because object_type is
14074: -- non-updateable.
14075: IF p_create_update_flag = 'C'
14076: AND p_relationship_rec.object_type IS NOT NULL

Line 14082: FROM fnd_object_instance_sets fois

14078: THEN
14079: BEGIN
14080: SELECT 'Y'
14081: INTO l_dummy
14082: FROM fnd_object_instance_sets fois
14083: WHERE fois.instance_set_name = p_relationship_rec.object_type;
14084: EXCEPTION
14085: WHEN NO_DATA_FOUND THEN
14086: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

14085: WHEN NO_DATA_FOUND THEN
14086: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
14087: fnd_message.set_token('FK', 'object_type');
14088: fnd_message.set_token('COLUMN', 'instance_set_name');
14089: fnd_message.set_token('TABLE', 'fnd_object_instance_sets');
14090: fnd_msg_pub.add;
14091: x_return_status := fnd_api.g_ret_sts_error;
14092: END;
14093:

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

14092: END;
14093:
14094: /*IF g_debug THEN
14095: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14096: 'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
14097: 'x_return_status = ' || x_return_status,
14098: l_debug_prefix
14099: );
14100: END IF;

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

14100: END IF;
14101: */
14102: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
14103: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14104: p_message=>'object_type has foreign key fnd_object_instance_sets.instance_set_name. ' ||
14105: 'x_return_status = ' || x_return_status,
14106: p_msg_level=>fnd_log.level_statement);
14107: END IF;
14108: