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

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

102:
103: -- Debug Message
104: IF (AMS_DEBUG_HIGH_ON) THEN
105:
106: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
107: END IF;
108:
109:
110: -- Initialize API return status to SUCCESS

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

133: -- =========================================================================
134:
135: IF FND_GLOBAL.User_Id IS NULL
136: THEN
137: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:
141: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 146: AMS_UTILITY_PVT.debug_message('Private API: Validate_Prod_Template');

142: THEN
143: -- Debug message
144: IF (AMS_DEBUG_HIGH_ON) THEN
145:
146: AMS_UTILITY_PVT.debug_message('Private API: Validate_Prod_Template');
147: END IF;
148:
149: -- Invoke validation procedures
150: Validate_prod_template(

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

338:
339: -- Debug Message
340: IF (AMS_DEBUG_HIGH_ON) THEN
341:
342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get

Line 352: WHEN AMS_Utility_PVT.resource_locked THEN

348: p_data => x_msg_data
349: );
350: EXCEPTION
351:
352: WHEN AMS_Utility_PVT.resource_locked THEN
353: x_return_status := FND_API.g_ret_sts_error;
354: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
355:
356: WHEN FND_API.G_EXC_ERROR THEN

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

350: EXCEPTION
351:
352: WHEN AMS_Utility_PVT.resource_locked THEN
353: x_return_status := FND_API.g_ret_sts_error;
354: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO CREATE_Prod_Template_PVT;
358: x_return_status := FND_API.G_RET_STS_ERROR;

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

440:
441: -- Debug Message
442: IF (AMS_DEBUG_HIGH_ON) THEN
443:
444: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
445: END IF;
446:
447:
448: -- Initialize API return status to SUCCESS

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

450:
451: -- Debug Message
452: IF (AMS_DEBUG_HIGH_ON) THEN
453:
454: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
455: END IF;
456:
457: /*
458: OPEN c_get_Prod_Template( l_tar_prod_template_rec.template_id);

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

459:
460: FETCH c_get_Prod_Template INTO l_ref_prod_template_rec ;
461:
462: If ( c_get_Prod_Template%NOTFOUND) THEN
463: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
464: p_token_name => 'INFO',
465: p_token_value => 'Prod_Template') ;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;

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

467: END IF;
468: -- Debug Message
469: IF (AMS_DEBUG_HIGH_ON) THEN
470:
471: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
472: END IF;
473: CLOSE c_get_Prod_Template;
474: */
475:

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

475:
476:
477: If (l_tar_prod_template_rec.object_version_number is NULL or
478: l_tar_prod_template_rec.object_version_number = FND_API.G_MISS_NUM ) Then
479: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
480: p_token_name => 'COLUMN',
481: p_token_value => 'Last_Update_Date') ;
482: raise FND_API.G_EXC_ERROR;
483: End if;

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

482: raise FND_API.G_EXC_ERROR;
483: End if;
484: -- Check Whether record has been changed by someone else
485: If (l_tar_prod_template_rec.object_version_number <> l_ref_prod_template_rec.object_version_number) Then
486: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
487: p_token_name => 'INFO',
488: p_token_value => 'Prod_Template') ;
489: raise FND_API.G_EXC_ERROR;
490: End if;

Line 496: AMS_UTILITY_PVT.debug_message('Private API: Validate_Prod_Template');

492: THEN
493: -- Debug message
494: IF (AMS_DEBUG_HIGH_ON) THEN
495:
496: AMS_UTILITY_PVT.debug_message('Private API: Validate_Prod_Template');
497: END IF;
498:
499: -- Invoke validation procedures
500: Validate_prod_template(

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

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

Line 565: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

563: EXCEPTION
564:
565: WHEN AMS_Utility_PVT.resource_locked THEN
566: x_return_status := FND_API.g_ret_sts_error;
567: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
568:
569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO UPDATE_Prod_Template_PVT;
571: x_return_status := FND_API.G_RET_STS_ERROR;

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

640:
641: -- Debug Message
642: IF (AMS_DEBUG_HIGH_ON) THEN
643:
644: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
645: END IF;
646:
647:
648: -- Initialize API return status to SUCCESS

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

652: -- Api body
653: --
654: -- Debug Message
655: IF (AMS_DEBUG_HIGH_ON) THEN
656: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
657: END IF;
658: /*
659: IF p_template_id = 1000
660: OR p_template_id = 1001

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

714:
715: -- Debug Message
716: IF (AMS_DEBUG_HIGH_ON) THEN
717:
718: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
719: END IF;
720:
721: -- Standard call to get message count and if count is 1, get message info.
722: FND_MSG_PUB.Count_And_Get

Line 728: WHEN AMS_Utility_PVT.resource_locked THEN

724: p_data => x_msg_data
725: );
726: EXCEPTION
727:
728: WHEN AMS_Utility_PVT.resource_locked THEN
729: x_return_status := FND_API.g_ret_sts_error;
730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
731:
732: WHEN FND_API.G_EXC_ERROR THEN

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

726: EXCEPTION
727:
728: WHEN AMS_Utility_PVT.resource_locked THEN
729: x_return_status := FND_API.g_ret_sts_error;
730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO DELETE_Prod_Template_PVT;
734: x_return_status := FND_API.G_RET_STS_ERROR;

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

796:
797: -- Debug Message
798: IF (AMS_DEBUG_HIGH_ON) THEN
799:
800: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE.
804: IF FND_API.to_Boolean( p_init_msg_list )

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

825: IF (AMS_DEBUG_HIGH_ON) THEN
826:
827:
828:
829: AMS_Utility_PVT.debug_message(l_full_name||': start');
830:
831: END IF;
832: OPEN c_Prod_Template;
833:

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

850: p_count => x_msg_count,
851: p_data => x_msg_data);
852: IF (AMS_DEBUG_HIGH_ON) THEN
853:
854: AMS_Utility_PVT.debug_message(l_full_name ||': end');
855: END IF;
856: EXCEPTION
857:
858: WHEN AMS_Utility_PVT.resource_locked THEN

Line 858: WHEN AMS_Utility_PVT.resource_locked THEN

854: AMS_Utility_PVT.debug_message(l_full_name ||': end');
855: END IF;
856: EXCEPTION
857:
858: WHEN AMS_Utility_PVT.resource_locked THEN
859: x_return_status := FND_API.g_ret_sts_error;
860: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
861:
862: WHEN FND_API.G_EXC_ERROR THEN

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

856: EXCEPTION
857:
858: WHEN AMS_Utility_PVT.resource_locked THEN
859: x_return_status := FND_API.g_ret_sts_error;
860: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
861:
862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO LOCK_Prod_Template_PVT;
864: x_return_status := FND_API.G_RET_STS_ERROR;

Line 926: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

922:
923: BEGIN
924: x_return_status := FND_API.g_ret_sts_success;
925: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
926: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
927: 'AMS_PROD_TEMPLATES_B',
928: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||''''
929: );
930: ELSE

Line 931: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

927: 'AMS_PROD_TEMPLATES_B',
928: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||''''
929: );
930: ELSE
931: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
932: 'AMS_PROD_TEMPLATES_B',
933: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||
934: ''' AND TEMPLATE_ID <> ' || p_prod_template_rec.TEMPLATE_ID
935: );

Line 939: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPLATE_ID_DUPLICATE');

935: );
936: END IF;
937:
938: IF l_valid_flag = FND_API.g_false THEN
939: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPLATE_ID_DUPLICATE');
940: x_return_status := FND_API.g_ret_sts_error;
941: RETURN;
942: END IF;
943:

Line 965: AMS_UTILITY_PVT.debug_message('l_valid_flag:'||l_valid_flag||' vd mode:'|| p_validation_mode||' g_create:'||JTF_PLSQL_API.g_create);

961: IF (AMS_DEBUG_HIGH_ON) THEN
962:
963:
964:
965: AMS_UTILITY_PVT.debug_message('l_valid_flag:'||l_valid_flag||' vd mode:'|| p_validation_mode||' g_create:'||JTF_PLSQL_API.g_create);
966:
967: END IF;
968:
969: IF l_valid_flag = 'Y'

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

1004:
1005: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1006:
1007: IF p_prod_template_rec.template_id IS NULL THEN
1008: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_prod_template_NO_template_id');
1009: x_return_status := FND_API.g_ret_sts_error;
1010: RETURN;
1011: END IF;
1012:

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

1224:
1225: -- Debug Message
1226: IF (AMS_DEBUG_HIGH_ON) THEN
1227:
1228: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1229: END IF;
1230:
1231:
1232: -- Initialize API return status to SUCCESS

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

1235:
1236: -- Debug Message
1237: IF (AMS_DEBUG_HIGH_ON) THEN
1238:
1239: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get

Line 1249: WHEN AMS_Utility_PVT.resource_locked THEN

1245: p_data => x_msg_data
1246: );
1247: EXCEPTION
1248:
1249: WHEN AMS_Utility_PVT.resource_locked THEN
1250: x_return_status := FND_API.g_ret_sts_error;
1251: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1252:
1253: WHEN FND_API.G_EXC_ERROR THEN

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

1247: EXCEPTION
1248:
1249: WHEN AMS_Utility_PVT.resource_locked THEN
1250: x_return_status := FND_API.g_ret_sts_error;
1251: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1252:
1253: WHEN FND_API.G_EXC_ERROR THEN
1254: ROLLBACK TO VALIDATE_Prod_Template_;
1255: x_return_status := FND_API.G_RET_STS_ERROR;

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

1312:
1313: -- Debug Message
1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1317: END IF;
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,