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 1046: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);

1042: EXCEPTION
1043: WHEN NO_DATA_FOUND THEN
1044: NULL;
1045: WHEN OTHERS THEN
1046: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);
1047: FND_FILE.put_line(FND_FILE.log,'Error ' || SQLERRM);
1048: l_return_status:= FND_API.G_RET_STS_ERROR;
1049: END;
1050: END IF;

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

1043: WHEN NO_DATA_FOUND THEN
1044: NULL;
1045: WHEN OTHERS THEN
1046: FND_FILE.put_line(FND_FILE.log,'l_return_status ' || l_return_status);
1047: FND_FILE.put_line(FND_FILE.log,'Error ' || SQLERRM);
1048: l_return_status:= FND_API.G_RET_STS_ERROR;
1049: END;
1050: END IF;
1051: END IF;

Line 1215: -- FND_FILE.close;

1211:
1212: outandlog('Concurrent Program Execution completed ');
1213: outandlog('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
1214:
1215: -- FND_FILE.close;
1216: --4634891
1217: IF p_preview <> 'Y' THEN
1218: OPEN merge_to_parties;
1219: LOOP

Line 1274: -- FND_FILE.close;

1270: store_merge_log(l_batch_pid, -1,
1271: -1,-1, -1,null,null,
1272: -1, 'Error', errbuf);
1273: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1274: -- FND_FILE.close;
1275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1276: --store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1277: IF p_preview = 'Y' AND l_batch_merge_spt THEN
1278: ROLLBACK to batch_merge;

Line 1298: -- FND_FILE.close;

1294: store_merge_log(l_batch_pid, -1,
1295: -1,-1, -1,null,null,
1296: -1, 'Error', errbuf);
1297: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1298: -- FND_FILE.close;
1299: WHEN OTHERS THEN
1300: --store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1301: IF p_preview = 'Y' AND l_batch_merge_spt THEN
1302: ROLLBACK to batch_merge;

Line 1322: -- FND_FILE.close;

1318: store_merge_log(l_batch_pid, -1,
1319: -1,-1, -1,null,null,
1320: -1, 'Error', errbuf);
1321: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1322: -- FND_FILE.close;
1323: END batch_merge;
1324:
1325: /*
1326: Procedure to perform merge for a to_record merging into a from_record

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

2784: message IN VARCHAR2,
2785: newline IN BOOLEAN DEFAULT TRUE) IS
2786: BEGIN
2787: IF message = 'NEWLINE' THEN
2788: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2789: ELSIF (newline) THEN
2790: FND_FILE.put_line(fnd_file.output,message);
2791: ELSE
2792: FND_FILE.put(fnd_file.output,message);

Line 2790: FND_FILE.put_line(fnd_file.output,message);

2786: BEGIN
2787: IF message = 'NEWLINE' THEN
2788: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2789: ELSIF (newline) THEN
2790: FND_FILE.put_line(fnd_file.output,message);
2791: ELSE
2792: FND_FILE.put(fnd_file.output,message);
2793: END IF;
2794: END out;

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

2788: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
2789: ELSIF (newline) THEN
2790: FND_FILE.put_line(fnd_file.output,message);
2791: ELSE
2792: FND_FILE.put(fnd_file.output,message);
2793: END IF;
2794: END out;
2795:
2796: /*------------------------------------------------------------------------

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

2802: newline IN BOOLEAN DEFAULT TRUE) IS
2803: BEGIN
2804:
2805: IF message = 'NEWLINE' THEN
2806: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2807: ELSIF (newline) THEN
2808: FND_FILE.put_line(fnd_file.log,message);
2809: ELSE
2810: FND_FILE.put(fnd_file.log,message);

Line 2808: FND_FILE.put_line(fnd_file.log,message);

2804:
2805: IF message = 'NEWLINE' THEN
2806: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2807: ELSIF (newline) THEN
2808: FND_FILE.put_line(fnd_file.log,message);
2809: ELSE
2810: FND_FILE.put(fnd_file.log,message);
2811: END IF;
2812: END log;

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

2806: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
2807: ELSIF (newline) THEN
2808: FND_FILE.put_line(fnd_file.log,message);
2809: ELSE
2810: FND_FILE.put(fnd_file.log,message);
2811: END IF;
2812: END log;
2813:
2814: /*------------------------------------------------------------------------

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

3548: l_msg_data := l_msg_data ||
3549: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3550: END LOOP;
3551: END IF;
3552: FND_FILE.put_line (FND_FILE.log,'Warning .. Error updating Org Profile of x_to_id ' || l_msg_data);
3553: -- Bug Fix : 3116262.
3554: --RETURN;
3555: RAISE FND_API.G_EXC_ERROR;
3556: END IF;

Line 4103: FND_FILE.put_line(FND_FILE.log,'To Not found');

4099: EXCEPTION
4100: WHEN NO_DATA_FOUND THEN
4101: -- Transfer From
4102: NULL;
4103: FND_FILE.put_line(FND_FILE.log,'To Not found');
4104: END;
4105: END LOOP;
4106:
4107: -- *******************************************