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

Line 108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Loading Product Catalog Hierarchy into Value set');

104: l_count NUMBER := 0;
105: l_compile BOOLEAN := FALSE;
106:
107: BEGIN
108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Loading Product Catalog Hierarchy into Value set');
109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Getting associated Structure...');
111:
112: BEGIN

Line 109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

105: l_compile BOOLEAN := FALSE;
106:
107: BEGIN
108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Loading Product Catalog Hierarchy into Value set');
109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Getting associated Structure...');
111:
112: BEGIN
113:

Line 110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Getting associated Structure...');

106:
107: BEGIN
108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Loading Product Catalog Hierarchy into Value set');
109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Getting associated Structure...');
111:
112: BEGIN
113:
114: g_catset_id := ENI_DENORM_HRCHY.get_category_set_id;

Line 121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Product Catalog Not Found');

117: FROM MTL_CATEGORY_SETS_B
118: WHERE CATEGORY_SET_ID = g_catset_id;
119: EXCEPTION
120: WHEN NO_DATA_FOUND THEN
121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Product Catalog Not Found');
122: errbuf := 'ERROR: Product Catalog Not Found';
123: retcode := 2;
124: RAISE;
125: END;

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Structure of default category set can have only one segment enabled. More than one segment is not supported');

132: and enabled_flag = 'Y';
133:
134: EXCEPTION
135: WHEN TOO_MANY_ROWS THEN
136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR: Structure of default category set can have only one segment enabled. More than one segment is not supported');
137: errbuf := 'ERROR: Structure of default category set can have only one segment enabled. More than one segment is not supported';
138: retcode := 2;
139: RAISE;
140: WHEN NO_DATA_FOUND THEN

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

242:
243: -- First check if the hierarchy will create a loop in the
244: -- value set
245:
246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');

Line 247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');

243: -- First check if the hierarchy will create a loop in the
244: -- value set
245:
246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
251:

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');

244: -- value set
245:
246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
251:
252: FOR i IN c_hierarchy_loop(l_top_node) LOOP

Line 249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');

245:
246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
251:
252: FOR i IN c_hierarchy_loop(l_top_node) LOOP
253: FND_FILE.PUT_LINE(FND_FILE.LOG, i.nodes);

Line 250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');

246: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
247: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR: The following nodes already exist as parent of the top node in the value set.');
248: FND_FILE.PUT_LINE(FND_FILE.LOG,'These nodes cannot be created as child of the top node');
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
251:
252: FOR i IN c_hierarchy_loop(l_top_node) LOOP
253: FND_FILE.PUT_LINE(FND_FILE.LOG, i.nodes);
254: l_count := 1;

Line 253: FND_FILE.PUT_LINE(FND_FILE.LOG, i.nodes);

249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
250: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
251:
252: FOR i IN c_hierarchy_loop(l_top_node) LOOP
253: FND_FILE.PUT_LINE(FND_FILE.LOG, i.nodes);
254: l_count := 1;
255: END LOOP;
256:
257: IF l_count = 0 THEN

Line 258: FND_FILE.PUT_LINE(FND_FILE.LOG,'-- None --');

254: l_count := 1;
255: END LOOP;
256:
257: IF l_count = 0 THEN
258: FND_FILE.PUT_LINE(FND_FILE.LOG,'-- None --');
259: ELSE
260: errbuf := 'ERROR: Circular reference in the value set is not allowed';
261: retcode := 2;
262: RAISE_APPLICATION_ERROR(-20009, 'ERROR: Data error');

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating hierarchy in temp table under the top node');

265:
266: -- populating the hierarchy from only the top node down
267: -- into the temp table
268:
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating hierarchy in temp table under the top node');
270:
271: INSERT INTO ENI_VSET_HRCHY_TEMP (
272: CHILD_CODE,
273: PARENT_CODE,

Line 308: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

304:
305: -- the following nodes do not exist in the hierarchy, so will be
306: -- inserted into the value set
307:
308: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NEW NODES: New values that will be inserted into the value set');
310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
311: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
312:

Line 309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NEW NODES: New values that will be inserted into the value set');

305: -- the following nodes do not exist in the hierarchy, so will be
306: -- inserted into the value set
307:
308: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NEW NODES: New values that will be inserted into the value set');
310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
311: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
312:
313:

Line 310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');

306: -- inserted into the value set
307:
308: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NEW NODES: New values that will be inserted into the value set');
310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
311: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
312:
313:
314: l_sql_stmt := '

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');

307:
308: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NEW NODES: New values that will be inserted into the value set');
310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
311: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
312:
313:
314: l_sql_stmt := '
315: SELECT

Line 340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Opening Cursor to Insert new values');

336: AND F.FLEX_VALUE_SET_ID = :l_flex_val_set_id)';
337:
338:
339: l_count := 0;
340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Opening Cursor to Insert new values');
341: -- INSERTING NEW VALUES INTO FND_FLEX_VALUES TABLE
342: OPEN new_values_cursor FOR l_sql_stmt USING l_struct_id, g_catset_id, l_flex_val_set_id;
343:
344: LOOP

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg) ;

364: p_hierarchy_level => NULL,
365: x_storage_value => l_msg);
366:
367: l_count := 1;
368: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg) ;
369:
370: EXCEPTION WHEN OTHERS THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while Inserting '||l_flex_value||', '||l_msg);
372: errbuf := 'Error while Inserting '||l_flex_value||', '||l_msg;

Line 371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while Inserting '||l_flex_value||', '||l_msg);

367: l_count := 1;
368: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg) ;
369:
370: EXCEPTION WHEN OTHERS THEN
371: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while Inserting '||l_flex_value||', '||l_msg);
372: errbuf := 'Error while Inserting '||l_flex_value||', '||l_msg;
373: retcode := 2;
374: RAISE;
375: END;

Line 380: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -- none --');

376:
377: END LOOP;
378:
379: IF l_count = 0 then
380: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -- none --');
381: END IF;
382:
383: IF new_values_cursor%ISOPEN THEN
384: CLOSE new_values_cursor;

Line 392: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

388: -- The following nodes already exist in the value set and will
389: -- be updated
390:
391:
392: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UPDATED NODES: Updating Existing Values');
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
396:

Line 393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UPDATED NODES: Updating Existing Values');

389: -- be updated
390:
391:
392: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UPDATED NODES: Updating Existing Values');
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
396:
397:

Line 394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');

390:
391:
392: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UPDATED NODES: Updating Existing Values');
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
396:
397:
398: l_sql_stmt := '

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');

391:
392: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
393: FND_FILE.PUT_LINE(FND_FILE.LOG, 'UPDATED NODES: Updating Existing Values');
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FLEX VALUES ');
395: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------');
396:
397:
398: l_sql_stmt := '
399: SELECT

Line 505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg);

501: p_summary_flag => l_new_summary_flag,
502: x_storage_value => l_msg);
503:
504: l_count := 1;
505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg);
506:
507: EXCEPTION WHEN OTHERS THEN
508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while updating '||l_flex_value||', '||l_msg);
509: errbuf := 'Error while updating '||l_flex_value||', '||l_msg;

Line 508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while updating '||l_flex_value||', '||l_msg);

504: l_count := 1;
505: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg);
506:
507: EXCEPTION WHEN OTHERS THEN
508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while updating '||l_flex_value||', '||l_msg);
509: errbuf := 'Error while updating '||l_flex_value||', '||l_msg;
510: retcode := 2;
511: RAISE;
512: END;

Line 516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -- none --');

512: END;
513: END LOOP;
514:
515: IF l_count = 0 then
516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' -- none --');
517: END IF;
518:
519: IF existing_values_cursor%ISOPEN THEN
520: CLOSE existing_values_cursor;

Line 549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while updating '||l_top_node||', '||l_msg);

545: p_enabled_flag => 'Y',
546: x_storage_value => l_msg);
547:
548: exception when others then
549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while updating '||l_top_node||', '||l_msg);
550: errbuf := 'Error while Inserting '||l_flex_value||', '||l_msg;
551: retcode := 2;
552: RAISE;
553:

Line 557: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

553:
554: end;
555: end if;
556:
557: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: Direct children of the top node ');
559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
560: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
561:

Line 558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: Direct children of the top node ');

554: end;
555: end if;
556:
557: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: Direct children of the top node ');
559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
560: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
561:
562: -- Inserting new nodes under the top node specified in the UI

Line 559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');

555: end if;
556:
557: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: Direct children of the top node ');
559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
560: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
561:
562: -- Inserting new nodes under the top node specified in the UI
563: FOR i in c_hierarchy_top_node(l_top_node) loop

Line 560: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');

556:
557: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
558: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: Direct children of the top node ');
559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
560: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
561:
562: -- Inserting new nodes under the top node specified in the UI
563: FOR i in c_hierarchy_top_node(l_top_node) loop
564: BEGIN

Line 573: FND_FILE.PUT_LINE(FND_FILE.LOG, i.parent_code || ' ' || i.child_code);

569: p_child_flex_value_low => i.CHILD_CODE,
570: p_child_flex_value_high => i.CHILD_CODE);
571:
572: l_count := l_count + 1;
573: FND_FILE.PUT_LINE(FND_FILE.LOG, i.parent_code || ' ' || i.child_code);
574:
575: l_compile := TRUE;
576:
577: EXCEPTION WHEN OTHERS THEN

Line 578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating hierarchy under the top node '||i.parent_code||', '||l_msg);

574:
575: l_compile := TRUE;
576:
577: EXCEPTION WHEN OTHERS THEN
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating hierarchy under the top node '||i.parent_code||', '||l_msg);
579: errbuf := 'Error while creating hierarchy under the top node '||i.parent_code||', '||l_msg;
580: retcode := 2;
581: RAISE;
582: END;

Line 591: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

587:
588:
589: -- INSERTING THE REST OF THE HIERARCHY
590:
591: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: All the nodes ');
593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
594: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
595: l_count := 0;

Line 592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: All the nodes ');

588:
589: -- INSERTING THE REST OF THE HIERARCHY
590:
591: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: All the nodes ');
593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
594: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
595: l_count := 0;
596:

Line 593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');

589: -- INSERTING THE REST OF THE HIERARCHY
590:
591: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: All the nodes ');
593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
594: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
595: l_count := 0;
596:
597: FOR i IN hierarchy LOOP

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');

590:
591: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating Hierarchy: All the nodes ');
593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parent Code Child Code ');
594: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------- ------------ ');
595: l_count := 0;
596:
597: FOR i IN hierarchy LOOP
598: BEGIN

Line 607: FND_FILE.PUT_LINE(FND_FILE.LOG, i.parent_code || ' '|| i.child_code);

603: p_child_flex_value_low => i.CHILD_CODE,
604: p_child_flex_value_high => i.CHILD_CODE);
605:
606: l_count := l_count + 1;
607: FND_FILE.PUT_LINE(FND_FILE.LOG, i.parent_code || ' '|| i.child_code);
608:
609: l_compile := TRUE;
610: EXCEPTION WHEN OTHERS THEN
611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating hierarchy for child '||i.CHILD_CODE);

Line 611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating hierarchy for child '||i.CHILD_CODE);

607: FND_FILE.PUT_LINE(FND_FILE.LOG, i.parent_code || ' '|| i.child_code);
608:
609: l_compile := TRUE;
610: EXCEPTION WHEN OTHERS THEN
611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating hierarchy for child '||i.CHILD_CODE);
612: errbuf := 'Error while creating hierarchy for child '||i.CHILD_CODE;
613: retcode := 2;
614: RAISE;
615: END;

Line 627: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

623:
624: l_count := 0;
625: -- if l_top_node is not null then
626:
627: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Removing hierarchy relationship for nodes that do not exist under the top node');
629:
630: -- This will delete all the other children that no longer has any parent-child relationship under the top node
631: -- This delete SQL has two parts:

Line 628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Removing hierarchy relationship for nodes that do not exist under the top node');

624: l_count := 0;
625: -- if l_top_node is not null then
626:
627: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Removing hierarchy relationship for nodes that do not exist under the top node');
629:
630: -- This will delete all the other children that no longer has any parent-child relationship under the top node
631: -- This delete SQL has two parts:
632: -- The first part of the union selects the existing parent-child

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records deleted: '||l_count);

674:
675: l_count := SQL%ROWCOUNT;
676:
677: -- end if; -- if l_top_node is not null
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records deleted: '||l_count);
679:
680: IF l_count > 0 THEN
681: l_compile := TRUE;
682: END IF;

Line 685: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

681: l_compile := TRUE;
682: END IF;
683:
684: IF l_compile THEN
685: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
686: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Compiling Value set Hierarchy...');
687:
688: FND_GLOBAL.APPS_INITIALIZE(user_id => 0,
689: resp_id => 20420,

Line 686: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Compiling Value set Hierarchy...');

682: END IF;
683:
684: IF l_compile THEN
685: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
686: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Compiling Value set Hierarchy...');
687:
688: FND_GLOBAL.APPS_INITIALIZE(user_id => 0,
689: resp_id => 20420,
690: resp_appl_id => 1);

Line 700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);

696: FND_FLEX_VAL_API.SUBMIT_VSET_HIERARCHY_COMPILER
697: (p_flex_value_set_name => l_value_set_name,
698: x_request_id => l_msg);
699:
700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);
701: EXCEPTION
702: WHEN OTHERS THEN
703: l_msg := l_msg || ' ' || dbms_utility.format_error_stack();
704: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);

Line 704: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);

700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);
701: EXCEPTION
702: WHEN OTHERS THEN
703: l_msg := l_msg || ' ' || dbms_utility.format_error_stack();
704: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Submitted request '||l_msg);
705: RAISE;
706: END;
707:
708: ELSE

Line 709: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

705: RAISE;
706: END;
707:
708: ELSE
709: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
710: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No changes detected in Hierarchy');
711: END IF;
712:
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 710: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No changes detected in Hierarchy');

706: END;
707:
708: ELSE
709: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
710: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No changes detected in Hierarchy');
711: END IF;
712:
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully completed loading Product Catalog Hierarchy to Value Set');

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

709: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
710: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No changes detected in Hierarchy');
711: END IF;
712:
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully completed loading Product Catalog Hierarchy to Value Set');
715:
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN

Line 714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully completed loading Product Catalog Hierarchy to Value Set');

710: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No changes detected in Hierarchy');
711: END IF;
712:
713: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully completed loading Product Catalog Hierarchy to Value Set');
715:
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN
718: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: No Data Found. Transaction will be rolled back');

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: No Data Found. Transaction will be rolled back');

714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Successfully completed loading Product Catalog Hierarchy to Value Set');
715:
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN
718: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: No Data Found. Transaction will be rolled back');
719: errbuf := 'No data found ' || sqlerrm;
720: retcode := 2;
721: ROLLBACK;
722: RAISE;

Line 724: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: ' || sqlerrm || ' .Transaction will be rolled back');

720: retcode := 2;
721: ROLLBACK;
722: RAISE;
723: WHEN OTHERS THEN
724: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: ' || sqlerrm || ' .Transaction will be rolled back');
725: errbuf := 'Error :' || sqlerrm;
726: retcode := 2;
727: ROLLBACK;
728: RAISE;