[Home] [Help]
171: --
172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
174: retrieve_data (p_api_version => 1.0,
175: p_init_msg_list => fnd_api.g_false,
176: p_commit => fnd_api.g_false,
177: p_validation_level => fnd_api.g_valid_level_full,
178: p_start_date => l_start_date,
179: p_end_date => l_end_date,
172: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
174: retrieve_data (p_api_version => 1.0,
175: p_init_msg_list => fnd_api.g_false,
176: p_commit => fnd_api.g_false,
177: p_validation_level => fnd_api.g_valid_level_full,
178: p_start_date => l_start_date,
179: p_end_date => l_end_date,
180: x_task_rec_tbl => l_task_rec_tbl,
173: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
174: retrieve_data (p_api_version => 1.0,
175: p_init_msg_list => fnd_api.g_false,
176: p_commit => fnd_api.g_false,
177: p_validation_level => fnd_api.g_valid_level_full,
178: p_start_date => l_start_date,
179: p_end_date => l_end_date,
180: x_task_rec_tbl => l_task_rec_tbl,
181: x_return_status => l_return_status,
183: x_msg_data => l_msg_data,
184: p_unstamped_only => p_unstamped_only
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);
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:
195: IF l_task_rec_tbl.COUNT > 0
196: THEN
223: THEN */
224:
225: csf_resource_address_pvt.resolve_address
226: (p_api_version => 1.0,
227: p_init_msg_list => fnd_api.g_false,
228: p_country => NVL (l_task_rec.country,
229: '_'
230: ),
231: p_state => NVL (l_task_rec.state,
272: x_geometry => l_locus,
273: p_update_address => 'F'
274: );
275:
276: if l_return_status <> fnd_api.g_ret_sts_success
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;
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,
289: p_init_msg_list => fnd_api.g_false,
290: p_commit => fnd_api.g_true,
291: p_validation_level => fnd_api.g_valid_level_full,
292: p_task_rec => l_task_rec,
293: x_return_status => l_return_status,
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,
289: p_init_msg_list => fnd_api.g_false,
290: p_commit => fnd_api.g_true,
291: p_validation_level => fnd_api.g_valid_level_full,
292: p_task_rec => l_task_rec,
293: x_return_status => l_return_status,
294: x_msg_count => l_msg_count,
287: l_task_rec.override_flag := g_valid_false;
288: /*log_info (p_api_version => 1.0,
289: p_init_msg_list => fnd_api.g_false,
290: p_commit => fnd_api.g_true,
291: p_validation_level => fnd_api.g_valid_level_full,
292: p_task_rec => l_task_rec,
293: x_return_status => l_return_status,
294: x_msg_count => l_msg_count,
295: x_msg_data => l_msg_data
294: x_msg_count => l_msg_count,
295: x_msg_data => l_msg_data
296: ); */
297: log_info_detail (p_api_version => 1.0,
298: p_init_msg_list => fnd_api.g_false,
299: p_commit => fnd_api.g_true,
300: p_validation_level => fnd_api.g_valid_level_full,
301: p_task_rec => l_task_rec,
302: x_return_status => l_return_status,
295: x_msg_data => l_msg_data
296: ); */
297: log_info_detail (p_api_version => 1.0,
298: p_init_msg_list => fnd_api.g_false,
299: p_commit => fnd_api.g_true,
300: p_validation_level => fnd_api.g_valid_level_full,
301: p_task_rec => l_task_rec,
302: x_return_status => l_return_status,
303: x_msg_count => l_msg_count,
296: ); */
297: log_info_detail (p_api_version => 1.0,
298: p_init_msg_list => fnd_api.g_false,
299: p_commit => fnd_api.g_true,
300: p_validation_level => fnd_api.g_valid_level_full,
301: p_task_rec => l_task_rec,
302: x_return_status => l_return_status,
303: x_msg_count => l_msg_count,
304: x_msg_data => l_msg_data,
302: x_return_status => l_return_status,
303: x_msg_count => l_msg_count,
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
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;
318: ELSIF l_return_status = fnd_api.g_ret_sts_success
319: THEN
320: l_task_rec.validated_flag := g_valid_true;
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;
318: ELSIF l_return_status = fnd_api.g_ret_sts_success
319: THEN
320: l_task_rec.validated_flag := g_valid_true;
321: l_task_rec.override_flag := g_valid_true;
322: success_log_info (p_api_version => 1.0,
319: THEN
320: l_task_rec.validated_flag := g_valid_true;
321: l_task_rec.override_flag := g_valid_true;
322: success_log_info (p_api_version => 1.0,
323: p_init_msg_list => fnd_api.g_false,
324: p_commit => fnd_api.g_true,
325: p_validation_level => fnd_api.g_valid_level_full,
326: p_task_rec => l_task_rec,
327: x_return_status => l_return_status,
320: l_task_rec.validated_flag := g_valid_true;
321: l_task_rec.override_flag := g_valid_true;
322: success_log_info (p_api_version => 1.0,
323: p_init_msg_list => fnd_api.g_false,
324: p_commit => fnd_api.g_true,
325: p_validation_level => fnd_api.g_valid_level_full,
326: p_task_rec => l_task_rec,
327: x_return_status => l_return_status,
328: x_msg_count => l_msg_count,
321: l_task_rec.override_flag := g_valid_true;
322: success_log_info (p_api_version => 1.0,
323: p_init_msg_list => fnd_api.g_false,
324: p_commit => fnd_api.g_true,
325: p_validation_level => fnd_api.g_valid_level_full,
326: p_task_rec => l_task_rec,
327: x_return_status => l_return_status,
328: x_msg_count => l_msg_count,
329: x_msg_data => l_msg_data
327: x_return_status => l_return_status,
328: x_msg_count => l_msg_count,
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);
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;
341: END IF; -- resolve_address
342: /* ELSE -- l_Time_zone_check false
343: update_geometry (l_task_rec.location_id);
340: END IF;
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,
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,
352: p_task_rec => l_task_rec,
353: x_return_status => l_return_status,
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,
352: p_task_rec => l_task_rec,
353: x_return_status => l_return_status,
354: x_msg_count => l_msg_count,
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,
352: p_task_rec => l_task_rec,
353: x_return_status => l_return_status,
354: x_msg_count => l_msg_count,
355: x_msg_data => l_msg_data
354: x_msg_count => l_msg_count,
355: x_msg_data => l_msg_data
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);
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;
368: END IF; -- l_Time_zone_check */
369:
370: i := l_task_rec_tbl.NEXT (i);
382:
383: -- Standard call to get message count and return the message info if the count is 1
384: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
385: EXCEPTION
386: WHEN fnd_api.g_exc_error
387: THEN
388: retcode := l_rc_err;
389: errbuf := l_msg_err;
390: fnd_msg_pub.count_and_get (p_count => l_msg_count,
389: errbuf := l_msg_err;
390: fnd_msg_pub.count_and_get (p_count => l_msg_count,
391: p_data => l_msg_data
392: );
393: WHEN fnd_api.g_exc_unexpected_error
394: THEN
395: retcode := l_rc_err;
396: errbuf := l_msg_err;
397: fnd_msg_pub.count_and_get (p_count => l_msg_count,
439: l_location_id hz_locations.location_id%TYPE;
440: l_task_id csf_ext_locations.task_id%TYPE;
441: BEGIN
442: -- Standard check for call compatibility
443: IF NOT fnd_api.compatible_api_call (l_api_version,
444: p_api_version,
445: l_api_name,
446: g_pkg_name
447: )
445: l_api_name,
446: g_pkg_name
447: )
448: THEN
449: RAISE fnd_api.g_exc_unexpected_error;
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE
453: IF fnd_api.to_boolean (p_init_msg_list)
449: RAISE fnd_api.g_exc_unexpected_error;
450: END IF;
451:
452: -- Initialize message list if p_init_msg_list is set to TRUE
453: IF fnd_api.to_boolean (p_init_msg_list)
454: THEN
455: fnd_msg_pub.initialize;
456: END IF;
457:
455: fnd_msg_pub.initialize;
456: END IF;
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);
538:
539:
540:
541: /* get_error_detail (p_api_version => 1.0,
542: p_init_msg_list => fnd_api.g_false,
543: p_commit => fnd_api.g_false,
544: p_validation_level => fnd_api.g_valid_level_full,
545: p_task_rec => p_task_rec,
546: x_error => l_error,
539:
540:
541: /* get_error_detail (p_api_version => 1.0,
542: p_init_msg_list => fnd_api.g_false,
543: p_commit => fnd_api.g_false,
544: p_validation_level => fnd_api.g_valid_level_full,
545: p_task_rec => p_task_rec,
546: x_error => l_error,
547: x_error_detail => l_error_detail,
540:
541: /* get_error_detail (p_api_version => 1.0,
542: p_init_msg_list => fnd_api.g_false,
543: p_commit => fnd_api.g_false,
544: p_validation_level => fnd_api.g_valid_level_full,
545: p_task_rec => p_task_rec,
546: x_error => l_error,
547: x_error_detail => l_error_detail,
548: x_return_status => x_return_status,
549: x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data
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);
643:
644: -- End of API body
645:
646: -- Standard check of p_commit
647: IF fnd_api.to_boolean (p_commit)
648: THEN
649: COMMIT WORK;
650: END IF;
651:
651:
652: -- Standard call to get message count and return the message info if the count is 1
653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: fnd_msg_pub.count_and_get (p_count => x_msg_count,
659: p_data => x_msg_data
653: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
654: EXCEPTION
655: WHEN fnd_api.g_exc_unexpected_error
656: THEN
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: fnd_msg_pub.count_and_get (p_count => x_msg_count,
659: p_data => x_msg_data
660: );
661: WHEN OTHERS
659: p_data => x_msg_data
660: );
661: WHEN OTHERS
662: THEN
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664:
665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
666: THEN
667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
944: select distinct spatial_dataset from csf_spatial_ctry_mappings;
945:
946: BEGIN
947: -- Standard check for call compatibility
948: IF NOT fnd_api.compatible_api_call (l_api_version,
949: p_api_version,
950: l_api_name,
951: g_pkg_name
952: )
950: l_api_name,
951: g_pkg_name
952: )
953: THEN
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956:
957: -- Initialize message list if p_init_msg_list is set to TRUE
958: IF fnd_api.to_boolean (p_init_msg_list)
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956:
957: -- Initialize message list if p_init_msg_list is set to TRUE
958: IF fnd_api.to_boolean (p_init_msg_list)
959: THEN
960: fnd_msg_pub.initialize;
961: END IF;
962:
960: fnd_msg_pub.initialize;
961: END IF;
962:
963: -- Initialize API return status to success
964: x_return_status := fnd_api.g_ret_sts_success;
965: -- API body
966: i := 1;
967:
968:
992: END LOOP;
993: END IF;
994:
995: -- Standard check of p_commit
996: IF fnd_api.to_boolean (p_commit)
997: THEN
998: COMMIT WORK;
999: END IF;
1000:
1000:
1001: -- Standard call to get message count and return the message info if the count is 1
1002: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1003: EXCEPTION
1004: WHEN fnd_api.g_exc_unexpected_error
1005: THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1008: p_data => x_msg_data
1002: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1003: EXCEPTION
1004: WHEN fnd_api.g_exc_unexpected_error
1005: THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1010: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1009: );
1010: debug('CSF_TASK_ADDRESS_PVT.retrieve_data: Unexpected Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1011: WHEN OTHERS
1012: THEN
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014:
1015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1016: THEN
1017: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1047: FROM hz_locations
1048: WHERE location_id = l_location_id;
1049: BEGIN
1050: -- Standard check for call compatibility
1051: IF NOT fnd_api.compatible_api_call (l_api_version,
1052: p_api_version,
1053: l_api_name,
1054: g_pkg_name
1055: )
1053: l_api_name,
1054: g_pkg_name
1055: )
1056: THEN
1057: RAISE fnd_api.g_exc_unexpected_error;
1058: END IF;
1059:
1060: -- Initialize message list if p_init_msg_list is set to TRUE
1061: IF fnd_api.to_boolean (p_init_msg_list)
1057: RAISE fnd_api.g_exc_unexpected_error;
1058: END IF;
1059:
1060: -- Initialize message list if p_init_msg_list is set to TRUE
1061: IF fnd_api.to_boolean (p_init_msg_list)
1062: THEN
1063: fnd_msg_pub.initialize;
1064: END IF;
1065:
1063: fnd_msg_pub.initialize;
1064: END IF;
1065:
1066: -- Initialize API return status to success
1067: x_return_status := fnd_api.g_ret_sts_success;
1068:
1069: -- API body
1070: BEGIN
1071: OPEN l_check_locus_csr (p_location_id);
1081: WHEN OTHERS
1082: THEN
1083: CLOSE l_check_locus_csr;
1084:
1085: RAISE fnd_api.g_exc_unexpected_error;
1086: END;
1087:
1088: -- End of API body
1089:
1087:
1088: -- End of API body
1089:
1090: -- Standard check of p_commit
1091: IF fnd_api.to_boolean (p_commit)
1092: THEN
1093: COMMIT WORK;
1094: END IF;
1095:
1095:
1096: -- Standard call to get message count and return the message info if the count is 1
1097: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1098: EXCEPTION
1099: WHEN fnd_api.g_exc_error
1100: THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1103: p_data => x_msg_data
1097: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1098: EXCEPTION
1099: WHEN fnd_api.g_exc_error
1100: THEN
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1105: WHEN fnd_api.g_exc_unexpected_error
1101: x_return_status := fnd_api.g_ret_sts_error;
1102: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1105: WHEN fnd_api.g_exc_unexpected_error
1106: THEN
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1109: p_data => x_msg_data
1103: p_data => x_msg_data
1104: );
1105: WHEN fnd_api.g_exc_unexpected_error
1106: THEN
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1109: p_data => x_msg_data
1110: );
1111: WHEN OTHERS
1109: p_data => x_msg_data
1110: );
1111: WHEN OTHERS
1112: THEN
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114:
1115: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1116: THEN
1117: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1156: l_api_name CONSTANT VARCHAR2 (30) := 'IS_GEOMETRY_VALID';
1157: l_api_version CONSTANT NUMBER := 1.0;
1158: BEGIN
1159: -- Standard check for call compatibility
1160: IF NOT fnd_api.compatible_api_call (l_api_version,
1161: p_api_version,
1162: l_api_name,
1163: g_pkg_name
1164: )
1162: l_api_name,
1163: g_pkg_name
1164: )
1165: THEN
1166: RAISE fnd_api.g_exc_unexpected_error;
1167: END IF;
1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE
1170: IF fnd_api.to_boolean (p_init_msg_list)
1166: RAISE fnd_api.g_exc_unexpected_error;
1167: END IF;
1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE
1170: IF fnd_api.to_boolean (p_init_msg_list)
1171: THEN
1172: fnd_msg_pub.initialize;
1173: END IF;
1174:
1172: fnd_msg_pub.initialize;
1173: END IF;
1174:
1175: -- Initialize API return status to success
1176: x_return_status := fnd_api.g_ret_sts_success;
1177: -- API body
1178: x_result := g_valid_false;
1179: /*
1180: Returns :
1195: ELSE
1196: x_result := g_valid_false;
1197: END IF;
1198:
1199: x_return_status := fnd_api.g_ret_sts_success;
1200:
1201: -- End of API body
1202:
1203: -- Standard check of p_commit
1200:
1201: -- End of API body
1202:
1203: -- Standard check of p_commit
1204: IF fnd_api.to_boolean (p_commit)
1205: THEN
1206: COMMIT WORK;
1207: END IF;
1208:
1208:
1209: -- Standard call to get message count and return the message info if the count is 1
1210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1211: EXCEPTION
1212: WHEN fnd_api.g_exc_error
1213: THEN
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1216: p_data => x_msg_data
1210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1211: EXCEPTION
1212: WHEN fnd_api.g_exc_error
1213: THEN
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );
1218: WHEN fnd_api.g_exc_unexpected_error
1214: x_return_status := fnd_api.g_ret_sts_error;
1215: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );
1218: WHEN fnd_api.g_exc_unexpected_error
1219: THEN
1220: x_return_status := fnd_api.g_ret_sts_unexp_error;
1221: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1222: p_data => x_msg_data
1216: p_data => x_msg_data
1217: );
1218: WHEN fnd_api.g_exc_unexpected_error
1219: THEN
1220: x_return_status := fnd_api.g_ret_sts_unexp_error;
1221: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1222: p_data => x_msg_data
1223: );
1224: WHEN OTHERS
1222: p_data => x_msg_data
1223: );
1224: WHEN OTHERS
1225: THEN
1226: x_return_status := fnd_api.g_ret_sts_unexp_error;
1227:
1228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1229: THEN
1230: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1280: WHERE HR_COUNTRY_NAME = p_task_rec.country;
1281:
1282: BEGIN
1283: -- Standard check for call compatibility
1284: IF NOT fnd_api.compatible_api_call (l_api_version,
1285: p_api_version,
1286: l_api_name,
1287: g_pkg_name
1288: )
1286: l_api_name,
1287: g_pkg_name
1288: )
1289: THEN
1290: RAISE fnd_api.g_exc_unexpected_error;
1291: END IF;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE
1294: IF fnd_api.to_boolean (p_init_msg_list)
1290: RAISE fnd_api.g_exc_unexpected_error;
1291: END IF;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE
1294: IF fnd_api.to_boolean (p_init_msg_list)
1295: THEN
1296: fnd_msg_pub.initialize;
1297: END IF;
1298:
1296: fnd_msg_pub.initialize;
1297: END IF;
1298:
1299: -- Initialize API return status to success
1300: x_return_status := fnd_api.g_ret_sts_success;
1301:
1302:
1303: open ctry_hr_to_spatial;
1304: fetch ctry_hr_to_spatial into l_country, l_spatail_dataset;
1378: WHEN OTHERS
1379: THEN
1380: CLOSE process_cursor;
1381:
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END;
1384: ELSE
1385:
1386: BEGIN
1407: WHEN OTHERS
1408: THEN
1409: CLOSE process_cursor;
1410:
1411: RAISE fnd_api.g_exc_unexpected_error;
1412: END;
1413:
1414: BEGIN
1415: l_tmp := NULL;
1436: WHEN OTHERS
1437: THEN
1438: CLOSE process_cursor;
1439:
1440: RAISE fnd_api.g_exc_unexpected_error;
1441: END;
1442:
1443: BEGIN
1444: l_tmp := NULL;
1503: WHEN OTHERS
1504: THEN
1505: CLOSE process_cursor;
1506:
1507: RAISE fnd_api.g_exc_unexpected_error;
1508: END;
1509:
1510: BEGIN
1511: l_tmp := NULL;
1586: WHEN OTHERS
1587: THEN
1588: CLOSE process_cursor;
1589:
1590: RAISE fnd_api.g_exc_unexpected_error;
1591: END;
1592: END IF;
1593:
1594: -- Added for LF enhancement of Forced accuracy
1619:
1620: -- End of API body
1621:
1622: -- Standard check of p_commit
1623: IF fnd_api.to_boolean (p_commit)
1624: THEN
1625: COMMIT WORK;
1626: END IF;
1627:
1627:
1628: -- Standard call to get message count and return the message info if the count is 1
1629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1630: EXCEPTION
1631: WHEN fnd_api.g_exc_unexpected_error
1632: THEN
1633: x_return_status := fnd_api.g_ret_sts_unexp_error;
1634: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1635: p_data => x_msg_data
1629: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1630: EXCEPTION
1631: WHEN fnd_api.g_exc_unexpected_error
1632: THEN
1633: x_return_status := fnd_api.g_ret_sts_unexp_error;
1634: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1635: p_data => x_msg_data
1636: );
1637: WHEN OTHERS
1635: p_data => x_msg_data
1636: );
1637: WHEN OTHERS
1638: THEN
1639: x_return_status := fnd_api.g_ret_sts_unexp_error;
1640:
1641: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1642: THEN
1643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1674: l_location_id hz_locations.location_id%TYPE;
1675: l_task_id csf_ext_locations.task_id%TYPE;
1676: BEGIN
1677: -- Standard check for call compatibility
1678: IF NOT fnd_api.compatible_api_call (l_api_version,
1679: p_api_version,
1680: l_api_name,
1681: g_pkg_name
1682: )
1680: l_api_name,
1681: g_pkg_name
1682: )
1683: THEN
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686:
1687: -- Initialize message list if p_init_msg_list is set to TRUE
1688: IF fnd_api.to_boolean (p_init_msg_list)
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686:
1687: -- Initialize message list if p_init_msg_list is set to TRUE
1688: IF fnd_api.to_boolean (p_init_msg_list)
1689: THEN
1690: fnd_msg_pub.initialize;
1691: END IF;
1692:
1690: fnd_msg_pub.initialize;
1691: END IF;
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);
1726: CLOSE c_check_ext_locations;
1727: END;
1728:
1729: get_error_detail (p_api_version => 1.0,
1730: p_init_msg_list => fnd_api.g_false,
1731: p_commit => fnd_api.g_false,
1732: p_validation_level => fnd_api.g_valid_level_full,
1733: p_task_rec => p_task_rec,
1734: x_error => l_error,
1727: END;
1728:
1729: get_error_detail (p_api_version => 1.0,
1730: p_init_msg_list => fnd_api.g_false,
1731: p_commit => fnd_api.g_false,
1732: p_validation_level => fnd_api.g_valid_level_full,
1733: p_task_rec => p_task_rec,
1734: x_error => l_error,
1735: x_error_detail => l_error_detail,
1728:
1729: get_error_detail (p_api_version => 1.0,
1730: p_init_msg_list => fnd_api.g_false,
1731: p_commit => fnd_api.g_false,
1732: p_validation_level => fnd_api.g_valid_level_full,
1733: p_task_rec => p_task_rec,
1734: x_error => l_error,
1735: x_error_detail => l_error_detail,
1736: x_return_status => x_return_status,
1737: x_msg_count => x_msg_count,
1738: x_msg_data => x_msg_data
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);
1830:
1831: -- End of API body
1832:
1833: -- Standard check of p_commit
1834: IF fnd_api.to_boolean (p_commit)
1835: THEN
1836: COMMIT WORK;
1837: END IF;
1838:
1838:
1839: -- Standard call to get message count and return the message info if the count is 1
1840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1841: EXCEPTION
1842: WHEN fnd_api.g_exc_unexpected_error
1843: THEN
1844: x_return_status := fnd_api.g_ret_sts_unexp_error;
1845: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1846: p_data => x_msg_data
1840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1841: EXCEPTION
1842: WHEN fnd_api.g_exc_unexpected_error
1843: THEN
1844: x_return_status := fnd_api.g_ret_sts_unexp_error;
1845: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1846: p_data => x_msg_data
1847: );
1848: WHEN OTHERS
1846: p_data => x_msg_data
1847: );
1848: WHEN OTHERS
1849: THEN
1850: x_return_status := fnd_api.g_ret_sts_unexp_error;
1851:
1852: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1853: THEN
1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1877: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1878:
1879: BEGIN
1880: -- Standard check for call compatibility
1881: IF NOT fnd_api.compatible_api_call (l_api_version,
1882: p_api_version,
1883: l_api_name,
1884: g_pkg_name
1885: )
1883: l_api_name,
1884: g_pkg_name
1885: )
1886: THEN
1887: RAISE fnd_api.g_exc_unexpected_error;
1888: END IF;
1889:
1890: -- Initialize message list if p_init_msg_list is set to TRUE
1891: IF fnd_api.to_boolean (p_init_msg_list)
1887: RAISE fnd_api.g_exc_unexpected_error;
1888: END IF;
1889:
1890: -- Initialize message list if p_init_msg_list is set to TRUE
1891: IF fnd_api.to_boolean (p_init_msg_list)
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
1924: x_error_detail := fnd_message.get;
1925: END IF;
1926:
1927: EXCEPTION
1928: WHEN fnd_api.g_exc_unexpected_error
1929: THEN
1930: NULL;
1931: WHEN OTHERS
1932: THEN
1983:
1984:
1985: BEGIN
1986: -- Standard check for call compatibility
1987: IF NOT fnd_api.compatible_api_call (l_api_version,
1988: p_api_version,
1989: l_api_name,
1990: g_pkg_name
1991: )
1989: l_api_name,
1990: g_pkg_name
1991: )
1992: THEN
1993: RAISE fnd_api.g_exc_unexpected_error;
1994: END IF;
1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE
1997: IF fnd_api.to_boolean (p_init_msg_list)
1993: RAISE fnd_api.g_exc_unexpected_error;
1994: END IF;
1995:
1996: -- Initialize message list if p_init_msg_list is set to TRUE
1997: IF fnd_api.to_boolean (p_init_msg_list)
1998: THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2050: AND n.NAME = UPPER ('''||p_state||''')';
2051:
2052:
2053: -- Initialize API return status to success
2054: -- x_return_status := fnd_api.g_ret_sts_success;
2055: -- API body
2056: IF p_country_code = 'GB'
2057: THEN
2058: BEGIN
2080: WHEN OTHERS
2081: THEN
2082: CLOSE process_cursor;
2083:
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END;
2086: ELSE
2087:
2088: BEGIN
2109: WHEN OTHERS
2110: THEN
2111: CLOSE process_cursor;
2112:
2113: RAISE fnd_api.g_exc_unexpected_error;
2114: END;
2115:
2116: BEGIN
2117: l_tmp := NULL;
2138: WHEN OTHERS
2139: THEN
2140: CLOSE process_cursor;
2141:
2142: RAISE fnd_api.g_exc_unexpected_error;
2143: END;
2144:
2145: BEGIN
2146: l_tmp := NULL;
2205: WHEN OTHERS
2206: THEN
2207: CLOSE process_cursor;
2208:
2209: RAISE fnd_api.g_exc_unexpected_error;
2210: END;
2211:
2212: BEGIN
2213: l_tmp := NULL;
2291: WHEN OTHERS
2292: THEN
2293: CLOSE process_cursor;
2294:
2295: RAISE fnd_api.g_exc_unexpected_error;
2296: END;
2297: END IF;
2298:
2299: -- Added for LF enhancement of Forced accuracy
2323: -- Enhancement Code ends here
2324:
2325: -- End of API body
2326: EXCEPTION
2327: WHEN fnd_api.g_exc_unexpected_error
2328: THEN
2329: NULL;
2330: WHEN OTHERS
2331: THEN
2379: AND ftt.language = 'US';
2380:
2381: BEGIN
2382: -- Standard check for call compatibility
2383: IF NOT fnd_api.compatible_api_call (l_api_version,
2384: p_api_version,
2385: l_api_name,
2386: g_pkg_name
2387: )
2385: l_api_name,
2386: g_pkg_name
2387: )
2388: THEN
2389: RAISE fnd_api.g_exc_unexpected_error;
2390: END IF;
2391:
2392: -- Initialize message list if p_init_msg_list is set to TRUE
2393: IF fnd_api.to_boolean (p_init_msg_list)
2389: RAISE fnd_api.g_exc_unexpected_error;
2390: END IF;
2391:
2392: -- Initialize message list if p_init_msg_list is set to TRUE
2393: IF fnd_api.to_boolean (p_init_msg_list)
2394: THEN
2395: fnd_msg_pub.initialize;
2396: END IF;
2397:
2395: fnd_msg_pub.initialize;
2396: END IF;
2397:
2398: -- Initialize API return status to success
2399: x_return_status := fnd_api.g_ret_sts_success;
2400: x_result := g_valid_true;
2401:
2402: -- API body
2403: BEGIN
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:
2431: CLOSE c_timezone_check; */
2432:
2431: CLOSE c_timezone_check; */
2432:
2433: csf_resource_address_pvt.resolve_address
2434: (p_api_version => 1.0,
2435: p_init_msg_list => fnd_api.g_false,
2436: p_country => NVL (p_country,
2437: '_'
2438: ),
2439: p_state => NVL (p_state,
2484: );
2485:
2486:
2487: l_dup_msg_data := x_msg_data;
2488: IF x_return_status = fnd_api.g_ret_sts_success
2489: THEN
2490: x_result := g_valid_true;
2491: ELSE
2492: x_result := g_valid_false;
2496: fnd_msg_pub.add_detail ();*/
2497: -- Added for Bug 7571215
2498: get_error_detail_info (
2499: p_api_version => 1.0,
2500: p_init_msg_list => fnd_api.g_false,
2501: p_country_code => NVL(l_country_code,'_'),
2502: p_country => NVL (p_country,'_'),
2503: p_state => NVL (p_state,'_'),
2504: p_city => NVL (p_city,'_'),
2505: p_postal_code => NVL (p_postal_code,'_'),
2506: x_error_detail => x_msg_data,
2507: x_dup_msg_data => l_dup_msg_data
2508: );
2509: RAISE fnd_api.g_exc_error;
2510: END IF;
2511:
2512: -- End of API body
2513:
2511:
2512: -- End of API body
2513:
2514: -- Standard check of p_commit
2515: IF fnd_api.to_boolean (p_commit)
2516: THEN
2517: COMMIT WORK;
2518: END IF;
2519:
2519:
2520: -- Standard call to get message count and return the message info if the count is 1
2521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2522: EXCEPTION
2523: WHEN fnd_api.g_exc_error
2524: THEN
2525: x_return_status := fnd_api.g_ret_sts_error;
2526: x_result := fnd_api.g_false;
2527: IF x_msg_data IS NULL
2521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2522: EXCEPTION
2523: WHEN fnd_api.g_exc_error
2524: THEN
2525: x_return_status := fnd_api.g_ret_sts_error;
2526: x_result := fnd_api.g_false;
2527: IF x_msg_data IS NULL
2528: THEN
2529: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2522: EXCEPTION
2523: WHEN fnd_api.g_exc_error
2524: THEN
2525: x_return_status := fnd_api.g_ret_sts_error;
2526: x_result := fnd_api.g_false;
2527: IF x_msg_data IS NULL
2528: THEN
2529: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2530: p_data => x_msg_data
2529: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2530: p_data => x_msg_data
2531: );
2532: END IF;
2533: WHEN fnd_api.g_exc_unexpected_error
2534: THEN
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: x_result := fnd_api.g_false;
2537: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2531: );
2532: END IF;
2533: WHEN fnd_api.g_exc_unexpected_error
2534: THEN
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: x_result := fnd_api.g_false;
2537: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );
2532: END IF;
2533: WHEN fnd_api.g_exc_unexpected_error
2534: THEN
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: x_result := fnd_api.g_false;
2537: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2538: p_data => x_msg_data
2539: );
2540: WHEN OTHERS
2538: p_data => x_msg_data
2539: );
2540: WHEN OTHERS
2541: THEN
2542: x_return_status := fnd_api.g_ret_sts_unexp_error;
2543: x_result := fnd_api.g_false;
2544:
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2546: THEN
2539: );
2540: WHEN OTHERS
2541: THEN
2542: x_return_status := fnd_api.g_ret_sts_unexp_error;
2543: x_result := fnd_api.g_false;
2544:
2545: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2546: THEN
2547: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2618: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
2619: AND ftt.language = 'US';
2620: BEGIN
2621: -- Standard check for call compatibility
2622: IF NOT fnd_api.compatible_api_call (l_api_version,
2623: p_api_version,
2624: l_api_name,
2625: g_pkg_name
2626: )
2624: l_api_name,
2625: g_pkg_name
2626: )
2627: THEN
2628: RAISE fnd_api.g_exc_unexpected_error;
2629: END IF;
2630:
2631: -- Initialize message list if p_init_msg_list is set to TRUE
2632: IF fnd_api.to_boolean (p_init_msg_list)
2628: RAISE fnd_api.g_exc_unexpected_error;
2629: END IF;
2630:
2631: -- Initialize message list if p_init_msg_list is set to TRUE
2632: IF fnd_api.to_boolean (p_init_msg_list)
2633: THEN
2634: fnd_msg_pub.initialize;
2635: END IF;
2636:
2634: fnd_msg_pub.initialize;
2635: END IF;
2636:
2637: -- Initialize API return status to success
2638: x_return_status := fnd_api.g_ret_sts_success;
2639:
2640: -- API body
2641: IF upper(p_country) = 'US VIRGIN ISLANDS'
2642: THEN
2764:
2765: -- End of API body
2766:
2767: -- Standard check of p_commit
2768: IF fnd_api.to_boolean (p_commit)
2769: THEN
2770: COMMIT WORK;
2771: END IF;
2772:
2772:
2773: -- Standard call to get message count and return the message info if the count is 1
2774: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2775: EXCEPTION
2776: WHEN fnd_api.g_exc_unexpected_error
2777: THEN
2778: x_return_status := fnd_api.g_ret_sts_unexp_error;
2779: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2780: p_data => x_msg_data
2774: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2775: EXCEPTION
2776: WHEN fnd_api.g_exc_unexpected_error
2777: THEN
2778: x_return_status := fnd_api.g_ret_sts_unexp_error;
2779: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2780: p_data => x_msg_data
2781: );
2782: WHEN OTHERS
2780: p_data => x_msg_data
2781: );
2782: WHEN OTHERS
2783: THEN
2784: x_return_status := fnd_api.g_ret_sts_unexp_error;
2785:
2786: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2787: THEN
2788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2837: put_stream (g_output, p_msg_data);
2838: put_stream (g_log, p_msg_data);
2839: END IF;
2840:
2841: fnd_msg_pub.count_and_get (fnd_api.g_false, l_msg_count, l_msg_data);
2842:
2843: IF l_msg_count = 1
2844: THEN
2845: put_stream (g_output, l_msg_data);
2846: put_stream (g_log, l_msg_data);
2847: END IF;
2848:
2849: put_stream (g_output,
2850: fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false)
2851: );
2852: fnd_msg_pub.RESET;
2853:
2854: LOOP
2851: );
2852: fnd_msg_pub.RESET;
2853:
2854: LOOP
2855: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);
2856: EXIT WHEN l_msg_data IS NULL;
2857: put_stream (g_log, l_msg_data);
2858: END LOOP;
2859: END show_messages;
2886: l_location_id csf_ext_locations.location_id%TYPE;
2887: l_task_id csf_ext_locations.task_id%TYPE;
2888: BEGIN
2889: -- Standard check for call compatibility
2890: IF NOT fnd_api.compatible_api_call (l_api_version,
2891: p_api_version,
2892: l_api_name,
2893: g_pkg_name
2894: )
2892: l_api_name,
2893: g_pkg_name
2894: )
2895: THEN
2896: RAISE fnd_api.g_exc_unexpected_error;
2897: END IF;
2898:
2899: -- Initialize message list if p_init_msg_list is set to TRUE
2900: IF fnd_api.to_boolean (p_init_msg_list)
2896: RAISE fnd_api.g_exc_unexpected_error;
2897: END IF;
2898:
2899: -- Initialize message list if p_init_msg_list is set to TRUE
2900: IF fnd_api.to_boolean (p_init_msg_list)
2901: THEN
2902: fnd_msg_pub.initialize;
2903: END IF;
2904:
2902: fnd_msg_pub.initialize;
2903: END IF;
2904:
2905: -- Initialize API return status to success
2906: x_return_status := fnd_api.g_ret_sts_success;
2907: -- API body
2908:
2909: BEGIN
2910: OPEN c_check_ext_locations (p_task_rec.location_id);
2957:
2958: -- End of API body
2959:
2960: -- Standard check of p_commit
2961: IF fnd_api.to_boolean (p_commit)
2962: THEN
2963: COMMIT WORK;
2964: END IF;
2965:
2965:
2966: -- Standard call to get message count and return the message info if the count is 1
2967: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2968: EXCEPTION
2969: WHEN fnd_api.g_exc_unexpected_error
2970: THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2973: p_data => x_msg_data
2967: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2968: EXCEPTION
2969: WHEN fnd_api.g_exc_unexpected_error
2970: THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2973: p_data => x_msg_data
2974: );
2975: WHEN OTHERS
2973: p_data => x_msg_data
2974: );
2975: WHEN OTHERS
2976: THEN
2977: x_return_status := fnd_api.g_ret_sts_unexp_error;
2978:
2979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2980: THEN
2981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);