DBA Data[Home] [Help]

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on FND_FILE

Line 126: FND_FILE.Put_Line(FND_FILE.Log,'Calling WSH API');

122: AND org_id = l_invoice_row.C_ORG_ID; --Bug#7307532
123:
124: END IF;
125:
126: FND_FILE.Put_Line(FND_FILE.Log,'Calling WSH API');
127:
128: -- Call WSH API
129: WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Party_Merge(
130: p_from_vendor_id => l_invoice_row.C_Dup_Vendor_Id,

Line 156: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

152: p_encoded => 'F',
153: p_data => l_msg_data,
154: p_msg_index_out => l_msg_index_out
155: );
156: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
157: End LOOP;
158: END IF;
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;

Line 162: FND_FILE.Put_Line(FND_FILE.Log,'Calling Fixed Assets API');

158: END IF;
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161:
162: FND_FILE.Put_Line(FND_FILE.Log,'Calling Fixed Assets API');
163:
164: -- Fixed Assets
165: FA_VendorMerge_GRP.Merge_Vendor(
166: p_api_version => 1.0

Line 197: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

193: p_encoded => 'F',
194: p_data => l_msg_data,
195: p_msg_index_out => l_msg_index_out
196: );
197: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
198: End LOOP;
199: END IF;
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;

Line 203: FND_FILE.Put_Line(FND_FILE.Log,'Calling Trade Management API');

199: END IF;
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203: FND_FILE.Put_Line(FND_FILE.Log,'Calling Trade Management API');
204:
205: -- Trade Management
206: OZF_VENDORMERGE_GRP.Merge_Vendor(
207: p_api_version => 1.0

Line 235: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

231: p_encoded => 'F',
232: p_data => l_msg_data,
233: p_msg_index_out => l_msg_index_out
234: );
235: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
236: End LOOP;
237: END IF;
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;

Line 241: FND_FILE.Put_Line(FND_FILE.Log,'Calling CMRO API');

237: END IF;
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:
241: FND_FILE.Put_Line(FND_FILE.Log,'Calling CMRO API');
242:
243: -- Complex Maintenance Repair and Overhaul
244: AHL_VENDORMERGE_GRP.Merge_Vendor(
245: p_api_version => 1.0

Line 273: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

269: p_encoded => 'F',
270: p_data => l_msg_data,
271: p_msg_index_out => l_msg_index_out
272: );
273: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
274: End LOOP;
275: END IF;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;

Line 279: FND_FILE.Put_Line(FND_FILE.Log,'Calling Netting API');

275: END IF;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278:
279: FND_FILE.Put_Line(FND_FILE.Log,'Calling Netting API');
280:
281: -- Netting
282: FUN_VENDORMERGE_GRP.Merge_Vendor(
283: p_api_version => 1.0

Line 307: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

303: p_encoded => 'F',
304: p_data => l_msg_data,
305: p_msg_index_out => l_msg_index_out
306: );
307: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
308: End LOOP;
309: END IF;
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;

Line 313: FND_FILE.Put_Line(FND_FILE.Log,'Calling iRecruitment API');

309: END IF;
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: FND_FILE.Put_Line(FND_FILE.Log,'Calling iRecruitment API');
314:
315: -- iRecruitment
316: IRC_VENDORMERGE_GRP.Merge_Vendor(
317: p_api_version => 1.0

Line 345: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

341: p_encoded => 'F',
342: p_data => l_msg_data,
343: p_msg_index_out => l_msg_index_out
344: );
345: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
346: End LOOP;
347: END IF;
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;

Line 352: FND_FILE.Put_Line(FND_FILE.Log,'Calling OKL API');

348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: -- Bug 6018743. Added the call to Oracle Loans API.
352: FND_FILE.Put_Line(FND_FILE.Log,'Calling OKL API');
353:
354: --Oracle Loans
355: OKL_VENDORMERGE_GRP.Merge_Vendor(
356: p_api_version => 1.0

Line 384: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

380: p_encoded => 'F',
381: p_data => l_msg_data,
382: p_msg_index_out => l_msg_index_out
383: );
384: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
385: End LOOP;
386: END IF;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;

Line 393: FND_FILE.Put_Line(FND_FILE.Log,'Calling DPP API');

389: -- Bug 6018743 ends.
390:
391: -- Bug6679421 . Added the call to Oracle Price Protection (DPP) API.
392:
393: FND_FILE.Put_Line(FND_FILE.Log,'Calling DPP API');
394:
395: DPP_VENDORMERGE_GRP.Merge_Vendor(
396: p_api_version => 1.0
397: , p_init_msg_list => FND_API.G_FALSE

Line 424: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

420: p_encoded => 'F',
421: p_data => l_msg_data,
422: p_msg_index_out => l_msg_index_out
423: );
424: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
425: End LOOP;
426: END IF;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;

Line 431: FND_FILE.Put_Line(FND_FILE.Log,'Invoices: Complete');

427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: --Bug6679421 ends.
430:
431: FND_FILE.Put_Line(FND_FILE.Log,'Invoices: Complete');
432:
433: END LOOP;
434: CLOSE Invoice_Cursor;
435: --

Line 458: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling WSH API');

454: AND org_id = l_po_row.C_ORG_ID; --Bug#7307532
455:
456: END IF;
457:
458: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling WSH API');
459:
460: -- Call WSH API
461: WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Party_Merge(
462: P_From_Vendor_Id => l_PO_Row.C_Dup_Vendor_ID,

Line 487: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

483: p_encoded => 'F',
484: p_data => l_msg_data,
485: p_msg_index_out => l_msg_index_out
486: );
487: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
488: End LOOP;
489: END IF;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;

Line 493: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling MRP API');

489: END IF;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492:
493: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling MRP API');
494:
495: -- MRP
496: MRP_VendorMerge_GRP.Merge_Vendor(
497: p_api_version => 1.0

Line 521: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

517: p_encoded => 'F',
518: p_data => l_msg_data,
519: p_msg_index_out => l_msg_index_out
520: );
521: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
522: END LOOP;
523: END IF;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;

Line 527: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Sourcing API');

523: END IF;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Sourcing API');
528:
529: -- Sourcing
530: PON_VENDORMERGE_GRP.Merge_Vendor(
531: p_api_version => 1.0

Line 559: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

555: p_encoded => 'F',
556: p_data => l_msg_data,
557: p_msg_index_out => l_msg_index_out
558: );
559: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
560: END LOOP;
561: END IF;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;

Line 565: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling iSP API');

561: END IF;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564:
565: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling iSP API');
566:
567: -- iSupplier Portal
568: POS_VENDORMERGE_GRP.merge_vendor (
569: p_api_version => 1.0,

Line 597: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

593: p_encoded => 'F',
594: p_data => l_msg_data,
595: p_msg_index_out => l_msg_index_out
596: );
597: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
598: END LOOP;
599: END IF;
600: RAISE FND_API.G_EXC_ERROR;
601: END IF;

Line 603: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Procurement API');

599: END IF;
600: RAISE FND_API.G_EXC_ERROR;
601: END IF;
602:
603: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Procurement API');
604:
605: -- Procurement
606: PO_VENDORMERGE_GRP.merge_vendor (
607: p_api_version => 1.0,

Line 635: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

631: p_encoded => 'F',
632: p_data => l_msg_data,
633: p_msg_index_out => l_msg_index_out
634: );
635: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
636: END LOOP;
637: END IF;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;

Line 641: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');

637: END IF;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');
642: -- Bug 7592393 Start. Call to update receiving tables
643: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Receiving API');
644:
645: -- Receiving

Line 643: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Receiving API');

639: END IF;
640:
641: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');
642: -- Bug 7592393 Start. Call to update receiving tables
643: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Receiving API');
644:
645: -- Receiving
646: RCV_UTILITIES.Merge_Vendor ( p_commit => fnd_api.g_false,
647: x_return_status => l_return_status,

Line 664: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);

660: p_encoded => 'F',
661: p_data => l_msg_data,
662: p_msg_index_out => l_msg_index_out
663: );
664: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
665: END LOOP;
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;

Line 724: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);

720: );
721: IF (SQLCODE <> -20001) THEN
722: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
724: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
725: END IF;
726:
727: IF Invoice_Cursor%ISOPEN THEN
728: CLOSE Invoice_Cursor;

Line 812: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');

808:
809:
810: BEGIN -- TCA_Contact_Merge Procedure begin
811:
812: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
813:
814: -- For loop to fetch all contacts one by one
815: FOR contact_loop_c IN
816: ( SELECT vendor_contact_id, per_party_id, org_party_site_id, org_contact_id, party_site_id

Line 853: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');

849: l_org_contact_rec.party_rel_rec := l_relationship_rec;
850:
851: hz_party_contact_v2pub.create_org_contact('T', l_org_contact_rec, l_org_contact_id,l_relationship_id,l_party_id,l_party_number,x_return_status,x_msg_count,x_msg_data);
852:
853: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');
854:
855: ELSE
856: hz_relationship_v2pub.create_relationship('T',l_relationship_rec,l_relationship_id,l_party_id,l_party_number,x_return_status,x_msg_count,x_msg_data);
857:

Line 858: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');

854:
855: ELSE
856: hz_relationship_v2pub.create_relationship('T',l_relationship_rec,l_relationship_id,l_party_id,l_party_number,x_return_status,x_msg_count,x_msg_data);
857:
858: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');
859: END IF;
860:
861: select location_id
862: into l_location_id

Line 888: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');

884: x_msg_data => x_msg_data,
885: x_party_site_id => l_party_site_id,
886: x_party_site_number => l_party_site_number);
887:
888: FND_FILE.Put_Line(FND_FILE.Log,'call hz_party_contact_v2pub.create_org_contact');
889:
890: -- For loop to fetch all contact points belong to above contacts (Email-Ids and Phone numbers)
891: FOR contact_point_loop_c IN c_contact_point(p_from_per_party_id)
892: LOOP

Line 966: FND_FILE.Put_Line(FND_FILE.Log,'call hz_contact_point_v2pub.create_contact_point');

962:
963: -- Creation of new contact points with new party_id
964: hz_contact_point_v2pub.create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,x_return_status,x_msg_count,x_msg_data);
965:
966: FND_FILE.Put_Line(FND_FILE.Log,'call hz_contact_point_v2pub.create_contact_point');
967:
968: END LOOP;
969:
970:

Line 986: FND_FILE.Put_Line(FND_FILE.Log,x_msg_data);

982: p_encoded => 'F',
983: p_data => x_msg_data,
984: p_msg_index_out => l_msg_index_out
985: );
986: FND_FILE.Put_Line(FND_FILE.Log,x_msg_data);
987: END LOOP;
988: END IF;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;

Line 992: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');

988: END IF;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
993:
994: END LOOP;
995:
996: COMMIT;

Line 1003: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);

999: WHEN OTHERS THEN
1000: IF (SQLCODE <> -20001) THEN
1001: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1002: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1003: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
1004: END IF;
1005:
1006: -- Bug 7297864- End
1007: