DBA Data[Home] [Help]

APPS.FLM_COPY_ROUTING dependencies on FND_FILE

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

593: END LOOP;
594:
595: if (l_rtg_tbl.COUNT <= 0) then
596: if (G_LOG_ON) then
597: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');
598: end if;
599: return;
600: end if;
601:

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

617: END LOOP;
618:
619: if (l_rtg_tbl.COUNT <= 0) then
620: if (G_LOG_ON) then
621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No routings to copy.');
622: end if;
623: return;
624: end if;
625:

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

661: END LOOP;
662:
663: l_rtg_total := l_rtg_tbl.COUNT;
664: if (G_LOG_ON) then
665: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total routings to copy: '||l_rtg_total);
666: end if;
667:
668: success := 0;
669:

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

715:
716: l_assembly_item_name := l_rtg_header_rec.assembly_item_name;
717:
718: if (G_LOG_ON) then
719: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy routing: '||
720: l_assembly_item_name||' ('||p_alternate_code_from||' -> '||p_alternate_code_to||')');
721: end if;
722:
723: -- routing revisions

Line 846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||

842: if (l_diff_count = 1) then
843: l_dept_diff := 1;
844: retcode := 1;
845: if (stdop.operation_type = 1) then
846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
847: l_assembly_item_name||' as department of Event '||stdop.standard_operation_code||' on source line '||l_line_code_from||
848: ' is different from that on the destination line '||l_line_code||'.');
849: elsif (stdop.operation_type = 2) then
850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||

Line 850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||

846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
847: l_assembly_item_name||' as department of Event '||stdop.standard_operation_code||' on source line '||l_line_code_from||
848: ' is different from that on the destination line '||l_line_code||'.');
849: elsif (stdop.operation_type = 2) then
850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||
852: ' is different from that on the destination line '||l_line_code||'.');
853: else
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||

Line 854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||

850: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
851: l_assembly_item_name||' as department of Process '||stdop.standard_operation_code||' on source line '||l_line_code_from||
852: ' is different from that on the destination line '||l_line_code||'.');
853: else
854: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy flow routing across Lines program failed to copy for assembly '||
855: l_assembly_item_name||' as department of Line Operation '||stdop.standard_operation_code||' on source line '||l_line_code_from||
856: ' is different from that on the destination line '||l_line_code||'.');
857: end if;
858: end if;

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

1387: fnd_message.set_name('FLM','FLM_RTG_BOM_API_FAILED');
1388: fnd_message.set_token('MSG_COUNT',error_handler.get_message_count);
1389: errbuf := fnd_message.get;
1390: if (G_LOG_ON) then
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf || ' - ' || l_assembly_item_name);
1392: while o_msg_count > 0 loop
1393: error_handler.get_message(l_msg,l_index,l_id,l_type);
1394: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1395: o_msg_count := o_msg_count - 1;

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

1390: if (G_LOG_ON) then
1391: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf || ' - ' || l_assembly_item_name);
1392: while o_msg_count > 0 loop
1393: error_handler.get_message(l_msg,l_index,l_id,l_type);
1394: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1395: o_msg_count := o_msg_count - 1;
1396: end loop;
1397: end if;
1398: ROLLBACK TO SAVEPOINT copy_std;

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

1399: elsif (o_msg_count > 0) then
1400: if (G_LOG_ON) then
1401: while o_msg_count > 0 loop
1402: error_handler.get_message(l_msg,l_index,l_id,l_type);
1403: FND_FILE.PUT_LINE(FND_FILE.LOG,l_type||' - '||l_msg||' - '||l_id);
1404: o_msg_count := o_msg_count - 1;
1405: end loop;
1406: end if;
1407: end if;

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

1420: end if;
1421: Close c_bill_sequence;
1422: if (l_from_sequence_id is not NULL) then
1423: if (G_LOG_ON) then
1424: FND_FILE.PUT_LINE(FND_FILE.LOG,'Copy bill: '||
1425: l_assembly_item_name||' ('||p_alternate_code_from||' -> '||p_alternate_code_to||')');
1426: end if;
1427:
1428: l_to_sequence_id := null;

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

1541: fnd_message.set_name('FLM', 'FLM_RTG_COPY_NONE');
1542: fnd_message.set_token('RTG_TOTAL',l_rtg_total);
1543: errbuf := fnd_message.get;
1544: if (G_LOG_ON) then
1545: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1546: end if;
1547: rollback;
1548: else
1549: fnd_message.set_name('FLM', 'FLM_RTG_COPY_DONE');

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

1550: fnd_message.set_token('RTG_COUNT', success);
1551: fnd_message.set_token('RTG_TOTAL',l_rtg_total);
1552: errbuf := fnd_message.get;
1553: if (G_LOG_ON) then
1554: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1555: end if;
1556: commit;
1557: end if;
1558: EXCEPTION

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

1559: WHEN OTHERS THEN
1560: retcode := 2;
1561: errbuf := 'Exception - ' || substr(SQLERRM,1,200) || ' (' || SQLCODE || ')';
1562: if (G_LOG_ON) then
1563: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1564: end if;
1565: rollback;
1566: return;
1567: End copy_routings;