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 13728: -- subject_table_name has foreign key fnd_objects.obj_name

13724: END IF;
13725:
13726: END IF;
13727:
13728: -- subject_table_name has foreign key fnd_objects.obj_name
13729: -- do not need to check during update because subject_table_name is
13730: -- non-updateable.
13731: IF p_create_update_flag = 'C'
13732: AND p_relationship_rec.subject_table_name IS NOT NULL

Line 13738: FROM fnd_objects fo

13734: THEN
13735: BEGIN
13736: SELECT 'Y'
13737: INTO l_dummy
13738: FROM fnd_objects fo
13739: WHERE fo.obj_name = p_relationship_rec.subject_table_name;
13740: EXCEPTION
13741: WHEN NO_DATA_FOUND THEN
13742: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13741: WHEN NO_DATA_FOUND THEN
13742: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13743: fnd_message.set_token('FK', 'subject_table_name');
13744: fnd_message.set_token('COLUMN', 'obj_name');
13745: fnd_message.set_token('TABLE', 'fnd_objects');
13746: fnd_msg_pub.add;
13747: x_return_status := fnd_api.g_ret_sts_error;
13748: END;
13749:

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

13748: END;
13749:
13750: /*IF g_debug THEN
13751: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13752: 'subject_table_name has foreign key fnd_objects.obj_name. ' ||
13753: 'x_return_status = ' || x_return_status,
13754: l_debug_prefix
13755: );
13756: END IF;

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

13756: END IF;
13757: */
13758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13759: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
13760: p_message=>'subject_table_name has foreign key fnd_objects.obj_name. ' ||
13761: 'x_return_status = ' || x_return_status,
13762: p_msg_level=>fnd_log.level_statement);
13763: END IF;
13764:

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

13980: END IF;
13981:
13982: END IF;
13983:
13984: -- object_table_name has foreign key fnd_objects.obj_name
13985: -- do not need to check during update because object_table_name is
13986: -- non-updateable.
13987: IF p_create_update_flag = 'C'
13988: AND p_relationship_rec.object_table_name IS NOT NULL

Line 13994: FROM fnd_objects fo

13990: THEN
13991: BEGIN
13992: SELECT 'Y'
13993: INTO l_dummy
13994: FROM fnd_objects fo
13995: WHERE fo.obj_name = p_relationship_rec.object_table_name;
13996: EXCEPTION
13997: WHEN NO_DATA_FOUND THEN
13998: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

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

13997: WHEN NO_DATA_FOUND THEN
13998: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
13999: fnd_message.set_token('FK', 'object_table_name');
14000: fnd_message.set_token('COLUMN', 'obj_name');
14001: fnd_message.set_token('TABLE', 'fnd_objects');
14002: fnd_msg_pub.add;
14003: x_return_status := fnd_api.g_ret_sts_error;
14004: END;
14005:

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

14004: END;
14005:
14006: /*IF g_debug THEN
14007: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14008: 'object_table_name has foreign key fnd_objects.obj_name. ' ||
14009: 'x_return_status = ' || x_return_status,
14010: l_debug_prefix
14011: );
14012: END IF;

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

14012: END IF;
14013: */
14014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
14015: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
14016: p_message=>'object_table_name has foreign key fnd_objects.obj_name. ' ||
14017: 'x_return_status = ' || x_return_status,
14018: p_msg_level=>fnd_log.level_statement);
14019: END IF;
14020: