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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2317: IF p_index>1 THEN
2318: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2319: 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);
2320: END IF;
2321: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2322: FND_MSG_PUB.ADD;
2323: RAISE FND_API.G_EXC_ERROR;
2324: ELSE
2325: push_eval;

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

2365: IF p_index>1 THEN
2366: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2367: 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);
2368: END IF;
2369: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2370: FND_MSG_PUB.ADD;
2371: RAISE FND_API.G_EXC_ERROR;
2372: ELSE
2373: push_eval;

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

2438: IF p_index>1 THEN
2439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2440: 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);
2441: END IF;
2442: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2443: FND_MSG_PUB.ADD;
2444: RAISE FND_API.G_EXC_ERROR;
2445: ELSE
2446: push_eval;

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

2550: IF p_index>1 THEN
2551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2552: 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);
2553: END IF;
2554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2555: FND_MSG_PUB.ADD;
2556: RAISE FND_API.G_EXC_ERROR;
2557: ELSE
2558: push_eval;

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

2661: IF p_index>1 THEN
2662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2663: 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);
2664: END IF;
2665: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2666: FND_MSG_PUB.ADD;
2667: RAISE FND_API.G_EXC_ERROR;
2668: ELSE
2669: push_eval;

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

2805: ELSE
2806: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2807: 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);
2808: END IF;
2809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2810: FND_MSG_PUB.ADD;
2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813: ELSE

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

2813: ELSE
2814: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2815: 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);
2816: END IF;
2817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2818: FND_MSG_PUB.ADD;
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;
2821: END IF;

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

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

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

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

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

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

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

3256: IF p_index>1 THEN
3257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3258: 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);
3259: END IF;
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3261: FND_MSG_PUB.ADD;
3262: RAISE FND_API.G_EXC_ERROR;
3263: ELSE
3264: push_eval;

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

3304: IF p_index>1 THEN
3305: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3306: 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);
3307: END IF;
3308: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: ELSE
3312: push_eval;

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

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

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

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

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

3416: IF p_index>1 THEN
3417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3418: 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);
3419: END IF;
3420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3421: FND_MSG_PUB.ADD;
3422: RAISE FND_API.G_EXC_ERROR;
3423: ELSE
3424: push_eval;

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

3605: IF p_index>1 THEN
3606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3607: 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);
3608: END IF;
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3610: FND_MSG_PUB.ADD;
3611: RAISE FND_API.G_EXC_ERROR;
3612: ELSE
3613: push_eval;

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

3693: ELSE
3694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3695: 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);
3696: END IF;
3697: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_ERROR;
3700: END IF;
3701: ELSE

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

3701: ELSE
3702: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3703: 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);
3704: END IF;
3705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3706: FND_MSG_PUB.ADD;
3707: RAISE FND_API.G_EXC_ERROR;
3708: END IF;
3709: END IF;

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

3848: RAISE FND_API.G_EXC_ERROR;
3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3855: FND_MSG_PUB.ADD;
3856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3851: WHEN OTHERS THEN
3852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3855: FND_MSG_PUB.ADD;
3856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3857: END find_persons;

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

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

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

3916: RAISE FND_API.G_EXC_ERROR;
3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3919: WHEN OTHERS THEN
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3921: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3919: WHEN OTHERS THEN
3920: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3921: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3922: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3925: END find_party_details;

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

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

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

4033: RAISE FND_API.G_EXC_ERROR;
4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: WHEN OTHERS THEN
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4040: FND_MSG_PUB.ADD;
4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: WHEN OTHERS THEN
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4038: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4040: FND_MSG_PUB.ADD;
4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4042: END find_duplicate_parties;

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

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

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

4118: RAISE FND_API.G_EXC_ERROR;
4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4121: WHEN OTHERS THEN
4122: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4123: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4125: FND_MSG_PUB.ADD;
4126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4121: WHEN OTHERS THEN
4122: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4123: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4125: FND_MSG_PUB.ADD;
4126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4127: END find_duplicate_party_sites;

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

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

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

4207: RAISE FND_API.G_EXC_ERROR;
4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4212: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4214: FND_MSG_PUB.ADD;
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: WHEN OTHERS THEN
4211: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4212: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4214: FND_MSG_PUB.ADD;
4215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4216: END find_duplicate_contacts;

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

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

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

4280: RAISE FND_API.G_EXC_ERROR;
4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4287: FND_MSG_PUB.ADD;
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4283: WHEN OTHERS THEN
4284: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4286: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4287: FND_MSG_PUB.ADD;
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: END find_duplicate_contact_points;

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

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

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

4588: RAISE FND_API.G_EXC_ERROR;
4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: WHEN OTHERS THEN
4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4594: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4595: FND_MSG_PUB.ADD;
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: WHEN OTHERS THEN
4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4594: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4595: FND_MSG_PUB.ADD;
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: END call_api_dynamic;

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

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

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

4826: RAISE FND_API.G_EXC_ERROR;
4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: WHEN OTHERS THEN
4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: WHEN OTHERS THEN
4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: END get_matching_party_sites;

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

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

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

5054: RAISE FND_API.G_EXC_ERROR;
5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: END get_matching_contacts;

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

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

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

5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5205: END get_matching_contact_points;

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

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

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

5408: RAISE FND_API.G_EXC_ERROR;
5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5415: FND_MSG_PUB.ADD;
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5415: FND_MSG_PUB.ADD;
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: END get_score_details;

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

5410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5415: FND_MSG_PUB.ADD;
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: END get_score_details;
5418:

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

5518: RAISE FND_API.G_EXC_ERROR;
5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5527: END get_party_for_search;

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

5520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5527: END get_party_for_search;
5528:

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

5564: RAISE FND_API.G_EXC_ERROR;
5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5573: END get_search_criteria;

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

5566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5573: END get_search_criteria;
5574:

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

5624: END IF;
5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5629: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5630: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;

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

5625:
5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5629: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5630: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;

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

5626: EXCEPTION
5627: WHEN OTHERS THEN
5628: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5629: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5630: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END get_party_rec;

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

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

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

5680: END LOOP;
5681:
5682: EXCEPTION
5683: WHEN OTHERS THEN
5684: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5685: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5686: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5688: FND_MSG_PUB.ADD;

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

5681:
5682: EXCEPTION
5683: WHEN OTHERS THEN
5684: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5685: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5686: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;

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

5682: EXCEPTION
5683: WHEN OTHERS THEN
5684: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5685: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5686: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END get_party_site_rec;

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

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

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

5736: END LOOP;
5737:
5738: EXCEPTION
5739: WHEN OTHERS THEN
5740: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5741: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5742: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5744: FND_MSG_PUB.ADD;

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

5737:
5738: EXCEPTION
5739: WHEN OTHERS THEN
5740: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5741: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5742: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5744: FND_MSG_PUB.ADD;
5745: RAISE FND_API.G_EXC_ERROR;

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

5738: EXCEPTION
5739: WHEN OTHERS THEN
5740: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5741: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5742: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5744: FND_MSG_PUB.ADD;
5745: RAISE FND_API.G_EXC_ERROR;
5746: END get_contact_rec;

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

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

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

5792: END LOOP;
5793:
5794: EXCEPTION
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5797: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5798: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;

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

5793:
5794: EXCEPTION
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5797: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5798: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_ERROR;

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

5794: EXCEPTION
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5797: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5798: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_ERROR;
5802: END get_contact_point_rec;

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

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

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

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

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

5929: END IF;
5930: EXCEPTION
5931: WHEN OTHERS THEN
5932: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5933: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5937: END;

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

5930: EXCEPTION
5931: WHEN OTHERS THEN
5932: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5933: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5937: END;
5938:

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

6046: END IF;
6047: END LOOP;
6048: EXCEPTION
6049: WHEN OTHERS THEN
6050: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6051: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6053: FND_MSG_PUB.ADD;
6054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6047: END LOOP;
6048: EXCEPTION
6049: WHEN OTHERS THEN
6050: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6051: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6053: FND_MSG_PUB.ADD;
6054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6055: END;

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

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

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

6088: END IF;
6089: NULL;
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6095: FND_MSG_PUB.ADD;
6096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6089: NULL;
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6095: FND_MSG_PUB.ADD;
6096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6097: END;

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

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

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

6195: END IF;
6196: END LOOP;
6197: EXCEPTION
6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6196: END LOOP;
6197: EXCEPTION
6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6204: END;

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

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

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

6221: FOR I IN 1..p_contact_point_list.COUNT LOOP
6222: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6223: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6224: ) THEN
6225: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6226: FND_MSG_PUB.ADD;
6227: RAISE FND_API.G_EXC_ERROR;
6228: END IF;
6229: END LOOP;

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

6253: EXCEPTION
6254: WHEN FND_API.G_EXC_ERROR THEN
6255: RAISE FND_API.G_EXC_ERROR;
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6254: WHEN FND_API.G_EXC_ERROR THEN
6255: RAISE FND_API.G_EXC_ERROR;
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END check_prim_cond;

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

6255: RAISE FND_API.G_EXC_ERROR;
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END check_prim_cond;
6263:

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

6308: EXIT WHEN x_secondary;
6309: END LOOP;
6310: EXCEPTION
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6309: END LOOP;
6310: EXCEPTION
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_party_site_cond;

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

6310: EXCEPTION
6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_party_site_cond;
6318:

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

6355: EXIT WHEN x_secondary;
6356: END LOOP;
6357: EXCEPTION
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6356: END LOOP;
6357: EXCEPTION
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END check_contact_cond;

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

6357: EXCEPTION
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END check_contact_cond;
6365:

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

6378: x_secondary:= FALSE;
6379:
6380: FOR I IN 1..p_contact_point_list.COUNT LOOP
6381: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6382: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_ERROR;
6385: END IF;
6386: END LOOP;

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

6401: EXIT WHEN x_secondary;
6402: END LOOP;
6403: EXCEPTION
6404: WHEN OTHERS THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6406: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6407: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6408: FND_MSG_PUB.ADD;
6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6402: END LOOP;
6403: EXCEPTION
6404: WHEN OTHERS THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6406: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6407: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6408: FND_MSG_PUB.ADD;
6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6410: END check_contact_point_cond;

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

6403: EXCEPTION
6404: WHEN OTHERS THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6406: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6407: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6408: FND_MSG_PUB.ADD;
6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6410: END check_contact_point_cond;
6411: