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_CNT_POINT_PVT dependencies on AMS_UTILITY_PVT

Line 66: AMS_UTILITY_PVT.debug_message('Inside Procedure Create_cnt_point');

62:
63: BEGIN
64: IF (AMS_DEBUG_HIGH_ON) THEN
65:
66: AMS_UTILITY_PVT.debug_message('Inside Procedure Create_cnt_point');
67: END IF;
68: -- Standard Start of API savepoint
69: SAVEPOINT CREATE_Cnt_Point_PVT;
70: IF (AMS_DEBUG_HIGH_ON) THEN

Line 72: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');

68: -- Standard Start of API savepoint
69: SAVEPOINT CREATE_Cnt_Point_PVT;
70: IF (AMS_DEBUG_HIGH_ON) THEN
71:
72: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');
73: END IF;
74: IF (AMS_DEBUG_HIGH_ON) THEN
75:
76: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');

Line 76: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');

72: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');
73: END IF;
74: IF (AMS_DEBUG_HIGH_ON) THEN
75:
76: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call ( L_API_VERSION_NUMBER,

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

93:
94: -- Debug Message
95: IF (AMS_DEBUG_HIGH_ON) THEN
96:
97: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
98: END IF;
99: IF (AMS_DEBUG_HIGH_ON) THEN
100:
101: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

97: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
98: END IF;
99: IF (AMS_DEBUG_HIGH_ON) THEN
100:
101: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
102: END IF;
103:
104:
105: -- Initialize API return status to SUCCESS

Line 130: AMS_UTILITY_PVT.debug_message('Retreived pk');

126: IF (AMS_DEBUG_HIGH_ON) THEN
127:
128:
129:
130: AMS_UTILITY_PVT.debug_message('Retreived pk');
131:
132: END IF;
133: -- =========================================================================
134: -- Validate Environment

Line 143: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');

139: THEN
140: -- Debug message
141: IF (AMS_DEBUG_HIGH_ON) THEN
142:
143: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');
144: END IF;
145: IF (AMS_DEBUG_HIGH_ON) THEN
146:
147: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');

Line 147: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');

143: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');
144: END IF;
145: IF (AMS_DEBUG_HIGH_ON) THEN
146:
147: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point');
148: END IF;
149: -- Invoke validation procedures
150:
151: Validate_cnt_point(

Line 171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

167:
168: -- Debug Message
169: IF (AMS_DEBUG_HIGH_ON) THEN
170:
171: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
172: END IF;
173:
174: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Insert_Row)
175: AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(

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

223:
224: -- Debug Message
225: IF (AMS_DEBUG_HIGH_ON) THEN
226:
227: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
228: END IF;
229:
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get

Line 237: WHEN AMS_Utility_PVT.resource_locked THEN

233: p_data => x_msg_data
234: );
235: EXCEPTION
236:
237: WHEN AMS_Utility_PVT.resource_locked THEN
238: x_return_status := FND_API.g_ret_sts_error;
239: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
240:
241: WHEN FND_API.G_EXC_ERROR THEN

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

235: EXCEPTION
236:
237: WHEN AMS_Utility_PVT.resource_locked THEN
238: x_return_status := FND_API.g_ret_sts_error;
239: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Cnt_Point_PVT;
243: x_return_status := FND_API.G_RET_STS_ERROR;

Line 312: AMS_UTILITY_PVT.debug_message('Inside Update_cnt_point');

308:
309: BEGIN
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('Inside Update_cnt_point');
313: END IF;
314: -- Standard Start of API savepoint
315: SAVEPOINT UPDATE_Cnt_Point_PVT;
316:

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

331:
332: -- Debug Message
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
336: END IF;
337:
338:
339: -- Initialize API return status to SUCCESS

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

341:
342: -- Debug Message
343: IF (AMS_DEBUG_HIGH_ON) THEN
344:
345: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
346: END IF;
347:
348:
349: OPEN c_get_Cnt_Point( l_tar_cnt_point_rec.contact_point_id);

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

350:
351: FETCH c_get_Cnt_Point INTO l_ref_cnt_point_rec ;
352:
353: If ( c_get_Cnt_Point%NOTFOUND) THEN
354: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
355: p_token_name => 'INFO',
356: p_token_value => 'Cnt_Point') ;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;

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

358: END IF;
359: -- Debug Message
360: IF (AMS_DEBUG_HIGH_ON) THEN
361:
362: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
363: END IF;
364: CLOSE c_get_Cnt_Point;
365:
366:

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

366:
367:
368: If (l_tar_cnt_point_rec.object_version_number is NULL or
369: l_tar_cnt_point_rec.object_version_number = FND_API.G_MISS_NUM ) Then
370: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
371: p_token_name => 'COLUMN',
372: p_token_value => 'Last_Update_Date') ;
373: raise FND_API.G_EXC_ERROR;
374: End if;

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

373: raise FND_API.G_EXC_ERROR;
374: End if;
375: -- Check Whether record has been changed by someone else
376: If (l_tar_cnt_point_rec.object_version_number <> l_ref_cnt_point_rec.object_version_number) Then
377: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
378: p_token_name => 'INFO',
379: p_token_value => 'Cnt_Point') ;
380: raise FND_API.G_EXC_ERROR;
381: End if;

Line 387: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point '|| x_return_status);

383: THEN
384: -- Debug message
385: IF (AMS_DEBUG_HIGH_ON) THEN
386:
387: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cnt_Point '|| x_return_status);
388: END IF;
389:
390: -- Invoke validation procedures
391: Validate_cnt_point(

Line 410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');

406:
407: -- Debug Message
408: IF (AMS_DEBUG_HIGH_ON) THEN
409:
410: AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
411: END IF;
412:
413: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Update_Row)
414: AMS_ACT_CONTACT_POINTS_PKG.Update_Row(

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

455:
456: -- Debug Message
457: IF (AMS_DEBUG_HIGH_ON) THEN
458:
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460: END IF;
461:
462: -- Standard call to get message count and if count is 1, get message info.
463: FND_MSG_PUB.Count_And_Get

Line 469: WHEN AMS_Utility_PVT.resource_locked THEN

465: p_data => x_msg_data
466: );
467: EXCEPTION
468:
469: WHEN AMS_Utility_PVT.resource_locked THEN
470: x_return_status := FND_API.g_ret_sts_error;
471: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
472:
473: WHEN FND_API.G_EXC_ERROR THEN

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

467: EXCEPTION
468:
469: WHEN AMS_Utility_PVT.resource_locked THEN
470: x_return_status := FND_API.g_ret_sts_error;
471: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
472:
473: WHEN FND_API.G_EXC_ERROR THEN
474: ROLLBACK TO UPDATE_Cnt_Point_PVT;
475: x_return_status := FND_API.G_RET_STS_ERROR;

Line 537: AMS_UTILITY_PVT.debug_message('Inside Delete_cnt_point');

533:
534: BEGIN
535: IF (AMS_DEBUG_HIGH_ON) THEN
536:
537: AMS_UTILITY_PVT.debug_message('Inside Delete_cnt_point');
538: END IF;
539: -- Standard Start of API savepoint
540: SAVEPOINT DELETE_Cnt_Point_PVT;
541:

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

556:
557: -- Debug Message
558: IF (AMS_DEBUG_HIGH_ON) THEN
559:
560: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
561: END IF;
562:
563: OPEN c_Cnt_Point;
564:

Line 569: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RECORD_NOT_FOUND');

565: FETCH c_Cnt_Point INTO l_CONTACT_POINT_ID ;
566:
567: IF (c_Cnt_Point%NOTFOUND) THEN
568: CLOSE c_Cnt_Point;
569: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RECORD_NOT_FOUND');
570: RAISE FND_API.g_exc_error;
571: END IF;
572:
573: CLOSE c_Cnt_Point;

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

581: --
582: -- Debug Message
583: IF (AMS_DEBUG_HIGH_ON) THEN
584:
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586: END IF;
587:
588: -- Invoke table handler(AMS_ACT_CONTACT_POINTS_PKG.Delete_Row)
589: AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(

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

603:
604: -- Debug Message
605: IF (AMS_DEBUG_HIGH_ON) THEN
606:
607: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
608: END IF;
609:
610: -- Standard call to get message count and if count is 1, get message info.
611: FND_MSG_PUB.Count_And_Get

Line 617: WHEN AMS_Utility_PVT.resource_locked THEN

613: p_data => x_msg_data
614: );
615: EXCEPTION
616:
617: WHEN AMS_Utility_PVT.resource_locked THEN
618: x_return_status := FND_API.g_ret_sts_error;
619: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
620:
621: WHEN FND_API.G_EXC_ERROR THEN

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

615: EXCEPTION
616:
617: WHEN AMS_Utility_PVT.resource_locked THEN
618: x_return_status := FND_API.g_ret_sts_error;
619: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622: ROLLBACK TO DELETE_Cnt_Point_PVT;
623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 690: AMS_UTILITY_PVT.debug_message('Inside LockCnt_point');

686: IF (AMS_DEBUG_HIGH_ON) THEN
687:
688:
689:
690: AMS_UTILITY_PVT.debug_message('Inside LockCnt_point');
691:
692: END IF;
693: -- Debug Message
694: IF (AMS_DEBUG_HIGH_ON) THEN

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

692: END IF;
693: -- Debug Message
694: IF (AMS_DEBUG_HIGH_ON) THEN
695:
696: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
697: END IF;
698:
699: -- Initialize message list if p_init_msg_list is set to TRUE.
700: IF FND_API.to_Boolean( p_init_msg_list )

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

721: IF (AMS_DEBUG_HIGH_ON) THEN
722:
723:
724:
725: AMS_Utility_PVT.debug_message(l_full_name||': start');
726:
727: END IF;
728: OPEN c_Cnt_Point;
729:

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

746: p_count => x_msg_count,
747: p_data => x_msg_data);
748: IF (AMS_DEBUG_HIGH_ON) THEN
749:
750: AMS_Utility_PVT.debug_message(l_full_name ||': end');
751: END IF;
752: EXCEPTION
753:
754: WHEN AMS_Utility_PVT.resource_locked THEN

Line 754: WHEN AMS_Utility_PVT.resource_locked THEN

750: AMS_Utility_PVT.debug_message(l_full_name ||': end');
751: END IF;
752: EXCEPTION
753:
754: WHEN AMS_Utility_PVT.resource_locked THEN
755: x_return_status := FND_API.g_ret_sts_error;
756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
757:
758: WHEN FND_API.G_EXC_ERROR THEN

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

752: EXCEPTION
753:
754: WHEN AMS_Utility_PVT.resource_locked THEN
755: x_return_status := FND_API.g_ret_sts_error;
756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO LOCK_Cnt_Point_PVT;
760: x_return_status := FND_API.G_RET_STS_ERROR;

Line 805: AMS_UTILITY_PVT.debug_message('Inside check_uk_items');

801: BEGIN
802: x_return_status := FND_API.g_ret_sts_success;
803: IF (AMS_DEBUG_HIGH_ON) THEN
804:
805: AMS_UTILITY_PVT.debug_message('Inside check_uk_items');
806: END IF;
807: IF (AMS_DEBUG_HIGH_ON) THEN
808:
809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

Line 809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

805: AMS_UTILITY_PVT.debug_message('Inside check_uk_items');
806: END IF;
807: IF (AMS_DEBUG_HIGH_ON) THEN
808:
809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
810: END IF;
811: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
812: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
813: 'AMS_ACT_CONTACT_POINTS',

Line 812: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

808:
809: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
810: END IF;
811: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
812: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
813: 'AMS_ACT_CONTACT_POINTS',
814: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
815: );
816: IF l_valid_flag = FND_API.g_false THEN

Line 817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');

813: 'AMS_ACT_CONTACT_POINTS',
814: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
815: );
816: IF l_valid_flag = FND_API.g_false THEN
817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');
818: x_return_status := FND_API.g_ret_sts_error;
819: RETURN;
820: END IF;
821: -- code added by me

Line 822: /*l_valid_flag := AMS_Utility_PVT.check_uniqueness(

818: x_return_status := FND_API.g_ret_sts_error;
819: RETURN;
820: END IF;
821: -- code added by me
822: /*l_valid_flag := AMS_Utility_PVT.check_uniqueness(
823: 'AMS_ACT_CONTACT_POINTS'
824: , '''ARC_CONTACT_USED_BY = ''' || p_cnt_point_rec.ARC_CONTACT_USED_BY ||
825: ''' AND ACT_CONTACT_USED_BY_ID = ' || p_cnt_point_rec.ACT_CONTACT_USED_BY_ID ||
826: ''' AND CONTACT_POINT_TYPE = ''' || p_cnt_point_rec.CONTACT_POINT_TYPE ||

Line 836: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

832: -- end code added by me
833:
834:
835: /*ELSE
836: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
837: 'AMS_ACT_CONTACT_POINTS',
838: 'CONTACT_POINT_ID = ' || p_cnt_point_rec.CONTACT_POINT_ID
839: );
840:

Line 846: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');

842: -- ||
843: --''' AND CONTACT_POINT_ID <> ' || p_cnt_point_rec.CONTACT_POINT_ID
844: --);
845: IF l_valid_flag = FND_API.g_false THEN
846: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');
847: x_return_status := FND_API.g_ret_sts_error;
848: RETURN;
849: END IF;*/
850:

Line 855: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

851:
852: END IF;
853: IF (AMS_DEBUG_HIGH_ON) THEN
854:
855: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
856: END IF;
857:
858: END check_cnt_point_uk_items;
859:

Line 884: AMS_UTILITY_PVT.debug_message('Inside check_cnt_point_req_items');

880: IF (AMS_DEBUG_HIGH_ON) THEN
881:
882:
883:
884: AMS_UTILITY_PVT.debug_message('Inside check_cnt_point_req_items');
885:
886: END IF;
887:
888: x_return_status := FND_API.g_ret_sts_success;

Line 894: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_ID');

890: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
891:
892: /*
893: IF p_cnt_point_rec.contact_point_id = FND_API.g_miss_num OR p_cnt_point_rec.contact_point_id IS NULL THEN
894: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_ID');
895: x_return_status := FND_API.g_ret_sts_error;
896:
897: RETURN;
898: END IF;

Line 902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');

898: END IF;
899: */
900:
901: /*IF p_cnt_point_rec.last_update_date = FND_API.g_miss_date OR p_cnt_point_rec.last_update_date IS NULL THEN
902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');
903: x_return_status := FND_API.g_ret_sts_error;
904: RETURN;
905: END IF;
906:

Line 909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');

905: END IF;
906:
907:
908: IF p_cnt_point_rec.last_updated_by = FND_API.g_miss_num OR p_cnt_point_rec.last_updated_by IS NULL THEN
909: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');
910: x_return_status := FND_API.g_ret_sts_error;
911: RETURN;
912: END IF;
913:

Line 916: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_creation_date');

912: END IF;
913:
914:
915: IF p_cnt_point_rec.creation_date = FND_API.g_miss_date OR p_cnt_point_rec.creation_date IS NULL THEN
916: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_creation_date');
917: x_return_status := FND_API.g_ret_sts_error;
918: RETURN;
919: END IF;
920:

Line 923: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_created_by');

919: END IF;
920:
921:
922: IF p_cnt_point_rec.created_by = FND_API.g_miss_num OR p_cnt_point_rec.created_by IS NULL THEN
923: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_created_by');
924: x_return_status := FND_API.g_ret_sts_error;
925: RETURN;
926: END IF;
927:

Line 930: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_object_version_number');

926: END IF;
927:
928:
929: IF p_cnt_point_rec.object_version_number = FND_API.g_miss_num OR p_cnt_point_rec.object_version_number IS NULL THEN
930: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_object_version_number');
931: x_return_status := FND_API.g_ret_sts_error;
932: RETURN;
933: END IF; */
934:

Line 937: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY');

933: END IF; */
934:
935:
936: IF p_cnt_point_rec.arc_contact_used_by = FND_API.g_miss_char OR p_cnt_point_rec.arc_contact_used_by IS NULL THEN
937: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY');
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;
940: END IF;
941:

Line 944: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY_ID');

940: END IF;
941:
942:
943: IF p_cnt_point_rec.act_contact_used_by_id = FND_API.g_miss_num OR p_cnt_point_rec.act_contact_used_by_id IS NULL THEN
944: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY_ID');
945: x_return_status := FND_API.g_ret_sts_error;
946: RETURN;
947: END IF;
948:

Line 951: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_TYPE');

947: END IF;
948:
949:
950: IF p_cnt_point_rec.contact_point_type = FND_API.g_miss_char OR p_cnt_point_rec.contact_point_type IS NULL THEN
951: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_TYPE');
952: x_return_status := FND_API.g_ret_sts_error;
953: RETURN;
954: END IF;
955:

Line 958: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_VALUE');

954: END IF;
955:
956:
957: IF p_cnt_point_rec.contact_point_value = FND_API.g_miss_char OR p_cnt_point_rec.contact_point_value IS NULL THEN
958: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_VALUE');
959: x_return_status := FND_API.g_ret_sts_error;
960: RETURN;
961: END IF;
962: ELSE

Line 966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_ID');

962: ELSE
963:
964:
965: IF p_cnt_point_rec.contact_point_id IS NULL THEN
966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_ID');
967: x_return_status := FND_API.g_ret_sts_error;
968: RETURN;
969: END IF;
970:

Line 973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');

969: END IF;
970:
971:
972: /*IF p_cnt_point_rec.last_update_date IS NULL THEN
973: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;
976: END IF;
977:

Line 980: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');

976: END IF;
977:
978:
979: IF p_cnt_point_rec.last_updated_by IS NULL THEN
980: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');
981: x_return_status := FND_API.g_ret_sts_error;
982: RETURN;
983: END IF;
984:

Line 987: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_creation_date');

983: END IF;
984:
985:
986: IF p_cnt_point_rec.creation_date IS NULL THEN
987: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_creation_date');
988: x_return_status := FND_API.g_ret_sts_error;
989: RETURN;
990: END IF;
991:

Line 994: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_created_by');

990: END IF;
991:
992:
993: IF p_cnt_point_rec.created_by IS NULL THEN
994: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_created_by');
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;
997: END IF;
998:

Line 1001: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_object_version_number');

997: END IF;
998:
999:
1000: IF p_cnt_point_rec.object_version_number IS NULL THEN
1001: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_object_version_number');
1002: x_return_status := FND_API.g_ret_sts_error;
1003: RETURN;
1004: END IF; */
1005:

Line 1008: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY');

1004: END IF; */
1005:
1006:
1007: IF p_cnt_point_rec.arc_contact_used_by IS NULL THEN
1008: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY');
1009: x_return_status := FND_API.g_ret_sts_error;
1010: RETURN;
1011: END IF;
1012:

Line 1015: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY_ID');

1011: END IF;
1012:
1013:
1014: IF p_cnt_point_rec.act_contact_used_by_id IS NULL THEN
1015: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_USED_BY_ID');
1016: x_return_status := FND_API.g_ret_sts_error;
1017: RETURN;
1018: END IF;
1019:

Line 1022: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_TYPE');

1018: END IF;
1019:
1020:
1021: IF p_cnt_point_rec.contact_point_type IS NULL THEN
1022: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_TYPE');
1023: x_return_status := FND_API.g_ret_sts_error;
1024: RETURN;
1025: END IF;
1026:

Line 1029: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_VALUE');

1025: END IF;
1026:
1027:
1028: IF p_cnt_point_rec.contact_point_value IS NULL THEN
1029: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_NO_VALUE');
1030: x_return_status := FND_API.g_ret_sts_error;
1031: RETURN;
1032: END IF;
1033: END IF;

Line 1039: AMS_UTILITY_PVT.debug_message(' Exiting check_cnt_point_req_items');

1035: IF (AMS_DEBUG_HIGH_ON) THEN
1036:
1037:
1038:
1039: AMS_UTILITY_PVT.debug_message(' Exiting check_cnt_point_req_items');
1040:
1041: END IF;
1042:
1043: END check_cnt_point_req_items;

Line 1053: l_pk_data_type NUMBER := AMS_Utility_PVT.g_number;

1049: IS
1050: l_table_name VARCHAR2(30):= 'jtf_loc_hierarchies_vl';
1051: l_pk_name VARCHAR2(30) := 'location_hierarchy_id';
1052: l_pk_value NUMBER := p_cnt_point_rec.country;
1053: l_pk_data_type NUMBER := AMS_Utility_PVT.g_number;
1054:
1055:
1056: BEGIN
1057: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1059: AMS_UTILITY_PVT.debug_message('Inside check_country_exists');

1055:
1056: BEGIN
1057: IF (AMS_DEBUG_HIGH_ON) THEN
1058:
1059: AMS_UTILITY_PVT.debug_message('Inside check_country_exists');
1060: END IF;
1061: -- initialise the return status to success
1062: x_return_status := FND_API.g_ret_sts_success ;
1063:

Line 1068: AMS_Utility_PVT.check_fk_exists(

1064: -- if country is null or missing then perform the check
1065: IF p_cnt_point_rec.country <> FND_API.g_miss_num
1066: AND p_cnt_point_rec.country IS NOT NULL THEN
1067: IF
1068: AMS_Utility_PVT.check_fk_exists(
1069: p_table_name => l_table_name
1070: , p_pk_name => l_pk_name
1071: , p_pk_value => l_pk_value
1072: , p_pk_data_type => l_pk_data_type

Line 1076: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_BAD_COUNTRY');

1072: , p_pk_data_type => l_pk_data_type
1073: , p_additional_where_clause => NULL
1074: ) = FND_API.g_false
1075: THEN
1076: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CNT_POINT_BAD_COUNTRY');
1077: x_return_status := FND_API.g_ret_sts_error;
1078: RETURN ;
1079: END IF;
1080: END IF;

Line 1098: AMS_UTILITY_PVT.debug_message('Inside check_cnt_point_fk_items');

1094: -- code added by me
1095: -- Check arc_contact_used_by
1096: IF (AMS_DEBUG_HIGH_ON) THEN
1097:
1098: AMS_UTILITY_PVT.debug_message('Inside check_cnt_point_fk_items');
1099: END IF;
1100:
1101: IF p_cnt_point_rec.arc_contact_used_by <> FND_API.G_MISS_CHAR THEN
1102: IF p_cnt_point_rec.arc_contact_used_by <> 'CAMP' AND

Line 1108: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_USED_BY'); -- TO CHECK THE ERROR MESSAGE TO BE RAISED*/

1104: p_cnt_point_rec.arc_contact_used_by <> 'EVEH' AND
1105: p_cnt_point_rec.arc_contact_used_by <> 'EVEO'
1106: THEN
1107: -- invalid item
1108: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_USED_BY'); -- TO CHECK THE ERROR MESSAGE TO BE RAISED*/
1109: /*IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1110: THEN -- MMSG
1111: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Foreign Key Does not Exist'); END IF;
1112: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CREATED_FOR');

Line 1111: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Foreign Key Does not Exist'); END IF;

1107: -- invalid item
1108: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_USED_BY'); -- TO CHECK THE ERROR MESSAGE TO BE RAISED*/
1109: /*IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1110: THEN -- MMSG
1111: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Foreign Key Does not Exist'); END IF;
1112: FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_CREATED_FOR');
1113: FND_MSG_PUB.Add;
1114: END IF;*/
1115:

Line 1130: AMS_Utility_PVT.Error_Message(p_message_name => 'API_CONTACT_INVALID_COUNTRY');

1126: , x_return_status => x_return_status
1127: );
1128:
1129: IF x_return_status <> FND_API.g_ret_sts_success THEN
1130: AMS_Utility_PVT.Error_Message(p_message_name => 'API_CONTACT_INVALID_COUNTRY');
1131: RETURN;
1132: END IF;
1133: END IF;
1134:

Line 1152: AMS_UTILITY_PVT.debug_message('Inside Ckeck lookups');

1148: IS
1149: BEGIN
1150: IF (AMS_DEBUG_HIGH_ON) THEN
1151:
1152: AMS_UTILITY_PVT.debug_message('Inside Ckeck lookups');
1153: END IF;
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155:
1156: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

Line 1156: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

1152: AMS_UTILITY_PVT.debug_message('Inside Ckeck lookups');
1153: END IF;
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155:
1156: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
1157: END IF;
1158: x_return_status := FND_API.g_ret_sts_success;
1159: -- code added by me
1160: IF p_cnt_point_rec.CONTACT_POINT_TYPE <> FND_API.G_MISS_CHAR

Line 1164: AMS_UTILITY_PVT.debug_message(' LookUp type lookup code = '''|| p_cnt_point_rec.contact_point_value);

1160: IF p_cnt_point_rec.CONTACT_POINT_TYPE <> FND_API.G_MISS_CHAR
1161: THEN
1162: IF (AMS_DEBUG_HIGH_ON) THEN
1163:
1164: AMS_UTILITY_PVT.debug_message(' LookUp type lookup code = '''|| p_cnt_point_rec.contact_point_value);
1165: END IF;
1166: IF AMS_Utility_PVT.Check_Lookup_Exists
1167: ( p_lookup_table_name => 'AMS_LOOKUPS'
1168: ,p_lookup_type => 'AMS_CONTACT_POINT_TYPE'

Line 1166: IF AMS_Utility_PVT.Check_Lookup_Exists

1162: IF (AMS_DEBUG_HIGH_ON) THEN
1163:
1164: AMS_UTILITY_PVT.debug_message(' LookUp type lookup code = '''|| p_cnt_point_rec.contact_point_value);
1165: END IF;
1166: IF AMS_Utility_PVT.Check_Lookup_Exists
1167: ( p_lookup_table_name => 'AMS_LOOKUPS'
1168: ,p_lookup_type => 'AMS_CONTACT_POINT_TYPE'
1169: ,p_lookup_code => p_cnt_point_rec.contact_point_type
1170: ) = FND_API.G_FALSE then

Line 1175: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Triggering Type is invalid'); END IF;

1171:
1172: -- invalid item
1173: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1174: THEN -- MMSG
1175: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Triggering Type is invalid'); END IF;
1176:
1177: FND_MSG_PUB.Add;
1178: END IF;*/
1179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_TYPE');

Line 1179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_TYPE');

1175: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('Triggering Type is invalid'); END IF;
1176:
1177: FND_MSG_PUB.Add;
1178: END IF;*/
1179: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_INVALID_TYPE');
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: -- If any errors happen abort API/Procedure.
1182: RETURN;
1183: END IF;

Line 1189: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);

