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

Line 155: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : WEBDAV : ' || l_child_org_document_id );

151: b.pk1_value = p_child_org_id AND
152: b.pk3_value = p_item_revision_id AND
153: (a.dm_folder_path || '/' || a.file_name) = l_master_folder_and_file AND
154: a.dm_node = l_master_item_node_id;
155: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : WEBDAV : ' || l_child_org_document_id );
156: -- Only one row should be found
157: l_child_org_document_id := l_child_org_document_id;
158: EXCEPTION
159: WHEN OTHERS THEN -- when no data found or if it returns more than one row

Line 160: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : WEBDAV Exception : ' || SQLERRM );

156: -- Only one row should be found
157: l_child_org_document_id := l_child_org_document_id;
158: EXCEPTION
159: WHEN OTHERS THEN -- when no data found or if it returns more than one row
160: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : WEBDAV Exception : ' || SQLERRM );
161: l_child_org_document_id := -1;
162: END;
163: END IF;
164:

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : Main Exception : ' ||SQLERRM );

165: RETURN l_child_org_document_id;
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MMITC : Main Exception : ' ||SQLERRM );
170:
171: END Get_Child_Org_Item_AttId;
172:
173: PROCEDURE Propagated_Local_Change (

Line 491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');

487: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
488: );
489: l_return_status := FND_API.G_RET_STS_ERROR;
490: -- this case should not be reached as validation of attachments has already been done.
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');
492: END IF;
493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);
494: IF l_return_status = FND_API.G_RET_STS_SUCCESS
495: THEN

Line 536: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error propagating attachment changes' ||SQLERRM);

532: , p_Message_Text => 'Unexpected Error Occurred when propagating attachment changes' ||SQLERRM
533: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl
534: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
535: );
536: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error propagating attachment changes' ||SQLERRM);
537: Eng_Propagation_log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Attach_Lines.END.ERROR');
538: END Propagate_Attach_Lines;
539:
540: PROCEDURE BREAK_COMMON_BOM (

Line 1108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in validation attachments ' || SQLERRM);

1104: THEN
1105: CLOSE c_check_item_level_changes;
1106: END IF;
1107: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.ERROR');
1108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in validation attachments ' || SQLERRM);
1109: l_error_logged := 1;
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: Error_Handler.Add_Error_Token(
1112: p_Message_Name => NULL

Line 1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');

1935: l_status_type NUMBER;
1936:
1937: BEGIN
1938:
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1942: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1943:

Line 1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);

1936:
1937: BEGIN
1938:
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1942: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1943:
1944: /* Need the Organization Id to fetch the records */

Line 1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);

1937: BEGIN
1938:
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1942: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1943:
1944: /* Need the Organization Id to fetch the records */
1945: SELECT MP.organization_id

Line 1942: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);

1938:
1939: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1941: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1942: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1943:
1944: /* Need the Organization Id to fetch the records */
1945: SELECT MP.organization_id
1946: INTO l_org_hierarchy_level_id

Line 1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists under the Hierarchy Level '|| p_org_hierarchy_name||' and '||p_org_hierarchy_level);

1962:
1963:
1964: IF (l_org_code_list.COUNT = 0) THEN
1965:
1966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists under the Hierarchy Level '|| p_org_hierarchy_name||' and '||p_org_hierarchy_level);
1967:
1968: RETURN;
1969: END IF;
1970:

Line 1973: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only Organization '|| p_org_hierarchy_level|| ' exists under the Hierarchy Level'|| p_org_hierarchy_name||' and '||p_org_hierarchy_level);

1969: END IF;
1970:
1971: IF (l_org_code_list.COUNT = 1) THEN
1972:
1973: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only Organization '|| p_org_hierarchy_level|| ' exists under the Hierarchy Level'|| p_org_hierarchy_name||' and '||p_org_hierarchy_level);
1974:
1975: RETURN;
1976: END IF;
1977:

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

1974:
1975: RETURN;
1976: END IF;
1977:
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1982:

Line 1979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');

1975: RETURN;
1976: END IF;
1977:
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1982:
1983: FOR l_org_count in 1..l_org_code_list.COUNT

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

1976: END IF;
1977:
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1982:
1983: FOR l_org_count in 1..l_org_code_list.COUNT
1984: Loop

Line 1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);

1977:
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1982:
1983: FOR l_org_count in 1..l_org_code_list.COUNT
1984: Loop
1985: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));

Line 1985: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));

1981: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1982:
1983: FOR l_org_count in 1..l_org_code_list.COUNT
1984: Loop
1985: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));
1986: end loop;
1987:
1988: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1989:

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

1984: Loop
1985: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));
1986: end loop;
1987:
1988: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1989:
1990: FOR l_org_count in 2..l_org_code_list.LAST
1991: LOOP /* Loop 1 */
1992:

Line 2012: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Organization '|| l_org_code);

2008:
2009: IF l_org_code IS NOT NULL /* Organization Check*/
2010: THEN
2011:
2012: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Organization '|| l_org_code);
2013: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2014:
2015:
2016: SELECT count(*)

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

2009: IF l_org_code IS NOT NULL /* Organization Check*/
2010: THEN
2011:
2012: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Organization '|| l_org_code);
2013: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2014:
2015:
2016: SELECT count(*)
2017: into temp_count

Line 2026: FND_FILE.PUT_LINE(FND_FILE.LOG,'This ECO '||p_change_notice|| 'will not be processed as it already exists in Organization '|| l_org_code);

2022: -- Fetch ECO Masters
2023:
2024: IF temp_count > 0 THEN /* ECO Check */
2025:
2026: FND_FILE.PUT_LINE(FND_FILE.LOG,'This ECO '||p_change_notice|| 'will not be processed as it already exists in Organization '|| l_org_code);
2027:
2028: ELSE
2029:
2030: FOR eco_rec IN c_eco_rec

Line 2033: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Header ...');

2029:
2030: FOR eco_rec IN c_eco_rec
2031: LOOP /* Loop 2 */
2032:
2033: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Header ...');
2034:
2035: IF (eco_rec.change_order_type_id IS NOT NULL) THEN
2036:
2037: SELECT CHANGE_ORDER_TYPE

Line 2081: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for requestor id ' || to_char( eco_rec.requestor_id) || ' in org ' || to_char(l_org_hierarchy_level_id));

2077: FETCH c_user_name INTO l_requestor_name;
2078: CLOSE c_user_name;
2079: exception
2080: When No_Data_found then
2081: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for requestor id ' || to_char( eco_rec.requestor_id) || ' in org ' || to_char(l_org_hierarchy_level_id));
2082: l_requestor_name := NULL;
2083: end;
2084:
2085: /*

Line 2095: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for requestor id ' || to_char( eco_rec.requestor_id) || ' in org ' || to_char(l_org_hierarchy_level_id));

2091: WHERE organization_id = l_org_hierarchy_level_id
2092: AND employee_id = eco_rec.requestor_id;
2093: Exception
2094: When No_Data_found then
2095: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for requestor id ' || to_char( eco_rec.requestor_id) || ' in org ' || to_char(l_org_hierarchy_level_id));
2096: l_requestor_name := NULL;
2097: End;
2098: */
2099: ELSE

Line 2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for assignee id ' || to_char( eco_rec.assignee_id) || ' in org ' || to_char(l_org_hierarchy_level_id));

2108: FETCH c_user_name INTO l_assignee_name;
2109: CLOSE c_user_name;
2110: exception
2111: When No_Data_found then
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for assignee id ' || to_char( eco_rec.assignee_id) || ' in org ' || to_char(l_org_hierarchy_level_id));
2113: l_assignee_name := NULL;
2114: end;
2115: ELSE
2116: l_assignee_name := NULL;

Line 2128: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));

2124: FROM pa_projects_all
2125: WHERE project_id = eco_rec.PROJECT_ID;
2126: Exception
2127: When No_Data_found then
2128: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));
2129: l_Project_Number := NULL;
2130: End;
2131: ELSE
2132: l_Project_Number := NULL;

Line 2143: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));

2139: FROM pa_tasks
2140: WHERE TASK_ID = eco_rec.TASK_ID;
2141: Exception
2142: When No_Data_found then
2143: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));
2144: l_Task_Number := NULL;
2145: End;
2146: ELSE
2147: l_Task_Number := NULL;

Line 2233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');

2229:
2230: FOR rev IN c_eco_revision
2231: LOOP /* Loop 3 */
2232:
2233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');
2234:
2235: l_eco_revision_tbl(i).eco_name := rev.change_notice;
2236: l_eco_revision_tbl(i).organization_code:= l_org_code;
2237: l_eco_revision_tbl(i).revision := rev.revision;

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

2262: i := i + 1;
2263:
2264: END LOOP; /* End Loop 3 */
2265:
2266: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2267:
2268: -- Fetch revised items
2269:
2270: i := 1;

Line 2275: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Items ...');

2271:
2272: FOR ri IN c_rev_items
2273: LOOP /* Loop 4 */
2274:
2275: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Items ...');
2276:
2277: BEGIN
2278:
2279: l_item_exits_in_org_flag := 1;

Line 2303: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alternate BOM Designator ' || ri.alternate_bom_designator||' is not defined for Org '||l_org_code);

2299: AND ALTERNATE_DESIGNATOR_CODE = ri.alternate_bom_designator;
2300:
2301: EXCEPTION
2302: WHEN NO_DATA_FOUND THEN
2303: FND_FILE.PUT_LINE(FND_FILE.LOG,'Alternate BOM Designator ' || ri.alternate_bom_designator||' is not defined for Org '||l_org_code);
2304: l_check_invalid_objects := 0;
2305: END;
2306:
2307: BEGIN

Line 2318: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot define an Alternate BOM Designator ' ||ri.alternate_bom_designator||' without primary bill for revised item id '|| ri.revised_item_id|| ' in org '||l_org_code);

2314: AND alternate_bom_designator is NULL;
2315:
2316: EXCEPTION
2317: WHEN NO_DATA_FOUND THEN
2318: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cannot define an Alternate BOM Designator ' ||ri.alternate_bom_designator||' without primary bill for revised item id '|| ri.revised_item_id|| ' in org '||l_org_code);
2319: l_check_invalid_objects := 0;
2320: END;
2321:
2322: END IF;

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

2341: l_use_up_item_name := NULL;
2342:
2343: END IF;
2344:
2345: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2346:
2347: IF (l_item_exits_in_org_flag = 1) THEN
2348: l_revised_item_tbl(i).eco_name := ri.change_notice;
2349: l_revised_item_tbl(i).organization_code := l_org_code;

Line 2437: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Use_Up_Item_id = '||

2433: i := i + 1;
2434:
2435: ELSE
2436:
2437: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Use_Up_Item_id = '||
2438: ri.use_up_item_id||' for Org '||l_org_code);
2439:
2440: END IF;
2441:

Line 2444: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id = '||

2440: END IF;
2441:
2442: ELSE
2443:
2444: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id = '||
2445: ri.revised_item_id||' for Org '||l_org_code);
2446:
2447: END IF;
2448:

Line 2456: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components For Implemented Ecos having ACD type as Disable for Components...');

2452: i := 1;
2453: For rcd IN c_rev_comps_disable
2454: LOOP
2455:
2456: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components For Implemented Ecos having ACD type as Disable for Components...');
2457:
2458: BEGIN
2459: l_item_exits_in_org_flag := 1;
2460: SELECT msi.concatenated_segments,eri.new_item_revision

Line 2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error in Disable After implementation for sql statement Number :' || to_char(St_Number));

2543: EXCEPTION
2544: WHEN NO_DATA_FOUND THEN
2545: old_operation_seq_num := NULL;
2546: old_effectivity_date := NULL;
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error in Disable After implementation for sql statement Number :' || to_char(St_Number));
2548: WHEN OTHERS THEN
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in Disable after implementation statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2550: END;
2551: l_rev_component_tbl(i).eco_name := rcd.change_notice;

Line 2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in Disable after implementation statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));

2545: old_operation_seq_num := NULL;
2546: old_effectivity_date := NULL;
2547: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error in Disable After implementation for sql statement Number :' || to_char(St_Number));
2548: WHEN OTHERS THEN
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in Disable after implementation statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2550: END;
2551: l_rev_component_tbl(i).eco_name := rcd.change_notice;
2552: l_rev_component_tbl(i).organization_code:= l_org_code;
2553: l_rev_component_tbl(i).revised_item_name :=

Line 2640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rcd.component_item_id||' for Org '||l_org_code);

2636: i := i + 1;
2637:
2638: ELSE
2639:
2640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rcd.component_item_id||' for Org '||l_org_code);
2641: END IF;
2642: ELSE
2643:
2644: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||rcd.revised_item_sequence_id||' for Org '||l_org_code);

Line 2644: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||rcd.revised_item_sequence_id||' for Org '||l_org_code);

2640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rcd.component_item_id||' for Org '||l_org_code);
2641: END IF;
2642: ELSE
2643:
2644: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||rcd.revised_item_sequence_id||' for Org '||l_org_code);
2645: END IF;
2646: END LOOP;
2647:
2648: -- Fetch revised components

Line 2653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components ...');

2649:
2650: FOR rc IN c_rev_comps
2651: LOOP /* Loop 5 */
2652:
2653: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components ...');
2654:
2655: BEGIN
2656:
2657: l_item_exits_in_org_flag := 1;

Line 2821: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error for sql statement Number :' || to_char(St_Number));

2817: EXCEPTION
2818: WHEN NO_DATA_FOUND THEN
2819: old_operation_seq_num := NULL;
2820: old_effectivity_date := NULL;
2821: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error for sql statement Number :' || to_char(St_Number));
2822: WHEN OTHERS THEN
2823: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2824: END;
2825: ELSE

Line 2823: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));

2819: old_operation_seq_num := NULL;
2820: old_effectivity_date := NULL;
2821: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error for sql statement Number :' || to_char(St_Number));
2822: WHEN OTHERS THEN
2823: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2824: END;
2825: ELSE
2826: old_operation_seq_num := NULL;
2827: old_effectivity_date := NULL;

Line 2928: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rc.component_item_id||' for Org '||l_org_code);

2924: i := i + 1;
2925:
2926: ELSE
2927:
2928: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rc.component_item_id||' for Org '||l_org_code);
2929:
2930: END IF;
2931:
2932: ELSE

Line 2934: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||

2930: END IF;
2931:
2932: ELSE
2933:
2934: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||
2935: rc.revised_item_sequence_id||' for Org '||l_org_code);
2936: END IF;
2937:
2938: END LOOP; /* End Loop 5 */

Line 2947: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');

2943:
2944: FOR sc IN c_sub_comps
2945: LOOP /* Loop 6 */
2946:
2947: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');
2948:
2949: BEGIN
2950:
2951: l_item_exits_in_org_flag := 1;

Line 3086: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Substitute_Component_Id = '|| sc.substitute_component_id||' for Org '||l_org_code);

3082: i := i + 1;
3083:
3084: ELSE
3085:
3086: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Substitute_Component_Id = '|| sc.substitute_component_id||' for Org '||l_org_code);
3087:
3088: END IF;
3089:
3090: ELSE

Line 3092: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '|| sc.component_sequence_id||' for Org '||l_org_code);

3088: END IF;
3089:
3090: ELSE
3091:
3092: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '|| sc.component_sequence_id||' for Org '||l_org_code);
3093:
3094: END IF;
3095:
3096: ELSE

Line 3098: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id for Component_Seq_Id = '|| sc.component_sequence_id||' for Org '||l_org_code);

3094: END IF;
3095:
3096: ELSE
3097:
3098: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id for Component_Seq_Id = '|| sc.component_sequence_id||' for Org '||l_org_code);
3099:
3100: END IF;
3101:
3102: END LOOP; /* End Loop 6 */

Line 3111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');

3107:
3108: FOR rd IN c_ref_desgs
3109: LOOP /* Loop 7 */
3110:
3111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');
3112: BEGIN
3113:
3114: l_item_exits_in_org_flag := 1;
3115:

Line 3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '||rd.component_sequence_id||' for Org '||l_org_code);

3206: i:= i + 1;
3207:
3208: ELSE
3209:
3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '||rd.component_sequence_id||' for Org '||l_org_code);
3211:
3212: END IF;
3213:
3214: ELSE

Line 3216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid revised_item_id for Component_Seq_Id = '|| rd.component_sequence_id||' for Org '||l_org_code);

3212: END IF;
3213:
3214: ELSE
3215:
3216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid revised_item_id for Component_Seq_Id = '|| rd.component_sequence_id||' for Org '||l_org_code);
3217:
3218: END IF;
3219: END LOOP; /* End Loop 7 */
3220:

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

3218: END IF;
3219: END LOOP; /* End Loop 7 */
3220:
3221: IF l_check_invalid_objects = 1 THEN
3222: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3223:
3224: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3225: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3226: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');

Line 3241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');

3237: /* Initializing the Error Handler */
3238:
3239: Error_Handler.Initialize;
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3242: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3243: Eng_Eco_Pub.Process_Eco
3244: (
3245: p_api_version_number => 1.0

Line 3275: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');

3271: ,p_output_dir => '/sqlcom/log/dom1151'
3272: ,p_debug_filename => 'ECO_BO_debug.log'
3273: );
3274: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT :=0; --resetting values
3275: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3276: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3277: --
3278: -- On return from the PUB API
3279: -- Perform all the error handler operations to verify that the

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

3272: ,p_debug_filename => 'ECO_BO_debug.log'
3273: );
3274: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT :=0; --resetting values
3275: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3276: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3277: --
3278: -- On return from the PUB API
3279: -- Perform all the error handler operations to verify that the
3280: -- error or warning are displayed and all the error table interface

Line 3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );

3297: SELECT change_id INTO l_new_change_id
3298: FROM eng_engineering_changes
3299: WHERE change_notice = p_change_notice
3300: AND organization_id = l_org_id;
3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );
3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );
3303: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Change_id '||l_new_change_id );
3304: fnd_attached_documents2_pkg.copy_attachments(
3305: X_from_entity_name => 'ENG_ENGINEERING_CHANGES',

Line 3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );

3298: FROM eng_engineering_changes
3299: WHERE change_notice = p_change_notice
3300: AND organization_id = l_org_id;
3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );
3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );
3303: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Change_id '||l_new_change_id );
3304: fnd_attached_documents2_pkg.copy_attachments(
3305: X_from_entity_name => 'ENG_ENGINEERING_CHANGES',
3306: X_from_pk1_value => ECO_rec.change_id,

Line 3303: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Change_id '||l_new_change_id );

3299: WHERE change_notice = p_change_notice
3300: AND organization_id = l_org_id;
3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );
3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );
3303: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Change_id '||l_new_change_id );
3304: fnd_attached_documents2_pkg.copy_attachments(
3305: X_from_entity_name => 'ENG_ENGINEERING_CHANGES',
3306: X_from_pk1_value => ECO_rec.change_id,
3307: X_from_pk2_value => '',

Line 3323: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment done for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );

3319: X_program_application_id=> '',
3320: X_program_id => '',
3321: X_request_id => ''
3322: );
3323: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment done for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );
3324: EXCEPTION WHEN OTHERS THEN
3325: FND_File.put_line(FND_FILE.log, 'Could not Copy ECO attachment for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );
3326: END;
3327: /*End bug #7496156 to Copy attached Document*/

Line 3325: FND_File.put_line(FND_FILE.log, 'Could not Copy ECO attachment for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );

3321: X_request_id => ''
3322: );
3323: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment done for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );
3324: EXCEPTION WHEN OTHERS THEN
3325: FND_File.put_line(FND_FILE.log, 'Could not Copy ECO attachment for Org Code '|| l_org_Code||' and Change Id '||l_new_change_id );
3326: END;
3327: /*End bug #7496156 to Copy attached Document*/
3328: COMMIT;
3329: else

Line 3335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);

3331: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3332: i:=0;
3333: FOR i IN 1..l_error_table.COUNT
3334: LOOP
3335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3336: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3338: END LOOP;
3339:

Line 3336: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);

3332: i:=0;
3333: FOR i IN 1..l_error_table.COUNT
3334: LOOP
3335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3336: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3338: END LOOP;
3339:
3340: end if;

Line 3337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);

3333: FOR i IN 1..l_error_table.COUNT
3334: LOOP
3335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3336: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3338: END LOOP;
3339:
3340: end if;
3341:

Line 3344: FND_FILE.PUT_LINE(FND_FILE.LOG,'This ECO '||p_change_notice|| ' cannot be processed as there are invalid Items as listed above . Please correct these Items and re-run the propagate ECO');

3340: end if;
3341:
3342: ELSE
3343:
3344: FND_FILE.PUT_LINE(FND_FILE.LOG,'This ECO '||p_change_notice|| ' cannot be processed as there are invalid Items as listed above . Please correct these Items and re-run the propagate ECO');
3345:
3346: l_check_invalid_objects := 1;
3347:
3348: END IF;

Line 3764: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');

3760:
3761: FOR sc IN c_plm_sub_comps
3762: LOOP /* Loop 6 */
3763:
3764: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');
3765: l_item_exits_in_org_flag := G_VAL_TRUE;
3766: OPEN c_get_item_details(sc.substitute_component_id, p_local_organization_id);
3767: FETCH c_get_item_details INTO l_substitute_component_name;
3768: IF c_get_item_details%NOTFOUND

Line 3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Component Enabling Failed ..');

3816: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3817: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3818: );
3819: END LOOP;
3820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Component Enabling Failed ..');
3821: l_item_error_table.delete;
3822: END IF;
3823: END IF;
3824: IF l_item_exits_in_org_flag = G_VAL_FALSE

Line 3889: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');

3885: /* Fetch all revised reference designators on this structure of this revised item */
3886: FOR rd IN c_plm_ref_desgs
3887: LOOP /* Loop 7 */
3888:
3889: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');
3890: l_ref_designator_tbl(l_ref_designator_count).eco_name := rd.change_notice;
3891: l_ref_designator_tbl(l_ref_designator_count).organization_code := p_revised_item_rec.organization_code;
3892: l_ref_designator_tbl(l_ref_designator_count).revised_item_name := l_revised_item_name;
3893: l_ref_designator_tbl(l_ref_designator_count).start_effective_date := rc.effectivity_date;

Line 4406: FND_FILE.PUT_LINE(FND_FILE.LOG,

4402: FETCH c_user_name INTO l_requestor_name;
4403: CLOSE c_user_name;
4404: EXCEPTION
4405: WHEN NO_DATA_FOUND THEN
4406: FND_FILE.PUT_LINE(FND_FILE.LOG,
4407: 'No_Data_found for requestor id '
4408: || to_char( eco_rec.requestor_id)
4409: || ' in org ' || to_char(p_organization_id));
4410: l_requestor_name := NULL;

Line 4425: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));

4421: FROM pa_projects_all
4422: WHERE project_id = eco_rec.PROJECT_ID;
4423: EXCEPTION
4424: WHEN NO_DATA_FOUND THEN
4425: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));
4426: l_Project_Number := NULL;
4427: END;
4428: ELSE
4429: l_Project_Number := NULL;

Line 4441: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));

4437: FROM pa_tasks
4438: WHERE TASK_ID = eco_rec.TASK_ID;
4439: EXCEPTION
4440: WHEN NO_DATA_FOUND THEN
4441: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));
4442: l_Task_Number := NULL;
4443: END;
4444: ELSE
4445: l_Task_Number := NULL;

Line 4465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing ECO Fetch status..' );

4461: l_task_number1 := NULL;
4462: END IF;
4463:
4464: /* check whether the local organization eco needs to be scheduled immediately */
4465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing ECO Fetch status..' );
4466: BEGIN
4467: SELECT 1
4468: INTO l_sched_immediately
4469: FROM ENG_ORG_HIERARCHY_POLICIES

Line 4499: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);

4495: INTO l_status_name
4496: FROM eng_change_statuses_vl ecs
4497: WHERE ecs.status_code = 0;
4498:
4499: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4500:
4501: ENGECOBO.GLOBAL_CHANGE_ID := p_change_id;
4502: ENGECOBO.GLOBAL_ORG_ID := eco_rec.organization_id;
4503:

Line 4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject .. ');

4502: ENGECOBO.GLOBAL_ORG_ID := eco_rec.organization_id;
4503:
4504: -- Fetch change subjects
4505: BEGIN
4506: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject .. ');
4507:
4508: l_header_subject_exists := 1;
4509:
4510: select sub1.pk1_value, sub1.pk2_value, sub2.pk3_value, sub2.entity_name

Line 4528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject 2.. ');

4524: END;
4525:
4526: IF (l_header_subject_exists = 1)
4527: THEN
4528: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject 2.. ');
4529: --
4530: -- Setting Pk1 Value
4531: IF (l_pk1_value IS NOT NULL)
4532: THEN

Line 4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject Status ' || l_invalid_subject);

4582: END;
4583: END IF;
4584: END IF;
4585:
4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject Status ' || l_invalid_subject);
4587:
4588: -- Changes for bug 3547805
4589: -- Assignee Name Processing
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee ..');

Line 4590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee ..');

4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject Status ' || l_invalid_subject);
4587:
4588: -- Changes for bug 3547805
4589: -- Assignee Name Processing
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee ..');
4591: l_party_id := eco_rec.assignee_id;
4592: l_assignee_name := NULL ;
4593: BEGIN
4594: -- if subject item is not null then process the role based assignee types

Line 4598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee Roles..');

4594: -- if subject item is not null then process the role based assignee types
4595: IF (l_pk1_value IS NOT NULL AND l_assignee_role_id IS NOT NULL AND l_default_assignee_type IS NOT NULL)
4596: THEN
4597: -- Process role based types
4598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee Roles..');
4599: IF (l_default_assignee_type = 'EGO_ITEM')
4600: THEN
4601: OPEN c_item_assignee(l_assignee_role_id , l_pk1_value , p_local_organization_id );
4602: FETCH c_item_assignee INTO l_party_id, l_assignee_name, l_party_type;

Line 4652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Population ECO Header Info.. ');

4648: l_assignee_name := null;
4649: END;
4650: -- End changes for bug 3547805
4651:
4652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Population ECO Header Info.. ');
4653: /* Popuating PL/SQL record for ECO Header */
4654: l_eco_rec.eco_name := eco_rec.change_notice;
4655: l_eco_rec.change_name := eco_rec.change_name; --Added for bug 9405365
4656: l_eco_rec.organization_code := p_local_organization_code;

Line 4709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');

4705: -- Fetch ECO Revisions
4706: i := 1;
4707: FOR rev IN c_eco_revision
4708: LOOP
4709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');
4710: l_eco_revision_tbl(i).eco_name := rev.change_notice;
4711: l_eco_revision_tbl(i).organization_code:= p_local_organization_code;
4712: l_eco_revision_tbl(i).revision := rev.revision;
4713: -- l_eco_revision_tbl(i).new_revision := rev.new_revision;

Line 5012: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Enable item in local org .. ' || l_transfer_item_enable);

5008:
5009: IF (l_ris.enable_item_in_local_org = 'Y')
5010: THEN
5011: l_transfer_item_enable := G_VAL_TRUE;
5012: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Enable item in local org .. ' || l_transfer_item_enable);
5013: END IF;
5014: l_status_master_controlled := Inventory_Status_Control_Level;
5015:
5016: OPEN c_revised_items_data;

Line 6263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists for propagating changes');

6259:
6260: l_orgs_Cnt := x_organizations_list.COUNT;
6261: IF (l_orgs_Cnt IN (0, 1))
6262: THEN
6263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists for propagating changes');
6264: x_return_status := FND_API.G_RET_STS_ERROR;
6265: END IF;
6266: END Get_Local_Orgs_List;
6267: