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

Line 112: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'ENGEIMPB.pls - in method UNAPPROVED_COMPONENTS_EXISTS');

108: AND msi.organization_id = VAR_ORGANIZATION_ID
109: AND nvl(msi.approval_status,'A') <> 'A');
110: l_dummy number;
111: BEGIN
112: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'ENGEIMPB.pls - in method UNAPPROVED_COMPONENTS_EXISTS');
113: OPEN check_components;
114: FETCH check_components INTO l_dummy;
115: CLOSE check_components;
116: IF l_dummy = 1 THEN

Line 202: FND_FILE.NEW_LINE(FND_FILE.LOG);

198: FETCH c_check_phase INTO l_valid_phase;
199: IF c_check_phase%NOTFOUND
200: THEN
201: l_implement_header := 'F';
202: FND_FILE.NEW_LINE(FND_FILE.LOG);
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented.');
204: ELSE
205:
206: l_implement_header := 'T';

Line 203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented.');

199: IF c_check_phase%NOTFOUND
200: THEN
201: l_implement_header := 'F';
202: FND_FILE.NEW_LINE(FND_FILE.LOG);
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented.');
204: ELSE
205:
206: l_implement_header := 'T';
207: -- check if there are any pending mandatory tasks in the ECO

Line 221: FND_FILE.NEW_LINE(FND_FILE.LOG);

217:
218: IF(l_mandatory_task_count <> 0)
219: THEN
220: l_implement_header := 'F';
221: FND_FILE.NEW_LINE(FND_FILE.LOG);
222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented as '||
223: 'there is at least one mandatory task which must be completed/cancelled.');
224: END IF;
225: END IF;

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented as '||

218: IF(l_mandatory_task_count <> 0)
219: THEN
220: l_implement_header := 'F';
221: FND_FILE.NEW_LINE(FND_FILE.LOG);
222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The header of ECO '|| p_change_notice||' will not be implemented as '||
223: 'there is at least one mandatory task which must be completed/cancelled.');
224: END IF;
225: END IF;
226: CLOSE c_check_phase;

Line 231: FND_FILE.NEW_LINE(FND_FILE.LOG);

227: RETURN l_implement_header;
228: END IF;
229: EXCEPTION
230: WHEN OTHERS THEN
231: FND_FILE.NEW_LINE(FND_FILE.LOG);
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in check_header_impl_allowed .. ' ||SQLERRM);
233: --do not implement the header if validation errors out
234: CLOSE c_check_phase;
235: l_implement_header := 'F';

Line 232: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in check_header_impl_allowed .. ' ||SQLERRM);

228: END IF;
229: EXCEPTION
230: WHEN OTHERS THEN
231: FND_FILE.NEW_LINE(FND_FILE.LOG);
232: FND_FILE.PUT_LINE(FND_FILE.LOG,' Error in check_header_impl_allowed .. ' ||SQLERRM);
233: --do not implement the header if validation errors out
234: CLOSE c_check_phase;
235: l_implement_header := 'F';
236: RETURN l_implement_header;

Line 701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on User Defined Attribute Group with Id ' || l_current_attr_group_id);

697: AND attr_group_id = l_current_attr_group_id
698: AND data_level_id not in (43103,43104,43105); -- Bug 6439100 Supplier datalevels change policy not supported
699:
700: IF l_pending_changes_count > 0 THEN
701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on User Defined Attribute Group with Id ' || l_current_attr_group_id);
702: l_can_implement_status := 'NO';
703: EXIT;
704: END IF;
705: END IF;

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on GDSN Singlerow Attribute Group with Id ' || l_current_attr_group_id);

714: p_attr_group_id => l_current_attr_group_id,
715: x_can_implement_status => l_can_implement_status);
716:
717: IF l_can_implement_status = 'NO' THEN
718: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on GDSN Singlerow Attribute Group with Id ' || l_current_attr_group_id);
719: EXIT;
720: END IF;
721: END IF;
722:

Line 732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on GDSN Multirow Attribute Group with Id ' || l_current_attr_group_id);

728: AND attr_group_id = l_current_attr_group_id
729: AND implementation_date IS NULL;
730:
731: IF l_pending_changes_count > 0 THEN
732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on GDSN Multirow Attribute Group with Id ' || l_current_attr_group_id);
733: l_can_implement_status := 'NO';
734: EXIT;
735: END IF;
736: END IF;

Line 754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on New Revision creation for the item.' );

750: WHERE revised_item_sequence_id = p_change_line_id))
751: AND implementation_date IS NULL;
752:
753: IF l_pending_changes_count > 0 THEN
754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on New Revision creation for the item.' );
755: l_can_implement_status := 'NO';
756: EXIT;
757: END IF;
758: END IF;

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on AML Associations.');

764: WHERE change_line_id = p_change_line_id
765: AND implmentation_date IS NULL;
766:
767: IF l_pending_changes_count > 0 THEN
768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on AML Associations.');
769: l_can_implement_status := 'NO';
770: EXIT;
771: END IF;
772: END IF;

Line 781: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Related Document Changes.');

777: FROM eng_relationship_changes
778: WHERE entity_id = p_change_line_id;
779:
780: IF l_pending_changes_count > 0 THEN
781: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Related Document Changes.');
782: l_can_implement_status := 'NO';
783: EXIT;
784: END IF;
785: END IF;

Line 802: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Structure Changes with structure type id ' || l_current_attr_group_id);

798: WHERE change_id in (SELECT change_id FROM eng_revised_items
799: WHERE revised_item_sequence_id = p_change_line_id));
800:
801: IF l_pending_changes_count > 0 THEN
802: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Structure Changes with structure type id ' || l_current_attr_group_id);
803: l_can_implement_status := 'NO';
804: EXIT;
805: END IF;
806:

Line 819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Component Changes with structure type id ' || l_current_attr_group_id);

815: WHERE change_id in (SELECT change_id FROM eng_revised_items
816: WHERE revised_item_sequence_id = p_change_line_id));
817:
818: IF l_pending_changes_count > 0 THEN
819: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Component Changes with structure type id ' || l_current_attr_group_id);
820: l_can_implement_status := 'NO';
821: EXIT;
822: END IF;
823:

Line 839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Operations Changes with structure type id ' || l_current_attr_group_id);

835: WHERE change_id in (SELECT change_id FROM eng_revised_items
836: WHERE revised_item_sequence_id = p_change_line_id));
837:
838: IF l_pending_changes_count > 0 THEN
839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Operations Changes with structure type id ' || l_current_attr_group_id);
840: l_can_implement_status := 'NO';
841: EXIT;
842: END IF;
843:

Line 855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Attachment Changes with Category type id ' || l_current_attr_group_id);

851: WHERE revised_item_sequence_id = p_change_line_id
852: AND category_id = l_current_attr_group_id; -- ?
853:
854: IF l_pending_changes_count > 0 THEN
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Implement the Revised Item '|| l_concatenated_segments || ' because there is a change policy NOT_ALLOWED on Attachment Changes with Category type id ' || l_current_attr_group_id);
856: l_can_implement_status := 'NO';
857: EXIT;
858: END IF;
859: END IF;

Line 1047: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledgement for ev_name='||my_events.event_name||', key='||my_events.event_key||', erec_id='||my_events.erecord_id||', stat='||l_trans_status);

1043: ELSE
1044: l_trans_status := 'ERROR';
1045: END IF;
1046: l_erecord_id := my_events.erecord_id;
1047: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Acknowledgement for ev_name='||my_events.event_name||', key='||my_events.event_key||', erec_id='||my_events.erecord_id||', stat='||l_trans_status);
1048:
1049: IF l_erecord_id IS NOT NULL
1050: THEN
1051: -- In case of error, autonomousCommit = TRUE

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

1062: , p_ackn_by => l_ackn_by
1063: , p_ackn_note => my_events.event_name||', '||my_events.event_key
1064: , p_autonomous_commit => FND_API.G_TRUE);
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
1067: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
1068: AND (l_msg_count > 0)
1069: THEN
1070: RAISE SEND_ACKN_ERROR;

Line 1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);

1075: WHERE erecord_id = my_events.erecord_id
1076: AND parent_erecord_id = my_events.parent_erecord_id;
1077:
1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1080: END LOOP;
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1082:
1083: EXCEPTION

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

1077:
1078: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1079: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1080: END LOOP;
1081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1082:
1083: EXCEPTION
1084: WHEN SEND_ACKN_ERROR THEN
1085: FND_MSG_PUB.Get(

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

1086: p_msg_index => 1,
1087: p_data => l_msg_data,
1088: p_encoded => FND_API.G_FALSE,
1089: p_msg_index_out => l_dummy_cnt);
1090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1091:
1092: WHEN OTHERS THEN
1093: l_msg_data := 'ACKN Others Error='||SQLERRM;
1094: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

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

1090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1091:
1092: WHEN OTHERS THEN
1093: l_msg_data := 'ACKN Others Error='||SQLERRM;
1094: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
1095:
1096: END event_acknowledgement;
1097: -- ERES change ends
1098:

Line 1194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change .. ');

1190: l_new_lifecycle_phase VARCHAR2(240);
1191: l_object_name VARCHAR2(30):= 'EGO_ITEM';
1192:
1193: BEGIN
1194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change .. ');
1195: l_sql_stmt := ' SELECT eip.project_id, ppa.name '
1196: || 'FROM EGO_ITEM_PROJECTS eip, PA_PROJECTS_ALL ppa '
1197: || 'WHERE eip.project_id = ppa.project_id '
1198: || 'AND eip.INVENTORY_ITEM_ID = :1 '

Line 1228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for project '|| l_lifecycle_project_number || '.. ');

1224: || 'end; ';
1225: EXECUTE IMMEDIATE l_plsql_block USING
1226: IN l_lifecycle_project_id, IN l_lifecycle_project_number, IN p_new_lifecycle_phase_id, IN l_new_lifecycle_phase,
1227: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for project '|| l_lifecycle_project_number || '.. ');
1229:
1230: EXCEPTION
1231: WHEN NO_DATA_FOUND THEN
1232: l_sql_stmt := ' SELECT lifecycle_id '

Line 1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: No lifecycle associated to the item ');

1237: BEGIN
1238: EXECUTE IMMEDIATE l_sql_stmt INTO l_lifecycle_id USING p_inventory_item_id, p_organization_id;
1239: EXCEPTION
1240: WHEN NO_DATA_FOUND THEN
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: No lifecycle associated to the item ');
1242: l_return_status := 'U';
1243: END;
1244: IF (l_lifecycle_id IS NOT NULL)
1245: THEN

Line 1246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for item.. ');

1242: l_return_status := 'U';
1243: END;
1244: IF (l_lifecycle_id IS NOT NULL)
1245: THEN
1246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for item.. ');
1247:
1248: /*l_plsql_block := 'begin '
1249: || 'ego_lifecycle_user_pub.Sync_Phase_Change '
1250: || '( p_api_version => :1 '

Line 1285: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));

1281: OUT l_return_status, OUT l_error_code,OUT l_msg_count, OUT l_msg_data;
1282:
1283: FOR I IN 1..l_msg_count
1284: LOOP
1285: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
1286: END LOOP;
1287:
1288: END IF;
1289: END;

Line 1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: ' ||SQLERRM);

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294:
1295: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: ' ||SQLERRM);
1296: x_return_status := 'U';
1297:
1298: END CHANGE_ITEM_LIFECYCLE_PHASE;
1299:

Line 3565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in Implement Revised Item. After Getting Parent Id, parent_erecord_id='||l_parent_record_id||', msg_cnt='||l_msg_count);

3561: , p_event_key => TO_CHAR(item.change_id)
3562: , x_erecord_id => l_parent_record_id);
3563: END IF;
3564:
3565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in Implement Revised Item. After Getting Parent Id, parent_erecord_id='||l_parent_record_id||', msg_cnt='||l_msg_count);
3566: ELSE
3567: -- set the value to N in case it is NULL.
3568: l_eres_enabled := 'N';
3569: END IF;

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

3566: ELSE
3567: -- set the value to N in case it is NULL.
3568: l_eres_enabled := 'N';
3569: END IF;
3570: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Info: EDR_ERES_ENABLED='||l_eres_enabled);
3571:
3572: -- ERES change ends
3573:
3574: IF (Nvl(item.transfer_or_copy,'N') = 'T' OR Nvl(item.transfer_or_copy,'N') = 'C') -- Check for Transfer/Copy OR Revised Item Change

Line 3641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Preparing ERES. parent_erecord_id='||l_parent_record_id);

3637: -- ERES change begins
3638: -- Create child event Transfer or Copy ToManufacturing:
3639: IF (l_eres_enabled = 'Y')
3640: THEN
3641: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Preparing ERES. parent_erecord_id='||l_parent_record_id);
3642:
3643: l_event.param_name_1 := 'DEFERRED';
3644: l_event.param_value_1 := 'Y';
3645:

Line 3692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);

3688: l_event.param_value_4 := 'NOT_FOUND';
3689: l_temp_id := '-1';
3690: END IF;
3691:
3692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3695:
3696: IF (NVL(l_parent_record_id, -1) > 0)

Line 3693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);

3689: l_temp_id := '-1';
3690: END IF;
3691:
3692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3695:
3696: IF (NVL(l_parent_record_id, -1) > 0)
3697: THEN

Line 3694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);

3690: END IF;
3691:
3692: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3695:
3696: IF (NVL(l_parent_record_id, -1) > 0)
3697: THEN
3698: --additional parameters for the child event

Line 3789: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', ev_key='||l_event.event_key);

3785: , l_parent_record_id
3786: , l_event.event_name, l_event.event_key, l_event.erecord_id
3787: , l_event.event_status);
3788:
3789: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', ev_key='||l_event.event_key);
3790: ELSE
3791: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
3792: END IF;
3793: END IF; -- l_eres_enabled

Line 3791: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');

3787: , l_event.event_status);
3788:
3789: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', ev_key='||l_event.event_key);
3790: ELSE
3791: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
3792: END IF;
3793: END IF; -- l_eres_enabled
3794: -- ERES change ends
3795:

Line 3868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for transfer line Failed');

3864: , p_new_lifecycle_phase_id => item.new_lifecycle_state_id
3865: , x_return_status => l_lc_return_status);
3866: IF (l_lc_return_status <> 'S')
3867: THEN
3868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for transfer line Failed');
3869: RAISE abort_implementation;
3870: END IF;
3871: END IF;
3872:

Line 3897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing obsolete Item .. ');

3893: END IF;
3894:
3895: IF (item.transfer_or_copy = 'O') -- if the item is obsoleted
3896: THEN
3897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing obsolete Item .. ');
3898:
3899: l_max_scheduled_date := item.scheduled_date;
3900: l_implement_revised_item := 1;
3901: FOR li IN c_local_org_rev_items (item.change_id, item.revised_item_sequence_id)

Line 3905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This item cannot be obsoleted since revised items propagated to the local organizations have not been implemented');

3901: FOR li IN c_local_org_rev_items (item.change_id, item.revised_item_sequence_id)
3902: LOOP
3903: IF (li.implementation_date IS NULL )
3904: THEN
3905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This item cannot be obsoleted since revised items propagated to the local organizations have not been implemented');
3906: Raise abort_implementation;
3907: END IF;
3908: IF li.scheduled_date > l_max_scheduled_date THEN
3909: l_max_scheduled_date := li.scheduled_date;

Line 3933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for obsolete item line Failed');

3929: , x_return_status => l_lc_return_status);
3930:
3931: IF (l_lc_return_status <> 'S')
3932: THEN
3933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for obsolete item line Failed');
3934: RAISE abort_implementation;
3935: END IF;
3936: END IF;
3937:

Line 3953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item status to inactive Failed');

3949: , x_Error_tbl => l_Error_tbl );
3950:
3951: IF (l_inv_return_status <> 'S' )
3952: THEN
3953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item status to inactive Failed');
3954: Raise abort_implementation;
3955: END IF;
3956:
3957: IF (p_is_lifecycle_phase_change = 2 )

Line 3975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing phase change Item .. ');

3971: END IF;
3972:
3973: ELSIF item.transfer_or_copy = 'L' THEN --life cycle phase chnage
3974:
3975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing phase change Item .. ');
3976: IF (item.new_lifecycle_state_id IS NOT NULL AND item.new_lifecycle_state_id <> item.current_lifecycle_state_id )
3977: THEN
3978: CHANGE_ITEM_LIFECYCLE_PHASE (
3979: p_rev_item_seq_id => revised_item

Line 3987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for phase change line Failed');

3983: , p_new_lifecycle_phase_id => item.new_lifecycle_state_id
3984: , x_return_status => l_lc_return_status);
3985: IF (l_lc_return_status <> 'S')
3986: THEN
3987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for phase change line Failed');
3988: RAISE abort_implementation;
3989: END IF;
3990: END IF;
3991:

Line 4209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WARNING: A lower revision for this revised item

4205:
4206: warnings := warnings + 1;
4207: message_names(msg_qty) := 'ENG_REV_PENDING';
4208: -- Added for bug 12826978, to show the warning message in log
4209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WARNING: A lower revision for this revised item
4210: is pending on another ECO.');
4211: else
4212: message_names(msg_qty) := 'ENG_REV_IMPL_ORDER';
4213: If trial_mode = no then

Line 4426: FND_FILE.NEW_LINE(FND_FILE.LOG);

4422: BEGIN
4423:
4424: -- SAVEPOINT ITEM_CHG ;
4425:
4426: FND_FILE.NEW_LINE(FND_FILE.LOG);
4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4430:

Line 4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');

4423:
4424: -- SAVEPOINT ITEM_CHG ;
4425:
4426: FND_FILE.NEW_LINE(FND_FILE.LOG);
4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4430:
4431: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');

4424: -- SAVEPOINT ITEM_CHG ;
4425:
4426: FND_FILE.NEW_LINE(FND_FILE.LOG);
4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4430:
4431: l_return_status := FND_API.G_RET_STS_SUCCESS;
4432: plsql_block := 'BEGIN

Line 4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');

4425:
4426: FND_FILE.NEW_LINE(FND_FILE.LOG);
4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4430:
4431: l_return_status := FND_API.G_RET_STS_SUCCESS;
4432: plsql_block := 'BEGIN
4433: FND_MSG_PUB.initialize ;

Line 4450: FND_FILE.PUT_LINE(FND_FILE.LOG,'After: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes: Return Status=' || l_return_status);

4446: OUT l_return_status, -- x_return_status
4447: OUT l_msg_count, -- x_msg_count
4448: OUT l_msg_data; -- x_msg_data
4449:
4450: FND_FILE.PUT_LINE(FND_FILE.LOG,'After: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes: Return Status=' || l_return_status);
4451:
4452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4453: THEN
4454: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');

Line 4462: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');

4458:
4459: RAISE FND_API.G_EXC_ERROR;
4460: END IF;
4461:
4462: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4463:
4464: EXCEPTION
4465: WHEN PLSQL_COMPILE_ERROR THEN
4466: null;

Line 4470: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');

4466: null;
4467:
4468: WHEN FND_API.G_EXC_ERROR THEN
4469:
4470: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4471: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4472: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4473:
4474: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

4467:
4468: WHEN FND_API.G_EXC_ERROR THEN
4469:
4470: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4471: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4472: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4473:
4474: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4475:

Line 4476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message Number : '|| I );

4472: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4473:
4474: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4475:
4476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message Number : '|| I );
4477: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
4478:
4479: IF msg_qty < max_messages
4480: then

Line 4477: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

4473:
4474: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4475:
4476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message Number : '|| I );
4477: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
4478:
4479: IF msg_qty < max_messages
4480: then
4481: msg_qty := msg_qty + 1;

Line 4495: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');

4491:
4492: END LOOP;
4493:
4494:
4495: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4496:
4497: IF trial_mode = no then
4498: Raise abort_implementation;
4499: END IF;

Line 4504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));

4500:
4501:
4502:
4503: WHEN OTHERS THEN
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4505:
4506: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4507: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4508: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;

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

4502:
4503: WHEN OTHERS THEN
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4505:
4506: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4507: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4508: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4509:
4510:

Line 4507: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');

4503: WHEN OTHERS THEN
4504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4505:
4506: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4507: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4508: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4509:
4510:
4511: IF msg_qty < max_messages

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

4519: value2(msg_qty) := null;
4520: translate2(msg_qty) := 0;
4521: END IF;
4522:
4523: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4524:
4525:
4526: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4527:

Line 4526: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');

4522:
4523: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4524:
4525:
4526: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4527:
4528: IF trial_mode = no then
4529: Raise abort_implementation;
4530: END IF;

Line 4911: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WARNING: There exists a pending unimplemented

4907:
4908: warnings := warnings + 1;
4909: message_names(msg_qty) := 'ENG_RTG_REV_PENDING';
4910: -- Added for bug 12826978, to show the warning message in log
4911: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WARNING: There exists a pending unimplemented
4912: ECO having the same revised item and its routing revision is less than the new
4913: revision.');
4914:
4915: else

Line 5001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in mtl_rtg_item_revisions... bERES_Flag_for_Routing=TRUE');

4997: -- ERES flag to be set for triggering Routing Event:
4998: bERES_Flag_for_Routing := TRUE;
4999: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing revision is being updated by revised item
5000: l_WIP_Flag_for_Routing := 'Y';
5001: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in mtl_rtg_item_revisions... bERES_Flag_for_Routing=TRUE');
5002: END IF;
5003: -- ERES changes end.
5004:
5005: END IF; -- end of nlssort(current_routing_revision)

Line 5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in bom_operational_routings ... bERES_Flag_for_Routing=TRUE');

5157: -- ERES flag to be set for triggering Routing Event:
5158: bERES_Flag_for_Routing := TRUE;
5159: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing header is being updated by revised item
5160: l_WIP_Flag_for_Routing := 'Y';
5161: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in bom_operational_routings ... bERES_Flag_for_Routing=TRUE');
5162: END IF;
5163: -- ERES changes end.
5164: END IF;
5165: --end of bugfix 3234628

Line 6011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in chng_operation_rows loop... bERES_Flag_for_Routing=TRUE');

6007: -- ERES flag to be set for triggering Routing Event:
6008: bERES_Flag_for_Routing := TRUE;
6009: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing details is being updated by revised item
6010: l_WIP_Flag_for_Routing := 'Y';
6011: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in chng_operation_rows loop... bERES_Flag_for_Routing=TRUE');
6012: -- ERES changes end.
6013:
6014: END LOOP;
6015:

Line 7105: FND_FILE.put_line(FND_FILE.LOG, l_message);

7101: FND_MESSAGE.Set_Token('SUBSTITUTE_ITEM_NAME',sub_component.item_number) ;
7102: FND_MESSAGE.Set_Token('REVISED_COMPONENT_NAME',component.item_number) ;
7103: FND_MSG_PUB.Add;
7104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => l_error_msg_count , p_data => l_message);
7105: FND_FILE.put_line(FND_FILE.LOG, l_message);
7106: If trial_mode = no then
7107: Close check_existing_substitutes;
7108: Raise abort_implementation;
7109: end if;

Line 7614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in component loop... bERES_Flag_for_BOM=TRUE');

7610: end if;
7611:
7612: -- ERES changes begin : bug 3741444
7613: bERES_Flag_for_BOM := TRUE;
7614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in component loop... bERES_Flag_for_BOM=TRUE');
7615: -- ERES changes end.
7616:
7617: -- Bug 4584490: Changes for Bom Business Events
7618: -- l_BOMEvents_Comps_ACD:

Line 7777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', bill='||item.bill_sequence_id);

7773: , l_parent_record_id
7774: , l_event.event_name, l_event.event_key, l_event.erecord_id
7775: , l_event.event_status);
7776:
7777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', bill='||item.bill_sequence_id);
7778: ELSE
7779: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
7780: END IF;
7781: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)

Line 7779: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');

7775: , l_event.event_status);
7776:
7777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', bill='||item.bill_sequence_id);
7778: ELSE
7779: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
7780: END IF;
7781: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)
7782:
7783: ELSE

Line 7784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_BOM=FALSE, then, NO ERES event for BOM .');

7780: END IF;
7781: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)
7782:
7783: ELSE
7784: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_BOM=FALSE, then, NO ERES event for BOM .');
7785: END IF; -- SQL%ROWCOUNT > 0
7786: END IF; -- l_eres_enabled
7787: -- ERES change ends
7788:

Line 7912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', routing='||item.routing_sequence_id);

7908: , l_parent_record_id
7909: , l_event.event_name, l_event.event_key, l_event.erecord_id
7910: , l_event.event_status);
7911:
7912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', routing='||item.routing_sequence_id);
7913: ELSE
7914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
7915: END IF;
7916:

Line 7914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');

7910: , l_event.event_status);
7911:
7912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After event='||l_child_event_name||', eRecord_id='||l_event.erecord_id||', status='||l_event.event_status||', routing='||item.routing_sequence_id);
7913: ELSE
7914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
7915: END IF;
7916:
7917: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');

Line 7918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');

7914: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No eRecord generated for '||l_event.event_name||'. This is normal. Please check your rules or other setups');
7915: END IF;
7916:
7917: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');
7919:
7920: ELSE
7921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_Routing=FALSE, then, NO ERES event for Routing.');
7922: END IF; -- SQL%ROWCOUNT > 0

Line 7921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_Routing=FALSE, then, NO ERES event for Routing.');

7917: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');
7919:
7920: ELSE
7921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_Routing=FALSE, then, NO ERES event for Routing.');
7922: END IF; -- SQL%ROWCOUNT > 0
7923: END IF; -- l_eres_enabled
7924: -- ERES change ends
7925:

Line 8112: FND_FILE.PUT_NAMES('CP.impECO.wf.log',

8108: -- New code: end
8109:
8110: -- Fix for bug: 3463308
8111: /* does not work for some reason, but do not delete
8112: FND_FILE.PUT_NAMES('CP.impECO.wf.log',
8113: 'CP.impECO.wf.out',
8114: '/appslog/bis_top/utl/plm115dt/log'
8115: );
8116: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');

Line 8116: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');

8112: FND_FILE.PUT_NAMES('CP.impECO.wf.log',
8113: 'CP.impECO.wf.out',
8114: '/appslog/bis_top/utl/plm115dt/log'
8115: );
8116: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');
8117: FND_FILE.PUT_LINE(fnd_file.log, ' item.change_id = ' || item.change_id);
8118: */
8119: -- using dynamic sql to launch status_change workflow API for implement phase
8120: BEGIN

Line 8117: FND_FILE.PUT_LINE(fnd_file.log, ' item.change_id = ' || item.change_id);

8113: 'CP.impECO.wf.out',
8114: '/appslog/bis_top/utl/plm115dt/log'
8115: );
8116: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');
8117: FND_FILE.PUT_LINE(fnd_file.log, ' item.change_id = ' || item.change_id);
8118: */
8119: -- using dynamic sql to launch status_change workflow API for implement phase
8120: BEGIN
8121: -- Log action for promotion to implement phase

Line 8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');

8246: WHEN OTHERS THEN
8247: null;
8248: END;
8249: /* does not work for some reason, but do not delete
8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );

Line 8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);

8247: null;
8248: END;
8249: /* does not work for some reason, but do not delete
8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
8255: FND_FILE.CLOSE;

Line 8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );

8248: END;
8249: /* does not work for some reason, but do not delete
8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
8255: FND_FILE.CLOSE;
8256: */

Line 8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );

8249: /* does not work for some reason, but do not delete
8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
8255: FND_FILE.CLOSE;
8256: */
8257: END IF;

Line 8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );

8250: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
8255: FND_FILE.CLOSE;
8256: */
8257: END IF;
8258: end if;

Line 8255: FND_FILE.CLOSE;

8251: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
8252: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
8253: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
8254: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
8255: FND_FILE.CLOSE;
8256: */
8257: END IF;
8258: end if;
8259: Close check_for_unimp_items;

Line 8868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);

8864: p_data => l_message,
8865: p_encoded => FND_API.G_FALSE,
8866: p_msg_index_out => l_dummy_cnt);
8867:
8868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);
8870: event_acknowledgement('FAILURE');
8871:
8872: IF (msg_qty < max_messages)

Line 8869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);

8865: p_encoded => FND_API.G_FALSE,
8866: p_msg_index_out => l_dummy_cnt);
8867:
8868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);
8870: event_acknowledgement('FAILURE');
8871:
8872: IF (msg_qty < max_messages)
8873: THEN

Line 8896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Others Error: '||SQLERRM);

8892: -- ERES change ends
8893:
8894: When others then
8895: -- ERES change begins
8896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Others Error: '||SQLERRM);
8897: event_acknowledgement('FAILURE');
8898: -- ERES change ends
8899:
8900: -- Added for bug 4150069

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

9308:
9309: IF l_return_status = 'E' THEN
9310: l_message_name := 'ENG_ATTACHMENT_IMP_ERROR';
9311: l_message_desc := 'Attachment Changes implementation failed';
9312: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
9313: END IF;
9314:
9315: EXCEPTION
9316: WHEN OTHERS THEN

Line 9317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment Changes Implementation Failed'||SQLERRM);

9313: END IF;
9314:
9315: EXCEPTION
9316: WHEN OTHERS THEN
9317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment Changes Implementation Failed'||SQLERRM);
9318: l_message_name := 'ENG_ATTACHMENT_IMP_ERROR';
9319: l_message_desc := 'Attachment Changes implementation failed';
9320: goto error_block;
9321: END;

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

9341:
9342: IF l_return_status = 'E' THEN
9343: l_message_name := 'ENG_RELATED_ENTITY_IMP_ERROR';
9344: l_message_desc := 'Related Entity Changes implementation failed';
9345: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
9346: END IF;
9347: END IF;
9348: EXCEPTION
9349: -- Don't throw an exception when package not found.

Line 9353: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Related Entity Changes Implementation Failed'||SQLERRM);

9349: -- Don't throw an exception when package not found.
9350: WHEN PLSQL_COMPILE_ERROR THEN
9351: null;
9352: WHEN OTHERS THEN
9353: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Related Entity Changes Implementation Failed'||SQLERRM);
9354: l_message_name := 'ENG_RELATED_ENTITY_IMP_ERROR';
9355: l_message_desc := 'Related Entity Changes implementation failed';
9356: goto error_block;
9357: END;

Line 9375: FND_FILE.NEW_LINE(FND_FILE.LOG);

9371: translate2(msg_qty) := 0;
9372: message_names(msg_qty) := l_message_name;
9373: FOR I IN 1..l_msg_count
9374: LOOP
9375: FND_FILE.NEW_LINE(FND_FILE.LOG);
9376: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9377: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9378:
9379: END LOOP;

Line 9376: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);

9372: message_names(msg_qty) := l_message_name;
9373: FOR I IN 1..l_msg_count
9374: LOOP
9375: FND_FILE.NEW_LINE(FND_FILE.LOG);
9376: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9377: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9378:
9379: END LOOP;
9380: ELSE

Line 9377: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));

9373: FOR I IN 1..l_msg_count
9374: LOOP
9375: FND_FILE.NEW_LINE(FND_FILE.LOG);
9376: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9377: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9378:
9379: END LOOP;
9380: ELSE
9381:

Line 9561: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure Start *') ;

9557: l_bill_sequence_id NUMBER := 0;
9558: common_bom_is_running EXCEPTION;
9559:
9560: BEGIN
9561: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure Start *********') ;
9562: IF FND_API.To_Boolean(p_autonomous_commit) THEN
9563: SELECT B.BILL_SEQUENCE_ID INTO l_bill_sequence_id
9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R
9565: WHERE R.REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id

Line 9571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Revised Item Sequence Id: ' || p_revised_item_sequence_id);

9567: AND R.ORGANIZATION_ID = B.ORGANIZATION_ID
9568: AND NVL(R.ALTERNATE_BOM_DESIGNATOR,' ') = NVL(B.ALTERNATE_BOM_DESIGNATOR,' ')
9569: AND B.BILL_SEQUENCE_ID (+) = R.BILL_SEQUENCE_ID;
9570:
9571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Revised Item Sequence Id: ' || p_revised_item_sequence_id);
9572: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill Sequence Id of the Revised Item: ' || l_bill_sequence_id);
9573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
9574:
9575: update BOM_BILL_OF_MATERIALS bbm

Line 9572: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill Sequence Id of the Revised Item: ' || l_bill_sequence_id);

9568: AND NVL(R.ALTERNATE_BOM_DESIGNATOR,' ') = NVL(B.ALTERNATE_BOM_DESIGNATOR,' ')
9569: AND B.BILL_SEQUENCE_ID (+) = R.BILL_SEQUENCE_ID;
9570:
9571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Revised Item Sequence Id: ' || p_revised_item_sequence_id);
9572: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill Sequence Id of the Revised Item: ' || l_bill_sequence_id);
9573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
9574:
9575: update BOM_BILL_OF_MATERIALS bbm
9576: set bbm.REQUEST_ID = P_ECOIMPL_IS_RUNNING

Line 9573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);

9569: AND B.BILL_SEQUENCE_ID (+) = R.BILL_SEQUENCE_ID;
9570:
9571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Revised Item Sequence Id: ' || p_revised_item_sequence_id);
9572: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill Sequence Id of the Revised Item: ' || l_bill_sequence_id);
9573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
9574:
9575: update BOM_BILL_OF_MATERIALS bbm
9576: set bbm.REQUEST_ID = P_ECOIMPL_IS_RUNNING
9577: WHERE nvl(bbm.REQUEST_ID, 0) <> P_COMMONBOM_IS_RUNNING

Line 9584: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Successfully Stamped with '||P_ECOIMPL_IS_RUNNING||' on bom row');

9580: then
9581: raise common_bom_is_running;
9582: else
9583: COMMIT; -- Commiting the autonomous transaction in case of successfull lock on the row.
9584: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Successfully Stamped with '||P_ECOIMPL_IS_RUNNING||' on bom row');
9585: end if;
9586: END IF;
9587: x_return_status := 0; -- Success
9588: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');

Line 9588: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure End *');

9584: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Successfully Stamped with '||P_ECOIMPL_IS_RUNNING||' on bom row');
9585: end if;
9586: END IF;
9587: x_return_status := 0; -- Success
9588: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9589:
9590: EXCEPTION
9591: WHEN common_bom_is_running THEN
9592: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ERROR while Implementing Revised Item Sequence Id: ' || p_revised_item_sequence_id );

Line 9592: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ERROR while Implementing Revised Item Sequence Id: ' || p_revised_item_sequence_id );

9588: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9589:
9590: EXCEPTION
9591: WHEN common_bom_is_running THEN
9592: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ERROR while Implementing Revised Item Sequence Id: ' || p_revised_item_sequence_id );
9593: FND_MESSAGE.SET_NAME('ENG','ENG_COMMONBOM_INPROGRESS');
9594: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET) ;
9595: x_return_status := 1; -- Error
9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');

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

9590: EXCEPTION
9591: WHEN common_bom_is_running THEN
9592: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ERROR while Implementing Revised Item Sequence Id: ' || p_revised_item_sequence_id );
9593: FND_MESSAGE.SET_NAME('ENG','ENG_COMMONBOM_INPROGRESS');
9594: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET) ;
9595: x_return_status := 1; -- Error
9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9597: ROLLBACK; -- Rolling back the autonomous transacation in case of exception.
9598: WHEN OTHERS THEN

Line 9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure End *');

9592: FND_FILE.PUT_LINE( FND_FILE.LOG, 'ERROR while Implementing Revised Item Sequence Id: ' || p_revised_item_sequence_id );
9593: FND_MESSAGE.SET_NAME('ENG','ENG_COMMONBOM_INPROGRESS');
9594: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET) ;
9595: x_return_status := 1; -- Error
9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9597: ROLLBACK; -- Rolling back the autonomous transacation in case of exception.
9598: WHEN OTHERS THEN
9599: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Not stamping with '||P_ECOIMPL_IS_RUNNING||' as Exception occurred in Update_BSB_Request_Id_Column procedure') ;
9600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;

Line 9599: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Not stamping with '||P_ECOIMPL_IS_RUNNING||' as Exception occurred in Update_BSB_Request_Id_Column procedure') ;

9595: x_return_status := 1; -- Error
9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9597: ROLLBACK; -- Rolling back the autonomous transacation in case of exception.
9598: WHEN OTHERS THEN
9599: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Not stamping with '||P_ECOIMPL_IS_RUNNING||' as Exception occurred in Update_BSB_Request_Id_Column procedure') ;
9600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
9601: x_return_status := 0;
9602: -- Deliberately setting it to success(0) in case of unknown exception because,when we cannot acquire a lock, we don't want the ECO process to end here itself,
9603: --and want it proceed and provide its own error logging

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

9596: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9597: ROLLBACK; -- Rolling back the autonomous transacation in case of exception.
9598: WHEN OTHERS THEN
9599: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Not stamping with '||P_ECOIMPL_IS_RUNNING||' as Exception occurred in Update_BSB_Request_Id_Column procedure') ;
9600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
9601: x_return_status := 0;
9602: -- Deliberately setting it to success(0) in case of unknown exception because,when we cannot acquire a lock, we don't want the ECO process to end here itself,
9603: --and want it proceed and provide its own error logging
9604: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');

Line 9604: FND_FILE.PUT_LINE( FND_FILE.LOG, '* Update_BSB_Request_Id_Column procedure End *');

9600: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Others '||SQLCODE || ':'||SQLERRM) ;
9601: x_return_status := 0;
9602: -- Deliberately setting it to success(0) in case of unknown exception because,when we cannot acquire a lock, we don't want the ECO process to end here itself,
9603: --and want it proceed and provide its own error logging
9604: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure End *********');
9605: ROLLBACK; -- Rolling back the autonomous transaction in case of exception.
9606:
9607: END Update_BSB_Request_Id_Column;
9608: