DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_SIGNON

Line 1: package body FND_SIGNON as

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: --

Line 182: generic_error('FND_SIGNON.AUDIT_FORM', SQLCODE, SQLERRM);

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

Line 234: -- calling fnd_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;

Line 261: generic_error('FND_SIGNON.AUDIT_RESPONSIBILITY', SQLCODE, SQLERRM);

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

Line 322: generic_error('FND_SIGNON.AUDIT_USER', SQLCODE, SQLERRM);

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

Line 339: generic_error('FND_SIGNON.AUDIT_END', SQLCODE, SQLERRM);

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

Line 412: generic_error('FND_SIGNON.NEW_SESSION', SQLCODE, SQLERRM);

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)

Line 474: generic_error('FND_SIGNON.is_pwd_expired', SQLCODE, SQLERRM);

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.

Line 564: generic_error('FND_SIGNON.NEW_PROXY_ICX_SESSION', SQLCODE, SQLERRM);

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)

Line 640: generic_error('FND_SIGNON.UPDATE_DESKTOP_OBJECT', SQLCODE, SQLERRM);

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

Line 671: Fnd_Signon.Update_Desktop_Object(function1, 1,

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,

Line 673: Fnd_Signon.Update_Desktop_Object(function2, 2,

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,

Line 675: Fnd_Signon.Update_Desktop_Object(function3, 3,

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,

Line 677: Fnd_Signon.Update_Desktop_Object(function4, 4,

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,

Line 679: Fnd_Signon.Update_Desktop_Object(function5, 5,

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,

Line 681: Fnd_Signon.Update_Desktop_Object(function6, 6,

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,

Line 683: Fnd_Signon.Update_Desktop_Object(function7, 7,

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,

Line 685: Fnd_Signon.Update_Desktop_Object(function8, 8,

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,

Line 687: Fnd_Signon.Update_Desktop_Object(function9, 9,

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:

Line 689: Fnd_Signon.Update_Desktop_Object(function10, 10,

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',

Line 710: generic_error('FND_SIGNON.UPDATE_NAVIGATOR', SQLCODE, SQLERRM);

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

Line 742: generic_error('FND_SIGNON.GET_NAVIGATOR_PREFERENCES', SQLCODE, SQLERRM);

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

Line 773: generic_error('FND_SIGNON.SET_SESSION', SQLCODE, SQLERRM);

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.

Line 831: generic_error('FND_SIGNON.NEW_AOLJ_SESSION', SQLCODE, SQLERRM);

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.

Line 890: generic_error('FND_SIGNON.AUDIT_WEB_RESPONSIBILITY', SQLCODE, SQLERRM);

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

Line 976: -- Changed FND_SIGNON.NEW_AOLJ_SESSION to FND_SIGNON.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:

Line 978: generic_error('FND_SIGNON.NEW_ICX_SESSION', SQLCODE, SQLERRM);

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 */

Line 1030: end FND_SIGNON;

1026:
1027:
1028: END get_invalid_logins;
1029:
1030: end FND_SIGNON;