APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_MESSAGE

Line 543: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');

539: WHERE match_rule_id = l_rule_id;
540:
541: EXCEPTION
542: WHEN NO_DATA_FOUND THEN
543: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_NO_RULE');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END;
547:

Line 555: FND_MESSAGE.SET_NAME('AR', 'HZ_RULE_SET_UNCOMP_RULE_EXISTS');

551:
552: --Start of Code Change for Match Rule Set
553: IF (l_match_rule_type = 'SET') THEN
554: IF (has_uncompiled_childern(l_rule_id)) THEN
555: FND_MESSAGE.SET_NAME('AR', 'HZ_RULE_SET_UNCOMP_RULE_EXISTS');
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559: --Populate the match rule set primary and secondary attributes

Line 589: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');

585: EXCEPTION
586: WHEN OTHERS THEN
587: NULL;
588: END;
589: fnd_message.set_name('AR','HZ_SCORING_NO_ACQUISITION');
590: FND_MSG_PUB.ADD;
591: RAISE FND_API.G_EXC_ERROR;
592: END IF;
593: CLOSE check_null_set;

Line 607: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');

603: WHEN OTHERS THEN
604: NULL;
605: END;
606:
607: fnd_message.set_name('AR','HZ_MR_HAS_INACTIVE_TX');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: CLOSE check_inactive;

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

687: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
688: COMMIT;
689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:

Line 692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');

688: COMMIT;
689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:
696: FND_MSG_PUB.Count_And_Get(

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

689: WHEN OTHERS THEN
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
692: FND_MESSAGE.SET_TOKEN('PROC','compile_match_rule');
693: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
694: FND_MSG_PUB.ADD;
695:
696: FND_MSG_PUB.Count_And_Get(
697: p_encoded => FND_API.G_FALSE,

Line 840: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

836: l(' -- Find the match rule');
837: l(' null;');
838: l('');
839: l(' -- No MATCH RULE FOUND');
840: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
841: l(' FND_MSG_PUB.ADD;');
842: l(' RAISE FND_API.G_EXC_ERROR;');
843: l(' END IF;');
844:

Line 848: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

844:
845: l(' OPEN c_match_rule;');
846: l(' FETCH c_match_rule INTO l_cmp_flag;');
847: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
848: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
849: l(' FND_MSG_PUB.ADD;');
850: l(' RAISE FND_API.G_EXC_ERROR;');
851: l(' END IF;');
852:

Line 867: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

863: ELSE
864: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
865: END IF;
866: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
867: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
868: l(' FND_MSG_PUB.ADD;');
869: l(' RAISE FND_API.G_EXC_ERROR;');
870: l(' END IF;');
871:

Line 926: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

922: l(' -- Find the match rule');
923: l(' null;');
924: l('');
925: l(' -- No MATCH RULE FOUND');
926: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
927: l(' FND_MSG_PUB.ADD;');
928: l(' RAISE FND_API.G_EXC_ERROR;');
929: l(' END IF;');
930:

Line 934: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

930:
931: l(' OPEN c_match_rule;');
932: l(' FETCH c_match_rule INTO l_cmp_flag;');
933: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
934: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
935: l(' FND_MSG_PUB.ADD;');
936: l(' RAISE FND_API.G_EXC_ERROR;');
937: l(' END IF;');
938: ---Bug:5261867, additional parameter null in place of p_search_merged

Line 959: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

955: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
956: END IF;
957: IF check_proc(RULE.MATCH_RULE_ID) THEN
958: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
959: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
960: l(' FND_MSG_PUB.ADD;');
961: l(' RAISE FND_API.G_EXC_ERROR;');
962: l(' END IF;');
963: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_persons(');

Line 967: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

963: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_persons(');
964: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');
965: l(' p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,''N'',x_search_ctx_id,x_num_matches);');
966: ELSE
967: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
968: l(' FND_MSG_PUB.ADD;');
969: l(' RAISE FND_API.G_EXC_ERROR;');
970: END IF;
971:

Line 1046: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1042: l(' -- Find the match rule');
1043: l(' null;');
1044: l('');
1045: l(' -- No MATCH RULE FOUND');
1046: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1047: l(' FND_MSG_PUB.ADD;');
1048: l(' RAISE FND_API.G_EXC_ERROR;');
1049: l(' END IF;');
1050:

Line 1054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1050:
1051: l(' OPEN c_match_rule;');
1052: l(' FETCH c_match_rule INTO l_cmp_flag;');
1053: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1055: l(' FND_MSG_PUB.ADD;');
1056: l(' RAISE FND_API.G_EXC_ERROR;');
1057: l(' END IF;');
1058:

Line 1073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1069: ELSE
1070: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1071: END IF;
1072: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1074: l(' FND_MSG_PUB.ADD;');
1075: l(' RAISE FND_API.G_EXC_ERROR;');
1076: l(' END IF;');
1077:

Line 1125: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1121: l(' -- Find the match rule');
1122: l(' null;');
1123: l('');
1124: l(' -- No MATCH RULE FOUND');
1125: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1126: l(' FND_MSG_PUB.ADD;');
1127: l(' RAISE FND_API.G_EXC_ERROR;');
1128: l(' END IF;');
1129:

Line 1134: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1130: l(' IF g_last_rule<>p_rule_id OR NOT g_last_rule_valid THEN');
1131: l(' OPEN c_match_rule;');
1132: l(' FETCH c_match_rule INTO l_cmp_flag;');
1133: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1134: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1135: l(' FND_MSG_PUB.ADD;');
1136: l(' RAISE FND_API.G_EXC_ERROR;');
1137: l(' END IF;');
1138: l(' g_last_rule := p_rule_id;');

Line 1156: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1152: ELSE
1153: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1154: END IF;
1155: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1156: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1157: l(' FND_MSG_PUB.ADD;');
1158: l(' RAISE FND_API.G_EXC_ERROR;');
1159: l(' END IF;');
1160:

Line 1209: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1205: l(' -- Find the match rule');
1206: l(' null;');
1207: l('');
1208: l(' -- No MATCH RULE FOUND');
1209: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1210: l(' FND_MSG_PUB.ADD;');
1211: l(' RAISE FND_API.G_EXC_ERROR;');
1212: l(' END IF;');
1213:

Line 1217: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1213:
1214: l(' OPEN c_match_rule;');
1215: l(' FETCH c_match_rule INTO l_cmp_flag;');
1216: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1217: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1218: l(' FND_MSG_PUB.ADD;');
1219: l(' RAISE FND_API.G_EXC_ERROR;');
1220: l(' END IF;');
1221:

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

1232: ELSE
1233: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1234: END IF;
1235: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1236: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1237: l(' FND_MSG_PUB.ADD;');
1238: l(' RAISE FND_API.G_EXC_ERROR;');
1239: l(' END IF;');
1240:

Line 1288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1284: l(' -- Find the match rule');
1285: l(' null;');
1286: l('');
1287: l(' -- No MATCH RULE FOUND');
1288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1289: l(' FND_MSG_PUB.ADD;');
1290: l(' RAISE FND_API.G_EXC_ERROR;');
1291: l(' END IF;');
1292:

Line 1296: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1292:
1293: l(' OPEN c_match_rule;');
1294: l(' FETCH c_match_rule INTO l_cmp_flag;');
1295: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1296: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1297: l(' FND_MSG_PUB.ADD;');
1298: l(' RAISE FND_API.G_EXC_ERROR;');
1299: l(' END IF;');
1300:

Line 1315: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1311: ELSE
1312: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1313: END IF;
1314: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1315: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1316: l(' FND_MSG_PUB.ADD;');
1317: l(' RAISE FND_API.G_EXC_ERROR;');
1318: l(' END IF;');
1319:

Line 1367: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1363: l(' -- Find the match rule');
1364: l(' null;');
1365: l('');
1366: l(' -- No MATCH RULE FOUND');
1367: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1368: l(' FND_MSG_PUB.ADD;');
1369: l(' RAISE FND_API.G_EXC_ERROR;');
1370: l(' END IF;');
1371:

Line 1375: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1371:
1372: l(' OPEN c_match_rule;');
1373: l(' FETCH c_match_rule INTO l_cmp_flag;');
1374: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1375: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1376: l(' FND_MSG_PUB.ADD;');
1377: l(' RAISE FND_API.G_EXC_ERROR;');
1378: l(' END IF;');
1379:

Line 1394: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1390: ELSE
1391: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1392: END IF;
1393: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1394: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1395: l(' FND_MSG_PUB.ADD;');
1396: l(' RAISE FND_API.G_EXC_ERROR;');
1397: l(' END IF;');
1398:

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

1481: l(' -- Find the match rule');
1482: l(' null;');
1483: l('');
1484: l(' -- No MATCH RULE FOUND');
1485: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1486: l(' FND_MSG_PUB.ADD;');
1487: l(' RAISE FND_API.G_EXC_ERROR;');
1488: l(' END IF;');
1489:

Line 1493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1489:
1490: l(' OPEN c_match_rule;');
1491: l(' FETCH c_match_rule INTO l_cmp_flag;');
1492: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1494: l(' FND_MSG_PUB.ADD;');
1495: l(' RAISE FND_API.G_EXC_ERROR;');
1496: l(' END IF;');
1497:

Line 1512: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1508: ELSE
1509: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1510: END IF;
1511: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1512: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1513: l(' FND_MSG_PUB.ADD;');
1514: l(' RAISE FND_API.G_EXC_ERROR;');
1515: l(' END IF;');
1516:

Line 1612: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1608: l(' -- Find the match rule');
1609: l(' null;');
1610: l('');
1611: l(' -- No MATCH RULE FOUND');
1612: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1613: l(' FND_MSG_PUB.ADD;');
1614: l(' RAISE FND_API.G_EXC_ERROR;');
1615: l(' END IF;');
1616:

Line 1620: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1616:
1617: l(' OPEN c_match_rule;');
1618: l(' FETCH c_match_rule INTO l_cmp_flag;');
1619: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1620: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1621: l(' FND_MSG_PUB.ADD;');
1622: l(' RAISE FND_API.G_EXC_ERROR;');
1623: l(' END IF;');
1624:

Line 1647: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1643: END IF;
1644: IF check_proc(RULE.MATCH_RULE_ID) THEN
1645:
1646: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1647: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1648: l(' FND_MSG_PUB.ADD;');
1649: l(' RAISE FND_API.G_EXC_ERROR;');
1650: l(' END IF;');
1651:

Line 1664: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1660: l(' p_attrib_val11,p_attrib_val12,p_attrib_val13,p_attrib_val14,p_attrib_val15,');
1661: l(' p_attrib_val16,p_attrib_val17,p_attrib_val18,p_attrib_val19,p_attrib_val20,');
1662: l(' p_restrict_sql,p_api_name,p_match_type,p_party_id,p_search_merged,x_search_ctx_id,x_num_matches);');
1663: ELSE
1664: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1665: l(' FND_MSG_PUB.ADD;');
1666: l(' RAISE FND_API.G_EXC_ERROR;');
1667: END IF;
1668:

Line 1740: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1736: l(' END IF;');
1737: l('');
1738: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1739: l(' -- No MATCH RULE FOUND');
1740: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1741: l(' FND_MSG_PUB.ADD;');
1742: l(' RAISE FND_API.G_EXC_ERROR;');
1743: l(' END IF;');
1744:

Line 1748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1744:
1745: l(' OPEN c_match_rule;');
1746: l(' FETCH c_match_rule INTO l_cmp_flag;');
1747: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1749: l(' FND_MSG_PUB.ADD;');
1750: l(' RAISE FND_API.G_EXC_ERROR;');
1751: l(' END IF;');
1752:

Line 1767: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1763: ELSE
1764: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1765: END IF;
1766: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1767: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1768: l(' FND_MSG_PUB.ADD;');
1769: l(' RAISE FND_API.G_EXC_ERROR;');
1770: l(' END IF;');
1771: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_party_sites(');

Line 1843: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1839: l(' END IF;');
1840: l('');
1841: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1842: l(' -- No MATCH RULE FOUND');
1843: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1844: l(' FND_MSG_PUB.ADD;');
1845: l(' RAISE FND_API.G_EXC_ERROR;');
1846: l(' END IF;');
1847:

Line 1851: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1847:
1848: l(' OPEN c_match_rule;');
1849: l(' FETCH c_match_rule INTO l_cmp_flag;');
1850: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1851: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1852: l(' FND_MSG_PUB.ADD;');
1853: l(' RAISE FND_API.G_EXC_ERROR;');
1854: l(' END IF;');
1855:

Line 1870: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1866: ELSE
1867: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1868: END IF;
1869: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1870: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1871: l(' FND_MSG_PUB.ADD;');
1872: l(' RAISE FND_API.G_EXC_ERROR;');
1873: l(' END IF;');
1874: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contacts(');

Line 1942: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

1938: l(' END IF;');
1939: l('');
1940: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1941: l(' -- No MATCH RULE FOUND');
1942: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
1943: l(' FND_MSG_PUB.ADD;');
1944: l(' RAISE FND_API.G_EXC_ERROR;');
1945: l(' END IF;');
1946:

Line 1950: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

1946:
1947: l(' OPEN c_match_rule;');
1948: l(' FETCH c_match_rule INTO l_cmp_flag;');
1949: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
1950: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
1951: l(' FND_MSG_PUB.ADD;');
1952: l(' RAISE FND_API.G_EXC_ERROR;');
1953: l(' END IF;');
1954:

Line 1969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

1965: ELSE
1966: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
1967: END IF;
1968: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
1969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
1970: l(' FND_MSG_PUB.ADD;');
1971: l(' RAISE FND_API.G_EXC_ERROR;');
1972: l(' END IF;');
1973:

Line 2047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2043: l(' END IF;');
2044: l('');
2045: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2046: l(' -- No MATCH RULE FOUND');
2047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2048: l(' FND_MSG_PUB.ADD;');
2049: l(' RAISE FND_API.G_EXC_ERROR;');
2050: l(' END IF;');
2051:

Line 2055: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2051:
2052: l(' OPEN c_match_rule;');
2053: l(' FETCH c_match_rule INTO l_cmp_flag;');
2054: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2055: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2056: l(' FND_MSG_PUB.ADD;');
2057: l(' RAISE FND_API.G_EXC_ERROR;');
2058: l(' END IF;');
2059:

Line 2074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2070: ELSE
2071: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2072: END IF;
2073: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2075: l(' FND_MSG_PUB.ADD;');
2076: l(' RAISE FND_API.G_EXC_ERROR;');
2077: l(' END IF;');
2078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_score_details(');

Line 2120: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2116: l(' END IF;');
2117: l('');
2118: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2119: l(' -- No MATCH RULE FOUND');
2120: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2121: l(' FND_MSG_PUB.ADD;');
2122: l(' RAISE FND_API.G_EXC_ERROR;');
2123: l(' END IF;');
2124:

Line 2128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2124:
2125: l(' OPEN c_match_rule;');
2126: l(' FETCH c_match_rule INTO l_cmp_flag;');
2127: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2129: l(' FND_MSG_PUB.ADD;');
2130: l(' RAISE FND_API.G_EXC_ERROR;');
2131: l(' END IF;');
2132:

Line 2147: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2143: ELSE
2144: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2145: END IF;
2146: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2147: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2148: l(' FND_MSG_PUB.ADD;');
2149: l(' RAISE FND_API.G_EXC_ERROR;');
2150: l(' END IF;');
2151: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_party_for_search(');

Line 2195: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');

2191: l(' END IF;');
2192: l('');
2193: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
2194: l(' -- No MATCH RULE FOUND');
2195: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_MATCH_RULE'');');
2196: l(' FND_MSG_PUB.ADD;');
2197: l(' RAISE FND_API.G_EXC_ERROR;');
2198: l(' END IF;');
2199:

Line 2203: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

2199:
2200: l(' OPEN c_match_rule;');
2201: l(' FETCH c_match_rule INTO l_cmp_flag;');
2202: l(' IF c_match_rule%NOTFOUND OR l_cmp_flag <> ''C'' THEN');
2203: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
2204: l(' FND_MSG_PUB.ADD;');
2205: l(' RAISE FND_API.G_EXC_ERROR;');
2206: l(' END IF;');
2207:

Line 2222: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');

2218: ELSE
2219: l(' ELSIF p_rule_id='||RULE.MATCH_RULE_ID||' THEN ');
2220: END IF;
2221: l(' IF NOT HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.check_staged THEN');
2222: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_TX_NOT_STAGED'');');
2223: l(' FND_MSG_PUB.ADD;');
2224: l(' RAISE FND_API.G_EXC_ERROR;');
2225: l(' END IF;');
2226: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_search_criteria(');

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

2813:
2814: l(' END LOOP;');
2815: l(' -- Add the search criteria to query string');
2816: l(' IF lengthb(l_contains_str) > 4000 THEN');
2817: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');
2819: l(' FND_MSG_PUB.ADD;');
2820: l(' RAISE FND_API.G_EXC_ERROR;');
2821: l(' END IF;');

Line 2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');

2814: l(' END LOOP;');
2815: l(' -- Add the search criteria to query string');
2816: l(' IF lengthb(l_contains_str) > 4000 THEN');
2817: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
2818: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'','''||p_entity||''');');
2819: l(' FND_MSG_PUB.ADD;');
2820: l(' RAISE FND_API.G_EXC_ERROR;');
2821: l(' END IF;');
2822: l(' x_denorm_str := l_den_contains_str;');

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

3050: --bug 4959719 start
3051: l(' exception');
3052: l(' when others then');
3053: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3054: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3055: l(' FND_MSG_PUB.ADD;');
3056: l(' RAISE FND_API.G_EXC_ERROR;');
3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

3055: l(' FND_MSG_PUB.ADD;');
3056: l(' RAISE FND_API.G_EXC_ERROR;');
3057: --Start Bug No: 3032742.
3058: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3060: l(' FND_MSG_PUB.ADD;');
3061: l(' RAISE FND_API.G_EXC_ERROR;');
3062: --End Bug No : 3032742.
3063: l(' else ');

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

3300: l(' IF NOT check_prim_cond (p_party_search_rec,');
3301: l(' p_party_site_list,');
3302: l(' p_contact_list,');
3303: l(' p_contact_point_list) THEN');
3304: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
3305: l(' FND_MSG_PUB.ADD;');
3306: l(' RAISE FND_API.G_EXC_ERROR;');
3307: l(' END IF;');
3308: IF l_max_score=1 THEN

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

3548: l(' END IF;');
3549: END IF;
3550: END LOOP;
3551: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3552: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3553: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3554: l(' FND_MSG_PUB.ADD;');
3555: l(' RAISE FND_API.G_EXC_ERROR;');
3556: l(' END IF;');

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

3549: END IF;
3550: END LOOP;
3551: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3552: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3553: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3554: l(' FND_MSG_PUB.ADD;');
3555: l(' RAISE FND_API.G_EXC_ERROR;');
3556: l(' END IF;');
3557: l(' IF (p_match_str = '' AND '' OR p_party_max_score

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

3960: l(' END IF;');
3961: l(' exception');
3962: l(' when others then');
3963: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3964: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3965: l(' FND_MSG_PUB.ADD;');
3966: l(' RAISE FND_API.G_EXC_ERROR;');
3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

3965: l(' FND_MSG_PUB.ADD;');
3966: l(' RAISE FND_API.G_EXC_ERROR;');
3967: --Start Bug No: 3032742.
3968: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3969: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3970: l(' FND_MSG_PUB.ADD;');
3971: l(' RAISE FND_API.G_EXC_ERROR;');
3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

3970: l(' FND_MSG_PUB.ADD;');
3971: l(' RAISE FND_API.G_EXC_ERROR;');
3972: --Bug: 3392837
3973: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3974: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3975: l(' FND_MSG_PUB.ADD;');
3976: l(' RAISE FND_API.G_EXC_ERROR;');
3977: --End Bug No : 3032742.
3978: l(' else ');

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

3975: l(' FND_MSG_PUB.ADD;');
3976: l(' RAISE FND_API.G_EXC_ERROR;');
3977: --End Bug No : 3032742.
3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3980: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3981: l(' FND_MSG_PUB.ADD;');
3982: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3983: l(' end if;');

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

3976: l(' RAISE FND_API.G_EXC_ERROR;');
3977: --End Bug No : 3032742.
3978: l(' else ');
3979: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3980: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3981: l(' FND_MSG_PUB.ADD;');
3982: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3983: l(' end if;');
3984: l(' END;');

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

4240: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4241: l(' exception');
4242: l(' when others then');
4243: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4244: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4245: l(' FND_MSG_PUB.ADD;');
4246: l(' RAISE FND_API.G_EXC_ERROR;');
4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4245: l(' FND_MSG_PUB.ADD;');
4246: l(' RAISE FND_API.G_EXC_ERROR;');
4247: --Start Bug No: 3032742.
4248: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4249: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4250: l(' FND_MSG_PUB.ADD;');
4251: l(' RAISE FND_API.G_EXC_ERROR;');
4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4250: l(' FND_MSG_PUB.ADD;');
4251: l(' RAISE FND_API.G_EXC_ERROR;');
4252: --Bug: 3392837
4253: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4254: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4255: l(' FND_MSG_PUB.ADD;');
4256: l(' RAISE FND_API.G_EXC_ERROR;');
4257: --End Bug No : 3032742.
4258: l(' else ');

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

4255: l(' FND_MSG_PUB.ADD;');
4256: l(' RAISE FND_API.G_EXC_ERROR;');
4257: --End Bug No : 3032742.
4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4261: l(' FND_MSG_PUB.ADD;');
4262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4263: l(' end if;');

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

4256: l(' RAISE FND_API.G_EXC_ERROR;');
4257: --End Bug No : 3032742.
4258: l(' else ');
4259: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4261: l(' FND_MSG_PUB.ADD;');
4262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4263: l(' end if;');
4264: l(' END;');

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

4408: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4409: l(' exception');
4410: l(' when others then');
4411: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4412: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4413: l(' FND_MSG_PUB.ADD;');
4414: l(' RAISE FND_API.G_EXC_ERROR;');
4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4413: l(' FND_MSG_PUB.ADD;');
4414: l(' RAISE FND_API.G_EXC_ERROR;');
4415: --Start Bug No: 3032742.
4416: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4417: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4418: l(' FND_MSG_PUB.ADD;');
4419: l(' RAISE FND_API.G_EXC_ERROR;');
4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4418: l(' FND_MSG_PUB.ADD;');
4419: l(' RAISE FND_API.G_EXC_ERROR;');
4420: --Bug: 3392837
4421: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4422: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4423: l(' FND_MSG_PUB.ADD;');
4424: l(' RAISE FND_API.G_EXC_ERROR;');
4425: --End Bug No : 3032742.
4426: l(' else ');

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

4423: l(' FND_MSG_PUB.ADD;');
4424: l(' RAISE FND_API.G_EXC_ERROR;');
4425: --End Bug No : 3032742.
4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4428: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4429: l(' FND_MSG_PUB.ADD;');
4430: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4431: l(' end if;');

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

4424: l(' RAISE FND_API.G_EXC_ERROR;');
4425: --End Bug No : 3032742.
4426: l(' else ');
4427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4428: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4429: l(' FND_MSG_PUB.ADD;');
4430: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4431: l(' end if;');
4432: l(' END;');

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

4720: l(' output_long_strings(''Restrict Sql = ''||p_restrict_sql);');
4721: l(' exception');
4722: l(' when others then');
4723: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4725: l(' FND_MSG_PUB.ADD;');
4726: l(' RAISE FND_API.G_EXC_ERROR;');
4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

4725: l(' FND_MSG_PUB.ADD;');
4726: l(' RAISE FND_API.G_EXC_ERROR;');
4727: --Start Bug No: 3032742.
4728: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4730: l(' FND_MSG_PUB.ADD;');
4731: l(' RAISE FND_API.G_EXC_ERROR;');
4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');

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

4730: l(' FND_MSG_PUB.ADD;');
4731: l(' RAISE FND_API.G_EXC_ERROR;');
4732: --Bug: 3392837
4733: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4735: l(' FND_MSG_PUB.ADD;');
4736: l(' RAISE FND_API.G_EXC_ERROR;');
4737: --End Bug No : 3032742.
4738: l(' else ');

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

4735: l(' FND_MSG_PUB.ADD;');
4736: l(' RAISE FND_API.G_EXC_ERROR;');
4737: --End Bug No : 3032742.
4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4740: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4741: l(' FND_MSG_PUB.ADD;');
4742: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4743: l(' end if;');

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

4736: l(' RAISE FND_API.G_EXC_ERROR;');
4737: --End Bug No : 3032742.
4738: l(' else ');
4739: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4740: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4741: l(' FND_MSG_PUB.ADD;');
4742: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4743: l(' end if;');
4744: l(' END;');

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

4983: l(' END IF;');
4984: l(' ELSE');
4985: l(' IF p_index>1 THEN');
4986: ldbg_s('In eval party level number of matches found exceeded threshold');
4987: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
4988: l(' FND_MSG_PUB.ADD;');
4989: l(' RAISE FND_API.G_EXC_ERROR;');
4990: l(' ELSE');
4991: l(' push_eval;');

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

5028: l(' END IF;');
5029: l(' CLOSE l_party_cur;'); --Bug No: 3872745
5030: l(' IF p_index>1 THEN');
5031: ldbg_s('In eval party level estimated hits exceed threshold');
5032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5033: l(' FND_MSG_PUB.ADD;');
5034: l(' RAISE FND_API.G_EXC_ERROR;');
5035: l(' ELSE');
5036: l(' push_eval;');

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

5090: l(' and check_estimate_hits(''PARTY_SITES'',p_party_site_contains_str)>l_max_thresh THEN');
5091: ldbg_s('In eval party site level estimated hits exceed threshold');
5092: l(' IF p_index>1 THEN');
5093: ldbg_s('In eval party site level number of matches found exceeded threshold');
5094: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5095: l(' FND_MSG_PUB.ADD;');
5096: l(' RAISE FND_API.G_EXC_ERROR;');
5097: l(' ELSE');
5098: l(' push_eval;');

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

5187: l(' and check_estimate_hits(''CONTACTS'',p_contact_contains_str)>l_max_thresh THEN');
5188: ldbg_s('In eval contact level estimated hits exceed threshold');
5189: l(' IF p_index>1 THEN');
5190: ldbg_s('In eval contact level number of matches found exceeded threshold');
5191: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5192: l(' FND_MSG_PUB.ADD;');
5193: l(' RAISE FND_API.G_EXC_ERROR;');
5194: l(' ELSE');
5195: l(' push_eval;');

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

5284: l(' and check_estimate_hits(''CONTACT_POINTS'',p_contact_pt_contains_str)>l_max_thresh THEN');
5285: ldbg_s('In eval contact point level estimated hits exceed threshold');
5286: l(' IF p_index>1 THEN');
5287: ldbg_s('In eval contact point level number of matches found exceeded threshold');
5288: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5289: l(' FND_MSG_PUB.ADD;');
5290: l(' RAISE FND_API.G_EXC_ERROR;');
5291: l(' ELSE');
5292: l(' push_eval;');

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

5489: ldbg_s('When max score of entity level 5490: l(' RETURN; ');
5491: l(' ELSE ');
5492: ldbg_s('In do eval number of matches found exceeded threshold');
5493: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
5494: l(' FND_MSG_PUB.ADD; ');
5495: l(' RAISE FND_API.G_EXC_ERROR; ');
5496: l(' END IF; ');
5497: --end of Bug No:5218095

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

5496: l(' END IF; ');
5497: --end of Bug No:5218095
5498: l(' ELSE');
5499: ldbg_s('In do eval number of matches found exceeded threshold');
5500: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5501: l(' FND_MSG_PUB.ADD;');
5502: l(' RAISE FND_API.G_EXC_ERROR;');
5503: l(' END IF; ');
5504: l(' END IF;');

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

5503: l(' END IF; ');
5504: l(' END IF;');
5505: --End of Bug No: 4407425
5506: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
5507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5508: l(' FND_MSG_PUB.ADD;');
5509: l(' RAISE FND_API.G_EXC_ERROR;');
5510: l(' END IF;');
5511: */

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

5787: l(' RAISE FND_API.G_EXC_ERROR;');
5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5794: l(' FND_MSG_PUB.ADD;');
5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

5788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5794: l(' FND_MSG_PUB.ADD;');
5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5796: l('END find_parties;');

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

5789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5790: l(' WHEN OTHERS THEN');
5791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5794: l(' FND_MSG_PUB.ADD;');
5795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5796: l('END find_parties;');
5797: l('');

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

5993: l(' END IF;');
5994: l(' ELSE');
5995: l(' IF p_index>1 THEN');
5996: ldbg_s('In eval party level number of matches found exceeded threshold');
5997: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5998: l(' FND_MSG_PUB.ADD;');
5999: l(' RAISE FND_API.G_EXC_ERROR;');
6000: l(' ELSE');
6001: l(' push_eval;');

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

6041:
6042: l(' CLOSE l_party_cur;'); --Bug No: 3872745
6043: l(' IF p_index>1 THEN');
6044: ldbg_s('In eval party level number of matches found exceeded threshold');
6045: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6046: l(' FND_MSG_PUB.ADD;');
6047: l(' RAISE FND_API.G_EXC_ERROR;');
6048: l(' ELSE');
6049: l(' push_eval;');

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

6078: --bug 4959719 start
6079: l(' exception');
6080: l(' when others then');
6081: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
6082: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
6083: l(' FND_MSG_PUB.ADD;');
6084: l(' RAISE FND_API.G_EXC_ERROR;');
6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

6083: l(' FND_MSG_PUB.ADD;');
6084: l(' RAISE FND_API.G_EXC_ERROR;');
6085: --Start Bug No: 3032742.
6086: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6087: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6088: l(' FND_MSG_PUB.ADD;');
6089: l(' RAISE FND_API.G_EXC_ERROR;');
6090: --End Bug No : 3032742.
6091: l(' else ');

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

6160: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6161: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
6162: l(' IF p_index>1 THEN');
6163: ldbg_s('In eval party site level number of matches found exceeded threshold');
6164: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6165: l(' FND_MSG_PUB.ADD;');
6166: l(' RAISE FND_API.G_EXC_ERROR;');
6167: l(' ELSE');
6168: l(' push_eval;');

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

6382: l(' IF (l_party_id_idx-1)>l_max_thresh THEN');
6383: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
6384: l(' IF p_index>1 THEN');
6385: ldbg_s('In eval contact point level number of matches found exceeded threshold');
6386: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6387: l(' FND_MSG_PUB.ADD;');
6388: l(' RAISE FND_API.G_EXC_ERROR;');
6389: l(' ELSE');
6390: l(' push_eval;');

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

6498: ldbg_s('When max score of entity level 6499: l(' RETURN; ');
6500: l(' ELSE ');
6501: ldbg_s('In do eval number of matches found exceeded threshold');
6502: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
6503: l(' FND_MSG_PUB.ADD; ');
6504: l(' RAISE FND_API.G_EXC_ERROR; ');
6505: l(' END IF; ');
6506: --end of Bug No:5218095

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

6505: l(' END IF; ');
6506: --end of Bug No:5218095
6507: l(' ELSE');
6508: ldbg_s('In do eval number of matches found exceeded threshold');
6509: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6510: l(' FND_MSG_PUB.ADD;');
6511: l(' RAISE FND_API.G_EXC_ERROR;');
6512: l(' END IF; ');
6513: l(' END IF;');

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

6512: l(' END IF; ');
6513: l(' END IF;');
6514: --End of Bug No: 4407425
6515: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
6516: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6517: l(' FND_MSG_PUB.ADD;');
6518: l(' RAISE FND_API.G_EXC_ERROR;');
6519: l(' END IF;');
6520: */

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

6681: l(' RAISE FND_API.G_EXC_ERROR;');
6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6688: l(' FND_MSG_PUB.ADD;');
6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

6682: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6688: l(' FND_MSG_PUB.ADD;');
6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6690: l('END find_persons;');

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

6683: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6684: l(' WHEN OTHERS THEN');
6685: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6686: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6687: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6688: l(' FND_MSG_PUB.ADD;');
6689: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6690: l('END find_persons;');
6691: l('');

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

6704: l(' RAISE FND_API.G_EXC_ERROR;');
6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6711: l(' FND_MSG_PUB.ADD;');
6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

6705: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6711: l(' FND_MSG_PUB.ADD;');
6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6713: l('END find_persons;');

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

6706: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6707: l(' WHEN OTHERS THEN');
6708: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6709: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6710: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6711: l(' FND_MSG_PUB.ADD;');
6712: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6713: l('END find_persons;');
6714: END IF; ---End of Code Change for Match Rule Set

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

6778: l(' RAISE FND_API.G_EXC_ERROR;');
6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6785: l(' FND_MSG_PUB.ADD;');
6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

6779: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6785: l(' FND_MSG_PUB.ADD;');
6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6787: l('END find_party_details;');

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

6780: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6781: l(' WHEN OTHERS THEN');
6782: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6783: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6784: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6785: l(' FND_MSG_PUB.ADD;');
6786: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6787: l('END find_party_details;');
6788: l('');

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

6896: l(' RAISE FND_API.G_EXC_ERROR;');
6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6902: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6903: l(' FND_MSG_PUB.ADD;');
6904: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

6897: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6902: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6903: l(' FND_MSG_PUB.ADD;');
6904: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6905: l('END find_duplicate_parties;');

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

6898: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6899: l(' WHEN OTHERS THEN');
6900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6901: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6902: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6903: l(' FND_MSG_PUB.ADD;');
6904: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6905: l('END find_duplicate_parties;');
6906:

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

6989: l(' RAISE FND_API.G_EXC_ERROR;');
6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6996: l(' FND_MSG_PUB.ADD;');
6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

6990: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6996: l(' FND_MSG_PUB.ADD;');
6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6998: l('END find_duplicate_party_sites; ');

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

6991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6992: l(' WHEN OTHERS THEN');
6993: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6994: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
6995: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6996: l(' FND_MSG_PUB.ADD;');
6997: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6998: l('END find_duplicate_party_sites; ');
6999: l(' ');

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

7085: l(' RAISE FND_API.G_EXC_ERROR;');
7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7092: l(' FND_MSG_PUB.ADD;');
7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

7086: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7092: l(' FND_MSG_PUB.ADD;');
7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7094: l('END find_duplicate_contacts; ');

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

7087: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7088: l(' WHEN OTHERS THEN');
7089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7090: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7091: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7092: l(' FND_MSG_PUB.ADD;');
7093: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7094: l('END find_duplicate_contacts; ');
7095: l('');

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

7161: l(' RAISE FND_API.G_EXC_ERROR;');
7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7168: l(' FND_MSG_PUB.ADD;');
7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

7162: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7168: l(' FND_MSG_PUB.ADD;');
7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7170: l('END find_duplicate_contact_points;');

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

7163: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7164: l(' WHEN OTHERS THEN');
7165: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7166: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7167: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7168: l(' FND_MSG_PUB.ADD;');
7169: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7170: l('END find_duplicate_contact_points;');
7171: l('');

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

7403: l(' RAISE FND_API.G_EXC_ERROR;');
7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7410: l(' FND_MSG_PUB.ADD;');
7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

7404: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7410: l(' FND_MSG_PUB.ADD;');
7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7412:

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

7405: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7406: l(' WHEN OTHERS THEN');
7407: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7408: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7409: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7410: l(' FND_MSG_PUB.ADD;');
7411: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7412:
7413:

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

7676: l(' RAISE FND_API.G_EXC_ERROR;');
7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7683: l(' FND_MSG_PUB.ADD;');
7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

7677: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7683: l(' FND_MSG_PUB.ADD;');
7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7685: l('END get_matching_party_sites;');

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

7678: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7679: l(' WHEN OTHERS THEN');
7680: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7681: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7682: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7683: l(' FND_MSG_PUB.ADD;');
7684: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7685: l('END get_matching_party_sites;');
7686: l('');

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

7952: l(' RAISE FND_API.G_EXC_ERROR;');
7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7959: l(' FND_MSG_PUB.ADD;');
7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

7953: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7959: l(' FND_MSG_PUB.ADD;');
7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7961: l('END get_matching_contacts;');

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

7954: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7955: l(' WHEN OTHERS THEN');
7956: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7957: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7958: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7959: l(' FND_MSG_PUB.ADD;');
7960: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7961: l('END get_matching_contacts;');
7962: l('');

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

8134: l(' RAISE FND_API.G_EXC_ERROR;');
8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8140: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8141: l(' FND_MSG_PUB.ADD;');
8142: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

8135: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8140: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8141: l(' FND_MSG_PUB.ADD;');
8142: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8143: l('END get_matching_contact_points;');

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

8136: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8137: l(' WHEN OTHERS THEN');
8138: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8139: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8140: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8141: l(' FND_MSG_PUB.ADD;');
8142: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8143: l('END get_matching_contact_points;');
8144:

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

8377: l(' RAISE FND_API.G_EXC_ERROR;');
8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8384: l(' FND_MSG_PUB.ADD;');
8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');

8378: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8384: l(' FND_MSG_PUB.ADD;');
8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8386: l('END get_score_details;');

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

8379: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8380: l(' WHEN OTHERS THEN');
8381: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8382: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8383: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8384: l(' FND_MSG_PUB.ADD;');
8385: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8386: l('END get_score_details;');
8387: l('');

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

8475: l('RETURN null;');
8476:
8477: l('EXCEPTION');
8478: l(' WHEN OTHERS THEN');
8479: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8481: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8482: l(' FND_MSG_PUB.ADD;');
8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');

8476:
8477: l('EXCEPTION');
8478: l(' WHEN OTHERS THEN');
8479: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8481: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8482: l(' FND_MSG_PUB.ADD;');
8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8484: l(' END check_parties_bulk ;');

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

8477: l('EXCEPTION');
8478: l(' WHEN OTHERS THEN');
8479: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8480: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8481: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8482: l(' FND_MSG_PUB.ADD;');
8483: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8484: l(' END check_parties_bulk ;');
8485: l('');

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

8537:
8538: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8539: l('EXCEPTION');
8540: l(' WHEN OTHERS THEN');
8541: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8543: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8544: l(' FND_MSG_PUB.ADD;');
8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');

8538: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8539: l('EXCEPTION');
8540: l(' WHEN OTHERS THEN');
8541: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8543: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8544: l(' FND_MSG_PUB.ADD;');
8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8546: l(' END check_party_sites_bulk ;');

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

8539: l('EXCEPTION');
8540: l(' WHEN OTHERS THEN');
8541: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8542: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8543: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8544: l(' FND_MSG_PUB.ADD;');
8545: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8546: l(' END check_party_sites_bulk ;');
8547: l('');

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

8601:
8602: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8603: l('EXCEPTION');
8604: l(' WHEN OTHERS THEN');
8605: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8607: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8608: l(' FND_MSG_PUB.ADD;');
8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');

8602: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8603: l('EXCEPTION');
8604: l(' WHEN OTHERS THEN');
8605: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8607: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8608: l(' FND_MSG_PUB.ADD;');
8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8610: l(' END check_contacts_bulk ;');

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

8603: l('EXCEPTION');
8604: l(' WHEN OTHERS THEN');
8605: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8606: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8607: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8608: l(' FND_MSG_PUB.ADD;');
8609: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8610: l(' END check_contacts_bulk ;');
8611: l('');

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

8663:
8664: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8665: l('EXCEPTION');
8666: l(' WHEN OTHERS THEN');
8667: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8669: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8670: l(' FND_MSG_PUB.ADD;');
8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');

8664: l(' IF x_primary = TRUE THEN RETURN ''Y''; ELSE RETURN null; END IF; ');
8665: l('EXCEPTION');
8666: l(' WHEN OTHERS THEN');
8667: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8669: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8670: l(' FND_MSG_PUB.ADD;');
8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8672: l(' END check_cpts_bulk ;');

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

8665: l('EXCEPTION');
8666: l(' WHEN OTHERS THEN');
8667: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8668: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8669: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8670: l(' FND_MSG_PUB.ADD;');
8671: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8672: l(' END check_cpts_bulk ;');
8673: l('');

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

8966: l(' IF NOT check_prim_cond (p_party_search_rec,');
8967: l(' p_party_site_list,');
8968: l(' p_contact_list,');
8969: l(' p_contact_point_list) THEN');
8970: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
8971: l(' FND_MSG_PUB.ADD;');
8972: l(' RAISE FND_API.G_EXC_ERROR;');
8973: l(' END IF;');
8974: IF l_max_score=1 THEN

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

9289: l(' END IF;');
9290: l(' exception');
9291: l(' when others then');
9292: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9293: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9294: l(' FND_MSG_PUB.ADD;');
9295: l(' RAISE FND_API.G_EXC_ERROR;');
9296: l(' else ');
9297: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9402: l(' END IF;');
9403: l(' exception');
9404: l(' when others then');
9405: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9406: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9407: l(' FND_MSG_PUB.ADD;');
9408: l(' RAISE FND_API.G_EXC_ERROR;');
9409: l(' else ');
9410: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9503: l(' END IF;');
9504: l(' exception');
9505: l(' when others then');
9506: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9508: l(' FND_MSG_PUB.ADD;');
9509: l(' RAISE FND_API.G_EXC_ERROR;');
9510: l(' else ');
9511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9610: l(' END IF;');
9611: l(' exception');
9612: l(' when others then');
9613: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9614: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9615: l(' FND_MSG_PUB.ADD;');
9616: l(' RAISE FND_API.G_EXC_ERROR;');
9617: l(' else ');
9618: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

9829: l(' IF l_party_id_idx>l_max_thresh THEN');
9830: l(' CLOSE l_party_cur;'); --Bug No: 3872745
9831: l(' IF p_index>1 THEN');
9832: ldbg_s('In eval party level number of matches found exceeded threshold');
9833: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9834: l(' FND_MSG_PUB.ADD;');
9835: l(' RAISE FND_API.G_EXC_ERROR;');
9836: l(' ELSE');
9837: l(' push_eval;');

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

9901: l(' IF l_party_id_idx>l_max_thresh THEN');
9902: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
9903: l(' IF p_index>1 THEN');
9904: ldbg_s('In eval party site level number of matches found exceeded threshold');
9905: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9906: l(' FND_MSG_PUB.ADD;');
9907: l(' RAISE FND_API.G_EXC_ERROR;');
9908: l(' ELSE');
9909: l(' push_eval;');

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

9985: l(' IF l_party_id_idx>l_max_thresh THEN');
9986: l(' CLOSE l_contact_cur;'); --Bug No: 3872745
9987: l(' IF p_index>1 THEN');
9988: ldbg_s('In eval contact level number of matches found exceeded threshold');
9989: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9990: l(' FND_MSG_PUB.ADD;');
9991: l(' RAISE FND_API.G_EXC_ERROR;');
9992: l(' ELSE');
9993: l(' push_eval;');

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

10069: l(' IF l_party_id_idx>l_max_thresh THEN');
10070: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10071: l(' IF p_index>1 THEN');
10072: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10073: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10074: l(' FND_MSG_PUB.ADD;');
10075: l(' RAISE FND_API.G_EXC_ERROR;');
10076: l(' ELSE');
10077: l(' push_eval;');

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

10117: l(' IF( (l_match_str = '' AND '' AND other_criteria_exists) OR ( call_max_score(p_index) < l_threshold) )THEN');
10118: l(' RETURN; ');
10119: l(' ELSE');
10120: ldbg_s('In do eval number of matches found exceeded threshold');
10121: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10122: l(' FND_MSG_PUB.ADD;');
10123: l(' RAISE FND_API.G_EXC_ERROR;');
10124: l(' END IF; ');
10125: l(' END IF;');

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

10124: l(' END IF; ');
10125: l(' END IF;');
10126: --End of Bug No: 4407425
10127: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10129: l(' FND_MSG_PUB.ADD;');
10130: l(' RAISE FND_API.G_EXC_ERROR;');
10131: l(' END IF;');
10132: */

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

10388: l(' ROLLBACK to find_parties;');
10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10390: l(' WHEN OTHERS THEN');
10391: l(' ROLLBACK to find_parties;');
10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10394: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10395: l(' FND_MSG_PUB.ADD;');
10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');

10389: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10390: l(' WHEN OTHERS THEN');
10391: l(' ROLLBACK to find_parties;');
10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10394: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10395: l(' FND_MSG_PUB.ADD;');
10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10397: l('END find_parties;');

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

10390: l(' WHEN OTHERS THEN');
10391: l(' ROLLBACK to find_parties;');
10392: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10393: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10394: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10395: l(' FND_MSG_PUB.ADD;');
10396: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10397: l('END find_parties;');
10398: l('');

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

10614: l(' IF l_party_id_idx>l_max_thresh THEN');
10615: l(' CLOSE l_party_cur;'); --Bug No: 3872745
10616: l(' IF p_index>1 THEN');
10617: ldbg_s('In eval party level number of matches found exceeded threshold');
10618: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10619: l(' FND_MSG_PUB.ADD;');
10620: l(' RAISE FND_API.G_EXC_ERROR;');
10621: l(' ELSE');
10622: l(' push_eval;');

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

10651: --bug 4959719 start
10652: l(' exception');
10653: l(' when others then');
10654: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
10655: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
10656: l(' FND_MSG_PUB.ADD;');
10657: l(' RAISE FND_API.G_EXC_ERROR;');
10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');

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

10656: l(' FND_MSG_PUB.ADD;');
10657: l(' RAISE FND_API.G_EXC_ERROR;');
10658: --Start Bug No: 3032742.
10659: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10661: l(' FND_MSG_PUB.ADD;');
10662: l(' RAISE FND_API.G_EXC_ERROR;');
10663: --End Bug No : 3032742.
10664: l(' else ');

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

10738: l(' IF l_party_id_idx>l_max_thresh THEN');
10739: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
10740: l(' IF p_index>1 THEN');
10741: ldbg_s('In eval party site level number of matches found exceeded threshold');
10742: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10743: l(' FND_MSG_PUB.ADD;');
10744: l(' RAISE FND_API.G_EXC_ERROR;');
10745: l(' ELSE');
10746: l(' push_eval;');

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

10894: l(' IF l_party_id_idx>l_max_thresh THEN');
10895: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10896: l(' IF p_index>1 THEN');
10897: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10898: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10899: l(' FND_MSG_PUB.ADD;');
10900: l(' RAISE FND_API.G_EXC_ERROR;');
10901: l(' ELSE');
10902: l(' push_eval;');

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

10942: l(' IF( (l_match_str = '' AND '' AND other_criteria_exists) OR ( call_max_score(p_index) < l_threshold) )THEN');
10943: l(' RETURN; ');
10944: l(' ELSE');
10945: ldbg_s('In do eval number of matches found exceeded threshold');
10946: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10947: l(' FND_MSG_PUB.ADD;');
10948: l(' RAISE FND_API.G_EXC_ERROR;');
10949: l(' END IF; ');
10950: l(' END IF;');

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

10950: l(' END IF;');
10951: --End of Bug No: 4407425
10952: /*
10953: l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10954: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10955: l(' FND_MSG_PUB.ADD;');
10956: l(' RAISE FND_API.G_EXC_ERROR;');
10957: l(' END IF;');
10958: */

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

11101: l(' ROLLBACK to find_persons;');
11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11103: l(' WHEN OTHERS THEN');
11104: l(' ROLLBACK to find_persons;');
11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11107: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11108: l(' FND_MSG_PUB.ADD;');
11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');

11102: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11103: l(' WHEN OTHERS THEN');
11104: l(' ROLLBACK to find_persons;');
11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11107: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11108: l(' FND_MSG_PUB.ADD;');
11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11110: l('END find_persons;');

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

11103: l(' WHEN OTHERS THEN');
11104: l(' ROLLBACK to find_persons;');
11105: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11106: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11107: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11108: l(' FND_MSG_PUB.ADD;');
11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11110: l('END find_persons;');
11111: ELSE

Line 11113: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');

11109: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11110: l('END find_persons;');
11111: ELSE
11112: l('BEGIN');
11113: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
11114: l(' FND_MSG_PUB.ADD;');
11115: l(' RAISE FND_API.G_EXC_ERROR;');
11116: l('END find_persons;');
11117: l('');

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

11181: l(' RAISE FND_API.G_EXC_ERROR;');
11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11188: l(' FND_MSG_PUB.ADD;');
11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');

11182: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11188: l(' FND_MSG_PUB.ADD;');
11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11190: l('END find_party_details;');

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

11183: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11184: l(' WHEN OTHERS THEN');
11185: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11186: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11187: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11188: l(' FND_MSG_PUB.ADD;');
11189: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11190: l('END find_party_details;');
11191: l('');

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

11273: l(' RAISE FND_API.G_EXC_ERROR;');
11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11280: l(' FND_MSG_PUB.ADD;');
11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');

11274: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11280: l(' FND_MSG_PUB.ADD;');
11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11282: l('END find_duplicate_parties;');

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

11275: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11276: l(' WHEN OTHERS THEN');
11277: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11278: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11279: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11280: l(' FND_MSG_PUB.ADD;');
11281: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11282: l('END find_duplicate_parties;');
11283:

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

11368: l(' RAISE FND_API.G_EXC_ERROR;');
11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11375: l(' FND_MSG_PUB.ADD;');
11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');

11369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11375: l(' FND_MSG_PUB.ADD;');
11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11377: l('END find_duplicate_party_sites; ');

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

11370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11371: l(' WHEN OTHERS THEN');
11372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11373: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11375: l(' FND_MSG_PUB.ADD;');
11376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11377: l('END find_duplicate_party_sites; ');
11378: l(' ');

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

11466: l(' RAISE FND_API.G_EXC_ERROR;');
11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11473: l(' FND_MSG_PUB.ADD;');
11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');

11467: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11473: l(' FND_MSG_PUB.ADD;');
11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11475: l('END find_duplicate_contacts; ');

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

11468: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11469: l(' WHEN OTHERS THEN');
11470: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11471: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11472: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11473: l(' FND_MSG_PUB.ADD;');
11474: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11475: l('END find_duplicate_contacts; ');
11476: l('');

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

11544: l(' RAISE FND_API.G_EXC_ERROR;');
11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11551: l(' FND_MSG_PUB.ADD;');
11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');

11545: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11551: l(' FND_MSG_PUB.ADD;');
11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11553: l('END find_duplicate_contact_points;');

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

11546: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11547: l(' WHEN OTHERS THEN');
11548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11549: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11551: l(' FND_MSG_PUB.ADD;');
11552: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11553: l('END find_duplicate_contact_points;');
11554: l('');

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

11787: l(' RAISE FND_API.G_EXC_ERROR;');
11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11794: l(' FND_MSG_PUB.ADD;');
11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');

11788: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11794: l(' FND_MSG_PUB.ADD;');
11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11796:

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

11789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11790: l(' WHEN OTHERS THEN');
11791: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11792: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11793: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11794: l(' FND_MSG_PUB.ADD;');
11795: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11796:
11797:

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

12028: l(' ROLLBACK to get_matching_party_sites ;');
12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12030: l(' WHEN OTHERS THEN');
12031: l(' ROLLBACK to get_matching_party_sites ;');
12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12035: l(' FND_MSG_PUB.ADD;');
12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');

12029: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12030: l(' WHEN OTHERS THEN');
12031: l(' ROLLBACK to get_matching_party_sites ;');
12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12035: l(' FND_MSG_PUB.ADD;');
12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12037: l('END get_matching_party_sites;');

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

12030: l(' WHEN OTHERS THEN');
12031: l(' ROLLBACK to get_matching_party_sites ;');
12032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12035: l(' FND_MSG_PUB.ADD;');
12036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12037: l('END get_matching_party_sites;');
12038: l('');

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

12270: l(' ROLLBACK to get_matching_contacts ;');
12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12272: l(' WHEN OTHERS THEN');
12273: l(' ROLLBACK to get_matching_contacts ;');
12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12276: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12277: l(' FND_MSG_PUB.ADD;');
12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');

12271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12272: l(' WHEN OTHERS THEN');
12273: l(' ROLLBACK to get_matching_contacts ;');
12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12276: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12277: l(' FND_MSG_PUB.ADD;');
12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12279: l('END get_matching_contacts;');

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

12272: l(' WHEN OTHERS THEN');
12273: l(' ROLLBACK to get_matching_contacts ;');
12274: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12275: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12276: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12277: l(' FND_MSG_PUB.ADD;');
12278: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12279: l('END get_matching_contacts;');
12280: l('');

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

12431: l(' ROLLBACK to get_matching_contact_points ;');
12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12433: l(' WHEN OTHERS THEN');
12434: l(' ROLLBACK to get_matching_contact_points ;');
12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12438: l(' FND_MSG_PUB.ADD;');
12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');

12432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12433: l(' WHEN OTHERS THEN');
12434: l(' ROLLBACK to get_matching_contact_points ;');
12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12438: l(' FND_MSG_PUB.ADD;');
12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12440: l('END get_matching_contact_points;');

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

12433: l(' WHEN OTHERS THEN');
12434: l(' ROLLBACK to get_matching_contact_points ;');
12435: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12436: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12438: l(' FND_MSG_PUB.ADD;');
12439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12440: l('END get_matching_contact_points;');
12441:

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

12673: l(' DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;');
12674: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12675: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12676: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12677: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12679: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12680: l(' FND_MSG_PUB.ADD;');
12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');

12674: l(' DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;');
12675: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12676: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12677: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12679: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12680: l(' FND_MSG_PUB.ADD;');
12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12682: l('END get_score_details;');

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

12675: l(' DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;');
12676: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12677: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12678: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12679: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12680: l(' FND_MSG_PUB.ADD;');
12681: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12682: l('END get_score_details;');
12683: l('');

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

12906:
12907:
12908: l('EXCEPTION');
12909: l(' WHEN OTHERS THEN');
12910: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12912: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12913: l(' FND_MSG_PUB.ADD;');
12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

12907:
12908: l('EXCEPTION');
12909: l(' WHEN OTHERS THEN');
12910: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12912: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12913: l(' FND_MSG_PUB.ADD;');
12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12915: l('END;');

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

12908: l('EXCEPTION');
12909: l(' WHEN OTHERS THEN');
12910: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12911: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12912: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12913: l(' FND_MSG_PUB.ADD;');
12914: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12915: l('END;');
12916:

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

13098: END IF;
13099:
13100: l('EXCEPTION');
13101: l(' WHEN OTHERS THEN');
13102: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13104: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13105: l(' FND_MSG_PUB.ADD;');
13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13099:
13100: l('EXCEPTION');
13101: l(' WHEN OTHERS THEN');
13102: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13104: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13105: l(' FND_MSG_PUB.ADD;');
13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13107: l('END;');

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

13100: l('EXCEPTION');
13101: l(' WHEN OTHERS THEN');
13102: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13103: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13104: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13105: l(' FND_MSG_PUB.ADD;');
13106: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13107: l('END;');
13108:

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

13198: END IF ;
13199:
13200: l('EXCEPTION');
13201: l(' WHEN OTHERS THEN');
13202: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13204: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13205: l(' FND_MSG_PUB.ADD;');
13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13199:
13200: l('EXCEPTION');
13201: l(' WHEN OTHERS THEN');
13202: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13204: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13205: l(' FND_MSG_PUB.ADD;');
13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13207: l('END;');

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

13200: l('EXCEPTION');
13201: l(' WHEN OTHERS THEN');
13202: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13203: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13204: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13205: l(' FND_MSG_PUB.ADD;');
13206: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13207: l('END;');
13208:

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

13416: END IF;
13417:
13418: l('EXCEPTION');
13419: l(' WHEN OTHERS THEN');
13420: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13422: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13423: l(' FND_MSG_PUB.ADD;');
13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13417:
13418: l('EXCEPTION');
13419: l(' WHEN OTHERS THEN');
13420: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13422: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13423: l(' FND_MSG_PUB.ADD;');
13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13425: l('END;');

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

13418: l('EXCEPTION');
13419: l(' WHEN OTHERS THEN');
13420: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13421: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13422: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13423: l(' FND_MSG_PUB.ADD;');
13424: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13425: l('END;');
13426:

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

13622:
13623:
13624: l('EXCEPTION');
13625: l(' WHEN OTHERS THEN');
13626: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13628: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13629: l(' FND_MSG_PUB.ADD;');
13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');

13623:
13624: l('EXCEPTION');
13625: l(' WHEN OTHERS THEN');
13626: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13628: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13629: l(' FND_MSG_PUB.ADD;');
13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13631: l('END;');

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

13624: l('EXCEPTION');
13625: l(' WHEN OTHERS THEN');
13626: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13627: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13628: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13629: l(' FND_MSG_PUB.ADD;');
13630: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13631: l('END;');
13632:

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

13674: END IF;
13675: END LOOP;
13676: IF NOT FIRST THEN
13677: l(' ) THEN');
13678: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
13679: l(' FND_MSG_PUB.ADD;');
13680: l(' RAISE FND_API.G_EXC_ERROR;');
13681: l(' END IF;');
13682: l(' END LOOP;');

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

13725: l('EXCEPTION');
13726: l(' WHEN FND_API.G_EXC_ERROR THEN');
13727: l(' RAISE FND_API.G_EXC_ERROR;');
13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13732: l(' FND_MSG_PUB.ADD;');
13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

13726: l(' WHEN FND_API.G_EXC_ERROR THEN');
13727: l(' RAISE FND_API.G_EXC_ERROR;');
13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13732: l(' FND_MSG_PUB.ADD;');
13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13734: l(' END check_prim_cond;');

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

13727: l(' RAISE FND_API.G_EXC_ERROR;');
13728: l(' WHEN OTHERS THEN');
13729: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13730: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13731: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13732: l(' FND_MSG_PUB.ADD;');
13733: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13734: l(' END check_prim_cond;');
13735: l('');

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

13861: END IF;
13862: l(' END LOOP;');
13863: l('EXCEPTION');
13864: l(' WHEN OTHERS THEN');
13865: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13866: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13867: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13868: l(' FND_MSG_PUB.ADD;');
13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

13862: l(' END LOOP;');
13863: l('EXCEPTION');
13864: l(' WHEN OTHERS THEN');
13865: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13866: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13867: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13868: l(' FND_MSG_PUB.ADD;');
13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13870: l(' END check_party_site_cond;');

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

13863: l('EXCEPTION');
13864: l(' WHEN OTHERS THEN');
13865: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13866: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13867: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13868: l(' FND_MSG_PUB.ADD;');
13869: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13870: l(' END check_party_site_cond;');
13871: l('');

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

13999: l(' END LOOP;');
14000:
14001: l('EXCEPTION');
14002: l(' WHEN OTHERS THEN');
14003: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14004: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14005: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14006: l(' FND_MSG_PUB.ADD;');
14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14000:
14001: l('EXCEPTION');
14002: l(' WHEN OTHERS THEN');
14003: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14004: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14005: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14006: l(' FND_MSG_PUB.ADD;');
14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14008: l(' END check_contact_cond;');

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

14001: l('EXCEPTION');
14002: l(' WHEN OTHERS THEN');
14003: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14004: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14005: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14006: l(' FND_MSG_PUB.ADD;');
14007: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14008: l(' END check_contact_cond;');
14009: l('');

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

14024: l(' x_secondary:= FALSE;');
14025: l('');
14026: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');
14027: l(' IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN ');
14028: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
14029: l(' FND_MSG_PUB.ADD;');
14030: l(' RAISE FND_API.G_EXC_ERROR;');
14031: l(' END IF;');
14032: l(' END LOOP;');

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

14086: END IF;
14087: l(' END LOOP;');
14088: l('EXCEPTION');
14089: l(' WHEN OTHERS THEN');
14090: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14091: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14093: l(' FND_MSG_PUB.ADD;');
14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14087: l(' END LOOP;');
14088: l('EXCEPTION');
14089: l(' WHEN OTHERS THEN');
14090: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14091: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14093: l(' FND_MSG_PUB.ADD;');
14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14095: l(' END check_contact_point_cond;');

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

14088: l('EXCEPTION');
14089: l(' WHEN OTHERS THEN');
14090: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14091: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14093: l(' FND_MSG_PUB.ADD;');
14094: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14095: l(' END check_contact_point_cond;');
14096: l('');

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

14368: l(' RAISE FND_API.G_EXC_ERROR;');
14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14375: l(' FND_MSG_PUB.ADD;');
14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14369: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14375: l(' FND_MSG_PUB.ADD;');
14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14377: l('END get_party_for_search;');

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

14370: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14371: l(' WHEN OTHERS THEN');
14372: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14373: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14374: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14375: l(' FND_MSG_PUB.ADD;');
14376: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14377: l('END get_party_for_search;');
14378: l('');

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

14503: l(' RAISE FND_API.G_EXC_ERROR;');
14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14510: l(' FND_MSG_PUB.ADD;');
14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

14504: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14510: l(' FND_MSG_PUB.ADD;');
14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14512: l('END get_search_criteria;');

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

14505: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14506: l(' WHEN OTHERS THEN');
14507: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14508: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14509: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14510: l(' FND_MSG_PUB.ADD;');
14511: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14512: l('END get_search_criteria;');
14513: l('');

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

14751: generate_custom_code(p_rule_id, ' x_party_search_rec','PARTY','p_party_id');
14752: l('');
14753: l('EXCEPTION');
14754: l(' WHEN OTHERS THEN');
14755: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');

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

14752: l('');
14753: l('EXCEPTION');
14754: l(' WHEN OTHERS THEN');
14755: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');
14760: l(' RAISE FND_API.G_EXC_ERROR;');

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

14753: l('EXCEPTION');
14754: l(' WHEN OTHERS THEN');
14755: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');
14760: l(' RAISE FND_API.G_EXC_ERROR;');
14761: l('END get_party_rec;');

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

14754: l(' WHEN OTHERS THEN');
14755: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14756: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14757: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14758: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14759: l(' FND_MSG_PUB.ADD;');
14760: l(' RAISE FND_API.G_EXC_ERROR;');
14761: l('END get_party_rec;');
14762: l('');

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

14840: l(' END LOOP;');
14841: l('');
14842: l('EXCEPTION');
14843: l(' WHEN OTHERS THEN');
14844: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');

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

14841: l('');
14842: l('EXCEPTION');
14843: l(' WHEN OTHERS THEN');
14844: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');
14849: l(' RAISE FND_API.G_EXC_ERROR;');

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

14842: l('EXCEPTION');
14843: l(' WHEN OTHERS THEN');
14844: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');
14849: l(' RAISE FND_API.G_EXC_ERROR;');
14850: l('END get_party_site_rec;');

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

14843: l(' WHEN OTHERS THEN');
14844: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14845: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14846: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14847: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14848: l(' FND_MSG_PUB.ADD;');
14849: l(' RAISE FND_API.G_EXC_ERROR;');
14850: l('END get_party_site_rec;');
14851: l('');

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

14934: l(' END LOOP;');
14935: l('');
14936: l('EXCEPTION');
14937: l(' WHEN OTHERS THEN');
14938: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');

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

14935: l('');
14936: l('EXCEPTION');
14937: l(' WHEN OTHERS THEN');
14938: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');
14943: l(' RAISE FND_API.G_EXC_ERROR;');

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

14936: l('EXCEPTION');
14937: l(' WHEN OTHERS THEN');
14938: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');
14943: l(' RAISE FND_API.G_EXC_ERROR;');
14944: l('END get_contact_rec;');

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

14937: l(' WHEN OTHERS THEN');
14938: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14939: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14940: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14942: l(' FND_MSG_PUB.ADD;');
14943: l(' RAISE FND_API.G_EXC_ERROR;');
14944: l('END get_contact_rec;');
14945: l('');

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

15029:
15030: l('');
15031: l('EXCEPTION');
15032: l(' WHEN OTHERS THEN');
15033: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');

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

15030: l('');
15031: l('EXCEPTION');
15032: l(' WHEN OTHERS THEN');
15033: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');
15038: l(' RAISE FND_API.G_EXC_ERROR;');

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

15031: l('EXCEPTION');
15032: l(' WHEN OTHERS THEN');
15033: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');
15038: l(' RAISE FND_API.G_EXC_ERROR;');
15039: l('END get_contact_point_rec;');

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

15032: l(' WHEN OTHERS THEN');
15033: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15034: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15035: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15036: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15037: l(' FND_MSG_PUB.ADD;');
15038: l(' RAISE FND_API.G_EXC_ERROR;');
15039: l('END get_contact_point_rec;');
15040:

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

15544: l(' p_data => x_msg_data);');
15545: l('');
15546: l(' WHEN OTHERS THEN');
15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');

Line 15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');

15545: l('');
15546: l(' WHEN OTHERS THEN');
15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');
15553: l(' FND_MSG_PUB.Count_And_Get(');

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

15546: l(' WHEN OTHERS THEN');
15547: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15548: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15549: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15550: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15551: l(' FND_MSG_PUB.ADD;');
15552: l('');
15553: l(' FND_MSG_PUB.Count_And_Get(');
15554: l(' p_encoded => FND_API.G_FALSE,');

Line 15796: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');

15792: l(' where entity_name = substrb(p_str, 0, l_pl - 1) ');
15793: l(' and ATTRIBUTE_NAME = substrb(p_str, l_pl + 1); ');
15794: l(' RETURN l_id; ');
15795: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15796: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15797: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15798: l(' FND_MSG_PUB.ADD; ');
15799: l(' RAISE FND_API.G_EXC_ERROR; ');
15800: l(' END get_attrib_id; ');

Line 15797: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');

15793: l(' and ATTRIBUTE_NAME = substrb(p_str, l_pl + 1); ');
15794: l(' RETURN l_id; ');
15795: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15796: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15797: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15798: l(' FND_MSG_PUB.ADD; ');
15799: l(' RAISE FND_API.G_EXC_ERROR; ');
15800: l(' END get_attrib_id; ');
15801:

Line 16200: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');

16196: l(' WHEN OTHERS THEN') ;
16197: l(' OPEN c_rule_name(l_condition_match_rule_id);');
16198: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16199: l(' CLOSE c_rule_name; ');
16200: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16201: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16202: l(' FND_MSG_PUB.ADD; ');
16203: l(' RAISE; ');
16204: l('END;');

Line 16201: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');

16197: l(' OPEN c_rule_name(l_condition_match_rule_id);');
16198: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16199: l(' CLOSE c_rule_name; ');
16200: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16201: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16202: l(' FND_MSG_PUB.ADD; ');
16203: l(' RAISE; ');
16204: l('END;');
16205: --End of Bug No: 4234203