DBA Data[Home] [Help]

APPS.FND_USER_RESP_GROUPS_API dependencies on FND_MESSAGE

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

21: errcode in number,
22: errmsg in varchar2)
23: is
24: begin
25: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
26: fnd_message.set_token('ROUTINE', routine);
27: fnd_message.set_token('ERRNO', errcode);
28: fnd_message.set_token('REASON', errmsg);
29: app_exception.raise_exception;

Line 26: fnd_message.set_token('ROUTINE', routine);

22: errmsg in varchar2)
23: is
24: begin
25: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
26: fnd_message.set_token('ROUTINE', routine);
27: fnd_message.set_token('ERRNO', errcode);
28: fnd_message.set_token('REASON', errmsg);
29: app_exception.raise_exception;
30: end Generic_Error;

Line 27: fnd_message.set_token('ERRNO', errcode);

23: is
24: begin
25: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
26: fnd_message.set_token('ROUTINE', routine);
27: fnd_message.set_token('ERRNO', errcode);
28: fnd_message.set_token('REASON', errmsg);
29: app_exception.raise_exception;
30: end Generic_Error;
31:

Line 28: fnd_message.set_token('REASON', errmsg);

24: begin
25: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
26: fnd_message.set_token('ROUTINE', routine);
27: fnd_message.set_token('ERRNO', errcode);
28: fnd_message.set_token('REASON', errmsg);
29: app_exception.raise_exception;
30: end Generic_Error;
31:
32: --

Line 422: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

418: open c(username, rolename);
419: fetch c into recinfo;
420: if (c%notfound) then
421: close c;
422: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
423: app_exception.raise_exception;
424: end if;
425: close c;
426: if ( ((recinfo.start_date = x_start_date)

Line 433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

429: OR ((recinfo.end_date is null) AND (x_end_date is null)))
430: ) then
431: null;
432: else
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: app_exception.raise_exception;
435: end if;
436:
437: end Lock_Assignment;

Line 508: fnd_message.set_name('FND', 'FND_CANT_INSERT_USER_ROLE');

504: /* Check whether there already is a direct row; if so, */
505: /* we can't insert a duplicate. */
506: result := assignment_check(username, rolename, 'D');
507: if (result = TRUE) then
508: fnd_message.set_name('FND', 'FND_CANT_INSERT_USER_ROLE');
509: fnd_message.set_token('USERNAME', username);
510: fnd_message.set_token('ROLENAME', rolename);
511: fnd_message.set_token('ROUTINE',
512: 'FND_USER_RESP_GROUPS_API.Insert_Assignment');

Line 509: fnd_message.set_token('USERNAME', username);

505: /* we can't insert a duplicate. */
506: result := assignment_check(username, rolename, 'D');
507: if (result = TRUE) then
508: fnd_message.set_name('FND', 'FND_CANT_INSERT_USER_ROLE');
509: fnd_message.set_token('USERNAME', username);
510: fnd_message.set_token('ROLENAME', rolename);
511: fnd_message.set_token('ROUTINE',
512: 'FND_USER_RESP_GROUPS_API.Insert_Assignment');
513: app_exception.raise_exception;

Line 510: fnd_message.set_token('ROLENAME', rolename);

506: result := assignment_check(username, rolename, 'D');
507: if (result = TRUE) then
508: fnd_message.set_name('FND', 'FND_CANT_INSERT_USER_ROLE');
509: fnd_message.set_token('USERNAME', username);
510: fnd_message.set_token('ROLENAME', rolename);
511: fnd_message.set_token('ROUTINE',
512: 'FND_USER_RESP_GROUPS_API.Insert_Assignment');
513: app_exception.raise_exception;
514: end if;

Line 511: fnd_message.set_token('ROUTINE',

507: if (result = TRUE) then
508: fnd_message.set_name('FND', 'FND_CANT_INSERT_USER_ROLE');
509: fnd_message.set_token('USERNAME', username);
510: fnd_message.set_token('ROLENAME', rolename);
511: fnd_message.set_token('ROUTINE',
512: 'FND_USER_RESP_GROUPS_API.Insert_Assignment');
513: app_exception.raise_exception;
514: end if;
515:

Line 697: fnd_message.set_name('FND', 'FND_CANT_UPDATE_USER_ROLE');

693: /* the caller probably queried an indirect row and is trying to */
694: /* update it which is not allowed. */
695: result := assignment_check(username, rolename,'D');
696: if (result = FALSE) then
697: fnd_message.set_name('FND', 'FND_CANT_UPDATE_USER_ROLE');
698: fnd_message.set_token('USERNAME', username);
699: fnd_message.set_token('ROLENAME', rolename);
700: fnd_message.set_token('ROUTINE',
701: 'FND_USER_RESP_GROUPS_API.Update_Assignment');

Line 698: fnd_message.set_token('USERNAME', username);

694: /* update it which is not allowed. */
695: result := assignment_check(username, rolename,'D');
696: if (result = FALSE) then
697: fnd_message.set_name('FND', 'FND_CANT_UPDATE_USER_ROLE');
698: fnd_message.set_token('USERNAME', username);
699: fnd_message.set_token('ROLENAME', rolename);
700: fnd_message.set_token('ROUTINE',
701: 'FND_USER_RESP_GROUPS_API.Update_Assignment');
702: app_exception.raise_exception;

Line 699: fnd_message.set_token('ROLENAME', rolename);

695: result := assignment_check(username, rolename,'D');
696: if (result = FALSE) then
697: fnd_message.set_name('FND', 'FND_CANT_UPDATE_USER_ROLE');
698: fnd_message.set_token('USERNAME', username);
699: fnd_message.set_token('ROLENAME', rolename);
700: fnd_message.set_token('ROUTINE',
701: 'FND_USER_RESP_GROUPS_API.Update_Assignment');
702: app_exception.raise_exception;
703: end if;

Line 700: fnd_message.set_token('ROUTINE',

696: if (result = FALSE) then
697: fnd_message.set_name('FND', 'FND_CANT_UPDATE_USER_ROLE');
698: fnd_message.set_token('USERNAME', username);
699: fnd_message.set_token('ROLENAME', rolename);
700: fnd_message.set_token('ROUTINE',
701: 'FND_USER_RESP_GROUPS_API.Update_Assignment');
702: app_exception.raise_exception;
703: end if;
704: