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.HZ_EMAIL_DOMAINS_V2PUB dependencies on HZ_EMAIL_DOMAINS

Line 1: PACKAGE BODY HZ_EMAIL_DOMAINS_V2PUB AS

1: PACKAGE BODY HZ_EMAIL_DOMAINS_V2PUB AS
2: /*$Header: ARH2EMDB.pls 120.14 2005/06/16 21:07:20 jhuang noship $ */
3:
4: g_debug_count NUMBER := 0;
5: --g_debug BOOLEAN := FALSE;

Line 182: --UPDATE HZ_EMAIL_DOMAINS

178: x_to_id <> p_from_id) THEN
179:
180: --commented out because this part we are doing in email_domain_merge
181: --procedure
182: --UPDATE HZ_EMAIL_DOMAINS
183: --SET
184: -- STATUS = 'M',
185: -- last_update_date = hz_utility_pub.last_update_date,
186: -- last_updated_by = hz_utility_pub.user_id,

Line 191: UPDATE HZ_EMAIL_DOMAINS

187: -- last_update_login = hz_utility_pub.last_update_login
188: --WHERE email_domain_id = p_from_id;
189: --ELSE
190: -- Update and set party_id = p_to_fk_id where pk = from_id
191: UPDATE HZ_EMAIL_DOMAINS
192: SET
193: party_id = p_to_fk_id,
194: last_update_date = hz_utility_pub.last_update_date,
195: last_updated_by = hz_utility_pub.user_id,

Line 280: * This API will insert a row into the HZ_EMAIL_DOMAINS table. It should

276: /**
277: * PROCEDURE create_email_domain
278: *
279: * DESCRIPTION
280: * This API will insert a row into the HZ_EMAIL_DOMAINS table. It should
281: * internally call the function defined above (transpose_domain), and
282: * insert the transposed value as well.
283: *
284: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 321: FROM hz_email_domains

317:
318: CURSOR c_unique_email_domain ( p_party_id IN NUMBER,
319: p_domain_name IN VARCHAR2) IS
320: SELECT 'Y'
321: FROM hz_email_domains
322: WHERE party_id = p_party_id
323: AND domain_name = p_domain_name;
324:
325: BEGIN

Line 420: -- Insert into HZ_EMAIL_DOMAINS

416: p_column_value => p_domain_name,
417: x_return_status => x_return_status);
418:
419: -------------------------------
420: -- Insert into HZ_EMAIL_DOMAINS
421: -------------------------------
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;

Line 426: INSERT INTO HZ_EMAIL_DOMAINS(

422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: INSERT INTO HZ_EMAIL_DOMAINS(
427: EMAIL_DOMAIN_ID
428: , PARTY_ID
429: , TRANSPOSED_DOMAIN
430: , DOMAIN_NAME

Line 437: hz_email_domains_s.nextval

433: , LAST_UPDATE_LOGIN
434: , LAST_UPDATE_DATE
435: , LAST_UPDATED_BY
436: , CREATED_BY ) VALUES (
437: hz_email_domains_s.nextval
438: , p_party_id
439: , transpose_domain( p_domain_name)
440: , p_domain_name
441: , 'A'

Line 520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',

516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
518: check_params(p_entity_name, p_from_id, l_to_id, NULL,
519: p_from_id, p_par_entity_name,
520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',
521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',
522: 'EMAIL_DOMAIN_ID', 'PARTY_ID',x_return_status);
523:
524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

Line 521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',

517:
518: check_params(p_entity_name, p_from_id, l_to_id, NULL,
519: p_from_id, p_par_entity_name,
520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',
521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',
522: 'EMAIL_DOMAIN_ID', 'PARTY_ID',x_return_status);
523:
524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
525: l_dup_exists := HZ_EMAIL_DOMAINS_V2PUB.check_email_domain_dup(

Line 525: l_dup_exists := HZ_EMAIL_DOMAINS_V2PUB.check_email_domain_dup(

521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',
522: 'EMAIL_DOMAIN_ID', 'PARTY_ID',x_return_status);
523:
524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
525: l_dup_exists := HZ_EMAIL_DOMAINS_V2PUB.check_email_domain_dup(
526: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
527: x_return_status);
528: END IF;
529:

Line 530: --since hz_email_domains does n't has its own id, p_from_id=p_from_fk_id

526: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
527: x_return_status);
528: END IF;
529:
530: --since hz_email_domains does n't has its own id, p_from_id=p_from_fk_id
531: --and p_to_fk_id = party_id
532: IF (x_return_status =FND_API.G_RET_STS_SUCCESS AND l_dup_exists = FND_API.G_FALSE) THEN
533:
534: do_email_domain_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,

Line 537: UPDATE HZ_EMAIL_DOMAINS

533:
534: do_email_domain_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
535: x_return_status);
536: ELSIF (l_dup_exists = FND_API.G_TRUE) THEN
537: UPDATE HZ_EMAIL_DOMAINS
538: SET
539: STATUS = 'M',
540: last_update_date = hz_utility_pub.last_update_date,
541: last_updated_by = hz_utility_pub.user_id,

Line 566: FROM HZ_EMAIL_DOMAINS

562: RETURN VARCHAR2 IS
563:
564: CURSOR dupcheck IS
565: SELECT PARTY_ID
566: FROM HZ_EMAIL_DOMAINS
567: WHERE party_id = p_to_fk_id
568: AND DOMAIN_NAME = ( SELECT DOMAIN_NAME
569: FROM HZ_EMAIL_DOMAINS
570: WHERE EMAIL_DOMAIN_ID= p_from_id);

Line 569: FROM HZ_EMAIL_DOMAINS

565: SELECT PARTY_ID
566: FROM HZ_EMAIL_DOMAINS
567: WHERE party_id = p_to_fk_id
568: AND DOMAIN_NAME = ( SELECT DOMAIN_NAME
569: FROM HZ_EMAIL_DOMAINS
570: WHERE EMAIL_DOMAIN_ID= p_from_id);
571:
572: l_record_id NUMBER;
573:

Line 716: from hz_email_domains

712: IF p_context = 'STAGE'
713: THEN
714: FOR email_domains_cur in
715: (select domain_name
716: from hz_email_domains
717: where party_id = p_party_id)
718: LOOP
719: l_ret_str := l_ret_str || ' ' || ltrim(rtrim(email_domains_cur.domain_name)) ;
720: END LOOP;

Line 727: from hz_email_domains

723: (
724: select d_name
725: from
726: (select domain_name as d_name
727: from hz_email_domains
728: where party_id = p_party_id
729: order by length(domain_name)
730: )
731: where rownum = 1

Line 743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

739: return l_ret_str ;
740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');
745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

823: return retstr;
824:
825: EXCEPTION
826: WHEN OTHERS THEN
827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');
829: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
830: FND_MSG_PUB.ADD;
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');

1010: return retstr;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1027: END HZ_EMAIL_DOMAINS_V2PUB;

1023:
1024:
1025:
1026:
1027: END HZ_EMAIL_DOMAINS_V2PUB;
1028:
1029: