228: g_last_update_login:=hz_utility_pub.last_update_login;
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
229: g_last_update_date :=hz_utility_pub.last_update_date;
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
230: g_user_id :=hz_utility_pub.user_id;
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
231:
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
239: g_skip_dict_id.DELETE;
232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
239: g_skip_dict_id.DELETE;
240: FOR ENTITY IN (
233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
239: g_skip_dict_id.DELETE;
240: FOR ENTITY IN (
241: SELECT DISTINCT MERGE_DICT_ID, ENTITY_NAME
234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_date)||'#');
235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');
236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');
237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');
239: g_skip_dict_id.DELETE;
240: FOR ENTITY IN (
241: SELECT DISTINCT MERGE_DICT_ID, ENTITY_NAME
242: FROM HZ_MERGE_DICTIONARY WHERE DICT_APPLICATION_ID<>222
1079: EXCEPTION
1080: WHEN NO_DATA_FOUND THEN
1081: NULL;
1082: WHEN OTHERS THEN
1083: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);
1084: FND_FILE.put_line(FND_FILE.log,'Error ' || SQLERRM);
1085: l_return_status:= FND_API.G_RET_STS_ERROR;
1086: END;
1087: END IF;
1080: WHEN NO_DATA_FOUND THEN
1081: NULL;
1082: WHEN OTHERS THEN
1083: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);
1084: FND_FILE.put_line(FND_FILE.log,'Error ' || SQLERRM);
1085: l_return_status:= FND_API.G_RET_STS_ERROR;
1086: END;
1087: END IF;
1088: END IF;
1248:
1249: outandlog('Concurrent Program Execution completed ');
1250: outandlog('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1251:
1252: -- FND_FILE.close;
1253: --4634891
1254: IF p_preview <> 'Y' THEN
1255: OPEN merge_to_parties;
1256: LOOP
1308: store_merge_log(l_batch_pid, -1,
1309: -1,-1, -1,null,null,
1310: -1, 'Error', errbuf);
1311: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1312: -- FND_FILE.close;
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: --store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1315: IF p_preview = 'Y' AND l_batch_merge_spt THEN
1316: ROLLBACK to batch_merge;
1333: store_merge_log(l_batch_pid, -1,
1334: -1,-1, -1,null,null,
1335: -1, 'Error', errbuf);
1336: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1337: -- FND_FILE.close;
1338: WHEN OTHERS THEN
1339: --store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1340: IF p_preview = 'Y' AND l_batch_merge_spt THEN
1341: ROLLBACK to batch_merge;
1358: store_merge_log(l_batch_pid, -1,
1359: -1,-1, -1,null,null,
1360: -1, 'Error', errbuf);
1361: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1362: -- FND_FILE.close;
1363: END batch_merge;
1364:
1365: /*
1366: Procedure to perform merge for a to_record merging into a from_record
2824: message IN VARCHAR2,
2825: newline IN BOOLEAN DEFAULT TRUE) IS
2826: BEGIN
2827: IF message = 'NEWLINE' THEN
2828: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2829: ELSIF (newline) THEN
2830: FND_FILE.put_line(fnd_file.output,message);
2831: ELSE
2832: FND_FILE.put(fnd_file.output,message);
2826: BEGIN
2827: IF message = 'NEWLINE' THEN
2828: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2829: ELSIF (newline) THEN
2830: FND_FILE.put_line(fnd_file.output,message);
2831: ELSE
2832: FND_FILE.put(fnd_file.output,message);
2833: END IF;
2834: END out;
2828: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2829: ELSIF (newline) THEN
2830: FND_FILE.put_line(fnd_file.output,message);
2831: ELSE
2832: FND_FILE.put(fnd_file.output,message);
2833: END IF;
2834: END out;
2835:
2836: /*------------------------------------------------------------------------
2842: newline IN BOOLEAN DEFAULT TRUE) IS
2843: BEGIN
2844:
2845: IF message = 'NEWLINE' THEN
2846: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2847: ELSIF (newline) THEN
2848: FND_FILE.put_line(fnd_file.log,message);
2849: ELSE
2850: FND_FILE.put(fnd_file.log,message);
2844:
2845: IF message = 'NEWLINE' THEN
2846: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2847: ELSIF (newline) THEN
2848: FND_FILE.put_line(fnd_file.log,message);
2849: ELSE
2850: FND_FILE.put(fnd_file.log,message);
2851: END IF;
2852: END log;
2846: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2847: ELSIF (newline) THEN
2848: FND_FILE.put_line(fnd_file.log,message);
2849: ELSE
2850: FND_FILE.put(fnd_file.log,message);
2851: END IF;
2852: END log;
2853:
2854: /*------------------------------------------------------------------------
3571: l_msg_data := l_msg_data ||
3572: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3573: END LOOP;
3574: END IF;
3575: FND_FILE.put_line (FND_FILE.log,'Warning .. Error updating Org Profile of x_to_id ' || l_msg_data);
3576: -- Bug Fix : 3116262.
3577: --RETURN;
3578: RAISE FND_API.G_EXC_ERROR;
3579: END IF;