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 264: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

260: BEGIN
261: SAVEPOINT resolve_address_pub;
262:
263: -- Check for API Compatibility
264: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
265: RAISE fnd_api.g_exc_unexpected_error;
266: END IF;
267:
268: -- Initialize Message Stack if required

Line 265: RAISE fnd_api.g_exc_unexpected_error;

261: SAVEPOINT resolve_address_pub;
262:
263: -- Check for API Compatibility
264: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
265: RAISE fnd_api.g_exc_unexpected_error;
266: END IF;
267:
268: -- Initialize Message Stack if required
269: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 269: IF fnd_api.to_boolean(p_init_msg_list) THEN

265: RAISE fnd_api.g_exc_unexpected_error;
266: END IF;
267:
268: -- Initialize Message Stack if required
269: IF fnd_api.to_boolean(p_init_msg_list) THEN
270: fnd_msg_pub.initialize;
271: END IF;
272:
273: -- Initialize Return Status

Line 274: x_return_status := fnd_api.g_ret_sts_success;

270: fnd_msg_pub.initialize;
271: END IF;
272:
273: -- Initialize Return Status
274: x_return_status := fnd_api.g_ret_sts_success;
275:
276: IF l_debug THEN
277: debug('Resolving the Address corresponding to Location #' || p_location_id, l_api_name, fnd_log.level_procedure);
278: debug(' --> Address1 = ' || p_address1, l_api_name, fnd_log.level_statement);

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

283: debug(' --> Country Code = ' || p_country_code, l_api_name, fnd_log.level_statement);
284: debug(' --> Update Addr = ' || p_update_address, l_api_name, fnd_log.level_statement);
285: END IF;
286:
287: l_update_addr := NVL(fnd_api.to_boolean(p_update_address), FALSE);
288: l_update_geo := FALSE;
289:
290: -- Location Finder Profiles. Check whether Resolve Address needs to be called.
291: IF l_debug THEN

Line 327: IF x_return_status <> fnd_api.g_ret_sts_success THEN

323: , p_alternate => NVL(l_roadname, '_')
324: , x_resultsarray => l_resultarray
325: );
326:
327: IF x_return_status <> fnd_api.g_ret_sts_success THEN
328: IF l_debug THEN
329: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
330: debug('CSF_LF_PUB.RESOLVE returned error: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
331: END IF;

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

325: );
326:
327: IF x_return_status <> fnd_api.g_ret_sts_success THEN
328: IF l_debug THEN
329: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
330: debug('CSF_LF_PUB.RESOLVE returned error: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
331: END IF;
332: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
333: RAISE fnd_api.g_exc_unexpected_error;

Line 332: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

328: IF l_debug THEN
329: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
330: debug('CSF_LF_PUB.RESOLVE returned error: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
331: END IF;
332: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335: RAISE fnd_api.g_exc_error;
336: END IF;

Line 333: RAISE fnd_api.g_exc_unexpected_error;

329: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
330: debug('CSF_LF_PUB.RESOLVE returned error: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
331: END IF;
332: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335: RAISE fnd_api.g_exc_error;
336: END IF;
337:

Line 335: RAISE fnd_api.g_exc_error;

331: END IF;
332: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
333: RAISE fnd_api.g_exc_unexpected_error;
334: END IF;
335: RAISE fnd_api.g_exc_error;
336: END IF;
337:
338: IF (l_resultarray IS NULL OR l_resultarray.COUNT > 1) THEN
339: IF l_debug THEN

Line 342: RAISE fnd_api.g_exc_error;

338: IF (l_resultarray IS NULL OR l_resultarray.COUNT > 1) THEN
339: IF l_debug THEN
340: debug('CSF_LF_PUB.RESOLVE didnt return proper result.. So Error', l_api_name, fnd_log.level_error);
341: END IF;
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:
345: x_geometry := l_resultarray(1).locus;
346: l_update_geo := TRUE;

Line 433: IF fnd_api.to_boolean(p_commit) THEN

429: , x_msg_data => x_msg_data );
430:
431: END IF;
432:
433: IF fnd_api.to_boolean(p_commit) THEN
434: COMMIT;
435: END IF;
436:
437: EXCEPTION

Line 438: WHEN fnd_api.g_exc_error THEN

434: COMMIT;
435: END IF;
436:
437: EXCEPTION
438: WHEN fnd_api.g_exc_error THEN
439: IF l_debug THEN
440: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
441: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
442: END IF;

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

436:
437: EXCEPTION
438: WHEN fnd_api.g_exc_error THEN
439: IF l_debug THEN
440: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
441: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
442: END IF;
443:
444: ROLLBACK TO resolve_address_pub;

Line 445: x_return_status := fnd_api.g_ret_sts_error;

441: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
442: END IF;
443:
444: ROLLBACK TO resolve_address_pub;
445: x_return_status := fnd_api.g_ret_sts_error;
446: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
447: WHEN fnd_api.g_exc_unexpected_error THEN
448: IF l_debug THEN
449: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 447: WHEN fnd_api.g_exc_unexpected_error THEN

443:
444: ROLLBACK TO resolve_address_pub;
445: x_return_status := fnd_api.g_ret_sts_error;
446: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
447: WHEN fnd_api.g_exc_unexpected_error THEN
448: IF l_debug THEN
449: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
450: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
451: END IF;

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

445: x_return_status := fnd_api.g_ret_sts_error;
446: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
447: WHEN fnd_api.g_exc_unexpected_error THEN
448: IF l_debug THEN
449: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
450: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
451: END IF;
452:
453: ROLLBACK TO resolve_address_pub;

Line 454: x_return_status := fnd_api.g_ret_sts_unexp_error;

450: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
451: END IF;
452:
453: ROLLBACK TO resolve_address_pub;
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
456: WHEN OTHERS THEN
457: IF l_debug THEN
458: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 461: x_return_status := fnd_api.g_ret_sts_unexp_error;

457: IF l_debug THEN
458: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
459: END IF;
460:
461: x_return_status := fnd_api.g_ret_sts_unexp_error;
462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
463: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
464: END IF;
465: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

718: debug('Creating the Resource Party Link for Resource ID = ' || p_resource_id, l_api_name, fnd_log.level_procedure);
719: END IF;
720:
721: -- Check for API Compatibility
722: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
723: RAISE fnd_api.g_exc_unexpected_error;
724: END IF;
725:
726: -- Initialize Message Stack if required

Line 723: RAISE fnd_api.g_exc_unexpected_error;

719: END IF;
720:
721: -- Check for API Compatibility
722: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
723: RAISE fnd_api.g_exc_unexpected_error;
724: END IF;
725:
726: -- Initialize Message Stack if required
727: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 727: IF fnd_api.to_boolean(p_init_msg_list) THEN

723: RAISE fnd_api.g_exc_unexpected_error;
724: END IF;
725:
726: -- Initialize Message Stack if required
727: IF fnd_api.to_boolean(p_init_msg_list) THEN
728: fnd_msg_pub.initialize;
729: END IF;
730:
731: -- Initialize Return Status

Line 732: x_return_status := fnd_api.g_ret_sts_success;

728: fnd_msg_pub.initialize;
729: END IF;
730:
731: -- Initialize Return Status
732: x_return_status := fnd_api.g_ret_sts_success;
733:
734: SAVEPOINT create_party;
735:
736: -- Street and Country are NOT NULL columns in HZ_LOCATIONS

Line 766: p_init_msg_list => fnd_api.g_false

762:
763: l_location_rec.created_by_module := 'CSFDEAR'; -- Calling Module 'CSF: Departure Arrival'
764:
765: hz_location_v2pub.create_location(
766: p_init_msg_list => fnd_api.g_false
767: , p_location_rec => l_location_rec
768: , x_return_status => x_return_status
769: , x_msg_count => x_msg_count
770: , x_msg_data => x_msg_data

Line 773: IF x_return_status <> fnd_api.g_ret_sts_success THEN

769: , x_msg_count => x_msg_count
770: , x_msg_data => x_msg_data
771: , x_location_id => p_address.location_id
772: );
773: IF x_return_status <> fnd_api.g_ret_sts_success THEN
774: IF l_debug THEN
775: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
777: END IF;

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

771: , x_location_id => p_address.location_id
772: );
773: IF x_return_status <> fnd_api.g_ret_sts_success THEN
774: IF l_debug THEN
775: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
777: END IF;
778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
779: RAISE fnd_api.g_exc_unexpected_error;

Line 778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

774: IF l_debug THEN
775: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
777: END IF;
778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;
781: RAISE fnd_api.g_exc_error;
782: ELSE

Line 779: RAISE fnd_api.g_exc_unexpected_error;

775: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
776: debug('HZ_LOCATION_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
777: END IF;
778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;
781: RAISE fnd_api.g_exc_error;
782: ELSE
783: IF l_debug THEN

Line 781: RAISE fnd_api.g_exc_error;

777: END IF;
778: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;
781: RAISE fnd_api.g_exc_error;
782: ELSE
783: IF l_debug THEN
784: debug('HZ_LOCATION_V2PUB.CREATE was successful. Location ID = ' || p_address.location_id, l_api_name, fnd_log.level_statement);
785: END IF;

Line 809: p_init_msg_list => fnd_api.g_false

805: debug(' --> Last Name = ' || l_person_rec.person_last_name, l_api_name, fnd_log.level_statement);
806: END IF;
807:
808: hz_party_v2pub.create_person(
809: p_init_msg_list => fnd_api.g_false
810: , p_person_rec => l_person_rec
811: , x_return_status => x_return_status
812: , x_msg_count => x_msg_count
813: , x_msg_data => x_msg_data

Line 819: IF x_return_status <> fnd_api.g_ret_sts_success THEN

815: , x_party_number => l_party_number
816: , x_profile_id => l_profile_id
817: );
818:
819: IF x_return_status <> fnd_api.g_ret_sts_success THEN
820: IF l_debug THEN
821: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
822: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
823: END IF;

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

817: );
818:
819: IF x_return_status <> fnd_api.g_ret_sts_success THEN
820: IF l_debug THEN
821: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
822: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
823: END IF;
824: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
825: RAISE fnd_api.g_exc_unexpected_error;

Line 824: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

820: IF l_debug THEN
821: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
822: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
823: END IF;
824: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
825: RAISE fnd_api.g_exc_unexpected_error;
826: END IF;
827: RAISE fnd_api.g_exc_error;
828: ELSE

Line 825: RAISE fnd_api.g_exc_unexpected_error;

821: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
822: debug('HZ_PARTY_V2PUB.CREATE returned error: Error = ' || fnd_msg_pub.get(fnd_msg_pub.g_last), l_api_name, fnd_log.level_error);
823: END IF;
824: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
825: RAISE fnd_api.g_exc_unexpected_error;
826: END IF;
827: RAISE fnd_api.g_exc_error;
828: ELSE
829: IF l_debug THEN

Line 827: RAISE fnd_api.g_exc_error;

823: END IF;
824: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
825: RAISE fnd_api.g_exc_unexpected_error;
826: END IF;
827: RAISE fnd_api.g_exc_error;
828: ELSE
829: IF l_debug THEN
830: debug('HZ_PARTY_V2PUB.CREATE_P was successful: Party ID = ' || p_address.party_id, l_api_name, fnd_log.level_statement);
831: END IF;

Line 858: p_init_msg_list => fnd_api.g_false

854: debug(' --> Location ID = ' || l_party_site_rec.location_id, l_api_name, fnd_log.level_statement);
855: END IF;
856:
857: hz_party_site_v2pub.create_party_site(
858: p_init_msg_list => fnd_api.g_false
859: , p_party_site_rec => l_party_site_rec
860: , x_return_status => x_return_status
861: , x_msg_count => x_msg_count
862: , x_msg_data => x_msg_data

Line 867: IF x_return_status <> fnd_api.g_ret_sts_success THEN

863: , x_party_site_id => p_address.party_site_id
864: , x_party_site_number => l_party_site_number
865: );
866:
867: IF x_return_status <> fnd_api.g_ret_sts_success THEN
868: IF l_debug THEN
869: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
870: 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);
871: END IF;

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

865: );
866:
867: IF x_return_status <> fnd_api.g_ret_sts_success THEN
868: IF l_debug THEN
869: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
870: 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);
871: END IF;
872: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
873: RAISE fnd_api.g_exc_unexpected_error;

Line 872: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

868: IF l_debug THEN
869: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
870: 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);
871: END IF;
872: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
873: RAISE fnd_api.g_exc_unexpected_error;
874: END IF;
875: RAISE fnd_api.g_exc_error;
876: ELSE

Line 873: RAISE fnd_api.g_exc_unexpected_error;

869: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
870: 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);
871: END IF;
872: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
873: RAISE fnd_api.g_exc_unexpected_error;
874: END IF;
875: RAISE fnd_api.g_exc_error;
876: ELSE
877: IF l_debug THEN

Line 875: RAISE fnd_api.g_exc_error;

871: END IF;
872: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
873: RAISE fnd_api.g_exc_unexpected_error;
874: END IF;
875: RAISE fnd_api.g_exc_error;
876: ELSE
877: IF l_debug THEN
878: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
879: END IF;

Line 882: IF fnd_api.to_boolean(p_commit) THEN

878: debug('HZ_PARTY_SITE_V2PUB.CREATE_PS was successful. Party Site ID = ' || p_address.party_site_id, l_api_name, fnd_log.level_error);
879: END IF;
880: END IF;
881:
882: IF fnd_api.to_boolean(p_commit) THEN
883: COMMIT;
884: END IF;
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN

Line 886: WHEN fnd_api.g_exc_error THEN

882: IF fnd_api.to_boolean(p_commit) THEN
883: COMMIT;
884: END IF;
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN
887: IF l_debug THEN
888: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
889: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
890: END IF;

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

884: END IF;
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN
887: IF l_debug THEN
888: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
889: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
890: END IF;
891:
892: ROLLBACK TO create_party;

Line 893: x_return_status := fnd_api.g_ret_sts_error;

889: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
890: END IF;
891:
892: ROLLBACK TO create_party;
893: x_return_status := fnd_api.g_ret_sts_error;
894: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
895: WHEN fnd_api.g_exc_unexpected_error THEN
896: IF l_debug THEN
897: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 895: WHEN fnd_api.g_exc_unexpected_error THEN

891:
892: ROLLBACK TO create_party;
893: x_return_status := fnd_api.g_ret_sts_error;
894: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
895: WHEN fnd_api.g_exc_unexpected_error THEN
896: IF l_debug THEN
897: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
898: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
899: END IF;

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

893: x_return_status := fnd_api.g_ret_sts_error;
894: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
895: WHEN fnd_api.g_exc_unexpected_error THEN
896: IF l_debug THEN
897: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
898: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
899: END IF;
900:
901: ROLLBACK TO create_party;

Line 902: x_return_status := fnd_api.g_ret_sts_unexp_error;

898: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
899: END IF;
900:
901: ROLLBACK TO create_party;
902: x_return_status := fnd_api.g_ret_sts_unexp_error;
903: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
904: WHEN OTHERS THEN
905: IF l_debug THEN
906: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 910: x_return_status := fnd_api.g_ret_sts_unexp_error;

906: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
907: END IF;
908:
909: ROLLBACK TO create_party;
910: x_return_status := fnd_api.g_ret_sts_unexp_error;
911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;
914: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

942: , l_api_name, fnd_log.level_procedure);
943: END IF;
944:
945: -- Check for API Compatibility
946: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;
949:
950: -- Initialize Message Stack if required

Line 947: RAISE fnd_api.g_exc_unexpected_error;

943: END IF;
944:
945: -- Check for API Compatibility
946: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;
949:
950: -- Initialize Message Stack if required
951: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 951: IF fnd_api.to_boolean(p_init_msg_list) THEN

947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;
949:
950: -- Initialize Message Stack if required
951: IF fnd_api.to_boolean(p_init_msg_list) THEN
952: fnd_msg_pub.initialize;
953: END IF;
954:
955: -- Initialize Return Status

Line 956: x_return_status := fnd_api.g_ret_sts_success;

952: fnd_msg_pub.initialize;
953: END IF;
954:
955: -- Initialize Return Status
956: x_return_status := fnd_api.g_ret_sts_success;
957:
958: SAVEPOINT resource_party_info;
959:
960: -- Get the Resource Home address as stored in HRMS for the Resource.

Line 1001: , p_init_msg_list => fnd_api.g_false

997: debug('Since Location is not created.... Creating it', l_api_name, fnd_log.level_statement);
998: END IF;
999: create_resource_party_link(
1000: p_api_version => l_api_version
1001: , p_init_msg_list => fnd_api.g_false
1002: , p_commit => fnd_api.g_false
1003: , x_return_status => x_return_status
1004: , x_msg_count => x_msg_count
1005: , x_msg_data => x_msg_data

Line 1002: , p_commit => fnd_api.g_false

998: END IF;
999: create_resource_party_link(
1000: p_api_version => l_api_version
1001: , p_init_msg_list => fnd_api.g_false
1002: , p_commit => fnd_api.g_false
1003: , x_return_status => x_return_status
1004: , x_msg_count => x_msg_count
1005: , x_msg_data => x_msg_data
1006: , p_resource_id => p_resource_id

Line 1011: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1007: , p_resource_type => p_resource_type
1008: , p_address => x_address_rec
1009: );
1010:
1011: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1012: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015: RAISE fnd_api.g_exc_error;

Line 1012: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1008: , p_address => x_address_rec
1009: );
1010:
1011: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1012: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015: RAISE fnd_api.g_exc_error;
1016: END IF;

Line 1013: RAISE fnd_api.g_exc_unexpected_error;

1009: );
1010:
1011: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1012: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015: RAISE fnd_api.g_exc_error;
1016: END IF;
1017:

Line 1015: RAISE fnd_api.g_exc_error;

1011: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1012: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015: RAISE fnd_api.g_exc_error;
1016: END IF;
1017:
1018: l_validate_address := TRUE;
1019: ELSIF l_home_address.address_id IS NOT NULL AND NOT are_addresses_equal(l_home_address, x_address_rec) THEN

Line 1023: l_change_address := fnd_api.g_true;

1019: ELSIF l_home_address.address_id IS NOT NULL AND NOT are_addresses_equal(l_home_address, x_address_rec) THEN
1020: IF l_debug THEN
1021: debug('Location is already created.... Needs Updation', l_api_name, fnd_log.level_statement);
1022: END IF;
1023: l_change_address := fnd_api.g_true;
1024: l_validate_address := TRUE;
1025:
1026: x_address_rec.street := l_home_address.street;
1027: x_address_rec.city := l_home_address.city;

Line 1062: x_return_status := fnd_api.g_ret_sts_success;

1058: , x_geometry => x_address_rec.geometry
1059: );
1060:
1061: -- Dont error out . Scheduler will handle it appro.
1062: x_return_status := fnd_api.g_ret_sts_success;
1063: END IF;
1064:
1065: IF l_debug THEN
1066: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);

Line 1070: IF fnd_api.to_boolean(p_commit) THEN

1066: debug('Returning Resource Party Info', l_api_name, fnd_log.level_statement);
1067: debug(' --> Party Site ID = ' || x_address_rec.party_site_id, l_api_name, fnd_log.level_statement);
1068: END IF;
1069:
1070: IF fnd_api.to_boolean(p_commit) THEN
1071: COMMIT;
1072: END IF;
1073: EXCEPTION
1074: WHEN fnd_api.g_exc_error THEN

Line 1074: WHEN fnd_api.g_exc_error THEN

1070: IF fnd_api.to_boolean(p_commit) THEN
1071: COMMIT;
1072: END IF;
1073: EXCEPTION
1074: WHEN fnd_api.g_exc_error THEN
1075: IF l_debug THEN
1076: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1077: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1078: END IF;

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

1072: END IF;
1073: EXCEPTION
1074: WHEN fnd_api.g_exc_error THEN
1075: IF l_debug THEN
1076: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1077: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1078: END IF;
1079:
1080: ROLLBACK TO resource_party_info;

Line 1081: x_return_status := fnd_api.g_ret_sts_error;

1077: debug('Expected Error: ' || x_msg_data, l_api_name, fnd_log.level_error);
1078: END IF;
1079:
1080: ROLLBACK TO resource_party_info;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: IF l_debug THEN
1085: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);

Line 1083: WHEN fnd_api.g_exc_unexpected_error THEN

1079:
1080: ROLLBACK TO resource_party_info;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: IF l_debug THEN
1085: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1086: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1087: END IF;

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

1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: IF l_debug THEN
1085: fnd_msg_pub.count_and_get(fnd_api.g_false, x_msg_count, x_msg_data);
1086: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1087: END IF;
1088:
1089: ROLLBACK TO resource_party_info;

Line 1090: x_return_status := fnd_api.g_ret_sts_unexp_error;

1086: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);
1087: END IF;
1088:
1089: ROLLBACK TO resource_party_info;
1090: x_return_status := fnd_api.g_ret_sts_unexp_error;
1091: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1092: WHEN OTHERS THEN
1093: IF l_debug THEN
1094: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1098: x_return_status := fnd_api.g_ret_sts_unexp_error;

1094: debug('Exception: SQLCODE = ' || SQLCODE || ' : SQLERRM = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1095: END IF;
1096:
1097: ROLLBACK TO resource_party_info;
1098: x_return_status := fnd_api.g_ret_sts_unexp_error;
1099: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1100: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1101: END IF;
1102: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1134: IF x_return_status = fnd_api.g_ret_sts_success THEN

1130: , p_date => p_date
1131: , x_address_rec => l_address
1132: );
1133:
1134: IF x_return_status = fnd_api.g_ret_sts_success THEN
1135: x_party_id := l_address.party_id;
1136: x_party_site_id := l_address.party_site_id;
1137: x_location_id := l_address.location_id;
1138: END IF;