APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on FND_LOG

Line 2039: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2035: l_wml_i NUMBER;
2036:
2037: BEGIN
2038:
2039: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2041: END IF;
2042:
2043: -- Standard Start of API savepoint

Line 2040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');

2036:
2037: BEGIN
2038:
2039: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2041: END IF;
2042:
2043: -- Standard Start of API savepoint
2044: SAVEPOINT g_accept_changes;

Line 2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2067: ELSE
2068: l_user_access := 'NO_ACCESS';
2069: END IF;
2070:
2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2073: END IF;
2074:
2075: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN

Line 2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);

2068: l_user_access := 'NO_ACCESS';
2069: END IF;
2070:
2071: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2073: END IF;
2074:
2075: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2072: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2073: END IF;
2074:
2075: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10300: User has no privileges to accept changes');
2078: END IF;
2079:
2080: END IF;

Line 2077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10300: User has no privileges to accept changes');

2073: END IF;
2074:
2075: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10300: User has no privileges to accept changes');
2078: END IF;
2079:
2080: END IF;
2081: --2 way word sync with clause edit begins

Line 2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2143: obj_titles,
2144: orut_ids;
2145: CLOSE accepted_terms_csr;
2146: END IF;
2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10400: After bulk collect of accepted_terms_csr');
2149: END IF;
2150:
2151: IF rut_ids.COUNT > 0 THEN

Line 2148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10400: After bulk collect of accepted_terms_csr');

2144: orut_ids;
2145: CLOSE accepted_terms_csr;
2146: END IF;
2147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10400: After bulk collect of accepted_terms_csr');
2149: END IF;
2150:
2151: IF rut_ids.COUNT > 0 THEN
2152: FOR i IN rut_ids.FIRST .. rut_ids.LAST

Line 2160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2156: END LOOP;
2157:
2158: END IF; --IF rut_ids.COUNT > 0 THEN
2159:
2160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2161: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: After looping thru new_parents_csr');
2162: END IF;
2163:
2164: IF rut_ids.COUNT > 0 THEN

Line 2161: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: After looping thru new_parents_csr');

2157:
2158: END IF; --IF rut_ids.COUNT > 0 THEN
2159:
2160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2161: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: After looping thru new_parents_csr');
2162: END IF;
2163:
2164: IF rut_ids.COUNT > 0 THEN
2165:

Line 2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2162: END IF;
2163:
2164: IF rut_ids.COUNT > 0 THEN
2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10600: Review records exist before looping');
2168: END IF;
2169:
2170: FOR i IN rut_ids.FIRST .. rut_ids.LAST

Line 2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10600: Review records exist before looping');

2163:
2164: IF rut_ids.COUNT > 0 THEN
2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10600: Review records exist before looping');
2168: END IF;
2169:
2170: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2171: LOOP

Line 2173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2169:
2170: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2171: LOOP
2172:
2173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10700: Looping thru review records');
2175: END IF;
2176:
2177: l_ref_id := null;

Line 2174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10700: Looping thru review records');

2170: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2171: LOOP
2172:
2173: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2174: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10700: Looping thru review records');
2175: END IF;
2176:
2177: l_ref_id := null;
2178: IF (new_parents(i) is not null and pobj_types(i) = 'SECTION') THEN

Line 2198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2194: END IF;
2195:
2196: IF actions(i) = 'ADDED' THEN
2197:
2198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10900: Action is ADDED');
2200: END IF;
2201:
2202: IF obj_types(i) = 'SECTION' THEN

Line 2199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10900: Action is ADDED');

2195:
2196: IF actions(i) = 'ADDED' THEN
2197:
2198: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10900: Action is ADDED');
2200: END IF;
2201:
2202: IF obj_types(i) = 'SECTION' THEN
2203:

Line 2204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2200: END IF;
2201:
2202: IF obj_types(i) = 'SECTION' THEN
2203:
2204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: Object Type is SECTION');
2206: END IF;
2207:
2208: IF (to_char(obj_titles(i)) =

Line 2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: Object Type is SECTION');

2201:
2202: IF obj_types(i) = 'SECTION' THEN
2203:
2204: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: Object Type is SECTION');
2206: END IF;
2207:
2208: IF (to_char(obj_titles(i)) =
2209: Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE)) THEN

Line 2213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2209: Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE)) THEN
2210:
2211: l_scn_code := G_UNASSIGNED_SECTION_CODE;
2212:
2213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: Section is Unassigned');
2215: END IF;
2216: ELSE
2217: l_scn_code := null;

Line 2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: Section is Unassigned');

2210:
2211: l_scn_code := G_UNASSIGNED_SECTION_CODE;
2212:
2213: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2214: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: Section is Unassigned');
2215: END IF;
2216: ELSE
2217: l_scn_code := null;
2218: END IF;

Line 2220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2216: ELSE
2217: l_scn_code := null;
2218: END IF;
2219:
2220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11200: Before calling OKC_TERMS_SECTIONS_GRP.add_section');
2222: END IF;
2223:
2224: OKC_TERMS_SECTIONS_GRP.add_section(

Line 2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11200: Before calling OKC_TERMS_SECTIONS_GRP.add_section');

2217: l_scn_code := null;
2218: END IF;
2219:
2220: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11200: Before calling OKC_TERMS_SECTIONS_GRP.add_section');
2222: END IF;
2223:
2224: OKC_TERMS_SECTIONS_GRP.add_section(
2225: p_api_version => p_api_version,

Line 2249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2245:
2246: curr_obj_ids(rut_ids(i)) := l_scn_id;
2247: obj_ids(i) := l_scn_id;
2248:
2249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2252: END IF;
2253:

Line 2250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');

2246: curr_obj_ids(rut_ids(i)) := l_scn_id;
2247: obj_ids(i) := l_scn_id;
2248:
2249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2252: END IF;
2253:
2254: ELSIF obj_types(i) = 'ARTICLE' THEN

Line 2251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);

2247: obj_ids(i) := l_scn_id;
2248:
2249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2252: END IF;
2253:
2254: ELSIF obj_types(i) = 'ARTICLE' THEN
2255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2251: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2252: END IF;
2253:
2254: ELSIF obj_types(i) = 'ARTICLE' THEN
2255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11500: Object Type is ARTICLE');
2257: END IF;
2258:
2259: IF l_prof_value = 'Y' THEN

Line 2256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11500: Object Type is ARTICLE');

2252: END IF;
2253:
2254: ELSIF obj_types(i) = 'ARTICLE' THEN
2255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11500: Object Type is ARTICLE');
2257: END IF;
2258:
2259: IF l_prof_value = 'Y' THEN
2260: NULL;

Line 2266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2262: obj_texts(i) :=
2263: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2264: END IF;
2265:
2266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11600: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2268: END IF;
2269:
2270: OKC_K_NON_STD_ART_GRP.create_non_std_article(

Line 2267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11600: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');

2263: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2264: END IF;
2265:
2266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11600: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2268: END IF;
2269:
2270: OKC_K_NON_STD_ART_GRP.create_non_std_article(
2271: p_api_version => p_api_version,

Line 2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2303: IF l_prof_value = 'Y' THEN
2304: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2305: END IF;
2306:
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: After calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2310: END IF;
2311: END IF; --IF obj_types(i) = 'SECTION' THEN

Line 2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: After calling OKC_K_NON_STD_ART_GRP.create_non_std_article');

2304: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2305: END IF;
2306:
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: After calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2310: END IF;
2311: END IF; --IF obj_types(i) = 'SECTION' THEN
2312: ELSIF actions(i) = 'UPDATED' THEN

Line 2309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);

2305: END IF;
2306:
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: After calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2310: END IF;
2311: END IF; --IF obj_types(i) = 'SECTION' THEN
2312: ELSIF actions(i) = 'UPDATED' THEN
2313:

Line 2314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2310: END IF;
2311: END IF; --IF obj_types(i) = 'SECTION' THEN
2312: ELSIF actions(i) = 'UPDATED' THEN
2313:
2314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11900: Action is UPDATED');
2316: END IF;
2317:
2318: IF obj_types(i) = 'SECTION' THEN

Line 2315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11900: Action is UPDATED');

2311: END IF; --IF obj_types(i) = 'SECTION' THEN
2312: ELSIF actions(i) = 'UPDATED' THEN
2313:
2314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11900: Action is UPDATED');
2316: END IF;
2317:
2318: IF obj_types(i) = 'SECTION' THEN
2319:

Line 2320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2316: END IF;
2317:
2318: IF obj_types(i) = 'SECTION' THEN
2319:
2320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12000: B4 call OKC_TERMS_SECTIONS_GRP.update_section');
2322: END IF;
2323:
2324: OKC_TERMS_SECTIONS_GRP.update_section(

Line 2321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12000: B4 call OKC_TERMS_SECTIONS_GRP.update_section');

2317:
2318: IF obj_types(i) = 'SECTION' THEN
2319:
2320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12000: B4 call OKC_TERMS_SECTIONS_GRP.update_section');
2322: END IF;
2323:
2324: OKC_TERMS_SECTIONS_GRP.update_section(
2325: p_api_version => p_api_version,

Line 2344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2340: p_description => NULL,
2341: p_scn_code => FND_API.G_MISS_CHAR,
2342: p_object_version_number => NULL);
2343:
2344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');
2346: END IF;
2347:
2348: ELSIF obj_types(i) = 'ARTICLE' THEN

Line 2345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');

2341: p_scn_code => FND_API.G_MISS_CHAR,
2342: p_object_version_number => NULL);
2343:
2344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');
2346: END IF;
2347:
2348: ELSIF obj_types(i) = 'ARTICLE' THEN
2349:

Line 2357: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2353: obj_texts(i) :=
2354: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2355: END IF;
2356:
2357: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: Object Type is ARTICLE');
2359: END IF;
2360:
2361: IF non_stds(i) = 'Y' THEN

Line 2358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: Object Type is ARTICLE');

2354: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2355: END IF;
2356:
2357: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: Object Type is ARTICLE');
2359: END IF;
2360:
2361: IF non_stds(i) = 'Y' THEN
2362:

Line 2363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2359: END IF;
2360:
2361: IF non_stds(i) = 'Y' THEN
2362:
2363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12300: Non-Std article');
2365: END IF;
2366:
2367: l_article_type := null;

Line 2364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12300: Non-Std article');

2360:
2361: IF non_stds(i) = 'Y' THEN
2362:
2363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12300: Non-Std article');
2365: END IF;
2366:
2367: l_article_type := null;
2368:

Line 2373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2369: open get_clause_type_csr(rut_ids(i));
2370: fetch get_clause_type_csr into l_article_type;
2371: close get_clause_type_csr;
2372:
2373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12400: B4 call OKC_K_NON_STD_ART_GRP.update_non_std_article');
2375: END IF;
2376:
2377: OKC_K_NON_STD_ART_GRP.update_non_std_article(

Line 2374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12400: B4 call OKC_K_NON_STD_ART_GRP.update_non_std_article');

2370: fetch get_clause_type_csr into l_article_type;
2371: close get_clause_type_csr;
2372:
2373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12400: B4 call OKC_K_NON_STD_ART_GRP.update_non_std_article');
2375: END IF;
2376:
2377: OKC_K_NON_STD_ART_GRP.update_non_std_article(
2378: p_api_version => p_api_version,

Line 2412: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2408: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2409: END IF;
2410:
2411:
2412: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12500: After OKC_K_NON_STD_ART_GRP.update_non_std_article');
2414: END IF;
2415:
2416: ELSE --IF non_stds(i) = 'Y' THEN

Line 2413: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12500: After OKC_K_NON_STD_ART_GRP.update_non_std_article');

2409: END IF;
2410:
2411:
2412: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2413: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12500: After OKC_K_NON_STD_ART_GRP.update_non_std_article');
2414: END IF;
2415:
2416: ELSE --IF non_stds(i) = 'Y' THEN
2417:

Line 2418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2414: END IF;
2415:
2416: ELSE --IF non_stds(i) = 'Y' THEN
2417:
2418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12600: Std article');
2420: END IF;
2421:
2422: is_ibr := 'N';

Line 2419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12600: Std article');

2415:
2416: ELSE --IF non_stds(i) = 'Y' THEN
2417:
2418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12600: Std article');
2420: END IF;
2421:
2422: is_ibr := 'N';
2423: is_lock_text := 'N';

Line 2429: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2425: open is_article_ibr(rut_ids(i));
2426: fetch is_article_ibr into is_ibr;
2427: close is_article_ibr;
2428:
2429: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: is_ibr='||is_ibr);
2431: END IF;
2432:
2433: IF (is_ibr <> 'Y') THEN

Line 2430: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: is_ibr='||is_ibr);

2426: fetch is_article_ibr into is_ibr;
2427: close is_article_ibr;
2428:
2429: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: is_ibr='||is_ibr);
2431: END IF;
2432:
2433: IF (is_ibr <> 'Y') THEN
2434:

Line 2439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2435: open is_article_text_locked(rut_ids(i));
2436: fetch is_article_text_locked into is_lock_text;
2437: close is_article_text_locked;
2438:
2439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12800: is_lock_text='||is_lock_text);
2441: END IF;
2442:
2443:

Line 2440: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12800: is_lock_text='||is_lock_text);

2436: fetch is_article_text_locked into is_lock_text;
2437: close is_article_text_locked;
2438:
2439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12800: is_lock_text='||is_lock_text);
2441: END IF;
2442:
2443:
2444: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR

Line 2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2443:
2444: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2445: is_lock_text <> 'Y') THEN
2446:
2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;

Line 2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');

2444: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2445: is_lock_text <> 'Y') THEN
2446:
2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;
2452:

Line 2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');

2445: is_lock_text <> 'Y') THEN
2446:
2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;
2452:
2453: UPDATE okc_k_articles_b

Line 2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));

2446:
2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;
2452:
2453: UPDATE okc_k_articles_b
2454: SET scn_id = l_ref_id

Line 2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2492: IF l_prof_value = 'Y' THEN
2493: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2494: END IF;
2495:
2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');
2498: END IF;
2499: END IF; -- if l_user_access...
2500: END IF; -- if ibr_text <> 'Y'

Line 2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');

2493: OKC_WORD_DOWNLOAD_UPLOAD.INSERT_WML_TEXT(l_article_version_id,obj_texts_wml(i));
2494: END IF;
2495:
2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');
2498: END IF;
2499: END IF; -- if l_user_access...
2500: END IF; -- if ibr_text <> 'Y'
2501: END IF; -- IF non_stds(i) = 'Y' THEN

Line 2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2502: END IF;
2503:
2504: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2508: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2509: END IF;
2510:

Line 2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));

2503:
2504: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2508: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2509: END IF;
2510:
2511: IF obj_types(i) = 'SECTION' THEN

Line 2508: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));

2504: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2508: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2509: END IF;
2510:
2511: IF obj_types(i) = 'SECTION' THEN
2512: IF p_mode = 'AMEND' THEN

Line 2513: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2509: END IF;
2510:
2511: IF obj_types(i) = 'SECTION' THEN
2512: IF p_mode = 'AMEND' THEN
2513: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2515: END IF;
2516:
2517: UPDATE okc_sections_b scn

Line 2514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);

2510:
2511: IF obj_types(i) = 'SECTION' THEN
2512: IF p_mode = 'AMEND' THEN
2513: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2515: END IF;
2516:
2517: UPDATE okc_sections_b scn
2518: SET scn.last_updated_by = fnd_global.user_id,

Line 2531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2527: scn.last_amendment_date = sysdate
2528: WHERE scn.id = obj_ids(i);
2529: ELSE
2530:
2531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2533: END IF;
2534:
2535: DELETE FROM okc_sections_b

Line 2532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);

2528: WHERE scn.id = obj_ids(i);
2529: ELSE
2530:
2531: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2533: END IF;
2534:
2535: DELETE FROM okc_sections_b
2536: WHERE id = obj_ids(i);

Line 2541: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2537: END IF; --IF p_mode = 'AMEND' THEN
2538:
2539: ELSIF obj_types(i) = 'ARTICLE' THEN
2540:
2541: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13800: Clause Title=' || obj_titles(i));
2543: END IF;
2544:
2545: is_mandatory_text := 'N';

Line 2542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13800: Clause Title=' || obj_titles(i));

2538:
2539: ELSIF obj_types(i) = 'ARTICLE' THEN
2540:
2541: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13800: Clause Title=' || obj_titles(i));
2543: END IF;
2544:
2545: is_mandatory_text := 'N';
2546:

Line 2551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2547: open is_article_mandatory(rut_ids(i));
2548: fetch is_article_mandatory into is_mandatory_text;
2549: close is_article_mandatory;
2550:
2551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2553: END IF;
2554:
2555: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then

Line 2552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);

2548: fetch is_article_mandatory into is_mandatory_text;
2549: close is_article_mandatory;
2550:
2551: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2553: END IF;
2554:
2555: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2553: END IF;
2554:
2555: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2558: END IF;
2559: IF p_mode = 'AMEND' THEN
2560:

Line 2557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');

2553: END IF;
2554:
2555: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2558: END IF;
2559: IF p_mode = 'AMEND' THEN
2560:
2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2558: END IF;
2559: IF p_mode = 'AMEND' THEN
2560:
2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2563: END IF;
2564:
2565: UPDATE okc_k_articles_b kart

Line 2562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));

2558: END IF;
2559: IF p_mode = 'AMEND' THEN
2560:
2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2563: END IF;
2564:
2565: UPDATE okc_k_articles_b kart
2566: SET kart.last_updated_by = fnd_global.user_id,

Line 2579: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2575: kart.last_amendment_date = sysdate
2576: WHERE kart.id = obj_ids(i);
2577: ELSE
2578:
2579: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2580: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2581: END IF;
2582:
2583: DELETE FROM okc_k_articles_b

Line 2580: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));

2576: WHERE kart.id = obj_ids(i);
2577: ELSE
2578:
2579: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2580: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2581: END IF;
2582:
2583: DELETE FROM okc_k_articles_b
2584: WHERE id = obj_ids(i);

Line 2587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2583: DELETE FROM okc_k_articles_b
2584: WHERE id = obj_ids(i);
2585: END IF;
2586:
2587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2589: END IF;
2590: END IF; --IF ((l_user_access = 'SUPER_USER' )
2591: END IF; --IF obj_types(i) = 'SECTION' THEN

Line 2588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');

2584: WHERE id = obj_ids(i);
2585: END IF;
2586:
2587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2589: END IF;
2590: END IF; --IF ((l_user_access = 'SUPER_USER' )
2591: END IF; --IF obj_types(i) = 'SECTION' THEN
2592: --ELSE

Line 2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2593: END IF; --IF actions(i) = 'ADDED'
2594: END LOOP;
2595: END IF; --IF rut_ids.COUNT > 0 THEN
2596:
2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2599: END IF;
2600:
2601: FORALL i IN rut_ids.FIRST..rut_ids.LAST

Line 2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');

2594: END LOOP;
2595: END IF; --IF rut_ids.COUNT > 0 THEN
2596:
2597: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2599: END IF;
2600:
2601: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2602: UPDATE okc_sections_b

Line 2608: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2604: section_sequence = disp_seqs(i)
2605: WHERE id = obj_ids(i)
2606: AND obj_types(i) = 'SECTION';
2607:
2608: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2610: END IF;
2611:
2612: FORALL i IN rut_ids.FIRST..rut_ids.LAST

Line 2609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');

2605: WHERE id = obj_ids(i)
2606: AND obj_types(i) = 'SECTION';
2607:
2608: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2610: END IF;
2611:
2612: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2613: UPDATE okc_k_articles_b

Line 2619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2615: display_sequence = disp_seqs(i)
2616: WHERE id = obj_ids(i)
2617: AND obj_types(i) = 'ARTICLE';
2618:
2619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2621: END IF;
2622:
2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

Line 2620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');

2616: WHERE id = obj_ids(i)
2617: AND obj_types(i) = 'ARTICLE';
2618:
2619: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2620: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2621: END IF;
2622:
2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2624: p_api_version => l_api_version,

Line 2649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2645: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2646: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2647: document_id = p_document_id);
2648:
2649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');
2651: END IF;
2652:
2653: open current_num_scheme;

Line 2650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');

2646: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2647: document_id = p_document_id);
2648:
2649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');
2651: END IF;
2652:
2653: open current_num_scheme;
2654: fetch current_num_scheme into l_doc_num_scheme;

Line 2657: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2653: open current_num_scheme;
2654: fetch current_num_scheme into l_doc_num_scheme;
2655: close current_num_scheme;
2656:
2657: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2658: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2659: END IF;
2660:
2661: IF (l_doc_num_scheme is NOT NULL) THEN

Line 2658: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);

2654: fetch current_num_scheme into l_doc_num_scheme;
2655: close current_num_scheme;
2656:
2657: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2658: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2659: END IF;
2660:
2661: IF (l_doc_num_scheme is NOT NULL) THEN
2662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2658: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2659: END IF;
2660:
2661: IF (l_doc_num_scheme is NOT NULL) THEN
2662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Before invoking apply_numbering_scheme');
2664: END IF;
2665:
2666: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(

Line 2663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Before invoking apply_numbering_scheme');

2659: END IF;
2660:
2661: IF (l_doc_num_scheme is NOT NULL) THEN
2662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Before invoking apply_numbering_scheme');
2664: END IF;
2665:
2666: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
2667: p_api_version => p_api_version,

Line 2678: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2674: p_doc_type => p_document_type,
2675: p_doc_id => p_document_id,
2676: p_num_scheme_id => l_doc_num_scheme);
2677:
2678: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2680: END IF;
2681: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2682:

Line 2679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');

2675: p_doc_id => p_document_id,
2676: p_num_scheme_id => l_doc_num_scheme);
2677:
2678: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2680: END IF;
2681: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2682:
2683: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2683: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2680: END IF;
2681: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2682:
2683: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2684: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2685: END IF;
2686:
2687: -- Added for Performance after accepting the changes no longer required to retain data in this table.

Line 2684: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');

2680: END IF;
2681: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2682:
2683: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2684: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2685: END IF;
2686:
2687: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2688: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;

Line 2697: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2693: END IF;
2694:
2695: EXCEPTION
2696: WHEN FND_API.G_EXC_ERROR THEN
2697: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2699: END IF;
2700: ROLLBACK TO g_accept_changes;
2701: x_return_status := G_RET_STS_ERROR ;

Line 2698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');

2694:
2695: EXCEPTION
2696: WHEN FND_API.G_EXC_ERROR THEN
2697: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2699: END IF;
2700: ROLLBACK TO g_accept_changes;
2701: x_return_status := G_RET_STS_ERROR ;
2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2705: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2701: x_return_status := G_RET_STS_ERROR ;
2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2703:
2704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2705: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2707: END IF;
2708: ROLLBACK TO g_accept_Changes;
2709: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2703:
2704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2705: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2707: END IF;
2708: ROLLBACK TO g_accept_Changes;
2709: x_return_status := G_RET_STS_UNEXP_ERROR ;
2710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2709: x_return_status := G_RET_STS_UNEXP_ERROR ;
2710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2711:
2712: WHEN OTHERS THEN
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);
2715: END IF;
2716:
2717: ROLLBACK TO g_accept_changes;

Line 2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);

2710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2711:
2712: WHEN OTHERS THEN
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);
2715: END IF;
2716:
2717: ROLLBACK TO g_accept_changes;
2718: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2738: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Changes';
2739: l_api_version CONSTANT NUMBER := 1;
2740:
2741: BEGIN
2742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2744: END IF;
2745:
2746: -- Standard Start of API savepoint

Line 2743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');

2739: l_api_version CONSTANT NUMBER := 1;
2740:
2741: BEGIN
2742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2744: END IF;
2745:
2746: -- Standard Start of API savepoint
2747: SAVEPOINT g_reject_changes;

Line 2771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2767: p_document_type => p_document_type,
2768: p_document_id => p_document_id
2769: );
2770:
2771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2773: END IF;
2774:
2775: -- Added for Performance after accepting the changes no longer required to retain data in this table.

Line 2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');

2768: p_document_id => p_document_id
2769: );
2770:
2771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2773: END IF;
2774:
2775: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2776: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;

Line 2785: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2781: END IF;
2782:
2783: EXCEPTION
2784: WHEN FND_API.G_EXC_ERROR THEN
2785: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_reject_changes;
2789: x_return_status := G_RET_STS_ERROR ;

Line 2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');

2782:
2783: EXCEPTION
2784: WHEN FND_API.G_EXC_ERROR THEN
2785: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_reject_changes;
2789: x_return_status := G_RET_STS_ERROR ;
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2793: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2789: x_return_status := G_RET_STS_ERROR ;
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2791:
2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_reject_Changes;
2797: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2791:
2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_reject_Changes;
2797: x_return_status := G_RET_STS_UNEXP_ERROR ;
2798: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2797: x_return_status := G_RET_STS_UNEXP_ERROR ;
2798: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2799:
2800: WHEN OTHERS THEN
2801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2802: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
2803: END IF;
2804:
2805: ROLLBACK TO g_reject_changes;

Line 2802: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

2798: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2799:
2800: WHEN OTHERS THEN
2801: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2802: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
2803: END IF;
2804:
2805: ROLLBACK TO g_reject_changes;
2806: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2828: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Uploaded_Terms';
2829: l_api_version CONSTANT NUMBER := 1;
2830:
2831: BEGIN
2832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2834: END IF;
2835:
2836: -- Standard Start of API savepoint

Line 2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');

2829: l_api_version CONSTANT NUMBER := 1;
2830:
2831: BEGIN
2832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2834: END IF;
2835:
2836: -- Standard Start of API savepoint
2837: SAVEPOINT g_delete_uploaded_terms;

Line 2857: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2853: FROM okc_REVIEW_UPLD_TERMS
2854: WHERE document_id = p_document_id
2855: AND document_type = p_document_type);
2856:
2857: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2859: END IF;
2860:
2861: DELETE

Line 2858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');

