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_MESSAGE

Line 143: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

139: --check if the dup_set_id is valid
140: OPEN c_batch_name;
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;

Line 144: FND_MESSAGE.SET_TOKEN('PARAMETER','DUP_SET_ID' );

140: OPEN c_batch_name;
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;

Line 347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

343: WHERE dup_set_id = p_dup_set_id;
344:
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;

Line 348: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_dup_sets');

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

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

384: WHEN OTHERS THEN
385: ROLLBACK to create_merge_batch;
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(

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

385: ROLLBACK to create_merge_batch;
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,

Line 570: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

566: WHERE batch_party_id = p_batch_party_id;
567:
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;

Line 571: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 584: FND_MESSAGE.set_name('AR','HZ_MAND_MERGE_ERROR');

580: AND entity_name = p_entity
581: AND merge_from_entity_id = p_from_entity_id;
582:
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;

Line 585: FND_MESSAGE.set_token('ENTITY1',p_from_entity_id);

581: AND merge_from_entity_id = p_from_entity_id;
582:
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;

Line 586: FND_MESSAGE.set_token('ENTITY2',p_to_entity_id);

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

Line 617: FND_MESSAGE.set_name('AR','HZ_CANNOT_UNMAP_ERROR');

613: AND md2.merge_from_entity_id = p_to_entity_id
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;

Line 625: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

621: END IF;
622:
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;

Line 626: FND_MESSAGE.SET_TOKEN('PARAMETER', 'MERGE_FROM_ENTITY_ID');

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

Line 651: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');

647: CLOSE c_address;
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

Line 666: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

662: x_return_status,
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:

Line 721: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');

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

Line 832: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

828: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
829: WHERE BATCH_ID = l_dup_set_id;
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;

Line 833: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_merge_party_details');

829: WHERE BATCH_ID = l_dup_set_id;
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:

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

862: WHEN OTHERS THEN
863: ROLLBACK to map_detail_record;
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:

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

863: ROLLBACK to map_detail_record;
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(

Line 1023: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1019:
1020: ---Check for valid batch id
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;

Line 1024: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

1020: ---Check for valid batch id
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:

Line 1031: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1027: end if;
1028:
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;

Line 1032: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 1039: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1035: END IF;
1036:
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;

Line 1040: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

Line 1051: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_REC_PRESENT');

1047: FETCH c_map_detail_record_exist into l_map_dtl_count;
1048: CLOSE c_map_detail_record_exist;
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;

Line 1052: FND_MESSAGE.SET_TOKEN('ID', p_from_entity_id);

1048: CLOSE c_map_detail_record_exist;
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:

Line 1068: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

1064: /*OPEN c_loc_assignments(p_from_entity_id,p_to_entity_id);
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: */

Line 1090: FND_MESSAGE.set_name('AR','HZ_DL_ADDR_MASTER_ERR');

1086: CLOSE c_address;
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:

Line 1106: FND_MESSAGE.set_name('AR','HZ_PS_LOC_ASSIGN_ERROR');

1102: x_return_status,
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:

Line 1132: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

1128: --Both from and to party_site_id's should point to same party_id
1129: --and that party should be the one that is getting merged
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;

Line 1133: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

1129: --and that party should be the one that is getting merged
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;

Line 1176: FND_MESSAGE.set_name('AR','HZ_REL_NOT_SIMILAR');

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

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

1314: WHEN OTHERS THEN
1315: ROLLBACK to map_within_party;
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:

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

1315: ROLLBACK to map_within_party;
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(

Line 1418: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_PROCESSING');

1414: dev_status => l_conc_dev_status,
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

Line 1431: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1427: FALSE,
1428: p_batch_id, l_preview );
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;

Line 1432: -- FND_MESSAGE.RETRIEVE(l_message);

1428: p_batch_id, l_preview );
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;

Line 1449: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1445: to_char(sysdate,'DD-MON-YY HH24:MI:SS'),
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;

Line 1456: FND_MESSAGE.set_name('AR', 'HZ_CANNOT_SUBMIT_REQUEST');

1452: retcode := 2;
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

Line 1472: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');

1468: ,FALSE,
1469: to_char(p_batch_id), l_preview );
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;

Line 1473: -- FND_MESSAGE.RETRIEVE(l_message);

1469: to_char(p_batch_id), l_preview );
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;

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

1526: WHEN OTHERS THEN
1527: ROLLBACK to submit_batch;
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(

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

1527: ROLLBACK to submit_batch;
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,

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

1645: CLOSE merged_relns;
1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1651: APP_EXCEPTION.RAISE_EXCEPTION;
1652: END insert_reln_parties;
1653:

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

1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1651: APP_EXCEPTION.RAISE_EXCEPTION;
1652: END insert_reln_parties;
1653:
1654:

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

1752: END LOOP;
1753: CLOSE c_from_ps_loc;
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1758: APP_EXCEPTION.RAISE_EXCEPTION;
1759: END insert_party_site_details;
1760:

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

1753: CLOSE c_from_ps_loc;
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1758: APP_EXCEPTION.RAISE_EXCEPTION;
1759: END insert_party_site_details;
1760:
1761:

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

2123: END LOOP;
2124: CLOSE c_from_reln;
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2129: APP_EXCEPTION.RAISE_EXCEPTION;
2130: END insert_party_reln_details;
2131:

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

2124: CLOSE c_from_reln;
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2129: APP_EXCEPTION.RAISE_EXCEPTION;
2130: END insert_party_reln_details;
2131:
2132: /*=======================================================================+

Line 2169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2165: x_return_status := FND_API.G_RET_STS_SUCCESS;
2166:
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;

Line 2170: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DUP_SET_ID');

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

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

2262: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);
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:

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

2292:
2293: WHEN OTHERS THEN
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,

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

2293: WHEN OTHERS THEN
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,

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

2731:
2732: EXCEPTION
2733:
2734: WHEN OTHERS THEN
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2737: APP_EXCEPTION.RAISE_EXCEPTION;
2738:
2739: END suggested_party_sites;

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

2732: EXCEPTION
2733:
2734: WHEN OTHERS THEN
2735: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2737: APP_EXCEPTION.RAISE_EXCEPTION;
2738:
2739: END suggested_party_sites;
2740:

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

3158:
3159: EXCEPTION
3160:
3161: WHEN OTHERS THEN
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3164: APP_EXCEPTION.RAISE_EXCEPTION;
3165:
3166: END suggested_party_reln;

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

3159: EXCEPTION
3160:
3161: WHEN OTHERS THEN
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3164: APP_EXCEPTION.RAISE_EXCEPTION;
3165:
3166: END suggested_party_reln;
3167:

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

3302: END LOOP;
3303: CLOSE c_from_ps_loc;
3304: EXCEPTION
3305: WHEN OTHERS THEN
3306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3308: APP_EXCEPTION.RAISE_EXCEPTION;
3309: END insert_sugg_reln_ps_details;
3310:

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

3303: CLOSE c_from_ps_loc;
3304: EXCEPTION
3305: WHEN OTHERS THEN
3306: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3307: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3308: APP_EXCEPTION.RAISE_EXCEPTION;
3309: END insert_sugg_reln_ps_details;
3310:
3311: PROCEDURE insert_sugg_reln_party(

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

3352: );
3353:
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3358: APP_EXCEPTION.RAISE_EXCEPTION;
3359: END insert_sugg_reln_party;
3360:

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

3353:
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3357: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3358: APP_EXCEPTION.RAISE_EXCEPTION;
3359: END insert_sugg_reln_party;
3360:
3361: --

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

3504:
3505: WHEN OTHERS THEN
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,

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

3505: WHEN OTHERS THEN
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,

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

3720:
3721: WHEN OTHERS THEN
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,

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

3721: WHEN OTHERS THEN
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,

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

4088:
4089: WHEN OTHERS THEN
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,

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

4089: WHEN OTHERS THEN
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,

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

4224:
4225: WHEN OTHERS THEN
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,

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

4225: WHEN OTHERS THEN
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,

Line 4303: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_PARAM');

4299: SAVEPOINT unmap_child_records;
4300:
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;

Line 4304: FND_MESSAGE.SET_TOKEN('PARAMETER', 'BATCH_PARTY_ID');

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

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

4368: WHEN OTHERS THEN
4369: ROLLBACK to unmap_child_records;
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:

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

4369: ROLLBACK to unmap_child_records;
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(

Line 4516: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');

4512: exit when dset_overlap_merged_party_csr%NOTFOUND;
4513: if l_party_number is not null
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;

Line 4517: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

4513: if l_party_number is not null
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;

Line 4533: FND_MESSAGE.SET_NAME('AR', 'HZ_PM_MR_EXIST_DL');

4529: l_party_number := get_party_number(l_party_id);
4530: x_return_status := FND_API.G_RET_STS_ERROR;
4531: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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

Line 4534: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

4530: x_return_status := FND_API.G_RET_STS_ERROR;
4531: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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');

Line 4535: FND_MESSAGE.SET_TOKEN('REQUEST_ID', l_batch_id);

4531: if get_merge_batch_data_source(l_batch_id) = 'D' -- from DL UI
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 );

Line 4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_MR_EXIST_FORM_WARNING');

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);
4541: FND_MSG_PUB.ADD;
4542: end if;

Line 4539: 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);
4541: FND_MSG_PUB.ADD;
4542: end if;
4543: end if;

Line 4540: FND_MESSAGE.SET_TOKEN('BATCH_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);
4541: FND_MSG_PUB.ADD;
4542: end if;
4543: end if;
4544: end loop;

Line 4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_PARTY_ALREADY_MERGED');

4602: FND_FILE.put_line(fnd_file.log,'The Party with Registry ID ' || l_party_number || ' has already been merged.');
4603:
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;

Line 4607: FND_MESSAGE.SET_TOKEN('ID', l_party_number );

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

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

4616:
4617: EXCEPTION
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,

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

4617: EXCEPTION
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,

Line 4786: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_INFO');

4782: if p_generate_note_flag = 'N'
4783: then
4784: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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:

Line 4787: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);

4783: then
4784: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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'

Line 4788: FND_MESSAGE.SET_TOKEN('CONCAT_DUP_ADDR', l_concat_addr);

4784: l_concat_addr := get_addresses(l_to_entity_id,'Y');
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

Line 4796: FND_MESSAGE.SET_NAME('AR', 'HZ_DL_ACCTSITEDUP_NOTE');

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

Line 4797: FND_MESSAGE.SET_TOKEN('ACCTNUM', l_account_number);

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;
4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

Line 4798: FND_MESSAGE.SET_TOKEN('MERGETO_ADDR', l_to_addr);

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;
4800:
4801: l_note_text := fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
4802:

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

4840:
4841: EXCEPTION
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,

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

4841: EXCEPTION
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,