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

Line 62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Checking event(commonBill)='||p_event_name||', event_key='||p_event_key||', erecord_id='||l_erecord_id||', msg_cnt='||l_msg_count);

58: , p_event_name => p_event_name
59: , p_event_key => p_event_key
60: , x_erecord_id => l_erecord_id);
61:
62: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Checking event(commonBill)='||p_event_name||', event_key='||p_event_key||', erecord_id='||l_erecord_id||', msg_cnt='||l_msg_count);
63:
64: IF (NVL( l_erecord_id, -1) >0)
65: THEN
66: IF (p_event_status = 'SUCCESS')

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledging eRecord_id='||l_erecord_id||' with status='||l_trans_status);

73: -- Get message that will be send to SEND_ACKN :
74: FND_MESSAGE.SET_NAME('ENG', 'BOM_ERES_ACKN_BILL');
75: l_ackn_by := FND_MESSAGE.GET;
76:
77: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledging eRecord_id='||l_erecord_id||' with status='||l_trans_status);
78: QA_EDR_STANDARD.SEND_ACKN
79: ( p_api_version => 1.0
80: , p_init_msg_list => FND_API.G_TRUE
81: , x_return_status => l_return_status

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

88: , p_ackn_by => l_ackn_by
89: , p_ackn_note => p_event_name||', '||p_event_key
90: , p_autonomous_commit => FND_API.G_TRUE);
91:
92: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
93:
94: IF (l_return_status <> FND_API.G_TRUE)
95: THEN
96: RAISE SEND_ACKN_ERROR;

Line 99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');

95: THEN
96: RAISE SEND_ACKN_ERROR;
97: END IF;
98:
99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
100: ELSE
101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');
102: END IF;
103:

Line 101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');

97: END IF;
98:
99: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
100: ELSE
101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Acknowledgement.');
102: END IF;
103:
104: EXCEPTION
105: WHEN SEND_ACKN_ERROR THEN

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);

107: p_msg_index => 1,
108: p_data => l_msg_data,
109: p_encoded => FND_API.G_FALSE,
110: p_msg_index_out => l_dummy_cnt);
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
112:
113: WHEN OTHERS THEN
114: l_msg_data := 'ACKN Others Error='||SQLERRM;
115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
112:
113: WHEN OTHERS THEN
114: l_msg_data := 'ACKN Others Error='||SQLERRM;
115: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
116:
117:
118: END Event_Acknowledgement;
119: -- ERES change ends

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

188: l_erecord_id NUMBER;
189: -- ERES change ends
190: BEGIN
191: /* Print the list of parameters */
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));

Line 193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));

189: -- ERES change ends
190: BEGIN
191: /* Print the list of parameters */
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);

Line 194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);

190: BEGIN
191: /* Print the list of parameters */
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));

Line 195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));

191: /* Print the list of parameters */
192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));

Line 196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));

192: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);

193: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
201:

Line 198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));

194: FND_FILE.PUT_LINE( FND_FILE.LOG,'ORG_HIERARCHY='||org_hierarchy);
195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
201:
202: /* Make sure the right set of parameter are passed */

Line 199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));

195: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
201:
202: /* Make sure the right set of parameter are passed */
203: IF (scope = 2) AND (org_hierarchy IS NULL) THEN

Line 200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

196: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_FROM='||to_char(common_item_from));
197: FND_FILE.PUT_LINE( FND_FILE.LOG,'ALTERNATE='||alternate);
198: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ORG_TO='||to_char(common_org_to));
199: FND_FILE.PUT_LINE( FND_FILE.LOG,'COMMON_ITEM_TO='||to_char(common_item_to));
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
201:
202: /* Make sure the right set of parameter are passed */
203: IF (scope = 2) AND (org_hierarchy IS NULL) THEN
204: raise Hierarchy_not_specified ;

Line 300: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));

296: WHERE organization_id = current_org_id ;
297:
298: /*** Loop through the organization in the list of organizations ***/
299: FOR I in starting_org_counter..t_org_code_list.LAST LOOP
300: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing Organization : '||t_org_code_list(I));
301:
302: SELECT organization_code
303: INTO l_org_code_to
304: FROM ORG_ORGANIZATION_DEFINITIONS

Line 482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');

478:
479: --bug:5235742 Delete groups API will return 1 when one or more entities
480: --can not be deleted.
481: If ( ( RETCOD <> '0' ) AND ( RETCOD <> '1' ) ) Then
482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
484: failure_counter := failure_counter + 1 ;
485: ROLLBACK ;
486: to_proceed := 1;

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

479: --bug:5235742 Delete groups API will return 1 when one or more entities
480: --can not be deleted.
481: If ( ( RETCOD <> '0' ) AND ( RETCOD <> '1' ) ) Then
482: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted');
483: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
484: failure_counter := failure_counter + 1 ;
485: ROLLBACK ;
486: to_proceed := 1;
487: Else

Line 496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');

492: where DELETE_ENTITY_SEQUENCE_ID = delete_entity_id;
493:
494: If (delete_error_rec = 0) then
495: to_proceed := 2;
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
498: Else
499: to_proceed := 1;
500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');

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

493:
494: If (delete_error_rec = 0) then
495: to_proceed := 2;
496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
498: Else
499: to_proceed := 1;
500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
501: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;

Line 500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');

496: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' has been deleted succesfully');
497: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
498: Else
499: to_proceed := 1;
500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
501: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
502: failure_counter := failure_counter + 1 ;
503: End if;
504: End if;

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

497: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
498: Else
499: to_proceed := 1;
500: FND_FILE.PUT_LINE(FND_FILE.LOG,'Existing Common Bill For Item ' || l_assembly_item_name|| ' in organization ' || l_organization_code || ' could not be deleted because of delete constraints');
501: FND_FILE.PUT_LINE(FND_FILE.LOG,'') ;
502: failure_counter := failure_counter + 1 ;
503: End if;
504: End if;
505: END IF;

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');

544: security_group_id=>FND_PROFILE.Value('SECURITY_GROUP_ID')) ;
545:
546: /** Initialize the message list **/
547: ERROR_HANDLER.INITIALIZE ;
548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling BOM_BO_PUB.PROCESS_BOM');
549:
550: /** Call the BOM Business Object **/
551: BOM_BO_PUB.PROCESS_BOM
552: (

Line 582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully commoned for organization : '||t_org_code_list(I)) ;

578: , p_event_status => 'SUCCESS');
579: -- ERES change ends
580:
581: success_counter := success_counter + 1 ;
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Successfully commoned for organization : '||t_org_code_list(I)) ;
583: COMMIT ;
584: ELSE
585: -- ERES change begins
586: Event_Acknowledgement

Line 593: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;

589: , p_event_status => 'FAILURE');
590: -- ERES change ends
591:
592: failure_counter := failure_counter + 1 ;
593: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;
594: ROLLBACK ;
595: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
596: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
597: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 597: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

593: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commoning errored for organization : '||t_org_code_list(I)) ;
594: ROLLBACK ;
595: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
596: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
597: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
600: END LOOP ;
601: END IF ;

Line 598: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;

594: ROLLBACK ;
595: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
596: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
597: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
600: END LOOP ;
601: END IF ;
602: END IF;

Line 599: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;

595: ERROR_HANDLER.GET_MESSAGE_LIST(x_message_list=>l_error_tbl) ;
596: FOR K in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
597: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'entity_id : '||l_error_tbl(K).entity_id) ;
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'message_text : '||l_error_tbl(K).message_text) ;
600: END LOOP ;
601: END IF ;
602: END IF;
603: ELSE

Line 607: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

603: ELSE
604: FND_MESSAGE.SET_NAME('BOM','BOM_BILL_EXISTS');
605: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
606: msg := FND_MESSAGE.GET ;
607: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
608: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;
609: END IF ;
610: ELSE
611: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');

Line 608: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;

604: FND_MESSAGE.SET_NAME('BOM','BOM_BILL_EXISTS');
605: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
606: msg := FND_MESSAGE.GET ;
607: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
608: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill already exists for organization '||t_org_code_list(I)) ;
609: END IF ;
610: ELSE
611: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');
612: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);

Line 615: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

611: FND_MESSAGE.SET_NAME('BOM','BOM_INVALID_ASSEMBLY');
612: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);
613: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
614: msg := FND_MESSAGE.GET ;
615: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;
617: END IF ;
618: END LOOP ;
619:

Line 616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;

612: FND_MESSAGE.SET_TOKEN('ASSEMBLY_NAME',l_assy_item_name);
613: FND_MESSAGE.SET_TOKEN('ORG_CODE',t_org_code_list(I));
614: msg := FND_MESSAGE.GET ;
615: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
616: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Assembly item'||l_assy_item_name||'does not exists in organization'||t_org_code_list(I)) ;
617: END IF ;
618: END LOOP ;
619:
620: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');

Line 624: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

620: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
621: FND_MESSAGE.SET_TOKEN('ENTITY1','SUCCEDED');
622: FND_MESSAGE.SET_TOKEN('ENTITY2',success_counter);
623: msg := FND_MESSAGE.GET ;
624: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
625:
626: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
627: FND_MESSAGE.SET_TOKEN('ENTITY1','FAILED');
628: FND_MESSAGE.SET_TOKEN('ENTITY2',failure_counter);

Line 630: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

626: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_SUMMARY');
627: FND_MESSAGE.SET_TOKEN('ENTITY1','FAILED');
628: FND_MESSAGE.SET_TOKEN('ENTITY2',failure_counter);
629: msg := FND_MESSAGE.GET ;
630: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
631:
632: /*
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;

Line 633: FND_FILE.PUT_LINE(FND_FILE.LOG,'*SUMMARY***') ;

629: msg := FND_MESSAGE.GET ;
630: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
631:
632: /*
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
636:
637: */

Line 634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;

630: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
631:
632: /*
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
636:
637: */
638:

Line 635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;

631:
632: /*
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'*************SUMMARY***************') ;
634: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations successfully commoned : '||success_counter) ;
635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of organizations for which commoning failed : '||failure_counter) ;
636:
637: */
638:
639: IF (failure_counter > 0) THEN

Line 651: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

647: EXCEPTION
648: WHEN Hierarchy_not_specified THEN
649: FND_MESSAGE.SET_NAME('BOM','BOM_HIERARCHY_MISSING');
650: msg := FND_MESSAGE.GET ;
651: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
652: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;
653: RETCODE := 2;
654: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
655:

Line 652: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;

648: WHEN Hierarchy_not_specified THEN
649: FND_MESSAGE.SET_NAME('BOM','BOM_HIERARCHY_MISSING');
650: msg := FND_MESSAGE.GET ;
651: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
652: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Hierarchy Name must be specified') ;
653: RETCODE := 2;
654: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
655:
656: WHEN invalid_common_itemorg_to THEN

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

655:
656: WHEN invalid_common_itemorg_to THEN
657: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_ITEM_ORG_INVALID');
658: msg := FND_MESSAGE.GET ;
659: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
660: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;
661: RETCODE := 2;
662: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
663:

Line 660: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;

656: WHEN invalid_common_itemorg_to THEN
657: FND_MESSAGE.SET_NAME('BOM','BOM_COMMON_ITEM_ORG_INVALID');
658: msg := FND_MESSAGE.GET ;
659: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
660: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Either common item to or common org to is not specified') ;
661: RETCODE := 2;
662: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
663:
664: WHEN same_common_itemorg_to THEN

Line 667: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;

663:
664: WHEN same_common_itemorg_to THEN
665: FND_MESSAGE.SET_NAME('BOM','BOM_TO_ORG_ITEM_SAME');
666: msg := FND_MESSAGE.GET ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
668: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;
669: RETCODE := 2;
670: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
671:

Line 668: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;

664: WHEN same_common_itemorg_to THEN
665: FND_MESSAGE.SET_NAME('BOM','BOM_TO_ORG_ITEM_SAME');
666: msg := FND_MESSAGE.GET ;
667: FND_FILE.PUT_LINE(FND_FILE.LOG,msg) ;
668: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'For Single Organization Scope, both TO org and item cannot be same as From org and item') ;
669: RETCODE := 2;
670: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
671:
672: WHEN OTHERS THEN

Line 673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;

669: RETCODE := 2;
670: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
671:
672: WHEN OTHERS THEN
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;
674: RETCODE := 2;
675: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
676: END create_common_bills;
677:

Line 877: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

873: , x_Mesg_Token_Tbl => l_mesg_token_tbl
874: , p_Token_Tbl => l_token_table
875: );
876: fnd_message.set_name('BOM', 'BOM_EDIT_COMM_INVALID_EFF');
877: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
878: /*Error_Handler.Log_Error
879: (p_error_status => FND_API.G_RET_STS_ERROR
880: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
881: , p_error_scope => Error_Handler.G_SCOPE_RECORD