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_RESOURCE_ADDRESS_PVT dependencies on FND_API

Line 327: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

323: BEGIN
324: SAVEPOINT resolve_address_pub;
325:
326: -- Check for API Compatibility
327: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330:
331: -- Initialize Message Stack if required

Line 328: RAISE fnd_api.g_exc_unexpected_error;

324: SAVEPOINT resolve_address_pub;
325:
326: -- Check for API Compatibility
327: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330:
331: -- Initialize Message Stack if required
332: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 332: IF fnd_api.to_boolean(p_init_msg_list) THEN

328: RAISE fnd_api.g_exc_unexpected_error;
329: END IF;
330:
331: -- Initialize Message Stack if required
332: IF fnd_api.to_boolean(p_init_msg_list) THEN
333: fnd_msg_pub.initialize;
334: END IF;
335:
336: -- Initialize Return Status

Line 337: x_return_status := fnd_api.g_ret_sts_success;

333: fnd_msg_pub.initialize;
334: END IF;
335:
336: -- Initialize Return Status
337: x_return_status := fnd_api.g_ret_sts_success;
338: OPEN c_location_locking_info;
339: FETCH c_location_locking_info INTO l_location_ovn, l_geometry, l_geom_status_code ;
340: CLOSE c_location_locking_info;
341:

Line 364: l_update_addr := NVL(fnd_api.to_boolean(p_update_address), FALSE);

360: END IF;
361: END IF;
362:
363: --Update the address details only when address is valid
364: l_update_addr := NVL(fnd_api.to_boolean(p_update_address), FALSE);
365:
366: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
367: IF l_debug THEN
368: debug('CSF: Location Finder Installed = ' || fnd_profile.VALUE('CSF_LF_INSTALLED'), l_api_name, fnd_log.level_statement);

Line 436: IF x_return_status <> fnd_api.g_ret_sts_success THEN

432: debug('l_road = ' || l_road, l_api_name, fnd_log.level_statement);
433: END IF;
434: END IF;
435:
436: IF x_return_status <> fnd_api.g_ret_sts_success THEN
437: x_msg_data := l_msg_data;
438: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
439: fnd_message.set_name ('CSF', 'CSF_LF_RAISED_ERROR');
440: fnd_message.set_token ('LOCATION_ID',p_location_id);

Line 549: if x_return_status <> fnd_api.g_ret_sts_success then

545: , x_msg_count => x_msg_count
546: , x_msg_data => l_msg_data );
547: END IF;
548:
549: if x_return_status <> fnd_api.g_ret_sts_success then
550: x_msg_data := l_msg_data;
551: debug('Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
552: fnd_message.set_name ('CSF', 'CSF_HZ_UPD_LOC_ERROR');
553: fnd_message.set_token ('LOCATION_ID', p_location_id);

Line 560: RAISE fnd_api.g_exc_error;

556: IF (l_resultarray IS NULL OR l_resultarray.COUNT > 1) THEN
557: IF l_debug THEN
558: debug('CSF_LF_PUB.RESOLVE didnt return proper result.. So Error', l_api_name, fnd_log.level_error);
559: END IF;
560: RAISE fnd_api.g_exc_error;
561: END IF;
562:
563: IF fnd_api.to_boolean(p_commit) THEN
564: COMMIT;

Line 563: IF fnd_api.to_boolean(p_commit) THEN

559: END IF;
560: RAISE fnd_api.g_exc_error;
561: END IF;
562:
563: IF fnd_api.to_boolean(p_commit) THEN
564: COMMIT;
565: END IF;
566:
567: IF l_debug THEN

Line 573: WHEN fnd_api.g_exc_error THEN

569: debug('Resolve address API completed with:' || x_return_status, l_api_name, fnd_log.level_procedure);
570: END IF;
571:
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN
574: if l_debug then
575: debug('Expected Error: ' || fnd_message.get, l_api_name, fnd_log.level_error);
576: END IF;
577: ROLLBACK TO resolve_address_pub;

Line 578: x_return_status := fnd_api.g_ret_sts_error;

574: if l_debug then
575: debug('Expected Error: ' || fnd_message.get, l_api_name, fnd_log.level_error);
576: END IF;
577: ROLLBACK TO resolve_address_pub;
578: x_return_status := fnd_api.g_ret_sts_error;
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: IF l_debug THEN
581: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
582: END IF;

Line 579: WHEN fnd_api.g_exc_unexpected_error THEN

575: debug('Expected Error: ' || fnd_message.get, l_api_name, fnd_log.level_error);
576: END IF;
577: ROLLBACK TO resolve_address_pub;
578: x_return_status := fnd_api.g_ret_sts_error;
579: WHEN fnd_api.g_exc_unexpected_error THEN
580: IF l_debug THEN
581: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
582: END IF;
583: ROLLBACK TO resolve_address_pub;

Line 584: x_return_status := fnd_api.g_ret_sts_unexp_error;

580: IF l_debug THEN
581: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
582: END IF;
583: ROLLBACK TO resolve_address_pub;
584: x_return_status := fnd_api.g_ret_sts_unexp_error;
585: WHEN OTHERS THEN
586: IF l_debug THEN
587: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
588: END IF;

Line 589: x_return_status := fnd_api.g_ret_sts_unexp_error;

585: WHEN OTHERS THEN
586: IF l_debug THEN
587: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
588: END IF;
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
591: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
592: END IF;
593: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

855: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
856: END IF;
857:
858: -- Check for API Compatibility
859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
860: RAISE fnd_api.g_exc_unexpected_error;
861: END IF;
862:
863: -- Initialize Message Stack if required

Line 860: RAISE fnd_api.g_exc_unexpected_error;

856: END IF;
857:
858: -- Check for API Compatibility
859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
860: RAISE fnd_api.g_exc_unexpected_error;
861: END IF;
862:
863: -- Initialize Message Stack if required
864: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 864: IF fnd_api.to_boolean(p_init_msg_list) THEN

860: RAISE fnd_api.g_exc_unexpected_error;
861: END IF;
862:
863: -- Initialize Message Stack if required
864: IF fnd_api.to_boolean(p_init_msg_list) THEN
865: fnd_msg_pub.initialize;
866: END IF;
867:
868: -- Initialize Return Status

Line 869: x_return_status := fnd_api.g_ret_sts_success;

865: fnd_msg_pub.initialize;
866: END IF;
867:
868: -- Initialize Return Status
869: x_return_status := fnd_api.g_ret_sts_success;
870:
871: -- SAVEPOINT create_party;
872:
873: -- Street and Country are NOT NULL columns in HZ_LOCATIONS

Line 905: p_init_msg_list => fnd_api.g_false

901:
902: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
903:
904: hz_location_v2pub.create_location(
905: p_init_msg_list => fnd_api.g_false
906: , p_location_rec => l_location_rec
907: , x_return_status => x_return_status
908: , x_msg_count => x_msg_count
909: , x_msg_data => x_msg_data

Line 912: IF x_return_status <> fnd_api.g_ret_sts_success THEN

908: , x_msg_count => x_msg_count
909: , x_msg_data => x_msg_data
910: , x_location_id => p_address.location_id
911: );
912: IF x_return_status <> fnd_api.g_ret_sts_success THEN
913: IF l_debug THEN
914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
916: END IF;

Line 914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

910: , x_location_id => p_address.location_id
911: );
912: IF x_return_status <> fnd_api.g_ret_sts_success THEN
913: IF l_debug THEN
914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
916: END IF;
917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
918: RAISE fnd_api.g_exc_unexpected_error;

Line 917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

913: IF l_debug THEN
914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
916: END IF;
917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920: RAISE fnd_api.g_exc_error;
921: ELSE

Line 918: RAISE fnd_api.g_exc_unexpected_error;

914: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
915: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
916: END IF;
917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920: RAISE fnd_api.g_exc_error;
921: ELSE
922: IF l_debug THEN

Line 920: RAISE fnd_api.g_exc_error;

916: END IF;
917: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920: RAISE fnd_api.g_exc_error;
921: ELSE
922: IF l_debug THEN
923: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
924: END IF;

Line 948: p_init_msg_list => fnd_api.g_false

944: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
945: END IF;
946:
947: hz_party_v2pub.create_person(
948: p_init_msg_list => fnd_api.g_false
949: , p_person_rec => l_person_rec
950: , x_return_status => x_return_status
951: , x_msg_count => x_msg_count
952: , x_msg_data => x_msg_data

Line 958: IF x_return_status <> fnd_api.g_ret_sts_success THEN

954: , x_party_number => l_party_number
955: , x_profile_id => l_profile_id
956: );
957:
958: IF x_return_status <> fnd_api.g_ret_sts_success THEN
959: IF l_debug THEN
960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
962: END IF;

Line 960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

956: );
957:
958: IF x_return_status <> fnd_api.g_ret_sts_success THEN
959: IF l_debug THEN
960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
962: END IF;
963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
964: RAISE fnd_api.g_exc_unexpected_error;

Line 963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

959: IF l_debug THEN
960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
962: END IF;
963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
964: RAISE fnd_api.g_exc_unexpected_error;
965: END IF;
966: RAISE fnd_api.g_exc_error;
967: ELSE

Line 964: RAISE fnd_api.g_exc_unexpected_error;

960: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
961: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
962: END IF;
963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
964: RAISE fnd_api.g_exc_unexpected_error;
965: END IF;
966: RAISE fnd_api.g_exc_error;
967: ELSE
968: IF l_debug THEN

Line 966: RAISE fnd_api.g_exc_error;

962: END IF;
963: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
964: RAISE fnd_api.g_exc_unexpected_error;
965: END IF;
966: RAISE fnd_api.g_exc_error;
967: ELSE
968: IF l_debug THEN
969: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
970: END IF;

Line 997: p_init_msg_list => fnd_api.g_false

993: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
994: END IF;
995:
996: hz_party_site_v2pub.create_party_site(
997: p_init_msg_list => fnd_api.g_false
998: , p_party_site_rec => l_party_site_rec
999: , x_return_status => x_return_status
1000: , x_msg_count => x_msg_count
1001: , x_msg_data => x_msg_data

Line 1006: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1002: , x_party_site_id => p_address.party_site_id
1003: , x_party_site_number => l_party_site_number
1004: );
1005:
1006: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1007: IF l_debug THEN
1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1010: END IF;

Line 1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1004: );
1005:
1006: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1007: IF l_debug THEN
1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1010: END IF;
1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1012: RAISE fnd_api.g_exc_unexpected_error;

Line 1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1007: IF l_debug THEN
1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1010: END IF;
1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END IF;
1014: RAISE fnd_api.g_exc_error;
1015: ELSE

Line 1012: RAISE fnd_api.g_exc_unexpected_error;

1008: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1009: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1010: END IF;
1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END IF;
1014: RAISE fnd_api.g_exc_error;
1015: ELSE
1016: IF l_debug THEN

Line 1014: RAISE fnd_api.g_exc_error;

1010: END IF;
1011: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END IF;
1014: RAISE fnd_api.g_exc_error;
1015: ELSE
1016: IF l_debug THEN
1017: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1018: END IF;

Line 1021: IF fnd_api.to_boolean(p_commit) THEN

1017: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1018: END IF;
1019: END IF;
1020:
1021: IF fnd_api.to_boolean(p_commit) THEN
1022: COMMIT;
1023: END IF;
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN

Line 1025: WHEN fnd_api.g_exc_error THEN

1021: IF fnd_api.to_boolean(p_commit) THEN
1022: COMMIT;
1023: END IF;
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: IF l_debug THEN
1027: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1028: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1029: END IF;

Line 1027: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1023: END IF;
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: IF l_debug THEN
1027: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1028: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1029: END IF;
1030:
1031: -- ROLLBACK TO create_party;

Line 1032: x_return_status := fnd_api.g_ret_sts_error;

1028: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1029: END IF;
1030:
1031: -- ROLLBACK TO create_party;
1032: x_return_status := fnd_api.g_ret_sts_error;
1033: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1034: WHEN fnd_api.g_exc_unexpected_error THEN
1035: IF l_debug THEN
1036: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 1034: WHEN fnd_api.g_exc_unexpected_error THEN

1030:
1031: -- ROLLBACK TO create_party;
1032: x_return_status := fnd_api.g_ret_sts_error;
1033: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1034: WHEN fnd_api.g_exc_unexpected_error THEN
1035: IF l_debug THEN
1036: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1037: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1038: END IF;

Line 1036: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1032: x_return_status := fnd_api.g_ret_sts_error;
1033: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1034: WHEN fnd_api.g_exc_unexpected_error THEN
1035: IF l_debug THEN
1036: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1037: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1038: END IF;
1039:
1040: -- ROLLBACK TO create_party;

Line 1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

1037: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1038: END IF;
1039:
1040: -- ROLLBACK TO create_party;
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1043: WHEN OTHERS THEN
1044: IF l_debug THEN
1045: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1049: x_return_status := fnd_api.g_ret_sts_unexp_error;

1045: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1046: END IF;
1047:
1048: -- ROLLBACK TO create_party;
1049: x_return_status := fnd_api.g_ret_sts_unexp_error;
1050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1051: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1052: END IF;
1053: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1089: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1085: , l_api_name, fnd_log.level_procedure);
1086: END IF;
1087:
1088: -- Check for API Compatibility
1089: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1090: RAISE fnd_api.g_exc_unexpected_error;
1091: END IF;
1092:
1093: -- Initialize Message Stack if required

Line 1090: RAISE fnd_api.g_exc_unexpected_error;

1086: END IF;
1087:
1088: -- Check for API Compatibility
1089: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1090: RAISE fnd_api.g_exc_unexpected_error;
1091: END IF;
1092:
1093: -- Initialize Message Stack if required
1094: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1094: IF fnd_api.to_boolean(p_init_msg_list) THEN

1090: RAISE fnd_api.g_exc_unexpected_error;
1091: END IF;
1092:
1093: -- Initialize Message Stack if required
1094: IF fnd_api.to_boolean(p_init_msg_list) THEN
1095: fnd_msg_pub.initialize;
1096: END IF;
1097:
1098: -- Initialize Return Status

Line 1099: x_return_status := fnd_api.g_ret_sts_success;

1095: fnd_msg_pub.initialize;
1096: END IF;
1097:
1098: -- Initialize Return Status
1099: x_return_status := fnd_api.g_ret_sts_success;
1100:
1101: -- SAVEPOINT resource_party_info;
1102:
1103: G_RES_ADD_PROF := p_res_shift_add;

Line 1181: , p_init_msg_list => fnd_api.g_false

1177: END IF;
1178:
1179: create_resource_party_link(
1180: p_api_version => l_api_version
1181: , p_init_msg_list => fnd_api.g_false
1182: , p_commit => fnd_api.g_false
1183: , x_return_status => x_return_status
1184: , x_msg_count => x_msg_count
1185: , x_msg_data => x_msg_data

Line 1182: , p_commit => fnd_api.g_false

1178:
1179: create_resource_party_link(
1180: p_api_version => l_api_version
1181: , p_init_msg_list => fnd_api.g_false
1182: , p_commit => fnd_api.g_false
1183: , x_return_status => x_return_status
1184: , x_msg_count => x_msg_count
1185: , x_msg_data => x_msg_data
1186: , p_resource_id => p_resource_id

Line 1191: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1187: , p_resource_type => p_resource_type
1188: , p_address => x_address_rec
1189: );
1190:
1191: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1192: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1193: RAISE fnd_api.g_exc_unexpected_error;
1194: END IF;
1195: RAISE fnd_api.g_exc_error;

Line 1192: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1188: , p_address => x_address_rec
1189: );
1190:
1191: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1192: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1193: RAISE fnd_api.g_exc_unexpected_error;
1194: END IF;
1195: RAISE fnd_api.g_exc_error;
1196: END IF;

Line 1193: RAISE fnd_api.g_exc_unexpected_error;

1189: );
1190:
1191: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1192: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1193: RAISE fnd_api.g_exc_unexpected_error;
1194: END IF;
1195: RAISE fnd_api.g_exc_error;
1196: END IF;
1197:

Line 1195: RAISE fnd_api.g_exc_error;

1191: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1192: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1193: RAISE fnd_api.g_exc_unexpected_error;
1194: END IF;
1195: RAISE fnd_api.g_exc_error;
1196: END IF;
1197:
1198: l_validate_address := TRUE;
1199: ELSIF l_home_address.address_id IS NOT NULL AND NOT are_addresses_equal(l_home_address, x_address_rec) THEN

Line 1203: l_change_address := fnd_api.g_true;

1199: ELSIF l_home_address.address_id IS NOT NULL AND NOT are_addresses_equal(l_home_address, x_address_rec) THEN
1200: IF l_debug THEN
1201: debug('Location is already created.... Needs Updation', l_api_name, fnd_log.level_statement);
1202: END IF;
1203: l_change_address := fnd_api.g_true;
1204: l_validate_address := TRUE;
1205:
1206: x_address_rec.street := l_home_address.street;
1207: x_address_rec.city := l_home_address.city;

Line 1245: x_return_status := fnd_api.g_ret_sts_success;

1241: , x_geometry => x_address_rec.geometry
1242: );
1243: END IF;
1244: -- Dont error out . Scheduler will handle it appro.
1245: x_return_status := fnd_api.g_ret_sts_success;
1246: END IF;
1247:
1248: IF l_debug THEN
1249: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);

Line 1253: IF fnd_api.to_boolean(p_commit) THEN

1249: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);
1250: debug(' --> Party Site ID = ' || x_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
1251: END IF;
1252:
1253: IF fnd_api.to_boolean(p_commit) THEN
1254: COMMIT;
1255: END IF;
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN

Line 1257: WHEN fnd_api.g_exc_error THEN

1253: IF fnd_api.to_boolean(p_commit) THEN
1254: COMMIT;
1255: END IF;
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: IF l_debug THEN
1259: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1260: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1261: END IF;

Line 1259: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1255: END IF;
1256: EXCEPTION
1257: WHEN fnd_api.g_exc_error THEN
1258: IF l_debug THEN
1259: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1260: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1261: END IF;
1262:
1263: -- ROLLBACK TO resource_party_info;

Line 1264: x_return_status := fnd_api.g_ret_sts_error;

1260: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1261: END IF;
1262:
1263: -- ROLLBACK TO resource_party_info;
1264: x_return_status := fnd_api.g_ret_sts_error;
1265: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1266: WHEN fnd_api.g_exc_unexpected_error THEN
1267: IF l_debug THEN
1268: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 1266: WHEN fnd_api.g_exc_unexpected_error THEN

1262:
1263: -- ROLLBACK TO resource_party_info;
1264: x_return_status := fnd_api.g_ret_sts_error;
1265: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1266: WHEN fnd_api.g_exc_unexpected_error THEN
1267: IF l_debug THEN
1268: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1269: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1270: END IF;

Line 1268: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1264: x_return_status := fnd_api.g_ret_sts_error;
1265: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1266: WHEN fnd_api.g_exc_unexpected_error THEN
1267: IF l_debug THEN
1268: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1269: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1270: END IF;
1271:
1272: -- ROLLBACK TO resource_party_info;

Line 1273: x_return_status := fnd_api.g_ret_sts_unexp_error;

1269: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1270: END IF;
1271:
1272: -- ROLLBACK TO resource_party_info;
1273: x_return_status := fnd_api.g_ret_sts_unexp_error;
1274: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1275: WHEN OTHERS THEN
1276: IF l_debug THEN
1277: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1281: x_return_status := fnd_api.g_ret_sts_unexp_error;

1277: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1278: END IF;
1279:
1280: -- ROLLBACK TO resource_party_info;
1281: x_return_status := fnd_api.g_ret_sts_unexp_error;
1282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1283: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1284: END IF;
1285: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1317: IF x_return_status = fnd_api.g_ret_sts_success THEN

1313: , p_date => p_date
1314: , x_address_rec => l_address
1315: );
1316:
1317: IF x_return_status = fnd_api.g_ret_sts_success THEN
1318: x_party_id := l_address.party_id;
1319: x_party_site_id := l_address.party_site_id;
1320: x_location_id := l_address.location_id;
1321: END IF;

Line 1361: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1357: END IF;
1358:
1359:
1360: -- Check for API Compatibility
1361: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1362: RAISE fnd_api.g_exc_unexpected_error;
1363: END IF;
1364:
1365: -- Initialize Message Stack if required

Line 1362: RAISE fnd_api.g_exc_unexpected_error;

1358:
1359:
1360: -- Check for API Compatibility
1361: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1362: RAISE fnd_api.g_exc_unexpected_error;
1363: END IF;
1364:
1365: -- Initialize Message Stack if required
1366: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1366: IF fnd_api.to_boolean(p_init_msg_list) THEN

1362: RAISE fnd_api.g_exc_unexpected_error;
1363: END IF;
1364:
1365: -- Initialize Message Stack if required
1366: IF fnd_api.to_boolean(p_init_msg_list) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Initialize Return Status

Line 1371: x_return_status := fnd_api.g_ret_sts_success;

1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Initialize Return Status
1371: x_return_status := fnd_api.g_ret_sts_success;
1372:
1373: SAVEPOINT create_party;
1374:
1375: -- Street and Country are NOT NULL columns in HZ_LOCATIONS

Line 1417: p_init_msg_list => fnd_api.g_false

1413:
1414: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
1415:
1416: hz_location_v2pub.create_location(
1417: p_init_msg_list => fnd_api.g_false
1418: , p_location_rec => l_location_rec
1419: , x_return_status => x_return_status
1420: , x_msg_count => x_msg_count
1421: , x_msg_data => x_msg_data

Line 1425: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1421: , x_msg_data => x_msg_data
1422: , x_location_id => p_address.location_id
1423: );
1424:
1425: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1426: IF l_debug THEN
1427: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1428: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1429: END IF;

Line 1427: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1423: );
1424:
1425: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1426: IF l_debug THEN
1427: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1428: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1429: END IF;
1430:
1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1427: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1428: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1429: END IF;
1430:
1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1432:
1433: RAISE fnd_api.g_exc_unexpected_error;
1434: END IF;
1435: RAISE fnd_api.g_exc_error;

Line 1433: RAISE fnd_api.g_exc_unexpected_error;

1429: END IF;
1430:
1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1432:
1433: RAISE fnd_api.g_exc_unexpected_error;
1434: END IF;
1435: RAISE fnd_api.g_exc_error;
1436: ELSE
1437: IF l_debug THEN

Line 1435: RAISE fnd_api.g_exc_error;

1431: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1432:
1433: RAISE fnd_api.g_exc_unexpected_error;
1434: END IF;
1435: RAISE fnd_api.g_exc_error;
1436: ELSE
1437: IF l_debug THEN
1438: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
1439: END IF;

Line 1463: p_init_msg_list => fnd_api.g_false

1459: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
1460: END IF;
1461:
1462: hz_party_v2pub.create_person(
1463: p_init_msg_list => fnd_api.g_false
1464: , p_person_rec => l_person_rec
1465: , x_return_status => x_return_status
1466: , x_msg_count => x_msg_count
1467: , x_msg_data => x_msg_data

Line 1473: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1469: , x_party_number => l_party_number
1470: , x_profile_id => l_profile_id
1471: );
1472:
1473: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1474: IF l_debug THEN
1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1477: END IF;

Line 1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1471: );
1472:
1473: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1474: IF l_debug THEN
1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1477: END IF;
1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1479: RAISE fnd_api.g_exc_unexpected_error;

Line 1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1474: IF l_debug THEN
1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1477: END IF;
1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;
1481: RAISE fnd_api.g_exc_error;
1482: ELSE

Line 1479: RAISE fnd_api.g_exc_unexpected_error;

1475: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1476: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1477: END IF;
1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;
1481: RAISE fnd_api.g_exc_error;
1482: ELSE
1483: IF l_debug THEN

Line 1481: RAISE fnd_api.g_exc_error;

1477: END IF;
1478: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;
1481: RAISE fnd_api.g_exc_error;
1482: ELSE
1483: IF l_debug THEN
1484: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
1485: END IF;

Line 1512: p_init_msg_list => fnd_api.g_false

1508: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
1509: END IF;
1510:
1511: hz_party_site_v2pub.create_party_site(
1512: p_init_msg_list => fnd_api.g_false
1513: , p_party_site_rec => l_party_site_rec
1514: , x_return_status => x_return_status
1515: , x_msg_count => x_msg_count
1516: , x_msg_data => x_msg_data

Line 1521: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1517: , x_party_site_id => p_address.party_site_id
1518: , x_party_site_number => l_party_site_number
1519: );
1520:
1521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1522: IF l_debug THEN
1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1525: END IF;

Line 1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1519: );
1520:
1521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1522: IF l_debug THEN
1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1525: END IF;
1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1527: RAISE fnd_api.g_exc_unexpected_error;

Line 1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1522: IF l_debug THEN
1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1525: END IF;
1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1527: RAISE fnd_api.g_exc_unexpected_error;
1528: END IF;
1529: RAISE fnd_api.g_exc_error;
1530: ELSE

Line 1527: RAISE fnd_api.g_exc_unexpected_error;

1523: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1524: debug('HZ_PARTY_SITE_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
1525: END IF;
1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1527: RAISE fnd_api.g_exc_unexpected_error;
1528: END IF;
1529: RAISE fnd_api.g_exc_error;
1530: ELSE
1531: IF l_debug THEN

Line 1529: RAISE fnd_api.g_exc_error;

1525: END IF;
1526: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1527: RAISE fnd_api.g_exc_unexpected_error;
1528: END IF;
1529: RAISE fnd_api.g_exc_error;
1530: ELSE
1531: IF l_debug THEN
1532: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1533: END IF;

Line 1536: IF fnd_api.to_boolean(p_commit) THEN

1532: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
1533: END IF;
1534: END IF;
1535:
1536: IF fnd_api.to_boolean(p_commit) THEN
1537: COMMIT;
1538: END IF;
1539:
1540:

Line 1542: WHEN fnd_api.g_exc_error THEN

1538: END IF;
1539:
1540:
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: IF l_debug THEN
1544: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1545: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1546: END IF;

Line 1544: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1540:
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: IF l_debug THEN
1544: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1545: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1546: END IF;
1547:
1548: ROLLBACK TO create_party;

Line 1549: x_return_status := fnd_api.g_ret_sts_error;

1545: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1546: END IF;
1547:
1548: ROLLBACK TO create_party;
1549: x_return_status := fnd_api.g_ret_sts_error;
1550: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1551: WHEN fnd_api.g_exc_unexpected_error THEN
1552: IF l_debug THEN
1553: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 1551: WHEN fnd_api.g_exc_unexpected_error THEN

1547:
1548: ROLLBACK TO create_party;
1549: x_return_status := fnd_api.g_ret_sts_error;
1550: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1551: WHEN fnd_api.g_exc_unexpected_error THEN
1552: IF l_debug THEN
1553: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1554: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1555: END IF;

Line 1553: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

1549: x_return_status := fnd_api.g_ret_sts_error;
1550: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1551: WHEN fnd_api.g_exc_unexpected_error THEN
1552: IF l_debug THEN
1553: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1554: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1555: END IF;
1556:
1557: ROLLBACK TO create_party;

Line 1558: x_return_status := fnd_api.g_ret_sts_unexp_error;

1554: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1555: END IF;
1556:
1557: ROLLBACK TO create_party;
1558: x_return_status := fnd_api.g_ret_sts_unexp_error;
1559: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1560: WHEN OTHERS THEN
1561: IF l_debug THEN
1562: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1566: x_return_status := fnd_api.g_ret_sts_unexp_error;

1562: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1563: END IF;
1564:
1565: ROLLBACK TO create_party;
1566: x_return_status := fnd_api.g_ret_sts_unexp_error;
1567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1569: END IF;
1570: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);