159: x_return_status := FND_API.g_ret_sts_error;
160: FND_MESSAGE.set_name('AMS', 'AMS_PRETTY_URL_NOT_UNIQUE_ERR');
161: FND_MESSAGE.set_token('SCHEDULENAME', l_scheduleName);
162: FND_MESSAGE.set_token('OWNER', l_ownerName);
163: FND_MSG_PUB.add;
164: RETURN;
165: END IF;
166: END IF;
167: END IF;
215:
216: -- Initialize message list if p_init_msg_list is set to TRUE.
217: IF FND_API.to_Boolean( p_init_msg_list )
218: THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
305: -- Debug Message
306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313: EXCEPTION
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO CREATE_Pretty_Url_PVT;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: -- Standard call to get message count and if count=1, get the message
323: FND_MSG_PUB.Count_And_Get (
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: ROLLBACK TO CREATE_Pretty_Url_PVT;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: FND_MSG_PUB.Count_And_Get (
334: p_encoded => FND_API.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338:
339: WHEN OTHERS THEN
340: ROLLBACK TO CREATE_Pretty_Url_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
340: ROLLBACK TO CREATE_Pretty_Url_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
343: THEN
344: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
345: END IF;
346: -- Standard call to get message count and if count=1, get the message
347: FND_MSG_PUB.Count_And_Get (
348: p_encoded => FND_API.G_FALSE,
349: p_count => x_msg_count,
350: p_data => x_msg_data
351: );
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean( p_init_msg_list )
398: THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Debug Message
403: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
461: END IF;
462:
463:
464: -- Debug Message
465: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
466:
467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)
468: AMS_PRETTY_URL_PKG.Update_Row(
469: p_pretty_url_id => p_pretty_url_rec.pretty_url_id,
488: -- Debug Message
489: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
490:
491: -- Standard call to get message count and if count is 1, get message info.
492: FND_MSG_PUB.Count_And_Get
493: (p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496: EXCEPTION
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO UPDATE_Pretty_Url_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: -- Standard call to get message count and if count=1, get the message
506: FND_MSG_PUB.Count_And_Get (
507: p_encoded => FND_API.G_FALSE,
508: p_count => x_msg_count,
509: p_data => x_msg_data
510: );
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO UPDATE_Pretty_Url_PVT;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: -- Standard call to get message count and if count=1, get the message
516: FND_MSG_PUB.Count_And_Get (
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count,
519: p_data => x_msg_data
520: );
521:
522: WHEN OTHERS THEN
523: ROLLBACK TO UPDATE_Pretty_Url_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
523: ROLLBACK TO UPDATE_Pretty_Url_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
528: END IF;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data
534: );
567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF FND_API.to_Boolean( p_init_msg_list )
570: THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: -- Debug Message
575: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
601: -- Debug Message
602: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count,
607: p_data => x_msg_data
608: );
609: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO DELETE_Pretty_Url_PVT;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data
623: );
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: ROLLBACK TO DELETE_Pretty_Url_PVT;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:
635: WHEN OTHERS THEN
636: ROLLBACK TO DELETE_Pretty_Url_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
636: ROLLBACK TO DELETE_Pretty_Url_PVT;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );
682:
683: -- Initialize message list if p_init_msg_list is set to TRUE.
684: IF FND_API.to_Boolean( p_init_msg_list )
685: THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
708: FETCH c_Pretty_Url INTO l_PRETTY_URL_ID;
709:
710: IF (c_Pretty_Url%NOTFOUND) THEN
711: CLOSE c_Pretty_Url;
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
714: FND_MSG_PUB.add;
715: END IF;
716: RAISE FND_API.g_exc_error;
710: IF (c_Pretty_Url%NOTFOUND) THEN
711: CLOSE c_Pretty_Url;
712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
714: FND_MSG_PUB.add;
715: END IF;
716: RAISE FND_API.g_exc_error;
717: END IF;
718:
718:
719: CLOSE c_Pretty_Url;
720:
721: -------------------- finish --------------------------
722: FND_MSG_PUB.count_and_get(
723: p_encoded => FND_API.g_false,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO LOCK_Pretty_Url_PVT;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: -- Standard call to get message count and if count=1, get the message
737: FND_MSG_PUB.Count_And_Get (
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );
743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
744: ROLLBACK TO LOCK_Pretty_Url_PVT;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );
752:
753: WHEN OTHERS THEN
754: ROLLBACK TO LOCK_Pretty_Url_PVT;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
754: ROLLBACK TO LOCK_Pretty_Url_PVT;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
759: END IF;
760: -- Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );
1057:
1058: -- Initialize message list if p_init_msg_list is set to TRUE.
1059: IF FND_API.to_Boolean( p_init_msg_list )
1060: THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_pretty_url_Items(
1065: p_pretty_url_rec => p_pretty_url_rec,
1107: -- Debug Message
1108: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get
1112: (p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115: EXCEPTION
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK TO VALIDATE_Pretty_Url_;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: -- Standard call to get message count and if count=1, get the message
1125: FND_MSG_PUB.Count_And_Get (
1126: p_encoded => FND_API.G_FALSE,
1127: p_count => x_msg_count,
1128: p_data => x_msg_data
1129: );
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: ROLLBACK TO VALIDATE_Pretty_Url_;
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1140:
1141: WHEN OTHERS THEN
1142: ROLLBACK TO VALIDATE_Pretty_Url_;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1142: ROLLBACK TO VALIDATE_Pretty_Url_;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1145: THEN
1146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1147: END IF;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1166: BEGIN
1167: -- Initialize message list if p_init_msg_list is set to TRUE.
1168: IF FND_API.to_Boolean( p_init_msg_list )
1169: THEN
1170: FND_MSG_PUB.initialize;
1171: END IF;
1172:
1173: -- Initialize API return status to SUCCESS
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1180:
1181: -- Debug Message
1182: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1183: -- Standard call to get message count and if count is 1, get message info.
1184: FND_MSG_PUB.Count_And_Get
1185: (p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );
1188: END Validate_pretty_url_Rec;
1214: WRITE_LOG(l_api_name, 'Pretty Url Id not found');
1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here
1216: x_return_status := FND_API.g_ret_sts_error;
1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');
1218: FND_MSG_PUB.add;
1219: RETURN;
1220: END IF;
1221:
1222: IF p_pretty_url_rec.landing_page_url = FND_API.g_miss_char OR p_pretty_url_rec.landing_page_url IS NULL THEN
1223: WRITE_LOG(l_api_name, 'Landing page Url not found');
1224: --AMS_Utility_PVT.Error_Message('AMS_REQ_FIELDS_NOT_MAPPED');
1225: x_return_status := FND_API.g_ret_sts_error;
1226: FND_MESSAGE.set_name('AMS', 'AMS_PU_REQ_FIELDS_NOT_MAPPED');
1227: FND_MSG_PUB.add;
1228: RETURN;
1229: END IF;
1230:
1231: END CHECK_PU_MANDATORY_FIELDS;