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 540: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');

536: -- If batch not found error out
537: IF (p_batch_id IS NOT NULL) THEN
538: l_batch_id := TO_NUMBER(p_batch_id);
539: ELSE
540: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
541: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
542: FND_MSG_PUB.ADD;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;

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

537: IF (p_batch_id IS NOT NULL) THEN
538: l_batch_id := TO_NUMBER(p_batch_id);
539: ELSE
540: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
541: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
542: FND_MSG_PUB.ADD;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545:

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

547: OPEN c_batch(l_batch_id);
548: FETCH c_batch INTO l_batch_name, l_rule_set_name, l_batch_status,
549: l_batch_delete, l_batch_commit;
550: IF (c_batch%NOTFOUND) THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
552: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;

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

548: FETCH c_batch INTO l_batch_name, l_rule_set_name, l_batch_status,
549: l_batch_delete, l_batch_commit;
550: IF (c_batch%NOTFOUND) THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
552: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
553: FND_MSG_PUB.ADD;
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:

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

555: END IF;
556:
557: -- If batch already complete error out
558: IF (l_batch_status = 'COMPLETE') THEN
559: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');
560: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
561: FND_MSG_PUB.ADD;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;

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

556:
557: -- If batch already complete error out
558: IF (l_batch_status = 'COMPLETE') THEN
559: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');
560: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
561: FND_MSG_PUB.ADD;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: CLOSE c_batch;

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

570: p_ext_party => l_ext_party,
571: p_merge_ok => l_ret_merge_ok);
572:
573: IF (l_ret_merge_ok = 'N') THEN
574: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
575: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
576: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
577: FND_MSG_PUB.ADD;
578: RAISE FND_API.G_EXC_ERROR;

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

571: p_merge_ok => l_ret_merge_ok);
572:
573: IF (l_ret_merge_ok = 'N') THEN
574: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
575: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
576: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
577: FND_MSG_PUB.ADD;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;

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

572:
573: IF (l_ret_merge_ok = 'N') THEN
574: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
575: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
576: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
577: FND_MSG_PUB.ADD;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:

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

766: -- Fetch the dictionary id for the HZ_PARTIES entity
767: OPEN c_dict_id(l_rule_set_name,'HZ_PARTIES');
768: FETCH c_dict_id INTO l_dict_id;
769: IF c_dict_id%NOTFOUND THEN
770: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
771: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;

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

767: OPEN c_dict_id(l_rule_set_name,'HZ_PARTIES');
768: FETCH c_dict_id INTO l_dict_id;
769: IF c_dict_id%NOTFOUND THEN
770: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
771: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: CLOSE c_dict_id;

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

807:
808: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_SITES');
809: FETCH c_dict_id INTO l_dict_id;
810: IF c_dict_id%NOTFOUND THEN
811: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
812: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;

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

808: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_SITES');
809: FETCH c_dict_id INTO l_dict_id;
810: IF c_dict_id%NOTFOUND THEN
811: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
812: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;
816: CLOSE c_dict_id;

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

854: if l_return_status = FND_API.G_RET_STS_SUCCESS then
855: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
856: FETCH c_dict_id INTO l_dict_id;
857: IF c_dict_id%NOTFOUND THEN
858: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
859: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;

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

855: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
856: FETCH c_dict_id INTO l_dict_id;
857: IF c_dict_id%NOTFOUND THEN
858: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
859: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863: CLOSE c_dict_id;

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

907: if l_return_status = FND_API.G_RET_STS_SUCCESS then
908: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_RELATIONSHIPS');
909: FETCH c_dict_id INTO l_dict_id;
910: IF c_dict_id%NOTFOUND THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
912: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;

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

908: OPEN c_dict_id(l_rule_set_name,'HZ_PARTY_RELATIONSHIPS');
909: FETCH c_dict_id INTO l_dict_id;
910: IF c_dict_id%NOTFOUND THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
912: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916: CLOSE c_dict_id;

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

976: CLOSE c_batch_relationships;
977: end if; --l_return_status
978:
979: ELSE --type of merge
980: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_TYPE');
981: FND_MSG_PUB.ADD;
982: RAISE FND_API.G_EXC_ERROR;
983: END IF; --type of merge
984:

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

1390: BEGIN
1391: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1392: FETCH c_dict_id INTO l_dict_id, l_desc;
1393: IF c_dict_id%NOTFOUND THEN
1394: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1395: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
1396: FND_MSG_PUB.ADD;
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;

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

1391: OPEN c_dict_id(p_rule_set_name,p_entity_name);
1392: FETCH c_dict_id INTO l_dict_id, l_desc;
1393: IF c_dict_id%NOTFOUND THEN
1394: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1395: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
1396: FND_MSG_PUB.ADD;
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;
1399: CLOSE c_dict_id;

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

1517: l_fk_column_name, l_parent_entity_name;
1518:
1519: -- If not found error out
1520: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1522: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;

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

1518:
1519: -- If not found error out
1520: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1521: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1522: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526: CLOSE c_dict_details;

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

1717:
1718: -- Invalid subentity in dictionary .. error out
1719: IF (l_sub_entity_name is null or l_sub_fk_column_name is null or
1720: l_sub_fk_column_name is null) THEN
1721: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1722: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1723: FND_MSG_PUB.ADD;
1724:
1725: x_error_msg:=logerror;

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

1718: -- Invalid subentity in dictionary .. error out
1719: IF (l_sub_entity_name is null or l_sub_fk_column_name is null or
1720: l_sub_fk_column_name is null) THEN
1721: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1722: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1723: FND_MSG_PUB.ADD;
1724:
1725: x_error_msg:=logerror;
1726: store_merge_log(p_batch_party_id, -1,

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

1800: END IF;
1801: END IF;
1802: l_subrec_str:=NULL;
1803: ELSE
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
1806: FND_MSG_PUB.ADD;
1807:
1808: x_error_msg:=logerror;

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

1801: END IF;
1802: l_subrec_str:=NULL;
1803: ELSE
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
1806: FND_MSG_PUB.ADD;
1807:
1808: x_error_msg:=logerror;
1809: store_merge_log(p_batch_party_id, -1,

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

1825: FETCH c_dict_details INTO l_proc_name_b, l_pk_column_name_b,l_desc_column_name_b,
1826: l_fk_column_name_b, l_parent_entity_name_b;
1827: -- If not found error out
1828: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1830: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;

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

1826: l_fk_column_name_b, l_parent_entity_name_b;
1827: -- If not found error out
1828: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1830: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_ERROR;
1833: END IF;
1834: CLOSE c_dict_details;

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

1944: l_fk_column_name_b, l_parent_entity_name_b;
1945:
1946: -- If not found error out
1947: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1949: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: END IF;

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

1945:
1946: -- If not found error out
1947: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1948: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1949: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: END IF;
1953: CLOSE c_dict_details;

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

2058: END IF;
2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2063: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
2064: FND_MSG_PUB.ADD;
2065:
2066: x_error_msg:=logerror;

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

2059:
2060: EXCEPTION
2061: WHEN OTHERS THEN
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2063: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
2064: FND_MSG_PUB.ADD;
2065:
2066: x_error_msg:=logerror;
2067: store_merge_log(p_batch_party_id, -1,

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

2097: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2103: FND_MSG_PUB.ADD;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2105: END lock_batch;

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

2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2103: FND_MSG_PUB.ADD;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2105: END lock_batch;
2106:

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

2224: END LOOP;
2225: CLOSE c_dict_details;
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2229: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2231: FND_MSG_PUB.ADD;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2225: CLOSE c_dict_details;
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2229: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2231: FND_MSG_PUB.ADD;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233: END lock_records;

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

2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2229: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2231: FND_MSG_PUB.ADD;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233: END lock_records;
2234:

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

2287: END LOOP;
2288: log('Delete complete');
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');
2292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2293: FND_MSG_PUB.ADD;
2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2295: END delete_merged_records;

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

2288: log('Delete complete');
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');
2292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2293: FND_MSG_PUB.ADD;
2294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2295: END delete_merged_records;
2296:

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

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

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

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

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

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

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

2370: EXECUTE IMMEDIATE rec_query INTO l_desc USING p_record_pk;
2371: RETURN '"' || l_desc || '" (ROWID:' || p_record_pk || ')';
2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2375: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2377: FND_MSG_PUB.ADD;
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2371: RETURN '"' || l_desc || '" (ROWID:' || p_record_pk || ')';
2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2375: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2377: FND_MSG_PUB.ADD;
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: RETURN NULL;

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

2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2375: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2376: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2377: FND_MSG_PUB.ADD;
2378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2379: RETURN NULL;
2380: END get_record_desc_r;

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

2459: log('****** Error executing merge procedure : ' || p_proc_name );
2460: log('for table : ' || p_entity_name);
2461: log('Data exists in table for the merge-to party. Aborting merge');
2462: log('');
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2467: END exec_merge;

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

2460: log('for table : ' || p_entity_name);
2461: log('Data exists in table for the merge-to party. Aborting merge');
2462: log('');
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2465: FND_MSG_PUB.ADD;
2466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2467: END exec_merge;
2468:

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

2545: log('****** Error executing merge procedure : ' || p_proc_name );
2546: log('for table : ' || p_entity_name);
2547: log('Data exists in table for the merge-to party. Aborting merge');
2548: log('');
2549: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2551: FND_MSG_PUB.ADD;
2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2553: END exec_merge_r;

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

2546: log('for table : ' || p_entity_name);
2547: log('Data exists in table for the merge-to party. Aborting merge');
2548: log('');
2549: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2550: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2551: FND_MSG_PUB.ADD;
2552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2553: END exec_merge_r;
2554:

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

2602: log('****** Error executing merge procedure : ' || p_proc_name );
2603: log('for table : ' || p_entity_name);
2604: log('Data exists in table for the merge-to party. Aborting merge');
2605: log('');
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2608: FND_MSG_PUB.ADD;
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: END exec_merge;

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

2603: log('for table : ' || p_entity_name);
2604: log('Data exists in table for the merge-to party. Aborting merge');
2605: log('');
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2608: FND_MSG_PUB.ADD;
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2610: END exec_merge;
2611:

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

2704: H_op_type(H_Counter) := p_op_type;
2705:
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2710: FND_MSG_PUB.ADD;
2711: RAISE FND_API.G_EXC_ERROR;
2712: END store_merge_history;

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

2705:
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2710: FND_MSG_PUB.ADD;
2711: RAISE FND_API.G_EXC_ERROR;
2712: END store_merge_history;
2713:

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

2809: EXCEPTION
2810: WHEN OTHERS THEN
2811: -- ROLLBACK to batch_merge;
2812: ROLLBACK; -- bug 3947633
2813: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2815: FND_MSG_PUB.ADD;
2816: RAISE FND_API.G_EXC_ERROR;
2817: END store_merge_log;

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

2810: WHEN OTHERS THEN
2811: -- ROLLBACK to batch_merge;
2812: ROLLBACK; -- bug 3947633
2813: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2815: FND_MSG_PUB.ADD;
2816: RAISE FND_API.G_EXC_ERROR;
2817: END store_merge_log;
2818:

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

2960: OPEN pre_batch(p_batch_id);
2961: FETCH pre_batch INTO l_batch_name, l_rule_set_name,
2962: l_batch_status, l_batch_delete,l_batch_commit;
2963: IF (pre_batch%NOTFOUND) THEN
2964: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
2965: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;

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

2961: FETCH pre_batch INTO l_batch_name, l_rule_set_name,
2962: l_batch_status, l_batch_delete,l_batch_commit;
2963: IF (pre_batch%NOTFOUND) THEN
2964: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
2965: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969: CLOSE pre_batch;

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

3239: EXCEPTION
3240: WHEN OTHERS THEN
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242:
3243: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3245: FND_MSG_PUB.ADD;
3246:
3247: FND_MSG_PUB.Count_And_Get(

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

3240: WHEN OTHERS THEN
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242:
3243: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3245: FND_MSG_PUB.ADD;
3246:
3247: FND_MSG_PUB.Count_And_Get(
3248: p_encoded => FND_API.G_FALSE,

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

3282:
3283: RETURN dtype;
3284: EXCEPTION
3285: WHEN OTHERS THEN
3286: /* FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3287: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3288: FND_MSG_PUB.ADD;
3289: RAISE FND_API.G_EXC_ERROR;*/
3290: RETURN NULL;

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

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

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

3324:
3325: RETURN l_data_type;
3326: EXCEPTION
3327: WHEN OTHERS THEN
3328: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3330: FND_MSG_PUB.ADD;
3331: RAISE FND_API.G_EXC_ERROR;
3332: END get_col_type;

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

3325: RETURN l_data_type;
3326: EXCEPTION
3327: WHEN OTHERS THEN
3328: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3330: FND_MSG_PUB.ADD;
3331: RAISE FND_API.G_EXC_ERROR;
3332: END get_col_type;
3333:

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

3398: EXCEPTION
3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3401:
3402: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3404: FND_MSG_PUB.ADD;
3405:
3406: FND_MSG_PUB.Count_And_Get(

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

3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3401:
3402: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3404: FND_MSG_PUB.ADD;
3405:
3406: FND_MSG_PUB.Count_And_Get(
3407: p_count => x_msg_count,

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

4183:
4184: EXCEPTION
4185: WHEN OTHERS THEN
4186: log('Error in setup DNB data: '||SQLERRM);
4187: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4189: FND_MSG_PUB.ADD;
4190: APP_EXCEPTION.RAISE_EXCEPTION;
4191: END;

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

4184: EXCEPTION
4185: WHEN OTHERS THEN
4186: log('Error in setup DNB data: '||SQLERRM);
4187: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4188: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4189: FND_MSG_PUB.ADD;
4190: APP_EXCEPTION.RAISE_EXCEPTION;
4191: END;
4192:

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

4258: CLOSE c_from_ps_loc;
4259: EXCEPTION
4260: WHEN OTHERS THEN
4261: log('Error in DNB insert rel party site details : '||SQLERRM);
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4263: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4264: APP_EXCEPTION.RAISE_EXCEPTION;
4265: END insert_party_site_details;
4266:

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

4259: EXCEPTION
4260: WHEN OTHERS THEN
4261: log('Error in DNB insert rel party site details : '||SQLERRM);
4262: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4263: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4264: APP_EXCEPTION.RAISE_EXCEPTION;
4265: END insert_party_site_details;
4266:
4267: PROCEDURE check_int_ext_party_type(

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

4399:
4400: EXCEPTION
4401: WHEN OTHERS THEN
4402: log('Error in check internal/external party type: '||SQLERRM);
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4405: FND_MSG_PUB.ADD;
4406: APP_EXCEPTION.RAISE_EXCEPTION;
4407: END check_int_ext_party_type;

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

4400: EXCEPTION
4401: WHEN OTHERS THEN
4402: log('Error in check internal/external party type: '||SQLERRM);
4403: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4405: FND_MSG_PUB.ADD;
4406: APP_EXCEPTION.RAISE_EXCEPTION;
4407: END check_int_ext_party_type;
4408: