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_CUST_ACCOUNT_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 72: * HZ_UTILITY_V2PUB.enable_debug

68: * DESCRIPTION
69: * Turn on debug mode.
70: *
71: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
72: * HZ_UTILITY_V2PUB.enable_debug
73: *
74: * MODIFICATION HISTORY
75: *
76: * 07-23-2001 Jianying Huang o Created.

Line 90: HZ_UTILITY_V2PUB.enable_debug;

86: IF G_DEBUG_COUNT = 1 THEN
87: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
88: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
89: THEN
90: HZ_UTILITY_V2PUB.enable_debug;
91: G_DEBUG := TRUE;
92: END IF;
93: END IF;
94:

Line 106: * HZ_UTILITY_V2PUB.disable_debug

102: * DESCRIPTION
103: * Turn off debug mode.
104: *
105: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
106: * HZ_UTILITY_V2PUB.disable_debug
107: *
108: * MODIFICATION HISTORY
109: *
110: * 07-23-2001 Jianying Huang o Created.

Line 122: HZ_UTILITY_V2PUB.disable_debug;

118: IF G_DEBUG THEN
119: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
120:
121: IF G_DEBUG_COUNT = 0 THEN
122: HZ_UTILITY_V2PUB.disable_debug;
123: G_DEBUG := FALSE;
124: END IF;
125: END IF;
126:

Line 242: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (+)',

238:
239: -- Debug info.
240:
241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
242: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (+)',
243: p_prefix=>l_debug_prefix,
244: p_msg_level=>fnd_log.level_procedure);
245: END IF;
246:

Line 394: hz_utility_v2pub.debug(p_message=>'We need to create party. ',

390:
391: -- Debug info.
392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
393: IF l_create_party THEN
394: hz_utility_v2pub.debug(p_message=>'We need to create party. ',
395: p_prefix =>l_debug_prefix,
396: p_msg_level=>fnd_log.level_statement);
397: ELSE
398: hz_utility_v2pub.debug(p_message=>'We donot need to create party. ',

Line 398: hz_utility_v2pub.debug(p_message=>'We donot need to create party. ',

394: hz_utility_v2pub.debug(p_message=>'We need to create party. ',
395: p_prefix =>l_debug_prefix,
396: p_msg_level=>fnd_log.level_statement);
397: ELSE
398: hz_utility_v2pub.debug(p_message=>'We donot need to create party. ',
399: p_prefix =>l_debug_prefix,
400: p_msg_level=>fnd_log.level_statement);
401:
402: END IF;

Line 454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',

450:
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (+) ',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:

Line 567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||

563: );
564:
565: -- Debug info.
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
568: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
569: 'x_account_number = ' || p_cust_account_rec.account_number,
570: p_prefix=>l_debug_prefix,
571: p_msg_level=>fnd_log.level_procedure);

Line 683: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',

679: x_profile_id := l_profile_id;
680:
681: -- Debug info.
682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
683: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
684: p_prefix=>l_debug_prefix,
685: p_msg_level=>fnd_log.level_procedure);
686: END IF;
687:

Line 759: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',

755: BEGIN
756:
757: -- Debug info.
758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
759: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
760: p_prefix=>l_debug_prefix,
761: p_msg_level=>fnd_log.level_procedure);
762: END IF;
763:

Line 821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',

817: end if;
818:
819: -- Debug info.
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825:

Line 935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',

931: );
932:
933: -- Debug info.
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;
939:

Line 991: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',

987: END IF;
988:
989: -- Debug info.
990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
991: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
992: p_prefix=>l_debug_prefix,
993: p_msg_level=>fnd_log.level_procedure);
994: END IF;
995:

Line 1050: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',

1046: BEGIN
1047:
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1054:

Line 1080: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',

1076: END IF;
1077:
1078: -- Debug info.
1079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1080: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1081: p_prefix=>l_debug_prefix,
1082: p_msg_level=>fnd_log.level_procedure);
1083: END IF;
1084:

Line 1120: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',

1116: );
1117:
1118: -- Debug info.
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:

Line 1139: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',

1135: BEGIN
1136:
1137: -- Debug info.
1138: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1140: p_prefix =>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_statement);
1142: END IF;
1143:

Line 1189: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',

1185: END IF;
1186:
1187: -- Debug info.
1188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1189: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1190: p_prefix=>l_debug_prefix,
1191: p_msg_level=>fnd_log.level_procedure);
1192: END IF;
1193:

Line 1255: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',

1251: BEGIN
1252:
1253: -- Debug info.
1254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1255: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1256: p_prefix=>l_debug_prefix,
1257: p_msg_level=>fnd_log.level_procedure);
1258: END IF;
1259:

Line 1412: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',

1408: END IF;
1409:
1410: -- Debug info.
1411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1413: p_prefix=>l_debug_prefix,
1414: p_msg_level=>fnd_log.level_procedure);
1415: END IF;
1416:

Line 1451: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',

1447: );
1448:
1449: -- Debug info.
1450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1451: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1452: p_prefix=>l_debug_prefix,
1453: p_msg_level=>fnd_log.level_procedure);
1454: END IF;
1455:

Line 1461: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',

1457: -- same logic in insert mode during update.
1458:
1459: -- Debug info.
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;
1465:

Line 1551: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',

1547: --enable_debug;
1548:
1549: -- Debug info.
1550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1551: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1552: p_prefix=>l_debug_prefix,
1553: p_msg_level=>fnd_log.level_procedure);
1554: END IF;
1555:

Line 1594: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1590: x_return_status );
1591:
1592:
1593: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1594: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1595: -- Invoke business event system.
1596: HZ_BUSINESS_EVENT_V2PVT.create_cust_account_event (
1597: l_cust_account_rec,
1598: l_person_rec,

Line 1603: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1599: l_customer_profile_rec,
1600: p_create_profile_amt );
1601: END IF;
1602:
1603: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1604: -- populate function for integration service
1605: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1606: p_operation => 'I',
1607: p_cust_account_id => x_cust_account_id );

Line 1622: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1618: p_data => x_msg_data );
1619:
1620: -- Debug info.
1621: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1622: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1623: p_msg_data=>x_msg_data,
1624: p_msg_type=>'WARNING',
1625: p_msg_level=>fnd_log.level_exception);
1626: END IF;

Line 1628: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

1624: p_msg_type=>'WARNING',
1625: p_msg_level=>fnd_log.level_exception);
1626: END IF;
1627: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1628: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1629: p_prefix=>l_debug_prefix,
1630: p_msg_level=>fnd_log.level_procedure);
1631: END IF;
1632:

Line 1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1644: p_data => x_msg_data );
1645:
1646: -- Debug info.
1647: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1649: p_msg_data=>x_msg_data,
1650: p_msg_type=>'ERROR',
1651: p_msg_level=>fnd_log.level_error);
1652:

Line 1655: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

1651: p_msg_level=>fnd_log.level_error);
1652:
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1659:

Line 1674: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1670: p_data => x_msg_data );
1671:
1672: -- Debug info.
1673: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1675: p_msg_data=>x_msg_data,
1676: p_msg_type=>'UNEXPECTED ERROR',
1677: p_msg_level=>fnd_log.level_error);
1678:

Line 1681: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

1677: p_msg_level=>fnd_log.level_error);
1678:
1679: END IF;
1680: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1681: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1682: p_prefix=>l_debug_prefix,
1683: p_msg_level=>fnd_log.level_procedure);
1684: END IF;
1685:

Line 1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1700: p_data => x_msg_data );
1701:
1702: -- Debug info.
1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'SQL ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708:

Line 1711: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',

1707: p_msg_level=>fnd_log.level_error);
1708:
1709: END IF;
1710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1712: p_prefix=>l_debug_prefix,
1713: p_msg_level=>fnd_log.level_procedure);
1714: END IF;
1715:

Line 1800: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',

1796: --enable_debug;
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804:

Line 1842: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

1838: x_profile_id,
1839: x_return_status );
1840:
1841: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1842: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1843: -- Invoke business event system.
1844: HZ_BUSINESS_EVENT_V2PVT.create_cust_account_event (
1845: l_cust_account_rec,
1846: l_organization_rec,

Line 1851: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

1847: l_customer_profile_rec,
1848: p_create_profile_amt );
1849: END IF;
1850:
1851: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1852: -- populate function for integration service
1853: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1854: p_operation => 'I',
1855: p_cust_account_id => x_cust_account_id );

Line 1870: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1866: p_data => x_msg_data );
1867:
1868: -- Debug info.
1869: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1871: p_msg_data=>x_msg_data,
1872: p_msg_type=>'WARNING',
1873: p_msg_level=>fnd_log.level_exception);
1874: END IF;

Line 1876: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

1872: p_msg_type=>'WARNING',
1873: p_msg_level=>fnd_log.level_exception);
1874: END IF;
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1877: p_prefix=>l_debug_prefix,
1878: p_msg_level=>fnd_log.level_procedure);
1879: END IF;
1880:

Line 1897: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1893: p_data => x_msg_data );
1894:
1895: -- Debug info.
1896: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1898: p_msg_data=>x_msg_data,
1899: p_msg_type=>'ERROR',
1900: p_msg_level=>fnd_log.level_error);
1901:

Line 1904: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

1900: p_msg_level=>fnd_log.level_error);
1901:
1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1905: p_prefix=>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_procedure);
1907: END IF;
1908:

Line 1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1919: p_data => x_msg_data );
1920:
1921: -- Debug info.
1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);
1927:

Line 1930: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

1926: p_msg_level=>fnd_log.level_error);
1927:
1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1931: p_prefix=>l_debug_prefix,
1932: p_msg_level=>fnd_log.level_procedure);
1933: END IF;
1934:

Line 1954: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1950:
1951: -- Debug info.
1952:
1953: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1955: p_msg_data=>x_msg_data,
1956: p_msg_type=>'SQL ERROR',
1957: p_msg_level=>fnd_log.level_error);
1958:

Line 1961: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',

1957: p_msg_level=>fnd_log.level_error);
1958:
1959: END IF;
1960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1962: p_prefix=>l_debug_prefix,
1963: p_msg_level=>fnd_log.level_procedure);
1964: END IF;
1965:

Line 2027: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',

2023: --enable_debug;
2024:
2025: -- Debug info.
2026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2027: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2028: p_prefix=>l_debug_prefix,
2029: p_msg_level=>fnd_log.level_procedure);
2030: END IF;
2031:

Line 2092: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2088:
2089: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2090: -- Invoke business event system.
2091: l_old_cust_account_rec.orig_system := l_cust_account_rec.orig_system;
2092: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2093: HZ_BUSINESS_EVENT_V2PVT.update_cust_account_event (
2094: l_cust_account_rec , l_old_cust_account_rec);
2095: END IF;
2096:

Line 2097: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

2093: HZ_BUSINESS_EVENT_V2PVT.update_cust_account_event (
2094: l_cust_account_rec , l_old_cust_account_rec);
2095: END IF;
2096:
2097: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2098: -- populate function for integration service
2099: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
2100: p_operation => 'U',
2101: p_cust_account_id => l_cust_account_rec.cust_account_id );

Line 2116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2112: p_data => x_msg_data );
2113:
2114: -- Debug info.
2115: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2117: p_msg_data=>x_msg_data,
2118: p_msg_type=>'WARNING',
2119: p_msg_level=>fnd_log.level_exception);
2120: END IF;

Line 2122: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

2118: p_msg_type=>'WARNING',
2119: p_msg_level=>fnd_log.level_exception);
2120: END IF;
2121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2123: p_prefix=>l_debug_prefix,
2124: p_msg_level=>fnd_log.level_procedure);
2125: END IF;
2126:

Line 2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2138: p_data => x_msg_data );
2139:
2140: -- Debug info.
2141: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'ERROR',
2145: p_msg_level=>fnd_log.level_error);
2146:

Line 2149: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

2145: p_msg_level=>fnd_log.level_error);
2146:
2147: END IF;
2148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2149: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2150: p_prefix=>l_debug_prefix,
2151: p_msg_level=>fnd_log.level_procedure);
2152: END IF;
2153:

Line 2168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2164: p_data => x_msg_data );
2165:
2166: -- Debug info.
2167: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2169: p_msg_data=>x_msg_data,
2170: p_msg_type=>'UNEXPECTED ERROR',
2171: p_msg_level=>fnd_log.level_error);
2172:

Line 2175: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

2171: p_msg_level=>fnd_log.level_error);
2172:
2173: END IF;
2174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2175: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2176: p_prefix=>l_debug_prefix,
2177: p_msg_level=>fnd_log.level_procedure);
2178: END IF;
2179:

Line 2198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2194: p_data => x_msg_data );
2195:
2196: -- Debug info.
2197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2199: p_msg_data=>x_msg_data,
2200: p_msg_type=>'SQL ERROR',
2201: p_msg_level=>fnd_log.level_error);
2202:

Line 2205: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',

2201: p_msg_level=>fnd_log.level_error);
2202:
2203: END IF;
2204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2206: p_prefix=>l_debug_prefix,
2207: p_msg_level=>fnd_log.level_procedure);
2208: END IF;
2209:

Line 2268: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',

2264: --enable_debug;
2265:
2266: -- Debug info.
2267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2268: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2269: p_prefix=>l_debug_prefix,
2270: p_msg_level=>fnd_log.level_procedure);
2271: END IF;
2272:

Line 2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',

2294:
2295: x_cust_account_rec.cust_account_id := p_cust_account_id;
2296:
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302:

Line 2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',

2404: X_APPLICATION_ID => x_cust_account_rec.application_id
2405: );
2406:
2407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2408: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2409: p_prefix=>l_debug_prefix,
2410: p_msg_level=>fnd_log.level_procedure);
2411: END IF;
2412:

Line 2442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2438: p_data => x_msg_data );
2439:
2440: -- Debug info.
2441: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2443: p_msg_data=>x_msg_data,
2444: p_msg_type=>'WARNING',
2445: p_msg_level=>fnd_log.level_exception);
2446: END IF;

Line 2448: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

2444: p_msg_type=>'WARNING',
2445: p_msg_level=>fnd_log.level_exception);
2446: END IF;
2447: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2449: p_prefix=>l_debug_prefix,
2450: p_msg_level=>fnd_log.level_procedure);
2451: END IF;
2452:

Line 2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2463: p_data => x_msg_data );
2464:
2465: -- Debug info.
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471:

Line 2474: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

2470: p_msg_level=>fnd_log.level_error);
2471:
2472: END IF;
2473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2475: p_prefix=>l_debug_prefix,
2476: p_msg_level=>fnd_log.level_procedure);
2477: END IF;
2478:

Line 2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2488: p_data => x_msg_data );
2489:
2490: -- Debug info.
2491: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2492: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2493: p_msg_data=>x_msg_data,
2494: p_msg_type=>'UNEXPECTED ERROR',
2495: p_msg_level=>fnd_log.level_error);
2496:

Line 2499: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

2495: p_msg_level=>fnd_log.level_error);
2496:
2497: END IF;
2498: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2499: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2500: p_prefix=>l_debug_prefix,
2501: p_msg_level=>fnd_log.level_procedure);
2502: END IF;
2503:

Line 2522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2518: p_data => x_msg_data );
2519:
2520: -- Debug info.
2521: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2522: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2523: p_msg_data=>x_msg_data,
2524: p_msg_type=>'SQL ERROR',
2525: p_msg_level=>fnd_log.level_error);
2526:

Line 2529: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',

2525: p_msg_level=>fnd_log.level_error);
2526:
2527: END IF;
2528: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2529: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2530: p_prefix=>l_debug_prefix,
2531: p_msg_level=>fnd_log.level_procedure);
2532: END IF;
2533:

Line 2640: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',

2636: --enable_debug;
2637:
2638: -- Debug info.
2639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2640: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2641: p_prefix=>l_debug_prefix,
2642: p_msg_level=>fnd_log.level_procedure);
2643: END IF;
2644:

Line 2661: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2657:
2658: x_cust_acct_relate_id := l_cust_acct_relate_rec.cust_acct_relate_id;
2659:
2660: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2661: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2662: -- Invoke business event system.
2663: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_relate_event (
2664: l_cust_acct_relate_rec );
2665: END IF;

Line 2667: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

2663: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_relate_event (
2664: l_cust_acct_relate_rec );
2665: END IF;
2666:
2667: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2668: -- populate function for integration service
2669: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2670: p_operation => 'I',
2671: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);

Line 2683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2679: p_data => x_msg_data );
2680:
2681: -- Debug info.
2682: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2684: p_msg_data=>x_msg_data,
2685: p_msg_type=>'WARNING',
2686: p_msg_level=>fnd_log.level_exception);
2687: END IF;

Line 2689: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',

2685: p_msg_type=>'WARNING',
2686: p_msg_level=>fnd_log.level_exception);
2687: END IF;
2688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2689: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2690: p_prefix=>l_debug_prefix,
2691: p_msg_level=>fnd_log.level_procedure);
2692: END IF;
2693:

