eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RT_QUOTA_ASGNS_PVT dependencies on CN_CHK_PLAN_ELEMENT_PKG

Line 88: := cn_chk_plan_element_pkg.get_calc_formula_id(

84: x_rate_schedule_id
85: := cn_api.get_rate_table_id(p_rt_quota_asgns_rec.rate_schedule_name,p_rt_quota_asgns_rec.org_id);
86:
87: l_calc_formula_id
88: := cn_chk_plan_element_pkg.get_calc_formula_id(
89: p_rt_quota_asgns_rec.calc_formula_name,p_org_id);
90: x_calc_formula_id := l_calc_formula_id;
91:
92: -- Raise an error, if rate schedule id is null, not exists in the database

Line 130: x_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id

126: p_rt_quota_asgns_rec.rate_schedule_name_old <> cn_api.g_miss_char)) THEN
127:
128: -- Get the rt_quota_asgn_id to Update the exact record.
129:
130: x_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id
131: (p_quota_id => p_quota_id,
132: p_rate_schedule_id => cn_api.get_rate_table_id
133: (p_rt_quota_asgns_rec.rate_schedule_name_old,p_rt_quota_asgns_rec.org_id),
134: p_calc_formula_id => l_calc_formula_id,

Line 179: cn_chk_plan_element_pkg.chk_date_effective

175:
176: -- Check date Effetcivity, quota rate assigns start date and end must
177: -- be with start date and end date of the quota date
178:
179: cn_chk_plan_element_pkg.chk_date_effective
180: (
181: x_return_status => x_return_status,
182: p_start_date => p_rt_quota_asgns_rec.start_date,
183: p_end_date => p_rt_quota_asgns_rec.end_date,

Line 193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN

189: x_loading_status := l_loading_status;
190:
191: -- check quota type, if quota type is NONE you cannot have rates
192:
193: IF Nvl(cn_chk_plan_element_pkg.get_quota_type ( p_quota_id ),'NONE') = 'NONE' THEN
194: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
195: THEN
196: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_CANNOT_HAVE_RATE' );
197: FND_MSG_PUB.Add;

Line 317: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

313:
314: -- check quota name is missing or null, mandatory
315: IF ( (cn_api.chk_miss_char_para
316: ( p_char_para => p_quota_name,
317: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
318: p_loading_status => x_loading_status,
319: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
320: RAISE FND_API.G_EXC_ERROR ;
321: ELSIF ( (cn_api.chk_null_char_para

Line 323: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

319: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
320: RAISE FND_API.G_EXC_ERROR ;
321: ELSIF ( (cn_api.chk_null_char_para
322: (p_char_para => p_quota_name,
323: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
324: p_loading_status => x_loading_status,
325: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
326: RAISE FND_API.G_EXC_ERROR ;
327: END IF;

Line 332: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

328:
329:
330: -- get Quota ID
331:
332: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
333:
334:
335: -- if Quota id is null and name is not null then raise an error
336:

Line 462: cn_chk_plan_element_pkg.chk_rate_quota_iud

458:
459:
460: -- Check the sequence and overlap of the start date and the end date
461:
462: cn_chk_plan_element_pkg.chk_rate_quota_iud
463: (
464: x_return_status => x_return_status,
465: p_start_Date => l_rate_date_seq_rec_tbl(i).start_date,
466: p_end_date => l_rate_date_seq_rec_tbl(i).end_date,

Line 612: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

608:
609: -- check quota name is missing or null, mandatory
610: IF ( (cn_api.chk_miss_char_para
611: ( p_char_para => p_quota_name,
612: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
613: p_loading_status => x_loading_status,
614: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
615: RAISE FND_API.G_EXC_ERROR ;
616: ELSIF ( (cn_api.chk_null_char_para

Line 618: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

614: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
615: RAISE FND_API.G_EXC_ERROR ;
616: ELSIF ( (cn_api.chk_null_char_para
617: (p_char_para => p_quota_name,
618: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
619: p_loading_status => x_loading_status,
620: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
621: RAISE FND_API.G_EXC_ERROR ;
622: END IF;

Line 624: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

620: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
621: RAISE FND_API.G_EXC_ERROR ;
622: END IF;
623:
624: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
625:
626: -- get Quota id, if id is null and name is not null then raise an error
627:
628: IF (p_quota_name IS NOT NULL

Line 743: cn_chk_plan_element_pkg.chk_rate_quota_iud

739:
740:
741: -- Check the sequence and overlap of the start date and the end date
742:
743: cn_chk_plan_element_pkg.chk_rate_quota_iud
744: (
745: x_return_status => x_return_status,
746: p_start_Date => l_rate_date_seq_rec_tbl(i).start_date,
747: p_end_date => l_rate_date_seq_rec_tbl(i).end_date,

Line 894: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

890: -- check quota name is missing or null, mandatory
891:
892: IF ( (cn_api.chk_miss_char_para
893: ( p_char_para => p_quota_name,
894: p_para_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
895: p_loading_status => x_loading_status,
896: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
897: RAISE FND_API.G_EXC_ERROR ;
898: ELSIF ( (cn_api.chk_null_char_para

Line 900: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,

896: x_loading_status => l_loading_status)) = FND_API.G_TRUE) THEN
897: RAISE FND_API.G_EXC_ERROR ;
898: ELSIF ( (cn_api.chk_null_char_para
899: (p_char_para => p_quota_name,
900: p_obj_name => CN_CHK_PLAN_ELEMENT_PKG.G_PE_NAME,
901: p_loading_status => x_loading_status,
902: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
903: RAISE FND_API.G_EXC_ERROR ;
904: END IF;

Line 906: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);

902: x_loading_status => l_loading_status)) = FND_API.G_TRUE ) THEN
903: RAISE FND_API.G_EXC_ERROR ;
904: END IF;
905:
906: l_quota_id := cn_chk_plan_element_pkg.get_quota_id(p_quota_name,p_org_id);
907:
908: -- get Quota id, if id is null and name is not null then raise an error
909:
910: IF (p_quota_name IS NOT NULL

Line 932: l_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id

928: LOOP
929:
930: -- get rt quota Assign ID to delete the record
931:
932: l_rt_quota_asgn_id := cn_chk_plan_element_pkg.get_rt_quota_asgn_id
933: (
934: p_quota_id => l_quota_id,
935: p_rate_schedule_id => cn_api.get_rate_table_id(
936: p_rt_quota_asgns_rec_tbl(i).rate_schedule_name,p_rt_quota_asgns_rec_tbl(i).org_id),

Line 937: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(

933: (
934: p_quota_id => l_quota_id,
935: p_rate_schedule_id => cn_api.get_rate_table_id(
936: p_rt_quota_asgns_rec_tbl(i).rate_schedule_name,p_rt_quota_asgns_rec_tbl(i).org_id),
937: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(
938: p_rt_quota_asgns_rec_tbl(i).calc_formula_name,p_org_id),
939: p_start_date => p_rt_quota_asgns_rec_tbl(i).start_date,
940: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date
941: );

Line 960: cn_chk_plan_element_pkg.chk_rate_quota_iud

956: END IF;
957:
958: -- Check wheather delete is Allowed, this only first and last record can be deleted
959:
960: cn_chk_plan_element_pkg.chk_rate_quota_iud
961: (
962: x_return_status => x_return_status,
963: p_start_Date => p_rt_quota_asgns_rec_tbl(i).start_date,
964: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date,

Line 967: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(

963: p_start_Date => p_rt_quota_asgns_rec_tbl(i).start_date,
964: p_end_date => p_rt_quota_asgns_rec_tbl(i).end_date,
965: p_iud_flag => 'D',
966: p_quota_id => l_quota_id,
967: p_calc_formula_id => cn_chk_plan_element_pkg.get_calc_formula_id(
968: p_rt_quota_asgns_rec_tbl(i).calc_formula_name,p_org_id),
969: p_rt_quota_asgn_id => l_rt_quota_asgn_id,
970: p_loading_status => x_loading_status,
971: x_loading_status => l_loading_status