eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on FND_FILE

Line 177: FND_FILE.Put_Line(FND_FILE.Log,'Calling IBY API - Start');

173: END IF;
174:
175: /*Changes for bug 9551257 Start */
176:
177: FND_FILE.Put_Line(FND_FILE.Log,'Calling IBY API - Start');
178:
179: SELECT count(apps.vendor_site_id)
180: INTO l_active_site_count
181: FROM ap_suppliers aps, ap_supplier_sites_all apps

Line 194: FND_FILE.Put_Line(FND_FILE.Log,'In IBY merge call, p_last_site_flag:'||p_last_site_flag);

190: ELSE
191: p_last_site_flag := 'Y';
192: END IF;
193:
194: FND_FILE.Put_Line(FND_FILE.Log,'In IBY merge call, p_last_site_flag:'||p_last_site_flag);
195:
196: IBY_SUPP_BANK_MERGE_PUB.BANK_ACCOUNTS_MERGE(
197: P_from_vendor_id => l_invoice_row.C_DUP_VENDOR_ID,
198: P_to_vendor_id => l_invoice_row.C_VENDOR_ID,

Line 216: FND_FILE.Put_Line(FND_FILE.Log,'In IBY merge call, l_return_status:'||l_return_status);

212: X_msg_count => l_msg_count,
213: X_msg_data => l_msg_data
214: );
215:
216: FND_FILE.Put_Line(FND_FILE.Log,'In IBY merge call, l_return_status:'||l_return_status);
217:
218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219: --
220: --

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

226: p_encoded => 'F',
227: p_data => l_msg_data,
228: p_msg_index_out => l_msg_index_out
229: );
230: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
231: End LOOP;
232: END IF;
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;

Line 240: FND_FILE.Put_Line(FND_FILE.Log,'Calling XLA API - Start');

236: /*Changes for bug 9551257 End */
237:
238: /* Changes introduced for bug 9501188 - Start */
239:
240: FND_FILE.Put_Line(FND_FILE.Log,'Calling XLA API - Start');
241:
242: BEGIN
243: SELECT set_of_books_id into l_xla_ledger_id
244: FROM ap_system_parameters_all

Line 248: FND_FILE.Put_Line(FND_FILE.Log,'Fetching the ledge_id: '||l_xla_ledger_id||' and org_id:'||l_invoice_row.C_ORG_ID);

244: FROM ap_system_parameters_all
245: WHERE org_id = l_invoice_row.C_ORG_ID
246: and rownum = 1;
247:
248: FND_FILE.Put_Line(FND_FILE.Log,'Fetching the ledge_id: '||l_xla_ledger_id||' and org_id:'||l_invoice_row.C_ORG_ID);
249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: FND_FILE.Put_Line(FND_FILE.Log,' Error fetching set of book id');

Line 252: FND_FILE.Put_Line(FND_FILE.Log,' Error fetching set of book id');

248: FND_FILE.Put_Line(FND_FILE.Log,'Fetching the ledge_id: '||l_xla_ledger_id||' and org_id:'||l_invoice_row.C_ORG_ID);
249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: FND_FILE.Put_Line(FND_FILE.Log,' Error fetching set of book id');
253: RAISE FND_API.G_EXC_ERROR;
254: END;
255:
256: BEGIN

Line 264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);

260: WHEN OTHERS THEN
261: l_count_xla_gt := 0;
262: END;
263:
264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);
265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');
266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);

Line 265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');

261: l_count_xla_gt := 0;
262: END;
263:
264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);
265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');
266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);
269:

Line 266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');

262: END;
263:
264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);
265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');
266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);
269:
270: FND_FILE.Put_Line(FND_FILE.Log,'Before call to xla_third_party_merge_pub.third_party_merge...');

Line 267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);

263:
264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);
265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');
266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);
269:
270: FND_FILE.Put_Line(FND_FILE.Log,'Before call to xla_third_party_merge_pub.third_party_merge...');
271:

Line 268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);

264: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_count_xla_gt:'||l_count_xla_gt);
265: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_ID:'||l_invoice_row.C_DUP_VENDOR_ID||':');
266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);
269:
270: FND_FILE.Put_Line(FND_FILE.Log,'Before call to xla_third_party_merge_pub.third_party_merge...');
271:
272: If (nvl(l_count_xla_gt,0) <> 0) then

Line 270: FND_FILE.Put_Line(FND_FILE.Log,'Before call to xla_third_party_merge_pub.third_party_merge...');

266: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_DUP_VENDOR_SITE_ID:'||l_invoice_row.C_DUP_VENDOR_SITE_ID||':');
267: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_ID:'||l_invoice_row.C_VENDOR_ID);
268: FND_FILE.Put_Line(FND_FILE.Log,'third_party_merge l_invoice_row.C_VENDOR_SITE_ID:'||l_invoice_row.C_VENDOR_SITE_ID);
269:
270: FND_FILE.Put_Line(FND_FILE.Log,'Before call to xla_third_party_merge_pub.third_party_merge...');
271:
272: If (nvl(l_count_xla_gt,0) <> 0) then
273: xla_third_party_merge_pub.third_party_merge (x_errbuf => l_xla_errbuf,
274: x_retcode => l_xla_retcode,

Line 293: FND_FILE.Put_Line(FND_FILE.Log, 'Call after procedure xla_third_party_merge_pub.third_party_merge:'||l_xla_retcode);

289: p_transfer_to_gl_flag => 'Y',
290: p_post_in_gl_flag => 'N'
291: );
292:
293: FND_FILE.Put_Line(FND_FILE.Log, 'Call after procedure xla_third_party_merge_pub.third_party_merge:'||l_xla_retcode);
294: IF l_xla_retcode <> 'S' then
295:
296: FND_FILE.Put_Line(FND_FILE.Log, 'Error on procedure call xla_third_party_merge_pub.third_party_merge call:'||l_xla_retcode);
297: IF l_xla_errbuf IS NOT NULL THEN

Line 296: FND_FILE.Put_Line(FND_FILE.Log, 'Error on procedure call xla_third_party_merge_pub.third_party_merge call:'||l_xla_retcode);

292:
293: FND_FILE.Put_Line(FND_FILE.Log, 'Call after procedure xla_third_party_merge_pub.third_party_merge:'||l_xla_retcode);
294: IF l_xla_retcode <> 'S' then
295:
296: FND_FILE.Put_Line(FND_FILE.Log, 'Error on procedure call xla_third_party_merge_pub.third_party_merge call:'||l_xla_retcode);
297: IF l_xla_errbuf IS NOT NULL THEN
298: FND_FILE.PUT_LINE(FND_FILE.Log,'Error buffer l_xla_errbuf:'||l_xla_errbuf);
299: END IF;
300: RAISE FND_API.G_EXC_ERROR;

Line 298: FND_FILE.PUT_LINE(FND_FILE.Log,'Error buffer l_xla_errbuf:'||l_xla_errbuf);

294: IF l_xla_retcode <> 'S' then
295:
296: FND_FILE.Put_Line(FND_FILE.Log, 'Error on procedure call xla_third_party_merge_pub.third_party_merge call:'||l_xla_retcode);
297: IF l_xla_errbuf IS NOT NULL THEN
298: FND_FILE.PUT_LINE(FND_FILE.Log,'Error buffer l_xla_errbuf:'||l_xla_errbuf);
299: END IF;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:

Line 315: FND_FILE.Put_Line(FND_FILE.Log, 'Deleting the record of xla_events_gt');

311: END LOOP;
312:
313: DELETE FROM xla_events_gt;
314:
315: FND_FILE.Put_Line(FND_FILE.Log, 'Deleting the record of xla_events_gt');
316:
317: FND_FILE.Put_Line(FND_FILE.Log,'Calling XLA API - End');
318:
319: End if;

Line 317: FND_FILE.Put_Line(FND_FILE.Log,'Calling XLA API - End');

313: DELETE FROM xla_events_gt;
314:
315: FND_FILE.Put_Line(FND_FILE.Log, 'Deleting the record of xla_events_gt');
316:
317: FND_FILE.Put_Line(FND_FILE.Log,'Calling XLA API - End');
318:
319: End if;
320: /* Changes introduced for bug 9501188 - End */
321:

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

319: End if;
320: /* Changes introduced for bug 9501188 - End */
321:
322:
323: FND_FILE.Put_Line(FND_FILE.Log,'Calling WSH API');
324:
325: -- Call WSH API
326: WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Party_Merge(
327: p_from_vendor_id => l_invoice_row.C_Dup_Vendor_Id,

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

349: p_encoded => 'F',
350: p_data => l_msg_data,
351: p_msg_index_out => l_msg_index_out
352: );
353: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
354: End LOOP;
355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;

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

355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
359: FND_FILE.Put_Line(FND_FILE.Log,'Calling Fixed Assets API');
360:
361: -- Fixed Assets
362: FA_VendorMerge_GRP.Merge_Vendor(
363: p_api_version => 1.0

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

390: p_encoded => 'F',
391: p_data => l_msg_data,
392: p_msg_index_out => l_msg_index_out
393: );
394: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
395: End LOOP;
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;

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

396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399:
400: FND_FILE.Put_Line(FND_FILE.Log,'Calling Trade Management API');
401:
402: -- Trade Management
403: OZF_VENDORMERGE_GRP.Merge_Vendor(
404: p_api_version => 1.0

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

428: p_encoded => 'F',
429: p_data => l_msg_data,
430: p_msg_index_out => l_msg_index_out
431: );
432: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
433: End LOOP;
434: END IF;
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;

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

434: END IF;
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
438: FND_FILE.Put_Line(FND_FILE.Log,'Calling CMRO API');
439:
440: -- Complex Maintenance Repair and Overhaul
441: AHL_VENDORMERGE_GRP.Merge_Vendor(
442: p_api_version => 1.0

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

466: p_encoded => 'F',
467: p_data => l_msg_data,
468: p_msg_index_out => l_msg_index_out
469: );
470: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
471: End LOOP;
472: END IF;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;

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

472: END IF;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: FND_FILE.Put_Line(FND_FILE.Log,'Calling Netting API');
477:
478: -- Netting
479: FUN_VENDORMERGE_GRP.Merge_Vendor(
480: p_api_version => 1.0

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

500: p_encoded => 'F',
501: p_data => l_msg_data,
502: p_msg_index_out => l_msg_index_out
503: );
504: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
505: End LOOP;
506: END IF;
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;

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

506: END IF;
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509:
510: FND_FILE.Put_Line(FND_FILE.Log,'Calling iRecruitment API');
511:
512: -- iRecruitment
513: IRC_VENDORMERGE_GRP.Merge_Vendor(
514: p_api_version => 1.0

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

538: p_encoded => 'F',
539: p_data => l_msg_data,
540: p_msg_index_out => l_msg_index_out
541: );
542: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
543: End LOOP;
544: END IF;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;

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

545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547:
548: -- Bug 6018743. Added the call to Oracle Loans API.
549: FND_FILE.Put_Line(FND_FILE.Log,'Calling OKL API');
550:
551: --Oracle Loans
552: OKL_VENDORMERGE_GRP.Merge_Vendor(
553: p_api_version => 1.0

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

577: p_encoded => 'F',
578: p_data => l_msg_data,
579: p_msg_index_out => l_msg_index_out
580: );
581: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
582: End LOOP;
583: END IF;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;

Line 590: FND_FILE.Put_Line(FND_FILE.Log,'Calling JL API');

586: -- Bug 6018743 ends.
587:
588: /* Bug 9677677 Start - Localization */
589:
590: FND_FILE.Put_Line(FND_FILE.Log,'Calling JL API');
591:
592: JL_VENDORMERGE_GRP.Merge_Vendor(
593: p_api_version => 1.0
594: , p_init_msg_list => FND_API.G_FALSE

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

618: p_encoded => 'F',
619: p_data => l_msg_data,
620: p_msg_index_out => l_msg_index_out
621: );
622: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
623: End LOOP;
624: END IF;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;

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

625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627: /* Bug 9677677 End - Localization */
628:
629: FND_FILE.Put_Line(FND_FILE.Log,'Invoices: Complete');
630:
631: END LOOP;
632: CLOSE Invoice_Cursor;
633: --

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

652: AND org_id = l_po_row.C_ORG_ID; --Bug#7307532
653:
654: END IF;
655:
656: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling WSH API');
657:
658: -- Call WSH API
659: WSH_VENDOR_PARTY_MERGE_PKG.Vendor_Party_Merge(
660: P_From_Vendor_Id => l_PO_Row.C_Dup_Vendor_ID,

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

681: p_encoded => 'F',
682: p_data => l_msg_data,
683: p_msg_index_out => l_msg_index_out
684: );
685: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
686: End LOOP;
687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
689: END IF;

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

687: END IF;
688: RAISE FND_API.G_EXC_ERROR;
689: END IF;
690:
691: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling MRP API');
692:
693: -- MRP
694: MRP_VendorMerge_GRP.Merge_Vendor(
695: p_api_version => 1.0

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

715: p_encoded => 'F',
716: p_data => l_msg_data,
717: p_msg_index_out => l_msg_index_out
718: );
719: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
720: END LOOP;
721: END IF;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;

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

721: END IF;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Sourcing API');
726:
727: -- Sourcing
728: PON_VENDORMERGE_GRP.Merge_Vendor(
729: p_api_version => 1.0

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

753: p_encoded => 'F',
754: p_data => l_msg_data,
755: p_msg_index_out => l_msg_index_out
756: );
757: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
758: END LOOP;
759: END IF;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;

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

759: END IF;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762:
763: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling iSP API');
764:
765: -- iSupplier Portal
766: POS_VENDORMERGE_GRP.merge_vendor (
767: p_api_version => 1.0,

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

791: p_encoded => 'F',
792: p_data => l_msg_data,
793: p_msg_index_out => l_msg_index_out
794: );
795: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
796: END LOOP;
797: END IF;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;

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

797: END IF;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:
801: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Procurement API');
802:
803: -- Procurement
804: PO_VENDORMERGE_GRP.merge_vendor (
805: p_api_version => 1.0,

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

829: p_encoded => 'F',
830: p_data => l_msg_data,
831: p_msg_index_out => l_msg_index_out
832: );
833: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
834: END LOOP;
835: END IF;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;

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

835: END IF;
836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');
840: -- Bug 7592393 Start. Call to update receiving tables
841: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Receiving API');
842:
843: -- Receiving

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

837: END IF;
838:
839: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');
840: -- Bug 7592393 Start. Call to update receiving tables
841: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Receiving API');
842:
843: -- Receiving
844: RCV_UTILITIES.Merge_Vendor ( p_commit => fnd_api.g_false,
845: x_return_status => l_return_status,

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

858: p_encoded => 'F',
859: p_data => l_msg_data,
860: p_msg_index_out => l_msg_index_out
861: );
862: FND_FILE.Put_Line(FND_FILE.Log,l_msg_data);
863: END LOOP;
864: END IF;
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;

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

918: );
919: IF (SQLCODE <> -20001) THEN
920: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
921: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
922: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
923: END IF;
924:
925: IF Invoice_Cursor%ISOPEN THEN
926: CLOSE Invoice_Cursor;

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

1009:
1010:
1011: BEGIN -- TCA_Contact_Merge Procedure begin
1012:
1013: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
1014:
1015: -- For loop to fetch all contacts one by one
1016: FOR contact_loop_c IN ( SELECT vendor_contact_id,
1017: per_party_id,

Line 1026: FND_FILE.Put_Line(FND_FILE.Log,'Inside the loop of merge vendor_contact :'|| contact_loop_c.vendor_contact_id);

1022: WHERE org_party_site_id = p_from_party_site_id
1023: )
1024: LOOP
1025:
1026: FND_FILE.Put_Line(FND_FILE.Log,'Inside the loop of merge vendor_contact :'|| contact_loop_c.vendor_contact_id);
1027:
1028: --Initialization of new relationship rec - relationship between 'To Party' and 'Contact'
1029: l_relationship_rec.subject_id := contact_loop_c.per_party_id;
1030: l_relationship_rec.subject_type := 'PERSON';

Line 1091: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause contact_loop_c.org_contact_id is not null');

1087: IF l_relationship_id IS NULL
1088: AND l_org_contact_id IS NULL
1089: AND contact_loop_c.org_contact_id IS NOT NULL THEN
1090:
1091: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause contact_loop_c.org_contact_id is not null');
1092:
1093: SELECT comments,
1094: contact_number,
1095: department_code,

Line 1119: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause before calling hz_party_contact_v2pub.create_org_contact');

1115:
1116: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';
1117: l_org_contact_rec.party_rel_rec := l_relationship_rec;
1118:
1119: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause before calling hz_party_contact_v2pub.create_org_contact');
1120:
1121: hz_party_contact_v2pub.Create_org_contact('T',l_org_contact_rec,l_org_contact_id,l_relationship_id,
1122: l_party_id,l_party_number,x_return_status,
1123: x_msg_count,x_msg_data);

Line 1125: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause after calling hz_party_contact_v2pub.create_org_contact');

1121: hz_party_contact_v2pub.Create_org_contact('T',l_org_contact_rec,l_org_contact_id,l_relationship_id,
1122: l_party_id,l_party_number,x_return_status,
1123: x_msg_count,x_msg_data);
1124:
1125: FND_FILE.Put_Line(FND_FILE.Log,'Inside if clause after calling hz_party_contact_v2pub.create_org_contact');
1126:
1127: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1128: IF x_msg_count > 0 THEN
1129: FOR i IN 1.. fnd_msg_pub.count_msg LOOP

Line 1133: FND_FILE.Put_Line(FND_FILE.Log,x_msg_data||' for Vendor contact : '||contact_loop_c.vendor_contact_id);

1129: FOR i IN 1.. fnd_msg_pub.count_msg LOOP
1130: fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F',p_data => x_msg_data,
1131: p_msg_index_out => l_msg_index_out);
1132:
1133: FND_FILE.Put_Line(FND_FILE.Log,x_msg_data||' for Vendor contact : '||contact_loop_c.vendor_contact_id);
1134: END LOOP;
1135: END IF;
1136: RAISE fnd_api.g_exc_error;
1137: END IF;

Line 1143: FND_FILE.Put_Line(FND_FILE.Log,'Inside else clause before calling hz_relationship_v2pub.create_relationship');

1139: ELSIF l_relationship_id IS NULL
1140: AND l_org_contact_id IS NULL
1141: AND contact_loop_c.org_contact_id IS NULL THEN
1142:
1143: FND_FILE.Put_Line(FND_FILE.Log,'Inside else clause before calling hz_relationship_v2pub.create_relationship');
1144:
1145: hz_relationship_v2pub.Create_relationship('T',l_relationship_rec,l_relationship_id,
1146: l_party_id,l_party_number,x_return_status,
1147: x_msg_count,x_msg_data);

Line 1149: FND_FILE.Put_Line(FND_FILE.Log,'Inside else clause after calling hz_relationship_v2pub.create_relationship');

1145: hz_relationship_v2pub.Create_relationship('T',l_relationship_rec,l_relationship_id,
1146: l_party_id,l_party_number,x_return_status,
1147: x_msg_count,x_msg_data);
1148:
1149: FND_FILE.Put_Line(FND_FILE.Log,'Inside else clause after calling hz_relationship_v2pub.create_relationship');
1150:
1151: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1152: IF x_msg_count > 0 THEN
1153: FOR i IN 1.. fnd_msg_pub.count_msg LOOP

Line 1157: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);

1153: FOR i IN 1.. fnd_msg_pub.count_msg LOOP
1154: fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F',p_data => x_msg_data,
1155: p_msg_index_out => l_msg_index_out);
1156:
1157: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);
1158: END LOOP;
1159: END IF;
1160: RAISE fnd_api.g_exc_error;
1161: END IF;

Line 1195: FND_FILE.Put_Line(FND_FILE.Log,'Inside loop before calling hz_party_site_v2pub.create_party_site');

1191: INTO l_party_site_rec.party_site_number
1192: FROM dual;
1193: END IF;
1194:
1195: FND_FILE.Put_Line(FND_FILE.Log,'Inside loop before calling hz_party_site_v2pub.create_party_site');
1196:
1197: -- Create party_site between l_location_id and new party_id - l_party_id
1198: hz_party_site_v2pub.Create_party_site('T',p_party_site_rec => l_party_site_rec,
1199: x_return_status => x_return_status,x_msg_count => x_msg_count,

Line 1209: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);

1205: FOR i IN 1.. fnd_msg_pub.count_msg LOOP
1206: fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F',p_data => x_msg_data,
1207: p_msg_index_out => l_msg_index_out);
1208:
1209: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);
1210: END LOOP;
1211: END IF;
1212:
1213: RAISE fnd_api.g_exc_error;

Line 1216: FND_FILE.Put_Line(FND_FILE.Log,'Inside loop after calling hz_party_site_v2pub.create_party_site');

1212:
1213: RAISE fnd_api.g_exc_error;
1214: END IF;
1215:
1216: FND_FILE.Put_Line(FND_FILE.Log,'Inside loop after calling hz_party_site_v2pub.create_party_site');
1217:
1218: END IF;
1219:
1220: BEGIN

Line 1232: FND_FILE.Put_Line(FND_FILE.Log,'inside second loop');

1228: EXCEPTION
1229: WHEN no_data_found THEN
1230: -- For loop to fetch all contact points belong to above contacts (Email-Ids and Phone numbers)
1231: FOR contact_point_loop_c IN c_contact_point(p_from_per_party_id, contact_loop_c.per_party_id) LOOP /* Bug 9604355 */
1232: FND_FILE.Put_Line(FND_FILE.Log,'inside second loop');
1233: BEGIN
1234: -- Fetching contact point details
1235: SELECT contact_point_type,
1236: status,

Line 1305: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);

1301: -- Creation of new contact points with new party_id
1302: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1303: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,
1304: x_return_status,x_msg_count,x_msg_data);
1305: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);
1306:
1307: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1308: IF x_msg_count > 0 THEN
1309: FOR i IN 1.. fnd_msg_pub.count_msg LOOP

Line 1312: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);

1308: IF x_msg_count > 0 THEN
1309: FOR i IN 1.. fnd_msg_pub.count_msg LOOP
1310: fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F',p_data => x_msg_data,
1311: p_msg_index_out => l_msg_index_out);
1312: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);
1313: END LOOP;
1314: END IF;
1315:
1316: RAISE fnd_api.g_exc_error;

Line 1318: FND_FILE.Put_Line(FND_FILE.Log,'end of second loop');

1314: END IF;
1315:
1316: RAISE fnd_api.g_exc_error;
1317: END IF;
1318: FND_FILE.Put_Line(FND_FILE.Log,'end of second loop');
1319: EXCEPTION
1320: WHEN no_data_found THEN
1321: NULL;
1322: END;

Line 1326: FND_FILE.Put_Line(FND_FILE.Log,'before creating ap_supplier_contacts');

1322: END;
1323: END LOOP;
1324:
1325: END;
1326: FND_FILE.Put_Line(FND_FILE.Log,'before creating ap_supplier_contacts');
1327: FND_FILE.Put_Line(FND_FILE.Log,'contact_loop_c.vendor_contact_id '
1328: ||contact_loop_c.vendor_contact_id);
1329:
1330: BEGIN

Line 1327: FND_FILE.Put_Line(FND_FILE.Log,'contact_loop_c.vendor_contact_id '

1323: END LOOP;
1324:
1325: END;
1326: FND_FILE.Put_Line(FND_FILE.Log,'before creating ap_supplier_contacts');
1327: FND_FILE.Put_Line(FND_FILE.Log,'contact_loop_c.vendor_contact_id '
1328: ||contact_loop_c.vendor_contact_id);
1329:
1330: BEGIN
1331: /* Bug 9559145 -- commenting below and writing new insert statement*/

Line 1347: FND_FILE.Put_Line(FND_FILE.Log,'creating new contact for to_party');

1343: -- program_application_id = FND_GLOBAL.prog_appl_id,
1344: -- program_id = FND_GLOBAL.conc_program_id
1345: --WHERE vendor_contact_id = contact_loop_c.vendor_contact_id;
1346:
1347: FND_FILE.Put_Line(FND_FILE.Log,'creating new contact for to_party');
1348:
1349: INSERT INTO AP_SUPPLIER_CONTACTS
1350: ( VENDOR_CONTACT_ID,
1351: LAST_UPDATE_DATE,

Line 1458: FND_FILE.Put_Line(FND_FILE.Log,'No.of rows inserted '||SQL%ROWCOUNT);

1454: p_to_party_site_id
1455: FROM AP_SUPPLIER_CONTACTS
1456: WHERE vendor_contact_id = contact_loop_c.vendor_contact_id;
1457:
1458: FND_FILE.Put_Line(FND_FILE.Log,'No.of rows inserted '||SQL%ROWCOUNT);
1459:
1460: l_org_contact_id := NULL; --Bug9899876
1461:
1462: EXCEPTION

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

1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1465: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1466: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
1467: RAISE fnd_api.g_exc_error;
1468: END;
1469: ELSE
1470: FND_FILE.Put_Line(FND_FILE.Log,'Vendor contact already exists with same info ID : '

Line 1470: FND_FILE.Put_Line(FND_FILE.Log,'Vendor contact already exists with same info ID : '

1466: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
1467: RAISE fnd_api.g_exc_error;
1468: END;
1469: ELSE
1470: FND_FILE.Put_Line(FND_FILE.Log,'Vendor contact already exists with same info ID : '
1471: || l_new_vendor_contact_id);
1472: END IF;
1473: END LOOP;
1474:

Line 1484: FND_FILE.Put_Line(FND_FILE.Log,'inside party site contact points oop');

1480: FROM hz_contact_points
1481: WHERE owner_table_name = 'HZ_PARTY_SITES'
1482: AND owner_table_id = p_from_party_site_id
1483: ) LOOP
1484: FND_FILE.Put_Line(FND_FILE.Log,'inside party site contact points oop');
1485: BEGIN
1486: -- Fetching contact point details
1487: SELECT contact_point_type,
1488: status,

Line 1557: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);

1553: -- Creation of new contact points with new party_site_id
1554: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1555: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,
1556: x_return_status,x_msg_count,x_msg_data);
1557: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);
1558:
1559: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1560: IF x_msg_count > 0 THEN
1561: FOR i IN 1.. fnd_msg_pub.count_msg LOOP

Line 1564: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);

1560: IF x_msg_count > 0 THEN
1561: FOR i IN 1.. fnd_msg_pub.count_msg LOOP
1562: fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F',p_data => x_msg_data,
1563: p_msg_index_out => l_msg_index_out);
1564: FND_FILE.Put_Line(FND_FILE.Log,'Error : '||x_msg_data);
1565: END LOOP;
1566: END IF;
1567:
1568: RAISE fnd_api.g_exc_error;

Line 1570: FND_FILE.Put_Line(FND_FILE.Log,'end of party site contact points loop');

1566: END IF;
1567:
1568: RAISE fnd_api.g_exc_error;
1569: END IF;
1570: FND_FILE.Put_Line(FND_FILE.Log,'end of party site contact points loop');
1571: EXCEPTION
1572: WHEN no_data_found THEN
1573: NULL;
1574: END;

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

1576:
1577: END IF;
1578: --bug12571995 end
1579:
1580: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
1581:
1582: EXCEPTION
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: FND_MSG_PUB.Count_And_Get

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

1619: );
1620: IF (SQLCODE <> -20001) THEN
1621: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1622: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1623: FND_FILE.Put_Line(FND_FILE.Log,sqlerrm);
1624: END IF;
1625:
1626: IF c_contact_point%ISOPEN THEN
1627: CLOSE c_contact_point;