DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on FND_FILE

Line 118: fnd_file.put_line(fnd_file.log,fnd_message.get);

114: WHERE employee_id = p_new_personid;
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: po_message_s.sql_error('Not a Valid Buyer','Not a Valid Buyer',l_progress,SQLCODE,SQLERRM);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: x_valid_buyer := 'N';
120: END;
121:
122: IF x_valid_buyer = 'Y' THEN

Line 862: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg15 );

858: l_row_index := 0;
859:
860: END IF;
861:
862: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg15 );
863:
864: EXCEPTION
865:
866: WHEN OTHERS THEN

Line 1190: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg15 );

1186: l_commit_count := 0;
1187:
1188: END IF;
1189:
1190: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg15 );
1191:
1192: EXCEPTION
1193:
1194: WHEN OTHERS THEN

Line 1603: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg17 );

1599: END IF;
1600:
1601:
1602:
1603: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg17 );
1604:
1605: EXCEPTION
1606:
1607: WHEN OTHERS THEN

Line 1805: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg17);

1801:
1802: END IF;
1803:
1804:
1805: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg17);
1806:
1807: EXCEPTION
1808:
1809: WHEN OTHERS THEN

Line 2218: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg18 );

2214: END IF;
2215:
2216: IF l_release_id IS NULL THEN
2217:
2218: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg18 );
2219:
2220: END IF;
2221:
2222: EXCEPTION

Line 2425: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg18);

2421: PO_DEBUG.debug_var(l_log_head,l_progress,'l_commit_count', l_commit_count);
2422:
2423: END IF;
2424:
2425: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg18);
2426:
2427: EXCEPTION
2428:
2429: WHEN OTHERS THEN

Line 2647: fnd_file.put_line(fnd_file.output, l_msg1);

2643: l_msg15 := fnd_message.get;
2644:
2645: l_progress := '002';
2646:
2647: fnd_file.put_line(fnd_file.output, l_msg1);
2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);

Line 2648: fnd_file.put_line(fnd_file.output, ' ');

2644:
2645: l_progress := '002';
2646:
2647: fnd_file.put_line(fnd_file.output, l_msg1);
2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);

Line 2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);

2645: l_progress := '002';
2646:
2647: fnd_file.put_line(fnd_file.output, l_msg1);
2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);

Line 2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);

2646:
2647: fnd_file.put_line(fnd_file.output, l_msg1);
2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';

Line 2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);

2647: fnd_file.put_line(fnd_file.output, l_msg1);
2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);

Line 2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);

2648: fnd_file.put_line(fnd_file.output, ' ');
2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);

Line 2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);

2649: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2650: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);

Line 2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);

2651: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);

Line 2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);

2652: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';

Line 2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);

2653: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');

Line 2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);

2654: l_progress := '003';
2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);

Line 2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);

2655: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2656: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');

Line 2661: fnd_file.put_line(fnd_file.output, ' ');

2657: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');
2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));

Line 2662: fnd_file.put_line(fnd_file.output, l_msg12);

2658: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');
2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2666:

Line 2663: fnd_file.put_line(fnd_file.output, ' ');

2659: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');
2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2666:
2667: EXCEPTION

Line 2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);

2660: l_progress := '004';
2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');
2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2666:
2667: EXCEPTION
2668:

Line 2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));

2661: fnd_file.put_line(fnd_file.output, ' ');
2662: fnd_file.put_line(fnd_file.output, l_msg12);
2663: fnd_file.put_line(fnd_file.output, ' ');
2664: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2665: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2666:
2667: EXCEPTION
2668:
2669: WHEN OTHERS THEN