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 1920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');

1916: l_status_type NUMBER;
1917:
1918: BEGIN
1919:
1920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1921: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1924:

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

1917:
1918: BEGIN
1919:
1920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1921: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1924:
1925: /* Need the Organization Id to fetch the records */

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

1918: BEGIN
1919:
1920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1921: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1924:
1925: /* Need the Organization Id to fetch the records */
1926: SELECT MP.organization_id

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

1919:
1920: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting PROPAGATE_ECO');
1921: FND_FILE.PUT_LINE(FND_FILE.LOG,'CHANGE_NOTICE '|| p_change_notice);
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_NAME '|| p_org_hierarchy_name);
1923: FND_FILE.PUT_LINE(FND_FILE.LOG,'HIERARCHY_LEVEL '|| p_org_hierarchy_level);
1924:
1925: /* Need the Organization Id to fetch the records */
1926: SELECT MP.organization_id
1927: INTO l_org_hierarchy_level_id

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

1943:
1944:
1945: IF (l_org_code_list.COUNT = 0) THEN
1946:
1947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists under the Hierarchy Level '|| p_org_hierarchy_name||' and '||p_org_hierarchy_level);
1948:
1949: RETURN;
1950: END IF;
1951:

Line 1954: 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);

1950: END IF;
1951:
1952: IF (l_org_code_list.COUNT = 1) THEN
1953:
1954: 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);
1955:
1956: RETURN;
1957: END IF;
1958:

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

1955:
1956: RETURN;
1957: END IF;
1958:
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1962: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1963:

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

1956: RETURN;
1957: END IF;
1958:
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1962: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1963:
1964: FOR l_org_count in 1..l_org_code_list.COUNT

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

1957: END IF;
1958:
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1962: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1963:
1964: FOR l_org_count in 1..l_org_code_list.COUNT
1965: Loop

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

1958:
1959: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1960: FND_FILE.PUT_LINE(FND_FILE.LOG,'Organizations in Hierarchy ');
1961: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------');
1962: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1963:
1964: FOR l_org_count in 1..l_org_code_list.COUNT
1965: Loop
1966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));

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

1962: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Orgs in Hierarchy = '||l_org_code_list.COUNT);
1963:
1964: FOR l_org_count in 1..l_org_code_list.COUNT
1965: Loop
1966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));
1967: end loop;
1968:
1969: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1970:

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

1965: Loop
1966: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org : '||l_org_code_list(l_org_count));
1967: end loop;
1968:
1969: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1970:
1971: FOR l_org_count in 2..l_org_code_list.LAST
1972: LOOP /* Loop 1 */
1973:

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

1989:
1990: IF l_org_code IS NOT NULL /* Organization Check*/
1991: THEN
1992:
1993: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Organization '|| l_org_code);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1995:
1996:
1997: SELECT count(*)

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

1990: IF l_org_code IS NOT NULL /* Organization Check*/
1991: THEN
1992:
1993: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Organization '|| l_org_code);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1995:
1996:
1997: SELECT count(*)
1998: into temp_count

Line 2007: 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);

2003: -- Fetch ECO Masters
2004:
2005: IF temp_count > 0 THEN /* ECO Check */
2006:
2007: 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);
2008:
2009: ELSE
2010:
2011: FOR eco_rec IN c_eco_rec

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

2010:
2011: FOR eco_rec IN c_eco_rec
2012: LOOP /* Loop 2 */
2013:
2014: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Header ...');
2015:
2016: IF (eco_rec.change_order_type_id IS NOT NULL) THEN
2017:
2018: SELECT CHANGE_ORDER_TYPE

Line 2062: 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));

2058: FETCH c_user_name INTO l_requestor_name;
2059: CLOSE c_user_name;
2060: exception
2061: When No_Data_found then
2062: 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));
2063: l_requestor_name := NULL;
2064: end;
2065:
2066: /*

Line 2076: 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));

2072: WHERE organization_id = l_org_hierarchy_level_id
2073: AND employee_id = eco_rec.requestor_id;
2074: Exception
2075: When No_Data_found then
2076: 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: l_requestor_name := NULL;
2078: End;
2079: */
2080: ELSE

Line 2093: 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));

2089: FETCH c_user_name INTO l_assignee_name;
2090: CLOSE c_user_name;
2091: exception
2092: When No_Data_found then
2093: 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));
2094: l_assignee_name := NULL;
2095: end;
2096: ELSE
2097: l_assignee_name := NULL;

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

2105: FROM pa_projects_all
2106: WHERE project_id = eco_rec.PROJECT_ID;
2107: Exception
2108: When No_Data_found then
2109: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));
2110: l_Project_Number := NULL;
2111: End;
2112: ELSE
2113: l_Project_Number := NULL;

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

2120: FROM pa_tasks
2121: WHERE TASK_ID = eco_rec.TASK_ID;
2122: Exception
2123: When No_Data_found then
2124: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));
2125: l_Task_Number := NULL;
2126: End;
2127: ELSE
2128: l_Task_Number := NULL;

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

2209:
2210: FOR rev IN c_eco_revision
2211: LOOP /* Loop 3 */
2212:
2213: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');
2214:
2215: l_eco_revision_tbl(i).eco_name := rev.change_notice;
2216: l_eco_revision_tbl(i).organization_code:= l_org_code;
2217: l_eco_revision_tbl(i).revision := rev.revision;

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

2242: i := i + 1;
2243:
2244: END LOOP; /* End Loop 3 */
2245:
2246: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2247:
2248: -- Fetch revised items
2249:
2250: i := 1;

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

2251:
2252: FOR ri IN c_rev_items
2253: LOOP /* Loop 4 */
2254:
2255: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Items ...');
2256:
2257: BEGIN
2258:
2259: l_item_exits_in_org_flag := 1;

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

2289: l_use_up_item_name := NULL;
2290:
2291: END IF;
2292:
2293: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
2294:
2295: IF (l_item_exits_in_org_flag = 1) THEN
2296: l_revised_item_tbl(i).eco_name := ri.change_notice;
2297: l_revised_item_tbl(i).organization_code := l_org_code;

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

2381: i := i + 1;
2382:
2383: ELSE
2384:
2385: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Use_Up_Item_id = '||
2386: ri.use_up_item_id||' for Org '||l_org_code);
2387:
2388: END IF;
2389:

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

2388: END IF;
2389:
2390: ELSE
2391:
2392: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id = '||
2393: ri.revised_item_id||' for Org '||l_org_code);
2394:
2395: END IF;
2396:

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

2401:
2402: For rcd IN c_rev_comps_disable
2403: LOOP
2404:
2405: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components For Implemented Ecos having ACD type as Disable for Components...');
2406:
2407: BEGIN
2408: l_item_exits_in_org_flag := 1;
2409: SELECT msi.concatenated_segments,eri.new_item_revision

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

2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN
2488: old_operation_seq_num := NULL;
2489: old_effectivity_date := NULL;
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error in Disable After implementation for sql statement Number :' || to_char(St_Number));
2491: WHEN OTHERS THEN
2492: 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));
2493: END;
2494: l_rev_component_tbl(i).eco_name := rcd.change_notice;

Line 2492: 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));

2488: old_operation_seq_num := NULL;
2489: old_effectivity_date := NULL;
2490: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error in Disable After implementation for sql statement Number :' || to_char(St_Number));
2491: WHEN OTHERS THEN
2492: 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));
2493: END;
2494: l_rev_component_tbl(i).eco_name := rcd.change_notice;
2495: l_rev_component_tbl(i).organization_code:= l_org_code;
2496: l_rev_component_tbl(i).revised_item_name :=

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

2579: i := i + 1;
2580:
2581: ELSE
2582:
2583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rcd.component_item_id||' for Org '||l_org_code);
2584: END IF;
2585: ELSE
2586:
2587: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||rcd.revised_item_sequence_id||' for Org '||l_org_code);

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

2583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rcd.component_item_id||' for Org '||l_org_code);
2584: END IF;
2585: ELSE
2586:
2587: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||rcd.revised_item_sequence_id||' for Org '||l_org_code);
2588: END IF;
2589: END LOOP;
2590:
2591: -- Fetch revised components

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

2592:
2593: FOR rc IN c_rev_comps
2594: LOOP /* Loop 5 */
2595:
2596: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Revised Components ...');
2597:
2598: BEGIN
2599:
2600: l_item_exits_in_org_flag := 1;

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

2749: EXCEPTION
2750: WHEN NO_DATA_FOUND THEN
2751: old_operation_seq_num := NULL;
2752: old_effectivity_date := NULL;
2753: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error for sql statement Number :' || to_char(St_Number));
2754: WHEN OTHERS THEN
2755: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2756: END;
2757: ELSE

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

2751: old_operation_seq_num := NULL;
2752: old_effectivity_date := NULL;
2753: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found error for sql statement Number :' || to_char(St_Number));
2754: WHEN OTHERS THEN
2755: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql error in statement number: '|| to_char(St_Number) || ':' || TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 1, 100));
2756: END;
2757: ELSE
2758: old_operation_seq_num := NULL;
2759: old_effectivity_date := NULL;

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

2856: i := i + 1;
2857:
2858: ELSE
2859:
2860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_Item_id = '|| rc.component_item_id||' for Org '||l_org_code);
2861:
2862: END IF;
2863:
2864: ELSE

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

2862: END IF;
2863:
2864: ELSE
2865:
2866: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_seq_id = '||
2867: rc.revised_item_sequence_id||' for Org '||l_org_code);
2868: END IF;
2869:
2870: END LOOP; /* End Loop 5 */

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

2875:
2876: FOR sc IN c_sub_comps
2877: LOOP /* Loop 6 */
2878:
2879: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');
2880:
2881: BEGIN
2882:
2883: l_item_exits_in_org_flag := 1;

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

3002: i := i + 1;
3003:
3004: ELSE
3005:
3006: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Substitute_Component_Id = '|| sc.substitute_component_id||' for Org '||l_org_code);
3007:
3008: END IF;
3009:
3010: ELSE

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

3008: END IF;
3009:
3010: ELSE
3011:
3012: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '|| sc.component_sequence_id||' for Org '||l_org_code);
3013:
3014: END IF;
3015:
3016: ELSE

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

3014: END IF;
3015:
3016: ELSE
3017:
3018: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid revised_item_id for Component_Seq_Id = '|| sc.component_sequence_id||' for Org '||l_org_code);
3019:
3020: END IF;
3021:
3022: END LOOP; /* End Loop 6 */

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

3027:
3028: FOR rd IN c_ref_desgs
3029: LOOP /* Loop 7 */
3030:
3031: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');
3032: BEGIN
3033:
3034: l_item_exits_in_org_flag := 1;
3035:

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

3114: i:= i + 1;
3115:
3116: ELSE
3117:
3118: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invalid Component_seq_id = '||rd.component_sequence_id||' for Org '||l_org_code);
3119:
3120: END IF;
3121:
3122: ELSE

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

3120: END IF;
3121:
3122: ELSE
3123:
3124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid revised_item_id for Component_Seq_Id = '|| rd.component_sequence_id||' for Org '||l_org_code);
3125:
3126: END IF;
3127: END LOOP; /* End Loop 7 */
3128:

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

3126: END IF;
3127: END LOOP; /* End Loop 7 */
3128:
3129: IF l_check_invalid_objects = 1 THEN
3130: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3131:
3132: Eng_Globals.G_WHO_REC.org_id := l_org_id;
3133: Eng_Globals.G_WHO_REC.user_id := FND_PROFILE.value('USER_ID');
3134: Eng_Globals.G_WHO_REC.login_id := FND_PROFILE.value('LOGIN_ID');

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

3145: /* Initializing the Error Handler */
3146:
3147: Error_Handler.Initialize;
3148:
3149: FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling ECO Business Objects');
3150: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
3151: Eng_Eco_Pub.Process_Eco
3152: (
3153: p_api_version_number => 1.0

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

3179: ,p_output_dir => '/sqlcom/log/dom1151'
3180: ,p_debug_filename => 'ECO_BO_debug.log'
3181: );
3182: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT :=0; --resetting values
3183: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3184: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3185: --
3186: -- On return from the PUB API
3187: -- Perform all the error handler operations to verify that the

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

3180: ,p_debug_filename => 'ECO_BO_debug.log'
3181: );
3182: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT :=0; --resetting values
3183: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Business Object Processing Done');
3184: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
3185: --
3186: -- On return from the PUB API
3187: -- Perform all the error handler operations to verify that the
3188: -- error or warning are displayed and all the error table interface

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

3206: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3207: i:=0;
3208: FOR i IN 1..l_error_table.COUNT
3209: LOOP
3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3213: END LOOP;
3214:

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

3207: i:=0;
3208: FOR i IN 1..l_error_table.COUNT
3209: LOOP
3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3213: END LOOP;
3214:
3215: end if;

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

3208: FOR i IN 1..l_error_table.COUNT
3209: LOOP
3210: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_table(i).entity_id);
3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_table(i).entity_index);
3212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_table(i).message_text);
3213: END LOOP;
3214:
3215: end if;
3216:

Line 3219: 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');

3215: end if;
3216:
3217: ELSE
3218:
3219: 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');
3220:
3221: l_check_invalid_objects := 1;
3222:
3223: END IF;

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

3635:
3636: FOR sc IN c_plm_sub_comps
3637: LOOP /* Loop 6 */
3638:
3639: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Substitute Components ...');
3640: l_item_exits_in_org_flag := G_VAL_TRUE;
3641: OPEN c_get_item_details(sc.substitute_component_id, p_local_organization_id);
3642: FETCH c_get_item_details INTO l_substitute_component_name;
3643: IF c_get_item_details%NOTFOUND

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

3691: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3692: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3693: );
3694: END LOOP;
3695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Component Enabling Failed ..');
3696: l_item_error_table.delete;
3697: END IF;
3698: END IF;
3699: IF l_item_exits_in_org_flag = G_VAL_FALSE

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

3760: /* Fetch all revised reference designators on this structure of this revised item */
3761: FOR rd IN c_plm_ref_desgs
3762: LOOP /* Loop 7 */
3763:
3764: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Reference Designators ...');
3765: l_ref_designator_tbl(l_ref_designator_count).eco_name := rd.change_notice;
3766: l_ref_designator_tbl(l_ref_designator_count).organization_code := p_revised_item_rec.organization_code;
3767: l_ref_designator_tbl(l_ref_designator_count).revised_item_name := l_revised_item_name;
3768: l_ref_designator_tbl(l_ref_designator_count).start_effective_date := rc.effectivity_date;

Line 4281: FND_FILE.PUT_LINE(FND_FILE.LOG,

4277: FETCH c_user_name INTO l_requestor_name;
4278: CLOSE c_user_name;
4279: EXCEPTION
4280: WHEN NO_DATA_FOUND THEN
4281: FND_FILE.PUT_LINE(FND_FILE.LOG,
4282: 'No_Data_found for requestor id '
4283: || to_char( eco_rec.requestor_id)
4284: || ' in org ' || to_char(p_organization_id));
4285: l_requestor_name := NULL;

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

4296: FROM pa_projects_all
4297: WHERE project_id = eco_rec.PROJECT_ID;
4298: EXCEPTION
4299: WHEN NO_DATA_FOUND THEN
4300: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for project id ' || to_char( eco_rec.PROJECT_ID));
4301: l_Project_Number := NULL;
4302: END;
4303: ELSE
4304: l_Project_Number := NULL;

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

4312: FROM pa_tasks
4313: WHERE TASK_ID = eco_rec.TASK_ID;
4314: EXCEPTION
4315: WHEN NO_DATA_FOUND THEN
4316: FND_FILE.PUT_LINE(FND_FILE.LOG,'No_Data_found for task id ' || to_char( eco_rec.TASK_ID));
4317: l_Task_Number := NULL;
4318: END;
4319: ELSE
4320: l_Task_Number := NULL;

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

4336: l_task_number1 := NULL;
4337: END IF;
4338:
4339: /* check whether the local organization eco needs to be scheduled immediately */
4340: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing ECO Fetch status..' );
4341: BEGIN
4342: SELECT 1
4343: INTO l_sched_immediately
4344: FROM ENG_ORG_HIERARCHY_POLICIES

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

4370: INTO l_status_name
4371: FROM eng_change_statuses_vl ecs
4372: WHERE ecs.status_code = 0;
4373:
4374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Status = ' || l_status_name);
4375:
4376: ENGECOBO.GLOBAL_CHANGE_ID := p_change_id;
4377: ENGECOBO.GLOBAL_ORG_ID := eco_rec.organization_id;
4378:

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

4377: ENGECOBO.GLOBAL_ORG_ID := eco_rec.organization_id;
4378:
4379: -- Fetch change subjects
4380: BEGIN
4381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject .. ');
4382:
4383: l_header_subject_exists := 1;
4384:
4385: select sub1.pk1_value, sub1.pk2_value, sub2.pk3_value, sub2.entity_name

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

4399: END;
4400:
4401: IF (l_header_subject_exists = 1)
4402: THEN
4403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject 2.. ');
4404: --
4405: -- Setting Pk1 Value
4406: IF (l_pk1_value IS NOT NULL)
4407: THEN

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

4457: END;
4458: END IF;
4459: END IF;
4460:
4461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject Status ' || l_invalid_subject);
4462:
4463: -- Changes for bug 3547805
4464: -- Assignee Name Processing
4465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee ..');

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

4461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Subject Status ' || l_invalid_subject);
4462:
4463: -- Changes for bug 3547805
4464: -- Assignee Name Processing
4465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee ..');
4466: l_party_id := eco_rec.assignee_id;
4467: l_assignee_name := NULL ;
4468: BEGIN
4469: -- if subject item is not null then process the role based assignee types

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

4469: -- if subject item is not null then process the role based assignee types
4470: IF (l_pk1_value IS NOT NULL AND l_assignee_role_id IS NOT NULL AND l_default_assignee_type IS NOT NULL)
4471: THEN
4472: -- Process role based types
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Assignee Roles..');
4474: IF (l_default_assignee_type = 'EGO_ITEM')
4475: THEN
4476: OPEN c_item_assignee(l_assignee_role_id , l_pk1_value , p_local_organization_id );
4477: FETCH c_item_assignee INTO l_party_id, l_assignee_name, l_party_type;

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

4523: l_assignee_name := null;
4524: END;
4525: -- End changes for bug 3547805
4526:
4527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Population ECO Header Info.. ');
4528: /* Popuating PL/SQL record for ECO Header */
4529: l_eco_rec.eco_name := eco_rec.change_notice;
4530: l_eco_rec.organization_code := p_local_organization_code;
4531: l_eco_rec.change_type_code := l_change_type_code;

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

4579: -- Fetch ECO Revisions
4580: i := 1;
4581: FOR rev IN c_eco_revision
4582: LOOP
4583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO Revision ...');
4584: l_eco_revision_tbl(i).eco_name := rev.change_notice;
4585: l_eco_revision_tbl(i).organization_code:= p_local_organization_code;
4586: l_eco_revision_tbl(i).revision := rev.revision;
4587: -- l_eco_revision_tbl(i).new_revision := rev.new_revision;

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

4881:
4882: IF (l_ris.enable_item_in_local_org = 'Y')
4883: THEN
4884: l_transfer_item_enable := G_VAL_TRUE;
4885: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Enable item in local org .. ' || l_transfer_item_enable);
4886: END IF;
4887: l_status_master_controlled := Inventory_Status_Control_Level;
4888:
4889: OPEN c_revised_items_data;

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

5786:
5787: l_orgs_Cnt := x_organizations_list.COUNT;
5788: IF (l_orgs_Cnt IN (0, 1))
5789: THEN
5790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists for propagating changes');
5791: x_return_status := FND_API.G_RET_STS_ERROR;
5792: END IF;
5793: END Get_Local_Orgs_List;
5794: