138: END LOOP;
139: ---------- exception block ---------------
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
143: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_DUP_RESULTS');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: ---------- exception block ---------------
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
143: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_DUP_RESULTS');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END;
140: EXCEPTION
141: WHEN OTHERS THEN
142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
143: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_DUP_RESULTS');
144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END;
148:
238:
239: ---------- exception block ---------------
240: EXCEPTION
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
243: FND_MESSAGE.SET_TOKEN('PROC','SANITIZE_TCA_DUP_PARTIES');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: ---------- exception block ---------------
240: EXCEPTION
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
243: FND_MESSAGE.SET_TOKEN('PROC','SANITIZE_TCA_DUP_PARTIES');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
240: EXCEPTION
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
243: FND_MESSAGE.SET_TOKEN('PROC','SANITIZE_TCA_DUP_PARTIES');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: END;
296:
297: ---------- exception block ---------------
298: EXCEPTION
299: WHEN OTHERS THEN
300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
301: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_INT_DUP_RESULTS');
302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: ---------- exception block ---------------
298: EXCEPTION
299: WHEN OTHERS THEN
300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
301: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_INT_DUP_RESULTS');
302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END;
298: EXCEPTION
299: WHEN OTHERS THEN
300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
301: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_INT_DUP_RESULTS');
302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END;
306:
413:
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
418: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_PARTY_OSRS');
419: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
418: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_PARTY_OSRS');
419: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422:
415: EXCEPTION
416: WHEN OTHERS THEN
417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
418: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_PARTY_OSRS');
419: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
420: FND_MSG_PUB.ADD;
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422:
423: END;
555: h.batch_id = p_batch_id ;
556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
560: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
561: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
562: FND_MSG_PUB.ADD;
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
560: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
561: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
562: FND_MSG_PUB.ADD;
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
557: EXCEPTION
558: WHEN OTHERS THEN
559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
560: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
561: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
562: FND_MSG_PUB.ADD;
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564:
565: END;
672: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of update for getting import table dates '||to_char(sysdate,'hh24:mi:ss'));
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
677: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_DETAIL_OSRS');
678: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
677: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_DETAIL_OSRS');
678: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681:
674: EXCEPTION
675: WHEN OTHERS THEN
676: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
677: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_DETAIL_OSRS');
678: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
679: FND_MSG_PUB.ADD;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681:
682: END;
777:
778: ---------- exception block ---------------
779: EXCEPTION
780: WHEN OTHERS THEN
781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
782: FND_MESSAGE.SET_TOKEN('PROC','REPORT_TCA_DUP_PARTIES');
783: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: ---------- exception block ---------------
779: EXCEPTION
780: WHEN OTHERS THEN
781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
782: FND_MESSAGE.SET_TOKEN('PROC','REPORT_TCA_DUP_PARTIES');
783: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786:
779: EXCEPTION
780: WHEN OTHERS THEN
781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
782: FND_MESSAGE.SET_TOKEN('PROC','REPORT_TCA_DUP_PARTIES');
783: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786:
787: END;
1032: CLOSE pt_cur;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1037: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_DUP_ID_WORKER');
1038: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1037: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_DUP_ID_WORKER');
1038: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1037: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_DUP_ID_WORKER');
1038: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041:
1042:
1075:
1076: -- exception block
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1080: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_SANITIZE_REPORT');
1081: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: -- exception block
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1080: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_SANITIZE_REPORT');
1081: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084:
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1080: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_SANITIZE_REPORT');
1081: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1082: FND_MSG_PUB.ADD;
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084:
1085:
1168: END LOOP;
1169: ---------- exception block ---------------
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1173: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_IMP_DUP_PARTIES');
1174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ---------- exception block ---------------
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1173: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_IMP_DUP_PARTIES');
1174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END;
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1173: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_IMP_DUP_PARTIES');
1174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1175: FND_MSG_PUB.ADD;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END;
1178:
1318:
1319:
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1323: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_PARTIES');
1324: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319:
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1323: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_PARTIES');
1324: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327:
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1323: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_PARTIES');
1324: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1327:
1328:
1465:
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_DETAILS');
1471: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_DETAILS');
1471: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END ;
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_DETAILS');
1471: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END ;
1475:
1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');
1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1531: FND_MSG_PUB.ADD;
1532: FND_MSG_PUB.Count_And_Get(
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');
1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1531: FND_MSG_PUB.ADD;
1532: FND_MSG_PUB.Count_And_Get(
1533: p_encoded => FND_API.G_FALSE,
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');
1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1531: FND_MSG_PUB.ADD;
1532: FND_MSG_PUB.Count_And_Get(
1533: p_encoded => FND_API.G_FALSE,
1534: p_count => x_msg_count,
1585:
1586: ---------- exception block ---------------
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1590: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_PARTY_DQM_ACTION_FLAG');
1591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1586: ---------- exception block ---------------
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1590: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_PARTY_DQM_ACTION_FLAG');
1591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: END;
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1590: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_PARTY_DQM_ACTION_FLAG');
1591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1592: FND_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594: END;
1595:
1668:
1669: ---------- exception block ---------------
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1673: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_DETAIL_DQM_ACTION_FLAG');
1674: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1669: ---------- exception block ---------------
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1673: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_DETAIL_DQM_ACTION_FLAG');
1674: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END;
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1673: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_DETAIL_DQM_ACTION_FLAG');
1674: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1677: END;
1678:
1748: h.batch_id = p_batch_id ;
1749:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1753: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
1754: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1755: FND_MSG_PUB.ADD;
1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1753: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
1754: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1755: FND_MSG_PUB.ADD;
1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1757:
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1753: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_ID');
1754: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1755: FND_MSG_PUB.ADD;
1756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1757:
1758: END;
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');
1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');
1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');
1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1792: FND_MSG_PUB.ADD;
1793: FND_MSG_PUB.Count_And_Get(
1794: p_encoded => FND_API.G_FALSE,
1795: p_count => x_msg_count,
1948:
1949:
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1953: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_DUP_PARTY_OSRS');
1954: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1949:
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1953: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_DUP_PARTY_OSRS');
1954: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: END ;
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1953: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_DUP_PARTY_OSRS');
1954: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: END ;
1958:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: -- dbms_output.put_line('err '||SQLERRM);
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');
2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2007: FND_MSG_PUB.ADD;
2008: FND_MSG_PUB.Count_And_Get(
2001: WHEN OTHERS THEN
2002: -- dbms_output.put_line('err '||SQLERRM);
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');
2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2007: FND_MSG_PUB.ADD;
2008: FND_MSG_PUB.Count_And_Get(
2009: p_encoded => FND_API.G_FALSE,
2002: -- dbms_output.put_line('err '||SQLERRM);
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');
2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2007: FND_MSG_PUB.ADD;
2008: FND_MSG_PUB.Count_And_Get(
2009: p_encoded => FND_API.G_FALSE,
2010: p_count => x_msg_count,
2049: final_process_int_dup_id(p_batch_id);
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');
2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: FND_MSG_PUB.Count_And_Get(
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');
2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: FND_MSG_PUB.Count_And_Get(
2058: p_encoded => FND_API.G_FALSE,
2051: WHEN OTHERS THEN
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');
2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: FND_MSG_PUB.Count_And_Get(
2058: p_encoded => FND_API.G_FALSE,
2059: p_count => x_msg_count,
2152: WHERE match_rule_id = p_match_rule_id;
2153:
2154: EXCEPTION
2155: WHEN NO_DATA_FOUND THEN
2156: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
2157: FND_MSG_PUB.ADD;
2158: RAISE FND_API.G_EXC_ERROR;
2159: END;
2160:
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: NULL;
2177: END;
2178: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');
2179: FND_MSG_PUB.ADD;
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: CLOSE check_null_set;
2193: WHEN OTHERS THEN
2194: NULL;
2195: END;
2196:
2197: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
2198: FND_MSG_PUB.ADD;
2199: RAISE FND_API.G_EXC_ERROR;
2200: END IF;
2201: CLOSE check_inactive;
2240: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = p_match_rule_id;
2241: COMMIT;
2242: WHEN OTHERS THEN
2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
2246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2247: FND_MSG_PUB.ADD;
2248:
2241: COMMIT;
2242: WHEN OTHERS THEN
2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
2246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2247: FND_MSG_PUB.ADD;
2248:
2249: FND_MSG_PUB.Count_And_Get(
2242: WHEN OTHERS THEN
2243:
2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
2246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2247: FND_MSG_PUB.ADD;
2248:
2249: FND_MSG_PUB.Count_And_Get(
2250: p_encoded => FND_API.G_FALSE,