APPS.CN_PERIOD_QUOTAS_GRP dependencies on CN_API

Line 49: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,

45:
46: -- API body
47: -- check for required data for Period_quotas
48: -- Check MISS and NULL ( Quota Name, Period_name )
49: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,
50: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
51: p_loading_status => x_loading_status,
52: x_loading_status => l_loading_status
53: )

Line 58: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

54: ) = fnd_api.g_true
55: )
56: THEN
57: RAISE fnd_api.g_exc_error;
58: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
59: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
60: p_loading_status => x_loading_status,
61: x_loading_status => l_loading_status
62: )

Line 72: IF ((cn_api.chk_miss_char_para (p_char_para => p_period_quotas_rec.period_name,

68:
69: --+
70: -- Check Period name is not miss, not null
71: --+
72: IF ((cn_api.chk_miss_char_para (p_char_para => p_period_quotas_rec.period_name,
73: p_para_name => 'Period Name',
74: p_loading_status => x_loading_status,
75: x_loading_status => l_loading_status
76: )

Line 81: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name,

77: ) = fnd_api.g_true
78: )
79: THEN
80: RAISE fnd_api.g_exc_error;
81: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name,
82: p_obj_name => 'Period Name',
83: p_loading_status => x_loading_status,
84: x_loading_status => l_loading_status
85: )

Line 158: /*IF Nvl(cn_api.get_itd_flag(l_calc_formula_id),'N') <> 'Y' THEN

154: --+
155: -- Check Itd Flag is Y
156: --+
157:
158: /*IF Nvl(cn_api.get_itd_flag(l_calc_formula_id),'N') <> 'Y' THEN
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
160: THEN
161: FND_MESSAGE.SET_NAME('CN' , 'CN_QUOTA_CANNOT_HAVE_PERIODS');
162: FND_MESSAGE.SET_TOKEN('PE_NAME',p_quota_name );

Line 172: x_period_id := cn_api.get_acc_period_id (p_period_quotas_rec.period_name, l_org_id);

168:
169: --+
170: -- get period id
171: --+
172: x_period_id := cn_api.get_acc_period_id (p_period_quotas_rec.period_name, l_org_id);
173:
174: --+
175: -- Check Period ID is Not Null
176: --+

Line 203: OR TRUNC (l_period_end_date) > TRUNC (cn_api.next_period (NVL (l_quota_end_date, l_period_end_date), l_org_id))

199: FROM cn_acc_period_statuses_v
200: WHERE period_id = x_period_id AND org_id = l_org_id;
201:
202: IF TRUNC (l_period_start_date) < TRUNC (cn_period_quotas_pkg.previous_period (l_quota_start_date,l_org_id))
203: OR TRUNC (l_period_end_date) > TRUNC (cn_api.next_period (NVL (l_quota_end_date, l_period_end_date), l_org_id))
204: THEN
205: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
206: THEN
207: fnd_message.set_name ('CN', 'CN_PRD_DT_NOT_WIN_QUOTA_DT');

Line 300: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,

296:
297: --+
298: -- Check quota name is not null
299: --+
300: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,
301: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
302: p_loading_status => x_loading_status,
303: x_loading_status => l_loading_status
304: )

Line 309: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

305: ) = fnd_api.g_true
306: )
307: THEN
308: RAISE fnd_api.g_exc_error;
309: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
310: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
311: p_loading_status => x_loading_status,
312: x_loading_status => l_loading_status
313: )

Line 344: IF ((cn_api.chk_miss_char_para (p_char_para => p_period_quotas_rec.period_name_old,

340:
341: -- +
342: -- Check period name is not null or missing
343: --+
344: IF ((cn_api.chk_miss_char_para (p_char_para => p_period_quotas_rec.period_name_old,
345: p_para_name => 'Period Name',
346: p_loading_status => x_loading_status,
347: x_loading_status => l_loading_status
348: )

Line 353: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name_old,

349: ) = fnd_api.g_true
350: )
351: THEN
352: RAISE fnd_api.g_exc_error;
353: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_period_quotas_rec.period_name_old,
354: p_obj_name => 'Period Name',
355: p_loading_status => x_loading_status,
356: x_loading_status => l_loading_status
357: )

Line 367: x_period_id_old := cn_api.get_acc_period_id (p_period_quotas_rec.period_name_old,p_period_quotas_rec.org_id);

363:
364: --+
365: -- get period id
366: --+
367: x_period_id_old := cn_api.get_acc_period_id (p_period_quotas_rec.period_name_old,p_period_quotas_rec.org_id);
368:
369: --+
370: -- Check Period ID is Not Null
371: --+

Line 428: l_meaning := cn_api.get_lkup_meaning ('PERIOD_ID', 'PERIOD_OBJECT_TYPE');

424: IF (l_period_quotas_rec.period_id <> x_period_id_old)
425: THEN
426: -- Error, check the msg level and add an error message to the
427: -- API message list
428: l_meaning := cn_api.get_lkup_meaning ('PERIOD_ID', 'PERIOD_OBJECT_TYPE');
429:
430: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
431: THEN
432: fnd_message.set_name ('CN', 'CN_PERIOD_NOT_CONSISTENT');