DBA Data[Home] [Help]

APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_RELATIONSHIPS_PKG

Line 713: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',

709: p_relationship_rec.relationship_id := l_relationship_id;
710:
711: -- Debug info.
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (+)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;
717:

Line 719: HZ_RELATIONSHIPS_PKG.Insert_Row (

715: p_msg_level=>fnd_log.level_procedure);
716: END IF;
717:
718: -- Call table-handler to create the forward record.
719: HZ_RELATIONSHIPS_PKG.Insert_Row (
720: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
721: X_SUBJECT_ID => p_relationship_rec.subject_id,
722: X_SUBJECT_TYPE => p_relationship_rec.subject_type,
723: X_SUBJECT_TABLE_NAME => p_relationship_rec.subject_table_name,

Line 797: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||

793: );
794:
795: -- Debug info.
796: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
797: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-1 (-) ' ||
798: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
799: p_prefix=>l_debug_prefix,
800: p_msg_level=>fnd_log.level_procedure);
801: END IF;

Line 805: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',

801: END IF;
802:
803: -- Debug info.
804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (+) ',
806: p_prefix=>l_debug_prefix,
807: p_msg_level=>fnd_log.level_procedure);
808: END IF;
809:

Line 822: HZ_RELATIONSHIPS_PKG.Insert_Row (

818:
819: -- Call table-handler again to create the backward record.
820: -- This is done because for every relationship we want to
821: -- create both forward and backward relationship.
822: HZ_RELATIONSHIPS_PKG.Insert_Row (
823: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
824: X_SUBJECT_ID => p_relationship_rec.object_id,
825: X_SUBJECT_TYPE => p_relationship_rec.object_type,
826: X_SUBJECT_TABLE_NAME => p_relationship_rec.object_table_name,

Line 900: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||

896: );
897:
898: -- Debug info.
899: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Insert_Row-2 (-) ' ||
901: 'x_relationship_id = ' || p_relationship_rec.relationship_id,
902: p_prefix=>l_debug_prefix,
903: p_msg_level=>fnd_log.level_procedure);
904: END IF;

Line 1677: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',

1673: END IF;
1674:
1675: -- Debug info.
1676: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1677: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1678: p_prefix=>l_debug_prefix,
1679: p_msg_level=>fnd_log.level_procedure);
1680: END IF;
1681:

Line 1691: HZ_RELATIONSHIPS_PKG.Update_Row (

1687: END IF;
1688:
1689:
1690: --Call to table-handler.
1691: HZ_RELATIONSHIPS_PKG.Update_Row (
1692: X_Rowid => l_rowid,
1693: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1694: -- Bug 4873016 : pass NULL for non updateable columns
1695: /*

Line 1783: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',

1779: );
1780:
1781: -- Debug info.
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;
1787:

Line 1801: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',

1797: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1798:
1799: -- Debug info.
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1802: p_prefix=>l_debug_prefix,
1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:

Line 1807: HZ_RELATIONSHIPS_PKG.Update_Row (

1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:
1806: -- update the reciprocal record
1807: HZ_RELATIONSHIPS_PKG.Update_Row (
1808: X_Rowid => l_rowid,
1809: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1810: X_SUBJECT_ID => NULL,
1811: X_SUBJECT_TYPE => NULL,

Line 1886: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',

1882: );
1883:
1884: -- Debug info.
1885: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1886: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1887: p_prefix=>l_debug_prefix,
1888: p_msg_level=>fnd_log.level_procedure);
1889: END IF;
1890:

Line 3561: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',

3557: END IF;
3558:
3559: -- Debug info.
3560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3561: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3562: p_prefix =>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_statement);
3564: END IF;
3565:

Line 3566: HZ_RELATIONSHIPS_PKG.Select_Row (

3562: p_prefix =>l_debug_prefix,
3563: p_msg_level=>fnd_log.level_statement);
3564: END IF;
3565:
3566: HZ_RELATIONSHIPS_PKG.Select_Row (
3567: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
3568: X_DIRECTIONAL_FLAG => l_directional_flag,
3569: X_SUBJECT_ID => x_rel_rec.subject_id,
3570: X_SUBJECT_TYPE => x_rel_rec.subject_type,