74: FROM fnd_timezones_vl
75: WHERE timezone_code = p_timezone_id;
76: BEGIN
77: -- Initialize message list
78: fnd_msg_pub.initialize;
79: -- get termination messages
80: fnd_message.set_name ('CSF', 'CSF_GST_DONE_SUCC');
81: l_msg_succ := fnd_message.get;
82: fnd_message.set_name ('CSF', 'CSF_GST_DONE_WARN');
341: put_stream (g_output, l_msg_succ);
342: -- End of API body
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;
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,
352: p_data => l_msg_data
353: );
354: WHEN fnd_api.g_exc_unexpected_error
355: THEN
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,
359: p_data => l_msg_data
360: );
361: WHEN OTHERS
362: THEN
362: THEN
363: retcode := l_rc_err;
364: errbuf := l_msg_err;
365:
366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
367: THEN
368: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
369: END IF;
370:
364: errbuf := l_msg_err;
365:
366: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
367: THEN
368: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
369: END IF;
370:
371: fnd_msg_pub.count_and_get (p_count => l_msg_count,
372: p_data => l_msg_data);
367: THEN
368: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
369: END IF;
370:
371: fnd_msg_pub.count_and_get (p_count => l_msg_count,
372: p_data => l_msg_data);
373: END validate_address;
374:
375: PROCEDURE retrieve_data (
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:
562: -- Initialize API return status to success
563: x_return_status := fnd_api.g_ret_sts_success;
637: COMMIT WORK;
638: END IF;
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;
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
650: THEN
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);
656: END IF;
657:
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);
656: END IF;
657:
658: fnd_msg_pub.count_and_get (p_count => x_msg_count,
659: p_data => x_msg_data);
654: THEN
655: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
656: END IF;
657:
658: fnd_msg_pub.count_and_get (p_count => x_msg_count,
659: p_data => x_msg_data);
660: END retrieve_data;
661:
662: /*
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:
703: -- Initialize API return status to success
704: x_return_status := fnd_api.g_ret_sts_success;
730: COMMIT WORK;
731: END IF;
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;
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
743: THEN
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
749: THEN
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);
755: END IF;
756:
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);
755: END IF;
756:
757: fnd_msg_pub.count_and_get (p_count => x_msg_count,
758: p_data => x_msg_data);
753: THEN
754: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
755: END IF;
756:
757: fnd_msg_pub.count_and_get (p_count => x_msg_count,
758: p_data => x_msg_data);
759: END get_geometry;
760:
761: -- This function is used to check if the geometry is null.
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:
812: -- Initialize API return status to success
813: x_return_status := fnd_api.g_ret_sts_success;
843: COMMIT WORK;
844: END IF;
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;
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
856: THEN
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
862: THEN
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);
868: END IF;
869:
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);
868: END IF;
869:
870: fnd_msg_pub.count_and_get (p_count => x_msg_count,
871: p_data => x_msg_data);
866: THEN
867: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
868: END IF;
869:
870: fnd_msg_pub.count_and_get (p_count => x_msg_count,
871: p_data => x_msg_data);
872: END is_geometry_valid;
873:
874: PROCEDURE get_error_detail (
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:
935: -- Initialize API return status to success
936: x_return_status := fnd_api.g_ret_sts_success;
1260: COMMIT WORK;
1261: END IF;
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;
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
1273: THEN
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);
1279: END IF;
1280:
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);
1279: END IF;
1280:
1281: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1282: p_data => x_msg_data);
1277: THEN
1278: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1279: END IF;
1280:
1281: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1282: p_data => x_msg_data);
1283: END get_error_detail;
1284:
1285: PROCEDURE log_info (
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:
1327: -- Initialize API return status to success
1328: x_return_status := fnd_api.g_ret_sts_success;
1470: COMMIT WORK;
1471: END IF;
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;
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
1483: THEN
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);
1489: END IF;
1490:
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);
1489: END IF;
1490:
1491: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1492: p_data => x_msg_data);
1487: THEN
1488: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1489: END IF;
1490:
1491: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1492: p_data => x_msg_data);
1493: END log_info;
1494: --
1495: -- Added for bug 7571215
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:
1558: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
1559:
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:
1951: -- Initialize API return status to success
1952: x_return_status := fnd_api.g_ret_sts_success;
1976:
1977: IF l_timezone_id IS NULL
1978: THEN
1979: fnd_message.set_name ('CSF', 'CSF_TIME_ZONE_ERROR');
1980: fnd_msg_pub.add_detail ();
1981: RAISE fnd_api.g_exc_error;
1982: END IF;
1983:
1984: CLOSE c_timezone_check; */
2039: x_result := g_valid_false;
2040: /* fnd_message.set_name ('CSF', 'CSF_RESOLVE_ADDRESS_ERROR');
2041: fnd_message.set_token ('LOCATION_ID', p_location_id);
2042: fnd_message.set_token ('RETURN_STATUS', x_return_status);
2043: fnd_msg_pub.add_detail ();*/
2044: -- Added for Bug 7571215
2045: get_error_detail (
2046: p_api_version => 1.0,
2047: p_init_msg_list => fnd_api.g_false,
2063: COMMIT WORK;
2064: END IF;
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;
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
2077: );
2078: END IF;
2079: WHEN fnd_api.g_exc_unexpected_error
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
2087: THEN
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);
2094: END IF;
2095:
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);
2094: END IF;
2095:
2096: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2097: p_data => x_msg_data);
2092: THEN
2093: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2094: END IF;
2095:
2096: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2097: p_data => x_msg_data);
2098: END validate_task_data;
2099:
2100: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
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:
2183: -- Initialize API return status to success
2184: x_return_status := fnd_api.g_ret_sts_success;
2316: COMMIT WORK;
2317: END IF;
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;
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
2329: THEN
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);
2335: END IF;
2336:
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);
2335: END IF;
2336:
2337: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2338: p_data => x_msg_data);
2333: THEN
2334: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2335: END IF;
2336:
2337: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2338: p_data => x_msg_data);
2339: END update_task_address;
2340:
2341: PROCEDURE dbgl (p_msg_data VARCHAR2)
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
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
2401: l_msg_data := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_false);
2402: EXIT WHEN l_msg_data IS NULL;
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;
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:
2451: -- Initialize API return status to success
2452: x_return_status := fnd_api.g_ret_sts_success;
2509: COMMIT WORK;
2510: END IF;
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;
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
2522: THEN
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);
2528: END IF;
2529:
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);
2528: END IF;
2529:
2530: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2531: p_data => x_msg_data);
2526: THEN
2527: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2528: END IF;
2529:
2530: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2531: p_data => x_msg_data);
2532: END success_log_info;
2533: -- This procedure used by Change Invalid address to get the counrty code
2534: -- and place id