2854: WHERE document_id = p_document_id
2855: AND document_type = p_document_type);
2856:
2857: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2859: END IF;
2860:
2861: DELETE
2862: FROM OKC_REVIEW_VAR_VALUES v

Line 2869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2865: FROM okc_REVIEW_UPLD_TERMS
2866: WHERE document_id = p_document_id
2867: AND document_type = p_document_type);
2868:
2869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');
2871: END IF;
2872:
2873: DELETE

Line 2870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');

2866: WHERE document_id = p_document_id
2867: AND document_type = p_document_type);
2868:
2869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');
2871: END IF;
2872:
2873: DELETE
2874: FROM OKC_REVIEW_UPLD_TERMS

Line 2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2879: FROM OKC_REVIEW_UPLD_HEADER
2880: WHERE document_id = p_document_id
2881: AND document_type = p_document_type;
2882:
2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2885: END IF;
2886:
2887: -- Standard check of p_commit

Line 2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');

2880: WHERE document_id = p_document_id
2881: AND document_type = p_document_type;
2882:
2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2885: END IF;
2886:
2887: -- Standard check of p_commit
2888: IF FND_API.To_Boolean( p_commit ) THEN

Line 2894: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2890: END IF;
2891:
2892: EXCEPTION
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2895: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2896: END IF;
2897: ROLLBACK TO g_delete_uploaded_terms;
2898: x_return_status := G_RET_STS_ERROR ;

Line 2895: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');

2891:
2892: EXCEPTION
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2895: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2896: END IF;
2897: ROLLBACK TO g_delete_uploaded_terms;
2898: x_return_status := G_RET_STS_ERROR ;
2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2898: x_return_status := G_RET_STS_ERROR ;
2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2904: END IF;
2905: ROLLBACK TO g_delete_uploaded_terms;
2906: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2904: END IF;
2905: ROLLBACK TO g_delete_uploaded_terms;
2906: x_return_status := G_RET_STS_UNEXP_ERROR ;
2907: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 2910: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2906: x_return_status := G_RET_STS_UNEXP_ERROR ;
2907: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2908:
2909: WHEN OTHERS THEN
2910: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);
2912: END IF;
2913:
2914: ROLLBACK TO g_delete_uploaded_terms;

Line 2911: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);

2907: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2908:
2909: WHEN OTHERS THEN
2910: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2911: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);
2912: END IF;
2913:
2914: ROLLBACK TO g_delete_uploaded_terms;
2915: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 3764: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3760:
3761: open clauses_without_parent_exist;
3762: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3763: if (clauses_without_parent_exist%FOUND) THEN
3764: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');
3766: END IF;
3767: open unassigned_section_exists;
3768: fetch unassigned_section_exists into l_unassigned_scn_id;

Line 3765: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');

3761: open clauses_without_parent_exist;
3762: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3763: if (clauses_without_parent_exist%FOUND) THEN
3764: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3765: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');
3766: END IF;
3767: open unassigned_section_exists;
3768: fetch unassigned_section_exists into l_unassigned_scn_id;
3769: if(unassigned_section_exists%NOTFOUND)THEN

Line 3780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3776: x_return_status => x_return_status,
3777: x_msg_count => x_msg_count,
3778: x_msg_data => x_msg_data
3779: );
3780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3783: END IF;
3784:

Line 3781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);

3777: x_msg_count => x_msg_count,
3778: x_msg_data => x_msg_data
3779: );
3780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3783: END IF;
3784:
3785: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);

3778: x_msg_data => x_msg_data
3779: );
3780: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3781: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3783: END IF;
3784:
3785: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 4013: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4009: IF l_prof_value = 'Y' THEN
4010: NULL;
4011: ELSE
4012:
4013: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
4015: for upd_csr in get_updated_articles_csr loop
4016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
4017: end loop;

Line 4014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');

4010: NULL;
4011: ELSE
4012:
4013: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
4015: for upd_csr in get_updated_articles_csr loop
4016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
4017: end loop;
4018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');

Line 4016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );

4012:
4013: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
4015: for upd_csr in get_updated_articles_csr loop
4016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
4017: end loop;
4018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');
4019: END IF;
4020:

Line 4018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');

4014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
4015: for upd_csr in get_updated_articles_csr loop
4016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
4017: end loop;
4018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');
4019: END IF;
4020:
4021: END IF;
4022: -- 2 way word sync with clause edit ends

