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

Line 123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the ERES part for org_id='||p_organization_id||', change_notice='||p_change_notice);

119: BEGIN
120:
121: x_return_status := FND_API.G_FALSE;
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the ERES part for org_id='||p_organization_id||', change_notice='||p_change_notice);
124:
125: -- Get Parent Event record id :
126: -- The error is not trapped, so that the execution can carry on.
127: QA_EDR_STANDARD.GET_ERECORD_ID

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'change_id='||l_change_id||', parent_id='||l_parent_record_id);

140: FETCH Get_ECO_Details
141: INTO l_change_id;
142: CLOSE Get_ECO_Details;
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'change_id='||l_change_id||', parent_id='||l_parent_record_id);
145: IF (l_change_id IS NOT NULL)
146: THEN
147: -- First: Preparing child event #1
148:

Line 240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);

236: , p_ackn_by => l_ackn_by
237: , p_ackn_note => '(organization_id, change_notice)='||TO_CHAR(p_organization_id)||', '||p_change_notice||')'
238: , p_autonomous_commit => FND_API.G_FALSE);
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);
241: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
242: AND (x_msg_count > 0)
243: THEN
244: RAISE SEND_ACKN_ERROR;

Line 252: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, RAISE_ERES_EVENT_ERROR :');

248: END IF; -- (l_change_id IS NOT NULL)
249:
250: EXCEPTION
251: WHEN RAISE_ERES_EVENT_ERROR THEN
252: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, RAISE_ERES_EVENT_ERROR :');
253: -- Get the message and raise the procedure exception.
254: FND_MSG_PUB.Get(
255: p_msg_index => 1,
256: p_data => l_message,

Line 259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);

255: p_msg_index => 1,
256: p_data => l_message,
257: p_encoded => FND_API.G_FALSE,
258: p_msg_index_out => l_dummy_cnt);
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
260:
261: WHEN SEND_ACKN_ERROR THEN
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, SEND_ACKN_ERROR :');
263: -- Get the message and raise the procedure exception.

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, SEND_ACKN_ERROR :');

258: p_msg_index_out => l_dummy_cnt);
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
260:
261: WHEN SEND_ACKN_ERROR THEN
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, SEND_ACKN_ERROR :');
263: -- Get the message and raise the procedure exception.
264: FND_MSG_PUB.Get(
265: p_msg_index => 1,
266: p_data => l_message,

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);

265: p_msg_index => 1,
266: p_data => l_message,
267: p_encoded => FND_API.G_FALSE,
268: p_msg_index_out => l_dummy_cnt);
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
270:
271: WHEN OTHERS THEN
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, OTHERS :'||SQLERRM);
273:

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, OTHERS :'||SQLERRM);

268: p_msg_index_out => l_dummy_cnt);
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
270:
271: WHEN OTHERS THEN
272: FND_FILE.PUT_LINE(FND_FILE.LOG,'ECO Create event, OTHERS :'||SQLERRM);
273:
274: END Raise_ECO_Create_Event;
275: -- ERES change ends
276:

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete rev effective structures from list');

320: SAVEPOINT begin_match;
321:
322: -- Bug 4216428
323:
324: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete rev effective structures from list');
325: DELETE FROM bom_lists l
326: WHERE l.sequence_id = p_list_id
327: AND EXISTS (
328: SELECT NULL

Line 338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');

334: AND b.effectivity_control =4);
335: --
336: -- Bug 4106826
337: --
338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');
339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||
341: to_char(l_bom_lists_count));
342: -- end Bug 4106826

Line 340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||

336: -- Bug 4106826
337: --
338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');
339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||
341: to_char(l_bom_lists_count));
342: -- end Bug 4106826
343:
344: -- Removed NVL and added AND/OR condition on Alternate_bom_desigantor to improve performance

Line 462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||

458:
459: x_error_message := NULL;
460: COMMIT;
461: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||
463: to_char(l_bom_lists_count));
464:
465: EXCEPTION
466: WHEN others THEN

Line 532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||

528: --
529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.
530: --
531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||
533: to_char(l_bom_lists_count));
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (

Line 580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||

576: AND r.change_notice = p_eco
577: AND r.organization_id = p_organization);
578:
579: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||
581: to_char(l_bom_lists_count));
582:
583: --
584: -- Do not create revised items if:

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||

618: AND c.revised_item_sequence_id = r.revised_item_sequence_id
619: AND r.change_notice = p_eco
620: AND r.organization_id = p_organization);
621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||
623: to_char(l_bom_lists_count));
624:
625: DELETE FROM bom_lists bl
626: WHERE bl.sequence_id = p_list_id

Line 734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||

730: OR
731: ri_itm.effectivity_control = date_control)
732: );
733: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||
735: to_char(l_bom_lists_count));
736: --
737: -- Do not create revised items if:
738: --

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||

820:
821: x_error_message := NULL;
822: COMMIT;
823: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||
825: to_char(l_bom_lists_count));
826: EXCEPTION
827: WHEN others THEN
828: ROLLBACK TO begin_combo;

Line 1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||

1101:
1102: COMMIT;
1103: x_error_buffer := NULL;
1104: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||
1106: to_char(l_bom_lists_count));
1107: EXCEPTION
1108: WHEN l_subroutine_error THEN
1109: x_error_buffer := l_internal_error;

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||

1293: RAISE l_internal_error;
1294: END IF;
1295: x_error_message := NULL;
1296: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||
1298: to_char(l_bom_lists_count));
1299: EXCEPTION
1300: WHEN l_internal_error THEN
1301: x_error_message := l_subroutine_error_msg;

Line 2709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||

2705: --get lookup values
2706: l_component_item_name := Get_Item_Name(comp_delete.component_item_id, org_id);
2707: l_location_name := Get_Location_Name(comp_delete.supply_locator_id);
2708:
2709: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||
2710: ' on '||l_revised_item_name);
2711:
2712: l_comp_cnt := l_comp_cnt + 1;
2713:

Line 2937: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||

2933: --get lookup values
2934: l_component_item_name := Get_Item_Name(comp_replace.component_item_id, org_id);
2935: l_location_name := Get_Location_Name(comp_replace.supply_locator_id);
2936:
2937: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||
2938: ' on '||l_revised_item_name);
2939:
2940: l_comp_cnt := l_comp_cnt + 1;
2941:

Line 3208: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing update of ' ||l_component_item_name||

3204: l_component_item_name := Get_Item_Name(comp_change.component_item_id, org_id);
3205: l_location_name := Get_Location_Name(comp_change.supply_locator_id);
3206:
3207: IF (comp_change.acd_type = ecg_action_change) THEN
3208: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing update of ' ||l_component_item_name||
3209: ' on '||l_revised_item_name);
3210: ELSE --comp_change.acd_type = ecg_action_add
3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3212: ' to '||l_revised_item_name);

Line 3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||

3207: IF (comp_change.acd_type = ecg_action_change) THEN
3208: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing update of ' ||l_component_item_name||
3209: ' on '||l_revised_item_name);
3210: ELSE --comp_change.acd_type = ecg_action_add
3211: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3212: ' to '||l_revised_item_name);
3213: END IF;
3214:
3215: l_comp_cnt := l_comp_cnt + 1;

Line 3433: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||

3429: --get lookup values
3430: l_component_item_name := Get_Item_Name(comp_add.component_item_id, org_id);
3431: l_location_name := Get_Location_Name(comp_add.supply_locator_id);
3432:
3433: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3434: ' to '||l_revised_item_name);
3435:
3436: l_comp_cnt := l_comp_cnt + 1;
3437:

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

3588: -- Set Value for Caller Type
3589: BOM_GLOBALS.Set_Caller_Type(BOM_GLOBALS.G_MASS_CHANGE);
3590:
3591: --Now call the Business Object to process the ECOs
3592: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO');
3593: ENG_ECO_PUB.Process_Eco(p_api_version_number => 1.0
3594: , p_init_msg_list => FALSE
3595: , x_return_status => l_return_status
3596: , x_msg_count => l_msg_cnt

Line 3627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Info: profile EDR_ERES_ENABLED ='||l_eres_enabled||'.');

3623: END IF;
3624:
3625: -- ERES change begins :
3626: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Info: profile EDR_ERES_ENABLED ='||l_eres_enabled||'.');
3628: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3629: THEN
3630: Raise_ECO_Create_Event
3631: ( p_organization_id => org_id

Line 3792: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

3788: EXCEPTION
3789:
3790: WHEN others THEN
3791: error_message := 'Error in ENG_CHANGE_TEXT_UTIL.Sync_index';
3792: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3793: END;
3794:
3795: error_message := NULL;
3796:

Line 3801: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

3797: EXCEPTION
3798:
3799: WHEN list_error THEN
3800: error_message := list_error_msg;
3801: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3802:
3803: WHEN revision_error THEN
3804: ROLLBACK TO begin_mass_update;
3805: error_message := rev_error_msg;

Line 3806: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

3802:
3803: WHEN revision_error THEN
3804: ROLLBACK TO begin_mass_update;
3805: error_message := rev_error_msg;
3806: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3807:
3808: WHEN process_eco_error THEN
3809: ROLLBACK TO begin_mass_update;
3810: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);

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

3809: ROLLBACK TO begin_mass_update;
3810: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);
3811: i:=0;
3812: FOR i IN 1..l_error_tbl.COUNT LOOP
3813: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3816: END LOOP;
3817: error_message := 'Error processing ECO Business Object';

Line 3814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);

3810: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);
3811: i:=0;
3812: FOR i IN 1..l_error_tbl.COUNT LOOP
3813: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3816: END LOOP;
3817: error_message := 'Error processing ECO Business Object';
3818: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

Line 3815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);

3811: i:=0;
3812: FOR i IN 1..l_error_tbl.COUNT LOOP
3813: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3816: END LOOP;
3817: error_message := 'Error processing ECO Business Object';
3818: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3819:

Line 3818: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

3814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3816: END LOOP;
3817: error_message := 'Error processing ECO Business Object';
3818: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3819:
3820: WHEN others THEN
3821: error_message := X_Statement_Number||SUBSTRB(sqlerrm, 1, 150);
3822: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

Line 3822: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

3818: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3819:
3820: WHEN others THEN
3821: error_message := X_Statement_Number||SUBSTRB(sqlerrm, 1, 150);
3822: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3823: ROLLBACK TO begin_mass_update;
3824:
3825: END mass_update;
3826: