DBA Data[Home] [Help]

APPS.JTF_MSITE_GRP dependencies on FND_MSG_PUB

Line 172: FND_MSG_PUB.ADD;

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:

Line 211: FND_MSG_PUB.ADD;

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:

Line 250: FND_MSG_PUB.ADD;

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;

Line 283: FND_MSG_PUB.ADD;

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,

Line 304: FND_MSG_PUB.ADD;

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:

Line 392: FND_MSG_PUB.initialize;

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;

Line 434: FND_MSG_PUB.ADD;

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:

Line 746: FND_MSG_PUB.count_and_get(

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: );

Line 757: FND_MSG_PUB.count_and_get(

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: );

Line 767: FND_MSG_PUB.count_and_get(

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: );

Line 777: FND_MSG_PUB.ADD;

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,

Line 779: FND_MSG_PUB.count_and_get(

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: );

Line 788: FND_MSG_PUB.count_and_get(

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: );

Line 799: FND_MSG_PUB.ADD;

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

Line 800: FND_MSG_PUB.count_and_get(

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: );

Line 810: FND_MSG_PUB.ADD;

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

Line 811: FND_MSG_PUB.count_and_get(

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: );

Line 822: FND_MSG_PUB.ADD;

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

Line 823: FND_MSG_PUB.count_and_get(

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: );

Line 832: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 834: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 836: FND_MSG_PUB.count_and_get(

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: );

Line 885: FND_MSG_PUB.initialize;

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;

Line 994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,

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

Line 1002: FND_MSG_PUB.count_and_get(

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: );

Line 1011: FND_MSG_PUB.ADD;

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

Line 1012: FND_MSG_PUB.count_and_get(

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: );

Line 1022: FND_MSG_PUB.ADD;

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

Line 1023: FND_MSG_PUB.count_and_get(

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: );

Line 1031: FND_MSG_PUB.count_and_get(

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

Line 1038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 1040: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 1042: FND_MSG_PUB.count_and_get(

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:

Line 1082: FND_MSG_PUB.initialize;

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

Line 1188: FND_MSG_PUB.count_and_get(

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: );

Line 1198: FND_MSG_PUB.count_and_get(

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: );

Line 1207: FND_MSG_PUB.ADD;

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

Line 1208: FND_MSG_PUB.count_and_get(

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: );

Line 1218: FND_MSG_PUB.ADD;

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

Line 1219: FND_MSG_PUB.count_and_get(

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: );

Line 1227: FND_MSG_PUB.count_and_get(

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: );

Line 1235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 1237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 1239: FND_MSG_PUB.count_and_get(

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: );

Line 1289: FND_MSG_PUB.initialize;

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;

Line 1389: FND_MSG_PUB.count_and_get(

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: );

Line 1400: FND_MSG_PUB.count_and_get(

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: );

Line 1410: FND_MSG_PUB.ADD;

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

Line 1411: FND_MSG_PUB.count_and_get(

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: );

Line 1419: FND_MSG_PUB.count_and_get(

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: );

Line 1430: FND_MSG_PUB.ADD;

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

Line 1431: FND_MSG_PUB.count_and_get(

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: );

Line 1440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 1442: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 1444: FND_MSG_PUB.count_and_get(

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: );

Line 1492: FND_MSG_PUB.initialize;

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;

Line 1542: FND_MSG_PUB.Add;

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;

Line 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:

Line 1574: FND_MSG_PUB.count_and_get(

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: );

Line 1584: FND_MSG_PUB.count_and_get(

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: );

Line 1594: FND_MSG_PUB.ADD;

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

Line 1595: FND_MSG_PUB.count_and_get(

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: );

Line 1604: FND_MSG_PUB.count_and_get(

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: );

Line 1613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 1615: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 1617: FND_MSG_PUB.count_and_get(

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: );

Line 1657: FND_MSG_PUB.initialize;

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;

Line 1678: FND_MSG_PUB.count_and_get(

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: );

Line 1688: FND_MSG_PUB.count_and_get(

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: );

Line 1698: FND_MSG_PUB.ADD;

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

Line 1699: FND_MSG_PUB.count_and_get(

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: );

Line 1708: FND_MSG_PUB.count_and_get(

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: );

Line 1717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

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(

Line 1719: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

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,

Line 1721: FND_MSG_PUB.count_and_get(

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: );