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_MERGE_DUP_PVT dependencies on FND_MSG_PUB

Line 134: fnd_msg_pub.initialize;

130: BEGIN
131:
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: fnd_msg_pub.initialize;
135: l_batch_id := null;
136:
137: SAVEPOINT create_merge_batch;
138:

Line 145: FND_MSG_PUB.ADD;

141: FETCH c_batch_name INTO l_batch_name, l_merge_to, l_merge_type;
142: IF c_batch_name%NOTFOUND THEN
143: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
144: FND_MESSAGE.SET_TOKEN('PARAMETER','DUP_SET_ID' );
145: FND_MSG_PUB.ADD;
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148: CLOSE c_batch_name;
149:

Line 349: FND_MSG_PUB.ADD;

345: p_object_version_number := l_object_version_number;
346: ELSE
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
348: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');
349: FND_MSG_PUB.ADD;
350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: ---Default mapping of the entities

Line 362: FND_MSG_PUB.Count_And_Get(

358:
359: x_merge_batch_id := l_batch_id;
360:
361: -- standard call to get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data);
366:

Line 371: FND_MSG_PUB.Count_And_Get(

367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK to create_merge_batch;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(
372: p_encoded => FND_API.G_FALSE,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:

Line 379: FND_MSG_PUB.Count_And_Get(

375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK to create_merge_batch;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:

Line 390: FND_MSG_PUB.ADD;

386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
390: FND_MSG_PUB.ADD;
391:
392: FND_MSG_PUB.Count_And_Get(
393: p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,

Line 392: FND_MSG_PUB.Count_And_Get(

388: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
389: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
390: FND_MSG_PUB.ADD;
391:
392: FND_MSG_PUB.Count_And_Get(
393: p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396:

Line 558: fnd_msg_pub.initialize;

554: --End of DLProject Changes
555:
556: BEGIN
557:
558: fnd_msg_pub.initialize;
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: SAVEPOINT map_detail_record;
562:

Line 572: FND_MSG_PUB.ADD;

568: IF (p_batch_party_id is null) OR (l_batch_id IS NULL )
569: OR (p_entity is null) OR (p_from_entity_id IS NULL) THEN
570: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
571: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:
576: BEGIN

Line 587: FND_MSG_PUB.ADD;

583: IF l_mm = 'Y' THEN
584: FND_MESSAGE.set_name('AR','HZ_MAND_MERGE_ERROR');
585: FND_MESSAGE.set_token('ENTITY1',p_from_entity_id);
586: FND_MESSAGE.set_token('ENTITY2',p_to_entity_id);
587: FND_MSG_PUB.ADD;
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: IF p_from_entity_id = l_merge_to THEN

Line 618: FND_MSG_PUB.ADD;

614: AND md2.merge_to_entity_id<>p_to_entity_id;
615:
616: IF l_tmp>0 OR l_tmp2>0 THEN
617: FND_MESSAGE.set_name('AR','HZ_CANNOT_UNMAP_ERROR');
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621: END IF;
622:

Line 627: FND_MSG_PUB.ADD;

623: EXCEPTION
624: WHEN NO_DATA_FOUND THEN
625: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
626: FND_MESSAGE.SET_TOKEN('PARAMETER', 'MERGE_FROM_ENTITY_ID');
627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: END;
630:
631: ---Validation for locations/Party sites

Line 652: FND_MSG_PUB.ADD;

648:
649: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
650: then
651: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_ERROR;
654: end if;
655: --bug 4569674
656: l_merge_yn := null;

Line 667: FND_MSG_PUB.ADD;

663: x_msg_count,
664: x_msg_data);
665: IF l_merge_yn = 'N' THEN
666: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 722: FND_MSG_PUB.ADD;

718: --Don't raise the error , If both the relationships are in the contact relationship group
719:
720: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
721: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:
726: END IF;

Line 834: FND_MSG_PUB.ADD;

830:
831: ELSE
832: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
833: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');
834: FND_MSG_PUB.ADD;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838:

Line 840: FND_MSG_PUB.Count_And_Get(

836: END IF;
837:
838:
839: -- standard call to get message count and if count is 1, get message info.
840: FND_MSG_PUB.Count_And_Get(
841: p_encoded => FND_API.G_FALSE,
842: p_count => x_msg_count,
843: p_data => x_msg_data);
844:

Line 849: FND_MSG_PUB.Count_And_Get(

845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: ROLLBACK to map_detail_record ;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data);
853:

Line 857: FND_MSG_PUB.Count_And_Get(

853:
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK to map_detail_record ;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:

Line 868: FND_MSG_PUB.ADD;

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865:
866: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
867: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
868: FND_MSG_PUB.ADD;
869:
870:
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,

Line 871: FND_MSG_PUB.Count_And_Get(

867: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
868: FND_MSG_PUB.ADD;
869:
870:
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_msg_count,
874: p_data => x_msg_data);
875:

Line 1011: fnd_msg_pub.initialize;

1007:
1008: BEGIN
1009:
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011: fnd_msg_pub.initialize;
1012: SAVEPOINT map_within_party;
1013:
1014: --Get the batch_id and party_id for the same party merge
1015: SELECT DISTINCT batch_id, from_party_id, to_party_id ,merge_type

Line 1025: FND_MSG_PUB.ADD;

1021: IF (p_batch_party_id is null) or (l_batch_id is null )
1022: OR (p_entity is null) or (p_from_entity_id is null) THEN
1023: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1024: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1025: FND_MSG_PUB.ADD;
1026: RAISE FND_API.G_EXC_ERROR;
1027: end if;
1028:
1029: --check if the from and to_party are the same

Line 1033: FND_MSG_PUB.ADD;

1029: --check if the from and to_party are the same
1030: IF l_from_party_id <> l_to_party_id then
1031: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1032: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1033: FND_MSG_PUB.ADD;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037:

Line 1041: FND_MSG_PUB.ADD;

1037:
1038: IF l_merge_type <> 'SAME_PARTY_MERGE' THEN
1039: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1040: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1041: FND_MSG_PUB.ADD;
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: --check if the record already exists

Line 1053: FND_MSG_PUB.ADD;

1049:
1050: IF l_map_dtl_count > 0 AND p_to_entity_id IS NOT NULL THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_REC_PRESENT');
1052: FND_MESSAGE.SET_TOKEN('ID', p_from_entity_id);
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057:

Line 1069: FND_MSG_PUB.ADD;

1065: FETCH c_loc_assignments INTO l_loc, l_org;
1066: IF c_loc_assignments%FOUND THEN
1067: CLOSE c_loc_assignments;
1068: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: */
1073: OPEN c_cust_site_check;

Line 1091: FND_MSG_PUB.ADD;

1087:
1088: if l_from_ps_status = 'A' and l_to_ps_status = 'I'
1089: then
1090: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');
1091: FND_MSG_PUB.ADD;
1092: RAISE FND_API.G_EXC_ERROR;
1093: end if;
1094:
1095: --bug 4569674

Line 1107: FND_MSG_PUB.ADD;

1103: x_msg_count,
1104: x_msg_data);
1105: IF l_merge_yn = 'N' THEN
1106: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');
1107: FND_MSG_PUB.ADD;
1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110:
1111:

Line 1134: FND_MSG_PUB.ADD;

1130: IF ( (l_from_site_party_id <> l_to_site_party_id) AND
1131: (l_from_site_party_id <> l_from_party_id) ) THEN
1132: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
1133: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137: END IF;
1138: CLOSE c_cust_site_check;

Line 1177: FND_MSG_PUB.ADD;

1173:
1174: IF l_from_rel_type <> l_to_rel_type OR l_from_dflag <> l_to_dflag THEN
1175: IF(NOT isContactGroupRelType(p_from_entity_id,p_to_entity_id)) THEN
1176: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');
1177: FND_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179: END IF;
1180: END IF;
1181:

Line 1292: FND_MSG_PUB.Count_And_Get(

1288: WHERE batch_party_id = p_batch_party_id
1289: AND ROWNUM = 1);
1290:
1291: -- standard call to get message count and if count is 1, get message info.
1292: FND_MSG_PUB.Count_And_Get(
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data);
1296:

Line 1301: FND_MSG_PUB.Count_And_Get(

1297: EXCEPTION
1298: WHEN FND_API.G_EXC_ERROR THEN
1299: ROLLBACK to map_within_party;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:

Line 1309: FND_MSG_PUB.Count_And_Get(

1305:
1306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1307: ROLLBACK to map_within_party;
1308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: FND_MSG_PUB.Count_And_Get(
1310: p_encoded => FND_API.G_FALSE,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:

Line 1320: FND_MSG_PUB.ADD;

1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1320: FND_MSG_PUB.ADD;
1321:
1322:
1323: FND_MSG_PUB.Count_And_Get(
1324: p_encoded => FND_API.G_FALSE,

Line 1323: FND_MSG_PUB.Count_And_Get(

1319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1320: FND_MSG_PUB.ADD;
1321:
1322:
1323: FND_MSG_PUB.Count_And_Get(
1324: p_encoded => FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:

Line 1386: fnd_msg_pub.initialize;

1382:
1383: BEGIN
1384:
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386: fnd_msg_pub.initialize;
1387:
1388: SAVEPOINT submit_batch;
1389:
1390: IF p_preview is null THEN

Line 1419: FND_MSG_PUB.ADD;

1415: message => l_message ) ;
1416:
1417: IF l_conc_dev_phase <> 'COMPLETE' THEN
1418: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_ERROR;
1421: ELSE
1422: IF l_conc_dev_status <>'NORMAL' THEN
1423: l_request_id := fnd_request.submit_request('AR',

Line 1433: FND_MSG_PUB.ADD;

1429:
1430: IF l_request_id = 0 THEN
1431: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1432: -- FND_MESSAGE.RETRIEVE(l_message);
1433: FND_MSG_PUB.ADD;
1434: RAISE FND_API.G_EXC_ERROR;
1435: retcode := 2;
1436: RETURN;
1437: END IF;

Line 1450: FND_MSG_PUB.ADD;

1446: FALSE,
1447: p_batch_id, l_preview );
1448: IF l_request_id = 0 THEN
1449: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1450: FND_MSG_PUB.ADD;
1451: RAISE FND_API.G_EXC_ERROR;
1452: retcode := 2;
1453: RETURN;
1454: END IF;

Line 1457: FND_MSG_PUB.ADD;

1453: RETURN;
1454: END IF;
1455: ELSE
1456: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');
1457: FND_MSG_PUB.ADD;
1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460: END IF; --l_conc_status
1461: END IF; --l_conc_dev_phase

Line 1474: FND_MSG_PUB.ADD;

1470:
1471: IF l_request_id = 0 THEN
1472: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
1473: -- FND_MESSAGE.RETRIEVE(l_message);
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: -- retcode := 2;
1477: -- RETURN;
1478: END IF;

Line 1504: FND_MSG_PUB.Count_And_Get(

1500:
1501: x_request_id := l_request_id;
1502:
1503: -- standard call to get message count and if count is 1, get message info.
1504: FND_MSG_PUB.Count_And_Get(
1505: p_encoded => FND_API.G_FALSE,
1506: p_count => x_msg_count,
1507: p_data => x_msg_data);
1508:

Line 1513: FND_MSG_PUB.Count_And_Get(

1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: ROLLBACK to submit_batch;
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get(
1514: p_encoded => FND_API.G_FALSE,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:

Line 1521: FND_MSG_PUB.Count_And_Get(

1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: ROLLBACK to submit_batch;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: FND_MSG_PUB.Count_And_Get(
1522: p_encoded => FND_API.G_FALSE,
1523: p_count => x_msg_count,
1524: p_data => x_msg_data);
1525:

Line 1532: FND_MSG_PUB.ADD;

1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529:
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1532: FND_MSG_PUB.ADD;
1533:
1534: FND_MSG_PUB.Count_And_Get(
1535: p_encoded => FND_API.G_FALSE,
1536: p_count => x_msg_count,

Line 1534: FND_MSG_PUB.Count_And_Get(

1530: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1532: FND_MSG_PUB.ADD;
1533:
1534: FND_MSG_PUB.Count_And_Get(
1535: p_encoded => FND_API.G_FALSE,
1536: p_count => x_msg_count,
1537: p_data => x_msg_data);
1538: END submit_batch;

Line 2163: fnd_msg_pub.initialize;

2159: BEGIN
2160:
2161: savepoint suggested_defaults;
2162:
2163: fnd_msg_pub.initialize;
2164: --Initialize API return status to success.
2165: x_return_status := FND_API.G_RET_STS_SUCCESS;
2166:
2167: IF(p_batch_id IS NULL OR

Line 2171: FND_MSG_PUB.ADD;

2167: IF(p_batch_id IS NULL OR
2168: p_batch_id = FND_API.G_MISS_NUM) THEN
2169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2170: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');
2171: FND_MSG_PUB.ADD;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174:
2175: open get_dup_sets_info(p_batch_id);

Line 2267: FND_MSG_PUB.ADD;

2263: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);
2264:
2265: if((l_addr_match_rule = 0) OR (l_reln_match_rule = 0)) then
2266: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
2267: FND_MSG_PUB.ADD;
2268: RAISE FND_API.G_EXC_ERROR;
2269: end if;
2270:
2271: -- call suggested defaults for address and relationship

Line 2280: FND_MSG_PUB.Count_And_Get(

2276:
2277: WHEN FND_API.G_EXC_ERROR THEN
2278: ROLLBACK TO suggested_defaults;
2279: x_return_status := FND_API.G_RET_STS_ERROR;
2280: FND_MSG_PUB.Count_And_Get(
2281: p_encoded => FND_API.G_FALSE,
2282: p_count => x_msg_count,
2283: p_data => x_msg_data);
2284:

Line 2288: FND_MSG_PUB.Count_And_Get(

2284:
2285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2286: ROLLBACK TO suggested_defaults;
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2288: FND_MSG_PUB.Count_And_Get(
2289: p_encoded => FND_API.G_FALSE,
2290: p_count => x_msg_count,
2291: p_data => x_msg_data);
2292:

Line 2298: FND_MSG_PUB.ADD;

2294: ROLLBACK TO suggested_defaults;
2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data);

Line 2299: FND_MSG_PUB.Count_And_Get(

2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data);
2303:

Line 3492: FND_MSG_PUB.Count_And_Get(

3488:
3489: WHEN FND_API.G_EXC_ERROR THEN
3490: ROLLBACK TO apply_suggested_default;
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MSG_PUB.Count_And_Get(
3493: p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:

Line 3500: FND_MSG_PUB.Count_And_Get(

3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: ROLLBACK TO apply_suggested_default;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: FND_MSG_PUB.Count_And_Get(
3501: p_encoded => FND_API.G_FALSE,
3502: p_count => x_msg_count,
3503: p_data => x_msg_data);
3504:

Line 3510: FND_MSG_PUB.ADD;

3506: ROLLBACK TO apply_suggested_default;
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3510: FND_MSG_PUB.ADD;
3511: FND_MSG_PUB.Count_And_Get(
3512: p_encoded => FND_API.G_FALSE,
3513: p_count => x_msg_count,
3514: p_data => x_msg_data);

Line 3511: FND_MSG_PUB.Count_And_Get(

3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3508: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3509: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3510: FND_MSG_PUB.ADD;
3511: FND_MSG_PUB.Count_And_Get(
3512: p_encoded => FND_API.G_FALSE,
3513: p_count => x_msg_count,
3514: p_data => x_msg_data);
3515:

Line 3708: FND_MSG_PUB.Count_And_Get(

3704:
3705: WHEN FND_API.G_EXC_ERROR THEN
3706: ROLLBACK TO clear_suggested_default;
3707: x_return_status := FND_API.G_RET_STS_ERROR;
3708: FND_MSG_PUB.Count_And_Get(
3709: p_encoded => FND_API.G_FALSE,
3710: p_count => x_msg_count,
3711: p_data => x_msg_data);
3712:

Line 3716: FND_MSG_PUB.Count_And_Get(

3712:
3713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3714: ROLLBACK TO clear_suggested_default;
3715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3716: FND_MSG_PUB.Count_And_Get(
3717: p_encoded => FND_API.G_FALSE,
3718: p_count => x_msg_count,
3719: p_data => x_msg_data);
3720:

Line 3726: FND_MSG_PUB.ADD;

3722: ROLLBACK TO clear_suggested_default;
3723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3726: FND_MSG_PUB.ADD;
3727: FND_MSG_PUB.Count_And_Get(
3728: p_encoded => FND_API.G_FALSE,
3729: p_count => x_msg_count,
3730: p_data => x_msg_data);

Line 3727: FND_MSG_PUB.Count_And_Get(

3723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3726: FND_MSG_PUB.ADD;
3727: FND_MSG_PUB.Count_And_Get(
3728: p_encoded => FND_API.G_FALSE,
3729: p_count => x_msg_count,
3730: p_data => x_msg_data);
3731:

Line 3916: fnd_msg_pub.initialize;

3912: if l_count <>0
3913: then return;
3914: end if;
3915:
3916: fnd_msg_pub.initialize;
3917:
3918: savepoint create_reln_sysbatch;
3919:
3920: update hz_merge_batch

Line 4076: FND_MSG_PUB.Count_And_Get(

4072:
4073: WHEN FND_API.G_EXC_ERROR THEN
4074: ROLLBACK TO create_reln_sysbatch;
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MSG_PUB.Count_And_Get(
4077: p_encoded => FND_API.G_FALSE,
4078: p_count => x_msg_count,
4079: p_data => x_msg_data);
4080:

Line 4084: FND_MSG_PUB.Count_And_Get(

4080:
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4082: ROLLBACK TO create_reln_sysbatch;
4083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4084: FND_MSG_PUB.Count_And_Get(
4085: p_encoded => FND_API.G_FALSE,
4086: p_count => x_msg_count,
4087: p_data => x_msg_data);
4088:

Line 4094: FND_MSG_PUB.ADD;

4090: ROLLBACK TO create_reln_sysbatch;
4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4094: FND_MSG_PUB.ADD;
4095: FND_MSG_PUB.Count_And_Get(
4096: p_encoded => FND_API.G_FALSE,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data);

Line 4095: FND_MSG_PUB.Count_And_Get(

4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4094: FND_MSG_PUB.ADD;
4095: FND_MSG_PUB.Count_And_Get(
4096: p_encoded => FND_API.G_FALSE,
4097: p_count => x_msg_count,
4098: p_data => x_msg_data);
4099:

Line 4147: fnd_msg_pub.initialize;

4143:
4144: BEGIN
4145:
4146: x_return_status := FND_API.G_RET_STS_SUCCESS;
4147: fnd_msg_pub.initialize;
4148:
4149: savepoint delete_mapping;
4150:
4151: l_batch_id := p_batch_id;

Line 4212: FND_MSG_PUB.Count_And_Get(

4208:
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: ROLLBACK TO delete_mapping;
4211: x_return_status := FND_API.G_RET_STS_ERROR;
4212: FND_MSG_PUB.Count_And_Get(
4213: p_encoded => FND_API.G_FALSE,
4214: p_count => x_msg_count,
4215: p_data => x_msg_data);
4216:

Line 4220: FND_MSG_PUB.Count_And_Get(

4216:
4217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4218: ROLLBACK TO delete_mapping;
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4220: FND_MSG_PUB.Count_And_Get(
4221: p_encoded => FND_API.G_FALSE,
4222: p_count => x_msg_count,
4223: p_data => x_msg_data);
4224:

Line 4230: FND_MSG_PUB.ADD;

4226: ROLLBACK TO delete_mapping;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4230: FND_MSG_PUB.ADD;
4231: FND_MSG_PUB.Count_And_Get(
4232: p_encoded => FND_API.G_FALSE,
4233: p_count => x_msg_count,
4234: p_data => x_msg_data);

Line 4231: FND_MSG_PUB.Count_And_Get(

4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4229: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4230: FND_MSG_PUB.ADD;
4231: FND_MSG_PUB.Count_And_Get(
4232: p_encoded => FND_API.G_FALSE,
4233: p_count => x_msg_count,
4234: p_data => x_msg_data);
4235:

Line 4296: fnd_msg_pub.initialize;

4292: AND mpd.merge_to_entity_id = cp_entity_id;
4293:
4294: BEGIN
4295:
4296: fnd_msg_pub.initialize;
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: SAVEPOINT unmap_child_records;
4300:

Line 4305: FND_MSG_PUB.ADD;

4301: IF (p_merge_batch_id is null) OR (p_merge_type IS NULL )
4302: OR (p_entity is null) OR (p_entity_id IS NULL) THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');
4304: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');
4305: FND_MSG_PUB.ADD;
4306: RAISE FND_API.G_EXC_ERROR;
4307: END IF;
4308:
4309: OPEN c_children(p_merge_batch_id, p_entity, p_entity_id);

Line 4346: FND_MSG_PUB.Count_And_Get(

4342:
4343: END IF;
4344:
4345: -- standard call to get message count and if count is 1, get message info.
4346: FND_MSG_PUB.Count_And_Get(
4347: p_encoded => FND_API.G_FALSE,
4348: p_count => x_msg_count,
4349: p_data => x_msg_data);
4350:

Line 4355: FND_MSG_PUB.Count_And_Get(

4351: EXCEPTION
4352: WHEN FND_API.G_EXC_ERROR THEN
4353: ROLLBACK to unmap_child_records ;
4354: x_return_status := FND_API.G_RET_STS_ERROR;
4355: FND_MSG_PUB.Count_And_Get(
4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data);
4359:

Line 4363: FND_MSG_PUB.Count_And_Get(

4359:
4360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4361: ROLLBACK to unmap_child_records ;
4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: FND_MSG_PUB.Count_And_Get(
4364: p_encoded => FND_API.G_FALSE,
4365: p_count => x_msg_count,
4366: p_data => x_msg_data);
4367:

Line 4374: FND_MSG_PUB.ADD;

4370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4371:
4372: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4374: FND_MSG_PUB.ADD;
4375:
4376:
4377: FND_MSG_PUB.Count_And_Get(
4378: p_encoded => FND_API.G_FALSE,

Line 4377: FND_MSG_PUB.Count_And_Get(

4373: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4374: FND_MSG_PUB.ADD;
4375:
4376:
4377: FND_MSG_PUB.Count_And_Get(
4378: p_encoded => FND_API.G_FALSE,
4379: p_count => x_msg_count,
4380: p_data => x_msg_data);
4381:

Line 4502: FND_MSG_PUB.initialize;

4498:
4499: -- Initialize message list if p_init_msg_list is set to TRUE.
4500: IF FND_API.to_Boolean( p_init_msg_list )
4501: THEN
4502: FND_MSG_PUB.initialize;
4503: END IF;
4504:
4505: if p_dup_set_id is not null -- data passed in from Data librarian(DL) UI
4506: -- or sys dup identification from FORM

Line 4518: FND_MSG_PUB.ADD;

4514: then
4515: x_return_status := FND_API.G_RET_STS_ERROR;
4516: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4517: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4518: FND_MSG_PUB.ADD;
4519: end if;
4520: end loop;
4521: close dset_overlap_merged_party_csr;
4522:

Line 4536: FND_MSG_PUB.ADD;

4532: then
4533: FND_MESSAGE.SET_NAME('AR', 'HZ_PM_MR_EXIST_DL');
4534: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4535: FND_MESSAGE.SET_TOKEN('REQUEST_ID', l_batch_id);
4536: FND_MSG_PUB.ADD;
4537: else -- from FORM UI
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');
4539: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4540: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);

Line 4541: FND_MSG_PUB.ADD;

4537: else -- from FORM UI
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');
4539: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4540: FND_MESSAGE.SET_TOKEN('BATCH_ID', l_batch_id);
4541: FND_MSG_PUB.ADD;
4542: end if;
4543: end if;
4544: end loop;
4545: close dset_overlap_req_party_csr;

Line 4572: FND_MSG_PUB.Count_And_Get(

4568:
4569: x_return_status := FND_API.G_RET_STS_ERROR;
4570: end if;
4571:
4572: FND_MSG_PUB.Count_And_Get(
4573: p_encoded => FND_API.G_FALSE,
4574: p_count => x_msg_count,
4575: p_data => x_msg_data);
4576:

Line 4608: FND_MSG_PUB.ADD;

4604: if l_err_reported = 0 then
4605: x_return_status := FND_API.G_RET_STS_ERROR;
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');
4607: FND_MESSAGE.SET_TOKEN('ID', l_party_number );
4608: FND_MSG_PUB.ADD;
4609: l_err_reported := 1;
4610: end if;
4611: end if;
4612: end loop;

Line 4622: FND_MSG_PUB.ADD;

4618: WHEN OTHERS THEN
4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4620: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4621: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4622: FND_MSG_PUB.ADD;
4623: FND_MSG_PUB.Count_And_Get(
4624: p_encoded => FND_API.G_FALSE,
4625: p_count => x_msg_count,
4626: p_data => x_msg_data);

Line 4623: FND_MSG_PUB.Count_And_Get(

4619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4620: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4621: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4622: FND_MSG_PUB.ADD;
4623: FND_MSG_PUB.Count_And_Get(
4624: p_encoded => FND_API.G_FALSE,
4625: p_count => x_msg_count,
4626: p_data => x_msg_data);
4627:

Line 4774: FND_MSG_PUB.initialize; -- make sure only show warning messages

4770: l_msg varchar2(2000);
4771: l_messages varchar2(2000) :='';
4772:
4773: begin
4774: FND_MSG_PUB.initialize; -- make sure only show warning messages
4775: x_return_status := FND_API.G_RET_STS_SUCCESS;
4776: open check_site_merge_csr;
4777: loop
4778: fetch check_site_merge_csr into l_account_number, l_to_entity_id;

Line 4789: FND_MSG_PUB.ADD;

4785:
4786: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_INFO');
4787: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4788: FND_MESSAGE.SET_TOKEN('CONCAT_DUP_ADDR', l_concat_addr);
4789: FND_MSG_PUB.ADD;
4790:
4791: elsif p_generate_note_flag = 'Y'
4792: then
4793: l_to_addr := get_addresses(l_to_entity_id,'N');

Line 4795: FND_MSG_PUB.initialize;-- only want the current message

4791: elsif p_generate_note_flag = 'Y'
4792: then
4793: l_to_addr := get_addresses(l_to_entity_id,'N');
4794:
4795: FND_MSG_PUB.initialize;-- only want the current message
4796: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');
4797: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4798: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4799: FND_MSG_PUB.ADD;

Line 4799: FND_MSG_PUB.ADD;

4795: FND_MSG_PUB.initialize;-- only want the current message
4796: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');
4797: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4798: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4799: FND_MSG_PUB.ADD;
4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4802:
4803: str := 'BEGIN '||

Line 4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4797: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);
4798: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);
4799: FND_MSG_PUB.ADD;
4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4802:
4803: str := 'BEGIN '||
4804: 'JTF_NOTES_PUB.Create_note(null,null,1,FND_API.g_false,FND_API.g_true,100,'
4805: ||':x_return_status,:x_msg_count,:x_msg_data,'||'null,'||':p_merge_batch_id,'

Line 4820: FND_MSG_PUB.Count_And_Get(

4816: close check_site_merge_csr;
4817:
4818: if p_generate_note_flag = 'N'
4819: then
4820: FND_MSG_PUB.Count_And_Get(
4821: p_encoded => FND_API.G_FALSE,
4822: p_count => x_msg_count,
4823: p_data => x_msg_data);
4824:

Line 4827: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

4823: p_data => x_msg_data);
4824:
4825: if x_msg_count = 1
4826: then
4827: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4828: else
4829: FOR l_index IN 1..x_msg_count LOOP
4830: l_msg := FND_MSG_PUB.Get(
4831: p_msg_index => l_index,

Line 4830: l_msg := FND_MSG_PUB.Get(

4826: then
4827: l_messages := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4828: else
4829: FOR l_index IN 1..x_msg_count LOOP
4830: l_msg := FND_MSG_PUB.Get(
4831: p_msg_index => l_index,
4832: p_encoded => FND_API.G_FALSE);
4833: --l_messages:=l_messages||fnd_global.local_chr(10)||l_msg||fnd_global.local_chr(10);
4834: l_messages:=l_messages||'
'||l_msg||'
';

Line 4846: FND_MSG_PUB.ADD;

4842: WHEN OTHERS THEN
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4845: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4846: FND_MSG_PUB.ADD;
4847: FND_MSG_PUB.Count_And_Get(
4848: p_encoded => FND_API.G_FALSE,
4849: p_count => x_msg_count,
4850: p_data => x_msg_data);

Line 4847: FND_MSG_PUB.Count_And_Get(

4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4845: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4846: FND_MSG_PUB.ADD;
4847: FND_MSG_PUB.Count_And_Get(
4848: p_encoded => FND_API.G_FALSE,
4849: p_count => x_msg_count,
4850: p_data => x_msg_data);
4851: