DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PUB dependencies on CN_QUOTA_ASSIGN_PUB

Line 1: PACKAGE BODY CN_QUOTA_ASSIGN_PUB AS

1: PACKAGE BODY CN_QUOTA_ASSIGN_PUB AS
2: /*$Header: cnpqtasb.pls 120.4 2005/11/08 03:23:47 kjayapau noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_QUOTA_ASSIGN_PUB';
5: G_LAST_UPDATE_DATE DATE := Sysdate;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_QUOTA_ASSIGN_PUB';

1: PACKAGE BODY CN_QUOTA_ASSIGN_PUB AS
2: /*$Header: cnpqtasb.pls 120.4 2005/11/08 03:23:47 kjayapau noship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_QUOTA_ASSIGN_PUB';
5: G_LAST_UPDATE_DATE DATE := Sysdate;
6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
7: G_CREATION_DATE DATE := Sysdate;
8: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 145: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Create_Quota_Assign.org_validate',

141: mo_global.validate_orgid_pub_api(org_id => l_org_id, status => l_status);
142:
143: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
145: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Create_Quota_Assign.org_validate',
146: 'Validated org_id = ' || l_org_id || ' status = '|| l_status);
147: end if;
148: l_quota_assign_rec.org_id := l_org_id;
149:

Line 312: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.org_validate',

308: mo_global.validate_orgid_pub_api(org_id => l_org_id, status => l_status);
309:
310: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
312: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.org_validate',
313: 'Validated org_id = ' || l_org_id || ' status = '|| l_status);
314: end if;
315:
316: l_quota_assign_rec.org_id := l_org_id;

Line 349: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.error',

345:
346: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
347: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
348: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
349: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Update_Quota_Assign.error',
350: true);
351: end if;
352:
353: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 530: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.org_validate',

526: mo_global.validate_orgid_pub_api(org_id => l_org_id, status => l_status);
527:
528: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
530: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.org_validate',
531: 'Validated org_id = ' || l_org_id || ' status = '|| l_status);
532: end if;
533:
534: l_quota_assign_rec.org_id := l_org_id;

Line 554: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.error',

550:
551: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
552: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
553: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
554: 'cn.plsql.CN_QUOTA_ASSIGN_PUB.Delete_Quota_Assign.error',
555: true);
556: end if;
557:
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 645: END CN_QUOTA_ASSIGN_PUB;

641: p_data => x_msg_data ,
642: p_encoded => FND_API.G_FALSE );
643: END Delete_Quota_Assign;
644:
645: END CN_QUOTA_ASSIGN_PUB;