DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PVT dependencies on AMS_UTILITY_PVT

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

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

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

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

Line 115: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Strats');

111: THEN
112: -- Debug message
113: IF (AMS_DEBUG_HIGH_ON) THEN
114:
115: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Strats');
116: END IF;
117:
118: -- Invoke validation procedures
119: Validate_ps_strats(

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

133:
134: -- Debug Message
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:
137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Insert_Row)
141: AMS_IBA_PS_STRATS_B_PKG.Insert_Row(

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

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

Line 183: WHEN AMS_Utility_PVT.resource_locked THEN

179: p_data => x_msg_data
180: );
181: EXCEPTION
182:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
186:
187: WHEN FND_API.G_EXC_ERROR THEN

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

181: EXCEPTION
182:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
186:
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO CREATE_Ps_Strats_PVT;
189: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

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

Line 303: AMS_UTILITY_PVT.debug_message('l_object_version '|| l_object_version);

299: IF (AMS_DEBUG_HIGH_ON) THEN
300:
301:
302:
303: AMS_UTILITY_PVT.debug_message('l_object_version '|| l_object_version);
304:
305: END IF;
306:
307: If ( c_get_Ps_Strats%NOTFOUND) THEN

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

304:
305: END IF;
306:
307: If ( c_get_Ps_Strats%NOTFOUND) THEN
308: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
309: p_token_name => 'INFO',
310: p_token_value => 'Ps_Strats') ;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;

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

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

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

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

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

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

Line 341: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Strats');

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

Line 358: AMS_UTILITY_PVT.debug_message('Exception: Return Status: '|| x_return_status);

354:
355: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
356: IF (AMS_DEBUG_HIGH_ON) THEN
357:
358: AMS_UTILITY_PVT.debug_message('Exception: Return Status: '|| x_return_status);
359: END IF;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:

Line 364: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;

360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: -- Debug Message
364: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
365:
366: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Update_Row)
367: AMS_IBA_PS_STRATS_B_PKG.Update_Row(
368: p_created_by => FND_GLOBAL.USER_ID,

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

392:
393: -- Debug Message
394: IF (AMS_DEBUG_HIGH_ON) THEN
395:
396: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
397: END IF;
398:
399: -- Standard call to get message count and if count is 1, get message info.
400: FND_MSG_PUB.Count_And_Get

Line 406: WHEN AMS_Utility_PVT.resource_locked THEN

402: p_data => x_msg_data
403: );
404: EXCEPTION
405:
406: WHEN AMS_Utility_PVT.resource_locked THEN
407: x_return_status := FND_API.g_ret_sts_error;
408: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
409:
410: WHEN FND_API.G_EXC_ERROR THEN

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

404: EXCEPTION
405:
406: WHEN AMS_Utility_PVT.resource_locked THEN
407: x_return_status := FND_API.g_ret_sts_error;
408: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO UPDATE_Ps_Strats_PVT;
412: x_return_status := FND_API.G_RET_STS_ERROR;

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

520:
521: -- Debug Message
522: IF (AMS_DEBUG_HIGH_ON) THEN
523:
524: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
525: END IF;
526:
527:
528: -- Initialize API return status to SUCCESS

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

533: --
534: -- Debug Message
535: IF (AMS_DEBUG_HIGH_ON) THEN
536:
537: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
538: END IF;
539:
540: -- Invoke table handler(AMS_IBA_PS_STRATS_B_PKG.Delete_Row)
541: AMS_IBA_PS_STRATS_B_PKG.Delete_Row(

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

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

Line 566: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

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

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

632: BEGIN
633: -- Debug Message
634: IF (AMS_DEBUG_HIGH_ON) THEN
635:
636: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
637: END IF;
638:
639: -- Initialize message list if p_init_msg_list is set to TRUE.
640: IF FND_API.to_Boolean( p_init_msg_list )

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

661: IF (AMS_DEBUG_HIGH_ON) THEN
662:
663:
664:
665: AMS_Utility_PVT.debug_message(l_full_name||': start');
666:
667: END IF;
668: OPEN c_Ps_Strats;
669:

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

686: p_count => x_msg_count,
687: p_data => x_msg_data);
688: IF (AMS_DEBUG_HIGH_ON) THEN
689:
690: AMS_Utility_PVT.debug_message(l_full_name ||': end');
691: END IF;
692: EXCEPTION
693:
694: WHEN AMS_Utility_PVT.resource_locked THEN

Line 694: WHEN AMS_Utility_PVT.resource_locked THEN

690: AMS_Utility_PVT.debug_message(l_full_name ||': end');
691: END IF;
692: EXCEPTION
693:
694: WHEN AMS_Utility_PVT.resource_locked THEN
695: x_return_status := FND_API.g_ret_sts_error;
696: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
697:
698: WHEN FND_API.G_EXC_ERROR THEN

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

692: EXCEPTION
693:
694: WHEN AMS_Utility_PVT.resource_locked THEN
695: x_return_status := FND_API.g_ret_sts_error;
696: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
697:
698: WHEN FND_API.G_EXC_ERROR THEN
699: ROLLBACK TO LOCK_Ps_Strats_PVT;
700: x_return_status := FND_API.G_RET_STS_ERROR;

Line 744: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

740:
741: BEGIN
742: x_return_status := FND_API.g_ret_sts_success;
743: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
744: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
745: 'AMS_IBA_PS_STRATS_B',
746: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||''''
747: );
748: ELSE

Line 749: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

745: 'AMS_IBA_PS_STRATS_B',
746: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||''''
747: );
748: ELSE
749: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
750: 'AMS_IBA_PS_STRATS_B',
751: 'STRATEGY_ID = ''' || p_ps_strats_rec.STRATEGY_ID ||
752: ''' AND STRATEGY_ID <> ' || p_ps_strats_rec.STRATEGY_ID
753: );

Line 757: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_STRATEGY_ID_DUPLICATE');

753: );
754: END IF;
755:
756: IF l_valid_flag = FND_API.g_false THEN
757: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_STRATEGY_ID_DUPLICATE');
758: x_return_status := FND_API.g_ret_sts_error;
759: RETURN;
760: END IF;
761:

Line 777: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_created_by');

773: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
774:
775:
776: IF p_ps_strats_rec.created_by = FND_API.g_miss_num OR p_ps_strats_rec.created_by IS NULL THEN
777: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_created_by');
778: x_return_status := FND_API.g_ret_sts_error;
779: RETURN;
780: END IF;
781:

Line 784: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_creation_date');

780: END IF;
781:
782:
783: IF p_ps_strats_rec.creation_date = FND_API.g_miss_date OR p_ps_strats_rec.creation_date IS NULL THEN
784: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_creation_date');
785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:

Line 791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_updated_by');

787: END IF;
788:
789:
790: IF p_ps_strats_rec.last_updated_by = FND_API.g_miss_num OR p_ps_strats_rec.last_updated_by IS NULL THEN
791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_updated_by');
792: x_return_status := FND_API.g_ret_sts_error;
793: RETURN;
794: END IF;
795:

Line 798: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_update_date');

794: END IF;
795:
796:
797: IF p_ps_strats_rec.last_update_date = FND_API.g_miss_date OR p_ps_strats_rec.last_update_date IS NULL THEN
798: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_update_date');
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;
802:

Line 805: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_id');

801: END IF;
802:
803:
804: IF p_ps_strats_rec.strategy_id = FND_API.g_miss_num OR p_ps_strats_rec.strategy_id IS NULL THEN
805: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_id');
806: x_return_status := FND_API.g_ret_sts_error;
807: RETURN;
808: END IF;
809:

Line 812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_type');

808: END IF;
809:
810:
811: IF p_ps_strats_rec.strategy_type = FND_API.g_miss_char OR p_ps_strats_rec.strategy_type IS NULL THEN
812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_type');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816: ELSE

Line 820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_created_by');

816: ELSE
817:
818:
819: IF p_ps_strats_rec.created_by IS NULL THEN
820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_created_by');
821: x_return_status := FND_API.g_ret_sts_error;
822: RETURN;
823: END IF;
824:

Line 827: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_creation_date');

823: END IF;
824:
825:
826: IF p_ps_strats_rec.creation_date IS NULL THEN
827: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_creation_date');
828: x_return_status := FND_API.g_ret_sts_error;
829: RETURN;
830: END IF;
831:

Line 834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_updated_by');

830: END IF;
831:
832:
833: IF p_ps_strats_rec.last_updated_by IS NULL THEN
834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_updated_by');
835: x_return_status := FND_API.g_ret_sts_error;
836: RETURN;
837: END IF;
838:

Line 841: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_update_date');

837: END IF;
838:
839:
840: IF p_ps_strats_rec.last_update_date IS NULL THEN
841: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_last_update_date');
842: x_return_status := FND_API.g_ret_sts_error;
843: RETURN;
844: END IF;
845:

Line 848: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_id');

844: END IF;
845:
846:
847: IF p_ps_strats_rec.strategy_id IS NULL THEN
848: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_id');
849: x_return_status := FND_API.g_ret_sts_error;
850: RETURN;
851: END IF;
852:

Line 855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_type');

851: END IF;
852:
853:
854: IF p_ps_strats_rec.strategy_type IS NULL THEN
855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_strats_NO_strategy_type');
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
859: END IF;

Line 1076: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Inside Comment');

1072:
1073: -- Debug Message
1074: IF (AMS_DEBUG_HIGH_ON) THEN
1075:
1076: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Inside Comment');
1077: END IF;
1078:
1079: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1080: Validate_ps_strats_Rec(

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

1095:
1096: -- Debug Message
1097: IF (AMS_DEBUG_HIGH_ON) THEN
1098:
1099: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1100: END IF;
1101:
1102:
1103: -- Initialize API return status to SUCCESS

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

1106:
1107: -- Debug Message
1108: IF (AMS_DEBUG_HIGH_ON) THEN
1109:
1110: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1111: END IF;
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: FND_MSG_PUB.Count_And_Get

Line 1120: WHEN AMS_Utility_PVT.resource_locked THEN

1116: p_data => x_msg_data
1117: );
1118: EXCEPTION
1119:
1120: WHEN AMS_Utility_PVT.resource_locked THEN
1121: x_return_status := FND_API.g_ret_sts_error;
1122: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN

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

1118: EXCEPTION
1119:
1120: WHEN AMS_Utility_PVT.resource_locked THEN
1121: x_return_status := FND_API.g_ret_sts_error;
1122: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: ROLLBACK TO VALIDATE_Ps_Strats_;
1126: x_return_status := FND_API.G_RET_STS_ERROR;

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

1183:
1184: -- Debug Message
1185: IF (AMS_DEBUG_HIGH_ON) THEN
1186:
1187: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1188: END IF;
1189: -- Standard call to get message count and if count is 1, get message info.
1190: FND_MSG_PUB.Count_And_Get
1191: (p_count => x_msg_count,