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_MESSAGE

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

119: AND city is null
120: AND state is null
121: AND country = p_country;
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||',';

Line 124: FND_MESSAGE.SET_TOKEN('RECORD', 'mapping');

120: AND state is null
121: AND country = p_country;
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;

Line 139: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);

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);
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;

Line 140: --FND_MESSAGE.SET_TOKEN('VALUE', p_postal_code||','||p_city||','||p_state||','||p_country);

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);
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

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

182: AND city is null
183: AND state is null
184: AND country = p_country;
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||',';

Line 187: FND_MESSAGE.SET_TOKEN('RECORD', 'mapping');

183: AND state is null
184: AND country = p_country;
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;

Line 202: FND_MESSAGE.SET_TOKEN('VALUE', l_msg_token);

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);
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;

Line 203: --FND_MESSAGE.SET_TOKEN('VALUE', p_postal_code||','||p_city||','||p_state||','||p_country);

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);
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

Line 372: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

368: x_timezone_id := null;
369:
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;

Line 373: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_phone_country_code' );

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

Line 393: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

389: close get_area_code_count_csr;
390:
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;

Line 394: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_country_code' );

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

Line 428: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

424: fetch get_tz_by_pcc_cc_csr into x_timezone_id;
425: close get_tz_by_pcc_cc_csr;
426: if x_timezone_id is null
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;

Line 429: FND_MESSAGE.SET_TOKEN('COLUMN','phone_country_code+country_code');

425: close get_tz_by_pcc_cc_csr;
426: if x_timezone_id is null
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;

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

426: if x_timezone_id is null
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

Line 437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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' );
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;

Line 438: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'country_code' );

434: end if; -- x_timezone_id is null
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;

Line 445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_DATA_FOUND');

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;

Line 446: FND_MESSAGE.SET_TOKEN('COLUMN','PHONE_COUNTRY_CODE');

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;

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

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

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

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;
481:
482: FND_MSG_PUB.Count_And_Get(

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

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

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

579: WHERE H.timezone_id = p_timezone_id
580: AND H.timezone_id = F.upgrade_tz_id;
581:
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;

Line 584: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');

580: AND H.timezone_id = F.upgrade_tz_id;
581:
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;

Line 585: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));

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

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

694: FROM fnd_timezones_b
695: WHERE upgrade_tz_id = p_source_tz_id;
696:
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;

Line 699: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');

695: WHERE upgrade_tz_id = p_source_tz_id;
696:
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;

Line 700: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_dest_tz_id)||to_char(p_source_tz_id));

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

Line 787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NULL_PARAMETER_RECEIVED');

783: IF ((p_source_tz_id is null) OR
784: (p_dest_tz_id is null) OR
785: (p_source_day_time is null))
786: THEN
787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NULL_PARAMETER_RECEIVED');
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);

Line 788: FND_MESSAGE.SET_TOKEN('PROC','Get_Time');

784: (p_dest_tz_id is null) OR
785: (p_source_day_time is null))
786: THEN
787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NULL_PARAMETER_RECEIVED');
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;

Line 789: FND_MESSAGE.SET_TOKEN('P_SOURCE_TZ_ID',p_source_tz_id);

785: (p_source_day_time is null))
786: THEN
787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NULL_PARAMETER_RECEIVED');
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;

Line 790: FND_MESSAGE.SET_TOKEN('P_DEST_TZ_ID',p_dest_tz_id);

786: THEN
787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NULL_PARAMETER_RECEIVED');
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;

Line 791: FND_MESSAGE.SET_TOKEN('P_SOURCE_DAY_TIME',p_source_day_time);

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

Line 927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');

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')||','
931: ||to_char(p_dest_tz_id));

Line 928: FND_MESSAGE.SET_TOKEN('PROC', 'GET_GMT_DEVIATION');

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')||','
931: ||to_char(p_dest_tz_id));
932: FND_MSG_PUB.ADD;

Line 929: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_dest_tz_id)||','

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')||','
931: ||to_char(p_dest_tz_id));
932: FND_MSG_PUB.ADD;
933: RAISE FND_API.G_EXC_ERROR;

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

1081: and nvl(end_dst_hour,-99) = nvl(p_end_dst_hour,-99)
1082: and h.primary_zone_flag = 'Y';
1083:
1084: EXCEPTION WHEN NO_DATA_FOUND THEN
1085: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1086: FND_MESSAGE.SET_TOKEN('RECORD', 'zone mapping');
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)

Line 1086: FND_MESSAGE.SET_TOKEN('RECORD', 'zone mapping');

1082: and h.primary_zone_flag = 'Y';
1083:
1084: EXCEPTION WHEN NO_DATA_FOUND THEN
1085: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1086: FND_MESSAGE.SET_TOKEN('RECORD', 'zone mapping');
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));

Line 1087: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_gmt_deviation_hours)||

1083:
1084: EXCEPTION WHEN NO_DATA_FOUND THEN
1085: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1086: FND_MESSAGE.SET_TOKEN('RECORD', 'zone mapping');
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;

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

1232: WHERE H.timezone_id = p_timezone_id
1233: AND H.timezone_id = F.upgrade_tz_id;
1234:
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;

Line 1237: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone id');

1233: AND H.timezone_id = F.upgrade_tz_id;
1234:
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;

Line 1238: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));

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

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

1255:
1256: l_timezone_code := p_timezone_code;
1257:
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;

Line 1260: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone code');

1256: l_timezone_code := p_timezone_code;
1257:
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;

Line 1261: FND_MESSAGE.SET_TOKEN('VALUE', p_timezone_code);

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

Line 1410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');

1406: to_char(v_begin_dst_week_of_m),
1407: to_char(v_begin_dst_day_of_w),
1408: v_date);
1409: IF v_date is null THEN
1410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
1411: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');
1412: FND_MESSAGE.SET_TOKEN('VALUE', p_year||','
1413: ||v_begin_dst_month
1414: ||','||to_char(v_begin_dst_week_of_m)

Line 1411: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');

1407: to_char(v_begin_dst_day_of_w),
1408: v_date);
1409: IF v_date is null THEN
1410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
1411: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');
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));

Line 1412: FND_MESSAGE.SET_TOKEN('VALUE', p_year||','

1408: v_date);
1409: IF v_date is null THEN
1410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
1411: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');
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;

Line 1465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');

1461: to_char(v_end_dst_week_of_m),
1462: to_char(v_end_dst_day_of_w),
1463: v_date);
1464: IF v_date is null THEN
1465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
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));

Line 1466: FND_MESSAGE.SET_TOKEN('PROC', 'Get_date_from_W_and_D');

1462: to_char(v_end_dst_day_of_w),
1463: v_date);
1464: IF v_date is null THEN
1465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
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;

Line 1467: FND_MESSAGE.SET_TOKEN('VALUE', p_year||','||v_end_dst_month

1463: v_date);
1464: IF v_date is null THEN
1465: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RETURN_ERROR');
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;

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

1497: END IF;
1498: END IF;
1499: END IF;
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;

Line 1502: FND_MESSAGE.SET_TOKEN('RECORD', 'timezone');

1498: END IF;
1499: END IF;
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;

Line 1503: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_timezone_id));

1499: END IF;
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: