954: l_flag VARCHAR2(1);
955: BEGIN
956:
957: -- send the run details to the log file
958: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARXFZKEY - Generate Key.');
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
955: BEGIN
956:
957: -- send the run details to the log file
958: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARXFZKEY - Generate Key.');
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
956:
957: -- send the run details to the log file
958: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARXFZKEY - Generate Key.');
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
964:
957: -- send the run details to the log file
958: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARXFZKEY - Generate Key.');
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
964:
965: IF p_key_type = 'PARTY' -- generate keys for the hz_parties table
958: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Concurrent program ARXFZKEY - Generate Key.');
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
964:
965: IF p_key_type = 'PARTY' -- generate keys for the hz_parties table
966: THEN
959: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
960: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Options - ');
961: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Key type : '||p_key_type);
962: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Only new rows : '||p_new_rows);
963: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
964:
965: IF p_key_type = 'PARTY' -- generate keys for the hz_parties table
966: THEN
967: IF p_new_rows = 'Y'
1168: END IF;
1169: END IF;
1170: COMMIT;
1171: -- send count info to the log file
1172: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(l_rec_count) || ' ' || p_key_type || ' keys generated.');
1175:
1176: EXCEPTION
1169: END IF;
1170: COMMIT;
1171: -- send count info to the log file
1172: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(l_rec_count) || ' ' || p_key_type || ' keys generated.');
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1170: COMMIT;
1171: -- send count info to the log file
1172: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1173: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1174: FND_FILE.PUT_LINE (FND_FILE.LOG, to_char(l_rec_count) || ' ' || p_key_type || ' keys generated.');
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: arp_util.debug('OTHERS : hz_fuzzy_pub.generate_full_table_key');