DBA Data[Home] [Help]

APPS.MO_GLOBAL dependencies on FND_MESSAGE

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

25: PROCEDURE generic_error(routine in varchar2,
26: errcode in number,
27: errmsg in varchar2) IS
28: BEGIN
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

26: errcode in number,
27: errmsg in varchar2) IS
28: BEGIN
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);

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

27: errmsg in varchar2) IS
28: BEGIN
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
35: END IF;

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

28: BEGIN
29: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
30: fnd_message.set_token('ROUTINE', routine);
31: fnd_message.set_token('ERRNO', errcode);
32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
35: END IF;
36: fnd_message.raise_error;

Line 36: fnd_message.raise_error;

32: fnd_message.set_token('REASON', errmsg);
33: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, routine, FALSE);
35: END IF;
36: fnd_message.raise_error;
37: END;
38:
39: --
40: -- This is an internal API that accepts the ORG_ID, SECURITY_PROFILE_ID

Line 544: fnd_message.set_name('FND','FND_MO_NO_APPL_NAME_FOUND'); -- raise error to

540: FROM fnd_mo_product_init mpi
541: WHERE mpi.application_short_name = p_appl_short_name;
542: EXCEPTION
543: WHEN NO_DATA_FOUND THEN
544: fnd_message.set_name('FND','FND_MO_NO_APPL_NAME_FOUND'); -- raise error to
545: app_exception.raise_exception; -- enforce MO registration
546: WHEN OTHERS THEN
547: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
548: END;

Line 637: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_DATA_FOUND');

633: END IF;
634:
635: EXCEPTION
636: WHEN NO_ORG_ACCESS_FOUND THEN
637: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_DATA_FOUND');
638: app_exception.raise_exception;
639: WHEN NO_SP_OU_FOUND THEN
640: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_SP_OU_FOUND');
641: app_exception.raise_exception;

Line 640: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_SP_OU_FOUND');

636: WHEN NO_ORG_ACCESS_FOUND THEN
637: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_DATA_FOUND');
638: app_exception.raise_exception;
639: WHEN NO_SP_OU_FOUND THEN
640: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_SP_OU_FOUND');
641: app_exception.raise_exception;
642: WHEN NO_APPL_NAME THEN
643: app_exception.raise_exception;
644: WHEN OTHERS THEN

Line 977: fnd_message.set_name('FND', 'MO_ORG_REQUIRED');

973:
974: BEGIN
975: IF (p_org_id is null) THEN
976: -- Post an error message and return:
977: fnd_message.set_name('FND', 'MO_ORG_REQUIRED');
978: FND_MSG_PUB.ADD;
979: RETURN 'N';
980: END IF;
981:

Line 987: fnd_message.set_name('FND', 'MO_ORG_INVALID');

983: RETURN 'Y';
984: END IF;
985:
986: -- Post an error message and return:
987: fnd_message.set_name('FND', 'MO_ORG_INVALID');
988: FND_MSG_PUB.ADD;
989: RETURN 'N';
990: END;
991:

Line 1332: FND_MESSAGE.SET_NAME('FND','FND_MO_NOINIT_SP_PUB_API');

1328: STATUS := 'F'; -- initialize the variable to F
1329:
1330: IF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL
1331: AND g_ou_count = 0 THEN
1332: FND_MESSAGE.SET_NAME('FND','FND_MO_NOINIT_SP_PUB_API');
1333: FND_MSG_PUB.ADD;
1334: APP_EXCEPTION.RAISE_EXCEPTION;
1335: END IF;
1336:

Line 1353: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');

1349: IF CHECK_ACCESS(ORG_ID) = 'Y' THEN
1350: STATUS:='S';
1351: ELSE
1352: IF ERROR_MESG_SUPPR = 'N' THEN
1353: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1354: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1355: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1356: FND_MSG_PUB.ADD;
1357: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1354: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));

1350: STATUS:='S';
1351: ELSE
1352: IF ERROR_MESG_SUPPR = 'N' THEN
1353: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1354: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1355: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1356: FND_MSG_PUB.ADD;
1357: APP_EXCEPTION.RAISE_EXCEPTION;
1358: END IF;

Line 1355: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);

1351: ELSE
1352: IF ERROR_MESG_SUPPR = 'N' THEN
1353: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1354: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1355: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1356: FND_MSG_PUB.ADD;
1357: APP_EXCEPTION.RAISE_EXCEPTION;
1358: END IF;
1359: END IF;

Line 1405: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');

1401: END IF;
1402:
1403:
1404: IF STATUS='F' AND ERROR_MESG_SUPPR = 'N' THEN
1405: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');
1406: FND_MSG_PUB.ADD;
1407: APP_EXCEPTION.RAISE_EXCEPTION;
1408: -- RAISE ORG_ID_INVALID_OR_NON_DRV;
1409: END IF;

Line 1413: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');

1409: END IF;
1410:
1411: EXCEPTION
1412: WHEN ORG_ID_INVALID_OR_NON_DRV THEN
1413: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');
1414: APP_EXCEPTION.RAISE_EXCEPTION;
1415: WHEN others THEN
1416: STATUS:='F';
1417: generic_error('MO_GLOBAL.VALIDATE_ORGID_PUB_API', sqlcode, sqlerrm);