APPS.HZ_COPY_REL_PVT dependencies on HZ_RELATIONSHIP_V2PUB

Line 487: p_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;

483: (p_source_rel_type VARCHAR2, p_dest_rel_type VARCHAR2, p_rel_valid_date DATE,
484: x_return_status out NOCOPY VARCHAR2, x_msg_count out number, x_msg_data out VARCHAR2)
485: IS
486: /***** FOR CREATING RELATIONSHIPS **********/
487: p_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
488: x_relationship_id NUMBER;
489: x_party_id NUMBER;
490: x_party_number VARCHAR2(2000);
491: cursor c0

Line 527: hz_relationship_v2pub.get_relationship_rec(

523:
524: FOR id_cur in c0
525: LOOP
526: -- GET RELATIONSHIP RECORD
527: hz_relationship_v2pub.get_relationship_rec(
528: FND_API.G_FALSE,
529: id_cur.relationship_id,
530: 'F',
531: p_relationship_rec,

Line 546: hz_relationship_v2pub.create_relationship('T',p_relationship_rec,x_relationship_id,x_party_id,x_party_number,x_return_status,x_msg_count,x_msg_data,'');

542: p_relationship_rec.party_rec.party_number := NULL;
543: p_relationship_rec.created_by_module := 'HZ_COPY_SCRIPT_CREATED';
544:
545: -- CALL RELATIONSHIP API
546: hz_relationship_v2pub.create_relationship('T',p_relationship_rec,x_relationship_id,x_party_id,x_party_number,x_return_status,x_msg_count,x_msg_data,'');
547:
548:
549: -- RAISE HELL WHEN return status is not success
550:

Line 572: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');

568:
569: log('NEWLINE');
570:
571: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
572: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');
573: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
574: --FND_MSG_PUB.ADD;
575: l_message_text := FND_MESSAGE.GET;
576: log(l_message_text);

Line 831: p_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;

827: p_rel_valid_date DATE, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NUMBER,
828: x_msg_data OUT NOCOPY VARCHAR2)
829: IS
830: /***** FOR CREATING RELATIONSHIPS **********/
831: p_relationship_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
832: p_child NUMBER;
833: x_relationship_id NUMBER;
834: x_party_id NUMBER;
835: x_party_number VARCHAR2(2000);

Line 855: hz_relationship_v2pub.get_relationship_rec(

851:
852: FOR id_rec in c0
853: LOOP
854: -- GET RELATIONSHIP RECORD
855: hz_relationship_v2pub.get_relationship_rec(
856: FND_API.G_FALSE,
857: id_rec.relationship_id,
858: 'F',
859: p_relationship_rec,

Line 880: hz_relationship_v2pub.create_relationship('T',p_relationship_rec,x_relationship_id,

876: log('Relationship Id = ' || p_relationship_rec.relationship_id );
877: log('Relationship = ' || p_relationship_rec.relationship_code );
878: log('About to create relationship');
879: -- CALL RELATIONSHIP API
880: hz_relationship_v2pub.create_relationship('T',p_relationship_rec,x_relationship_id,
881: x_party_id,x_party_number,x_return_status,x_msg_count,x_msg_data,'');
882:
883:
884: IF x_return_status = FND_API.G_RET_STS_SUCCESS

Line 924: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');

920:
921: log('NEWLINE');
922:
923: FND_MESSAGE.SET_NAME('AR', 'HZ_COPY_REL_API_ERROR');
924: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_RELATIONSHIP_V2PUB.CREATE_RELATIONSHIP');
925: FND_MESSAGE.SET_TOKEN('ERROR' , SQLERRM);
926: -- FND_MSG_PUB.ADD;
927: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: l_message_text := FND_MESSAGE.GET;