eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on FND_USER

Line 2066: FROM per_all_workforce_v pf,fnd_user fu

2062:
2063: --ER Structured Terms Authoring in Repository strivedi
2064: CURSOR getRepDefaultInternalContactId IS
2065: SELECT pf.person_id contact_id
2066: FROM per_all_workforce_v pf,fnd_user fu
2067: WHERE fu.user_id = fnd_global.user_id
2068: AND pf.person_id = fu.employee_id;
2069: l_rep_dflt_int_contact_id okc_deliverables.INTERNAL_PARTY_CONTACT_ID%TYPE;
2070: --End of ER Code Modifications

Line 7297: CURSOR fnd_user_cur IS

7293: p_contact_id NUMBER
7294: ) RETURN VARCHAR2
7295: IS
7296:
7297: CURSOR fnd_user_cur IS
7298: select employee_id from fnd_user
7299: where employee_id = p_contact_id;
7300:
7301: fnd_user_rec fnd_user_cur%ROWTYPE;

Line 7298: select employee_id from fnd_user

7294: ) RETURN VARCHAR2
7295: IS
7296:
7297: CURSOR fnd_user_cur IS
7298: select employee_id from fnd_user
7299: where employee_id = p_contact_id;
7300:
7301: fnd_user_rec fnd_user_cur%ROWTYPE;
7302:

Line 7301: fnd_user_rec fnd_user_cur%ROWTYPE;

7297: CURSOR fnd_user_cur IS
7298: select employee_id from fnd_user
7299: where employee_id = p_contact_id;
7300:
7301: fnd_user_rec fnd_user_cur%ROWTYPE;
7302:
7303: CURSOR contact_cur IS
7304: select email_address
7305: from per_all_people_f

Line 7319: OPEN fnd_user_cur;

7315: BEGIN
7316: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
7318: END IF;
7319: OPEN fnd_user_cur;
7320: FETCH fnd_user_cur INTO fnd_user_rec;
7321: IF fnd_user_cur%FOUND THEN
7322: --contact person is a fnd user, so it's ok
7323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7320: FETCH fnd_user_cur INTO fnd_user_rec;

7316: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
7318: END IF;
7319: OPEN fnd_user_cur;
7320: FETCH fnd_user_cur INTO fnd_user_rec;
7321: IF fnd_user_cur%FOUND THEN
7322: --contact person is a fnd user, so it's ok
7323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');

Line 7321: IF fnd_user_cur%FOUND THEN

7317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
7318: END IF;
7319: OPEN fnd_user_cur;
7320: FETCH fnd_user_cur INTO fnd_user_rec;
7321: IF fnd_user_cur%FOUND THEN
7322: --contact person is a fnd user, so it's ok
7323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
7325: END IF;

Line 7322: --contact person is a fnd user, so it's ok

7318: END IF;
7319: OPEN fnd_user_cur;
7320: FETCH fnd_user_cur INTO fnd_user_rec;
7321: IF fnd_user_cur%FOUND THEN
7322: --contact person is a fnd user, so it's ok
7323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
7325: END IF;
7326: RETURN('Y');

Line 7324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');

7320: FETCH fnd_user_cur INTO fnd_user_rec;
7321: IF fnd_user_cur%FOUND THEN
7322: --contact person is a fnd user, so it's ok
7323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
7325: END IF;
7326: RETURN('Y');
7327: ELSE
7328: OPEN contact_cur;

Line 7332: --contact person is not fnd user, but it has an email address in per_people_all

7328: OPEN contact_cur;
7329: FETCH contact_cur INTO contact_rec;
7330: IF contact_cur%FOUND THEN
7331: IF(contact_rec.email_address is not null) THEN
7332: --contact person is not fnd user, but it has an email address in per_people_all
7333: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7334: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, but has an email address, thus returning Y');
7335: END IF;
7336: RETURN('Y');

Line 7334: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, but has an email address, thus returning Y');

7330: IF contact_cur%FOUND THEN
7331: IF(contact_rec.email_address is not null) THEN
7332: --contact person is not fnd user, but it has an email address in per_people_all
7333: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7334: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, but has an email address, thus returning Y');
7335: END IF;
7336: RETURN('Y');
7337: ELSE
7338: --not a fnd user, no email address either

Line 7338: --not a fnd user, no email address either

7334: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, but has an email address, thus returning Y');
7335: END IF;
7336: RETURN('Y');
7337: ELSE
7338: --not a fnd user, no email address either
7339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, does not have an email address, thus returning N');
7341: END IF;
7342: RETURN('N');

Line 7340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, does not have an email address, thus returning N');

7336: RETURN('Y');
7337: ELSE
7338: --not a fnd user, no email address either
7339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not a fnd user, does not have an email address, thus returning N');
7341: END IF;
7342: RETURN('N');
7343: END IF;
7344: ELSE

Line 7345: --not a fnd user, not in per_people_all

7341: END IF;
7342: RETURN('N');
7343: END IF;
7344: ELSE
7345: --not a fnd user, not in per_people_all
7346: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7347: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not in per_people_f also not a fnd user, thus returning N');
7348: END IF;
7349: RETURN('N');

Line 7347: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not in per_people_f also not a fnd user, thus returning N');

7343: END IF;
7344: ELSE
7345: --not a fnd user, not in per_people_all
7346: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7347: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is not in per_people_f also not a fnd user, thus returning N');
7348: END IF;
7349: RETURN('N');
7350: END IF;
7351: END IF;

Line 7352: CLOSE fnd_user_cur;

7348: END IF;
7349: RETURN('N');
7350: END IF;
7351: END IF;
7352: CLOSE fnd_user_cur;
7353: CLOSE contact_cur;
7354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid');
7356: END IF;

Line 7363: IF fnd_user_cur %ISOPEN THEN

7359: WHEN OTHERS THEN
7360: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7361: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');
7362: END IF;
7363: IF fnd_user_cur %ISOPEN THEN
7364: CLOSE fnd_user_cur ;
7365: END IF;
7366: IF contact_cur %ISOPEN THEN
7367: CLOSE contact_cur ;

Line 7364: CLOSE fnd_user_cur ;

7360: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7361: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');
7362: END IF;
7363: IF fnd_user_cur %ISOPEN THEN
7364: CLOSE fnd_user_cur ;
7365: END IF;
7366: IF contact_cur %ISOPEN THEN
7367: CLOSE contact_cur ;
7368: END IF;

Line 8119: --check if internal contact is a valid fnd user or if it has an email address

8115: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',l_qa_code);
8116:
8117: l_doc_type_class := getDocTypeClass(p_bus_doctype => del_rec.business_document_type);
8118:
8119: --check if internal contact is a valid fnd user or if it has an email address
8120: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.internal_party_contact_id is not null) THEN
8121: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.internal_party_contact_id);
8122: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8123: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'internal contact valid (l_contact_valid): '||l_contact_valid);

Line 8153: --check if requester is a valid fnd user or if it has an email address

8149: END IF;
8150:
8151: END IF;
8152:
8153: --check if requester is a valid fnd user or if it has an email address
8154: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.requester_id is not null) THEN
8155: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.requester_id);
8156: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8157: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'requester valid (l_contact_valid): '||l_contact_valid);

Line 8186: --check if escalation assignee is a valid fnd user or if it has an email address

8182:
8183: END IF;
8184: END IF;
8185:
8186: --check if escalation assignee is a valid fnd user or if it has an email address
8187: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.notify_escalation_yn = 'Y' and del_rec.escalation_assignee is not null) THEN
8188: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.escalation_assignee);
8189: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8190: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'escalation assignee valid (l_contact_valid): '||l_contact_valid);