815: open l_primary_contact_fax_csr(p_object_id1);
816: fetch l_primary_contact_fax_csr into L_FAX_COUNTRY_CODE,L_FAX_AREA_CODE,L_FAX_NUMBER,L_FAX_EXTENSION;
817: close l_primary_contact_fax_csr;
818:
819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
816: fetch l_primary_contact_fax_csr into L_FAX_COUNTRY_CODE,L_FAX_AREA_CODE,L_FAX_NUMBER,L_FAX_EXTENSION;
817: close l_primary_contact_fax_csr;
818:
819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
817: close l_primary_contact_fax_csr;
818:
819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
818:
819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);
821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);
829:
822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_CODE);
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);
829:
830:
823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);
829:
830:
831:
824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);
825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);
826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_CODE);
827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);
828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);
829:
830:
831:
832:
829:
830:
831:
832:
833: return FND_MESSAGE.get;
834: end;
835:
836: -- Currentely it's hardcoded for Contracts for Sales
837: -- When ADDRESS is required for any ORG JTF SOURCE we will retrieve it