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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_persons;

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

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

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

3858: RAISE FND_API.G_EXC_ERROR;
3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: WHEN OTHERS THEN
3862: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3863: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3864: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3865: FND_MSG_PUB.ADD;
3866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: WHEN OTHERS THEN
3862: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3863: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3864: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3865: FND_MSG_PUB.ADD;
3866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3867: END find_party_details;

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

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

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

3975: RAISE FND_API.G_EXC_ERROR;
3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3978: WHEN OTHERS THEN
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3982: FND_MSG_PUB.ADD;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3978: WHEN OTHERS THEN
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3982: FND_MSG_PUB.ADD;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END find_duplicate_parties;

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

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

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

4060: RAISE FND_API.G_EXC_ERROR;
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4063: WHEN OTHERS THEN
4064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4067: FND_MSG_PUB.ADD;
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4063: WHEN OTHERS THEN
4064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_party_sites');
4066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4067: FND_MSG_PUB.ADD;
4068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4069: END find_duplicate_party_sites;

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

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

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

4149: RAISE FND_API.G_EXC_ERROR;
4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4156: FND_MSG_PUB.ADD;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4156: FND_MSG_PUB.ADD;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158: END find_duplicate_contacts;

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

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

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

4222: RAISE FND_API.G_EXC_ERROR;
4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: WHEN OTHERS THEN
4226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4227: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: WHEN OTHERS THEN
4226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4227: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4231: END find_duplicate_contact_points;

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

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

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

4496: RAISE FND_API.G_EXC_ERROR;
4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4499: WHEN OTHERS THEN
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4503: FND_MSG_PUB.ADD;
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4499: WHEN OTHERS THEN
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4503: FND_MSG_PUB.ADD;
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505: END call_api_dynamic;

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

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

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

4730: RAISE FND_API.G_EXC_ERROR;
4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: WHEN OTHERS THEN
4734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4735: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4737: FND_MSG_PUB.ADD;
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4733: WHEN OTHERS THEN
4734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4735: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4737: FND_MSG_PUB.ADD;
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4739: END get_matching_party_sites;

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

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

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

4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4964: END get_matching_contacts;

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

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

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

5094: RAISE FND_API.G_EXC_ERROR;
5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097: WHEN OTHERS THEN
5098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5099: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5101: FND_MSG_PUB.ADD;
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5097: WHEN OTHERS THEN
5098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5099: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5101: FND_MSG_PUB.ADD;
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: END get_matching_contact_points;

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

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

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

5296: RAISE FND_API.G_EXC_ERROR;
5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5303: FND_MSG_PUB.ADD;
5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5303: FND_MSG_PUB.ADD;
5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5305: END get_score_details;

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

5298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5303: FND_MSG_PUB.ADD;
5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5305: END get_score_details;
5306:

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

5374: RAISE FND_API.G_EXC_ERROR;
5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_party_for_search;

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

5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_party_for_search;
5384:

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

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

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

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

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

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

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

5478: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
5479:
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5484: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;

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

5479:
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5484: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_ERROR;

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

5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5484: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_ERROR;
5488: END get_party_rec;

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

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

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

5534: END LOOP;
5535:
5536: EXCEPTION
5537: WHEN OTHERS THEN
5538: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5539: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5540: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5542: FND_MSG_PUB.ADD;

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

5535:
5536: EXCEPTION
5537: WHEN OTHERS THEN
5538: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5539: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5540: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;

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

5536: EXCEPTION
5537: WHEN OTHERS THEN
5538: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5539: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5540: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END get_party_site_rec;

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

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

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

5590: END LOOP;
5591:
5592: EXCEPTION
5593: WHEN OTHERS THEN
5594: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5595: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5596: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5598: FND_MSG_PUB.ADD;

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

5591:
5592: EXCEPTION
5593: WHEN OTHERS THEN
5594: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5595: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5596: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5598: FND_MSG_PUB.ADD;
5599: RAISE FND_API.G_EXC_ERROR;

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

5592: EXCEPTION
5593: WHEN OTHERS THEN
5594: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5595: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5596: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5598: FND_MSG_PUB.ADD;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END get_contact_rec;

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

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

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

5642: END LOOP;
5643:
5644: EXCEPTION
5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5648: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;

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

5643:
5644: EXCEPTION
5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5648: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_ERROR;

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

5644: EXCEPTION
5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5648: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_ERROR;
5652: END get_contact_point_rec;

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

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

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

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

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

5780: END IF;
5781: EXCEPTION
5782: WHEN OTHERS THEN
5783: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5784: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5785: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: END;

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

5781: EXCEPTION
5782: WHEN OTHERS THEN
5783: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5784: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5785: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: END;
5789:

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

5894: END IF;
5895: END LOOP;
5896: EXCEPTION
5897: WHEN OTHERS THEN
5898: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5901: FND_MSG_PUB.ADD;
5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5895: END LOOP;
5896: EXCEPTION
5897: WHEN OTHERS THEN
5898: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5901: FND_MSG_PUB.ADD;
5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5903: END;

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

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

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

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

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

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

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

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

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

6003: END IF;
6004: NULL;
6005: EXCEPTION
6006: WHEN OTHERS THEN
6007: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6008: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6010: FND_MSG_PUB.ADD;
6011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6004: NULL;
6005: EXCEPTION
6006: WHEN OTHERS THEN
6007: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6008: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6010: FND_MSG_PUB.ADD;
6011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6012: END;

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

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

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

6038: EXCEPTION
6039: WHEN FND_API.G_EXC_ERROR THEN
6040: RAISE FND_API.G_EXC_ERROR;
6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6039: WHEN FND_API.G_EXC_ERROR THEN
6040: RAISE FND_API.G_EXC_ERROR;
6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6047: END check_prim_cond;

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

6040: RAISE FND_API.G_EXC_ERROR;
6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6047: END check_prim_cond;
6048:

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

6082: NULL;
6083: END LOOP;
6084: EXCEPTION
6085: WHEN OTHERS THEN
6086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6087: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6083: END LOOP;
6084: EXCEPTION
6085: WHEN OTHERS THEN
6086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6087: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6091: END check_party_site_cond;

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

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

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

6120: NULL;
6121: END LOOP;
6122: EXCEPTION
6123: WHEN OTHERS THEN
6124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6125: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6121: END LOOP;
6122: EXCEPTION
6123: WHEN OTHERS THEN
6124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6125: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6129: END check_contact_cond;

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

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

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

6143: x_secondary:= FALSE;
6144:
6145: FOR I IN 1..p_contact_point_list.COUNT LOOP
6146: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6147: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: END LOOP;

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

6157: NULL;
6158: END LOOP;
6159: EXCEPTION
6160: WHEN OTHERS THEN
6161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6162: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6164: FND_MSG_PUB.ADD;
6165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6158: END LOOP;
6159: EXCEPTION
6160: WHEN OTHERS THEN
6161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6162: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6164: FND_MSG_PUB.ADD;
6165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6166: END check_contact_point_cond;

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

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