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_RELATIONSHIP_V2PUB dependencies on FND_LOG

Line 413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

409:
410: BEGIN
411:
412: -- Debug info.
413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug(p_message=>'do_create_rel (+)',
415: p_prefix=>l_debug_prefix,
416: p_msg_level=>fnd_log.level_procedure);
417: END IF;

Line 416: p_msg_level=>fnd_log.level_procedure);

412: -- Debug info.
413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug(p_message=>'do_create_rel (+)',
415: p_prefix=>l_debug_prefix,
416: p_msg_level=>fnd_log.level_procedure);
417: END IF;
418:
419: -- Generate primary key from sequence if not passed in. If this values already exists in
420: -- the database, keep generating till a unique value is found.

Line 468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

464:
465: x_relationship_id := l_relationship_id;
466:
467: -- Debug info.
468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'Obtained relationship_id : '||x_relationship_id,
470: p_prefix =>l_debug_prefix,
471: p_msg_level=>fnd_log.level_statement);
472: END IF;

Line 471: p_msg_level=>fnd_log.level_statement);

467: -- Debug info.
468: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'Obtained relationship_id : '||x_relationship_id,
470: p_prefix =>l_debug_prefix,
471: p_msg_level=>fnd_log.level_statement);
472: END IF;
473:
474:
475: -- validate the relationship record

Line 512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: -- Debug info.
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: hz_utility_v2pub.debug(p_message=>'relationship type record found',
514: p_prefix =>l_debug_prefix,
515: p_msg_level=>fnd_log.level_statement);
516: END IF;

Line 515: p_msg_level=>fnd_log.level_statement);

511: -- Debug info.
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: hz_utility_v2pub.debug(p_message=>'relationship type record found',
514: p_prefix =>l_debug_prefix,
515: p_msg_level=>fnd_log.level_statement);
516: END IF;
517:
518:
519: -- decide who is parent and who is child in this relationship.

Line 641: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

637: p_relationship_rec.object_table_name = 'HZ_PARTIES'
638: THEN
639:
640: -- Debug info.
641: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'creating relationship party',
643: p_prefix =>l_debug_prefix,
644: p_msg_level=>fnd_log.level_statement);
645: END IF;

Line 644: p_msg_level=>fnd_log.level_statement);

640: -- Debug info.
641: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'creating relationship party',
643: p_prefix =>l_debug_prefix,
644: p_msg_level=>fnd_log.level_statement);
645: END IF;
646:
647:
648: x_created_party := 'Y';

Line 695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

691: p_relationship_rec.object_table_name = 'HZ_PARTIES'
692: THEN
693:
694: -- Debug info.
695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;

Line 698: p_msg_level=>fnd_log.level_statement);

694: -- Debug info.
695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;
700:
701:
702: do_update_party_flags(

Line 710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

706:
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;

Line 713: p_msg_level=>fnd_log.level_procedure);

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:
716: -- Call table-handler to create the forward record.
717: HZ_RELATIONSHIPS_PKG.Insert_Row (

Line 794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

790: X_ACTUAL_CONTENT_SOURCE => p_relationship_rec.actual_content_source
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);

Line 798: p_msg_level=>fnd_log.level_procedure);

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;
800:
801: -- Debug info.
802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

798: p_msg_level=>fnd_log.level_procedure);
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;

Line 805: p_msg_level=>fnd_log.level_procedure);

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:
808: -- determine the direction_code for the backward record
809: IF r_rel_type.direction_code = 'P' THEN

Line 897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

893: X_ACTUAL_CONTENT_SOURCE => p_relationship_rec.actual_content_source
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);

Line 901: p_msg_level=>fnd_log.level_procedure);

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;
903:
904: -- maintain hierarchy of relationships
905: -- check if the relationship type is hierarchical

Line 1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1174: END LOOP;
1175: END IF;
1176:
1177: -- Debug info.
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'do_create_rel (-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;

Line 1181: p_msg_level=>fnd_log.level_procedure);

1177: -- Debug info.
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'do_create_rel (-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;
1183:
1184: END do_create_rel;
1185:

Line 1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1285:
1286: BEGIN
1287:
1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'do_update_rel (+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;

Line 1292: p_msg_level=>fnd_log.level_procedure);

1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'do_update_rel (+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:
1295: /* Bug 4873016 : Select the record from hz_relationships based on
1296: * the values passed by the user to this API. If there is no record

Line 1446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1442: END;
1443: END;
1444:
1445: -- Debug info.
1446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'Done with locking',
1448: p_prefix =>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_statement);
1450: END IF;

Line 1449: p_msg_level=>fnd_log.level_statement);

1445: -- Debug info.
1446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'Done with locking',
1448: p_prefix =>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_statement);
1450: END IF;
1451:
1452: -- get the relationship type for its attributes
1453: SELECT HIERARCHICAL_FLAG,

Line 1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1653: l_object_table_name = 'HZ_PARTIES'
1654: THEN
1655:
1656: -- Debug info.
1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1659: p_prefix =>l_debug_prefix,
1660: p_msg_level=>fnd_log.level_statement);
1661: END IF;

Line 1660: p_msg_level=>fnd_log.level_statement);

1656: -- Debug info.
1657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug(p_message=>'denormalizing to hz_parties',
1659: p_prefix =>l_debug_prefix,
1660: p_msg_level=>fnd_log.level_statement);
1661: END IF;
1662:
1663: do_update_party_flags(l_rel_rec,
1664: l_rel_rec.subject_id);

Line 1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1664: l_rel_rec.subject_id);
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;

Line 1671: p_msg_level=>fnd_log.level_procedure);

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:
1674: -- Bug 4693719 : pass NULL if the secure data is not updated
1675: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

Line 1774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1770: X_ACTUAL_CONTENT_SOURCE => l_acs
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;

Line 1777: p_msg_level=>fnd_log.level_procedure);

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:
1780: -- get the reciprocal record information
1781: SELECT ROWID

Line 1792: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1788: */
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;

Line 1795: p_msg_level=>fnd_log.level_procedure);

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:
1798: -- update the reciprocal record
1799: HZ_RELATIONSHIPS_PKG.Update_Row (

Line 1877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1873: X_ACTUAL_CONTENT_SOURCE => p_relationship_rec.actual_content_source
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;

Line 1880: p_msg_level=>fnd_log.level_procedure);

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:
1883: -- Check if party exists for party_relationship. If yes, update party.
1884: -- build the record for creation of relationship party record

Line 1910: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1906: THEN
1907: IF l_party_id IS NOT NULL THEN
1908:
1909: -- Debug info.
1910: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1911: hz_utility_v2pub.debug(p_message=>'updating party record',
1912: p_prefix =>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_statement);
1914: END IF;

Line 1913: p_msg_level=>fnd_log.level_statement);

1909: -- Debug info.
1910: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1911: hz_utility_v2pub.debug(p_message=>'updating party record',
1912: p_prefix =>l_debug_prefix,
1913: p_msg_level=>fnd_log.level_statement);
1914: END IF;
1915:
1916: IF p_party_object_version_number IS NULL THEN
1917: l_party_object_version_number := 1;

Line 2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2054: END IF;
2055: END IF;
2056:
2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_update_rel (-)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;

Line 2061: p_msg_level=>fnd_log.level_procedure);

2057: -- Debug info.
2058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug(p_message=>'do_update_rel (-)',
2060: p_prefix=>l_debug_prefix,
2061: p_msg_level=>fnd_log.level_procedure);
2062: END IF;
2063:
2064: END do_update_rel;
2065:

Line 2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2238:
2239: BEGIN
2240:
2241: -- Debug info.
2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2243: hz_utility_v2pub.debug(p_message=>'do_create_party (+)',
2244: p_prefix=>l_debug_prefix,
2245: p_msg_level=>fnd_log.level_procedure);
2246: END IF;

Line 2245: p_msg_level=>fnd_log.level_procedure);

2241: -- Debug info.
2242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2243: hz_utility_v2pub.debug(p_message=>'do_create_party (+)',
2244: p_prefix=>l_debug_prefix,
2245: p_msg_level=>fnd_log.level_procedure);
2246: END IF;
2247:
2248: l_party_id := l_party_rec.party_id;
2249: l_party_number := l_party_rec.party_number;

Line 2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2366: l_party_rec.party_id := NULL;
2367: END IF;
2368:
2369: -- Debug info.
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;

Line 2373: p_msg_level=>fnd_log.level_procedure);

2369: -- Debug info.
2370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2371: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (+)',
2372: p_prefix=>l_debug_prefix,
2373: p_msg_level=>fnd_log.level_procedure);
2374: END IF;
2375:
2376: HZ_PARTIES_PKG.Insert_Row (
2377: X_PARTY_ID => l_party_rec.party_id,

Line 2467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2463: x_party_id := l_party_rec.party_id;
2464: x_party_number := l_party_rec.party_number;
2465:
2466: -- Debug info.
2467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2469: 'x_party_id = ' || x_party_id,
2470: p_prefix=>l_debug_prefix,
2471: p_msg_level=>fnd_log.level_procedure);

Line 2471: p_msg_level=>fnd_log.level_procedure);

2467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2468: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Insert_Row (-) ' ||
2469: 'x_party_id = ' || x_party_id,
2470: p_prefix=>l_debug_prefix,
2471: p_msg_level=>fnd_log.level_procedure);
2472: END IF;
2473:
2474: -- update the party_name
2475: l_party_name := SUBSTRB(l_subject_name || '-' ||

Line 2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2478:
2479: UPDATE HZ_PARTIES SET PARTY_NAME = l_party_name WHERE PARTY_ID = x_party_id;
2480:
2481: -- Debug info.
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',
2484: p_prefix=>l_debug_prefix,
2485: p_msg_level=>fnd_log.level_procedure);
2486: END IF;

Line 2485: p_msg_level=>fnd_log.level_procedure);

2481: -- Debug info.
2482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2483: hz_utility_v2pub.debug(p_message=>'do_create_party (-)',
2484: p_prefix=>l_debug_prefix,
2485: p_msg_level=>fnd_log.level_procedure);
2486: END IF;
2487:
2488: END do_create_party;
2489:

Line 2551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2547:
2548: BEGIN
2549:
2550: -- Debug info.
2551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2552: hz_utility_v2pub.debug(p_message=>'do_update_party (+)',
2553: p_prefix=>l_debug_prefix,
2554: p_msg_level=>fnd_log.level_procedure);
2555: END IF;

Line 2554: p_msg_level=>fnd_log.level_procedure);

2550: -- Debug info.
2551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2552: hz_utility_v2pub.debug(p_message=>'do_update_party (+)',
2553: p_prefix=>l_debug_prefix,
2554: p_msg_level=>fnd_log.level_procedure);
2555: END IF;
2556:
2557: -- check whether record has been updated by another user.
2558: BEGIN

Line 2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2608: RAISE FND_API.G_EXC_ERROR;
2609: END IF;
2610:
2611: -- Debug info.
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;

Line 2615: p_msg_level=>fnd_log.level_procedure);

2611: -- Debug info.
2612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2613: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (+) ',
2614: p_prefix=>l_debug_prefix,
2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617:
2618: -- call table handler to update the record
2619: HZ_PARTIES_PKG.Update_Row (

Line 2709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2705: X_APPLICATION_ID => p_relationship_rec.application_id
2706: );
2707:
2708: -- Debug info.
2709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2711: p_prefix=>l_debug_prefix,
2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;

Line 2712: p_msg_level=>fnd_log.level_procedure);

2708: -- Debug info.
2709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug(p_message=>'HZ_PARTIES_PKG.Update_Row (-) ',
2711: p_prefix=>l_debug_prefix,
2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;
2714:
2715: -- Debug info.
2716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2712: p_msg_level=>fnd_log.level_procedure);
2713: END IF;
2714:
2715: -- Debug info.
2716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2717: hz_utility_v2pub.debug(p_message=>'do_update_party (-)',
2718: p_prefix=>l_debug_prefix,
2719: p_msg_level=>fnd_log.level_procedure);
2720: END IF;

Line 2719: p_msg_level=>fnd_log.level_procedure);

2715: -- Debug info.
2716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2717: hz_utility_v2pub.debug(p_message=>'do_update_party (-)',
2718: p_prefix=>l_debug_prefix,
2719: p_msg_level=>fnd_log.level_procedure);
2720: END IF;
2721:
2722: END do_update_party;
2723:

Line 2935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2931: -- Check if API is called in debug mode. If yes, enable debug.
2932: --enable_debug;
2933:
2934: -- Debug info.
2935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2936: hz_utility_v2pub.debug(p_message=>'create_relationship (+)',
2937: p_prefix=>l_debug_prefix,
2938: p_msg_level=>fnd_log.level_procedure);
2939: END IF;

Line 2938: p_msg_level=>fnd_log.level_procedure);

2934: -- Debug info.
2935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2936: hz_utility_v2pub.debug(p_message=>'create_relationship (+)',
2937: p_prefix=>l_debug_prefix,
2938: p_msg_level=>fnd_log.level_procedure);
2939: END IF;
2940:
2941: -- Initialize message list if p_init_msg_list is set to TRUE.
2942: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3065: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3061: p_count => x_msg_count,
3062: p_data => x_msg_data);
3063:
3064: -- Debug info.
3065: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3066: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3067: p_msg_data=>x_msg_data,
3068: p_msg_type=>'WARNING',
3069: p_msg_level=>fnd_log.level_exception);

Line 3069: p_msg_level=>fnd_log.level_exception);

3065: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3066: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3067: p_msg_data=>x_msg_data,
3068: p_msg_type=>'WARNING',
3069: p_msg_level=>fnd_log.level_exception);
3070: END IF;
3071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3073: p_prefix=>l_debug_prefix,

Line 3071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3067: p_msg_data=>x_msg_data,
3068: p_msg_type=>'WARNING',
3069: p_msg_level=>fnd_log.level_exception);
3070: END IF;
3071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3073: p_prefix=>l_debug_prefix,
3074: p_msg_level=>fnd_log.level_procedure);
3075: END IF;

Line 3074: p_msg_level=>fnd_log.level_procedure);

3070: END IF;
3071: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3073: p_prefix=>l_debug_prefix,
3074: p_msg_level=>fnd_log.level_procedure);
3075: END IF;
3076:
3077: -- Check if API is called in debug mode. If yes, disable debug.
3078: --disable_debug;

Line 3090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3086: p_count => x_msg_count,
3087: p_data => x_msg_data);
3088:
3089: -- Debug info.
3090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3092: p_msg_data=>x_msg_data,
3093: p_msg_type=>'ERROR',
3094: p_msg_level=>fnd_log.level_error);

Line 3094: p_msg_level=>fnd_log.level_error);

3090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3092: p_msg_data=>x_msg_data,
3093: p_msg_type=>'ERROR',
3094: p_msg_level=>fnd_log.level_error);
3095:
3096: END IF;
3097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3098: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

Line 3097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3093: p_msg_type=>'ERROR',
3094: p_msg_level=>fnd_log.level_error);
3095:
3096: END IF;
3097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3098: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3099: p_prefix=>l_debug_prefix,
3100: p_msg_level=>fnd_log.level_procedure);
3101: END IF;

Line 3100: p_msg_level=>fnd_log.level_procedure);

3096: END IF;
3097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3098: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3099: p_prefix=>l_debug_prefix,
3100: p_msg_level=>fnd_log.level_procedure);
3101: END IF;
3102:
3103: -- Check if API is called in debug mode. If yes, disable debug.
3104: --disable_debug;

Line 3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3111: p_count => x_msg_count,
3112: p_data => x_msg_data);
3113:
3114: -- Debug info.
3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'UNEXPECTED ERROR',
3119: p_msg_level=>fnd_log.level_error);

Line 3119: p_msg_level=>fnd_log.level_error);

3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'UNEXPECTED ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120:
3121: END IF;
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

Line 3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3118: p_msg_type=>'UNEXPECTED ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120:
3121: END IF;
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;

Line 3125: p_msg_level=>fnd_log.level_procedure);

3121: END IF;
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;
3127:
3128: -- Check if API is called in debug mode. If yes, disable debug.
3129: --disable_debug;

Line 3143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3139: p_count => x_msg_count,
3140: p_data => x_msg_data);
3141:
3142: -- Debug info.
3143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3145: p_msg_data=>x_msg_data,
3146: p_msg_type=>'SQL ERROR',
3147: p_msg_level=>fnd_log.level_error);

Line 3147: p_msg_level=>fnd_log.level_error);

3143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3145: p_msg_data=>x_msg_data,
3146: p_msg_type=>'SQL ERROR',
3147: p_msg_level=>fnd_log.level_error);
3148:
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',

Line 3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3146: p_msg_type=>'SQL ERROR',
3147: p_msg_level=>fnd_log.level_error);
3148:
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;

Line 3153: p_msg_level=>fnd_log.level_procedure);

3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'create_relationship (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;
3155:
3156: -- Check if API is called in debug mode. If yes, disable debug.
3157: --disable_debug;

Line 3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3218: -- Check if API is called in debug mode. If yes, enable debug.
3219: --enable_debug;
3220:
3221: -- Debug info.
3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3223: hz_utility_v2pub.debug(p_message=>'update_relationship (+)',
3224: p_prefix=>l_debug_prefix,
3225: p_msg_level=>fnd_log.level_procedure);
3226: END IF;

Line 3225: p_msg_level=>fnd_log.level_procedure);

3221: -- Debug info.
3222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3223: hz_utility_v2pub.debug(p_message=>'update_relationship (+)',
3224: p_prefix=>l_debug_prefix,
3225: p_msg_level=>fnd_log.level_procedure);
3226: END IF;
3227:
3228: -- Initialize message list if p_init_msg_list is set to TRUE.
3229: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3353: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3349: p_count => x_msg_count,
3350: p_data => x_msg_data);
3351:
3352: -- Debug info.
3353: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3355: p_msg_data=>x_msg_data,
3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);

Line 3357: p_msg_level=>fnd_log.level_exception);

3353: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3355: p_msg_data=>x_msg_data,
3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3361: p_prefix=>l_debug_prefix,

Line 3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3355: p_msg_data=>x_msg_data,
3356: p_msg_type=>'WARNING',
3357: p_msg_level=>fnd_log.level_exception);
3358: END IF;
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3361: p_prefix=>l_debug_prefix,
3362: p_msg_level=>fnd_log.level_procedure);
3363: END IF;

Line 3362: p_msg_level=>fnd_log.level_procedure);

3358: END IF;
3359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3360: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3361: p_prefix=>l_debug_prefix,
3362: p_msg_level=>fnd_log.level_procedure);
3363: END IF;
3364:
3365: -- Check if API is called in debug mode. If yes, disable debug.
3366: --disable_debug;

Line 3379: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3375: p_count => x_msg_count,
3376: p_data => x_msg_data);
3377:
3378: -- Debug info.
3379: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3381: p_msg_data=>x_msg_data,
3382: p_msg_type=>'ERROR',
3383: p_msg_level=>fnd_log.level_error);

Line 3383: p_msg_level=>fnd_log.level_error);

3379: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3380: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3381: p_msg_data=>x_msg_data,
3382: p_msg_type=>'ERROR',
3383: p_msg_level=>fnd_log.level_error);
3384:
3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

Line 3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3382: p_msg_type=>'ERROR',
3383: p_msg_level=>fnd_log.level_error);
3384:
3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3388: p_prefix=>l_debug_prefix,
3389: p_msg_level=>fnd_log.level_procedure);
3390: END IF;

Line 3389: p_msg_level=>fnd_log.level_procedure);

3385: END IF;
3386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3387: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3388: p_prefix=>l_debug_prefix,
3389: p_msg_level=>fnd_log.level_procedure);
3390: END IF;
3391:
3392: -- Check if API is called in debug mode. If yes, disable debug.
3393: --disable_debug;

Line 3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3401: p_count => x_msg_count,
3402: p_data => x_msg_data);
3403:
3404: -- Debug info.
3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);

Line 3409: p_msg_level=>fnd_log.level_error);

3405: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3406: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3407: p_msg_data=>x_msg_data,
3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);
3410:
3411: END IF;
3412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

Line 3412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3408: p_msg_type=>'UNEXPECTED ERROR',
3409: p_msg_level=>fnd_log.level_error);
3410:
3411: END IF;
3412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3414: p_prefix=>l_debug_prefix,
3415: p_msg_level=>fnd_log.level_procedure);
3416: END IF;

Line 3415: p_msg_level=>fnd_log.level_procedure);

3411: END IF;
3412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3414: p_prefix=>l_debug_prefix,
3415: p_msg_level=>fnd_log.level_procedure);
3416: END IF;
3417:
3418: -- Check if API is called in debug mode. If yes, disable debug.
3419: --disable_debug;

Line 3434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3430: p_count => x_msg_count,
3431: p_data => x_msg_data);
3432:
3433: -- Debug info.
3434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3436: p_msg_data=>x_msg_data,
3437: p_msg_type=>'SQL ERROR',
3438: p_msg_level=>fnd_log.level_error);

Line 3438: p_msg_level=>fnd_log.level_error);

3434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3436: p_msg_data=>x_msg_data,
3437: p_msg_type=>'SQL ERROR',
3438: p_msg_level=>fnd_log.level_error);
3439:
3440: END IF;
3441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',

Line 3441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3437: p_msg_type=>'SQL ERROR',
3438: p_msg_level=>fnd_log.level_error);
3439:
3440: END IF;
3441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3443: p_prefix=>l_debug_prefix,
3444: p_msg_level=>fnd_log.level_procedure);
3445: END IF;

Line 3444: p_msg_level=>fnd_log.level_procedure);

3440: END IF;
3441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug(p_message=>'update_relationship (-)',
3443: p_prefix=>l_debug_prefix,
3444: p_msg_level=>fnd_log.level_procedure);
3445: END IF;
3446: -- Check if API is called in debug mode. If yes, disable debug.
3447: --disable_debug;
3448:

Line 3500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3496: -- Check if API is called in debug mode. If yes, enable debug.
3497: --enable_debug;
3498:
3499: -- Debug info.
3500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3501: hz_utility_v2pub.debug(p_message=>'get_relationship_rec (+)',
3502: p_prefix=>l_debug_prefix,
3503: p_msg_level=>fnd_log.level_procedure);
3504: END IF;

Line 3503: p_msg_level=>fnd_log.level_procedure);

3499: -- Debug info.
3500: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3501: hz_utility_v2pub.debug(p_message=>'get_relationship_rec (+)',
3502: p_prefix=>l_debug_prefix,
3503: p_msg_level=>fnd_log.level_procedure);
3504: END IF;
3505:
3506:
3507: --Initialize message list if p_init_msg_list is set to TRUE.

Line 3535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3531: l_directional_flag := NVL(p_directional_flag, 'F');
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;

Line 3538: p_msg_level=>fnd_log.level_statement);

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:
3541: HZ_RELATIONSHIPS_PKG.Select_Row (
3542: X_RELATIONSHIP_ID => x_rel_rec.relationship_id,

Line 3617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3613: X_ACTUAL_CONTENT_SOURCE => x_rel_rec.actual_content_source
3614: );
3615:
3616: -- Debug info.
3617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3618: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_V2PUB.get_party_rec',
3619: p_prefix =>l_debug_prefix,
3620: p_msg_level=>fnd_log.level_statement);
3621: END IF;

Line 3620: p_msg_level=>fnd_log.level_statement);

3616: -- Debug info.
3617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3618: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_V2PUB.get_party_rec',
3619: p_prefix =>l_debug_prefix,
3620: p_msg_level=>fnd_log.level_statement);
3621: END IF;
3622:
3623: IF l_party_id IS NOT NULL
3624: AND

Line 3649: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

3645: p_count => x_msg_count,
3646: p_data => x_msg_data );
3647:
3648: -- Debug info.
3649: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3650: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3651: p_msg_data=>x_msg_data,
3652: p_msg_type=>'WARNING',
3653: p_msg_level=>fnd_log.level_exception);

Line 3653: p_msg_level=>fnd_log.level_exception);

3649: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3650: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3651: p_msg_data=>x_msg_data,
3652: p_msg_type=>'WARNING',
3653: p_msg_level=>fnd_log.level_exception);
3654: END IF;
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3656: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',
3657: p_prefix=>l_debug_prefix,

Line 3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3651: p_msg_data=>x_msg_data,
3652: p_msg_type=>'WARNING',
3653: p_msg_level=>fnd_log.level_exception);
3654: END IF;
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3656: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',
3657: p_prefix=>l_debug_prefix,
3658: p_msg_level=>fnd_log.level_procedure);
3659: END IF;

Line 3658: p_msg_level=>fnd_log.level_procedure);

3654: END IF;
3655: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3656: hz_utility_v2pub.debug(p_message=>'get_relationhsip_rec (-)',
3657: p_prefix=>l_debug_prefix,
3658: p_msg_level=>fnd_log.level_procedure);
3659: END IF;
3660:
3661: -- Check if API is called in debug mode. If yes, disable debug.
3662: --disable_debug;

Line 3674: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3670: p_count => x_msg_count,
3671: p_data => x_msg_data );
3672:
3673: -- Debug info.
3674: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3675: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3676: p_msg_data=>x_msg_data,
3677: p_msg_type=>'ERROR',
3678: p_msg_level=>fnd_log.level_error);

Line 3678: p_msg_level=>fnd_log.level_error);

3674: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3675: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3676: p_msg_data=>x_msg_data,
3677: p_msg_type=>'ERROR',
3678: p_msg_level=>fnd_log.level_error);
3679:
3680: END IF;
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',

Line 3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3677: p_msg_type=>'ERROR',
3678: p_msg_level=>fnd_log.level_error);
3679:
3680: END IF;
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3683: p_prefix=>l_debug_prefix,
3684: p_msg_level=>fnd_log.level_procedure);
3685: END IF;

Line 3684: p_msg_level=>fnd_log.level_procedure);

3680: END IF;
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3683: p_prefix=>l_debug_prefix,
3684: p_msg_level=>fnd_log.level_procedure);
3685: END IF;
3686:
3687: -- Check if API is called in debug mode. If yes, disable debug.
3688: --disable_debug;

Line 3699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3695: p_count => x_msg_count,
3696: p_data => x_msg_data );
3697:
3698: -- Debug info.
3699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3701: p_msg_data=>x_msg_data,
3702: p_msg_type=>'UNEXPECTED ERROR',
3703: p_msg_level=>fnd_log.level_error);

Line 3703: p_msg_level=>fnd_log.level_error);

3699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3701: p_msg_data=>x_msg_data,
3702: p_msg_type=>'UNEXPECTED ERROR',
3703: p_msg_level=>fnd_log.level_error);
3704:
3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',

Line 3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3702: p_msg_type=>'UNEXPECTED ERROR',
3703: p_msg_level=>fnd_log.level_error);
3704:
3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3708: p_prefix=>l_debug_prefix,
3709: p_msg_level=>fnd_log.level_procedure);
3710: END IF;

Line 3709: p_msg_level=>fnd_log.level_procedure);

3705: END IF;
3706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)',
3708: p_prefix=>l_debug_prefix,
3709: p_msg_level=>fnd_log.level_procedure);
3710: END IF;
3711:
3712: -- Check if API is called in debug mode. If yes, disable debug.
3713: --disable_debug;

Line 3728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

3724: p_count => x_msg_count,
3725: p_data => x_msg_data );
3726:
3727: -- Debug info.
3728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3730: p_msg_data=>x_msg_data,
3731: p_msg_type=>'SQL ERROR',
3732: p_msg_level=>fnd_log.level_error);

Line 3732: p_msg_level=>fnd_log.level_error);

3728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3730: p_msg_data=>x_msg_data,
3731: p_msg_type=>'SQL ERROR',
3732: p_msg_level=>fnd_log.level_error);
3733:
3734: END IF;
3735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,

Line 3735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3731: p_msg_type=>'SQL ERROR',
3732: p_msg_level=>fnd_log.level_error);
3733:
3734: END IF;
3735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,
3737: p_prefix=>l_debug_prefix,
3738: p_msg_level=>fnd_log.level_procedure);
3739: END IF;

Line 3738: p_msg_level=>fnd_log.level_procedure);

3734: END IF;
3735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug(p_message=>'get_relationsip_rec (-)' ,
3737: p_prefix=>l_debug_prefix,
3738: p_msg_level=>fnd_log.level_procedure);
3739: END IF;
3740:
3741:
3742: -- Check if API is called in debug mode. If yes, disable debug.