DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on FND_API

Line 251: IF X_Comp_Plan_Id IS NULL OR X_Comp_Plan_Id = CN_API.G_MISS_ID OR X_Comp_Plan_Id = FND_API.G_MISS_NUM THEN

247: -- Get_Uid
248: -------------------------------------------------------------------------++
249: PROCEDURE Get_Uid ( X_Comp_Plan_Id IN OUT NOCOPY NUMBER ) IS
250: BEGIN
251: IF X_Comp_Plan_Id IS NULL OR X_Comp_Plan_Id = CN_API.G_MISS_ID OR X_Comp_Plan_Id = FND_API.G_MISS_NUM THEN
252: SELECT cn_comp_plans_s.nextval
253: INTO x_comp_plan_id
254: FROM sys.dual;
255: END IF;

Line 619: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),

615: attribute14 = x_attribute14,
616: attribute15 = x_attribute15,
617: object_version_number = object_version_number + 1,
618: status_code =
619: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),
620: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),
621: decode(x_allow_rev_class_overlap,
622: nvl(x_allow_rev_class_overlap_old,'X'),
623: status_code, 'INCOMPLETE'

Line 620: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),

616: attribute15 = x_attribute15,
617: object_version_number = object_version_number + 1,
618: status_code =
619: decode(x_start_date , nvl(x_start_date_old,fnd_api.g_miss_date),
620: decode(x_end_date, nvl(x_end_date_old,fnd_api.g_miss_date),
621: decode(x_allow_rev_class_overlap,
622: nvl(x_allow_rev_class_overlap_old,'X'),
623: status_code, 'INCOMPLETE'
624: ), 'INCOMPLETE'

Line 716: RAISE FND_API.G_EXC_ERROR ;

712:
713: l_okay := Check_Assigned( X_Comp_Plan_Id);
714:
715: IF not l_okay then
716: RAISE FND_API.G_EXC_ERROR ;
717: end if;
718:
719: select 1 into l_exists FROM cn_comp_plans
720: WHERE comp_plan_id = x_comp_plan_id;

Line 1003: p_validation_level => fnd_api.g_valid_level_full,

999: cn_plan_element_pvt.validate_plan_element(
1000: p_api_version => 1.0 ,
1001: p_init_msg_list =>'F',
1002: p_commit => 'F',
1003: p_validation_level => fnd_api.g_valid_level_full,
1004: p_comp_plan_id => x_comp_plan_id,
1005: p_quota_id => quota_rec.quota_id,
1006: x_status_code => x_quota_status_code ,
1007: x_return_status => l_return_status,