APPS.OKS_EXTWAR_UTIL_PUB dependencies on FND_PROFILE

Line 741: l_setup_admin VARCHAR2(200) := FND_PROFILE.VALUE('OKS_SETUP_ADMIN_ID');

737: return(l_mesg);
738: END GET_FND_MESSAGE;
739:
740: PROCEDURE NOTIFY_SETUP_ADMIN IS
741: l_setup_admin VARCHAR2(200) := FND_PROFILE.VALUE('OKS_SETUP_ADMIN_ID');
742: BEGIN
743: null;
744: IF l_setup_admin IS NOT NULL THEN
745: OKS_EXTWAR_UTIL_PUB.NOTIFY('NSA',l_setup_admin,NULL,NULL,NULL,'Profile Vendor Contact Role Not Set Up');

Line 778: l_terr_admin_id := FND_PROFILE.VALUE('OKS_TERR_ADMIN_ID');

774: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
775: 'Inside NOTIFY_TERRITORY_ADMIN');
776: END IF;
777:
778: l_terr_admin_id := FND_PROFILE.VALUE('OKS_TERR_ADMIN_ID');
779: l_subj := FND_MESSAGE.get_string('OKS','OKS_TERR_SETUP_ERR_SUB');
780: IF (l_terr_admin_id IS NULL) THEN
781: l_contract_admin_id := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');
782: END IF;

Line 781: l_contract_admin_id := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');

777:
778: l_terr_admin_id := FND_PROFILE.VALUE('OKS_TERR_ADMIN_ID');
779: l_subj := FND_MESSAGE.get_string('OKS','OKS_TERR_SETUP_ERR_SUB');
780: IF (l_terr_admin_id IS NULL) THEN
781: l_contract_admin_id := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');
782: END IF;
783: IF l_terr_admin_id IS NOT NULL THEN
784: OPEN l_fnd_csr(l_terr_admin_id);
785: FETCH l_fnd_csr INTO l_user_name;

Line 800: l_user_name := FND_PROFILE.VALUE('OKC_K_APPROVER');

796: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
797: 'Contract Admin is not null - ' || l_user_name);
798: END IF;
799: ELSE
800: l_user_name := FND_PROFILE.VALUE('OKC_K_APPROVER');
801: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
803: 'Contract Approver is not null - ' || l_user_name);
804: END IF;

Line 831: l_contract_admin VARCHAR2(200) := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');

827: END IF;
828: END NOTIFY_TERRITORY_ADMIN;
829:
830: PROCEDURE NOTIFY_CONTRACT_ADMIN (p_chr_id IN Number, p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2, p_mesg IN VARCHAR2) IS
831: l_contract_admin VARCHAR2(200) := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');
832: BEGIN
833:
834: IF l_contract_admin IS NOT NULL THEN
835: OKS_EXTWAR_UTIL_PUB.NOTIFY('NCA',l_contract_admin,p_chr_id,p_contract_number,p_contract_number_modifier,p_mesg);

Line 841: --l_salesperson_id VARCHAR2(200) := FND_PROFILE.VALUE('OKS_SALESPERSON_ID');

837: END IF;
838: END NOTIFY_CONTRACT_ADMIN;
839:
840: PROCEDURE NOTIFY_SALESREP (p_user_id IN NUMBER, p_chr_id IN Number, p_contract_number IN VARCHAR2, p_contract_number_modifier IN VARCHAR2, p_mesg IN VARCHAR2) IS
841: --l_salesperson_id VARCHAR2(200) := FND_PROFILE.VALUE('OKS_SALESPERSON_ID');
842: BEGIN
843:
844: OKS_EXTWAR_UTIL_PUB.NOTIFY('NSR',p_user_id,p_chr_id,p_contract_number,p_contract_number_modifier,p_mesg);
845: -- LOG_MESSAGES(p_mesg || ':' || p_contract_number || ':' || p_contract_number_modifier || ':' || p_user_id);

Line 1862: IF (FND_PROFILE.VALUE('OKS_USE_JTF') = 'YES') THEN

1858:
1859:
1860: l_org_id := p_org_id;
1861:
1862: IF (FND_PROFILE.VALUE('OKS_USE_JTF') = 'YES') THEN
1863: fnd_file.put_line(FND_FILE.LOG,'OKS: Use Territories to Default Sales Person: Yes');
1864: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');
1865:
1866: -- set org context when the org parameter is not null

Line 1864: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');

1860: l_org_id := p_org_id;
1861:
1862: IF (FND_PROFILE.VALUE('OKS_USE_JTF') = 'YES') THEN
1863: fnd_file.put_line(FND_FILE.LOG,'OKS: Use Territories to Default Sales Person: Yes');
1864: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');
1865:
1866: -- set org context when the org parameter is not null
1867: IF l_org_id IS NOT NULL THEN
1868: OKC_CONTEXT.set_okc_org_context(l_org_id,null);

Line 1875: IF NVL(fnd_profile.value('OKS_SRC_TERR_QUALFIERS'),'V')='V' THEN

1871: IF l_cro_code IS NULL THEN
1872: fnd_file.put_line(FND_FILE.LOG,'Invalid CRO Code');
1873: NOTIFY_SETUP_ADMIN;
1874: ELSE
1875: IF NVL(fnd_profile.value('OKS_SRC_TERR_QUALFIERS'),'V')='V' THEN
1876: l_terr_res := 'V';
1877: ELSE
1878: l_terr_res := 'C';
1879: END IF;