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_PARTY_MERGE dependencies on FND_MESSAGE

Line 517: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');

513: -- If batch not found error out
514: IF (p_batch_id IS NOT NULL) THEN
515: l_batch_id := TO_NUMBER(p_batch_id);
516: ELSE
517: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
518: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;

Line 518: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);

514: IF (p_batch_id IS NOT NULL) THEN
515: l_batch_id := TO_NUMBER(p_batch_id);
516: ELSE
517: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
518: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:

Line 528: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');

524: OPEN c_batch(l_batch_id);
525: FETCH c_batch INTO l_batch_name, l_rule_set_name, l_batch_status,
526: l_batch_delete, l_batch_commit;
527: IF (c_batch%NOTFOUND) THEN
528: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
529: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
530: FND_MSG_PUB.ADD;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;

Line 529: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);

525: FETCH c_batch INTO l_batch_name, l_rule_set_name, l_batch_status,
526: l_batch_delete, l_batch_commit;
527: IF (c_batch%NOTFOUND) THEN
528: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
529: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
530: FND_MSG_PUB.ADD;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:

Line 536: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');

532: END IF;
533:
534: -- If batch already complete error out
535: IF (l_batch_status = 'COMPLETE') THEN
536: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');
537: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;

Line 537: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);

533:
534: -- If batch already complete error out
535: IF (l_batch_status = 'COMPLETE') THEN
536: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');
537: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: CLOSE c_batch;

Line 551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');

547: p_ext_party => l_ext_party,
548: p_merge_ok => l_ret_merge_ok);
549:
550: IF (l_ret_merge_ok = 'N') THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
552: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
553: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
554: FND_MSG_PUB.ADD;
555: RAISE FND_API.G_EXC_ERROR;

Line 552: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);

548: p_merge_ok => l_ret_merge_ok);
549:
550: IF (l_ret_merge_ok = 'N') THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
552: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
553: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
554: FND_MSG_PUB.ADD;
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;

Line 553: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);

549:
550: IF (l_ret_merge_ok = 'N') THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
552: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
553: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
554: FND_MSG_PUB.ADD;
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557:

Line 733: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

729: -- Fetch the dictionary id for the HZ_PARTIES entity
730: OPEN c_dict_id(l_rule_set_name,'HZ_PARTIES');
731: FETCH c_dict_id INTO l_dict_id;
732: IF c_dict_id%NOTFOUND THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
734: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');
735: FND_MSG_PUB.ADD;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;

Line 734: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');

730: OPEN c_dict_id(l_rule_set_name,'HZ_PARTIES');
731: FETCH c_dict_id INTO l_dict_id;
732: IF c_dict_id%NOTFOUND THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
734: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');
735: FND_MSG_PUB.ADD;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: CLOSE c_dict_id;

Line 774: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

770:
771: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_SITES');
772: FETCH c_dict_id INTO l_dict_id;
773: IF c_dict_id%NOTFOUND THEN
774: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
775: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;

Line 775: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');

771: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_SITES');
772: FETCH c_dict_id INTO l_dict_id;
773: IF c_dict_id%NOTFOUND THEN
774: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
775: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779: CLOSE c_dict_id;

Line 821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

817: if l_return_status = FND_API.G_RET_STS_SUCCESS then
818: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
819: FETCH c_dict_id INTO l_dict_id;
820: IF c_dict_id%NOTFOUND THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;

Line 822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');

818: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
819: FETCH c_dict_id INTO l_dict_id;
820: IF c_dict_id%NOTFOUND THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826: CLOSE c_dict_id;

Line 874: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

870: if l_return_status = FND_API.G_RET_STS_SUCCESS then
871: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_RELATIONSHIPS');
872: FETCH c_dict_id INTO l_dict_id;
873: IF c_dict_id%NOTFOUND THEN
874: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
875: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');
876: FND_MSG_PUB.ADD;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;

Line 875: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');

871: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_RELATIONSHIPS');
872: FETCH c_dict_id INTO l_dict_id;
873: IF c_dict_id%NOTFOUND THEN
874: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
875: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');
876: FND_MSG_PUB.ADD;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: CLOSE c_dict_id;

Line 943: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_TYPE');

939: CLOSE c_batch_relationships;
940: end if; --l_return_status
941:
942: ELSE --type of merge
943: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_TYPE');
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF; --type of merge
947:

Line 1354: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

1350: BEGIN
1351: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1352: FETCH c_dict_id INTO l_dict_id, l_desc;
1353: IF c_dict_id%NOTFOUND THEN
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1355: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
1356: FND_MSG_PUB.ADD;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;

Line 1355: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');

1351: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1352: FETCH c_dict_id INTO l_dict_id, l_desc;
1353: IF c_dict_id%NOTFOUND THEN
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1355: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
1356: FND_MSG_PUB.ADD;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359: CLOSE c_dict_id;

Line 1481: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

1477: l_fk_column_name, l_parent_entity_name;
1478:
1479: -- If not found error out
1480: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1482: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
1483: FND_MSG_PUB.ADD;
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;

Line 1482: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);

1478:
1479: -- If not found error out
1480: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1482: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
1483: FND_MSG_PUB.ADD;
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486: CLOSE c_dict_details;

Line 1681: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

1677:
1678: -- Invalid subentity in dictionary .. error out
1679: IF (l_sub_entity_name is null or l_sub_fk_column_name is null or
1680: l_sub_fk_column_name is null) THEN
1681: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1682: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1683: FND_MSG_PUB.ADD;
1684:
1685: x_error_msg:=logerror;

Line 1682: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);

1678: -- Invalid subentity in dictionary .. error out
1679: IF (l_sub_entity_name is null or l_sub_fk_column_name is null or
1680: l_sub_fk_column_name is null) THEN
1681: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1682: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1683: FND_MSG_PUB.ADD;
1684:
1685: x_error_msg:=logerror;
1686: store_merge_log(p_batch_party_id, -1,

Line 1764: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

1760: END IF;
1761: END IF;
1762: l_subrec_str:=NULL;
1763: ELSE
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1765: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
1766: FND_MSG_PUB.ADD;
1767:
1768: x_error_msg:=logerror;

Line 1765: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);

1761: END IF;
1762: l_subrec_str:=NULL;
1763: ELSE
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1765: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
1766: FND_MSG_PUB.ADD;
1767:
1768: x_error_msg:=logerror;
1769: store_merge_log(p_batch_party_id, -1,

Line 1789: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

1785: FETCH c_dict_details INTO l_proc_name_b, l_pk_column_name_b,l_desc_column_name_b,
1786: l_fk_column_name_b, l_parent_entity_name_b;
1787: -- If not found error out
1788: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1790: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;

Line 1790: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);

1786: l_fk_column_name_b, l_parent_entity_name_b;
1787: -- If not found error out
1788: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1790: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794: CLOSE c_dict_details;

Line 1908: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');

1904: l_fk_column_name_b, l_parent_entity_name_b;
1905:
1906: -- If not found error out
1907: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1909: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;

Line 1909: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);

1905:
1906: -- If not found error out
1907: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1909: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913: CLOSE c_dict_details;

Line 2022: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2018: END IF;
2019:
2020: EXCEPTION
2021: WHEN OTHERS THEN
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
2024: FND_MSG_PUB.ADD;
2025:
2026: x_error_msg:=logerror;

Line 2023: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);

2019:
2020: EXCEPTION
2021: WHEN OTHERS THEN
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
2024: FND_MSG_PUB.ADD;
2025:
2026: x_error_msg:=logerror;
2027: store_merge_log(p_batch_party_id, -1,

Line 2061: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');

2057: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2058:
2059: EXCEPTION
2060: WHEN OTHERS THEN
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2062: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2063: FND_MSG_PUB.ADD;
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: END lock_batch;

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

2058:
2059: EXCEPTION
2060: WHEN OTHERS THEN
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2062: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2063: FND_MSG_PUB.ADD;
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: END lock_batch;
2066:

Line 2188: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');

2184: END LOOP;
2185: CLOSE c_dict_details;
2186: EXCEPTION
2187: WHEN OTHERS THEN
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2191: FND_MSG_PUB.ADD;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2189: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);

2185: CLOSE c_dict_details;
2186: EXCEPTION
2187: WHEN OTHERS THEN
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2191: FND_MSG_PUB.ADD;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: END lock_records;

Line 2190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);

2186: EXCEPTION
2187: WHEN OTHERS THEN
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2191: FND_MSG_PUB.ADD;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: END lock_records;
2194:

Line 2251: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');

2247: END LOOP;
2248: log('Delete complete');
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');
2252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2253: FND_MSG_PUB.ADD;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: END delete_merged_records;

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

2248: log('Delete complete');
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');
2252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2253: FND_MSG_PUB.ADD;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: END delete_merged_records;
2256:

Line 2297: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');

2293: EXECUTE IMMEDIATE rec_query INTO l_desc USING p_record_pk;
2294: RETURN '"' || l_desc || '" (ID:' || p_record_pk || ')';
2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2298: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2300: FND_MSG_PUB.ADD;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2298: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);

2294: RETURN '"' || l_desc || '" (ID:' || p_record_pk || ')';
2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2298: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2300: FND_MSG_PUB.ADD;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: RETURN NULL;

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

2295: EXCEPTION
2296: WHEN OTHERS THEN
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2298: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2300: FND_MSG_PUB.ADD;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: RETURN NULL;
2303: END get_record_desc;

Line 2334: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');

2330: EXECUTE IMMEDIATE rec_query INTO l_desc USING p_record_pk;
2331: RETURN '"' || l_desc || '" (ROWID:' || p_record_pk || ')';
2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2337: FND_MSG_PUB.ADD;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2335: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);

2331: RETURN '"' || l_desc || '" (ROWID:' || p_record_pk || ')';
2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2337: FND_MSG_PUB.ADD;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2339: RETURN NULL;

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

2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2337: FND_MSG_PUB.ADD;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2339: RETURN NULL;
2340: END get_record_desc_r;

Line 2423: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2419: log('****** Error executing merge procedure : ' || p_proc_name );
2420: log('for table : ' || p_entity_name);
2421: log('Data exists in table for the merge-to party. Aborting merge');
2422: log('');
2423: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2425: FND_MSG_PUB.ADD;
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: END exec_merge;

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

2420: log('for table : ' || p_entity_name);
2421: log('Data exists in table for the merge-to party. Aborting merge');
2422: log('');
2423: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2425: FND_MSG_PUB.ADD;
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: END exec_merge;
2428:

Line 2509: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2505: log('****** Error executing merge procedure : ' || p_proc_name );
2506: log('for table : ' || p_entity_name);
2507: log('Data exists in table for the merge-to party. Aborting merge');
2508: log('');
2509: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2510: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2511: FND_MSG_PUB.ADD;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: END exec_merge_r;

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

2506: log('for table : ' || p_entity_name);
2507: log('Data exists in table for the merge-to party. Aborting merge');
2508: log('');
2509: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2510: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2511: FND_MSG_PUB.ADD;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: END exec_merge_r;
2514:

Line 2566: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2562: log('****** Error executing merge procedure : ' || p_proc_name );
2563: log('for table : ' || p_entity_name);
2564: log('Data exists in table for the merge-to party. Aborting merge');
2565: log('');
2566: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2568: FND_MSG_PUB.ADD;
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570: END exec_merge;

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

2563: log('for table : ' || p_entity_name);
2564: log('Data exists in table for the merge-to party. Aborting merge');
2565: log('');
2566: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2568: FND_MSG_PUB.ADD;
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570: END exec_merge;
2571:

Line 2668: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2664: H_op_type(H_Counter) := p_op_type;
2665:
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2670: FND_MSG_PUB.ADD;
2671: RAISE FND_API.G_EXC_ERROR;
2672: END store_merge_history;

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

2665:
2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2670: FND_MSG_PUB.ADD;
2671: RAISE FND_API.G_EXC_ERROR;
2672: END store_merge_history;
2673:

Line 2773: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

2769: EXCEPTION
2770: WHEN OTHERS THEN
2771: -- ROLLBACK to batch_merge;
2772: ROLLBACK; -- bug 3947633
2773: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END store_merge_log;

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

2770: WHEN OTHERS THEN
2771: -- ROLLBACK to batch_merge;
2772: ROLLBACK; -- bug 3947633
2773: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END store_merge_log;
2778:

Line 2924: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');

2920: OPEN pre_batch(p_batch_id);
2921: FETCH pre_batch INTO l_batch_name, l_rule_set_name,
2922: l_batch_status, l_batch_delete,l_batch_commit;
2923: IF (pre_batch%NOTFOUND) THEN
2924: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
2925: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
2926: FND_MSG_PUB.ADD;
2927: RAISE FND_API.G_EXC_ERROR;
2928: END IF;

Line 2925: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);

2921: FETCH pre_batch INTO l_batch_name, l_rule_set_name,
2922: l_batch_status, l_batch_delete,l_batch_commit;
2923: IF (pre_batch%NOTFOUND) THEN
2924: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
2925: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
2926: FND_MSG_PUB.ADD;
2927: RAISE FND_API.G_EXC_ERROR;
2928: END IF;
2929: CLOSE pre_batch;

Line 3203: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

3199: EXCEPTION
3200: WHEN OTHERS THEN
3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202:
3203: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3205: FND_MSG_PUB.ADD;
3206:
3207: FND_MSG_PUB.Count_And_Get(

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

3200: WHEN OTHERS THEN
3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202:
3203: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3205: FND_MSG_PUB.ADD;
3206:
3207: FND_MSG_PUB.Count_And_Get(
3208: p_encoded => FND_API.G_FALSE,

Line 3246: /* FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

3242:
3243: RETURN dtype;
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: /* FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: RAISE FND_API.G_EXC_ERROR;*/
3250: RETURN NULL;

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

3243: RETURN dtype;
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: /* FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: RAISE FND_API.G_EXC_ERROR;*/
3250: RETURN NULL;
3251: END;

Line 3288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

3284:
3285: RETURN l_data_type;
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3290: FND_MSG_PUB.ADD;
3291: RAISE FND_API.G_EXC_ERROR;
3292: END get_col_type;

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

3285: RETURN l_data_type;
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3290: FND_MSG_PUB.ADD;
3291: RAISE FND_API.G_EXC_ERROR;
3292: END get_col_type;
3293:

Line 3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

3358: EXCEPTION
3359: WHEN OTHERS THEN
3360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3361:
3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3363: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3364: FND_MSG_PUB.ADD;
3365:
3366: FND_MSG_PUB.Count_And_Get(

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

3359: WHEN OTHERS THEN
3360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3361:
3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3363: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3364: FND_MSG_PUB.ADD;
3365:
3366: FND_MSG_PUB.Count_And_Get(
3367: p_count => x_msg_count,

Line 4589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

4585:
4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: log('Error in setup DNB data: '||SQLERRM);
4589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4591: FND_MSG_PUB.ADD;
4592: APP_EXCEPTION.RAISE_EXCEPTION;
4593: END;

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

4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: log('Error in setup DNB data: '||SQLERRM);
4589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4591: FND_MSG_PUB.ADD;
4592: APP_EXCEPTION.RAISE_EXCEPTION;
4593: END;
4594:

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

4660: CLOSE c_from_ps_loc;
4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: log('Error in DNB insert rel party site details : '||SQLERRM);
4664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4666: APP_EXCEPTION.RAISE_EXCEPTION;
4667: END insert_party_site_details;
4668:

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

4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: log('Error in DNB insert rel party site details : '||SQLERRM);
4664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4665: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4666: APP_EXCEPTION.RAISE_EXCEPTION;
4667: END insert_party_site_details;
4668:
4669: PROCEDURE check_int_ext_party_type(

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

4801:
4802: EXCEPTION
4803: WHEN OTHERS THEN
4804: log('Error in check internal/external party type: '||SQLERRM);
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4807: FND_MSG_PUB.ADD;
4808: APP_EXCEPTION.RAISE_EXCEPTION;
4809: END check_int_ext_party_type;

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

4802: EXCEPTION
4803: WHEN OTHERS THEN
4804: log('Error in check internal/external party type: '||SQLERRM);
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4807: FND_MSG_PUB.ADD;
4808: APP_EXCEPTION.RAISE_EXCEPTION;
4809: END check_int_ext_party_type;
4810: