DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on STANDARD

Line 344: -- Standard call to get message count and return the message info if the count is 1

340: put_stream (g_log, l_msg_succ);
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

Line 546: -- Standard check for call compatibility

542: AND t.planned_start_date BETWEEN Trunc(p_start_date) AND Trunc(p_end_date) + .99998;
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

Line 634: -- Standard check of p_commit

630: END LOOP;
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;

Line 640: -- Standard call to get message count and return the message info if the count is 1

636: THEN
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

Line 687: -- Standard check for call compatibility

683: SELECT geometry
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

Line 727: -- Standard check of p_commit

723: END;
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;

Line 733: -- Standard call to get message count and return the message info if the count is 1

729: THEN
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

Line 796: -- Standard check for call compatibility

792: IS
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

Line 840: -- Standard check of p_commit

836: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 846: -- Standard call to get message count and return the message info if the count is 1

842: THEN
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

Line 919: -- Standard check for call compatibility

915: FROM CSF_SPATIAL_CTRY_MAPPINGS
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

Line 1257: -- Standard check of p_commit

1253: -- Enhancement Code ends here
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;

Line 1263: -- Standard call to get message count and return the message info if the count is 1

1259: THEN
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

Line 1311: -- Standard check for call compatibility

1307:
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

Line 1467: -- Standard check of p_commit

1463: END IF;
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;

Line 1473: -- Standard call to get message count and return the message info if the count is 1

1469: THEN
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

Line 1542: -- Standard check for call compatibility

1538: WHERE HR_COUNTRY_NAME = upper(p_country);
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

Line 1935: -- Standard check for call compatibility

1931: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)
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

Line 2060: -- Standard check of p_commit

2056: END IF;
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;

Line 2066: -- Standard call to get message count and return the message info if the count is 1

2062: THEN
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

Line 2167: -- Standard check for call compatibility

2163: FROM fnd_territories_tl ftt
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

Line 2313: -- Standard check of p_commit

2309: END IF;
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;

Line 2319: -- Standard call to get message count and return the message info if the count is 1

2315: THEN
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

Line 2435: -- Standard check for call compatibility

2431:
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

Line 2506: -- Standard check of p_commit

2502: END IF;
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;

Line 2512: -- Standard call to get message count and return the message info if the count is 1

2508: THEN
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