DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HZ_CONTACT_POINT_V2PUB

Line 3516: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type; --B 7831956

3512: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type; --Bug6648405
3513: l_party_usg_validation_level NUMBER;
3514: l_debug_info VARCHAR2(500); -- Bug 6823885
3515:
3516: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type; --B 7831956
3517: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type; --B 7831956
3518: l_url_return_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS; --B 7831956
3519: l_url_msg_count NUMBER; --B 7831956
3520: l_url_msg_data VARCHAR2(1000); --B 7831956

Line 3517: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type; --B 7831956

3513: l_party_usg_validation_level NUMBER;
3514: l_debug_info VARCHAR2(500); -- Bug 6823885
3515:
3516: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type; --B 7831956
3517: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type; --B 7831956
3518: l_url_return_status VARCHAR2(50) := FND_API.G_RET_STS_SUCCESS; --B 7831956
3519: l_url_msg_count NUMBER; --B 7831956
3520: l_url_msg_data VARCHAR2(1000); --B 7831956
3521: l_url_contact_point_id NUMBER; --B 7831956

Line 3757: hz_contact_point_v2pub.create_web_contact_point(

3753: --Open Issue 5
3754: l_url_rec.web_type := 'HTTP';
3755: l_url_rec.url := l_vendor_rec.url ;
3756:
3757: hz_contact_point_v2pub.create_web_contact_point(
3758: p_init_msg_list => FND_API.G_FALSE,
3759: p_contact_point_rec => l_contact_point_rec,
3760: p_web_rec => l_url_rec,
3761: --p_commit => FND_API.G_FALSE,

Line 3768: l_debug_info := 'After call to hz_contact_point_v2pub.create_web_contact_point';

3764: x_msg_data => l_url_msg_data,
3765: x_contact_point_id => l_url_contact_point_id);
3766: IF l_url_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3767: ------------------------------------------------------------------------
3768: l_debug_info := 'After call to hz_contact_point_v2pub.create_web_contact_point';
3769: l_debug_info := l_debug_info||' Return status : '||l_url_return_status||' Error : '||l_url_msg_data;
3770: ------------------------------------------------------------------------
3771: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3772: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 13823: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

Line 13824: l_email_rec HZ_CONTACT_POINT_V2PUB.email_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;

Line 13825: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

Line 13826: l_alt_phone_rec HZ_CONTACT_POINT_V2PUB.phone_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:

Line 13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;

Line 13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_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;
13827: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
13828: l_url_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
13829: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
13830:
13831: l_user_id number := FND_GLOBAL.USER_ID;
13832: l_last_update_login number := FND_GLOBAL.LOGIN_ID;

Line 14305: hz_contact_point_v2pub.create_phone_contact_point(

14301: -- Changed the phone line type to GEN.
14302: --
14303: l_phone_rec.phone_line_type := 'GEN';
14304:
14305: hz_contact_point_v2pub.create_phone_contact_point(
14306: p_init_msg_list => FND_API.G_FALSE,
14307: p_contact_point_rec => l_contact_point_rec,
14308: p_phone_rec => l_phone_rec,
14309: --p_commit => FND_API.G_FALSE,

Line 14317: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Primary Phone';

14313: x_contact_point_id => l_phone_contact_point_id);
14314:
14315: IF l_phone_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14316: ------------------------------------------------------------------------
14317: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Primary Phone';
14318: l_debug_info := l_debug_info||' Return status : '||l_phone_return_status||' Error : '||l_phone_msg_data;
14319: ------------------------------------------------------------------------
14320: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14321: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 14390: hz_contact_point_v2pub.create_phone_contact_point(

14386: -- Changed the phone line type to GEN.
14387: --
14388: l_alt_phone_rec.phone_line_type := 'GEN';
14389:
14390: hz_contact_point_v2pub.create_phone_contact_point(
14391: p_init_msg_list => FND_API.G_FALSE,
14392: p_contact_point_rec => l_contact_point_rec,
14393: p_phone_rec => l_alt_phone_rec,
14394: --p_commit => FND_API.G_FALSE,

Line 14402: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Alt Phone';

14398: x_contact_point_id => l_alt_phone_contact_point_id);
14399:
14400: IF l_alt_phone_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14401: ------------------------------------------------------------------------
14402: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Alt Phone';
14403: l_debug_info := l_debug_info||' Return status : '||l_alt_phone_return_status||' Error : '||l_alt_phone_msg_data;
14404: ------------------------------------------------------------------------
14405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14406: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 14471: hz_contact_point_v2pub.create_phone_contact_point(

14467: l_fax_rec.phone_area_code := l_vendor_contact_rec.fax_area_code;
14468: l_fax_rec.phone_number := l_vendor_contact_rec.fax_phone;
14469: l_fax_rec.phone_line_type := 'FAX';
14470:
14471: hz_contact_point_v2pub.create_phone_contact_point(
14472: p_init_msg_list => FND_API.G_FALSE,
14473: p_contact_point_rec => l_contact_point_rec,
14474: p_phone_rec => l_fax_rec,
14475: --p_commit => FND_API.G_FALSE,

Line 14483: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Fax Phone';

14479: x_contact_point_id => l_fax_contact_point_id);
14480:
14481: IF l_fax_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14482: ------------------------------------------------------------------------
14483: l_debug_info := 'After call to hz_contact_point_v2pub.create_phone_contact_point Fax Phone';
14484: l_debug_info := l_debug_info||' Return status : '||l_fax_return_status||' Error : '||l_fax_msg_data;
14485: ------------------------------------------------------------------------
14486: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 14549: hz_contact_point_v2pub.create_email_contact_point(

14545: l_contact_point_rec.contact_point_purpose := 'BUSINESS';
14546: l_contact_point_rec.primary_by_purpose := 'N';
14547: l_email_rec.email_address := l_vendor_contact_rec.email_address;
14548:
14549: hz_contact_point_v2pub.create_email_contact_point(
14550: p_init_msg_list => FND_API.G_FALSE,
14551: p_contact_point_rec => l_contact_point_rec,
14552: p_email_rec => l_email_rec,
14553: --p_commit => FND_API.G_FALSE,

Line 14561: l_debug_info := 'After call to hz_contact_point_v2pub.create_email_contact_point';

14557: x_contact_point_id => l_email_contact_point_id);
14558:
14559: IF l_email_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14560: ------------------------------------------------------------------------
14561: l_debug_info := 'After call to hz_contact_point_v2pub.create_email_contact_point';
14562: l_debug_info := l_debug_info||' Return status : '||l_email_return_status||' Error : '||l_email_msg_data;
14563: ------------------------------------------------------------------------
14564: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14565: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 14629: hz_contact_point_v2pub.create_web_contact_point(

14625: --Open Issue 5
14626: l_url_rec.web_type := 'HTTP';
14627: l_url_rec.url := l_vendor_contact_rec.url;
14628:
14629: hz_contact_point_v2pub.create_web_contact_point(
14630: p_init_msg_list => FND_API.G_FALSE,
14631: p_contact_point_rec => l_contact_point_rec,
14632: p_web_rec => l_url_rec,
14633: --p_commit => FND_API.G_FALSE,

Line 14641: l_debug_info := 'After call to hz_contact_point_v2pub.create_web_contact_point';

14637: x_contact_point_id => l_url_contact_point_id);
14638:
14639: IF l_url_return_status <> FND_API.G_RET_STS_SUCCESS THEN
14640: ------------------------------------------------------------------------
14641: l_debug_info := 'After call to hz_contact_point_v2pub.create_web_contact_point';
14642: l_debug_info := l_debug_info||' Return status : '||l_url_return_status||' Error : '||l_url_msg_data;
14643: ------------------------------------------------------------------------
14644: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);