377: p_hz_organization_bo.party_usage_objs);
378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: fnd_file.put_line(fnd_file.log,'exception detected in assign_organization.');
382: RAISE;
383:
384: END assign_organization;
385:
472: x_return_status,
473: x_msg_count,
474: x_msg_data);
475: IF x_msg_data IS NULL THEN
476: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Data');
477: ELSE
478: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Data: Exception: '||x_msg_data);
479: END IF;
480:
474: x_msg_data);
475: IF x_msg_data IS NULL THEN
476: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Data');
477: ELSE
478: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Data: Exception: '||x_msg_data);
479: END IF;
480:
481: /*pos_supplier_uda_bo_pkg.get_uda_data(p_api_version ,
482: NULL ,
497: x_return_status,
498: x_msg_count,
499: x_msg_data);
500: IF x_msg_data IS NULL THEN
501: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Site Data');
502: ELSE
503: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Site Data: Exception: '||x_msg_data);
504: END IF;
505:
499: x_msg_data);
500: IF x_msg_data IS NULL THEN
501: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Site Data');
502: ELSE
503: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Site Data: Exception: '||x_msg_data);
504: END IF;
505:
506:
507: pos_hz_party_site_bo_tbl_pkg.get_party_site_bos(l_party_id,
510: x_msg_count,
511: x_msg_data);
512:
513: IF x_msg_data IS NULL THEN
514: fnd_file.put_line(fnd_file.log,'Extracted the Party Site Data');
515: ELSE
516: fnd_file.put_line(fnd_file.log,'Extracting the Party Site Data: Exception: '||x_msg_data);
517: END IF;
518:
512:
513: IF x_msg_data IS NULL THEN
514: fnd_file.put_line(fnd_file.log,'Extracted the Party Site Data');
515: ELSE
516: fnd_file.put_line(fnd_file.log,'Extracting the Party Site Data: Exception: '||x_msg_data);
517: END IF;
518:
519: -- Bug 12795884: Populating bank account data
520:
528: x_msg_count,
529: x_msg_data);
530:
531: IF x_msg_data IS NULL THEN
532: fnd_file.put_line(fnd_file.log,'Extracted the Bank Account Data');
533: ELSE
534: fnd_file.put_line(fnd_file.log,'Extracting the Bank Account Data: Exception: '||x_msg_data);
535: END IF;
536:
530:
531: IF x_msg_data IS NULL THEN
532: fnd_file.put_line(fnd_file.log,'Extracted the Bank Account Data');
533: ELSE
534: fnd_file.put_line(fnd_file.log,'Extracting the Bank Account Data: Exception: '||x_msg_data);
535: END IF;
536:
537: -- End Bug 12795884
538:
546: x_msg_count,
547: x_msg_data);
548:
549: IF x_msg_data IS NULL THEN
550: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Organization Data');
551: ELSE
552: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Organization Data: Exception: '||x_msg_data);
553: END IF;
554:
548:
549: IF x_msg_data IS NULL THEN
550: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Organization Data');
551: ELSE
552: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Organization Data: Exception: '||x_msg_data);
553: END IF;
554:
555: --populating business class data;
556: pos_business_class_bo_pkg.get_pos_business_class_bo_tbl(p_api_version,
562: x_return_status,
563: x_msg_count,
564: x_msg_data);
565: IF x_msg_data IS NULL THEN
566: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Business Class Data');
567: ELSE
568: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Business Class Data: Exception: '||x_msg_data);
569: END IF;
570:
564: x_msg_data);
565: IF x_msg_data IS NULL THEN
566: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Business Class Data');
567: ELSE
568: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Business Class Data: Exception: '||x_msg_data);
569: END IF;
570:
571: --populating bank payee data;
572: pos_bank_payee_bo_pkg.get_pos_bank_payee_bo_tbl(p_api_version,
578: x_return_status,
579: x_msg_count,
580: x_msg_data);
581: IF x_msg_data IS NULL THEN
582: fnd_file.put_line(fnd_file.log,'Extracted the Bank Payee Data');
583: ELSE
584: fnd_file.put_line(fnd_file.log,'Extracting the Bank Payee Data: Exception: '||x_msg_data);
585: END IF;
586:
580: x_msg_data);
581: IF x_msg_data IS NULL THEN
582: fnd_file.put_line(fnd_file.log,'Extracted the Bank Payee Data');
583: ELSE
584: fnd_file.put_line(fnd_file.log,'Extracting the Bank Payee Data: Exception: '||x_msg_data);
585: END IF;
586:
587:
588: --Populating Party Data
594: x_return_status,
595: x_msg_count,
596: x_msg_data);
597: IF x_msg_data IS NULL THEN
598: fnd_file.put_line(fnd_file.log,'Extracted the Party Data');
599: ELSE
600: fnd_file.put_line(fnd_file.log,'Extracting the Party Data: Exception: '||x_msg_data);
601: END IF;
602:
596: x_msg_data);
597: IF x_msg_data IS NULL THEN
598: fnd_file.put_line(fnd_file.log,'Extracted the Party Data');
599: ELSE
600: fnd_file.put_line(fnd_file.log,'Extracting the Party Data: Exception: '||x_msg_data);
601: END IF;
602:
603: --populating product services data
604: pos_product_service_bo_pkg.get_pos_product_service_bo_tbl(p_api_version,
610: x_return_status,
611: x_msg_count,
612: x_msg_data);
613: IF (x_msg_data IS NULL or x_msg_data='SUCCESS' )THEN
614: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Product Services Data');
615: ELSE
616: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Product Services Data: Exception: '||x_msg_data);
617: END IF;
618:
612: x_msg_data);
613: IF (x_msg_data IS NULL or x_msg_data='SUCCESS' )THEN
614: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Product Services Data');
615: ELSE
616: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Product Services Data: Exception: '||x_msg_data);
617: END IF;
618:
619: --Populating supplier contacts data
620: pos_supplier_contact_bo_pkg.get_pos_supp_contact_bo_tbl(p_api_version,
626: x_return_status,
627: x_msg_count,
628: x_msg_data);
629: IF x_msg_data IS NULL THEN
630: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Contact Data');
631: ELSE
632: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Contact Data: Exception: '||x_msg_data);
633: END IF;
634:
628: x_msg_data);
629: IF x_msg_data IS NULL THEN
630: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Contact Data');
631: ELSE
632: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Contact Data: Exception: '||x_msg_data);
633: END IF;
634:
635: --populating tax profile data
636: pos_supplier_tax_prof_bo_pkg.get_pos_sup_tax_prof_bo_tbl(p_api_version,
642: x_return_status,
643: x_msg_count,
644: x_msg_data);
645: IF x_msg_data IS NULL THEN
646: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Tax Profile Data');
647: ELSE
648: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Tax Profile Data: Exception: '||x_msg_data);
649: END IF;
650:
644: x_msg_data);
645: IF x_msg_data IS NULL THEN
646: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Tax Profile Data');
647: ELSE
648: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Tax Profile Data: Exception: '||x_msg_data);
649: END IF;
650:
651: --Populating tax reporting data
652: pos_tax_report_bo_pkg.get_pos_tax_report_bo_tbl(p_api_version,
658: x_return_status,
659: x_msg_count,
660: x_msg_data);
661: IF x_msg_data IS NULL THEN
662: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Tax Report Data');
663: ELSE
664: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Tax Report Data: Exception: '||x_msg_data);
665: END IF;
666:
660: x_msg_data);
661: IF x_msg_data IS NULL THEN
662: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Tax Report Data');
663: ELSE
664: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Tax Report Data: Exception: '||x_msg_data);
665: END IF;
666:
667: --Populating Location data
668: pos_hz_location_bo_pkg.get_hz_location_bo(p_api_version,
675: x_msg_count,
676: x_msg_data);
677:
678: IF x_msg_data IS NULL THEN
679: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Location Data');
680: ELSE
681: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Location Data: Exception: '||x_msg_data);
682: END IF;
683:
677:
678: IF x_msg_data IS NULL THEN
679: fnd_file.put_line(fnd_file.log,'Extracted the Supplier Location Data');
680: ELSE
681: fnd_file.put_line(fnd_file.log,'Extracting the Supplier Location Data: Exception: '||x_msg_data);
682: END IF;
683:
684: x_pos_supplier_bo.p_pos_ap_supplier_bo := x_ap_supplier_bo;
685: x_pos_supplier_bo.p_pos_supplier_sites_all_tbl := x_pos_supplier_site_bo;