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 570: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Insert API'

566: X_ADVANCE_PAYMENT_INDICATOR => p_cust_account_rec.advance_payment_indicator
567: );
568:
569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
570: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Insert API'
571: ||' FedEntType : '|| p_cust_account_rec.federal_entity_type
572: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
573: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION
574: ||' AdvPmntInd : '|| p_cust_account_rec.advance_payment_indicator,

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

576: p_msg_level=>fnd_log.level_procedure);
577: END IF;
578: -- Debug info.
579: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
580: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Insert_Row (-) ' ||
581: 'x_cust_account_id = ' || p_cust_account_rec.cust_account_id || ' ' ||
582: 'x_account_number = ' || p_cust_account_rec.account_number,
583: p_prefix=>l_debug_prefix,
584: p_msg_level=>fnd_log.level_procedure);

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

692: x_profile_id := l_profile_id;
693:
694: -- Debug info.
695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
696: hz_utility_v2pub.debug(p_message=>'do_create_cust_account (-)',
697: p_prefix=>l_debug_prefix,
698: p_msg_level=>fnd_log.level_procedure);
699: END IF;
700:

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

768: BEGIN
769:
770: -- Debug info.
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (+)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;
776:

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

830: end if;
831:
832: -- Debug info.
833: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
834: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (+)',
835: p_prefix=>l_debug_prefix,
836: p_msg_level=>fnd_log.level_procedure);
837: END IF;
838:

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

948: );
949:
950: -- Debug info.
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Update_Row (-)',
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;
956:

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

1004: END IF;
1005:
1006: -- Debug info.
1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1008: hz_utility_v2pub.debug(p_message=>'do_update_cust_account (-)',
1009: p_prefix=>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_procedure);
1011: END IF;
1012:

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

1063: BEGIN
1064:
1065: -- Debug info.
1066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1067: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (+)',
1068: p_prefix=>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_procedure);
1070: END IF;
1071:

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

1093: END IF;
1094:
1095: -- Debug info.
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (+)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101:

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

1133: );
1134:
1135: -- Debug info.
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Insert_Row (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141:

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

1152: BEGIN
1153:
1154: -- Debug info.
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'customer_reciprocal_flag = Y ',
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: END IF;
1160:

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

1202: END IF;
1203:
1204: -- Debug info.
1205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1206: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_relate (-)',
1207: p_prefix=>l_debug_prefix,
1208: p_msg_level=>fnd_log.level_procedure);
1209: END IF;
1210:

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

1268: BEGIN
1269:
1270: -- Debug info.
1271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (+)',
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;
1276:

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

1425: END IF;
1426:
1427: -- Debug info.
1428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1429: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (+)',
1430: p_prefix=>l_debug_prefix,
1431: p_msg_level=>fnd_log.level_procedure);
1432: END IF;
1433:

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

1464: );
1465:
1466: -- Debug info.
1467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Update_Row (-)',
1469: p_prefix=>l_debug_prefix,
1470: p_msg_level=>fnd_log.level_procedure);
1471: END IF;
1472:

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

1474: -- same logic in insert mode during update.
1475:
1476: -- Debug info.
1477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_relate (-)',
1479: p_prefix=>l_debug_prefix,
1480: p_msg_level=>fnd_log.level_procedure);
1481: END IF;
1482:

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

1564: --enable_debug;
1565:
1566: -- Debug info.
1567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1568: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for person',
1569: p_prefix=>l_debug_prefix,
1570: p_msg_level=>fnd_log.level_procedure);
1571: END IF;
1572:

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

1607: x_return_status );
1608:
1609:
1610: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1611: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1612: -- Invoke business event system.
1613: HZ_BUSINESS_EVENT_V2PVT.create_cust_account_event (
1614: l_cust_account_rec,
1615: l_person_rec,

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

1616: l_customer_profile_rec,
1617: p_create_profile_amt );
1618: END IF;
1619:
1620: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1621: -- populate function for integration service
1622: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1623: p_operation => 'I',
1624: p_cust_account_id => x_cust_account_id );

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

1635: p_data => x_msg_data );
1636:
1637: -- Debug info.
1638: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1640: p_msg_data=>x_msg_data,
1641: p_msg_type=>'WARNING',
1642: p_msg_level=>fnd_log.level_exception);
1643: END IF;

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

1641: p_msg_type=>'WARNING',
1642: p_msg_level=>fnd_log.level_exception);
1643: END IF;
1644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1646: p_prefix=>l_debug_prefix,
1647: p_msg_level=>fnd_log.level_procedure);
1648: END IF;
1649:

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

1661: p_data => x_msg_data );
1662:
1663: -- Debug info.
1664: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1666: p_msg_data=>x_msg_data,
1667: p_msg_type=>'ERROR',
1668: p_msg_level=>fnd_log.level_error);
1669:

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

1668: p_msg_level=>fnd_log.level_error);
1669:
1670: END IF;
1671: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1672: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1673: p_prefix=>l_debug_prefix,
1674: p_msg_level=>fnd_log.level_procedure);
1675: END IF;
1676:

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

1687: p_data => x_msg_data );
1688:
1689: -- Debug info.
1690: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1692: p_msg_data=>x_msg_data,
1693: p_msg_type=>'UNEXPECTED ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695:

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

1694: p_msg_level=>fnd_log.level_error);
1695:
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702:

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

1717: p_data => x_msg_data );
1718:
1719: -- Debug info.
1720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1722: p_msg_data=>x_msg_data,
1723: p_msg_type=>'SQL ERROR',
1724: p_msg_level=>fnd_log.level_error);
1725:

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

1724: p_msg_level=>fnd_log.level_error);
1725:
1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for person',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732:

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

1813: --enable_debug;
1814:
1815: -- Debug info.
1816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug(p_message=>'create_cust_account (+) : for organization',
1818: p_prefix=>l_debug_prefix,
1819: p_msg_level=>fnd_log.level_procedure);
1820: END IF;
1821:

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

1855: x_profile_id,
1856: x_return_status );
1857:
1858: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1859: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1860: -- Invoke business event system.
1861: HZ_BUSINESS_EVENT_V2PVT.create_cust_account_event (
1862: l_cust_account_rec,
1863: l_organization_rec,

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

1864: l_customer_profile_rec,
1865: p_create_profile_amt );
1866: END IF;
1867:
1868: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1869: -- populate function for integration service
1870: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
1871: p_operation => 'I',
1872: p_cust_account_id => x_cust_account_id );

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

1883: p_data => x_msg_data );
1884:
1885: -- Debug info.
1886: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1888: p_msg_data=>x_msg_data,
1889: p_msg_type=>'WARNING',
1890: p_msg_level=>fnd_log.level_exception);
1891: END IF;

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

1889: p_msg_type=>'WARNING',
1890: p_msg_level=>fnd_log.level_exception);
1891: END IF;
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1894: p_prefix=>l_debug_prefix,
1895: p_msg_level=>fnd_log.level_procedure);
1896: END IF;
1897:

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

1910: p_data => x_msg_data );
1911:
1912: -- Debug info.
1913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1915: p_msg_data=>x_msg_data,
1916: p_msg_type=>'ERROR',
1917: p_msg_level=>fnd_log.level_error);
1918:

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

1917: p_msg_level=>fnd_log.level_error);
1918:
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;
1925:

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

1936: p_data => x_msg_data );
1937:
1938: -- Debug info.
1939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1941: p_msg_data=>x_msg_data,
1942: p_msg_type=>'UNEXPECTED ERROR',
1943: p_msg_level=>fnd_log.level_error);
1944:

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

1943: p_msg_level=>fnd_log.level_error);
1944:
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951:

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

1967:
1968: -- Debug info.
1969:
1970: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1971: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1972: p_msg_data=>x_msg_data,
1973: p_msg_type=>'SQL ERROR',
1974: p_msg_level=>fnd_log.level_error);
1975:

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

1974: p_msg_level=>fnd_log.level_error);
1975:
1976: END IF;
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_cust_account (-) : for organization',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1982:

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

2040: --enable_debug;
2041:
2042: -- Debug info.
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'update_cust_account (+)',
2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2048:

Line 2050: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Update API'

2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2048:
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'FV Attributes at Public Update API'
2051: ||' FedEntType : '|| p_cust_account_rec.federal_entity_type
2052: ||' TPAI : '|| p_cust_account_rec.trading_partner_agency_id
2053: ||' DunsExt : '|| p_cust_account_rec.DUNS_EXTENSION
2054: ||' AdvPmntInd : '|| p_cust_account_rec.advance_payment_indicator,

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

2115:
2116: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2117: -- Invoke business event system.
2118: l_old_cust_account_rec.orig_system := l_cust_account_rec.orig_system;
2119: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2120: HZ_BUSINESS_EVENT_V2PVT.update_cust_account_event (
2121: l_cust_account_rec , l_old_cust_account_rec);
2122: END IF;
2123:

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

2120: HZ_BUSINESS_EVENT_V2PVT.update_cust_account_event (
2121: l_cust_account_rec , l_old_cust_account_rec);
2122: END IF;
2123:
2124: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2125: -- populate function for integration service
2126: HZ_POPULATE_BOT_PKG.pop_hz_cust_accounts(
2127: p_operation => 'U',
2128: p_cust_account_id => l_cust_account_rec.cust_account_id );

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

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

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

2145: p_msg_type=>'WARNING',
2146: p_msg_level=>fnd_log.level_exception);
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 2169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

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

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

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

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

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

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

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

2221: p_data => x_msg_data );
2222:
2223: -- Debug info.
2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'SQL ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229:

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

2228: p_msg_level=>fnd_log.level_error);
2229:
2230: END IF;
2231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug(p_message=>'update_cust_account (-)',
2233: p_prefix=>l_debug_prefix,
2234: p_msg_level=>fnd_log.level_procedure);
2235: END IF;
2236:

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

2291: --enable_debug;
2292:
2293: -- Debug info.
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (+)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;
2299:

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

2321:
2322: x_cust_account_rec.cust_account_id := p_cust_account_id;
2323:
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (+)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:

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

2437:
2438:
2439:
2440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2441: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNTS_PKG.Select_Row (-)',
2442: p_prefix=>l_debug_prefix,
2443: p_msg_level=>fnd_log.level_procedure);
2444: END IF;
2445:

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

2471: p_data => x_msg_data );
2472:
2473: -- Debug info.
2474: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2475: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2476: p_msg_data=>x_msg_data,
2477: p_msg_type=>'WARNING',
2478: p_msg_level=>fnd_log.level_exception);
2479: END IF;

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

2477: p_msg_type=>'WARNING',
2478: p_msg_level=>fnd_log.level_exception);
2479: END IF;
2480: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2482: p_prefix=>l_debug_prefix,
2483: p_msg_level=>fnd_log.level_procedure);
2484: END IF;
2485:

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

2496: p_data => x_msg_data );
2497:
2498: -- Debug info.
2499: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2501: p_msg_data=>x_msg_data,
2502: p_msg_type=>'ERROR',
2503: p_msg_level=>fnd_log.level_error);
2504:

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

2503: p_msg_level=>fnd_log.level_error);
2504:
2505: END IF;
2506: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2507: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2508: p_prefix=>l_debug_prefix,
2509: p_msg_level=>fnd_log.level_procedure);
2510: END IF;
2511:

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

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

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

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

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

2551: p_data => x_msg_data );
2552:
2553: -- Debug info.
2554: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'SQL ERROR',
2558: p_msg_level=>fnd_log.level_error);
2559:

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

2558: p_msg_level=>fnd_log.level_error);
2559:
2560: END IF;
2561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2562: hz_utility_v2pub.debug(p_message=>'get_cust_account_rec (-)',
2563: p_prefix=>l_debug_prefix,
2564: p_msg_level=>fnd_log.level_procedure);
2565: END IF;
2566:

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

2669: --enable_debug;
2670:
2671: -- Debug info.
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (+)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677:

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

2690:
2691: x_cust_acct_relate_id := l_cust_acct_relate_rec.cust_acct_relate_id;
2692:
2693: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2694: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2695: -- Invoke business event system.
2696: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_relate_event (
2697: l_cust_acct_relate_rec );
2698: END IF;

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

2696: HZ_BUSINESS_EVENT_V2PVT.create_cust_acct_relate_event (
2697: l_cust_acct_relate_rec );
2698: END IF;
2699:
2700: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2701: -- populate function for integration service
2702: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2703: p_operation => 'I',
2704: p_cust_acct_relate_id => l_cust_acct_relate_rec.cust_acct_relate_id);

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

2712: p_data => x_msg_data );
2713:
2714: -- Debug info.
2715: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2717: p_msg_data=>x_msg_data,
2718: p_msg_type=>'WARNING',
2719: p_msg_level=>fnd_log.level_exception);
2720: END IF;

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

2718: p_msg_type=>'WARNING',
2719: p_msg_level=>fnd_log.level_exception);
2720: END IF;
2721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2722: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2723: p_prefix=>l_debug_prefix,
2724: p_msg_level=>fnd_log.level_procedure);
2725: END IF;
2726:

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

2738: p_data => x_msg_data );
2739:
2740: -- Debug info.
2741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'ERROR',
2745: p_msg_level=>fnd_log.level_error);
2746:

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

2745: p_msg_level=>fnd_log.level_error);
2746:
2747: END IF;
2748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2749: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relate (-)',
2750: p_prefix=>l_debug_prefix,
2751: p_msg_level=>fnd_log.level_procedure);
2752: END IF;
2753:

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

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

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

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

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

2794: p_data => x_msg_data );
2795:
2796: -- Debug info.
2797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2799: p_msg_data=>x_msg_data,
2800: p_msg_type=>'SQL ERROR',
2801: p_msg_level=>fnd_log.level_error);
2802:

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

2801: p_msg_level=>fnd_log.level_error);
2802:
2803: END IF;
2804: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug(p_message=> 'create_cust_acct_relate (-)',
2806: p_prefix=>l_debug_prefix,
2807: p_msg_level=>fnd_log.level_procedure);
2808: END IF;
2809:

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

2869: --enable_debug;
2870:
2871: -- Debug info.
2872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2873: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
2874: p_prefix=>l_debug_prefix,
2875: p_msg_level=>fnd_log.level_procedure);
2876: END IF;
2877:

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

2911: NULL, /* Bug 3449118 pass NULL for rowid */
2912: x_return_status );
2913:
2914: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2915: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
2916: -- Invoke business event system.
2917: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
2918: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
2919: END IF;

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

2917: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
2918: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
2919: END IF;
2920:
2921: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2922: -- populate function for integration service
2923: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
2924: p_operation => 'U',
2925: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.

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

2934: p_data => x_msg_data );
2935:
2936: -- Debug info.
2937: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'WARNING',
2941: p_msg_level=>fnd_log.level_exception);
2942: END IF;

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

2940: p_msg_type=>'WARNING',
2941: p_msg_level=>fnd_log.level_exception);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;
2948:

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

2960: p_data => x_msg_data );
2961:
2962: -- Debug info.
2963: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2965: p_msg_data=>x_msg_data,
2966: p_msg_type=>'ERROR',
2967: p_msg_level=>fnd_log.level_error);
2968:

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

2967: p_msg_level=>fnd_log.level_error);
2968:
2969: END IF;
2970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2971: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2972: p_prefix=>l_debug_prefix,
2973: p_msg_level=>fnd_log.level_procedure);
2974: END IF;
2975:

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

2986: p_data => x_msg_data );
2987:
2988: -- Debug info.
2989: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2990: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2991: p_msg_data=>x_msg_data,
2992: p_msg_type=>'UNEXPECTED ERROR',
2993: p_msg_level=>fnd_log.level_error);
2994:

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

2993: p_msg_level=>fnd_log.level_error);
2994:
2995: END IF;
2996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2997: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
2998: p_prefix=>l_debug_prefix,
2999: p_msg_level=>fnd_log.level_procedure);
3000: END IF;
3001:

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

3016: p_data => x_msg_data );
3017:
3018: -- Debug info.
3019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3020: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3021: p_msg_data=>x_msg_data,
3022: p_msg_type=>'SQL ERROR',
3023: p_msg_level=>fnd_log.level_error);
3024:

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

3023: p_msg_level=>fnd_log.level_error);
3024:
3025: END IF;
3026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3027: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3028: p_prefix=>l_debug_prefix,
3029: p_msg_level=>fnd_log.level_procedure);
3030: END IF;
3031:

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

3097: --enable_debug;
3098:
3099: -- Debug info.
3100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3101: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (+)',
3102: p_prefix=>l_debug_prefix,
3103: p_msg_level=>fnd_log.level_procedure);
3104: END IF;
3105:

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

3138: p_rowid,
3139: x_return_status );
3140:
3141: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3142: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
3143: -- Invoke business event system.
3144: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
3145: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
3146: END IF;

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

3144: HZ_BUSINESS_EVENT_V2PVT.update_cust_acct_relate_event (
3145: l_cust_acct_relate_rec , l_old_cust_acct_relate_rec);
3146: END IF;
3147:
3148: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3149: -- populate function for integration service
3150: HZ_POPULATE_BOT_PKG.pop_hz_cust_acct_relate_all(
3151: p_operation => 'U',
3152: p_cust_acct_relate_id => l_old_cust_acct_relate_rec.cust_acct_relate_id); --bug 8654754. cust_acct_relate_id has no value in relate rec. Old rec got the value from the get API.

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

3161: p_data => x_msg_data );
3162:
3163: -- Debug info.
3164: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3166: p_msg_data=>x_msg_data,
3167: p_msg_type=>'WARNING',
3168: p_msg_level=>fnd_log.level_exception);
3169: END IF;

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

3167: p_msg_type=>'WARNING',
3168: p_msg_level=>fnd_log.level_exception);
3169: END IF;
3170: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3171: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3172: p_prefix=>l_debug_prefix,
3173: p_msg_level=>fnd_log.level_procedure);
3174: END IF;
3175:

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

3187: p_data => x_msg_data );
3188:
3189: -- Debug info.
3190: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3191: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3192: p_msg_data=>x_msg_data,
3193: p_msg_type=>'ERROR',
3194: p_msg_level=>fnd_log.level_error);
3195:

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

3194: p_msg_level=>fnd_log.level_error);
3195:
3196: END IF;
3197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3198: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3199: p_prefix=>l_debug_prefix,
3200: p_msg_level=>fnd_log.level_procedure);
3201: END IF;
3202:

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

3213: p_data => x_msg_data );
3214:
3215: -- Debug info.
3216: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3218: p_msg_data=>x_msg_data,
3219: p_msg_type=>'UNEXPECTED ERROR',
3220: p_msg_level=>fnd_log.level_error);
3221:

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

3220: p_msg_level=>fnd_log.level_error);
3221:
3222: END IF;
3223: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3224: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3225: p_prefix=>l_debug_prefix,
3226: p_msg_level=>fnd_log.level_procedure);
3227: END IF;
3228:

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

3243: p_data => x_msg_data );
3244:
3245: -- Debug info.
3246: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3247: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3248: p_msg_data=>x_msg_data,
3249: p_msg_type=>'SQL ERROR',
3250: p_msg_level=>fnd_log.level_error);
3251:

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

3250: p_msg_level=>fnd_log.level_error);
3251:
3252: END IF;
3253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3254: hz_utility_v2pub.debug(p_message=>'update_cust_acct_relate (-)',
3255: p_prefix=>l_debug_prefix,
3256: p_msg_level=>fnd_log.level_procedure);
3257: END IF;
3258:

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

3318: --enable_debug;
3319:
3320: -- Debug info.
3321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3322: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (+)',
3323: p_prefix=>l_debug_prefix,
3324: p_msg_level=>fnd_log.level_procedure);
3325: END IF;
3326:

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

3357: x_cust_acct_relate_rec.cust_acct_relate_id := p_cust_acct_relate_id;
3358:
3359: -- Debug info.
3360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (+)',
3362: p_prefix=>l_debug_prefix,
3363: p_msg_level=>fnd_log.level_procedure);
3364: END IF;
3365:

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

3434:
3435:
3436: -- Debug info.
3437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3438: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCT_RELATE_PKG.Select_Row (-)',
3439: p_prefix=>l_debug_prefix,
3440: p_msg_level=>fnd_log.level_procedure);
3441: END IF;
3442:

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

3447: p_data => x_msg_data );
3448:
3449: -- Debug info.
3450: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3452: p_msg_data=>x_msg_data,
3453: p_msg_type=>'WARNING',
3454: p_msg_level=>fnd_log.level_exception);
3455: END IF;

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

3453: p_msg_type=>'WARNING',
3454: p_msg_level=>fnd_log.level_exception);
3455: END IF;
3456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3457: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3458: p_prefix=>l_debug_prefix,
3459: p_msg_level=>fnd_log.level_procedure);
3460: END IF;
3461:

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

3473: p_data => x_msg_data );
3474:
3475: -- Debug info.
3476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3478: p_msg_data=>x_msg_data,
3479: p_msg_type=>'ERROR',
3480: p_msg_level=>fnd_log.level_error);
3481:

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

3480: p_msg_level=>fnd_log.level_error);
3481:
3482: END IF;
3483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3484: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3485: p_prefix=>l_debug_prefix,
3486: p_msg_level=>fnd_log.level_procedure);
3487: END IF;
3488:

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

3498: p_data => x_msg_data );
3499:
3500: -- Debug info.
3501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3503: p_msg_data=>x_msg_data,
3504: p_msg_type=>'UNEXPECTED ERROR',
3505: p_msg_level=>fnd_log.level_error);
3506:

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

3505: p_msg_level=>fnd_log.level_error);
3506:
3507: END IF;
3508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3509: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3510: p_prefix=>l_debug_prefix,
3511: p_msg_level=>fnd_log.level_procedure);
3512: END IF;
3513:

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

3527: p_data => x_msg_data );
3528:
3529: -- Debug info.
3530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3532: p_msg_data=>x_msg_data,
3533: p_msg_type=>'SQL ERROR',
3534: p_msg_level=>fnd_log.level_error);
3535:

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

3534: p_msg_level=>fnd_log.level_error);
3535:
3536: END IF;
3537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3538: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_rec (-)',
3539: p_prefix=>l_debug_prefix,
3540: p_msg_level=>fnd_log.level_procedure);
3541: END IF;
3542: