79:
80: G_DEBUG_COUNT := G_DEBUG_COUNT + 1;
81:
82: IF G_DEBUG_COUNT = 1 THEN
83: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
84: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
85: THEN
86: HZ_UTILITY_V2PUB.enable_debug;
87: G_DEBUG := TRUE;
80: G_DEBUG_COUNT := G_DEBUG_COUNT + 1;
81:
82: IF G_DEBUG_COUNT = 1 THEN
83: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
84: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
85: THEN
86: HZ_UTILITY_V2PUB.enable_debug;
87: G_DEBUG := TRUE;
88: END IF;
214: NULL;
215: END;
216: END IF;
217:
218: l_gen_contact_number := fnd_profile.value('HZ_GENERATE_CONTACT_NUMBER');
219: --Bug14079129
220: --Below count selection from HZ_ORG_CONTACTS query changed.
221: --When multiple records for sequence generated contact number then rror out.
222: --Instead of 1 getting count.
1182: -- initialize API return status to success.
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;
1184:
1185: -- report error on obsolete columns based on profile
1186: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1187: check_obsolete_columns (
1188: p_create_update_flag => 'C',
1189: p_org_contact_rec => l_org_contact_rec,
1190: x_return_status => x_return_status
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437:
1438: -- report error on obsolete columns based on profile
1439: IF NVL(FND_PROFILE.VALUE('HZ_API_ERR_ON_OBSOLETE_COLUMN'), 'Y') = 'Y' THEN
1440: check_obsolete_columns (
1441: p_create_update_flag => 'U',
1442: p_org_contact_rec => l_org_contact_rec,
1443: p_old_org_contact_rec => l_old_org_contact_rec,