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

Line 172: fnd_file.put_line(fnd_file.log, 'Processing an External Entity');

168: l_source_system_code NUMBER;
169: l_request_id NUMBER(15);
170: BEGIN
171:
172: fnd_file.put_line(fnd_file.log, 'Processing an External Entity');
173:
174: --Bugfix 4969879: Remove call to get_reference_data_info as this is already stored on p_datasub_info
175:
176: l_event_key := 'Load Identifier : ' || p_load_id;

Line 179: fnd_file.put_line(fnd_file.log, 'Launching Workflow');

175:
176: l_event_key := 'Load Identifier : ' || p_load_id;
177:
178: -- Launch the Workflow
179: fnd_file.put_line(fnd_file.log, 'Launching Workflow');
180: --Bugfix 5197891: Pass the corrrect owner rather than null value for workflow
181: WF_ENGINE.CreateProcess('DATASUB',
182: l_event_key,
183: 'GCSDATASUB',

Line 197: fnd_file.put_line(fnd_file.log, 'Completed Workflow');

193: INTO l_status_code
194: FROM gcs_data_sub_dtls
195: WHERE load_id = p_load_id;
196:
197: fnd_file.put_line(fnd_file.log, 'Completed Workflow');
198:
199: IF (l_status_code = 'IN_PROGRESS') THEN
200: -- Submit the Engine
201: BEGIN

Line 216: fnd_file.put_line(fnd_file.log,

212: WHEN NO_DATA_FOUND THEN
213: l_execution_mode := 'S';
214: END;
215:
216: fnd_file.put_line(fnd_file.log,
217: 'Executing External Ledger Integration');
218:
219: FEM_XGL_POST_ENGINE_PKG.Main(x_errbuf => l_errbuf,
220: x_retcode => l_retcode,

Line 232: fnd_file.put_line(fnd_file.log,

228: p_qtd_ytd_code => 'YTD');
229:
230: COMMIT;
231:
232: fnd_file.put_line(fnd_file.log,
233: 'Completed External Ledger Integration');
234:
235: fnd_file.put_line(fnd_file.log, 'Raising Pristine Data Event');
236:

Line 235: fnd_file.put_line(fnd_file.log, 'Raising Pristine Data Event');

231:
232: fnd_file.put_line(fnd_file.log,
233: 'Completed External Ledger Integration');
234:
235: fnd_file.put_line(fnd_file.log, 'Raising Pristine Data Event');
236:
237: raise_impact_analysis_event(p_load_id => p_load_id,
238: p_ledger_id => p_datasub_info.ledger_id);
239:

Line 240: fnd_file.put_line(fnd_file.log, 'Updating Process Status');

236:
237: raise_impact_analysis_event(p_load_id => p_load_id,
238: p_ledger_id => p_datasub_info.ledger_id);
239:
240: fnd_file.put_line(fnd_file.log, 'Updating Process Status');
241:
242: update_status(p_load_id => p_load_id);
243:
244: fnd_file.put_line(fnd_file.log, 'Updating Data Status');

Line 244: fnd_file.put_line(fnd_file.log, 'Updating Data Status');

240: fnd_file.put_line(fnd_file.log, 'Updating Process Status');
241:
242: update_status(p_load_id => p_load_id);
243:
244: fnd_file.put_line(fnd_file.log, 'Updating Data Status');
245:
246: -- Bugfix 5676634: Submit request for data status update instead of API call
247: -- issuing a commit prior to request submission to ensure information is going
248: --to be available to the concurrent program which will run in different context/session

Line 272: fnd_file.put_line(fnd_file.log,

268: argument2 => NULL,
269: argument3 => NULL,
270: argument4 => p_load_id);
271:
272: fnd_file.put_line(fnd_file.log,
273: 'Submitted XML Generation Request Id: ' ||
274: l_request_id);
275:
276: ELSE

Line 278: fnd_file.put_line(fnd_file.log, '<<<<< Beginning of Error >>>>>');

274: l_request_id);
275:
276: ELSE
277: -- Bug Fix : 5234796
278: fnd_file.put_line(fnd_file.log, '<<<<< Beginning of Error >>>>>');
279: IF (l_status_code = 'VALIDATION_MEMBERS_FAILED') THEN
280: fnd_file.put_line(fnd_file.log,
281: 'Validations on dimension members failed. Please review the error_message_code column or data loaded report to see which members are invalid.');
282: ELSIF (l_status_code = 'VALIDATION_FAILED') THEN

Line 280: fnd_file.put_line(fnd_file.log,

276: ELSE
277: -- Bug Fix : 5234796
278: fnd_file.put_line(fnd_file.log, '<<<<< Beginning of Error >>>>>');
279: IF (l_status_code = 'VALIDATION_MEMBERS_FAILED') THEN
280: fnd_file.put_line(fnd_file.log,
281: 'Validations on dimension members failed. Please review the error_message_code column or data loaded report to see which members are invalid.');
282: ELSIF (l_status_code = 'VALIDATION_FAILED') THEN
283: fnd_file.put_line(fnd_file.log,
284: 'Validations on data failed. Please review the error_message_code column or data loaded report to see which trial balance rows are invalid.');

Line 283: fnd_file.put_line(fnd_file.log,

279: IF (l_status_code = 'VALIDATION_MEMBERS_FAILED') THEN
280: fnd_file.put_line(fnd_file.log,
281: 'Validations on dimension members failed. Please review the error_message_code column or data loaded report to see which members are invalid.');
282: ELSIF (l_status_code = 'VALIDATION_FAILED') THEN
283: fnd_file.put_line(fnd_file.log,
284: 'Validations on data failed. Please review the error_message_code column or data loaded report to see which trial balance rows are invalid.');
285: --Bugfix 5261560: Added new validations on whether the transfer processed correctly or not
286: ELSIF (l_status_code = 'INVALID_FEM_INDEX') THEN
287: fnd_file.put_line(fnd_file.log,

Line 287: fnd_file.put_line(fnd_file.log,

283: fnd_file.put_line(fnd_file.log,
284: 'Validations on data failed. Please review the error_message_code column or data loaded report to see which trial balance rows are invalid.');
285: --Bugfix 5261560: Added new validations on whether the transfer processed correctly or not
286: ELSIF (l_status_code = 'INVALID_FEM_INDEX') THEN
287: fnd_file.put_line(fnd_file.log,
288: 'The index defined on FEM_BAL_INTERFACE_T does not contain all columns that are part of the processing key. Please review the index definition.');
289: ELSIF (l_status_code = 'TRANSFER_ERROR') THEN
290: fnd_file.put_line(fnd_file.log,
291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');

Line 290: fnd_file.put_line(fnd_file.log,

286: ELSIF (l_status_code = 'INVALID_FEM_INDEX') THEN
287: fnd_file.put_line(fnd_file.log,
288: 'The index defined on FEM_BAL_INTERFACE_T does not contain all columns that are part of the processing key. Please review the index definition.');
289: ELSIF (l_status_code = 'TRANSFER_ERROR') THEN
290: fnd_file.put_line(fnd_file.log,
291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');
292: ELSE
293: fnd_file.put_line(fnd_file.log, 'Transformation on data failed.');
294: END IF;

Line 293: fnd_file.put_line(fnd_file.log, 'Transformation on data failed.');

289: ELSIF (l_status_code = 'TRANSFER_ERROR') THEN
290: fnd_file.put_line(fnd_file.log,
291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');
292: ELSE
293: fnd_file.put_line(fnd_file.log, 'Transformation on data failed.');
294: END IF;
295: fnd_file.put_line(fnd_file.log, '<<<<< End of Error >>>>>');
296:
297: -- Transformation or Validation Failed

Line 295: fnd_file.put_line(fnd_file.log, '<<<<< End of Error >>>>>');

291: 'The transfer of data from GCS_BAL_INTERFACE_T to FEM_BAL_INTERFACE_T failed. Please review the information in FND_LOG_MESSAGES for more details.');
292: ELSE
293: fnd_file.put_line(fnd_file.log, 'Transformation on data failed.');
294: END IF;
295: fnd_file.put_line(fnd_file.log, '<<<<< End of Error >>>>>');
296:
297: -- Transformation or Validation Failed
298: UPDATE gcs_data_sub_dtls
299: SET status_code = 'ERROR',

Line 377: fnd_file.put_line(fnd_file.log, 'Processing an Internal Entity');

373: AND cal_period_id = p_cal_period_id;
374:
375: BEGIN
376:
377: fnd_file.put_line(fnd_file.log, 'Processing an Internal Entity');
378:
379: fnd_file.put_line(fnd_file.log,
380: 'Retrieving Chart of Accounts Information');
381:

Line 379: fnd_file.put_line(fnd_file.log,

375: BEGIN
376:
377: fnd_file.put_line(fnd_file.log, 'Processing an Internal Entity');
378:
379: fnd_file.put_line(fnd_file.log,
380: 'Retrieving Chart of Accounts Information');
381:
382: SELECT gsob.chart_of_accounts_id,
383: gsob.currency_code

Line 389: fnd_file.put_line(fnd_file.log, 'Retrieving Balances Rule Information');

385: l_currency_code
386: FROM gl_sets_of_books gsob
387: WHERE gsob.set_of_books_id = p_datasub_info.ledger_id;
388:
389: fnd_file.put_line(fnd_file.log, 'Retrieving Balances Rule Information');
390:
391: SELECT fibrd.bal_rule_obj_def_id,
392: fibrd.currency_option_code,
393: fibrd.xlated_bal_option_code,

Line 423: fnd_file.put_line(fnd_file.log,

419: SET currency_code = l_currency_code
420: WHERE load_id = p_datasub_info.load_id;
421:
422: --Check if ADB enabled
423: fnd_file.put_line(fnd_file.log,
424: 'Checking if Average Balances is Enabled');
425:
426: IF (l_enable_avg_bal_flag = 'Y') THEN
427: -- Bugfix 5630225: Added balances_rule_id to the insert statement

Line 482: fnd_file.put_line(fnd_file.log, 'Performing a snapshot load');

478: WHERE gdsd.load_id = p_datasub_info.load_id;
479: END IF;
480:
481: IF (p_datasub_info.load_method_code = 'SNAPSHOT') THEN
482: fnd_file.put_line(fnd_file.log, 'Performing a snapshot load');
483: -- Submit Data for All Entities Associated to Balances Rules
484: -- Bugfix 5630225: Added balances_rule_id to the insert statement
485: -- BugFix 5843592 : Use gcs_entities_attr instead of fem_entities_attr
486: INSERT INTO gcs_data_sub_dtls

Line 549: fnd_file.put_line(fnd_file.log,

545: AND fcpa.date_assign_value BETWEEN gea.effective_start_date
546: AND NVL(gea.effective_end_date, fcpa.date_assign_value ) ;
547:
548:
549: fnd_file.put_line(fnd_file.log,
550: 'Submitting the balances integration');
551:
552: BEGIN
553: --Submit the concurrent program

Line 566: fnd_file.put_line(fnd_file.log,

562: p_bsv_range_high => NULL);
563: EXCEPTION
564: WHEN OTHERS THEN
565: l_error_occurred := TRUE;
566: fnd_file.put_line(fnd_file.log,
567: 'An error occurred while synchronizing balances.');
568: fnd_file.put_line(fnd_file.log,
569: 'Please review the output of the request for more details.');
570: END;

Line 568: fnd_file.put_line(fnd_file.log,

564: WHEN OTHERS THEN
565: l_error_occurred := TRUE;
566: fnd_file.put_line(fnd_file.log,
567: 'An error occurred while synchronizing balances.');
568: fnd_file.put_line(fnd_file.log,
569: 'Please review the output of the request for more details.');
570: END;
571: ELSE
572: BEGIN

Line 573: fnd_file.put_line(fnd_file.log, 'Submitting an incremental load');

569: 'Please review the output of the request for more details.');
570: END;
571: ELSE
572: BEGIN
573: fnd_file.put_line(fnd_file.log, 'Submitting an incremental load');
574:
575: fnd_file.put_line(fnd_file.log,
576: 'Checking if chart of accounts mapping is required');
577: --Check if chart of accounts mapping is required

Line 575: fnd_file.put_line(fnd_file.log,

571: ELSE
572: BEGIN
573: fnd_file.put_line(fnd_file.log, 'Submitting an incremental load');
574:
575: fnd_file.put_line(fnd_file.log,
576: 'Checking if chart of accounts mapping is required');
577: --Check if chart of accounts mapping is required
578:
579: l_code_point := 'RETRIEVE_LOCAL_VALUE_SETS';

Line 618: fnd_file.put_line(fnd_file.log,

614:
615: IF ((l_fch_company_vs_id <> l_company_vs_id) AND
616: (l_fch_org_vs_id <> l_org_vs_id)) THEN
617:
618: fnd_file.put_line(fnd_file.log,
619: 'Chart of Accounts mapping is reuqired');
620:
621: l_code_point := 'RETRIEVE_DEFAULT_HIERARCHY';
622:

Line 656: fnd_file.put_line(fnd_file.log,

652: AND fcoa.dim_attribute_numeric_member = fcmax.company_id
653: AND fcmin.value_set_id = l_fch_company_vs_id
654: AND fcmax.value_set_id = l_fch_company_vs_id;
655: ELSE
656: fnd_file.put_line(fnd_file.log,
657: 'Chart of accounts mapping is not required');
658:
659: l_code_point := 'RETRIEVING_COMPANY_VALUE_RANGES';
660:

Line 673: fnd_file.put_line(fnd_file.log, 'Loading the balances data');

669: AND geo.company_cost_center_org_id = fcmin.company_id
670: AND geo.company_cost_center_org_id = fcmax.company_id;
671: END IF;
672:
673: fnd_file.put_line(fnd_file.log, 'Loading the balances data');
674:
675: l_code_point := 'SUBMITTING_INTEGRATION';
676:
677: --Submit the concurrent program

Line 691: fnd_file.put_line(fnd_file.log,

687: EXCEPTION
688: WHEN OTHERS THEN
689: l_error_occurred := TRUE;
690: IF (l_code_point = 'SUBMITING_INTEGRATION') THEN
691: fnd_file.put_line(fnd_file.log,
692: 'Error occurred while synchronizing balances.');
693: fnd_file.put_line(fnd_file.log,
694: 'Please review the output file for more details.');
695: ELSIF (l_code_point = 'RETRIEVING_COMPANY_VALUE_RANGES') THEN

Line 693: fnd_file.put_line(fnd_file.log,

689: l_error_occurred := TRUE;
690: IF (l_code_point = 'SUBMITING_INTEGRATION') THEN
691: fnd_file.put_line(fnd_file.log,
692: 'Error occurred while synchronizing balances.');
693: fnd_file.put_line(fnd_file.log,
694: 'Please review the output file for more details.');
695: ELSIF (l_code_point = 'RETRIEVING_COMPANY_VALUE_RANGES') THEN
696: fnd_file.put_line(fnd_file.log,
697: 'Error while retrieving company values.');

Line 696: fnd_file.put_line(fnd_file.log,

692: 'Error occurred while synchronizing balances.');
693: fnd_file.put_line(fnd_file.log,
694: 'Please review the output file for more details.');
695: ELSIF (l_code_point = 'RETRIEVING_COMPANY_VALUE_RANGES') THEN
696: fnd_file.put_line(fnd_file.log,
697: 'Error while retrieving company values.');
698: ELSIF (l_code_point = 'RETRIEVE_DEFAULT_HIERARCHY') THEN
699: fnd_file.put_line(fnd_file.log,
700: 'The default value set map is not available on the Org Hierarchy');

Line 699: fnd_file.put_line(fnd_file.log,

695: ELSIF (l_code_point = 'RETRIEVING_COMPANY_VALUE_RANGES') THEN
696: fnd_file.put_line(fnd_file.log,
697: 'Error while retrieving company values.');
698: ELSIF (l_code_point = 'RETRIEVE_DEFAULT_HIERARCHY') THEN
699: fnd_file.put_line(fnd_file.log,
700: 'The default value set map is not available on the Org Hierarchy');
701: ELSIF (l_code_point = 'RETRIEVE_CONSOLIDATION_VALUE_SETS') THEN
702: fnd_file.put_line(fnd_file.log,
703: ' Error retrieving the consolidation value sets for the Org and Company dimension.');

Line 702: fnd_file.put_line(fnd_file.log,

698: ELSIF (l_code_point = 'RETRIEVE_DEFAULT_HIERARCHY') THEN
699: fnd_file.put_line(fnd_file.log,
700: 'The default value set map is not available on the Org Hierarchy');
701: ELSIF (l_code_point = 'RETRIEVE_CONSOLIDATION_VALUE_SETS') THEN
702: fnd_file.put_line(fnd_file.log,
703: ' Error retrieving the consolidation value sets for the Org and Company dimension.');
704: ELSIF (l_code_point = 'RETRIEVE_LOCAL_VALUE_SETS') THEN
705: fnd_file.put_line(fnd_file.log,
706: 'Error retrieving the local value sets for the Org and Company dimension.');

Line 705: fnd_file.put_line(fnd_file.log,

701: ELSIF (l_code_point = 'RETRIEVE_CONSOLIDATION_VALUE_SETS') THEN
702: fnd_file.put_line(fnd_file.log,
703: ' Error retrieving the consolidation value sets for the Org and Company dimension.');
704: ELSIF (l_code_point = 'RETRIEVE_LOCAL_VALUE_SETS') THEN
705: fnd_file.put_line(fnd_file.log,
706: 'Error retrieving the local value sets for the Org and Company dimension.');
707: END IF;
708: END;
709: END IF;

Line 713: fnd_file.put_line(fnd_file.log, 'Reviewing translation balances');

709: END IF;
710:
711: IF (NOT l_error_occurred) THEN
712:
713: fnd_file.put_line(fnd_file.log, 'Reviewing translation balances');
714:
715: FOR v_translated_balances IN c_translated_balances(FND_GLOBAL.CONC_REQUEST_ID,
716: p_datasub_info.balances_rule_id,
717: p_datasub_info.ledger_id,

Line 773: fnd_file.put_line(fnd_file.log,

769: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID;
770:
771: END LOOP;
772:
773: fnd_file.put_line(fnd_file.log,
774: 'Setting the concurrent request status');
775:
776: SELECT status_code
777: INTO l_status_code

Line 824: fnd_file.put_line(fnd_file.log, 'Raising Pristine Data Event');

820: IF (l_status_code = 'C') THEN
821: -- Bugfix 5569620: l_retcode will be null in case load was successful
822: -- so raise pristine data event for this case to sync data status
823: IF (l_retcode IS NULL OR l_retcode <> 1) THEN
824: fnd_file.put_line(fnd_file.log, 'Raising Pristine Data Event');
825: raise_impact_analysis_event(p_load_id => v_generated_loads.load_id,
826: p_ledger_id => p_datasub_info.ledger_id);
827:
828: -- Bugfix 5347804: Do not need to call update status as it is done in prior call

Line 830: --fnd_file.put_line(fnd_file.log, 'Updating Process Status');

826: p_ledger_id => p_datasub_info.ledger_id);
827:
828: -- Bugfix 5347804: Do not need to call update status as it is done in prior call
829: --
830: --fnd_file.put_line(fnd_file.log, 'Updating Process Status');
831: --update_status
832: -- (p_load_id => v_generated_loads.load_id);
833:
834: fnd_file.put_line(fnd_file.log, 'Updating Data Status');

Line 834: fnd_file.put_line(fnd_file.log, 'Updating Data Status');

830: --fnd_file.put_line(fnd_file.log, 'Updating Process Status');
831: --update_status
832: -- (p_load_id => v_generated_loads.load_id);
833:
834: fnd_file.put_line(fnd_file.log, 'Updating Data Status');
835:
836: -- Bugfix 5676634: Submit request for data status update instead of API call
837:
838: --gcs_cons_monitor_pkg.update_data_status(p_load_id => v_generated_loads.load_id,

Line 860: --fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request Id: '||l_request_id);

856: argument3 => NULL,
857: argument4 => v_generated_loads.load_id);
858:
859: --Bugfix 5347804: Commenting out println statement
860: --fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request Id: '||l_request_id);
861: END IF;
862:
863: END LOOP;
864:

Line 892: -- fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request Id: '||l_request_id);

888: -- argument2 => NULL,
889: -- argument3 => NULL,
890: -- argument4 => p_load_id);
891:
892: -- fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request Id: '||l_request_id);
893:
894: l_error_occurred := fnd_concurrent.set_completion_status(status => 'ERROR',
895: message => NULL);
896: END IF;

Line 902: fnd_file.put_line(fnd_file.log, 'An unexpected error occurred');

898: COMMIT;
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: fnd_file.put_line(fnd_file.log, 'An unexpected error occurred');
903: fnd_file.put_line(fnd_file.log,
904: 'The following SQL Error happened : ' || SQLERRM);
905:
906: UPDATE gcs_data_sub_dtls

Line 903: fnd_file.put_line(fnd_file.log,

899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: fnd_file.put_line(fnd_file.log, 'An unexpected error occurred');
903: fnd_file.put_line(fnd_file.log,
904: 'The following SQL Error happened : ' || SQLERRM);
905:
906: UPDATE gcs_data_sub_dtls
907: SET status_code = DECODE(l_status_code,

Line 956: fnd_file.put_line(fnd_file.log, 'Beginning Data Submission Execution');

952: g_api || '.SUBMIT_DATASUB.begin',
953: '<>');
954: END IF;
955:
956: fnd_file.put_line(fnd_file.log, 'Beginning Data Submission Execution');
957:
958: get_datasub_dtls(p_load_id => p_load_id,
959: p_datasub_info => l_datasub_info);
960:

Line 995: fnd_file.put_line(fnd_file.log,

991: WHERE load_id = p_load_id;
992:
993: COMMIT;
994:
995: fnd_file.put_line(fnd_file.log,
996: 'Checking Entity Type either External versus Oracle');
997:
998: --Bugfix 4969879: Remove call to check source system, as it has moved to get_datasub_info
999: fnd_file.put_line(fnd_file.log,

Line 999: fnd_file.put_line(fnd_file.log,

995: fnd_file.put_line(fnd_file.log,
996: 'Checking Entity Type either External versus Oracle');
997:
998: --Bugfix 4969879: Remove call to check source system, as it has moved to get_datasub_info
999: fnd_file.put_line(fnd_file.log,
1000: 'Source System Code is : ' ||
1001: l_datasub_info.source_system_code);
1002:
1003: --Bugfix 5112626: Need to use l_datasub_info.source_system_code rather than l_ledger_source_system_code

Line 1016: fnd_file.put_line(fnd_file.log,

1012:
1013: --Bugfix 6016288: If Locked, Put the message into log file, set the request status to warning and delete the
1014: --record from gcs_data_sub_dtls which is failed to submit.
1015: ElSE
1016: fnd_file.put_line(fnd_file.log,
1017: 'Recent Submission is locked, Unlock it and Resubmit');
1018:
1019: DELETE gcs_data_sub_dtls
1020: WHERE load_id = l_datasub_info.load_id;

Line 1035: fnd_file.put_line(fnd_file.log, SQLERRM);

1031: '<>');
1032: END IF;
1033: EXCEPTION
1034: WHEN OTHERS THEN
1035: fnd_file.put_line(fnd_file.log, SQLERRM);
1036: END submit_datasub;
1037:
1038: PROCEDURE update_amounts_autonomous(p_datasub_info IN r_datasub_info,
1039: p_first_ever_loaded IN VARCHAR2,

Line 2261: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning of Error >>>>');

2257: IF l_msg_info.FIRST IS NOT NULL THEN
2258: FOR l_counter in l_msg_info.FIRST .. l_msg_info.LAST LOOP
2259: IF l_msg_info(l_counter).error_msg IS NOT NULL THEN
2260:
2261: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning of Error >>>>');
2262: FND_FILE.NEW_LINE(FND_FILE.LOG);
2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 2262: FND_FILE.NEW_LINE(FND_FILE.LOG);

2258: FOR l_counter in l_msg_info.FIRST .. l_msg_info.LAST LOOP
2259: IF l_msg_info(l_counter).error_msg IS NOT NULL THEN
2260:
2261: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning of Error >>>>');
2262: FND_FILE.NEW_LINE(FND_FILE.LOG);
2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');

Line 2263: FND_FILE.PUT_LINE(FND_FILE.LOG,

2259: IF l_msg_info(l_counter).error_msg IS NOT NULL THEN
2260:
2261: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning of Error >>>>');
2262: FND_FILE.NEW_LINE(FND_FILE.LOG);
2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');
2267: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 2265: FND_FILE.NEW_LINE(FND_FILE.LOG);

2261: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning of Error >>>>');
2262: FND_FILE.NEW_LINE(FND_FILE.LOG);
2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');
2267: FND_FILE.NEW_LINE(FND_FILE.LOG);
2268:
2269: UPDATE gcs_data_sub_dtls

Line 2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');

2262: FND_FILE.NEW_LINE(FND_FILE.LOG);
2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');
2267: FND_FILE.NEW_LINE(FND_FILE.LOG);
2268:
2269: UPDATE gcs_data_sub_dtls
2270: SET status_code = 'VALIDATION_MEMBERS_FAILED'

Line 2267: FND_FILE.NEW_LINE(FND_FILE.LOG);

2263: FND_FILE.PUT_LINE(FND_FILE.LOG,
2264: 'One or more of the dimension members are invalid.Please refer View Data Loaded Report');
2265: FND_FILE.NEW_LINE(FND_FILE.LOG);
2266: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< End of Error >>>>');
2267: FND_FILE.NEW_LINE(FND_FILE.LOG);
2268:
2269: UPDATE gcs_data_sub_dtls
2270: SET status_code = 'VALIDATION_MEMBERS_FAILED'
2271: WHERE load_id = l_datasub_info.load_id;