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;
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
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
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:
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
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
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
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;
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
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
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:
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
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
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
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:
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:
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,
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:
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;
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
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
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));
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));
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));
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);
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;
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:
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
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
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;
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;
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 */
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:
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
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
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;
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:
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:
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));
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));
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));
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;
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
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;
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:
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
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
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;
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))||
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))||
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: /*===========================================================================+