DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on FND_MESSAGE

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

103: BEGIN
104: -- Initialize message list
105: fnd_msg_pub.initialize;
106: -- get termination messages
107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');

Line 108: l_msg_succ := fnd_message.get;

104: -- Initialize message list
105: fnd_msg_pub.initialize;
106: -- get termination messages
107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
112: l_msg_err := fnd_message.get;

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

105: fnd_msg_pub.initialize;
106: -- get termination messages
107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
112: l_msg_err := fnd_message.get;
113: -- Initialize API return status to success

Line 110: l_msg_warn := fnd_message.get;

106: -- get termination messages
107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
112: l_msg_err := fnd_message.get;
113: -- Initialize API return status to success
114: retcode := l_rc_succ;

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

107: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
112: l_msg_err := fnd_message.get;
113: -- Initialize API return status to success
114: retcode := l_rc_succ;
115: errbuf := l_msg_succ;

Line 112: l_msg_err := fnd_message.get;

108: l_msg_succ := fnd_message.get;
109: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
110: l_msg_warn := fnd_message.get;
111: fnd_message.set_name ('CSF', 'CSF_GST_DONE_ERR');
112: l_msg_err := fnd_message.get;
113: -- Initialize API return status to success
114: retcode := l_rc_succ;
115: errbuf := l_msg_succ;
116: -- API body

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

113: -- Initialize API return status to success
114: retcode := l_rc_succ;
115: errbuf := l_msg_succ;
116: -- API body
117: fnd_message.set_name ('CSF', 'CSF_FIND_INVALID_ADDRESS');
118: l_msg_data := fnd_message.get;
119: put_stream (g_output, l_msg_data);
120:
121: --

Line 118: l_msg_data := fnd_message.get;

114: retcode := l_rc_succ;
115: errbuf := l_msg_succ;
116: -- API body
117: fnd_message.set_name ('CSF', 'CSF_FIND_INVALID_ADDRESS');
118: l_msg_data := fnd_message.get;
119: put_stream (g_output, l_msg_data);
120:
121: --
122: -- start date defaults to today (truncated)

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

161: END IF;
162:
163: --
164: -- feedback the date range
165: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
166: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
167: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
168: put_stream (g_output, fnd_message.get);
169: --

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

162:
163: --
164: -- feedback the date range
165: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
166: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
167: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
168: put_stream (g_output, fnd_message.get);
169: --
170: -- finally convert the date range to server timezone before processing

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

163: --
164: -- feedback the date range
165: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
166: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
167: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
168: put_stream (g_output, fnd_message.get);
169: --
170: -- finally convert the date range to server timezone before processing
171: --

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

164: -- feedback the date range
165: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_DATE_RANGE');
166: fnd_message.set_token ('P_START_DATE', TO_CHAR (l_start_date, l_fmt));
167: fnd_message.set_token ('P_END_DATE', TO_CHAR (l_end_date, l_fmt));
168: put_stream (g_output, fnd_message.get);
169: --
170: -- finally convert the date range to server timezone before processing
171: --
172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);

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

185: );
186:
187: IF l_return_status <> fnd_api.g_ret_sts_success
188: THEN
189: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
190: l_msg_data := fnd_message.get;
191: put_stream (g_log, l_msg_data);
192: RAISE fnd_api.g_exc_error;
193: END IF;

Line 190: l_msg_data := fnd_message.get;

186:
187: IF l_return_status <> fnd_api.g_ret_sts_success
188: THEN
189: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
190: l_msg_data := fnd_message.get;
191: put_stream (g_log, l_msg_data);
192: RAISE fnd_api.g_exc_error;
193: END IF;
194:

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

277: then
278: csf_lf_geopvt.move_invalid_to_geo_batch(l_task_rec);
279: update_geometry (l_task_rec.location_id);
280: l_dup_msg_data := l_msg_data;
281: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
282: fnd_message.set_token ('RETURN_STATUS', l_return_status);
283: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
284: l_msg_data := fnd_message.get;
285: put_stream (g_log, l_msg_data);

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

278: csf_lf_geopvt.move_invalid_to_geo_batch(l_task_rec);
279: update_geometry (l_task_rec.location_id);
280: l_dup_msg_data := l_msg_data;
281: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
282: fnd_message.set_token ('RETURN_STATUS', l_return_status);
283: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
284: l_msg_data := fnd_message.get;
285: put_stream (g_log, l_msg_data);
286: l_task_rec.validated_flag := g_valid_false;

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

279: update_geometry (l_task_rec.location_id);
280: l_dup_msg_data := l_msg_data;
281: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
282: fnd_message.set_token ('RETURN_STATUS', l_return_status);
283: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
284: l_msg_data := fnd_message.get;
285: put_stream (g_log, l_msg_data);
286: l_task_rec.validated_flag := g_valid_false;
287: l_task_rec.override_flag := g_valid_false;

Line 284: l_msg_data := fnd_message.get;

280: l_dup_msg_data := l_msg_data;
281: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
282: fnd_message.set_token ('RETURN_STATUS', l_return_status);
283: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
284: l_msg_data := fnd_message.get;
285: put_stream (g_log, l_msg_data);
286: l_task_rec.validated_flag := g_valid_false;
287: l_task_rec.override_flag := g_valid_false;
288: /*log_info (p_api_version => 1.0,

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

304: x_msg_data => l_msg_data,
305: x_dup_msg_data => l_dup_msg_data );
306: IF l_return_status <> fnd_api.g_ret_sts_success
307: THEN
308: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
309: fnd_message.set_token ('LOCATION_ID',
310: l_task_rec.location_id
311: );
312: fnd_message.set_token ('RETURN_STATUS', l_return_status);

Line 309: fnd_message.set_token ('LOCATION_ID',

305: x_dup_msg_data => l_dup_msg_data );
306: IF l_return_status <> fnd_api.g_ret_sts_success
307: THEN
308: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
309: fnd_message.set_token ('LOCATION_ID',
310: l_task_rec.location_id
311: );
312: fnd_message.set_token ('RETURN_STATUS', l_return_status);
313: l_msg_data := fnd_message.get;

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

308: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
309: fnd_message.set_token ('LOCATION_ID',
310: l_task_rec.location_id
311: );
312: fnd_message.set_token ('RETURN_STATUS', l_return_status);
313: l_msg_data := fnd_message.get;
314: put_stream (g_log, l_msg_data);
315: put_stream (g_output, l_msg_data);
316: RAISE fnd_api.g_exc_error;

Line 313: l_msg_data := fnd_message.get;

309: fnd_message.set_token ('LOCATION_ID',
310: l_task_rec.location_id
311: );
312: fnd_message.set_token ('RETURN_STATUS', l_return_status);
313: l_msg_data := fnd_message.get;
314: put_stream (g_log, l_msg_data);
315: put_stream (g_output, l_msg_data);
316: RAISE fnd_api.g_exc_error;
317: END IF;

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

329: x_msg_data => l_msg_data
330: );
331: IF l_return_status <> fnd_api.g_ret_sts_success
332: THEN
333: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
334: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
335: fnd_message.set_token ('RETURN_STATUS', l_return_status);
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);

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

330: );
331: IF l_return_status <> fnd_api.g_ret_sts_success
332: THEN
333: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
334: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
335: fnd_message.set_token ('RETURN_STATUS', l_return_status);
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);
338: put_stream (g_output, l_msg_data);

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

331: IF l_return_status <> fnd_api.g_ret_sts_success
332: THEN
333: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
334: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
335: fnd_message.set_token ('RETURN_STATUS', l_return_status);
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);
338: put_stream (g_output, l_msg_data);
339: RAISE fnd_api.g_exc_error;

Line 336: l_msg_data := fnd_message.get;

332: THEN
333: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
334: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
335: fnd_message.set_token ('RETURN_STATUS', l_return_status);
336: l_msg_data := fnd_message.get;
337: put_stream (g_log, l_msg_data);
338: put_stream (g_output, l_msg_data);
339: RAISE fnd_api.g_exc_error;
340: END IF;

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

341: END IF; -- resolve_address
342: /* ELSE -- l_Time_zone_check false
343: update_geometry (l_task_rec.location_id);
344: l_return_status := fnd_api.g_ret_sts_unexp_error;
345: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
346: fnd_message.set_token ('RETURN_STATUS', l_return_status);
347: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
348: log_info (p_api_version => 1.0,
349: p_init_msg_list => fnd_api.g_false,

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

342: /* ELSE -- l_Time_zone_check false
343: update_geometry (l_task_rec.location_id);
344: l_return_status := fnd_api.g_ret_sts_unexp_error;
345: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
346: fnd_message.set_token ('RETURN_STATUS', l_return_status);
347: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
348: log_info (p_api_version => 1.0,
349: p_init_msg_list => fnd_api.g_false,
350: p_commit => fnd_api.g_true,

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

343: update_geometry (l_task_rec.location_id);
344: l_return_status := fnd_api.g_ret_sts_unexp_error;
345: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
346: fnd_message.set_token ('RETURN_STATUS', l_return_status);
347: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
348: log_info (p_api_version => 1.0,
349: p_init_msg_list => fnd_api.g_false,
350: p_commit => fnd_api.g_true,
351: p_validation_level => fnd_api.g_valid_level_full,

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

356: );
357:
358: IF l_return_status <> fnd_api.g_ret_sts_success
359: THEN
360: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
361: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
362: fnd_message.set_token ('RETURN_STATUS', l_return_status);
363: l_msg_data := fnd_message.get;
364: put_stream (g_log, l_msg_data);

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

357:
358: IF l_return_status <> fnd_api.g_ret_sts_success
359: THEN
360: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
361: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
362: fnd_message.set_token ('RETURN_STATUS', l_return_status);
363: l_msg_data := fnd_message.get;
364: put_stream (g_log, l_msg_data);
365: put_stream (g_output, l_msg_data);

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

358: IF l_return_status <> fnd_api.g_ret_sts_success
359: THEN
360: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
361: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
362: fnd_message.set_token ('RETURN_STATUS', l_return_status);
363: l_msg_data := fnd_message.get;
364: put_stream (g_log, l_msg_data);
365: put_stream (g_output, l_msg_data);
366: RAISE fnd_api.g_exc_error;

Line 363: l_msg_data := fnd_message.get;

359: THEN
360: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
361: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
362: fnd_message.set_token ('RETURN_STATUS', l_return_status);
363: l_msg_data := fnd_message.get;
364: put_stream (g_log, l_msg_data);
365: put_stream (g_output, l_msg_data);
366: RAISE fnd_api.g_exc_error;
367: END IF;

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

370: i := l_task_rec_tbl.NEXT (i);
371: END LOOP;
372: ELSIF l_task_rec_tbl.COUNT = 0
373: THEN
374: fnd_message.set_name ('CSF', 'CSF_NO_DATA_TOPROCESS');
375: l_msg_data := fnd_message.get;
376: put_stream (g_log, l_msg_data);
377: END IF;
378:

Line 375: l_msg_data := fnd_message.get;

371: END LOOP;
372: ELSIF l_task_rec_tbl.COUNT = 0
373: THEN
374: fnd_message.set_name ('CSF', 'CSF_NO_DATA_TOPROCESS');
375: l_msg_data := fnd_message.get;
376: put_stream (g_log, l_msg_data);
377: END IF;
378:
379: put_stream (g_log, l_msg_succ);

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

457:
458: -- Initialize API return status to success
459: x_return_status := fnd_api.g_ret_sts_success;
460: -- API body
461: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);

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

458: -- Initialize API return status to success
459: x_return_status := fnd_api.g_ret_sts_success;
460: -- API body
461: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);

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

459: x_return_status := fnd_api.g_ret_sts_success;
460: -- API body
461: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);

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

460: -- API body
461: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);

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

461: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);
469: l_msg_data := fnd_message.get;

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

462: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);
469: l_msg_data := fnd_message.get;
470: put_stream (g_log, l_msg_data);

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

463: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);
469: l_msg_data := fnd_message.get;
470: put_stream (g_log, l_msg_data);
471: put_stream (g_output, l_msg_data);

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

464: fnd_message.set_token ('CITY', p_task_rec.city);
465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);
469: l_msg_data := fnd_message.get;
470: put_stream (g_log, l_msg_data);
471: put_stream (g_output, l_msg_data);
472:

Line 469: l_msg_data := fnd_message.get;

465: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
466: fnd_message.set_token ('COUNTY', p_task_rec.county);
467: fnd_message.set_token ('STATE', p_task_rec.state);
468: fnd_message.set_token ('COUNTRY', p_task_rec.country);
469: l_msg_data := fnd_message.get;
470: put_stream (g_log, l_msg_data);
471: put_stream (g_output, l_msg_data);
472:
473: IF l_location_id IS NULL

Line 495: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');

491: CLOSE c_check_ext_locations;
492: END;
493:
494: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
495: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
496: l_error := fnd_message.get;
497: l_error_detail := l_error;
498: put_stream (g_output, l_error_detail);
499: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then

Line 496: l_error := fnd_message.get;

492: END;
493:
494: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
495: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
496: l_error := fnd_message.get;
497: l_error_detail := l_error;
498: put_stream (g_output, l_error_detail);
499: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
500: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');

Line 500: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');

496: l_error := fnd_message.get;
497: l_error_detail := l_error;
498: put_stream (g_output, l_error_detail);
499: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
500: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
501: l_error := fnd_message.get;
502: l_error_detail := l_error;
503: put_stream (g_output, l_error_detail);
504: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then

Line 501: l_error := fnd_message.get;

497: l_error_detail := l_error;
498: put_stream (g_output, l_error_detail);
499: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
500: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
501: l_error := fnd_message.get;
502: l_error_detail := l_error;
503: put_stream (g_output, l_error_detail);
504: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
505: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');

Line 505: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');

501: l_error := fnd_message.get;
502: l_error_detail := l_error;
503: put_stream (g_output, l_error_detail);
504: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
505: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
506: l_error := fnd_message.get;
507: l_error_detail := l_error;
508: put_stream (g_output, l_error_detail);
509: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then

Line 506: l_error := fnd_message.get;

502: l_error_detail := l_error;
503: put_stream (g_output, l_error_detail);
504: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
505: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
506: l_error := fnd_message.get;
507: l_error_detail := l_error;
508: put_stream (g_output, l_error_detail);
509: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
510: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');

Line 510: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');

506: l_error := fnd_message.get;
507: l_error_detail := l_error;
508: put_stream (g_output, l_error_detail);
509: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
510: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
511: l_error := fnd_message.get;
512: l_error_detail := l_error;
513: put_stream (g_output, l_error_detail);
514: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then

Line 511: l_error := fnd_message.get;

507: l_error_detail := l_error;
508: put_stream (g_output, l_error_detail);
509: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
510: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
511: l_error := fnd_message.get;
512: l_error_detail := l_error;
513: put_stream (g_output, l_error_detail);
514: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
515: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');

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

511: l_error := fnd_message.get;
512: l_error_detail := l_error;
513: put_stream (g_output, l_error_detail);
514: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
515: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
516: fnd_message.set_token ('COUNTRY', p_task_rec.country);
517: l_error := fnd_message.get;
518: l_error_detail := l_error;
519: put_stream (g_output, l_error_detail);

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

512: l_error_detail := l_error;
513: put_stream (g_output, l_error_detail);
514: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
515: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
516: fnd_message.set_token ('COUNTRY', p_task_rec.country);
517: l_error := fnd_message.get;
518: l_error_detail := l_error;
519: put_stream (g_output, l_error_detail);
520: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then

Line 517: l_error := fnd_message.get;

513: put_stream (g_output, l_error_detail);
514: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
515: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
516: fnd_message.set_token ('COUNTRY', p_task_rec.country);
517: l_error := fnd_message.get;
518: l_error_detail := l_error;
519: put_stream (g_output, l_error_detail);
520: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
521: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');

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

517: l_error := fnd_message.get;
518: l_error_detail := l_error;
519: put_stream (g_output, l_error_detail);
520: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
521: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
522: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
523: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
524: if (l_exp_accuracy_level = '0') then
525: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

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

521: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
522: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
523: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
524: if (l_exp_accuracy_level = '0') then
525: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
526: end if;
527: if (l_exp_accuracy_level = '1') then
528: fnd_message.set_token ('ACCURACY','street level accuracy');
529: end if;

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

524: if (l_exp_accuracy_level = '0') then
525: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
526: end if;
527: if (l_exp_accuracy_level = '1') then
528: fnd_message.set_token ('ACCURACY','street level accuracy');
529: end if;
530: if (l_exp_accuracy_level = '2') then
531: fnd_message.set_token ('ACCURACY','building number level accuracy');
532: end if;

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

527: if (l_exp_accuracy_level = '1') then
528: fnd_message.set_token ('ACCURACY','street level accuracy');
529: end if;
530: if (l_exp_accuracy_level = '2') then
531: fnd_message.set_token ('ACCURACY','building number level accuracy');
532: end if;
533: l_error := fnd_message.get;
534: --x_error_detail := x_error_detail || ' ' || x_error;
535: l_error_detail := l_error;

Line 533: l_error := fnd_message.get;

529: end if;
530: if (l_exp_accuracy_level = '2') then
531: fnd_message.set_token ('ACCURACY','building number level accuracy');
532: end if;
533: l_error := fnd_message.get;
534: --x_error_detail := x_error_detail || ' ' || x_error;
535: l_error_detail := l_error;
536: put_stream (g_output, l_error_detail);
537: end if;

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

551: );
552:
553: IF x_return_status <> fnd_api.g_ret_sts_success
554: THEN
555: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
556: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
557: fnd_message.set_token ('RETURN_STATUS', x_return_status);
558: l_msg_data := fnd_message.get;
559: put_stream (g_log, l_msg_data);

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

552:
553: IF x_return_status <> fnd_api.g_ret_sts_success
554: THEN
555: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
556: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
557: fnd_message.set_token ('RETURN_STATUS', x_return_status);
558: l_msg_data := fnd_message.get;
559: put_stream (g_log, l_msg_data);
560: put_stream (g_output, l_msg_data);

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

553: IF x_return_status <> fnd_api.g_ret_sts_success
554: THEN
555: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
556: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
557: fnd_message.set_token ('RETURN_STATUS', x_return_status);
558: l_msg_data := fnd_message.get;
559: put_stream (g_log, l_msg_data);
560: put_stream (g_output, l_msg_data);
561: END IF;

Line 558: l_msg_data := fnd_message.get;

554: THEN
555: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
556: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
557: fnd_message.set_token ('RETURN_STATUS', x_return_status);
558: l_msg_data := fnd_message.get;
559: put_stream (g_log, l_msg_data);
560: put_stream (g_output, l_msg_data);
561: END IF;
562:

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

561: END IF;
562:
563: IF l_error IS NULL
564: THEN
565: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
566: l_error := fnd_message.get;
567: END IF;
568:
569: IF l_error_detail IS NULL

Line 566: l_error := fnd_message.get;

562:
563: IF l_error IS NULL
564: THEN
565: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
566: l_error := fnd_message.get;
567: END IF;
568:
569: IF l_error_detail IS NULL
570: THEN

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

567: END IF;
568:
569: IF l_error_detail IS NULL
570: THEN
571: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
572: l_error_detail := fnd_message.get;
573: END IF;
574: */
575:

Line 572: l_error_detail := fnd_message.get;

568:
569: IF l_error_detail IS NULL
570: THEN
571: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
572: l_error_detail := fnd_message.get;
573: END IF;
574: */
575:
576: IF l_task_id IS NULL

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

1362: INTO l_tmp;
1363:
1364: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1365: THEN
1366: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1367: fnd_message.set_token ('CITY', p_task_rec.city);
1368: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1369: x_error := fnd_message.get;
1370: x_error_detail := x_error_detail || ' ' || x_error;

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

1363:
1364: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1365: THEN
1366: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1367: fnd_message.set_token ('CITY', p_task_rec.city);
1368: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1369: x_error := fnd_message.get;
1370: x_error_detail := x_error_detail || ' ' || x_error;
1371: END IF;

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

1364: IF l_tmp IS NULL AND trim(p_task_rec.city) <> '_'
1365: THEN
1366: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1367: fnd_message.set_token ('CITY', p_task_rec.city);
1368: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1369: x_error := fnd_message.get;
1370: x_error_detail := x_error_detail || ' ' || x_error;
1371: END IF;
1372:

Line 1369: x_error := fnd_message.get;

1365: THEN
1366: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1367: fnd_message.set_token ('CITY', p_task_rec.city);
1368: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1369: x_error := fnd_message.get;
1370: x_error_detail := x_error_detail || ' ' || x_error;
1371: END IF;
1372:
1373: CLOSE process_cursor;

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

1392: INTO l_tmp;
1393:
1394: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1395: THEN
1396: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1397: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1398: x_error := fnd_message.get;
1399: x_error_detail := x_error_detail || ' ' || x_error;
1400: END IF;

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

1393:
1394: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1395: THEN
1396: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1397: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1398: x_error := fnd_message.get;
1399: x_error_detail := x_error_detail || ' ' || x_error;
1400: END IF;
1401:

Line 1398: x_error := fnd_message.get;

1394: IF l_tmp IS NULL AND trim(p_task_rec.country) <> '_'
1395: THEN
1396: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1397: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1398: x_error := fnd_message.get;
1399: x_error_detail := x_error_detail || ' ' || x_error;
1400: END IF;
1401:
1402: CLOSE process_cursor;

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

1420: INTO l_tmp;
1421:
1422: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1423: THEN
1424: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1425: fnd_message.set_token ('STATE', p_task_rec.state);
1426: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1427: x_error := fnd_message.get;
1428: x_error_detail := x_error_detail || ' ' || x_error;

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

1421:
1422: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1423: THEN
1424: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1425: fnd_message.set_token ('STATE', p_task_rec.state);
1426: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1427: x_error := fnd_message.get;
1428: x_error_detail := x_error_detail || ' ' || x_error;
1429: END IF;

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

1422: IF l_tmp IS NULL AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.country) <> '_'
1423: THEN
1424: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1425: fnd_message.set_token ('STATE', p_task_rec.state);
1426: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1427: x_error := fnd_message.get;
1428: x_error_detail := x_error_detail || ' ' || x_error;
1429: END IF;
1430:

Line 1427: x_error := fnd_message.get;

1423: THEN
1424: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
1425: fnd_message.set_token ('STATE', p_task_rec.state);
1426: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1427: x_error := fnd_message.get;
1428: x_error_detail := x_error_detail || ' ' || x_error;
1429: END IF;
1430:
1431: CLOSE process_cursor;

Line 1483: fnd_message.set_name ('CSF',

1479: IF l_tmp IS NULL
1480: THEN
1481: IF l_flag = 'S' AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.city) <> '_'
1482: THEN
1483: fnd_message.set_name ('CSF',
1484: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1485: fnd_message.set_token ('CITY', p_task_rec.city);
1486: fnd_message.set_token ('STATE', p_task_rec.state);
1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'

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

1481: IF l_flag = 'S' AND trim(p_task_rec.state) <> '_' AND trim(p_task_rec.city) <> '_'
1482: THEN
1483: fnd_message.set_name ('CSF',
1484: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1485: fnd_message.set_token ('CITY', p_task_rec.city);
1486: fnd_message.set_token ('STATE', p_task_rec.state);
1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1488: THEN
1489: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

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

1482: THEN
1483: fnd_message.set_name ('CSF',
1484: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
1485: fnd_message.set_token ('CITY', p_task_rec.city);
1486: fnd_message.set_token ('STATE', p_task_rec.state);
1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1488: THEN
1489: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1490: fnd_message.set_token ('CITY', p_task_rec.city);

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

1485: fnd_message.set_token ('CITY', p_task_rec.city);
1486: fnd_message.set_token ('STATE', p_task_rec.state);
1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1488: THEN
1489: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1490: fnd_message.set_token ('CITY', p_task_rec.city);
1491: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1492: END IF;
1493:

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

1486: fnd_message.set_token ('STATE', p_task_rec.state);
1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1488: THEN
1489: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1490: fnd_message.set_token ('CITY', p_task_rec.city);
1491: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1492: END IF;
1493:
1494: x_error := fnd_message.get;

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

1487: ELSIF trim(p_task_rec.country) <> '_' AND trim(p_task_rec.city) <> '_'
1488: THEN
1489: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
1490: fnd_message.set_token ('CITY', p_task_rec.city);
1491: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1492: END IF;
1493:
1494: x_error := fnd_message.get;
1495: x_error_detail := x_error_detail || ' ' || x_error;

Line 1494: x_error := fnd_message.get;

1490: fnd_message.set_token ('CITY', p_task_rec.city);
1491: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1492: END IF;
1493:
1494: x_error := fnd_message.get;
1495: x_error_detail := x_error_detail || ' ' || x_error;
1496: END IF;
1497:
1498: CLOSE process_cursor;

Line 1556: fnd_message.set_name ('CSF',

1552: IF l_tmp IS NULL
1553: THEN
1554: IF l_flag = 'C' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.city) <> '_'
1555: THEN
1556: fnd_message.set_name ('CSF',
1557: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1558: );
1559: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1560: fnd_message.set_token ('CITY', p_task_rec.city);

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

1555: THEN
1556: fnd_message.set_name ('CSF',
1557: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1558: );
1559: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1560: fnd_message.set_token ('CITY', p_task_rec.city);
1561: x_error := fnd_message.get;
1562: x_error_detail := x_error_detail || ' ' || x_error;
1563: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'

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

1556: fnd_message.set_name ('CSF',
1557: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1558: );
1559: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1560: fnd_message.set_token ('CITY', p_task_rec.city);
1561: x_error := fnd_message.get;
1562: x_error_detail := x_error_detail || ' ' || x_error;
1563: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1564: THEN

Line 1561: x_error := fnd_message.get;

1557: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
1558: );
1559: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1560: fnd_message.set_token ('CITY', p_task_rec.city);
1561: x_error := fnd_message.get;
1562: x_error_detail := x_error_detail || ' ' || x_error;
1563: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1564: THEN
1565: fnd_message.set_name ('CSF',

Line 1565: fnd_message.set_name ('CSF',

1561: x_error := fnd_message.get;
1562: x_error_detail := x_error_detail || ' ' || x_error;
1563: ELSIF l_flag = 'S' AND trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.state) <> '_'
1564: THEN
1565: fnd_message.set_name ('CSF',
1566: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1567: );
1568: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1569: fnd_message.set_token ('STATE', p_task_rec.state);

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

1564: THEN
1565: fnd_message.set_name ('CSF',
1566: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1567: );
1568: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1569: fnd_message.set_token ('STATE', p_task_rec.state);
1570: x_error := fnd_message.get;
1571: x_error_detail := x_error_detail || ' ' || x_error;
1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'

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

1565: fnd_message.set_name ('CSF',
1566: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1567: );
1568: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1569: fnd_message.set_token ('STATE', p_task_rec.state);
1570: x_error := fnd_message.get;
1571: x_error_detail := x_error_detail || ' ' || x_error;
1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1573: THEN

Line 1570: x_error := fnd_message.get;

1566: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
1567: );
1568: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1569: fnd_message.set_token ('STATE', p_task_rec.state);
1570: x_error := fnd_message.get;
1571: x_error_detail := x_error_detail || ' ' || x_error;
1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1573: THEN
1574: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');

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

1570: x_error := fnd_message.get;
1571: x_error_detail := x_error_detail || ' ' || x_error;
1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1573: THEN
1574: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1575: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1576: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1577: x_error := fnd_message.get;
1578: x_error_detail := x_error_detail || ' ' || x_error;

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

1571: x_error_detail := x_error_detail || ' ' || x_error;
1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1573: THEN
1574: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1575: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1576: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1577: x_error := fnd_message.get;
1578: x_error_detail := x_error_detail || ' ' || x_error;
1579: END IF;

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

1572: ELSIF trim(p_task_rec.postal_code) <> '_' AND trim (p_task_rec.country) <> '_'
1573: THEN
1574: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1575: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1576: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1577: x_error := fnd_message.get;
1578: x_error_detail := x_error_detail || ' ' || x_error;
1579: END IF;
1580: END IF;

Line 1577: x_error := fnd_message.get;

1573: THEN
1574: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
1575: fnd_message.set_token ('ZIP', p_task_rec.postal_code);
1576: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1577: x_error := fnd_message.get;
1578: x_error_detail := x_error_detail || ' ' || x_error;
1579: END IF;
1580: END IF;
1581: CLOSE process_cursor;

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

1595: DECLARE
1596: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1597: BEGIN
1598:
1599: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1600: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1601: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1602: IF (l_exp_accuracy_level = '0')
1603: THEN

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

1600: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1601: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1602: IF (l_exp_accuracy_level = '0')
1603: THEN
1604: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1605: END IF;
1606: IF (l_exp_accuracy_level = '1')
1607: THEN
1608: fnd_message.set_token ('ACCURACY','street level accuracy');

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

1604: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1605: END IF;
1606: IF (l_exp_accuracy_level = '1')
1607: THEN
1608: fnd_message.set_token ('ACCURACY','street level accuracy');
1609: END IF;
1610: IF (l_exp_accuracy_level = '2')
1611: THEN
1612: fnd_message.set_token ('ACCURACY','building number level accuracy');

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

1608: fnd_message.set_token ('ACCURACY','street level accuracy');
1609: END IF;
1610: IF (l_exp_accuracy_level = '2')
1611: THEN
1612: fnd_message.set_token ('ACCURACY','building number level accuracy');
1613: END IF;
1614: x_error := fnd_message.get;
1615: x_error_detail := x_error_detail || ' ' || x_error;
1616:

Line 1614: x_error := fnd_message.get;

1610: IF (l_exp_accuracy_level = '2')
1611: THEN
1612: fnd_message.set_token ('ACCURACY','building number level accuracy');
1613: END IF;
1614: x_error := fnd_message.get;
1615: x_error_detail := x_error_detail || ' ' || x_error;
1616:
1617: END;
1618: -- Enhancement Code ends here

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

1692:
1693: -- Initialize API return status to success
1694: x_return_status := fnd_api.g_ret_sts_success;
1695: -- API body
1696: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);

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

1693: -- Initialize API return status to success
1694: x_return_status := fnd_api.g_ret_sts_success;
1695: -- API body
1696: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);

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

1694: x_return_status := fnd_api.g_ret_sts_success;
1695: -- API body
1696: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);

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

1695: -- API body
1696: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);

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

1696: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1704: l_msg_data := fnd_message.get;

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

1697: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1704: l_msg_data := fnd_message.get;
1705: put_stream (g_log, l_msg_data);

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

1698: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1704: l_msg_data := fnd_message.get;
1705: put_stream (g_log, l_msg_data);
1706: put_stream (g_output, l_msg_data);

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

1699: fnd_message.set_token ('CITY', p_task_rec.city);
1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1704: l_msg_data := fnd_message.get;
1705: put_stream (g_log, l_msg_data);
1706: put_stream (g_output, l_msg_data);
1707:

Line 1704: l_msg_data := fnd_message.get;

1700: fnd_message.set_token ('POSTAL_CODE', p_task_rec.postal_code);
1701: fnd_message.set_token ('COUNTY', p_task_rec.county);
1702: fnd_message.set_token ('STATE', p_task_rec.state);
1703: fnd_message.set_token ('COUNTRY', p_task_rec.country);
1704: l_msg_data := fnd_message.get;
1705: put_stream (g_log, l_msg_data);
1706: put_stream (g_output, l_msg_data);
1707:
1708: IF l_location_id IS NULL

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

1739: );
1740:
1741: IF x_return_status <> fnd_api.g_ret_sts_success
1742: THEN
1743: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1744: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1745: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1746: l_msg_data := fnd_message.get;
1747: put_stream (g_log, l_msg_data);

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

1740:
1741: IF x_return_status <> fnd_api.g_ret_sts_success
1742: THEN
1743: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1744: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1745: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1746: l_msg_data := fnd_message.get;
1747: put_stream (g_log, l_msg_data);
1748: put_stream (g_output, l_msg_data);

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

1741: IF x_return_status <> fnd_api.g_ret_sts_success
1742: THEN
1743: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1744: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1745: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1746: l_msg_data := fnd_message.get;
1747: put_stream (g_log, l_msg_data);
1748: put_stream (g_output, l_msg_data);
1749: END IF;

Line 1746: l_msg_data := fnd_message.get;

1742: THEN
1743: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1744: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1745: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1746: l_msg_data := fnd_message.get;
1747: put_stream (g_log, l_msg_data);
1748: put_stream (g_output, l_msg_data);
1749: END IF;
1750:

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

1749: END IF;
1750:
1751: IF l_error IS NULL
1752: THEN
1753: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
1754: l_error := fnd_message.get;
1755: END IF;
1756:
1757: IF l_error_detail IS NULL

Line 1754: l_error := fnd_message.get;

1750:
1751: IF l_error IS NULL
1752: THEN
1753: fnd_message.set_name ('CSF', 'CSF_ADDRESS_INVALID_INFO');
1754: l_error := fnd_message.get;
1755: END IF;
1756:
1757: IF l_error_detail IS NULL
1758: THEN

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

1755: END IF;
1756:
1757: IF l_error_detail IS NULL
1758: THEN
1759: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
1760: l_error_detail := fnd_message.get;
1761: END IF;
1762:
1763: IF l_task_id IS NULL

Line 1760: l_error_detail := fnd_message.get;

1756:
1757: IF l_error_detail IS NULL
1758: THEN
1759: fnd_message.set_name ('CSF', 'CSF_NO_ADDRESS_ENTERED_ERROR');
1760: l_error_detail := fnd_message.get;
1761: END IF;
1762:
1763: IF l_task_id IS NULL
1764: THEN

Line 1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');

1892: THEN
1893: fnd_msg_pub.initialize;
1894: END IF;
1895: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
1897: x_error_detail := fnd_message.get;
1898: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;

Line 1897: x_error_detail := fnd_message.get;

1893: fnd_msg_pub.initialize;
1894: END IF;
1895: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
1897: x_error_detail := fnd_message.get;
1898: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;
1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then

Line 1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');

1895: if (x_dup_msg_data = 'CSF_LF 223634:CSF_LF_INVALID_ADDRESS_DETAILS') then
1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
1897: x_error_detail := fnd_message.get;
1898: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;
1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;

Line 1900: x_error_detail := fnd_message.get;

1896: fnd_message.set_name ('CSF', 'CSF_LF_INVALID_ADDRESS_DETAILS');
1897: x_error_detail := fnd_message.get;
1898: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;
1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;
1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then

Line 1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');

1898: elsif (x_dup_msg_data = 'CSF_LF 223632:CSF_LF_POSTAL_OR_STATE_NOT_RESOLVED') then
1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;
1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;
1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;

Line 1903: x_error_detail := fnd_message.get;

1899: fnd_message.set_name ('CSF', 'CSF_LF_ZIP_STATE_UNRESOLVED');
1900: x_error_detail := fnd_message.get;
1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;
1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then

Line 1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');

1901: elsif(x_dup_msg_data = 'CSF_LF 223633:CSF_LF_CITY_OR_STATE_NOT_RESOLVED') then
1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;
1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);

Line 1906: x_error_detail := fnd_message.get;

1902: fnd_message.set_name ('CSF', 'CSF_LF_CITY_STATE_UNRESOLVED');
1903: x_error_detail := fnd_message.get;
1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;

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

1904: elsif(x_dup_msg_data = 'CSF_LF 223630:CSF_LF_ELOC_ADDRESS_UNRESOLVED') then
1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;
1911: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');

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

1905: fnd_message.set_name ('CSF', 'CSF_LF_ELOC_ADDR_UNRESOLVED');
1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;
1911: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

Line 1910: x_error_detail := fnd_message.get;

1906: x_error_detail := fnd_message.get;
1907: elsif(x_dup_msg_data = 'CSF_LF 223602:CSF_LF_COUNTRY_NOT_RESOLVED') then
1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;
1911: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1914: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');

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

1908: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;
1911: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1914: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1915: IF (l_exp_accuracy_level = '0') THEN
1916: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

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

1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1914: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1915: IF (l_exp_accuracy_level = '0') THEN
1916: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1917: END IF;
1918: IF (l_exp_accuracy_level = '1') THEN
1919: fnd_message.set_token ('ACCURACY','street level accuracy');
1920: END IF;

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

1915: IF (l_exp_accuracy_level = '0') THEN
1916: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1917: END IF;
1918: IF (l_exp_accuracy_level = '1') THEN
1919: fnd_message.set_token ('ACCURACY','street level accuracy');
1920: END IF;
1921: IF (l_exp_accuracy_level = '2') THEN
1922: fnd_message.set_token ('ACCURACY','building number level accuracy');
1923: END IF;

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

1918: IF (l_exp_accuracy_level = '1') THEN
1919: fnd_message.set_token ('ACCURACY','street level accuracy');
1920: END IF;
1921: IF (l_exp_accuracy_level = '2') THEN
1922: fnd_message.set_token ('ACCURACY','building number level accuracy');
1923: END IF;
1924: x_error_detail := fnd_message.get;
1925: END IF;
1926:

Line 1924: x_error_detail := fnd_message.get;

1920: END IF;
1921: IF (l_exp_accuracy_level = '2') THEN
1922: fnd_message.set_token ('ACCURACY','building number level accuracy');
1923: END IF;
1924: x_error_detail := fnd_message.get;
1925: END IF;
1926:
1927: EXCEPTION
1928: WHEN fnd_api.g_exc_unexpected_error

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

2064: INTO l_tmp;
2065:
2066: IF l_tmp IS NULL AND trim(p_city) <> '_'
2067: THEN
2068: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2069: fnd_message.set_token ('CITY', p_city);
2070: fnd_message.set_token ('COUNTRY', p_country);
2071: x_error := fnd_message.get;
2072: x_error_detail := x_error_detail || ' ' || x_error;

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

2065:
2066: IF l_tmp IS NULL AND trim(p_city) <> '_'
2067: THEN
2068: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2069: fnd_message.set_token ('CITY', p_city);
2070: fnd_message.set_token ('COUNTRY', p_country);
2071: x_error := fnd_message.get;
2072: x_error_detail := x_error_detail || ' ' || x_error;
2073: END IF;

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

2066: IF l_tmp IS NULL AND trim(p_city) <> '_'
2067: THEN
2068: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2069: fnd_message.set_token ('CITY', p_city);
2070: fnd_message.set_token ('COUNTRY', p_country);
2071: x_error := fnd_message.get;
2072: x_error_detail := x_error_detail || ' ' || x_error;
2073: END IF;
2074:

Line 2071: x_error := fnd_message.get;

2067: THEN
2068: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2069: fnd_message.set_token ('CITY', p_city);
2070: fnd_message.set_token ('COUNTRY', p_country);
2071: x_error := fnd_message.get;
2072: x_error_detail := x_error_detail || ' ' || x_error;
2073: END IF;
2074:
2075: CLOSE process_cursor;

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

2094: INTO l_tmp;
2095:
2096: IF l_tmp IS NULL AND trim(p_country) <> '_'
2097: THEN
2098: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
2099: fnd_message.set_token ('COUNTRY', p_country);
2100: x_error := fnd_message.get;
2101: x_error_detail := x_error_detail || ' ' || x_error;
2102: END IF;

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

2095:
2096: IF l_tmp IS NULL AND trim(p_country) <> '_'
2097: THEN
2098: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
2099: fnd_message.set_token ('COUNTRY', p_country);
2100: x_error := fnd_message.get;
2101: x_error_detail := x_error_detail || ' ' || x_error;
2102: END IF;
2103:

Line 2100: x_error := fnd_message.get;

2096: IF l_tmp IS NULL AND trim(p_country) <> '_'
2097: THEN
2098: fnd_message.set_name ('CSF', 'CSF_COUNTRY_NOT_FOUND_ERROR');
2099: fnd_message.set_token ('COUNTRY', p_country);
2100: x_error := fnd_message.get;
2101: x_error_detail := x_error_detail || ' ' || x_error;
2102: END IF;
2103:
2104: CLOSE process_cursor;

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

2122: INTO l_tmp;
2123:
2124: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
2125: THEN
2126: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
2127: fnd_message.set_token ('STATE', p_state);
2128: fnd_message.set_token ('COUNTRY', p_country);
2129: x_error := fnd_message.get;
2130: x_error_detail := x_error_detail || ' ' || x_error;

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

2123:
2124: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
2125: THEN
2126: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
2127: fnd_message.set_token ('STATE', p_state);
2128: fnd_message.set_token ('COUNTRY', p_country);
2129: x_error := fnd_message.get;
2130: x_error_detail := x_error_detail || ' ' || x_error;
2131: END IF;

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

2124: IF l_tmp IS NULL AND trim(p_country) <> '_' AND trim(p_state) <> '_'
2125: THEN
2126: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
2127: fnd_message.set_token ('STATE', p_state);
2128: fnd_message.set_token ('COUNTRY', p_country);
2129: x_error := fnd_message.get;
2130: x_error_detail := x_error_detail || ' ' || x_error;
2131: END IF;
2132:

Line 2129: x_error := fnd_message.get;

2125: THEN
2126: fnd_message.set_name ('CSF', 'CSF_STATE_NOT_FOUND_ERROR');
2127: fnd_message.set_token ('STATE', p_state);
2128: fnd_message.set_token ('COUNTRY', p_country);
2129: x_error := fnd_message.get;
2130: x_error_detail := x_error_detail || ' ' || x_error;
2131: END IF;
2132:
2133: CLOSE process_cursor;

Line 2185: fnd_message.set_name ('CSF',

2181: IF l_tmp IS NULL
2182: THEN
2183: IF l_flag = 'S' AND trim(p_state) <> '_' AND trim(p_city) <> '_'
2184: THEN
2185: fnd_message.set_name ('CSF',
2186: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
2187: fnd_message.set_token ('CITY', p_city);
2188: fnd_message.set_token ('STATE', p_state);
2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'

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

2183: IF l_flag = 'S' AND trim(p_state) <> '_' AND trim(p_city) <> '_'
2184: THEN
2185: fnd_message.set_name ('CSF',
2186: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
2187: fnd_message.set_token ('CITY', p_city);
2188: fnd_message.set_token ('STATE', p_state);
2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
2190: THEN
2191: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');

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

2184: THEN
2185: fnd_message.set_name ('CSF',
2186: 'CSF_CITY_NOT_FOUND_ERROR_STATE');
2187: fnd_message.set_token ('CITY', p_city);
2188: fnd_message.set_token ('STATE', p_state);
2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
2190: THEN
2191: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2192: fnd_message.set_token ('CITY', p_city);

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

2187: fnd_message.set_token ('CITY', p_city);
2188: fnd_message.set_token ('STATE', p_state);
2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
2190: THEN
2191: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2192: fnd_message.set_token ('CITY', p_city);
2193: fnd_message.set_token ('COUNTRY', p_country);
2194: END IF;
2195:

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

2188: fnd_message.set_token ('STATE', p_state);
2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
2190: THEN
2191: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2192: fnd_message.set_token ('CITY', p_city);
2193: fnd_message.set_token ('COUNTRY', p_country);
2194: END IF;
2195:
2196: x_error := fnd_message.get;

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

2189: ELSIF trim(p_country) <> '_' AND trim(p_city) <> '_'
2190: THEN
2191: fnd_message.set_name ('CSF', 'CSF_CITY_NOT_FOUND_ERROR');
2192: fnd_message.set_token ('CITY', p_city);
2193: fnd_message.set_token ('COUNTRY', p_country);
2194: END IF;
2195:
2196: x_error := fnd_message.get;
2197: x_error_detail := x_error_detail || ' ' || x_error;

Line 2196: x_error := fnd_message.get;

2192: fnd_message.set_token ('CITY', p_city);
2193: fnd_message.set_token ('COUNTRY', p_country);
2194: END IF;
2195:
2196: x_error := fnd_message.get;
2197: x_error_detail := x_error_detail || ' ' || x_error;
2198: END IF;
2199:
2200: CLOSE process_cursor;

Line 2259: fnd_message.set_name ('CSF',

2255: THEN
2256: IF l_flag = 'C' AND trim(p_postal_code) <> '_' AND
2257: trim (p_city) <> '_'
2258: THEN
2259: fnd_message.set_name ('CSF',
2260: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
2261: );
2262: fnd_message.set_token ('ZIP', p_postal_code);
2263: fnd_message.set_token ('CITY', p_city);

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

2258: THEN
2259: fnd_message.set_name ('CSF',
2260: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
2261: );
2262: fnd_message.set_token ('ZIP', p_postal_code);
2263: fnd_message.set_token ('CITY', p_city);
2264: x_error := fnd_message.get;
2265: x_error_detail := x_error_detail || ' ' || x_error;
2266: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND

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

2259: fnd_message.set_name ('CSF',
2260: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
2261: );
2262: fnd_message.set_token ('ZIP', p_postal_code);
2263: fnd_message.set_token ('CITY', p_city);
2264: x_error := fnd_message.get;
2265: x_error_detail := x_error_detail || ' ' || x_error;
2266: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
2267: trim (p_state) <> '_'

Line 2264: x_error := fnd_message.get;

2260: 'CSF_ZIP_NOT_FOUND_ERROR_CITY'
2261: );
2262: fnd_message.set_token ('ZIP', p_postal_code);
2263: fnd_message.set_token ('CITY', p_city);
2264: x_error := fnd_message.get;
2265: x_error_detail := x_error_detail || ' ' || x_error;
2266: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
2267: trim (p_state) <> '_'
2268: THEN

Line 2269: fnd_message.set_name ('CSF',

2265: x_error_detail := x_error_detail || ' ' || x_error;
2266: ELSIF l_flag = 'S' AND trim(p_postal_code) <> '_' AND
2267: trim (p_state) <> '_'
2268: THEN
2269: fnd_message.set_name ('CSF',
2270: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
2271: );
2272: fnd_message.set_token ('ZIP', p_postal_code);
2273: fnd_message.set_token ('STATE', p_state);

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

2268: THEN
2269: fnd_message.set_name ('CSF',
2270: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
2271: );
2272: fnd_message.set_token ('ZIP', p_postal_code);
2273: fnd_message.set_token ('STATE', p_state);
2274: x_error := fnd_message.get;
2275: x_error_detail := x_error_detail || ' ' || x_error;
2276: ELSIF trim(p_postal_code) <> '_' AND

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

2269: fnd_message.set_name ('CSF',
2270: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
2271: );
2272: fnd_message.set_token ('ZIP', p_postal_code);
2273: fnd_message.set_token ('STATE', p_state);
2274: x_error := fnd_message.get;
2275: x_error_detail := x_error_detail || ' ' || x_error;
2276: ELSIF trim(p_postal_code) <> '_' AND
2277: trim (p_country) <> '_'

Line 2274: x_error := fnd_message.get;

2270: 'CSF_ZIP_NOT_FOUND_ERROR_STATE'
2271: );
2272: fnd_message.set_token ('ZIP', p_postal_code);
2273: fnd_message.set_token ('STATE', p_state);
2274: x_error := fnd_message.get;
2275: x_error_detail := x_error_detail || ' ' || x_error;
2276: ELSIF trim(p_postal_code) <> '_' AND
2277: trim (p_country) <> '_'
2278: THEN

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

2275: x_error_detail := x_error_detail || ' ' || x_error;
2276: ELSIF trim(p_postal_code) <> '_' AND
2277: trim (p_country) <> '_'
2278: THEN
2279: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
2280: fnd_message.set_token ('ZIP', p_postal_code);
2281: fnd_message.set_token ('COUNTRY', p_country);
2282: x_error := fnd_message.get;
2283: x_error_detail := x_error_detail || ' ' || x_error;

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

2276: ELSIF trim(p_postal_code) <> '_' AND
2277: trim (p_country) <> '_'
2278: THEN
2279: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
2280: fnd_message.set_token ('ZIP', p_postal_code);
2281: fnd_message.set_token ('COUNTRY', p_country);
2282: x_error := fnd_message.get;
2283: x_error_detail := x_error_detail || ' ' || x_error;
2284: END IF;

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

2277: trim (p_country) <> '_'
2278: THEN
2279: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
2280: fnd_message.set_token ('ZIP', p_postal_code);
2281: fnd_message.set_token ('COUNTRY', p_country);
2282: x_error := fnd_message.get;
2283: x_error_detail := x_error_detail || ' ' || x_error;
2284: END IF;
2285: END IF;

Line 2282: x_error := fnd_message.get;

2278: THEN
2279: fnd_message.set_name ('CSF', 'CSF_ZIP_NOT_FOUND_ERROR');
2280: fnd_message.set_token ('ZIP', p_postal_code);
2281: fnd_message.set_token ('COUNTRY', p_country);
2282: x_error := fnd_message.get;
2283: x_error_detail := x_error_detail || ' ' || x_error;
2284: END IF;
2285: END IF;
2286: CLOSE process_cursor;

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

2300: DECLARE
2301: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
2302: BEGIN
2303:
2304: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
2305: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
2306: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
2307: IF (l_exp_accuracy_level = '0')
2308: THEN

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

2305: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
2306: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
2307: IF (l_exp_accuracy_level = '0')
2308: THEN
2309: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
2310: END IF;
2311: IF (l_exp_accuracy_level = '1')
2312: THEN
2313: fnd_message.set_token ('ACCURACY','street level accuracy');

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

2309: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
2310: END IF;
2311: IF (l_exp_accuracy_level = '1')
2312: THEN
2313: fnd_message.set_token ('ACCURACY','street level accuracy');
2314: END IF;
2315: IF (l_exp_accuracy_level = '2')
2316: THEN
2317: fnd_message.set_token ('ACCURACY','building number level accuracy');

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

2313: fnd_message.set_token ('ACCURACY','street level accuracy');
2314: END IF;
2315: IF (l_exp_accuracy_level = '2')
2316: THEN
2317: fnd_message.set_token ('ACCURACY','building number level accuracy');
2318: END IF;
2319: x_error := fnd_message.get;
2320: x_error_detail := x_error_detail || ' ' || x_error;
2321:

Line 2319: x_error := fnd_message.get;

2315: IF (l_exp_accuracy_level = '2')
2316: THEN
2317: fnd_message.set_token ('ACCURACY','building number level accuracy');
2318: END IF;
2319: x_error := fnd_message.get;
2320: x_error_detail := x_error_detail || ' ' || x_error;
2321:
2322: END;
2323: -- Enhancement Code ends here

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

2422: INTO l_timezone_id;
2423:
2424: IF l_timezone_id IS NULL
2425: THEN
2426: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
2427: fnd_msg_pub.add_detail ();
2428: RAISE fnd_api.g_exc_error;
2429: END IF;
2430:

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

2489: THEN
2490: x_result := g_valid_true;
2491: ELSE
2492: x_result := g_valid_false;
2493: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2494: fnd_message.set_token ('LOCATION_ID', p_location_id);
2495: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2496: fnd_msg_pub.add_detail ();*/
2497: -- Added for Bug 7571215

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

2490: x_result := g_valid_true;
2491: ELSE
2492: x_result := g_valid_false;
2493: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2494: fnd_message.set_token ('LOCATION_ID', p_location_id);
2495: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2496: fnd_msg_pub.add_detail ();*/
2497: -- Added for Bug 7571215
2498: get_error_detail_info (

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

2491: ELSE
2492: x_result := g_valid_false;
2493: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2494: fnd_message.set_token ('LOCATION_ID', p_location_id);
2495: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2496: fnd_msg_pub.add_detail ();*/
2497: -- Added for Bug 7571215
2498: get_error_detail_info (
2499: p_api_version => 1.0,

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

2716: );
2717:
2718: IF p_validated_flag = g_valid_true
2719: THEN
2720: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2721: l_short_msg := fnd_message.get;
2722: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2723: l_long_msg := fnd_message.get;
2724: END IF;

Line 2721: l_short_msg := fnd_message.get;

2717:
2718: IF p_validated_flag = g_valid_true
2719: THEN
2720: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2721: l_short_msg := fnd_message.get;
2722: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2723: l_long_msg := fnd_message.get;
2724: END IF;
2725:

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

2718: IF p_validated_flag = g_valid_true
2719: THEN
2720: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2721: l_short_msg := fnd_message.get;
2722: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2723: l_long_msg := fnd_message.get;
2724: END IF;
2725:
2726: IF p_override_flag = g_valid_true

Line 2723: l_long_msg := fnd_message.get;

2719: THEN
2720: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2721: l_short_msg := fnd_message.get;
2722: fnd_message.set_name ('CSF', 'CSF_ADDRESS_VALIDATED_INFO');
2723: l_long_msg := fnd_message.get;
2724: END IF;
2725:
2726: IF p_override_flag = g_valid_true
2727: THEN

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

2724: END IF;
2725:
2726: IF p_override_flag = g_valid_true
2727: THEN
2728: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2729: l_short_msg := fnd_message.get;
2730: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2731: l_long_msg := fnd_message.get;
2732: END IF;

Line 2729: l_short_msg := fnd_message.get;

2725:
2726: IF p_override_flag = g_valid_true
2727: THEN
2728: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2729: l_short_msg := fnd_message.get;
2730: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2731: l_long_msg := fnd_message.get;
2732: END IF;
2733:

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

2726: IF p_override_flag = g_valid_true
2727: THEN
2728: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2729: l_short_msg := fnd_message.get;
2730: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2731: l_long_msg := fnd_message.get;
2732: END IF;
2733:
2734: csf_locations_pkg.update_row_ext

Line 2731: l_long_msg := fnd_message.get;

2727: THEN
2728: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2729: l_short_msg := fnd_message.get;
2730: fnd_message.set_name ('CSF', 'CSF_ADDRESS_OVERRIDDEN_INFO');
2731: l_long_msg := fnd_message.get;
2732: END IF;
2733:
2734: csf_locations_pkg.update_row_ext
2735: (p_csf_ext_location_id => p_location_id,