DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_MESSAGE

Line 95: reason := fnd_message.get;

91: x_description, x_email_address, x_fax, x_expire_pwd, x_user_guid,
92: x_oid_pwd, l_result);
93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
95: reason := fnd_message.get;
96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
97: fnd_message.set_token('USER_NAME', x_user_name);
98: fnd_message.set_token('REASON', reason);
99: app_exception.raise_exception;

Line 96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');

92: x_oid_pwd, l_result);
93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
95: reason := fnd_message.get;
96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
97: fnd_message.set_token('USER_NAME', x_user_name);
98: fnd_message.set_token('REASON', reason);
99: app_exception.raise_exception;
100: end if;

Line 97: fnd_message.set_token('USER_NAME', x_user_name);

93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
95: reason := fnd_message.get;
96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
97: fnd_message.set_token('USER_NAME', x_user_name);
98: fnd_message.set_token('REASON', reason);
99: app_exception.raise_exception;
100: end if;
101:

Line 98: fnd_message.set_token('REASON', reason);

94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
95: reason := fnd_message.get;
96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
97: fnd_message.set_token('USER_NAME', x_user_name);
98: fnd_message.set_token('REASON', reason);
99: app_exception.raise_exception;
100: end if;
101:
102: exception

Line 104: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');

100: end if;
101:
102: exception
103: when others then
104: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
105: fnd_message.set_token('USER_NAME', x_user_name);
106: fnd_message.set_token('REASON', sqlerrm);
107: app_exception.raise_exception;
108: end;

Line 105: fnd_message.set_token('USER_NAME', x_user_name);

101:
102: exception
103: when others then
104: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
105: fnd_message.set_token('USER_NAME', x_user_name);
106: fnd_message.set_token('REASON', sqlerrm);
107: app_exception.raise_exception;
108: end;
109:

Line 106: fnd_message.set_token('REASON', sqlerrm);

102: exception
103: when others then
104: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
105: fnd_message.set_token('USER_NAME', x_user_name);
106: fnd_message.set_token('REASON', sqlerrm);
107: app_exception.raise_exception;
108: end;
109:
110: ----------------------------------------------------------------------^M

Line 243: fnd_message.set_name('FND', 'SECURITY-GUEST START DATE');

239: -- If start_date > sysdate, do not update the start_date for GUEST.
240: if (l_user_id = 6) then
241: if (x_start_date > sysdate) then
242: -- throw the error message SECURITY-GUEST START DATE
243: fnd_message.set_name('FND', 'SECURITY-GUEST START DATE');
244: app_exception.raise_exception;
245: else
246: l_start_date := x_start_date;
247: end if;

Line 325: fnd_message.set_name('FND', 'FND_INVALID_USER');

321: from fnd_user u
322: where u.user_name = upper(x_user_name);
323: exception
324: when others then
325: fnd_message.set_name('FND', 'FND_INVALID_USER');
326: fnd_message.set_token('USER_NAME', X_USER_NAME);
327: app_exception.raise_exception;
328: end;
329:

Line 326: fnd_message.set_token('USER_NAME', X_USER_NAME);

322: where u.user_name = upper(x_user_name);
323: exception
324: when others then
325: fnd_message.set_name('FND', 'FND_INVALID_USER');
326: fnd_message.set_token('USER_NAME', X_USER_NAME);
327: app_exception.raise_exception;
328: end;
329:
330: -- PARTY

Line 454: reason := fnd_message.get();

450: end if;
451: G_EXPIRE_USER_PWD := NULL;
452:
453: if (ret = 'N') then
454: reason := fnd_message.get();
455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
456: fnd_message.set_token('USER_NAME', X_USER_NAME);
457: fnd_message.set_token('REASON', reason);
458: app_exception.raise_exception;

Line 455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');

451: G_EXPIRE_USER_PWD := NULL;
452:
453: if (ret = 'N') then
454: reason := fnd_message.get();
455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
456: fnd_message.set_token('USER_NAME', X_USER_NAME);
457: fnd_message.set_token('REASON', reason);
458: app_exception.raise_exception;
459: end if;

Line 456: fnd_message.set_token('USER_NAME', X_USER_NAME);

452:
453: if (ret = 'N') then
454: reason := fnd_message.get();
455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
456: fnd_message.set_token('USER_NAME', X_USER_NAME);
457: fnd_message.set_token('REASON', reason);
458: app_exception.raise_exception;
459: end if;
460: end if;

Line 457: fnd_message.set_token('REASON', reason);

