[Home] [Help]
442: -- Validate Contact Type
443: --
444: IF p_new_contact_rec.contact_type IS NULL
445: THEN
446: CS_SERVICEREQUEST_UTIL.add_null_parameter_msg
447: ( p_token_an => l_api_name_full
448: , p_token_np => 'p_contacts.contact_type'
449: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
450: , p_column_name => 'CONTACT_TYPE'
460: p_new_contact_rec.contact_type = 'EMPLOYEE'
461: THEN
462: NULL;
463: ELSE
464: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
465: ( p_token_an => l_api_name_full
466: , p_token_v => p_new_contact_rec.contact_type
467: , p_token_p => 'p_contacts.contact_type'
468: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
480: THEN
481: NULL;
482: -- contact type is valid. do nothing.
483: ELSE
484: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
485: p_token_an => l_api_name_full,
486: p_token_v => p_new_contact_rec.contact_type,
487: p_token_p => 'p_contacts.contact_type' ,
488: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
495: -- Validate Contact Party
496: --
497: IF p_new_contact_rec.party_id IS NULL
498: THEN
499: CS_SERVICEREQUEST_UTIL.add_null_parameter_msg
500: ( p_token_an => l_api_name_full,
501: p_token_np => 'p_contacts.party_id',
502: p_table_name => 'CS_HZ_SR_CONTACT_POINTS',
503: p_column_name => 'PARTY_ID'
507: p_new_contact_rec.party_id <> NVL(p_old_contact_rec.party_id , -1 ) OR
508: p_new_contact_rec.party_role_code <> NVL(p_old_contact_rec.party_role_code, 'CONTACT'))
509: THEN
510: IF (p_new_contact_rec.contact_type = 'EMPLOYEE') THEN
511: CS_ServiceRequest_UTIL.Validate_Employee
512: ( p_api_name => l_api_name_full
513: , p_parameter_name => 'p_employee_id'
514: , p_employee_id => p_new_contact_rec.party_id
515: , p_org_id => NULL
521: -- so if party role is CONTACT then do not validation relationship between
522: -- SR customer and contact party. contact party should merely exist in
523: -- hz_parties table
524: THEN
525: CS_SERVICEREQUEST_UTIL.get_party_details
526: ( p_party_id => p_new_contact_rec.party_id
527: , x_party_type => l_party_type
528: , x_status => l_status
529: , x_return_status => x_return_status
562: -- This part means party role is not contact and contact type is not employee
563: -- so validate contact party and SR customer using relationship between them
564: IF p_caller_type = 'ORGANIZATION'
565: THEN
566: CS_ServiceRequest_UTIL.Validate_Org_Relationship
567: ( p_api_name => l_api_name_full,
568: p_parameter_name => 'p_party_id',
569: p_customer_contact_id => p_new_contact_rec.party_id,
570: p_customer_id => p_customer_id,
570: p_customer_id => p_customer_id,
571: p_org_id => NULL,
572: x_return_status => x_return_status) ;
573: ELSE
574: CS_ServiceRequest_UTIL.Validate_Person_Relationship
575: ( p_api_name => l_api_name_full,
576: p_parameter_name => 'p_party_id',
577: p_customer_contact_id => p_new_contact_rec.party_id,
578: p_customer_id => p_customer_id,
591: IF (p_new_contact_rec.contact_point_type IS NOT NULL AND
592: p_new_contact_rec.contact_point_type <>
593: NVL(p_old_contact_rec.contact_point_type,'-9'))
594: THEN
595: CS_ServiceRequest_UTIL.validate_contact_point_type
596: ( p_api_name => l_api_name_full
597: , p_parameter_name => 'p_contact_point_type'
598: , p_contact_point_type => p_new_contact_rec.contact_point_type
599: , x_return_status => x_return_status
612: THEN
613: IF p_new_contact_rec.contact_type = 'EMPLOYEE'
614: THEN
615: IF (p_new_contact_rec.contact_point_type = 'PHONE') THEN
616: CS_ServiceRequest_UTIL.Validate_Emp_Contact_Point_Id
617: ( p_api_name => l_api_name_full
618: , p_parameter_name => 'p_contact_point_id'
619: , p_employee_id => p_new_contact_rec.party_id
620: , p_contact_point_id => p_new_contact_rec.contact_point_id
622: ELSIF (p_new_contact_rec.contact_point_type <> 'EMAIL') THEN
623: -- Added this logic for bug#2626855, if the contact_type is
624: -- Employee and the contact_point_type is other than email or
625: -- phone then give error else success.
626: CS_SERVICEREQUEST_UTIL.add_invalid_argument_msg
627: ( p_token_an => l_api_name_full
628: , p_token_v => p_new_contact_rec.contact_point_type
629: , p_token_p => 'p_contact_point_type'
630: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
632: );
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: END IF;
635: ELSE -- Contact type is either PERSON or PARTY_RELATIONSHIP
636: CS_ServiceRequest_UTIL.Validate_Per_Contact_Point_Id
637: ( p_api_name => l_api_name_full
638: , p_parameter_name => 'p_contact_point_id'
639: , p_contact_point_type => p_new_contact_rec.contact_point_type
640: , p_contact_point_id => p_new_contact_rec.contact_point_id
652: --
653: IF p_new_contact_rec.party_role_code IS NOT NULL AND
654: p_new_contact_rec.party_role_code <> NVL(p_old_contact_rec.party_role_code,'#')
655: THEN
656: CS_SERVICEREQUEST_UTIL.validate_party_role_code
657: ( p_new_contact_rec.party_role_code
658: , x_return_status
659: );
660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1254: IF l_contact_party_role_found > 0
1255: THEN
1256: IF l_primary_found >= 2
1257: THEN
1258: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
1259: ( p_token_an => l_api_name_full
1260: , p_token_v => 'Y'
1261: , p_token_p => 'p_contacts.primary_flag'
1262: , p_table_name => 'CS_HZ_SR_CONTACT_POINTS'
1278: CLOSE c_primary_count;
1279: END IF;
1280: IF l_existing_primary = 0
1281: THEN
1282: CS_SERVICEREQUEST_UTIL.add_null_parameter_msg
1283: ( p_token_an => l_api_name_full
1284: , p_token_np => 'Primary Contact Information'
1285: );
1286: RAISE FND_API.G_EXC_ERROR;