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.AMS_COMPETITOR_PRODUCT_PVT dependencies on AMS_UTILITY_PVT

Line 84: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

80:
81: -- Debug Message
82: IF (AMS_DEBUG_HIGH_ON) THEN
83:
84: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
85: END IF;
86:
87:
88: -- Initialize API return status to SUCCESS

Line 116: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

112: -- =========================================================================
113:
114: IF FND_GLOBAL.User_Id IS NULL
115: THEN
116: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;
119:
120: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 125: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ams_Comp_Product');

121: THEN
122: -- Debug message
123: IF (AMS_DEBUG_HIGH_ON) THEN
124:
125: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ams_Comp_Product');
126: END IF;
127:
128: -- Invoke validation procedures
129: Validate_comp_prod(

Line 207: WHEN AMS_Utility_PVT.resource_locked THEN

203: p_data => x_msg_data
204: );
205: EXCEPTION
206:
207: WHEN AMS_Utility_PVT.resource_locked THEN
208: x_return_status := FND_API.g_ret_sts_error;
209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
210:
211: WHEN FND_API.G_EXC_ERROR THEN

Line 209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

205: EXCEPTION
206:
207: WHEN AMS_Utility_PVT.resource_locked THEN
208: x_return_status := FND_API.g_ret_sts_error;
209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Ams_Comp_Product_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;

Line 302: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

298:
299: -- Debug Message
300: IF (AMS_DEBUG_HIGH_ON) THEN
301:
302: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
303: END IF;
304:
305:
306: -- Initialize API return status to SUCCESS

Line 312: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

308:
309: -- Debug Message
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
313: END IF;
314:
315:
316: OPEN c_get_Ams_Comp_Product( l_tar_comp_prod_type_rec.competitor_product_id);

Line 320: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

316: OPEN c_get_Ams_Comp_Product( l_tar_comp_prod_type_rec.competitor_product_id);
317: FETCH c_get_Ams_Comp_Product INTO l_ref_comp_prod_rec ;
318:
319: If ( c_get_Ams_Comp_Product%NOTFOUND) THEN
320: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
321: p_token_name => 'INFO',
322: p_token_value => 'Ams_Competitor_Product_Pvt') ;
323: RAISE FND_API.G_EXC_ERROR;
324: END IF;

Line 328: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

324: END IF;
325: -- Debug Message
326: IF (AMS_DEBUG_HIGH_ON) THEN
327:
328: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
329: END IF;
330: CLOSE c_get_Ams_Comp_Product;
331:
332:

Line 335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

331:
332:
333: If (l_tar_comp_prod_type_rec.object_version_number is NULL or
334: l_tar_comp_prod_type_rec.object_version_number = FND_API.G_MISS_NUM ) Then
335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
336: p_token_name => 'COLUMN',
337: p_token_value => 'Last_Update_Date') ;
338: raise FND_API.G_EXC_ERROR;
339: End if;

Line 342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

338: raise FND_API.G_EXC_ERROR;
339: End if;
340: -- Check Whether record has been changed by someone else
341: If (l_tar_comp_prod_type_rec.object_version_number <> l_ref_comp_prod_rec.object_version_number) Then
342: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
343: p_token_name => 'INFO',
344: p_token_value => 'Ams_Competitor_Product_Pvt') ;
345: raise FND_API.G_EXC_ERROR;
346: End if;

Line 352: AMS_UTILITY_PVT.debug_message('Private API: Validate_comp_prod');

348: THEN
349: -- Debug message
350: IF (AMS_DEBUG_HIGH_ON) THEN
351:
352: AMS_UTILITY_PVT.debug_message('Private API: Validate_comp_prod');
353: END IF;
354:
355: -- Invoke validation procedures
356: Validate_comp_prod(

Line 427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

423:
424: -- Debug Message
425: IF (AMS_DEBUG_HIGH_ON) THEN
426:
427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get

Line 437: WHEN AMS_Utility_PVT.resource_locked THEN

433: p_data => x_msg_data
434: );
435: EXCEPTION
436:
437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN

Line 439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

435: EXCEPTION
436:
437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Ams_Comp_Product_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;

Line 517: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

513:
514: -- Debug Message
515: IF (AMS_DEBUG_HIGH_ON) THEN
516:
517: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
518: END IF;
519:
520:
521: -- Initialize API return status to SUCCESS

Line 530: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

526: --
527: -- Debug Message
528: IF (AMS_DEBUG_HIGH_ON) THEN
529:
530: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
531: END IF;
532:
533: -- Invoke table handler(AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row)
534: AMS_COMPETITOR_PRODUCTS_B_PKG.Delete_Row(

Line 552: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

548:
549: -- Debug Message
550: IF (AMS_DEBUG_HIGH_ON) THEN
551:
552: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
553: END IF;
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get

Line 562: WHEN AMS_Utility_PVT.resource_locked THEN

558: p_data => x_msg_data
559: );
560: EXCEPTION
561:
562: WHEN AMS_Utility_PVT.resource_locked THEN
563: x_return_status := FND_API.g_ret_sts_error;
564: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
565:
566: WHEN FND_API.G_EXC_ERROR THEN

Line 564: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

560: EXCEPTION
561:
562: WHEN AMS_Utility_PVT.resource_locked THEN
563: x_return_status := FND_API.g_ret_sts_error;
564: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
565:
566: WHEN FND_API.G_EXC_ERROR THEN
567: ROLLBACK TO DELETE_Ams_Comp_Product_PVT;
568: x_return_status := FND_API.G_RET_STS_ERROR;

Line 635: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

631:
632: -- Debug Message
633: IF (AMS_DEBUG_HIGH_ON) THEN
634:
635: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
636: END IF;
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )

Line 664: AMS_Utility_PVT.debug_message(l_full_name||': start');

660: IF (AMS_DEBUG_HIGH_ON) THEN
661:
662:
663:
664: AMS_Utility_PVT.debug_message(l_full_name||': start');
665:
666: END IF;
667: OPEN c_Ams_Comp_Product;
668:

Line 689: AMS_Utility_PVT.debug_message(l_full_name ||': end');

685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN
688:
689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN

Line 693: WHEN AMS_Utility_PVT.resource_locked THEN

689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN

Line 695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Ams_Comp_Product_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;

Line 868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

864:
865: BEGIN
866: x_return_status := FND_API.g_ret_sts_success;
867: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
869: 'AMS_COMPETITOR_PRODUCTS_B',
870: 'competitor_product_id = '|| p_comp_prod_rec.competitor_product_id
871: );
872: ELSE

Line 873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

869: 'AMS_COMPETITOR_PRODUCTS_B',
870: 'competitor_product_id = '|| p_comp_prod_rec.competitor_product_id
871: );
872: ELSE
873: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
874: 'AMS_COMPETITOR_PRODUCTS_B',
875: 'competitor_product_id = ''' || p_comp_prod_rec.competitor_product_id ||
876: ''' AND competitor_product_id <> ' || p_comp_prod_rec.competitor_product_id
877: );

Line 881: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_competitor_product_id_DUPLICATE');

877: );
878: END IF;
879:
880: IF l_valid_flag = FND_API.g_false THEN
881: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_competitor_product_id_DUPLICATE');
882: x_return_status := FND_API.g_ret_sts_error;
883: RETURN;
884: END IF;
885:

Line 901: AMS_UTILITY_PVT.debug_message('INSIDE THE check_comp_Prod_req_items and p_validation_mode is:'||p_validation_mode);

897: x_return_status := FND_API.g_ret_sts_success;
898:
899: IF (AMS_DEBUG_HIGH_ON)
900: THEN
901: AMS_UTILITY_PVT.debug_message('INSIDE THE check_comp_Prod_req_items and p_validation_mode is:'||p_validation_mode);
902: END IF;
903:
904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
905:

Line 907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_party_id');

903:
904: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
905:
906: IF p_comp_Prod_rec.competitor_party_id = FND_API.g_miss_num OR p_comp_Prod_rec.competitor_party_id IS NULL THEN
907: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_party_id');
908: x_return_status := FND_API.g_ret_sts_error;
909: RETURN;
910: END IF;
911:

Line 913: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_name');

909: RETURN;
910: END IF;
911:
912: IF p_comp_Prod_rec.competitor_product_name = FND_API.g_miss_char OR p_comp_Prod_rec.competitor_product_name IS NULL THEN
913: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_name');
914: x_return_status := FND_API.g_ret_sts_error;
915: RETURN;
916: END IF;
917:

Line 920: AMS_UTILITY_PVT.debug_message('before error msf');

916: END IF;
917:
918: IF (AMS_DEBUG_HIGH_ON)
919: THEN
920: AMS_UTILITY_PVT.debug_message('before error msf');
921: IF( p_comp_Prod_rec.inventory_item_id=FND_API.g_miss_num
922: AND p_comp_prod_rec.category_id=FND_API.g_miss_num)
923: THEN
924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');

Line 924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');

920: AMS_UTILITY_PVT.debug_message('before error msf');
921: IF( p_comp_Prod_rec.inventory_item_id=FND_API.g_miss_num
922: AND p_comp_prod_rec.category_id=FND_API.g_miss_num)
923: THEN
924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');
925: ELSE
926: AMS_UTILITY_PVT.debug_message(' in the else part before erroring out');
927: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.inventory_item_id:'||p_comp_Prod_rec.inventory_item_id);
928: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.category_id:'||p_comp_Prod_rec.category_id);

Line 926: AMS_UTILITY_PVT.debug_message(' in the else part before erroring out');

922: AND p_comp_prod_rec.category_id=FND_API.g_miss_num)
923: THEN
924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');
925: ELSE
926: AMS_UTILITY_PVT.debug_message(' in the else part before erroring out');
927: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.inventory_item_id:'||p_comp_Prod_rec.inventory_item_id);
928: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.category_id:'||p_comp_Prod_rec.category_id);
929: END IF;
930: END IF;

Line 927: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.inventory_item_id:'||p_comp_Prod_rec.inventory_item_id);

923: THEN
924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');
925: ELSE
926: AMS_UTILITY_PVT.debug_message(' in the else part before erroring out');
927: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.inventory_item_id:'||p_comp_Prod_rec.inventory_item_id);
928: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.category_id:'||p_comp_Prod_rec.category_id);
929: END IF;
930: END IF;
931:

Line 928: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.category_id:'||p_comp_Prod_rec.category_id);

924: AMS_UTILITY_PVT.debug_message('inv_id and cat id is g_miss num');
925: ELSE
926: AMS_UTILITY_PVT.debug_message(' in the else part before erroring out');
927: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.inventory_item_id:'||p_comp_Prod_rec.inventory_item_id);
928: AMS_UTILITY_PVT.debug_message('p_comp_Prod_rec.category_id:'||p_comp_Prod_rec.category_id);
929: END IF;
930: END IF;
931:
932: IF ((p_comp_Prod_rec.inventory_item_id=FND_API.g_miss_num AND p_comp_prod_rec.category_id=FND_API.g_miss_num)

Line 936: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_INV_AND_CAT_NULL');

932: IF ((p_comp_Prod_rec.inventory_item_id=FND_API.g_miss_num AND p_comp_prod_rec.category_id=FND_API.g_miss_num)
933: OR
934: ((p_comp_Prod_rec.inventory_item_id IS NULL) AND (p_comp_prod_rec.category_id IS NULL)))
935: THEN
936: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_INV_AND_CAT_NULL');
937: x_return_status := FND_API.g_ret_sts_error;
938: RETURN;
939: END IF;
940: ELSE

Line 943: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_id');

939: END IF;
940: ELSE
941:
942: IF p_comp_Prod_rec.competitor_product_id IS NULL THEN
943: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_id');
944: x_return_status := FND_API.g_ret_sts_error;
945: RETURN;
946: END IF;
947:

Line 950: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_INV_AND_CAT_NULL');

946: END IF;
947:
948: IF (( p_comp_Prod_rec.inventory_item_id IS NULL ) AND (p_comp_prod_rec.category_id IS NULL)) --interest_type_id
949: THEN
950: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_INV_AND_CAT_NULL');
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;
953: END IF;
954:

Line 956: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_party_id');

952: RETURN;
953: END IF;
954:
955: IF p_comp_Prod_rec.competitor_party_id IS NULL THEN
956: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_party_id');
957: x_return_status := FND_API.g_ret_sts_error;
958: RETURN;
959: END IF;
960:

Line 962: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_name');

958: RETURN;
959: END IF;
960:
961: IF p_comp_Prod_rec.competitor_product_name IS NULL THEN
962: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_competitor_product_name');
963: x_return_status := FND_API.g_ret_sts_error;
964: RETURN;
965: END IF;
966:

Line 971: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_inventory_item_id');

967:
968: /***
969:
970: IF p_comp_Prod_rec.inventory_item_id IS NULL THEN
971: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_inventory_item_id');
972: x_return_status := FND_API.g_ret_sts_error;
973: RETURN;
974: END IF;
975:

Line 978: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_organization_id');

974: END IF;
975:
976:
977: IF p_comp_Prod_rec.organization_id IS NULL THEN
978: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_comp_Prod_NO_organization_id');
979: x_return_status := FND_API.g_ret_sts_error;
980: RETURN;
981: END IF;
982: ***/

Line 1001: IF AMS_Utility_PVT.check_fk_exists(

997: --- checking the inventory_item_id
998: IF p_comp_prod_rec.inventory_item_id <> FND_API.g_miss_num
999: AND p_comp_prod_rec.inventory_item_id IS NOT NULL
1000: THEN
1001: IF AMS_Utility_PVT.check_fk_exists(
1002: 'mtl_system_items_b',
1003: 'inventory_item_id',
1004: p_comp_prod_rec.inventory_item_id ) = FND_API.g_false
1005: THEN

Line 1006: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_ITEM_ID');

1002: 'mtl_system_items_b',
1003: 'inventory_item_id',
1004: p_comp_prod_rec.inventory_item_id ) = FND_API.g_false
1005: THEN
1006: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_ITEM_ID');
1007: x_return_status := FND_API.g_ret_sts_error;
1008: RETURN;
1009: END IF;
1010: END IF;

Line 1016: IF AMS_Utility_PVT.check_fk_exists(

1012: --- checking the organization_id
1013: IF p_comp_prod_rec.organization_id <> FND_API.G_MISS_NUM
1014: AND p_comp_prod_rec.organization_id IS NOT NULL
1015: THEN
1016: IF AMS_Utility_PVT.check_fk_exists(
1017: 'mtl_system_items_b'
1018: ,'organization_id'
1019: ,p_comp_prod_rec.organization_id) = FND_API.g_false
1020: THEN

Line 1021: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_ORG_ID');

1017: 'mtl_system_items_b'
1018: ,'organization_id'
1019: ,p_comp_prod_rec.organization_id) = FND_API.g_false
1020: THEN
1021: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_ORG_ID');
1022: x_return_status := FND_API.g_ret_sts_error;
1023: RETURN;
1024: END IF;
1025: END IF;

Line 1031: IF AMS_Utility_PVT.check_fk_exists(

1027: -- checking the competitor_party_id
1028: IF p_comp_prod_rec.competitor_party_id <> FND_API.g_miss_num
1029: AND p_comp_prod_rec.competitor_party_id IS NOT NULL
1030: THEN
1031: IF AMS_Utility_PVT.check_fk_exists(
1032: 'hz_parties'
1033: ,'party_id '
1034: ,p_comp_prod_rec.competitor_party_id) = FND_API.g_false
1035: THEN

Line 1036: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_PARTY_ID');

1032: 'hz_parties'
1033: ,'party_id '
1034: ,p_comp_prod_rec.competitor_party_id) = FND_API.g_false
1035: THEN
1036: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_PARTY_ID');
1037: x_return_status := FND_API.g_ret_sts_error;
1038: RETURN;
1039: END IF;
1040: END IF;

Line 1046: IF AMS_Utility_PVT.check_fk_exists(

1042: -- checking the interest_Type_id
1043: IF p_comp_prod_rec.interest_type_id <> FND_API.G_MISS_NUM
1044: AND p_comp_prod_rec.interest_type_id IS NOT NULL
1045: THEN
1046: IF AMS_Utility_PVT.check_fk_exists(
1047: 'as_interest_types_v'
1048: ,'interest_type_id'
1049: ,p_comp_prod_rec.interest_type_id) = FND_API.g_false
1050: THEN

Line 1051: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_INTEREST_ID');

1047: 'as_interest_types_v'
1048: ,'interest_type_id'
1049: ,p_comp_prod_rec.interest_type_id) = FND_API.g_false
1050: THEN
1051: AMS_Utility_PVT.Error_Message('AMS_PCMP_BAD_INTEREST_ID');
1052: x_return_status := FND_API.g_ret_sts_error;
1053: RETURN;
1054: END IF;
1055: END IF;

Line 1069: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - is first the return status '||x_return_status);

1065: BEGIN
1066:
1067: -- Check Items Uniqueness API calls
1068: IF (AMS_DEBUG_HIGH_ON) THEN
1069: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - is first the return status '||x_return_status);
1070: END IF;
1071: -- Initialize API return status to SUCCESS
1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:

Line 1085: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - return status after uk_items :'||x_return_status);

1081:
1082: -- Check Items Required/NOT NULL API calls
1083: IF (AMS_DEBUG_HIGH_ON) THEN
1084:
1085: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - return status after uk_items :'||x_return_status);
1086: END IF;
1087:
1088: check_comp_prod_req_items(
1089: p_comp_prod_rec => p_comp_prod_rec,

Line 1100: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - return status after reg_items :'||x_return_status);

1096: IF (AMS_DEBUG_HIGH_ON) THEN
1097:
1098:
1099:
1100: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - return status after reg_items :'||x_return_status);
1101:
1102: END IF;
1103: -- Check Items Foreign Keys API calls
1104:

Line 1116: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - is sucess the return status '||x_return_status);

1112: IF (AMS_DEBUG_HIGH_ON) THEN
1113:
1114:
1115:
1116: AMS_UTILITY_PVT.debug_message('Check_Comp_prod_Items - is sucess the return status '||x_return_status);
1117:
1118: END IF;
1119:
1120: END Check_Comp_prod_Items;

Line 1153: Ams_Utility_Pvt.debug_message('The End date is greater than Start date');

1149:
1150: -- Debug Message
1151: IF(p_comp_prod_rec.start_date > p_comp_prod_rec.end_date)
1152: THEN
1153: Ams_Utility_Pvt.debug_message('The End date is greater than Start date');
1154: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1155: THEN
1156: Fnd_Message.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');
1157: Fnd_Msg_Pub.ADD;

Line 1194: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

1190:
1191: -- Debug Message
1192: IF (AMS_DEBUG_HIGH_ON) THEN
1193:
1194: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1195: END IF;
1196:
1197: -- Initialize API return status to SUCCESS
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1255: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1251:
1252: -- Debug Message
1253: IF (AMS_DEBUG_HIGH_ON) THEN
1254:
1255: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get

Line 1265: WHEN AMS_Utility_PVT.resource_locked THEN

1261: p_data => x_msg_data
1262: );
1263: EXCEPTION
1264:
1265: WHEN AMS_Utility_PVT.resource_locked THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1268:
1269: WHEN FND_API.G_EXC_ERROR THEN

Line 1267: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1263: EXCEPTION
1264:
1265: WHEN AMS_Utility_PVT.resource_locked THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1268:
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO VALIDATE_Ams_Comp_Product_;
1271: x_return_status := FND_API.G_RET_STS_ERROR;