eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_TIMEZONE_PUB dependencies on FND_API

Line 42: -- p_init_msg_list in varchar2:= FND_API.G_FLASE ,

38: +===========================================================================*/
39: Procedure Get_Timezone_ID
40: (
41: p_api_version in number,
42: -- p_init_msg_list in varchar2:= FND_API.G_FLASE ,
43: p_init_msg_list in varchar2,
44: p_postal_code in varchar2,
45: p_city in varchar2,
46: p_state in varchar2,

Line 60: IF NOT FND_API.Compatible_API_Call(

56: l_msg_token VARCHAR2(2000);
57: BEGIN
58:
59: --Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call(
61: l_api_version,
62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: p_api_version,
63: l_api_name,
64: G_PKG_NAME)
65: THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: --Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 70: IF FND_API.to_Boolean(p_init_msg_list) THEN

66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
69: --Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: --Initialize API return status to success.

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: --Initialize API return status to success.
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: BEGIN
78: -- postal_code is unique within a country. There should never be more than one mapping row
79: -- for the same postal code within the same country. Thus, if the postal code and country are passed in

Line 126: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN

122: EXCEPTION WHEN NO_DATA_FOUND THEN --not found
123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
124: FND_MESSAGE.SET_TOKEN('RECORD', 'mapping');
125: --------Bug no: 3565475--------------------
126: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN
127: l_msg_token := p_postal_code||',';
128: END IF;
129: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
130: l_msg_token := l_msg_token||p_city||',';

Line 129: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN

125: --------Bug no: 3565475--------------------
126: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN
127: l_msg_token := p_postal_code||',';
128: END IF;
129: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
130: l_msg_token := l_msg_token||p_city||',';
131: END IF;
132: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
133: l_msg_token := l_msg_token||p_state||',';

Line 132: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN

128: END IF;
129: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
130: l_msg_token := l_msg_token||p_city||',';
131: END IF;
132: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
133: l_msg_token := l_msg_token||p_state||',';
134: END IF;
135: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN
136: l_msg_token := l_msg_token||p_country||',';

Line 135: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN

131: END IF;
132: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
133: l_msg_token := l_msg_token||p_state||',';
134: END IF;
135: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN
136: l_msg_token := l_msg_token||p_country||',';
137: END IF;
138: l_msg_token := substrb(l_msg_token,1,instrb(l_msg_token,',',-1)-1);
139: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);

Line 143: RAISE FND_API.G_EXC_ERROR;

139: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);
140: --FND_MESSAGE.SET_TOKEN('VALUE', p_postal_code||','||p_city||','||p_state||','||p_country);
141: ------End of Bug no: 3565475----------------
142: FND_MSG_PUB.ADD;
143: RAISE FND_API.G_EXC_ERROR;
144: END; -- compare country, no state
145: END; -- compare city, no state
146: END; -- compare all, no state
147:

Line 189: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN

185: EXCEPTION WHEN NO_DATA_FOUND THEN
186: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
187: FND_MESSAGE.SET_TOKEN('RECORD', 'mapping');
188: --------Bug no: 3565475--------------------
189: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN
190: l_msg_token := p_postal_code||',';
191: END IF;
192: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
193: l_msg_token := l_msg_token||p_city||',';

Line 192: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN

188: --------Bug no: 3565475--------------------
189: IF p_postal_code IS NOT NULL and p_postal_code <> fnd_api.g_miss_char THEN
190: l_msg_token := p_postal_code||',';
191: END IF;
192: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
193: l_msg_token := l_msg_token||p_city||',';
194: END IF;
195: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
196: l_msg_token := l_msg_token||p_state||',';

Line 195: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN

191: END IF;
192: IF p_city IS NOT NULL and p_city <> fnd_api.g_miss_char THEN
193: l_msg_token := l_msg_token||p_city||',';
194: END IF;
195: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
196: l_msg_token := l_msg_token||p_state||',';
197: END IF;
198: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN
199: l_msg_token := l_msg_token||p_country||',';

Line 198: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN

194: END IF;
195: IF p_state IS NOT NULL and p_state <> fnd_api.g_miss_char THEN
196: l_msg_token := l_msg_token||p_state||',';
197: END IF;
198: IF p_country IS NOT NULL and p_country <> fnd_api.g_miss_char THEN
199: l_msg_token := l_msg_token||p_country||',';
200: END IF;
201: l_msg_token := substrb(l_msg_token,1,instrb(l_msg_token,',',-1)-1);
202: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);

Line 206: RAISE FND_API.G_EXC_ERROR;

202: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);
203: --FND_MESSAGE.SET_TOKEN('VALUE', p_postal_code||','||p_city||','||p_state||','||p_country);
204: ------End of Bug no: 3565475----------------
205: FND_MSG_PUB.ADD;
206: RAISE FND_API.G_EXC_ERROR;
207: END; --compare country
208: END; --compare state, country
209: END; --compare city, state, country
210: END; --compare all

Line 216: p_encoded => FND_API.G_FALSE,

212: END; --if postal code and country match
213:
214: --Standard call to get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get(
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data);
219:
220: EXCEPTION

Line 221: WHEN FND_API.G_EXC_ERROR THEN

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

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 224: p_encoded => FND_API.G_FALSE,

220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227: /* comment out arp_util.debug for fixing bug 3655764
228: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: arp_util.debug('x_msg_data '|| x_msg_data);
230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.Count_And_Get(
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: arp_util.debug('EXC');
231: arp_util.debug('error code : '|| to_char(SQLCODE));
232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.Count_And_Get(
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data);

Line 236: p_encoded => FND_API.G_FALSE,

232: arp_util.debug('error text : '|| SQLERRM); */
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.Count_And_Get(
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data);
239: /* comment out arp_util.debug for fixing bug 3655764
240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
241: arp_util.debug('x_msg_data '|| x_msg_data);
242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data);

Line 246: p_encoded => FND_API.G_FALSE,

242: arp_util.debug('UNEXC'); */
243: WHEN OTHERS THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249: /* comment out arp_util.debug for fixing bug 3655764
250: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 352: IF NOT FND_API.Compatible_API_Call(

348:
349: BEGIN
350:
351: --Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call(
353: l_api_version,
354: p_api_version,
355: l_api_name,
356: G_PKG_NAME)

Line 358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

354: p_api_version,
355: l_api_name,
356: G_PKG_NAME)
357: THEN
358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: --Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 362: IF FND_API.to_Boolean(p_init_msg_list) THEN

358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: --Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean(p_init_msg_list) THEN
363: FND_MSG_PUB.initialize;
364: END IF;
365:
366: --Initialize API return status to success.

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

363: FND_MSG_PUB.initialize;
364: END IF;
365:
366: --Initialize API return status to success.
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368: x_timezone_id := null;
369:
370: if p_phone_country_code is null
371: then

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: then
372: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
373: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_phone_country_code' );
374: FND_MSG_PUB.ADD;
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: RAISE FND_API.G_EXC_ERROR;
377: else -- phone_country_code is not null
378: if p_area_code is not null
379: then

Line 376: RAISE FND_API.G_EXC_ERROR;

372: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
373: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_phone_country_code' );
374: FND_MSG_PUB.ADD;
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: RAISE FND_API.G_EXC_ERROR;
377: else -- phone_country_code is not null
378: if p_area_code is not null
379: then
380: if p_country_code is not null

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: then
393: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
394: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_country_code' );
395: FND_MSG_PUB.ADD;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: RAISE FND_API.G_EXC_ERROR;
398: elsif l_tz_count = 1
399: then
400: open get_area_code_tzone_csr;

Line 397: RAISE FND_API.G_EXC_ERROR;

393: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
394: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_country_code' );
395: FND_MSG_PUB.ADD;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: RAISE FND_API.G_EXC_ERROR;
398: elsif l_tz_count = 1
399: then
400: open get_area_code_tzone_csr;
401: fetch get_area_code_tzone_csr into x_timezone_id;

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
429: FND_MESSAGE.SET_TOKEN('COLUMN','phone_country_code+country_code');
430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR;
434: end if; -- x_timezone_id is null
435:
436: else

Line 433: RAISE FND_API.G_EXC_ERROR;

429: FND_MESSAGE.SET_TOKEN('COLUMN','phone_country_code+country_code');
430: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR;
434: end if; -- x_timezone_id is null
435:
436: else
437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: else
437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
438: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'country_code' );
439: FND_MSG_PUB.ADD;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: RAISE FND_API.G_EXC_ERROR;
442: end if;
443: elsif l_count = 0
444: then

Line 441: RAISE FND_API.G_EXC_ERROR;

437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
438: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'country_code' );
439: FND_MSG_PUB.ADD;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: RAISE FND_API.G_EXC_ERROR;
442: end if;
443: elsif l_count = 0
444: then
445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');
446: FND_MESSAGE.SET_TOKEN('COLUMN','PHONE_COUNTRY_CODE');
447: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
448: FND_MSG_PUB.ADD;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: RAISE FND_API.G_EXC_ERROR;
451: end if; -- l_count = 1
452: end if; -- if timezone_id is null
453: end if;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: FND_MESSAGE.SET_TOKEN('COLUMN','PHONE_COUNTRY_CODE');
447: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PHONE_COUNTRY_CODES');
448: FND_MSG_PUB.ADD;
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: RAISE FND_API.G_EXC_ERROR;
451: end if; -- l_count = 1
452: end if; -- if timezone_id is null
453: end if;
454: FND_MSG_PUB.Count_And_Get(

Line 455: p_encoded => FND_API.G_FALSE,

451: end if; -- l_count = 1
452: end if; -- if timezone_id is null
453: end if;
454: FND_MSG_PUB.Count_And_Get(
455: p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data);
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data);
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461:
462: FND_MSG_PUB.Count_And_Get(
463: p_encoded => FND_API.G_FALSE,

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: p_count => x_msg_count,
457: p_data => x_msg_data);
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461:
462: FND_MSG_PUB.Count_And_Get(
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,

Line 463: p_encoded => FND_API.G_FALSE,

459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR;
461:
462: FND_MSG_PUB.Count_And_Get(
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data );
466:
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data );
466:
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464: p_count => x_msg_count,
465: p_data => x_msg_data );
466:
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,

Line 471: p_encoded => FND_API.G_FALSE,

467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:
475: WHEN OTHERS THEN

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: p_count => x_msg_count,
473: p_data => x_msg_data );
474:
475: WHEN OTHERS THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
480: FND_MSG_PUB.ADD;

Line 483: p_encoded => FND_API.G_FALSE,

479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
480: FND_MSG_PUB.ADD;
481:
482: FND_MSG_PUB.Count_And_Get(
483: p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data );
486:
487: end get_phone_timezone_id;

Line 544: IF NOT FND_API.Compatible_API_Call(

540: l_timezone_code varchar2(50);
541: BEGIN
542:
543: --Standard call to check for call compatibility.
544: IF NOT FND_API.Compatible_API_Call(
545: l_api_version,
546: p_api_version,
547: l_api_name,
548: G_PKG_NAME)

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: p_api_version,
547: l_api_name,
548: G_PKG_NAME)
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: --Initialize message list if p_init_msg_list is set to TRUE.
554: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 554: IF FND_API.to_Boolean(p_init_msg_list) THEN

550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552:
553: --Initialize message list if p_init_msg_list is set to TRUE.
554: IF FND_API.to_Boolean(p_init_msg_list) THEN
555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: --Initialize API return status to success.

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: --Initialize API return status to success.
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: /* this should be changed in the next release to get the global_timezone_name from the tzabbrev
562: of v$timezone_names which is the database table of timezones, but we will leave it for now
563: because some product may be using the %s substitution capability in order to turn a P%sT into

Line 587: RAISE FND_API.G_EXC_ERROR;

583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
584: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');
585: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));
586: FND_MSG_PUB.ADD;
587: RAISE FND_API.G_EXC_ERROR;
588: END;
589:
590: IF (l_dst_flag = 'N')THEN
591: x_GMT_deviation := l_GMT_Deviation;

Line 610: p_encoded => FND_API.G_FALSE,

606: END IF;
607:
608: --Standard call to get message count and if count is 1, get message info.
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MSG_PUB.Count_And_Get(
617: p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: p_count => x_msg_count,
612: p_data => x_msg_data);
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MSG_PUB.Count_And_Get(
617: p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,
619: p_data => x_msg_data);

Line 617: p_encoded => FND_API.G_FALSE,

613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: FND_MSG_PUB.Count_And_Get(
617: p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
621: arp_util.debug('x_msg_data '|| x_msg_data);

Line 625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

621: arp_util.debug('x_msg_data '|| x_msg_data);
622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Count_And_Get(
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

622: arp_util.debug('EXC');
623: arp_util.debug('error code : '|| to_char(SQLCODE));
624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Count_And_Get(
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);

Line 628: p_encoded => FND_API.G_FALSE,

624: arp_util.debug('error text : '|| SQLERRM);
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.Count_And_Get(
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data);
631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
632: arp_util.debug('x_msg_data '|| x_msg_data);

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
632: arp_util.debug('x_msg_data '|| x_msg_data);
633: arp_util.debug('UNEXC');
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);

Line 637: p_encoded => FND_API.G_FALSE,

633: arp_util.debug('UNEXC');
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
641: arp_util.debug('x_msg_data '|| x_msg_data);

Line 702: RAISE FND_API.G_EXC_ERROR;

698: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
699: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');
700: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_dest_tz_id)||to_char(p_source_tz_id));
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703: END;
704:
705: return fnd_timezone_pub.adjust_datetime(p_source_day_time, l_source_tz_code, l_dest_tz_code);
706:

Line 765: IF NOT FND_API.Compatible_API_Call(

761:
762: BEGIN
763:
764: --Standard call to check for call compatibility.
765: IF NOT FND_API.Compatible_API_Call(
766: l_api_version,
767: p_api_version,
768: l_api_name,
769: G_PKG_NAME)

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: p_api_version,
768: l_api_name,
769: G_PKG_NAME)
770: THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: --Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 775: IF FND_API.to_Boolean(p_init_msg_list) THEN

771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774: --Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean(p_init_msg_list) THEN
776: FND_MSG_PUB.initialize;
777: END IF;
778:
779: --Initialize API return status to success.

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: FND_MSG_PUB.initialize;
777: END IF;
778:
779: --Initialize API return status to success.
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: -- Validate that non null parameters have been passed
783: IF ((p_source_tz_id is null) OR
784: (p_dest_tz_id is null) OR

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: FND_MESSAGE.SET_TOKEN('P_SOURCE_TZ_ID',p_source_tz_id);
790: FND_MESSAGE.SET_TOKEN('P_DEST_TZ_ID',p_dest_tz_id);
791: FND_MESSAGE.SET_TOKEN('P_SOURCE_DAY_TIME',p_source_day_time);
792: FND_MSG_PUB.ADD;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: x_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);

Line 794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

790: FND_MESSAGE.SET_TOKEN('P_DEST_TZ_ID',p_dest_tz_id);
791: FND_MESSAGE.SET_TOKEN('P_SOURCE_DAY_TIME',p_source_day_time);
792: FND_MSG_PUB.ADD;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: x_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);
798:

Line 800: WHEN FND_API.G_EXC_ERROR THEN

796:
797: x_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);
798:
799: EXCEPTION
800: WHEN FND_API.G_EXC_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get(
803: p_encoded => FND_API.G_FALSE,
804: p_count => x_msg_count,

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: x_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);
798:
799: EXCEPTION
800: WHEN FND_API.G_EXC_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get(
803: p_encoded => FND_API.G_FALSE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);

Line 803: p_encoded => FND_API.G_FALSE,

799: EXCEPTION
800: WHEN FND_API.G_EXC_ERROR THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: FND_MSG_PUB.Count_And_Get(
803: p_encoded => FND_API.G_FALSE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

802: FND_MSG_PUB.Count_And_Get(
803: p_encoded => FND_API.G_FALSE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: FND_MSG_PUB.Count_And_Get(
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,

Line 807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

803: p_encoded => FND_API.G_FALSE,
804: p_count => x_msg_count,
805: p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: FND_MSG_PUB.Count_And_Get(
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data);

Line 809: p_encoded => FND_API.G_FALSE,

805: p_data => x_msg_data);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: FND_MSG_PUB.Count_And_Get(
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data);
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data);
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: FND_MSG_PUB.Count_And_Get(
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data);

Line 815: p_encoded => FND_API.G_FALSE,

811: p_data => x_msg_data);
812: WHEN OTHERS THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: FND_MSG_PUB.Count_And_Get(
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data);
818: END Get_Time;
819:

Line 889: IF NOT FND_API.Compatible_API_Call(

885:
886: BEGIN
887:
888: --Standard call to check for call compatibility.
889: IF NOT FND_API.Compatible_API_Call(
890: l_api_version,
891: p_api_version,
892: l_api_name,
893: G_PKG_NAME)

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: p_api_version,
892: l_api_name,
893: G_PKG_NAME)
894: THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897:
898: --Initialize message list if p_init_msg_list is set to TRUE.
899: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 899: IF FND_API.to_Boolean(p_init_msg_list) THEN

895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897:
898: --Initialize message list if p_init_msg_list is set to TRUE.
899: IF FND_API.to_Boolean(p_init_msg_list) THEN
900: FND_MSG_PUB.initialize;
901: END IF;
902:
903: --Initialize API return status to success.

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: FND_MSG_PUB.initialize;
901: END IF;
902:
903: --Initialize API return status to success.
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: /* convert p_source_day_time to new timezone */
907: l_dest_day_time := hz_timezone_pub.convert_datetime(p_source_tz_id, p_dest_tz_id, p_source_day_time);
908:

Line 926: IF(s_status <> FND_API.G_RET_STS_SUCCESS )THEN

922:
923: Get_Timezone_GMT_Deviation(1.0, 'F', p_dest_tz_id, l_dest_day_time,
924: d_GMT_deviation, l_global_timezone_name, l_name, s_status,
925: s_msg_count, s_msg_data);
926: IF(s_status <> FND_API.G_RET_STS_SUCCESS )THEN
927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
928: FND_MESSAGE.SET_TOKEN('PROC', 'GET_GMT_DEVIATION');
929: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_dest_tz_id)||','
930: ||to_char(l_dest_day_time, 'MM-DD-RR')||','

Line 933: RAISE FND_API.G_EXC_ERROR;

929: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_dest_tz_id)||','
930: ||to_char(l_dest_day_time, 'MM-DD-RR')||','
931: ||to_char(p_dest_tz_id));
932: FND_MSG_PUB.ADD;
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;
935:
936: /* if the current offset is different than the standard offset, then it must be daylight savings */
937: IF (std_GMT_deviation <> d_GMT_deviation) THEN

Line 948: p_encoded => FND_API.G_FALSE,

944: x_dest_day_time := l_dest_day_time;
945:
946: --Standard call to get message count and if count is 1, get message info.
947: FND_MSG_PUB.Count_And_Get(
948: p_encoded => FND_API.G_FALSE,
949: p_count => x_msg_count,
950: p_data => x_msg_data);
951:
952: EXCEPTION

