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 629: 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);

625: AND attr_group_id = l_current_attr_group_id
626: AND data_level_id not in (43103,43104,43105); -- Bug 6439100 Supplier datalevels change policy not supported
627:
628: IF l_pending_changes_count > 0 THEN
629: 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);
630: l_can_implement_status := 'NO';
631: EXIT;
632: END IF;
633: END IF;

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

642: p_attr_group_id => l_current_attr_group_id,
643: x_can_implement_status => l_can_implement_status);
644:
645: IF l_can_implement_status = 'NO' THEN
646: 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);
647: EXIT;
648: END IF;
649: END IF;
650:

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

656: AND attr_group_id = l_current_attr_group_id
657: AND implementation_date IS NULL;
658:
659: IF l_pending_changes_count > 0 THEN
660: 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);
661: l_can_implement_status := 'NO';
662: EXIT;
663: END IF;
664: END IF;

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

678: WHERE revised_item_sequence_id = p_change_line_id))
679: AND implementation_date IS NULL;
680:
681: IF l_pending_changes_count > 0 THEN
682: 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.' );
683: l_can_implement_status := 'NO';
684: EXIT;
685: END IF;
686: END IF;

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

692: WHERE change_line_id = p_change_line_id
693: AND implmentation_date IS NULL;
694:
695: IF l_pending_changes_count > 0 THEN
696: 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.');
697: l_can_implement_status := 'NO';
698: EXIT;
699: END IF;
700: END IF;

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

705: FROM eng_relationship_changes
706: WHERE entity_id = p_change_line_id;
707:
708: IF l_pending_changes_count > 0 THEN
709: 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.');
710: l_can_implement_status := 'NO';
711: EXIT;
712: END IF;
713: END IF;

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

726: WHERE change_id in (SELECT change_id FROM eng_revised_items
727: WHERE revised_item_sequence_id = p_change_line_id));
728:
729: IF l_pending_changes_count > 0 THEN
730: 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);
731: l_can_implement_status := 'NO';
732: EXIT;
733: END IF;
734:

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

743: WHERE change_id in (SELECT change_id FROM eng_revised_items
744: WHERE revised_item_sequence_id = p_change_line_id));
745:
746: IF l_pending_changes_count > 0 THEN
747: 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);
748: l_can_implement_status := 'NO';
749: EXIT;
750: END IF;
751:

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

763: WHERE change_id in (SELECT change_id FROM eng_revised_items
764: WHERE revised_item_sequence_id = p_change_line_id));
765:
766: IF l_pending_changes_count > 0 THEN
767: 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);
768: l_can_implement_status := 'NO';
769: EXIT;
770: END IF;
771:

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

779: WHERE revised_item_sequence_id = p_change_line_id
780: AND category_id = l_current_attr_group_id; -- ?
781:
782: IF l_pending_changes_count > 0 THEN
783: 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);
784: l_can_implement_status := 'NO';
785: EXIT;
786: END IF;
787: END IF;

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

971: ELSE
972: l_trans_status := 'ERROR';
973: END IF;
974: l_erecord_id := my_events.erecord_id;
975: 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);
976:
977: IF l_erecord_id IS NOT NULL
978: THEN
979: -- In case of error, autonomousCommit = TRUE

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

990: , p_ackn_by => l_ackn_by
991: , p_ackn_note => my_events.event_name||', '||my_events.event_key
992: , p_autonomous_commit => FND_API.G_TRUE);
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
995: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
996: AND (l_msg_count > 0)
997: THEN
998: RAISE SEND_ACKN_ERROR;

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

1003: WHERE erecord_id = my_events.erecord_id
1004: AND parent_erecord_id = my_events.parent_erecord_id;
1005:
1006: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1007: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1008: END LOOP;
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1010:
1011: EXCEPTION

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

1005:
1006: -- select count(*) INTO l_parent_child_count from eng_parent_child_events_temp;
1007: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'eng_parent_child_events_temp count='||l_parent_child_count);
1008: END LOOP;
1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of acknowledgement part ');
1010:
1011: EXCEPTION
1012: WHEN SEND_ACKN_ERROR THEN
1013: FND_MSG_PUB.Get(

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

1014: p_msg_index => 1,
1015: p_data => l_msg_data,
1016: p_encoded => FND_API.G_FALSE,
1017: p_msg_index_out => l_dummy_cnt);
1018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1019:
1020: WHEN OTHERS THEN
1021: l_msg_data := 'ACKN Others Error='||SQLERRM;
1022: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

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

1018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1019:
1020: WHEN OTHERS THEN
1021: l_msg_data := 'ACKN Others Error='||SQLERRM;
1022: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
1023:
1024: END event_acknowledgement;
1025: -- ERES change ends
1026:

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

1118: l_new_lifecycle_phase VARCHAR2(240);
1119: l_object_name VARCHAR2(30):= 'EGO_ITEM';
1120:
1121: BEGIN
1122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change .. ');
1123: l_sql_stmt := ' SELECT eip.project_id, ppa.name '
1124: || 'FROM EGO_ITEM_PROJECTS eip, PA_PROJECTS_ALL ppa '
1125: || 'WHERE eip.project_id = ppa.project_id '
1126: || 'AND eip.INVENTORY_ITEM_ID = :1 '

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

1152: || 'end; ';
1153: EXECUTE IMMEDIATE l_plsql_block USING
1154: IN l_lifecycle_project_id, IN l_lifecycle_project_number, IN p_new_lifecycle_phase_id, IN l_new_lifecycle_phase,
1155: OUT l_return_status, OUT l_msg_count, OUT l_msg_data;
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for project '|| l_lifecycle_project_number || '.. ');
1157:
1158: EXCEPTION
1159: WHEN NO_DATA_FOUND THEN
1160: l_sql_stmt := ' SELECT lifecycle_id '

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

1165: BEGIN
1166: EXECUTE IMMEDIATE l_sql_stmt INTO l_lifecycle_id USING p_inventory_item_id, p_organization_id;
1167: EXCEPTION
1168: WHEN NO_DATA_FOUND THEN
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: No lifecycle associated to the item ');
1170: l_return_status := 'U';
1171: END;
1172: IF (l_lifecycle_id IS NOT NULL)
1173: THEN

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

1170: l_return_status := 'U';
1171: END;
1172: IF (l_lifecycle_id IS NOT NULL)
1173: THEN
1174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing lifecycle phase change for item.. ');
1175:
1176: /*l_plsql_block := 'begin '
1177: || 'ego_lifecycle_user_pub.Sync_Phase_Change '
1178: || '( p_api_version => :1 '

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

1209: OUT l_return_status, OUT l_error_code,OUT l_msg_count, OUT l_msg_data;
1210:
1211: FOR I IN 1..l_msg_count
1212: LOOP
1213: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
1214: END LOOP;
1215:
1216: END IF;
1217: END;

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

1219:
1220: EXCEPTION
1221: WHEN OTHERS THEN
1222:
1223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Lifecycle phase change Error: ' ||SQLERRM);
1224: x_return_status := 'U';
1225:
1226: END CHANGE_ITEM_LIFECYCLE_PHASE;
1227:

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

3317: , p_event_key => TO_CHAR(item.change_id)
3318: , x_erecord_id => l_parent_record_id);
3319: END IF;
3320:
3321: 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);
3322: ELSE
3323: -- set the value to N in case it is NULL.
3324: l_eres_enabled := 'N';
3325: END IF;

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

3322: ELSE
3323: -- set the value to N in case it is NULL.
3324: l_eres_enabled := 'N';
3325: END IF;
3326: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Info: EDR_ERES_ENABLED='||l_eres_enabled);
3327:
3328: -- ERES change ends
3329:
3330: 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 3397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Preparing ERES. parent_erecord_id='||l_parent_record_id);

3393: -- ERES change begins
3394: -- Create child event Transfer or Copy ToManufacturing:
3395: IF (l_eres_enabled = 'Y')
3396: THEN
3397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Preparing ERES. parent_erecord_id='||l_parent_record_id);
3398:
3399: l_event.param_name_1 := 'DEFERRED';
3400: l_event.param_value_1 := 'Y';
3401:

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

3444: l_event.param_value_4 := 'NOT_FOUND';
3445: l_temp_id := '-1';
3446: END IF;
3447:
3448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3449: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3451:
3452: IF (NVL(l_parent_record_id, -1) > 0)

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

3445: l_temp_id := '-1';
3446: END IF;
3447:
3448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3449: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3451:
3452: IF (NVL(l_parent_record_id, -1) > 0)
3453: THEN

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

3446: END IF;
3447:
3448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Creating event='||l_child_event_name);
3449: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for event_key='||l_temp_id);
3450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'for user_event_key='||l_event.param_value_4);
3451:
3452: IF (NVL(l_parent_record_id, -1) > 0)
3453: THEN
3454: --additional parameters for the child event

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

3541: , l_parent_record_id
3542: , l_event.event_name, l_event.event_key, l_event.erecord_id
3543: , l_event.event_status);
3544:
3545: 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);
3546: ELSE
3547: 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');
3548: END IF;
3549: END IF; -- l_eres_enabled

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

3543: , l_event.event_status);
3544:
3545: 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);
3546: ELSE
3547: 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');
3548: END IF;
3549: END IF; -- l_eres_enabled
3550: -- ERES change ends
3551:

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

3620: , p_new_lifecycle_phase_id => item.new_lifecycle_state_id
3621: , x_return_status => l_lc_return_status);
3622: IF (l_lc_return_status <> 'S')
3623: THEN
3624: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for transfer line Failed');
3625: RAISE abort_implementation;
3626: END IF;
3627: END IF;
3628:

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

3649: END IF;
3650:
3651: IF (item.transfer_or_copy = 'O') -- if the item is obsoleted
3652: THEN
3653: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing obsolete Item .. ');
3654:
3655: l_max_scheduled_date := item.scheduled_date;
3656: l_implement_revised_item := 1;
3657: FOR li IN c_local_org_rev_items (item.change_id, item.revised_item_sequence_id)

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

3657: FOR li IN c_local_org_rev_items (item.change_id, item.revised_item_sequence_id)
3658: LOOP
3659: IF (li.implementation_date IS NULL )
3660: THEN
3661: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This item cannot be obsoleted since revised items propagated to the local organizations have not been implemented');
3662: Raise abort_implementation;
3663: END IF;
3664: IF li.scheduled_date > l_max_scheduled_date THEN
3665: l_max_scheduled_date := li.scheduled_date;

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

3685: , x_return_status => l_lc_return_status);
3686:
3687: IF (l_lc_return_status <> 'S')
3688: THEN
3689: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for obsolete item line Failed');
3690: RAISE abort_implementation;
3691: END IF;
3692: END IF;
3693:

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

3705: , x_Error_tbl => l_Error_tbl );
3706:
3707: IF (l_inv_return_status <> 'S' )
3708: THEN
3709: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item status to inactive Failed');
3710: Raise abort_implementation;
3711: END IF;
3712:
3713: IF (p_is_lifecycle_phase_change = 2 )

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

3727: END IF;
3728:
3729: ELSIF item.transfer_or_copy = 'L' THEN --life cycle phase chnage
3730:
3731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing phase change Item .. ');
3732: IF (item.new_lifecycle_state_id IS NOT NULL AND item.new_lifecycle_state_id <> item.current_lifecycle_state_id )
3733: THEN
3734: CHANGE_ITEM_LIFECYCLE_PHASE (
3735: p_rev_item_seq_id => revised_item

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

3739: , p_new_lifecycle_phase_id => item.new_lifecycle_state_id
3740: , x_return_status => l_lc_return_status);
3741: IF (l_lc_return_status <> 'S')
3742: THEN
3743: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Change Item phase for phase change line Failed');
3744: RAISE abort_implementation;
3745: END IF;
3746: END IF;
3747:

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

4164: BEGIN
4165:
4166: -- SAVEPOINT ITEM_CHG ;
4167:
4168: FND_FILE.NEW_LINE(FND_FILE.LOG);
4169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4170: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4172:

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

4165:
4166: -- SAVEPOINT ITEM_CHG ;
4167:
4168: FND_FILE.NEW_LINE(FND_FILE.LOG);
4169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4170: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4172:
4173: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

4166: -- SAVEPOINT ITEM_CHG ;
4167:
4168: FND_FILE.NEW_LINE(FND_FILE.LOG);
4169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4170: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4172:
4173: l_return_status := FND_API.G_RET_STS_SUCCESS;
4174: plsql_block := 'BEGIN

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

4167:
4168: FND_FILE.NEW_LINE(FND_FILE.LOG);
4169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4170: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4172:
4173: l_return_status := FND_API.G_RET_STS_SUCCESS;
4174: plsql_block := 'BEGIN
4175: FND_MSG_PUB.initialize ;

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

4188: OUT l_return_status, -- x_return_status
4189: OUT l_msg_count, -- x_msg_count
4190: OUT l_msg_data; -- x_msg_data
4191:
4192: FND_FILE.PUT_LINE(FND_FILE.LOG,'After: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes: Return Status=' || l_return_status);
4193:
4194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4195: THEN
4196: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');

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

4200:
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:
4204: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4205:
4206: EXCEPTION
4207: WHEN PLSQL_COMPILE_ERROR THEN
4208: null;

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

4208: null;
4209:
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4213: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4214: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4215:
4216: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

4209:
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4213: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4214: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4215:
4216: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4217:

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

4214: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4215:
4216: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4217:
4218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message Number : '|| I );
4219: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
4220:
4221: IF msg_qty < max_messages
4222: then

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

4215:
4216: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
4217:
4218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Message Number : '|| I );
4219: FND_FILE.PUT_LINE(FND_FILE.LOG,'DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
4220:
4221: IF msg_qty < max_messages
4222: then
4223: msg_qty := msg_qty + 1;

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

4233:
4234: END LOOP;
4235:
4236:
4237: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4238:
4239: IF trial_mode = no then
4240: Raise abort_implementation;
4241: END IF;

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

4242:
4243:
4244:
4245: WHEN OTHERS THEN
4246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4247:
4248: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4249: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4250: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;

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

4244:
4245: WHEN OTHERS THEN
4246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4247:
4248: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4249: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4250: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4251:
4252:

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

4245: WHEN OTHERS THEN
4246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Other Unexpected Error: '|| substr(SQLERRM,1,200));
4247:
4248: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4249: FND_FILE.PUT_LINE(FND_FILE.LOG,'ROLL BACK TO ITEM_CHG');
4250: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;
4251:
4252:
4253: IF msg_qty < max_messages

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

4261: value2(msg_qty) := null;
4262: translate2(msg_qty) := 0;
4263: END IF;
4264:
4265: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4266:
4267:
4268: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4269:

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

4264:
4265: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4266:
4267:
4268: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4269:
4270: IF trial_mode = no then
4271: Raise abort_implementation;
4272: END IF;

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

4733: -- ERES flag to be set for triggering Routing Event:
4734: bERES_Flag_for_Routing := TRUE;
4735: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing revision is being updated by revised item
4736: l_WIP_Flag_for_Routing := 'Y';
4737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in mtl_rtg_item_revisions... bERES_Flag_for_Routing=TRUE');
4738: END IF;
4739: -- ERES changes end.
4740:
4741: END IF; -- end of nlssort(current_routing_revision)

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

4893: -- ERES flag to be set for triggering Routing Event:
4894: bERES_Flag_for_Routing := TRUE;
4895: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing header is being updated by revised item
4896: l_WIP_Flag_for_Routing := 'Y';
4897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in bom_operational_routings ... bERES_Flag_for_Routing=TRUE');
4898: END IF;
4899: -- ERES changes end.
4900: END IF;
4901: --end of bugfix 3234628

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

5743: -- ERES flag to be set for triggering Routing Event:
5744: bERES_Flag_for_Routing := TRUE;
5745: -- Bug 4455543: Set l_WIP_Flag_for_Routing when routing details is being updated by revised item
5746: l_WIP_Flag_for_Routing := 'Y';
5747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in chng_operation_rows loop... bERES_Flag_for_Routing=TRUE');
5748: -- ERES changes end.
5749:
5750: END LOOP;
5751:

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

6783: FND_MESSAGE.Set_Token('SUBSTITUTE_ITEM_NAME',sub_component.item_number) ;
6784: FND_MESSAGE.Set_Token('REVISED_COMPONENT_NAME',component.item_number) ;
6785: FND_MSG_PUB.Add;
6786: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => l_error_msg_count , p_data => l_message);
6787: FND_FILE.put_line(FND_FILE.LOG, l_message);
6788: If trial_mode = no then
6789: Close check_existing_substitutes;
6790: Raise abort_implementation;
6791: end if;

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

7288: end if;
7289:
7290: -- ERES changes begin : bug 3741444
7291: bERES_Flag_for_BOM := TRUE;
7292: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in component loop... bERES_Flag_for_BOM=TRUE');
7293: -- ERES changes end.
7294:
7295: -- Bug 4584490: Changes for Bom Business Events
7296: -- l_BOMEvents_Comps_ACD:

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

7450: , l_parent_record_id
7451: , l_event.event_name, l_event.event_key, l_event.erecord_id
7452: , l_event.event_status);
7453:
7454: 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);
7455: ELSE
7456: 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');
7457: END IF;
7458: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)

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

7452: , l_event.event_status);
7453:
7454: 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);
7455: ELSE
7456: 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');
7457: END IF;
7458: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)
7459:
7460: ELSE

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

7457: END IF;
7458: END IF; -- (NVL(item.bill_sequence_id, -1) > 0)
7459:
7460: ELSE
7461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_BOM=FALSE, then, NO ERES event for BOM .');
7462: END IF; -- SQL%ROWCOUNT > 0
7463: END IF; -- l_eres_enabled
7464: -- ERES change ends
7465:

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

7585: , l_parent_record_id
7586: , l_event.event_name, l_event.event_key, l_event.erecord_id
7587: , l_event.event_status);
7588:
7589: 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);
7590: ELSE
7591: 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');
7592: END IF;
7593:

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

7587: , l_event.event_status);
7588:
7589: 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);
7590: ELSE
7591: 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');
7592: END IF;
7593:
7594: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');

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

7591: 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');
7592: END IF;
7593:
7594: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');
7596:
7597: ELSE
7598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_Routing=FALSE, then, NO ERES event for Routing.');
7599: END IF; -- SQL%ROWCOUNT > 0

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

7594: END IF; -- (NVL(item.routing_sequence_id, -1) > 0)
7595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Normal end of ERES Calls for procedure implement_revised_item.');
7596:
7597: ELSE
7598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'bERES_Flag_for_Routing=FALSE, then, NO ERES event for Routing.');
7599: END IF; -- SQL%ROWCOUNT > 0
7600: END IF; -- l_eres_enabled
7601: -- ERES change ends
7602:

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

7785: -- New code: end
7786:
7787: -- Fix for bug: 3463308
7788: /* does not work for some reason, but do not delete
7789: FND_FILE.PUT_NAMES('CP.impECO.wf.log',
7790: 'CP.impECO.wf.out',
7791: '/appslog/bis_top/utl/plm115dt/log'
7792: );
7793: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');

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

7789: FND_FILE.PUT_NAMES('CP.impECO.wf.log',
7790: 'CP.impECO.wf.out',
7791: '/appslog/bis_top/utl/plm115dt/log'
7792: );
7793: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');
7794: FND_FILE.PUT_LINE(fnd_file.log, ' item.change_id = ' || item.change_id);
7795: */
7796: -- using dynamic sql to launch status_change workflow API for implement phase
7797: BEGIN

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

7790: 'CP.impECO.wf.out',
7791: '/appslog/bis_top/utl/plm115dt/log'
7792: );
7793: FND_FILE.PUT_LINE(fnd_file.log, 'Before: calling startWorkflow');
7794: FND_FILE.PUT_LINE(fnd_file.log, ' item.change_id = ' || item.change_id);
7795: */
7796: -- using dynamic sql to launch status_change workflow API for implement phase
7797: BEGIN
7798: -- Log action for promotion to implement phase

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

7905: WHEN OTHERS THEN
7906: null;
7907: END;
7908: /* does not work for some reason, but do not delete
7909: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );

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

7906: null;
7907: END;
7908: /* does not work for some reason, but do not delete
7909: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
7914: FND_FILE.CLOSE;

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

7907: END;
7908: /* does not work for some reason, but do not delete
7909: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
7914: FND_FILE.CLOSE;
7915: */

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

7908: /* does not work for some reason, but do not delete
7909: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
7914: FND_FILE.CLOSE;
7915: */
7916: END IF;

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

7909: FND_FILE.PUT_LINE(fnd_file.log, 'After: calling startWorkflow');
7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
7914: FND_FILE.CLOSE;
7915: */
7916: END IF;
7917: end if;

Line 7914: FND_FILE.CLOSE;

7910: FND_FILE.PUT_LINE(fnd_file.log, ' l_return_status = ' || l_return_status);
7911: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_count = ' || to_char( nvl(l_msg_count, 0) ) );
7912: FND_FILE.PUT_LINE(fnd_file.log, ' l_msg_data = ' || nvl(l_msg_data, 'no msg data') );
7913: FND_FILE.PUT_LINE(fnd_file.log, ' l_item_key = ' || nvl(l_item_key, 'no item key') );
7914: FND_FILE.CLOSE;
7915: */
7916: END IF;
7917: end if;
7918: Close check_for_unimp_items;

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

8520: p_data => l_message,
8521: p_encoded => FND_API.G_FALSE,
8522: p_msg_index_out => l_dummy_cnt);
8523:
8524: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);
8526: event_acknowledgement('FAILURE');
8527:
8528: IF (msg_qty < max_messages)

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

8521: p_encoded => FND_API.G_FALSE,
8522: p_msg_index_out => l_dummy_cnt);
8523:
8524: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);
8526: event_acknowledgement('FAILURE');
8527:
8528: IF (msg_qty < max_messages)
8529: THEN

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

8548: -- ERES change ends
8549:
8550: When others then
8551: -- ERES change begins
8552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Others Error: '||SQLERRM);
8553: event_acknowledgement('FAILURE');
8554: -- ERES change ends
8555:
8556: -- Added for bug 4150069

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

8963:
8964: IF l_return_status = 'E' THEN
8965: l_message_name := 'ENG_ATTACHMENT_IMP_ERROR';
8966: l_message_desc := 'Attachment Changes implementation failed';
8967: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
8968: END IF;
8969:
8970: EXCEPTION
8971: WHEN OTHERS THEN

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

8968: END IF;
8969:
8970: EXCEPTION
8971: WHEN OTHERS THEN
8972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment Changes Implementation Failed'||SQLERRM);
8973: l_message_name := 'ENG_ATTACHMENT_IMP_ERROR';
8974: l_message_desc := 'Attachment Changes implementation failed';
8975: goto error_block;
8976: END;

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

8996:
8997: IF l_return_status = 'E' THEN
8998: l_message_name := 'ENG_RELATED_ENTITY_IMP_ERROR';
8999: l_message_desc := 'Related Entity Changes implementation failed';
9000: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
9001: END IF;
9002: END IF;
9003: EXCEPTION
9004: -- Don't throw an exception when package not found.

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

9004: -- Don't throw an exception when package not found.
9005: WHEN PLSQL_COMPILE_ERROR THEN
9006: null;
9007: WHEN OTHERS THEN
9008: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Related Entity Changes Implementation Failed'||SQLERRM);
9009: l_message_name := 'ENG_RELATED_ENTITY_IMP_ERROR';
9010: l_message_desc := 'Related Entity Changes implementation failed';
9011: goto error_block;
9012: END;

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

9026: translate2(msg_qty) := 0;
9027: message_names(msg_qty) := l_message_name;
9028: FOR I IN 1..l_msg_count
9029: LOOP
9030: FND_FILE.NEW_LINE(FND_FILE.LOG);
9031: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9032: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9033:
9034: END LOOP;

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

9027: message_names(msg_qty) := l_message_name;
9028: FOR I IN 1..l_msg_count
9029: LOOP
9030: FND_FILE.NEW_LINE(FND_FILE.LOG);
9031: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9032: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9033:
9034: END LOOP;
9035: ELSE

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

9028: FOR I IN 1..l_msg_count
9029: LOOP
9030: FND_FILE.NEW_LINE(FND_FILE.LOG);
9031: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message_desc);
9032: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MSG_PUB.get(I, 'F'));
9033:
9034: END LOOP;
9035: ELSE
9036: