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_GL_TRANSFER_PVT dependencies on FND_FILE

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start ='||G_PKG_NAME);

120: AND sp.set_of_books_id <> -1;
121:
122: BEGIN
123:
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start ='||G_PKG_NAME);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------Transfer To GL Execution Report -----------------------------*');
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:

Line 125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------Transfer To GL Execution Report -----------------------------');

121:
122: BEGIN
123:
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start ='||G_PKG_NAME);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------Transfer To GL Execution Report -----------------------------*');
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');

Line 126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

122: BEGIN
123:
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start ='||G_PKG_NAME);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------Transfer To GL Execution Report -----------------------------*');
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:

Line 127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

123:
124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start ='||G_PKG_NAME);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------Transfer To GL Execution Report -----------------------------*');
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );

Line 129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');

125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*--------------------------------Transfer To GL Execution Report -----------------------------*');
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );

Line 131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );

127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );

Line 132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );

128:
129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );

Line 133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );

129: FND_FILE.PUT_LINE(FND_FILE.LOG, 'In Parameters : ');
130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );

130:
131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );

Line 135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );

131: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_selection_type : '||p_selection_type );
132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );

132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_set_of_books_id : '||p_set_of_books_id );
133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );

Line 137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );

133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_include_reporting_sob : '||p_include_reporting_sob );
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );

Line 138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );

134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_batch_name : '||p_batch_name );
135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );

135: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_start_date : '||p_start_date );
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );

Line 140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );

136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_end_date : '||p_end_date );
137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );

Line 141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );

137: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_accounting_method : '||p_accounting_method );
138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );
145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );

Line 142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );

138: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_document_class : '||p_document_class );
139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );
145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );
146:

Line 143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );

139: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_journal_category : '||p_journal_category );
140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );
145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );
146:
147: -- Set the start date. Currently utilizing the gl_periods set for

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );

140: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_validate_account : '||p_validate_account );
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );
145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );
146:
147: -- Set the start date. Currently utilizing the gl_periods set for
148: -- AR applicaiotn.Change to 682 after open/close periods functionality is

Line 145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );

141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_gl_transfer_mode : '||p_gl_transfer_mode );
142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_submit_journal_import : '||p_submit_journal_import );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_summary_journal_entry : '||p_summary_journal_entry );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_process_days : '||p_process_days );
145: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_debug_flag : '||p_debug_flag );
146:
147: -- Set the start date. Currently utilizing the gl_periods set for
148: -- AR applicaiotn.Change to 682 after open/close periods functionality is
149: -- provided to Funds and Claims module.

Line 152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before deriving the start date');

148: -- AR applicaiotn.Change to 682 after open/close periods functionality is
149: -- provided to Funds and Claims module.
150:
151: /* Bugfix: 7412302 - Changed start date to G_MISS_DATE in case of NULL.
152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before deriving the start date');
153:
154: IF p_start_date is null THEN
155: if p_set_of_books_id <> -1 then
156: select min(start_date)

Line 176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving start date '||l_start_date);

172: and closing_status IN ( 'O','F');
173: end if;
174: END IF;
175:
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving start date '||l_start_date);
177: */
178:
179:
180: IF p_start_date IS NOT NULL THEN

Line 188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving start date '||l_start_date);

184: END IF;
185:
186: l_end_date := FND_DATE.CANONICAL_TO_DATE(p_end_date);
187:
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving start date '||l_start_date);
189: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After converting end date '||l_end_date);
190:
191: -- If the Document class is Claims then transfer Claims and Deduction
192: -- entries.

Line 189: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After converting end date '||l_end_date);

185:
186: l_end_date := FND_DATE.CANONICAL_TO_DATE(p_end_date);
187:
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving start date '||l_start_date);
189: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After converting end date '||l_end_date);
190:
191: -- If the Document class is Claims then transfer Claims and Deduction
192: -- entries.
193:

Line 194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before deriving the je_category - Document class : '||p_document_class);

190:
191: -- If the Document class is Claims then transfer Claims and Deduction
192: -- entries.
193:
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before deriving the je_category - Document class : '||p_document_class);
195:
196: IF p_document_class IS NOT NULL THEN
197: IF nvl(p_document_class,'A') = 'Claims' THEN
198: l_je_category(1) := 'Claims';

Line 223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving the je_category');

219: l_je_category(1) := p_journal_category;
220: END IF;
221: END IF;
222:
223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After deriving the je_category');
224:
225: --Get Profile Information
226: l_request_id := FND_GLOBAL.conc_request_id;
227: l_appl_id := FND_GLOBAL.resp_appl_id;

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After getting user profile from client_info');

227: l_appl_id := FND_GLOBAL.resp_appl_id;
228: l_user_id := FND_GLOBAL.user_id;
229: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enhancements
230:
231: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After getting user profile from client_info');
232: l_debug_info := 'Poplating l_sob_info table';
233:
234: FOR rec IN c1(p_set_of_books_id) LOOP
235: i := i+1 ;

Line 244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After populating sob_info');

240: l_sob_info(i).encumb_flag := rec.encumbrance_flag;
241: l_sob_info(i).sob_name := rec.name;
242: END LOOP; /* c1 loop */
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After populating sob_info');
245:
246: /* -- If MRC is Installed
247: IF Nvl(p_include_reporting_sob,'N') = 'Y' THEN
248: l_debug_info := 'Calling MRC API to get the reporting set of books';

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After populating sob_list');

260: l_sob_list(i).sob_curr_code := l_sob_info(i).currency_code;
261: l_sob_list(i).encum_flag := l_sob_info(i).encumb_flag;
262: END LOOP;
263:
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After populating sob_list');
265:
266: -- Get org_code
267: l_debug_info := 'Getting Organization Name';
268:

Line 277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before calling xla_gl_transfer');

273:
274: --Call common transfer API
275: l_debug_info :='Calling Common Transfer API';
276:
277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before calling xla_gl_transfer');
278:
279: IF p_journal_category IS NOT NULL THEN
280: IF p_journal_category = 'A' THEN
281: OPEN lookup_name_csr('BOTH_ALL_NONE', p_journal_category);

Line 309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );

305: FETCH submit_jrnl_import_csr into l_submit_journal_import;
306: CLOSE submit_jrnl_import_csr;
307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );

Line 310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );

306: CLOSE submit_jrnl_import_csr;
307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );

Line 311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );

307: END IF;
308:
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );

Line 312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );

308:
309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );

Line 313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );

309: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books Name : '||l_sob_info(1).sob_name );
310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );
317:

Line 314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );

310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Name : '||p_batch_name );
311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );
317:
318: xla_gl_transfer_pkg.xla_gl_transfer

Line 315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );

311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'From Date : '||l_start_date );
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );
317:
318: xla_gl_transfer_pkg.xla_gl_transfer
319: (

Line 316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );

312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'To Date : '||l_end_date );
313: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Journal Category : '||l_je_category_name );
314: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Validate Accounts : '||l_val_acct );
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Transfer to Gl Interface : '||l_gl_interface );
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Submit Journal Import : '||l_submit_journal_import );
317:
318: xla_gl_transfer_pkg.xla_gl_transfer
319: (
320: p_application_id => l_appl_id,

Line 344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');

340: p_je_line_desc => l_org_code || ' ' || p_batch_name,
341: p_debug_flag => p_debug_flag
342: );
343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

341: p_debug_flag => p_debug_flag
342: );
343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
349:

Line 346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );

342: );
343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
349:
350: EXCEPTION

Line 347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
349:
350: EXCEPTION
351: WHEN OTHERS THEN

Line 348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

344: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After calling xla_gl_transfer');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
346: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
348: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: p_errbuf := Sqlerrm;

Line 354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);

350: EXCEPTION
351: WHEN OTHERS THEN
352: p_errbuf := Sqlerrm;
353: p_retcode := 2;
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');

Line 355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

351: WHEN OTHERS THEN
352: p_errbuf := Sqlerrm;
353: p_retcode := 2;
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
359:

Line 356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');

352: p_errbuf := Sqlerrm;
353: p_retcode := 2;
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
359:
360: IF (SQLCODE <> -20001) THEN

Line 357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

353: p_retcode := 2;
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
359:
360: IF (SQLCODE <> -20001) THEN
361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

Line 358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '---------------------------------------------------------------------------------------------');

354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' ||SQLCODE||SQLERRM || ')');
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
359:
360: IF (SQLCODE <> -20001) THEN
361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
362: --APP_EXCEPTION.RAISE_EXCEPTION;

Line 361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*---------------------------------------------------------------------------------------------*');
359:
360: IF (SQLCODE <> -20001) THEN
361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
362: --APP_EXCEPTION.RAISE_EXCEPTION;
363: RAISE;
364: ELSE
365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

Line 365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
362: --APP_EXCEPTION.RAISE_EXCEPTION;
363: RAISE;
364: ELSE
365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
366: --g_error_message := Sqlerrm;
367: APP_EXCEPTION.RAISE_EXCEPTION;
368: END IF;
369: END OZF_GL_TRANSFER;