DBA Data[Home] [Help]

APPS.OKC_QUERY dependencies on FND_MESSAGE

Line 819: FND_MESSAGE.SET_NAME(application => 'OKC', name => 'OKC_GET_CONTACT');

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);

Line 820: FND_MESSAGE.SET_TOKEN(token => 'EMAIL_ADDRESS' , value => L_EMAIL_ADDRESS);

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);

Line 821: FND_MESSAGE.SET_TOKEN(token => 'PHONE_COUNTRY_CODE' , value => L_PHONE_COUNTRY_CODE);

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);

Line 822: FND_MESSAGE.SET_TOKEN(token => 'PHONE_AREA_CODE' , value => L_PHONE_AREA_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);

Line 823: FND_MESSAGE.SET_TOKEN(token => 'PHONE_NUMBER' , value => L_PHONE_NUMBER);

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);

Line 824: FND_MESSAGE.SET_TOKEN(token => 'PHONE_EXTENSION' , value => L_PHONE_EXTENSION);

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);

Line 825: FND_MESSAGE.SET_TOKEN(token => 'FAX_COUNTRY_CODE' , value => L_FAX_COUNTRY_CODE);

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:

Line 826: FND_MESSAGE.SET_TOKEN(token => 'FAX_AREA_CODE' , value => L_FAX_AREA_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:
830:

Line 827: FND_MESSAGE.SET_TOKEN(token => 'FAX_NUMBER' , value => L_FAX_NUMBER);

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:

Line 828: FND_MESSAGE.SET_TOKEN(token => 'FAX_EXTENSION' , value => L_FAX_EXTENSION);

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:

Line 833: return FND_MESSAGE.get;

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