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

Line 80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');

76:
77: BEGIN
78:
79: -- Bugfix 5257413: Added some logging information
80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');
81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);

Line 81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');

77: BEGIN
78:
79: -- Bugfix 5257413: Added some logging information
80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');
81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);
85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');

Line 82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);

78:
79: -- Bugfix 5257413: Added some logging information
80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');
81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);
85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');
86:

Line 83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);

79: -- Bugfix 5257413: Added some logging information
80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');
81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);
85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');
86:
87: -- Bug fix : 5257413, Start

Line 84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);

80: fnd_file.put_line(fnd_file.log, '.............Beginning of Concurrent Program.............');
81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);
85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');
86:
87: -- Bug fix : 5257413, Start
88: -- Checking if the User Dimension-01 is a part of the Processing Key

Line 85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');

81: fnd_file.put_line(fnd_file.log, '.............Beginning of Parameter Listing.............');
82: fnd_file.put_line(fnd_file.log, 'Hierarchy Identifier: ' || p_hierarchy_obj_id);
83: fnd_file.put_line(fnd_file.log, 'Version Name : ' || p_version_name);
84: fnd_file.put_line(fnd_file.log, 'Hierarchy Name : ' || p_hierarchy_name);
85: fnd_file.put_line(fnd_file.log, '.............End of Parameter Listing.............');
86:
87: -- Bug fix : 5257413, Start
88: -- Checking if the User Dimension-01 is a part of the Processing Key
89: BEGIN

Line 143: fnd_file.put_line(fnd_file.log, '.............Beginning of Attribute Information.............');

139: FROM fem_dim_attr_versions_b
140: WHERE attribute_id = l_attribute_id
141: AND default_version_flag = 'Y';
142:
143: fnd_file.put_line(fnd_file.log, '.............Beginning of Attribute Information.............');
144: fnd_file.put_line(fnd_file.log, 'Attribute Identifier: ' || l_attribute_id);
145: fnd_file.put_line(fnd_file.log, 'Version Identifier : ' || l_version_id);
146: fnd_file.put_line(fnd_file.log, '.............End of Attribute Information.............');
147:

Line 144: fnd_file.put_line(fnd_file.log, 'Attribute Identifier: ' || l_attribute_id);

140: WHERE attribute_id = l_attribute_id
141: AND default_version_flag = 'Y';
142:
143: fnd_file.put_line(fnd_file.log, '.............Beginning of Attribute Information.............');
144: fnd_file.put_line(fnd_file.log, 'Attribute Identifier: ' || l_attribute_id);
145: fnd_file.put_line(fnd_file.log, 'Version Identifier : ' || l_version_id);
146: fnd_file.put_line(fnd_file.log, '.............End of Attribute Information.............');
147:
148: --SKAMDAR: Modifying select statement to use version_name passed into the concurrent program

Line 145: fnd_file.put_line(fnd_file.log, 'Version Identifier : ' || l_version_id);

141: AND default_version_flag = 'Y';
142:
143: fnd_file.put_line(fnd_file.log, '.............Beginning of Attribute Information.............');
144: fnd_file.put_line(fnd_file.log, 'Attribute Identifier: ' || l_attribute_id);
145: fnd_file.put_line(fnd_file.log, 'Version Identifier : ' || l_version_id);
146: fnd_file.put_line(fnd_file.log, '.............End of Attribute Information.............');
147:
148: --SKAMDAR: Modifying select statement to use version_name passed into the concurrent program
149: SELECT object_definition_id

Line 146: fnd_file.put_line(fnd_file.log, '.............End of Attribute Information.............');

142:
143: fnd_file.put_line(fnd_file.log, '.............Beginning of Attribute Information.............');
144: fnd_file.put_line(fnd_file.log, 'Attribute Identifier: ' || l_attribute_id);
145: fnd_file.put_line(fnd_file.log, 'Version Identifier : ' || l_version_id);
146: fnd_file.put_line(fnd_file.log, '.............End of Attribute Information.............');
147:
148: --SKAMDAR: Modifying select statement to use version_name passed into the concurrent program
149: SELECT object_definition_id
150: INTO l_hierarchy_obj_def_id

Line 178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');

174: --If no data is found then the consolidation chart of accounts has not been assigned
175: RAISE CONSOLIDATION_GVSC_UNDEFINED;
176: END;
177:
178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');
179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);
180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);
181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;

Line 179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);

175: RAISE CONSOLIDATION_GVSC_UNDEFINED;
176: END;
177:
178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');
179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);
180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);
181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;
183:

Line 180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);

176: END;
177:
178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');
179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);
180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);
181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;
183:
184:

Line 181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);

177:
178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');
179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);
180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);
181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;
183:
184:
185: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_B Records).............');

Line 182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;

178: fnd_file.put_line(fnd_file.log, '.............Beginning of Hierarchy Information.............');
179: fnd_file.put_line(fnd_file.log, 'Hierarchy Object Def Identifier: ' || l_hierarchy_obj_def_id);
180: fnd_file.put_line(fnd_file.log, 'Value Set Identifier : ' || l_value_set_id);
181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;
183:
184:
185: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_B Records).............');
186: g_no_rows := 0;

Line 185: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_B Records).............');

181: fnd_file.put_line(fnd_file.log, 'Value Set Display Code : ' || l_vs_display_code);
182: fnd_file.put_line(fnd_file.log, '.............End of Hierarchy Information.............') ;
183:
184:
185: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_B Records).............');
186: g_no_rows := 0;
187: --SKAMDAR: Can change this into bulk statement in future.
188: FOR v_additional_lobs IN c_additional_lobs LOOP
189: INSERT INTO fem_user_dim1_b

Line 222: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);

218: g_no_rows := g_no_rows + 1;
219:
220: END LOOP;
221:
222: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
223: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_B Records).............');
224:
225: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_TL Records).............');
226:

Line 223: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_B Records).............');

219:
220: END LOOP;
221:
222: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
223: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_B Records).............');
224:
225: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_TL Records).............');
226:
227: INSERT INTO fem_user_dim1_tl

Line 225: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_TL Records).............');

221:
222: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
223: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_B Records).............');
224:
225: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_TL Records).............');
226:
227: INSERT INTO fem_user_dim1_tl
228: (user_dim1_id,
229: value_set_id,

Line 262: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);

258: AND fudt.language = fl.language_code);
259:
260: g_no_rows := NVL(SQL%ROWCOUNT,0);
261:
262: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
263: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_TL Records).............');
264:
265: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_ATTR Records).............');
266:

Line 263: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_TL Records).............');

259:
260: g_no_rows := NVL(SQL%ROWCOUNT,0);
261:
262: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
263: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_TL Records).............');
264:
265: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_ATTR Records).............');
266:
267: INSERT INTO fem_user_dim1_attr

Line 265: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_ATTR Records).............');

261:
262: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
263: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_TL Records).............');
264:
265: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Eliminations LOBs (_ATTR Records).............');
266:
267: INSERT INTO fem_user_dim1_attr
268: (attribute_id,
269: version_id,

Line 313: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);

309: AND fuda.value_set_id = fudb.value_set_id);
310:
311: g_no_rows := NVL(SQL%ROWCOUNT,0);
312:
313: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
314: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_ATTR Records).............');
315:
316: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Elimination Attributes.............');
317: INSERT INTO fem_user_dim1_attr(

Line 314: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_ATTR Records).............');

310:
311: g_no_rows := NVL(SQL%ROWCOUNT,0);
312:
313: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
314: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_ATTR Records).............');
315:
316: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Elimination Attributes.............');
317: INSERT INTO fem_user_dim1_attr(
318: attribute_id,

Line 316: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Elimination Attributes.............');

312:
313: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
314: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Eliminations LOBs (_ATTR Records).............');
315:
316: fnd_file.put_line(fnd_file.log, '.............Beginning Generation of Elimination Attributes.............');
317: INSERT INTO fem_user_dim1_attr(
318: attribute_id,
319: version_id,
320: user_dim1_id,

Line 362: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);

358: AND fuda1.value_set_id = fudb.value_set_id);
359:
360: g_no_rows := NVL(SQL%ROWCOUNT,0);
361:
362: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
363: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Elimination Attributes .............');
364:
365: INSERT INTO fem_hierarchies_t
366: (hierarchy_object_name,

Line 363: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Elimination Attributes .............');

359:
360: g_no_rows := NVL(SQL%ROWCOUNT,0);
361:
362: fnd_file.put_line(fnd_file.log, '# of rows: ' || g_no_rows);
363: fnd_file.put_line(fnd_file.log, '.............Completed Generation of Elimination Attributes .............');
364:
365: INSERT INTO fem_hierarchies_t
366: (hierarchy_object_name,
367: folder_name,

Line 493: fnd_file.put_line(fnd_file.log, '.............Beginning Submission of EPF Hierarchy Loader.............');

489:
490: COMMIT;
491:
492: -- Submit Dimension hierarchy loader.
493: fnd_file.put_line(fnd_file.log, '.............Beginning Submission of EPF Hierarchy Loader.............');
494: IF (l_submit_req >= 1) THEN
495: req_id := fnd_request.submit_request(
496: application => 'FEM',
497: program => 'FEM_HIER_LOADER',

Line 506: fnd_file.put_line(fnd_file.log, 'Request Identifier: ' || req_id);

502: argument4 => p_hierarchy_name,
503: argument5 => p_version_name);
504: COMMIT;
505:
506: fnd_file.put_line(fnd_file.log, 'Request Identifier: ' || req_id);
507: fnd_file.put_line(fnd_file.log, '.............Completed Submission of EPF Hierarchy Loader.............');
508:
509: IF req_id <= 0 THEN
510: p_errbuf := FND_MESSAGE.get;

Line 507: fnd_file.put_line(fnd_file.log, '.............Completed Submission of EPF Hierarchy Loader.............');

503: argument5 => p_version_name);
504: COMMIT;
505:
506: fnd_file.put_line(fnd_file.log, 'Request Identifier: ' || req_id);
507: fnd_file.put_line(fnd_file.log, '.............Completed Submission of EPF Hierarchy Loader.............');
508:
509: IF req_id <= 0 THEN
510: p_errbuf := FND_MESSAGE.get;
511: p_retcode := '2';

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

513: END IF;
514:
515: EXCEPTION
516: WHEN NO_USER_DIM1_PROC_KEY THEN
517: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
518: fnd_file.put_line(fnd_file.log, 'User Dimension 1 must be part of the consolidation processing key in order to run this program.');
519: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
520: p_errbuf := 'User Dimension 1 must be part of the consolidation processing key in order to run this program.';
521: p_retcode := 2;

Line 518: fnd_file.put_line(fnd_file.log, 'User Dimension 1 must be part of the consolidation processing key in order to run this program.');

514:
515: EXCEPTION
516: WHEN NO_USER_DIM1_PROC_KEY THEN
517: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
518: fnd_file.put_line(fnd_file.log, 'User Dimension 1 must be part of the consolidation processing key in order to run this program.');
519: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
520: p_errbuf := 'User Dimension 1 must be part of the consolidation processing key in order to run this program.';
521: p_retcode := 2;
522: WHEN CONSOLIDATION_GVSC_UNDEFINED THEN

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

515: EXCEPTION
516: WHEN NO_USER_DIM1_PROC_KEY THEN
517: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
518: fnd_file.put_line(fnd_file.log, 'User Dimension 1 must be part of the consolidation processing key in order to run this program.');
519: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
520: p_errbuf := 'User Dimension 1 must be part of the consolidation processing key in order to run this program.';
521: p_retcode := 2;
522: WHEN CONSOLIDATION_GVSC_UNDEFINED THEN
523: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');

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

519: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
520: p_errbuf := 'User Dimension 1 must be part of the consolidation processing key in order to run this program.';
521: p_retcode := 2;
522: WHEN CONSOLIDATION_GVSC_UNDEFINED THEN
523: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
524: fnd_file.put_line(fnd_file.log, 'The consolidation chart of accounts must be assigned before running this program.');
525: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
526: p_errbuf := 'The consolidation chart of accounts must be assigned before running this program.';
527: p_retcode := 2;

Line 524: fnd_file.put_line(fnd_file.log, 'The consolidation chart of accounts must be assigned before running this program.');

520: p_errbuf := 'User Dimension 1 must be part of the consolidation processing key in order to run this program.';
521: p_retcode := 2;
522: WHEN CONSOLIDATION_GVSC_UNDEFINED THEN
523: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
524: fnd_file.put_line(fnd_file.log, 'The consolidation chart of accounts must be assigned before running this program.');
525: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
526: p_errbuf := 'The consolidation chart of accounts must be assigned before running this program.';
527: p_retcode := 2;
528: WHEN OTHERS THEN

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

521: p_retcode := 2;
522: WHEN CONSOLIDATION_GVSC_UNDEFINED THEN
523: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
524: fnd_file.put_line(fnd_file.log, 'The consolidation chart of accounts must be assigned before running this program.');
525: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
526: p_errbuf := 'The consolidation chart of accounts must be assigned before running this program.';
527: p_retcode := 2;
528: WHEN OTHERS THEN
529: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');

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

525: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
526: p_errbuf := 'The consolidation chart of accounts must be assigned before running this program.';
527: p_retcode := 2;
528: WHEN OTHERS THEN
529: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
530: fnd_file.put_line(fnd_file.log, SQLERRM);
531: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
532: p_errbuf := SUBSTR(SQLERRM, 1, 255);
533: p_retcode := 2;

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

526: p_errbuf := 'The consolidation chart of accounts must be assigned before running this program.';
527: p_retcode := 2;
528: WHEN OTHERS THEN
529: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
530: fnd_file.put_line(fnd_file.log, SQLERRM);
531: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
532: p_errbuf := SUBSTR(SQLERRM, 1, 255);
533: p_retcode := 2;
534: ROLLBACK;

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

527: p_retcode := 2;
528: WHEN OTHERS THEN
529: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>');
530: fnd_file.put_line(fnd_file.log, SQLERRM);
531: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>');
532: p_errbuf := SUBSTR(SQLERRM, 1, 255);
533: p_retcode := 2;
534: ROLLBACK;
535: