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.IBE_MSITE_GRP dependencies on FND_MSG_PUB

Line 145: FND_MSG_PUB.ADD;

141: close valid_language_cur;
142: END IF;
143: FND_MESSAGE.set_name('IBE','IBE_MSITE_LANG_INVLD');
144: FND_MESSAGE.set_token('0', p_language);
145: FND_MSG_PUB.ADD;
146: -----dbms_output.put_line('invalid languages');
147: return false;
148: END valid_language;
149:

Line 184: FND_MSG_PUB.ADD;

180: close valid_orgid_cur;
181: END IF;
182: FND_MESSAGE.set_name('IBE','IBE_MSITE_ORGID_INVLD');
183: FND_MESSAGE.set_token('0', p_orgid);
184: FND_MSG_PUB.ADD;
185: --dbms_output.put_line('invalid Org id');
186: return false;
187: END valid_orgid;
188:

Line 223: FND_MSG_PUB.ADD;

219: close valid_currency_cur;
220: END IF;
221: FND_MESSAGE.set_name('IBE','IBE_MSITE_CURRENCY_INVLD');
222: FND_MESSAGE.set_token('0', p_currency);
223: FND_MSG_PUB.ADD;
224: --dbms_output.put_line('error in currency code');
225: return false;
226:
227: END valid_currency;

Line 259: FND_MSG_PUB.ADD;

255: p_partner_prclstid is null
256: then
257: FND_MESSAGE.set_name('IBE','IBE_MSITE_PRCLSTID_REQ');
258: FND_MESSAGE.set_token('CURR_CODE', p_currency);
259: FND_MSG_PUB.ADD;
260: raise FND_API.g_exc_error;
261: END IF;
262:
263: OPEN valid_currency_prclstid_cur(p_currency,p_walkin_prclstid,p_registered_prclstid,

Line 281: FND_MSG_PUB.ADD;

277: FND_MESSAGE.set_token('REG_ID' , p_registered_prclstid);
278: FND_MESSAGE.set_token('BIZ_ID' , p_bizpartner_prclstid);
279: FND_MESSAGE.set_token('PARTNER_ID' , p_partner_prclstid);
280: FND_MESSAGE.set_token('CURR_CODE',p_currency);
281: FND_MSG_PUB.ADD;
282: end if;
283:
284: return l_return_status;
285:

Line 387: FND_MSG_PUB.initialize;

383: END IF;
384:
385:
386: IF FND_API.to_boolean(p_init_msg_list) THEN
387: FND_MSG_PUB.initialize;
388: END IF;
389:
390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 438: FND_MSG_PUB.ADD;

434: p_msite_rec.enable_for_store = FND_API.g_true) or
435: p_msite_rec.enable_for_store = FND_API.g_true
436: then
437: FND_MESSAGE.set_name('IBE','IBE_MSITE_RSECID_INVLD');
438: FND_MSG_PUB.ADD;
439: raise FND_API.g_exc_error;
440: end if;
441: end if;
442:

Line 843: FND_MSG_PUB.count_and_get(

839: END IF;
840:
841: x_return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: FND_MSG_PUB.count_and_get(
844: p_encoded => FND_API.g_false,
845: p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 854: FND_MSG_PUB.count_and_get(

850:
851: WHEN FND_API.g_exc_error THEN
852: ROLLBACK TO save_msite;
853: x_return_status := FND_API.g_ret_sts_error;
854: FND_MSG_PUB.count_and_get(
855: p_encoded => FND_API.g_false,
856: p_count => x_msg_count,
857: p_data => x_msg_data
858: );

Line 864: FND_MSG_PUB.count_and_get(

860: WHEN FND_API.g_exc_unexpected_error THEN
861: ROLLBACK TO save_msite;
862: x_return_status := FND_API.g_ret_sts_unexp_error ;
863: --dbms_output.put_line('unexpected error raised');
864: FND_MSG_PUB.count_and_get(
865: p_encoded => FND_API.g_false,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );

Line 874: FND_MSG_PUB.ADD;

870: WHEN master_msite_exists_exception THEN
871: ROLLBACK TO save_msite;
872: x_return_status := FND_API.g_ret_sts_error ;
873: FND_MESSAGE.set_name('IBE','IBE_MSITE_MASTER_EXISTS');
874: FND_MSG_PUB.ADD;
875: --dbms_output.put_line('master_msite error raised');
876: FND_MSG_PUB.count_and_get(
877: p_encoded => FND_API.g_false,
878: p_count => x_msg_count,

Line 876: FND_MSG_PUB.count_and_get(

872: x_return_status := FND_API.g_ret_sts_error ;
873: FND_MESSAGE.set_name('IBE','IBE_MSITE_MASTER_EXISTS');
874: FND_MSG_PUB.ADD;
875: --dbms_output.put_line('master_msite error raised');
876: FND_MSG_PUB.count_and_get(
877: p_encoded => FND_API.g_false,
878: p_count => x_msg_count,
879: p_data => x_msg_data
880: );

Line 885: FND_MSG_PUB.count_and_get(

881:
882: WHEN store_not_exists_exception THEN
883: ROLLBACK TO save_msite;
884: x_return_status := FND_API.g_ret_sts_error ;
885: FND_MSG_PUB.count_and_get(
886: p_encoded => FND_API.g_false,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

Line 896: FND_MSG_PUB.ADD;

892: ROLLBACK TO save_msite;
893: x_return_status := FND_API.g_ret_sts_error;
894: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_ORG_REQ');
895: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
896: FND_MSG_PUB.ADD;
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data

Line 897: FND_MSG_PUB.count_and_get(

893: x_return_status := FND_API.g_ret_sts_error;
894: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_ORG_REQ');
895: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
896: FND_MSG_PUB.ADD;
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );

Line 907: FND_MSG_PUB.ADD;

903: ROLLBACK TO save_msite;
904: x_return_status := FND_API.g_ret_sts_error;
905: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_CURR_REQ');
906: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
907: FND_MSG_PUB.ADD;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data

Line 908: FND_MSG_PUB.count_and_get(

904: x_return_status := FND_API.g_ret_sts_error;
905: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_CURR_REQ');
906: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
907: FND_MSG_PUB.ADD;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );

Line 919: FND_MSG_PUB.ADD;

915: ROLLBACK TO save_msite;
916: x_return_status := FND_API.g_ret_sts_error;
917: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_LANG_REQ');
918: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.count_and_get(
921: p_encoded => FND_API.g_false,
922: p_count => x_msg_count,
923: p_data => x_msg_data

Line 920: FND_MSG_PUB.count_and_get(

916: x_return_status := FND_API.g_ret_sts_error;
917: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_LANG_REQ');
918: FND_MESSAGE.set_token('ID', p_msite_rec.msite_id);
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.count_and_get(
921: p_encoded => FND_API.g_false,
922: p_count => x_msg_count,
923: p_data => x_msg_data
924: );

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

925:
926: WHEN OTHERS THEN
927: ROLLBACK TO save_msite;
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
930: THEN
931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
932: END IF;
933: FND_MSG_PUB.count_and_get(

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

927: ROLLBACK TO save_msite;
928: x_return_status := FND_API.g_ret_sts_unexp_error ;
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
930: THEN
931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
932: END IF;
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,

Line 933: FND_MSG_PUB.count_and_get(

929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
930: THEN
931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
932: END IF;
933: FND_MSG_PUB.count_and_get(
934: p_encoded => FND_API.g_false,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );

Line 1080: FND_MSG_PUB.initialize;

1076: G_PKG_NAME) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079: IF FND_API.to_Boolean(p_init_msg_list) THEN
1080: FND_MSG_PUB.initialize;
1081: END IF;
1082: -- Initialize API return status to SUCCESS
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084:

Line 1125: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1121: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1122: IF (l_debug = 'Y') THEN
1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1124: for i in 1..l_msg_count loop
1125: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1126: IBE_UTIL.debug(l_msg_data);
1127: end loop;
1128: END IF;
1129: RAISE FND_API.G_EXC_ERROR;

Line 1134: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1130: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1131: IF (l_debug = 'Y') THEN
1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1133: for i in 1..l_msg_count loop
1134: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1135: IBE_UTIL.debug(l_msg_data);
1136: end loop;
1137: END IF;
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1187: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1183: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: IF (l_debug = 'Y') THEN
1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1186: for i in 1..l_msg_count loop
1187: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1188: IBE_UTIL.debug(l_msg_data);
1189: end loop;
1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;

Line 1196: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1193: IF (l_debug = 'Y') THEN
1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1195: for i in 1..l_msg_count loop
1196: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1197: IBE_UTIL.debug(l_msg_data);
1198: end loop;
1199: END IF;
1200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1287: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: IF (l_debug = 'Y') THEN
1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1286: for i in 1..l_msg_count loop
1287: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1288: IBE_UTIL.debug(l_msg_data);
1289: end loop;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;

Line 1296: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1292: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1293: IF (l_debug = 'Y') THEN
1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1295: for i in 1..l_msg_count loop
1296: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1297: IBE_UTIL.debug(l_msg_data);
1298: end loop;
1299: END IF;
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1320: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1316: IF (l_debug = 'Y') THEN
1317: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1318: 'Change_Msite_Info');
1319: for i in 1..l_msg_count loop
1320: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1321: IBE_UTIL.debug(l_msg_data);
1322: end loop;
1323: END IF;
1324: RAISE FND_API.G_EXC_ERROR;

Line 1330: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1326: IF (l_debug = 'Y') THEN
1327: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
1328: 'Change_Msite_Info');
1329: for i in 1..l_msg_count loop
1330: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1331: IBE_UTIL.debug(l_msg_data);
1332: end loop;
1333: END IF;
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1400: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1396: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1397: IF (l_debug = 'Y') THEN
1398: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1399: for i in 1..l_msg_count loop
1400: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1401: IBE_UTIL.debug(l_msg_data);
1402: end loop;
1403: END IF;
1404: RAISE FND_API.G_EXC_ERROR;

Line 1409: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1406: IF (l_debug = 'Y') THEN
1407: IBE_UTIL.debug('Error in IBE_Msite_Resp_Pvt.Create_Msite_Resp');
1408: for i in 1..l_msg_count loop
1409: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1410: IBE_UTIL.debug(l_msg_data);
1411: end loop;
1412: END IF;
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1457: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: IF (l_debug = 'Y') THEN
1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1456: for i in 1..l_msg_count loop
1457: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1458: IBE_UTIL.debug(l_msg_data);
1459: end loop;
1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;

Line 1466: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

1462: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1463: IF (l_debug = 'Y') THEN
1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1465: for i in 1..l_msg_count loop
1466: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1467: IBE_UTIL.debug(l_msg_data);
1468: end loop;
1469: END IF;
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1476: END IF;
1477: IF (FND_API.To_Boolean(p_commit)) THEN
1478: COMMIT WORK;
1479: END IF;
1480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1481: p_data => x_msg_data,
1482: p_encoded => 'F');
1483: IF (l_debug = 'Y') THEN
1484: IBE_UTIL.debug('duplicate_msite Ends +');

Line 1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1486: EXCEPTION
1487: WHEN FND_API.G_EXC_ERROR THEN
1488: ROLLBACK TO DUPLICATE_MSITE_SAVE;
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1491: p_data => x_msg_data,
1492: p_encoded => 'F');
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: ROLLBACK TO DUPLICATE_MSITE_SAVE;

Line 1496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1492: p_encoded => 'F');
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: ROLLBACK TO DUPLICATE_MSITE_SAVE;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1497: p_data => x_msg_data,
1498: p_encoded => 'F');
1499: WHEN OTHERS THEN
1500: ROLLBACK TO DUPLICATE_MSITE_SAVE;

Line 1505: FND_MSG_PUB.Add;

1501: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1502: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1503: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1504: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1505: FND_MSG_PUB.Add;
1506: IF (l_debug = 'Y') THEN
1507: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1509: END IF;

Line 1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1507: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1509: END IF;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1513: END IF;
1514: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1515: p_data => x_msg_data,

Line 1512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1508: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1509: END IF;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1513: END IF;
1514: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1515: p_data => x_msg_data,
1516: p_encoded => 'F');

Line 1514: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1513: END IF;
1514: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1515: p_data => x_msg_data,
1516: p_encoded => 'F');
1517: END duplicate_msite;
1518:

Line 1563: FND_MSG_PUB.initialize;

1559: END IF;
1560:
1561:
1562: IF FND_API.to_boolean(p_init_msg_list) THEN
1563: FND_MSG_PUB.initialize;
1564: END IF;
1565:
1566:
1567: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1671: end if;
1672: else
1673: raise ibe_dspmgrvalidation_grp.msite_req_exception;
1674: end if;
1675: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
1676: p_count => x_msg_count,
1677: p_data => x_msg_data
1678: );
1679: EXCEPTION

Line 1683: FND_MSG_PUB.count_and_get(

1679: EXCEPTION
1680: WHEN FND_API.g_exc_error THEN
1681: ROLLBACK TO save_msite_languages;
1682: x_return_status := FND_API.g_ret_sts_error;
1683: FND_MSG_PUB.count_and_get(
1684: p_encoded => FND_API.g_false,
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );

Line 1692: FND_MSG_PUB.ADD;

1688: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
1689: ROLLBACK TO save_msite_languages;
1690: x_return_status := FND_API.g_ret_sts_error;
1691: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1692: FND_MSG_PUB.ADD;
1693: FND_MSG_PUB.count_and_get(
1694: p_encoded => FND_API.g_false,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data

Line 1693: FND_MSG_PUB.count_and_get(

1689: ROLLBACK TO save_msite_languages;
1690: x_return_status := FND_API.g_ret_sts_error;
1691: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1692: FND_MSG_PUB.ADD;
1693: FND_MSG_PUB.count_and_get(
1694: p_encoded => FND_API.g_false,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );

Line 1703: FND_MSG_PUB.ADD;

1699: ROLLBACK TO save_msite_languages;
1700: x_return_status := FND_API.g_ret_sts_error;
1701: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_LANG_REQ');
1702: FND_MESSAGE.set_token('ID', p_msite_id);
1703: FND_MSG_PUB.ADD;
1704: FND_MSG_PUB.count_and_get(
1705: p_encoded => FND_API.g_false,
1706: p_count => x_msg_count,
1707: p_data => x_msg_data

Line 1704: FND_MSG_PUB.count_and_get(

1700: x_return_status := FND_API.g_ret_sts_error;
1701: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_LANG_REQ');
1702: FND_MESSAGE.set_token('ID', p_msite_id);
1703: FND_MSG_PUB.ADD;
1704: FND_MSG_PUB.count_and_get(
1705: p_encoded => FND_API.g_false,
1706: p_count => x_msg_count,
1707: p_data => x_msg_data
1708: );

Line 1712: FND_MSG_PUB.count_and_get(

1708: );
1709: WHEN FND_API.g_exc_unexpected_error THEN
1710: ROLLBACK TO save_msite_languages;
1711: x_return_status := FND_API.g_ret_sts_unexp_error ;
1712: FND_MSG_PUB.count_and_get(
1713: p_encoded => FND_API.g_false,
1714: p_count => x_msg_count,
1715: p_data => x_msg_data );
1716: WHEN OTHERS THEN

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

1715: p_data => x_msg_data );
1716: WHEN OTHERS THEN
1717: ROLLBACK TO save_msite_languages;
1718: x_return_status := FND_API.g_ret_sts_unexp_error ;
1719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1720: THEN
1721: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1722: END IF;
1723: FND_MSG_PUB.count_and_get(

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

1717: ROLLBACK TO save_msite_languages;
1718: x_return_status := FND_API.g_ret_sts_unexp_error ;
1719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1720: THEN
1721: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1722: END IF;
1723: FND_MSG_PUB.count_and_get(
1724: p_encoded => FND_API.g_false,
1725: p_count => x_msg_count,

Line 1723: FND_MSG_PUB.count_and_get(

1719: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1720: THEN
1721: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1722: END IF;
1723: FND_MSG_PUB.count_and_get(
1724: p_encoded => FND_API.g_false,
1725: p_count => x_msg_count,
1726: p_data => x_msg_data );
1727:

Line 1771: FND_MSG_PUB.initialize;

1767: RAISE FND_API.g_exc_unexpected_error;
1768: END IF;
1769:
1770: IF FND_API.to_boolean(p_init_msg_list) THEN
1771: FND_MSG_PUB.initialize;
1772: END IF;
1773: x_return_status := FND_API.G_RET_STS_SUCCESS;
1774: --- Check if the msite_id exists
1775: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num

Line 1936: FND_MSG_PUB.count_and_get(

1932: end if;
1933: else
1934: raise ibe_dspmgrvalidation_grp.msite_req_exception;
1935: end if;
1936: FND_MSG_PUB.count_and_get(
1937: p_encoded => FND_API.g_false,
1938: p_count => x_msg_count,
1939: p_data => x_msg_data
1940: );

Line 1946: FND_MSG_PUB.count_and_get(

1942: EXCEPTION
1943: WHEN FND_API.g_exc_error THEN
1944: ROLLBACK TO save_msite_currencies;
1945: x_return_status := FND_API.g_ret_sts_error;
1946: FND_MSG_PUB.count_and_get(
1947: p_encoded => FND_API.g_false,
1948: p_count => x_msg_count,
1949: p_data => x_msg_data
1950: );

Line 1955: FND_MSG_PUB.ADD;

1951: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
1952: ROLLBACK TO save_msite_currencies;
1953: x_return_status := FND_API.g_ret_sts_error;
1954: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1955: FND_MSG_PUB.ADD;
1956: FND_MSG_PUB.count_and_get(
1957: p_encoded => FND_API.g_false,
1958: p_count => x_msg_count,
1959: p_data => x_msg_data

Line 1956: FND_MSG_PUB.count_and_get(

1952: ROLLBACK TO save_msite_currencies;
1953: x_return_status := FND_API.g_ret_sts_error;
1954: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1955: FND_MSG_PUB.ADD;
1956: FND_MSG_PUB.count_and_get(
1957: p_encoded => FND_API.g_false,
1958: p_count => x_msg_count,
1959: p_data => x_msg_data
1960: );

Line 1966: FND_MSG_PUB.ADD;

1962: ROLLBACK TO save_msite_currencies;
1963: x_return_status := FND_API.g_ret_sts_error;
1964: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_CURR_REQ');
1965: FND_MESSAGE.set_token('ID', p_msite_id);
1966: FND_MSG_PUB.ADD;
1967: FND_MSG_PUB.count_and_get(
1968: p_encoded => FND_API.g_false,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data

Line 1967: FND_MSG_PUB.count_and_get(

1963: x_return_status := FND_API.g_ret_sts_error;
1964: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_CURR_REQ');
1965: FND_MESSAGE.set_token('ID', p_msite_id);
1966: FND_MSG_PUB.ADD;
1967: FND_MSG_PUB.count_and_get(
1968: p_encoded => FND_API.g_false,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data
1971: );

Line 1975: FND_MSG_PUB.count_and_get(

1971: );
1972: WHEN FND_API.g_exc_unexpected_error THEN
1973: ROLLBACK TO save_msite_currencies;
1974: x_return_status := FND_API.g_ret_sts_unexp_error ;
1975: FND_MSG_PUB.count_and_get(
1976: p_encoded => FND_API.g_false,
1977: p_count => x_msg_count,
1978: p_data => x_msg_data
1979: );

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

1979: );
1980: WHEN OTHERS THEN
1981: ROLLBACK TO save_msite_currencies;
1982: x_return_status := FND_API.g_ret_sts_unexp_error ;
1983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1986: END IF;
1987: FND_MSG_PUB.count_and_get(

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

1981: ROLLBACK TO save_msite_currencies;
1982: x_return_status := FND_API.g_ret_sts_unexp_error ;
1983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1986: END IF;
1987: FND_MSG_PUB.count_and_get(
1988: p_encoded => FND_API.g_false,
1989: p_count => x_msg_count,

Line 1987: FND_MSG_PUB.count_and_get(

1983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1986: END IF;
1987: FND_MSG_PUB.count_and_get(
1988: p_encoded => FND_API.g_false,
1989: p_count => x_msg_count,
1990: p_data => x_msg_data
1991: );

Line 2039: FND_MSG_PUB.initialize;

2035: END IF;
2036:
2037:
2038: IF FND_API.to_boolean(p_init_msg_list) THEN
2039: FND_MSG_PUB.initialize;
2040: END IF;
2041:
2042:
2043: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2139: FND_MSG_PUB.count_and_get(

2135: else
2136: raise ibe_dspmgrvalidation_grp.msite_req_exception;
2137: end if;
2138:
2139: FND_MSG_PUB.count_and_get(
2140: p_encoded => FND_API.g_false,
2141: p_count => x_msg_count,
2142: p_data => x_msg_data
2143: );

Line 2150: FND_MSG_PUB.count_and_get(

2146:
2147: WHEN FND_API.g_exc_error THEN
2148: ROLLBACK TO save_msite_orgids;
2149: x_return_status := FND_API.g_ret_sts_error;
2150: FND_MSG_PUB.count_and_get(
2151: p_encoded => FND_API.g_false,
2152: p_count => x_msg_count,
2153: p_data => x_msg_data
2154: );

Line 2160: FND_MSG_PUB.ADD;

2156: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2157: ROLLBACK TO save_msite_orgids;
2158: x_return_status := FND_API.g_ret_sts_error;
2159: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2160: FND_MSG_PUB.ADD;
2161: FND_MSG_PUB.count_and_get(
2162: p_encoded => FND_API.g_false,
2163: p_count => x_msg_count,
2164: p_data => x_msg_data

Line 2161: FND_MSG_PUB.count_and_get(

2157: ROLLBACK TO save_msite_orgids;
2158: x_return_status := FND_API.g_ret_sts_error;
2159: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2160: FND_MSG_PUB.ADD;
2161: FND_MSG_PUB.count_and_get(
2162: p_encoded => FND_API.g_false,
2163: p_count => x_msg_count,
2164: p_data => x_msg_data
2165: );

Line 2169: FND_MSG_PUB.count_and_get(

2165: );
2166: WHEN FND_API.g_exc_unexpected_error THEN
2167: ROLLBACK TO save_msite_orgids;
2168: x_return_status := FND_API.g_ret_sts_unexp_error ;
2169: FND_MSG_PUB.count_and_get(
2170: p_encoded => FND_API.g_false,
2171: p_count => x_msg_count,
2172: p_data => x_msg_data
2173: );

Line 2180: FND_MSG_PUB.ADD;

2176: ROLLBACK TO save_msite_orgids;
2177: x_return_status := FND_API.g_ret_sts_error;
2178: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_ORG_REQ');
2179: FND_MESSAGE.set_token('ID', p_msite_id);
2180: FND_MSG_PUB.ADD;
2181: FND_MSG_PUB.count_and_get(
2182: p_encoded => FND_API.g_false,
2183: p_count => x_msg_count,
2184: p_data => x_msg_data

Line 2181: FND_MSG_PUB.count_and_get(

2177: x_return_status := FND_API.g_ret_sts_error;
2178: FND_MESSAGE.set_name('IBE','IBE_MSITE_DEF_ORG_REQ');
2179: FND_MESSAGE.set_token('ID', p_msite_id);
2180: FND_MSG_PUB.ADD;
2181: FND_MSG_PUB.count_and_get(
2182: p_encoded => FND_API.g_false,
2183: p_count => x_msg_count,
2184: p_data => x_msg_data
2185: );

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

2186:
2187: WHEN OTHERS THEN
2188: ROLLBACK TO save_msite_orgids;
2189: x_return_status := FND_API.g_ret_sts_unexp_error ;
2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2191: THEN
2192: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2193: END IF;
2194: FND_MSG_PUB.count_and_get(

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

2188: ROLLBACK TO save_msite_orgids;
2189: x_return_status := FND_API.g_ret_sts_unexp_error ;
2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2191: THEN
2192: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2193: END IF;
2194: FND_MSG_PUB.count_and_get(
2195: p_encoded => FND_API.g_false,
2196: p_count => x_msg_count,

Line 2194: FND_MSG_PUB.count_and_get(

2190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2191: THEN
2192: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2193: END IF;
2194: FND_MSG_PUB.count_and_get(
2195: p_encoded => FND_API.g_false,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );

Line 2245: FND_MSG_PUB.initialize;

2241: END IF;
2242:
2243:
2244: IF FND_API.to_boolean(p_init_msg_list) THEN
2245: FND_MSG_PUB.initialize;
2246: END IF;
2247:
2248:
2249: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2295: FND_MSG_PUB.Add;

2291: x_msg_data => x_msg_data );
2292:
2293: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2294: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
2295: FND_MSG_PUB.Add;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2298: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
2299: FND_MSG_PUB.Add;

Line 2299: FND_MSG_PUB.Add;

2295: FND_MSG_PUB.Add;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2298: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_RESP_FL');
2299: FND_MSG_PUB.Add;
2300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2301: END IF;
2302: End Loop;
2303:

Line 2330: FND_MSG_PUB.count_and_get(

2326: END IF;
2327:
2328: x_return_status := FND_API.G_RET_STS_SUCCESS;
2329:
2330: FND_MSG_PUB.count_and_get(
2331: p_encoded => FND_API.g_false,
2332: p_count => x_msg_count,
2333: p_data => x_msg_data
2334: );

Line 2340: FND_MSG_PUB.count_and_get(

2336: EXCEPTION
2337: WHEN FND_API.g_exc_error THEN
2338: ROLLBACK TO delete_msite;
2339: x_return_status := FND_API.g_ret_sts_error;
2340: FND_MSG_PUB.count_and_get(
2341: p_encoded => FND_API.g_false,
2342: p_count => x_msg_count,
2343: p_data => x_msg_data
2344: );

Line 2350: FND_MSG_PUB.ADD;

2346: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2347: ROLLBACK TO delete_msite;
2348: x_return_status := FND_API.g_ret_sts_error;
2349: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2350: FND_MSG_PUB.ADD;
2351: FND_MSG_PUB.count_and_get(
2352: p_encoded => FND_API.g_false,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data

Line 2351: FND_MSG_PUB.count_and_get(

2347: ROLLBACK TO delete_msite;
2348: x_return_status := FND_API.g_ret_sts_error;
2349: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2350: FND_MSG_PUB.ADD;
2351: FND_MSG_PUB.count_and_get(
2352: p_encoded => FND_API.g_false,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );

Line 2360: FND_MSG_PUB.count_and_get(

2356:
2357: WHEN FND_API.g_exc_unexpected_error THEN
2358: ROLLBACK TO delete_msite;
2359: x_return_status := FND_API.g_ret_sts_unexp_error ;
2360: FND_MSG_PUB.count_and_get(
2361: p_encoded => FND_API.g_false,
2362: p_count => x_msg_count,
2363: p_data => x_msg_data
2364: );

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

2365:
2366: WHEN OTHERS THEN
2367: ROLLBACK TO delete_msite;
2368: x_return_status := FND_API.g_ret_sts_unexp_error ;
2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2370: THEN
2371: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2372: END IF;
2373: FND_MSG_PUB.count_and_get(

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

2367: ROLLBACK TO delete_msite;
2368: x_return_status := FND_API.g_ret_sts_unexp_error ;
2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2370: THEN
2371: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2372: END IF;
2373: FND_MSG_PUB.count_and_get(
2374: p_encoded => FND_API.g_false,
2375: p_count => x_msg_count,

Line 2373: FND_MSG_PUB.count_and_get(

2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2370: THEN
2371: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2372: END IF;
2373: FND_MSG_PUB.count_and_get(
2374: p_encoded => FND_API.g_false,
2375: p_count => x_msg_count,
2376: p_data => x_msg_data
2377: );

Line 2415: FND_MSG_PUB.initialize;

2411: END IF;
2412:
2413:
2414: IF FND_API.to_boolean(p_init_msg_list) THEN
2415: FND_MSG_PUB.initialize;
2416: END IF;
2417:
2418:
2419: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2436: FND_MSG_PUB.count_and_get(

2432: END IF;
2433:
2434: x_return_status := FND_API.G_RET_STS_SUCCESS;
2435:
2436: FND_MSG_PUB.count_and_get(
2437: p_encoded => FND_API.g_false,
2438: p_count => x_msg_count,
2439: p_data => x_msg_data
2440: );

Line 2446: FND_MSG_PUB.count_and_get(

2442: EXCEPTION
2443: WHEN FND_API.g_exc_error THEN
2444: ROLLBACK TO get_msite_attribute;
2445: x_return_status := FND_API.g_ret_sts_error;
2446: FND_MSG_PUB.count_and_get(
2447: p_encoded => FND_API.g_false,
2448: p_count => x_msg_count,
2449: p_data => x_msg_data
2450: );

Line 2456: FND_MSG_PUB.ADD;

2452: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2453: ROLLBACK TO get_msite_attribute;
2454: x_return_status := FND_API.g_ret_sts_error;
2455: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2456: FND_MSG_PUB.ADD;
2457: FND_MSG_PUB.count_and_get(
2458: p_encoded => FND_API.g_false,
2459: p_count => x_msg_count,
2460: p_data => x_msg_data

Line 2457: FND_MSG_PUB.count_and_get(

2453: ROLLBACK TO get_msite_attribute;
2454: x_return_status := FND_API.g_ret_sts_error;
2455: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2456: FND_MSG_PUB.ADD;
2457: FND_MSG_PUB.count_and_get(
2458: p_encoded => FND_API.g_false,
2459: p_count => x_msg_count,
2460: p_data => x_msg_data
2461: );

Line 2466: FND_MSG_PUB.count_and_get(

2462:
2463: WHEN FND_API.g_exc_unexpected_error THEN
2464: ROLLBACK TO get_msite_attribute;
2465: x_return_status := FND_API.g_ret_sts_unexp_error ;
2466: FND_MSG_PUB.count_and_get(
2467: p_encoded => FND_API.g_false,
2468: p_count => x_msg_count,
2469: p_data => x_msg_data
2470: );

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

2471:
2472: WHEN OTHERS THEN
2473: ROLLBACK TO get_msite_attribute;
2474: x_return_status := FND_API.g_ret_sts_unexp_error ;
2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2476: THEN
2477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2478: END IF;
2479: FND_MSG_PUB.count_and_get(

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

2473: ROLLBACK TO get_msite_attribute;
2474: x_return_status := FND_API.g_ret_sts_unexp_error ;
2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2476: THEN
2477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2478: END IF;
2479: FND_MSG_PUB.count_and_get(
2480: p_encoded => FND_API.g_false,
2481: p_count => x_msg_count,

Line 2479: FND_MSG_PUB.count_and_get(

2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2476: THEN
2477: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2478: END IF;
2479: FND_MSG_PUB.count_and_get(
2480: p_encoded => FND_API.g_false,
2481: p_count => x_msg_count,
2482: p_data => x_msg_data
2483: );