1: package body FND_SIGNON as
2: /* $Header: AFSCSGNB.pls 120.12.12020000.2 2012/08/13 18:22:01 ctilley ship $ */
3:
4:
5: --
178: COMMIT;
179: exception
180: when others then
181: rollback;
182: generic_error('FND_SIGNON.AUDIT_FORM', SQLCODE, SQLERRM);
183: end AUDIT_FORM;
184:
185: --
186: -- AUDIT_RESPONSIBILITY - Signon audit responsibility
230: -- by the changes in bug 3043856 wherein the login_id obtained by ICX is not used throughout
231: -- the session. A new sequence, FND_LOGIN_RESPONSIBILITIES_S, is created to generate unique
232: -- values for login_resp_id and will be used when inserting records into
233: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API
234: -- calling fnd_signon.audit_responsibility().
235: --
236: -- If login_resp_id is null, then generate one.
237: if (login_resp_id is null) then
238: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
257: COMMIT;
258: exception
259: when others then
260: rollback;
261: generic_error('FND_SIGNON.AUDIT_RESPONSIBILITY', SQLCODE, SQLERRM);
262: end AUDIT_RESPONSIBILITY;
263:
264: --
265: -- AUDIT_USER - Begin user level signon auditing
318: COMMIT;
319: exception
320: when others then
321: rollback;
322: generic_error('FND_SIGNON.AUDIT_USER', SQLCODE, SQLERRM);
323: end AUDIT_USER;
324:
325: --
326: -- AUDIT_END - End signon audit
335: COMMIT;
336: exception
337: when others then
338: rollback;
339: generic_error('FND_SIGNON.AUDIT_END', SQLCODE, SQLERRM);
340: end AUDIT_END;
341:
342: --
343: -- NEW_SESSION - Misc signon things
408:
409: commit;
410: exception
411: when others then
412: generic_error('FND_SIGNON.NEW_SESSION', SQLCODE, SQLERRM);
413: end NEW_SESSION;
414:
415: --
416: -- Bug 3375261. new_icx_session(user_id,login_id,expired)
470: commit;
471: exception
472: when others then
473: rollback;
474: generic_error('FND_SIGNON.is_pwd_expired', SQLCODE, SQLERRM);
475: end is_pwd_expired;
476:
477: /*
478: * updates session_number in fnd_user table.
560: login_id := l_login_id;
561: exception
562: when others then
563: login_id := 0;
564: generic_error('FND_SIGNON.NEW_PROXY_ICX_SESSION', SQLCODE, SQLERRM);
565: end new_proxy_icx_session;
566:
567: --
568: -- Update_Desktop_Object (PRIVATE)
636: end if;
637: end if;
638: exception
639: when others then
640: generic_error('FND_SIGNON.UPDATE_DESKTOP_OBJECT', SQLCODE, SQLERRM);
641: end;
642:
643: --
644: -- UPDATE_NAVIGATOR
667: NEW_WINDOW_FLAG in varchar2) is
668:
669: begin
670: -- Save Hotlist functions to desktop objects
671: Fnd_Signon.Update_Desktop_Object(function1, 1,
672: user_id, resp_id, appl_id, login_id);
673: Fnd_Signon.Update_Desktop_Object(function2, 2,
674: user_id, resp_id, appl_id, login_id);
675: Fnd_Signon.Update_Desktop_Object(function3, 3,
669: begin
670: -- Save Hotlist functions to desktop objects
671: Fnd_Signon.Update_Desktop_Object(function1, 1,
672: user_id, resp_id, appl_id, login_id);
673: Fnd_Signon.Update_Desktop_Object(function2, 2,
674: user_id, resp_id, appl_id, login_id);
675: Fnd_Signon.Update_Desktop_Object(function3, 3,
676: user_id, resp_id, appl_id, login_id);
677: Fnd_Signon.Update_Desktop_Object(function4, 4,
671: Fnd_Signon.Update_Desktop_Object(function1, 1,
672: user_id, resp_id, appl_id, login_id);
673: Fnd_Signon.Update_Desktop_Object(function2, 2,
674: user_id, resp_id, appl_id, login_id);
675: Fnd_Signon.Update_Desktop_Object(function3, 3,
676: user_id, resp_id, appl_id, login_id);
677: Fnd_Signon.Update_Desktop_Object(function4, 4,
678: user_id, resp_id, appl_id, login_id);
679: Fnd_Signon.Update_Desktop_Object(function5, 5,
673: Fnd_Signon.Update_Desktop_Object(function2, 2,
674: user_id, resp_id, appl_id, login_id);
675: Fnd_Signon.Update_Desktop_Object(function3, 3,
676: user_id, resp_id, appl_id, login_id);
677: Fnd_Signon.Update_Desktop_Object(function4, 4,
678: user_id, resp_id, appl_id, login_id);
679: Fnd_Signon.Update_Desktop_Object(function5, 5,
680: user_id, resp_id, appl_id, login_id);
681: Fnd_Signon.Update_Desktop_Object(function6, 6,
675: Fnd_Signon.Update_Desktop_Object(function3, 3,
676: user_id, resp_id, appl_id, login_id);
677: Fnd_Signon.Update_Desktop_Object(function4, 4,
678: user_id, resp_id, appl_id, login_id);
679: Fnd_Signon.Update_Desktop_Object(function5, 5,
680: user_id, resp_id, appl_id, login_id);
681: Fnd_Signon.Update_Desktop_Object(function6, 6,
682: user_id, resp_id, appl_id, login_id);
683: Fnd_Signon.Update_Desktop_Object(function7, 7,
677: Fnd_Signon.Update_Desktop_Object(function4, 4,
678: user_id, resp_id, appl_id, login_id);
679: Fnd_Signon.Update_Desktop_Object(function5, 5,
680: user_id, resp_id, appl_id, login_id);
681: Fnd_Signon.Update_Desktop_Object(function6, 6,
682: user_id, resp_id, appl_id, login_id);
683: Fnd_Signon.Update_Desktop_Object(function7, 7,
684: user_id, resp_id, appl_id, login_id);
685: Fnd_Signon.Update_Desktop_Object(function8, 8,
679: Fnd_Signon.Update_Desktop_Object(function5, 5,
680: user_id, resp_id, appl_id, login_id);
681: Fnd_Signon.Update_Desktop_Object(function6, 6,
682: user_id, resp_id, appl_id, login_id);
683: Fnd_Signon.Update_Desktop_Object(function7, 7,
684: user_id, resp_id, appl_id, login_id);
685: Fnd_Signon.Update_Desktop_Object(function8, 8,
686: user_id, resp_id, appl_id, login_id);
687: Fnd_Signon.Update_Desktop_Object(function9, 9,
681: Fnd_Signon.Update_Desktop_Object(function6, 6,
682: user_id, resp_id, appl_id, login_id);
683: Fnd_Signon.Update_Desktop_Object(function7, 7,
684: user_id, resp_id, appl_id, login_id);
685: Fnd_Signon.Update_Desktop_Object(function8, 8,
686: user_id, resp_id, appl_id, login_id);
687: Fnd_Signon.Update_Desktop_Object(function9, 9,
688: user_id, resp_id, appl_id, login_id);
689: Fnd_Signon.Update_Desktop_Object(function10, 10,
683: Fnd_Signon.Update_Desktop_Object(function7, 7,
684: user_id, resp_id, appl_id, login_id);
685: Fnd_Signon.Update_Desktop_Object(function8, 8,
686: user_id, resp_id, appl_id, login_id);
687: Fnd_Signon.Update_Desktop_Object(function9, 9,
688: user_id, resp_id, appl_id, login_id);
689: Fnd_Signon.Update_Desktop_Object(function10, 10,
690: user_id, resp_id, appl_id, login_id);
691:
685: Fnd_Signon.Update_Desktop_Object(function8, 8,
686: user_id, resp_id, appl_id, login_id);
687: Fnd_Signon.Update_Desktop_Object(function9, 9,
688: user_id, resp_id, appl_id, login_id);
689: Fnd_Signon.Update_Desktop_Object(function10, 10,
690: user_id, resp_id, appl_id, login_id);
691:
692: -- Save window position to preferences
693: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
706: 'NEW_WINDOW_FLAG', new_window_flag);
707: commit;
708: exception
709: when others then
710: generic_error('FND_SIGNON.UPDATE_NAVIGATOR', SQLCODE, SQLERRM);
711: end UPDATE_NAVIGATOR;
712:
713: --
714: -- GET_NAVIGATOR_PREFERENCES
738: Fnd_Global.User_Name,
739: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);
740: exception
741: when others then
742: generic_error('FND_SIGNON.GET_NAVIGATOR_PREFERENCES', SQLCODE, SQLERRM);
743: end GET_NAVIGATOR_PREFERENCES;
744:
745: --
746: -- SET_SESSION
769:
770: commit;
771: exception
772: when others then
773: generic_error('FND_SIGNON.SET_SESSION', SQLCODE, SQLERRM);
774: end SET_SESSION;
775:
776: -- Misc signon things for an aol/j session.
777: -- For internal use only.
827: EXCEPTION
828: WHEN OTHERS THEN
829: login_id := 0;
830: expired := 'N';
831: generic_error('FND_SIGNON.NEW_AOLJ_SESSION', SQLCODE, SQLERRM);
832: end NEW_AOLJ_SESSION;
833:
834:
835: --AUDIT_WEB_RESPONSIBILITY created to audit visits to Responsibilities within ICX.
886: exception
887: when others then
888: rollback;
889:
890: generic_error('FND_SIGNON.AUDIT_WEB_RESPONSIBILITY', SQLCODE, SQLERRM);
891: end AUDIT_WEB_RESPONSIBILITY;
892:
893: /*
894: * NEW_ICX_SESSION
972: EXCEPTION
973: WHEN OTHERS THEN
974: login_id := 0;
975: expired := 'N';
976: -- Changed FND_SIGNON.NEW_AOLJ_SESSION to FND_SIGNON.NEW_ICX_SESSION
977: -- for consistency.
978: generic_error('FND_SIGNON.NEW_ICX_SESSION', SQLCODE, SQLERRM);
979: end NEW_ICX_SESSION;
980:
974: login_id := 0;
975: expired := 'N';
976: -- Changed FND_SIGNON.NEW_AOLJ_SESSION to FND_SIGNON.NEW_ICX_SESSION
977: -- for consistency.
978: generic_error('FND_SIGNON.NEW_ICX_SESSION', SQLCODE, SQLERRM);
979: end NEW_ICX_SESSION;
980:
981: /* BUG:5052314: API to retrieve number of unsuccessful logins */
982: /* previous to current login */
1026:
1027:
1028: END get_invalid_logins;
1029:
1030: end FND_SIGNON;