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