DBA Data[Home] [Help]

APPS.CN_SRP_PMT_PLANS_PVT dependencies on CN_API

Line 197: IF ( (cn_api.invalid_date_range

193: -- Check if date range invalid
194: -- will check : if start_date is null
195: -- if start_date/end_date is missing
196: -- if start_date > end_date
197: IF ( (cn_api.invalid_date_range
198: (p_start_date => p_start_date,
199: p_end_date => p_end_date,
200: p_end_date_nullable => FND_API.G_TRUE,
201: p_loading_status => x_loading_status,

Line 802: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));

798:
799: l_note_msg VARCHAR2(240);
800: BEGIN
801: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
802: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
803: fnd_message.set_token('OLD', p_old_value);
804: fnd_message.set_token('NEW', p_new_value);
805: l_note_msg := fnd_message.get;
806:

Line 1767: /* if cn_api.date_range_overlap(

1763: x_start_date => l_start_date,
1764: x_end_date => l_end_date);
1765:
1766:
1767: /* if cn_api.date_range_overlap(
1768: a_start_date => l_srp_start_date,
1769: a_end_date => l_srp_end_date,
1770: b_start_date => l_pp_start_date,
1771: b_end_date => l_pp_end_date

Line 1774: cn_api.get_date_range_intersect(

1770: b_start_date => l_pp_start_date,
1771: b_end_date => l_pp_end_date
1772: ) THEN
1773:
1774: cn_api.get_date_range_intersect(
1775: a_start_date => l_srp_start_date,
1776: a_end_date => l_srp_end_date,
1777: b_start_date => l_pp_start_date,
1778: b_end_date => l_pp_end_date,

Line 2014: if cn_api.date_range_overlap(

2010: l_end_date_new := NULL;
2011:
2012: x_return_status := FND_API.G_RET_STS_SUCCESS;
2013:
2014: if cn_api.date_range_overlap(
2015: a_start_date => l_srp_start_date_new,
2016: a_end_date => l_srp_end_date_new,
2017: b_start_date => l_pp_start_date_new,
2018: b_end_date => l_pp_end_date_new

Line 2307: (cn_api.date_range_within(

2303: IF ((l_salesrep_id IS NOT NULL)
2304:
2305: AND
2306:
2307: (cn_api.date_range_within(
2308: a_start_date => l_start_date,
2309: a_end_date => l_end_date,
2310: b_start_date => l_role_pp_start_date,
2311: b_end_date => l_role_pp_end_date