APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_RATE_SCHEDULES

Line 19: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE

15: )
16: IS
17: l_api_name CONSTANT VARCHAR2 (30) := 'valid_rate_table';
18: l_tmp NUMBER := 0;
19: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE
20: -- := FND_API.G_MISS_CHAR;
21: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;
22: BEGIN
23: /*

Line 21: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;

17: l_api_name CONSTANT VARCHAR2 (30) := 'valid_rate_table';
18: l_tmp NUMBER := 0;
19: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE
20: -- := FND_API.G_MISS_CHAR;
21: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;
22: BEGIN
23: /*
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: x_loading_status := p_loading_status;

Line 53: -- cn_rate_schedules

49: x_loading_status => x_loading_status)) = FND_API.G_TRUE) THEN
50: RAISE FND_API.G_EXC_ERROR ;
51: END IF;
52: -- Rasie error when user pass in rate table name not exist in
53: -- cn_rate_schedules
54: IF (CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) IS NULL THEN
55: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
56: THEN
57: FND_MESSAGE.SET_NAME ('CN' , 'CN_RATE_SCH_NOT_EXIST');

Line 78: -- CN_RATE_SCHEDULES

74: END IF ;
75: ELSE
76: -- If rate_table_id and rate_table_name both are not missing or null,
77: -- make sure they're compatible, access to same record in
78: -- CN_RATE_SCHEDULES
79: IF(p_pe_rec.rate_table_id <>
80: CN_API.get_rate_table_id(p_pe_rec.rate_table_name)) THEN
81: -- Error, check the msg level and add an error message to the
82: -- API message list

Line 102: FROM cn_rate_schedules rs

98: -- check tier/commission unit code
99: --+
100: SELECT tier_unit_code, commission_unit_code
101: INTO l_tier_unit_code, l_comm_unit_code
102: FROM cn_rate_schedules rs
103: WHERE rs.rate_schedule_id = p_pe_rec.rate_table_id;
104: -- check tier unit code
105: IF p_pe_rec.quota_type_code IN ('TARGET','UNIT_BASED_QUOTA') THEN
106: IF l_tier_unit_code <> 'PERCENT' THEN

Line 223: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE

219: )
220: IS
221: l_api_name CONSTANT VARCHAR2 (30) := 'valid_disc_rate_table';
222: l_tmp NUMBER := 0;
223: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE
224: -- := FND_API.G_MISS_CHAR;
225: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;
226: BEGIN
227: /* x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 225: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;

221: l_api_name CONSTANT VARCHAR2 (30) := 'valid_disc_rate_table';
222: l_tmp NUMBER := 0;
223: -- l_tier_unit_code cn_rate_schedules.tier_unit_code%TYPE
224: -- := FND_API.G_MISS_CHAR;
225: l_comm_unit_code cn_rate_schedules.commission_unit_code%TYPE := fnd_api.g_miss_char;
226: BEGIN
227: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
228: x_loading_status := p_loading_status;
229:

Line 258: -- cn_rate_schedules

254: x_loading_status => x_loading_status)) = FND_API.G_TRUE) THEN
255: RAISE FND_API.G_EXC_ERROR ;
256: END IF;
257: -- Rasie error when user pass in dicsount rate table name not exist in
258: -- cn_rate_schedules
259: IF (CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) IS NULL
260: THEN
261: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
262: THEN

Line 286: -- CN_RATE_SCHEDULES

282: ELSE
283: -- If disc_rate_table_id and disc_rate_table_name both are not
284: -- missing or null,
285: -- make sure they're compatible, access to same record in
286: -- CN_RATE_SCHEDULES
287: IF(p_pe_rec.disc_rate_table_id <>
288: CN_API.get_rate_table_id(p_pe_rec.disc_rate_table_name)) THEN
289: -- Error, check the msg level and add an error message to the
290: -- API message list

Line 321: FROM cn_rate_schedules rs

317: -- check tier/commission unit code
318: --+
319: SELECT tier_unit_code, commission_unit_code
320: INTO l_tier_unit_code, l_comm_unit_code
321: FROM cn_rate_schedules rs
322: WHERE rs.rate_schedule_id = p_pe_rec.disc_rate_table_id;
323: IF l_tier_unit_code <> 'PERCENT' OR
324: l_comm_unit_code <> 'PERCENT' THEN
325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 487: -- CN_RATE_SCHEDULES

483: ELSE
484: -- If rev_class_id and rev_class_name both are not
485: -- missing or null,
486: -- make sure they're compatible, access to same record in
487: -- CN_RATE_SCHEDULES
488: IF (p_pe_rec.rev_class_id <> cn_api.get_rev_class_id (p_pe_rec.rev_class_name, p_pe_rec.org_id))
489: THEN
490: -- Error, check the msg level and add an error message to the
491: -- API message list