DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on AHL_UTIL_PKG

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

339: END IF;
340:
341: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Processing for CMRO type of SR');
343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
344: END IF;
345:
346: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
347: AHL_UTIL_PKG.Get_Appln_Usage

Line 346: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage

342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Processing for CMRO type of SR');
343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
344: END IF;
345:
346: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
347: AHL_UTIL_PKG.Get_Appln_Usage
348: (
349: x_appln_code => l_appln_code,
350: x_return_status => l_return_status

Line 347: AHL_UTIL_PKG.Get_Appln_Usage

343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling AHL_UTIL_PKG.Get_Appln_Usage' );
344: END IF;
345:
346: --Call the procedure AHL_UTIL_PKG.Get_Appln_Usage
347: AHL_UTIL_PKG.Get_Appln_Usage
348: (
349: x_appln_code => l_appln_code,
350: x_return_status => l_return_status
351: );

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

350: x_return_status => l_return_status
351: );
352:
353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' After Calling AHL_UTIL_PKG.Get_Appln_Usage successfully' );
355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' l_appln_code: ' || l_appln_code);
356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' l_return_status: ' || l_return_status);
357: END IF;
358:

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

646:
647: IF (l_skip_processing = false) THEN
648: IF (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG) THEN
649: -- Since this is a CMRO type SR, ensure that the Application Usage profile option has been set to AHL
650: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
651: x_return_status => x_return_status);
652:
653: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
654: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

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

806: ', p_object_version_number = ' || p_object_version_number ||
807: ' and p_x_sr_mr_association_tbl.COUNT = ' || p_x_sr_mr_association_tbl.COUNT);
808: END IF;
809: -- Check if the Application Usage profile option has been set
810: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
811: x_return_status => x_return_status);
812:
813: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
814: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

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

904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
906: p_data => x_msg_data,
907: p_encoded => fnd_api.g_false);
908: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Process_SR_MR_Associations_pvt;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
914: p_data => x_msg_data,
915: p_encoded => fnd_api.g_false);
916: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
917:
918: WHEN OTHERS THEN
919: ROLLBACK TO Process_SR_MR_Associations_pvt;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

925: END IF;
926: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
927: p_data => x_msg_data,
928: p_encoded => fnd_api.g_false);
929: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
930:
931: END Process_SR_MR_Associations;
932:
933: ----------------------------------------