DBA Data[Home] [Help]

APPS.AMS_LISTDEDUPE_PVT dependencies on FND_API

Line 685: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

681: -- 11-Nov-1999 choang Moved to AMS_ListDedupe_PVT.
682: --------------------------------------------------------------------
683: PROCEDURE Generate_Key (
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
687:
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,

Line 686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

682: --------------------------------------------------------------------
683: PROCEDURE Generate_Key (
684: p_api_version IN NUMBER,
685: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
686: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
687:
688: x_return_status OUT NOCOPY VARCHAR2,
689: x_msg_count OUT NOCOPY NUMBER,
690: x_msg_data OUT NOCOPY VARCHAR2,

Line 742: IF FND_API.to_boolean (p_init_msg_list) THEN

738:
739: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
740: END IF;
741:
742: IF FND_API.to_boolean (p_init_msg_list) THEN
743: -- Clear out the message buffer.
744: FND_MSG_PUB.initialize;
745: END IF;
746:

Line 747: IF NOT FND_API.compatible_api_call (

743: -- Clear out the message buffer.
744: FND_MSG_PUB.initialize;
745: END IF;
746:
747: IF NOT FND_API.compatible_api_call (
748: l_api_version,
749: p_api_version,
750: l_api_name,
751: g_pkg_name

Line 753: RAISE FND_API.g_exc_unexpected_error;

749: p_api_version,
750: l_api_name,
751: g_pkg_name
752: ) THEN
753: RAISE FND_API.g_exc_unexpected_error;
754: END IF;
755:
756: x_return_status := FND_API.g_ret_sts_success;
757:

Line 756: x_return_status := FND_API.g_ret_sts_success;

752: ) THEN
753: RAISE FND_API.g_exc_unexpected_error;
754: END IF;
755:
756: x_return_status := FND_API.g_ret_sts_success;
757:
758: ----------------------- generate -----------------------
759: IF (AMS_DEBUG_HIGH_ON) THEN
760:

Line 773: RAISE FND_API.g_exc_error;

769: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
770: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_DEDUPE_RULE');
771: FND_MSG_PUB.add;
772: END IF;
773: RAISE FND_API.g_exc_error;
774: END IF;
775: EXIT WHEN c_fields%NOTFOUND;
776:
777: -- if the enable word replacement flag is set we construct the sql

Line 866: p_encoded => FND_API.g_false,

862: -- the allowable key length.
863: x_dedupe_key := SUBSTR (l_dedupe_key, 1, L_KEY_LENGTH);
864:
865: FND_MSG_PUB.count_and_get (
866: p_encoded => FND_API.g_false,
867: p_count => x_msg_count,
868: p_data => x_msg_data
869: );
870:

Line 880: WHEN FND_API.g_exc_error THEN

876:
877: END IF;
878:
879: EXCEPTION
880: WHEN FND_API.g_exc_error THEN
881: x_return_status := FND_API.g_ret_sts_error;
882: FND_MSG_PUB.count_and_get (
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,

Line 881: x_return_status := FND_API.g_ret_sts_error;

877: END IF;
878:
879: EXCEPTION
880: WHEN FND_API.g_exc_error THEN
881: x_return_status := FND_API.g_ret_sts_error;
882: FND_MSG_PUB.count_and_get (
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data

Line 883: p_encoded => FND_API.g_false,

879: EXCEPTION
880: WHEN FND_API.g_exc_error THEN
881: x_return_status := FND_API.g_ret_sts_error;
882: FND_MSG_PUB.count_and_get (
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: WHEN FND_API.g_exc_unexpected_error THEN

Line 887: WHEN FND_API.g_exc_unexpected_error THEN

883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: WHEN FND_API.g_exc_unexpected_error THEN
888: x_return_status := FND_API.g_ret_sts_unexp_error ;
889: FND_MSG_PUB.count_and_get (
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,

Line 888: x_return_status := FND_API.g_ret_sts_unexp_error ;

884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887: WHEN FND_API.g_exc_unexpected_error THEN
888: x_return_status := FND_API.g_ret_sts_unexp_error ;
889: FND_MSG_PUB.count_and_get (
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,
892: p_data => x_msg_data

Line 890: p_encoded => FND_API.g_false,

886: );
887: WHEN FND_API.g_exc_unexpected_error THEN
888: x_return_status := FND_API.g_ret_sts_unexp_error ;
889: FND_MSG_PUB.count_and_get (
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );
894: WHEN OTHERS THEN

Line 895: x_return_status := FND_API.g_ret_sts_unexp_error;

891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );
894: WHEN OTHERS THEN
895: x_return_status := FND_API.g_ret_sts_unexp_error;
896: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
897: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
898: END IF;
899:

Line 901: p_encoded => FND_API.g_false,

897: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
898: END IF;
899:
900: FND_MSG_PUB.count_and_get (
901: p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905: END Generate_Key;