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 461: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2699: --get lookup values
2700: l_component_item_name := Get_Item_Name(comp_delete.component_item_id, org_id);
2701: l_location_name := Get_Location_Name(comp_delete.supply_locator_id);
2702:
2703: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||
2704: ' on '||l_revised_item_name);
2705:
2706: l_comp_cnt := l_comp_cnt + 1;
2707:

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

2927: --get lookup values
2928: l_component_item_name := Get_Item_Name(comp_replace.component_item_id, org_id);
2929: l_location_name := Get_Location_Name(comp_replace.supply_locator_id);
2930:
2931: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing disable of ' ||l_component_item_name||
2932: ' on '||l_revised_item_name);
2933:
2934: l_comp_cnt := l_comp_cnt + 1;
2935:

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

3198: l_component_item_name := Get_Item_Name(comp_change.component_item_id, org_id);
3199: l_location_name := Get_Location_Name(comp_change.supply_locator_id);
3200:
3201: IF (comp_change.acd_type = ecg_action_change) THEN
3202: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing update of ' ||l_component_item_name||
3203: ' on '||l_revised_item_name);
3204: ELSE --comp_change.acd_type = ecg_action_add
3205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3206: ' to '||l_revised_item_name);

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

3201: IF (comp_change.acd_type = ecg_action_change) THEN
3202: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing update of ' ||l_component_item_name||
3203: ' on '||l_revised_item_name);
3204: ELSE --comp_change.acd_type = ecg_action_add
3205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3206: ' to '||l_revised_item_name);
3207: END IF;
3208:
3209: l_comp_cnt := l_comp_cnt + 1;

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

3423: --get lookup values
3424: l_component_item_name := Get_Item_Name(comp_add.component_item_id, org_id);
3425: l_location_name := Get_Location_Name(comp_add.supply_locator_id);
3426:
3427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Preparing add of ' ||l_component_item_name||
3428: ' to '||l_revised_item_name);
3429:
3430: l_comp_cnt := l_comp_cnt + 1;
3431:

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

3582: -- Set Value for Caller Type
3583: BOM_GLOBALS.Set_Caller_Type(BOM_GLOBALS.G_MASS_CHANGE);
3584:
3585: --Now call the Business Object to process the ECOs
3586: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing ECO');
3587: ENG_ECO_PUB.Process_Eco(p_api_version_number => 1.0
3588: , p_init_msg_list => FALSE
3589: , x_return_status => l_return_status
3590: , x_msg_count => l_msg_cnt

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

3617: END IF;
3618:
3619: -- ERES change begins :
3620: l_eres_enabled := FND_PROFILE.VALUE('EDR_ERES_ENABLED');
3621: FND_FILE.PUT_LINE(FND_FILE.LOG,'Info: profile EDR_ERES_ENABLED ='||l_eres_enabled||'.');
3622: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3623: THEN
3624: Raise_ECO_Create_Event
3625: ( p_organization_id => org_id

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

3782: EXCEPTION
3783:
3784: WHEN others THEN
3785: error_message := 'Error in ENG_CHANGE_TEXT_UTIL.Sync_index';
3786: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3787: END;
3788:
3789: error_message := NULL;
3790:

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

3791: EXCEPTION
3792:
3793: WHEN list_error THEN
3794: error_message := list_error_msg;
3795: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3796:
3797: WHEN revision_error THEN
3798: ROLLBACK TO begin_mass_update;
3799: error_message := rev_error_msg;

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

3796:
3797: WHEN revision_error THEN
3798: ROLLBACK TO begin_mass_update;
3799: error_message := rev_error_msg;
3800: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3801:
3802: WHEN process_eco_error THEN
3803: ROLLBACK TO begin_mass_update;
3804: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);

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

3803: ROLLBACK TO begin_mass_update;
3804: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);
3805: i:=0;
3806: FOR i IN 1..l_error_tbl.COUNT LOOP
3807: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3809: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3810: END LOOP;
3811: error_message := 'Error processing ECO Business Object';

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

3804: Error_Handler.Get_Message_List( x_message_list => l_error_tbl);
3805: i:=0;
3806: FOR i IN 1..l_error_tbl.COUNT LOOP
3807: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3809: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3810: END LOOP;
3811: error_message := 'Error processing ECO Business Object';
3812: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

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

3805: i:=0;
3806: FOR i IN 1..l_error_tbl.COUNT LOOP
3807: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity Id: '||l_error_tbl(i).entity_id);
3808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3809: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3810: END LOOP;
3811: error_message := 'Error processing ECO Business Object';
3812: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3813:

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

3808: FND_FILE.PUT_LINE(FND_FILE.LOG,'Index: '||l_error_tbl(i).entity_index);
3809: FND_FILE.PUT_LINE(FND_FILE.LOG,'Mesg: '||l_error_tbl(i).message_text);
3810: END LOOP;
3811: error_message := 'Error processing ECO Business Object';
3812: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3813:
3814: WHEN others THEN
3815: error_message := X_Statement_Number||SUBSTRB(sqlerrm, 1, 150);
3816: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);

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

3812: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3813:
3814: WHEN others THEN
3815: error_message := X_Statement_Number||SUBSTRB(sqlerrm, 1, 150);
3816: FND_FILE.PUT_LINE(FND_FILE.LOG,error_message);
3817: ROLLBACK TO begin_mass_update;
3818:
3819: END mass_update;
3820: