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.OZF_LE_UPGRADE_PVT dependencies on FND_FILE

Line 53: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- LEGAL ENTITY PROCESS START SUMMARY -------------------+');

49: WHERE legal_entity_id is null;
50:
51: BEGIN
52: SAVEPOINT Start_Process;
53: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- LEGAL ENTITY PROCESS START SUMMARY -------------------+');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
55: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
56:
57: -- Main Cursor

Line 54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

50:
51: BEGIN
52: SAVEPOINT Start_Process;
53: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- LEGAL ENTITY PROCESS START SUMMARY -------------------+');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
55: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
56:
57: -- Main Cursor
58: OPEN claim_org_id_csr;

Line 55: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

51: BEGIN
52: SAVEPOINT Start_Process;
53: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- LEGAL ENTITY PROCESS START SUMMARY -------------------+');
54: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
55: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
56:
57: -- Main Cursor
58: OPEN claim_org_id_csr;
59: LOOP

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);

73:
74: IF ( l_return_status = FND_API.g_ret_sts_error
75: OR l_return_status = FND_API.g_ret_sts_unexp_error ) THEN
76: ROLLBACK TO Start_Process;
77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);
78: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);
79: OZF_UTILITY_PVT.write_conc_log;
80: END IF;
81:

Line 78: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);

74: IF ( l_return_status = FND_API.g_ret_sts_error
75: OR l_return_status = FND_API.g_ret_sts_unexp_error ) THEN
76: ROLLBACK TO Start_Process;
77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);
78: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Legal Entity ID is FAILED for the ORG_ID : '||l_org_id);
79: OZF_UTILITY_PVT.write_conc_log;
80: END IF;
81:
82: l_legal_entity_id := l_ou_le_info(1).legal_entity_id;

Line 86: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is NULL for the ORG_ID : '||l_org_id);

82: l_legal_entity_id := l_ou_le_info(1).legal_entity_id;
83:
84:
85: IF l_legal_entity_id IS NULL THEN
86: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is NULL for the ORG_ID : '||l_org_id);
87: ELSE
88:
89: UPDATE OZF_CLAIMS_ALL
90: SET legal_entity_id = l_legal_entity_id

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');

89: UPDATE OZF_CLAIMS_ALL
90: SET legal_entity_id = l_legal_entity_id
91: WHERE claim_id = l_claim_id;
92:
93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);
97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);

90: SET legal_entity_id = l_legal_entity_id
91: WHERE claim_id = l_claim_id;
92:
93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);
97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');
98: OZF_UTILITY_PVT.write_conc_log;

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);

91: WHERE claim_id = l_claim_id;
92:
93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);
97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');
98: OZF_UTILITY_PVT.write_conc_log;
99: END IF;

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);

92:
93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);
97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');
98: OZF_UTILITY_PVT.write_conc_log;
99: END IF;
100:

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');

93: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------BEGIN------------ ');
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID is SET for the Claim_id : '||l_claim_id);
95: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ORG ID : '||l_org_id);
96: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity ID : '||l_legal_entity_id);
97: FND_FILE.PUT_LINE(FND_FILE.LOG, '--------------END------------ ');
98: OZF_UTILITY_PVT.write_conc_log;
99: END IF;
100:
101: END LOOP;

Line 104: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- LEGAL ENTITY PROCESS END SUMMARY --------------------+');

100:
101: END LOOP;
102: CLOSE claim_org_id_csr;
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- LEGAL ENTITY PROCESS END SUMMARY --------------------+');
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
106:
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN

Line 105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

101: END LOOP;
102: CLOSE claim_org_id_csr;
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- LEGAL ENTITY PROCESS END SUMMARY --------------------+');
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
106:
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
109: ROLLBACK TO Start_Process;

Line 110: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Error happened during LE ---/');

106:
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
109: ROLLBACK TO Start_Process;
110: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during LE ---*/');
111: OZF_UTILITY_PVT.Write_Conc_Log;
112: ERRBUF := l_msg_data;
113: RETCODE := 1;
114:

Line 117: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Error happened during LE ---/');

113: RETCODE := 1;
114:
115: WHEN FND_API.g_exc_unexpected_error THEN
116: ROLLBACK TO Start_Process;
117: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during LE ---*/');
118: OZF_UTILITY_PVT.Write_Conc_Log;
119: ERRBUF := l_msg_data;
120: RETCODE := 2;
121:

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Inside Others, Error happened during LE ---/');

120: RETCODE := 2;
121:
122: WHEN OTHERS THEN
123: ROLLBACK TO Start_Process;
124: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Inside Others, Error happened during LE ---*/');
125: OZF_UTILITY_PVT.Write_Conc_Log;
126: ERRBUF := l_msg_data;
127: RETCODE := 2;
128: