APPS.HZ_PARTY_SITES_PKG dependencies on HZ_UTILITY_V2PUB

Line 106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

102: DECODE( X_PARTY_SITE_ID, FND_API.G_MISS_NUM, HZ_PARTY_SITES_S.NEXTVAL, NULL, HZ_PARTY_SITES_S.NEXTVAL, X_PARTY_SITE_ID ),
103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

103: DECODE( X_PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), NULL, TO_CHAR( HZ_PARTY_SITE_NUMBER_S.NEXTVAL ), X_PARTY_SITE_NUMBER ),
104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 108: HZ_UTILITY_V2PUB.CREATION_DATE,

104: DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 109: HZ_UTILITY_V2PUB.CREATED_BY,

105: DECODE( X_LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

106: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 111: HZ_UTILITY_V2PUB.REQUEST_ID,

107: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

108: HZ_UTILITY_V2PUB.CREATION_DATE,
109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 113: HZ_UTILITY_V2PUB.PROGRAM_ID,

109: HZ_UTILITY_V2PUB.CREATED_BY,
110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

110: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
111: HZ_UTILITY_V2PUB.REQUEST_ID,
112: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
113: HZ_UTILITY_V2PUB.PROGRAM_ID,
114: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
115: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
116: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
117: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
118: DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),

Line 190: hz_utility_v2pub.debug(p_message=>'DUP_VAL_ON_INDEX Error on HZ_PARTY_SITES_U2 Index',

186: l_dummy VARCHAR2(1);
187: BEGIN
188: -- Debug info.
189: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
190: hz_utility_v2pub.debug(p_message=>'DUP_VAL_ON_INDEX Error on HZ_PARTY_SITES_U2 Index',
191: p_prefix=>l_debug_prefix,
192: p_msg_level=>fnd_log.level_procedure);
193: END IF;
194: -- Bug9394160 When Profile HZ: Generate Party Site Number set to NO

Line 201: hz_utility_v2pub.debug(p_message=>'HZ: Generate Party Site Number set to NO so raising Dup val Error.',

197: IF fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER') = 'N' THEN
198:
199: -- Debug info.
200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug(p_message=>'HZ: Generate Party Site Number set to NO so raising Dup val Error.',
202: p_prefix=>l_debug_prefix,
203: p_msg_level=>fnd_log.level_procedure);
204: END IF;
205:

Line 284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

280: UPDATE HZ_PARTY_SITES SET
281: PARTY_SITE_ID = DECODE( X_PARTY_SITE_ID, NULL, PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_SITE_ID ),
282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,

Line 286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

282: PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
283: LOCATION_ID = DECODE( X_LOCATION_ID, NULL, LOCATION_ID, FND_API.G_MISS_NUM, NULL, X_LOCATION_ID ),
284: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

285: PARTY_SITE_NUMBER = DECODE( X_PARTY_SITE_NUMBER, NULL, PARTY_SITE_NUMBER, FND_API.G_MISS_CHAR, NULL, X_PARTY_SITE_NUMBER ),
286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

287: CREATION_DATE = CREATION_DATE,
288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

288: CREATED_BY = CREATED_BY,
289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

289: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
290: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
291: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
292: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
293: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
294: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
295: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
296: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
297: ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),