[Home] [Help]
144: --
145: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
146: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
147: retrieve_data (p_api_version => 1.0,
148: p_init_msg_list => fnd_api.g_false,
149: p_commit => fnd_api.g_false,
150: p_validation_level => fnd_api.g_valid_level_full,
151: p_start_date => l_start_date,
152: p_end_date => l_end_date,
145: l_start_date := csf_timezones_pvt.date_to_server_tz_date (l_start_date);
146: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
147: retrieve_data (p_api_version => 1.0,
148: p_init_msg_list => fnd_api.g_false,
149: p_commit => fnd_api.g_false,
150: p_validation_level => fnd_api.g_valid_level_full,
151: p_start_date => l_start_date,
152: p_end_date => l_end_date,
153: x_task_rec_tbl => l_task_rec_tbl,
146: l_end_date := csf_timezones_pvt.date_to_server_tz_date (l_end_date);
147: retrieve_data (p_api_version => 1.0,
148: p_init_msg_list => fnd_api.g_false,
149: p_commit => fnd_api.g_false,
150: p_validation_level => fnd_api.g_valid_level_full,
151: p_start_date => l_start_date,
152: p_end_date => l_end_date,
153: x_task_rec_tbl => l_task_rec_tbl,
154: x_return_status => l_return_status,
155: x_msg_count => l_msg_count,
156: x_msg_data => l_msg_data
157: );
158:
159: IF l_return_status <> fnd_api.g_ret_sts_success
160: THEN
161: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
162: l_msg_data := fnd_message.get;
163: put_stream (g_log, l_msg_data);
160: THEN
161: fnd_message.set_name ('CSF', 'CSF_RETRIEVE_DATA_ERROR');
162: l_msg_data := fnd_message.get;
163: put_stream (g_log, l_msg_data);
164: RAISE fnd_api.g_exc_error;
165: END IF;
166:
167: IF l_task_rec_tbl.COUNT > 0
168: THEN
195: THEN */
196:
197: csf_resource_address_pvt.resolve_address
198: (p_api_version => 1.0,
199: p_init_msg_list => fnd_api.g_false,
200: p_country => NVL (l_task_rec.country,
201: '_'
202: ),
203: p_state => NVL (l_task_rec.state,
243: x_msg_data => l_msg_data,
244: x_geometry => l_locus
245: );
246:
247: IF l_return_status <> fnd_api.g_ret_sts_success
248: THEN
249: update_geometry (l_task_rec.location_id);
250: fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
251: fnd_message.set_token ('RETURN_STATUS', l_return_status);
254: put_stream (g_log, l_msg_data);
255: l_task_rec.validated_flag := g_valid_false;
256: l_task_rec.override_flag := g_valid_false;
257: log_info (p_api_version => 1.0,
258: p_init_msg_list => fnd_api.g_false,
259: p_commit => fnd_api.g_true,
260: p_validation_level => fnd_api.g_valid_level_full,
261: p_task_rec => l_task_rec,
262: x_return_status => l_return_status,
255: l_task_rec.validated_flag := g_valid_false;
256: l_task_rec.override_flag := g_valid_false;
257: log_info (p_api_version => 1.0,
258: p_init_msg_list => fnd_api.g_false,
259: p_commit => fnd_api.g_true,
260: p_validation_level => fnd_api.g_valid_level_full,
261: p_task_rec => l_task_rec,
262: x_return_status => l_return_status,
263: x_msg_count => l_msg_count,
256: l_task_rec.override_flag := g_valid_false;
257: log_info (p_api_version => 1.0,
258: p_init_msg_list => fnd_api.g_false,
259: p_commit => fnd_api.g_true,
260: p_validation_level => fnd_api.g_valid_level_full,
261: p_task_rec => l_task_rec,
262: x_return_status => l_return_status,
263: x_msg_count => l_msg_count,
264: x_msg_data => l_msg_data
263: x_msg_count => l_msg_count,
264: x_msg_data => l_msg_data
265: );
266:
267: IF l_return_status <> fnd_api.g_ret_sts_success
268: THEN
269: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
270: fnd_message.set_token ('LOCATION_ID',
271: l_task_rec.location_id
273: fnd_message.set_token ('RETURN_STATUS', l_return_status);
274: l_msg_data := fnd_message.get;
275: put_stream (g_log, l_msg_data);
276: put_stream (g_output, l_msg_data);
277: RAISE fnd_api.g_exc_error;
278: END IF;
279: ELSIF l_return_status = fnd_api.g_ret_sts_success
280: THEN
281: l_task_rec.validated_flag := g_valid_true;
275: put_stream (g_log, l_msg_data);
276: put_stream (g_output, l_msg_data);
277: RAISE fnd_api.g_exc_error;
278: END IF;
279: ELSIF l_return_status = fnd_api.g_ret_sts_success
280: THEN
281: l_task_rec.validated_flag := g_valid_true;
282: l_task_rec.override_flag := g_valid_true;
283: success_log_info (p_api_version => 1.0,
280: THEN
281: l_task_rec.validated_flag := g_valid_true;
282: l_task_rec.override_flag := g_valid_true;
283: success_log_info (p_api_version => 1.0,
284: p_init_msg_list => fnd_api.g_false,
285: p_commit => fnd_api.g_true,
286: p_validation_level => fnd_api.g_valid_level_full,
287: p_task_rec => l_task_rec,
288: x_return_status => l_return_status,
281: l_task_rec.validated_flag := g_valid_true;
282: l_task_rec.override_flag := g_valid_true;
283: success_log_info (p_api_version => 1.0,
284: p_init_msg_list => fnd_api.g_false,
285: p_commit => fnd_api.g_true,
286: p_validation_level => fnd_api.g_valid_level_full,
287: p_task_rec => l_task_rec,
288: x_return_status => l_return_status,
289: x_msg_count => l_msg_count,
282: l_task_rec.override_flag := g_valid_true;
283: success_log_info (p_api_version => 1.0,
284: p_init_msg_list => fnd_api.g_false,
285: p_commit => fnd_api.g_true,
286: p_validation_level => fnd_api.g_valid_level_full,
287: p_task_rec => l_task_rec,
288: x_return_status => l_return_status,
289: x_msg_count => l_msg_count,
290: x_msg_data => l_msg_data
288: x_return_status => l_return_status,
289: x_msg_count => l_msg_count,
290: x_msg_data => l_msg_data
291: );
292: IF l_return_status <> fnd_api.g_ret_sts_success
293: THEN
294: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
295: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
296: fnd_message.set_token ('RETURN_STATUS', l_return_status);
297: l_msg_data := fnd_message.get;
298: put_stream (g_log, l_msg_data);
299: put_stream (g_output, l_msg_data);
300: RAISE fnd_api.g_exc_error;
301: END IF;
302: END IF; -- resolve_address
303: /* ELSE -- l_Time_zone_check false
304: update_geometry (l_task_rec.location_id);
301: END IF;
302: END IF; -- resolve_address
303: /* ELSE -- l_Time_zone_check false
304: update_geometry (l_task_rec.location_id);
305: l_return_status := fnd_api.g_ret_sts_unexp_error;
306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
306: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,
311: p_commit => fnd_api.g_true,
312: p_validation_level => fnd_api.g_valid_level_full,
313: p_task_rec => l_task_rec,
314: x_return_status => l_return_status,
307: fnd_message.set_token ('RETURN_STATUS', l_return_status);
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,
311: p_commit => fnd_api.g_true,
312: p_validation_level => fnd_api.g_valid_level_full,
313: p_task_rec => l_task_rec,
314: x_return_status => l_return_status,
315: x_msg_count => l_msg_count,
308: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
309: log_info (p_api_version => 1.0,
310: p_init_msg_list => fnd_api.g_false,
311: p_commit => fnd_api.g_true,
312: p_validation_level => fnd_api.g_valid_level_full,
313: p_task_rec => l_task_rec,
314: x_return_status => l_return_status,
315: x_msg_count => l_msg_count,
316: x_msg_data => l_msg_data
315: x_msg_count => l_msg_count,
316: x_msg_data => l_msg_data
317: );
318:
319: IF l_return_status <> fnd_api.g_ret_sts_success
320: THEN
321: fnd_message.set_name ('CSF', 'CSF_LOG_INFO_ERROR');
322: fnd_message.set_token ('LOCATION_ID', l_task_rec.location_id);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
323: fnd_message.set_token ('RETURN_STATUS', l_return_status);
324: l_msg_data := fnd_message.get;
325: put_stream (g_log, l_msg_data);
326: put_stream (g_output, l_msg_data);
327: RAISE fnd_api.g_exc_error;
328: END IF;
329: END IF; -- l_Time_zone_check */
330:
331: i := l_task_rec_tbl.NEXT (i);
343:
344: -- Standard call to get message count and return the message info if the count is 1
345: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
346: EXCEPTION
347: WHEN fnd_api.g_exc_error
348: THEN
349: retcode := l_rc_err;
350: errbuf := l_msg_err;
351: fnd_msg_pub.count_and_get (p_count => l_msg_count,
350: errbuf := l_msg_err;
351: fnd_msg_pub.count_and_get (p_count => l_msg_count,
352: p_data => l_msg_data
353: );
354: WHEN fnd_api.g_exc_unexpected_error
355: THEN
356: retcode := l_rc_err;
357: errbuf := l_msg_err;
358: fnd_msg_pub.count_and_get (p_count => l_msg_count,
543:
544: l_data_set_name varchar2(40);
545: BEGIN
546: -- Standard check for call compatibility
547: IF NOT fnd_api.compatible_api_call (l_api_version,
548: p_api_version,
549: l_api_name,
550: g_pkg_name
551: )
549: l_api_name,
550: g_pkg_name
551: )
552: THEN
553: RAISE fnd_api.g_exc_unexpected_error;
554: END IF;
555:
556: -- Initialize message list if p_init_msg_list is set to TRUE
557: IF fnd_api.to_boolean (p_init_msg_list)
553: RAISE fnd_api.g_exc_unexpected_error;
554: END IF;
555:
556: -- Initialize message list if p_init_msg_list is set to TRUE
557: IF fnd_api.to_boolean (p_init_msg_list)
558: THEN
559: fnd_msg_pub.initialize;
560: END IF;
561:
559: fnd_msg_pub.initialize;
560: END IF;
561:
562: -- Initialize API return status to success
563: x_return_status := fnd_api.g_ret_sts_success;
564: -- API body
565: i := 1;
566:
567: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
631: END IF;
632: -- End of API body
633:
634: -- Standard check of p_commit
635: IF fnd_api.to_boolean (p_commit)
636: THEN
637: COMMIT WORK;
638: END IF;
639:
639:
640: -- Standard call to get message count and return the message info if the count is 1
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
642: EXCEPTION
643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: fnd_msg_pub.count_and_get (p_count => x_msg_count,
647: p_data => x_msg_data
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
642: EXCEPTION
643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: fnd_msg_pub.count_and_get (p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: WHEN OTHERS
647: p_data => x_msg_data
648: );
649: WHEN OTHERS
650: THEN
651: x_return_status := fnd_api.g_ret_sts_unexp_error;
652:
653: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
654: THEN
655: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
684: FROM hz_locations
685: WHERE location_id = l_location_id;
686: BEGIN
687: -- Standard check for call compatibility
688: IF NOT fnd_api.compatible_api_call (l_api_version,
689: p_api_version,
690: l_api_name,
691: g_pkg_name
692: )
690: l_api_name,
691: g_pkg_name
692: )
693: THEN
694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;
696:
697: -- Initialize message list if p_init_msg_list is set to TRUE
698: IF fnd_api.to_boolean (p_init_msg_list)
694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;
696:
697: -- Initialize message list if p_init_msg_list is set to TRUE
698: IF fnd_api.to_boolean (p_init_msg_list)
699: THEN
700: fnd_msg_pub.initialize;
701: END IF;
702:
700: fnd_msg_pub.initialize;
701: END IF;
702:
703: -- Initialize API return status to success
704: x_return_status := fnd_api.g_ret_sts_success;
705:
706: -- API body
707: BEGIN
708: OPEN l_check_locus_csr (p_location_id);
718: WHEN OTHERS
719: THEN
720: CLOSE l_check_locus_csr;
721:
722: RAISE fnd_api.g_exc_unexpected_error;
723: END;
724:
725: -- End of API body
726:
724:
725: -- End of API body
726:
727: -- Standard check of p_commit
728: IF fnd_api.to_boolean (p_commit)
729: THEN
730: COMMIT WORK;
731: END IF;
732:
732:
733: -- Standard call to get message count and return the message info if the count is 1
734: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
735: EXCEPTION
736: WHEN fnd_api.g_exc_error
737: THEN
738: x_return_status := fnd_api.g_ret_sts_error;
739: fnd_msg_pub.count_and_get (p_count => x_msg_count,
740: p_data => x_msg_data
734: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
735: EXCEPTION
736: WHEN fnd_api.g_exc_error
737: THEN
738: x_return_status := fnd_api.g_ret_sts_error;
739: fnd_msg_pub.count_and_get (p_count => x_msg_count,
740: p_data => x_msg_data
741: );
742: WHEN fnd_api.g_exc_unexpected_error
738: x_return_status := fnd_api.g_ret_sts_error;
739: fnd_msg_pub.count_and_get (p_count => x_msg_count,
740: p_data => x_msg_data
741: );
742: WHEN fnd_api.g_exc_unexpected_error
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_msg_pub.count_and_get (p_count => x_msg_count,
746: p_data => x_msg_data
740: p_data => x_msg_data
741: );
742: WHEN fnd_api.g_exc_unexpected_error
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_msg_pub.count_and_get (p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748: WHEN OTHERS
746: p_data => x_msg_data
747: );
748: WHEN OTHERS
749: THEN
750: x_return_status := fnd_api.g_ret_sts_unexp_error;
751:
752: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
753: THEN
754: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
793: l_api_name CONSTANT VARCHAR2 (30) := 'IS_GEOMETRY_VALID';
794: l_api_version CONSTANT NUMBER := 1.0;
795: BEGIN
796: -- Standard check for call compatibility
797: IF NOT fnd_api.compatible_api_call (l_api_version,
798: p_api_version,
799: l_api_name,
800: g_pkg_name
801: )
799: l_api_name,
800: g_pkg_name
801: )
802: THEN
803: RAISE fnd_api.g_exc_unexpected_error;
804: END IF;
805:
806: -- Initialize message list if p_init_msg_list is set to TRUE
807: IF fnd_api.to_boolean (p_init_msg_list)
803: RAISE fnd_api.g_exc_unexpected_error;
804: END IF;
805:
806: -- Initialize message list if p_init_msg_list is set to TRUE
807: IF fnd_api.to_boolean (p_init_msg_list)
808: THEN
809: fnd_msg_pub.initialize;
810: END IF;
811:
809: fnd_msg_pub.initialize;
810: END IF;
811:
812: -- Initialize API return status to success
813: x_return_status := fnd_api.g_ret_sts_success;
814: -- API body
815: x_result := g_valid_false;
816: /*
817: Returns :
832: ELSE
833: x_result := g_valid_false;
834: END IF;
835:
836: x_return_status := fnd_api.g_ret_sts_success;
837:
838: -- End of API body
839:
840: -- Standard check of p_commit
837:
838: -- End of API body
839:
840: -- Standard check of p_commit
841: IF fnd_api.to_boolean (p_commit)
842: THEN
843: COMMIT WORK;
844: END IF;
845:
845:
846: -- Standard call to get message count and return the message info if the count is 1
847: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
848: EXCEPTION
849: WHEN fnd_api.g_exc_error
850: THEN
851: x_return_status := fnd_api.g_ret_sts_error;
852: fnd_msg_pub.count_and_get (p_count => x_msg_count,
853: p_data => x_msg_data
847: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
848: EXCEPTION
849: WHEN fnd_api.g_exc_error
850: THEN
851: x_return_status := fnd_api.g_ret_sts_error;
852: fnd_msg_pub.count_and_get (p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: WHEN fnd_api.g_exc_unexpected_error
851: x_return_status := fnd_api.g_ret_sts_error;
852: fnd_msg_pub.count_and_get (p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: WHEN fnd_api.g_exc_unexpected_error
856: THEN
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get (p_count => x_msg_count,
859: p_data => x_msg_data
853: p_data => x_msg_data
854: );
855: WHEN fnd_api.g_exc_unexpected_error
856: THEN
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858: fnd_msg_pub.count_and_get (p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: WHEN OTHERS
859: p_data => x_msg_data
860: );
861: WHEN OTHERS
862: THEN
863: x_return_status := fnd_api.g_ret_sts_unexp_error;
864:
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
916: WHERE HR_COUNTRY_NAME = p_task_rec.country;
917:
918: BEGIN
919: -- Standard check for call compatibility
920: IF NOT fnd_api.compatible_api_call (l_api_version,
921: p_api_version,
922: l_api_name,
923: g_pkg_name
924: )
922: l_api_name,
923: g_pkg_name
924: )
925: THEN
926: RAISE fnd_api.g_exc_unexpected_error;
927: END IF;
928:
929: -- Initialize message list if p_init_msg_list is set to TRUE
930: IF fnd_api.to_boolean (p_init_msg_list)
926: RAISE fnd_api.g_exc_unexpected_error;
927: END IF;
928:
929: -- Initialize message list if p_init_msg_list is set to TRUE
930: IF fnd_api.to_boolean (p_init_msg_list)
931: THEN
932: fnd_msg_pub.initialize;
933: END IF;
934:
932: fnd_msg_pub.initialize;
933: END IF;
934:
935: -- Initialize API return status to success
936: x_return_status := fnd_api.g_ret_sts_success;
937:
938:
939: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
940:
1013: WHEN OTHERS
1014: THEN
1015: CLOSE process_cursor;
1016:
1017: RAISE fnd_api.g_exc_unexpected_error;
1018: END;
1019: ELSE
1020:
1021: BEGIN
1042: WHEN OTHERS
1043: THEN
1044: CLOSE process_cursor;
1045:
1046: RAISE fnd_api.g_exc_unexpected_error;
1047: END;
1048:
1049: BEGIN
1050: l_tmp := NULL;
1071: WHEN OTHERS
1072: THEN
1073: CLOSE process_cursor;
1074:
1075: RAISE fnd_api.g_exc_unexpected_error;
1076: END;
1077:
1078: BEGIN
1079: l_tmp := NULL;
1138: WHEN OTHERS
1139: THEN
1140: CLOSE process_cursor;
1141:
1142: RAISE fnd_api.g_exc_unexpected_error;
1143: END;
1144:
1145: BEGIN
1146: l_tmp := NULL;
1221: WHEN OTHERS
1222: THEN
1223: CLOSE process_cursor;
1224:
1225: RAISE fnd_api.g_exc_unexpected_error;
1226: END;
1227: END IF;
1228:
1229: -- Added for LF enhancement of Forced accuracy
1254:
1255: -- End of API body
1256:
1257: -- Standard check of p_commit
1258: IF fnd_api.to_boolean (p_commit)
1259: THEN
1260: COMMIT WORK;
1261: END IF;
1262:
1262:
1263: -- Standard call to get message count and return the message info if the count is 1
1264: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1265: EXCEPTION
1266: WHEN fnd_api.g_exc_unexpected_error
1267: THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1270: p_data => x_msg_data
1264: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1265: EXCEPTION
1266: WHEN fnd_api.g_exc_unexpected_error
1267: THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );
1272: WHEN OTHERS
1270: p_data => x_msg_data
1271: );
1272: WHEN OTHERS
1273: THEN
1274: x_return_status := fnd_api.g_ret_sts_unexp_error;
1275:
1276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1277: THEN
1278: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1308: l_location_id hz_locations.location_id%TYPE;
1309: l_task_id csf_ext_locations.task_id%TYPE;
1310: BEGIN
1311: -- Standard check for call compatibility
1312: IF NOT fnd_api.compatible_api_call (l_api_version,
1313: p_api_version,
1314: l_api_name,
1315: g_pkg_name
1316: )
1314: l_api_name,
1315: g_pkg_name
1316: )
1317: THEN
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: END IF;
1320:
1321: -- Initialize message list if p_init_msg_list is set to TRUE
1322: IF fnd_api.to_boolean (p_init_msg_list)
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: END IF;
1320:
1321: -- Initialize message list if p_init_msg_list is set to TRUE
1322: IF fnd_api.to_boolean (p_init_msg_list)
1323: THEN
1324: fnd_msg_pub.initialize;
1325: END IF;
1326:
1324: fnd_msg_pub.initialize;
1325: END IF;
1326:
1327: -- Initialize API return status to success
1328: x_return_status := fnd_api.g_ret_sts_success;
1329: -- API body
1330: fnd_message.set_name ('CSF', 'CSF_INVALID_TASK_INFO');
1331: fnd_message.set_token ('TASK_ID', p_task_rec.task_id);
1332: fnd_message.set_token ('TASK_NUMBER', p_task_rec.task_number);
1360: CLOSE c_check_ext_locations;
1361: END;
1362:
1363: get_error_detail (p_api_version => 1.0,
1364: p_init_msg_list => fnd_api.g_false,
1365: p_commit => fnd_api.g_false,
1366: p_validation_level => fnd_api.g_valid_level_full,
1367: p_task_rec => p_task_rec,
1368: x_error => l_error,
1361: END;
1362:
1363: get_error_detail (p_api_version => 1.0,
1364: p_init_msg_list => fnd_api.g_false,
1365: p_commit => fnd_api.g_false,
1366: p_validation_level => fnd_api.g_valid_level_full,
1367: p_task_rec => p_task_rec,
1368: x_error => l_error,
1369: x_error_detail => l_error_detail,
1362:
1363: get_error_detail (p_api_version => 1.0,
1364: p_init_msg_list => fnd_api.g_false,
1365: p_commit => fnd_api.g_false,
1366: p_validation_level => fnd_api.g_valid_level_full,
1367: p_task_rec => p_task_rec,
1368: x_error => l_error,
1369: x_error_detail => l_error_detail,
1370: x_return_status => x_return_status,
1371: x_msg_count => x_msg_count,
1372: x_msg_data => x_msg_data
1373: );
1374:
1375: IF x_return_status <> fnd_api.g_ret_sts_success
1376: THEN
1377: fnd_message.set_name ('CSF', 'CSF_GET_ERROR_DETAIL_ERROR');
1378: fnd_message.set_token ('LOCATION_ID', p_task_rec.location_id);
1379: fnd_message.set_token ('RETURN_STATUS', x_return_status);
1464:
1465: -- End of API body
1466:
1467: -- Standard check of p_commit
1468: IF fnd_api.to_boolean (p_commit)
1469: THEN
1470: COMMIT WORK;
1471: END IF;
1472:
1472:
1473: -- Standard call to get message count and return the message info if the count is 1
1474: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1475: EXCEPTION
1476: WHEN fnd_api.g_exc_unexpected_error
1477: THEN
1478: x_return_status := fnd_api.g_ret_sts_unexp_error;
1479: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1480: p_data => x_msg_data
1474: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1475: EXCEPTION
1476: WHEN fnd_api.g_exc_unexpected_error
1477: THEN
1478: x_return_status := fnd_api.g_ret_sts_unexp_error;
1479: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );
1482: WHEN OTHERS
1480: p_data => x_msg_data
1481: );
1482: WHEN OTHERS
1483: THEN
1484: x_return_status := fnd_api.g_ret_sts_unexp_error;
1485:
1486: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1487: THEN
1488: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1539:
1540:
1541: BEGIN
1542: -- Standard check for call compatibility
1543: IF NOT fnd_api.compatible_api_call (l_api_version,
1544: p_api_version,
1545: l_api_name,
1546: g_pkg_name
1547: )
1545: l_api_name,
1546: g_pkg_name
1547: )
1548: THEN
1549: RAISE fnd_api.g_exc_unexpected_error;
1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE
1553: IF fnd_api.to_boolean (p_init_msg_list)
1549: RAISE fnd_api.g_exc_unexpected_error;
1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE
1553: IF fnd_api.to_boolean (p_init_msg_list)
1554: THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1604: AND n.NAME = UPPER ('''||p_state||''')';
1605:
1606:
1607: -- Initialize API return status to success
1608: -- x_return_status := fnd_api.g_ret_sts_success;
1609: -- API body
1610: IF p_country_code = 'GB'
1611: THEN
1612: BEGIN
1634: WHEN OTHERS
1635: THEN
1636: CLOSE process_cursor;
1637:
1638: RAISE fnd_api.g_exc_unexpected_error;
1639: END;
1640: ELSE
1641:
1642: BEGIN
1663: WHEN OTHERS
1664: THEN
1665: CLOSE process_cursor;
1666:
1667: RAISE fnd_api.g_exc_unexpected_error;
1668: END;
1669:
1670: BEGIN
1671: l_tmp := NULL;
1692: WHEN OTHERS
1693: THEN
1694: CLOSE process_cursor;
1695:
1696: RAISE fnd_api.g_exc_unexpected_error;
1697: END;
1698:
1699: BEGIN
1700: l_tmp := NULL;
1759: WHEN OTHERS
1760: THEN
1761: CLOSE process_cursor;
1762:
1763: RAISE fnd_api.g_exc_unexpected_error;
1764: END;
1765:
1766: BEGIN
1767: l_tmp := NULL;
1845: WHEN OTHERS
1846: THEN
1847: CLOSE process_cursor;
1848:
1849: RAISE fnd_api.g_exc_unexpected_error;
1850: END;
1851: END IF;
1852:
1853: -- Added for LF enhancement of Forced accuracy
1877: -- Enhancement Code ends here
1878:
1879: -- End of API body
1880: EXCEPTION
1881: WHEN fnd_api.g_exc_unexpected_error
1882: THEN
1883: NULL;
1884: WHEN OTHERS
1885: THEN
1932: AND ftt.language = 'US';
1933:
1934: BEGIN
1935: -- Standard check for call compatibility
1936: IF NOT fnd_api.compatible_api_call (l_api_version,
1937: p_api_version,
1938: l_api_name,
1939: g_pkg_name
1940: )
1938: l_api_name,
1939: g_pkg_name
1940: )
1941: THEN
1942: RAISE fnd_api.g_exc_unexpected_error;
1943: END IF;
1944:
1945: -- Initialize message list if p_init_msg_list is set to TRUE
1946: IF fnd_api.to_boolean (p_init_msg_list)
1942: RAISE fnd_api.g_exc_unexpected_error;
1943: END IF;
1944:
1945: -- Initialize message list if p_init_msg_list is set to TRUE
1946: IF fnd_api.to_boolean (p_init_msg_list)
1947: THEN
1948: fnd_msg_pub.initialize;
1949: END IF;
1950:
1948: fnd_msg_pub.initialize;
1949: END IF;
1950:
1951: -- Initialize API return status to success
1952: x_return_status := fnd_api.g_ret_sts_success;
1953: x_result := g_valid_true;
1954:
1955: -- API body
1956: BEGIN
1977: IF l_timezone_id IS NULL
1978: THEN
1979: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
1980: fnd_msg_pub.add_detail ();
1981: RAISE fnd_api.g_exc_error;
1982: END IF;
1983:
1984: CLOSE c_timezone_check; */
1985:
1984: CLOSE c_timezone_check; */
1985:
1986: csf_resource_address_pvt.resolve_address
1987: (p_api_version => 1.0,
1988: p_init_msg_list => fnd_api.g_false,
1989: p_country => NVL (p_country,
1990: '_'
1991: ),
1992: p_state => NVL (p_state,
2031: x_geometry => l_locus
2032: );
2033:
2034:
2035: IF x_return_status = fnd_api.g_ret_sts_success
2036: THEN
2037: x_result := g_valid_true;
2038: ELSE
2039: x_result := g_valid_false;
2043: fnd_msg_pub.add_detail ();*/
2044: -- Added for Bug 7571215
2045: get_error_detail (
2046: p_api_version => 1.0,
2047: p_init_msg_list => fnd_api.g_false,
2048: p_country_code => NVL(l_country_code,'_'),
2049: p_country => NVL (p_country,'_'),
2050: p_state => NVL (p_state,'_'),
2051: p_city => NVL (p_city,'_'),
2051: p_city => NVL (p_city,'_'),
2052: p_postal_code => NVL (p_postal_code,'_'),
2053: x_error_detail => x_msg_data
2054: );
2055: RAISE fnd_api.g_exc_error;
2056: END IF;
2057:
2058: -- End of API body
2059:
2057:
2058: -- End of API body
2059:
2060: -- Standard check of p_commit
2061: IF fnd_api.to_boolean (p_commit)
2062: THEN
2063: COMMIT WORK;
2064: END IF;
2065:
2065:
2066: -- Standard call to get message count and return the message info if the count is 1
2067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2068: EXCEPTION
2069: WHEN fnd_api.g_exc_error
2070: THEN
2071: x_return_status := fnd_api.g_ret_sts_error;
2072: x_result := fnd_api.g_false;
2073: IF x_msg_data IS NULL
2067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2068: EXCEPTION
2069: WHEN fnd_api.g_exc_error
2070: THEN
2071: x_return_status := fnd_api.g_ret_sts_error;
2072: x_result := fnd_api.g_false;
2073: IF x_msg_data IS NULL
2074: THEN
2075: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2068: EXCEPTION
2069: WHEN fnd_api.g_exc_error
2070: THEN
2071: x_return_status := fnd_api.g_ret_sts_error;
2072: x_result := fnd_api.g_false;
2073: IF x_msg_data IS NULL
2074: THEN
2075: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2076: p_data => x_msg_data
2075: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2076: p_data => x_msg_data
2077: );
2078: END IF;
2079: WHEN fnd_api.g_exc_unexpected_error
2080: THEN
2081: x_return_status := fnd_api.g_ret_sts_unexp_error;
2082: x_result := fnd_api.g_false;
2083: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2077: );
2078: END IF;
2079: WHEN fnd_api.g_exc_unexpected_error
2080: THEN
2081: x_return_status := fnd_api.g_ret_sts_unexp_error;
2082: x_result := fnd_api.g_false;
2083: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2084: p_data => x_msg_data
2085: );
2078: END IF;
2079: WHEN fnd_api.g_exc_unexpected_error
2080: THEN
2081: x_return_status := fnd_api.g_ret_sts_unexp_error;
2082: x_result := fnd_api.g_false;
2083: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2084: p_data => x_msg_data
2085: );
2086: WHEN OTHERS
2084: p_data => x_msg_data
2085: );
2086: WHEN OTHERS
2087: THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: x_result := fnd_api.g_false;
2090:
2091: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2092: THEN
2085: );
2086: WHEN OTHERS
2087: THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: x_result := fnd_api.g_false;
2090:
2091: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2092: THEN
2093: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2164: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
2165: AND ftt.language = 'US';
2166: BEGIN
2167: -- Standard check for call compatibility
2168: IF NOT fnd_api.compatible_api_call (l_api_version,
2169: p_api_version,
2170: l_api_name,
2171: g_pkg_name
2172: )
2170: l_api_name,
2171: g_pkg_name
2172: )
2173: THEN
2174: RAISE fnd_api.g_exc_unexpected_error;
2175: END IF;
2176:
2177: -- Initialize message list if p_init_msg_list is set to TRUE
2178: IF fnd_api.to_boolean (p_init_msg_list)
2174: RAISE fnd_api.g_exc_unexpected_error;
2175: END IF;
2176:
2177: -- Initialize message list if p_init_msg_list is set to TRUE
2178: IF fnd_api.to_boolean (p_init_msg_list)
2179: THEN
2180: fnd_msg_pub.initialize;
2181: END IF;
2182:
2180: fnd_msg_pub.initialize;
2181: END IF;
2182:
2183: -- Initialize API return status to success
2184: x_return_status := fnd_api.g_ret_sts_success;
2185:
2186: -- API body
2187: IF upper(p_country) = 'US VIRGIN ISLANDS'
2188: THEN
2310:
2311: -- End of API body
2312:
2313: -- Standard check of p_commit
2314: IF fnd_api.to_boolean (p_commit)
2315: THEN
2316: COMMIT WORK;
2317: END IF;
2318:
2318:
2319: -- Standard call to get message count and return the message info if the count is 1
2320: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2321: EXCEPTION
2322: WHEN fnd_api.g_exc_unexpected_error
2323: THEN
2324: x_return_status := fnd_api.g_ret_sts_unexp_error;
2325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2326: p_data => x_msg_data
2320: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2321: EXCEPTION
2322: WHEN fnd_api.g_exc_unexpected_error
2323: THEN
2324: x_return_status := fnd_api.g_ret_sts_unexp_error;
2325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2326: p_data => x_msg_data
2327: );
2328: WHEN OTHERS
2326: p_data => x_msg_data
2327: );
2328: WHEN OTHERS
2329: THEN
2330: x_return_status := fnd_api.g_ret_sts_unexp_error;
2331:
2332: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2333: THEN
2334: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2383: put_stream (g_output, p_msg_data);
2384: put_stream (g_log, p_msg_data);
2385: END IF;
2386:
2387: fnd_msg_pub.count_and_get (fnd_api.g_false, l_msg_count, l_msg_data);
2388:
2389: IF l_msg_count = 1
2390: THEN
2391: put_stream (g_output, l_msg_data);
2392: put_stream (g_log, l_msg_data);
2393: END IF;
2394:
2395: put_stream (g_output,
2396: fnd_msg_pub.get (fnd_msg_pub.g_last, fnd_api.g_false)
2397: );
2398: fnd_msg_pub.RESET;
2399:
2400: LOOP
2397: );
2398: fnd_msg_pub.RESET;
2399:
2400: LOOP
2401: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);
2402: EXIT WHEN l_msg_data IS NULL;
2403: put_stream (g_log, l_msg_data);
2404: END LOOP;
2405: END show_messages;
2432: l_location_id csf_ext_locations.location_id%TYPE;
2433: l_task_id csf_ext_locations.task_id%TYPE;
2434: BEGIN
2435: -- Standard check for call compatibility
2436: IF NOT fnd_api.compatible_api_call (l_api_version,
2437: p_api_version,
2438: l_api_name,
2439: g_pkg_name
2440: )
2438: l_api_name,
2439: g_pkg_name
2440: )
2441: THEN
2442: RAISE fnd_api.g_exc_unexpected_error;
2443: END IF;
2444:
2445: -- Initialize message list if p_init_msg_list is set to TRUE
2446: IF fnd_api.to_boolean (p_init_msg_list)
2442: RAISE fnd_api.g_exc_unexpected_error;
2443: END IF;
2444:
2445: -- Initialize message list if p_init_msg_list is set to TRUE
2446: IF fnd_api.to_boolean (p_init_msg_list)
2447: THEN
2448: fnd_msg_pub.initialize;
2449: END IF;
2450:
2448: fnd_msg_pub.initialize;
2449: END IF;
2450:
2451: -- Initialize API return status to success
2452: x_return_status := fnd_api.g_ret_sts_success;
2453: -- API body
2454:
2455: BEGIN
2456: OPEN c_check_ext_locations (p_task_rec.location_id);
2503:
2504: -- End of API body
2505:
2506: -- Standard check of p_commit
2507: IF fnd_api.to_boolean (p_commit)
2508: THEN
2509: COMMIT WORK;
2510: END IF;
2511:
2511:
2512: -- Standard call to get message count and return the message info if the count is 1
2513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2514: EXCEPTION
2515: WHEN fnd_api.g_exc_unexpected_error
2516: THEN
2517: x_return_status := fnd_api.g_ret_sts_unexp_error;
2518: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2519: p_data => x_msg_data
2513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2514: EXCEPTION
2515: WHEN fnd_api.g_exc_unexpected_error
2516: THEN
2517: x_return_status := fnd_api.g_ret_sts_unexp_error;
2518: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2519: p_data => x_msg_data
2520: );
2521: WHEN OTHERS
2519: p_data => x_msg_data
2520: );
2521: WHEN OTHERS
2522: THEN
2523: x_return_status := fnd_api.g_ret_sts_unexp_error;
2524:
2525: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2526: THEN
2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);