DBA Data[Home] [Help]

APPS.HZ_PARTY_MERGE dependencies on FND_FILE

Line 232: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');

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||'#');

Line 233: FND_FILE.put_line(FND_FILE.log,'User ID:'||g_user_id||'#');

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||'#');

Line 234: FND_FILE.put_line(FND_FILE.log,'Creation Date:'||TO_CHAR(g_creation_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||'#');
238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_id||'#');

Line 235: FND_FILE.put_line(FND_FILE.log,'Last Update Date:'||TO_CHAR(g_last_update_date)||'#');

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;

Line 236: FND_FILE.put_line(FND_FILE.log,'Last Update Login:'||g_last_update_login||'#');

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 (

Line 237: FND_FILE.put_line(FND_FILE.log,'Created By:'||g_created_by||'#');

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

Line 238: FND_FILE.put_line(FND_FILE.log,'Request ID:'||g_request_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
242: FROM HZ_MERGE_DICTIONARY WHERE DICT_APPLICATION_ID<>222

Line 1083: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);

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;

Line 1084: FND_FILE.put_line(FND_FILE.log,'Error ' || SQLERRM);

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;

Line 1252: -- FND_FILE.close;

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

Line 1312: -- FND_FILE.close;

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;

Line 1337: -- FND_FILE.close;

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;

Line 1362: -- FND_FILE.close;

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

Line 2828: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

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);

Line 2830: FND_FILE.put_line(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;

Line 2832: FND_FILE.put(fnd_file.output,message);

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: /*------------------------------------------------------------------------

Line 2846: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

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);

Line 2848: FND_FILE.put_line(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;

Line 2850: FND_FILE.put(fnd_file.log,message);

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: /*------------------------------------------------------------------------

Line 3575: FND_FILE.put_line (FND_FILE.log,'Warning .. Error updating Org Profile of x_to_id ' || l_msg_data);

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;