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_MATCH_RULE_7 dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
97: exception
98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

675: BEGIN
676: NULL ;
677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

676: NULL ;
677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END;

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

677: EXCEPTION
678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END;
685:

Line 699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

695: BEGIN
696: NULL ;
697: EXCEPTION
698: WHEN OTHERS THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

696: NULL ;
697: EXCEPTION
698: WHEN OTHERS THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END;

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

697: EXCEPTION
698: WHEN OTHERS THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END;
705:

Line 719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

715: BEGIN
716: NULL ;
717: EXCEPTION
718: WHEN OTHERS THEN
719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

716: NULL ;
717: EXCEPTION
718: WHEN OTHERS THEN
719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END;

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

717: EXCEPTION
718: WHEN OTHERS THEN
719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END;
725:

Line 739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

735: BEGIN
736: NULL ;
737: EXCEPTION
738: WHEN OTHERS THEN
739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

736: NULL ;
737: EXCEPTION
738: WHEN OTHERS THEN
739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744: END;

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

737: EXCEPTION
738: WHEN OTHERS THEN
739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744: END;
745:

Line 808: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

804: IF NOT check_prim_cond (p_party_search_rec,
805: p_party_site_list,
806: p_contact_list,
807: p_contact_point_list) THEN
808: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1038: ELSE
1039: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1040: END IF;
1041: IF lengthb(l_party_contains_str) > 4000 THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1044: FND_MSG_PUB.ADD;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;

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

1039: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1040: END IF;
1041: IF lengthb(l_party_contains_str) > 4000 THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1044: FND_MSG_PUB.ADD;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047: IF (p_match_str = ' AND ' OR p_party_max_score

Line 1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1107: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1108: END LOOP;
1109: -- Add the search criteria to query string
1110: IF lengthb(l_contains_str) > 4000 THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1113: FND_MSG_PUB.ADD;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;

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

1108: END LOOP;
1109: -- Add the search criteria to query string
1110: IF lengthb(l_contains_str) > 4000 THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1113: FND_MSG_PUB.ADD;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: x_denorm_str := l_den_contains_str;

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

1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;

Line 1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;

Line 1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1389: END IF;
1390: exception
1391: when others then
1392: if (instrb(SQLERRM,'DRG-51030')>0) then
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: end if;

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

1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: end if;
1410: END;

Line 1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1634: output_long_strings('Restrict Sql = '||p_restrict_sql);
1635: exception
1636: when others then
1637: if (instrb(SQLERRM,'DRG-51030')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: end if;

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

1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: end if;
1655: END;

Line 1785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1781: output_long_strings('Restrict Sql = '||p_restrict_sql);
1782: exception
1783: when others then
1784: if (instrb(SQLERRM,'DRG-51030')>0) then
1785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1786: FND_MSG_PUB.ADD;
1787: RAISE FND_API.G_EXC_ERROR;
1788: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1786: FND_MSG_PUB.ADD;
1787: RAISE FND_API.G_EXC_ERROR;
1788: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1790: FND_MSG_PUB.ADD;
1791: RAISE FND_API.G_EXC_ERROR;
1792: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1790: FND_MSG_PUB.ADD;
1791: RAISE FND_API.G_EXC_ERROR;
1792: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: else
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: else
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1798: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1799: FND_MSG_PUB.ADD;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: end if;

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

1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: else
1797: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1798: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1799: FND_MSG_PUB.ADD;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: end if;
1802: END;

Line 2058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2054: output_long_strings('Restrict Sql = '||p_restrict_sql);
2055: exception
2056: when others then
2057: if (instrb(SQLERRM,'DRG-51030')>0) then
2058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: end if;

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

2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: end if;
2075: END;

Line 2324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2320: IF p_index>1 THEN
2321: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2322: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2323: END IF;
2324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2325: FND_MSG_PUB.ADD;
2326: RAISE FND_API.G_EXC_ERROR;
2327: ELSE
2328: push_eval;

Line 2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2368: IF p_index>1 THEN
2369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2370: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2371: END IF;
2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: ELSE
2376: push_eval;

Line 2445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2441: IF p_index>1 THEN
2442: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2443: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2444: END IF;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2446: FND_MSG_PUB.ADD;
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSE
2449: push_eval;

Line 2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2553: IF p_index>1 THEN
2554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2556: END IF;
2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2558: FND_MSG_PUB.ADD;
2559: RAISE FND_API.G_EXC_ERROR;
2560: ELSE
2561: push_eval;

Line 2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2664: IF p_index>1 THEN
2665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2666: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2667: END IF;
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2669: FND_MSG_PUB.ADD;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: push_eval;

Line 2812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2808: ELSE
2809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2810: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2811: END IF;
2812: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2813: FND_MSG_PUB.ADD;
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816: ELSE

Line 2820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2816: ELSE
2817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2818: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2819: END IF;
2820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2821: FND_MSG_PUB.ADD;
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824: END IF;

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

3065: RAISE FND_API.G_EXC_ERROR;
3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3072: FND_MSG_PUB.ADD;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');

3066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3072: FND_MSG_PUB.ADD;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: END find_parties;

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

3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3072: FND_MSG_PUB.ADD;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: END find_parties;
3075:

Line 3264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3260: IF p_index>1 THEN
3261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3262: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3263: END IF;
3264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3265: FND_MSG_PUB.ADD;
3266: RAISE FND_API.G_EXC_ERROR;
3267: ELSE
3268: push_eval;

Line 3312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3308: IF p_index>1 THEN
3309: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3310: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3311: END IF;
3312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3313: FND_MSG_PUB.ADD;
3314: RAISE FND_API.G_EXC_ERROR;
3315: ELSE
3316: push_eval;

Line 3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3344: and d.search_context_id = p_search_ctx_id);
3345: exception
3346: when others then
3347: if (instrb(SQLERRM,'DRG-51030')>0) then
3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: else
3356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3420: IF p_index>1 THEN
3421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3422: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3423: END IF;
3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: ELSE
3428: push_eval;

Line 3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3609: IF p_index>1 THEN
3610: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3611: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3612: END IF;
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: ELSE
3617: push_eval;

Line 3701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3697: ELSE
3698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3699: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3700: END IF;
3701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3702: FND_MSG_PUB.ADD;
3703: RAISE FND_API.G_EXC_ERROR;
3704: END IF;
3705: ELSE

Line 3709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3705: ELSE
3706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3707: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3708: END IF;
3709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3710: FND_MSG_PUB.ADD;
3711: RAISE FND_API.G_EXC_ERROR;
3712: END IF;
3713: END IF;

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

3852: RAISE FND_API.G_EXC_ERROR;
3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3859: FND_MSG_PUB.ADD;
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');

3853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3859: FND_MSG_PUB.ADD;
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: END find_persons;

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

3854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3859: FND_MSG_PUB.ADD;
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: END find_persons;
3862:

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

3920: RAISE FND_API.G_EXC_ERROR;
3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');

3921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END find_party_details;

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

3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END find_party_details;
3930:

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

4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');

4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_parties;

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

4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_parties;
4047:

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

4122: RAISE FND_API.G_EXC_ERROR;
4123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4125: WHEN OTHERS THEN
4126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4127: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4129: FND_MSG_PUB.ADD;
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4127: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');

4123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4125: WHEN OTHERS THEN
4126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4127: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4129: FND_MSG_PUB.ADD;
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END find_duplicate_party_sites;

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

4124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4125: WHEN OTHERS THEN
4126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4127: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4129: FND_MSG_PUB.ADD;
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END find_duplicate_party_sites;
4132:

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

4211: RAISE FND_API.G_EXC_ERROR;
4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4218: FND_MSG_PUB.ADD;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');

4212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4218: FND_MSG_PUB.ADD;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END find_duplicate_contacts;

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

4213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4218: FND_MSG_PUB.ADD;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END find_duplicate_contacts;
4221:

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

4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');

4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_contact_points;

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

4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_contact_points;
4294:

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

4592: RAISE FND_API.G_EXC_ERROR;
4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4599: FND_MSG_PUB.ADD;
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');

4593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4599: FND_MSG_PUB.ADD;
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: END call_api_dynamic;

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

4594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4599: FND_MSG_PUB.ADD;
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: END call_api_dynamic;
4602:

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

4830: RAISE FND_API.G_EXC_ERROR;
4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');

4831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END get_matching_party_sites;

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

4832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END get_matching_party_sites;
4840:

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

5058: RAISE FND_API.G_EXC_ERROR;
5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');

5059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END get_matching_contacts;

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

5060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END get_matching_contacts;
5068:

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

5200: RAISE FND_API.G_EXC_ERROR;
5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');

5201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5209: END get_matching_contact_points;

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

5202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5209: END get_matching_contact_points;
5210:

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

5413: RAISE FND_API.G_EXC_ERROR;
5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');

5414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END get_score_details;

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

5415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END get_score_details;
5423:

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

5523: RAISE FND_API.G_EXC_ERROR;
5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

5524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5532: END get_party_for_search;

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

5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5532: END get_party_for_search;
5533:

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

5569: RAISE FND_API.G_EXC_ERROR;
5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5576: FND_MSG_PUB.ADD;
5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

5570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5576: FND_MSG_PUB.ADD;
5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5578: END get_search_criteria;

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

5571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5576: FND_MSG_PUB.ADD;
5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5578: END get_search_criteria;
5579:

Line 5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5629: END IF;
5630:
5631: EXCEPTION
5632: WHEN OTHERS THEN
5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;

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

5630:
5631: EXCEPTION
5632: WHEN OTHERS THEN
5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;

Line 5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

5631: EXCEPTION
5632: WHEN OTHERS THEN
5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;
5639: END get_party_rec;

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

5632: WHEN OTHERS THEN
5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;
5639: END get_party_rec;
5640:

Line 5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5685: END LOOP;
5686:
5687: EXCEPTION
5688: WHEN OTHERS THEN
5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;

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

5686:
5687: EXCEPTION
5688: WHEN OTHERS THEN
5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;
5694: RAISE FND_API.G_EXC_ERROR;

Line 5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

5687: EXCEPTION
5688: WHEN OTHERS THEN
5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;
5694: RAISE FND_API.G_EXC_ERROR;
5695: END get_party_site_rec;

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

5688: WHEN OTHERS THEN
5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;
5694: RAISE FND_API.G_EXC_ERROR;
5695: END get_party_site_rec;
5696:

Line 5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5741: END LOOP;
5742:
5743: EXCEPTION
5744: WHEN OTHERS THEN
5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;

Line 5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

5742:
5743: EXCEPTION
5744: WHEN OTHERS THEN
5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;
5750: RAISE FND_API.G_EXC_ERROR;

Line 5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

5743: EXCEPTION
5744: WHEN OTHERS THEN
5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;
5750: RAISE FND_API.G_EXC_ERROR;
5751: END get_contact_rec;

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

5744: WHEN OTHERS THEN
5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;
5750: RAISE FND_API.G_EXC_ERROR;
5751: END get_contact_rec;
5752:

Line 5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

5797: END LOOP;
5798:
5799: EXCEPTION
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;

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

5798:
5799: EXCEPTION
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;

Line 5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

5799: EXCEPTION
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END get_contact_point_rec;

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

5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END get_contact_point_rec;
5808:

Line 5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

5933: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5934: END IF;
5935: EXCEPTION
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

5934: END IF;
5935: EXCEPTION
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END;

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

5935: EXCEPTION
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END;
5943:

Line 6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6051: END IF;
6052: END LOOP;
6053: EXCEPTION
6054: WHEN OTHERS THEN
6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

6052: END LOOP;
6053: EXCEPTION
6054: WHEN OTHERS THEN
6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6060: END;

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

6053: EXCEPTION
6054: WHEN OTHERS THEN
6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6060: END;
6061:

Line 6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6093: END IF;
6094: NULL;
6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6099: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6100: FND_MSG_PUB.ADD;
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

6094: NULL;
6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6099: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6100: FND_MSG_PUB.ADD;
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: END;

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

6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6099: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6100: FND_MSG_PUB.ADD;
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: END;
6103:

Line 6204: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6200: END IF;
6201: END LOOP;
6202: EXCEPTION
6203: WHEN OTHERS THEN
6204: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6205: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6207: FND_MSG_PUB.ADD;
6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6205: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

6201: END LOOP;
6202: EXCEPTION
6203: WHEN OTHERS THEN
6204: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6205: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6207: FND_MSG_PUB.ADD;
6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6209: END;

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

6202: EXCEPTION
6203: WHEN OTHERS THEN
6204: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6205: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6207: FND_MSG_PUB.ADD;
6208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6209: END;
6210:

Line 6230: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

6226: FOR I IN 1..p_contact_point_list.COUNT LOOP
6227: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6228: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6229: ) THEN
6230: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6231: FND_MSG_PUB.ADD;
6232: RAISE FND_API.G_EXC_ERROR;
6233: END IF;
6234: END LOOP;

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

6258: EXCEPTION
6259: WHEN FND_API.G_EXC_ERROR THEN
6260: RAISE FND_API.G_EXC_ERROR;
6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6265: FND_MSG_PUB.ADD;
6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

6259: WHEN FND_API.G_EXC_ERROR THEN
6260: RAISE FND_API.G_EXC_ERROR;
6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6265: FND_MSG_PUB.ADD;
6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6267: END check_prim_cond;

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

6260: RAISE FND_API.G_EXC_ERROR;
6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6265: FND_MSG_PUB.ADD;
6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6267: END check_prim_cond;
6268:

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

6313: EXIT WHEN x_secondary;
6314: END LOOP;
6315: EXCEPTION
6316: WHEN OTHERS THEN
6317: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

6314: END LOOP;
6315: EXCEPTION
6316: WHEN OTHERS THEN
6317: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6322: END check_party_site_cond;

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

6315: EXCEPTION
6316: WHEN OTHERS THEN
6317: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6322: END check_party_site_cond;
6323:

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

6360: EXIT WHEN x_secondary;
6361: END LOOP;
6362: EXCEPTION
6363: WHEN OTHERS THEN
6364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6365: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6367: FND_MSG_PUB.ADD;
6368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6365: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

6361: END LOOP;
6362: EXCEPTION
6363: WHEN OTHERS THEN
6364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6365: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6367: FND_MSG_PUB.ADD;
6368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6369: END check_contact_cond;

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

6362: EXCEPTION
6363: WHEN OTHERS THEN
6364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6365: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6367: FND_MSG_PUB.ADD;
6368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6369: END check_contact_cond;
6370:

Line 6387: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

6383: x_secondary:= FALSE;
6384:
6385: FOR I IN 1..p_contact_point_list.COUNT LOOP
6386: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6387: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_ERROR;
6390: END IF;
6391: END LOOP;

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

6406: EXIT WHEN x_secondary;
6407: END LOOP;
6408: EXCEPTION
6409: WHEN OTHERS THEN
6410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6413: FND_MSG_PUB.ADD;
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

6407: END LOOP;
6408: EXCEPTION
6409: WHEN OTHERS THEN
6410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6413: FND_MSG_PUB.ADD;
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: END check_contact_point_cond;

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

6408: EXCEPTION
6409: WHEN OTHERS THEN
6410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6413: FND_MSG_PUB.ADD;
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: END check_contact_point_cond;
6416: