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_MSG_PUB

Line 71: FND_MSG_PUB.initialize;

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.
75: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 142: FND_MSG_PUB.ADD;

138: l_msg_token := substrb(l_msg_token,1,instrb(l_msg_token,',',-1)-1);
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

Line 205: FND_MSG_PUB.ADD;

201: l_msg_token := substrb(l_msg_token,1,instrb(l_msg_token,',',-1)-1);
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

Line 215: FND_MSG_PUB.Count_And_Get(

211: END IF; --if state is passed
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:

Line 223: FND_MSG_PUB.Count_And_Get(

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);
227: /* comment out arp_util.debug for fixing bug 3655764

Line 235: FND_MSG_PUB.Count_And_Get(

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);
239: /* comment out arp_util.debug for fixing bug 3655764

Line 245: FND_MSG_PUB.Count_And_Get(

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);
249: /* comment out arp_util.debug for fixing bug 3655764

Line 363: FND_MSG_PUB.initialize;

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.
367: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 374: FND_MSG_PUB.ADD;

370: if p_phone_country_code is null
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

Line 395: FND_MSG_PUB.ADD;

391: if l_tz_count >1 -- need country code to be passed in
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

Line 431: FND_MSG_PUB.ADD;

427: then
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:

Line 439: FND_MSG_PUB.ADD;

435:
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

Line 448: FND_MSG_PUB.ADD;

444: then
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

Line 454: FND_MSG_PUB.Count_And_Get(

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(
455: p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => x_msg_data);
458: EXCEPTION

Line 462: FND_MSG_PUB.Count_And_Get(

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,
465: p_data => x_msg_data );
466:

Line 470: FND_MSG_PUB.Count_And_Get(

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,
473: p_data => x_msg_data );
474:

Line 480: FND_MSG_PUB.ADD;

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;
481:
482: FND_MSG_PUB.Count_And_Get(
483: p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,

Line 482: FND_MSG_PUB.Count_And_Get(

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

Line 555: FND_MSG_PUB.initialize;

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.
559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 586: FND_MSG_PUB.ADD;

582: EXCEPTION WHEN NO_DATA_FOUND THEN
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

Line 609: FND_MSG_PUB.Count_And_Get(

605:
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

Line 616: FND_MSG_PUB.Count_And_Get(

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);
620: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 627: FND_MSG_PUB.Count_And_Get(

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);
631: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 636: FND_MSG_PUB.Count_And_Get(

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);
640: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 701: FND_MSG_PUB.ADD;

697: EXCEPTION WHEN NO_DATA_FOUND THEN
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);

Line 776: FND_MSG_PUB.initialize;

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.
780: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 792: FND_MSG_PUB.ADD;

788: FND_MESSAGE.SET_TOKEN('PROC','Get_Time');
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:

Line 802: FND_MSG_PUB.Count_And_Get(

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);
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 808: FND_MSG_PUB.Count_And_Get(

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);
812: WHEN OTHERS THEN

Line 814: FND_MSG_PUB.Count_And_Get(

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);
818: END Get_Time;

Line 900: FND_MSG_PUB.initialize;

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.
904: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 932: FND_MSG_PUB.ADD;

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')||','
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 */

Line 947: FND_MSG_PUB.Count_And_Get(

943: x_dest_gmt_deviation := d_GMT_deviation;
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:

Line 955: FND_MSG_PUB.Count_And_Get(

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);
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 961: FND_MSG_PUB.Count_And_Get(

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);
965: WHEN OTHERS THEN

Line 967: FND_MSG_PUB.Count_And_Get(

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);
971: END Get_Time_and_Code;

Line 1091: FND_MSG_PUB.ADD;

1087: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_gmt_deviation_hours)||
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:

Line 1097: FND_MSG_PUB.Count_And_Get(

1093:
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:

Line 1105: FND_MSG_PUB.Count_And_Get(

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);
1109: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 1116: FND_MSG_PUB.Count_And_Get(

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);
1120: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 1125: FND_MSG_PUB.Count_And_Get(

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);
1129: arp_util.debug('x_msg_count ' || to_char(x_msg_count));

Line 1212: FND_MSG_PUB.initialize;

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.
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1239: FND_MSG_PUB.ADD;

1235: EXCEPTION WHEN NO_DATA_FOUND THEN
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

Line 1262: FND_MSG_PUB.ADD;

1258: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 1288: FND_MSG_PUB.Count_And_Get(

1284:
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:

Line 1296: FND_MSG_PUB.Count_And_Get(

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);
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1302: FND_MSG_PUB.Count_And_Get(

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);
1306: WHEN OTHERS THEN

Line 1308: FND_MSG_PUB.Count_And_Get(

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);
1312: END Get_Timezone_Short_Code;

Line 1416: FND_MSG_PUB.ADD;

1412: FND_MESSAGE.SET_TOKEN('VALUE', p_year||','
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))||

Line 1470: FND_MSG_PUB.ADD;

1466: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');
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))||

Line 1504: FND_MSG_PUB.ADD;

1500: EXCEPTION WHEN NO_DATA_FOUND THEN
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: /*===========================================================================+