APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_PRETTY_URL_PVT

Line 2042: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;

2038: l_attr_available VARCHAR2(30);
2039: l_system_url VARCHAR2(4000); -- dbiswas added 26May05 for 11.5.10.RUP4
2040: l_pretty_url_id NUMBER; -- dbiswas added 30Aug06 for R12 bug 5477945
2041: l_ctd_id NUMBER;
2042: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;
2043: l_ctd_rec AMS_CTD_PVT.ctd_rec_type;
2044:
2045: x_status_code VARCHAR2(30);
2046:

Line 2098: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2094: OPEN c_pretty_url(l_pretty_url_id);
2095: FETCH c_pretty_url INTO l_pretty_url_rec;
2096: CLOSE c_pretty_url;
2097: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2098: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2099: p_pretty_url_rec => l_pretty_url_rec,
2100: x_return_status => l_return_status);
2101: IF l_return_status <> FND_API.g_ret_sts_success THEN
2102: RAISE FND_API.g_exc_error;

Line 2124: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,

2120: ELSE --CTD Referenced in System url but does not exist. ERROR
2121: RAISE FND_API.g_exc_error;
2122: END IF ;
2123:
2124: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2125: p_current_used_by_id => p_schedule_id,
2126: p_current_used_by_type => 'CSCH',
2127: x_return_status => l_return_status);
2128: IF l_return_status <> FND_API.g_ret_sts_success THEN

Line 2224: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2220: OPEN c_pretty_url(l_pretty_url_id);
2221: FETCH c_pretty_url INTO l_pretty_url_rec;
2222: CLOSE c_pretty_url;
2223: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2224: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2225: p_pretty_url_rec => l_pretty_url_rec,
2226: x_return_status => l_return_status);
2227: IF l_return_status <> FND_API.g_ret_sts_success THEN
2228: RAISE FND_API.g_exc_error;

Line 2250: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,

2246: ELSE --CTD Referenced in System url but does not exist. ERROR
2247: RAISE FND_API.g_exc_error;
2248: END IF ;
2249:
2250: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2251: p_current_used_by_id => p_schedule_id,
2252: p_current_used_by_type => 'CSCH',
2253: x_return_status => l_return_status);
2254: IF l_return_status <> FND_API.g_ret_sts_success THEN