Line 4024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4020:
4021: END IF;
4022: -- 2 way word sync with clause edit ends
4023:
4024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
4026: END IF;
4027: l_clause_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_CLAUSE');
4028: l_section_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_SECTION');

Line 4025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');

4021: END IF;
4022: -- 2 way word sync with clause edit ends
4023:
4024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
4026: END IF;
4027: l_clause_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_CLAUSE');
4028: l_section_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_SECTION');
4029: l_clause_counter:= 1;

Line 4230: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4226: END IF;
4227:
4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4231: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4232: END IF;
4233: ROLLBACK TO g_reject_changes;
4234: x_return_status := G_RET_STS_ERROR ;

Line 4231: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');

4227:
4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4231: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4232: END IF;
4233: ROLLBACK TO g_reject_changes;
4234: x_return_status := G_RET_STS_ERROR ;
4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 4238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4234: x_return_status := G_RET_STS_ERROR ;
4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4236:
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4240: END IF;
4241: ROLLBACK TO g_reject_Changes;
4242: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4236:
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4240: END IF;
4241: ROLLBACK TO g_reject_Changes;
4242: x_return_status := G_RET_STS_UNEXP_ERROR ;
4243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

Line 4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4242: x_return_status := G_RET_STS_UNEXP_ERROR ;
4243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4244:
4245: WHEN OTHERS THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
4248: END IF;
4249:
4250: ROLLBACK TO g_reject_changes;

Line 4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);

4243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4244:
4245: WHEN OTHERS THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
4248: END IF;
4249:
4250: ROLLBACK TO g_reject_changes;
4251: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4287: AND DOCUMENT_ID = p_document_id
4288: AND PARENT_ID IS NULL or new_parent_id = p_document_id;
4289:
4290: BEGIN
4291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4293: END IF;
4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;

Line 4292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');

4288: AND PARENT_ID IS NULL or new_parent_id = p_document_id;
4289:
4290: BEGIN
4291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4293: END IF;
4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;
4296: -- Standard call to check for call compatibility.

Line 4313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4309: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
4310: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
4311: -- Set x_scn_id to id returned by simpel API.
4312: --------------------------------------------
4313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');
4315: END IF;
4316: --------------------------------------------
4317: l_meaning := Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE);

Line 4314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');

4310: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
4311: -- Set x_scn_id to id returned by simpel API.
4312: --------------------------------------------
4313: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4314: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');
4315: END IF;
4316: --------------------------------------------
4317: l_meaning := Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE);
4318:

Line 4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4395: COMMIT WORK;
4396: END IF;
4397: -- Standard call to get message count and if count is 1, get message info.
4398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN

Line 4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');

4396: END IF;
4397: -- Standard call to get message count and if count is 1, get message info.
4398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: ROLLBACK TO g_Create_Unassigned_Section;

Line 4405: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: ROLLBACK TO g_Create_Unassigned_Section;
4405: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4406: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');
4407: END IF;
4408:
4409: IF l_get_max_seq_csr%ISOPEN THEN

Line 4406: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');

4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: ROLLBACK TO g_Create_Unassigned_Section;
4405: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4406: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');
4407: END IF;
4408:
4409: IF l_get_max_seq_csr%ISOPEN THEN
4410: CLOSE l_get_max_seq_csr;

Line 4418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4415:
4416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4417: ROLLBACK TO g_Create_Unassigned_Section;
4418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4420: END IF;
4421:
4422: IF l_get_max_seq_csr%ISOPEN THEN

Line 4419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

4415:
4416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4417: ROLLBACK TO g_Create_Unassigned_Section;
4418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4420: END IF;
4421:
4422: IF l_get_max_seq_csr%ISOPEN THEN
4423: CLOSE l_get_max_seq_csr;

Line 4431: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4427: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4428:
4429: WHEN OTHERS THEN
4430: ROLLBACK TO g_Create_Unassigned_Section;
4431: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4432: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Create_Unassigned_Section because of EXCEPTION: '||sqlerrm);
4433: END IF;
4434:
4435: IF l_get_max_seq_csr%ISOPEN THEN

Line 4432: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Create_Unassigned_Section because of EXCEPTION: '||sqlerrm);

4428:
4429: WHEN OTHERS THEN
4430: ROLLBACK TO g_Create_Unassigned_Section;
4431: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4432: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Create_Unassigned_Section because of EXCEPTION: '||sqlerrm);
4433: END IF;
4434:
4435: IF l_get_max_seq_csr%ISOPEN THEN
4436: CLOSE l_get_max_seq_csr;