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;
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: );
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:
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
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:
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
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,
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:
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');
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;
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: */
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:
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: );
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:
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
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:
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
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,
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:
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');
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;
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: );
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:
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
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:
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
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,
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:
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');
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;
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: );
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:
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
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:
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
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,
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:
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');
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;
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: );
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:
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
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:
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
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,
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:
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');
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:
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: );
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:
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
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:
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
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,
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:
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');
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
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: );
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: );
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: );
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: );
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
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: );
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: );
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: );
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: );
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
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:
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
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:
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
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,
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:
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');
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
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:
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
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:
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
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,
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:
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');
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:
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:
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
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:
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
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,
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:
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');