168: close valid_language_cur;
169: END IF;
170: FND_MESSAGE.set_name('JTF','JTF_MSITE_LANG_INVLD');
171: FND_MESSAGE.set_token('0', p_language);
172: FND_MSG_PUB.ADD;
173: -----dbms_output.put_line('invalid languages');
174: return false;
175: END valid_language;
176:
207: close valid_orgid_cur;
208: END IF;
209: FND_MESSAGE.set_name('JTF','JTF_MSITE_ORGID_INVLD');
210: FND_MESSAGE.set_token('0', p_orgid);
211: FND_MSG_PUB.ADD;
212: --dbms_output.put_line('invalid Org id');
213: return false;
214: END valid_orgid;
215:
246: close valid_currency_cur;
247: END IF;
248: FND_MESSAGE.set_name('JTF','JTF_MSITE_CURRENCY_INVLD');
249: FND_MESSAGE.set_token('0', p_currency);
250: FND_MSG_PUB.ADD;
251: --dbms_output.put_line('error in currency code');
252: return false;
253:
254: END valid_currency;
279: p_bizpartner_prclstid is null
280: then
281: FND_MESSAGE.set_name('JTF','JTF_MSITE_PRCLSTID_REQ');
282: FND_MESSAGE.set_token('CURR_CODE', p_currency);
283: FND_MSG_PUB.ADD;
284: raise FND_API.g_exc_error;
285: END IF;
286:
287: OPEN valid_currency_prclstid_cur(p_currency,p_walkin_prclstid,p_registered_prclstid,
300: FND_MESSAGE.set_token('WALKIN_ID',p_walkin_prclstid);
301: FND_MESSAGE.set_token('REG_ID' , p_registered_prclstid);
302: FND_MESSAGE.set_token('BIZ_ID' , p_bizpartner_prclstid);
303: FND_MESSAGE.set_token('CURR_CODE',p_currency);
304: FND_MSG_PUB.ADD;
305: end if;
306:
307: return l_return_status;
308:
388: END IF;
389:
390:
391: IF FND_API.to_boolean(p_init_msg_list) THEN
392: FND_MSG_PUB.initialize;
393: END IF;
394:
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
430: p_msite_rec.enable_for_store = FND_API.g_true) or
431: p_msite_rec.enable_for_store = FND_API.g_true
432: then
433: FND_MESSAGE.set_name('JTF','JTF_MSITE_RSECID_INVLD');
434: FND_MSG_PUB.ADD;
435: raise FND_API.g_exc_error;
436: end if;
437: end if;
438:
742: END IF;
743:
744: x_return_status := FND_API.G_RET_STS_SUCCESS;
745:
746: FND_MSG_PUB.count_and_get(
747: p_encoded => FND_API.g_false,
748: p_count => x_msg_count,
749: p_data => x_msg_data
750: );
753:
754: WHEN FND_API.g_exc_error THEN
755: ROLLBACK TO save_msite;
756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MSG_PUB.count_and_get(
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
763: WHEN FND_API.g_exc_unexpected_error THEN
764: ROLLBACK TO save_msite;
765: x_return_status := FND_API.g_ret_sts_unexp_error ;
766: --dbms_output.put_line('unexpected error raised');
767: FND_MSG_PUB.count_and_get(
768: p_encoded => FND_API.g_false,
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );
773: WHEN master_msite_exists_exception THEN
774: ROLLBACK TO save_msite;
775: x_return_status := FND_API.g_ret_sts_error ;
776: FND_MESSAGE.set_name('JTF','JTF_MSITE_MASTER_EXISTS');
777: FND_MSG_PUB.ADD;
778: --dbms_output.put_line('master_msite error raised');
779: FND_MSG_PUB.count_and_get(
780: p_encoded => FND_API.g_false,
781: p_count => x_msg_count,
775: x_return_status := FND_API.g_ret_sts_error ;
776: FND_MESSAGE.set_name('JTF','JTF_MSITE_MASTER_EXISTS');
777: FND_MSG_PUB.ADD;
778: --dbms_output.put_line('master_msite error raised');
779: FND_MSG_PUB.count_and_get(
780: p_encoded => FND_API.g_false,
781: p_count => x_msg_count,
782: p_data => x_msg_data
783: );
784:
785: WHEN store_not_exists_exception THEN
786: ROLLBACK TO save_msite;
787: x_return_status := FND_API.g_ret_sts_error ;
788: FND_MSG_PUB.count_and_get(
789: p_encoded => FND_API.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data
792: );
795: ROLLBACK TO save_msite;
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_ORG_REQ');
798: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
799: FND_MSG_PUB.ADD;
800: FND_MSG_PUB.count_and_get(
801: p_encoded => FND_API.g_false,
802: p_count => x_msg_count,
803: p_data => x_msg_data
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_ORG_REQ');
798: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
799: FND_MSG_PUB.ADD;
800: FND_MSG_PUB.count_and_get(
801: p_encoded => FND_API.g_false,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
806: ROLLBACK TO save_msite;
807: x_return_status := FND_API.g_ret_sts_error;
808: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_CURR_REQ');
809: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
810: FND_MSG_PUB.ADD;
811: FND_MSG_PUB.count_and_get(
812: p_encoded => FND_API.g_false,
813: p_count => x_msg_count,
814: p_data => x_msg_data
807: x_return_status := FND_API.g_ret_sts_error;
808: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_CURR_REQ');
809: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
810: FND_MSG_PUB.ADD;
811: FND_MSG_PUB.count_and_get(
812: p_encoded => FND_API.g_false,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );
818: ROLLBACK TO save_msite;
819: x_return_status := FND_API.g_ret_sts_error;
820: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_LANG_REQ');
821: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.count_and_get(
824: p_encoded => FND_API.g_false,
825: p_count => x_msg_count,
826: p_data => x_msg_data
819: x_return_status := FND_API.g_ret_sts_error;
820: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_LANG_REQ');
821: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.count_and_get(
824: p_encoded => FND_API.g_false,
825: p_count => x_msg_count,
826: p_data => x_msg_data
827: );
828:
829: WHEN OTHERS THEN
830: ROLLBACK TO save_msite;
831: x_return_status := FND_API.g_ret_sts_unexp_error ;
832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
833: THEN
834: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
835: END IF;
836: FND_MSG_PUB.count_and_get(
830: ROLLBACK TO save_msite;
831: x_return_status := FND_API.g_ret_sts_unexp_error ;
832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
833: THEN
834: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
835: END IF;
836: FND_MSG_PUB.count_and_get(
837: p_encoded => FND_API.g_false,
838: p_count => x_msg_count,
832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
833: THEN
834: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
835: END IF;
836: FND_MSG_PUB.count_and_get(
837: p_encoded => FND_API.g_false,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
881: END IF;
882:
883:
884: IF FND_API.to_boolean(p_init_msg_list) THEN
885: FND_MSG_PUB.initialize;
886: END IF;
887:
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
990: end if;
991: else
992: raise jtf_dspmgrvalidation_grp.msite_req_exception;
993: end if;
994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
995: p_count => x_msg_count,
996: p_data => x_msg_data
997: );
998: EXCEPTION
998: EXCEPTION
999: WHEN FND_API.g_exc_error THEN
1000: ROLLBACK TO save_msite_languages;
1001: x_return_status := FND_API.g_ret_sts_error;
1002: FND_MSG_PUB.count_and_get(
1003: p_encoded => FND_API.g_false,
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1007: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1008: ROLLBACK TO save_msite_languages;
1009: x_return_status := FND_API.g_ret_sts_error;
1010: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1011: FND_MSG_PUB.ADD;
1012: FND_MSG_PUB.count_and_get(
1013: p_encoded => FND_API.g_false,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1008: ROLLBACK TO save_msite_languages;
1009: x_return_status := FND_API.g_ret_sts_error;
1010: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1011: FND_MSG_PUB.ADD;
1012: FND_MSG_PUB.count_and_get(
1013: p_encoded => FND_API.g_false,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1018: ROLLBACK TO save_msite_languages;
1019: x_return_status := FND_API.g_ret_sts_error;
1020: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_LANG_REQ');
1021: FND_MESSAGE.set_token('ID', p_msite_id);
1022: FND_MSG_PUB.ADD;
1023: FND_MSG_PUB.count_and_get(
1024: p_encoded => FND_API.g_false,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data
1019: x_return_status := FND_API.g_ret_sts_error;
1020: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_LANG_REQ');
1021: FND_MESSAGE.set_token('ID', p_msite_id);
1022: FND_MSG_PUB.ADD;
1023: FND_MSG_PUB.count_and_get(
1024: p_encoded => FND_API.g_false,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data
1027: );
1027: );
1028: WHEN FND_API.g_exc_unexpected_error THEN
1029: ROLLBACK TO save_msite_languages;
1030: x_return_status := FND_API.g_ret_sts_unexp_error ;
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.g_false,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data );
1035: WHEN OTHERS THEN
1034: p_data => x_msg_data );
1035: WHEN OTHERS THEN
1036: ROLLBACK TO save_msite_languages;
1037: x_return_status := FND_API.g_ret_sts_unexp_error ;
1038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1039: THEN
1040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1041: END IF;
1042: FND_MSG_PUB.count_and_get(
1036: ROLLBACK TO save_msite_languages;
1037: x_return_status := FND_API.g_ret_sts_unexp_error ;
1038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1039: THEN
1040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1041: END IF;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1044: p_count => x_msg_count,
1038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1039: THEN
1040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1041: END IF;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data );
1046:
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080:
1081: IF FND_API.to_boolean(p_init_msg_list) THEN
1082: FND_MSG_PUB.initialize;
1083: END IF;
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085: --- Check if the msite_id exists
1086: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
1184: end if;
1185: else
1186: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1187: end if;
1188: FND_MSG_PUB.count_and_get(
1189: p_encoded => FND_API.g_false,
1190: p_count => x_msg_count,
1191: p_data => x_msg_data
1192: );
1194: EXCEPTION
1195: WHEN FND_API.g_exc_error THEN
1196: ROLLBACK TO save_msite_currencies;
1197: x_return_status := FND_API.g_ret_sts_error;
1198: FND_MSG_PUB.count_and_get(
1199: p_encoded => FND_API.g_false,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data
1202: );
1203: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1204: ROLLBACK TO save_msite_currencies;
1205: x_return_status := FND_API.g_ret_sts_error;
1206: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1207: FND_MSG_PUB.ADD;
1208: FND_MSG_PUB.count_and_get(
1209: p_encoded => FND_API.g_false,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1204: ROLLBACK TO save_msite_currencies;
1205: x_return_status := FND_API.g_ret_sts_error;
1206: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1207: FND_MSG_PUB.ADD;
1208: FND_MSG_PUB.count_and_get(
1209: p_encoded => FND_API.g_false,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );
1214: ROLLBACK TO save_msite_currencies;
1215: x_return_status := FND_API.g_ret_sts_error;
1216: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_CURR_REQ');
1217: FND_MESSAGE.set_token('ID', p_msite_id);
1218: FND_MSG_PUB.ADD;
1219: FND_MSG_PUB.count_and_get(
1220: p_encoded => FND_API.g_false,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data
1215: x_return_status := FND_API.g_ret_sts_error;
1216: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_CURR_REQ');
1217: FND_MESSAGE.set_token('ID', p_msite_id);
1218: FND_MSG_PUB.ADD;
1219: FND_MSG_PUB.count_and_get(
1220: p_encoded => FND_API.g_false,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data
1223: );
1223: );
1224: WHEN FND_API.g_exc_unexpected_error THEN
1225: ROLLBACK TO save_msite_currencies;
1226: x_return_status := FND_API.g_ret_sts_unexp_error ;
1227: FND_MSG_PUB.count_and_get(
1228: p_encoded => FND_API.g_false,
1229: p_count => x_msg_count,
1230: p_data => x_msg_data
1231: );
1231: );
1232: WHEN OTHERS THEN
1233: ROLLBACK TO save_msite_currencies;
1234: x_return_status := FND_API.g_ret_sts_unexp_error ;
1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1236: THEN
1237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1238: END IF;
1239: FND_MSG_PUB.count_and_get(
1233: ROLLBACK TO save_msite_currencies;
1234: x_return_status := FND_API.g_ret_sts_unexp_error ;
1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1236: THEN
1237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1238: END IF;
1239: FND_MSG_PUB.count_and_get(
1240: p_encoded => FND_API.g_false,
1241: p_count => x_msg_count,
1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1236: THEN
1237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1238: END IF;
1239: FND_MSG_PUB.count_and_get(
1240: p_encoded => FND_API.g_false,
1241: p_count => x_msg_count,
1242: p_data => x_msg_data
1243: );
1285: END IF;
1286:
1287:
1288: IF FND_API.to_boolean(p_init_msg_list) THEN
1289: FND_MSG_PUB.initialize;
1290: END IF;
1291:
1292:
1293: x_return_status := FND_API.G_RET_STS_SUCCESS;
1385: else
1386: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1387: end if;
1388:
1389: FND_MSG_PUB.count_and_get(
1390: p_encoded => FND_API.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1396:
1397: WHEN FND_API.g_exc_error THEN
1398: ROLLBACK TO save_msite_orgids;
1399: x_return_status := FND_API.g_ret_sts_error;
1400: FND_MSG_PUB.count_and_get(
1401: p_encoded => FND_API.g_false,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );
1406: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1407: ROLLBACK TO save_msite_orgids;
1408: x_return_status := FND_API.g_ret_sts_error;
1409: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1410: FND_MSG_PUB.ADD;
1411: FND_MSG_PUB.count_and_get(
1412: p_encoded => FND_API.g_false,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1407: ROLLBACK TO save_msite_orgids;
1408: x_return_status := FND_API.g_ret_sts_error;
1409: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1410: FND_MSG_PUB.ADD;
1411: FND_MSG_PUB.count_and_get(
1412: p_encoded => FND_API.g_false,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );
1415: );
1416: WHEN FND_API.g_exc_unexpected_error THEN
1417: ROLLBACK TO save_msite_orgids;
1418: x_return_status := FND_API.g_ret_sts_unexp_error ;
1419: FND_MSG_PUB.count_and_get(
1420: p_encoded => FND_API.g_false,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );
1426: ROLLBACK TO save_msite_orgids;
1427: x_return_status := FND_API.g_ret_sts_error;
1428: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_ORG_REQ');
1429: FND_MESSAGE.set_token('ID', p_msite_id);
1430: FND_MSG_PUB.ADD;
1431: FND_MSG_PUB.count_and_get(
1432: p_encoded => FND_API.g_false,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1427: x_return_status := FND_API.g_ret_sts_error;
1428: FND_MESSAGE.set_name('JTF','JTF_MSITE_DEF_ORG_REQ');
1429: FND_MESSAGE.set_token('ID', p_msite_id);
1430: FND_MSG_PUB.ADD;
1431: FND_MSG_PUB.count_and_get(
1432: p_encoded => FND_API.g_false,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );
1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO save_msite_orgids;
1439: x_return_status := FND_API.g_ret_sts_unexp_error ;
1440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1441: THEN
1442: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: FND_MSG_PUB.count_and_get(
1438: ROLLBACK TO save_msite_orgids;
1439: x_return_status := FND_API.g_ret_sts_unexp_error ;
1440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1441: THEN
1442: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: FND_MSG_PUB.count_and_get(
1445: p_encoded => FND_API.g_false,
1446: p_count => x_msg_count,
1440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1441: THEN
1442: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1443: END IF;
1444: FND_MSG_PUB.count_and_get(
1445: p_encoded => FND_API.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data
1448: );
1488: END IF;
1489:
1490:
1491: IF FND_API.to_boolean(p_init_msg_list) THEN
1492: FND_MSG_PUB.initialize;
1493: END IF;
1494:
1495:
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1538: x_msg_data => x_msg_data );
1539:
1540: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1541: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
1542: FND_MSG_PUB.Add;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1545: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
1546: FND_MSG_PUB.Add;
1542: FND_MSG_PUB.Add;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1545: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
1546: FND_MSG_PUB.Add;
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: END IF;
1549: End Loop;
1550:
1570: END IF;
1571:
1572: x_return_status := FND_API.G_RET_STS_SUCCESS;
1573:
1574: FND_MSG_PUB.count_and_get(
1575: p_encoded => FND_API.g_false,
1576: p_count => x_msg_count,
1577: p_data => x_msg_data
1578: );
1580: EXCEPTION
1581: WHEN FND_API.g_exc_error THEN
1582: ROLLBACK TO delete_msite;
1583: x_return_status := FND_API.g_ret_sts_error;
1584: FND_MSG_PUB.count_and_get(
1585: p_encoded => FND_API.g_false,
1586: p_count => x_msg_count,
1587: p_data => x_msg_data
1588: );
1590: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1591: ROLLBACK TO delete_msite;
1592: x_return_status := FND_API.g_ret_sts_error;
1593: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1594: FND_MSG_PUB.ADD;
1595: FND_MSG_PUB.count_and_get(
1596: p_encoded => FND_API.g_false,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1591: ROLLBACK TO delete_msite;
1592: x_return_status := FND_API.g_ret_sts_error;
1593: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1594: FND_MSG_PUB.ADD;
1595: FND_MSG_PUB.count_and_get(
1596: p_encoded => FND_API.g_false,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1599: );
1600:
1601: WHEN FND_API.g_exc_unexpected_error THEN
1602: ROLLBACK TO delete_msite;
1603: x_return_status := FND_API.g_ret_sts_unexp_error ;
1604: FND_MSG_PUB.count_and_get(
1605: p_encoded => FND_API.g_false,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data
1608: );
1609:
1610: WHEN OTHERS THEN
1611: ROLLBACK TO delete_msite;
1612: x_return_status := FND_API.g_ret_sts_unexp_error ;
1613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1616: END IF;
1617: FND_MSG_PUB.count_and_get(
1611: ROLLBACK TO delete_msite;
1612: x_return_status := FND_API.g_ret_sts_unexp_error ;
1613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1616: END IF;
1617: FND_MSG_PUB.count_and_get(
1618: p_encoded => FND_API.g_false,
1619: p_count => x_msg_count,
1613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1614: THEN
1615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1616: END IF;
1617: FND_MSG_PUB.count_and_get(
1618: p_encoded => FND_API.g_false,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );
1653: END IF;
1654:
1655:
1656: IF FND_API.to_boolean(p_init_msg_list) THEN
1657: FND_MSG_PUB.initialize;
1658: END IF;
1659:
1660:
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1674: END IF;
1675:
1676: x_return_status := FND_API.G_RET_STS_SUCCESS;
1677:
1678: FND_MSG_PUB.count_and_get(
1679: p_encoded => FND_API.g_false,
1680: p_count => x_msg_count,
1681: p_data => x_msg_data
1682: );
1684: EXCEPTION
1685: WHEN FND_API.g_exc_error THEN
1686: ROLLBACK TO get_msite_attribute;
1687: x_return_status := FND_API.g_ret_sts_error;
1688: FND_MSG_PUB.count_and_get(
1689: p_encoded => FND_API.g_false,
1690: p_count => x_msg_count,
1691: p_data => x_msg_data
1692: );
1694: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1695: ROLLBACK TO get_msite_attribute;
1696: x_return_status := FND_API.g_ret_sts_error;
1697: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1698: FND_MSG_PUB.ADD;
1699: FND_MSG_PUB.count_and_get(
1700: p_encoded => FND_API.g_false,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data
1695: ROLLBACK TO get_msite_attribute;
1696: x_return_status := FND_API.g_ret_sts_error;
1697: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1698: FND_MSG_PUB.ADD;
1699: FND_MSG_PUB.count_and_get(
1700: p_encoded => FND_API.g_false,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data
1703: );
1704:
1705: WHEN FND_API.g_exc_unexpected_error THEN
1706: ROLLBACK TO get_msite_attribute;
1707: x_return_status := FND_API.g_ret_sts_unexp_error ;
1708: FND_MSG_PUB.count_and_get(
1709: p_encoded => FND_API.g_false,
1710: p_count => x_msg_count,
1711: p_data => x_msg_data
1712: );
1713:
1714: WHEN OTHERS THEN
1715: ROLLBACK TO get_msite_attribute;
1716: x_return_status := FND_API.g_ret_sts_unexp_error ;
1717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1718: THEN
1719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1720: END IF;
1721: FND_MSG_PUB.count_and_get(
1715: ROLLBACK TO get_msite_attribute;
1716: x_return_status := FND_API.g_ret_sts_unexp_error ;
1717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1718: THEN
1719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1720: END IF;
1721: FND_MSG_PUB.count_and_get(
1722: p_encoded => FND_API.g_false,
1723: p_count => x_msg_count,
1717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1718: THEN
1719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1720: END IF;
1721: FND_MSG_PUB.count_and_get(
1722: p_encoded => FND_API.g_false,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data
1725: );