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

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

108: END IF;
109: -- Debug Message
110: IF (AMS_DEBUG_HIGH_ON) THEN
111:
112: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
113: END IF;
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:

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

118: -- Validate Environment
119: -- =========================================================================
120: IF FND_GLOBAL.USER_ID IS NULL
121: THEN
122: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 131: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cal_Crt');

127: THEN
128: -- Debug message
129: IF (AMS_DEBUG_HIGH_ON) THEN
130:
131: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cal_Crt');
132: END IF;
133: -- Charu: Populate the default required items.
134: l_cal_crt_rec_rec.last_update_date := SYSDATE;
135: l_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;

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

169: END IF;
170: -- Debug Message
171: IF (AMS_DEBUG_HIGH_ON) THEN
172:
173: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
174: END IF;
175:
176: -- Invoke table handler(Ams_Cal_Crt_Pkg.Insert_Row)
177: Ams_Cal_Crt_Pkg.Insert_Row(

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

208: COMMIT WORK;
209: END IF;
210: -- Debug Message
211: IF (AMS_DEBUG_HIGH_ON) THEN
212: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
213: END IF;
214: -- Standard call to get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count,

Line 220: WHEN AMS_Utility_PVT.resource_locked THEN

216: (p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: EXCEPTION
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO CREATE_Cal_Crt_PVT;

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

218: );
219: EXCEPTION
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO CREATE_Cal_Crt_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message

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

331:
332: -- Debug Message
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
336: END IF;
337:
338: -- Charu added
339: l_tar_cal_crt_rec_rec.last_update_date := SYSDATE;

Line 345: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);

341: l_tar_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);
346: END IF;
347: IF (AMS_DEBUG_HIGH_ON) THEN
348: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_id: ' || l_tar_cal_crt_rec_rec.criteria_id);
349: END IF;

Line 348: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_id: ' || l_tar_cal_crt_rec_rec.criteria_id);

344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);
346: END IF;
347: IF (AMS_DEBUG_HIGH_ON) THEN
348: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_id: ' || l_tar_cal_crt_rec_rec.criteria_id);
349: END IF;
350: -- Debug Message
351: IF (AMS_DEBUG_HIGH_ON) THEN
352: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

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

348: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_id: ' || l_tar_cal_crt_rec_rec.criteria_id);
349: END IF;
350: -- Debug Message
351: IF (AMS_DEBUG_HIGH_ON) THEN
352: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
353: END IF;
354: IF ( (l_tar_cal_crt_rec_rec.criteria_deleted = 'Y') AND (l_tar_cal_crt_rec_rec.criteria_enabled = 'Y') ) THEN
355: x_return_status := FND_API.g_ret_sts_error;
356: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_ENABLED_DELETE');

Line 356: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_ENABLED_DELETE');

352: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
353: END IF;
354: IF ( (l_tar_cal_crt_rec_rec.criteria_deleted = 'Y') AND (l_tar_cal_crt_rec_rec.criteria_enabled = 'Y') ) THEN
355: x_return_status := FND_API.g_ret_sts_error;
356: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_ENABLED_DELETE');
357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
358: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_ENABLED_DELETE');
359: FND_MSG_PUB.add;
360: RAISE FND_API.G_EXC_ERROR;

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

362: ELSE
363: OPEN c_get_Cal_Crt( l_tar_cal_crt_rec_rec.criteria_id);
364: FETCH c_get_Cal_Crt INTO l_ref_cal_crt_rec_rec ;
365: If ( c_get_Cal_Crt%NOTFOUND) THEN
366: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
367: p_token_name => 'INFO',
368: p_token_value => 'Cal_Crt'
369: ) ;
370: RAISE FND_API.G_EXC_ERROR;

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

371: END IF;
372: -- Debug Message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:
375: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
376: END IF;
377: CLOSE c_get_Cal_Crt;
378:
379: If (l_tar_cal_crt_rec_rec.object_version_number is NULL or

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

377: CLOSE c_get_Cal_Crt;
378:
379: If (l_tar_cal_crt_rec_rec.object_version_number is NULL or
380: l_tar_cal_crt_rec_rec.object_version_number = FND_API.G_MISS_NUM ) Then
381: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
382: p_token_name => 'COLUMN',
383: p_token_value => 'Last_Update_Date') ;
384: raise FND_API.G_EXC_ERROR;
385: End if;

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

384: raise FND_API.G_EXC_ERROR;
385: End if;
386: -- Check Whether record has been changed by someone else
387: If (l_tar_cal_crt_rec_rec.object_version_number <> l_ref_cal_crt_rec_rec.object_version_number) Then
388: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
389: p_token_name => 'INFO',
390: p_token_value => 'Cal_Crt') ;
391: raise FND_API.G_EXC_ERROR;
392: End if;

Line 399: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cal_Crt');

395: THEN
396: -- Debug message
397: IF (AMS_DEBUG_HIGH_ON) THEN
398:
399: AMS_UTILITY_PVT.debug_message('Private API: Validate_Cal_Crt');
400: END IF;
401: -- Invoke validation procedures
402: Validate_cal_crt(
403: p_api_version_number => 1.0,

Line 419: AMS_UTILITY_PVT.debug_message('Calling Table Handler Update');

415: END IF;
416:
417: -- Debug Message
418: IF (AMS_DEBUG_HIGH_ON) THEN
419: AMS_UTILITY_PVT.debug_message('Calling Table Handler Update');
420: END IF;
421: -- Invoke table handler(Ams_Cal_Crt_Pkg.Update_Row)
422: Ams_Cal_Crt_Pkg.Update_Row(
423: p_criteria_id => l_tar_cal_crt_rec_rec.criteria_id,

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

448: END IF;
449:
450: -- Debug Message
451: IF (AMS_DEBUG_HIGH_ON) THEN
452: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
453: END IF;
454: -- Standard call to get message count and if count is 1, get message info.
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count,

Line 462: WHEN AMS_Utility_PVT.resource_locked THEN

458: );
459:
460: EXCEPTION
461:
462: WHEN AMS_Utility_PVT.resource_locked THEN
463: x_return_status := FND_API.g_ret_sts_error;
464: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
465:
466: WHEN FND_API.G_EXC_ERROR THEN

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

460: EXCEPTION
461:
462: WHEN AMS_Utility_PVT.resource_locked THEN
463: x_return_status := FND_API.g_ret_sts_error;
464: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO UPDATE_Cal_Crt_PVT;
468: x_return_status := FND_API.G_RET_STS_ERROR;

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

564: END IF;
565: -- Debug Message
566: IF (AMS_DEBUG_HIGH_ON) THEN
567:
568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
569: END IF;
570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:

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

574: -- Api body
575: --
576: -- Debug Message
577: IF (AMS_DEBUG_HIGH_ON) THEN
578: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
579: END IF;
580: -- Invoke table handler(Ams_Cal_Crt_Pkg.Delete_Row)
581: Ams_Cal_Crt_Pkg.Delete_Row(
582: p_criteria_id => p_criteria_id,

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

591: END IF;
592: -- Debug Message
593: IF (AMS_DEBUG_HIGH_ON) THEN
594:
595: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
596: END IF;
597:
598: -- Standard call to get message count and if count is 1, get message info.
599: FND_MSG_PUB.Count_And_Get

Line 604: WHEN AMS_Utility_PVT.resource_locked THEN

600: (p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603: EXCEPTION
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO DELETE_Cal_Crt_PVT;

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

602: );
603: EXCEPTION
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO DELETE_Cal_Crt_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: -- Standard call to get message count and if count=1, get the message

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

696:
697: -- Debug Message
698: IF (AMS_DEBUG_HIGH_ON) THEN
699:
700: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )

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

727: p_count => x_msg_count,
728: p_data => x_msg_data);
729: IF (AMS_DEBUG_HIGH_ON) THEN
730:
731: AMS_Utility_PVT.debug_message(l_full_name ||': end');
732: END IF;
733: EXCEPTION
734: WHEN AMS_Utility_PVT.resource_locked THEN
735: x_return_status := FND_API.g_ret_sts_error;

Line 734: WHEN AMS_Utility_PVT.resource_locked THEN

730:
731: AMS_Utility_PVT.debug_message(l_full_name ||': end');
732: END IF;
733: EXCEPTION
734: WHEN AMS_Utility_PVT.resource_locked THEN
735: x_return_status := FND_API.g_ret_sts_error;
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN

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

732: END IF;
733: EXCEPTION
734: WHEN AMS_Utility_PVT.resource_locked THEN
735: x_return_status := FND_API.g_ret_sts_error;
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO LOCK_Cal_Crt_PVT;
740: x_return_status := FND_API.G_RET_STS_ERROR;

Line 818: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_DUPLICATE');

814: IF c_criteria%NOTFOUND THEN
815: x_return_status := FND_API.g_ret_sts_success;
816: ELSE
817: x_return_status := FND_API.g_ret_sts_error;
818: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_DUPLICATE');
819: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
820: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_DUPLICATE');
821: FND_MSG_PUB.add;
822: RAISE FND_API.G_EXC_ERROR;

Line 840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

836: x_return_status := FND_API.g_ret_sts_success;
837: IF p_validation_mode = JTF_PLSQL_API.g_create
838: AND p_cal_crt_rec_rec.criteria_id IS NOT NULL
839: THEN
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
841: 'ams_calendar_criteria',
842: 'criteria_id = ''' || p_cal_crt_rec_rec.criteria_id ||''''
843: );
844: END IF;

Line 847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_criteria_id_DUPLICATE');

843: );
844: END IF;
845:
846: IF l_valid_flag = FND_API.g_false THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_criteria_id_DUPLICATE');
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850: END check_Cal_Crt_Rec_Uk_Items;
851:

Line 862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );

858: BEGIN
859: x_return_status := FND_API.g_ret_sts_success;
860: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
861: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char OR p_cal_crt_rec_rec.object_type_code IS NULL THEN
862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
863: x_return_status := FND_API.g_ret_sts_error;
864: END IF;
865:
866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN

Line 867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

863: x_return_status := FND_API.g_ret_sts_error;
864: END IF;
865:
866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN
867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: ELSE
871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN

Line 872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CRITERIA_ID' );

868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: ELSE
871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CRITERIA_ID' );
873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875:
876: /*

Line 878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );

874: END IF;
875:
876: /*
877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN
878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line 882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885: */
886: END IF;

Line 930: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_INVALID_DATES');

926: END IF;
927: -- Charu: Check if the current criteria endDate > startDate
928: IF ((p_cal_crt_rec_rec.criteria_start_date IS NOT NULL) AND (p_cal_crt_rec_rec.criteria_end_date IS NOT NULL)
929: AND (p_cal_crt_rec_rec.criteria_end_date < p_cal_crt_rec_rec.criteria_start_date)) THEN
930: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_INVALID_DATES');
931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_INVALID_DATES');
933: FND_MSG_PUB.add;
934: RAISE FND_API.G_EXC_ERROR;

Line 995: AMS_UTILITY_PVT.debug_message('criteria_id is: ' || x_complete_rec.criteria_id);

991: IF p_cal_crt_rec_rec.criteria_id IS NULL THEN
992: x_complete_rec.criteria_id := l_cal_crt_rec_rec.criteria_id;
993: END IF;
994: IF (AMS_DEBUG_HIGH_ON) THEN
995: AMS_UTILITY_PVT.debug_message('criteria_id is: ' || x_complete_rec.criteria_id);
996: END IF;
997: -- object_type_code
998: IF p_cal_crt_rec_rec.object_type_code IS NULL THEN
999: x_complete_rec.object_type_code := l_cal_crt_rec_rec.object_type_code;

Line 1002: AMS_UTILITY_PVT.debug_message('object_type_code is: ' || x_complete_rec.object_type_code);

998: IF p_cal_crt_rec_rec.object_type_code IS NULL THEN
999: x_complete_rec.object_type_code := l_cal_crt_rec_rec.object_type_code;
1000: END IF;
1001: IF (AMS_DEBUG_HIGH_ON) THEN
1002: AMS_UTILITY_PVT.debug_message('object_type_code is: ' || x_complete_rec.object_type_code);
1003: END IF;
1004: -- custom_setup_id
1005: IF p_cal_crt_rec_rec.custom_setup_id IS NULL THEN
1006: x_complete_rec.custom_setup_id := l_cal_crt_rec_rec.custom_setup_id;

Line 1147: AMS_UTILITY_PVT.debug_message('2');

1143: END IF;
1144: END IF;
1145: IF (AMS_DEBUG_HIGH_ON) THEN
1146:
1147: AMS_UTILITY_PVT.debug_message('2');
1148: END IF;
1149: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1150: Default_Cal_Crt_Rec_Items (p_cal_crt_rec_rec => p_cal_crt_rec_rec ,
1151: x_cal_crt_rec_rec => l_cal_crt_rec_rec) ;

Line 1155: AMS_UTILITY_PVT.debug_message('3');

1151: x_cal_crt_rec_rec => l_cal_crt_rec_rec) ;
1152: END IF ;
1153:
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155: AMS_UTILITY_PVT.debug_message('3');
1156: END IF;
1157:
1158: Complete_cal_crt_rec_Rec(
1159: p_cal_crt_rec_rec => p_cal_crt_rec_rec,

Line 1164: AMS_UTILITY_PVT.debug_message('4');

1160: x_complete_rec => l_cal_crt_rec_rec
1161: );
1162: IF (AMS_DEBUG_HIGH_ON) THEN
1163:
1164: AMS_UTILITY_PVT.debug_message('4');
1165: END IF;
1166:
1167: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1168: Validate_cal_crt_rec_Rec(

Line 1184: AMS_UTILITY_PVT.debug_message('5');

1180: END IF;
1181: END IF;
1182: IF (AMS_DEBUG_HIGH_ON) THEN
1183:
1184: AMS_UTILITY_PVT.debug_message('5');
1185: END IF;
1186: -- Debug Message
1187: IF (AMS_DEBUG_HIGH_ON) THEN
1188:

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

1185: END IF;
1186: -- Debug Message
1187: IF (AMS_DEBUG_HIGH_ON) THEN
1188:
1189: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1190: END IF;
1191:
1192: -- Initialize API return status to SUCCESS
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1192: -- Initialize API return status to SUCCESS
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: -- Debug Message
1195: IF (AMS_DEBUG_HIGH_ON) THEN
1196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1197: END IF;
1198: -- Standard call to get message count and if count is 1, get message info.
1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count,

Line 1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'ended fully');

1200: (p_count => x_msg_count,
1201: p_data => x_msg_data
1202: );
1203: IF (AMS_DEBUG_HIGH_ON) THEN
1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'ended fully');
1205: END IF;
1206: EXCEPTION
1207: WHEN AMS_Utility_PVT.resource_locked THEN
1208: x_return_status := FND_API.g_ret_sts_error;

Line 1207: WHEN AMS_Utility_PVT.resource_locked THEN

1203: IF (AMS_DEBUG_HIGH_ON) THEN
1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'ended fully');
1205: END IF;
1206: EXCEPTION
1207: WHEN AMS_Utility_PVT.resource_locked THEN
1208: x_return_status := FND_API.g_ret_sts_error;
1209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Cal_Crt_;

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

1205: END IF;
1206: EXCEPTION
1207: WHEN AMS_Utility_PVT.resource_locked THEN
1208: x_return_status := FND_API.g_ret_sts_error;
1209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Cal_Crt_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message

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

1264: -- x_return_status := FND_API.G_RET_STS_ERROR;
1265:
1266: -- Debug Message
1267: IF (AMS_DEBUG_HIGH_ON) THEN
1268: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1269: END IF;
1270: -- Standard call to get message count and if count is 1, get message info.
1271: FND_MSG_PUB.Count_And_Get
1272: (p_count => x_msg_count,