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 1950: FROM per_all_workforce_v pf,fnd_user fu

1946:
1947: --ER Structured Terms Authoring in Repository strivedi
1948: CURSOR getRepDefaultInternalContactId IS
1949: SELECT pf.person_id contact_id
1950: FROM per_all_workforce_v pf,fnd_user fu
1951: WHERE fu.user_id = fnd_global.user_id
1952: AND pf.person_id = fu.employee_id;
1953: l_rep_dflt_int_contact_id okc_deliverables.INTERNAL_PARTY_CONTACT_ID%TYPE;
1954: --End of ER Code Modifications

Line 6896: CURSOR fnd_user_cur IS

6892: p_contact_id NUMBER
6893: ) RETURN VARCHAR2
6894: IS
6895:
6896: CURSOR fnd_user_cur IS
6897: select employee_id from fnd_user
6898: where employee_id = p_contact_id;
6899:
6900: fnd_user_rec fnd_user_cur%ROWTYPE;

Line 6897: select employee_id from fnd_user

6893: ) RETURN VARCHAR2
6894: IS
6895:
6896: CURSOR fnd_user_cur IS
6897: select employee_id from fnd_user
6898: where employee_id = p_contact_id;
6899:
6900: fnd_user_rec fnd_user_cur%ROWTYPE;
6901:

Line 6900: fnd_user_rec fnd_user_cur%ROWTYPE;

6896: CURSOR fnd_user_cur IS
6897: select employee_id from fnd_user
6898: where employee_id = p_contact_id;
6899:
6900: fnd_user_rec fnd_user_cur%ROWTYPE;
6901:
6902: CURSOR contact_cur IS
6903: select email_address
6904: from per_all_people_f

Line 6918: OPEN fnd_user_cur;

6914: BEGIN
6915: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
6917: END IF;
6918: OPEN fnd_user_cur;
6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN
6921: --contact person is a fnd user, so it's ok
6922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6919: FETCH fnd_user_cur INTO fnd_user_rec;

6915: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
6917: END IF;
6918: OPEN fnd_user_cur;
6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN
6921: --contact person is a fnd user, so it's ok
6922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');

Line 6920: IF fnd_user_cur%FOUND THEN

6916: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: Inside OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid ');
6917: END IF;
6918: OPEN fnd_user_cur;
6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN
6921: --contact person is a fnd user, so it's ok
6922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
6924: END IF;

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

6917: END IF;
6918: OPEN fnd_user_cur;
6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN
6921: --contact person is a fnd user, so it's ok
6922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
6924: END IF;
6925: RETURN('Y');

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

6919: FETCH fnd_user_cur INTO fnd_user_rec;
6920: IF fnd_user_cur%FOUND THEN
6921: --contact person is a fnd user, so it's ok
6922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'contact is a fnd user, thus returning Y');
6924: END IF;
6925: RETURN('Y');
6926: ELSE
6927: OPEN contact_cur;

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

6927: OPEN contact_cur;
6928: FETCH contact_cur INTO contact_rec;
6929: IF contact_cur%FOUND THEN
6930: IF(contact_rec.email_address is not null) THEN
6931: --contact person is not fnd user, but it has an email address in per_people_all
6932: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6933: 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');
6934: END IF;
6935: RETURN('Y');

Line 6933: 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');

6929: IF contact_cur%FOUND THEN
6930: IF(contact_rec.email_address is not null) THEN
6931: --contact person is not fnd user, but it has an email address in per_people_all
6932: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6933: 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');
6934: END IF;
6935: RETURN('Y');
6936: ELSE
6937: --not a fnd user, no email address either

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

6933: 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');
6934: END IF;
6935: RETURN('Y');
6936: ELSE
6937: --not a fnd user, no email address either
6938: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6939: 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');
6940: END IF;
6941: RETURN('N');

Line 6939: 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');

6935: RETURN('Y');
6936: ELSE
6937: --not a fnd user, no email address either
6938: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6939: 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');
6940: END IF;
6941: RETURN('N');
6942: END IF;
6943: ELSE

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

6940: END IF;
6941: RETURN('N');
6942: END IF;
6943: ELSE
6944: --not a fnd user, not in per_people_all
6945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6946: 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');
6947: END IF;
6948: RETURN('N');

Line 6946: 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');

6942: END IF;
6943: ELSE
6944: --not a fnd user, not in per_people_all
6945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6946: 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');
6947: END IF;
6948: RETURN('N');
6949: END IF;
6950: END IF;

Line 6951: CLOSE fnd_user_cur;

6947: END IF;
6948: RETURN('N');
6949: END IF;
6950: END IF;
6951: CLOSE fnd_user_cur;
6952: CLOSE contact_cur;
6953: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6954: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'101: OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid');
6955: END IF;

Line 6962: IF fnd_user_cur %ISOPEN THEN

6958: WHEN OTHERS THEN
6959: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6960: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');
6961: END IF;
6962: IF fnd_user_cur %ISOPEN THEN
6963: CLOSE fnd_user_cur ;
6964: END IF;
6965: IF contact_cur %ISOPEN THEN
6966: CLOSE contact_cur ;

Line 6963: CLOSE fnd_user_cur ;

6959: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6960: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102: Leaving OKC_DELIVERABLE_PROCESS_PVT.internal_contact_valid with Exception');
6961: END IF;
6962: IF fnd_user_cur %ISOPEN THEN
6963: CLOSE fnd_user_cur ;
6964: END IF;
6965: IF contact_cur %ISOPEN THEN
6966: CLOSE contact_cur ;
6967: END IF;

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

7475: l_short_desc := get_lookup_meaning('OKC_TERM_QA_LIST',l_qa_code);
7476:
7477: l_doc_type_class := getDocTypeClass(p_bus_doctype => del_rec.business_document_type);
7478:
7479: --check if internal contact is a valid fnd user or if it has an email address
7480: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.internal_party_contact_id is not null) THEN
7481: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.internal_party_contact_id);
7482: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'internal contact valid (l_contact_valid): '||l_contact_valid);

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

7497: END IF;
7498:
7499: END IF;
7500:
7501: --check if requester is a valid fnd user or if it has an email address
7502: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.requester_id is not null) THEN
7503: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.requester_id);
7504: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'requester valid (l_contact_valid): '||l_contact_valid);

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

7517:
7518: END IF;
7519: END IF;
7520:
7521: --check if escalation assignee is a valid fnd user or if it has an email address
7522: IF(l_doc_type_class <> 'TEMPLATE' and del_rec.notify_escalation_yn = 'Y' and del_rec.escalation_assignee is not null) THEN
7523: l_contact_valid := internal_contact_valid(p_contact_id => del_rec.escalation_assignee);
7524: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'escalation assignee valid (l_contact_valid): '||l_contact_valid);