APPS.HZ_TIMEZONE_UTILS_PVT dependencies on HZ_PHONE_AREA_CODES

Line 32: from hz_phone_area_codes

28: x_return_status out nocopy varchar2) is
29:
30: cursor area_code_exist_csr is
31: select 'Y'
32: from hz_phone_area_codes
33: where territory_code = p_territory_code
34: and area_code = p_area_code;
35:
36: l_exist varchar2(1);

Line 83: HZ_PHONE_AREA_CODES_PKG.insert_row(

79: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: HZ_PHONE_AREA_CODES_PKG.insert_row(
84: p_rowid => l_rowid,
85: p_TERRITORY_CODE =>p_TERRITORY_CODE,
86: p_AREA_CODE =>p_AREA_CODE,
87: p_PHONE_COUNTRY_CODE =>p_PHONE_COUNTRY_CODE,

Line 164: FROM HZ_PHONE_AREA_CODES

160: -- check whether record has been updated by another user. If not, lock it.
161: BEGIN
162: SELECT OBJECT_VERSION_NUMBER,rowid,area_code
163: INTO l_object_version_number, l_rowid, l_area_code
164: FROM HZ_PHONE_AREA_CODES
165: WHERE TERRITORY_CODE = p_territory_code
166: and area_code = p_old_area_code
167: FOR UPDATE OF TERRITORY_CODE NOWAIT;
168:

Line 174: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_AREA_CODES');

170: null)
171: OR (p_object_version_number = l_object_version_number))
172: THEN
173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
174: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_AREA_CODES');
175: FND_MSG_PUB.ADD;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;

Line 184: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PHONE_AREA_CODES');

180: p_object_version_number := nvl(l_object_version_number, 1) + 1;
181:
182: EXCEPTION WHEN NO_DATA_FOUND THEN
183: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
184: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PHONE_AREA_CODES');
185: FND_MESSAGE.SET_TOKEN('VALUE', 'territory_code+area_code');
186: FND_MSG_PUB.ADD;
187: RAISE FND_API.G_EXC_ERROR;
188: END;

Line 202: HZ_PHONE_AREA_CODES_PKG.update_row(

198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: end if;
201:
202: HZ_PHONE_AREA_CODES_PKG.update_row(
203: p_rowid => l_rowid,
204: p_TERRITORY_CODE =>p_TERRITORY_CODE,
205: p_AREA_CODE =>p_AREA_CODE,
206: p_PHONE_COUNTRY_CODE =>fnd_api.g_miss_char,

Line 250: from hz_phone_area_codes

246: function areacode_timezone_exist(p_territory_code in varchar2) return varchar2 is
247:
248: cursor areacode_timezone_exist_csr is
249: select 'Y'
250: from hz_phone_area_codes
251: where territory_code = p_territory_code
252: and timezone_id is not null;
253:
254: l_exist varchar2(1);

Line 301: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PHONE_AREA_CODES');

297: p_object_version_number := nvl(l_object_version_number, 1) + 1;
298:
299: EXCEPTION WHEN NO_DATA_FOUND THEN
300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
301: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_PHONE_AREA_CODES');
302: FND_MESSAGE.SET_TOKEN('VALUE', 'territory_code+area_code');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305: END;

Line 332: update hz_phone_area_codes

328: l_exist_flag := areacode_timezone_exist(p_territory_code);
329: -- if timezone is entered from country level, delete area code level timezone
330: if p_timezone_id is not null and l_exist_flag = 'Y'
331: then
332: update hz_phone_area_codes
333: set timezone_id = null,
334: object_version_number = nvl(object_version_number,1)+1,
335: -- Bug 3032780
336: -- CREATED_BY =hz_utility_v2pub.created_by,