DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HZ_PARTY_SITE_V2PUB

Line 7688: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;

7684: l_api_name CONSTANT VARCHAR2(30) := 'Create_Vendor_Site';
7685: l_api_version CONSTANT NUMBER := 1.0;
7686:
7687: l_def_org_id NUMBER;
7688: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
7689: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
7690:
7691: -- variables for retrieving defaults from PO_VENDORS
7692: l_rowid VARCHAR2(255);

Line 7930: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

7926: l_employee_id ap_suppliers.employee_id%type; --bug 12835899
7927: l_create_awt_dists_type ap_system_parameters_all.create_awt_dists_type%type; --bug 13092500
7928:
7929: /* Bug 12334398 start */
7930: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
7931: l_site_use_return_status VARCHAR2(50) := 'S';
7932: l_site_use_msg_count NUMBER;
7933: l_site_use_msg_data VARCHAR2(2000);
7934: l_party_site_use_id NUMBER;

Line 8611: hz_party_site_v2pub.create_party_site(

8607: INTO l_party_site_rec.party_site_number
8608: FROM DUAL;
8609: END IF;
8610: -- udhenuko Bug 6823885 End
8611: hz_party_site_v2pub.create_party_site(
8612: p_init_msg_list => FND_API.G_FALSE,
8613: p_party_site_rec => l_party_site_rec,
8614: --p_commit => FND_API.G_FALSE,
8615: x_return_status => l_site_return_status,

Line 8622: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site';

8618: x_party_site_id => l_party_site_id,
8619: x_party_site_number => l_party_site_number);
8620: IF l_site_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8621: ------------------------------------------------------------------------
8622: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site';
8623: l_debug_info := l_debug_info||' Return status : '||l_site_return_status||' Error : '||l_site_msg_data;
8624: ------------------------------------------------------------------------
8625: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8626: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8643: hz_party_site_v2pub.create_party_site_use (

8639: l_party_site_use_rec.application_id :=200;
8640:
8641: IF(l_vendor_site_rec.pay_site_flag = 'Y') THEN
8642: l_party_site_use_rec.SITE_USE_TYPE := 'PAY';
8643: hz_party_site_v2pub.create_party_site_use (
8644: p_init_msg_list => 'F',
8645: p_party_site_use_rec => l_party_site_use_rec,
8646: x_party_site_use_id => l_party_site_use_id,
8647: x_return_status => l_site_use_return_status,

Line 8652: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for PAY';

8648: x_msg_count => l_site_use_msg_count,
8649: x_msg_data => l_site_use_msg_data);
8650: IF l_site_use_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8651: ------------------------------------------------------------------------
8652: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for PAY';
8653: l_debug_info := l_debug_info||' Return status : ' || l_site_use_return_status ||' Error : '|| l_site_use_msg_data;
8654: ------------------------------------------------------------------------
8655: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8663: hz_party_site_v2pub.create_party_site_use (

8659: END IF;
8660:
8661: IF(l_vendor_site_rec.rfq_only_site_flag = 'Y') THEN
8662: l_party_site_use_rec.SITE_USE_TYPE := 'RFQ';
8663: hz_party_site_v2pub.create_party_site_use (
8664: p_init_msg_list => 'F',
8665: p_party_site_use_rec => l_party_site_use_rec,
8666: x_party_site_use_id => l_party_site_use_id,
8667: x_return_status => l_site_use_return_status,

Line 8672: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for RFQ';

8668: x_msg_count => l_site_use_msg_count,
8669: x_msg_data => l_site_use_msg_data);
8670: IF l_site_use_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8671: ------------------------------------------------------------------------
8672: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for RFQ';
8673: l_debug_info := l_debug_info||' Return status : ' || l_site_use_return_status ||' Error : ' || l_site_use_msg_data;
8674: ------------------------------------------------------------------------
8675: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8676: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 8683: hz_party_site_v2pub.create_party_site_use (

8679: END IF;
8680:
8681: IF(l_vendor_site_rec.purchasing_site_flag = 'Y') THEN
8682: l_party_site_use_rec.SITE_USE_TYPE := 'PURCHASING';
8683: hz_party_site_v2pub.create_party_site_use (
8684: p_init_msg_list => 'F',
8685: p_party_site_use_rec => l_party_site_use_rec,
8686: x_party_site_use_id => l_party_site_use_id,
8687: x_return_status => l_site_use_return_status,

Line 8692: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for PURCHASING';

8688: x_msg_count => l_site_use_msg_count,
8689: x_msg_data => l_site_use_msg_data);
8690: IF l_site_use_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8691: ------------------------------------------------------------------------
8692: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site_use for PURCHASING';
8693: l_debug_info := l_debug_info||' Return status : ' || l_site_use_return_status ||' Error : ' || l_site_use_msg_data;
8694: ------------------------------------------------------------------------
8695: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8696: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 13822: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;

13818: l_party_rec HZ_PARTY_V2PUB.party_rec_type;
13819: l_per_rec HZ_PARTY_V2PUB.person_rec_type;
13820: l_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
13821: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
13822: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
13823: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
13824: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
13825: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13826: l_alt_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

Line 14207: hz_party_site_v2pub.create_party_site(

14203: FROM DUAL;
14204: END IF;
14205: -- udhenuko Bug 6823885 End
14206:
14207: hz_party_site_v2pub.create_party_site(
14208: p_init_msg_list => FND_API.G_FALSE,
14209: p_party_site_rec => l_party_site_rec,
14210: --p_commit => FND_API.G_FALSE,
14211: x_return_status => l_site_return_status,

Line 14219: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site';

14215: x_party_site_number => l_party_site_number);
14216:
14217: IF l_site_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14218: ------------------------------------------------------------------------
14219: l_debug_info := 'After call to hz_party_site_v2pub.create_party_site';
14220: l_debug_info := l_debug_info||' Return status : '||l_site_return_status||' Error : '||l_site_msg_data;
14221: ------------------------------------------------------------------------
14222: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14223: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);