APPS.HZ_TIMEZONE_UTILS_PVT dependencies on FND_MSG_PUB

Line 22: FND_MSG_PUB.ADD;

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

Line 46: FND_MSG_PUB.ADD;

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

Line 64: fnd_msg_pub.initialize;

60:
61: l_rowid ROWID;
62: begin
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: fnd_msg_pub.initialize;
65: SAVEPOINT create_area_code;
66:
67: if p_area_code <> TRANSLATE (
68: p_area_code,

Line 73: FND_MSG_PUB.ADD;

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

Line 101: FND_MSG_PUB.Count_And_Get(

97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: ROLLBACK to create_area_code;
100: x_return_status := FND_API.G_RET_STS_ERROR;
101: FND_MSG_PUB.Count_And_Get(
102: p_encoded => FND_API.G_FALSE,
103: p_count => x_msg_count,
104: p_data => x_msg_data);
105:

Line 109: FND_MSG_PUB.Count_And_Get(

105:
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: ROLLBACK to create_area_code;
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);
113:

Line 120: FND_MSG_PUB.ADD;

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,
124: p_count => x_msg_count,

Line 122: FND_MSG_PUB.Count_And_Get(

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,
124: p_count => x_msg_count,
125: p_data => x_msg_data);
126: END;

Line 145: fnd_msg_pub.initialize;

141: l_area_code varchar2(30);
142:
143: begin
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145: fnd_msg_pub.initialize;
146: SAVEPOINT update_area_code;
147:
148:
149: if p_area_code <> TRANSLATE (

Line 155: FND_MSG_PUB.ADD;

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

Line 175: FND_MSG_PUB.ADD;

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

Line 186: FND_MSG_PUB.ADD;

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:
190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 220: FND_MSG_PUB.Count_And_Get(

216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK to update_area_code;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get(
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224:

Line 228: FND_MSG_PUB.Count_And_Get(

224:
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK to update_area_code;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_MSG_PUB.Count_And_Get(
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data);
232:

Line 239: FND_MSG_PUB.ADD;

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,
243: p_count => x_msg_count,

Line 241: FND_MSG_PUB.Count_And_Get(

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,
243: p_count => x_msg_count,
244: p_data => x_msg_data);
245: end;

Line 277: fnd_msg_pub.initialize;

273: l_exist_flag varchar2(1);
274: l_object_version_number number;
275: begin
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277: fnd_msg_pub.initialize;
278:
279: BEGIN
280: SELECT OBJECT_VERSION_NUMBER
281: INTO l_object_version_number

Line 292: FND_MSG_PUB.ADD;

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

Line 303: FND_MSG_PUB.ADD;

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:
307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN