DBA Data[Home] [Help]

APPS.IBE_PARTY_V2PVT dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.initialize;

60:
61:
62:
63: -- initialize message list
64: FND_MSG_PUB.initialize;
65:
66:
67: -- Initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 168: FND_MSG_PUB.count_and_get(

164:
165:
166:
167: -- standard call to get message count and if count is 1, get message info
168: FND_MSG_PUB.count_and_get(
169: p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );

Line 186: FND_MSG_PUB.ADD;

182:
183:
184:
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => 'F');
190:

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

183:
184:
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => 'F');
190:
191: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 203: FND_MSG_PUB.ADD;

199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200:
201:
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.ADD;
204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
205: p_data => x_msg_data,
206: p_encoded => 'F');
207:

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

200:
201:
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.ADD;
204: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
205: p_data => x_msg_data,
206: p_encoded => 'F');
207:
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 222: FND_MSG_PUB.Add;

218:
219: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
220: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Add;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
226: p_data => x_msg_data,

Line 224: FND_MSG_PUB.Add;

220: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Add;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
226: p_data => x_msg_data,
227: p_encoded => 'F');
228:

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

221: FND_MESSAGE.Set_Token('REASON', SQLERRM);
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MSG_PUB.Add;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
226: p_data => x_msg_data,
227: p_encoded => 'F');
228:
229: --IBE_UTIL.debug('OTHER exception');

Line 308: FND_MSG_PUB.initialize;

304: END IF;
305:
306:
307: -- initialize message list
308: FND_MSG_PUB.initialize;
309:
310:
311: -- Initialize API return status to success
312: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 351: FND_MSG_PUB.ADD;

347: IBE_UTIL.debug('Inside find_organization - x_org_name : '||p_org_name);
348: END IF;
349:
350: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_EXISTS');
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: end if;
354: else
355: */

Line 409: FND_MSG_PUB.ADD;

405: IBE_UTIL.debug('Inside NOT find_organization - x_org_name : '||p_org_name);
406: END IF;
407: /* If organization does not exist then raise error */
408: FND_MESSAGE.SET_NAME('IBE','IBE_ERR_UM_ORG_NOT_FOUND');
409: FND_MSG_PUB.ADD;
410: RAISE FND_API.G_EXC_ERROR;
411: end if;
412:
413:

Line 509: FND_MSG_PUB.count_and_get(

505:
506: END IF;
507:
508: -- standard call to get message count and if count is 1, get message info
509: FND_MSG_PUB.count_and_get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );

Line 527: FND_MSG_PUB.ADD;

523:
524:
525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.ADD;
528: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
529: p_data => x_msg_data,
530: p_encoded => 'F');
531:

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

524:
525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.ADD;
528: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
529: p_data => x_msg_data,
530: p_encoded => 'F');
531:
532: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 544: FND_MSG_PUB.ADD;

540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541:
542:
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MSG_PUB.ADD;
545: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
546: p_data => x_msg_data,
547: p_encoded => 'F');
548:

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

541:
542:
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MSG_PUB.ADD;
545: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
546: p_data => x_msg_data,
547: p_encoded => 'F');
548:
549: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 563: FND_MSG_PUB.Add;

559:
560: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
561: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Add;
566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
567: p_data => x_msg_data,

Line 565: FND_MSG_PUB.Add;

561: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Add;
566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
567: p_data => x_msg_data,
568: p_encoded => 'F');
569:

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

562: FND_MESSAGE.Set_Token('REASON', SQLERRM);
563: FND_MSG_PUB.Add;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Add;
566: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
567: p_data => x_msg_data,
568: p_encoded => 'F');
569:
570: --IBE_UTIL.debug('OTHER exception');

Line 636: FND_MSG_PUB.initialize;

632:
633:
634:
635: -- initialize message list
636: FND_MSG_PUB.initialize;
637:
638:
639: -- Initialize API return status to success
640: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 779: FND_MSG_PUB.count_and_get(

775:
776:
777:
778: -- standard call to get message count and if count is 1, get message info
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 797: FND_MSG_PUB.ADD;

793:
794:
795:
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: FND_MSG_PUB.ADD;
798: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
799: p_data => x_msg_data,
800: p_encoded => 'F');
801:

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

794:
795:
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: FND_MSG_PUB.ADD;
798: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
799: p_data => x_msg_data,
800: p_encoded => 'F');
801:
802: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 814: FND_MSG_PUB.ADD;

810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
811:
812:
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: FND_MSG_PUB.ADD;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:

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

811:
812:
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: FND_MSG_PUB.ADD;
815: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
816: p_data => x_msg_data,
817: p_encoded => 'F');
818:
819: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 833: FND_MSG_PUB.Add;

829:
830: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: FND_MSG_PUB.Add;
836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
837: p_data => x_msg_data,

Line 835: FND_MSG_PUB.Add;

831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: FND_MSG_PUB.Add;
836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
837: p_data => x_msg_data,
838: p_encoded => 'F');
839:

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

832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: FND_MSG_PUB.Add;
836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
837: p_data => x_msg_data,
838: p_encoded => 'F');
839:
840: --IBE_UTIL.debug('OTHER exception');

Line 907: FND_MSG_PUB.initialize;

903:
904:
905:
906: -- initialize message list
907: FND_MSG_PUB.initialize;
908:
909:
910: -- Initialize API return status to success
911: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1018: FND_MSG_PUB.count_and_get(

1014: END IF;
1015:
1016: End if;
1017: -- standard call to get message count and if count is 1, get message info
1018: FND_MSG_PUB.count_and_get(
1019: p_encoded => FND_API.G_FALSE,
1020: p_count => x_msg_count,
1021: p_data => x_msg_data
1022: );

Line 1036: FND_MSG_PUB.ADD;

1032:
1033:
1034:
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.ADD;
1037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1038: p_data => x_msg_data,
1039: p_encoded => 'F');
1040:

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

1033:
1034:
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.ADD;
1037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1038: p_data => x_msg_data,
1039: p_encoded => 'F');
1040:
1041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1053: FND_MSG_PUB.ADD;

1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050:
1051:
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1055: p_data => x_msg_data,
1056: p_encoded => 'F');
1057:

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

1050:
1051:
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1055: p_data => x_msg_data,
1056: p_encoded => 'F');
1057:
1058: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1072: FND_MSG_PUB.Add;

1068:
1069: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1070: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Add;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1076: p_data => x_msg_data,

Line 1074: FND_MSG_PUB.Add;

1070: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Add;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1076: p_data => x_msg_data,
1077: p_encoded => 'F');
1078:

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

1071: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1072: FND_MSG_PUB.Add;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Add;
1075: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1076: p_data => x_msg_data,
1077: p_encoded => 'F');
1078:
1079: --IBE_UTIL.debug('OTHER exception');

Line 1161: FND_MSG_PUB.initialize;

1157: l_location_rec := p_location_rec;
1158: l_location_rec.created_by_module := p_created_by_module;
1159: l_location_rec.application_id := G_APPLICATION_ID;
1160: -- initialize message list
1161: FND_MSG_PUB.initialize;
1162:
1163:
1164: -- Initialize API return status to success
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1320: FND_MSG_PUB.count_and_get(

1316: END IF;
1317:
1318: End if;
1319: -- standard call to get message count and if count is 1, get message info
1320: FND_MSG_PUB.count_and_get(
1321: p_encoded => FND_API.G_FALSE,
1322: p_count => x_msg_count,
1323: p_data => x_msg_data
1324: );

Line 1338: FND_MSG_PUB.ADD;

1334:
1335:
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.ADD;
1339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1340: p_data => x_msg_data,
1341: p_encoded => 'F');
1342:

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

1335:
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: FND_MSG_PUB.ADD;
1339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1340: p_data => x_msg_data,
1341: p_encoded => 'F');
1342:
1343: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1355: FND_MSG_PUB.ADD;

1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352:
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: FND_MSG_PUB.ADD;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1357: p_data => x_msg_data,
1358: p_encoded => 'F');
1359:

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

1352:
1353:
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: FND_MSG_PUB.ADD;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1357: p_data => x_msg_data,
1358: p_encoded => 'F');
1359:
1360: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1374: FND_MSG_PUB.Add;

1370:
1371: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Add;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data,

Line 1376: FND_MSG_PUB.Add;

1372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Add;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data,
1379: p_encoded => 'F');
1380:

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

1373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1374: FND_MSG_PUB.Add;
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376: FND_MSG_PUB.Add;
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data,
1379: p_encoded => 'F');
1380:
1381: --IBE_UTIL.debug('OTHER exception');

Line 1440: FND_MSG_PUB.initialize;

1436:
1437:
1438:
1439: -- initialize message list
1440: FND_MSG_PUB.initialize;
1441: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1442: IBE_UTIL.debug('Enter Create_Contact_Points()');
1443: END IF;
1444:

Line 1568: FND_MSG_PUB.count_and_get(

1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: end if;
1566: end if;
1567: -- standard call to get message count and if count is 1, get message info
1568: FND_MSG_PUB.count_and_get(
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );

Line 1586: FND_MSG_PUB.ADD;

1582:
1583:
1584:
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: FND_MSG_PUB.ADD;
1587: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1588: p_data => x_msg_data,
1589: p_encoded => 'F');
1590:

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

1583:
1584:
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: FND_MSG_PUB.ADD;
1587: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1588: p_data => x_msg_data,
1589: p_encoded => 'F');
1590:
1591: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1603: FND_MSG_PUB.ADD;

1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600:
1601:
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603: FND_MSG_PUB.ADD;
1604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1605: p_data => x_msg_data,
1606: p_encoded => 'F');
1607:

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

1600:
1601:
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603: FND_MSG_PUB.ADD;
1604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1605: p_data => x_msg_data,
1606: p_encoded => 'F');
1607:
1608: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1622: FND_MSG_PUB.Add;

1618:
1619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1620: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: FND_MSG_PUB.Add;
1625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1626: p_data => x_msg_data,

Line 1624: FND_MSG_PUB.Add;

1620: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: FND_MSG_PUB.Add;
1625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1626: p_data => x_msg_data,
1627: p_encoded => 'F');
1628:

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

1621: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1622: FND_MSG_PUB.Add;
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: FND_MSG_PUB.Add;
1625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1626: p_data => x_msg_data,
1627: p_encoded => 'F');
1628:
1629: --IBE_UTIL.debug('OTHER exception');

Line 1682: FND_MSG_PUB.initialize;

1678: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1679: IBE_UTIL.debug('enter ibe_party_v2pvt.update_contact_preference');
1680: END IF;
1681:
1682: FND_MSG_PUB.initialize;
1683:
1684:
1685: --begin set/create contact preferences
1686: BEGIN

Line 1750: FND_MSG_PUB.count_and_get(

1746: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1747: IBE_UTIL.debug('Before FND_MSG_API.count_and_get');
1748: END IF;
1749:
1750: FND_MSG_PUB.count_and_get(
1751: p_encoded => FND_API.G_FALSE,
1752: p_count => x_msg_count,
1753: p_data => x_msg_data
1754: );

Line 1770: FND_MSG_PUB.count_and_get(

1766:
1767: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1768: IBE_UTIL.debug('Before FND_MSG_API.count_and_get in Exception');
1769: END IF;
1770: FND_MSG_PUB.count_and_get(
1771: p_encoded => FND_API.G_FALSE,
1772: p_count => x_msg_count,
1773: p_data => x_msg_data
1774: );

Line 1789: FND_MSG_PUB.count_and_get(

1785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1786: --IBE_UTIL.enable_debug();
1787:
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: FND_MSG_PUB.count_and_get(
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data
1793: );

Line 1808: FND_MSG_PUB.count_and_get(

1804:
1805:
1806:
1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1808: FND_MSG_PUB.count_and_get(
1809: p_encoded => FND_API.G_FALSE,
1810: p_count => x_msg_count,
1811: p_data => x_msg_data
1812: );

Line 1866: FND_MSG_PUB.initialize;

1862: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1863: IBE_UTIL.debug('enter ibe_party_v2pvt.update_person_language');
1864: END IF;
1865:
1866: FND_MSG_PUB.initialize;
1867:
1868:
1869: --begin unset primary language indicator
1870: BEGIN

Line 1947: FND_MSG_PUB.count_and_get(

1943:
1944:
1945:
1946: -- standard call to get message count and if count is 1, get message info
1947: FND_MSG_PUB.count_and_get(
1948: p_encoded => FND_API.G_FALSE,
1949: p_count => x_msg_count,
1950: p_data => x_msg_data
1951: );

Line 1959: FND_MSG_PUB.count_and_get(

1955: EXCEPTION
1956: WHEN FND_API.G_EXC_ERROR THEN
1957:
1958: x_return_status := FND_API.G_RET_STS_ERROR;
1959: FND_MSG_PUB.count_and_get(
1960: p_encoded => FND_API.G_FALSE,
1961: p_count => x_msg_count,
1962: p_data => x_msg_data
1963: );

Line 1976: FND_MSG_PUB.count_and_get(

1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976: FND_MSG_PUB.count_and_get(
1977: p_encoded => FND_API.G_FALSE,
1978: p_count => x_msg_count,
1979: p_data => x_msg_data
1980: );

Line 1995: FND_MSG_PUB.count_and_get(

1991:
1992:
1993: ROLLBACK TO person_language;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1995: FND_MSG_PUB.count_and_get(
1996: p_encoded => FND_API.G_FALSE,
1997: p_count => x_msg_count,
1998: p_data => x_msg_data
1999: );

Line 2061: FND_MSG_PUB.initialize;

2057: IBE_UTIL.debug('enter ibe_party_v2pvt.create_account');
2058: END IF;
2059:
2060: -- initialize message list if p_init_msg_list is set to TRUE.
2061: FND_MSG_PUB.initialize;
2062:
2063: -- Initialize API return status to success
2064: x_return_status := FND_API.G_RET_STS_SUCCESS;
2065: BEGIN

Line 2155: FND_MSG_PUB.ADD;

2151:
2152: WHEN FND_API.G_EXC_ERROR THEN
2153:
2154: x_return_status := FND_API.G_RET_STS_ERROR;
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2157: p_data => x_msg_data,
2158: p_encoded => 'F');
2159:

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

2152: WHEN FND_API.G_EXC_ERROR THEN
2153:
2154: x_return_status := FND_API.G_RET_STS_ERROR;
2155: FND_MSG_PUB.ADD;
2156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2157: p_data => x_msg_data,
2158: p_encoded => 'F');
2159:
2160: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2172: FND_MSG_PUB.ADD;

2168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2169:
2170:
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2172: FND_MSG_PUB.ADD;
2173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2174: p_data => x_msg_data,
2175: p_encoded => 'F');
2176:

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

2169:
2170:
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2172: FND_MSG_PUB.ADD;
2173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2174: p_data => x_msg_data,
2175: p_encoded => 'F');
2176:
2177: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2191: FND_MSG_PUB.Add;

2187:
2188: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2189: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Add;
2194: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2195: p_data => x_msg_data,

Line 2193: FND_MSG_PUB.Add;

2189: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Add;
2194: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2195: p_data => x_msg_data,
2196: p_encoded => 'F');
2197:

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

2190: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2191: FND_MSG_PUB.Add;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MSG_PUB.Add;
2194: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2195: p_data => x_msg_data,
2196: p_encoded => 'F');
2197:
2198: --IBE_UTIL.debug('OTHER exception');

Line 2301: FND_MSG_PUB.initialize;

2297: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2298: IBE_UTIL.debug('Begin ibe_party_v2pvt.update_party_status');
2299: END IF;
2300: -- initialize message list if p_init_msg_list is set to TRUE.
2301: FND_MSG_PUB.initialize;
2302: -- Initialize API return status to success
2303: x_return_status := FND_API.G_RET_STS_SUCCESS;
2304:
2305: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2515: FND_MSG_PUB.ADD;

2511: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2512: IBE_UTIL.debug('Expected Error');
2513: END IF;
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2517: p_data => x_msg_data,
2518: p_encoded => 'F');
2519:

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

2512: IBE_UTIL.debug('Expected Error');
2513: END IF;
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515: FND_MSG_PUB.ADD;
2516: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2517: p_data => x_msg_data,
2518: p_encoded => 'F');
2519:
2520: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2534: FND_MSG_PUB.ADD;

2530: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2531: IBE_UTIL.debug('UnExpected Error');
2532: END IF;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534: FND_MSG_PUB.ADD;
2535: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2536: p_data => x_msg_data,
2537: p_encoded => 'F');
2538:

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

2531: IBE_UTIL.debug('UnExpected Error');
2532: END IF;
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534: FND_MSG_PUB.ADD;
2535: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2536: p_data => x_msg_data,
2537: p_encoded => 'F');
2538:
2539: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 2554: FND_MSG_PUB.Add;

2550: END IF;
2551: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2552: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Add;
2557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2558: p_data => x_msg_data,

Line 2556: FND_MSG_PUB.Add;

2552: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Add;
2557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2558: p_data => x_msg_data,
2559: p_encoded => 'F');
2560:

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

2553: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2554: FND_MSG_PUB.Add;
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556: FND_MSG_PUB.Add;
2557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2558: p_data => x_msg_data,
2559: p_encoded => 'F');
2560:
2561: --IBE_UTIL.debug('OTHER exception');

Line 2821: FND_MSG_PUB.initialize;

2817: IBE_UTIL.debug('enter ibe_party_v2pvt.Save_Tca_Entities');
2818: END IF;
2819:
2820: -- initialize message list
2821: FND_MSG_PUB.initialize;
2822:
2823: -- Initialize API return status to success
2824: x_return_status := FND_API.G_RET_STS_SUCCESS;
2825:

Line 3658: FND_MSG_PUB.ADD;

3654:
3655:
3656:
3657: x_return_status := FND_API.G_RET_STS_ERROR;
3658: FND_MSG_PUB.ADD;
3659: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3660: p_data => x_msg_data,
3661: p_encoded => 'F');
3662:

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

3655:
3656:
3657: x_return_status := FND_API.G_RET_STS_ERROR;
3658: FND_MSG_PUB.ADD;
3659: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3660: p_data => x_msg_data,
3661: p_encoded => 'F');
3662:
3663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3675: FND_MSG_PUB.ADD;

3671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3672:
3673:
3674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3675: FND_MSG_PUB.ADD;
3676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3677: p_data => x_msg_data,
3678: p_encoded => 'F');
3679:

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

3672:
3673:
3674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3675: FND_MSG_PUB.ADD;
3676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3677: p_data => x_msg_data,
3678: p_encoded => 'F');
3679:
3680: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3694: FND_MSG_PUB.Add;

3690:
3691: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3692: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696: FND_MSG_PUB.Add;
3697: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3698: p_data => x_msg_data,

Line 3696: FND_MSG_PUB.Add;

3692: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696: FND_MSG_PUB.Add;
3697: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3698: p_data => x_msg_data,
3699: p_encoded => 'F');
3700:

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

3693: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3694: FND_MSG_PUB.Add;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696: FND_MSG_PUB.Add;
3697: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
3698: p_data => x_msg_data,
3699: p_encoded => 'F');
3700:
3701: --IBE_UTIL.debug('OTHER exception');