DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on FND_LOG

Line 5439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5435: l_dummy VARCHAR2(1);
5436: --
5437:
5438: BEGIN
5439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
5441: END IF;
5442:
5443: -- initialize error message stack

Line 5440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');

5436: --
5437:
5438: BEGIN
5439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
5441: END IF;
5442:
5443: -- initialize error message stack
5444: FND_MSG_PUB.Initialize;

Line 5449: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5445:
5446: -- standard call to check for call compatibility
5447: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
5448: l_api_name, G_PKG_NAME) THEN
5449: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5450: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5451: ' Incompatible call. Raising exception.');
5452: END IF;
5453:

Line 5450: FND_LOG.string(FND_LOG.level_statement,l_full_name,

5446: -- standard call to check for call compatibility
5447: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
5448: l_api_name, G_PKG_NAME) THEN
5449: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5450: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5451: ' Incompatible call. Raising exception.');
5452: END IF;
5453:
5454: retcode := 2;

Line 5463: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5459: -- check for pc_header_id validity
5460: OPEN check_for_pc_csr(p_pc_header_id);
5461: FETCH check_for_pc_csr INTO l_dummy;
5462: IF check_for_pc_csr%NOTFOUND THEN
5463: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5464: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5465: ' Invalid PC');
5466: END IF;
5467:

Line 5464: FND_LOG.string(FND_LOG.level_statement,l_full_name,

5460: OPEN check_for_pc_csr(p_pc_header_id);
5461: FETCH check_for_pc_csr INTO l_dummy;
5462: IF check_for_pc_csr%NOTFOUND THEN
5463: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5464: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5465: ' Invalid PC');
5466: END IF;
5467:
5468: CLOSE check_for_pc_csr;

Line 5480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5476: END IF;
5477: CLOSE check_for_pc_csr;
5478:
5479: -- get all the applicable MRs for the PC
5480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5482: ' p_pc_header_id => '||p_pc_header_id);
5483: END IF;
5484:

Line 5481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

5477: CLOSE check_for_pc_csr;
5478:
5479: -- get all the applicable MRs for the PC
5480: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5482: ' p_pc_header_id => '||p_pc_header_id);
5483: END IF;
5484:
5485: OPEN get_mr_for_pc_csr(p_pc_header_id);

Line 5507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

5503: x_mr_item_inst_tbl => l_mr_item_inst_tbl);
5504:
5505: -- check for the return status
5506: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5508: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5509: ' Raising exception with x_return_status => '||l_return_status);
5510: END IF;
5511:

Line 5508: FND_LOG.string(FND_LOG.level_statement,l_full_name,

5504:
5505: -- check for the return status
5506: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5508: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5509: ' Raising exception with x_return_status => '||l_return_status);
5510: END IF;
5511:
5512: retcode := 2;

Line 5534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5530: CLOSE get_mr_for_pc_csr;
5531:
5532: -- put all the applicable instances for the PC in the debug logs
5533: indx := l_pc_mr_item_inst_tbl.FIRST;
5534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5535: WHILE indx IS NOT NULL LOOP
5536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5537: ' l_pc_mr_item_inst_tbl indx, item_instance_id => '||indx||
5538: ' ,'||l_pc_mr_item_inst_tbl(indx));

Line 5536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

5532: -- put all the applicable instances for the PC in the debug logs
5533: indx := l_pc_mr_item_inst_tbl.FIRST;
5534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5535: WHILE indx IS NOT NULL LOOP
5536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5537: ' l_pc_mr_item_inst_tbl indx, item_instance_id => '||indx||
5538: ' ,'||l_pc_mr_item_inst_tbl(indx));
5539: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
5540: END LOOP;

Line 5561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5557:
5558: l_msg_count := FND_MSG_PUB.Count_Msg;
5559: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5560: -- error based only on return status
5561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5563: ' Build_UnitEffectivity failed for l_pc_mr_item_inst_tbl(indx) => '||
5564: l_pc_mr_item_inst_tbl(indx));
5565: END IF;

Line 5562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

5558: l_msg_count := FND_MSG_PUB.Count_Msg;
5559: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5560: -- error based only on return status
5561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5563: ' Build_UnitEffectivity failed for l_pc_mr_item_inst_tbl(indx) => '||
5564: l_pc_mr_item_inst_tbl(indx));
5565: END IF;
5566:

Line 5571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5567: retcode := 2;
5568: EXIT; -- stop building unit effectivities for rest of the instances
5569: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5570: -- warning based on return status + msg count
5571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5573: ' Build_UnitEffectivity had warnings for l_pc_mr_item_inst_tbl(indx) => '||
5574: l_pc_mr_item_inst_tbl(indx));
5575: END IF;

Line 5572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

5568: EXIT; -- stop building unit effectivities for rest of the instances
5569: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5570: -- warning based on return status + msg count
5571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5573: ' Build_UnitEffectivity had warnings for l_pc_mr_item_inst_tbl(indx) => '||
5574: l_pc_mr_item_inst_tbl(indx));
5575: END IF;
5576:

Line 5586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5582:
5583: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
5584: END LOOP;
5585:
5586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
5588: END IF;
5589:
5590: END Building_PC_Unit_Effectivities;

Line 5587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');

5583: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
5584: END LOOP;
5585:
5586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
5588: END IF;
5589:
5590: END Building_PC_Unit_Effectivities;
5591: