eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASK_ADDRESS_PVT dependencies on STANDARD

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

379: put_stream (g_log, l_msg_succ);
380: put_stream (g_output, l_msg_succ);
381: -- End of API body
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

Line 442: -- Standard check for call compatibility

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

Line 646: -- Standard check of p_commit

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

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

648: THEN
649: COMMIT WORK;
650: END IF;
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

Line 947: -- Standard check for call compatibility

943: cursor mdsListCur is
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

Line 995: -- Standard check of p_commit

991: p_unstamped_only);
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;

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

997: THEN
998: COMMIT WORK;
999: END IF;
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

Line 1050: -- Standard check for call compatibility

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

Line 1090: -- Standard check of p_commit

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

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

1092: THEN
1093: COMMIT WORK;
1094: END IF;
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

Line 1159: -- Standard check for call compatibility

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

Line 1203: -- Standard check of p_commit

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

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

1205: THEN
1206: COMMIT WORK;
1207: END IF;
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

Line 1283: -- Standard check for call compatibility

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

Line 1622: -- Standard check of p_commit

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

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

1624: THEN
1625: COMMIT WORK;
1626: END IF;
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

Line 1677: -- Standard check for call compatibility

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

Line 1833: -- Standard check of p_commit

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

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

1835: THEN
1836: COMMIT WORK;
1837: END IF;
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

Line 1880: -- Standard check for call compatibility

1876: l_api_version CONSTANT NUMBER := 1.0;
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

Line 1986: -- Standard check for call compatibility

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

Line 2382: -- Standard check for call compatibility

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

Line 2514: -- Standard check of p_commit

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

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

2516: THEN
2517: COMMIT WORK;
2518: END IF;
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

Line 2621: -- Standard check for call compatibility

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

Line 2767: -- Standard check of p_commit

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

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

2769: THEN
2770: COMMIT WORK;
2771: END IF;
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

Line 2889: -- Standard check for call compatibility

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

Line 2960: -- Standard check of p_commit

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

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

2962: THEN
2963: COMMIT WORK;
2964: END IF;
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