DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on FND_LOG

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

5861: l_dummy VARCHAR2(1);
5862: --
5863:
5864: BEGIN
5865: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
5867: END IF;
5868:
5869: -- initialize error message stack

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

5862: --
5863:
5864: BEGIN
5865: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'Start of the API');
5867: END IF;
5868:
5869: -- initialize error message stack
5870: FND_MSG_PUB.Initialize;

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

5871:
5872: -- standard call to check for call compatibility
5873: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
5874: l_api_name, G_PKG_NAME) THEN
5875: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5876: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5877: ' Incompatible call. Raising exception.');
5878: END IF;
5879:

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

5872: -- standard call to check for call compatibility
5873: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
5874: l_api_name, G_PKG_NAME) THEN
5875: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5876: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5877: ' Incompatible call. Raising exception.');
5878: END IF;
5879:
5880: retcode := 2;

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

5885: -- check for pc_header_id validity
5886: OPEN check_for_pc_csr(p_pc_header_id);
5887: FETCH check_for_pc_csr INTO l_dummy;
5888: IF check_for_pc_csr%NOTFOUND THEN
5889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5890: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5891: ' Invalid PC');
5892: END IF;
5893:

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

5886: OPEN check_for_pc_csr(p_pc_header_id);
5887: FETCH check_for_pc_csr INTO l_dummy;
5888: IF check_for_pc_csr%NOTFOUND THEN
5889: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5890: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5891: ' Invalid PC');
5892: END IF;
5893:
5894: CLOSE check_for_pc_csr;

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

5902: END IF;
5903: CLOSE check_for_pc_csr;
5904:
5905: -- get all the applicable MRs for the PC
5906: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5908: ' p_pc_header_id => '||p_pc_header_id);
5909: END IF;
5910:

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

5903: CLOSE check_for_pc_csr;
5904:
5905: -- get all the applicable MRs for the PC
5906: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5907: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5908: ' p_pc_header_id => '||p_pc_header_id);
5909: END IF;
5910:
5911: OPEN get_mr_for_pc_csr(p_pc_header_id);

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

5929: x_mr_item_inst_tbl => l_mr_item_inst_tbl);
5930:
5931: -- check for the return status
5932: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5933: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5934: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5935: ' Raising exception with x_return_status => '||l_return_status);
5936: END IF;
5937:

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

5930:
5931: -- check for the return status
5932: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5933: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
5934: FND_LOG.string(FND_LOG.level_statement,l_full_name,
5935: ' Raising exception with x_return_status => '||l_return_status);
5936: END IF;
5937:
5938: retcode := 2;

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

5956: CLOSE get_mr_for_pc_csr;
5957:
5958: -- put all the applicable instances for the PC in the debug logs
5959: indx := l_pc_mr_item_inst_tbl.FIRST;
5960: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5961: WHILE indx IS NOT NULL LOOP
5962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5963: ' l_pc_mr_item_inst_tbl indx, item_instance_id => '||indx||
5964: ' ,'||l_pc_mr_item_inst_tbl(indx));

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

5958: -- put all the applicable instances for the PC in the debug logs
5959: indx := l_pc_mr_item_inst_tbl.FIRST;
5960: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5961: WHILE indx IS NOT NULL LOOP
5962: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5963: ' l_pc_mr_item_inst_tbl indx, item_instance_id => '||indx||
5964: ' ,'||l_pc_mr_item_inst_tbl(indx));
5965: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
5966: END LOOP;

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

5983:
5984: l_msg_count := FND_MSG_PUB.Count_Msg;
5985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5986: -- error based only on return status
5987: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5988: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5989: ' Build_UnitEffectivity failed for l_pc_mr_item_inst_tbl(indx) => '||
5990: l_pc_mr_item_inst_tbl(indx));
5991: END IF;

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

5984: l_msg_count := FND_MSG_PUB.Count_Msg;
5985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5986: -- error based only on return status
5987: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5988: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5989: ' Build_UnitEffectivity failed for l_pc_mr_item_inst_tbl(indx) => '||
5990: l_pc_mr_item_inst_tbl(indx));
5991: END IF;
5992:

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

5993: retcode := 2;
5994: EXIT; -- stop building unit effectivities for rest of the instances
5995: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5996: -- warning based on return status + msg count
5997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5998: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5999: ' Build_UnitEffectivity had warnings for l_pc_mr_item_inst_tbl(indx) => '||
6000: l_pc_mr_item_inst_tbl(indx));
6001: END IF;

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

5994: EXIT; -- stop building unit effectivities for rest of the instances
5995: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5996: -- warning based on return status + msg count
5997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5998: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,
5999: ' Build_UnitEffectivity had warnings for l_pc_mr_item_inst_tbl(indx) => '||
6000: l_pc_mr_item_inst_tbl(indx));
6001: END IF;
6002:

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

6008:
6009: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
6010: END LOOP;
6011:
6012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
6014: END IF;
6015:
6016: END Building_PC_Unit_Effectivities;

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

6009: indx := l_pc_mr_item_inst_tbl.NEXT(indx);
6010: END LOOP;
6011:
6012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6013: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_full_name,'End of the API');
6014: END IF;
6015:
6016: END Building_PC_Unit_Effectivities;
6017: