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_RES_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_res');

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

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

173:
174: -- Debug Message
175: IF (AMS_DEBUG_HIGH_ON) THEN
176:
177: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
178: END IF;
179:
180: -- Standard call to get message count and if count is 1, get message info.
181: FND_MSG_PUB.Count_And_Get

Line 187: WHEN AMS_Utility_PVT.resource_locked THEN

183: p_data => x_msg_data
184: );
185: EXCEPTION
186:
187: WHEN AMS_Utility_PVT.resource_locked THEN
188: x_return_status := FND_API.g_ret_sts_error;
189: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
190:
191: WHEN FND_API.G_EXC_ERROR THEN

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

185: EXCEPTION
186:
187: WHEN AMS_Utility_PVT.resource_locked THEN
188: x_return_status := FND_API.g_ret_sts_error;
189: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
190:
191: WHEN FND_API.G_EXC_ERROR THEN
192: ROLLBACK TO CREATE_template_res_PVT;
193: x_return_status := FND_API.G_RET_STS_ERROR;

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

275:
276: -- Debug Message
277: IF (AMS_DEBUG_HIGH_ON) THEN
278:
279: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
280: END IF;
281:
282:
283: -- Initialize API return status to SUCCESS

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

285:
286: -- Debug Message
287: IF (AMS_DEBUG_HIGH_ON) THEN
288:
289: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
290: END IF;
291:
292: /*
293: OPEN c_get_template_res( l_tar_template_res_rec.templ_responsibility_id);

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

294:
295: FETCH c_get_template_res INTO l_ref_template_res_rec ;
296:
297: If ( c_get_template_res%NOTFOUND) THEN
298: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
299: p_token_name => 'INFO',
300: p_token_value => 'template_res') ;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;

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

302: END IF;
303: -- Debug Message
304: IF (AMS_DEBUG_HIGH_ON) THEN
305:
306: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
307: END IF;
308: CLOSE c_get_template_res;
309: */
310:

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

310:
311:
312: If (l_tar_template_res_rec.object_version_number is NULL or
313: l_tar_template_res_rec.object_version_number = FND_API.G_MISS_NUM ) Then
314: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
315: p_token_name => 'COLUMN',
316: p_token_value => 'Last_Update_Date') ;
317: raise FND_API.G_EXC_ERROR;
318: End if;

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

317: raise FND_API.G_EXC_ERROR;
318: End if;
319: -- Check Whether record has been changed by someone else
320: If (l_tar_template_res_rec.object_version_number <> l_ref_template_res_rec.object_version_number) Then
321: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
322: p_token_name => 'INFO',
323: p_token_value => 'template_res') ;
324: raise FND_API.G_EXC_ERROR;
325: End if;

Line 331: AMS_UTILITY_PVT.debug_message('Private API: Validate_template_res');

327: THEN
328: -- Debug message
329: IF (AMS_DEBUG_HIGH_ON) THEN
330:
331: AMS_UTILITY_PVT.debug_message('Private API: Validate_template_res');
332: END IF;
333:
334: -- Invoke validation procedures
335: Validate_template_res(

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

375:
376: -- Debug Message
377: IF (AMS_DEBUG_HIGH_ON) THEN
378:
379: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
380: END IF;
381:
382: -- Standard call to get message count and if count is 1, get message info.
383: FND_MSG_PUB.Count_And_Get

Line 389: WHEN AMS_Utility_PVT.resource_locked THEN

385: p_data => x_msg_data
386: );
387: EXCEPTION
388:
389: WHEN AMS_Utility_PVT.resource_locked THEN
390: x_return_status := FND_API.g_ret_sts_error;
391: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
392:
393: WHEN FND_API.G_EXC_ERROR THEN

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

387: EXCEPTION
388:
389: WHEN AMS_Utility_PVT.resource_locked THEN
390: x_return_status := FND_API.g_ret_sts_error;
391: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
392:
393: WHEN FND_API.G_EXC_ERROR THEN
394: ROLLBACK TO UPDATE_template_res_PVT;
395: x_return_status := FND_API.G_RET_STS_ERROR;

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

464:
465: -- Debug Message
466: IF (AMS_DEBUG_HIGH_ON) THEN
467:
468: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
469: END IF;
470:
471:
472: -- Initialize API return status to SUCCESS

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

488:
489: -- Debug Message
490: IF (AMS_DEBUG_HIGH_ON) THEN
491:
492: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
493: END IF;
494:
495: -- Standard call to get message count and if count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get

Line 502: WHEN AMS_Utility_PVT.resource_locked THEN

498: p_data => x_msg_data
499: );
500: EXCEPTION
501:
502: WHEN AMS_Utility_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN

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

500: EXCEPTION
501:
502: WHEN AMS_Utility_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO DELETE_template_res_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;

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

570:
571: -- Debug Message
572: IF (AMS_DEBUG_HIGH_ON) THEN
573:
574: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
575: END IF;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )

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

599: IF (AMS_DEBUG_HIGH_ON) THEN
600:
601:
602:
603: AMS_Utility_PVT.debug_message(l_full_name||': start');
604:
605: END IF;
606: OPEN c_template_res;
607:

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

624: p_count => x_msg_count,
625: p_data => x_msg_data);
626: IF (AMS_DEBUG_HIGH_ON) THEN
627:
628: AMS_Utility_PVT.debug_message(l_full_name ||': end');
629: END IF;
630: EXCEPTION
631:
632: WHEN AMS_Utility_PVT.resource_locked THEN

Line 632: WHEN AMS_Utility_PVT.resource_locked THEN

628: AMS_Utility_PVT.debug_message(l_full_name ||': end');
629: END IF;
630: EXCEPTION
631:
632: WHEN AMS_Utility_PVT.resource_locked THEN
633: x_return_status := FND_API.g_ret_sts_error;
634: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
635:
636: WHEN FND_API.G_EXC_ERROR THEN

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

630: EXCEPTION
631:
632: WHEN AMS_Utility_PVT.resource_locked THEN
633: x_return_status := FND_API.g_ret_sts_error;
634: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
635:
636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO LOCK_template_res_PVT;
638: x_return_status := FND_API.G_RET_STS_ERROR;

Line 682: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

678:
679: BEGIN
680: x_return_status := FND_API.g_ret_sts_success;
681: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
682: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
683: 'AMS_TEMPL_RESPONSIBILITY',
684: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||''''
685: );
686: ELSE

Line 687: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

683: 'AMS_TEMPL_RESPONSIBILITY',
684: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||''''
685: );
686: ELSE
687: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
688: 'AMS_TEMPL_RESPONSIBILITY',
689: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||
690: ''' AND TEMPL_RESPONSIBILITY_ID <> ' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID
691: );

Line 695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPL_RESPONSIBILITY_ID_DUPLICATE');

691: );
692: END IF;
693:
694: IF l_valid_flag = FND_API.g_false THEN
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPL_RESPONSIBILITY_ID_DUPLICATE');
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698: END IF;
699:

Line 733: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_templ_responsibility_id');

729: ELSE
730:
731:
732: IF p_template_res_rec.templ_responsibility_id IS NULL THEN
733: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_templ_responsibility_id');
734: x_return_status := FND_API.g_ret_sts_error;
735: RETURN;
736: END IF;
737:

Line 740: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_template_id');

736: END IF;
737:
738:
739: IF p_template_res_rec.template_id IS NULL THEN
740: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_template_id');
741: x_return_status := FND_API.g_ret_sts_error;
742: RETURN;
743: END IF;
744:

Line 747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_responsibility_id');

743: END IF;
744:
745:
746: IF p_template_res_rec.responsibility_id IS NULL THEN
747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_template_res_NO_responsibility_id');
748: x_return_status := FND_API.g_ret_sts_error;
749: RETURN;
750: END IF;
751:

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

969:
970: -- Debug Message
971: IF (AMS_DEBUG_HIGH_ON) THEN
972:
973: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
974: END IF;
975:
976:
977: -- Initialize API return status to SUCCESS

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

980:
981: -- Debug Message
982: IF (AMS_DEBUG_HIGH_ON) THEN
983:
984: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
985: END IF;
986:
987: -- Standard call to get message count and if count is 1, get message info.
988: FND_MSG_PUB.Count_And_Get

Line 994: WHEN AMS_Utility_PVT.resource_locked THEN

990: p_data => x_msg_data
991: );
992: EXCEPTION
993:
994: WHEN AMS_Utility_PVT.resource_locked THEN
995: x_return_status := FND_API.g_ret_sts_error;
996: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
997:
998: WHEN FND_API.G_EXC_ERROR THEN

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

992: EXCEPTION
993:
994: WHEN AMS_Utility_PVT.resource_locked THEN
995: x_return_status := FND_API.g_ret_sts_error;
996: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO VALIDATE_template_res_;
1000: x_return_status := FND_API.G_RET_STS_ERROR;

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

1057:
1058: -- Debug Message
1059: IF (AMS_DEBUG_HIGH_ON) THEN
1060:
1061: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1062: END IF;
1063: -- Standard call to get message count and if count is 1, get message info.
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,