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

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

76:
77: -- Debug Message
78: IF (AMS_DEBUG_HIGH_ON) THEN
79:
80: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
81: END IF;
82:
83:
84: -- Initialize API return status to SUCCESS

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

105: -- =========================================================================
106:
107: IF FND_GLOBAL.User_Id IS NULL
108: THEN
109: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 118: AMS_UTILITY_PVT.debug_message('Private API: Validate_Template_Attr');

114: THEN
115: -- Debug message
116: IF (AMS_DEBUG_HIGH_ON) THEN
117:
118: AMS_UTILITY_PVT.debug_message('Private API: Validate_Template_Attr');
119: END IF;
120:
121: -- Invoke validation procedures
122: Validate_template_attr(

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

182:
183: -- Debug Message
184: IF (AMS_DEBUG_HIGH_ON) THEN
185:
186: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
187: END IF;
188:
189: -- Standard call to get message count and if count is 1, get message info.
190: FND_MSG_PUB.Count_And_Get

Line 196: WHEN AMS_Utility_PVT.resource_locked THEN

192: p_data => x_msg_data
193: );
194: EXCEPTION
195:
196: WHEN AMS_Utility_PVT.resource_locked THEN
197: x_return_status := FND_API.g_ret_sts_error;
198: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
199:
200: WHEN FND_API.G_EXC_ERROR THEN

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

194: EXCEPTION
195:
196: WHEN AMS_Utility_PVT.resource_locked THEN
197: x_return_status := FND_API.g_ret_sts_error;
198: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
199:
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO CREATE_Template_Attr_PVT;
202: x_return_status := FND_API.G_RET_STS_ERROR;

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

286:
287: -- Debug Message
288: IF (AMS_DEBUG_HIGH_ON) THEN
289:
290: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
291: END IF;
292:
293:
294: -- Initialize API return status to SUCCESS

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

296:
297: -- Debug Message
298: IF (AMS_DEBUG_HIGH_ON) THEN
299:
300: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
301: END IF;
302:
303: /*
304: OPEN c_get_Template_Attr( l_tar_template_attr_rec.template_attribute_id);

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

305:
306: FETCH c_get_Template_Attr INTO l_ref_template_attr_rec ;
307:
308: If ( c_get_Template_Attr%NOTFOUND) THEN
309: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
310: p_token_name => 'INFO',
311: p_token_value => 'Template_Attr') ;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;

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

313: END IF;
314: -- Debug Message
315: IF (AMS_DEBUG_HIGH_ON) THEN
316:
317: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
318: END IF;
319: CLOSE c_get_Template_Attr;
320: */
321:

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

321:
322:
323: If (l_tar_template_attr_rec.object_version_number is NULL or
324: l_tar_template_attr_rec.object_version_number = FND_API.G_MISS_NUM ) Then
325: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
326: p_token_name => 'COLUMN',
327: p_token_value => 'Last_Update_Date') ;
328: raise FND_API.G_EXC_ERROR;
329: End if;

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

328: raise FND_API.G_EXC_ERROR;
329: End if;
330: -- Check Whether record has been changed by someone else
331: If (l_tar_template_attr_rec.object_version_number <> l_ref_template_attr_rec.object_version_number) Then
332: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
333: p_token_name => 'INFO',
334: p_token_value => 'Template_Attr') ;
335: raise FND_API.G_EXC_ERROR;
336: End if;

Line 342: AMS_UTILITY_PVT.debug_message('Private API: Validate_Template_Attr');

338: THEN
339: -- Debug message
340: IF (AMS_DEBUG_HIGH_ON) THEN
341:
342: AMS_UTILITY_PVT.debug_message('Private API: Validate_Template_Attr');
343: END IF;
344:
345: -- Invoke validation procedures
346: Validate_template_attr(

Line 362: AMS_UTILITY_PVT.debug_message(' IN UPDATE API VALUE FOR DeFAULT FLAG IS :'||l_template_attr_rec.default_flag);

358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: IF (AMS_DEBUG_HIGH_ON) THEN
362: AMS_UTILITY_PVT.debug_message(' IN UPDATE API VALUE FOR DeFAULT FLAG IS :'||l_template_attr_rec.default_flag);
363: END IF;
364:
365: /* If select all flag is "Y" then defaulting the default,editable flag to "Y" */
366: --IF l_template_attr_rec.parent_select_all ='Y'

Line 396: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.attribute_code:' ||l_template_attr_rec.attribute_code);

392:
393:
394: IF (AMS_DEBUG_HIGH_ON)
395: THEN
396: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.attribute_code:' ||l_template_attr_rec.attribute_code);
397: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);
398: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_attribute_code:' ||l_template_attr_rec.parent_attribute_code);
399: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.template_id:' ||l_template_attr_rec.template_id);
400: END IF;

Line 397: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);

393:
394: IF (AMS_DEBUG_HIGH_ON)
395: THEN
396: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.attribute_code:' ||l_template_attr_rec.attribute_code);
397: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);
398: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_attribute_code:' ||l_template_attr_rec.parent_attribute_code);
399: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.template_id:' ||l_template_attr_rec.template_id);
400: END IF;
401:

Line 398: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_attribute_code:' ||l_template_attr_rec.parent_attribute_code);

394: IF (AMS_DEBUG_HIGH_ON)
395: THEN
396: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.attribute_code:' ||l_template_attr_rec.attribute_code);
397: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);
398: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_attribute_code:' ||l_template_attr_rec.parent_attribute_code);
399: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.template_id:' ||l_template_attr_rec.template_id);
400: END IF;
401:
402: IF (l_template_attr_rec.attribute_code = 'AMS_PROD_INV_ITM'

Line 399: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.template_id:' ||l_template_attr_rec.template_id);

395: THEN
396: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.attribute_code:' ||l_template_attr_rec.attribute_code);
397: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_select_all:' ||l_template_attr_rec.parent_select_all);
398: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.parent_attribute_code:' ||l_template_attr_rec.parent_attribute_code);
399: AMS_UTILITY_PVT.debug_message(' l_template_attr_rec.template_id:' ||l_template_attr_rec.template_id);
400: END IF;
401:
402: IF (l_template_attr_rec.attribute_code = 'AMS_PROD_INV_ITM'
403: OR l_template_attr_rec.attribute_code = 'AMS_PROD_BOA'

Line 436: AMS_UTILITY_PVT.debug_message('AFTER UPDATe for l_template_attr_rec.parent_select_all :'||l_template_attr_rec.parent_select_all );

432: IF (AMS_DEBUG_HIGH_ON) THEN
433:
434:
435:
436: AMS_UTILITY_PVT.debug_message('AFTER UPDATe for l_template_attr_rec.parent_select_all :'||l_template_attr_rec.parent_select_all );
437:
438: END IF;
439: END IF;
440:

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

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

Line 467: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

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

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

542:
543: -- Debug Message
544: IF (AMS_DEBUG_HIGH_ON) THEN
545:
546: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
547: END IF;
548:
549:
550: -- Initialize API return status to SUCCESS

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

567:
568: -- Debug Message
569: IF (AMS_DEBUG_HIGH_ON) THEN
570:
571: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
572: END IF;
573:
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get

Line 581: WHEN AMS_Utility_PVT.resource_locked THEN

577: p_data => x_msg_data
578: );
579: EXCEPTION
580:
581: WHEN AMS_Utility_PVT.resource_locked THEN
582: x_return_status := FND_API.g_ret_sts_error;
583: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
584:
585: WHEN FND_API.G_EXC_ERROR THEN

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

579: EXCEPTION
580:
581: WHEN AMS_Utility_PVT.resource_locked THEN
582: x_return_status := FND_API.g_ret_sts_error;
583: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
584:
585: WHEN FND_API.G_EXC_ERROR THEN
586: ROLLBACK TO DELETE_Template_Attr_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;

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

649:
650: -- Debug Message
651: IF (AMS_DEBUG_HIGH_ON) THEN
652:
653: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
654: END IF;
655:
656: -- Initialize message list if p_init_msg_list is set to TRUE.
657: IF FND_API.to_Boolean( p_init_msg_list )

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

678: IF (AMS_DEBUG_HIGH_ON) THEN
679:
680:
681:
682: AMS_Utility_PVT.debug_message(l_full_name||': start');
683:
684: END IF;
685: OPEN c_Template_Attr;
686:

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

703: p_count => x_msg_count,
704: p_data => x_msg_data);
705: IF (AMS_DEBUG_HIGH_ON) THEN
706:
707: AMS_Utility_PVT.debug_message(l_full_name ||': end');
708: END IF;
709: EXCEPTION
710:
711: WHEN AMS_Utility_PVT.resource_locked THEN

Line 711: WHEN AMS_Utility_PVT.resource_locked THEN

707: AMS_Utility_PVT.debug_message(l_full_name ||': end');
708: END IF;
709: EXCEPTION
710:
711: WHEN AMS_Utility_PVT.resource_locked THEN
712: x_return_status := FND_API.g_ret_sts_error;
713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
714:
715: WHEN FND_API.G_EXC_ERROR THEN

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

709: EXCEPTION
710:
711: WHEN AMS_Utility_PVT.resource_locked THEN
712: x_return_status := FND_API.g_ret_sts_error;
713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
714:
715: WHEN FND_API.G_EXC_ERROR THEN
716: ROLLBACK TO LOCK_Template_Attr_PVT;
717: x_return_status := FND_API.G_RET_STS_ERROR;

Line 761: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

757:
758: BEGIN
759: x_return_status := FND_API.g_ret_sts_success;
760: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
761: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
762: 'AMS_PROD_TEMPLATE_ATTR',
763: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||''''
764: );
765: ELSE

Line 766: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

762: 'AMS_PROD_TEMPLATE_ATTR',
763: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||''''
764: );
765: ELSE
766: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
767: 'AMS_PROD_TEMPLATE_ATTR',
768: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||
769: ''' AND TEMPLATE_ATTRIBUTE_ID <> ' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID
770: );

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

770: );
771: END IF;
772:
773: IF l_valid_flag = FND_API.g_false THEN
774: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPLATE_ID_DUPLICATE');
775: x_return_status := FND_API.g_ret_sts_error;
776: RETURN;
777: END IF;
778:

Line 802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_attr_NO_template_attribute_id');

798:
799: ELSE
800:
801: IF p_template_attr_rec.template_attribute_id IS NULL THEN
802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_attr_NO_template_attribute_id');
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;
805: END IF;
806:

Line 809: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_attr_NO_template_id');

805: END IF;
806:
807:
808: IF p_template_attr_rec.template_id IS NULL THEN
809: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_attr_NO_template_id');
810: x_return_status := FND_API.g_ret_sts_error;
811: RETURN;
812: END IF;
813: /*

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

1023:
1024: -- Debug Message
1025: IF (AMS_DEBUG_HIGH_ON) THEN
1026:
1027: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1028: END IF;
1029:
1030: -- Standard Start of API savepoint
1031: SAVEPOINT VALIDATE_Template_Attr_;

Line 1086: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end and the return status is '||x_return_status);

1082:
1083: -- Debug Message
1084: IF (AMS_DEBUG_HIGH_ON) THEN
1085:
1086: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end and the return status is '||x_return_status);
1087: END IF;
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get

Line 1096: WHEN AMS_Utility_PVT.resource_locked THEN

1092: p_data => x_msg_data
1093: );
1094: EXCEPTION
1095:
1096: WHEN AMS_Utility_PVT.resource_locked THEN
1097: x_return_status := FND_API.g_ret_sts_error;
1098: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1099:
1100: WHEN FND_API.G_EXC_ERROR THEN

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

1094: EXCEPTION
1095:
1096: WHEN AMS_Utility_PVT.resource_locked THEN
1097: x_return_status := FND_API.g_ret_sts_error;
1098: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO VALIDATE_Template_Attr_;
1102: x_return_status := FND_API.G_RET_STS_ERROR;

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

1159:
1160: -- Debug Message
1161: IF (AMS_DEBUG_HIGH_ON) THEN
1162:
1163: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1164: END IF;
1165: -- Standard call to get message count and if count is 1, get message info.
1166: FND_MSG_PUB.Count_And_Get
1167: (p_count => x_msg_count,