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 807: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg15 );

803: l_row_index := 0;
804:
805: END IF;
806:
807: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg15 );
808:
809: EXCEPTION
810:
811: WHEN OTHERS THEN

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

1113: l_commit_count := 0;
1114:
1115: END IF;
1116:
1117: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg15 );
1118:
1119: EXCEPTION
1120:
1121: WHEN OTHERS THEN

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

1526: END IF;
1527:
1528:
1529:
1530: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg17 );
1531:
1532: EXCEPTION
1533:
1534: WHEN OTHERS THEN

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

1728:
1729: END IF;
1730:
1731:
1732: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg17);
1733:
1734: EXCEPTION
1735:
1736: WHEN OTHERS THEN

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

2141: END IF;
2142:
2143: IF l_release_id IS NULL THEN
2144:
2145: fnd_file.put_line(fnd_file.output, rpad(l_po_num,26) || rpad(l_doc_type,32) || l_msg18 );
2146:
2147: END IF;
2148:
2149: EXCEPTION

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

2348: PO_DEBUG.debug_var(l_log_head,l_progress,'l_commit_count', l_commit_count);
2349:
2350: END IF;
2351:
2352: fnd_file.put_line(fnd_file.output, rpad(l_po_num || '-' || l_rel_num,32) || rpad(l_doc_type,26) || l_msg18);
2353:
2354: EXCEPTION
2355:
2356: WHEN OTHERS THEN

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

2570: l_msg15 := fnd_message.get;
2571:
2572: l_progress := '002';
2573:
2574: fnd_file.put_line(fnd_file.output, l_msg1);
2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);

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

2571:
2572: l_progress := '002';
2573:
2574: fnd_file.put_line(fnd_file.output, l_msg1);
2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);

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

2572: l_progress := '002';
2573:
2574: fnd_file.put_line(fnd_file.output, l_msg1);
2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);

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

2573:
2574: fnd_file.put_line(fnd_file.output, l_msg1);
2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';

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

2574: fnd_file.put_line(fnd_file.output, l_msg1);
2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);

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

2575: fnd_file.put_line(fnd_file.output, ' ');
2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);

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

2576: fnd_file.put_line(fnd_file.output, rpad(l_msg2,21) || ' : ' || sysdate);
2577: fnd_file.put_line(fnd_file.output, rpad(l_msg3,21) || ' : ' || p_org_name);
2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);

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

2578: fnd_file.put_line(fnd_file.output, rpad(l_msg4,21) || ' : ' || p_old_buyer_name);
2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);

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

2579: fnd_file.put_line(fnd_file.output, rpad(l_msg5,21) || ' : ' || p_new_buyer_name);
2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';

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

2580: fnd_file.put_line(fnd_file.output, rpad(l_msg6,21) || ' : ' || p_document_type);
2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');

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

2581: l_progress := '003';
2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);

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

2582: fnd_file.put_line(fnd_file.output, rpad(l_msg7,21) || ' : ' || p_document_no_from);
2583: fnd_file.put_line(fnd_file.output, rpad(l_msg8,21) || ' : ' || p_document_no_to);
2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');

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

2584: fnd_file.put_line(fnd_file.output, rpad(l_msg9,21) || ' : ' || p_date_from);
2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');
2591: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2592: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));

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

2585: fnd_file.put_line(fnd_file.output, rpad(l_msg10,21) || ' : ' || p_date_to);
2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');
2591: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2592: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2593:

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

2586: fnd_file.put_line(fnd_file.output, rpad(l_msg11,21) || ' : ' || p_supplier_name);
2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');
2591: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2592: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2593:
2594: EXCEPTION

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

2587: l_progress := '004';
2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');
2591: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2592: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2593:
2594: EXCEPTION
2595:

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

2588: fnd_file.put_line(fnd_file.output, ' ');
2589: fnd_file.put_line(fnd_file.output, l_msg12);
2590: fnd_file.put_line(fnd_file.output, ' ');
2591: fnd_file.put_line(fnd_file.output, rpad(l_msg13,26) || rpad(l_msg14,32) || l_msg15);
2592: fnd_file.put_line(fnd_file.output, rpad('-',70,'-'));
2593:
2594: EXCEPTION
2595:
2596: WHEN OTHERS THEN