1185: -- end code added by me
1186: -- Enter custom code here
1187: IF (AMS_DEBUG_HIGH_ON) THEN
1188:
1189: AMS_UTILITY_PVT.debug_message(p_cnt_point_rec.arc_contact_used_by);
1190: END IF;
1191: END check_cnt_point_Lookup_items;
1192:
1193: PROCEDURE Check_cnt_point_Items (

Line 1204: AMS_UTILITY_PVT.debug_message('Inside Check_cnt_point_items');

1200:
1201: -- Check Items Uniqueness API calls
1202: IF (AMS_DEBUG_HIGH_ON) THEN
1203:
1204: AMS_UTILITY_PVT.debug_message('Inside Check_cnt_point_items');
1205: END IF;
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207:
1208: AMS_UTILITY_PVT.debug_message('Before Calling uk Items');

Line 1208: AMS_UTILITY_PVT.debug_message('Before Calling uk Items');

1204: AMS_UTILITY_PVT.debug_message('Inside Check_cnt_point_items');
1205: END IF;
1206: IF (AMS_DEBUG_HIGH_ON) THEN
1207:
1208: AMS_UTILITY_PVT.debug_message('Before Calling uk Items');
1209: END IF;
1210: IF (AMS_DEBUG_HIGH_ON) THEN
1211:
1212: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

Line 1212: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

1208: AMS_UTILITY_PVT.debug_message('Before Calling uk Items');
1209: END IF;
1210: IF (AMS_DEBUG_HIGH_ON) THEN
1211:
1212: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);
1213: END IF;
1214: check_cnt_point_uk_items(
1215: p_cnt_point_rec => p_cnt_point_rec,
1216: p_validation_mode => p_validation_mode,

Line 1223: AMS_UTILITY_PVT.debug_message('After Calling uk Items '||x_return_status);

1219: RETURN;
1220: END IF;
1221: IF (AMS_DEBUG_HIGH_ON) THEN
1222:
1223: AMS_UTILITY_PVT.debug_message('After Calling uk Items '||x_return_status);
1224: END IF;
1225:
1226: -- Check Items Required/NOT NULL API calls
1227: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1229: AMS_UTILITY_PVT.debug_message('Before Calling req Items');

1225:
1226: -- Check Items Required/NOT NULL API calls
1227: IF (AMS_DEBUG_HIGH_ON) THEN
1228:
1229: AMS_UTILITY_PVT.debug_message('Before Calling req Items');
1230: END IF;
1231: IF (AMS_DEBUG_HIGH_ON) THEN
1232:
1233: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

Line 1233: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

1229: AMS_UTILITY_PVT.debug_message('Before Calling req Items');
1230: END IF;
1231: IF (AMS_DEBUG_HIGH_ON) THEN
1232:
1233: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);
1234: END IF;
1235: check_cnt_point_req_items(
1236: p_cnt_point_rec => p_cnt_point_rec,
1237: p_validation_mode => p_validation_mode,

Line 1244: AMS_UTILITY_PVT.debug_message('After Calling req Items'|| x_return_status);

1240: RETURN;
1241: END IF;
1242: IF (AMS_DEBUG_HIGH_ON) THEN
1243:
1244: AMS_UTILITY_PVT.debug_message('After Calling req Items'|| x_return_status);
1245: END IF;
1246:
1247: /* Commented by nrengasw 05/07/2001. No validation required on contact point used by.
1248: Country is a free format column. Do not validate against geographies

Line 1253: AMS_UTILITY_PVT.debug_message('Before Calling fk Items');

1249:
1250: -- Check Items Foreign Keys API calls
1251: IF (AMS_DEBUG_HIGH_ON) THEN
1252:
1253: AMS_UTILITY_PVT.debug_message('Before Calling fk Items');
1254: END IF;
1255: check_cnt_point_FK_items(
1256: p_cnt_point_rec => p_cnt_point_rec,
1257: x_return_status => x_return_status);

Line 1263: AMS_UTILITY_PVT.debug_message('After Calling fk Items' || x_return_status);

1259: RETURN;
1260: END IF;
1261: IF (AMS_DEBUG_HIGH_ON) THEN
1262:
1263: AMS_UTILITY_PVT.debug_message('After Calling fk Items' || x_return_status);
1264: END IF;
1265:
1266: End of comments by nrengasw
1267: */

Line 1271: AMS_UTILITY_PVT.debug_message('Before Calling Lk Items');

1267: */
1268: -- Check Items Lookups
1269: IF (AMS_DEBUG_HIGH_ON) THEN
1270:
1271: AMS_UTILITY_PVT.debug_message('Before Calling Lk Items');
1272: END IF;
1273: check_cnt_point_Lookup_items(
1274: p_cnt_point_rec => p_cnt_point_rec,
1275: x_return_status => x_return_status);

Line 1281: AMS_UTILITY_PVT.debug_message('After Calling lk Items'|| x_return_status);

1277: RETURN;
1278: END IF;
1279: IF (AMS_DEBUG_HIGH_ON) THEN
1280:
1281: AMS_UTILITY_PVT.debug_message('After Calling lk Items'|| x_return_status);
1282: END IF;
1283: END Check_cnt_point_Items;
1284:
1285:

Line 1321: AMS_UTILITY_PVT.debug_message('Inside Validate_cnt_points');

1317:
1318: BEGIN
1319: IF (AMS_DEBUG_HIGH_ON) THEN
1320:
1321: AMS_UTILITY_PVT.debug_message('Inside Validate_cnt_points');
1322: END IF;
1323:
1324: -- Standard Start of API savepoint
1325: SAVEPOINT VALIDATE_Cnt_Point_;

Line 1340: AMS_UTILITY_PVT.debug_message('Validate Api is compatible');

1336: IF (AMS_DEBUG_HIGH_ON) THEN
1337:
1338:
1339:
1340: AMS_UTILITY_PVT.debug_message('Validate Api is compatible');
1341:
1342: END IF;
1343: -- Initialize message list if p_init_msg_list is set to TRUE.
1344: IF FND_API.to_Boolean( p_init_msg_list )

Line 1352: AMS_UTILITY_PVT.debug_message('Calling Check_cnt_point');

1348:
1349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1350: IF (AMS_DEBUG_HIGH_ON) THEN
1351:
1352: AMS_UTILITY_PVT.debug_message('Calling Check_cnt_point');
1353: END IF;
1354: IF (AMS_DEBUG_HIGH_ON) THEN
1355:
1356: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

Line 1356: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);

1352: AMS_UTILITY_PVT.debug_message('Calling Check_cnt_point');
1353: END IF;
1354: IF (AMS_DEBUG_HIGH_ON) THEN
1355:
1356: AMS_UTILITY_PVT.debug_message('Validation mode is ' || p_validation_mode);
1357: END IF;
1358: Check_cnt_point_Items(
1359: p_cnt_point_rec => p_cnt_point_rec,
1360: p_validation_mode => p_validation_mode,

Line 1368: AMS_UTILITY_PVT.debug_message('DOne calling check_cnt_point '||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1364: IF (AMS_DEBUG_HIGH_ON) THEN
1365:
1366:
1367:
1368: AMS_UTILITY_PVT.debug_message('DOne calling check_cnt_point '||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1369:
1370: END IF;
1371:
1372: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1383: AMS_UTILITY_PVT.debug_message('Callin Complete rec');

1379: IF (AMS_DEBUG_HIGH_ON) THEN
1380:
1381:
1382:
1383: AMS_UTILITY_PVT.debug_message('Callin Complete rec');
1384:
1385: END IF;
1386: Complete_cnt_point_Rec(
1387: p_cnt_point_rec => p_cnt_point_rec,

Line 1395: AMS_UTILITY_PVT.debug_message('DOne calling Complete_rec '|| x_return_status);

1391: IF (AMS_DEBUG_HIGH_ON) THEN
1392:
1393:
1394:
1395: AMS_UTILITY_PVT.debug_message('DOne calling Complete_rec '|| x_return_status);
1396:
1397: END IF;
1398:
1399:

Line 1404: AMS_UTILITY_PVT.debug_message('Calling Validate rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1400:
1401: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1402: IF (AMS_DEBUG_HIGH_ON) THEN
1403:
1404: AMS_UTILITY_PVT.debug_message('Calling Validate rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1405: END IF;
1406: Validate_cnt_point_Rec(
1407: p_api_version_number => 1.0,
1408: p_validation_mode => p_validation_mode,

Line 1417: AMS_UTILITY_PVT.debug_message('DOne calling Validate rec ' ||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1413: x_msg_data => x_msg_data,
1414: p_cnt_point_rec => p_cnt_point_rec);
1415: IF (AMS_DEBUG_HIGH_ON) THEN
1416:
1417: AMS_UTILITY_PVT.debug_message('DOne calling Validate rec ' ||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1418: END IF;
1419:
1420: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1421: RAISE FND_API.G_EXC_ERROR;

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

1427:
1428: -- Debug Message
1429: IF (AMS_DEBUG_HIGH_ON) THEN
1430:
1431: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start '||x_return_status);
1432: END IF;
1433:
1434:
1435: -- Initialize API return status to SUCCESS

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

1438:
1439: -- Debug Message
1440: IF (AMS_DEBUG_HIGH_ON) THEN
1441:
1442: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end ' || x_return_status);
1443: END IF;
1444:
1445: -- Standard call to get message count and if count is 1, get message info.
1446: FND_MSG_PUB.Count_And_Get

Line 1453: WHEN AMS_Utility_PVT.resource_locked THEN

1449: p_data => x_msg_data
1450: );
1451: EXCEPTION
1452:
1453: WHEN AMS_Utility_PVT.resource_locked THEN
1454: x_return_status := FND_API.g_ret_sts_error;
1455: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN

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

1451: EXCEPTION
1452:
1453: WHEN AMS_Utility_PVT.resource_locked THEN
1454: x_return_status := FND_API.g_ret_sts_error;
1455: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO VALIDATE_Cnt_Point_;
1459: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1530: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');

1526: OPEN c_check_cnt_point_uk_rec_cr ;
1527: FETCH c_check_cnt_point_uk_rec_cr INTO l_contact_point_id;
1528: IF c_check_cnt_point_uk_rec_cr%FOUND THEN
1529: x_return_status := FND_API.G_RET_STS_ERROR;
1530: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');
1531: CLOSE c_check_cnt_point_uk_rec_cr ;
1532: RETURN;
1533: END IF;
1534: CLOSE c_check_cnt_point_uk_rec_cr ;

Line 1543: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');

1539: FETCH c_check_cnt_point_uk_rec_up INTO l_contact_point_id;
1540:
1541: IF c_check_cnt_point_uk_rec_up%FOUND THEN
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CONTACT_POINT_ID_DUPLICATE');
1544: CLOSE c_check_cnt_point_uk_rec_up ;
1545: RETURN;
1546: END IF;
1547: CLOSE c_check_cnt_point_uk_rec_up ;

Line 1581: AMS_UTILITY_PVT.debug_message('Calling Get_Qual_Table_Name_And_PK');

1577: BEGIN
1578: /* check if the arc_contact_point_id is valid */
1579: IF (AMS_DEBUG_HIGH_ON) THEN
1580:
1581: AMS_UTILITY_PVT.debug_message('Calling Get_Qual_Table_Name_And_PK');
1582: END IF;
1583: IF (AMS_DEBUG_HIGH_ON) THEN
1584:
1585: AMS_UTILITY_PVT.debug_message(l_arc_contact_used_by || ' '|| p_cnt_point_rec.arc_contact_used_by );

Line 1585: AMS_UTILITY_PVT.debug_message(l_arc_contact_used_by || ' '|| p_cnt_point_rec.arc_contact_used_by );

1581: AMS_UTILITY_PVT.debug_message('Calling Get_Qual_Table_Name_And_PK');
1582: END IF;
1583: IF (AMS_DEBUG_HIGH_ON) THEN
1584:
1585: AMS_UTILITY_PVT.debug_message(l_arc_contact_used_by || ' '|| p_cnt_point_rec.arc_contact_used_by );
1586: END IF;
1587: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
1588: p_sys_qual => l_arc_contact_used_by,
1589: x_return_status => x_return_status,

Line 1587: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (

1583: IF (AMS_DEBUG_HIGH_ON) THEN
1584:
1585: AMS_UTILITY_PVT.debug_message(l_arc_contact_used_by || ' '|| p_cnt_point_rec.arc_contact_used_by );
1586: END IF;
1587: AMS_Utility_PVT.Get_Qual_Table_Name_And_PK (
1588: p_sys_qual => l_arc_contact_used_by,
1589: x_return_status => x_return_status,
1590: x_table_name => l_table_name,
1591: x_pk_name => l_pk_name

Line 1598: AMS_UTILITY_PVT.debug_message('Done Calling Get_Qual_Table_Name_And_PK ' || l_arc_contact_used_by ||l_table_name|| l_pk_name || x_return_status);

1594: IF (AMS_DEBUG_HIGH_ON) THEN
1595:
1596:
1597:
1598: AMS_UTILITY_PVT.debug_message('Done Calling Get_Qual_Table_Name_And_PK ' || l_arc_contact_used_by ||l_table_name|| l_pk_name || x_return_status);
1599:
1600: END IF;
1601:
1602: l_pk_value := p_cnt_point_rec.ACT_CONTACT_USED_BY_ID ; -- findout what to assign

Line 1603: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;

1599:
1600: END IF;
1601:
1602: l_pk_value := p_cnt_point_rec.ACT_CONTACT_USED_BY_ID ; -- findout what to assign
1603: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1604: l_additional_where_clause := NULL;
1605: IF (AMS_DEBUG_HIGH_ON) THEN
1606:
1607: AMS_UTILITY_PVT.debug_message(' Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );

Line 1607: AMS_UTILITY_PVT.debug_message(' Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );

1603: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1604: l_additional_where_clause := NULL;
1605: IF (AMS_DEBUG_HIGH_ON) THEN
1606:
1607: AMS_UTILITY_PVT.debug_message(' Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );
1608: END IF;
1609: IF AMS_Utility_PVT.Check_FK_Exists (
1610: p_table_name => l_table_name
1611: ,p_pk_name => l_pk_name

Line 1609: IF AMS_Utility_PVT.Check_FK_Exists (

1605: IF (AMS_DEBUG_HIGH_ON) THEN
1606:
1607: AMS_UTILITY_PVT.debug_message(' Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );
1608: END IF;
1609: IF AMS_Utility_PVT.Check_FK_Exists (
1610: p_table_name => l_table_name
1611: ,p_pk_name => l_pk_name
1612: ,p_pk_value => l_pk_value
1613: --,p_pk_data_type => l_pk_data_type

Line 1618: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TRIG_INVALID_CREATED_FOR');

1614: --,p_additional_where_clause => l_additional_where_clause
1615: ) = FND_API.G_FALSE
1616: THEN
1617:
1618: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TRIG_INVALID_CREATED_FOR');
1619:
1620:
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1624: AMS_UTILITY_PVT.debug_message(' Done Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );

1620:
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: IF (AMS_DEBUG_HIGH_ON) THEN
1623:
1624: AMS_UTILITY_PVT.debug_message(' Done Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );
1625: END IF;
1626: RETURN;
1627: END IF;
1628:

Line 1638: IF AMS_Utility_PVT.Check_FK_Exists (

1634: THEN
1635:
1636: -- soagrawa 21-jan-2003 fixed bug# 2757856
1637: -- now comparing trimmed values
1638: IF AMS_Utility_PVT.Check_FK_Exists (
1639: p_table_name => 'ies_deployed_scripts'
1640: ,p_pk_name => 'ltrim(rtrim(dscript_name))'
1641: ,p_pk_value => ltrim(rtrim(l_contact_point_value))
1642: ) = FND_API.G_FALSE

Line 1646: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_INBOUND_DSCRIPT');

1642: ) = FND_API.G_FALSE
1643: THEN
1644: IF l_contact_point_type = 'INBOUND_SCRIPT'
1645: THEN
1646: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_INBOUND_DSCRIPT');
1647: ELSIF l_contact_point_type = 'OUTBOUND_SCRIPT'
1648: THEN
1649: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_OUTBOUND_DSCRIPT');
1650: END IF;

Line 1649: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_OUTBOUND_DSCRIPT');

1645: THEN
1646: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_INBOUND_DSCRIPT');
1647: ELSIF l_contact_point_type = 'OUTBOUND_SCRIPT'
1648: THEN
1649: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CSCH_BAD_OUTBOUND_DSCRIPT');
1650: END IF;
1651:
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1655: AMS_UTILITY_PVT.debug_message(' Done Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );

1651:
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: IF (AMS_DEBUG_HIGH_ON) THEN
1654:
1655: AMS_UTILITY_PVT.debug_message(' Done Calling Check FK Exists '|| l_table_name || l_pk_name || l_pk_value || l_pk_data_type || x_return_status );
1656: END IF;
1657: RETURN;
1658: END IF;
1659:

Line 1696: AMS_UTILITY_PVT.debug_message('Inside Validate rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1692: IF (AMS_DEBUG_HIGH_ON) THEN
1693:
1694:
1695:
1696: AMS_UTILITY_PVT.debug_message('Inside Validate rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1697:
1698: END IF;
1699: -- Initialize API return status to SUCCESS
1700: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1717: AMS_UTILITY_PVT.debug_message('Calling check_cnt_point_fk_rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1713: RETURN;
1714: END IF;*/
1715: IF (AMS_DEBUG_HIGH_ON) THEN
1716:
1717: AMS_UTILITY_PVT.debug_message('Calling check_cnt_point_fk_rec'||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1718: END IF;
1719:
1720: check_cnt_point_fk_rec(
1721: p_cnt_point_rec => p_cnt_point_rec

Line 1726: AMS_UTILITY_PVT.debug_message(' Done calling check_cnt_point_fk_rec '||p_cnt_point_rec.arc_contact_used_by|| x_return_status);

1722: ,x_return_status => x_return_status
1723: );
1724: IF (AMS_DEBUG_HIGH_ON) THEN
1725:
1726: AMS_UTILITY_PVT.debug_message(' Done calling check_cnt_point_fk_rec '||p_cnt_point_rec.arc_contact_used_by|| x_return_status);
1727: END IF;
1728: IF x_return_status <> FND_API.g_ret_sts_success THEN
1729: RETURN;
1730: END IF;

Line 1739: AMS_UTILITY_PVT.debug_message('Calling check_cnt_point_uk_rec');

1735:
1736:
1737:
1738:
1739: AMS_UTILITY_PVT.debug_message('Calling check_cnt_point_uk_rec');
1740:
1741:
1742: END IF;
1743: check_cnt_point_uk_rec(

Line 1749: AMS_UTILITY_PVT.debug_message(' Done calling check_cnt_point_uk_rec '||x_return_status);

1745: p_validation_mode => p_validation_mode,
1746: x_return_status => x_return_status);
1747: IF (AMS_DEBUG_HIGH_ON) THEN
1748:
1749: AMS_UTILITY_PVT.debug_message(' Done calling check_cnt_point_uk_rec '||x_return_status);
1750: END IF;
1751:
1752: IF x_return_status <> FND_API.g_ret_sts_success THEN
1753: RETURN;