DBA Data[Home] [Help]

APPS.HZ_TIMEZONE_UTILS_PVT dependencies on FND_MESSAGE

Line 20: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

16: fetch territory_code_exist_csr into l_exist;
17: close territory_code_exist_csr;
18: if l_exist = 'Y'
19: then
20: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
21: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');
22: FND_MSG_PUB.ADD;
23: x_return_status := FND_API.G_RET_STS_ERROR;
24: end if;

Line 21: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');

17: close territory_code_exist_csr;
18: if l_exist = 'Y'
19: then
20: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
21: FND_MESSAGE.SET_TOKEN('COLUMN', 'territory_code');
22: FND_MSG_PUB.ADD;
23: x_return_status := FND_API.G_RET_STS_ERROR;
24: end if;
25: end;

Line 45: FND_MESSAGE.SET_NAME('AR', 'HZ_TZ_AREA_DUP_ERROR');

41: fetch area_code_exist_csr into l_exist;
42: close area_code_exist_csr;
43: if l_exist = 'Y'
44: then
45: FND_MESSAGE.SET_NAME('AR', 'HZ_TZ_AREA_DUP_ERROR');
46: FND_MSG_PUB.ADD;
47: x_return_status := FND_API.G_RET_STS_ERROR;
48: end if;
49: end;

Line 72: fnd_message.set_name('AR','HZ_INVALID_AREA_CODE');

68: p_area_code,
69: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()- .+''~`\/@#$%^*_,|}{[]?<>=";:',
70: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')
71: then
72: fnd_message.set_name('AR','HZ_INVALID_AREA_CODE');
73: FND_MSG_PUB.ADD;
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: RAISE FND_API.G_EXC_ERROR;
76: end if;

Line 118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

114: WHEN OTHERS THEN
115: ROLLBACK to create_area_code;
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
120: FND_MSG_PUB.ADD;
121:
122: FND_MSG_PUB.Count_And_Get(

Line 119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

115: ROLLBACK to create_area_code;
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117:
118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
120: FND_MSG_PUB.ADD;
121:
122: FND_MSG_PUB.Count_And_Get(
123: p_encoded => FND_API.G_FALSE,

Line 154: fnd_message.set_name('AR','HZ_INVALID_AREA_CODE');

150: p_area_code,
151: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()- .+''~`\/@#$%^*_,|}{[]?<>=";:',
152: '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')
153: then
154: fnd_message.set_name('AR','HZ_INVALID_AREA_CODE');
155: FND_MSG_PUB.ADD;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: RAISE FND_API.G_EXC_ERROR;
158: end if;

Line 173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

169: IF NOT ((p_object_version_number is null and l_object_version_number is
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;

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 183: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

179:
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;

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 185: FND_MESSAGE.SET_TOKEN('VALUE', 'territory_code+area_code');

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;
189:

Line 237: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

233: WHEN OTHERS THEN
234: ROLLBACK to update_area_code;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
239: FND_MSG_PUB.ADD;
240:
241: FND_MSG_PUB.Count_And_Get(

Line 238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

234: ROLLBACK to update_area_code;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
239: FND_MSG_PUB.ADD;
240:
241: FND_MSG_PUB.Count_And_Get(
242: p_encoded => FND_API.G_FALSE,

Line 290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

286: IF NOT ((p_object_version_number is null and l_object_version_number is
287: null)
288: OR (p_object_version_number = l_object_version_number))
289: THEN
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
291: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
292: FND_MSG_PUB.ADD;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RAISE FND_API.G_EXC_ERROR;

Line 291: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');

287: null)
288: OR (p_object_version_number = l_object_version_number))
289: THEN
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
291: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
292: FND_MSG_PUB.ADD;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;

Line 300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

296:
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;

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 302: FND_MESSAGE.SET_TOKEN('VALUE', 'territory_code+area_code');

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;
306: