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_39 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 560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

556: BEGIN
557: NULL ;
558: EXCEPTION
559: WHEN OTHERS THEN
560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
561: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

557: NULL ;
558: EXCEPTION
559: WHEN OTHERS THEN
560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
561: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END;

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

558: EXCEPTION
559: WHEN OTHERS THEN
560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
561: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END;
566:

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

576: BEGIN
577: NULL ;
578: EXCEPTION
579: WHEN OTHERS THEN
580: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
581: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

577: NULL ;
578: EXCEPTION
579: WHEN OTHERS THEN
580: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
581: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END;

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

578: EXCEPTION
579: WHEN OTHERS THEN
580: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
581: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END;
586:

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

596: BEGIN
597: NULL ;
598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
601: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

597: NULL ;
598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
601: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END;

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

598: EXCEPTION
599: WHEN OTHERS THEN
600: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
601: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END;
606:

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

616: BEGIN
617: NULL ;
618: EXCEPTION
619: WHEN OTHERS THEN
620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
621: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

617: NULL ;
618: EXCEPTION
619: WHEN OTHERS THEN
620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
621: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END;

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

618: EXCEPTION
619: WHEN OTHERS THEN
620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
621: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END;
626:

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

685: IF NOT check_prim_cond (p_party_search_rec,
686: p_party_site_list,
687: p_contact_list,
688: p_contact_point_list) THEN
689: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

902: ELSE
903: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
904: END IF;
905: IF lengthb(l_party_contains_str) > 4000 THEN
906: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
907: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
908: FND_MSG_PUB.ADD;
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;

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

903: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
904: END IF;
905: IF lengthb(l_party_contains_str) > 4000 THEN
906: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
907: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
908: FND_MSG_PUB.ADD;
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911: IF (p_match_str = ' AND ' OR p_party_max_score

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

964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
965: END LOOP;
966: -- Add the search criteria to query string
967: IF lengthb(l_contains_str) > 4000 THEN
968: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
969: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;

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

965: END LOOP;
966: -- Add the search criteria to query string
967: IF lengthb(l_contains_str) > 4000 THEN
968: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
969: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: x_denorm_str := l_den_contains_str;

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

1230: END IF;
1231: exception
1232: when others then
1233: if (instrb(SQLERRM,'DRG-51030')>0) then
1234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1235: FND_MSG_PUB.ADD;
1236: RAISE FND_API.G_EXC_ERROR;
1237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1234: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1235: FND_MSG_PUB.ADD;
1236: RAISE FND_API.G_EXC_ERROR;
1237: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1238: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: else
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: else
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: end if;

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

1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: else
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1248: FND_MSG_PUB.ADD;
1249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1250: end if;
1251: END;

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

1475: output_long_strings('Restrict Sql = '||p_restrict_sql);
1476: exception
1477: when others then
1478: if (instrb(SQLERRM,'DRG-51030')>0) then
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1484: FND_MSG_PUB.ADD;
1485: RAISE FND_API.G_EXC_ERROR;
1486: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1484: FND_MSG_PUB.ADD;
1485: RAISE FND_API.G_EXC_ERROR;
1486: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: else
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: else
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1493: FND_MSG_PUB.ADD;
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: end if;

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

1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: else
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1493: FND_MSG_PUB.ADD;
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: end if;
1496: END;

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

1622: output_long_strings('Restrict Sql = '||p_restrict_sql);
1623: exception
1624: when others then
1625: if (instrb(SQLERRM,'DRG-51030')>0) then
1626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1627: FND_MSG_PUB.ADD;
1628: RAISE FND_API.G_EXC_ERROR;
1629: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1626: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1627: FND_MSG_PUB.ADD;
1628: RAISE FND_API.G_EXC_ERROR;
1629: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: else
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: else
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1639: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1640: FND_MSG_PUB.ADD;
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: end if;

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

1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: else
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1639: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1640: FND_MSG_PUB.ADD;
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: end if;
1643: END;

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

1895: output_long_strings('Restrict Sql = '||p_restrict_sql);
1896: exception
1897: when others then
1898: if (instrb(SQLERRM,'DRG-51030')>0) then
1899: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1899: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1900: FND_MSG_PUB.ADD;
1901: RAISE FND_API.G_EXC_ERROR;
1902: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1904: FND_MSG_PUB.ADD;
1905: RAISE FND_API.G_EXC_ERROR;
1906: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: else
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: else
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: end if;

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

1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: else
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: end if;
1916: END;

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

2158: IF p_index>1 THEN
2159: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2160: 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);
2161: END IF;
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: ELSE
2166: push_eval;

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

2206: IF p_index>1 THEN
2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: 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);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSE
2214: push_eval;

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

2279: IF p_index>1 THEN
2280: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2281: 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);
2282: END IF;
2283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2284: FND_MSG_PUB.ADD;
2285: RAISE FND_API.G_EXC_ERROR;
2286: ELSE
2287: push_eval;

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

2391: IF p_index>1 THEN
2392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2393: 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);
2394: END IF;
2395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;
2398: ELSE
2399: push_eval;

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

2502: IF p_index>1 THEN
2503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2504: 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);
2505: END IF;
2506: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2507: FND_MSG_PUB.ADD;
2508: RAISE FND_API.G_EXC_ERROR;
2509: ELSE
2510: push_eval;

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

2727: ELSE
2728: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2729: 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);
2730: END IF;
2731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735: ELSE

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

2735: ELSE
2736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2737: 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);
2738: END IF;
2739: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2740: FND_MSG_PUB.ADD;
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743: END IF;

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

2941: RAISE FND_API.G_EXC_ERROR;
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');

2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2950: END find_parties;

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

2943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2944: WHEN OTHERS THEN
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2946: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2950: END find_parties;
2951:

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

3133: IF p_index>1 THEN
3134: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3135: 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);
3136: END IF;
3137: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3138: FND_MSG_PUB.ADD;
3139: RAISE FND_API.G_EXC_ERROR;
3140: ELSE
3141: push_eval;

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

3181: IF p_index>1 THEN
3182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3183: 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);
3184: END IF;
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: ELSE
3189: push_eval;

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

3217: and d.search_context_id = p_search_ctx_id);
3218: exception
3219: when others then
3220: if (instrb(SQLERRM,'DRG-51030')>0) then
3221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3222: FND_MSG_PUB.ADD;
3223: RAISE FND_API.G_EXC_ERROR;
3224: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3222: FND_MSG_PUB.ADD;
3223: RAISE FND_API.G_EXC_ERROR;
3224: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3226: FND_MSG_PUB.ADD;
3227: RAISE FND_API.G_EXC_ERROR;
3228: else
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3293: IF p_index>1 THEN
3294: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3295: 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);
3296: END IF;
3297: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3298: FND_MSG_PUB.ADD;
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSE
3301: push_eval;

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

3552: IF p_index>1 THEN
3553: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3554: 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);
3555: END IF;
3556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3557: FND_MSG_PUB.ADD;
3558: RAISE FND_API.G_EXC_ERROR;
3559: ELSE
3560: push_eval;

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

3665: ELSE
3666: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3667: 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);
3668: END IF;
3669: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;
3673: ELSE

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

3673: ELSE
3674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3675: 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);
3676: END IF;
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3678: FND_MSG_PUB.ADD;
3679: RAISE FND_API.G_EXC_ERROR;
3680: END IF;
3681: END IF;

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

3794: RAISE FND_API.G_EXC_ERROR;
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');

3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_persons;

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

3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: WHEN OTHERS THEN
3798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_persons;
3804:

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

3862: RAISE FND_API.G_EXC_ERROR;
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3869: FND_MSG_PUB.ADD;
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');

3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3869: FND_MSG_PUB.ADD;
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END find_party_details;

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

3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3869: FND_MSG_PUB.ADD;
3870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3871: END find_party_details;
3872:

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

3979: RAISE FND_API.G_EXC_ERROR;
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3986: FND_MSG_PUB.ADD;
3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');

3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3986: FND_MSG_PUB.ADD;
3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3988: END find_duplicate_parties;

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

3981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982: WHEN OTHERS THEN
3983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3984: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3986: FND_MSG_PUB.ADD;
3987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3988: END find_duplicate_parties;
3989:

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

4064: RAISE FND_API.G_EXC_ERROR;
4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');

4065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END find_duplicate_party_sites;

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

4066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END find_duplicate_party_sites;
4074:

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

4153: RAISE FND_API.G_EXC_ERROR;
4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');

4154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_contacts;

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

4155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4156: WHEN OTHERS THEN
4157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4158: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4159: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4160: FND_MSG_PUB.ADD;
4161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4162: END find_duplicate_contacts;
4163:

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

4226: RAISE FND_API.G_EXC_ERROR;
4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4232: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4233: FND_MSG_PUB.ADD;
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');

4227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4232: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4233: FND_MSG_PUB.ADD;
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END find_duplicate_contact_points;

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

4228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4229: WHEN OTHERS THEN
4230: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4231: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4232: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4233: FND_MSG_PUB.ADD;
4234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4235: END find_duplicate_contact_points;
4236:

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

4500: RAISE FND_API.G_EXC_ERROR;
4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4507: FND_MSG_PUB.ADD;
4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');

4501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4507: FND_MSG_PUB.ADD;
4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4509: END call_api_dynamic;

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

4502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4507: FND_MSG_PUB.ADD;
4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4509: END call_api_dynamic;
4510:

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

4734: RAISE FND_API.G_EXC_ERROR;
4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');

4735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_party_sites;

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

4736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_party_sites;
4744:

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

4959: RAISE FND_API.G_EXC_ERROR;
4960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4966: FND_MSG_PUB.ADD;
4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');

4960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4966: FND_MSG_PUB.ADD;
4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4968: END get_matching_contacts;

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

4961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4966: FND_MSG_PUB.ADD;
4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4968: END get_matching_contacts;
4969:

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

5098: RAISE FND_API.G_EXC_ERROR;
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');

5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: END get_matching_contact_points;

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

5100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5101: WHEN OTHERS THEN
5102: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5103: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5105: FND_MSG_PUB.ADD;
5106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5107: END get_matching_contact_points;
5108:

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

5301: RAISE FND_API.G_EXC_ERROR;
5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5308: FND_MSG_PUB.ADD;
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');

5302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5308: FND_MSG_PUB.ADD;
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: END get_score_details;

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

5303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5304: WHEN OTHERS THEN
5305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5306: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5308: FND_MSG_PUB.ADD;
5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: END get_score_details;
5311:

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

5379: RAISE FND_API.G_EXC_ERROR;
5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5386: FND_MSG_PUB.ADD;
5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5386: FND_MSG_PUB.ADD;
5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5388: END get_party_for_search;

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

5381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5386: FND_MSG_PUB.ADD;
5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5388: END get_party_for_search;
5389:

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

5419: RAISE FND_API.G_EXC_ERROR;
5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: END get_search_criteria;

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

5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: END get_search_criteria;
5429:

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

5483: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5484:
5485: EXCEPTION
5486: WHEN OTHERS THEN
5487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;

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

5484:
5485: EXCEPTION
5486: WHEN OTHERS THEN
5487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_ERROR;

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

5485: EXCEPTION
5486: WHEN OTHERS THEN
5487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_ERROR;
5493: END get_party_rec;

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

5486: WHEN OTHERS THEN
5487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_ERROR;
5493: END get_party_rec;
5494:

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

5539: END LOOP;
5540:
5541: EXCEPTION
5542: WHEN OTHERS THEN
5543: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;

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

5540:
5541: EXCEPTION
5542: WHEN OTHERS THEN
5543: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;
5548: RAISE FND_API.G_EXC_ERROR;

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

5541: EXCEPTION
5542: WHEN OTHERS THEN
5543: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;
5548: RAISE FND_API.G_EXC_ERROR;
5549: END get_party_site_rec;

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

5542: WHEN OTHERS THEN
5543: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;
5548: RAISE FND_API.G_EXC_ERROR;
5549: END get_party_site_rec;
5550:

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

5595: END LOOP;
5596:
5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;

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

5596:
5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;

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

5597: EXCEPTION
5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: END get_contact_rec;

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

5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: END get_contact_rec;
5606:

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

5647: END LOOP;
5648:
5649: EXCEPTION
5650: WHEN OTHERS THEN
5651: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;

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

5648:
5649: EXCEPTION
5650: WHEN OTHERS THEN
5651: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;

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

5649: EXCEPTION
5650: WHEN OTHERS THEN
5651: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END get_contact_point_rec;

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

5650: WHEN OTHERS THEN
5651: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END get_contact_point_rec;
5658:

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

5784: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5785: END IF;
5786: EXCEPTION
5787: WHEN OTHERS THEN
5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5791: FND_MSG_PUB.ADD;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5785: END IF;
5786: EXCEPTION
5787: WHEN OTHERS THEN
5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5791: FND_MSG_PUB.ADD;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5793: END;

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

5786: EXCEPTION
5787: WHEN OTHERS THEN
5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5791: FND_MSG_PUB.ADD;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5793: END;
5794:

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

5899: END IF;
5900: END LOOP;
5901: EXCEPTION
5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5900: END LOOP;
5901: EXCEPTION
5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;

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

5901: EXCEPTION
5902: WHEN OTHERS THEN
5903: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5904: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5906: FND_MSG_PUB.ADD;
5907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5908: END;
5909:

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

5941: END IF;
5942: NULL;
5943: EXCEPTION
5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5942: NULL;
5943: EXCEPTION
5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5950: END;

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

5943: EXCEPTION
5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5950: END;
5951:

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

6008: END IF;
6009: NULL;
6010: EXCEPTION
6011: WHEN OTHERS THEN
6012: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6013: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6009: NULL;
6010: EXCEPTION
6011: WHEN OTHERS THEN
6012: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6013: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6017: END;

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

6010: EXCEPTION
6011: WHEN OTHERS THEN
6012: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6013: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6017: END;
6018:

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

6043: EXCEPTION
6044: WHEN FND_API.G_EXC_ERROR THEN
6045: RAISE FND_API.G_EXC_ERROR;
6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6044: WHEN FND_API.G_EXC_ERROR THEN
6045: RAISE FND_API.G_EXC_ERROR;
6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6052: END check_prim_cond;

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

6045: RAISE FND_API.G_EXC_ERROR;
6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6052: END check_prim_cond;
6053:

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

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

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

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

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

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

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

6125: NULL;
6126: END LOOP;
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6126: END LOOP;
6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END check_contact_cond;

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

6127: EXCEPTION
6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END check_contact_cond;
6135:

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

6148: x_secondary:= FALSE;
6149:
6150: FOR I IN 1..p_contact_point_list.COUNT LOOP
6151: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6152: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END IF;
6156: END LOOP;

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

6162: NULL;
6163: END LOOP;
6164: EXCEPTION
6165: WHEN OTHERS THEN
6166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6167: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6169: FND_MSG_PUB.ADD;
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6163: END LOOP;
6164: EXCEPTION
6165: WHEN OTHERS THEN
6166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6167: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6169: FND_MSG_PUB.ADD;
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: END check_contact_point_cond;

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

6164: EXCEPTION
6165: WHEN OTHERS THEN
6166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6167: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6169: FND_MSG_PUB.ADD;
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: END check_contact_point_cond;
6172: