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

Line 121: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler insert_row API'

117: IF X_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM THEN
118: X_CUST_ACCOUNT_ID := NULL;
119: END IF;
120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
121: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler insert_row API'
122: ||' FedEntType : '|| X_FEDERAL_ENTITY_TYPE
123: ||' TPAI : '|| X_TRADING_PARTNER_AGENCY_ID
124: ||' DunsExt : '|| X_DUNS_EXTENSION
125: ||' AdvPmntInd : '|| X_ADVANCE_PAYMENT_INDICATOR,

Line 241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

237: VALUES (
238: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
239: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
240: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

238: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_ACCOUNTS_S.NEXTVAL, NULL, HZ_CUST_ACCOUNTS_S.NEXTVAL, X_CUST_ACCOUNT_ID ),
239: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
240: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 243: HZ_UTILITY_V2PUB.CREATION_DATE,

239: DECODE( X_ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), NULL, TO_CHAR( HZ_ACCOUNT_NUM_S.NEXTVAL ), X_ACCOUNT_NUMBER ),
240: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 244: HZ_UTILITY_V2PUB.CREATED_BY,

240: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

241: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,
249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 246: HZ_UTILITY_V2PUB.REQUEST_ID,

242: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,
249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
250: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

243: HZ_UTILITY_V2PUB.CREATION_DATE,
244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,
249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
250: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
251: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 248: HZ_UTILITY_V2PUB.PROGRAM_ID,

244: HZ_UTILITY_V2PUB.CREATED_BY,
245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,
249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
250: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
251: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
252: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

245: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
246: HZ_UTILITY_V2PUB.REQUEST_ID,
247: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
248: HZ_UTILITY_V2PUB.PROGRAM_ID,
249: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
250: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
251: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
252: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
253: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 531: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler update_row API'

527: l_debug_prefix VARCHAR2(30) := '';
528: BEGIN
529:
530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
531: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler update_row API'
532: ||' FedEntType : '|| X_FEDERAL_ENTITY_TYPE
533: ||' TPAI : '|| X_TRADING_PARTNER_AGENCY_ID
534: ||' DunsExt : '|| X_DUNS_EXTENSION
535: ||' AdvPmntInd : '|| X_ADVANCE_PAYMENT_INDICATOR,

Line 542: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

538: END IF;
539: UPDATE HZ_CUST_ACCOUNTS SET
540: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
541: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
542: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
543: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
544: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
545: CREATION_DATE = CREATION_DATE,
546: CREATED_BY = CREATED_BY,

Line 544: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

540: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
541: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
542: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
543: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
544: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
545: CREATION_DATE = CREATION_DATE,
546: CREATED_BY = CREATED_BY,
547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

543: ACCOUNT_NUMBER = DECODE( X_ACCOUNT_NUMBER, NULL, ACCOUNT_NUMBER, FND_API.G_MISS_CHAR, NULL, X_ACCOUNT_NUMBER ),
544: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
545: CREATION_DATE = CREATION_DATE,
546: CREATED_BY = CREATED_BY,
547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

544: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
545: CREATION_DATE = CREATION_DATE,
546: CREATED_BY = CREATED_BY,
547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
552: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

545: CREATION_DATE = CREATION_DATE,
546: CREATED_BY = CREATED_BY,
547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
552: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
553: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

546: CREATED_BY = CREATED_BY,
547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
552: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
553: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
554: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

547: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
548: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
549: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
550: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
551: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
552: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
553: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
554: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
555: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 1427: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler select_row API'

1423: FROM HZ_CUST_ACCOUNTS
1424: WHERE CUST_ACCOUNT_ID = X_CUST_ACCOUNT_ID;
1425:
1426: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'FV Attributes at Tab Handler select_row API'
1428: ||' FedEntType : '|| X_FEDERAL_ENTITY_TYPE
1429: ||' TPAI : '|| X_TRADING_PARTNER_AGENCY_ID
1430: ||' DunsExt : '|| X_DUNS_EXTENSION
1431: ||' AdvPmntInd : '|| X_ADVANCE_PAYMENT_INDICATOR,