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

Line 288: fnd_file.put_line(fnd_file.Log,'Start deleting Item Entities.');

284: l_item_asso_entity_count NUMBER := 0;
285:
286: BEGIN
287:
288: fnd_file.put_line(fnd_file.Log,'Start deleting Item Entities.');
289:
290:
291: FORALL item IN 1.. l_item_table.Count
292:

Line 317: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are '||l_item_entity_count);

313: l_item_entity_count := l_item_entity_count + SQL%BULK_ROWCOUNT(i);
314:
315: END LOOP;
316:
317: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are '||l_item_entity_count);
318:
319: FORALL item IN l_item_table.first .. l_item_table.last
320:
321: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE

Line 343: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are '||l_item_rev_entity_count);

339: FOR i IN l_item_table.first .. l_item_table.last
340: LOOP
341: l_item_rev_entity_count := l_item_rev_entity_count + SQL%BULK_ROWCOUNT(i);
342: END LOOP;
343: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are '||l_item_rev_entity_count);
344:
345:
346:
347:

Line 372: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are '||l_item_ppl_entity_count);

368: FOR i IN l_item_table.first .. l_item_table.last
369: LOOP
370: l_item_ppl_entity_count := l_item_ppl_entity_count + SQL%BULK_ROWCOUNT(i);
371: END LOOP;
372: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are '||l_item_ppl_entity_count);
373:
374:
375: FORALL item IN l_item_table.first .. l_item_table.last
376:

Line 400: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are '||l_item_cat_entity_count);

396: FOR i IN l_item_table.first .. l_item_table.last
397: LOOP
398: l_item_cat_entity_count := l_item_cat_entity_count + SQL%BULK_ROWCOUNT(i);
399: END LOOP;
400: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are '||l_item_cat_entity_count);
401:
402:
403:
404: FORALL item IN l_item_table.first .. l_item_table.last

Line 469: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are '||l_item_asso_entity_count);

465: FOR i IN l_item_table.first .. l_item_table.last
466: LOOP
467: l_item_asso_entity_count := l_item_asso_entity_count + SQL%BULK_ROWCOUNT(i);
468: END LOOP;
469: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are '||l_item_asso_entity_count);
470:
471:
472:
473: END;

Line 491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');

487:
488:
489: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
490:
491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');
492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');
493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');
494: fnd_file.put_line(fnd_file.Log,' ');
495:

Line 492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');

488:
489: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
490:
491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');
492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');
493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');
494: fnd_file.put_line(fnd_file.Log,' ');
495:
496:

Line 493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');

489: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
490:
491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');
492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');
493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');
494: fnd_file.put_line(fnd_file.Log,' ');
495:
496:
497: IF p_purge_criteria='ALL' THEN

Line 494: fnd_file.put_line(fnd_file.Log,' ');

490:
491: fnd_file.put_line(fnd_file.Log,'Purge Program run for Batch ID:'||p_batch_id || '.');
492: fnd_file.put_line(fnd_file.Log,'Batch type is '||l_batch_type||'.');
493: fnd_file.put_line(fnd_file.Log,'Purge Criteria is '|| p_purge_criteria||'.');
494: fnd_file.put_line(fnd_file.Log,' ');
495:
496:
497: IF p_purge_criteria='ALL' THEN
498:

Line 522: fnd_file.put_line(fnd_file.Log,err_buff);

518:
519: WHEN OTHERS THEN
520: err_buff := 'batch_purge: stm_num = '||stm_num||'. Error msg: '||SUBSTR(SQLERRM, 1, 200);
521: ret_code := 2;--FND_API.G_RET_STS_ERROR;
522: fnd_file.put_line(fnd_file.Log,err_buff);
523:
524: END batch_purge;
525:
526:

Line 553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');

549: clear_items(p_purge_criteria,l_item_table);
550:
551: COMMIT;
552: ELSE
553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');

Line 554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');

550:
551: COMMIT;
552: ELSE
553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
558: END IF;

Line 555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');

551: COMMIT;
552: ELSE
553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
558: END IF;
559:

Line 556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');

552: ELSE
553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
558: END IF;
559:
560: EXCEPTION

Line 557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');

553: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
554: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
555: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
556: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
557: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
558: END IF;
559:
560: EXCEPTION
561:

Line 565: fnd_file.put_line(fnd_file.Log,err_buff);

561:
562: WHEN OTHERS THEN
563: err_buff := 'Item_Purge: stm_num = '||stm_num||'. Error msg: '||SUBSTR(SQLERRM, 1, 200);
564: ret_code := 2;--FND_API.G_RET_STS_ERROR;
565: fnd_file.put_line(fnd_file.Log,err_buff);
566:
567:
568:
569: END Item_Purge;

Line 663: fnd_file.put_line(fnd_file.Log,'Start deleting Structure Entities');

659: --Start deleting records from bom tables
660:
661: IF str_num >0 THEN
662:
663: fnd_file.put_line(fnd_file.Log,'Start deleting Structure Entities');
664:
665: --delete records from bom_sub_comps_interface
666: stm_num := 2;
667:

Line 800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);

796:
797: END IF;
798:
799:
800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);
801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);
802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);
803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);
804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);

Line 801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);

797: END IF;
798:
799:
800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);
801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);
802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);
803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);
804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);
805:

Line 802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);

798:
799:
800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);
801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);
802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);
803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);
804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);
805:
806:

Line 803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);

799:
800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);
801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);
802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);
803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);
804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);
805:
806:
807:

Line 804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);

800: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||l_bom_entity_count);
801: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||l_comp_entity_count);
802: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||l_sub_comp_entity_count);
803: fnd_file.put_line(fnd_file.Log,'No.of Ref-designators deleted are '||l_ref_comp_entity_count);
804: fnd_file.put_line(fnd_file.Log,'No.of Component operations deleted are '||l_op_comp_entity_count);
805:
806:
807:
808: --end deleting records from bom tables

Line 827: fnd_file.put_line(fnd_file.Log,'Start deleting Routing Entities');

823:
824: --delete records from bom_op_resources_interface
825: stm_num := 8;
826:
827: fnd_file.put_line(fnd_file.Log,'Start deleting Routing Entities');
828:
829:
830: FORALL op IN l_routing_table.first .. l_routing_table.last
831:

Line 935: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||l_bom_op_route_entity_count);

931:
932: END IF;
933:
934:
935: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||l_bom_op_route_entity_count);
936: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||l_bom_op_res_entity_count);
937: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||l_bom_sub_op_res_entity_count);
938: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||l_bom_op_seq_entity_count);
939:

Line 936: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||l_bom_op_res_entity_count);

932: END IF;
933:
934:
935: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||l_bom_op_route_entity_count);
936: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||l_bom_op_res_entity_count);
937: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||l_bom_sub_op_res_entity_count);
938: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||l_bom_op_seq_entity_count);
939:
940: --end delete routing tables

Line 937: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||l_bom_sub_op_res_entity_count);

933:
934:
935: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||l_bom_op_route_entity_count);
936: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||l_bom_op_res_entity_count);
937: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||l_bom_sub_op_res_entity_count);
938: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||l_bom_op_seq_entity_count);
939:
940: --end delete routing tables
941:

Line 938: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||l_bom_op_seq_entity_count);

934:
935: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||l_bom_op_route_entity_count);
936: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||l_bom_op_res_entity_count);
937: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||l_bom_sub_op_res_entity_count);
938: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||l_bom_op_seq_entity_count);
939:
940: --end delete routing tables
941:
942:

Line 997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');

993: COMMIT;
994:
995: ELSE
996:
997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');

Line 998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');

994:
995: ELSE
996:
997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
1002:

Line 999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');

995: ELSE
996:
997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
1002:
1003: END IF;

Line 1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');

996:
997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
1002:
1003: END IF;
1004:

Line 1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');

997: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are 0');
998: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are 0');
999: fnd_file.put_line(fnd_file.Log,'No.of Item People deleted are 0');
1000: fnd_file.put_line(fnd_file.Log,'No.of Item Categories deleted are 0');
1001: fnd_file.put_line(fnd_file.Log,'No.of Item Associations deleted are 0');
1002:
1003: END IF;
1004:
1005:

Line 1014: fnd_file.put_line(fnd_file.Log,err_buff);

1010: WHEN OTHERS THEN
1011:
1012: err_buff := 'Structure_Purge: stm_num = '||stm_num||'. Error msg: '||SUBSTR(SQLERRM, 1, 200);
1013: ret_code := 2;--FND_API.G_RET_STS_ERROR;
1014: fnd_file.put_line(fnd_file.Log,err_buff);
1015:
1016: END Structure_Purge;
1017:
1018:

Line 1037: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are '||SQL%ROWCOUNT);

1033: stm_num :=2;
1034:
1035: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE WHERE set_process_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1036:
1037: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are '||SQL%ROWCOUNT);
1038:
1039: stm_num :=3;
1040:
1041: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE WHERE SET_PROCESS_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);

Line 1043: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are '||SQL%ROWCOUNT);

1039: stm_num :=3;
1040:
1041: DELETE FROM MTL_ITEM_REVISIONS_INTERFACE WHERE SET_PROCESS_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1042:
1043: fnd_file.put_line(fnd_file.Log,'No.of Item Revision Entities deleted are '||SQL%ROWCOUNT);
1044:
1045:
1046: stm_num :=4;
1047:

Line 1050: fnd_file.put_line(fnd_file.Log,'No.of Item People Entities deleted are '||SQL%ROWCOUNT);

1046: stm_num :=4;
1047:
1048: DELETE FROM EGO_ITEM_PEOPLE_INTF WHERE DATA_SET_ID = p_batch_id AND PROCESS_STATUS IN (3,4,6,7);
1049:
1050: fnd_file.put_line(fnd_file.Log,'No.of Item People Entities deleted are '||SQL%ROWCOUNT);
1051:
1052:
1053: stm_num :=5;
1054:

Line 1057: fnd_file.put_line(fnd_file.Log,'No.of Item Categories Entities deleted are '||SQL%ROWCOUNT);

1053: stm_num :=5;
1054:
1055: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE WHERE SET_PROCESS_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1056:
1057: fnd_file.put_line(fnd_file.Log,'No.of Item Categories Entities deleted are '||SQL%ROWCOUNT);
1058:
1059:
1060: stm_num :=6;
1061:

Line 1065: fnd_file.put_line(fnd_file.Log,'No.of Item Association Entities deleted are '||SQL%ROWCOUNT);

1061:
1062:
1063: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF WHERE BATCH_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1064:
1065: fnd_file.put_line(fnd_file.Log,'No.of Item Association Entities deleted are '||SQL%ROWCOUNT);
1066:
1067:
1068: stm_num :=7;
1069:

Line 1088: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||SQL%ROWCOUNT);

1084: stm_num :=8;
1085:
1086: DELETE bom_bill_of_mtls_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1087:
1088: fnd_file.put_line(fnd_file.Log,'No.of Structures deleted are '||SQL%ROWCOUNT);
1089:
1090:
1091: stm_num :=9;
1092:

Line 1095: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||SQL%ROWCOUNT);

1091: stm_num :=9;
1092:
1093: DELETE bom_inventory_comps_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1094:
1095: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||SQL%ROWCOUNT);
1096:
1097:
1098: stm_num :=10;
1099:

Line 1102: fnd_file.put_line(fnd_file.Log,'No.of ref-designators deleted are '||SQL%ROWCOUNT);

1098: stm_num :=10;
1099:
1100: DELETE bom_ref_desgs_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1101:
1102: fnd_file.put_line(fnd_file.Log,'No.of ref-designators deleted are '||SQL%ROWCOUNT);
1103:
1104:
1105: stm_num :=11;
1106:

Line 1109: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||SQL%ROWCOUNT);

1105: stm_num :=11;
1106:
1107: DELETE bom_sub_comps_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1108:
1109: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||SQL%ROWCOUNT);
1110:
1111:
1112: stm_num :=12;
1113:

Line 1121: fnd_file.put_line(fnd_file.Log,'No.of Component Operations deleted are '||SQL%ROWCOUNT);

1117: stm_num :=13;
1118:
1119: DELETE bom_component_ops_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1120:
1121: fnd_file.put_line(fnd_file.Log,'No.of Component Operations deleted are '||SQL%ROWCOUNT);
1122:
1123:
1124: stm_num :=14;
1125:

Line 1128: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||SQL%ROWCOUNT);

1124: stm_num :=14;
1125:
1126: DELETE bom_op_routings_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1127:
1128: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||SQL%ROWCOUNT);
1129:
1130:
1131: stm_num :=15;
1132:

Line 1135: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||SQL%ROWCOUNT);

1131: stm_num :=15;
1132:
1133: DELETE bom_op_resources_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1134:
1135: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||SQL%ROWCOUNT);
1136:
1137:
1138: stm_num :=16;
1139:

Line 1142: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||SQL%ROWCOUNT);

1138: stm_num :=16;
1139:
1140: DELETE bom_sub_op_resources_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1141:
1142: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||SQL%ROWCOUNT);
1143:
1144:
1145: stm_num :=17;
1146:

Line 1149: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||SQL%ROWCOUNT);

1145: stm_num :=17;
1146:
1147: DELETE bom_op_sequences_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1148:
1149: fnd_file.put_line(fnd_file.Log,'No.of Operation sequences deleted are '||SQL%ROWCOUNT);
1150:
1151:
1152: stm_num :=18;
1153:

Line 1165: fnd_file.put_line(fnd_file.Log,err_buff);

1161:
1162: WHEN OTHERS THEN
1163: err_buff := 'Purge_All: stm_num = '||stm_num||'. Error msg: '||SUBSTR(SQLERRM, 1, 200);
1164: ret_code := 2; --FND_API.G_RET_STS_ERROR;
1165: fnd_file.put_line(fnd_file.Log,err_buff);
1166:
1167: END Purge_All;
1168:
1169: