DBA Data[Home] [Help]

APPS.AMS_CTD_PVT dependencies on AMS_UTILITY_PVT

Line 51: AMS_UTILITY_PVT.debug_message(p_log_level,

47: l_module_name := 'ams'||DELIMETER||'plsql'||DELIMETER||G_PACKAGE_NAME||DELIMETER||p_procedure_name||DELIMETER||'-'||p_label;
48:
49:
50: -- Log the Message
51: AMS_UTILITY_PVT.debug_message(p_log_level,
52: l_module_name,
53: p_text
54: );
55:

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

470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: -- Debug Message
474: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
475:
476:
477: -- Initialize API return status to SUCCESS
478: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

498: -- =========================================================================
499:
500: IF FND_GLOBAL.User_Id IS NULL
501: THEN
502: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 509: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ctd');

505:
506: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
507: THEN
508: -- Debug message
509: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ctd');
510:
511: -- Invoke validation procedures
512: Validate_ctd(
513: p_api_version_number => 1.0,

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

524: END IF;
525:
526:
527: -- Debug Message
528: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
529:
530: -- Invoke table handler(AMS_CTDS_PKG.Insert_Row)
531: AMS_CTDS_PKG.Insert_Row(
532: px_ctd_id => l_ctd_id,

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

559: END IF;
560:
561:
562: -- Debug Message
563: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
564:
565: -- Standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count,

Line 572: WHEN AMS_Utility_PVT.resource_locked THEN

568: p_data => x_msg_data
569: );
570: EXCEPTION
571:
572: WHEN AMS_Utility_PVT.resource_locked THEN
573: x_return_status := FND_API.g_ret_sts_error;
574: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
575:
576: WHEN FND_API.G_EXC_ERROR THEN

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

570: EXCEPTION
571:
572: WHEN AMS_Utility_PVT.resource_locked THEN
573: x_return_status := FND_API.g_ret_sts_error;
574: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
575:
576: WHEN FND_API.G_EXC_ERROR THEN
577: ROLLBACK TO CREATE_Ctd_PVT;
578: x_return_status := FND_API.G_RET_STS_ERROR;

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

656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: -- Debug Message
660: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
661:
662:
663: -- Initialize API return status to SUCCESS
664: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

663: -- Initialize API return status to SUCCESS
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: -- Debug Message
667: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
668:
669: /*
670: OPEN c_get_Ctd( l_tar_ctd_rec.ctd_id);
671:

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

671:
672: FETCH c_get_Ctd INTO l_ref_ctd_rec ;
673:
674: If ( c_get_Ctd%NOTFOUND) THEN
675: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
676: p_token_name => 'INFO',
677: p_token_value => 'Ctd') ;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;

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

677: p_token_value => 'Ctd') ;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: -- Debug Message
681: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
682: CLOSE c_get_Ctd;
683: */
684:
685:

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

684:
685:
686: If (l_tar_ctd_rec.object_version_number is NULL or
687: l_tar_ctd_rec.object_version_number = FND_API.G_MISS_NUM ) Then
688: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
689: p_token_name => 'COLUMN',
690: p_token_value => 'Last_Update_Date') ;
691: raise FND_API.G_EXC_ERROR;
692: End if;

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

691: raise FND_API.G_EXC_ERROR;
692: End if;
693: -- Check Whether record has been changed by someone else
694: If (l_tar_ctd_rec.object_version_number <> l_ref_ctd_rec.object_version_number) Then
695: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
696: p_token_name => 'INFO',
697: p_token_value => 'Ctd') ;
698: raise FND_API.G_EXC_ERROR;
699: End if;

Line 703: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ctd');

699: End if;
700: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
701: THEN
702: -- Debug message
703: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ctd');
704:
705: -- Invoke validation procedures
706: Validate_ctd(
707: p_api_version_number => 1.0,

Line 722: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

718: END IF;
719:
720:
721: -- Debug Message
722: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
723:
724: -- Invoke table handler(AMS_CTDS_PKG.Update_Row)
725: AMS_CTDS_PKG.Update_Row(
726: p_ctd_id => p_ctd_rec.ctd_id,

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

747: END IF;
748:
749:
750: -- Debug Message
751: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
752:
753: -- Standard call to get message count and if count is 1, get message info.
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,

Line 760: WHEN AMS_Utility_PVT.resource_locked THEN

756: p_data => x_msg_data
757: );
758: EXCEPTION
759:
760: WHEN AMS_Utility_PVT.resource_locked THEN
761: x_return_status := FND_API.g_ret_sts_error;
762: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
763:
764: WHEN FND_API.G_EXC_ERROR THEN

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

758: EXCEPTION
759:
760: WHEN AMS_Utility_PVT.resource_locked THEN
761: x_return_status := FND_API.g_ret_sts_error;
762: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
763:
764: WHEN FND_API.G_EXC_ERROR THEN
765: ROLLBACK TO UPDATE_Ctd_PVT;
766: x_return_status := FND_API.G_RET_STS_ERROR;

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

833: FND_MSG_PUB.initialize;
834: END IF;
835:
836: -- Debug Message
837: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
838:
839:
840: -- Initialize API return status to SUCCESS
841: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

843: --
844: -- Api body
845: --
846: -- Debug Message
847: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
848:
849: -- Invoke table handler(AMS_CTDS_PKG.Delete_Row)
850: AMS_CTDS_PKG.Delete_Row(
851: p_CTD_ID => p_CTD_ID);

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

860: END IF;
861:
862:
863: -- Debug Message
864: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
865:
866: -- Standard call to get message count and if count is 1, get message info.
867: FND_MSG_PUB.Count_And_Get
868: (p_count => x_msg_count,

Line 873: WHEN AMS_Utility_PVT.resource_locked THEN

869: p_data => x_msg_data
870: );
871: EXCEPTION
872:
873: WHEN AMS_Utility_PVT.resource_locked THEN
874: x_return_status := FND_API.g_ret_sts_error;
875: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
876:
877: WHEN FND_API.G_EXC_ERROR THEN

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

871: EXCEPTION
872:
873: WHEN AMS_Utility_PVT.resource_locked THEN
874: x_return_status := FND_API.g_ret_sts_error;
875: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
876:
877: WHEN FND_API.G_EXC_ERROR THEN
878: ROLLBACK TO DELETE_Ctd_PVT;
879: x_return_status := FND_API.G_RET_STS_ERROR;

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

939:
940: BEGIN
941:
942: -- Debug Message
943: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list )
947: THEN

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

963:
964:
965: ------------------------ lock -------------------------
966:
967: AMS_Utility_PVT.debug_message(l_full_name||': start');
968: OPEN c_Ctd;
969:
970: FETCH c_Ctd INTO l_CTD_ID;
971:

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

984: FND_MSG_PUB.count_and_get(
985: p_encoded => FND_API.g_false,
986: p_count => x_msg_count,
987: p_data => x_msg_data);
988: AMS_Utility_PVT.debug_message(l_full_name ||': end');
989: EXCEPTION
990:
991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;

Line 991: WHEN AMS_Utility_PVT.resource_locked THEN

987: p_data => x_msg_data);
988: AMS_Utility_PVT.debug_message(l_full_name ||': end');
989: EXCEPTION
990:
991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;
993: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
994:
995: WHEN FND_API.G_EXC_ERROR THEN

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

989: EXCEPTION
990:
991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;
993: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
994:
995: WHEN FND_API.G_EXC_ERROR THEN
996: ROLLBACK TO LOCK_Ctd_PVT;
997: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1041: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1037:
1038: BEGIN
1039: x_return_status := FND_API.g_ret_sts_success;
1040: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1041: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1042: 'AMS_CTDS',
1043: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||''''
1044: );
1045: ELSE

Line 1046: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1042: 'AMS_CTDS',
1043: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||''''
1044: );
1045: ELSE
1046: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1047: 'AMS_CTDS',
1048: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||
1049: ''' AND CTD_ID <> ' || p_ctd_rec.CTD_ID
1050: );

Line 1054: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CTD_ID_DUPLICATE');

1050: );
1051: END IF;
1052:
1053: IF l_valid_flag = FND_API.g_false THEN
1054: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CTD_ID_DUPLICATE');
1055: x_return_status := FND_API.g_ret_sts_error;
1056: RETURN;
1057: END IF;
1058:

Line 1074: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_ctd_id');

1070: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1071:
1072:
1073: IF p_ctd_rec.ctd_id = FND_API.g_miss_num OR p_ctd_rec.ctd_id IS NULL THEN
1074: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_ctd_id');
1075: x_return_status := FND_API.g_ret_sts_error;
1076: RETURN;
1077: END IF;
1078:

Line 1081: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_action_id');

1077: END IF;
1078:
1079:
1080: IF p_ctd_rec.action_id = FND_API.g_miss_num OR p_ctd_rec.action_id IS NULL THEN
1081: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_action_id');
1082: x_return_status := FND_API.g_ret_sts_error;
1083: RETURN;
1084: END IF;
1085:

Line 1088: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_object_version_number');

1084: END IF;
1085:
1086:
1087: IF p_ctd_rec.object_version_number = FND_API.g_miss_num OR p_ctd_rec.object_version_number IS NULL THEN
1088: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_object_version_number');
1089: x_return_status := FND_API.g_ret_sts_error;
1090: RETURN;
1091: END IF;
1092:

Line 1095: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_update_date');

1091: END IF;
1092:
1093:
1094: IF p_ctd_rec.last_update_date = FND_API.g_miss_date OR p_ctd_rec.last_update_date IS NULL THEN
1095: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_update_date');
1096: x_return_status := FND_API.g_ret_sts_error;
1097: RETURN;
1098: END IF;
1099:

Line 1102: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_updated_by');

1098: END IF;
1099:
1100:
1101: IF p_ctd_rec.last_updated_by = FND_API.g_miss_num OR p_ctd_rec.last_updated_by IS NULL THEN
1102: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_updated_by');
1103: x_return_status := FND_API.g_ret_sts_error;
1104: RETURN;
1105: END IF;
1106:

Line 1109: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_creation_date');

1105: END IF;
1106:
1107:
1108: IF p_ctd_rec.creation_date = FND_API.g_miss_date OR p_ctd_rec.creation_date IS NULL THEN
1109: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_creation_date');
1110: x_return_status := FND_API.g_ret_sts_error;
1111: RETURN;
1112: END IF;
1113:

Line 1116: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_created_by');

1112: END IF;
1113:
1114:
1115: IF p_ctd_rec.created_by = FND_API.g_miss_num OR p_ctd_rec.created_by IS NULL THEN
1116: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_created_by');
1117: x_return_status := FND_API.g_ret_sts_error;
1118: RETURN;
1119: END IF;
1120: ELSE

Line 1124: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_ctd_id');

1120: ELSE
1121:
1122:
1123: IF p_ctd_rec.ctd_id IS NULL THEN
1124: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_ctd_id');
1125: x_return_status := FND_API.g_ret_sts_error;
1126: RETURN;
1127: END IF;
1128:

Line 1131: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_action_id');

1127: END IF;
1128:
1129:
1130: IF p_ctd_rec.action_id IS NULL THEN
1131: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_action_id');
1132: x_return_status := FND_API.g_ret_sts_error;
1133: RETURN;
1134: END IF;
1135:

Line 1138: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_object_version_number');

1134: END IF;
1135:
1136:
1137: IF p_ctd_rec.object_version_number IS NULL THEN
1138: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_object_version_number');
1139: x_return_status := FND_API.g_ret_sts_error;
1140: RETURN;
1141: END IF;
1142:

Line 1145: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_update_date');

1141: END IF;
1142:
1143:
1144: IF p_ctd_rec.last_update_date IS NULL THEN
1145: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_update_date');
1146: x_return_status := FND_API.g_ret_sts_error;
1147: RETURN;
1148: END IF;
1149:

Line 1152: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_updated_by');

1148: END IF;
1149:
1150:
1151: IF p_ctd_rec.last_updated_by IS NULL THEN
1152: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_last_updated_by');
1153: x_return_status := FND_API.g_ret_sts_error;
1154: RETURN;
1155: END IF;
1156:

Line 1159: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_creation_date');

1155: END IF;
1156:
1157:
1158: IF p_ctd_rec.creation_date IS NULL THEN
1159: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_creation_date');
1160: x_return_status := FND_API.g_ret_sts_error;
1161: RETURN;
1162: END IF;
1163:

Line 1166: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_created_by');

1162: END IF;
1163:
1164:
1165: IF p_ctd_rec.created_by IS NULL THEN
1166: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ctd_NO_created_by');
1167: x_return_status := FND_API.g_ret_sts_error;
1168: RETURN;
1169: END IF;
1170: END IF;

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

1397: END IF;
1398:
1399:
1400: -- Debug Message
1401: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1402:
1403:
1404: -- Initialize API return status to SUCCESS
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407:
1408: -- Debug Message
1409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1410:
1411: -- Standard call to get message count and if count is 1, get message info.
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,

Line 1418: WHEN AMS_Utility_PVT.resource_locked THEN

1414: p_data => x_msg_data
1415: );
1416: EXCEPTION
1417:
1418: WHEN AMS_Utility_PVT.resource_locked THEN
1419: x_return_status := FND_API.g_ret_sts_error;
1420: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1421:
1422: WHEN FND_API.G_EXC_ERROR THEN

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

1416: EXCEPTION
1417:
1418: WHEN AMS_Utility_PVT.resource_locked THEN
1419: x_return_status := FND_API.g_ret_sts_error;
1420: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1421:
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: ROLLBACK TO VALIDATE_Ctd_;
1424: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1483: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1479: -- THEN
1480: -- x_return_status := FND_API.G_RET_STS_ERROR;
1481:
1482: -- Debug Message
1483: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1484: -- Standard call to get message count and if count is 1, get message info.
1485: FND_MSG_PUB.Count_And_Get
1486: (p_count => x_msg_count,
1487: p_data => x_msg_data

Line 1513: --AMS_Utility_PVT.Error_Message('AMS_ctd_NO_ctd_id');

1509: BEGIN
1510: x_return_status := FND_API.g_ret_sts_success;
1511:
1512: IF P_ctd_rec.ctd_id = FND_API.g_miss_num OR P_ctd_rec.ctd_id IS NULL THEN
1513: --AMS_Utility_PVT.Error_Message('AMS_ctd_NO_ctd_id');
1514: x_return_status := FND_API.g_ret_sts_error;
1515: FND_MESSAGE.set_name('AMS', 'AMS_ctd_NO_ctd_id');
1516: FND_MSG_PUB.add;
1517: RETURN;

Line 1522: --AMS_Utility_PVT.Error_Message('AMS_ctd_NO_FORWARD_URL');

1518: END IF;
1519:
1520: IF P_ctd_rec.track_url IS NOT NULL THEN
1521: IF P_ctd_rec.forward_url IS NULL AND P_ctd_rec.action_id =1 THEN
1522: --AMS_Utility_PVT.Error_Message('AMS_ctd_NO_FORWARD_URL');
1523: x_return_status := FND_API.g_ret_sts_error;
1524: FND_MESSAGE.set_name('AMS', 'AMS_PU_REQ_FIELDS_NOT_MAPPED');
1525: FND_MSG_PUB.add;
1526: RETURN;