453: if (ret = 'N') then
454: reason := fnd_message.get();
455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
456: fnd_message.set_token('USER_NAME', X_USER_NAME);
457: fnd_message.set_token('REASON', reason);
458: app_exception.raise_exception;
459: end if;
460: end if;
461:

Line 473: reason := fnd_message.get_encoded;

469: p_parameter_list => l_parameter_list,
470: p_send_date => Sysdate);
471: exception
472: when others then
473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
475: fnd_message.set_encoded(reason);
476: else
477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');

Line 475: fnd_message.set_encoded(reason);

471: exception
472: when others then
473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
475: fnd_message.set_encoded(reason);
476: else
477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');
478: end if;
479: app_exception.raise_exception;

Line 477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');

473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
475: fnd_message.set_encoded(reason);
476: else
477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');
478: end if;
479: app_exception.raise_exception;
480: end;
481:

Line 520: fnd_message.set_name('FND', 'FND_INVALID_USER');

516: user_guid = l_user_guid
517: where user_name = upper(x_user_name);
518:
519: if (SQL%NOTFOUND) then
520: fnd_message.set_name('FND', 'FND_INVALID_USER');
521: fnd_message.set_token('USER_NAME', X_USER_NAME);
522: app_exception.raise_exception;
523: else
524: -- bug 8227171 relocated the user_id fetch higher up.

Line 521: fnd_message.set_token('USER_NAME', X_USER_NAME);

517: where user_name = upper(x_user_name);
518:
519: if (SQL%NOTFOUND) then
520: fnd_message.set_name('FND', 'FND_INVALID_USER');
521: fnd_message.set_token('USER_NAME', X_USER_NAME);
522: app_exception.raise_exception;
523: else
524: -- bug 8227171 relocated the user_id fetch higher up.
525: -- Added for Function Security Cache Invalidation

Line 562: reason := fnd_message.get();

558: x_fax => x_fax);
559: exception
560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);

Line 563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');

559: exception
560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);
567: app_exception.raise_exception;

Line 564: fnd_message.set_token('USERNAME', X_USER_NAME);

560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);
567: app_exception.raise_exception;
568: end;

Line 565: fnd_message.set_token('USERID', l_user_id);

561: ROLLBACK to update_user;
562: reason := fnd_message.get();
563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);
567: app_exception.raise_exception;
568: end;
569: end if;

Line 566: fnd_message.set_token('REASON', reason);

562: reason := fnd_message.get();
563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);
567: app_exception.raise_exception;
568: end;
569: end if;
570: -- End bug 4318754, 4424225

Line 717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );

713: end if;
714: end if;
715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;

Line 718: fnd_message.set_token('ROUTINE', l_api_name);

714: end if;
715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL

Line 719: fnd_message.set_token('ERRNO', SQLCODE);

715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL
723:

Line 720: fnd_message.set_token('REASON', SQLERRM);

716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL
723:
724: -- Bug 13989225 if new employee_id is null then delete

Line 745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );

741: and NUMBER_VALUE = l_old_employee_id;
742:
743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;

Line 746: fnd_message.set_token('ROUTINE', l_api_name);

742:
743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;

Line 747: fnd_message.set_token('ERRNO', SQLCODE);

743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;
751: end if;

Line 748: fnd_message.set_token('REASON', SQLERRM);

744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;
751: end if;
752:

Line 790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );

786: end if;
787:
788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;

Line 791: fnd_message.set_token('ROUTINE', l_api_name);

787:
788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;

Line 792: fnd_message.set_token('ERRNO', SQLCODE);

788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;
796:

Line 793: fnd_message.set_token('REASON', SQLERRM);

789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;
796:
797: if (l_supplier_id is not null) then

Line 834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );

830: end if;
831:
832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;

Line 835: fnd_message.set_token('ROUTINE', l_api_name);

831:
832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;

Line 836: fnd_message.set_token('ERRNO', SQLCODE);

832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;
840:

Line 837: fnd_message.set_token('REASON', SQLERRM);

833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;
840:
841: -- Sync user change to LDAP

Line 903: reason := fnd_message.get_encoded;

899: p_parameters => l_parameter_list,
900: p_send_date => Sysdate);
901: exception
902: when others then
903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
905: fnd_message.set_encoded(reason);
906: else
907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

Line 905: fnd_message.set_encoded(reason);

901: exception
902: when others then
903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
905: fnd_message.set_encoded(reason);
906: else
907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
908: end if;
909: app_exception.raise_exception;

Line 907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
905: fnd_message.set_encoded(reason);
906: else
907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
908: end if;
909: app_exception.raise_exception;
910:
911: end;

Line 1330: reason := fnd_message.get();

1326: -- End Bug 4318754, 4424225
1327: exception
1328: when others then
1329: ROLLBACK to create_user;
1330: reason := fnd_message.get();
1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1332: fnd_message.set_token('USER_NAME', X_USER_NAME);
1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;

Line 1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');

1327: exception
1328: when others then
1329: ROLLBACK to create_user;
1330: reason := fnd_message.get();
1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1332: fnd_message.set_token('USER_NAME', X_USER_NAME);
1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;
1335: end;

Line 1332: fnd_message.set_token('USER_NAME', X_USER_NAME);

1328: when others then
1329: ROLLBACK to create_user;
1330: reason := fnd_message.get();
1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1332: fnd_message.set_token('USER_NAME', X_USER_NAME);
1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;
1335: end;
1336:

Line 1333: fnd_message.set_token('REASON', reason);

1329: ROLLBACK to create_user;
1330: reason := fnd_message.get();
1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1332: fnd_message.set_token('USER_NAME', X_USER_NAME);
1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;
1335: end;
1336:
1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

Line 1435: reason := fnd_message.get_encoded;

1431: p_send_date => Sysdate);
1432:
1433: exception
1434: when others then
1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
1437: fnd_message.set_encoded(reason);
1438: else
1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

Line 1437: fnd_message.set_encoded(reason);

1433: exception
1434: when others then
1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
1437: fnd_message.set_encoded(reason);
1438: else
1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
1440: end if;
1441: app_exception.raise_exception;

Line 1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
1437: fnd_message.set_encoded(reason);
1438: else
1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
1440: end if;
1441: app_exception.raise_exception;
1442: end;
1443:

Line 1446: reason := fnd_message.get();

1442: end;
1443:
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
1446: reason := fnd_message.get();
1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1448: fnd_message.set_token('USER_NAME', X_USER_NAME);
1449: fnd_message.set_token('REASON', reason);
1450: app_exception.raise_exception;

Line 1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');

1443:
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
1446: reason := fnd_message.get();
1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1448: fnd_message.set_token('USER_NAME', X_USER_NAME);
1449: fnd_message.set_token('REASON', reason);
1450: app_exception.raise_exception;
1451: end if;

Line 1448: fnd_message.set_token('USER_NAME', X_USER_NAME);

1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
1446: reason := fnd_message.get();
1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1448: fnd_message.set_token('USER_NAME', X_USER_NAME);
1449: fnd_message.set_token('REASON', reason);
1450: app_exception.raise_exception;
1451: end if;
1452:

Line 1449: fnd_message.set_token('REASON', reason);

1445: -- The java layer puts message onto the message stack.
1446: reason := fnd_message.get();
1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1448: fnd_message.set_token('USER_NAME', X_USER_NAME);
1449: fnd_message.set_token('REASON', reason);
1450: app_exception.raise_exception;
1451: end if;
1452:
1453: return (user_id);

Line 1905: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');

1901: x_fax,
1902: x_customer_id,
1903: x_supplier_id);
1904: else
1905: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1906: fnd_message.set_token('USER_NAME', X_USER_NAME);
1907: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1908: app_exception.raise_exception;
1909: end if;

Line 1906: fnd_message.set_token('USER_NAME', X_USER_NAME);

1902: x_customer_id,
1903: x_supplier_id);
1904: else
1905: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1906: fnd_message.set_token('USER_NAME', X_USER_NAME);
1907: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1908: app_exception.raise_exception;
1909: end if;
1910: end if;

Line 1907: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');

1903: x_supplier_id);
1904: else
1905: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1906: fnd_message.set_token('USER_NAME', X_USER_NAME);
1907: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1908: app_exception.raise_exception;
1909: end if;
1910: end if;
1911: end LoadUser;

Line 2001: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');

1997: x_email_address,
1998: x_fax,
1999: x_person_party_id);
2000: else
2001: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
2002: fnd_message.set_token('USER_NAME', X_USER_NAME);
2003: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
2004: app_exception.raise_exception;
2005: end if;

Line 2002: fnd_message.set_token('USER_NAME', X_USER_NAME);

1998: x_fax,
1999: x_person_party_id);
2000: else
2001: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
2002: fnd_message.set_token('USER_NAME', X_USER_NAME);
2003: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
2004: app_exception.raise_exception;
2005: end if;
2006: end if;

Line 2003: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');

1999: x_person_party_id);
2000: else
2001: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
2002: fnd_message.set_token('USER_NAME', X_USER_NAME);
2003: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
2004: app_exception.raise_exception;
2005: end if;
2006: end if;
2007: end LoadUserParty;

Line 2703: reason := fnd_message.get;

2699: tmpbuf);
2700: end if;
2701: exception
2702: when others then
2703: reason := fnd_message.get;
2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);

Line 2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');

2700: end if;
2701: exception
2702: when others then
2703: reason := fnd_message.get;
2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);
2708: app_exception.raise_exception;

Line 2705: fnd_message.set_token('OLD_NAME', old_name);

2701: exception
2702: when others then
2703: reason := fnd_message.get;
2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);
2708: app_exception.raise_exception;
2709: end UpdateUserNameChildren;

Line 2706: fnd_message.set_token('NEW_NAME', new_name);

2702: when others then
2703: reason := fnd_message.get;
2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);
2708: app_exception.raise_exception;
2709: end UpdateUserNameChildren;
2710: --------------------------------------------------------------------------

Line 2707: fnd_message.set_token('REASON', reason);

2703: reason := fnd_message.get;
2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);
2708: app_exception.raise_exception;
2709: end UpdateUserNameChildren;
2710: --------------------------------------------------------------------------
2711: --

Line 2982: fnd_message.set_token('USER_NAME', username);

2978: and responsibility_application_id = appid;
2979:
2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);

Line 2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');

2979:
2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);
2987: app_exception.raise_exception;

Line 2984: fnd_message.set_token('APPS_NAME', resp_app);

2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);
2987: app_exception.raise_exception;
2988: end;

Line 2985: fnd_message.set_token('RESP_KEY', resp_key);

2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);
2987: app_exception.raise_exception;
2988: end;
2989:

Line 2986: fnd_message.set_token('SECURITY_GROUP', security_group);

2982: fnd_message.set_token('USER_NAME', username);
2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);
2987: app_exception.raise_exception;
2988: end;
2989:
2990: if (fnd_user_resp_groups_api.assignment_exists(

Line 3055: fnd_message.set_token('USER_NAME', username);

3051: where security_group_key = AddResp.security_group;
3052:
3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);

Line 3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');

3052:
3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);
3060: app_exception.raise_exception;

Line 3057: fnd_message.set_token('APPS_NAME', resp_app);

3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);
3060: app_exception.raise_exception;
3061: end;

Line 3058: fnd_message.set_token('RESP_KEY', resp_key);

3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);
3060: app_exception.raise_exception;
3061: end;
3062:

Line 3059: fnd_message.set_token('SECURITY_GROUP', security_group);

3055: fnd_message.set_token('USER_NAME', username);
3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);
3060: app_exception.raise_exception;
3061: end;
3062:
3063: if (fnd_user_resp_groups_api.assignment_exists(

Line 3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');

3196: l_party_name, l_party_type);
3197: exception
3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3201: fnd_message.set_token('USER', user_name);

3197: exception
3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3205: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);

Line 3202: fnd_message.set_token('CUSTID', l_customer_id);

3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3205: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3206: end if;

Line 3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');

3221: FND_OAM_USER_INFO.GET_ORGANIZATION_ID(l_customer_id);
3222: exception
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 3226: fnd_message.set_token('USER', user_name);

3222: exception
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3227: fnd_message.set_token('PNAME', l_party_name);

3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',

Line 3228: fnd_message.set_token('CUSTID', l_customer_id);

3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3232: FALSE);

Line 3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');

3238: end;
3239: else
3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);

Line 3243: fnd_message.set_token('USER', user_name);

3239: else
3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 3244: fnd_message.set_token('PNAME', l_party_name);

3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3245: fnd_message.set_token('PARTYID', l_customer_id);

3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3249: c_log_head || l_api_name || '.bad_party_type', FALSE);

Line 3246: fnd_message.set_token('PARTY_TYPE', l_party_type);

3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3249: c_log_head || l_api_name || '.bad_party_type', FALSE);
3250: end if;

Line 3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');

3273: l_emp_person_party_id := FND_OAM_USER_INFO.GET_PARTY_ID(l_employee_id);
3274: exception
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3278: fnd_message.set_token('USER', user_name);

3274: exception
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3282: c_log_head || l_api_name || '.bad_empid', FALSE);

Line 3279: fnd_message.set_token('EMPID', l_employee_id);

3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3282: c_log_head || l_api_name || '.bad_empid', FALSE);
3283: end if;

Line 3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');

3299: l_cust_person_party_name,
3300: l_party_type);
3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then

Line 3304: fnd_message.set_token('USER', user_name);

3300: l_party_type);
3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3305: fnd_message.set_token('CUSTID', l_customer_id);

3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3309: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);

Line 3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');

3316: l_emp_person_party_name,
3317: l_party_type);
3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then

Line 3321: fnd_message.set_token('USER', user_name);

3317: l_party_type);
3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3322: fnd_message.set_token('EMPID', l_emp_person_party_id);

3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3326: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);

Line 3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');

3327: end if;
3328: app_exception.raise_exception;
3329: end;
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);

Line 3332: fnd_message.set_token('USER', user_name);

3328: app_exception.raise_exception;
3329: end;
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);

Line 3333: fnd_message.set_token('CUSTID', l_customer_id);

3329: end;
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);

3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3335: fnd_message.set_token('EMPID', l_employee_id);

3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3339: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);

Line 3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);

3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3339: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3340: end if;

Line 3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');

3406: l_person_party_name,
3407: l_party_type);
3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3411: fnd_message.set_token('USER', user_name);

3407: l_party_type);
3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3415: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);

Line 3412: fnd_message.set_token('PARTYID', l_person_party_id);

3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3415: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3416: end if;

Line 3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');

3416: end if;
3417: app_exception.raise_exception;
3418: end;
3419: if (l_party_type <> 'PERSON') then
3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 3421: fnd_message.set_token('USER', user_name);

3417: app_exception.raise_exception;
3418: end;
3419: if (l_party_type <> 'PERSON') then
3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 3422: fnd_message.set_token('PARTYID', l_person_party_id);

3418: end;
3419: if (l_party_type <> 'PERSON') then
3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3426: c_log_head || l_api_name || '.bad_party_type', FALSE);

Line 3423: fnd_message.set_token('PARTY_TYPE', l_party_type);

3419: if (l_party_type <> 'PERSON') then
3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3426: c_log_head || l_api_name || '.bad_party_type', FALSE);
3427: end if;

Line 3614: fnd_message.set_name('FND', 'FND_INVALID_USER');

3610: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3611: 'No disabled user');
3612: end if;
3613:
3614: fnd_message.set_name('FND', 'FND_INVALID_USER');
3615: fnd_message.set_token('USER_NAME', username);
3616: app_exception.raise_exception;
3617: end;
3618:

Line 3615: fnd_message.set_token('USER_NAME', username);

3611: 'No disabled user');
3612: end if;
3613:
3614: fnd_message.set_name('FND', 'FND_INVALID_USER');
3615: fnd_message.set_token('USER_NAME', username);
3616: app_exception.raise_exception;
3617: end;
3618:
3619: -- Bug 4318754. Synch up with SSO

Line 3653: fnd_message.set_name('FND', 'FND_INVALID_USER');

3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3651: 'This pending user does not exist');
3652: end if;
3653: fnd_message.set_name('FND', 'FND_INVALID_USER');
3654: fnd_message.set_token('USER_NAME', username);
3655: app_exception.raise_exception;
3656: else
3657:

Line 3654: fnd_message.set_token('USER_NAME', username);

3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3651: 'This pending user does not exist');
3652: end if;
3653: fnd_message.set_name('FND', 'FND_INVALID_USER');
3654: fnd_message.set_token('USER_NAME', username);
3655: app_exception.raise_exception;
3656: else
3657:
3658: -- Added for Function Security Cache Invalidation

Line 3708: fnd_message.set_name('FND', 'FND_INVALID_PARTY');

3704: from hz_parties
3705: where upper(party_name) = upper(x_party);
3706: exception
3707: when no_data_found then
3708: fnd_message.set_name('FND', 'FND_INVALID_PARTY');
3709: fnd_message.set_token('PARTY_NAME', x_party);
3710: app_exception.raise_exception;
3711: end;
3712:

Line 3709: fnd_message.set_token('PARTY_NAME', x_party);

3705: where upper(party_name) = upper(x_party);
3706: exception
3707: when no_data_found then
3708: fnd_message.set_name('FND', 'FND_INVALID_PARTY');
3709: fnd_message.set_token('PARTY_NAME', x_party);
3710: app_exception.raise_exception;
3711: end;
3712:
3713: fnd_user_pkg.UpdateUserParty(x_user_name => x_user_name,

Line 3739: reason := fnd_message.get();

3735:
3736: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3737: x_new_user_name, l_result);
3738: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
3739: reason := fnd_message.get();
3740: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3741: fnd_message.set_token('REASON', reason);
3742: app_exception.raise_exception;
3743: end if;

Line 3740: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

3736: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3737: x_new_user_name, l_result);
3738: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
3739: reason := fnd_message.get();
3740: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3741: fnd_message.set_token('REASON', reason);
3742: app_exception.raise_exception;
3743: end if;
3744: exception

Line 3741: fnd_message.set_token('REASON', reason);

3737: x_new_user_name, l_result);
3738: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
3739: reason := fnd_message.get();
3740: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3741: fnd_message.set_token('REASON', reason);
3742: app_exception.raise_exception;
3743: end if;
3744: exception
3745: when others then

Line 3746: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

3742: app_exception.raise_exception;
3743: end if;
3744: exception
3745: when others then
3746: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3747: fnd_message.set_token('REASON', sqlerrm);
3748: app_exception.raise_exception;
3749: end;
3750:

Line 3747: fnd_message.set_token('REASON', sqlerrm);

3743: end if;
3744: exception
3745: when others then
3746: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3747: fnd_message.set_token('REASON', sqlerrm);
3748: app_exception.raise_exception;
3749: end;
3750:
3751: -- begin bug 2504562

Line 3783: fnd_message.set_name('FND', 'SECURITY-GUEST USERNAME');

3779:
3780: begin
3781: -- 7311525 do not allow the username of GUEST to be changed
3782: if (upper(x_old_user_name) = 'GUEST') then
3783: fnd_message.set_name('FND', 'SECURITY-GUEST USERNAME');
3784: app_exception.raise_exception;
3785: end if;
3786:
3787: -- ensure x_old_user_name exists in fnd_user before we proceed

Line 3797: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER');

3793: begin
3794: -- ensure x_new_user_name doesn't already exist in fnd_user
3795: select null into dummy from fnd_user
3796: where user_name = upper(x_new_user_name);
3797: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER');
3798: app_exception.raise_exception;
3799: exception
3800: when no_data_found then
3801: -- bug 8227171 change_user_name

Line 3879: reason := fnd_message.get;

3875: begin
3876: fnd_user_pkg.user_synch(upper(x_new_user_name));
3877: exception
3878: when others then
3879: reason := fnd_message.get;
3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);

Line 3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');

3876: fnd_user_pkg.user_synch(upper(x_new_user_name));
3877: exception
3878: when others then
3879: reason := fnd_message.get;
3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);
3884: app_exception.raise_exception;

Line 3881: fnd_message.set_token('OLD_NAME', x_old_user_name);

3877: exception
3878: when others then
3879: reason := fnd_message.get;
3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);
3884: app_exception.raise_exception;
3885: end;

Line 3882: fnd_message.set_token('NEW_NAME', x_new_user_name);

3878: when others then
3879: reason := fnd_message.get;
3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);
3884: app_exception.raise_exception;
3885: end;
3886:

Line 3883: fnd_message.set_token('REASON', reason);

3879: reason := fnd_message.get;
3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);
3884: app_exception.raise_exception;
3885: end;
3886:
3887: -- Added for bug 4676568

Line 3915: reason := fnd_message.get_encoded;

3911: p_send_date => Sysdate);
3912:
3913: exception
3914: when others then
3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
3917: fnd_message.set_encoded(reason);
3918: else
3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

Line 3917: fnd_message.set_encoded(reason);

3913: exception
3914: when others then
3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
3917: fnd_message.set_encoded(reason);
3918: else
3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
3920: end if;
3921: app_exception.raise_exception;

Line 3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');

3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
3917: fnd_message.set_encoded(reason);
3918: else
3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
3920: end if;
3921: app_exception.raise_exception;
3922: end;
3923: end;

Line 3928: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');

3924:
3925: exception
3926: when no_data_found then
3927: -- old username does not exist in fnd_user
3928: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');
3929: fnd_message.set_token('USER_NAME', x_old_user_name);
3930: app_exception.raise_exception;
3931:
3932:

Line 3929: fnd_message.set_token('USER_NAME', x_old_user_name);

3925: exception
3926: when no_data_found then
3927: -- old username does not exist in fnd_user
3928: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');
3929: fnd_message.set_token('USER_NAME', x_old_user_name);
3930: app_exception.raise_exception;
3931:
3932:
3933: end change_user_name;

Line 4014: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');

4010: uname varchar2(100);
4011: begin
4012: if (x_user_name is null or
4013: rtrim(x_user_name, ' ') is null) then
4014: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');
4015: app_exception.raise_exception;
4016: elsif (rtrim(x_user_name, ' ') <> x_user_name or
4017: ltrim(x_user_name, ' ') <> x_user_name) then
4018: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');

Line 4018: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');

4014: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');
4015: app_exception.raise_exception;
4016: elsif (rtrim(x_user_name, ' ') <> x_user_name or
4017: ltrim(x_user_name, ' ') <> x_user_name) then
4018: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');
4019: app_exception.raise_exception;
4020: elsif (instr(x_user_name, '/') > 0 OR
4021: instr(x_user_name, '"') > 0 OR
4022: instr(x_user_name, '(') > 0 OR

Line 4033: fnd_message.set_name('FND', 'INVALID_USER_NAME');

4029: instr(x_user_name, '>') > 0 OR
4030: instr(x_user_name, '\') > 0 OR
4031: instr(x_user_name, '~') > 0 OR
4032: instr(x_user_name, ':') > 0 ) then
4033: fnd_message.set_name('FND', 'INVALID_USER_NAME');
4034: fnd_message.set_token('UNAME', x_user_name);
4035: app_exception.raise_exception;
4036: else
4037: -- we pass the generic validation, it is time to call any

Line 4034: fnd_message.set_token('UNAME', x_user_name);

4030: instr(x_user_name, '\') > 0 OR
4031: instr(x_user_name, '~') > 0 OR
4032: instr(x_user_name, ':') > 0 ) then
4033: fnd_message.set_name('FND', 'INVALID_USER_NAME');
4034: fnd_message.set_token('UNAME', x_user_name);
4035: app_exception.raise_exception;
4036: else
4037: -- we pass the generic validation, it is time to call any
4038: -- customized user name validation if there is any.

Line 4047: msg := fnd_message.get_encoded;

4043: p_parameters => NULL,
4044: p_send_date => Sysdate);
4045: exception
4046: when others then
4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
4049: fnd_message.set_encoded(msg);
4050: else
4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');

Line 4049: fnd_message.set_encoded(msg);

4045: exception
4046: when others then
4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
4049: fnd_message.set_encoded(msg);
4050: else
4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');
4052: end if;
4053: app_exception.raise_exception;

Line 4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');

4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
4049: fnd_message.set_encoded(msg);
4050: else
4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');
4052: end if;
4053: app_exception.raise_exception;
4054: end;
4055: -- past generic and customized validation

Line 4284: fnd_message.set_name('FND', 'FND_USER_EXISTS_IN_FND');

4280: return(USER_INVALID_NAME);
4281: end;
4282:
4283: if (fnd_user_pkg.userExists(x_user_name)) then
4284: fnd_message.set_name('FND', 'FND_USER_EXISTS_IN_FND');
4285: return(USER_EXISTS_IN_FND);
4286: else
4287: begin
4288: retval := fnd_ldap_wrapper.user_exists(x_user_name);

Line 4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');

4295: -- The above check return that user exists in oid.
4296: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
4297:
4298: if(pf = 'Y') then
4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
4300: fnd_message.set_token('USER_NAME', x_user_name);
4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.

Line 4300: fnd_message.set_token('USER_NAME', x_user_name);

4296: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
4297:
4298: if(pf = 'Y') then
4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
4300: fnd_message.set_token('USER_NAME', x_user_name);
4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.
4304: else

Line 4305: fnd_message.set_name('FND', 'FND_USER_EXISTS_NO_LINK');

4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.
4304: else
4305: fnd_message.set_name('FND', 'FND_USER_EXISTS_NO_LINK');
4306: return(USER_EXISTS_NO_LINK_ALLOWED);
4307: end if;
4308: else
4309: return(USER_OK_CREATE);

Line 4464: reason := fnd_message.get();

4460: l_pwd, x_start_date, x_end_date, x_description,
4461: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4464: reason := fnd_message.get();
4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4466: fnd_message.set_token('USER_NAME', x_user_name);
4467: fnd_message.set_token('REASON', reason);
4468: app_exception.raise_exception;

Line 4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

4461: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4464: reason := fnd_message.get();
4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4466: fnd_message.set_token('USER_NAME', x_user_name);
4467: fnd_message.set_token('REASON', reason);
4468: app_exception.raise_exception;
4469: -- Bug 5605892

Line 4466: fnd_message.set_token('USER_NAME', x_user_name);

4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4464: reason := fnd_message.get();
4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4466: fnd_message.set_token('USER_NAME', x_user_name);
4467: fnd_message.set_token('REASON', reason);
4468: app_exception.raise_exception;
4469: -- Bug 5605892
4470: end if;

Line 4467: fnd_message.set_token('REASON', reason);

4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4464: reason := fnd_message.get();
4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4466: fnd_message.set_token('USER_NAME', x_user_name);
4467: fnd_message.set_token('REASON', reason);
4468: app_exception.raise_exception;
4469: -- Bug 5605892
4470: end if;
4471:

Line 4480: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

4476: return(null);
4477: end if;
4478: exception
4479: when others then
4480: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4481: fnd_message.set_token('USER_NAME', x_user_name);
4482: fnd_message.set_token('REASON', sqlerrm);
4483: app_exception.raise_exception;
4484: end;

Line 4481: fnd_message.set_token('USER_NAME', x_user_name);

4477: end if;
4478: exception
4479: when others then
4480: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4481: fnd_message.set_token('USER_NAME', x_user_name);
4482: fnd_message.set_token('REASON', sqlerrm);
4483: app_exception.raise_exception;
4484: end;
4485: exception

Line 4482: fnd_message.set_token('REASON', sqlerrm);

4478: exception
4479: when others then
4480: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4481: fnd_message.set_token('USER_NAME', x_user_name);
4482: fnd_message.set_token('REASON', sqlerrm);
4483: app_exception.raise_exception;
4484: end;
4485: exception
4486: when others then

Line 4603: reason := fnd_message.get();

4599: -- Add third argument to not use autonomous transaction when chaning
4600: -- passowrd. This is for bug 5087728
4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
4603: reason := fnd_message.get();
4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
4605: fnd_message.set_token('USER_NAME', X_USER_NAME);
4606: fnd_message.set_token('REASON', reason);
4607: app_exception.raise_exception;

Line 4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');

4600: -- passowrd. This is for bug 5087728
4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
4603: reason := fnd_message.get();
4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
4605: fnd_message.set_token('USER_NAME', X_USER_NAME);
4606: fnd_message.set_token('REASON', reason);
4607: app_exception.raise_exception;
4608: end if;

Line 4605: fnd_message.set_token('USER_NAME', X_USER_NAME);

4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
4603: reason := fnd_message.get();
4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
4605: fnd_message.set_token('USER_NAME', X_USER_NAME);
4606: fnd_message.set_token('REASON', reason);
4607: app_exception.raise_exception;
4608: end if;
4609: end if;

Line 4606: fnd_message.set_token('REASON', reason);

4602: if (ret = 'N') then
4603: reason := fnd_message.get();
4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
4605: fnd_message.set_token('USER_NAME', X_USER_NAME);
4606: fnd_message.set_token('REASON', reason);
4607: app_exception.raise_exception;
4608: end if;
4609: end if;
4610:

Line 4746: reason := fnd_message.get();

4742: x_hashed_password, x_start_date, x_end_date, x_description,
4743: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4746: reason := fnd_message.get();
4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4748: fnd_message.set_token('USER_NAME', x_user_name);
4749: fnd_message.set_token('REASON', reason);
4750: app_exception.raise_exception;

Line 4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

4743: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4746: reason := fnd_message.get();
4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4748: fnd_message.set_token('USER_NAME', x_user_name);
4749: fnd_message.set_token('REASON', reason);
4750: app_exception.raise_exception;
4751: end if;

Line 4748: fnd_message.set_token('USER_NAME', x_user_name);

4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4746: reason := fnd_message.get();
4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4748: fnd_message.set_token('USER_NAME', x_user_name);
4749: fnd_message.set_token('REASON', reason);
4750: app_exception.raise_exception;
4751: end if;
4752:

Line 4749: fnd_message.set_token('REASON', reason);

4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
4746: reason := fnd_message.get();
4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4748: fnd_message.set_token('USER_NAME', x_user_name);
4749: fnd_message.set_token('REASON', reason);
4750: app_exception.raise_exception;
4751: end if;
4752:
4753: if (l_pwd_ret = fnd_web_sec.external_pwd) then

Line 4762: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');

4758: end if;
4759:
4760: exception
4761: when others then
4762: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');
4763: fnd_message.set_token('USER_NAME', x_user_name);
4764: fnd_message.set_token('REASON', sqlerrm);
4765: app_exception.raise_exception;
4766:

Line 4763: fnd_message.set_token('USER_NAME', x_user_name);

4759:
4760: exception
4761: when others then
4762: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');
4763: fnd_message.set_token('USER_NAME', x_user_name);
4764: fnd_message.set_token('REASON', sqlerrm);
4765: app_exception.raise_exception;
4766:
4767: end;

Line 4764: fnd_message.set_token('REASON', sqlerrm);

4760: exception
4761: when others then
4762: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');
4763: fnd_message.set_token('USER_NAME', x_user_name);
4764: fnd_message.set_token('REASON', sqlerrm);
4765: app_exception.raise_exception;
4766:
4767: end;
4768: