DBA Data[Home] [Help]

APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_VENDOR_PUB_PKG

Line 14: x IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,

10:
11:
12: -- replace * with column listing
13: PROCEDURE get_vendorsite_rec(
14: x IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
15: p_vendorsite_id IN NUMBER,
16: p_vendor_id IN NUMBER) IS
17: BEGIN
18:

Line 118: x IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,

114: END;
115:
116: -- replace * with column listing
117: PROCEDURE get_vendor_rec(
118: x IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
119: p_vendor_id IN NUMBER) IS
120: BEGIN
121: g_action := 'vendor details lookup';
122: IF l_debug_level <= 1 then

Line 372: (r_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,

368: END;
369:
370:
371: PROCEDURE default_vendor_params
372: (r_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
373: vinfo_rec IN OUT NOCOPY vinfo_rec_type,
374: x_org IN OUT NOCOPY VARCHAR2)
375: IS
376: l_dummy_char VARCHAR2(200);

Line 496: r_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;

492: p_date IN DATE := NULL, /* controlarea.datetime */
493: p_org IN VARCHAR2, /* MOAC */
494: x_vinfo_rec OUT NOCOPY vinfo_rec_type
495: ) IS
496: r_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;
497: l_org_rec HZ_PARTY_V2PUB.organization_rec_type; --To Fix Bug :5186022
498: l_party_object_version_number NUMBER;
499: l_profile_id number;
500: l_party_number VARCHAR2(30);

Line 628: ap_vendor_pub_pkg.Create_Vendor(

624: IF l_debug_level <= 1 THEN
625: itg_debug_pub.add('Call to create vendor',1);
626: END IF;
627:
628: ap_vendor_pub_pkg.Create_Vendor(
629: p_api_version => '1.0',
630: x_return_status => l_ret_status,
631: x_msg_count => l_ret_count,
632: x_msg_data => l_ret_msg,

Line 648: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));

644: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
645: IF l_debug_level <= 6 THEN
646: itg_debug_pub.add('Error occured in Create Vendor',6);
647: END IF;
648: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor',l_ret_status,substr(l_ret_msg,1,200));
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652: g_action := 'verifying vendor_number';

Line 749: ap_vendor_pub_pkg.update_vendor(

745: IF (l_Debug_Level <= 1) THEN
746: itg_debug_pub.Add('SV - vendor_id'||r_vendor_rec.vendor_id ,1);
747: END IF;
748:
749: ap_vendor_pub_pkg.update_vendor(
750: p_api_version => '1.0',
751: x_return_status => l_ret_status,
752: x_msg_count => l_ret_count,
753: x_msg_data => l_ret_msg,

Line 815: 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));

811: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
812: IF l_debug_level <= 6 THEN
813: itg_debug_pub.add('Error occured in update Vendor or update organization',6);
814: END IF;
815: 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));
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819:

Line 968: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

964: l_party_id NUMBER;
965: l_location_id NUMBER;
966: l_ven_rec ap_vendors_v%ROWTYPE;
967: l_api_name VARCHAR2(50);
968: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
969: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
970: p_object_version_number NUMBER;
971: l_ship_to_location_id financials_system_params_all.ship_to_location_id%TYPE;
972: l_bill_to_location_id financials_system_params_all.bill_to_location_id%TYPE;

Line 1170: l_api_name := 'ap_vendor_pub_pkg.create_vendor_site';

1166: l_vendorsite_rec.match_option := 'P';
1167: l_vendorsite_rec.vendor_id := p_vinfo_rec.vendor_id;
1168: l_vendorsite_rec.org_id := p_org;
1169:
1170: l_api_name := 'ap_vendor_pub_pkg.create_vendor_site';
1171: ap_vendor_pub_pkg.create_vendor_site
1172: (
1173: p_api_version => '1.0',
1174: x_return_status => l_return_status,

Line 1171: ap_vendor_pub_pkg.create_vendor_site

1167: l_vendorsite_rec.vendor_id := p_vinfo_rec.vendor_id;
1168: l_vendorsite_rec.org_id := p_org;
1169:
1170: l_api_name := 'ap_vendor_pub_pkg.create_vendor_site';
1171: ap_vendor_pub_pkg.create_vendor_site
1172: (
1173: p_api_version => '1.0',
1174: x_return_status => l_return_status,
1175: x_msg_count => l_msg_count,

Line 1234: l_api_name := 'ap_vendor_pub_pkg.update_vendor_site';

1230:
1231: IF (l_Debug_Level <= 1) THEN
1232: itg_debug_pub.add('Calling ap_vendors_pub_pkg.update_vendor_site');
1233: END IF;
1234: l_api_name := 'ap_vendor_pub_pkg.update_vendor_site';
1235: ap_vendor_pub_pkg.update_vendor_site
1236: (
1237: p_api_version => '1.0',
1238: x_return_status => l_return_status,

Line 1235: ap_vendor_pub_pkg.update_vendor_site

1231: IF (l_Debug_Level <= 1) THEN
1232: itg_debug_pub.add('Calling ap_vendors_pub_pkg.update_vendor_site');
1233: END IF;
1234: l_api_name := 'ap_vendor_pub_pkg.update_vendor_site';
1235: ap_vendor_pub_pkg.update_vendor_site
1236: (
1237: p_api_version => '1.0',
1238: x_return_status => l_return_status,
1239: x_msg_count => l_msg_count,

Line 1386: r_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

1382: p_site_code IN VARCHAR2, /* userarea.ref_sitecode */
1383:
1384: p_vinfo_rec IN vinfo_rec_type
1385: ) IS
1386: r_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
1387: l_found Boolean;
1388: l_ret_status varchar2(20);
1389: l_msg_data varchar2(2000);
1390: l_ret_msg varchar2(2000);

Line 1485: Ap_vendor_pub_pkg.Create_Vendor_Contact

1481: r_vendor_contact_rec.VENDOR_SITE_ID := l_vsite_id;
1482: r_vendor_contact_rec.VENDOR_ID := p_vinfo_rec.vendor_id;
1483: r_vendor_contact_rec.PERSON_TITLE := p_title;
1484:
1485: Ap_vendor_pub_pkg.Create_Vendor_Contact
1486: (
1487: p_api_version => 1.0,
1488: x_return_status => l_ret_status,
1489: x_msg_count => l_msg_count,

Line 1510: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);

1506: itg_debug_pub.Add('l_party_site_id - ' || l_party_site_id,1 );
1507: END IF;
1508:
1509: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
1510: itg_msg.apicallret('Ap_vendor_pub_pkg.Create_Vendor_Contact',l_ret_status,l_msg_data);
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513: ELSE
1514: g_action := 'Vendor-contact record update';