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

Line 133: AMS_Utility_PVT.debug_message(l_api_name||': validate ');

129: CLOSE c_get_cell_name;
130:
131:
132: IF (AMS_DEBUG_HIGH_ON) THEN
133: AMS_Utility_PVT.debug_message(l_api_name||': validate ');
134: END IF;
135: AMS_CELL_PVT.get_single_sql(
136: p_api_version => 1.0,
137: p_init_msg_list => FND_API.G_FALSE,

Line 146: AMS_Utility_PVT.debug_message('get_single_sql status:' || l_return_status);

142: p_cell_id => p_cell_id,
143: x_sql_string => l_sql_string
144: );
145: IF (AMS_DEBUG_HIGH_ON) THEN
146: AMS_Utility_PVT.debug_message('get_single_sql status:' || l_return_status);
147: END IF;
148: IF l_return_status = FND_API.g_ret_sts_error THEN
149: RAISE FND_API.g_exc_error;
150: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 155: AMS_Utility_PVT.debug_message('sql_string:' || length(l_sql_string));

151: RAISE FND_API.g_exc_unexpected_error;
152: END IF;
153:
154: IF (AMS_DEBUG_HIGH_ON) THEN
155: AMS_Utility_PVT.debug_message('sql_string:' || length(l_sql_string));
156: END IF;
157: IF l_sql_string IS NULL OR
158: l_sql_string = ''
159: THEN

Line 165: AMS_Utility_PVT.debug_message('sql_string2:' || length(l_sql_string));

161: ELSE
162: --l_sql_string := UPPER(l_sql_string);
163:
164: IF (AMS_DEBUG_HIGH_ON) THEN
165: AMS_Utility_PVT.debug_message('sql_string2:' || length(l_sql_string));
166: END IF;
167: l_count := 0;
168: l_string_copy := l_sql_string;
169: l_length := length(l_string_copy);

Line 184: AMS_Utility_PVT.debug_message('validate string:' || length(l_sql_string));

180: l_length := length(l_string_copy);
181: END LOOP;
182:
183: IF (AMS_DEBUG_HIGH_ON) THEN
184: AMS_Utility_PVT.debug_message('validate string:' || length(l_sql_string));
185: END IF;
186: l_found := 'N';
187: AMS_ListGeneration_PKG.validate_sql_string(
188: p_sql_string => l_sql_string_tbl ,

Line 196: AMS_Utility_PVT.debug_message('FROM:' || l_found);

192: x_position => l_from_position,
193: x_counter => l_from_counter) ;
194:
195: IF (AMS_DEBUG_HIGH_ON) THEN
196: AMS_Utility_PVT.debug_message('FROM:' || l_found);
197: END IF;
198: IF l_found = 'N' THEN
199: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
200: FND_MSG_PUB.Add;

Line 219: AMS_Utility_PVT.debug_message('MASTER_TYPE:' || l_found);

215: x_source_object_name => l_source_object_name,
216: x_source_object_pk_field => l_source_object_pk_field);
217:
218: IF (AMS_DEBUG_HIGH_ON) THEN
219: AMS_Utility_PVT.debug_message('MASTER_TYPE:' || l_found);
220: END IF;
221: IF nvl(l_found,'N') = 'N' THEN
222: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
223: FND_MSG_PUB.Add;

Line 228: AMS_Utility_PVT.debug_message('sucess full:' );

224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: END IF;
227: IF (AMS_DEBUG_HIGH_ON) THEN
228: AMS_Utility_PVT.debug_message('sucess full:' );
229: END IF;
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,

Line 335: AMS_UTILITY_PVT.CREATE_LOG(

331:
332: -- g_message_table(g_count) := p_msg_data;
333: -- g_count := g_count + 1;
334: /*
335: AMS_UTILITY_PVT.CREATE_LOG(
336: x_return_status => l_return_status,
337: p_arc_log_used_by => 'LIST',
338: p_log_used_by_id => g_list_header_id,
339: p_msg_data => p_msg_data);

Line 454: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');

450:
451: -- Debug Message
452: IF (AMS_DEBUG_HIGH_ON) THEN
453:
454: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');
455: END IF;
456:
457:
458: -- Initialize API return status to SUCCESS

Line 485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING');

481: -- =========================================================================
482:
483: IF FND_GLOBAL.User_Id IS NULL
484: THEN
485: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_USER_PROFILE_MISSING');
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 494: AMS_Utility_PVT.debug_message('Private API: Validate_Act_List');

490: THEN
491: -- Debug message
492: IF (AMS_DEBUG_HIGH_ON) THEN
493:
494: AMS_Utility_PVT.debug_message('Private API: Validate_Act_List');
495: END IF;
496: -- Invoke validation procedures
497: IF (AMS_DEBUG_HIGH_ON) THEN
498:

Line 499: AMS_Utility_PVT.debug_message('1)validate act_list ' || x_return_status );

495: END IF;
496: -- Invoke validation procedures
497: IF (AMS_DEBUG_HIGH_ON) THEN
498:
499: AMS_Utility_PVT.debug_message('1)validate act_list ' || x_return_status );
500: END IF;
501:
502: Validate_act_list(
503: p_api_version_number => 1.0,

Line 515: AMS_Utility_PVT.debug_message('2)validate act list ->' || x_return_status );

511:
512:
513: IF (AMS_DEBUG_HIGH_ON) THEN
514:
515: AMS_Utility_PVT.debug_message('2)validate act list ->' || x_return_status );
516: END IF;
517: END IF;
518:
519: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 529: AMS_Utility_PVT.debug_message( 'Private API: Call Group code handler');

525: and l_act_list_rec.group_code is not null then
526: -- Debug Message
527: IF (AMS_DEBUG_HIGH_ON) THEN
528:
529: AMS_Utility_PVT.debug_message( 'Private API: Call Group code handler');
530: END IF;
531: l_act_list_group_id := null;
532: open c_check_group (l_act_list_rec.group_code ) ;
533: fetch c_check_group into l_act_list_group_id ;

Line 564: AMS_Utility_PVT.debug_message( 'Private API: Call create table handler');

560: -- Invoke table handler(AMS_ACT_LISTS_PKG.Insert_Row)
561: -- Debug Message
562: IF (AMS_DEBUG_HIGH_ON) THEN
563:
564: AMS_Utility_PVT.debug_message( 'Private API: Call create table handler');
565: END IF;
566:
567: AMS_ACT_LISTS_PKG.Insert_Row(
568: px_act_list_header_id => l_act_list_header_id,

Line 626: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');

622:
623: -- Debug Message
624: IF (AMS_DEBUG_HIGH_ON) THEN
625:
626: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
627: END IF;
628:
629: -- Standard call to get message count and if count is 1, get message info.
630: FND_MSG_PUB.Count_And_Get

Line 636: WHEN AMS_Utility_PVT.resource_locked THEN

632: p_data => x_msg_data
633: );
634: EXCEPTION
635:
636: WHEN AMS_Utility_PVT.resource_locked THEN
637: x_return_status := FND_API.g_ret_sts_error;
638: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
639:
640: WHEN FND_API.G_EXC_ERROR THEN

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

634: EXCEPTION
635:
636: WHEN AMS_Utility_PVT.resource_locked THEN
637: x_return_status := FND_API.g_ret_sts_error;
638: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
639:
640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO CREATE_Act_List_PVT;
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 895: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');

891:
892: -- Debug Message
893: IF (AMS_DEBUG_HIGH_ON) THEN
894:
895: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');
896: END IF;
897:
898: -- Initialize API return status to SUCCESS
899: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 904: AMS_Utility_PVT.debug_message('Private API: - Open Cursor to Select');

900:
901: -- Debug Message
902: IF (AMS_DEBUG_HIGH_ON) THEN
903:
904: AMS_Utility_PVT.debug_message('Private API: - Open Cursor to Select');
905: END IF;
906:
907: OPEN c_get_Act_List( l_tar_act_list_rec.act_list_header_id);
908: FETCH c_get_Act_List INTO l_ref_act_list_rec ;

Line 910: AMS_Utility_PVT.Error_Message(p_message_name =>

906:
907: OPEN c_get_Act_List( l_tar_act_list_rec.act_list_header_id);
908: FETCH c_get_Act_List INTO l_ref_act_list_rec ;
909: If ( c_get_Act_List%NOTFOUND) THEN
910: AMS_Utility_PVT.Error_Message(p_message_name =>
911: 'AMS_API_MISSING_UPDATE_TARGET',
912: p_token_name => 'INFO',
913: p_token_value => 'Act_List') ;
914: RAISE FND_API.G_EXC_ERROR;

Line 919: AMS_Utility_PVT.debug_message('Private API: - Close Cursor');

915: END IF;
916: -- Debug Message
917: IF (AMS_DEBUG_HIGH_ON) THEN
918:
919: AMS_Utility_PVT.debug_message('Private API: - Close Cursor');
920: END IF;
921: CLOSE c_get_Act_List;
922:
923:

Line 926: AMS_Utility_PVT.Error_Message(p_message_name =>

922:
923:
924: If (l_tar_act_list_rec.object_version_number is NULL or
925: l_tar_act_list_rec.object_version_number = FND_API.G_MISS_NUM ) Then
926: AMS_Utility_PVT.Error_Message(p_message_name =>
927: 'AMS_API_VERSION_MISSING',
928: p_token_name => 'COLUMN',
929: p_token_value => 'Last_Update_Date') ;
930: raise FND_API.G_EXC_ERROR;

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

931: End if;
932: -- Check Whether record has been changed by someone else
933: If (l_tar_act_list_rec.object_version_number <>
934: l_ref_act_list_rec.object_version_number) Then
935: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
936: p_token_name => 'INFO',
937: p_token_value => 'Act_List') ;
938: raise FND_API.G_EXC_ERROR;
939: End if;

Line 953: AMS_Utility_PVT.debug_message('Private API: Validate_Act_List');

949: IF (AMS_DEBUG_HIGH_ON) THEN
950:
951:
952:
953: AMS_Utility_PVT.debug_message('Private API: Validate_Act_List');
954:
955: END IF;
956:
957: -- Invoke validation procedures

Line 1036: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');

1032:
1033: -- Debug Message
1034: IF (AMS_DEBUG_HIGH_ON) THEN
1035:
1036: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1037: END IF;
1038:
1039: -- Standard call to get message count and if count is 1, get message info.
1040: FND_MSG_PUB.Count_And_Get

Line 1046: WHEN AMS_Utility_PVT.resource_locked THEN

1042: p_data => x_msg_data
1043: );
1044: EXCEPTION
1045:
1046: WHEN AMS_Utility_PVT.resource_locked THEN
1047: x_return_status := FND_API.g_ret_sts_error;
1048: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1049: WHEN FND_API.G_EXC_ERROR THEN
1050: ROLLBACK TO UPDATE_Act_List_PVT;

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

1044: EXCEPTION
1045:
1046: WHEN AMS_Utility_PVT.resource_locked THEN
1047: x_return_status := FND_API.g_ret_sts_error;
1048: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1049: WHEN FND_API.G_EXC_ERROR THEN
1050: ROLLBACK TO UPDATE_Act_List_PVT;
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: -- Standard call to get message count and if count=1, get the message

Line 1142: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');

1138:
1139: -- Debug Message
1140: IF (AMS_DEBUG_HIGH_ON) THEN
1141:
1142: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');
1143: END IF;
1144:
1145:
1146: -- Initialize API return status to SUCCESS

Line 1155: AMS_Utility_PVT.debug_message( 'Private API: Calling delete table

1151: --
1152: -- Debug Message
1153: IF (AMS_DEBUG_HIGH_ON) THEN
1154:
1155: AMS_Utility_PVT.debug_message( 'Private API: Calling delete table
1156: handler');
1157: END IF;
1158:
1159: -- Invoke table handler(AMS_ACT_LISTS_PKG.Delete_Row)

Line 1182: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');

1178:
1179: -- Debug Message
1180: IF (AMS_DEBUG_HIGH_ON) THEN
1181:
1182: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1183: END IF;
1184:
1185: -- Standard call to get message count and if count is 1, get message info.
1186: FND_MSG_PUB.Count_And_Get

Line 1192: WHEN AMS_Utility_PVT.resource_locked THEN

1188: p_data => x_msg_data
1189: );
1190: EXCEPTION
1191:
1192: WHEN AMS_Utility_PVT.resource_locked THEN
1193: x_return_status := FND_API.g_ret_sts_error;
1194: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO DELETE_Act_List_PVT;

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

1190: EXCEPTION
1191:
1192: WHEN AMS_Utility_PVT.resource_locked THEN
1193: x_return_status := FND_API.g_ret_sts_error;
1194: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO DELETE_Act_List_PVT;
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: -- Standard call to get message count and if count=1, get the message

Line 1261: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');

1257:
1258: -- Debug Message
1259: IF (AMS_DEBUG_HIGH_ON) THEN
1260:
1261: AMS_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');
1262: END IF;
1263: -- Initialize message list if p_init_msg_list is set to TRUE.
1264: IF FND_API.to_Boolean( p_init_msg_list )
1265: THEN

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

1282: IF (AMS_DEBUG_HIGH_ON) THEN
1283:
1284:
1285:
1286: AMS_Utility_PVT.debug_message(l_full_name||': start');
1287:
1288: END IF;
1289: OPEN c_Act_List;
1290:

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

1307: p_count => x_msg_count,
1308: p_data => x_msg_data);
1309: IF (AMS_DEBUG_HIGH_ON) THEN
1310:
1311: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1312: END IF;
1313: EXCEPTION
1314:
1315: WHEN AMS_Utility_PVT.resource_locked THEN

Line 1315: WHEN AMS_Utility_PVT.resource_locked THEN

1311: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1312: END IF;
1313: EXCEPTION
1314:
1315: WHEN AMS_Utility_PVT.resource_locked THEN
1316: x_return_status := FND_API.g_ret_sts_error;
1317: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1318: WHEN FND_API.G_EXC_ERROR THEN
1319: ROLLBACK TO LOCK_Act_List_PVT;

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

1313: EXCEPTION
1314:
1315: WHEN AMS_Utility_PVT.resource_locked THEN
1316: x_return_status := FND_API.g_ret_sts_error;
1317: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1318: WHEN FND_API.G_EXC_ERROR THEN
1319: ROLLBACK TO LOCK_Act_List_PVT;
1320: x_return_status := FND_API.G_RET_STS_ERROR;
1321: -- Standard call to get message count and if count=1, get the message

Line 1379: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1375: l_count NUMBER;
1376: BEGIN
1377: x_return_status := FND_API.g_ret_sts_success;
1378: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1379: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1380: 'AMS_ACT_LISTS',
1381: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1382: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1383: );

Line 1385: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1381: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1382: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1383: );
1384: ELSE
1385: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1386: 'AMS_ACT_LISTS',
1387: 'ACT_LIST_HEADER_ID = ' || p_act_list_rec.ACT_LIST_HEADER_ID
1388: ||' AND LIST_ACT_TYPE = ' ||''''|| p_act_list_rec.LIST_ACT_TYPE||''''
1389: ||' AND ACT_LIST_HEADER_ID <> ' || p_act_list_rec.ACT_LIST_HEADER_ID

Line 1394: AMS_Utility_PVT.Error_Message(p_message_name =>

1390: );
1391: END IF;
1392:
1393: IF l_valid_flag = FND_API.g_false THEN
1394: AMS_Utility_PVT.Error_Message(p_message_name =>
1395: 'AMS_ACT_LIST_ID_DUPLICATE');
1396: x_return_status := FND_API.g_ret_sts_error;
1397: RETURN;
1398: END IF;

Line 1401: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1397: RETURN;
1398: END IF;
1399:
1400: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1401: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1402: 'ams_act_lists',
1403: 'list_used_by_id = ' || p_act_list_rec.list_used_by_id||
1404: ' and list_used_by = '||''''||p_act_list_rec.list_used_by||''''
1405: ||' AND LIST_ACT_TYPE = ' || ''''||p_act_list_rec.LIST_ACT_TYPE||''''

Line 1410: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1406: ||' and list_header_id = '||p_act_list_rec.list_header_id
1407: ) ;
1408: ELSE
1409: /* dmvincen BUG 3792776: Too many variables for auto binding.
1410: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1411: 'ams_act_lists',
1412: 'list_used_by_id = ' || p_act_list_rec.list_used_by_id||
1413: ' and list_used_by = '||''''||p_act_list_rec.list_used_by||''''
1414: ||' AND LIST_ACT_TYPE = ' || ''''||p_act_list_rec.LIST_ACT_TYPE||''''

Line 1435: AMS_Utility_PVT.Error_Message(p_message_name =>

1431: END IF;
1432: END IF;
1433:
1434: IF l_valid_flag = FND_API.g_false THEN
1435: AMS_Utility_PVT.Error_Message(p_message_name =>
1436: 'AMS_ACT_LIST_USED_DUP');
1437: x_return_status := FND_API.g_ret_sts_error;
1438: RETURN;
1439: END IF;

Line 1456: AMS_Utility_PVT.Error_Message(p_message_name =>

1452: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1453:
1454: IF p_act_list_rec.list_header_id = FND_API.g_miss_num OR
1455: p_act_list_rec.list_header_id IS NULL THEN
1456: AMS_Utility_PVT.Error_Message(p_message_name =>
1457: 'AMS_API_MISSING_FIELD');
1458: FND_MESSAGE.set_token('MISS_FIELD',
1459: 'LIST_HEADER_ID' );
1460: x_return_status := FND_API.g_ret_sts_error;

Line 1467: AMS_Utility_PVT.Error_Message(p_message_name =>

1463:
1464:
1465: IF p_act_list_rec.list_used_by_id = FND_API.g_miss_num OR
1466: p_act_list_rec.list_used_by_id IS NULL THEN
1467: AMS_Utility_PVT.Error_Message(p_message_name =>
1468: 'AMS_USER_PROFILE_MISSING');
1469: x_return_status := FND_API.g_ret_sts_error;
1470: RETURN;
1471: END IF;

Line 1476: AMS_Utility_PVT.Error_Message(p_message_name =>

1472:
1473:
1474: IF p_act_list_rec.list_used_by = FND_API.g_miss_char OR
1475: p_act_list_rec.list_used_by IS NULL THEN
1476: AMS_Utility_PVT.Error_Message(p_message_name =>
1477: 'AMS_API_MISSING_FIELD');
1478: FND_MESSAGE.set_token('MISS_FIELD',
1479: 'LIST_USED_BY' );
1480: x_return_status := FND_API.g_ret_sts_error;

Line 1485: AMS_Utility_PVT.Error_Message(p_message_name =>

1481: RETURN;
1482: END IF;
1483: IF p_act_list_rec.list_act_type = FND_API.g_miss_char OR
1484: p_act_list_rec.list_act_type IS NULL THEN
1485: AMS_Utility_PVT.Error_Message(p_message_name =>
1486: 'AMS_API_MISSING_FIELD');
1487: FND_MESSAGE.set_token('MISS_FIELD',
1488: 'LIST_ACT_TYPE' );
1489: x_return_status := FND_API.g_ret_sts_error;

Line 1497: AMS_Utility_PVT.Error_Message(p_message_name =>

1493:
1494: ELSE
1495: /* Update Record */
1496: IF p_act_list_rec.act_list_header_id IS NULL THEN
1497: AMS_Utility_PVT.Error_Message(p_message_name =>
1498: 'AMS_API_MISSING_FIELD');
1499: FND_MESSAGE.set_token('MISS_FIELD',
1500: 'ACT_LIST_HEADER_ID' );
1501: x_return_status := FND_API.g_ret_sts_error;

Line 1506: AMS_Utility_PVT.Error_Message(p_message_name =>

1502: RETURN;
1503: END IF;
1504:
1505: IF p_act_list_rec.list_header_id IS NULL THEN
1506: AMS_Utility_PVT.Error_Message(p_message_name =>
1507: 'AMS_API_RESOURCE_LOCKED');
1508: x_return_status := FND_API.g_ret_sts_error;
1509: RETURN;
1510: END IF;

Line 1514: AMS_Utility_PVT.Error_Message(p_message_name =>

1510: END IF;
1511:
1512:
1513: IF p_act_list_rec.list_used_by_id IS NULL THEN
1514: AMS_Utility_PVT.Error_Message(p_message_name =>
1515: 'AMS_API_RESOURCE_LOCKED');
1516: x_return_status := FND_API.g_ret_sts_error;
1517: RETURN;
1518: END IF;

Line 1522: AMS_Utility_PVT.Error_Message(p_message_name =>

1518: END IF;
1519:
1520:
1521: IF p_act_list_rec.list_used_by IS NULL THEN
1522: AMS_Utility_PVT.Error_Message(p_message_name =>
1523: 'AMS_API_RESOURCE_LOCKED');
1524: x_return_status := FND_API.g_ret_sts_error;
1525: RETURN;
1526: END IF;

Line 1529: AMS_Utility_PVT.Error_Message(p_message_name =>

1525: RETURN;
1526: END IF;
1527:
1528: IF p_act_list_rec.list_act_type IS NULL THEN
1529: AMS_Utility_PVT.Error_Message(p_message_name =>
1530: 'AMS_API_RESOURCE_LOCKED');
1531: x_return_status := FND_API.g_ret_sts_error;
1532: RETURN;
1533: END IF;

Line 1554: AMS_Utility_PVT.get_qual_table_name_and_pk(

1550: BEGIN
1551: x_return_status := FND_API.g_ret_sts_success;
1552:
1553: IF p_act_list_rec.list_used_by <> FND_API.g_miss_char THEN
1554: AMS_Utility_PVT.get_qual_table_name_and_pk(
1555: p_sys_qual => p_act_list_rec.list_used_by,
1556: x_return_status => x_return_status,
1557: x_table_name => l_table_name,
1558: x_pk_name => l_pk_name

Line 1566: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name

1562: RETURN;
1563: END IF;
1564:
1565: IF p_act_list_rec.list_used_by_id <> FND_API.g_miss_num THEN
1566: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
1567: , l_pk_name
1568: , p_act_list_rec.list_used_by_id)
1569: = FND_API.G_TRUE)
1570: THEN

Line 1591: AMS_Utility_PVT.get_qual_table_name_and_pk(

1587: l_list_act_type := 'LIST';
1588: else
1589: l_list_act_type := p_act_list_rec.list_act_type ;
1590: end if;
1591: AMS_Utility_PVT.get_qual_table_name_and_pk(
1592: p_sys_qual => l_list_act_type,
1593: x_return_status => x_return_status,
1594: x_table_name => l_table_name,
1595: x_pk_name => l_pk_name

Line 1602: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name

1598: IF x_return_status <> FND_API.g_ret_sts_success THEN
1599: RETURN;
1600: END IF;
1601:
1602: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
1603: , l_pk_name
1604: , p_act_list_rec.list_header_id)
1605: = FND_API.G_TRUE)
1606: THEN

Line 1633: IF AMS_Utility_PVT.check_lookup_exists(

1629:
1630: -- Enter custom code here
1631: IF p_act_list_rec.list_act_type <> 'TARGET' and p_act_list_rec.list_act_type <> 'EMPLOYEE' then
1632: IF p_act_list_rec.list_act_type <> FND_API.g_miss_char THEN
1633: IF AMS_Utility_PVT.check_lookup_exists(
1634: p_lookup_type => 'AMS_LIST_ACT_TYPE',
1635: p_lookup_code => p_act_list_rec.list_act_type
1636: ) = FND_API.g_false
1637: THEN

Line 1654: IF AMS_Utility_PVT.check_lookup_exists(

1650: END IF;
1651:
1652: -- Check list_action_type
1653: IF p_act_list_rec.list_action_type <> FND_API.g_miss_char THEN
1654: IF AMS_Utility_PVT.check_lookup_exists(
1655: p_lookup_type => 'AMS_LIST_SELECT_ACTION',
1656: p_lookup_code => p_act_list_rec.list_action_type
1657: ) = FND_API.g_false
1658: THEN

Line 1687: AMS_Utility_PVT.debug_message('validate uk items' );

1683: IF (AMS_DEBUG_HIGH_ON) THEN
1684:
1685:
1686:
1687: AMS_Utility_PVT.debug_message('validate uk items' );
1688:
1689: END IF;
1690: check_act_list_uk_items(
1691: p_act_list_rec => p_act_list_rec,

Line 1704: AMS_Utility_PVT.debug_message('validate req items' );

1700: IF (AMS_DEBUG_HIGH_ON) THEN
1701:
1702:
1703:
1704: AMS_Utility_PVT.debug_message('validate req items' );
1705:
1706: END IF;
1707: check_act_list_req_items(
1708: p_act_list_rec => p_act_list_rec,

Line 1717: AMS_Utility_PVT.debug_message('validate fk items' );

1713: END IF;
1714: -- Check Items Foreign Keys API calls
1715: IF (AMS_DEBUG_HIGH_ON) THEN
1716:
1717: AMS_Utility_PVT.debug_message('validate fk items' );
1718: END IF;
1719:
1720: check_act_list_FK_items(
1721: p_act_list_rec => p_act_list_rec,

Line 1732: AMS_Utility_PVT.debug_message('validate lookups items' );

1728: IF (AMS_DEBUG_HIGH_ON) THEN
1729:
1730:
1731:
1732: AMS_Utility_PVT.debug_message('validate lookups items' );
1733:
1734: END IF;
1735: check_act_list_Lookup_items(
1736: p_act_list_rec => p_act_list_rec,

Line 1744: AMS_Utility_PVT.debug_message('validate end of check act list');

1740: END IF;
1741:
1742: IF (AMS_DEBUG_HIGH_ON) THEN
1743:
1744: AMS_Utility_PVT.debug_message('validate end of check act list');
1745: END IF;
1746:
1747: END Check_act_list_Items;
1748:

Line 1789: AMS_Utility_PVT.debug_message('act_list val->' || p_validation_level );

1785:
1786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1787: IF (AMS_DEBUG_HIGH_ON) THEN
1788:
1789: AMS_Utility_PVT.debug_message('act_list val->' || p_validation_level );
1790: END IF;
1791: Check_act_list_Items(
1792: p_act_list_rec => p_act_list_rec,
1793: p_validation_mode => JTF_PLSQL_API.g_update,

Line 1824: AMS_Utility_PVT.debug_message('validate act_list after_act_list_rec' || x_return_status );

1820:
1821:
1822:
1823: IF (AMS_DEBUG_HIGH_ON) THEN
1824: AMS_Utility_PVT.debug_message('validate act_list after_act_list_rec' || x_return_status );
1825: END IF;
1826:
1827: -- Initialize API return status to SUCCESS
1828: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1833: WHEN AMS_Utility_PVT.resource_locked THEN

1829:
1830:
1831: EXCEPTION
1832:
1833: WHEN AMS_Utility_PVT.resource_locked THEN
1834: x_return_status := FND_API.g_ret_sts_error;
1835: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1836:
1837: WHEN FND_API.G_EXC_ERROR THEN

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

1831: EXCEPTION
1832:
1833: WHEN AMS_Utility_PVT.resource_locked THEN
1834: x_return_status := FND_API.g_ret_sts_error;
1835: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1836:
1837: WHEN FND_API.G_EXC_ERROR THEN
1838: ROLLBACK TO VALIDATE_Act_List_;
1839: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1900: AMS_Utility_PVT.debug_message('Private API: Validate_rec');

1896:
1897: -- Debug Message
1898: IF (AMS_DEBUG_HIGH_ON) THEN
1899:
1900: AMS_Utility_PVT.debug_message('Private API: Validate_rec');
1901: END IF;
1902: -- Standard call to get message count and if count is 1, get message info.
1903: FND_MSG_PUB.Count_And_Get
1904: (p_count => x_msg_count,

Line 2483: AMS_Utility_PVT.debug_message('Update_Source_Code:Start');

2479: FND_MSG_PUB.Add;
2480: END IF; */
2481:
2482: IF (AMS_DEBUG_HIGH_ON) THEN
2483: AMS_Utility_PVT.debug_message('Update_Source_Code:Start');
2484: END IF;
2485:
2486:
2487: -- Initialize API return status to success

Line 2917: AMS_Utility_PVT.debug_message('Raise Business event for Target Group -- Start');

2913: write_to_act_log(p_msg_data => 'Business event for traffic cop starts' ,
2914: p_arc_log_used_by => 'LIST',
2915: p_log_used_by_id => g_list_header_id,
2916: p_level =>'LOW');
2917: AMS_Utility_PVT.debug_message('Raise Business event for Target Group -- Start');
2918: -- Raise a business event
2919: l_new_item_key := l_list_header_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
2920: l_parameter_list := WF_PARAMETER_LIST_T();
2921: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');

Line 2921: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');

2917: AMS_Utility_PVT.debug_message('Raise Business event for Target Group -- Start');
2918: -- Raise a business event
2919: l_new_item_key := l_list_header_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
2920: l_parameter_list := WF_PARAMETER_LIST_T();
2921: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');
2922: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2923: p_value => l_list_header_id,
2924: p_parameterlist => l_parameter_list);
2925: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');

Line 2925: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');

2921: AMS_Utility_PVT.debug_message('Raise Business event-- after WF_PARAMETER_LIST_T call');
2922: wf_event.AddParameterToList(p_name => 'LIST_HEADER_ID',
2923: p_value => l_list_header_id,
2924: p_parameterlist => l_parameter_list);
2925: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');
2926: wf_event.AddParameterToList(p_name => 'PURGE_FLAG',
2927: p_value => null,
2928: p_parameterlist => l_parameter_list);
2929: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');

Line 2929: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');

2925: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');
2926: wf_event.AddParameterToList(p_name => 'PURGE_FLAG',
2927: p_value => null,
2928: p_parameterlist => l_parameter_list);
2929: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');
2930: AMS_Utility_PVT.debug_message('Raise Business event-- Start');
2931: WF_EVENT.Raise
2932: ( p_event_name => 'oracle.apps.ams.list.PostTargetGroupEvent',
2933: p_event_key => l_new_item_key,

Line 2930: AMS_Utility_PVT.debug_message('Raise Business event-- Start');

2926: wf_event.AddParameterToList(p_name => 'PURGE_FLAG',
2927: p_value => null,
2928: p_parameterlist => l_parameter_list);
2929: AMS_Utility_PVT.debug_message('Raise Business event-- after AddParameterToList call');
2930: AMS_Utility_PVT.debug_message('Raise Business event-- Start');
2931: WF_EVENT.Raise
2932: ( p_event_name => 'oracle.apps.ams.list.PostTargetGroupEvent',
2933: p_event_key => l_new_item_key,
2934: p_parameters => l_parameter_list);

Line 2935: AMS_Utility_PVT.debug_message('Raise Business event for Target Group -- End');

2931: WF_EVENT.Raise
2932: ( p_event_name => 'oracle.apps.ams.list.PostTargetGroupEvent',
2933: p_event_key => l_new_item_key,
2934: p_parameters => l_parameter_list);
2935: AMS_Utility_PVT.debug_message('Raise Business event for Target Group -- End');
2936: /*write_to_act_log(p_msg_data => 'Business event for traffic cop ends' ,
2937: p_arc_log_used_by => 'LIST',
2938: p_log_used_by_id => g_list_header_id,
2939: p_level =>'LOW');*/

Line 3974: AMS_Utility_PVT.debug_message('Private API:AMS_Act_List_PVT.copy_target_group '||p_from_schedule_id||':::::'||p_to_schedule_id);

3970: begin
3971: SAVEPOINT copy_target_group_pvt;
3972:
3973: IF (AMS_DEBUG_HIGH_ON) THEN
3974: AMS_Utility_PVT.debug_message('Private API:AMS_Act_List_PVT.copy_target_group '||p_from_schedule_id||':::::'||p_to_schedule_id);
3975: END IF;
3976:
3977: open c_get_target_group;
3978: fetch c_get_target_group into l_target_group_rec ;

Line 3986: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group found');

3982: close c_get_target_group;
3983:
3984: IF AMS_DEBUG_HIGH_ON THEN
3985: IF l_target_group_found then
3986: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group found');
3987: ELSE
3988: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group not found');
3989: END IF;
3990: END IF;

Line 3988: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group not found');

3984: IF AMS_DEBUG_HIGH_ON THEN
3985: IF l_target_group_found then
3986: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group found');
3987: ELSE
3988: AMS_Utility_PVT.debug_message('Private API: copy_target_group target group not found');
3989: END IF;
3990: END IF;
3991:
3992:

Line 4095: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done creating header '||l_list_header_id);

4091: RAISE FND_API.g_exc_unexpected_error;
4092: END IF;
4093:
4094: IF (AMS_DEBUG_HIGH_ON) THEN
4095: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done creating header '||l_list_header_id);
4096: END IF;
4097:
4098: copy_selections
4099: ( p_old_header_id => l_old_list_header_id,

Line 4115: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_selections '||FND_API.G_VALID_LEVEL_FULL);

4111: RAISE FND_API.g_exc_unexpected_error;
4112: END IF;
4113:
4114: IF (AMS_DEBUG_HIGH_ON) THEN
4115: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_selections '||FND_API.G_VALID_LEVEL_FULL);
4116: END IF;
4117:
4118:
4119: IF l_query_temp_id IS NOT NULL THEN

Line 4122: AMS_Utility_PVT.debug_message('Private API: copy_target_group, l_query_temp_id : '||l_query_temp_id);

4118:
4119: IF l_query_temp_id IS NOT NULL THEN
4120:
4121: IF (AMS_DEBUG_HIGH_ON) THEN
4122: AMS_Utility_PVT.debug_message('Private API: copy_target_group, l_query_temp_id : '||l_query_temp_id);
4123: END IF;
4124:
4125: OPEN c_get_query_templete_type(l_query_temp_id);
4126: FETCH c_get_query_templete_type INTO l_templete_type;

Line 4130: AMS_Utility_PVT.debug_message('Private API: copy_target_group, template_type'||l_templete_type);

4126: FETCH c_get_query_templete_type INTO l_templete_type;
4127: CLOSE c_get_query_templete_type;
4128:
4129: IF (AMS_DEBUG_HIGH_ON) THEN
4130: AMS_Utility_PVT.debug_message('Private API: copy_target_group, template_type'||l_templete_type);
4131: END IF;
4132:
4133: IF l_templete_type = 'STANDARD' THEN
4134: copy_template_instance

Line 4152: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_template_instance');

4148: RAISE FND_API.g_exc_unexpected_error;
4149: END IF;
4150:
4151: IF (AMS_DEBUG_HIGH_ON) THEN
4152: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_template_instance');
4153: END IF;
4154:
4155: IF (AMS_DEBUG_HIGH_ON) THEN
4156: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_conditions' );

Line 4156: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_conditions' );

4152: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_template_instance');
4153: END IF;
4154:
4155: IF (AMS_DEBUG_HIGH_ON) THEN
4156: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_conditions' );
4157: END IF;
4158:
4159: END IF;
4160:

Line 4228: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done Create_Act_List For Target Group ');

4224: END IF;
4225:
4226:
4227: IF (AMS_DEBUG_HIGH_ON) THEN
4228: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done Create_Act_List For Target Group ');
4229: END IF;
4230:
4231:
4232: for l_target_group_rec in c_get_target_group_comp

Line 4235: AMS_Utility_PVT.debug_message('Private API: copy_target_group, call Create_Act_List For Target Group Components ');

4231:
4232: for l_target_group_rec in c_get_target_group_comp
4233: loop
4234: IF (AMS_DEBUG_HIGH_ON) THEN
4235: AMS_Utility_PVT.debug_message('Private API: copy_target_group, call Create_Act_List For Target Group Components ');
4236: END IF;
4237: j := j + 1;
4238: l_act_list_rec.list_used_by := l_target_group_rec.list_used_by;
4239: l_act_list_rec.list_used_by_id := p_to_schedule_id;

Line 4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );

4250: END IF;
4251: l_last_order_number := l_target_group_rec.order_number ;
4252:
4253: IF (AMS_DEBUG_HIGH_ON) THEN
4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );
4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );

Line 4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );

4251: l_last_order_number := l_target_group_rec.order_number ;
4252:
4253: IF (AMS_DEBUG_HIGH_ON) THEN
4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );
4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );

Line 4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );

4252:
4253: IF (AMS_DEBUG_HIGH_ON) THEN
4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );
4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );

Line 4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );

4253: IF (AMS_DEBUG_HIGH_ON) THEN
4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );
4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );

Line 4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );

4254: AMS_Utility_PVT.debug_message('l_query_id ' || l_query_id );
4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );
4262: END IF;

Line 4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );

4255: AMS_Utility_PVT.debug_message('l_templete_type ' || l_templete_type );
4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );
4262: END IF;
4263:

Line 4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );

4256: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by ' || l_act_list_rec.list_used_by );
4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );
4262: END IF;
4263:
4264: AMS_ACT_LIST_PVT.Create_Act_List(

Line 4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );

4257: AMS_Utility_PVT.debug_message('l_act_list_rec.list_used_by_id ' || l_act_list_rec.list_used_by_id );
4258: AMS_Utility_PVT.debug_message('l_act_list_rec.list_act_type ' || l_act_list_rec.list_act_type );
4259: AMS_Utility_PVT.debug_message('l_act_list_rec.list_action_type ' ||l_act_list_rec.list_action_type );
4260: AMS_Utility_PVT.debug_message('l_act_list_rec.order_number ' || l_act_list_rec.order_number );
4261: AMS_Utility_PVT.debug_message('l_act_list_rec.list_header_id ' || l_act_list_rec.list_header_id );
4262: END IF;
4263:
4264: AMS_ACT_LIST_PVT.Create_Act_List(
4265: p_api_version_number => 1.0,

Line 4283: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done second Create_Act_List');

4279: RAISE FND_API.g_exc_unexpected_error;
4280: END IF;
4281:
4282: IF (AMS_DEBUG_HIGH_ON) THEN
4283: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done second Create_Act_List');
4284: END IF;
4285:
4286: if j = 1 then
4287: --bug 4623994

Line 4340: AMS_Utility_PVT.debug_message('Private API: copy_target_group, excluded list size '|| l_excluded_list_size);

4336: FETCH c_list_size INTO l_excluded_list_size;
4337: CLOSE c_list_size;
4338:
4339: IF (AMS_DEBUG_HIGH_ON) THEN
4340: AMS_Utility_PVT.debug_message('Private API: copy_target_group, excluded list size '|| l_excluded_list_size);
4341: END IF;
4342: --vbhandar added to fix bug 3595605
4343:
4344: l_exclude_action_rec.list_select_action_id := NULL;

Line 4360: AMS_Utility_PVT.debug_message('Private API: copy_target_group, CAlling Create List Action in Copy tG');

4356: l_exclude_action_rec.description := NULL;
4357: l_exclude_action_rec.no_of_rows_targeted := NULL;
4358:
4359: IF (AMS_DEBUG_HIGH_ON) THEN
4360: AMS_Utility_PVT.debug_message('Private API: copy_target_group, CAlling Create List Action in Copy tG');
4361: END IF;
4362:
4363: AMS_ListAction_PVT.Create_ListAction
4364: ( 1.0,

Line 4377: AMS_Utility_PVT.debug_message('Private API: copy_target_group, l_returnStatus after create list' ||l_return_status);

4373: ) ;
4374:
4375:
4376: IF (AMS_DEBUG_HIGH_ON) THEN
4377: AMS_Utility_PVT.debug_message('Private API: copy_target_group, l_returnStatus after create list' ||l_return_status);
4378: END IF;
4379:
4380:
4381:

Line 4399: AMS_Utility_PVT.debug_message('Private API: copy_target_group,finished');

4395: end if;
4396: END IF; -- p_repeat_flag = Y
4397:
4398: IF (AMS_DEBUG_HIGH_ON) THEN
4399: AMS_Utility_PVT.debug_message('Private API: copy_target_group,finished');
4400: END IF;
4401: --RAISE FND_API.G_EXC_ERROR;
4402: END IF ; -- if l_target_group_found
4403: EXCEPTION

Line 4405: WHEN AMS_Utility_PVT.resource_locked THEN

4401: --RAISE FND_API.G_EXC_ERROR;
4402: END IF ; -- if l_target_group_found
4403: EXCEPTION
4404:
4405: WHEN AMS_Utility_PVT.resource_locked THEN
4406: x_return_status := FND_API.g_ret_sts_error;
4407: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
4408: WHEN FND_API.G_EXC_ERROR THEN
4409: ROLLBACK TO copy_target_group_pvt;

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

4403: EXCEPTION
4404:
4405: WHEN AMS_Utility_PVT.resource_locked THEN
4406: x_return_status := FND_API.g_ret_sts_error;
4407: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
4408: WHEN FND_API.G_EXC_ERROR THEN
4409: ROLLBACK TO copy_target_group_pvt;
4410: x_return_status := FND_API.G_RET_STS_ERROR;
4411: -- Standard call to get message count and if count=1, get the message

Line 4485: AMS_Utility_PVT.debug_message('Private API: copy_selections: Begin');

4481: l_old_list_header_id NUMBER;
4482: BEGIN
4483:
4484: IF (AMS_DEBUG_HIGH_ON) THEN
4485: AMS_Utility_PVT.debug_message('Private API: copy_selections: Begin');
4486: END IF;
4487:
4488: OPEN c_select_actions(p_old_header_id);
4489: FETCH c_select_actions INTO l_list_select_action_id;

Line 4492: AMS_Utility_PVT.debug_message('copy_selections old '||p_old_header_id);

4488: OPEN c_select_actions(p_old_header_id);
4489: FETCH c_select_actions INTO l_list_select_action_id;
4490:
4491: IF (AMS_DEBUG_HIGH_ON) THEN
4492: AMS_Utility_PVT.debug_message('copy_selections old '||p_old_header_id);
4493: AMS_Utility_PVT.debug_message('copy_selections new '||p_new_header_id);
4494: END IF;
4495:
4496: FOR l_list_actions_rec IN fetch_list_select_actions(p_old_header_id)

Line 4493: AMS_Utility_PVT.debug_message('copy_selections new '||p_new_header_id);

4489: FETCH c_select_actions INTO l_list_select_action_id;
4490:
4491: IF (AMS_DEBUG_HIGH_ON) THEN
4492: AMS_Utility_PVT.debug_message('copy_selections old '||p_old_header_id);
4493: AMS_Utility_PVT.debug_message('copy_selections new '||p_new_header_id);
4494: END IF;
4495:
4496: FOR l_list_actions_rec IN fetch_list_select_actions(p_old_header_id)
4497: LOOP

Line 4500: AMS_Utility_PVT.debug_message('********************copy_selections enter loop');

4496: FOR l_list_actions_rec IN fetch_list_select_actions(p_old_header_id)
4497: LOOP
4498:
4499: IF (AMS_DEBUG_HIGH_ON) THEN
4500: AMS_Utility_PVT.debug_message('********************copy_selections enter loop');
4501: END IF;
4502:
4503: AMS_ListAction_PVT.init_action_rec(l_action_rec);
4504: l_action_rec.list_select_action_id := NULL;

Line 4520: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID first ' || l_action_rec.incl_object_id);

4516: l_action_rec.no_of_rows_targeted := l_list_actions_rec.no_of_rows_targeted;
4517: l_action_rec.rank := l_list_actions_rec.rank;
4518: l_action_rec.incl_object_id := l_list_actions_rec.incl_object_id;
4519:
4520: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID first ' || l_action_rec.incl_object_id);
4521: --start
4522: IF (AMS_DEBUG_HIGH_ON) THEN
4523: AMS_Utility_PVT.debug_message('Private API: copy_target_group, begin copy_list_queries 1');
4524: END IF;

Line 4523: AMS_Utility_PVT.debug_message('Private API: copy_target_group, begin copy_list_queries 1');

4519:
4520: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID first ' || l_action_rec.incl_object_id);
4521: --start
4522: IF (AMS_DEBUG_HIGH_ON) THEN
4523: AMS_Utility_PVT.debug_message('Private API: copy_target_group, begin copy_list_queries 1');
4524: END IF;
4525:
4526: IF l_list_actions_rec.arc_incl_object_from = 'SQL' THEN
4527: l_list_name := p_list_name;

Line 4539: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 1' || l_new_query_id || ':::');

4535: x_return_status => l_return_status,
4536: x_new_query_id => l_new_query_id
4537: );
4538: IF (AMS_DEBUG_HIGH_ON) THEN
4539: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 1' || l_new_query_id || ':::');
4540: END IF;
4541:
4542: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID second ' || l_action_rec.incl_object_id);
4543: l_action_rec.incl_object_id := l_new_query_id;

Line 4542: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID second ' || l_action_rec.incl_object_id);

4538: IF (AMS_DEBUG_HIGH_ON) THEN
4539: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 1' || l_new_query_id || ':::');
4540: END IF;
4541:
4542: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID second ' || l_action_rec.incl_object_id);
4543: l_action_rec.incl_object_id := l_new_query_id;
4544: x_query_id := l_action_rec.incl_object_id;
4545: IF (AMS_DEBUG_HIGH_ON) THEN
4546: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 2');

Line 4546: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 2');

4542: AMS_Utility_PVT.debug_message('Action Rec Incl Object ID second ' || l_action_rec.incl_object_id);
4543: l_action_rec.incl_object_id := l_new_query_id;
4544: x_query_id := l_action_rec.incl_object_id;
4545: IF (AMS_DEBUG_HIGH_ON) THEN
4546: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_list_queries 2');
4547: END IF;
4548:
4549:
4550: copy_query_list_params

Line 4565: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_query_list_params');

4561: RAISE FND_API.g_exc_unexpected_error;
4562: END IF;
4563:
4564: IF (AMS_DEBUG_HIGH_ON) THEN
4565: AMS_Utility_PVT.debug_message('Private API: copy_target_group, done copy_query_list_params');
4566: END IF;
4567: END IF ;
4568: --end
4569:

Line 4572: AMS_Utility_PVT.debug_message('CAlling Create List Action in Copy Selections');

4568: --end
4569:
4570:
4571: IF (AMS_DEBUG_HIGH_ON) THEN
4572: AMS_Utility_PVT.debug_message('CAlling Create List Action in Copy Selections');
4573: END IF;
4574:
4575: AMS_ListAction_PVT.Create_ListAction
4576: ( l_api_version,

Line 4590: AMS_Utility_PVT.debug_message('(' || i || ') ' || l_msg_data);

4586:
4587: -------------VBCHANGE--------------------
4588: /* FOR i IN 1 .. l_msg_count LOOP
4589: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
4590: AMS_Utility_PVT.debug_message('(' || i || ') ' || l_msg_data);
4591: END LOOP;*/
4592:
4593: IF (AMS_DEBUG_HIGH_ON) THEN
4594: AMS_Utility_PVT.debug_message('Return status from Create_ListAction'||l_return_status);

Line 4594: AMS_Utility_PVT.debug_message('Return status from Create_ListAction'||l_return_status);

4590: AMS_Utility_PVT.debug_message('(' || i || ') ' || l_msg_data);
4591: END LOOP;*/
4592:
4593: IF (AMS_DEBUG_HIGH_ON) THEN
4594: AMS_Utility_PVT.debug_message('Return status from Create_ListAction'||l_return_status);
4595: END IF;
4596: IF l_return_status = FND_API.g_ret_sts_error THEN
4597: RAISE FND_API.g_exc_error;
4598: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4607: AMS_Utility_PVT.debug_message('copy_selections done creation');

4603: UPDATE ams_list_select_actions SET incl_object_name = l_list_actions_rec.incl_object_name
4604: WHERE list_select_action_id = l_action_id;
4605: -------------- x_query_id := l_action_rec.incl_object_id;------------VBCHANGE---------
4606: IF (AMS_DEBUG_HIGH_ON) THEN
4607: AMS_Utility_PVT.debug_message('copy_selections done creation');
4608: END IF;
4609:
4610:
4611: END LOOP;

Line 4662: AMS_Utility_PVT.debug_message('copy_list_queries p_old_query_id = ' || p_old_query_id);

4658:
4659: BEGIN
4660:
4661: IF (AMS_DEBUG_HIGH_ON) THEN
4662: AMS_Utility_PVT.debug_message('copy_list_queries p_old_query_id = ' || p_old_query_id);
4663: END IF;
4664:
4665: OPEN fetch_list_queries_all(p_old_query_id);
4666: FETCH fetch_list_queries_all INTO l_queries_rec;

Line 4698: AMS_Utility_PVT.debug_message('copy_queries...l_list_query_id '||l_list_query_id );

4694: p_list_query_rec => l_list_query_rec ,
4695: x_list_query_id => l_list_query_id
4696: );
4697: IF (AMS_DEBUG_HIGH_ON) THEN
4698: AMS_Utility_PVT.debug_message('copy_queries...l_list_query_id '||l_list_query_id );
4699: END IF;
4700:
4701: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4702: RAISE FND_API.G_EXC_ERROR;

Line 4755: AMS_Utility_PVT.debug_message('copy_query_list_params '||p_old_query_id||':::'||p_new_query_id);

4751: l_msg_count number;
4752: l_msg_data VARCHAR2(2000);
4753: BEGIN
4754: IF (AMS_DEBUG_HIGH_ON) THEN
4755: AMS_Utility_PVT.debug_message('copy_query_list_params '||p_old_query_id||':::'||p_new_query_id);
4756: END IF;
4757:
4758: FOR l_query_param_rec IN fetch_list_query_params(p_old_query_id)
4759: LOOP

Line 4765: AMS_Utility_PVT.debug_message('copy_query_list_params in loop' || l_list_query_param_id);

4761: FETCH c_qlp INTO l_list_query_param_id;
4762: CLOSE c_qlp;
4763:
4764: IF (AMS_DEBUG_HIGH_ON) THEN
4765: AMS_Utility_PVT.debug_message('copy_query_list_params in loop' || l_list_query_param_id);
4766: END IF;
4767:
4768: AMS_LIST_QUERIES_PARAM_PKG.INSERT_ROW (
4769: X_LIST_QUERY_PARAM_ID => l_list_query_param_id,

Line 4787: AMS_Utility_PVT.debug_message('copy_query_list_params in loop' || l_list_query_param_id);

4783: X_LAST_UPDATE_LOGIN =>FND_GLOBAL.CONC_LOGIN_ID
4784: );
4785:
4786: IF (AMS_DEBUG_HIGH_ON) THEN
4787: AMS_Utility_PVT.debug_message('copy_query_list_params in loop' || l_list_query_param_id);
4788: END IF;
4789:
4790: END LOOP;
4791: END copy_query_list_params;

Line 4824: AMS_Utility_PVT.debug_message('copy_template_instance '||p_old_header_id||':::'||p_new_header_id);

4820:
4821: BEGIN
4822:
4823: IF (AMS_DEBUG_HIGH_ON) THEN
4824: AMS_Utility_PVT.debug_message('copy_template_instance '||p_old_header_id||':::'||p_new_header_id);
4825: END IF;
4826:
4827: FOR l_templ_inst_rec IN fetch_templ_instance(p_old_header_id)
4828: LOOP

Line 4835: AMS_Utility_PVT.debug_message('copy_template_instance in loop '||l_templ_inst_id);

4831: FETCH c_templInst INTO l_templ_inst_id;
4832: CLOSE c_templInst;
4833:
4834: IF (AMS_DEBUG_HIGH_ON) THEN
4835: AMS_Utility_PVT.debug_message('copy_template_instance in loop '||l_templ_inst_id);
4836: END IF;
4837:
4838: x_old_templ_inst_id := l_templ_inst_rec.template_instance_id;
4839: x_new_templ_inst_id := l_templ_inst_id;

Line 4858: AMS_Utility_PVT.debug_message('copy_template_instance in loop done');

4854: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4855: );
4856:
4857: IF (AMS_DEBUG_HIGH_ON) THEN
4858: AMS_Utility_PVT.debug_message('copy_template_instance in loop done');
4859: END IF;
4860:
4861: copy_conditions
4862: ( p_old_templ_inst_id => x_old_templ_inst_id,

Line 4907: AMS_Utility_PVT.debug_message('copy_conditions '||p_old_templ_inst_id ||'::'||p_new_templ_inst_id);

4903:
4904: BEGIN
4905:
4906: IF (AMS_DEBUG_HIGH_ON) THEN
4907: AMS_Utility_PVT.debug_message('copy_conditions '||p_old_templ_inst_id ||'::'||p_new_templ_inst_id);
4908: END IF;
4909:
4910:
4911: FOR l_cond_assoc_rec IN fetch_condition_assoc(p_old_templ_inst_id)

Line 4921: AMS_Utility_PVT.debug_message('copy_conditions found assoc'||l_old_assoc_id);

4917:
4918: l_old_assoc_id := l_cond_assoc_rec.assoc_id;
4919:
4920: IF (AMS_DEBUG_HIGH_ON) THEN
4921: AMS_Utility_PVT.debug_message('copy_conditions found assoc'||l_old_assoc_id);
4922: END IF;
4923:
4924: ams_query_tmp_assoc_pkg.insert_row (
4925: X_ASSOC_ID => l_assoc_id,

Line 4941: AMS_Utility_PVT.debug_message('copy_conditions new assoc'||l_assoc_id);

4937: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4938: );
4939:
4940: IF (AMS_DEBUG_HIGH_ON) THEN
4941: AMS_Utility_PVT.debug_message('copy_conditions new assoc'||l_assoc_id);
4942: END IF;
4943:
4944: FOR l_cond_value_rec IN fetch_condition_value(l_old_assoc_id)
4945: LOOP

Line 4948: AMS_Utility_PVT.debug_message('copy_conditions found cond values for '||l_old_assoc_id);

4944: FOR l_cond_value_rec IN fetch_condition_value(l_old_assoc_id)
4945: LOOP
4946:
4947: IF (AMS_DEBUG_HIGH_ON) THEN
4948: AMS_Utility_PVT.debug_message('copy_conditions found cond values for '||l_old_assoc_id);
4949: END IF;
4950:
4951: OPEN c_cond_value;
4952: FETCH c_cond_value INTO l_cond_value_id;

Line 4971: AMS_Utility_PVT.debug_message('copy_conditions new cond values '||l_assoc_id||'::::'||l_cond_value_id);

4967: X_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
4968: );
4969:
4970: IF (AMS_DEBUG_HIGH_ON) THEN
4971: AMS_Utility_PVT.debug_message('copy_conditions new cond values '||l_assoc_id||'::::'||l_cond_value_id);
4972: END IF;
4973: END LOOP;
4974: END LOOP;
4975:

Line 4977: AMS_Utility_PVT.debug_message('copy_conditions end ');

4973: END LOOP;
4974: END LOOP;
4975:
4976: IF (AMS_DEBUG_HIGH_ON) THEN
4977: AMS_Utility_PVT.debug_message('copy_conditions end ');
4978: END IF;
4979:
4980: END copy_conditions;
4981:

Line 5033: AMS_Utility_PVT.debug_message('FUNCTION: INVOKE_TARGET_GROUP_LOCK start');

5029: l_related_event_obj_type := p_event.getValueForParameter('RELATED_EVENT_OBJECT_TYPE');
5030: l_related_event_id := p_event.getValueForParameter('RELATED_EVENT_OBJECT_ID');
5031:
5032: IF (AMS_DEBUG_HIGH_ON) THEN
5033: AMS_Utility_PVT.debug_message('****FUNCTION: INVOKE_TARGET_GROUP_LOCK start****');
5034: END IF;
5035: IF ( l_obj_type = 'CSCH' AND l_new_status_code = 'ACTIVE')
5036: THEN
5037:

Line 5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');

5038: IF ( ( l_related_event_obj_type IS NOT NULL ) AND ( l_related_event_id IS NOT NULL ) )
5039: THEN
5040:
5041: IF (AMS_DEBUG_HIGH_ON) THEN
5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');
5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

Line 5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );

5039: THEN
5040:
5041: IF (AMS_DEBUG_HIGH_ON) THEN
5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');
5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

Line 5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );

5040:
5041: IF (AMS_DEBUG_HIGH_ON) THEN
5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');
5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5048: END IF;

Line 5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);

5041: IF (AMS_DEBUG_HIGH_ON) THEN
5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');
5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5048: END IF;
5049: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_related_event_obj_type ,

Line 5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

5042: AMS_Utility_PVT.debug_message('For OneOffEvent Active Schedules');
5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5048: END IF;
5049: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_related_event_obj_type ,
5050: P_OBJ_ID => l_related_event_id,

Line 5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

5043: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_related_event_obj_type );
5044: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_related_event_id );
5045: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5046: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5047: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5048: END IF;
5049: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_related_event_obj_type ,
5050: P_OBJ_ID => l_related_event_id,
5051: X_MSG_COUNT => l_msg_count,

Line 5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');

5056:
5057: ELSE
5058:
5059: IF (AMS_DEBUG_HIGH_ON) THEN
5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');
5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

Line 5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );

5057: ELSE
5058:
5059: IF (AMS_DEBUG_HIGH_ON) THEN
5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');
5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

Line 5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );

5058:
5059: IF (AMS_DEBUG_HIGH_ON) THEN
5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');
5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5066: END IF;

Line 5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);

5059: IF (AMS_DEBUG_HIGH_ON) THEN
5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');
5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5066: END IF;
5067: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,

Line 5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

5060: AMS_Utility_PVT.debug_message('For Campaign Active Schedules');
5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5066: END IF;
5067: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,
5068: P_OBJ_ID => l_obj_id,

Line 5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

5061: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5062: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5063: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5064: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5065: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5066: END IF;
5067: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,
5068: P_OBJ_ID => l_obj_id,
5069: X_MSG_COUNT => l_msg_count,

Line 5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');

5076: ELSIF (((l_obj_type = 'EONE') OR (l_obj_type = 'EVEO') ) AND (l_new_status_code = 'ACTIVE'))
5077: THEN
5078:
5079: IF (AMS_DEBUG_HIGH_ON) THEN
5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');
5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

Line 5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );

5077: THEN
5078:
5079: IF (AMS_DEBUG_HIGH_ON) THEN
5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');
5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

Line 5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );

5078:
5079: IF (AMS_DEBUG_HIGH_ON) THEN
5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');
5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5086: END IF;

Line 5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);

5079: IF (AMS_DEBUG_HIGH_ON) THEN
5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');
5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5086: END IF;
5087: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,

Line 5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);

5080: AMS_Utility_PVT.debug_message('For EONE/EVEO Active Schedules');
5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5086: END IF;
5087: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,
5088: P_OBJ_ID => l_obj_id,

Line 5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);

5081: AMS_Utility_PVT.debug_message('P_OBJECT_TYPE ' || l_obj_type );
5082: AMS_Utility_PVT.debug_message('P_OBJ_ID ' || l_obj_id );
5083: AMS_Utility_PVT.debug_message('X_MSG_COUNT' || l_msg_count);
5084: AMS_Utility_PVT.debug_message('X_MSG_DATA' || l_msg_data);
5085: AMS_Utility_PVT.debug_message('X_RETURN_STATUS' || l_return_status);
5086: END IF;
5087: UPDATE_LIST_STATUS_TO_LOCKED(P_OBJECT_TYPE => l_obj_type ,
5088: P_OBJ_ID => l_obj_id,
5089: X_MSG_COUNT => l_msg_count,

Line 5155: AMS_Utility_PVT.debug_message('FUNCTION: UPDATE_LIST_STATUS_TO_LOCKED start');

5151: -- INITIALIZE RETURN STATUS TO SUCCESS
5152: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5153:
5154: IF (AMS_DEBUG_HIGH_ON) THEN
5155: AMS_Utility_PVT.debug_message('****FUNCTION: UPDATE_LIST_STATUS_TO_LOCKED start****');
5156:
5157: END IF;
5158:
5159: UPDATE AMS_LIST_HEADERS_ALL

Line 5170: AMS_Utility_PVT.debug_message('TARGET GROUP LOCKED while executing procedure UPDATE_LIST_STATUS_TO_LOCKED');

5166: AND LIST_TYPE = 'TARGET';
5167:
5168:
5169: IF (AMS_DEBUG_HIGH_ON) THEN
5170: AMS_Utility_PVT.debug_message('TARGET GROUP LOCKED while executing procedure UPDATE_LIST_STATUS_TO_LOCKED');
5171: END IF;
5172:
5173:
5174: EXCEPTION

Line 5179: AMS_Utility_PVT.debug_message('Exception while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);

5175:
5176:
5177: WHEN FND_API.G_EXC_ERROR THEN
5178: IF (AMS_DEBUG_HIGH_ON) THEN
5179: AMS_Utility_PVT.debug_message('Exception while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);
5180: END IF;
5181:
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: IF (AMS_DEBUG_HIGH_ON) THEN

Line 5184: AMS_Utility_PVT.debug_message('UNEXPECTED_ERROR while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);

5180: END IF;
5181:
5182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5183: IF (AMS_DEBUG_HIGH_ON) THEN
5184: AMS_Utility_PVT.debug_message('UNEXPECTED_ERROR while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);
5185: END IF;
5186:
5187:
5188: WHEN OTHERS THEN

Line 5190: AMS_Utility_PVT.debug_message('Other Error while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);

5186:
5187:
5188: WHEN OTHERS THEN
5189: IF (AMS_DEBUG_HIGH_ON) THEN
5190: AMS_Utility_PVT.debug_message('Other Error while executing procedure UPDATE_LIST_STATUS_TO_LOCKED'||' '||sqlerrm||' '||sqlcode);
5191: END IF;
5192:
5193: END UPDATE_LIST_STATUS_TO_LOCKED;
5194: