139: -- Validate and Default OrgId
140: l_org_id := l_quota_assign_rec.org_id;
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;
140: l_org_id := l_quota_assign_rec.org_id;
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;
306: -- Validate and Default OrgId
307: l_org_id := l_quota_assign_rec.org_id;
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;
307: l_org_id := l_quota_assign_rec.org_id;
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:
343:
344: if (l_org_id <> old_org_id) then
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;
344: if (l_org_id <> old_org_id) then
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:
524: -- Validate and Default OrgId
525: l_org_id := l_quota_assign_rec.org_id;
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;
525: l_org_id := l_quota_assign_rec.org_id;
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:
548:
549: if (l_org_id <> old_org_id) then
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;
549: if (l_org_id <> old_org_id) then
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: