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

Line 129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');

125:
126: EXECUTE IMMEDIATE 'SELECT HZ_MATCH_RULE_'||p_rule_id||'.check_staged_var from dual' INTO l_staged_var;
127:
128: IF l_staged_var='N' THEN
129: FND_MESSAGE.SET_NAME('AR', 'HZ_MATCH_RULE_TX_NOT_STAGED');
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133:

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

263: -- Find the match rule
264: null;
265:
266: -- No MATCH RULE FOUND
267: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:

Line 273: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_NAME');

269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: IF p_batch_name IS NULL OR p_batch_name = '' THEN
273: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_NAME');
274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:

Line 290: log(fnd_message.get);

286: TRUE, p_num_workers, TO_CHAR(I), p_rule_id,
287: to_char(l_batch_id),p_subset_defn,p_match_within_subset,p_search_merged);
288: IF l_sub_requests(i) = 0 THEN
289: log('Error submitting worker ' || i);
290: log(fnd_message.get);
291: dup_workers_completed := FALSE;
292: retcode := 2;
293: ELSE
294: log('Submitted request for Worker ' || TO_CHAR(I) );

Line 424: log(fnd_message.get);

420: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AR', 'ARHAMRGP','Automerge', to_char(sysdate,'DD-MON-YY HH24:MI:SS'), TRUE, l_batch_id, p_num_workers);
421:
422: IF l_req_id = 0 THEN
423: log('Error submitting Automerge request');
424: log(fnd_message.get);
425: ELSE
426: log('Submitted request ID for Automerge: ' || l_req_id );
427: END IF;
428: -- start bug 4773387

Line 497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');

493: l_return_status, l_msg_count, l_msg_data);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: ELSE

Line 498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));

494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
497: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: ELSE
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');

522: p_count => x_msg_count,
523: p_data => x_msg_data);
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529:
530: FND_MSG_PUB.Count_And_Get(

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

523: p_data => x_msg_data);
524: WHEN OTHERS THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
527: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
528: FND_MSG_PUB.ADD;
529:
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_FALSE,

Line 571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');

567: l_return_status, l_msg_count, l_msg_data);
568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: ELSE

Line 572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));

568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
571: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
572: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_ERROR;
575: ELSE
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');

598: p_count => x_msg_count,
599: p_data => x_msg_data);
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
604: FND_MSG_PUB.ADD;
605:
606: FND_MSG_PUB.Count_And_Get(

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

599: p_data => x_msg_data);
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
604: FND_MSG_PUB.ADD;
605:
606: FND_MSG_PUB.Count_And_Get(
607: p_encoded => FND_API.G_FALSE,

Line 899: FND_MESSAGE.CLEAR;

895: log('THIS WORKER ERRORED OUT');
896: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
897: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
898: END LOOP;
899: FND_MESSAGE.CLEAR;
900:
901: retcode := 2;
902: errbuf := 'Expected Error ' || l_cur_party_id;
903: FND_FILE.close;

Line 912: FND_MESSAGE.CLEAR;

908: log('THIS WORKER ERRORED OUT');
909: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
910: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
911: END LOOP;
912: FND_MESSAGE.CLEAR;
913:
914: errbuf := 'UnExpected Error ' || l_cur_party_id;
915: retcode := 2;
916: FND_FILE.close;

Line 959: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');

955: END IF;
956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
960: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 960: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');

956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
960: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;

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

957: EXCEPTION
958: WHEN OTHERS THEN
959: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
960: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
962: FND_MSG_PUB.ADD;
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965:

Line 1006: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');

1002: END IF;
1003:
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1007: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');

1003:
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END remove_non_duplicates;

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

1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1007: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1008: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END remove_non_duplicates;
1012:

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

1047: AND gt.ENTITY = vl.ENTITY_NAME
1048: AND gt.ATTRIBUTE=vl.ATTRIBUTE_NAME;
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1052: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1053: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1052: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');

1048: AND gt.ATTRIBUTE=vl.ATTRIBUTE_NAME;
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1052: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1053: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END insert_match_details;

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

1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1052: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1053: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1054: FND_MSG_PUB.ADD;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END insert_match_details;
1057:

Line 1113: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');

1109: from HZ_MATCH_RULES_VL
1110: where match_rule_id = p_rule_id;
1111:
1112: IF l_mr_comp_flag <> 'C' OR l_mr_last_updated_date > l_dup_set_creation_date THEN
1113: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');
1114: FND_MSG_PUB.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117:

Line 1124: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');

1120: l_party_site_list, l_contact_list, l_cpt_list,
1121: l_return_status, l_msg_count, l_msg_data);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1125: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1126: FND_MSG_PUB.ADD;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSE

Line 1125: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));

1121: l_return_status, l_msg_count, l_msg_data);
1122:
1123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1124: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1125: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1126: FND_MSG_PUB.ADD;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSE
1129:

Line 1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');

1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSE

Line 1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));

1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSE
1143: insert_match_details (l_search_ctx_id, p_dup_set_id, DUP.DUP_PARTY_ID);

Line 1163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');

1159: p_count => x_msg_count,
1160: p_data => x_msg_data);
1161: WHEN OTHERS THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
1164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1165: FND_MSG_PUB.ADD;
1166:
1167: FND_MSG_PUB.Count_And_Get(

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

1160: p_data => x_msg_data);
1161: WHEN OTHERS THEN
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
1164: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1165: FND_MSG_PUB.ADD;
1166:
1167: FND_MSG_PUB.Count_And_Get(
1168: p_encoded => FND_API.G_FALSE,