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

269: -- Find the match rule
270: null;
271:
272: -- No MATCH RULE FOUND
273: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MATCH_RULE');
274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:

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

275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: IF p_batch_name IS NULL OR p_batch_name = '' THEN
279: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_BATCH_NAME');
280: FND_MSG_PUB.ADD;
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:

Line 296: log(fnd_message.get);

292: TRUE, p_num_workers, TO_CHAR(I), p_rule_id,
293: to_char(l_batch_id),p_subset_defn,p_match_within_subset,p_search_merged);
294: IF l_sub_requests(i) = 0 THEN
295: log('Error submitting worker ' || i);
296: log(fnd_message.get);
297: dup_workers_completed := FALSE;
298: retcode := 2;
299: ELSE
300: log('Submitted request for Worker ' || TO_CHAR(I) );

Line 430: log(fnd_message.get);

426: 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);
427:
428: IF l_req_id = 0 THEN
429: log('Error submitting Automerge request');
430: log(fnd_message.get);
431: ELSE
432: log('Submitted request ID for Automerge: ' || l_req_id );
433: END IF;
434: -- start bug 4773387

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

499: l_return_status, l_msg_count, l_msg_data);
500:
501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
504: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
505: FND_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;
507: ELSE

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

500:
501: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
504: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
505: FND_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;
507: ELSE
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

528: p_count => x_msg_count,
529: p_data => x_msg_data);
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
533: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
534: FND_MSG_PUB.ADD;
535:
536: FND_MSG_PUB.Count_And_Get(

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

529: p_data => x_msg_data);
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
533: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
534: FND_MSG_PUB.ADD;
535:
536: FND_MSG_PUB.Count_And_Get(
537: p_encoded => FND_API.G_FALSE,

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

573: l_return_status, l_msg_count, l_msg_data);
574:
575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
577: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
578: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;
581: ELSE

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

574:
575: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
577: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
578: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(p_party_id));
579: FND_MSG_PUB.ADD;
580: RAISE FND_API.G_EXC_ERROR;
581: ELSE
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

604: p_count => x_msg_count,
605: p_data => x_msg_data);
606: WHEN OTHERS THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
609: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
610: FND_MSG_PUB.ADD;
611:
612: FND_MSG_PUB.Count_And_Get(

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

605: p_data => x_msg_data);
606: WHEN OTHERS THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
609: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
610: FND_MSG_PUB.ADD;
611:
612: FND_MSG_PUB.Count_And_Get(
613: p_encoded => FND_API.G_FALSE,

Line 905: FND_MESSAGE.CLEAR;

901: log('THIS WORKER ERRORED OUT');
902: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
903: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
904: END LOOP;
905: FND_MESSAGE.CLEAR;
906:
907: retcode := 2;
908: errbuf := 'Expected Error ' || l_cur_party_id;
909: FND_FILE.close;

Line 918: FND_MESSAGE.CLEAR;

914: log('THIS WORKER ERRORED OUT');
915: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
916: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
917: END LOOP;
918: FND_MESSAGE.CLEAR;
919:
920: errbuf := 'UnExpected Error ' || l_cur_party_id;
921: retcode := 2;
922: FND_FILE.close;

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

961: END IF;
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
966: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
966: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;

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

963: EXCEPTION
964: WHEN OTHERS THEN
965: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
966: FND_MESSAGE.SET_TOKEN('PROC' ,'check_party_in_dupset');
967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;
971:

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

1008: END IF;
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1013: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1015: FND_MSG_PUB.ADD;
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1013: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1015: FND_MSG_PUB.ADD;
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END remove_non_duplicates;

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

1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1013: FND_MESSAGE.SET_TOKEN('PROC' ,'remove_non_duplicates');
1014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1015: FND_MSG_PUB.ADD;
1016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1017: END remove_non_duplicates;
1018:

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

1053: AND gt.ENTITY = vl.ENTITY_NAME
1054: AND gt.ATTRIBUTE=vl.ATTRIBUTE_NAME;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1058: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1059: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1060: FND_MSG_PUB.ADD;
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1054: AND gt.ATTRIBUTE=vl.ATTRIBUTE_NAME;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1058: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1059: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1060: FND_MSG_PUB.ADD;
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END insert_match_details;

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

1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_SQL_ERROR');
1058: FND_MESSAGE.SET_TOKEN('PROC' ,'create_dup_set');
1059: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1060: FND_MSG_PUB.ADD;
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END insert_match_details;
1063:

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

1115: from HZ_MATCH_RULES_VL
1116: where match_rule_id = p_rule_id;
1117:
1118: IF l_mr_comp_flag <> 'C' OR l_mr_last_updated_date > l_dup_set_creation_date THEN
1119: FND_MESSAGE.SET_NAME('AR', 'HZ_CDL_NO_MATCH_DETAILS');
1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:

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

1126: l_party_site_list, l_contact_list, l_cpt_list,
1127: l_return_status, l_msg_count, l_msg_data);
1128:
1129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1130: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1131: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSE

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

1127: l_return_status, l_msg_count, l_msg_data);
1128:
1129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1130: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_ACQUIRE_ERROR');
1131: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(l_winner_party_id));
1132: FND_MSG_PUB.ADD;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSE
1135:

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

1140: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1141: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1142: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1145: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSE

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

1141: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1142: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1145: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSE
1149: insert_match_details (l_search_ctx_id, p_dup_set_id, DUP.DUP_PARTY_ID);

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

1165: p_count => x_msg_count,
1166: p_data => x_msg_data);
1167: WHEN OTHERS THEN
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172:
1173: FND_MSG_PUB.Count_And_Get(

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

1166: p_data => x_msg_data);
1167: WHEN OTHERS THEN
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SQL_EXCEP');
1170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1171: FND_MSG_PUB.ADD;
1172:
1173: FND_MSG_PUB.Count_And_Get(
1174: p_encoded => FND_API.G_FALSE,