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.CSF_TASK_ADDRESS_PVT dependencies on FND_MESSAGE

Line 80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');

76: BEGIN
77: -- Initialize message list
78: fnd_msg_pub.initialize;
79: -- get termination messages
80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');

Line 81: l_msg_succ := fnd_message.get;

77: -- Initialize message list
78: fnd_msg_pub.initialize;
79: -- get termination messages
80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
85: l_msg_err := fnd_message.get;

Line 82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');

78: fnd_msg_pub.initialize;
79: -- get termination messages
80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
85: l_msg_err := fnd_message.get;
86: -- Initialize API return status to success

Line 83: l_msg_warn := fnd_message.get;

79: -- get termination messages
80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
85: l_msg_err := fnd_message.get;
86: -- Initialize API return status to success
87: retcode := l_rc_succ;

Line 84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');

80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
85: l_msg_err := fnd_message.get;
86: -- Initialize API return status to success
87: retcode := l_rc_succ;
88: errbuf := l_msg_succ;

Line 85: l_msg_err := fnd_message.get;

81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
83: l_msg_warn := fnd_message.get;
84: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
85: l_msg_err := fnd_message.get;
86: -- Initialize API return status to success
87: retcode := l_rc_succ;
88: errbuf := l_msg_succ;
89: -- API body

Line 90: fnd_message.set_name ('CSF', 'CSF_FIND_INVALID_ADDRESS');

86: -- Initialize API return status to success
87: retcode := l_rc_succ;
88: errbuf := l_msg_succ;
89: -- API body
90: fnd_message.set_name ('CSF', 'CSF_FIND_INVALID_ADDRESS');
91: l_msg_data := fnd_message.get;
92: put_stream (g_output, l_msg_data);
93:
94: --

Line 91: l_msg_data := fnd_message.get;

87: retcode := l_rc_succ;
88: errbuf := l_msg_succ;
89: -- API body
90: fnd_message.set_name ('CSF', 'CSF_FIND_INVALID_ADDRESS');
91: l_msg_data := fnd_message.get;
92: put_stream (g_output, l_msg_data);
93:
94: --
95: -- start date defaults to today (truncated)

Line 138: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');

134: END IF;
135:
136: --
137: -- feedback the date range
138: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
139: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
140: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
141: put_stream (g_output, fnd_message.get);
142: --

Line 139: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));

135:
136: --
137: -- feedback the date range
138: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
139: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
140: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
141: put_stream (g_output, fnd_message.get);
142: --
143: -- finally convert the date range to server timezone before processing

Line 140: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));

136: --
137: -- feedback the date range
138: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
139: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
140: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
141: put_stream (g_output, fnd_message.get);
142: --
143: -- finally convert the date range to server timezone before processing
144: --

Line 141: put_stream (g_output, fnd_message.get);

137: -- feedback the date range
138: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
139: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
140: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
141: put_stream (g_output, fnd_message.get);
142: --
143: -- finally convert the date range to server timezone before processing
144: --
145: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);

Line 161: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');

157: );
158:
159: IF l_return_status <> fnd_api.g_ret_sts_success
160: THEN
161: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
162: l_msg_data := fnd_message.get;
163: put_stream (g_log, l_msg_data);
164: RAISE fnd_api.g_exc_error;
165: END IF;

Line 162: l_msg_data := fnd_message.get;

158:
159: IF l_return_status <> fnd_api.g_ret_sts_success
160: THEN
161: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
162: l_msg_data := fnd_message.get;
163: put_stream (g_log, l_msg_data);
164: RAISE fnd_api.g_exc_error;
165: END IF;
166:

Line 250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');

246:
247: IF l_return_status <> fnd_api.g_ret_sts_success
248: THEN
249: update_geometry (l_task_rec.location_id);
250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
251: fnd_message.set_token ('RETURN_STATUS', l_return_status);
252: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
253: l_msg_data := fnd_message.get;
254: put_stream (g_log, l_msg_data);

Line 251: fnd_message.set_token ('RETURN_STATUS', l_return_status);

247: IF l_return_status <> fnd_api.g_ret_sts_success
248: THEN
249: update_geometry (l_task_rec.location_id);
250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
251: fnd_message.set_token ('RETURN_STATUS', l_return_status);
252: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
253: l_msg_data := fnd_message.get;
254: put_stream (g_log, l_msg_data);
255: l_task_rec.validated_flag := g_valid_false;

Line 252: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);

248: THEN
249: update_geometry (l_task_rec.location_id);
250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
251: fnd_message.set_token ('RETURN_STATUS', l_return_status);
252: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
253: l_msg_data := fnd_message.get;
254: put_stream (g_log, l_msg_data);
255: l_task_rec.validated_flag := g_valid_false;
256: l_task_rec.override_flag := g_valid_false;

Line 253: l_msg_data := fnd_message.get;

249: update_geometry (l_task_rec.location_id);
250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
251: fnd_message.set_token ('RETURN_STATUS', l_return_status);
252: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
253: l_msg_data := fnd_message.get;
254: put_stream (g_log, l_msg_data);
255: l_task_rec.validated_flag := g_valid_false;
256: l_task_rec.override_flag := g_valid_false;
257: log_info (p_api_version => 1.0,

Line 269: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');

265: );
266:
267: IF l_return_status <> fnd_api.g_ret_sts_success
268: THEN
269: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
270: fnd_message.set_token ('LOCATION_ID',
271: l_task_rec.location_id
272: );
273: fnd_message.set_token ('RETURN_STATUS', l_return_status);

Line 270: fnd_message.set_token ('LOCATION_ID',

266:
267: IF l_return_status <> fnd_api.g_ret_sts_success
268: THEN
269: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
270: fnd_message.set_token ('LOCATION_ID',
271: l_task_rec.location_id
272: );
273: fnd_message.set_token ('RETURN_STATUS', l_return_status);
274: l_msg_data := fnd_message.get;

Line 273: fnd_message.set_token ('RETURN_STATUS', l_return_status);

269: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
270: fnd_message.set_token ('LOCATION_ID',
271: l_task_rec.location_id
272: );
273: fnd_message.set_token ('RETURN_STATUS', l_return_status);
274: l_msg_data := fnd_message.get;
275: put_stream (g_log, l_msg_data);
276: put_stream (g_output, l_msg_data);
277: RAISE fnd_api.g_exc_error;

Line 274: l_msg_data := fnd_message.get;

270: fnd_message.set_token ('LOCATION_ID',
271: l_task_rec.location_id
272: );
273: fnd_message.set_token ('RETURN_STATUS', l_return_status);
274: l_msg_data := fnd_message.get;
275: put_stream (g_log, l_msg_data);
276: put_stream (g_output, l_msg_data);
277: RAISE fnd_api.g_exc_error;
278: END IF;

Line 294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');

290: x_msg_data => l_msg_data
291: );
292: IF l_return_status <> fnd_api.g_ret_sts_success
293: THEN
294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
297: l_msg_data := fnd_message.get;
298: put_stream (g_log, l_msg_data);

Line 295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);

291: );
292: IF l_return_status <> fnd_api.g_ret_sts_success
293: THEN
294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
297: l_msg_data := fnd_message.get;
298: put_stream (g_log, l_msg_data);
299: put_stream (g_output, l_msg_data);

Line 296: fnd_message.set_token ('RETURN_STATUS', l_return_status);

292: IF l_return_status <> fnd_api.g_ret_sts_success
293: THEN
294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
297: l_msg_data := fnd_message.get;
298: put_stream (g_log, l_msg_data);
299: put_stream (g_output, l_msg_data);
300: RAISE fnd_api.g_exc_error;

Line 297: l_msg_data := fnd_message.get;

293: THEN
294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
297: l_msg_data := fnd_message.get;
298: put_stream (g_log, l_msg_data);
299: put_stream (g_output, l_msg_data);
300: RAISE fnd_api.g_exc_error;
301: END IF;

Line 306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');

302: END IF; -- resolve_address
303: /* ELSE -- l_Time_zone_check false
304: update_geometry (l_task_rec.location_id);
305: l_return_status := fnd_api.g_ret_sts_unexp_error;
306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,

Line 307: fnd_message.set_token ('RETURN_STATUS', l_return_status);

303: /* ELSE -- l_Time_zone_check false
304: update_geometry (l_task_rec.location_id);
305: l_return_status := fnd_api.g_ret_sts_unexp_error;
306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,
311: p_commit => fnd_api.g_true,

Line 308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);

304: update_geometry (l_task_rec.location_id);
305: l_return_status := fnd_api.g_ret_sts_unexp_error;
306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,
311: p_commit => fnd_api.g_true,
312: p_validation_level => fnd_api.g_valid_level_full,

Line 321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');

317: );
318:
319: IF l_return_status <> fnd_api.g_ret_sts_success
320: THEN
321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
324: l_msg_data := fnd_message.get;
325: put_stream (g_log, l_msg_data);

Line 322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);

318:
319: IF l_return_status <> fnd_api.g_ret_sts_success
320: THEN
321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
324: l_msg_data := fnd_message.get;
325: put_stream (g_log, l_msg_data);
326: put_stream (g_output, l_msg_data);

Line 323: fnd_message.set_token ('RETURN_STATUS', l_return_status);

319: IF l_return_status <> fnd_api.g_ret_sts_success
320: THEN
321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
324: l_msg_data := fnd_message.get;
325: put_stream (g_log, l_msg_data);
326: put_stream (g_output, l_msg_data);
327: RAISE fnd_api.g_exc_error;

Line 324: l_msg_data := fnd_message.get;

320: THEN
321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
324: l_msg_data := fnd_message.get;
325: put_stream (g_log, l_msg_data);
326: put_stream (g_output, l_msg_data);
327: RAISE fnd_api.g_exc_error;
328: END IF;

Line 335: fnd_message.set_name ('CSF', 'CSF_NO_DATA_TOPROCESS');

331: i := l_task_rec_tbl.NEXT (i);
332: END LOOP;
333: ELSIF l_task_rec_tbl.COUNT = 0
334: THEN
335: fnd_message.set_name ('CSF', 'CSF_NO_DATA_TOPROCESS');
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);
338: END IF;
339:

Line 336: l_msg_data := fnd_message.get;

332: END LOOP;
333: ELSIF l_task_rec_tbl.COUNT = 0
334: THEN
335: fnd_message.set_name ('CSF', 'CSF_NO_DATA_TOPROCESS');
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);
338: END IF;
339:
340: put_stream (g_log, l_msg_succ);

Line 1001: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

997: INTO l_tmp;
998:
999: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1000: THEN
1001: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1002: fnd_message.set_token ('CITY', p_task_rec.city);
1003: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1004: x_error := fnd_message.get;
1005: x_error_detail := x_error_detail || ' ' || x_error;

Line 1002: fnd_message.set_token ('CITY', p_task_rec.city);

998:
999: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1000: THEN
1001: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1002: fnd_message.set_token ('CITY', p_task_rec.city);
1003: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1004: x_error := fnd_message.get;
1005: x_error_detail := x_error_detail || ' ' || x_error;
1006: END IF;

Line 1003: fnd_message.set_token ('COUNTRY', p_task_rec.country);

999: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1000: THEN
1001: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1002: fnd_message.set_token ('CITY', p_task_rec.city);
1003: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1004: x_error := fnd_message.get;
1005: x_error_detail := x_error_detail || ' ' || x_error;
1006: END IF;
1007:

Line 1004: x_error := fnd_message.get;

1000: THEN
1001: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1002: fnd_message.set_token ('CITY', p_task_rec.city);
1003: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1004: x_error := fnd_message.get;
1005: x_error_detail := x_error_detail || ' ' || x_error;
1006: END IF;
1007:
1008: CLOSE process_cursor;

Line 1031: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');

1027: INTO l_tmp;
1028:
1029: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1030: THEN
1031: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1032: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1033: x_error := fnd_message.get;
1034: x_error_detail := x_error_detail || ' ' || x_error;
1035: END IF;

Line 1032: fnd_message.set_token ('COUNTRY', p_task_rec.country);

1028:
1029: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1030: THEN
1031: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1032: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1033: x_error := fnd_message.get;
1034: x_error_detail := x_error_detail || ' ' || x_error;
1035: END IF;
1036:

Line 1033: x_error := fnd_message.get;

1029: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1030: THEN
1031: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1032: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1033: x_error := fnd_message.get;
1034: x_error_detail := x_error_detail || ' ' || x_error;
1035: END IF;
1036:
1037: CLOSE process_cursor;

Line 1059: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');

1055: INTO l_tmp;
1056:
1057: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1058: THEN
1059: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1060: fnd_message.set_token ('STATE', p_task_rec.state);
1061: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1062: x_error := fnd_message.get;
1063: x_error_detail := x_error_detail || ' ' || x_error;

Line 1060: fnd_message.set_token ('STATE', p_task_rec.state);

1056:
1057: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1058: THEN
1059: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1060: fnd_message.set_token ('STATE', p_task_rec.state);
1061: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1062: x_error := fnd_message.get;
1063: x_error_detail := x_error_detail || ' ' || x_error;
1064: END IF;

Line 1061: fnd_message.set_token ('COUNTRY', p_task_rec.country);

1057: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1058: THEN
1059: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1060: fnd_message.set_token ('STATE', p_task_rec.state);
1061: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1062: x_error := fnd_message.get;
1063: x_error_detail := x_error_detail || ' ' || x_error;
1064: END IF;
1065:

Line 1062: x_error := fnd_message.get;

1058: THEN
1059: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1060: fnd_message.set_token ('STATE', p_task_rec.state);
1061: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1062: x_error := fnd_message.get;
1063: x_error_detail := x_error_detail || ' ' || x_error;
1064: END IF;
1065:
1066: CLOSE process_cursor;

Line 1118: fnd_message.set_name ('CSF',

1114: IF l_tmp IS NULL
1115: THEN
1116: IF l_flag = 'S' AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.city) <> '_'
1117: THEN
1118: fnd_message.set_name ('CSF',
1119: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1120: fnd_message.set_token ('CITY', p_task_rec.city);
1121: fnd_message.set_token ('STATE', p_task_rec.state);
1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'

Line 1120: fnd_message.set_token ('CITY', p_task_rec.city);

1116: IF l_flag = 'S' AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.city) <> '_'
1117: THEN
1118: fnd_message.set_name ('CSF',
1119: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1120: fnd_message.set_token ('CITY', p_task_rec.city);
1121: fnd_message.set_token ('STATE', p_task_rec.state);
1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1123: THEN
1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

Line 1121: fnd_message.set_token ('STATE', p_task_rec.state);

1117: THEN
1118: fnd_message.set_name ('CSF',
1119: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1120: fnd_message.set_token ('CITY', p_task_rec.city);
1121: fnd_message.set_token ('STATE', p_task_rec.state);
1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1123: THEN
1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1125: fnd_message.set_token ('CITY', p_task_rec.city);

Line 1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

1120: fnd_message.set_token ('CITY', p_task_rec.city);
1121: fnd_message.set_token ('STATE', p_task_rec.state);
1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1123: THEN
1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1125: fnd_message.set_token ('CITY', p_task_rec.city);
1126: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1127: END IF;
1128:

Line 1125: fnd_message.set_token ('CITY', p_task_rec.city);

1121: fnd_message.set_token ('STATE', p_task_rec.state);
1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1123: THEN
1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1125: fnd_message.set_token ('CITY', p_task_rec.city);
1126: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1127: END IF;
1128:
1129: x_error := fnd_message.get;

Line 1126: fnd_message.set_token ('COUNTRY', p_task_rec.country);

1122: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1123: THEN
1124: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1125: fnd_message.set_token ('CITY', p_task_rec.city);
1126: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1127: END IF;
1128:
1129: x_error := fnd_message.get;
1130: x_error_detail := x_error_detail || ' ' || x_error;

Line 1129: x_error := fnd_message.get;

1125: fnd_message.set_token ('CITY', p_task_rec.city);
1126: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1127: END IF;
1128:
1129: x_error := fnd_message.get;
1130: x_error_detail := x_error_detail || ' ' || x_error;
1131: END IF;
1132:
1133: CLOSE process_cursor;

Line 1191: fnd_message.set_name ('CSF',

1187: IF l_tmp IS NULL
1188: THEN
1189: IF l_flag = 'C' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.city) <> '_'
1190: THEN
1191: fnd_message.set_name ('CSF',
1192: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1193: );
1194: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1195: fnd_message.set_token ('CITY', p_task_rec.city);

Line 1194: fnd_message.set_token ('ZIP', p_task_rec.postal_code);

1190: THEN
1191: fnd_message.set_name ('CSF',
1192: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1193: );
1194: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1195: fnd_message.set_token ('CITY', p_task_rec.city);
1196: x_error := fnd_message.get;
1197: x_error_detail := x_error_detail || ' ' || x_error;
1198: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'

Line 1195: fnd_message.set_token ('CITY', p_task_rec.city);

1191: fnd_message.set_name ('CSF',
1192: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1193: );
1194: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1195: fnd_message.set_token ('CITY', p_task_rec.city);
1196: x_error := fnd_message.get;
1197: x_error_detail := x_error_detail || ' ' || x_error;
1198: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1199: THEN

Line 1196: x_error := fnd_message.get;

1192: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1193: );
1194: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1195: fnd_message.set_token ('CITY', p_task_rec.city);
1196: x_error := fnd_message.get;
1197: x_error_detail := x_error_detail || ' ' || x_error;
1198: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1199: THEN
1200: fnd_message.set_name ('CSF',

Line 1200: fnd_message.set_name ('CSF',

1196: x_error := fnd_message.get;
1197: x_error_detail := x_error_detail || ' ' || x_error;
1198: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1199: THEN
1200: fnd_message.set_name ('CSF',
1201: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1202: );
1203: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1204: fnd_message.set_token ('STATE', p_task_rec.state);

Line 1203: fnd_message.set_token ('ZIP', p_task_rec.postal_code);

1199: THEN
1200: fnd_message.set_name ('CSF',
1201: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1202: );
1203: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1204: fnd_message.set_token ('STATE', p_task_rec.state);
1205: x_error := fnd_message.get;
1206: x_error_detail := x_error_detail || ' ' || x_error;
1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'

Line 1204: fnd_message.set_token ('STATE', p_task_rec.state);

1200: fnd_message.set_name ('CSF',
1201: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1202: );
1203: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1204: fnd_message.set_token ('STATE', p_task_rec.state);
1205: x_error := fnd_message.get;
1206: x_error_detail := x_error_detail || ' ' || x_error;
1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1208: THEN

Line 1205: x_error := fnd_message.get;

1201: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1202: );
1203: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1204: fnd_message.set_token ('STATE', p_task_rec.state);
1205: x_error := fnd_message.get;
1206: x_error_detail := x_error_detail || ' ' || x_error;
1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1208: THEN
1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');

Line 1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');

1205: x_error := fnd_message.get;
1206: x_error_detail := x_error_detail || ' ' || x_error;
1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1208: THEN
1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1210: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1211: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1212: x_error := fnd_message.get;
1213: x_error_detail := x_error_detail || ' ' || x_error;

Line 1210: fnd_message.set_token ('ZIP', p_task_rec.postal_code);

1206: x_error_detail := x_error_detail || ' ' || x_error;
1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1208: THEN
1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1210: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1211: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1212: x_error := fnd_message.get;
1213: x_error_detail := x_error_detail || ' ' || x_error;
1214: END IF;

Line 1211: fnd_message.set_token ('COUNTRY', p_task_rec.country);

1207: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1208: THEN
1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1210: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1211: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1212: x_error := fnd_message.get;
1213: x_error_detail := x_error_detail || ' ' || x_error;
1214: END IF;
1215: END IF;

Line 1212: x_error := fnd_message.get;

1208: THEN
1209: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1210: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1211: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1212: x_error := fnd_message.get;
1213: x_error_detail := x_error_detail || ' ' || x_error;
1214: END IF;
1215: END IF;
1216: CLOSE process_cursor;

Line 1234: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');

1230: DECLARE
1231: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1232: BEGIN
1233:
1234: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1235: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1236: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1237: IF (l_exp_accuracy_level = '0')
1238: THEN

Line 1239: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

1235: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1236: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1237: IF (l_exp_accuracy_level = '0')
1238: THEN
1239: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1240: END IF;
1241: IF (l_exp_accuracy_level = '1')
1242: THEN
1243: fnd_message.set_token ('ACCURACY','street level accuracy');

Line 1243: fnd_message.set_token ('ACCURACY','street level accuracy');

1239: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1240: END IF;
1241: IF (l_exp_accuracy_level = '1')
1242: THEN
1243: fnd_message.set_token ('ACCURACY','street level accuracy');
1244: END IF;
1245: IF (l_exp_accuracy_level = '2')
1246: THEN
1247: fnd_message.set_token ('ACCURACY','building number level accuracy');

Line 1247: fnd_message.set_token ('ACCURACY','building number level accuracy');

1243: fnd_message.set_token ('ACCURACY','street level accuracy');
1244: END IF;
1245: IF (l_exp_accuracy_level = '2')
1246: THEN
1247: fnd_message.set_token ('ACCURACY','building number level accuracy');
1248: END IF;
1249: x_error := fnd_message.get;
1250: x_error_detail := x_error_detail || ' ' || x_error;
1251:

Line 1249: x_error := fnd_message.get;

1245: IF (l_exp_accuracy_level = '2')
1246: THEN
1247: fnd_message.set_token ('ACCURACY','building number level accuracy');
1248: END IF;
1249: x_error := fnd_message.get;
1250: x_error_detail := x_error_detail || ' ' || x_error;
1251:
1252: END;
1253: -- Enhancement Code ends here

Line 1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');

1326:
1327: -- Initialize API return status to success
1328: x_return_status := fnd_api.g_ret_sts_success;
1329: -- API body
1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);

Line 1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);

1327: -- Initialize API return status to success
1328: x_return_status := fnd_api.g_ret_sts_success;
1329: -- API body
1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);

Line 1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);

1328: x_return_status := fnd_api.g_ret_sts_success;
1329: -- API body
1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);

Line 1333: fnd_message.set_token ('CITY', p_task_rec.city);

1329: -- API body
1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);

Line 1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);

1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1338: l_msg_data := fnd_message.get;

Line 1335: fnd_message.set_token ('COUNTY', p_task_rec.county);

1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1338: l_msg_data := fnd_message.get;
1339: put_stream (g_log, l_msg_data);

Line 1336: fnd_message.set_token ('STATE', p_task_rec.state);

1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1338: l_msg_data := fnd_message.get;
1339: put_stream (g_log, l_msg_data);
1340: put_stream (g_output, l_msg_data);

Line 1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);

1333: fnd_message.set_token ('CITY', p_task_rec.city);
1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1338: l_msg_data := fnd_message.get;
1339: put_stream (g_log, l_msg_data);
1340: put_stream (g_output, l_msg_data);
1341:

Line 1338: l_msg_data := fnd_message.get;

1334: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1335: fnd_message.set_token ('COUNTY', p_task_rec.county);
1336: fnd_message.set_token ('STATE', p_task_rec.state);
1337: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1338: l_msg_data := fnd_message.get;
1339: put_stream (g_log, l_msg_data);
1340: put_stream (g_output, l_msg_data);
1341:
1342: IF l_location_id IS NULL

Line 1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');

1373: );
1374:
1375: IF x_return_status <> fnd_api.g_ret_sts_success
1376: THEN
1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1380: l_msg_data := fnd_message.get;
1381: put_stream (g_log, l_msg_data);

Line 1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);

1374:
1375: IF x_return_status <> fnd_api.g_ret_sts_success
1376: THEN
1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1380: l_msg_data := fnd_message.get;
1381: put_stream (g_log, l_msg_data);
1382: put_stream (g_output, l_msg_data);

Line 1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);

1375: IF x_return_status <> fnd_api.g_ret_sts_success
1376: THEN
1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1380: l_msg_data := fnd_message.get;
1381: put_stream (g_log, l_msg_data);
1382: put_stream (g_output, l_msg_data);
1383: END IF;

Line 1380: l_msg_data := fnd_message.get;

1376: THEN
1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1380: l_msg_data := fnd_message.get;
1381: put_stream (g_log, l_msg_data);
1382: put_stream (g_output, l_msg_data);
1383: END IF;
1384:

Line 1387: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');

1383: END IF;
1384:
1385: IF l_error IS NULL
1386: THEN
1387: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
1388: l_error := fnd_message.get;
1389: END IF;
1390:
1391: IF l_error_detail IS NULL

Line 1388: l_error := fnd_message.get;

1384:
1385: IF l_error IS NULL
1386: THEN
1387: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
1388: l_error := fnd_message.get;
1389: END IF;
1390:
1391: IF l_error_detail IS NULL
1392: THEN

Line 1393: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');

1389: END IF;
1390:
1391: IF l_error_detail IS NULL
1392: THEN
1393: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
1394: l_error_detail := fnd_message.get;
1395: END IF;
1396:
1397: IF l_task_id IS NULL

Line 1394: l_error_detail := fnd_message.get;

1390:
1391: IF l_error_detail IS NULL
1392: THEN
1393: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
1394: l_error_detail := fnd_message.get;
1395: END IF;
1396:
1397: IF l_task_id IS NULL
1398: THEN

Line 1622: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

1618: INTO l_tmp;
1619:
1620: IF l_tmp IS NULL AND trim(p_city) <> '_'
1621: THEN
1622: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1623: fnd_message.set_token ('CITY', p_city);
1624: fnd_message.set_token ('COUNTRY', p_country);
1625: x_error := fnd_message.get;
1626: x_error_detail := x_error_detail || ' ' || x_error;

Line 1623: fnd_message.set_token ('CITY', p_city);

1619:
1620: IF l_tmp IS NULL AND trim(p_city) <> '_'
1621: THEN
1622: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1623: fnd_message.set_token ('CITY', p_city);
1624: fnd_message.set_token ('COUNTRY', p_country);
1625: x_error := fnd_message.get;
1626: x_error_detail := x_error_detail || ' ' || x_error;
1627: END IF;

Line 1624: fnd_message.set_token ('COUNTRY', p_country);

1620: IF l_tmp IS NULL AND trim(p_city) <> '_'
1621: THEN
1622: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1623: fnd_message.set_token ('CITY', p_city);
1624: fnd_message.set_token ('COUNTRY', p_country);
1625: x_error := fnd_message.get;
1626: x_error_detail := x_error_detail || ' ' || x_error;
1627: END IF;
1628:

Line 1625: x_error := fnd_message.get;

1621: THEN
1622: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1623: fnd_message.set_token ('CITY', p_city);
1624: fnd_message.set_token ('COUNTRY', p_country);
1625: x_error := fnd_message.get;
1626: x_error_detail := x_error_detail || ' ' || x_error;
1627: END IF;
1628:
1629: CLOSE process_cursor;

Line 1652: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');

1648: INTO l_tmp;
1649:
1650: IF l_tmp IS NULL AND trim(p_country) <> '_'
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1653: fnd_message.set_token ('COUNTRY', p_country);
1654: x_error := fnd_message.get;
1655: x_error_detail := x_error_detail || ' ' || x_error;
1656: END IF;

Line 1653: fnd_message.set_token ('COUNTRY', p_country);

1649:
1650: IF l_tmp IS NULL AND trim(p_country) <> '_'
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1653: fnd_message.set_token ('COUNTRY', p_country);
1654: x_error := fnd_message.get;
1655: x_error_detail := x_error_detail || ' ' || x_error;
1656: END IF;
1657:

Line 1654: x_error := fnd_message.get;

1650: IF l_tmp IS NULL AND trim(p_country) <> '_'
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1653: fnd_message.set_token ('COUNTRY', p_country);
1654: x_error := fnd_message.get;
1655: x_error_detail := x_error_detail || ' ' || x_error;
1656: END IF;
1657:
1658: CLOSE process_cursor;

Line 1680: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');

1676: INTO l_tmp;
1677:
1678: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
1679: THEN
1680: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1681: fnd_message.set_token ('STATE', p_state);
1682: fnd_message.set_token ('COUNTRY', p_country);
1683: x_error := fnd_message.get;
1684: x_error_detail := x_error_detail || ' ' || x_error;

Line 1681: fnd_message.set_token ('STATE', p_state);

1677:
1678: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
1679: THEN
1680: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1681: fnd_message.set_token ('STATE', p_state);
1682: fnd_message.set_token ('COUNTRY', p_country);
1683: x_error := fnd_message.get;
1684: x_error_detail := x_error_detail || ' ' || x_error;
1685: END IF;

Line 1682: fnd_message.set_token ('COUNTRY', p_country);

1678: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
1679: THEN
1680: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1681: fnd_message.set_token ('STATE', p_state);
1682: fnd_message.set_token ('COUNTRY', p_country);
1683: x_error := fnd_message.get;
1684: x_error_detail := x_error_detail || ' ' || x_error;
1685: END IF;
1686:

Line 1683: x_error := fnd_message.get;

1679: THEN
1680: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1681: fnd_message.set_token ('STATE', p_state);
1682: fnd_message.set_token ('COUNTRY', p_country);
1683: x_error := fnd_message.get;
1684: x_error_detail := x_error_detail || ' ' || x_error;
1685: END IF;
1686:
1687: CLOSE process_cursor;

Line 1739: fnd_message.set_name ('CSF',

1735: IF l_tmp IS NULL
1736: THEN
1737: IF l_flag = 'S' AND trim(p_state) <> '_' AND trim(p_city) <> '_'
1738: THEN
1739: fnd_message.set_name ('CSF',
1740: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1741: fnd_message.set_token ('CITY', p_city);
1742: fnd_message.set_token ('STATE', p_state);
1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'

Line 1741: fnd_message.set_token ('CITY', p_city);

1737: IF l_flag = 'S' AND trim(p_state) <> '_' AND trim(p_city) <> '_'
1738: THEN
1739: fnd_message.set_name ('CSF',
1740: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1741: fnd_message.set_token ('CITY', p_city);
1742: fnd_message.set_token ('STATE', p_state);
1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
1744: THEN
1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

Line 1742: fnd_message.set_token ('STATE', p_state);

1738: THEN
1739: fnd_message.set_name ('CSF',
1740: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1741: fnd_message.set_token ('CITY', p_city);
1742: fnd_message.set_token ('STATE', p_state);
1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
1744: THEN
1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1746: fnd_message.set_token ('CITY', p_city);

Line 1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

1741: fnd_message.set_token ('CITY', p_city);
1742: fnd_message.set_token ('STATE', p_state);
1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
1744: THEN
1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1746: fnd_message.set_token ('CITY', p_city);
1747: fnd_message.set_token ('COUNTRY', p_country);
1748: END IF;
1749:

Line 1746: fnd_message.set_token ('CITY', p_city);

1742: fnd_message.set_token ('STATE', p_state);
1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
1744: THEN
1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1746: fnd_message.set_token ('CITY', p_city);
1747: fnd_message.set_token ('COUNTRY', p_country);
1748: END IF;
1749:
1750: x_error := fnd_message.get;

Line 1747: fnd_message.set_token ('COUNTRY', p_country);

1743: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
1744: THEN
1745: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1746: fnd_message.set_token ('CITY', p_city);
1747: fnd_message.set_token ('COUNTRY', p_country);
1748: END IF;
1749:
1750: x_error := fnd_message.get;
1751: x_error_detail := x_error_detail || ' ' || x_error;

Line 1750: x_error := fnd_message.get;

1746: fnd_message.set_token ('CITY', p_city);
1747: fnd_message.set_token ('COUNTRY', p_country);
1748: END IF;
1749:
1750: x_error := fnd_message.get;
1751: x_error_detail := x_error_detail || ' ' || x_error;
1752: END IF;
1753:
1754: CLOSE process_cursor;

Line 1813: fnd_message.set_name ('CSF',

1809: THEN
1810: IF l_flag = 'C' AND trim(p_postal_code) <> '_' AND
1811: trim (p_city) <> '_'
1812: THEN
1813: fnd_message.set_name ('CSF',
1814: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1815: );
1816: fnd_message.set_token ('ZIP', p_postal_code);
1817: fnd_message.set_token ('CITY', p_city);

Line 1816: fnd_message.set_token ('ZIP', p_postal_code);

1812: THEN
1813: fnd_message.set_name ('CSF',
1814: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1815: );
1816: fnd_message.set_token ('ZIP', p_postal_code);
1817: fnd_message.set_token ('CITY', p_city);
1818: x_error := fnd_message.get;
1819: x_error_detail := x_error_detail || ' ' || x_error;
1820: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND

Line 1817: fnd_message.set_token ('CITY', p_city);

1813: fnd_message.set_name ('CSF',
1814: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1815: );
1816: fnd_message.set_token ('ZIP', p_postal_code);
1817: fnd_message.set_token ('CITY', p_city);
1818: x_error := fnd_message.get;
1819: x_error_detail := x_error_detail || ' ' || x_error;
1820: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
1821: trim (p_state) <> '_'

Line 1818: x_error := fnd_message.get;

1814: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1815: );
1816: fnd_message.set_token ('ZIP', p_postal_code);
1817: fnd_message.set_token ('CITY', p_city);
1818: x_error := fnd_message.get;
1819: x_error_detail := x_error_detail || ' ' || x_error;
1820: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
1821: trim (p_state) <> '_'
1822: THEN

Line 1823: fnd_message.set_name ('CSF',

1819: x_error_detail := x_error_detail || ' ' || x_error;
1820: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
1821: trim (p_state) <> '_'
1822: THEN
1823: fnd_message.set_name ('CSF',
1824: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1825: );
1826: fnd_message.set_token ('ZIP', p_postal_code);
1827: fnd_message.set_token ('STATE', p_state);

Line 1826: fnd_message.set_token ('ZIP', p_postal_code);

1822: THEN
1823: fnd_message.set_name ('CSF',
1824: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1825: );
1826: fnd_message.set_token ('ZIP', p_postal_code);
1827: fnd_message.set_token ('STATE', p_state);
1828: x_error := fnd_message.get;
1829: x_error_detail := x_error_detail || ' ' || x_error;
1830: ELSIF trim(p_postal_code) <> '_' AND

Line 1827: fnd_message.set_token ('STATE', p_state);

1823: fnd_message.set_name ('CSF',
1824: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1825: );
1826: fnd_message.set_token ('ZIP', p_postal_code);
1827: fnd_message.set_token ('STATE', p_state);
1828: x_error := fnd_message.get;
1829: x_error_detail := x_error_detail || ' ' || x_error;
1830: ELSIF trim(p_postal_code) <> '_' AND
1831: trim (p_country) <> '_'

Line 1828: x_error := fnd_message.get;

1824: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1825: );
1826: fnd_message.set_token ('ZIP', p_postal_code);
1827: fnd_message.set_token ('STATE', p_state);
1828: x_error := fnd_message.get;
1829: x_error_detail := x_error_detail || ' ' || x_error;
1830: ELSIF trim(p_postal_code) <> '_' AND
1831: trim (p_country) <> '_'
1832: THEN

Line 1833: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');

1829: x_error_detail := x_error_detail || ' ' || x_error;
1830: ELSIF trim(p_postal_code) <> '_' AND
1831: trim (p_country) <> '_'
1832: THEN
1833: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1834: fnd_message.set_token ('ZIP', p_postal_code);
1835: fnd_message.set_token ('COUNTRY', p_country);
1836: x_error := fnd_message.get;
1837: x_error_detail := x_error_detail || ' ' || x_error;

Line 1834: fnd_message.set_token ('ZIP', p_postal_code);

1830: ELSIF trim(p_postal_code) <> '_' AND
1831: trim (p_country) <> '_'
1832: THEN
1833: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1834: fnd_message.set_token ('ZIP', p_postal_code);
1835: fnd_message.set_token ('COUNTRY', p_country);
1836: x_error := fnd_message.get;
1837: x_error_detail := x_error_detail || ' ' || x_error;
1838: END IF;

Line 1835: fnd_message.set_token ('COUNTRY', p_country);

1831: trim (p_country) <> '_'
1832: THEN
1833: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1834: fnd_message.set_token ('ZIP', p_postal_code);
1835: fnd_message.set_token ('COUNTRY', p_country);
1836: x_error := fnd_message.get;
1837: x_error_detail := x_error_detail || ' ' || x_error;
1838: END IF;
1839: END IF;

Line 1836: x_error := fnd_message.get;

1832: THEN
1833: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1834: fnd_message.set_token ('ZIP', p_postal_code);
1835: fnd_message.set_token ('COUNTRY', p_country);
1836: x_error := fnd_message.get;
1837: x_error_detail := x_error_detail || ' ' || x_error;
1838: END IF;
1839: END IF;
1840: CLOSE process_cursor;

Line 1858: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');

1854: DECLARE
1855: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1856: BEGIN
1857:
1858: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1859: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1860: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1861: IF (l_exp_accuracy_level = '0')
1862: THEN

Line 1863: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

1859: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1860: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1861: IF (l_exp_accuracy_level = '0')
1862: THEN
1863: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1864: END IF;
1865: IF (l_exp_accuracy_level = '1')
1866: THEN
1867: fnd_message.set_token ('ACCURACY','street level accuracy');

Line 1867: fnd_message.set_token ('ACCURACY','street level accuracy');

1863: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1864: END IF;
1865: IF (l_exp_accuracy_level = '1')
1866: THEN
1867: fnd_message.set_token ('ACCURACY','street level accuracy');
1868: END IF;
1869: IF (l_exp_accuracy_level = '2')
1870: THEN
1871: fnd_message.set_token ('ACCURACY','building number level accuracy');

Line 1871: fnd_message.set_token ('ACCURACY','building number level accuracy');

1867: fnd_message.set_token ('ACCURACY','street level accuracy');
1868: END IF;
1869: IF (l_exp_accuracy_level = '2')
1870: THEN
1871: fnd_message.set_token ('ACCURACY','building number level accuracy');
1872: END IF;
1873: x_error := fnd_message.get;
1874: x_error_detail := x_error_detail || ' ' || x_error;
1875:

Line 1873: x_error := fnd_message.get;

1869: IF (l_exp_accuracy_level = '2')
1870: THEN
1871: fnd_message.set_token ('ACCURACY','building number level accuracy');
1872: END IF;
1873: x_error := fnd_message.get;
1874: x_error_detail := x_error_detail || ' ' || x_error;
1875:
1876: END;
1877: -- Enhancement Code ends here

Line 1979: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');

1975: INTO l_timezone_id;
1976:
1977: IF l_timezone_id IS NULL
1978: THEN
1979: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
1980: fnd_msg_pub.add_detail ();
1981: RAISE fnd_api.g_exc_error;
1982: END IF;
1983:

Line 2040: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');

2036: THEN
2037: x_result := g_valid_true;
2038: ELSE
2039: x_result := g_valid_false;
2040: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2041: fnd_message.set_token ('LOCATION_ID', p_location_id);
2042: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2043: fnd_msg_pub.add_detail ();*/
2044: -- Added for Bug 7571215

Line 2041: fnd_message.set_token ('LOCATION_ID', p_location_id);

2037: x_result := g_valid_true;
2038: ELSE
2039: x_result := g_valid_false;
2040: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2041: fnd_message.set_token ('LOCATION_ID', p_location_id);
2042: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2043: fnd_msg_pub.add_detail ();*/
2044: -- Added for Bug 7571215
2045: get_error_detail (

Line 2042: fnd_message.set_token ('RETURN_STATUS', x_return_status);

2038: ELSE
2039: x_result := g_valid_false;
2040: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2041: fnd_message.set_token ('LOCATION_ID', p_location_id);
2042: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2043: fnd_msg_pub.add_detail ();*/
2044: -- Added for Bug 7571215
2045: get_error_detail (
2046: p_api_version => 1.0,

Line 2266: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');

2262: );
2263:
2264: IF p_validated_flag = g_valid_true
2265: THEN
2266: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2267: l_short_msg := fnd_message.get;
2268: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2269: l_long_msg := fnd_message.get;
2270: END IF;

Line 2267: l_short_msg := fnd_message.get;

2263:
2264: IF p_validated_flag = g_valid_true
2265: THEN
2266: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2267: l_short_msg := fnd_message.get;
2268: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2269: l_long_msg := fnd_message.get;
2270: END IF;
2271:

Line 2268: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');

2264: IF p_validated_flag = g_valid_true
2265: THEN
2266: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2267: l_short_msg := fnd_message.get;
2268: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2269: l_long_msg := fnd_message.get;
2270: END IF;
2271:
2272: IF p_override_flag = g_valid_true

Line 2269: l_long_msg := fnd_message.get;

2265: THEN
2266: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2267: l_short_msg := fnd_message.get;
2268: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2269: l_long_msg := fnd_message.get;
2270: END IF;
2271:
2272: IF p_override_flag = g_valid_true
2273: THEN

Line 2274: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');

2270: END IF;
2271:
2272: IF p_override_flag = g_valid_true
2273: THEN
2274: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2275: l_short_msg := fnd_message.get;
2276: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2277: l_long_msg := fnd_message.get;
2278: END IF;

Line 2275: l_short_msg := fnd_message.get;

2271:
2272: IF p_override_flag = g_valid_true
2273: THEN
2274: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2275: l_short_msg := fnd_message.get;
2276: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2277: l_long_msg := fnd_message.get;
2278: END IF;
2279:

Line 2276: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');

2272: IF p_override_flag = g_valid_true
2273: THEN
2274: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2275: l_short_msg := fnd_message.get;
2276: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2277: l_long_msg := fnd_message.get;
2278: END IF;
2279:
2280: csf_locations_pkg.update_row_ext

Line 2277: l_long_msg := fnd_message.get;

2273: THEN
2274: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2275: l_short_msg := fnd_message.get;
2276: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2277: l_long_msg := fnd_message.get;
2278: END IF;
2279:
2280: csf_locations_pkg.update_row_ext
2281: (p_csf_ext_location_id => p_location_id,