DBA Data[Home] [Help]

APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_RELATIONSHIPS_PKG

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

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

Line 717: HZ_RELATIONSHIPS_PKG.Insert_Row (

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

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

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

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

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

Line 820: HZ_RELATIONSHIPS_PKG.Insert_Row (

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

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

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

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

1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (+) ',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:

Line 1683: HZ_RELATIONSHIPS_PKG.Update_Row (

1679: END IF;
1680:
1681:
1682: --Call to table-handler.
1683: HZ_RELATIONSHIPS_PKG.Update_Row (
1684: X_Rowid => l_rowid,
1685: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1686: -- Bug 4873016 : pass NULL for non updateable columns
1687: /*

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

1771: );
1772:
1773: -- Debug info.
1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-1 (-) ',
1776: p_prefix=>l_debug_prefix,
1777: p_msg_level=>fnd_log.level_procedure);
1778: END IF;
1779:

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

1789: AND DIRECTIONAL_FLAG = decode(l_directional_flag, 'F', 'B','B', 'F');
1790:
1791: -- Debug info.
1792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1793: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (+) ',
1794: p_prefix=>l_debug_prefix,
1795: p_msg_level=>fnd_log.level_procedure);
1796: END IF;
1797:

Line 1799: HZ_RELATIONSHIPS_PKG.Update_Row (

1795: p_msg_level=>fnd_log.level_procedure);
1796: END IF;
1797:
1798: -- update the reciprocal record
1799: HZ_RELATIONSHIPS_PKG.Update_Row (
1800: X_Rowid => l_rowid,
1801: X_RELATIONSHIP_ID => p_relationship_rec.relationship_id,
1802: X_SUBJECT_ID => NULL,
1803: X_SUBJECT_TYPE => NULL,

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

1874: );
1875:
1876: -- Debug info.
1877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1878: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Update_Row-2 (-) ',
1879: p_prefix=>l_debug_prefix,
1880: p_msg_level=>fnd_log.level_procedure);
1881: END IF;
1882:

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

3532: END IF;
3533:
3534: -- Debug info.
3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'HZ_RELATIONSHIPS_PKG.Select_Row',
3537: p_prefix =>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_statement);
3539: END IF;
3540:

Line 3541: HZ_RELATIONSHIPS_PKG.Select_Row (

3537: p_prefix =>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_statement);
3539: END IF;
3540:
3541: HZ_RELATIONSHIPS_PKG.Select_Row (
3542: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,
3543: X_DIRECTIONAL_FLAG => l_directional_flag,
3544: X_SUBJECT_ID => x_rel_rec.subject_id,
3545: X_SUBJECT_TYPE => x_rel_rec.subject_type,