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 616: fnd_message.set_name('FND','FND_MO_NO_APPL_NAME_FOUND'); -- raise error to

612: FROM fnd_mo_product_init mpi
613: WHERE mpi.application_short_name = p_appl_short_name;
614: EXCEPTION
615: WHEN NO_DATA_FOUND THEN
616: fnd_message.set_name('FND','FND_MO_NO_APPL_NAME_FOUND'); -- raise error to
617: app_exception.raise_exception; -- enforce MO registration
618: WHEN OTHERS THEN
619: generic_error('MO_GLOBAL.SET_ORG_ACCESS', sqlcode, sqlerrm);
620: END;

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

705: END IF;
706:
707: EXCEPTION
708: WHEN NO_ORG_ACCESS_FOUND THEN
709: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_DATA_FOUND');
710: app_exception.raise_exception;
711: WHEN NO_SP_OU_FOUND THEN
712: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_SP_OU_FOUND');
713: app_exception.raise_exception;

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

708: WHEN NO_ORG_ACCESS_FOUND THEN
709: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_DATA_FOUND');
710: app_exception.raise_exception;
711: WHEN NO_SP_OU_FOUND THEN
712: fnd_message.set_name('FND','MO_ORG_ACCESS_NO_SP_OU_FOUND');
713: app_exception.raise_exception;
714: WHEN NO_APPL_NAME THEN
715: app_exception.raise_exception;
716: WHEN OTHERS THEN

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

1108:
1109: BEGIN
1110: IF (p_org_id is null) THEN
1111: -- Post an error message and return:
1112: fnd_message.set_name('FND', 'MO_ORG_REQUIRED');
1113: FND_MSG_PUB.ADD;
1114: RETURN 'N';
1115: END IF;
1116:

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

1118: RETURN 'Y';
1119: END IF;
1120:
1121: -- Post an error message and return:
1122: fnd_message.set_name('FND', 'MO_ORG_INVALID');
1123: FND_MSG_PUB.ADD;
1124: RETURN 'N';
1125: END;
1126:

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

1463: STATUS := 'F'; -- initialize the variable to F
1464:
1465: IF FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') is NOT NULL
1466: AND g_ou_count = 0 THEN
1467: FND_MESSAGE.SET_NAME('FND','FND_MO_NOINIT_SP_PUB_API');
1468: FND_MSG_PUB.ADD;
1469: APP_EXCEPTION.RAISE_EXCEPTION;
1470: END IF;
1471:

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

1484: IF CHECK_ACCESS(ORG_ID) = 'Y' THEN
1485: STATUS:='S';
1486: ELSE
1487: IF ERROR_MESG_SUPPR = 'N' THEN
1488: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1489: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1490: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1491: FND_MSG_PUB.ADD;
1492: APP_EXCEPTION.RAISE_EXCEPTION;

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

1485: STATUS:='S';
1486: ELSE
1487: IF ERROR_MESG_SUPPR = 'N' THEN
1488: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1489: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1490: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1491: FND_MSG_PUB.ADD;
1492: APP_EXCEPTION.RAISE_EXCEPTION;
1493: END IF;

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

1486: ELSE
1487: IF ERROR_MESG_SUPPR = 'N' THEN
1488: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_API');
1489: FND_MESSAGE.SET_TOKEN('ORG_NAME', mo_utils.get_org_name(ORG_ID));
1490: FND_MESSAGE.SET_TOKEN('ORG_ID', ORG_ID);
1491: FND_MSG_PUB.ADD;
1492: APP_EXCEPTION.RAISE_EXCEPTION;
1493: END IF;
1494: END IF;

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

1536: END IF;
1537:
1538:
1539: IF STATUS='F' AND ERROR_MESG_SUPPR = 'N' THEN
1540: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');
1541: FND_MSG_PUB.ADD;
1542: APP_EXCEPTION.RAISE_EXCEPTION;
1543: -- RAISE ORG_ID_INVALID_OR_NON_DRV;
1544: END IF;

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

1544: END IF;
1545:
1546: EXCEPTION
1547: WHEN ORG_ID_INVALID_OR_NON_DRV THEN
1548: FND_MESSAGE.SET_NAME('FND','FND_MO_INVALID_OU_PUB_API');
1549: APP_EXCEPTION.RAISE_EXCEPTION;
1550: WHEN others THEN
1551: STATUS:='F';
1552: generic_error('MO_GLOBAL.VALIDATE_ORGID_PUB_API', sqlcode, sqlerrm);