eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_ACQUIRE dependencies on FND_MESSAGE

Line 575: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');

571: WHEN OTHERS THEN
572: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Party ID: ' || p_party_id || '). Continuing ... ');
573: FND_FILE.put_line(FND_FILE.log,SQLERRM);
574: /*
575: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');
577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
579: FND_MSG_PUB.ADD;

Line 576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');

572: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Party ID: ' || p_party_id || '). Continuing ... ');
573: FND_FILE.put_line(FND_FILE.log,SQLERRM);
574: /*
575: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');
577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;

Line 577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);

573: FND_FILE.put_line(FND_FILE.log,SQLERRM);
574: /*
575: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');
577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;
581: */

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

574: /*
575: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
576: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY');
577: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
578: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;
581: */
582: END;

Line 591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');

588: WHEN FND_API.G_EXC_ERROR THEN
589: RAISE FND_API.G_EXC_ERROR;
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END;

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

589: RAISE FND_API.G_EXC_ERROR;
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
592: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_rec');
593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
594: FND_MSG_PUB.ADD;
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END;
597:

Line 819: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');

815: WHEN OTHERS THEN
816: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Party Site ID: ' || p_party_site_id || '). Continuing ... ');
817: FND_FILE.put_line(FND_FILE.log,SQLERRM);
818: /*
819: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
820: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY_SITES');
821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
822: FND_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;

Line 820: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY_SITES');

816: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Party Site ID: ' || p_party_site_id || '). Continuing ... ');
817: FND_FILE.put_line(FND_FILE.log,SQLERRM);
818: /*
819: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
820: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY_SITES');
821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
822: FND_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;
824: */

Line 821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);

817: FND_FILE.put_line(FND_FILE.log,SQLERRM);
818: /*
819: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
820: FND_MESSAGE.SET_TOKEN('ENTITY' ,'PARTY_SITES');
821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
822: FND_MSG_PUB.ADD;
823: RAISE FND_API.G_EXC_ERROR;
824: */
825: END;

Line 834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');
836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
837: FND_MSG_PUB.ADD;
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');

831: WHEN FND_API.G_EXC_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');
836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
837: FND_MSG_PUB.ADD;
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839:

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

832: RAISE FND_API.G_EXC_ERROR;
833: WHEN OTHERS THEN
834: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
835: FND_MESSAGE.SET_TOKEN('PROC' ,'get_party_site_rec');
836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
837: FND_MSG_PUB.ADD;
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839:
840: END;

Line 1072: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');

1068: WHEN OTHERS THEN
1069: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Org Contact ID: ' || p_org_contact_id || '). Continuing ... ');
1070: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1071: /*
1072: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1075: FND_MSG_PUB.ADD;
1076: RAISE FND_API.G_EXC_ERROR;

Line 1073: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT');

1069: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Org Contact ID: ' || p_org_contact_id || '). Continuing ... ');
1070: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1071: /*
1072: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1075: FND_MSG_PUB.ADD;
1076: RAISE FND_API.G_EXC_ERROR;
1077: */

Line 1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);

1070: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1071: /*
1072: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT');
1074: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1075: FND_MSG_PUB.ADD;
1076: RAISE FND_API.G_EXC_ERROR;
1077: */
1078: END;

Line 1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');
1089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1090: FND_MSG_PUB.ADD;
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');

1084: WHEN FND_API.G_EXC_ERROR THEN
1085: RAISE FND_API.G_EXC_ERROR;
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');
1089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1090: FND_MSG_PUB.ADD;
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092:

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

1085: RAISE FND_API.G_EXC_ERROR;
1086: WHEN OTHERS THEN
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1088: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_Rec');
1089: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1090: FND_MSG_PUB.ADD;
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092:
1093: END;

Line 1303: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');

1299: WHEN OTHERS THEN
1300: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Contact Point ID: ' || p_contact_point_id || '). Continuing ... ');
1301: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1302: /*
1303: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1304: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT POINTS');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;

Line 1304: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT POINTS');

1300: FND_FILE.put_line(FND_FILE.log,'Error executing custom procedure for attribute ' || l_attr_name || ' (Contact Point ID: ' || p_contact_point_id || '). Continuing ... ');
1301: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1302: /*
1303: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1304: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT POINTS');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: */

Line 1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);

1301: FND_FILE.put_line(FND_FILE.log,SQLERRM);
1302: /*
1303: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR');
1304: FND_MESSAGE.SET_TOKEN('ENTITY' ,'CONTACT POINTS');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attr_name);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: */
1309: END;

Line 1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

1315: WHEN FND_API.G_EXC_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: WHEN OTHERS THEN
1318: RAISE;
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');
1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');

1316: RAISE FND_API.G_EXC_ERROR;
1317: WHEN OTHERS THEN
1318: RAISE;
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');
1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324:

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

1317: WHEN OTHERS THEN
1318: RAISE;
1319: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
1320: FND_MESSAGE.SET_TOKEN('PROC' ,'get_contact_point_rec');
1321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1322: FND_MSG_PUB.ADD;
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324:
1325: END;

Line 1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1363: WHEN OTHERS THEN
1364: IF (sqlcode=-6502) THEN
1365: RETURN 'SYNC';--Bug 9204273
1366: END IF;
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');
1369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1370: FND_MSG_PUB.ADD;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');

1364: IF (sqlcode=-6502) THEN
1365: RETURN 'SYNC';--Bug 9204273
1366: END IF;
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');
1369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1370: FND_MSG_PUB.ADD;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END get_account_info;

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

1365: RETURN 'SYNC';--Bug 9204273
1366: END IF;
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');
1369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1370: FND_MSG_PUB.ADD;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END get_account_info;
1373:

Line 1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1398: RETURN l_party_name;
1399: END IF;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');
1404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');

1399: END IF;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');
1404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END get_known_as;

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

1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');
1404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END get_known_as;
1408:

Line 1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1435: END IF;
1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');

1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END get_address;

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

1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END get_address;
1445:

Line 1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1471: RETURN l_cname;
1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');

1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END get_contact_name;

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

1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END get_contact_name;
1481:

Line 1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1523: END IF;
1524: RETURN null;
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');
1529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');

1524: RETURN null;
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');
1529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: END get_phone_number;

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

1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');
1529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: END get_phone_number;
1533:

Line 1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

1621: WHEN OTHERS THEN
1622: IF (sqlcode=-6502) THEN
1623: return retstr;
1624: END IF;
1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');
1627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');

1622: IF (sqlcode=-6502) THEN
1623: return retstr;
1624: END IF;
1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');
1627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END get_ssm_mappings ;

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

1623: return retstr;
1624: END IF;
1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');
1627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END get_ssm_mappings ;
1631: