APPS.FLM_COPY_ROUTING dependencies on FND_FILE

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');

585: END LOOP;
586:
587: if (l_rtg_tbl.COUNT <= 0) then
588: if (G_LOG_ON) then
589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');
590: end if;
591: return;
592: end if;
593:

Line 614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');

610: END LOOP;
611:
612: if (l_rtg_tbl.COUNT <= 0) then
613: if (G_LOG_ON) then
614: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');
615: end if;
616: return;
617: end if;
618:

Line 658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total routings to copy: '||l_rtg_total);

654: END LOOP;
655:
656: l_rtg_total := l_rtg_tbl.COUNT;
657: if (G_LOG_ON) then
658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total routings to copy: '||l_rtg_total);
659: end if;
660:
661: success := 0;
662:

Line 712: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy routing: '||

708:
709: l_assembly_item_name := l_rtg_header_rec.assembly_item_name;
710:
711: if (G_LOG_ON) then
712: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy routing: '||
713: l_assembly_item_name||' ('||p_alternate_code_from||' -> '||p_alternate_code_to||')');
714: end if;
715:
716: -- routing revisions

Line 1112: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf || ' - ' || l_assembly_item_name);

1108: fnd_message.set_name('FLM','FLM_RTG_BOM_API_FAILED');
1109: fnd_message.set_token('MSG_COUNT',error_handler.get_message_count);
1110: errbuf := fnd_message.get;
1111: if (G_LOG_ON) then
1112: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf || ' - ' || l_assembly_item_name);
1113: while o_msg_count > 0 loop
1114: error_handler.get_message(l_msg,l_index,l_id,l_type);
1115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1116: o_msg_count := o_msg_count - 1;

Line 1115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);

1111: if (G_LOG_ON) then
1112: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf || ' - ' || l_assembly_item_name);
1113: while o_msg_count > 0 loop
1114: error_handler.get_message(l_msg,l_index,l_id,l_type);
1115: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1116: o_msg_count := o_msg_count - 1;
1117: end loop;
1118: end if;
1119: ROLLBACK TO SAVEPOINT copy_std;

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);

1120: elsif (o_msg_count > 0) then
1121: if (G_LOG_ON) then
1122: while o_msg_count > 0 loop
1123: error_handler.get_message(l_msg,l_index,l_id,l_type);
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1125: o_msg_count := o_msg_count - 1;
1126: end loop;
1127: end if;
1128: end if;

Line 1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy bill: '||

1144:
1145: if (l_from_sequence_id is not NULL) then
1146:
1147: if (G_LOG_ON) then
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy bill: '||
1149: l_assembly_item_name||' ('||p_alternate_code_from||' -> '||p_alternate_code_to||')');
1150: end if;
1151:
1152: l_to_sequence_id := null;

Line 1279: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1275: fnd_message.set_name('FLM', 'FLM_RTG_COPY_NONE');
1276: fnd_message.set_token('RTG_TOTAL',l_rtg_total);
1277: errbuf := fnd_message.get;
1278: if (G_LOG_ON) then
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1280: end if;
1281: rollback;
1282: else
1283: fnd_message.set_name('FLM', 'FLM_RTG_COPY_DONE');

Line 1288: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1284: fnd_message.set_token('RTG_COUNT', success);
1285: fnd_message.set_token('RTG_TOTAL',l_rtg_total);
1286: errbuf := fnd_message.get;
1287: if (G_LOG_ON) then
1288: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1289: end if;
1290: commit;
1291: end if;
1292:

Line 1298: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

1294: WHEN OTHERS THEN
1295: retcode := 2;
1296: errbuf := 'Exception - ' || substr(SQLERRM,1,200) || ' (' || SQLCODE || ')';
1297: if (G_LOG_ON) then
1298: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1299: end if;
1300: rollback;
1301: return;
1302: