eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_COMPILE dependencies on FND_MSG_PUB

Line 533: FND_MSG_PUB.initialize;

529: l_rule_id := TO_NUMBER(p_rule_id);
530: l_package_name := 'HZ_MATCH_RULE_'||p_rule_id;
531:
532: -- Initialize message stack
533: FND_MSG_PUB.initialize;
534:
535: BEGIN
536: -- Verify that the match rule exists
537: SELECT 1 INTO l_batch_flag

Line 544: FND_MSG_PUB.ADD;

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:
548:

Line 556: FND_MSG_PUB.ADD;

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
560: HZ_POP_MRULE_SET_ATTR_V2PUB.pop_mrule_set_attributes(l_rule_id);

Line 590: FND_MSG_PUB.ADD;

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;
594:

Line 608: FND_MSG_PUB.ADD;

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;
612:

Line 650: FND_MSG_PUB.Count_And_Get(

646:
647: EXECUTE IMMEDIATE 'ALTER PACKAGE ' || l_package_name || ' COMPILE SPECIFICATION'; --bug 5622345
648:
649: --Standard call to get message count and if count is 1, get message info.
650: FND_MSG_PUB.Count_And_Get(
651: p_encoded => FND_API.G_FALSE,
652: p_count => x_msg_count,
653: p_data => x_msg_data);
654:

Line 674: FND_MSG_PUB.Count_And_Get(

670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: FND_MSG_PUB.Count_And_Get(
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data);
678: x_return_status := FND_API.G_RET_STS_ERROR;

Line 682: FND_MSG_PUB.Count_And_Get(

678: x_return_status := FND_API.G_RET_STS_ERROR;
679: UPDATE HZ_MATCH_RULES_B SET COMPILATION_FLAG = 'U' WHERE MATCH_RULE_ID = l_rule_id;
680: COMMIT;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: FND_MSG_PUB.Count_And_Get(
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 694: FND_MSG_PUB.ADD;

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,
698: p_count => x_msg_count,

Line 696: FND_MSG_PUB.Count_And_Get(

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,
698: p_count => x_msg_count,
699: p_data => x_msg_data);
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 832: l(' FND_MSG_PUB.initialize;');

828: d(fnd_log.level_statement,'Rule ID','p_rule_id');
829: l(' -- Initialize return status and message stack');
830: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
831: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
832: l(' FND_MSG_PUB.initialize;');
833: l(' END IF;');
834: l('');
835: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
836: l(' -- Find the match rule');

Line 841: l(' FND_MSG_PUB.ADD;');

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:
845: l(' OPEN c_match_rule;');

Line 849: l(' FND_MSG_PUB.ADD;');

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:
853: FIRST := TRUE;

Line 868: l(' FND_MSG_PUB.ADD;');

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:
872: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties(');

Line 918: l(' FND_MSG_PUB.initialize;');

914: d(fnd_log.level_statement,'Rule ID','p_rule_id');
915: l(' -- Initialize return status and message stack');
916: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
917: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
918: l(' FND_MSG_PUB.initialize;');
919: l(' END IF;');
920: l('');
921: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
922: l(' -- Find the match rule');

Line 927: l(' FND_MSG_PUB.ADD;');

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:
931: l(' OPEN c_match_rule;');

Line 935: l(' FND_MSG_PUB.ADD;');

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
939: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.find_persons(-1,'||

Line 960: l(' FND_MSG_PUB.ADD;');

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(');
964: l(' p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,');

Line 968: l(' FND_MSG_PUB.ADD;');

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:
972: END LOOP;

Line 1038: l(' FND_MSG_PUB.initialize;');

1034: l('');
1035: l(' -- Initialize return status and message stack');
1036: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1037: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1038: l(' FND_MSG_PUB.initialize;');
1039: l(' END IF;');
1040: l('');
1041: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1042: l(' -- Find the match rule');

Line 1047: l(' FND_MSG_PUB.ADD;');

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:
1051: l(' OPEN c_match_rule;');

Line 1055: l(' FND_MSG_PUB.ADD;');

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:
1059: FIRST := TRUE;

Line 1074: l(' FND_MSG_PUB.ADD;');

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:
1078: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_party_details(');

Line 1117: l(' FND_MSG_PUB.initialize;');

1113: l('');
1114: l(' -- Initialize return status and message stack');
1115: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1116: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1117: l(' FND_MSG_PUB.initialize;');
1118: l(' END IF;');
1119: l('');
1120: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1121: l(' -- Find the match rule');

Line 1126: l(' FND_MSG_PUB.ADD;');

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:
1130: l(' IF g_last_rule<>p_rule_id OR NOT g_last_rule_valid THEN');

Line 1135: l(' FND_MSG_PUB.ADD;');

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;');
1139: l(' g_last_rule_valid := TRUE;');

Line 1157: l(' FND_MSG_PUB.ADD;');

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:
1161: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_parties(');

Line 1201: l(' FND_MSG_PUB.initialize;');

1197: l('');
1198: l(' -- Initialize return status and message stack');
1199: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1200: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1201: l(' FND_MSG_PUB.initialize;');
1202: l(' END IF;');
1203: l('');
1204: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1205: l(' -- Find the match rule');

Line 1210: l(' FND_MSG_PUB.ADD;');

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:
1214: l(' OPEN c_match_rule;');

Line 1218: l(' FND_MSG_PUB.ADD;');

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:
1222: FIRST := TRUE;

Line 1237: l(' FND_MSG_PUB.ADD;');

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:
1241: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_party_sites(');

Line 1280: l(' FND_MSG_PUB.initialize;');

1276: l('');
1277: l(' -- Initialize return status and message stack');
1278: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1279: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1280: l(' FND_MSG_PUB.initialize;');
1281: l(' END IF;');
1282: l('');
1283: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1284: l(' -- Find the match rule');

Line 1289: l(' FND_MSG_PUB.ADD;');

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:
1293: l(' OPEN c_match_rule;');

Line 1297: l(' FND_MSG_PUB.ADD;');

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:
1301: FIRST := TRUE;

Line 1316: l(' FND_MSG_PUB.ADD;');

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:
1320: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contacts(');

Line 1359: l(' FND_MSG_PUB.initialize;');

1355: l('');
1356: l(' -- Initialize return status and message stack');
1357: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1358: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1359: l(' FND_MSG_PUB.initialize;');
1360: l(' END IF;');
1361: l('');
1362: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1363: l(' -- Find the match rule');

Line 1368: l(' FND_MSG_PUB.ADD;');

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:
1372: l(' OPEN c_match_rule;');

Line 1376: l(' FND_MSG_PUB.ADD;');

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:
1380: FIRST := TRUE;

Line 1395: l(' FND_MSG_PUB.ADD;');

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:
1399: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_duplicate_contact_points(');

Line 1477: l(' FND_MSG_PUB.initialize;');

1473: l('');
1474: l(' -- Initialize return status and message stack');
1475: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1476: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1477: l(' FND_MSG_PUB.initialize;');
1478: l(' END IF;');
1479: l('');
1480: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1481: l(' -- Find the match rule');

Line 1486: l(' FND_MSG_PUB.ADD;');

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:
1490: l(' OPEN c_match_rule;');

Line 1494: l(' FND_MSG_PUB.ADD;');

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:
1498: FIRST := TRUE;

Line 1513: l(' FND_MSG_PUB.ADD;');

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:
1517: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.find_parties_dynamic(');

Line 1604: l(' FND_MSG_PUB.initialize;');

1600: l('');
1601: l(' -- Initialize return status and message stack');
1602: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1603: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1604: l(' FND_MSG_PUB.initialize;');
1605: l(' END IF;');
1606: l('');
1607: l(' IF p_rule_id IS NULL OR p_rule_id = 0 THEN');
1608: l(' -- Find the match rule');

Line 1613: l(' FND_MSG_PUB.ADD;');

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:
1617: l(' OPEN c_match_rule;');

Line 1621: l(' FND_MSG_PUB.ADD;');

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:
1625: l_sql := 'declare x number; y number; begin HZ_MATCH_RULE_RULEID.call_api_dynamic(null,null,'||

Line 1648: l(' FND_MSG_PUB.ADD;');

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:
1652: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.call_api_dynamic(');

Line 1665: l(' FND_MSG_PUB.ADD;');

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:
1669: END LOOP;

Line 1735: l(' FND_MSG_PUB.initialize;');

1731: l('');
1732: l(' -- Initialize return status and message stack');
1733: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1734: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1735: l(' FND_MSG_PUB.initialize;');
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');

Line 1741: l(' FND_MSG_PUB.ADD;');

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:
1745: l(' OPEN c_match_rule;');

Line 1749: l(' FND_MSG_PUB.ADD;');

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:
1753: FIRST := TRUE;

Line 1768: l(' FND_MSG_PUB.ADD;');

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(');
1772: l(' p_rule_id, p_party_id,p_party_site_list, p_contact_point_list,');

Line 1838: l(' FND_MSG_PUB.initialize;');

1834: l('');
1835: l(' -- Initialize return status and message stack');
1836: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1837: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1838: l(' FND_MSG_PUB.initialize;');
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');

Line 1844: l(' FND_MSG_PUB.ADD;');

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:
1848: l(' OPEN c_match_rule;');

Line 1852: l(' FND_MSG_PUB.ADD;');

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:
1856: FIRST := TRUE;

Line 1871: l(' FND_MSG_PUB.ADD;');

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(');
1875: l(' p_rule_id, p_party_id,p_contact_list, p_contact_point_list,');

Line 1937: l(' FND_MSG_PUB.initialize;');

1933: l('');
1934: l(' -- Initialize return status and message stack');
1935: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
1936: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
1937: l(' FND_MSG_PUB.initialize;');
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');

Line 1943: l(' FND_MSG_PUB.ADD;');

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:
1947: l(' OPEN c_match_rule;');

Line 1951: l(' FND_MSG_PUB.ADD;');

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:
1955: FIRST := TRUE;

Line 1970: l(' FND_MSG_PUB.ADD;');

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:
1974: l(' HZ_MATCH_RULE_'||RULE.MATCH_RULE_ID||'.get_matching_contact_points(');

Line 2042: l(' FND_MSG_PUB.initialize;');

2038: l('');
2039: l(' -- Initialize return status and message stack');
2040: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2041: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2042: l(' FND_MSG_PUB.initialize;');
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');

Line 2048: l(' FND_MSG_PUB.ADD;');

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:
2052: l(' OPEN c_match_rule;');

Line 2056: l(' FND_MSG_PUB.ADD;');

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:
2060: FIRST := TRUE;

Line 2075: l(' FND_MSG_PUB.ADD;');

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(');
2079: l(' p_rule_id,');

Line 2115: l(' FND_MSG_PUB.initialize;');

2111: l('');
2112: l(' -- Initialize return status and message stack');
2113: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2114: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2115: l(' FND_MSG_PUB.initialize;');
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');

Line 2121: l(' FND_MSG_PUB.ADD;');

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:
2125: l(' OPEN c_match_rule;');

Line 2129: l(' FND_MSG_PUB.ADD;');

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:
2133: FIRST := TRUE;

Line 2148: l(' FND_MSG_PUB.ADD;');

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(');
2152: l(' p_party_id, x_party_search_rec,x_party_site_list,');

Line 2190: l(' FND_MSG_PUB.initialize;');

2186: l('');
2187: l(' -- Initialize return status and message stack');
2188: l(' x_return_status := FND_API.G_RET_STS_SUCCESS;');
2189: l(' IF FND_API.to_Boolean(p_init_msg_list) THEN');
2190: l(' FND_MSG_PUB.initialize;');
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');

Line 2196: l(' FND_MSG_PUB.ADD;');

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:
2200: l(' OPEN c_match_rule;');

Line 2204: l(' FND_MSG_PUB.ADD;');

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:
2208: FIRST := TRUE;

Line 2223: l(' FND_MSG_PUB.ADD;');

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(');
2227: l(' p_party_id, p_party_site_ids, p_contact_ids, p_contact_pt_ids, x_party_search_rec,x_party_site_list,');

Line 2819: l(' FND_MSG_PUB.ADD;');

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;');
2823: l(' RETURN l_contains_str;');

Line 3062: l(' FND_MSG_PUB.ADD;');

3058: l(' exception');
3059: l(' when others then');
3060: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3061: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3062: l(' FND_MSG_PUB.ADD;');
3063: l(' RAISE FND_API.G_EXC_ERROR;');
3064: --Start Bug No: 3032742.
3065: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3066: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3067: l(' FND_MSG_PUB.ADD;');

3063: l(' RAISE FND_API.G_EXC_ERROR;');
3064: --Start Bug No: 3032742.
3065: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3066: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3067: l(' FND_MSG_PUB.ADD;');
3068: l(' RAISE FND_API.G_EXC_ERROR;');
3069: --End Bug No : 3032742.
3070: l(' else ');
3071: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 3312: l(' FND_MSG_PUB.ADD;');

3308: l(' p_party_site_list,');
3309: l(' p_contact_list,');
3310: l(' p_contact_point_list) THEN');
3311: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
3312: l(' FND_MSG_PUB.ADD;');
3313: l(' RAISE FND_API.G_EXC_ERROR;');
3314: l(' END IF;');
3315: IF l_max_score=1 THEN
3316: ldbg_s('In init_search calling util package set_no_score');

Line 3561: l(' FND_MSG_PUB.ADD;');

3557: END LOOP;
3558: l(' IF lengthb(l_party_contains_str) > 4000 THEN');
3559: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_SEARCH_CRIT_LARGE_ERROR'');');
3560: l(' FND_MESSAGE.SET_TOKEN(''ENTITY'',''PARTY'');');
3561: l(' FND_MSG_PUB.ADD;');
3562: l(' RAISE FND_API.G_EXC_ERROR;');
3563: l(' END IF;');
3564: l(' IF (p_match_str = '' AND '' OR p_party_max_score 3565: ldbg_s('party contains string returned by init_search is an AND between these strings ');

Line 3974: l(' FND_MSG_PUB.ADD;');

3970: l(' exception');
3971: l(' when others then');
3972: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
3973: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
3974: l(' FND_MSG_PUB.ADD;');
3975: l(' RAISE FND_API.G_EXC_ERROR;');
3976: --Start Bug No: 3032742.
3977: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3978: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3979: l(' FND_MSG_PUB.ADD;');

3975: l(' RAISE FND_API.G_EXC_ERROR;');
3976: --Start Bug No: 3032742.
3977: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
3978: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3979: l(' FND_MSG_PUB.ADD;');
3980: l(' RAISE FND_API.G_EXC_ERROR;');
3981: --Bug: 3392837
3982: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3983: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 3984: l(' FND_MSG_PUB.ADD;');

3980: l(' RAISE FND_API.G_EXC_ERROR;');
3981: --Bug: 3392837
3982: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
3983: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
3984: l(' FND_MSG_PUB.ADD;');
3985: l(' RAISE FND_API.G_EXC_ERROR;');
3986: --End Bug No : 3032742.
3987: l(' else ');
3988: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 3990: l(' FND_MSG_PUB.ADD;');

3986: --End Bug No : 3032742.
3987: l(' else ');
3988: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
3989: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
3990: l(' FND_MSG_PUB.ADD;');
3991: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3992: l(' end if;');
3993: l(' END;');
3994: l('');

Line 4254: l(' FND_MSG_PUB.ADD;');

4250: l(' exception');
4251: l(' when others then');
4252: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4253: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4254: l(' FND_MSG_PUB.ADD;');
4255: l(' RAISE FND_API.G_EXC_ERROR;');
4256: --Start Bug No: 3032742.
4257: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4259: l(' FND_MSG_PUB.ADD;');

4255: l(' RAISE FND_API.G_EXC_ERROR;');
4256: --Start Bug No: 3032742.
4257: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4259: l(' FND_MSG_PUB.ADD;');
4260: l(' RAISE FND_API.G_EXC_ERROR;');
4261: --Bug: 3392837
4262: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4263: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4264: l(' FND_MSG_PUB.ADD;');

4260: l(' RAISE FND_API.G_EXC_ERROR;');
4261: --Bug: 3392837
4262: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4263: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4264: l(' FND_MSG_PUB.ADD;');
4265: l(' RAISE FND_API.G_EXC_ERROR;');
4266: --End Bug No : 3032742.
4267: l(' else ');
4268: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4270: l(' FND_MSG_PUB.ADD;');

4266: --End Bug No : 3032742.
4267: l(' else ');
4268: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4269: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4270: l(' FND_MSG_PUB.ADD;');
4271: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4272: l(' end if;');
4273: l(' END;');
4274: l('');

Line 4422: l(' FND_MSG_PUB.ADD;');

4418: l(' exception');
4419: l(' when others then');
4420: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4421: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4422: l(' FND_MSG_PUB.ADD;');
4423: l(' RAISE FND_API.G_EXC_ERROR;');
4424: --Start Bug No: 3032742.
4425: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4426: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4427: l(' FND_MSG_PUB.ADD;');

4423: l(' RAISE FND_API.G_EXC_ERROR;');
4424: --Start Bug No: 3032742.
4425: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4426: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4427: l(' FND_MSG_PUB.ADD;');
4428: l(' RAISE FND_API.G_EXC_ERROR;');
4429: --Bug: 3392837
4430: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4431: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4432: l(' FND_MSG_PUB.ADD;');

4428: l(' RAISE FND_API.G_EXC_ERROR;');
4429: --Bug: 3392837
4430: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4431: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4432: l(' FND_MSG_PUB.ADD;');
4433: l(' RAISE FND_API.G_EXC_ERROR;');
4434: --End Bug No : 3032742.
4435: l(' else ');
4436: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4438: l(' FND_MSG_PUB.ADD;');

4434: --End Bug No : 3032742.
4435: l(' else ');
4436: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4437: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4438: l(' FND_MSG_PUB.ADD;');
4439: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4440: l(' end if;');
4441: l(' END;');
4442: l('');

Line 4734: l(' FND_MSG_PUB.ADD;');

4730: l(' exception');
4731: l(' when others then');
4732: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
4733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
4734: l(' FND_MSG_PUB.ADD;');
4735: l(' RAISE FND_API.G_EXC_ERROR;');
4736: --Start Bug No: 3032742.
4737: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4738: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4739: l(' FND_MSG_PUB.ADD;');

4735: l(' RAISE FND_API.G_EXC_ERROR;');
4736: --Start Bug No: 3032742.
4737: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
4738: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4739: l(' FND_MSG_PUB.ADD;');
4740: l(' RAISE FND_API.G_EXC_ERROR;');
4741: --Bug: 3392837
4742: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4743: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 4744: l(' FND_MSG_PUB.ADD;');

4740: l(' RAISE FND_API.G_EXC_ERROR;');
4741: --Bug: 3392837
4742: l(' elsif (instrb(SQLERRM,''ORA-20000'')>0) then ');
4743: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
4744: l(' FND_MSG_PUB.ADD;');
4745: l(' RAISE FND_API.G_EXC_ERROR;');
4746: --End Bug No : 3032742.
4747: l(' else ');
4748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');

Line 4750: l(' FND_MSG_PUB.ADD;');

4746: --End Bug No : 3032742.
4747: l(' else ');
4748: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_API_OTHERS_EXCEP'');');
4749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4750: l(' FND_MSG_PUB.ADD;');
4751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4752: l(' end if;');
4753: l(' END;');
4754: l('');

Line 4998: l(' FND_MSG_PUB.ADD;');

4994: l(' ELSE');
4995: l(' IF p_index>1 THEN');
4996: ldbg_s('In eval party level number of matches found exceeded threshold');
4997: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
4998: l(' FND_MSG_PUB.ADD;');
4999: l(' RAISE FND_API.G_EXC_ERROR;');
5000: l(' ELSE');
5001: l(' push_eval;');
5002: l(' RETURN;');

Line 5048: l(' FND_MSG_PUB.ADD;');

5044: l(' CLOSE l_party_cur;'); --Bug No: 3872745
5045: l(' IF p_index>1 THEN');
5046: ldbg_s('In eval party level estimated hits exceed threshold');
5047: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5048: l(' FND_MSG_PUB.ADD;');
5049: l(' RAISE FND_API.G_EXC_ERROR;');
5050: l(' ELSE');
5051: l(' push_eval;');
5052: l(' RETURN;');

Line 5110: l(' FND_MSG_PUB.ADD;');

5106: ldbg_s('In eval party site level estimated hits exceed threshold');
5107: l(' IF p_index>1 THEN');
5108: ldbg_s('In eval party site level number of matches found exceeded threshold');
5109: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5110: l(' FND_MSG_PUB.ADD;');
5111: l(' RAISE FND_API.G_EXC_ERROR;');
5112: l(' ELSE');
5113: l(' push_eval;');
5114: l(' RETURN;');

Line 5207: l(' FND_MSG_PUB.ADD;');

5203: ldbg_s('In eval contact level estimated hits exceed threshold');
5204: l(' IF p_index>1 THEN');
5205: ldbg_s('In eval contact level number of matches found exceeded threshold');
5206: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5207: l(' FND_MSG_PUB.ADD;');
5208: l(' RAISE FND_API.G_EXC_ERROR;');
5209: l(' ELSE');
5210: l(' push_eval;');
5211: l(' RETURN;');

Line 5304: l(' FND_MSG_PUB.ADD;');

5300: ldbg_s('In eval contact point level estimated hits exceed threshold');
5301: l(' IF p_index>1 THEN');
5302: ldbg_s('In eval contact point level number of matches found exceeded threshold');
5303: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5304: l(' FND_MSG_PUB.ADD;');
5305: l(' RAISE FND_API.G_EXC_ERROR;');
5306: l(' ELSE');
5307: l(' push_eval;');
5308: l(' RETURN;');

Line 5509: l(' FND_MSG_PUB.ADD; ');

5505: l(' RETURN; ');
5506: l(' ELSE ');
5507: ldbg_s('In do eval number of matches found exceeded threshold');
5508: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
5509: l(' FND_MSG_PUB.ADD; ');
5510: l(' RAISE FND_API.G_EXC_ERROR; ');
5511: l(' END IF; ');
5512: --end of Bug No:5218095
5513: l(' ELSE');

Line 5516: l(' FND_MSG_PUB.ADD;');

5512: --end of Bug No:5218095
5513: l(' ELSE');
5514: ldbg_s('In do eval number of matches found exceeded threshold');
5515: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5516: l(' FND_MSG_PUB.ADD;');
5517: l(' RAISE FND_API.G_EXC_ERROR;');
5518: l(' END IF; ');
5519: l(' END IF;');
5520: --End of Bug No: 4407425

Line 5523: l(' FND_MSG_PUB.ADD;');

5519: l(' END IF;');
5520: --End of Bug No: 4407425
5521: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
5522: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
5523: l(' FND_MSG_PUB.ADD;');
5524: l(' RAISE FND_API.G_EXC_ERROR;');
5525: l(' END IF;');
5526: */
5527: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 5817: l(' FND_MSG_PUB.ADD;');

5813: l(' WHEN OTHERS THEN');
5814: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
5815: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
5816: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
5817: l(' FND_MSG_PUB.ADD;');
5818: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
5819: l('END find_parties;');
5820: l('');
5821:

Line 6022: l(' FND_MSG_PUB.ADD;');

6018: l(' ELSE');
6019: l(' IF p_index>1 THEN');
6020: ldbg_s('In eval party level number of matches found exceeded threshold');
6021: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6022: l(' FND_MSG_PUB.ADD;');
6023: l(' RAISE FND_API.G_EXC_ERROR;');
6024: l(' ELSE');
6025: l(' push_eval;');
6026: l(' RETURN;');

Line 6075: l(' FND_MSG_PUB.ADD;');

6071: l(' CLOSE l_party_cur;'); --Bug No: 3872745
6072: l(' IF p_index>1 THEN');
6073: ldbg_s('In eval party level number of matches found exceeded threshold');
6074: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6075: l(' FND_MSG_PUB.ADD;');
6076: l(' RAISE FND_API.G_EXC_ERROR;');
6077: l(' ELSE');
6078: l(' push_eval;');
6079: l(' RETURN;');

Line 6112: l(' FND_MSG_PUB.ADD;');

6108: l(' exception');
6109: l(' when others then');
6110: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
6111: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
6112: l(' FND_MSG_PUB.ADD;');
6113: l(' RAISE FND_API.G_EXC_ERROR;');
6114: --Start Bug No: 3032742.
6115: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6116: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 6117: l(' FND_MSG_PUB.ADD;');

6113: l(' RAISE FND_API.G_EXC_ERROR;');
6114: --Start Bug No: 3032742.
6115: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
6116: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
6117: l(' FND_MSG_PUB.ADD;');
6118: l(' RAISE FND_API.G_EXC_ERROR;');
6119: --End Bug No : 3032742.
6120: l(' else ');
6121: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 6194: l(' FND_MSG_PUB.ADD;');

6190: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
6191: l(' IF p_index>1 THEN');
6192: ldbg_s('In eval party site level number of matches found exceeded threshold');
6193: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6194: l(' FND_MSG_PUB.ADD;');
6195: l(' RAISE FND_API.G_EXC_ERROR;');
6196: l(' ELSE');
6197: l(' push_eval;');
6198: l(' RETURN;');

Line 6416: l(' FND_MSG_PUB.ADD;');

6412: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
6413: l(' IF p_index>1 THEN');
6414: ldbg_s('In eval contact point level number of matches found exceeded threshold');
6415: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6416: l(' FND_MSG_PUB.ADD;');
6417: l(' RAISE FND_API.G_EXC_ERROR;');
6418: l(' ELSE');
6419: l(' push_eval;');
6420: l(' RETURN;');

Line 6532: l(' FND_MSG_PUB.ADD; ');

6528: l(' RETURN; ');
6529: l(' ELSE ');
6530: ldbg_s('In do eval number of matches found exceeded threshold');
6531: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED''); ');
6532: l(' FND_MSG_PUB.ADD; ');
6533: l(' RAISE FND_API.G_EXC_ERROR; ');
6534: l(' END IF; ');
6535: --end of Bug No:5218095
6536: l(' ELSE');

Line 6539: l(' FND_MSG_PUB.ADD;');

6535: --end of Bug No:5218095
6536: l(' ELSE');
6537: ldbg_s('In do eval number of matches found exceeded threshold');
6538: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6539: l(' FND_MSG_PUB.ADD;');
6540: l(' RAISE FND_API.G_EXC_ERROR;');
6541: l(' END IF; ');
6542: l(' END IF;');
6543: --End of Bug No: 4407425

Line 6546: l(' FND_MSG_PUB.ADD;');

6542: l(' END IF;');
6543: --End of Bug No: 4407425
6544: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
6545: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
6546: l(' FND_MSG_PUB.ADD;');
6547: l(' RAISE FND_API.G_EXC_ERROR;');
6548: l(' END IF;');
6549: */
6550: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 6727: l(' FND_MSG_PUB.ADD;');

6723: l(' WHEN OTHERS THEN');
6724: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6725: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6726: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6727: l(' FND_MSG_PUB.ADD;');
6728: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6729: l('END find_persons;');
6730: l('');
6731: ELSE ---Start of Code Change for Match Rule Set

Line 6750: l(' FND_MSG_PUB.ADD;');

6746: l(' WHEN OTHERS THEN');
6747: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6748: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
6749: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6750: l(' FND_MSG_PUB.ADD;');
6751: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6752: l('END find_persons;');
6753: END IF; ---End of Code Change for Match Rule Set
6754:

Line 6824: l(' FND_MSG_PUB.ADD;');

6820: l(' WHEN OTHERS THEN');
6821: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6822: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
6823: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6824: l(' FND_MSG_PUB.ADD;');
6825: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6826: l('END find_party_details;');
6827: l('');
6828: /************** find_duplicate_parties API ***************/

Line 6942: l(' FND_MSG_PUB.ADD;');

6938: l(' WHEN OTHERS THEN');
6939: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
6940: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
6941: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
6942: l(' FND_MSG_PUB.ADD;');
6943: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
6944: l('END find_duplicate_parties;');
6945:
6946:

Line 7035: l(' FND_MSG_PUB.ADD;');

7031: l(' WHEN OTHERS THEN');
7032: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7033: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
7034: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7035: l(' FND_MSG_PUB.ADD;');
7036: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7037: l('END find_duplicate_party_sites; ');
7038: l(' ');
7039:

Line 7131: l(' FND_MSG_PUB.ADD;');

7127: l(' WHEN OTHERS THEN');
7128: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7129: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
7130: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7131: l(' FND_MSG_PUB.ADD;');
7132: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7133: l('END find_duplicate_contacts; ');
7134: l('');
7135: /************** find_duplicate_contact_points API ***************/

Line 7207: l(' FND_MSG_PUB.ADD;');

7203: l(' WHEN OTHERS THEN');
7204: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7205: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
7206: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7207: l(' FND_MSG_PUB.ADD;');
7208: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7209: l('END find_duplicate_contact_points;');
7210: l('');
7211: l('PROCEDURE find_parties_dynamic (');

Line 7449: l(' FND_MSG_PUB.ADD;');

7445: l(' WHEN OTHERS THEN');
7446: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7447: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
7448: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7449: l(' FND_MSG_PUB.ADD;');
7450: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7451:
7452:
7453: l('END call_api_dynamic; ');

Line 7722: l(' FND_MSG_PUB.ADD;');

7718: l(' WHEN OTHERS THEN');
7719: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7720: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
7721: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7722: l(' FND_MSG_PUB.ADD;');
7723: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
7724: l('END get_matching_party_sites;');
7725: l('');
7726:

Line 7998: l(' FND_MSG_PUB.ADD;');

7994: l(' WHEN OTHERS THEN');
7995: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
7996: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
7997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
7998: l(' FND_MSG_PUB.ADD;');
7999: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8000: l('END get_matching_contacts;');
8001: l('');
8002:

Line 8180: l(' FND_MSG_PUB.ADD;');

8176: l(' WHEN OTHERS THEN');
8177: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8178: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
8179: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8180: l(' FND_MSG_PUB.ADD;');
8181: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8182: l('END get_matching_contact_points;');
8183:
8184: l('');

Line 8430: l(' FND_MSG_PUB.ADD;');

8426: l(' WHEN OTHERS THEN');
8427: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8428: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
8429: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8430: l(' FND_MSG_PUB.ADD;');
8431: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8432: l('END get_score_details;');
8433: l('');
8434:

Line 8528: l(' FND_MSG_PUB.ADD;');

8524: l(' WHEN OTHERS THEN');
8525: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8526: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_parties_bulk'');');
8527: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8528: l(' FND_MSG_PUB.ADD;');
8529: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8530: l(' END check_parties_bulk ;');
8531: l('');
8532: END generate_check_parties_bulk ;

Line 8590: l(' FND_MSG_PUB.ADD;');

8586: l(' WHEN OTHERS THEN');
8587: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8588: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_sites_bulk'');');
8589: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8590: l(' FND_MSG_PUB.ADD;');
8591: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8592: l(' END check_party_sites_bulk ;');
8593: l('');
8594:

Line 8654: l(' FND_MSG_PUB.ADD;');

8650: l(' WHEN OTHERS THEN');
8651: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8652: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contacts_bulk'');');
8653: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8654: l(' FND_MSG_PUB.ADD;');
8655: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8656: l(' END check_contacts_bulk ;');
8657: l('');
8658:

Line 8716: l(' FND_MSG_PUB.ADD;');

8712: l(' WHEN OTHERS THEN');
8713: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
8714: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_cpts_bulk'');');
8715: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
8716: l(' FND_MSG_PUB.ADD;');
8717: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
8718: l(' END check_cpts_bulk ;');
8719: l('');
8720:

Line 9017: l(' FND_MSG_PUB.ADD;');

9013: l(' p_party_site_list,');
9014: l(' p_contact_list,');
9015: l(' p_contact_point_list) THEN');
9016: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_PRIMARY_COND'');');
9017: l(' FND_MSG_PUB.ADD;');
9018: l(' RAISE FND_API.G_EXC_ERROR;');
9019: l(' END IF;');
9020: IF l_max_score=1 THEN
9021: l(' HZ_DQM_SEARCH_UTIL.set_no_score;');

Line 9340: l(' FND_MSG_PUB.ADD;');

9336: l(' exception');
9337: l(' when others then');
9338: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9339: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9340: l(' FND_MSG_PUB.ADD;');
9341: l(' RAISE FND_API.G_EXC_ERROR;');
9342: l(' else ');
9343: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9344: l(' end if;');

Line 9453: l(' FND_MSG_PUB.ADD;');

9449: l(' exception');
9450: l(' when others then');
9451: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9452: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9453: l(' FND_MSG_PUB.ADD;');
9454: l(' RAISE FND_API.G_EXC_ERROR;');
9455: l(' else ');
9456: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9457: l(' end if;');

Line 9554: l(' FND_MSG_PUB.ADD;');

9550: l(' exception');
9551: l(' when others then');
9552: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9553: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9554: l(' FND_MSG_PUB.ADD;');
9555: l(' RAISE FND_API.G_EXC_ERROR;');
9556: l(' else ');
9557: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9558: l(' end if;');

Line 9661: l(' FND_MSG_PUB.ADD;');

9657: l(' exception');
9658: l(' when others then');
9659: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
9660: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
9661: l(' FND_MSG_PUB.ADD;');
9662: l(' RAISE FND_API.G_EXC_ERROR;');
9663: l(' else ');
9664: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
9665: l(' end if;');

Line 9880: l(' FND_MSG_PUB.ADD;');

9876: l(' CLOSE l_party_cur;'); --Bug No: 3872745
9877: l(' IF p_index>1 THEN');
9878: ldbg_s('In eval party level number of matches found exceeded threshold');
9879: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9880: l(' FND_MSG_PUB.ADD;');
9881: l(' RAISE FND_API.G_EXC_ERROR;');
9882: l(' ELSE');
9883: l(' push_eval;');
9884: l(' RETURN;');

Line 9952: l(' FND_MSG_PUB.ADD;');

9948: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
9949: l(' IF p_index>1 THEN');
9950: ldbg_s('In eval party site level number of matches found exceeded threshold');
9951: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
9952: l(' FND_MSG_PUB.ADD;');
9953: l(' RAISE FND_API.G_EXC_ERROR;');
9954: l(' ELSE');
9955: l(' push_eval;');
9956: l(' RETURN;');

Line 10036: l(' FND_MSG_PUB.ADD;');

10032: l(' CLOSE l_contact_cur;'); --Bug No: 3872745
10033: l(' IF p_index>1 THEN');
10034: ldbg_s('In eval contact level number of matches found exceeded threshold');
10035: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10036: l(' FND_MSG_PUB.ADD;');
10037: l(' RAISE FND_API.G_EXC_ERROR;');
10038: l(' ELSE');
10039: l(' push_eval;');
10040: l(' RETURN;');

Line 10120: l(' FND_MSG_PUB.ADD;');

10116: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10117: l(' IF p_index>1 THEN');
10118: ldbg_s('In eval contact point level number of matches found exceeded threshold');
10119: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10120: l(' FND_MSG_PUB.ADD;');
10121: l(' RAISE FND_API.G_EXC_ERROR;');
10122: l(' ELSE');
10123: l(' push_eval;');
10124: l(' RETURN;');

Line 10168: l(' FND_MSG_PUB.ADD;');

10164: l(' RETURN; ');
10165: l(' ELSE');
10166: ldbg_s('In do eval number of matches found exceeded threshold');
10167: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10168: l(' FND_MSG_PUB.ADD;');
10169: l(' RAISE FND_API.G_EXC_ERROR;');
10170: l(' END IF; ');
10171: l(' END IF;');
10172: --End of Bug No: 4407425

Line 10175: l(' FND_MSG_PUB.ADD;');

10171: l(' END IF;');
10172: --End of Bug No: 4407425
10173: /*l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
10174: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10175: l(' FND_MSG_PUB.ADD;');
10176: l(' RAISE FND_API.G_EXC_ERROR;');
10177: l(' END IF;');
10178: */
10179: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 10451: l(' FND_MSG_PUB.ADD;');

10447: l(' ROLLBACK to find_parties;');
10448: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
10449: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_parties'');');
10450: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
10451: l(' FND_MSG_PUB.ADD;');
10452: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
10453: l('END find_parties;');
10454: l('');
10455:

Line 10675: l(' FND_MSG_PUB.ADD;');

10671: l(' CLOSE l_party_cur;'); --Bug No: 3872745
10672: l(' IF p_index>1 THEN');
10673: ldbg_s('In eval party level number of matches found exceeded threshold');
10674: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10675: l(' FND_MSG_PUB.ADD;');
10676: l(' RAISE FND_API.G_EXC_ERROR;');
10677: l(' ELSE');
10678: l(' push_eval;');
10679: l(' RETURN;');

Line 10712: l(' FND_MSG_PUB.ADD;');

10708: l(' exception');
10709: l(' when others then');
10710: l(' if (instrb(SQLERRM,''DRG-51030'')>0) then ');
10711: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_WILDCARD_ERR'');');
10712: l(' FND_MSG_PUB.ADD;');
10713: l(' RAISE FND_API.G_EXC_ERROR;');
10714: --Start Bug No: 3032742.
10715: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10716: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');

Line 10717: l(' FND_MSG_PUB.ADD;');

10713: l(' RAISE FND_API.G_EXC_ERROR;');
10714: --Start Bug No: 3032742.
10715: l(' elsif (instrb(SQLERRM,''DRG-50943'')>0) then ');
10716: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_SEARCH_ERROR'');');
10717: l(' FND_MSG_PUB.ADD;');
10718: l(' RAISE FND_API.G_EXC_ERROR;');
10719: --End Bug No : 3032742.
10720: l(' else ');
10721: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 10799: l(' FND_MSG_PUB.ADD;');

10795: l(' CLOSE l_party_site_cur;'); --Bug No: 3872745
10796: l(' IF p_index>1 THEN');
10797: ldbg_s('In eval party site level number of matches found exceeded threshold');
10798: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
10799: l(' FND_MSG_PUB.ADD;');
10800: l(' RAISE FND_API.G_EXC_ERROR;');
10801: l(' ELSE');
10802: l(' push_eval;');
10803: l(' RETURN;');

Line 10955: l(' FND_MSG_PUB.ADD;');

10951: l(' CLOSE l_contact_pt_cur;'); --Bug No: 3872745
10952: l(' IF p_index>1 THEN');
10953: ldbg_s('In eval contact point level number of matches found exceeded threshold');
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(' ELSE');
10958: l(' push_eval;');
10959: l(' RETURN;');

Line 11003: l(' FND_MSG_PUB.ADD;');

10999: l(' RETURN; ');
11000: l(' ELSE');
11001: ldbg_s('In do eval number of matches found exceeded threshold');
11002: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
11003: l(' FND_MSG_PUB.ADD;');
11004: l(' RAISE FND_API.G_EXC_ERROR;');
11005: l(' END IF; ');
11006: l(' END IF;');
11007: --End of Bug No: 4407425

Line 11011: l(' FND_MSG_PUB.ADD;');

11007: --End of Bug No: 4407425
11008: /*
11009: l(' IF p_index=5 AND call_order(5) <> ''NONE'' AND H_PARTY_ID.COUNT=0 THEN');
11010: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_THRESH_EXCEEDED'');');
11011: l(' FND_MSG_PUB.ADD;');
11012: l(' RAISE FND_API.G_EXC_ERROR;');
11013: l(' END IF;');
11014: */
11015: l(' IF call_order(p_index) = ''PARTY'' AND l_party_contains_str IS NOT NULL THEN');

Line 11164: l(' FND_MSG_PUB.ADD;');

11160: l(' ROLLBACK to find_persons;');
11161: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11162: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_persons'');');
11163: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11164: l(' FND_MSG_PUB.ADD;');
11165: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11166: l('END find_persons;');
11167: ELSE
11168: l('BEGIN');

Line 11170: l(' FND_MSG_PUB.ADD;');

11166: l('END find_persons;');
11167: ELSE
11168: l('BEGIN');
11169: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_INVALID_MATCH_RULE'');');
11170: l(' FND_MSG_PUB.ADD;');
11171: l(' RAISE FND_API.G_EXC_ERROR;');
11172: l('END find_persons;');
11173: l('');
11174: END IF;

Line 11244: l(' FND_MSG_PUB.ADD;');

11240: l(' WHEN OTHERS THEN');
11241: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11242: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_party_details'');');
11243: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11244: l(' FND_MSG_PUB.ADD;');
11245: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11246: l('END find_party_details;');
11247: l('');
11248: l('-------------------------------------------------------------------------------------');

Line 11336: l(' FND_MSG_PUB.ADD;');

11332: l(' WHEN OTHERS THEN');
11333: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11334: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_parties'');');
11335: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11336: l(' FND_MSG_PUB.ADD;');
11337: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11338: l('END find_duplicate_parties;');
11339:
11340:

Line 11431: l(' FND_MSG_PUB.ADD;');

11427: l(' WHEN OTHERS THEN');
11428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11429: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_party_sites'');');
11430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11431: l(' FND_MSG_PUB.ADD;');
11432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11433: l('END find_duplicate_party_sites; ');
11434: l(' ');
11435:

Line 11529: l(' FND_MSG_PUB.ADD;');

11525: l(' WHEN OTHERS THEN');
11526: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11527: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contacts'');');
11528: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11529: l(' FND_MSG_PUB.ADD;');
11530: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11531: l('END find_duplicate_contacts; ');
11532: l('');
11533: l('-------------------------------------------------------------------------------------');

Line 11607: l(' FND_MSG_PUB.ADD;');

11603: l(' WHEN OTHERS THEN');
11604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11605: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.find_duplicate_contact_points'');');
11606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11607: l(' FND_MSG_PUB.ADD;');
11608: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11609: l('END find_duplicate_contact_points;');
11610: l('');
11611:

Line 11850: l(' FND_MSG_PUB.ADD;');

11846: l(' WHEN OTHERS THEN');
11847: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
11848: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.call_api_dynamic'');');
11849: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
11850: l(' FND_MSG_PUB.ADD;');
11851: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
11852:
11853:
11854: l('END call_api_dynamic;');

Line 12091: l(' FND_MSG_PUB.ADD;');

12087: l(' ROLLBACK to get_matching_party_sites ;');
12088: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12089: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_party_sites'');');
12090: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12091: l(' FND_MSG_PUB.ADD;');
12092: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12093: l('END get_matching_party_sites;');
12094: l('');
12095:

Line 12333: l(' FND_MSG_PUB.ADD;');

12329: l(' ROLLBACK to get_matching_contacts ;');
12330: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12331: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contacts'');');
12332: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12333: l(' FND_MSG_PUB.ADD;');
12334: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12335: l('END get_matching_contacts;');
12336: l('');
12337: l('-------------------------------------------------------------------------------------');

Line 12494: l(' FND_MSG_PUB.ADD;');

12490: l(' ROLLBACK to get_matching_contact_points ;');
12491: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12492: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_matching_contact_points'');');
12493: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12494: l(' FND_MSG_PUB.ADD;');
12495: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12496: l('END get_matching_contact_points;');
12497:
12498: l('');

Line 12736: l(' FND_MSG_PUB.ADD;');

12732: l(' DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;');
12733: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
12734: l(' FND_MESSAGE.SET_TOKEN(''PROC'','''||p_pkg_name||'.get_score_details'');');
12735: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
12736: l(' FND_MSG_PUB.ADD;');
12737: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12738: l('END get_score_details;');
12739: l('');
12740:

Line 12969: l(' FND_MSG_PUB.ADD;');

12965: l(' WHEN OTHERS THEN');
12966: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
12967: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
12968: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
12969: l(' FND_MSG_PUB.ADD;');
12970: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
12971: l('END;');
12972:
12973: END generate_party_map_proc_bulk ;

Line 13161: l(' FND_MSG_PUB.ADD;');

13157: l(' WHEN OTHERS THEN');
13158: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13159: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13160: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13161: l(' FND_MSG_PUB.ADD;');
13162: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13163: l('END;');
13164:
13165: END generate_map_proc;

Line 13261: l(' FND_MSG_PUB.ADD;');

13257: l(' WHEN OTHERS THEN');
13258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13259: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13260: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13261: l(' FND_MSG_PUB.ADD;');
13262: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13263: l('END;');
13264:
13265: END ;

Line 13479: l(' FND_MSG_PUB.ADD;');

13475: l(' WHEN OTHERS THEN');
13476: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13477: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13478: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13479: l(' FND_MSG_PUB.ADD;');
13480: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13481: l('END;');
13482:
13483: END generate_map_proc_bulk ;

Line 13685: l(' FND_MSG_PUB.ADD;');

13681: l(' WHEN OTHERS THEN');
13682: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_TRANSFORM_PROC_ERROR'');');
13683: l(' FND_MESSAGE.SET_TOKEN(''PROC'' , ''' || p_proc_name || ''');');
13684: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
13685: l(' FND_MSG_PUB.ADD;');
13686: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13687: l('END;');
13688:
13689: END generate_party_map_proc;

Line 13735: l(' FND_MSG_PUB.ADD;');

13731: END LOOP;
13732: IF NOT FIRST THEN
13733: l(' ) THEN');
13734: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
13735: l(' FND_MSG_PUB.ADD;');
13736: l(' RAISE FND_API.G_EXC_ERROR;');
13737: l(' END IF;');
13738: l(' END LOOP;');
13739: l('');

Line 13788: l(' FND_MSG_PUB.ADD;');

13784: l(' WHEN OTHERS THEN');
13785: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13786: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_prim_cond'');');
13787: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13788: l(' FND_MSG_PUB.ADD;');
13789: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13790: l(' END check_prim_cond;');
13791: l('');
13792:

Line 13924: l(' FND_MSG_PUB.ADD;');

13920: l(' WHEN OTHERS THEN');
13921: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
13922: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_party_site_cond'');');
13923: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
13924: l(' FND_MSG_PUB.ADD;');
13925: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
13926: l(' END check_party_site_cond;');
13927: l('');
13928:

Line 14062: l(' FND_MSG_PUB.ADD;');

14058: l(' WHEN OTHERS THEN');
14059: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14060: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_cond'');');
14061: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14062: l(' FND_MSG_PUB.ADD;');
14063: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14064: l(' END check_contact_cond;');
14065: l('');
14066:

Line 14085: l(' FND_MSG_PUB.ADD;');

14081: l('');
14082: l(' FOR I IN 1..p_contact_point_list.COUNT LOOP');
14083: l(' IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN ');
14084: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_NO_CONTACT_POINT_TYPE'');');
14085: l(' FND_MSG_PUB.ADD;');
14086: l(' RAISE FND_API.G_EXC_ERROR;');
14087: l(' END IF;');
14088: l(' END LOOP;');
14089: l('');

Line 14149: l(' FND_MSG_PUB.ADD;');

14145: l(' WHEN OTHERS THEN');
14146: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14147: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''check_contact_point_cond'');');
14148: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14149: l(' FND_MSG_PUB.ADD;');
14150: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14151: l(' END check_contact_point_cond;');
14152: l('');
14153:

Line 14431: l(' FND_MSG_PUB.ADD;');

14427: l(' WHEN OTHERS THEN');
14428: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14429: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_for_search'');');
14430: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14431: l(' FND_MSG_PUB.ADD;');
14432: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14433: l('END get_party_for_search;');
14434: l('');
14435:

Line 14566: l(' FND_MSG_PUB.ADD;');

14562: l(' WHEN OTHERS THEN');
14563: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
14564: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_search_criteria'');');
14565: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14566: l(' FND_MSG_PUB.ADD;');
14567: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
14568: l('END get_search_criteria;');
14569: l('');
14570:

Line 14815: l(' FND_MSG_PUB.ADD;');

14811: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14812: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_rec'');');
14813: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',p_party_id);');
14814: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14815: l(' FND_MSG_PUB.ADD;');
14816: l(' RAISE FND_API.G_EXC_ERROR;');
14817: l('END get_party_rec;');
14818: l('');
14819: l('/************************************************');

Line 14904: l(' FND_MSG_PUB.ADD;');

14900: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14901: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_party_site_rec'');');
14902: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_party_site_id);');
14903: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14904: l(' FND_MSG_PUB.ADD;');
14905: l(' RAISE FND_API.G_EXC_ERROR;');
14906: l('END get_party_site_rec;');
14907: l('');
14908:

Line 14998: l(' FND_MSG_PUB.ADD;');

14994: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
14995: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_rec'');');
14996: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_org_contact_id);');
14997: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
14998: l(' FND_MSG_PUB.ADD;');
14999: l(' RAISE FND_API.G_EXC_ERROR;');
15000: l('END get_contact_rec;');
15001: l('');
15002: l('/************************************************');

Line 15093: l(' FND_MSG_PUB.ADD;');

15089: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_PARTY_QUERY_ERROR'');');
15090: l(' FND_MESSAGE.SET_TOKEN(''PROC'',''get_contact_point_rec'');');
15091: l(' FND_MESSAGE.SET_TOKEN(''PARTY_ID'',l_contact_point_id);');
15092: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM );');
15093: l(' FND_MSG_PUB.ADD;');
15094: l(' RAISE FND_API.G_EXC_ERROR;');
15095: l('END get_contact_point_rec;');
15096:
15097: END;

Line 15584: l(' FND_MSG_PUB.Count_And_Get(');

15580: PROCEDURE gen_exception_block IS
15581:
15582: BEGIN
15583: l(' --Standard call to get message count and if count is 1, get message info');
15584: l(' FND_MSG_PUB.Count_And_Get(');
15585: l(' p_encoded => FND_API.G_FALSE,');
15586: l(' p_count => x_msg_count,');
15587: l(' p_data => x_msg_data);');
15588: l(' EXCEPTION');

Line 15591: l(' FND_MSG_PUB.Count_And_Get(');

15587: l(' p_data => x_msg_data);');
15588: l(' EXCEPTION');
15589: l(' WHEN FND_API.G_EXC_ERROR THEN');
15590: l(' x_return_status := FND_API.G_RET_STS_ERROR;');
15591: l(' FND_MSG_PUB.Count_And_Get(');
15592: l(' p_encoded => FND_API.G_FALSE,');
15593: l(' p_count => x_msg_count,');
15594: l(' p_data => x_msg_data);');
15595: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');

Line 15597: l(' FND_MSG_PUB.Count_And_Get(');

15593: l(' p_count => x_msg_count,');
15594: l(' p_data => x_msg_data);');
15595: l(' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN');
15596: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15597: l(' FND_MSG_PUB.Count_And_Get(');
15598: l(' p_encoded => FND_API.G_FALSE,');
15599: l(' p_count => x_msg_count,');
15600: l(' p_data => x_msg_data);');
15601: l('');

Line 15607: l(' FND_MSG_PUB.ADD;');

15603: l(' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
15604: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_API_ERROR'');');
15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15607: l(' FND_MSG_PUB.ADD;');
15608: l('');
15609: l(' FND_MSG_PUB.Count_And_Get(');
15610: l(' p_encoded => FND_API.G_FALSE,');
15611: l(' p_count => x_msg_count,');

Line 15609: l(' FND_MSG_PUB.Count_And_Get(');

15605: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''HZ_PARTY_SEARCH'');');
15606: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
15607: l(' FND_MSG_PUB.ADD;');
15608: l('');
15609: l(' FND_MSG_PUB.Count_And_Get(');
15610: l(' p_encoded => FND_API.G_FALSE,');
15611: l(' p_count => x_msg_count,');
15612: l(' p_data => x_msg_data);');
15613: END;

Line 15647: FND_MSG_PUB.initialize;

15643:
15644: BEGIN
15645:
15646: -- Initialize return status and message stack
15647: FND_MSG_PUB.initialize;
15648:
15649: l_cur_date := SYSDATE;
15650:
15651: UPDATE HZ_MATCH_RULES_B SET compilation_flag = 'U'

Line 15715: FND_MSG_PUB.initialize;

15711: outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
15712: outandlog('NEWLINE');
15713:
15714: -- Initialize return status and message stack
15715: FND_MSG_PUB.initialize;
15716:
15717: l_cur_date := SYSDATE;
15718:
15719: log('');

Line 15824: FND_MSG_PUB.Reset;

15820: RETURN VARCHAR2 IS
15821:
15822: l_msg_data VARCHAR2(2000);
15823: BEGIN
15824: FND_MSG_PUB.Reset;
15825:
15826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15827: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15828: END LOOP;

Line 15826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

15822: l_msg_data VARCHAR2(2000);
15823: BEGIN
15824: FND_MSG_PUB.Reset;
15825:
15826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15827: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15828: END LOOP;
15829: IF (SQLERRM IS NOT NULL) THEN
15830: l_msg_data := l_msg_data || SQLERRM;

Line 15827: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

15823: BEGIN
15824: FND_MSG_PUB.Reset;
15825:
15826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
15827: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
15828: END LOOP;
15829: IF (SQLERRM IS NOT NULL) THEN
15830: l_msg_data := l_msg_data || SQLERRM;
15831: END IF;

Line 15856: l(' FND_MSG_PUB.ADD; ');

15852: l(' RETURN l_id; ');
15853: l(' EXCEPTION WHEN NO_DATA_FOUND THEN ');
15854: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_DQM_NOATTRIB_ERROR'' ); ');
15855: l(' FND_MESSAGE.SET_TOKEN(''ENTITY_ATTRIBUTE'' ,p_str); ');
15856: l(' FND_MSG_PUB.ADD; ');
15857: l(' RAISE FND_API.G_EXC_ERROR; ');
15858: l(' END get_attrib_id; ');
15859:
15860: l(' PROCEDURE call_api_dynamic_names (');

Line 16064: FND_MSG_PUB.initialize;

16060: l_has_errors BOOLEAN := FALSE;
16061: BEGIN
16062:
16063: -- Initialize return status and message stack
16064: FND_MSG_PUB.initialize;
16065:
16066: log('');
16067:
16068: OPEN c_rulesets_for_compile ;

Line 16260: l(' FND_MSG_PUB.ADD; ');

16256: l(' FETCH c_rule_name INTO l_cond_rule_name;');
16257: l(' CLOSE c_rule_name; ');
16258: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MATCH_RULE_SRCH_ERROR''); ');
16259: l(' FND_MESSAGE.SET_TOKEN(''MATCH_RULE'',l_cond_rule_name); ');
16260: l(' FND_MSG_PUB.ADD; ');
16261: l(' RAISE; ');
16262: l('END;');
16263: --End of Bug No: 4234203
16264: END pop_conditions;