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

489: BEGIN
490: NULL ;
491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

490: NULL ;
491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;

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

491: EXCEPTION
492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;
499:

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

509: BEGIN
510: NULL ;
511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

510: NULL ;
511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;

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

511: EXCEPTION
512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;
519:

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

529: BEGIN
530: NULL ;
531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

530: NULL ;
531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;

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

531: EXCEPTION
532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;
539:

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

549: BEGIN
550: NULL ;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

550: NULL ;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;

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

551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:

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

618: IF NOT check_prim_cond (p_party_search_rec,
619: p_party_site_list,
620: p_contact_list,
621: p_contact_point_list) THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

835: ELSE
836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;

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

836: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: IF (p_match_str = ' AND ' OR p_party_max_score

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

934: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;

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

935: END LOOP;
936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: x_denorm_str := l_den_contains_str;

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

1156: END IF;
1157: exception
1158: when others then
1159: if (instrb(SQLERRM,'DRG-51030')>0) then
1160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1161: FND_MSG_PUB.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1160: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1161: FND_MSG_PUB.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1164: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1165: FND_MSG_PUB.ADD;
1166: RAISE FND_API.G_EXC_ERROR;
1167: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171: else
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171: else
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: end if;

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

1169: FND_MSG_PUB.ADD;
1170: RAISE FND_API.G_EXC_ERROR;
1171: else
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: end if;
1177: END;

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

1401: output_long_strings('Restrict Sql = '||p_restrict_sql);
1402: exception
1403: when others then
1404: if (instrb(SQLERRM,'DRG-51030')>0) then
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1406: FND_MSG_PUB.ADD;
1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1406: FND_MSG_PUB.ADD;
1407: RAISE FND_API.G_EXC_ERROR;
1408: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;
1412: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1410: FND_MSG_PUB.ADD;
1411: RAISE FND_API.G_EXC_ERROR;
1412: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1414: FND_MSG_PUB.ADD;
1415: RAISE FND_API.G_EXC_ERROR;
1416: else
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1413: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1414: FND_MSG_PUB.ADD;
1415: RAISE FND_API.G_EXC_ERROR;
1416: else
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;

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

1414: FND_MSG_PUB.ADD;
1415: RAISE FND_API.G_EXC_ERROR;
1416: else
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;
1422: END;

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

1548: output_long_strings('Restrict Sql = '||p_restrict_sql);
1549: exception
1550: when others then
1551: if (instrb(SQLERRM,'DRG-51030')>0) then
1552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_ERROR;
1555: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_ERROR;
1555: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_ERROR;
1559: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_ERROR;
1559: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: else
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1560: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: else
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1566: FND_MSG_PUB.ADD;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: end if;

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

1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563: else
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1566: FND_MSG_PUB.ADD;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: end if;
1569: END;

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

1821: output_long_strings('Restrict Sql = '||p_restrict_sql);
1822: exception
1823: when others then
1824: if (instrb(SQLERRM,'DRG-51030')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1830: FND_MSG_PUB.ADD;
1831: RAISE FND_API.G_EXC_ERROR;
1832: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1833: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

1829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1830: FND_MSG_PUB.ADD;
1831: RAISE FND_API.G_EXC_ERROR;
1832: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1833: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1834: FND_MSG_PUB.ADD;
1835: RAISE FND_API.G_EXC_ERROR;
1836: else
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

1833: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1834: FND_MSG_PUB.ADD;
1835: RAISE FND_API.G_EXC_ERROR;
1836: else
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: end if;

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

1834: FND_MSG_PUB.ADD;
1835: RAISE FND_API.G_EXC_ERROR;
1836: else
1837: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1841: end if;
1842: END;

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

2082: IF p_index>1 THEN
2083: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2084: 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);
2085: END IF;
2086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2087: FND_MSG_PUB.ADD;
2088: RAISE FND_API.G_EXC_ERROR;
2089: ELSE
2090: push_eval;

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

2130: IF p_index>1 THEN
2131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2132: 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);
2133: END IF;
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: ELSE
2138: 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 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);
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 2319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

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

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

2426: IF p_index>1 THEN
2427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2428: 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);
2429: END IF;
2430: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2431: FND_MSG_PUB.ADD;
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSE
2434: push_eval;

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

2570: ELSE
2571: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2572: 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);
2573: END IF;
2574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2575: FND_MSG_PUB.ADD;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578: ELSE

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

2578: ELSE
2579: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2580: 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);
2581: END IF;
2582: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586: END IF;

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

2827: RAISE FND_API.G_EXC_ERROR;
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');

2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2836: END find_parties;

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

2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: WHEN OTHERS THEN
2831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2832: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2834: FND_MSG_PUB.ADD;
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2836: END find_parties;
2837:

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

3017: IF p_index>1 THEN
3018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3019: 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);
3020: END IF;
3021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3022: FND_MSG_PUB.ADD;
3023: RAISE FND_API.G_EXC_ERROR;
3024: ELSE
3025: push_eval;

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

3065: IF p_index>1 THEN
3066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3067: 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);
3068: END IF;
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3070: FND_MSG_PUB.ADD;
3071: RAISE FND_API.G_EXC_ERROR;
3072: ELSE
3073: push_eval;

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

3101: and d.search_context_id = p_search_ctx_id);
3102: exception
3103: when others then
3104: if (instrb(SQLERRM,'DRG-51030')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3110: FND_MSG_PUB.ADD;
3111: RAISE FND_API.G_EXC_ERROR;
3112: else
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3366: IF p_index>1 THEN
3367: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3368: 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);
3369: END IF;
3370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3371: FND_MSG_PUB.ADD;
3372: RAISE FND_API.G_EXC_ERROR;
3373: ELSE
3374: push_eval;

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

3454: ELSE
3455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3456: 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);
3457: END IF;
3458: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3459: FND_MSG_PUB.ADD;
3460: RAISE FND_API.G_EXC_ERROR;
3461: END IF;
3462: ELSE

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

3462: ELSE
3463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3464: 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);
3465: END IF;
3466: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3467: FND_MSG_PUB.ADD;
3468: RAISE FND_API.G_EXC_ERROR;
3469: END IF;
3470: END IF;

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

3609: RAISE FND_API.G_EXC_ERROR;
3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3616: FND_MSG_PUB.ADD;
3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');

3610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3616: FND_MSG_PUB.ADD;
3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3618: END find_persons;

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

3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: WHEN OTHERS THEN
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3614: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3616: FND_MSG_PUB.ADD;
3617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3618: END find_persons;
3619:

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

3677: RAISE FND_API.G_EXC_ERROR;
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3684: FND_MSG_PUB.ADD;
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');

3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3684: FND_MSG_PUB.ADD;
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: END find_party_details;

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

3679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3680: WHEN OTHERS THEN
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3684: FND_MSG_PUB.ADD;
3685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3686: END find_party_details;
3687:

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_3.find_duplicate_parties');
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_3.find_duplicate_parties');

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_3.find_duplicate_parties');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_duplicate_parties;

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_3.find_duplicate_parties');
3800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3801: FND_MSG_PUB.ADD;
3802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3803: END find_duplicate_parties;
3804:

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

3879: RAISE FND_API.G_EXC_ERROR;
3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');

3880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3888: END find_duplicate_party_sites;

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

3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3882: WHEN OTHERS THEN
3883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3884: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3886: FND_MSG_PUB.ADD;
3887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3888: END find_duplicate_party_sites;
3889:

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

3968: RAISE FND_API.G_EXC_ERROR;
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');

3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_contacts;

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

3970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3971: WHEN OTHERS THEN
3972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3973: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_contacts;
3978:

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

4041: RAISE FND_API.G_EXC_ERROR;
4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4048: FND_MSG_PUB.ADD;
4049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');

4042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4048: FND_MSG_PUB.ADD;
4049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4050: END find_duplicate_contact_points;

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

4043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4044: WHEN OTHERS THEN
4045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4048: FND_MSG_PUB.ADD;
4049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4050: END find_duplicate_contact_points;
4051:

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

4335: RAISE FND_API.G_EXC_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4342: FND_MSG_PUB.ADD;
4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');

4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4342: FND_MSG_PUB.ADD;
4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4344: END call_api_dynamic;

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

4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4342: FND_MSG_PUB.ADD;
4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4344: END call_api_dynamic;
4345:

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

4570: RAISE FND_API.G_EXC_ERROR;
4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');

4571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4579: END get_matching_party_sites;

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

4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4579: END get_matching_party_sites;
4580:

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

4798: RAISE FND_API.G_EXC_ERROR;
4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');

4799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END get_matching_contacts;

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

4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END get_matching_contacts;
4808:

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

4940: RAISE FND_API.G_EXC_ERROR;
4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');

4941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: END get_matching_contact_points;

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

4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4943: WHEN OTHERS THEN
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4945: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4947: FND_MSG_PUB.ADD;
4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: END get_matching_contact_points;
4950:

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

5140: RAISE FND_API.G_EXC_ERROR;
5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5147: FND_MSG_PUB.ADD;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');

5141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5147: FND_MSG_PUB.ADD;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5149: END get_score_details;

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

5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5147: FND_MSG_PUB.ADD;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5149: END get_score_details;
5150:

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

5215: RAISE FND_API.G_EXC_ERROR;
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5222: FND_MSG_PUB.ADD;
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5222: FND_MSG_PUB.ADD;
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5224: END get_party_for_search;

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

5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5222: FND_MSG_PUB.ADD;
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5224: END get_party_for_search;
5225:

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

5255: RAISE FND_API.G_EXC_ERROR;
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264: END get_search_criteria;

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

5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264: END get_search_criteria;
5265:

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

5315: END IF;
5316:
5317: EXCEPTION
5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;

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

5316:
5317: EXCEPTION
5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_ERROR;

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

5317: EXCEPTION
5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_ERROR;
5325: END get_party_rec;

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

5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_ERROR;
5325: END get_party_rec;
5326:

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

5367: END LOOP;
5368:
5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;

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

5368:
5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;

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

5369: EXCEPTION
5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_site_rec;

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

5370: WHEN OTHERS THEN
5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_site_rec;
5378:

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

5423: END LOOP;
5424:
5425: EXCEPTION
5426: WHEN OTHERS THEN
5427: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;

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

5424:
5425: EXCEPTION
5426: WHEN OTHERS THEN
5427: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;
5432: RAISE FND_API.G_EXC_ERROR;

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

5425: EXCEPTION
5426: WHEN OTHERS THEN
5427: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;
5432: RAISE FND_API.G_EXC_ERROR;
5433: END get_contact_rec;

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

5426: WHEN OTHERS THEN
5427: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;
5432: RAISE FND_API.G_EXC_ERROR;
5433: END get_contact_rec;
5434:

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

5479: END LOOP;
5480:
5481: EXCEPTION
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5485: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

5557: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5558: END IF;
5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5558: END IF;
5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END;

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

5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END;
5567:

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

5600: END IF;
5601: NULL;
5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5607: FND_MSG_PUB.ADD;
5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5601: NULL;
5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5607: FND_MSG_PUB.ADD;
5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5609: END;

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

5602: EXCEPTION
5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5607: FND_MSG_PUB.ADD;
5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5609: END;
5610:

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

5642: END IF;
5643: NULL;
5644: EXCEPTION
5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5649: FND_MSG_PUB.ADD;
5650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5643: NULL;
5644: EXCEPTION
5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5649: FND_MSG_PUB.ADD;
5650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5651: END;

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

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

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

5749: END IF;
5750: END LOOP;
5751: EXCEPTION
5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5750: END LOOP;
5751: EXCEPTION
5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: END;

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

5751: EXCEPTION
5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: END;
5759:

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

5776: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
5777: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
5778: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5779: ) THEN
5780: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5781: FND_MSG_PUB.ADD;
5782: RAISE FND_API.G_EXC_ERROR;
5783: END IF;
5784: END LOOP;

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

5800: EXCEPTION
5801: WHEN FND_API.G_EXC_ERROR THEN
5802: RAISE FND_API.G_EXC_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5801: WHEN FND_API.G_EXC_ERROR THEN
5802: RAISE FND_API.G_EXC_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END check_prim_cond;

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

5802: RAISE FND_API.G_EXC_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END check_prim_cond;
5810:

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

5846: EXIT WHEN x_secondary;
5847: END LOOP;
5848: EXCEPTION
5849: WHEN OTHERS THEN
5850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5851: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5853: FND_MSG_PUB.ADD;
5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5847: END LOOP;
5848: EXCEPTION
5849: WHEN OTHERS THEN
5850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5851: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5853: FND_MSG_PUB.ADD;
5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5855: END check_party_site_cond;

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

5848: EXCEPTION
5849: WHEN OTHERS THEN
5850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5851: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5853: FND_MSG_PUB.ADD;
5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5855: END check_party_site_cond;
5856:

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

5894: EXIT WHEN x_secondary;
5895: END LOOP;
5896: EXCEPTION
5897: WHEN OTHERS THEN
5898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
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','check_contact_cond');

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

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

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

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

5917: x_secondary:= FALSE;
5918:
5919: FOR I IN 1..p_contact_point_list.COUNT LOOP
5920: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5922: FND_MSG_PUB.ADD;
5923: RAISE FND_API.G_EXC_ERROR;
5924: END IF;
5925: END LOOP;

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

5941: EXIT WHEN x_secondary;
5942: END LOOP;
5943: EXCEPTION
5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
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','check_contact_point_cond');

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

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

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