1: package body FND_SIGNON as
2: /* $Header: AFSCSGNB.pls 120.8.12010000.3 2008/11/22 21:37:10 dggriffi ship $ */
3:
4:
5: --
154: COMMIT;
155: exception
156: when others then
157: rollback;
158: generic_error('FND_SIGNON.AUDIT_FORM', SQLCODE, SQLERRM);
159: end AUDIT_FORM;
160:
161: --
162: -- AUDIT_RESPONSIBILITY - Signon audit responsibility
206: -- by the changes in bug 3043856 wherein the login_id obtained by ICX is not used throughout
207: -- the session. A new sequence, FND_LOGIN_RESPONSIBILITIES_S, is created to generate unique
208: -- values for login_resp_id and will be used when inserting records into
209: -- FND_LOGIN_RESPONSIBILITIES. The login_resp_id generated will be passed back to the API
210: -- calling fnd_signon.audit_responsibility().
211: --
212: -- If login_resp_id is null, then generate one.
213: if (login_resp_id is null) then
214: select FND_LOGIN_RESPONSIBILITIES_S.nextval into login_resp_id from dual;
233: COMMIT;
234: exception
235: when others then
236: rollback;
237: generic_error('FND_SIGNON.AUDIT_RESPONSIBILITY', SQLCODE, SQLERRM);
238: end AUDIT_RESPONSIBILITY;
239:
240: --
241: -- AUDIT_USER - Begin user level signon auditing
294: COMMIT;
295: exception
296: when others then
297: rollback;
298: generic_error('FND_SIGNON.AUDIT_USER', SQLCODE, SQLERRM);
299: end AUDIT_USER;
300:
301: --
302: -- AUDIT_END - End signon audit
311: COMMIT;
312: exception
313: when others then
314: rollback;
315: generic_error('FND_SIGNON.AUDIT_END', SQLCODE, SQLERRM);
316: end AUDIT_END;
317:
318: --
319: -- NEW_SESSION - Misc signon things
384:
385: commit;
386: exception
387: when others then
388: generic_error('FND_SIGNON.NEW_SESSION', SQLCODE, SQLERRM);
389: end NEW_SESSION;
390:
391: --
392: -- Bug 3375261. new_icx_session(user_id,login_id,expired)
446: commit;
447: exception
448: when others then
449: rollback;
450: generic_error('FND_SIGNON.is_pwd_expired', SQLCODE, SQLERRM);
451: end is_pwd_expired;
452:
453: /*
454: * updates session_number in fnd_user table.
536: login_id := l_login_id;
537: exception
538: when others then
539: login_id := 0;
540: generic_error('FND_SIGNON.NEW_PROXY_ICX_SESSION', SQLCODE, SQLERRM);
541: end new_proxy_icx_session;
542:
543: --
544: -- Update_Desktop_Object (PRIVATE)
612: end if;
613: end if;
614: exception
615: when others then
616: generic_error('FND_SIGNON.UPDATE_DESKTOP_OBJECT', SQLCODE, SQLERRM);
617: end;
618:
619: --
620: -- UPDATE_NAVIGATOR
643: NEW_WINDOW_FLAG in varchar2) is
644:
645: begin
646: -- Save Hotlist functions to desktop objects
647: Fnd_Signon.Update_Desktop_Object(function1, 1,
648: user_id, resp_id, appl_id, login_id);
649: Fnd_Signon.Update_Desktop_Object(function2, 2,
650: user_id, resp_id, appl_id, login_id);
651: Fnd_Signon.Update_Desktop_Object(function3, 3,
645: begin
646: -- Save Hotlist functions to desktop objects
647: Fnd_Signon.Update_Desktop_Object(function1, 1,
648: user_id, resp_id, appl_id, login_id);
649: Fnd_Signon.Update_Desktop_Object(function2, 2,
650: user_id, resp_id, appl_id, login_id);
651: Fnd_Signon.Update_Desktop_Object(function3, 3,
652: user_id, resp_id, appl_id, login_id);
653: Fnd_Signon.Update_Desktop_Object(function4, 4,
647: Fnd_Signon.Update_Desktop_Object(function1, 1,
648: user_id, resp_id, appl_id, login_id);
649: Fnd_Signon.Update_Desktop_Object(function2, 2,
650: user_id, resp_id, appl_id, login_id);
651: Fnd_Signon.Update_Desktop_Object(function3, 3,
652: user_id, resp_id, appl_id, login_id);
653: Fnd_Signon.Update_Desktop_Object(function4, 4,
654: user_id, resp_id, appl_id, login_id);
655: Fnd_Signon.Update_Desktop_Object(function5, 5,
649: Fnd_Signon.Update_Desktop_Object(function2, 2,
650: user_id, resp_id, appl_id, login_id);
651: Fnd_Signon.Update_Desktop_Object(function3, 3,
652: user_id, resp_id, appl_id, login_id);
653: Fnd_Signon.Update_Desktop_Object(function4, 4,
654: user_id, resp_id, appl_id, login_id);
655: Fnd_Signon.Update_Desktop_Object(function5, 5,
656: user_id, resp_id, appl_id, login_id);
657: Fnd_Signon.Update_Desktop_Object(function6, 6,
651: Fnd_Signon.Update_Desktop_Object(function3, 3,
652: user_id, resp_id, appl_id, login_id);
653: Fnd_Signon.Update_Desktop_Object(function4, 4,
654: user_id, resp_id, appl_id, login_id);
655: Fnd_Signon.Update_Desktop_Object(function5, 5,
656: user_id, resp_id, appl_id, login_id);
657: Fnd_Signon.Update_Desktop_Object(function6, 6,
658: user_id, resp_id, appl_id, login_id);
659: Fnd_Signon.Update_Desktop_Object(function7, 7,
653: Fnd_Signon.Update_Desktop_Object(function4, 4,
654: user_id, resp_id, appl_id, login_id);
655: Fnd_Signon.Update_Desktop_Object(function5, 5,
656: user_id, resp_id, appl_id, login_id);
657: Fnd_Signon.Update_Desktop_Object(function6, 6,
658: user_id, resp_id, appl_id, login_id);
659: Fnd_Signon.Update_Desktop_Object(function7, 7,
660: user_id, resp_id, appl_id, login_id);
661: Fnd_Signon.Update_Desktop_Object(function8, 8,
655: Fnd_Signon.Update_Desktop_Object(function5, 5,
656: user_id, resp_id, appl_id, login_id);
657: Fnd_Signon.Update_Desktop_Object(function6, 6,
658: user_id, resp_id, appl_id, login_id);
659: Fnd_Signon.Update_Desktop_Object(function7, 7,
660: user_id, resp_id, appl_id, login_id);
661: Fnd_Signon.Update_Desktop_Object(function8, 8,
662: user_id, resp_id, appl_id, login_id);
663: Fnd_Signon.Update_Desktop_Object(function9, 9,
657: Fnd_Signon.Update_Desktop_Object(function6, 6,
658: user_id, resp_id, appl_id, login_id);
659: Fnd_Signon.Update_Desktop_Object(function7, 7,
660: user_id, resp_id, appl_id, login_id);
661: Fnd_Signon.Update_Desktop_Object(function8, 8,
662: user_id, resp_id, appl_id, login_id);
663: Fnd_Signon.Update_Desktop_Object(function9, 9,
664: user_id, resp_id, appl_id, login_id);
665: Fnd_Signon.Update_Desktop_Object(function10, 10,
659: Fnd_Signon.Update_Desktop_Object(function7, 7,
660: user_id, resp_id, appl_id, login_id);
661: Fnd_Signon.Update_Desktop_Object(function8, 8,
662: user_id, resp_id, appl_id, login_id);
663: Fnd_Signon.Update_Desktop_Object(function9, 9,
664: user_id, resp_id, appl_id, login_id);
665: Fnd_Signon.Update_Desktop_Object(function10, 10,
666: user_id, resp_id, appl_id, login_id);
667:
661: Fnd_Signon.Update_Desktop_Object(function8, 8,
662: user_id, resp_id, appl_id, login_id);
663: Fnd_Signon.Update_Desktop_Object(function9, 9,
664: user_id, resp_id, appl_id, login_id);
665: Fnd_Signon.Update_Desktop_Object(function10, 10,
666: user_id, resp_id, appl_id, login_id);
667:
668: -- Save window position to preferences
669: Fnd_Preference.Put(Fnd_Global.User_Name, 'FNDSCSGN',
682: 'NEW_WINDOW_FLAG', new_window_flag);
683: commit;
684: exception
685: when others then
686: generic_error('FND_SIGNON.UPDATE_NAVIGATOR', SQLCODE, SQLERRM);
687: end UPDATE_NAVIGATOR;
688:
689: --
690: -- GET_NAVIGATOR_PREFERENCES
714: Fnd_Global.User_Name,
715: 'FNDSCSGN', 'NEW_WINDOW_FLAG'), 1, 1);
716: exception
717: when others then
718: generic_error('FND_SIGNON.GET_NAVIGATOR_PREFERENCES', SQLCODE, SQLERRM);
719: end GET_NAVIGATOR_PREFERENCES;
720:
721: --
722: -- SET_SESSION
745:
746: commit;
747: exception
748: when others then
749: generic_error('FND_SIGNON.SET_SESSION', SQLCODE, SQLERRM);
750: end SET_SESSION;
751:
752: -- Misc signon things for an aol/j session.
753: -- For internal use only.
803: EXCEPTION
804: WHEN OTHERS THEN
805: login_id := 0;
806: expired := 'N';
807: generic_error('FND_SIGNON.NEW_AOLJ_SESSION', SQLCODE, SQLERRM);
808: end NEW_AOLJ_SESSION;
809:
810:
811: --AUDIT_WEB_RESPONSIBILITY created to audit visits to Responsibilities within ICX.
862: exception
863: when others then
864: rollback;
865:
866: generic_error('FND_SIGNON.AUDIT_WEB_RESPONSIBILITY', SQLCODE, SQLERRM);
867: end AUDIT_WEB_RESPONSIBILITY;
868:
869: /*
870: * NEW_ICX_SESSION
948: EXCEPTION
949: WHEN OTHERS THEN
950: login_id := 0;
951: expired := 'N';
952: -- Changed FND_SIGNON.NEW_AOLJ_SESSION to FND_SIGNON.NEW_ICX_SESSION
953: -- for consistency.
954: generic_error('FND_SIGNON.NEW_ICX_SESSION', SQLCODE, SQLERRM);
955: end NEW_ICX_SESSION;
956:
950: login_id := 0;
951: expired := 'N';
952: -- Changed FND_SIGNON.NEW_AOLJ_SESSION to FND_SIGNON.NEW_ICX_SESSION
953: -- for consistency.
954: generic_error('FND_SIGNON.NEW_ICX_SESSION', SQLCODE, SQLERRM);
955: end NEW_ICX_SESSION;
956:
957: /* BUG:5052314: API to retrieve number of unsuccessful logins */
958: /* previous to current login */
1002:
1003:
1004: END get_invalid_logins;
1005:
1006: end FND_SIGNON;