DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_UTIL_PKG

Line 325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );

321: END IF;
322:
323: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Processing for CMRO type of SR');
325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
326: END IF;
327:
328: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
329: AHL_UTIL_PKG.Get_Appln_Usage

Line 328: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage

324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Processing for CMRO type of SR');
325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
326: END IF;
327:
328: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
329: AHL_UTIL_PKG.Get_Appln_Usage
330: (
331: x_appln_code => l_appln_code,
332: x_return_status => l_return_status

Line 329: AHL_UTIL_PKG.Get_Appln_Usage

325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
326: END IF;
327:
328: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
329: AHL_UTIL_PKG.Get_Appln_Usage
330: (
331: x_appln_code => l_appln_code,
332: x_return_status => l_return_status
333: );

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );

332: x_return_status => l_return_status
333: );
334:
335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );
337: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' l_appln_code: ' || l_appln_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' l_return_status: ' || l_return_status);
339: END IF;
340:

Line 618: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,

614:
615: IF (l_skip_processing = false) THEN
616: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
617: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
618: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
619: x_return_status => x_return_status);
620:
621: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
622: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

Line 776: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,

772: ', p_object_version_number = ' || p_object_version_number ||
773: ' and p_x_sr_mr_association_tbl.COUNT = ' || p_x_sr_mr_association_tbl.COUNT);
774: END IF;
775: -- Check if the Application Usage profile option has been set
776: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
777: x_return_status => x_return_status);
778:
779: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
780: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

Line 874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

870: x_return_status := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
872: p_data => x_msg_data,
873: p_encoded => fnd_api.g_false);
874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
875:
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: ROLLBACK TO Process_SR_MR_Associations_pvt;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
880: p_data => x_msg_data,
881: p_encoded => fnd_api.g_false);
882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
883:
884: WHEN OTHERS THEN
885: ROLLBACK TO Process_SR_MR_Associations_pvt;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 895: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);

891: END IF;
892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => fnd_api.g_false);
895: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
896:
897: END Process_SR_MR_Associations;
898:
899: ----------------------------------------