DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_MSG_PUB

Line 270: fnd_msg_pub.initialize;

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

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 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 446: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);
450: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

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 455: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

Line 462: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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);
466: ROLLBACK TO resolve_address_pub;

Line 463: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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);
466: ROLLBACK TO resolve_address_pub;
467: END resolve_address;

Line 465: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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);
466: ROLLBACK TO resolve_address_pub;
467: END resolve_address;
468:
469: FUNCTION are_addresses_equal(

Line 728: fnd_msg_pub.initialize;

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

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 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);

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;
780: 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 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);

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;
826: 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 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);

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;
874: 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 894: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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);
898: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

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 903: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

Line 911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);
915: END create_resource_party_link;

Line 912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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);
915: END create_resource_party_link;
916:

Line 914: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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);
915: END create_resource_party_link;
916:
917: PROCEDURE get_resource_address(
918: p_api_version IN NUMBER

Line 952: fnd_msg_pub.initialize;

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

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 1082: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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);
1086: debug('Unexpected Error: ' || x_msg_data, l_api_name, fnd_log.level_unexpected);

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 1091: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

Line 1099: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);
1103: END get_resource_address;

Line 1100: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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);
1103: END get_resource_address;
1104:

Line 1102: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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);
1103: END get_resource_address;
1104:
1105: PROCEDURE get_resource_party_info(
1106: p_api_version IN NUMBER