Line 2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2705: p_data => x_msg_data );
2706:
2707: -- Debug info.
2708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2710: p_msg_data=>x_msg_data,
2711: p_msg_type=>'ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713:

Line 2716: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',

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

Line 2735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2731: p_data => x_msg_data );
2732:
2733: -- Debug info.
2734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2735: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2736: p_msg_data=>x_msg_data,
2737: p_msg_type=>'UNEXPECTED ERROR',
2738: p_msg_level=>fnd_log.level_error);
2739:

Line 2742: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',

2738: p_msg_level=>fnd_log.level_error);
2739:
2740: END IF;
2741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2743: p_prefix=>l_debug_prefix,
2744: p_msg_level=>fnd_log.level_procedure);
2745: END IF;
2746:

Line 2765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2761: p_data => x_msg_data );
2762:
2763: -- Debug info.
2764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2766: p_msg_data=>x_msg_data,
2767: p_msg_type=>'SQL ERROR',
2768: p_msg_level=>fnd_log.level_error);
2769:

Line 2772: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',

2768: p_msg_level=>fnd_log.level_error);
2769:
2770: END IF;
2771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2772: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2773: p_prefix=>l_debug_prefix,
2774: p_msg_level=>fnd_log.level_procedure);
2775: END IF;
2776:

Line 2840: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',

2836: --enable_debug;
2837:
2838: -- Debug info.
2839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2840: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2841: p_prefix=>l_debug_prefix,
2842: p_msg_level=>fnd_log.level_procedure);
2843: END IF;
2844:

Line 2882: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

2878: NULL, /* Bug 3449118 pass NULL for rowid */
2879: x_return_status );
2880:
2881: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2882: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2883: -- Invoke business event system.
2884: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
2885: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
2886: END IF;

Line 2888: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

2884: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
2885: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
2886: END IF;
2887:
2888: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2889: -- populate function for integration service
2890: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2891: p_operation => 'U',
2892: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);

Line 2904: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2900: p_data => x_msg_data );
2901:
2902: -- Debug info.
2903: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2904: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2905: p_msg_data=>x_msg_data,
2906: p_msg_type=>'WARNING',
2907: p_msg_level=>fnd_log.level_exception);
2908: END IF;

Line 2910: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

2906: p_msg_type=>'WARNING',
2907: p_msg_level=>fnd_log.level_exception);
2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2911: p_prefix=>l_debug_prefix,
2912: p_msg_level=>fnd_log.level_procedure);
2913: END IF;
2914:

Line 2930: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2926: p_data => x_msg_data );
2927:
2928: -- Debug info.
2929: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2930: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2931: p_msg_data=>x_msg_data,
2932: p_msg_type=>'ERROR',
2933: p_msg_level=>fnd_log.level_error);
2934:

Line 2937: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

2933: p_msg_level=>fnd_log.level_error);
2934:
2935: END IF;
2936: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2937: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2938: p_prefix=>l_debug_prefix,
2939: p_msg_level=>fnd_log.level_procedure);
2940: END IF;
2941:

Line 2956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2952: p_data => x_msg_data );
2953:
2954: -- Debug info.
2955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2957: p_msg_data=>x_msg_data,
2958: p_msg_type=>'UNEXPECTED ERROR',
2959: p_msg_level=>fnd_log.level_error);
2960:

Line 2963: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

2959: p_msg_level=>fnd_log.level_error);
2960:
2961: END IF;
2962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2963: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2964: p_prefix=>l_debug_prefix,
2965: p_msg_level=>fnd_log.level_procedure);
2966: END IF;
2967:

Line 2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2982: p_data => x_msg_data );
2983:
2984: -- Debug info.
2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990:

Line 2993: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

2989: p_msg_level=>fnd_log.level_error);
2990:
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;
2997:

Line 3067: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',

3063: --enable_debug;
3064:
3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;
3071:

Line 3108: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

3104: p_rowid,
3105: x_return_status );
3106:
3107: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3108: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3109: -- Invoke business event system.
3110: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
3111: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
3112: END IF;

Line 3114: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

3110: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
3111: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
3112: END IF;
3113:
3114: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3115: -- populate function for integration service
3116: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3117: p_operation => 'U',
3118: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);

Line 3130: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3126: p_data => x_msg_data );
3127:
3128: -- Debug info.
3129: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3130: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3131: p_msg_data=>x_msg_data,
3132: p_msg_type=>'WARNING',
3133: p_msg_level=>fnd_log.level_exception);
3134: END IF;

Line 3136: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

3132: p_msg_type=>'WARNING',
3133: p_msg_level=>fnd_log.level_exception);
3134: END IF;
3135: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3136: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3137: p_prefix=>l_debug_prefix,
3138: p_msg_level=>fnd_log.level_procedure);
3139: END IF;
3140:

Line 3156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3152: p_data => x_msg_data );
3153:
3154: -- Debug info.
3155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3156: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3157: p_msg_data=>x_msg_data,
3158: p_msg_type=>'ERROR',
3159: p_msg_level=>fnd_log.level_error);
3160:

Line 3163: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

3159: p_msg_level=>fnd_log.level_error);
3160:
3161: END IF;
3162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3163: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3164: p_prefix=>l_debug_prefix,
3165: p_msg_level=>fnd_log.level_procedure);
3166: END IF;
3167:

Line 3182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3178: p_data => x_msg_data );
3179:
3180: -- Debug info.
3181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3183: p_msg_data=>x_msg_data,
3184: p_msg_type=>'UNEXPECTED ERROR',
3185: p_msg_level=>fnd_log.level_error);
3186:

Line 3189: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

3185: p_msg_level=>fnd_log.level_error);
3186:
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;
3193:

Line 3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3208: p_data => x_msg_data );
3209:
3210: -- Debug info.
3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216:

Line 3219: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',

3215: p_msg_level=>fnd_log.level_error);
3216:
3217: END IF;
3218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3219: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3220: p_prefix=>l_debug_prefix,
3221: p_msg_level=>fnd_log.level_procedure);
3222: END IF;
3223:

Line 3287: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',

3283: --enable_debug;
3284:
3285: -- Debug info.
3286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3287: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3288: p_prefix=>l_debug_prefix,
3289: p_msg_level=>fnd_log.level_procedure);
3290: END IF;
3291:

Line 3326: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',

3322: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3323:
3324: -- Debug info.
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;
3330:

Line 3403: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',

3399:
3400:
3401: -- Debug info.
3402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3403: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3404: p_prefix=>l_debug_prefix,
3405: p_msg_level=>fnd_log.level_procedure);
3406: END IF;
3407:

Line 3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3412: p_data => x_msg_data );
3413:
3414: -- Debug info.
3415: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3417: p_msg_data=>x_msg_data,
3418: p_msg_type=>'WARNING',
3419: p_msg_level=>fnd_log.level_exception);
3420: END IF;

Line 3422: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

3418: p_msg_type=>'WARNING',
3419: p_msg_level=>fnd_log.level_exception);
3420: END IF;
3421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3423: p_prefix=>l_debug_prefix,
3424: p_msg_level=>fnd_log.level_procedure);
3425: END IF;
3426:

Line 3442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3438: p_data => x_msg_data );
3439:
3440: -- Debug info.
3441: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3442: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3443: p_msg_data=>x_msg_data,
3444: p_msg_type=>'ERROR',
3445: p_msg_level=>fnd_log.level_error);
3446:

Line 3449: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

3445: p_msg_level=>fnd_log.level_error);
3446:
3447: END IF;
3448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3449: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3450: p_prefix=>l_debug_prefix,
3451: p_msg_level=>fnd_log.level_procedure);
3452: END IF;
3453:

Line 3467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3463: p_data => x_msg_data );
3464:
3465: -- Debug info.
3466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3468: p_msg_data=>x_msg_data,
3469: p_msg_type=>'UNEXPECTED ERROR',
3470: p_msg_level=>fnd_log.level_error);
3471:

Line 3474: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

3470: p_msg_level=>fnd_log.level_error);
3471:
3472: END IF;
3473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3474: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3475: p_prefix=>l_debug_prefix,
3476: p_msg_level=>fnd_log.level_procedure);
3477: END IF;
3478:

Line 3496: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

3492: p_data => x_msg_data );
3493:
3494: -- Debug info.
3495: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3496: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3497: p_msg_data=>x_msg_data,
3498: p_msg_type=>'SQL ERROR',
3499: p_msg_level=>fnd_log.level_error);
3500:

Line 3503: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',

3499: p_msg_level=>fnd_log.level_error);
3500:
3501: END IF;
3502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3503: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3504: p_prefix=>l_debug_prefix,
3505: p_msg_level=>fnd_log.level_procedure);
3506: END IF;
3507: