DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on FND_OBJECTS

Line 582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */

578: /* Bug 2619099.
579: | fnd_message.set_name('AR', 'HZ_API_INVALID_FK'); |
580: | fnd_message.set_token('FK', 'OWNER_TABLE_NAME'); |
581: | fnd_message.set_token('COLUMN', 'HZ_PARTIES'); |
582: | fnd_message.set_token('TABLE', 'FND_OBJECTS'); */
583: fnd_message.set_name('AR','HZ_EDI_EFT_ORG_PARTIES_ONLY');
584:
585: fnd_msg_pub.add;
586: x_return_status := fnd_api.g_ret_sts_error;

Line 13718: -- subject_table_name has foreign key fnd_objects.obj_name

13714: END IF;
13715:
13716: END IF;
13717:
13718: -- subject_table_name has foreign key fnd_objects.obj_name
13719: -- do not need to check during update because subject_table_name is
13720: -- non-updateable.
13721: IF p_create_update_flag = 'C'
13722: AND p_relationship_rec.subject_table_name IS NOT NULL

Line 13728: FROM fnd_objects fo

13724: THEN
13725: BEGIN
13726: SELECT 'Y'
13727: INTO l_dummy
13728: FROM fnd_objects fo
13729: WHERE fo.obj_name = p_relationship_rec.subject_table_name;
13730: EXCEPTION
13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13731: WHEN NO_DATA_FOUND THEN
13732: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13733: fnd_message.set_token('FK', 'subject_table_name');
13734: fnd_message.set_token('COLUMN', 'obj_name');
13735: fnd_message.set_token('TABLE', 'fnd_objects');
13736: fnd_msg_pub.add;
13737: x_return_status := fnd_api.g_ret_sts_error;
13738: END;
13739:

Line 13742: 'subject_table_name has foreign key fnd_objects.obj_name. ' ||

13738: END;
13739:
13740: /*IF g_debug THEN
13741: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13742: 'subject_table_name has foreign key fnd_objects.obj_name. ' ||
13743: 'x_return_status = ' || x_return_status,
13744: l_debug_prefix
13745: );
13746: END IF;

Line 13750: p_message=>'subject_table_name has foreign key fnd_objects.obj_name. ' ||

13746: END IF;
13747: */
13748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13749: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13750: p_message=>'subject_table_name has foreign key fnd_objects.obj_name. ' ||
13751: 'x_return_status = ' || x_return_status,
13752: p_msg_level=>fnd_log.level_statement);
13753: END IF;
13754:

Line 13974: -- object_table_name has foreign key fnd_objects.obj_name

13970: END IF;
13971:
13972: END IF;
13973:
13974: -- object_table_name has foreign key fnd_objects.obj_name
13975: -- do not need to check during update because object_table_name is
13976: -- non-updateable.
13977: IF p_create_update_flag = 'C'
13978: AND p_relationship_rec.object_table_name IS NOT NULL

Line 13984: FROM fnd_objects fo

13980: THEN
13981: BEGIN
13982: SELECT 'Y'
13983: INTO l_dummy
13984: FROM fnd_objects fo
13985: WHERE fo.obj_name = p_relationship_rec.object_table_name;
13986: EXCEPTION
13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13987: WHEN NO_DATA_FOUND THEN
13988: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13989: fnd_message.set_token('FK', 'object_table_name');
13990: fnd_message.set_token('COLUMN', 'obj_name');
13991: fnd_message.set_token('TABLE', 'fnd_objects');
13992: fnd_msg_pub.add;
13993: x_return_status := fnd_api.g_ret_sts_error;
13994: END;
13995:

Line 13998: 'object_table_name has foreign key fnd_objects.obj_name. ' ||

13994: END;
13995:
13996: /*IF g_debug THEN
13997: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13998: 'object_table_name has foreign key fnd_objects.obj_name. ' ||
13999: 'x_return_status = ' || x_return_status,
14000: l_debug_prefix
14001: );
14002: END IF;

Line 14006: p_message=>'object_table_name has foreign key fnd_objects.obj_name. ' ||

14002: END IF;
14003: */
14004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
14005: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14006: p_message=>'object_table_name has foreign key fnd_objects.obj_name. ' ||
14007: 'x_return_status = ' || x_return_status,
14008: p_msg_level=>fnd_log.level_statement);
14009: END IF;
14010: