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.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on ITG_DEBUG

Line 21: itg_debug_pub.add('Entering get_vendorsite_rec');

17: BEGIN
18:
19: g_action := 'vendor site details lookup';
20: IF l_debug_level <= 1 then
21: itg_debug_pub.add('Entering get_vendorsite_rec');
22: itg_debug_pub.add('p_vendorsite_id ' || p_vendorsite_id);
23: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);
24: END IF;
25:

Line 22: itg_debug_pub.add('p_vendorsite_id ' || p_vendorsite_id);

18:
19: g_action := 'vendor site details lookup';
20: IF l_debug_level <= 1 then
21: itg_debug_pub.add('Entering get_vendorsite_rec');
22: itg_debug_pub.add('p_vendorsite_id ' || p_vendorsite_id);
23: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);
24: END IF;
25:
26: SELECT

Line 23: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);

19: g_action := 'vendor site details lookup';
20: IF l_debug_level <= 1 then
21: itg_debug_pub.add('Entering get_vendorsite_rec');
22: itg_debug_pub.add('p_vendorsite_id ' || p_vendorsite_id);
23: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);
24: END IF;
25:
26: SELECT
27: VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_CODE,

Line 103: itg_debug_pub.add('Exiting get_vendorsite_rec normal');

99: WHERE vendor_id = p_vendor_id
100: and vendor_site_id = p_vendorsite_id;
101:
102: IF l_debug_level <= 1 then
103: itg_debug_pub.add('Exiting get_vendorsite_rec normal');
104: END IF;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: itg_msg.no_vendor_site(p_vendorsite_id);

Line 111: itg_debug_pub.add('Error in get_vendorsite_rec ' || SQLCODE || ' - ' || SQLERRM,1);

107: itg_msg.no_vendor_site(p_vendorsite_id);
108: RAISE FND_API.G_EXC_ERROR;
109: WHEN OTHERS THEN
110: IF l_debug_level <= 1 THEN
111: itg_debug_pub.add('Error in get_vendorsite_rec ' || SQLCODE || ' - ' || SQLERRM,1);
112: END IF;
113: RAISE;
114: END;
115:

Line 123: itg_debug_pub.add('Entering get_vendor_rec');

119: p_vendor_id IN NUMBER) IS
120: BEGIN
121: g_action := 'vendor details lookup';
122: IF l_debug_level <= 1 then
123: itg_debug_pub.add('Entering get_vendor_rec');
124: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);
125: END IF;
126:
127: SELECT

Line 124: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);

120: BEGIN
121: g_action := 'vendor details lookup';
122: IF l_debug_level <= 1 then
123: itg_debug_pub.add('Entering get_vendor_rec');
124: itg_debug_pub.add('p_vendor_id ' || p_vendor_id);
125: END IF;
126:
127: SELECT
128: VENDOR_ID, VENDOR_NAME, VENDOR_NAME_ALT, SUMMARY_FLAG, ENABLED_FLAG, EMPLOYEE_ID,

Line 183: itg_debug_pub.add('Exiting get_vendor_rec normal');

179: FROM ap_vendors_v
180: WHERE vendor_id = p_vendor_id ;
181:
182: IF l_debug_level <= 1 then
183: itg_debug_pub.add('Exiting get_vendor_rec normal');
184: END IF;
185: EXCEPTION
186: WHEN NO_DATA_FOUND THEN
187: itg_msg.vendor_not_found(p_vendor_id);

Line 191: itg_debug_pub.add('Error in get_vendor_rec ' || SQLCODE || ' - ' || SQLERRM,1);

187: itg_msg.vendor_not_found(p_vendor_id);
188: RAISE FND_API.G_EXC_ERROR;
189: WHEN OTHERS THEN
190: IF l_debug_level <= 1 THEN
191: itg_debug_pub.add('Error in get_vendor_rec ' || SQLCODE || ' - ' || SQLERRM,1);
192: END IF;
193: RAISE;
194: END;
195:

Line 247: itg_debug_pub.Add(g_action,1);

243: BEGIN
244: g_action := 'Sync-vendor parameter validation';
245:
246: IF (l_Debug_Level <= 1) THEN
247: itg_debug_pub.Add(g_action,1);
248: END IF;
249:
250: IF p_org IS NULL THEN -- MOAC
251: itg_msg.invalid_org(p_org);

Line 269: itg_debug_pub.Add('SV- Checking paymethod', 1);

265: END IF;
266:
267: IF p_paymethod IS NOT NULL THEN
268: IF (l_Debug_Level <= 1) THEN
269: itg_debug_pub.Add('SV- Checking paymethod', 1);
270: END IF;
271:
272:
273: BEGIN

Line 288: itg_debug_pub.Add('SV- Checking termid', 1);

284: END IF;
285:
286: IF p_termid IS NOT NULL THEN
287: IF (l_Debug_Level <= 1) THEN
288: itg_debug_pub.Add('SV- Checking termid', 1);
289: END IF;
290:
291: BEGIN
292: SELECT term_id

Line 360: itg_debug_pub.Add('Validation complete', 1);

356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:
359: IF (l_Debug_Level <= 1) THEN
360: itg_debug_pub.Add('Validation complete', 1);
361: END IF;
362: EXCEPTION
363: WHEN OTHERS THEN
364: IF l_debug_level <= 1 THEN

Line 365: itg_debug_pub.add('Error in validate_vendor_params ' || SQLCODE || ' - ' || SQLERRM,1);

361: END IF;
362: EXCEPTION
363: WHEN OTHERS THEN
364: IF l_debug_level <= 1 THEN
365: itg_debug_pub.add('Error in validate_vendor_params ' || SQLCODE || ' - ' || SQLERRM,1);
366: END IF;
367: RAISE;
368: END;
369:

Line 383: itg_debug_pub.Add('SV - default vendor parameters', 1);

379: BEGIN
380: g_action := 'defaulting vendor parameters';
381:
382: IF (l_Debug_Level <= 1) THEN
383: itg_debug_pub.Add('SV - default vendor parameters', 1);
384: END IF;
385:
386: AP_Apxvdmvd_PKG.Initialize(
387: x_user_defined_vendor_num_code => l_dummy_char,

Line 460: itg_debug_pub.Add('Exiting default vendor parameters', 1);

456: x_calling_sequence => 'APXVDMVD'
457: );
458:
459: IF (l_Debug_Level <= 1) THEN
460: itg_debug_pub.Add('Exiting default vendor parameters', 1);
461: END IF;
462: EXCEPTION
463: WHEN OTHERS THEN
464: IF l_debug_level <= 1 THEN

Line 465: itg_debug_pub.add('Error in default_vendor_params ' || SQLCODE || ' - ' || SQLERRM,1);

461: END IF;
462: EXCEPTION
463: WHEN OTHERS THEN
464: IF l_debug_level <= 1 THEN
465: itg_debug_pub.add('Error in default_vendor_params ' || SQLCODE || ' - ' || SQLERRM,1);
466: END IF;
467: itg_msg.apicallret('AP_Apxvdmvd_PKG.Initialize','U',substr((SQLCODE || SQLERRM),1,200));
468: RAISE FND_API.G_EXC_ERROR;
469: END;

Line 516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);

512: SAVEPOINT Sync_Vendor_PVT;
513:
514: -- now in wrapperFND_MSG_PUB.Initialize;
515: IF (l_Debug_Level <= 1) THEN
516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);
517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);

Line 517: itg_debug_pub.Add('SV - Top of procedure.' ,1);

513:
514: -- now in wrapperFND_MSG_PUB.Initialize;
515: IF (l_Debug_Level <= 1) THEN
516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);
517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);

Line 518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);

514: -- now in wrapperFND_MSG_PUB.Initialize;
515: IF (l_Debug_Level <= 1) THEN
516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);
517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);

Line 519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);

515: IF (l_Debug_Level <= 1) THEN
516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);
517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);

Line 520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);

516: itg_debug_pub.Add('--- Parameters Obtained ---' ,1);
517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);

Line 521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);

517: itg_debug_pub.Add('SV - Top of procedure.' ,1);
518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);

Line 522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);

518: itg_debug_pub.Add('SV - p_syncind ' ||p_syncind,1);
519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);

Line 523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);

519: itg_debug_pub.Add('SV - p_name ' ||p_name,1);
520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);

Line 524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);

520: itg_debug_pub.Add('SV - p_onetime ' ||p_onetime,1);
521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);

Line 525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);

521: itg_debug_pub.Add('SV - p_partnerid ' ||p_partnerid,1);
522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);

Line 526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);

522: itg_debug_pub.Add('SV - p_active ' ||p_active,1);
523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);

Line 527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);

523: itg_debug_pub.Add('SV - p_currency ' ||p_currency,1);
524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);
531: itg_debug_pub.Add('SV - org ' ||p_org,1);

Line 528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);

524: itg_debug_pub.Add('SV - p_dunsnumber ' ||p_dunsnumber,1);
525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);
531: itg_debug_pub.Add('SV - org ' ||p_org,1);
532: END IF;

Line 529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);

525: itg_debug_pub.Add('SV - p_parentid ' ||p_parentid,1);
526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);
531: itg_debug_pub.Add('SV - org ' ||p_org,1);
532: END IF;
533:

Line 530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);

526: itg_debug_pub.Add('SV - p_paymethod' ||p_paymethod,1);
527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);
531: itg_debug_pub.Add('SV - org ' ||p_org,1);
532: END IF;
533:
534: BEGIN

Line 531: itg_debug_pub.Add('SV - org ' ||p_org,1);

527: itg_debug_pub.Add('SV - p_taxid ' ||p_taxid,1);
528: itg_debug_pub.Add('SV - p_termid ' ||p_termid,1);
529: itg_debug_pub.Add('SV - p_us_flag ' ||p_us_flag,1);
530: itg_debug_pub.Add('SV - p_date ' ||p_date,1);
531: itg_debug_pub.Add('SV - org ' ||p_org,1);
532: END IF;
533:
534: BEGIN
535: MO_GLOBAL.set_policy_context('S', p_org); -- MOAC

Line 540: itg_debug_pub.Add('MO_GLOBAL.set_policy_context ' || SQLCODE || ' - ' || SQLERRM,6);

536: EXCEPTION
537: WHEN OTHERS THEN
538: itg_msg.invalid_org(p_org);
539: IF l_debug_level <= 6 THEN
540: itg_debug_pub.Add('MO_GLOBAL.set_policy_context ' || SQLCODE || ' - ' || SQLERRM,6);
541: END IF;
542: RAISE FND_API.G_EXC_ERROR;
543: END;
544:

Line 546: itg_debug_pub.add('Before sync vendor, parameter validation ',1);

542: RAISE FND_API.G_EXC_ERROR;
543: END;
544:
545: IF l_debug_level <= 1 THEN
546: itg_debug_pub.add('Before sync vendor, parameter validation ',1);
547: END IF;
548:
549: validate_vendor_params(
550: p_syncind => p_syncind,

Line 566: itg_debug_pub.add('After sync vendor, parameter validation ',1);

562: p_date => p_date,
563: p_org => p_org);
564:
565: IF l_debug_level <= 1 THEN
566: itg_debug_pub.add('After sync vendor, parameter validation ',1);
567: END IF;
568:
569: l_syncind := UPPER(p_syncind);
570: IF p_termid IS NOT NULL THEN

Line 580: itg_debug_pub.add('SV - Termid - ' || l_term_id ,1);

576: l_term_id := null;
577: END IF;
578:
579: IF l_debug_level <= 1 THEN
580: itg_debug_pub.add('SV - Termid - ' || l_term_id ,1);
581: END IF;
582:
583: x_vinfo_rec.syncind := UPPER(p_syncind);
584: x_vinfo_rec.currency := p_currency;

Line 603: itg_debug_pub.add('SV - Vendor params defaulted',1);

599: l_org := p_org;
600: default_vendor_params(r_vendor_rec,x_vinfo_rec,l_org);
601:
602: IF l_debug_level <= 1 THEN
603: itg_debug_pub.add('SV - Vendor params defaulted',1);
604: END IF;
605:
606: r_vendor_rec.one_time_flag := flag_value(NVL(to_number(p_onetime), 0) <> 0);
607: r_vendor_rec.summary_flag := flag_value(NVL(p_parentid, 0) <> 0);

Line 623: itg_debug_pub.add('Call to create vendor',1);

619: r_vendor_rec.terms_date_basis := NVL(r_vendor_rec.terms_date_basis, 'Goods Received');
620:
621:
622: IF l_debug_level <= 1 THEN
623: itg_debug_pub.add('Call to create vendor',1);
624: END IF;
625:
626: ap_vendor_pub_pkg.Create_Vendor(
627: p_api_version => '1.0',

Line 638: itg_debug_pub.add('Create vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);

634:
635: x_vinfo_rec.vendor_id := r_vendor_rec.vendor_id;
636:
637: IF l_debug_level <= 1 THEN
638: itg_debug_pub.add('Create vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);
639: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);
640: END IF;
641:
642: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 639: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);

635: x_vinfo_rec.vendor_id := r_vendor_rec.vendor_id;
636:
637: IF l_debug_level <= 1 THEN
638: itg_debug_pub.add('Create vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);
639: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);
640: END IF;
641:
642: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
643: IF l_debug_level <= 6 THEN

Line 644: itg_debug_pub.add('Error occured in Create Vendor',6);

640: END IF;
641:
642: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
643: IF l_debug_level <= 6 THEN
644: itg_debug_pub.add('Error occured in Create Vendor',6);
645: END IF;
646: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));
647: RAISE FND_API.G_EXC_ERROR;
648: END IF;

Line 657: itg_debug_pub.Add('SV - segment1 '|| l_override_vendornum ,1);

653: INTO l_override_vendornum
654: FROM ap_vendors_v
655: WHERE vendor_id = r_vendor_rec.vendor_id;
656: IF l_debug_level <= 1 THEN
657: itg_debug_pub.Add('SV - segment1 '|| l_override_vendornum ,1);
658: END IF;
659: EXCEPTION
660: WHEN OTHERS THEN
661: IF l_debug_level <= 6 THEN

Line 662: itg_debug_pub.add('Error occured while retrieving vendor_number',6);

658: END IF;
659: EXCEPTION
660: WHEN OTHERS THEN
661: IF l_debug_level <= 6 THEN
662: itg_debug_pub.add('Error occured while retrieving vendor_number',6);
663: END IF;
664: RAISE FND_API.G_EXC_ERROR;
665: END;
666:

Line 667: itg_debug_pub.Add('SV - p_partnerid '||p_partnerid ,1);

663: END IF;
664: RAISE FND_API.G_EXC_ERROR;
665: END;
666:
667: itg_debug_pub.Add('SV - p_partnerid '||p_partnerid ,1);
668:
669: IF l_override_vendornum <> p_partnerid THEN
670: IF (l_Debug_Level <= 1) THEN
671: itg_debug_pub.Add('SV - Segment1 automatically allocated, overriding.' ,1);

Line 671: itg_debug_pub.Add('SV - Segment1 automatically allocated, overriding.' ,1);

667: itg_debug_pub.Add('SV - p_partnerid '||p_partnerid ,1);
668:
669: IF l_override_vendornum <> p_partnerid THEN
670: IF (l_Debug_Level <= 1) THEN
671: itg_debug_pub.Add('SV - Segment1 automatically allocated, overriding.' ,1);
672: END IF;
673: l_syncind := 'C';
674: END IF;
675: -- sync ind <> A (else) condtion block begins

Line 680: itg_debug_pub.Add('SV - Changing the vendor info.',1);

676: ELSE
677: g_action := 'Vendor record update';
678:
679: IF (l_Debug_Level <= 1) THEN
680: itg_debug_pub.Add('SV - Changing the vendor info.',1);
681: END IF;
682:
683: BEGIN
684: SELECT vendor_id

Line 692: itg_debug_pub.Add('x_vinfo_rec.vendor_id - '|| x_vinfo_rec.vendor_id,1);

688:
689: x_vinfo_rec.vendor_id := r_vendor_rec.vendor_id;
690:
691: IF (l_Debug_Level <= 1) THEN
692: itg_debug_pub.Add('x_vinfo_rec.vendor_id - '|| x_vinfo_rec.vendor_id,1);
693: END IF;
694: EXCEPTION
695: WHEN NO_DATA_FOUND THEN
696: itg_msg.vendor_not_found(p_name);

Line 710: itg_debug_pub.Add('Obtained vendor details ',1);

706:
707: get_vendor_rec(r_vendor_rec,x_vinfo_rec.vendor_id);
708:
709: IF (l_Debug_Level <= 1) THEN
710: itg_debug_pub.Add('Obtained vendor details ',1);
711: END IF;
712:
713:
714: r_vendor_rec.one_time_flag := flag_value(NVL(to_number(p_onetime), 0) <> 0);

Line 744: itg_debug_pub.Add('SV - vendor_id'||r_vendor_rec.vendor_id ,1);

740: END IF;
741:
742:
743: IF (l_Debug_Level <= 1) THEN
744: itg_debug_pub.Add('SV - vendor_id'||r_vendor_rec.vendor_id ,1);
745: END IF;
746:
747: ap_vendor_pub_pkg.update_vendor(
748: p_api_version => '1.0',

Line 757: itg_debug_pub.add('Update vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);

753: p_vendor_id => r_vendor_rec.vendor_id
754: );
755:
756: IF l_debug_level <= 1 THEN
757: itg_debug_pub.add('Update vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);
758: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);
759: END IF;
760:
761: /*Added following block to fix Bug :5186022 */

Line 758: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);

754: );
755:
756: IF l_debug_level <= 1 THEN
757: itg_debug_pub.add('Update vendor returns - ' || l_ret_status || ' - ' || l_ret_msg ,1);
758: ITG_Debug_pub.add('SV - vendor_id ' || r_vendor_rec.vendor_id,1);
759: END IF;
760:
761: /*Added following block to fix Bug :5186022 */
762:

Line 779: itg_debug_pub.Add('party_id - '|| l_party_id,1);

775: from hz_parties
776: where party_id=l_party_id;
777:
778: IF (l_Debug_Level <= 1) THEN
779: itg_debug_pub.Add('party_id - '|| l_party_id,1);
780: itg_debug_pub.Add('party_object_version_number - '|| l_party_object_version_number,1);
781: itg_debug_pub.Add('party_number - '|| l_party_number,1);
782: itg_debug_pub.Add('party_duns_number - '|| l_duns_number,1);
783:

Line 780: itg_debug_pub.Add('party_object_version_number - '|| l_party_object_version_number,1);

776: where party_id=l_party_id;
777:
778: IF (l_Debug_Level <= 1) THEN
779: itg_debug_pub.Add('party_id - '|| l_party_id,1);
780: itg_debug_pub.Add('party_object_version_number - '|| l_party_object_version_number,1);
781: itg_debug_pub.Add('party_number - '|| l_party_number,1);
782: itg_debug_pub.Add('party_duns_number - '|| l_duns_number,1);
783:
784: END IF;

Line 781: itg_debug_pub.Add('party_number - '|| l_party_number,1);

777:
778: IF (l_Debug_Level <= 1) THEN
779: itg_debug_pub.Add('party_id - '|| l_party_id,1);
780: itg_debug_pub.Add('party_object_version_number - '|| l_party_object_version_number,1);
781: itg_debug_pub.Add('party_number - '|| l_party_number,1);
782: itg_debug_pub.Add('party_duns_number - '|| l_duns_number,1);
783:
784: END IF;
785:

Line 782: itg_debug_pub.Add('party_duns_number - '|| l_duns_number,1);

778: IF (l_Debug_Level <= 1) THEN
779: itg_debug_pub.Add('party_id - '|| l_party_id,1);
780: itg_debug_pub.Add('party_object_version_number - '|| l_party_object_version_number,1);
781: itg_debug_pub.Add('party_number - '|| l_party_number,1);
782: itg_debug_pub.Add('party_duns_number - '|| l_duns_number,1);
783:
784: END IF;
785:
786: EXCEPTION

Line 789: itg_debug_pub.Add('Couldn''t find party_id from ap_suppliers or obj_ver,party_num,duns_num from hz_parties ');

785:
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: IF (l_Debug_Level <= 1) THEN
789: itg_debug_pub.Add('Couldn''t find party_id from ap_suppliers or obj_ver,party_num,duns_num from hz_parties ');
790: END IF;
791: RAISE FND_API.G_EXC_ERROR;
792: END;
793:

Line 811: itg_debug_pub.add('Error occured in update Vendor or update organization',6);

807:
808:
809: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
810: IF l_debug_level <= 6 THEN
811: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
812: END IF;
813: itg_msg.apicallret('ap_vendor_pub_pkg.Update_vendor or hz_party_v2pub.update_organization returns-',l_ret_status,substr(l_ret_msg,1,200));
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;

Line 821: itg_debug_pub.Add('Commiting work',1);

817:
818: END IF;
819:
820: IF (l_Debug_Level <= 1) THEN
821: itg_debug_pub.Add('Commiting work',1);
822: END IF;
823:
824: COMMIT WORK;
825:

Line 827: itg_debug_pub.Add('EXITING - Sync_Vendor.', 2);

823:
824: COMMIT WORK;
825:
826: IF (l_Debug_Level <= 2) THEN
827: itg_debug_pub.Add('EXITING - Sync_Vendor.', 2);
828: END IF;
829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: ROLLBACK TO Sync_Vendor_PVT;

Line 836: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);

832: COMMIT;
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: ITG_msg.checked_error(g_action);
835: IF (l_Debug_Level <= 6) THEN
836: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);
837: END IF;
838:
839: WHEN OTHERS THEN
840: ROLLBACK TO Sync_Vendor_PVT;

Line 843: itg_debug.msg('Unexpected error (Vendor sync) - ' || substr(SQLERRM,1,255),true);

839: WHEN OTHERS THEN
840: ROLLBACK TO Sync_Vendor_PVT;
841: COMMIT;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: itg_debug.msg('Unexpected error (Vendor sync) - ' || substr(SQLERRM,1,255),true);
844: ITG_msg.unexpected_error(g_action);
845: IF (l_Debug_Level <= 6) THEN
846: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);
847: END IF;

Line 846: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);

842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843: itg_debug.msg('Unexpected error (Vendor sync) - ' || substr(SQLERRM,1,255),true);
844: ITG_msg.unexpected_error(g_action);
845: IF (l_Debug_Level <= 6) THEN
846: itg_debug_pub.Add('EXITING - Sync_Vendor:: ERROR', 6);
847: END IF;
848:
849: -- Removed FND_MSG_PUB.Count_And_Get
850: END Sync_Vendor;

Line 1002: itg_debug_pub.Add('Top of procedure.', 1);

998:
999: SAVEPOINT Sync_VendorSite_PVT;
1000:
1001: IF (l_Debug_Level <= 1) THEN
1002: itg_debug_pub.Add('Top of procedure.', 1);
1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);

Line 1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);

999: SAVEPOINT Sync_VendorSite_PVT;
1000:
1001: IF (l_Debug_Level <= 1) THEN
1002: itg_debug_pub.Add('Top of procedure.', 1);
1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );

Line 1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);

1000:
1001: IF (l_Debug_Level <= 1) THEN
1002: itg_debug_pub.Add('Top of procedure.', 1);
1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );

Line 1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);

1001: IF (l_Debug_Level <= 1) THEN
1002: itg_debug_pub.Add('Top of procedure.', 1);
1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);

Line 1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);

1002: itg_debug_pub.Add('Top of procedure.', 1);
1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);

Line 1007: itg_debug_pub.Add('p_city' ||p_city, 1 );

1003: itg_debug_pub.Add('p_addrline1' ||p_addrline1, 1);
1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);

Line 1008: itg_debug_pub.Add('p_country' ||p_country, 1 );

1004: itg_debug_pub.Add('p_addrline2' ||p_addrline2, 1);
1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);

Line 1009: itg_debug_pub.Add('p_county' ||p_county, 1);

1005: itg_debug_pub.Add('p_addrline3' ||p_addrline3, 1);
1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);

Line 1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);

1006: itg_debug_pub.Add('p_addrline4' ||p_addrline4, 1);
1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);

Line 1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);

1007: itg_debug_pub.Add('p_city' ||p_city, 1 );
1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);

Line 1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);

1008: itg_debug_pub.Add('p_country' ||p_country, 1 );
1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);

Line 1013: itg_debug_pub.Add('p_state' ||p_state, 1);

1009: itg_debug_pub.Add('p_county' ||p_county, 1);
1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);

Line 1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);

1010: itg_debug_pub.Add('p_site_code' ||p_site_code, 1);
1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);

Line 1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);

1011: itg_debug_pub.Add('p_fax' ||p_fax, 1);
1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);

Line 1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);

1012: itg_debug_pub.Add('p_zip' ||p_zip, 1);
1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);
1020: itg_debug_pub.Add('p_org ' ||p_org, 1);

Line 1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);

1013: itg_debug_pub.Add('p_state' ||p_state, 1);
1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);
1020: itg_debug_pub.Add('p_org ' ||p_org, 1);
1021: END IF;

Line 1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);

1014: itg_debug_pub.Add('p_phone' ||p_phone, 1);
1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);
1020: itg_debug_pub.Add('p_org ' ||p_org, 1);
1021: END IF;
1022:

Line 1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);

1015: itg_debug_pub.Add('p_purch_site'||p_purch_site, 1);
1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);
1020: itg_debug_pub.Add('p_org ' ||p_org, 1);
1021: END IF;
1022:
1023: validate_vendorsite_params(

Line 1020: itg_debug_pub.Add('p_org ' ||p_org, 1);

1016: itg_debug_pub.Add('p_pay_site' ||p_pay_site, 1);
1017: itg_debug_pub.Add('p_pc_site' ||p_pc_site, 1);
1018: itg_debug_pub.Add('p_rfq_site' ||p_rfq_site, 1);
1019: itg_debug_pub.Add('p_vat_code' ||p_vat_code, 1);
1020: itg_debug_pub.Add('p_org ' ||p_org, 1);
1021: END IF;
1022:
1023: validate_vendorsite_params(
1024: p_addrline1 => p_addrline1,

Line 1046: itg_debug_pub.Add('Retrieving vendor record - ' || p_vinfo_rec.vendor_id ,1);

1042: p_vinfo_rec => p_vinfo_rec);
1043:
1044: BEGIN
1045: IF (l_Debug_Level <= 1) THEN
1046: itg_debug_pub.Add('Retrieving vendor record - ' || p_vinfo_rec.vendor_id ,1);
1047: END IF;
1048:
1049: g_action := 'query vendor details';
1050:

Line 1059: itg_debug_pub.Add('Vendor not found - erroring out' ,1);

1055:
1056: EXCEPTION
1057: WHEN NO_DATA_FOUND THEN
1058: IF (l_Debug_Level <= 1) THEN
1059: itg_debug_pub.Add('Vendor not found - erroring out' ,1);
1060: END IF;
1061: itg_msg.vendor_not_found('vendorid:' ||p_vinfo_rec.vendor_id);
1062: RAISE FND_API.G_EXC_ERROR;
1063: END;

Line 1077: itg_debug_pub.add('Vendor site obtained as - ' || l_vendor_site_id);

1073:
1074: l_vendor_found := true;
1075:
1076: IF (l_Debug_Level <= 1) THEN
1077: itg_debug_pub.add('Vendor site obtained as - ' || l_vendor_site_id);
1078: END IF;
1079:
1080: EXCEPTION
1081: WHEN NO_DATA_FOUND THEN

Line 1090: itg_debug_pub.Add('SVS - Looking up set_of_books_id',1);

1086: END;
1087:
1088: IF p_org IS NOT NULL THEN
1089: IF (l_Debug_Level <= 1) THEN
1090: itg_debug_pub.Add('SVS - Looking up set_of_books_id',1);
1091: END IF;
1092:
1093: OPEN sob_csr(p_org);
1094: FETCH sob_csr

Line 1102: itg_debug_pub.Add('SVS - Looking up financial params' ,1);

1098:
1099:
1100: IF l_sob_found THEN
1101: IF (l_Debug_Level <= 1) THEN
1102: itg_debug_pub.Add('SVS - Looking up financial params' ,1);
1103: itg_debug_pub.Add('SVS - set_of_books_id'||l_ven_rec.set_of_books_id,1);
1104: END IF;
1105:
1106: OPEN fin_params_csr(p_sob_id => l_ven_rec.set_of_books_id);

Line 1103: itg_debug_pub.Add('SVS - set_of_books_id'||l_ven_rec.set_of_books_id,1);

1099:
1100: IF l_sob_found THEN
1101: IF (l_Debug_Level <= 1) THEN
1102: itg_debug_pub.Add('SVS - Looking up financial params' ,1);
1103: itg_debug_pub.Add('SVS - set_of_books_id'||l_ven_rec.set_of_books_id,1);
1104: END IF;
1105:
1106: OPEN fin_params_csr(p_sob_id => l_ven_rec.set_of_books_id);
1107: FETCH fin_params_csr

Line 1123: itg_debug_pub.add('Creating vendor record');

1119:
1120:
1121: IF NOT l_vendor_found THEN
1122: IF (l_Debug_Level <= 1) THEN
1123: itg_debug_pub.add('Creating vendor record');
1124: END IF;
1125:
1126: g_action := 'vendor site creation';
1127: l_vendorsite_rec.vendor_site_code := p_site_code;

Line 1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');

1178: x_location_id => l_location_id
1179: );
1180:
1181: IF (l_Debug_Level <= 1) THEN
1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');
1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);

Line 1183: itg_debug_pub.add('l_return_status ' || l_return_status);

1179: );
1180:
1181: IF (l_Debug_Level <= 1) THEN
1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');
1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);

Line 1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);

1180:
1181: IF (l_Debug_Level <= 1) THEN
1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');
1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);
1188: itg_debug_pub.add('l_location_id ' || l_location_id);

Line 1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);

1181: IF (l_Debug_Level <= 1) THEN
1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');
1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);
1188: itg_debug_pub.add('l_location_id ' || l_location_id);
1189: END IF;

Line 1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);

1182: itg_debug_pub.add('return from ap_vendors_pub_pkg.create_vendor_site');
1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);
1188: itg_debug_pub.add('l_location_id ' || l_location_id);
1189: END IF;
1190:

Line 1187: itg_debug_pub.add('l_party_id ' || l_party_id);

1183: itg_debug_pub.add('l_return_status ' || l_return_status);
1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);
1188: itg_debug_pub.add('l_location_id ' || l_location_id);
1189: END IF;
1190:
1191: ELSE

Line 1188: itg_debug_pub.add('l_location_id ' || l_location_id);

1184: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1185: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1186: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1187: itg_debug_pub.add('l_party_id ' || l_party_id);
1188: itg_debug_pub.add('l_location_id ' || l_location_id);
1189: END IF;
1190:
1191: ELSE
1192:

Line 1195: itg_debug_pub.add('Updating vendor record');

1191: ELSE
1192:
1193: g_action := 'vendor site update';
1194: IF (l_Debug_Level <= 1) THEN
1195: itg_debug_pub.add('Updating vendor record');
1196: END IF;
1197:
1198: g_action := 'Vendor-site info update';
1199: get_vendorsite_rec(l_vendorsite_rec,l_vendor_site_id,p_vinfo_rec.vendor_id);

Line 1202: itg_debug_pub.add('Retrieved old vendor record information');

1198: g_action := 'Vendor-site info update';
1199: get_vendorsite_rec(l_vendorsite_rec,l_vendor_site_id,p_vinfo_rec.vendor_id);
1200:
1201: IF (l_Debug_Level <= 1) THEN
1202: itg_debug_pub.add('Retrieved old vendor record information');
1203: END IF;
1204: l_vendorsite_rec.vendor_site_code := null;
1205: l_vendorsite_rec.PHONE := NVL(p_phone, l_vendorsite_rec.phone);
1206: l_vendorsite_rec.FAX := NVL(p_fax, l_vendorsite_rec.fax);

Line 1230: itg_debug_pub.add('Calling ap_vendors_pub_pkg.update_vendor_site');

1226: l_vendorsite_rec.org_id := p_org;
1227: l_vendorsite_rec.vendor_site_id := l_vendor_site_id;
1228:
1229: IF (l_Debug_Level <= 1) THEN
1230: itg_debug_pub.add('Calling ap_vendors_pub_pkg.update_vendor_site');
1231: END IF;
1232: l_api_name := 'ap_vendor_pub_pkg.update_vendor_site';
1233: ap_vendor_pub_pkg.update_vendor_site
1234: (

Line 1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');

1240: p_vendor_site_id => l_vendor_site_id
1241: );
1242:
1243: IF (l_Debug_Level <= 1) THEN
1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');
1245: itg_debug_pub.add('l_return_status ' || l_return_status);
1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);

Line 1245: itg_debug_pub.add('l_return_status ' || l_return_status);

1241: );
1242:
1243: IF (l_Debug_Level <= 1) THEN
1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');
1245: itg_debug_pub.add('l_return_status ' || l_return_status);
1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1249: END IF;

Line 1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);

1242:
1243: IF (l_Debug_Level <= 1) THEN
1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');
1245: itg_debug_pub.add('l_return_status ' || l_return_status);
1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1249: END IF;
1250:

Line 1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);

1243: IF (l_Debug_Level <= 1) THEN
1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');
1245: itg_debug_pub.add('l_return_status ' || l_return_status);
1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1249: END IF;
1250:
1251: /* Adding following block to Fix Bug: 5258874 to update supplier site address locations*/

Line 1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);

1244: itg_debug_pub.add('Return from ap_vendors_pub_pkg.update_vendor_site');
1245: itg_debug_pub.add('l_return_status ' || l_return_status);
1246: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1247: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1248: itg_debug_pub.add('l_vendor_site_id ' || l_vendor_site_id);
1249: END IF;
1250:
1251: /* Adding following block to Fix Bug: 5258874 to update supplier site address locations*/
1252: BEGIN

Line 1257: itg_debug_pub.Add('location_id - '|| p_location_rec.location_id,1);

1253: select location_id into p_location_rec.location_id
1254: from ap_supplier_sites
1255: where vendor_id = p_vinfo_rec.vendor_id and vendor_site_id = l_vendor_site_id;
1256: IF (l_Debug_Level <= 1) THEN
1257: itg_debug_pub.Add('location_id - '|| p_location_rec.location_id,1);
1258: END IF;
1259:
1260: EXCEPTION
1261: WHEN NO_DATA_FOUND THEN

Line 1263: itg_debug_pub.Add('Couldn''t find location_id ');

1259:
1260: EXCEPTION
1261: WHEN NO_DATA_FOUND THEN
1262: IF (l_Debug_Level <= 1) THEN
1263: itg_debug_pub.Add('Couldn''t find location_id ');
1264: END IF;
1265: RAISE FND_API.G_EXC_ERROR;
1266: END;
1267:

Line 1276: itg_debug_pub.Add('object_version_number - '|| p_object_version_number);

1272: from hz_locations
1273: where location_id = p_location_rec.location_id;
1274:
1275: IF (l_Debug_Level <= 1) THEN
1276: itg_debug_pub.Add('object_version_number - '|| p_object_version_number);
1277: END IF;
1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN

Line 1282: itg_debug_pub.Add('Couldn''t find object_version_number');

1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: IF (l_Debug_Level <= 1) THEN
1282: itg_debug_pub.Add('Couldn''t find object_version_number');
1283: END IF;
1284: RAISE FND_API.G_EXC_ERROR;
1285:
1286: END;

Line 1302: itg_debug_pub.add('Calling hz_location_v2pub.update_location ');

1298: p_location_rec.province := NVL(p_state, l_vendorsite_rec.state);
1299: p_location_rec.county := NVL(p_county, l_vendorsite_rec.county);
1300:
1301: IF (l_Debug_Level <= 1) THEN
1302: itg_debug_pub.add('Calling hz_location_v2pub.update_location ');
1303:
1304: END IF;
1305: l_api_name := 'hz_location_v2pub.update_location';
1306: hz_location_v2pub.update_location

Line 1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');

1313: x_msg_data => l_ret_msg
1314:
1315: );
1316: IF (l_Debug_Level <= 1) THEN
1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');
1318: itg_debug_pub.add('l_return_status ' || l_return_status);
1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;

Line 1318: itg_debug_pub.add('l_return_status ' || l_return_status);

1314:
1315: );
1316: IF (l_Debug_Level <= 1) THEN
1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');
1318: itg_debug_pub.add('l_return_status ' || l_return_status);
1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;
1322: END IF;

Line 1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);

1315: );
1316: IF (l_Debug_Level <= 1) THEN
1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');
1318: itg_debug_pub.add('l_return_status ' || l_return_status);
1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;
1322: END IF;
1323:

Line 1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);

1316: IF (l_Debug_Level <= 1) THEN
1317: itg_debug_pub.add('Return from hz_location_v2pub.update_location');
1318: itg_debug_pub.add('l_return_status ' || l_return_status);
1319: itg_debug_pub.add('l_msg_count ' || l_msg_count);
1320: itg_debug_pub.add('l_ret_msg ' || l_ret_msg);
1321: End if;
1322: END IF;
1323:
1324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1327: itg_debug_pub.add('Create/Update_vendor_site/update_location API returns - ' || l_return_status || ' - ' || l_ret_msg);

1323:
1324: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1325:
1326: IF (l_Debug_Level <= 1) THEN
1327: itg_debug_pub.add('Create/Update_vendor_site/update_location API returns - ' || l_return_status || ' - ' || l_ret_msg);
1328: END IF;
1329: itg_msg.apicallret(l_api_name, l_return_status, l_ret_msg);
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;

Line 1334: itg_debug_pub.Add('Commiting work',1);

1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332:
1333: IF (l_Debug_Level <= 1) THEN
1334: itg_debug_pub.Add('Commiting work',1);
1335: END IF;
1336:
1337: COMMIT WORK;
1338:

Line 1340: itg_debug_pub.Add('EXITING - Sync_VendorSite.', 2);

1336:
1337: COMMIT WORK;
1338:
1339: IF (l_Debug_Level <= 2) THEN
1340: itg_debug_pub.Add('EXITING - Sync_VendorSite.', 2);
1341: END IF;
1342:
1343: EXCEPTION
1344: WHEN FND_API.G_EXC_ERROR THEN

Line 1351: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);

1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: ITG_msg.checked_error(g_action);
1349: itg_msg.vendor_site_only;
1350: IF (l_Debug_Level <= 6) THEN
1351: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);
1352: END IF;
1353:
1354:
1355: WHEN OTHERS THEN

Line 1361: itg_debug.msg('Unexpected error (VendorSite sync) - ' || substr(SQLERRM,1,255),true);

1357: commit;
1358: ITG_msg.unexpected_error(g_action);
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: itg_msg.vendor_site_only;
1361: itg_debug.msg('Unexpected error (VendorSite sync) - ' || substr(SQLERRM,1,255),true);
1362: IF (l_Debug_Level <= 6) THEN
1363: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);
1364: END IF;
1365:

Line 1363: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);

1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: itg_msg.vendor_site_only;
1361: itg_debug.msg('Unexpected error (VendorSite sync) - ' || substr(SQLERRM,1,255),true);
1362: IF (l_Debug_Level <= 6) THEN
1363: itg_debug_pub.Add('EXITING - Sync_VendorSite :ERROR', 6);
1364: END IF;
1365:
1366:
1367: END Sync_VendorSite;

Line 1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);

1403: x_return_status := FND_API.G_RET_STS_SUCCESS;
1404: g_action := 'Vendor-contact parameter validation';
1405:
1406: IF (l_Debug_Level <= 2) THEN
1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);
1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);

Line 1408: itg_debug_pub.Add('p_title - ' || p_title, 2);

1404: g_action := 'Vendor-contact parameter validation';
1405:
1406: IF (l_Debug_Level <= 2) THEN
1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);
1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);

Line 1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);

1405:
1406: IF (l_Debug_Level <= 2) THEN
1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);
1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);
1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);

Line 1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);

1406: IF (l_Debug_Level <= 2) THEN
1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);
1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);
1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);
1414: END IF;

Line 1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);

1407: itg_debug_pub.Add('ENTERING - Sync_VendorContact', 2);
1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);
1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);
1414: END IF;
1415:

Line 1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);

1408: itg_debug_pub.Add('p_title - ' || p_title, 2);
1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);
1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);
1414: END IF;
1415:
1416: -- sync vendor

Line 1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);

1409: itg_debug_pub.Add('p_first_name - ' || p_first_name, 2);
1410: itg_debug_pub.Add('p_middle_name - ' || p_middle_name, 2);
1411: itg_debug_pub.Add('p_last_name - ' || p_last_name, 2);
1412: itg_debug_pub.Add('p_phone - ' || p_phone, 2);
1413: itg_debug_pub.Add('p_site_code - ' || p_site_code, 2);
1414: END IF;
1415:
1416: -- sync vendor
1417: SAVEPOINT Sync_VendorContact_PVT;

Line 1431: itg_debug_pub.Add('Getting vendor site ID - ' || l_vsite_id ,1);

1427: WHERE UPPER(vendor_site_code) = UPPER(p_site_code)
1428: AND vendor_id = p_vinfo_rec.vendor_id;
1429:
1430: IF (l_Debug_Level <= 1) THEN
1431: itg_debug_pub.Add('Getting vendor site ID - ' || l_vsite_id ,1);
1432: END IF;
1433: EXCEPTION
1434: WHEN NO_DATA_FOUND THEN
1435: itg_msg.no_vendor_site('vendor-sitecode:' || p_site_code);

Line 1456: itg_debug_pub.Add('Contact party id - ' || l_party_id ,1);

1452:
1453: l_found := true;
1454:
1455: IF (l_Debug_Level <= 1) THEN
1456: itg_debug_pub.Add('Contact party id - ' || l_party_id ,1);
1457: itg_debug_pub.Add('Contact obj version - ' || l_obj_ver_num ,1);
1458: END IF;
1459:
1460:

Line 1457: itg_debug_pub.Add('Contact obj version - ' || l_obj_ver_num ,1);

1453: l_found := true;
1454:
1455: IF (l_Debug_Level <= 1) THEN
1456: itg_debug_pub.Add('Contact party id - ' || l_party_id ,1);
1457: itg_debug_pub.Add('Contact obj version - ' || l_obj_ver_num ,1);
1458: END IF;
1459:
1460:
1461: EXCEPTION

Line 1464: itg_debug_pub.Add('SVC - Contact record not found, trying to add it' ,5);

1460:
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: IF (l_Debug_Level <= 5) THEN
1464: itg_debug_pub.Add('SVC - Contact record not found, trying to add it' ,5);
1465: END IF;
1466: l_found := false;
1467: END;
1468:

Line 1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);

1495: x_party_site_id => l_party_site_id
1496: );
1497:
1498: IF l_debug_level <= 1 THEN
1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);
1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );

Line 1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);

1496: );
1497:
1498: IF l_debug_level <= 1 THEN
1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);
1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );

Line 1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);

1497:
1498: IF l_debug_level <= 1 THEN
1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);
1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1505: END IF;

Line 1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );

1498: IF l_debug_level <= 1 THEN
1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);
1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1505: END IF;
1506:

Line 1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );

1499: itg_debug_pub.Add('Create_Vendor_Contact - ' || l_ret_status || ' - ' || l_msg_data ,1);
1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1505: END IF;
1506:
1507: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );

1500: itg_debug_pub.Add('l_per_party_id - ' || l_per_party_id,1);
1501: itg_debug_pub.Add('l_rel_party_id - ' || l_rel_party_id,1);
1502: itg_debug_pub.Add('l_rel_id - ' || l_rel_id,1 );
1503: itg_debug_pub.Add('l_org_contact_id - ' || l_org_contact_id,1 );
1504: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1505: END IF;
1506:
1507: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1508: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);

Line 1531: itg_debug_pub.Add('HZ_PARTY_V2PUB.update_person - ' || l_ret_status || ' - ' || l_msg_data ,1);

1527: x_msg_count => l_msg_count,
1528: x_msg_data => l_msg_data);
1529:
1530: IF l_debug_level <= 1 THEN
1531: itg_debug_pub.Add('HZ_PARTY_V2PUB.update_person - ' || l_ret_status || ' - ' || l_msg_data ,1);
1532: itg_debug_pub.Add('l_obj_ver_num - ' || l_msg_count,1);
1533: itg_debug_pub.Add('l_profile_id - ' || l_obj_ver_num,1);
1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );
1535:

Line 1532: itg_debug_pub.Add('l_obj_ver_num - ' || l_msg_count,1);

1528: x_msg_data => l_msg_data);
1529:
1530: IF l_debug_level <= 1 THEN
1531: itg_debug_pub.Add('HZ_PARTY_V2PUB.update_person - ' || l_ret_status || ' - ' || l_msg_data ,1);
1532: itg_debug_pub.Add('l_obj_ver_num - ' || l_msg_count,1);
1533: itg_debug_pub.Add('l_profile_id - ' || l_obj_ver_num,1);
1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );
1535:
1536: END IF;

Line 1533: itg_debug_pub.Add('l_profile_id - ' || l_obj_ver_num,1);

1529:
1530: IF l_debug_level <= 1 THEN
1531: itg_debug_pub.Add('HZ_PARTY_V2PUB.update_person - ' || l_ret_status || ' - ' || l_msg_data ,1);
1532: itg_debug_pub.Add('l_obj_ver_num - ' || l_msg_count,1);
1533: itg_debug_pub.Add('l_profile_id - ' || l_obj_ver_num,1);
1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );
1535:
1536: END IF;
1537:

Line 1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );

1530: IF l_debug_level <= 1 THEN
1531: itg_debug_pub.Add('HZ_PARTY_V2PUB.update_person - ' || l_ret_status || ' - ' || l_msg_data ,1);
1532: itg_debug_pub.Add('l_obj_ver_num - ' || l_msg_count,1);
1533: itg_debug_pub.Add('l_profile_id - ' || l_obj_ver_num,1);
1534: itg_debug_pub.Add('l_msg_count - ' || l_profile_id,1 );
1535:
1536: END IF;
1537:
1538: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1546: itg_debug_pub.Add('Committing work' ,1);

1542:
1543: END IF;
1544:
1545: IF (l_Debug_Level <= 1) THEN
1546: itg_debug_pub.Add('Committing work' ,1);
1547: END IF;
1548:
1549: COMMIT WORK;
1550:

Line 1552: itg_debug_pub.Add('EXTING - Sync_VendorContact', 2);

1548:
1549: COMMIT WORK;
1550:
1551: IF (l_Debug_Level <= 2) THEN
1552: itg_debug_pub.Add('EXTING - Sync_VendorContact', 2);
1553: END IF;
1554:
1555:
1556: EXCEPTION

Line 1564: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);

1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ITG_msg.checked_error(g_action);
1562: itg_msg.vendor_contact_only;
1563: IF (l_Debug_Level <= 6) THEN
1564: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);
1565: END IF;
1566:
1567:
1568: WHEN OTHERS THEN

Line 1574: itg_debug.msg('Unexpected error (VendorContact sync) - ' || substr(SQLERRM,1,255),true);

1570: commit;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1572: ITG_msg.unexpected_error(g_action);
1573: itg_msg.vendor_contact_only;
1574: itg_debug.msg('Unexpected error (VendorContact sync) - ' || substr(SQLERRM,1,255),true);
1575: IF (l_Debug_Level <= 6) THEN
1576: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);
1577: END IF;
1578:

Line 1576: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);

1572: ITG_msg.unexpected_error(g_action);
1573: itg_msg.vendor_contact_only;
1574: itg_debug.msg('Unexpected error (VendorContact sync) - ' || substr(SQLERRM,1,255),true);
1575: IF (l_Debug_Level <= 6) THEN
1576: itg_debug_pub.Add('EXTING - Sync_VendorContact :OTHER ERROR', 6);
1577: END IF;
1578:
1579: END Sync_VendorContact;
1580: