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 1366: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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