DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on FND_MESSAGE

Line 142: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 143: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_DUP_RESULTS');

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;

Line 144: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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:

Line 242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 243: FND_MESSAGE.SET_TOKEN('PROC','SANITIZE_TCA_DUP_PARTIES');

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:

Line 244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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;

Line 300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 301: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_INT_DUP_RESULTS');

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;

Line 302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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:

Line 417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 418: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_PARTY_OSRS');

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:

Line 419: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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;

Line 559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 560: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_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;
564:

Line 561: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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;

Line 676: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 677: FND_MESSAGE.SET_TOKEN('PROC' ,'SANITIZE_INT_DUP_DETAIL_OSRS');

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:

Line 678: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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;

Line 781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 782: FND_MESSAGE.SET_TOKEN('PROC','REPORT_TCA_DUP_PARTIES');

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:

Line 783: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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;

Line 1036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1037: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_DUP_ID_WORKER');

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:

Line 1038: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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:

Line 1079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1080: FND_MESSAGE.SET_TOKEN('PROC' ,'TCA_SANITIZE_REPORT');

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:

Line 1081: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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:

Line 1172: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1173: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_HZ_IMP_DUP_PARTIES');

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;

Line 1174: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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:

Line 1322: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1323: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_PARTIES');

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:

Line 1324: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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:

Line 1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1470: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_TCA_DUP_DETAILS');

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 ;

Line 1471: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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:

Line 1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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(

Line 1529: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_DUP_ID');

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,

Line 1530: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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,

Line 1589: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1590: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_PARTY_DQM_ACTION_FLAG');

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;

Line 1591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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:

Line 1672: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1673: FND_MESSAGE.SET_TOKEN('PROC','UPDATE_DETAIL_DQM_ACTION_FLAG');

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;

Line 1674: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

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:

Line 1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1753: FND_MESSAGE.SET_TOKEN('PROC' ,'FINAL_PROCESS_INT_TCA_DUP_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;
1757:

Line 1754: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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;

Line 1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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(

Line 1790: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_TCA_SANITIZE_REPORT');

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,

Line 1791: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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,

Line 1952: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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;

Line 1953: FND_MESSAGE.SET_TOKEN('PROC' ,'REPORT_INT_DUP_PARTY_OSRS');

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 ;

Line 1954: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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:

Line 2004: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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(

Line 2005: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_DUP_ID_WORKER');

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,

Line 2006: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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,

Line 2053: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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(

Line 2054: FND_MESSAGE.SET_TOKEN('PROC' ,'INTERFACE_SANITIZE_REPORT');

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,

Line 2055: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);

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,

Line 2156: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');

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:

Line 2178: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');

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;

Line 2197: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');

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;

Line 2244: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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:

Line 2245: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');

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(

Line 2246: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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,