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

Line 203: FND_FILE.PUT_LINE(FND_FILE.LOG,

199: BEGIN
200: -- In case of an error, we will roll back to this point in time.
201: SAVEPOINT gcs_hrate_import_start;
202:
203: FND_FILE.PUT_LINE(FND_FILE.LOG,
204: g_pkg_name || '.' || l_api_name || ' ENTER');
205: FND_FILE.NEW_LINE(FND_FILE.LOG);
206:
207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

201: SAVEPOINT gcs_hrate_import_start;
202:
203: FND_FILE.PUT_LINE(FND_FILE.LOG,
204: g_pkg_name || '.' || l_api_name || ' ENTER');
205: FND_FILE.NEW_LINE(FND_FILE.LOG);
206:
207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
208: fnd_log.STRING(fnd_log.level_procedure,
209: g_pkg_name || '.' || l_api_name,

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG,

274: wf_event.addparametertolist(p_name => 'ENTITY_ID',
275: p_value => p_entity_id,
276: p_parameterlist => l_parameter_list);
277: begin
278: FND_FILE.PUT_LINE(FND_FILE.LOG,
279: g_pkg_name || '.' || l_api_name ||
280: ' RAISE WF_EVENT');
281: FND_FILE.NEW_LINE(FND_FILE.LOG);
282: wf_event.RAISE(p_event_name => l_event_name,

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

277: begin
278: FND_FILE.PUT_LINE(FND_FILE.LOG,
279: g_pkg_name || '.' || l_api_name ||
280: ' RAISE WF_EVENT');
281: FND_FILE.NEW_LINE(FND_FILE.LOG);
282: wf_event.RAISE(p_event_name => l_event_name,
283: p_event_key => l_event_key,
284: p_parameters => l_parameter_list);
285: EXCEPTION

Line 287: FND_FILE.PUT_LINE(FND_FILE.LOG,

283: p_event_key => l_event_key,
284: p_parameters => l_parameter_list);
285: EXCEPTION
286: WHEN OTHERS THEN
287: FND_FILE.PUT_LINE(FND_FILE.LOG,
288: g_pkg_name || '.' || l_api_name ||
289: ' WF_EVENT FAILED');
290: FND_FILE.NEW_LINE(FND_FILE.LOG);
291: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

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

286: WHEN OTHERS THEN
287: FND_FILE.PUT_LINE(FND_FILE.LOG,
288: g_pkg_name || '.' || l_api_name ||
289: ' WF_EVENT FAILED');
290: FND_FILE.NEW_LINE(FND_FILE.LOG);
291: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
292: fnd_log.STRING(fnd_log.level_error,
293: g_pkg_name || '.' || l_api_name,
294: ' wf_event.raise failed ' || ' ' ||

Line 299: FND_FILE.PUT_LINE(FND_FILE.LOG,

295: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
296: END IF;
297: END;
298:
299: FND_FILE.PUT_LINE(FND_FILE.LOG,
300: g_pkg_name || '.' || l_api_name || ' EXIT');
301: FND_FILE.NEW_LINE(FND_FILE.LOG);
302:
303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

297: END;
298:
299: FND_FILE.PUT_LINE(FND_FILE.LOG,
300: g_pkg_name || '.' || l_api_name || ' EXIT');
301: FND_FILE.NEW_LINE(FND_FILE.LOG);
302:
303: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
304: fnd_log.STRING(fnd_log.level_procedure,
305: g_pkg_name || '.' || l_api_name,

Line 314: FND_FILE.PUT_LINE(FND_FILE.LOG,

310: EXCEPTION
311: WHEN OTHERS THEN
312: ROLLBACK TO gcs_hrate_import_start;
313:
314: FND_FILE.PUT_LINE(FND_FILE.LOG,
315: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
316: SQLERRM);
317: FND_FILE.NEW_LINE(FND_FILE.LOG);
318:

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

313:
314: FND_FILE.PUT_LINE(FND_FILE.LOG,
315: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
316: SQLERRM);
317: FND_FILE.NEW_LINE(FND_FILE.LOG);
318:
319: -- Write the appropriate information to the execution report
320: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
321: fnd_log.STRING(fnd_log.level_error,

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

1190: l_api_name VARCHAR2(30) := 'DIM_MEMBER_IMPORT';
1191: BEGIN
1192: SAVEPOINT dm_import_start;
1193:
1194: FND_FILE.NEW_LINE(FND_FILE.LOG);
1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');

1191: BEGIN
1192: SAVEPOINT dm_import_start;
1193:
1194: FND_FILE.NEW_LINE(FND_FILE.LOG);
1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);

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

1192: SAVEPOINT dm_import_start;
1193:
1194: FND_FILE.NEW_LINE(FND_FILE.LOG);
1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');

1193:
1194: FND_FILE.NEW_LINE(FND_FILE.LOG);
1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);

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

1194: FND_FILE.NEW_LINE(FND_FILE.LOG);
1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);

1195: FND_FILE.PUT_LINE(FND_FILE.LOG, '<<<< Beginning Dimension Member Load >>>>');
1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');

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

1196: FND_FILE.NEW_LINE(FND_FILE.LOG);
1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);

1197: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning of Parameters');
1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:

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

1198: FND_FILE.NEW_LINE(FND_FILE.LOG);
1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:
1206:

Line 1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');

1199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence Number: ' || p_sequence_num);
1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:
1206:
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

1200: FND_FILE.NEW_LINE(FND_FILE.LOG);
1201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dimension Varchar Label: ' || p_dimension_varchar_label);
1202: FND_FILE.NEW_LINE(FND_FILE.LOG);
1203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Parameters');
1204: FND_FILE.NEW_LINE(FND_FILE.LOG);
1205:
1206:
1207: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1208: fnd_log.STRING(fnd_log.level_procedure,

Line 1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing EPF Loader');

1368:
1369: END IF;
1370:
1371:
1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing EPF Loader');
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374:
1375: FEM_DIM_MEMBER_LOADER_PKG.Main(errbuf => x_errbuf,
1376: retcode => x_retcode,

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

1369: END IF;
1370:
1371:
1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'Executing EPF Loader');
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374:
1375: FEM_DIM_MEMBER_LOADER_PKG.Main(errbuf => x_errbuf,
1376: retcode => x_retcode,
1377: p_execution_mode => 'S',

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

1400: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_table_name );
1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');

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

1401: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , l_member_tl_table_name);
1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

1402: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE', l_member_attr_table_name );
1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:

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

1403:
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1412: fnd_log.STRING(fnd_log.level_procedure,

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

1405: FND_FILE.NEW_LINE(FND_FILE.LOG);
1406: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1407: FND_FILE.NEW_LINE(FND_FILE.LOG);
1408: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1409: FND_FILE.NEW_LINE(FND_FILE.LOG);
1410:
1411: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1412: fnd_log.STRING(fnd_log.level_procedure,
1413: g_pkg_name || '.' || l_api_name, FND_MESSAGE.get );

Line 1418: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<<< Dimension Member Load completed successfully >>>>>> ');

1414: END IF;
1415:
1416: ELSE
1417:
1418: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<<< Dimension Member Load completed successfully >>>>>> ');
1419: FND_FILE.NEW_LINE(FND_FILE.LOG);
1420: -- Bug Fix : 5232709 , End
1421:
1422: END IF ;

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

1415:
1416: ELSE
1417:
1418: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<<< Dimension Member Load completed successfully >>>>>> ');
1419: FND_FILE.NEW_LINE(FND_FILE.LOG);
1420: -- Bug Fix : 5232709 , End
1421:
1422: END IF ;
1423:

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

1431: FND_MESSAGE.set_token( 'DIM_B_TABLE' , g_dimension_info(p_dimension_varchar_label).b_t_table_name );
1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');

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

1432: FND_MESSAGE.set_token( 'DIM_TL_TABLE' , g_dimension_info(p_dimension_varchar_label).tl_t_table_name );
1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );

1433: FND_MESSAGE.set_token( 'DIM_ATTR_TABLE' ,g_dimension_info(p_dimension_varchar_label).attr_t_table_name );
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);
1441:

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

1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);
1441:
1442: x_errbuf := SQLERRM;

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

1435: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);
1441:
1442: x_errbuf := SQLERRM;
1443: x_retcode := '2';

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

1436: FND_FILE.NEW_LINE(FND_FILE.LOG);
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.get );
1438: FND_FILE.NEW_LINE(FND_FILE.LOG);
1439: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1440: FND_FILE.NEW_LINE(FND_FILE.LOG);
1441:
1442: x_errbuf := SQLERRM;
1443: x_retcode := '2';
1444:

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

1466: -- delete submitted data for this run
1467: DELETE FROM gcs_dimension_members_t
1468: WHERE sequence_num = p_sequence_num;
1469:
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');

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

1467: DELETE FROM gcs_dimension_members_t
1468: WHERE sequence_num = p_sequence_num;
1469:
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );

1468: WHERE sequence_num = p_sequence_num;
1469:
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:

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

1469:
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:
1477: -- Write the appropriate information to the execution report

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

1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< Beginning of Error >>>>');
1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:
1477: -- Write the appropriate information to the execution report
1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN

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

1471: FND_FILE.NEW_LINE(FND_FILE.LOG);
1472: FND_FILE.PUT_LINE(FND_FILE.LOG, x_errbuf );
1473: FND_FILE.NEW_LINE(FND_FILE.LOG);
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'<<<< End of Error >>>>');
1475: FND_FILE.NEW_LINE(FND_FILE.LOG);
1476:
1477: -- Write the appropriate information to the execution report
1478: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1479: fnd_log.STRING(fnd_log.level_error,

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

1533:
1534: p_version_start_date := FND_CONC_DATE.STRING_TO_DATE(p_version_start_dt);
1535: p_version_end_date := FND_CONC_DATE.STRING_TO_DATE(p_version_end_dt);
1536:
1537: FND_FILE.NEW_LINE(FND_FILE.LOG);
1538: FND_FILE.PUT_LINE(FND_FILE.LOG,
1539: g_pkg_name || '.' || l_api_name ||
1540: ' ENTER : p_sequence_num = ' || p_sequence_num ||
1541: ', p_dimension_varchar_label = ' ||

Line 1538: FND_FILE.PUT_LINE(FND_FILE.LOG,

1534: p_version_start_date := FND_CONC_DATE.STRING_TO_DATE(p_version_start_dt);
1535: p_version_end_date := FND_CONC_DATE.STRING_TO_DATE(p_version_end_dt);
1536:
1537: FND_FILE.NEW_LINE(FND_FILE.LOG);
1538: FND_FILE.PUT_LINE(FND_FILE.LOG,
1539: g_pkg_name || '.' || l_api_name ||
1540: ' ENTER : p_sequence_num = ' || p_sequence_num ||
1541: ', p_dimension_varchar_label = ' ||
1542: p_dimension_varchar_label || ', p_hierarchy_name = ' ||

Line 1700: FND_FILE.PUT_LINE(FND_FILE.LOG,

1696:
1697: EXECUTE IMMEDIATE l_statement
1698: USING p_hierarchy_name, p_version_name, p_sequence_num;
1699:
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: g_pkg_name || '.' || l_api_name ||
1702: ' calling FEM_HIER_LOADER_PKG ');
1703: FND_FILE.NEW_LINE(FND_FILE.LOG);
1704:

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

1699:
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: g_pkg_name || '.' || l_api_name ||
1702: ' calling FEM_HIER_LOADER_PKG ');
1703: FND_FILE.NEW_LINE(FND_FILE.LOG);
1704:
1705: fem_hier_loader_pkg.Main(errbuf => x_errbuf,
1706: retcode => x_retcode,
1707: p_execution_mode => 'S',

Line 1719: FND_FILE.PUT_LINE(FND_FILE.LOG,

1715: INTO l_status_code
1716: FROM Fnd_Concurrent_Requests
1717: WHERE request_id = FND_GLOBAL.conc_request_id;
1718:
1719: FND_FILE.PUT_LINE(FND_FILE.LOG,
1720: g_pkg_name || '.' || l_api_name ||
1721: ' FEM_HIER_LOADER_PKG return status : ' ||
1722: l_status_code);
1723: FND_FILE.NEW_LINE(FND_FILE.LOG);

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

1719: FND_FILE.PUT_LINE(FND_FILE.LOG,
1720: g_pkg_name || '.' || l_api_name ||
1721: ' FEM_HIER_LOADER_PKG return status : ' ||
1722: l_status_code);
1723: FND_FILE.NEW_LINE(FND_FILE.LOG);
1724:
1725: IF (l_status_code = 'E') THEN
1726: FND_FILE.PUT_LINE(FND_FILE.LOG,
1727: g_pkg_name || '.' || l_api_name ||

Line 1726: FND_FILE.PUT_LINE(FND_FILE.LOG,

1722: l_status_code);
1723: FND_FILE.NEW_LINE(FND_FILE.LOG);
1724:
1725: IF (l_status_code = 'E') THEN
1726: FND_FILE.PUT_LINE(FND_FILE.LOG,
1727: g_pkg_name || '.' || l_api_name ||
1728: ' FEM_HIER_LOADER_PKG failed');
1729: FND_FILE.NEW_LINE(FND_FILE.LOG);
1730:

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

1725: IF (l_status_code = 'E') THEN
1726: FND_FILE.PUT_LINE(FND_FILE.LOG,
1727: g_pkg_name || '.' || l_api_name ||
1728: ' FEM_HIER_LOADER_PKG failed');
1729: FND_FILE.NEW_LINE(FND_FILE.LOG);
1730:
1731: EXECUTE IMMEDIATE 'SELECT dim_table.parent_display_code, dim_table.child_display_code, ' ||
1732: ' dim_table.parent_value_set_display_code, dim_table.child_value_set_display_code, dim_table.status ' ||
1733: ' FROM ' ||

Line 1745: FND_FILE.PUT_LINE(FND_FILE.LOG,

1741: USING p_sequence_num;
1742:
1743: IF l_err_parent_display_code.FIRST IS NOT NULL THEN
1744: FOR i IN l_err_parent_display_code.FIRST .. l_err_parent_display_code.LAST LOOP
1745: FND_FILE.PUT_LINE(FND_FILE.LOG,
1746: ' Errored parent : ' ||
1747: l_err_parent_display_code(i) ||
1748: '; Errored parent value set : ' ||
1749: l_err_parent_vs_display_code(i) ||

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

1751: l_err_child_display_code(i) ||
1752: '; Errored child value set : ' ||
1753: l_err_child_vs_display_code(i) ||
1754: '; Errored cause : ' || l_err_status(i));
1755: FND_FILE.NEW_LINE(FND_FILE.LOG);
1756: END LOOP;
1757:
1758: DELETE FROM fem_hierarchies_t
1759: WHERE hierarchy_object_name = p_hierarchy_name

Line 1829: FND_FILE.PUT_LINE(FND_FILE.LOG,

1825:
1826: -- delete submitted data for this run
1827: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1828:
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,
1830: g_pkg_name || '.' || l_api_name || ' EXIT');
1831: FND_FILE.NEW_LINE(FND_FILE.LOG);
1832:
1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

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

1827: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1828:
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,
1830: g_pkg_name || '.' || l_api_name || ' EXIT');
1831: FND_FILE.NEW_LINE(FND_FILE.LOG);
1832:
1833: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1834: fnd_log.STRING(fnd_log.level_procedure,
1835: g_pkg_name || '.' || l_api_name,

Line 1848: FND_FILE.PUT_LINE(FND_FILE.LOG,

1844: x_retcode := '2';
1845:
1846: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1847:
1848: FND_FILE.PUT_LINE(FND_FILE.LOG,
1849: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1850: x_errbuf);
1851: FND_FILE.NEW_LINE(FND_FILE.LOG);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

1847:
1848: FND_FILE.PUT_LINE(FND_FILE.LOG,
1849: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1850: x_errbuf);
1851: FND_FILE.NEW_LINE(FND_FILE.LOG);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,
1853: 'Conflicting levels exist for some members');
1854: FND_FILE.NEW_LINE(FND_FILE.LOG);
1855:

Line 1852: FND_FILE.PUT_LINE(FND_FILE.LOG,

1848: FND_FILE.PUT_LINE(FND_FILE.LOG,
1849: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1850: x_errbuf);
1851: FND_FILE.NEW_LINE(FND_FILE.LOG);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,
1853: 'Conflicting levels exist for some members');
1854: FND_FILE.NEW_LINE(FND_FILE.LOG);
1855:
1856: WHEN OTHERS THEN

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

1850: x_errbuf);
1851: FND_FILE.NEW_LINE(FND_FILE.LOG);
1852: FND_FILE.PUT_LINE(FND_FILE.LOG,
1853: 'Conflicting levels exist for some members');
1854: FND_FILE.NEW_LINE(FND_FILE.LOG);
1855:
1856: WHEN OTHERS THEN
1857: ROLLBACK TO dh_import_start;
1858:

Line 1864: FND_FILE.PUT_LINE(FND_FILE.LOG,

1860: x_retcode := '2';
1861:
1862: DELETE FROM gcs_hier_members_t WHERE sequence_num = p_sequence_num;
1863:
1864: FND_FILE.PUT_LINE(FND_FILE.LOG,
1865: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1866: x_errbuf);
1867: FND_FILE.NEW_LINE(FND_FILE.LOG);
1868:

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

1863:
1864: FND_FILE.PUT_LINE(FND_FILE.LOG,
1865: g_pkg_name || '.' || l_api_name || ' ERROR : ' ||
1866: x_errbuf);
1867: FND_FILE.NEW_LINE(FND_FILE.LOG);
1868:
1869: -- Write the appropriate information to the execution report
1870: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
1871: fnd_log.STRING(fnd_log.level_error,

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

1905: PROCEDURE handle_interco_map_flag IS
1906: l_cnt NUMBER ;
1907: l_api_name VARCHAR2(30) := 'handle_interco_map_flag';
1908: BEGIN
1909: FND_FILE.NEW_LINE(FND_FILE.LOG);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,
1911: g_pkg_name || '.' || l_api_name );
1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1913: fnd_log.STRING(fnd_log.level_procedure,

Line 1910: FND_FILE.PUT_LINE(FND_FILE.LOG,

1906: l_cnt NUMBER ;
1907: l_api_name VARCHAR2(30) := 'handle_interco_map_flag';
1908: BEGIN
1909: FND_FILE.NEW_LINE(FND_FILE.LOG);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,
1911: g_pkg_name || '.' || l_api_name );
1912: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1913: fnd_log.STRING(fnd_log.level_procedure,
1914: g_pkg_name || '.' || l_api_name ,'Begin');