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

Line 75: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

71: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_FEM_POSTING_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
72: GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' ||
73: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
74: END IF;
75: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
76:
77:
78: -- Set the epb table name
79: SELECT epb_table_name

Line 424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

420: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_cal_period_id = '' || to_char(p_cal_period_id));
421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );

Line 425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));

421: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id));
422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );
429: ';

Line 426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );

422: END IF;
423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );
429: ';
430:

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );

423:
424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );
429: ';
430:
431: curr_pos := 1;

Line 428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );

424: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || ''Gcs_Epb_Tr_Data'' || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
425: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_hierarchy_id = '' || to_char(p_hierarchy_id));
426: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_balance_type = '' || p_balance_type_code );
427: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_cal_period_id = '' || to_char(p_cal_period_id) );
428: FND_FILE.PUT_LINE(FND_FILE.LOG, '' p_analysis_cycle_id = '' || to_char(p_analysis_cycle_id) );
429: ';
430:
431: curr_pos := 1;
432: body_len := LENGTH(body);

Line 443: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Call Dimension Transfer '');

439: body:=
440: ' -- Call Dimension transfer program
441: GCS_DYN_EPB_DIMTR_PKG.Gcs_Epb_Tr_Dim(errbuf, retcode);
442:
443: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Call Dimension Transfer '');
444:
445: IF (statementloglevel >= runtimeloglevel ) THEN
446: FND_LOG.STRING(statementloglevel, ''gcs.plsql.gcs_epb_data_tr_pkg.gcs_epb_tr_data'', ''Called Dimension Transfer '');
447: END IF;

Line 466: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Top Currency = '' || l_top_curr );

462: AND attr.entity_id = hier.top_entity_id;
463:
464: --Bugfix 4655571: The top currency is no longer required since EPB should support reporting on currency as a dimension
465:
466: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Top Currency = '' || l_top_curr );
467:
468: -- get line item hierarchy id
469: SELECT ln_item_hierarchy_obj_id
470: INTO l_ln_item_obj_id

Line 549: FND_FILE.PUT_LINE(FND_FILE.LOG, '' cal_period_id = '' || to_char(p_cal_period_id));

545: -- FROM FEM_OBJECT_DEFINITION_B
546: -- WHERE object_id = l_ln_item_obj_id
547: -- AND l_end_date BETWEEN effective_start_date and effective_end_date;
548:
549: FND_FILE.PUT_LINE(FND_FILE.LOG, '' cal_period_id = '' || to_char(p_cal_period_id));
550:
551: -- Get object_id
552: SELECT associated_object_id
553: INTO l_object_id

Line 883: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Rows inserted into data table = '' || l_row_count);

879: body:=
880: '
881: l_row_count := SQL%ROWCOUNT;
882:
883: FND_FILE.PUT_LINE(FND_FILE.LOG, '' Rows inserted into data table = '' || l_row_count);
884:
885:
886: IF (l_row_count <> 0) THEN
887: -- Write to FEM_DATA_LOCATIONS

Line 940: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>'');

936: AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
937: AND feata.dim_attribute_varchar_member IN (''LIABILITY'', ''EQUITY'', ''REVENUE''));
938: ELSE
939: --Bugfix 5526501: Zero rows are inserted so we should set the completion status to warning
940: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>'');
941: fnd_file.put_line(fnd_file.log, ''No data was transferred to the data table'');
942: fnd_file.put_line(fnd_file.log, ''Please ensure the analytical report step in foundation was completed, and the consolidation process generated results.'');
943: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>'');
944: l_ret_status := fnd_concurrent.set_completion_status(

Line 941: fnd_file.put_line(fnd_file.log, ''No data was transferred to the data table'');

937: AND feata.dim_attribute_varchar_member IN (''LIABILITY'', ''EQUITY'', ''REVENUE''));
938: ELSE
939: --Bugfix 5526501: Zero rows are inserted so we should set the completion status to warning
940: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>'');
941: fnd_file.put_line(fnd_file.log, ''No data was transferred to the data table'');
942: fnd_file.put_line(fnd_file.log, ''Please ensure the analytical report step in foundation was completed, and the consolidation process generated results.'');
943: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>'');
944: l_ret_status := fnd_concurrent.set_completion_status(
945: status => ''WARNING'',

Line 942: fnd_file.put_line(fnd_file.log, ''Please ensure the analytical report step in foundation was completed, and the consolidation process generated results.'');

938: ELSE
939: --Bugfix 5526501: Zero rows are inserted so we should set the completion status to warning
940: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>'');
941: fnd_file.put_line(fnd_file.log, ''No data was transferred to the data table'');
942: fnd_file.put_line(fnd_file.log, ''Please ensure the analytical report step in foundation was completed, and the consolidation process generated results.'');
943: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>'');
944: l_ret_status := fnd_concurrent.set_completion_status(
945: status => ''WARNING'',
946: message => NULL);

Line 943: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>'');

939: --Bugfix 5526501: Zero rows are inserted so we should set the completion status to warning
940: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>'');
941: fnd_file.put_line(fnd_file.log, ''No data was transferred to the data table'');
942: fnd_file.put_line(fnd_file.log, ''Please ensure the analytical report step in foundation was completed, and the consolidation process generated results.'');
943: fnd_file.put_line(fnd_file.log, ''<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>'');
944: l_ret_status := fnd_concurrent.set_completion_status(
945: status => ''WARNING'',
946: message => NULL);
947: END IF;

Line 975: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);

971: retcode := ''0'';
972: IF (unexpectedloglevel >= runtimeloglevel ) THEN
973: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''NO_DATASET_CREATED'');
974: END IF;
975: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
976: l_ret_status := fnd_concurrent.set_completion_status(
977: status => ''ERROR'',
978: message => NULL);
979: RAISE;

Line 990: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);

986: retcode := ''0'';
987: IF (unexpectedloglevel >= runtimeloglevel ) THEN
988: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''DIM_TRANSFER_FAILED'');
989: END IF;
990: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
991: l_ret_status := fnd_concurrent.set_completion_status(
992: status => ''ERROR'',
993: message => NULL);
994: RAISE;

Line 1002: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);

998: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', ''GCS_NO_DATA_FOUND'');
999: END IF;
1000: retcode := ''0'';
1001: errbuf := ''GCS_NO_DATA_FOUND'';
1002: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
1003: l_ret_status := fnd_concurrent.set_completion_status(
1004: status => ''ERROR'',
1005: message => NULL);
1006: RAISE NO_DATA_FOUND;

Line 1014: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);

1010: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1011: FND_LOG.STRING(unexpectedloglevel, ''gcs.plsql.GCS_EPB_DATA_TR_PKG.GCS_EPB_TR_DATA'', errbuf);
1012: END IF;
1013: retcode := ''0'';
1014: fnd_file.put_line(fnd_file.log, ''Fatal Error Occurred : '' || SQLERRM);
1015: l_ret_status := fnd_concurrent.set_completion_status(
1016: status => ''ERROR'',
1017: message => NULL);
1018: RAISE;

Line 1075: fnd_file.put_line(fnd_file.log, ''<>'');

1071: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.begin'', ''<>'');
1073: END IF;
1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');
1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);
1077: fnd_file.put_line(fnd_file.log, ''Analysis Cycle Id : '' || p_analysis_cycle_id);
1078: fnd_file.put_line(fnd_file.log, ''<>'');
1079:

Line 1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);

1072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.SUBMIT_BUSINESS_PROCESS.begin'', ''<>'');
1073: END IF;
1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');
1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);
1077: fnd_file.put_line(fnd_file.log, ''Analysis Cycle Id : '' || p_analysis_cycle_id);
1078: fnd_file.put_line(fnd_file.log, ''<>'');
1079:
1080: -- bugfix 5569522: If the user had selected a business process, check whether

Line 1077: fnd_file.put_line(fnd_file.log, ''Analysis Cycle Id : '' || p_analysis_cycle_id);

1073: END IF;
1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');
1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);
1077: fnd_file.put_line(fnd_file.log, ''Analysis Cycle Id : '' || p_analysis_cycle_id);
1078: fnd_file.put_line(fnd_file.log, ''<>'');
1079:
1080: -- bugfix 5569522: If the user had selected a business process, check whether
1081: -- the user has the access to launch the business process.

Line 1078: fnd_file.put_line(fnd_file.log, ''<>'');

1074:
1075: fnd_file.put_line(fnd_file.log, ''<>'');
1076: fnd_file.put_line(fnd_file.log, ''Calendar Period : '' || p_cal_period_id);
1077: fnd_file.put_line(fnd_file.log, ''Analysis Cycle Id : '' || p_analysis_cycle_id);
1078: fnd_file.put_line(fnd_file.log, ''<>'');
1079:
1080: -- bugfix 5569522: If the user had selected a business process, check whether
1081: -- the user has the access to launch the business process.
1082: SELECT value

Line 1102: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS:Business Process access:'' || l_business_process_access);

1098: IF l_bp_user_id IS NOT NULL THEN
1099: l_business_process_access := ''Y'';
1100: END IF;
1101: END IF;
1102: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS:Business Process access:'' || l_business_process_access);
1103:
1104:
1105: IF (l_business_process_access = ''N'') THEN
1106: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');

Line 1106: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');

1102: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS:Business Process access:'' || l_business_process_access);
1103:
1104:
1105: IF (l_business_process_access = ''N'') THEN
1106: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');
1107: l_conc_req_status := FND_CONCURRENT.set_completion_status(''WARNING'', ''The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');
1108: ELSE
1109: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The user has access to submit the Business Process'');
1110: END IF;

Line 1109: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The user has access to submit the Business Process'');

1105: IF (l_business_process_access = ''N'') THEN
1106: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');
1107: l_conc_req_status := FND_CONCURRENT.set_completion_status(''WARNING'', ''The Business Process cannot be kicked off because the user does not have access to submit the Business Process'');
1108: ELSE
1109: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The user has access to submit the Business Process'');
1110: END IF;
1111:
1112:
1113: -- bugfix 5569522: if the user has access, launch the business process. If the

Line 1139: fnd_file.put_line(fnd_file.log, ''Business process name: '' || l_business_process_name);

1135: WHERE end_fcpa.cal_period_id = p_cal_period_id
1136: AND end_fcpa.attribute_id = l_end_date_attribute_id
1137: AND end_fcpa.version_id = l_end_date_version_id;
1138:
1139: fnd_file.put_line(fnd_file.log, ''Business process name: '' || l_business_process_name);
1140: fnd_file.put_line(fnd_file.log, ''Business Area name : '' || l_business_area_name);
1141: fnd_file.put_line(fnd_file.log, ''Horizon start date : '' || l_horizon_start);
1142: fnd_file.put_line(fnd_file.log, ''Horizon end date : '' || l_horizon_end);
1143:

Line 1140: fnd_file.put_line(fnd_file.log, ''Business Area name : '' || l_business_area_name);

1136: AND end_fcpa.attribute_id = l_end_date_attribute_id
1137: AND end_fcpa.version_id = l_end_date_version_id;
1138:
1139: fnd_file.put_line(fnd_file.log, ''Business process name: '' || l_business_process_name);
1140: fnd_file.put_line(fnd_file.log, ''Business Area name : '' || l_business_area_name);
1141: fnd_file.put_line(fnd_file.log, ''Horizon start date : '' || l_horizon_start);
1142: fnd_file.put_line(fnd_file.log, ''Horizon end date : '' || l_horizon_end);
1143:
1144:

Line 1141: fnd_file.put_line(fnd_file.log, ''Horizon start date : '' || l_horizon_start);

1137: AND end_fcpa.version_id = l_end_date_version_id;
1138:
1139: fnd_file.put_line(fnd_file.log, ''Business process name: '' || l_business_process_name);
1140: fnd_file.put_line(fnd_file.log, ''Business Area name : '' || l_business_area_name);
1141: fnd_file.put_line(fnd_file.log, ''Horizon start date : '' || l_horizon_start);
1142: fnd_file.put_line(fnd_file.log, ''Horizon end date : '' || l_horizon_end);
1143:
1144:
1145: ZPB_EXTERNAL_BP_PUBLISH.START_BUSINESS_PROCESS

Line 1142: fnd_file.put_line(fnd_file.log, ''Horizon end date : '' || l_horizon_end);

1138:
1139: fnd_file.put_line(fnd_file.log, ''Business process name: '' || l_business_process_name);
1140: fnd_file.put_line(fnd_file.log, ''Business Area name : '' || l_business_area_name);
1141: fnd_file.put_line(fnd_file.log, ''Horizon start date : '' || l_horizon_start);
1142: fnd_file.put_line(fnd_file.log, ''Horizon end date : '' || l_horizon_end);
1143:
1144:
1145: ZPB_EXTERNAL_BP_PUBLISH.START_BUSINESS_PROCESS
1146: (

Line 1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);

1159: X_msg_data => l_msg_data,
1160: X_return_status => l_return_status
1161: );
1162:
1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);
1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );

Line 1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);

1160: X_return_status => l_return_status
1161: );
1162:
1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);
1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );

Line 1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);

1161: );
1162:
1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);
1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );
1169:

Line 1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);

1162:
1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);
1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );
1169:
1170: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );

1163: fnd_file.put_line(fnd_file.log, '' l_start= '' || l_start);
1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );
1169:
1170: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1171: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process has been launched successfully'');

Line 1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );

1164: fnd_file.put_line(fnd_file.log, '' l_end= '' || l_end);
1165: fnd_file.put_line(fnd_file.log, '' l_key= '' || l_key);
1166: fnd_file.put_line(fnd_file.log, '' l_msg_count= '' || l_msg_count);
1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );
1169:
1170: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1171: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process has been launched successfully'');
1172:

Line 1171: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process has been launched successfully'');

1167: fnd_file.put_line(fnd_file.log, '' l_msg_data = '' || l_msg_data );
1168: fnd_file.put_line(fnd_file.log, '' l_return_status = '' || l_return_status );
1169:
1170: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1171: fnd_file.put_line(fnd_file.log, ''SUBMIT_BUSINESS_PROCESS: The Business Process has been launched successfully'');
1172:
1173: -- run the workflow background concurrent program.
1174: l_request_id := fnd_request.submit_request(
1175: application => ''FND'',

Line 1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'GCS_BUILD_EPB_DATATR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1212: GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' ||
1213: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1214: END IF;
1215: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 1228: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

1224: 'GCS_BUILD_EPB_DATA_TR_PKG' || '.' || 'BUILD_EPB_DATATR_PKG',
1225: GCS_UTILITY_PKG.g_module_failure || 'BUILD_EPB_DATATR_PKG' ||
1226: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1227: END IF;
1228: FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1229: 'BUILD_EPB_DATATR_PKG' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1230: END build_epb_datatr_pkg;
1231:
1232: END GCS_BUILD_EPB_DATA_TR_PKG;