Line 953: WHEN FND_API.G_EXC_ERROR THEN

949: p_count => x_msg_count,
950: p_data => x_msg_data);
951:
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,

Line 954: x_return_status := FND_API.G_RET_STS_ERROR;

950: p_data => x_msg_data);
951:
952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data);

Line 956: p_encoded => FND_API.G_FALSE,

952: EXCEPTION
953: WHEN FND_API.G_EXC_ERROR THEN
954: x_return_status := FND_API.G_RET_STS_ERROR;
955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: FND_MSG_PUB.Count_And_Get(
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,

Line 960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: FND_MSG_PUB.Count_And_Get(
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data);

Line 962: p_encoded => FND_API.G_FALSE,

958: p_data => x_msg_data);
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: FND_MSG_PUB.Count_And_Get(
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data);
965: WHEN OTHERS THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data);
965: WHEN OTHERS THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get(
968: p_encoded => FND_API.G_FALSE,
969: p_count => x_msg_count,
970: p_data => x_msg_data);

Line 968: p_encoded => FND_API.G_FALSE,

964: p_data => x_msg_data);
965: WHEN OTHERS THEN
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: FND_MSG_PUB.Count_And_Get(
968: p_encoded => FND_API.G_FALSE,
969: p_count => x_msg_count,
970: p_data => x_msg_data);
971: END Get_Time_and_Code;
972:

Line 1052: IF NOT FND_API.Compatible_API_Call(

1048:
1049: BEGIN
1050:
1051: --Standard call to check for call compatibility.
1052: IF NOT FND_API.Compatible_API_Call(
1053: l_api_version,
1054: p_api_version,
1055: l_api_name,
1056: G_PKG_NAME)

Line 1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1054: p_api_version,
1055: l_api_name,
1056: G_PKG_NAME)
1057: THEN
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: END IF;
1060: BEGIN
1061:
1062: select h.timezone_id,

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088: ','||p_daylight_savings_time_flag||','
1089: ||p_begin_dst_month||','||to_char(p_begin_dst_day)
1090: ||to_char(p_begin_dst_week_of_month)||','||to_char(p_begin_dst_day_of_week));
1091: FND_MSG_PUB.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093:
1094: END;
1095:
1096: --Standard call to get message count and if count is 1, get message info.

Line 1098: p_encoded => FND_API.G_FALSE,

1094: END;
1095:
1096: --Standard call to get message count and if count is 1, get message info.
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:
1102: EXCEPTION

Line 1103: WHEN FND_API.G_EXC_ERROR THEN

1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:
1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: FND_MSG_PUB.Count_And_Get(
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,

Line 1104: x_return_status := FND_API.G_RET_STS_ERROR;

1100: p_data => x_msg_data);
1101:
1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: FND_MSG_PUB.Count_And_Get(
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);

Line 1106: p_encoded => FND_API.G_FALSE,

1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: FND_MSG_PUB.Count_And_Get(
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1110: arp_util.debug('x_msg_data '|| x_msg_data);

Line 1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1110: arp_util.debug('x_msg_data '|| x_msg_data);
1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,

Line 1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1111: arp_util.debug('EXC');
1112: arp_util.debug('error code : '|| to_char(SQLCODE));
1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);

Line 1117: p_encoded => FND_API.G_FALSE,

1113: arp_util.debug('error text : '|| SQLERRM);
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: FND_MSG_PUB.Count_And_Get(
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1121: arp_util.debug('x_msg_data '|| x_msg_data);

Line 1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1121: arp_util.debug('x_msg_data '|| x_msg_data);
1122: arp_util.debug('UNEXC');
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: FND_MSG_PUB.Count_And_Get(
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);

Line 1126: p_encoded => FND_API.G_FALSE,

1122: arp_util.debug('UNEXC');
1123: WHEN OTHERS THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: FND_MSG_PUB.Count_And_Get(
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));
1130: arp_util.debug('x_msg_data '|| x_msg_data);

Line 1201: IF NOT FND_API.Compatible_API_Call(

1197:
1198: BEGIN
1199:
1200: --Standard call to check for call compatibility.
1201: IF NOT FND_API.Compatible_API_Call(
1202: l_api_version,
1203: p_api_version,
1204: l_api_name,
1205: G_PKG_NAME)

Line 1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1203: p_api_version,
1204: l_api_name,
1205: G_PKG_NAME)
1206: THEN
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: END IF;
1209:
1210: --Initialize message list if p_init_msg_list is set to TRUE.
1211: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1211: IF FND_API.to_Boolean(p_init_msg_list) THEN

1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: END IF;
1209:
1210: --Initialize message list if p_init_msg_list is set to TRUE.
1211: IF FND_API.to_Boolean(p_init_msg_list) THEN
1212: FND_MSG_PUB.initialize;
1213: END IF;
1214:
1215: --Initialize API return status to success.

Line 1216: x_return_status := FND_API.G_RET_STS_SUCCESS;

1212: FND_MSG_PUB.initialize;
1213: END IF;
1214:
1215: --Initialize API return status to success.
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:
1218: IF (p_timezone_id is not null) THEN
1219: BEGIN
1220:

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1237: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone id');
1238: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END;
1242: ELSE
1243: BEGIN
1244: SELECT f.GMT_OFFSET,

Line 1263: RAISE FND_API.G_EXC_ERROR;

1259: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1260: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone code');
1261: FND_MESSAGE.SET_TOKEN('VALUE', p_timezone_code);
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_ERROR;
1264: END;
1265:
1266: END IF;
1267:

Line 1289: p_encoded => FND_API.G_FALSE,

1285: x_gmt_deviation := l_current_GMT_deviation;
1286:
1287: --Standard call to get message count and if count is 1, get message info.
1288: FND_MSG_PUB.Count_And_Get(
1289: p_encoded => FND_API.G_FALSE,
1290: p_count => x_msg_count,
1291: p_data => x_msg_data);
1292:
1293: EXCEPTION

Line 1294: WHEN FND_API.G_EXC_ERROR THEN

1290: p_count => x_msg_count,
1291: p_data => x_msg_data);
1292:
1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: FND_MSG_PUB.Count_And_Get(
1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,

Line 1295: x_return_status := FND_API.G_RET_STS_ERROR;

1291: p_data => x_msg_data);
1292:
1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: FND_MSG_PUB.Count_And_Get(
1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);

Line 1297: p_encoded => FND_API.G_FALSE,

1293: EXCEPTION
1294: WHEN FND_API.G_EXC_ERROR THEN
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: FND_MSG_PUB.Count_And_Get(
1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1296: FND_MSG_PUB.Count_And_Get(
1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,

Line 1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1297: p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);

Line 1303: p_encoded => FND_API.G_FALSE,

1299: p_data => x_msg_data);
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN OTHERS THEN
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN OTHERS THEN
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: FND_MSG_PUB.Count_And_Get(
1309: p_encoded => FND_API.G_FALSE,
1310: p_count => x_msg_count,
1311: p_data => x_msg_data);

Line 1309: p_encoded => FND_API.G_FALSE,

1305: p_data => x_msg_data);
1306: WHEN OTHERS THEN
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: FND_MSG_PUB.Count_And_Get(
1309: p_encoded => FND_API.G_FALSE,
1310: p_count => x_msg_count,
1311: p_data => x_msg_data);
1312: END Get_Timezone_Short_Code;
1313:

Line 1417: RAISE FND_API.G_EXC_ERROR;

1413: ||v_begin_dst_month
1414: ||','||to_char(v_begin_dst_week_of_m)
1415: ||','||to_char(v_begin_dst_day_of_w));
1416: FND_MSG_PUB.ADD;
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419: x_begin_dst_date := to_date(to_char(v_date, 'MM-DD-YYYY')||
1420: ' '||to_char(trunc(v_begin_dst_hour))||
1421: ' '||to_char(round((v_begin_dst_hour - trunc(v_begin_dst_hour))*60,2)),

Line 1471: RAISE FND_API.G_EXC_ERROR;

1467: FND_MESSAGE.SET_TOKEN('VALUE', p_year||','||v_end_dst_month
1468: ||','||to_char(v_end_dst_week_of_m)
1469: ||','||to_char(v_end_dst_day_of_w));
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: END IF;
1473: x_end_dst_date := to_date(to_char(v_date, 'MM-DD-YYYY')
1474: ||' '||to_char(trunc(v_end_dst_hour))||
1475: ' '||to_char(round((v_end_dst_hour - trunc(v_end_dst_hour))*60,2)),

Line 1505: RAISE FND_API.G_EXC_ERROR;

1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1502: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');
1503: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));
1504: FND_MSG_PUB.ADD;
1505: RAISE FND_API.G_EXC_ERROR;
1506: END Get_begin_end_dst_day_time;
1507:
1508: /*===========================================================================+
1509: | PROCEDURE |