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.

[Home] [Help]

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on FND_API

Line 218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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: --
221: IF l_msg_count > 0 THEN
222: --

Line 233: RAISE FND_API.G_EXC_ERROR;

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;
235:
236: /*Changes for bug 9551257 End */
237:

Line 253: RAISE FND_API.G_EXC_ERROR;

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
257: select count(1) into l_count_xla_gt from xla_events_gt;

Line 300: RAISE FND_API.G_EXC_ERROR;

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:
303: FOR i IN l_xla_event_ids.FIRST .. l_xla_event_ids.LAST
304: LOOP

Line 341: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

337: x_msg_count => l_msg_count,
338: x_msg_data => l_msg_data);
339:
340:
341: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
342: --
343: --
344: IF l_msg_count > 0 THEN
345: --

Line 356: RAISE FND_API.G_EXC_ERROR;

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;
358:
359: FND_FILE.Put_Line(FND_FILE.Log,'Calling Fixed Assets API');
360:

Line 364: , p_init_msg_list => FND_API.G_FALSE

360:
361: -- Fixed Assets
362: FA_VendorMerge_GRP.Merge_Vendor(
363: p_api_version => 1.0
364: , p_init_msg_list => FND_API.G_FALSE
365: , p_commit => FND_API.G_FALSE
366: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
367: , x_return_status => l_return_status
368: , x_msg_count => l_msg_count

Line 365: , p_commit => FND_API.G_FALSE

361: -- Fixed Assets
362: FA_VendorMerge_GRP.Merge_Vendor(
363: p_api_version => 1.0
364: , p_init_msg_list => FND_API.G_FALSE
365: , p_commit => FND_API.G_FALSE
366: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
367: , x_return_status => l_return_status
368: , x_msg_count => l_msg_count
369: , x_msg_data => l_msg_data

Line 366: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

362: FA_VendorMerge_GRP.Merge_Vendor(
363: p_api_version => 1.0
364: , p_init_msg_list => FND_API.G_FALSE
365: , p_commit => FND_API.G_FALSE
366: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
367: , x_return_status => l_return_status
368: , x_msg_count => l_msg_count
369: , x_msg_data => l_msg_data
370: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

378: , p_segment1 => l_invoice_row.C_New_Vendor_Number
379: , p_dup_segment1 => l_invoice_row.C_Old_Vendor_Number
380: , p_vendor_name => l_invoice_row.C_Vendor_Name);
381:
382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: --
384: --
385: IF l_msg_count > 0 THEN
386: --

Line 397: RAISE FND_API.G_EXC_ERROR;

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;
399:
400: FND_FILE.Put_Line(FND_FILE.Log,'Calling Trade Management API');
401:

Line 405: , p_init_msg_list => FND_API.G_FALSE

401:
402: -- Trade Management
403: OZF_VENDORMERGE_GRP.Merge_Vendor(
404: p_api_version => 1.0
405: , p_init_msg_list => FND_API.G_FALSE
406: , p_commit => FND_API.G_FALSE
407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
408: , p_return_status => l_return_status
409: , p_msg_count => l_msg_count

Line 406: , p_commit => FND_API.G_FALSE

402: -- Trade Management
403: OZF_VENDORMERGE_GRP.Merge_Vendor(
404: p_api_version => 1.0
405: , p_init_msg_list => FND_API.G_FALSE
406: , p_commit => FND_API.G_FALSE
407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
408: , p_return_status => l_return_status
409: , p_msg_count => l_msg_count
410: , p_msg_data => l_msg_data

Line 407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

403: OZF_VENDORMERGE_GRP.Merge_Vendor(
404: p_api_version => 1.0
405: , p_init_msg_list => FND_API.G_FALSE
406: , p_commit => FND_API.G_FALSE
407: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
408: , p_return_status => l_return_status
409: , p_msg_count => l_msg_count
410: , p_msg_data => l_msg_data
411: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

416: , p_dup_party_id => l_invoice_row.C_Dup_Party_Id
417: , p_party_site_id => l_invoice_row.C_Party_Site_Id
418: , p_dup_party_site_id => l_invoice_row.C_Dup_Party_Site_Id);
419:
420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
421: --
422: --
423: IF l_msg_count > 0 THEN
424: --

Line 435: RAISE FND_API.G_EXC_ERROR;

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;
437:
438: FND_FILE.Put_Line(FND_FILE.Log,'Calling CMRO API');
439:

Line 443: , p_init_msg_list => FND_API.G_FALSE

439:
440: -- Complex Maintenance Repair and Overhaul
441: AHL_VENDORMERGE_GRP.Merge_Vendor(
442: p_api_version => 1.0
443: , p_init_msg_list => FND_API.G_FALSE
444: , p_commit => FND_API.G_FALSE
445: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
446: , x_return_status => l_return_status
447: , x_msg_count => l_msg_count

Line 444: , p_commit => FND_API.G_FALSE

440: -- Complex Maintenance Repair and Overhaul
441: AHL_VENDORMERGE_GRP.Merge_Vendor(
442: p_api_version => 1.0
443: , p_init_msg_list => FND_API.G_FALSE
444: , p_commit => FND_API.G_FALSE
445: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
446: , x_return_status => l_return_status
447: , x_msg_count => l_msg_count
448: , x_msg_data => l_msg_data

Line 445: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

441: AHL_VENDORMERGE_GRP.Merge_Vendor(
442: p_api_version => 1.0
443: , p_init_msg_list => FND_API.G_FALSE
444: , p_commit => FND_API.G_FALSE
445: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
446: , x_return_status => l_return_status
447: , x_msg_count => l_msg_count
448: , x_msg_data => l_msg_data
449: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

454: , p_dup_party_id => l_invoice_row.C_Dup_Party_Id
455: , p_party_site_id => l_invoice_row.C_Party_Site_Id
456: , p_dup_party_site_id => l_invoice_row.C_Dup_Party_Site_Id);
457:
458: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
459: --
460: --
461: IF l_msg_count > 0 THEN
462: --

Line 473: RAISE FND_API.G_EXC_ERROR;

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;
475:
476: FND_FILE.Put_Line(FND_FILE.Log,'Calling Netting API');
477:

Line 481: , p_init_msg_list => FND_API.G_FALSE

477:
478: -- Netting
479: FUN_VENDORMERGE_GRP.Merge_Vendor(
480: p_api_version => 1.0
481: , p_init_msg_list => FND_API.G_FALSE
482: , p_commit => FND_API.G_FALSE
483: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
484: , p_return_status => l_return_status
485: , p_msg_count => l_msg_count

Line 482: , p_commit => FND_API.G_FALSE

478: -- Netting
479: FUN_VENDORMERGE_GRP.Merge_Vendor(
480: p_api_version => 1.0
481: , p_init_msg_list => FND_API.G_FALSE
482: , p_commit => FND_API.G_FALSE
483: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
484: , p_return_status => l_return_status
485: , p_msg_count => l_msg_count
486: , p_msg_data => l_msg_data

Line 483: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

479: FUN_VENDORMERGE_GRP.Merge_Vendor(
480: p_api_version => 1.0
481: , p_init_msg_list => FND_API.G_FALSE
482: , p_commit => FND_API.G_FALSE
483: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
484: , p_return_status => l_return_status
485: , p_msg_count => l_msg_count
486: , p_msg_data => l_msg_data
487: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

488: , p_dup_vendor_id => l_invoice_row.C_Dup_Vendor_Id
489: , p_vendor_site_id => l_invoice_row.C_Vendor_Site_Id
490: , p_dup_vendor_site_id => l_invoice_row.C_Dup_Vendor_Site_Id);
491:
492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
493: --
494: --
495: IF l_msg_count > 0 THEN
496: --

Line 507: RAISE FND_API.G_EXC_ERROR;

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;
509:
510: FND_FILE.Put_Line(FND_FILE.Log,'Calling iRecruitment API');
511:

Line 515: , p_init_msg_list => FND_API.G_FALSE

511:
512: -- iRecruitment
513: IRC_VENDORMERGE_GRP.Merge_Vendor(
514: p_api_version => 1.0
515: , p_init_msg_list => FND_API.G_FALSE
516: , p_commit => FND_API.G_FALSE
517: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
518: , p_return_status => l_return_status
519: , p_msg_count => l_msg_count

Line 516: , p_commit => FND_API.G_FALSE

512: -- iRecruitment
513: IRC_VENDORMERGE_GRP.Merge_Vendor(
514: p_api_version => 1.0
515: , p_init_msg_list => FND_API.G_FALSE
516: , p_commit => FND_API.G_FALSE
517: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
518: , p_return_status => l_return_status
519: , p_msg_count => l_msg_count
520: , p_msg_data => l_msg_data

Line 517: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

513: IRC_VENDORMERGE_GRP.Merge_Vendor(
514: p_api_version => 1.0
515: , p_init_msg_list => FND_API.G_FALSE
516: , p_commit => FND_API.G_FALSE
517: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
518: , p_return_status => l_return_status
519: , p_msg_count => l_msg_count
520: , p_msg_data => l_msg_data
521: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

526: , p_dup_party_id => l_invoice_row.C_Dup_Party_Id
527: , p_party_site_id => l_invoice_row.C_Party_Site_Id
528: , p_dup_party_site_id => l_invoice_row.C_Dup_Party_Site_Id);
529:
530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
531: --
532: --
533: IF l_msg_count > 0 THEN
534: --

Line 545: RAISE FND_API.G_EXC_ERROR;

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;
547:
548: -- Bug 6018743. Added the call to Oracle Loans API.
549: FND_FILE.Put_Line(FND_FILE.Log,'Calling OKL API');

Line 554: , p_init_msg_list => FND_API.G_FALSE

550:
551: --Oracle Loans
552: OKL_VENDORMERGE_GRP.Merge_Vendor(
553: p_api_version => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_return_status => l_return_status
558: , p_msg_count => l_msg_count

Line 555: , p_commit => FND_API.G_FALSE

551: --Oracle Loans
552: OKL_VENDORMERGE_GRP.Merge_Vendor(
553: p_api_version => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_return_status => l_return_status
558: , p_msg_count => l_msg_count
559: , p_msg_data => l_msg_data

Line 556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

552: OKL_VENDORMERGE_GRP.Merge_Vendor(
553: p_api_version => 1.0
554: , p_init_msg_list => FND_API.G_FALSE
555: , p_commit => FND_API.G_FALSE
556: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
557: , p_return_status => l_return_status
558: , p_msg_count => l_msg_count
559: , p_msg_data => l_msg_data
560: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

565: , p_dup_party_id => l_invoice_row.C_Dup_Party_Id
566: , p_party_site_id => l_invoice_row.C_Party_Site_Id
567: , p_dup_party_site_id => l_invoice_row.C_Dup_Party_Site_Id);
568:
569: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
570: --
571: --
572: IF l_msg_count > 0 THEN
573: --

Line 584: RAISE FND_API.G_EXC_ERROR;

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;
586: -- Bug 6018743 ends.
587:
588: /* Bug 9677677 Start - Localization */

Line 594: , p_init_msg_list => FND_API.G_FALSE

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
595: , p_commit => FND_API.G_FALSE
596: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: , p_return_status => l_return_status
598: , p_msg_count => l_msg_count

Line 595: , p_commit => FND_API.G_FALSE

591:
592: JL_VENDORMERGE_GRP.Merge_Vendor(
593: p_api_version => 1.0
594: , p_init_msg_list => FND_API.G_FALSE
595: , p_commit => FND_API.G_FALSE
596: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: , p_return_status => l_return_status
598: , p_msg_count => l_msg_count
599: , p_msg_data => l_msg_data

Line 596: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

592: JL_VENDORMERGE_GRP.Merge_Vendor(
593: p_api_version => 1.0
594: , p_init_msg_list => FND_API.G_FALSE
595: , p_commit => FND_API.G_FALSE
596: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
597: , p_return_status => l_return_status
598: , p_msg_count => l_msg_count
599: , p_msg_data => l_msg_data
600: , p_vendor_id => l_invoice_row.C_Vendor_Id

Line 610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

606: , p_party_site_id => l_invoice_row.C_Party_Site_Id
607: , p_dup_party_site_id => l_invoice_row.C_Dup_Party_Site_Id
608: );
609:
610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
611: --
612: --
613: IF l_msg_count > 0 THEN
614: --

Line 625: RAISE FND_API.G_EXC_ERROR;

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;
627: /* Bug 9677677 End - Localization */
628:
629: FND_FILE.Put_Line(FND_FILE.Log,'Invoices: Complete');

Line 673: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

669: x_return_status => l_return_status,
670: x_msg_count => l_msg_count,
671: x_msg_data => l_msg_data);
672:
673: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
674: --
675: --
676: IF l_msg_count > 0 THEN
677: --

Line 688: RAISE FND_API.G_EXC_ERROR;

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;
690:
691: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling MRP API');
692:

Line 696: , p_init_msg_list => FND_API.G_FALSE

692:
693: -- MRP
694: MRP_VendorMerge_GRP.Merge_Vendor(
695: p_api_version => 1.0
696: , p_init_msg_list => FND_API.G_FALSE
697: , p_commit => FND_API.G_FALSE
698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
699: , x_return_status => l_return_status
700: , x_msg_count => l_msg_count

Line 697: , p_commit => FND_API.G_FALSE

693: -- MRP
694: MRP_VendorMerge_GRP.Merge_Vendor(
695: p_api_version => 1.0
696: , p_init_msg_list => FND_API.G_FALSE
697: , p_commit => FND_API.G_FALSE
698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
699: , x_return_status => l_return_status
700: , x_msg_count => l_msg_count
701: , x_msg_data => l_msg_data

Line 698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

694: MRP_VendorMerge_GRP.Merge_Vendor(
695: p_api_version => 1.0
696: , p_init_msg_list => FND_API.G_FALSE
697: , p_commit => FND_API.G_FALSE
698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
699: , x_return_status => l_return_status
700: , x_msg_count => l_msg_count
701: , x_msg_data => l_msg_data
702: , p_vendor_id => l_po_row.C_Vendor_Id

Line 707: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

703: , p_vendor_site_id => l_po_row.C_Vendor_Site_Id
704: , p_dup_vendor_id => l_po_row.C_Dup_Vendor_Id
705: , p_dup_vendor_site_id => l_po_row.C_Dup_Vendor_Site_Id);
706:
707: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
708: --
709: --
710: IF l_msg_count > 0 THEN
711: --

Line 722: RAISE FND_API.G_EXC_ERROR;

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;
724:
725: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Sourcing API');
726:

Line 738: , p_init_msg_list => FND_API.G_FALSE

734: , p_party_id => l_po_row.C_Party_Id
735: , p_dup_party_id => l_po_row.C_Dup_Party_Id
736: , p_party_site_id => l_po_row.C_Party_Site_Id
737: , p_dup_party_site_id => l_po_row.C_Dup_Party_Site_Id
738: , p_init_msg_list => FND_API.G_FALSE
739: , p_commit => FND_API.G_FALSE
740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
741: , p_return_status => l_return_status
742: , p_msg_count => l_msg_count

Line 739: , p_commit => FND_API.G_FALSE

735: , p_dup_party_id => l_po_row.C_Dup_Party_Id
736: , p_party_site_id => l_po_row.C_Party_Site_Id
737: , p_dup_party_site_id => l_po_row.C_Dup_Party_Site_Id
738: , p_init_msg_list => FND_API.G_FALSE
739: , p_commit => FND_API.G_FALSE
740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
741: , p_return_status => l_return_status
742: , p_msg_count => l_msg_count
743: , p_msg_data => l_msg_data);

Line 740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

736: , p_party_site_id => l_po_row.C_Party_Site_Id
737: , p_dup_party_site_id => l_po_row.C_Dup_Party_Site_Id
738: , p_init_msg_list => FND_API.G_FALSE
739: , p_commit => FND_API.G_FALSE
740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
741: , p_return_status => l_return_status
742: , p_msg_count => l_msg_count
743: , p_msg_data => l_msg_data);
744:

Line 745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

741: , p_return_status => l_return_status
742: , p_msg_count => l_msg_count
743: , p_msg_data => l_msg_data);
744:
745: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
746: --
747: --
748: IF l_msg_count > 0 THEN
749: --

Line 760: RAISE FND_API.G_EXC_ERROR;

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;
762:
763: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling iSP API');
764:

Line 768: p_init_msg_list => fnd_api.g_false,

764:
765: -- iSupplier Portal
766: POS_VENDORMERGE_GRP.merge_vendor (
767: p_api_version => 1.0,
768: p_init_msg_list => fnd_api.g_false,
769: p_commit => fnd_api.g_false,
770: p_validation_level => fnd_api.g_valid_level_full,
771: p_return_status => l_return_status,
772: p_msg_count => l_msg_count,

Line 769: p_commit => fnd_api.g_false,

765: -- iSupplier Portal
766: POS_VENDORMERGE_GRP.merge_vendor (
767: p_api_version => 1.0,
768: p_init_msg_list => fnd_api.g_false,
769: p_commit => fnd_api.g_false,
770: p_validation_level => fnd_api.g_valid_level_full,
771: p_return_status => l_return_status,
772: p_msg_count => l_msg_count,
773: p_msg_data => l_msg_data,

Line 770: p_validation_level => fnd_api.g_valid_level_full,

766: POS_VENDORMERGE_GRP.merge_vendor (
767: p_api_version => 1.0,
768: p_init_msg_list => fnd_api.g_false,
769: p_commit => fnd_api.g_false,
770: p_validation_level => fnd_api.g_valid_level_full,
771: p_return_status => l_return_status,
772: p_msg_count => l_msg_count,
773: p_msg_data => l_msg_data,
774: p_vendor_id => l_po_row.C_Vendor_Id,

Line 783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

779: p_dup_party_id => l_po_row.C_Dup_Party_Id,
780: p_party_site_id => l_po_row.C_Party_Site_Id,
781: p_dup_party_site_id => l_po_row.C_Dup_Party_Site_Id);
782:
783: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
784: --
785: --
786: IF l_msg_count > 0 THEN
787: --

Line 798: RAISE FND_API.G_EXC_ERROR;

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;
800:
801: FND_FILE.Put_Line(FND_FILE.Log,'PO: Calling Procurement API');
802:

Line 806: p_init_msg_list => fnd_api.g_false,

802:
803: -- Procurement
804: PO_VENDORMERGE_GRP.merge_vendor (
805: p_api_version => 1.0,
806: p_init_msg_list => fnd_api.g_false,
807: p_commit => fnd_api.g_false,
808: p_validation_level => fnd_api.g_valid_level_full,
809: x_return_status => l_return_status,
810: x_msg_count => l_msg_count,

Line 807: p_commit => fnd_api.g_false,

803: -- Procurement
804: PO_VENDORMERGE_GRP.merge_vendor (
805: p_api_version => 1.0,
806: p_init_msg_list => fnd_api.g_false,
807: p_commit => fnd_api.g_false,
808: p_validation_level => fnd_api.g_valid_level_full,
809: x_return_status => l_return_status,
810: x_msg_count => l_msg_count,
811: x_msg_data => l_msg_data,

Line 808: p_validation_level => fnd_api.g_valid_level_full,

804: PO_VENDORMERGE_GRP.merge_vendor (
805: p_api_version => 1.0,
806: p_init_msg_list => fnd_api.g_false,
807: p_commit => fnd_api.g_false,
808: p_validation_level => fnd_api.g_valid_level_full,
809: x_return_status => l_return_status,
810: x_msg_count => l_msg_count,
811: x_msg_data => l_msg_data,
812: p_vendor_id => l_po_row.C_Vendor_Id,

Line 821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

817: p_dup_party_id => l_po_row.C_Dup_Party_Id,
818: p_party_site_id => l_po_row.C_Party_Site_Id,
819: p_dup_party_site_id => l_po_row.C_Dup_Party_Site_Id);
820:
821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: --
823: --
824: IF l_msg_count > 0 THEN
825: --

Line 836: RAISE FND_API.G_EXC_ERROR;

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;
838:
839: FND_FILE.Put_Line(FND_FILE.Log,'PO: Complete');
840: -- Bug 7592393 Start. Call to update receiving tables

Line 844: RCV_UTILITIES.Merge_Vendor ( p_commit => fnd_api.g_false,

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,
846: x_msg_count => l_msg_count,
847: x_msg_data => l_msg_data,
848: p_vendor_id => l_po_row.C_Vendor_Id,

Line 854: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

850: p_dup_vendor_id => l_po_row.C_Dup_Vendor_Id,
851: p_dup_vendor_site_id => l_po_row.C_Dup_Vendor_Site_Id);
852:
853:
854: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
855: IF l_msg_count > 0 THEN
856: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
857: FND_MSG_PUB.Get( p_msg_index => i,
858: p_encoded => 'F',

Line 865: RAISE FND_API.G_EXC_ERROR;

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;
867: -- Bug 7592393 End.
868:
869:

Line 875: WHEN FND_API.G_EXC_ERROR THEN

871: CLOSE PO_Cursor;
872: --
873:
874: EXCEPTION
875: WHEN FND_API.G_EXC_ERROR THEN
876: FND_MSG_PUB.Count_And_Get
877: ( p_count => l_msg_count,
878: p_data => l_msg_data
879: );

Line 891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

887:
888: ROLLBACK;
889: APP_EXCEPTION.RAISE_EXCEPTION;
890:
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: FND_MSG_PUB.Count_And_Get
893: ( p_count => l_msg_count,
894: p_data => l_msg_data
895: );

Line 1127: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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
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);

Line 1136: RAISE fnd_api.g_exc_error;

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;
1138:
1139: ELSIF l_relationship_id IS NULL
1140: AND l_org_contact_id IS NULL

Line 1151: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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
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);

Line 1160: RAISE fnd_api.g_exc_error;

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;
1162: END IF;
1163:
1164: SELECT location_id

Line 1203: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1199: x_return_status => x_return_status,x_msg_count => x_msg_count,
1200: x_msg_data => x_msg_data,x_party_site_id => l_party_site_id,
1201: x_party_site_number => l_party_site_number);
1202:
1203: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1204: IF x_msg_count > 0 THEN
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);

Line 1213: RAISE fnd_api.g_exc_error;

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;
1214: END IF;
1215:
1216: FND_FILE.Put_Line(FND_FILE.Log,'Inside loop after calling hz_party_site_v2pub.create_party_site');
1217:

Line 1307: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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
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);

Line 1316: RAISE fnd_api.g_exc_error;

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;
1317: END IF;
1318: FND_FILE.Put_Line(FND_FILE.Log,'end of second loop');
1319: EXCEPTION
1320: WHEN no_data_found THEN

Line 1467: RAISE fnd_api.g_exc_error;

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

Line 1559: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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
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);

Line 1568: RAISE fnd_api.g_exc_error;

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;
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

Line 1583: WHEN FND_API.G_EXC_ERROR THEN

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
1585: ( p_count => x_msg_count,
1586: p_data => x_msg_data
1587: );

Line 1594: x_return_status := FND_API.G_RET_STS_ERROR;

1590: CLOSE c_contact_point;
1591: END IF;
1592:
1593: ROLLBACK;
1594: x_return_status := FND_API.G_RET_STS_ERROR;
1595:
1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1597: FND_MSG_PUB.Count_And_Get
1598: ( p_count => x_msg_count,

Line 1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1592:
1593: ROLLBACK;
1594: x_return_status := FND_API.G_RET_STS_ERROR;
1595:
1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1597: FND_MSG_PUB.Count_And_Get
1598: ( p_count => x_msg_count,
1599: p_data => x_msg_data
1600: );