APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on FND_LOG

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

1997:
1998:
1999: BEGIN
2000:
2001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2002: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2003: END IF;
2004:
2005: -- Standard Start of API savepoint

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

1998:
1999: BEGIN
2000:
2001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2002: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2003: END IF;
2004:
2005: -- Standard Start of API savepoint
2006: SAVEPOINT g_accept_changes;

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

2029: ELSE
2030: l_user_access := 'NO_ACCESS';
2031: END IF;
2032:
2033: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2034: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2035: END IF;
2036:
2037: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN

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

2030: l_user_access := 'NO_ACCESS';
2031: END IF;
2032:
2033: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2034: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2035: END IF;
2036:
2037: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2038: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2034: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10200: After access test, l_user_access='||l_user_access);
2035: END IF;
2036:
2037: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2038: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2039: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10300: User has no privileges to accept changes');
2040: END IF;
2041:
2042: END IF;

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

2035: END IF;
2036:
2037: IF l_user_access NOT IN ('NON_STD_AUTHOR','SUPER_USER') THEN
2038: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2039: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10300: User has no privileges to accept changes');
2040: END IF;
2041:
2042: END IF;
2043:

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

2063: obj_titles,
2064: orut_ids;
2065: CLOSE accepted_terms_csr;
2066:
2067: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2068: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10400: After bulk collect of accepted_terms_csr');
2069: END IF;
2070:
2071: IF rut_ids.COUNT > 0 THEN

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

2064: orut_ids;
2065: CLOSE accepted_terms_csr;
2066:
2067: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2068: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10400: After bulk collect of accepted_terms_csr');
2069: END IF;
2070:
2071: IF rut_ids.COUNT > 0 THEN
2072: FOR i IN rut_ids.FIRST .. rut_ids.LAST

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

2076: END LOOP;
2077:
2078: END IF; --IF rut_ids.COUNT > 0 THEN
2079:
2080: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: After looping thru new_parents_csr');
2082: END IF;
2083:
2084: IF rut_ids.COUNT > 0 THEN

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

2077:
2078: END IF; --IF rut_ids.COUNT > 0 THEN
2079:
2080: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: After looping thru new_parents_csr');
2082: END IF;
2083:
2084: IF rut_ids.COUNT > 0 THEN
2085:

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

2082: END IF;
2083:
2084: IF rut_ids.COUNT > 0 THEN
2085:
2086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10600: Review records exist before looping');
2088: END IF;
2089:
2090: FOR i IN rut_ids.FIRST .. rut_ids.LAST

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

2083:
2084: IF rut_ids.COUNT > 0 THEN
2085:
2086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10600: Review records exist before looping');
2088: END IF;
2089:
2090: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2091: LOOP

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

2089:
2090: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2091: LOOP
2092:
2093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10700: Looping thru review records');
2095: END IF;
2096:
2097: l_ref_id := null;

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

2090: FOR i IN rut_ids.FIRST .. rut_ids.LAST
2091: LOOP
2092:
2093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10700: Looping thru review records');
2095: END IF;
2096:
2097: l_ref_id := null;
2098: IF (new_parents(i) is not null and pobj_types(i) = 'SECTION') THEN

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

2114: END IF;
2115:
2116: IF actions(i) = 'ADDED' THEN
2117:
2118: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10900: Action is ADDED');
2120: END IF;
2121:
2122: IF obj_types(i) = 'SECTION' THEN

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

2115:
2116: IF actions(i) = 'ADDED' THEN
2117:
2118: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10900: Action is ADDED');
2120: END IF;
2121:
2122: IF obj_types(i) = 'SECTION' THEN
2123:

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

2120: END IF;
2121:
2122: IF obj_types(i) = 'SECTION' THEN
2123:
2124: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2125: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: Object Type is SECTION');
2126: END IF;
2127:
2128: IF (to_char(obj_titles(i)) =

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

2121:
2122: IF obj_types(i) = 'SECTION' THEN
2123:
2124: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2125: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11000: Object Type is SECTION');
2126: END IF;
2127:
2128: IF (to_char(obj_titles(i)) =
2129: Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE)) THEN

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

2129: Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE)) THEN
2130:
2131: l_scn_code := G_UNASSIGNED_SECTION_CODE;
2132:
2133: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2134: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: Section is Unassigned');
2135: END IF;
2136: ELSE
2137: l_scn_code := null;

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

2130:
2131: l_scn_code := G_UNASSIGNED_SECTION_CODE;
2132:
2133: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2134: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11100: Section is Unassigned');
2135: END IF;
2136: ELSE
2137: l_scn_code := null;
2138: END IF;

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

2136: ELSE
2137: l_scn_code := null;
2138: END IF;
2139:
2140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11200: Before calling OKC_TERMS_SECTIONS_GRP.add_section');
2142: END IF;
2143:
2144: OKC_TERMS_SECTIONS_GRP.add_section(

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

2137: l_scn_code := null;
2138: END IF;
2139:
2140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11200: Before calling OKC_TERMS_SECTIONS_GRP.add_section');
2142: END IF;
2143:
2144: OKC_TERMS_SECTIONS_GRP.add_section(
2145: p_api_version => p_api_version,

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

2165:
2166: curr_obj_ids(rut_ids(i)) := l_scn_id;
2167: obj_ids(i) := l_scn_id;
2168:
2169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2172: END IF;
2173:

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

2166: curr_obj_ids(rut_ids(i)) := l_scn_id;
2167: obj_ids(i) := l_scn_id;
2168:
2169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2172: END IF;
2173:
2174: ELSIF obj_types(i) = 'ARTICLE' THEN

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

2167: obj_ids(i) := l_scn_id;
2168:
2169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11300: After calling OKC_TERMS_SECTIONS_GRP.add_section');
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2172: END IF;
2173:
2174: ELSIF obj_types(i) = 'ARTICLE' THEN
2175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11400: lscn_id ='||l_scn_id);
2172: END IF;
2173:
2174: ELSIF obj_types(i) = 'ARTICLE' THEN
2175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11500: Object Type is ARTICLE');
2177: END IF;
2178:
2179: obj_texts(i) :=

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

2172: END IF;
2173:
2174: ELSIF obj_types(i) = 'ARTICLE' THEN
2175: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2176: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11500: Object Type is ARTICLE');
2177: END IF;
2178:
2179: obj_texts(i) :=
2180: regexp_replace(regexp_replace(obj_texts(i),'','@]');

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

2178:
2179: obj_texts(i) :=
2180: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2181:
2182: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2183: 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');
2184: END IF;
2185:
2186: OKC_K_NON_STD_ART_GRP.create_non_std_article(

Line 2183: 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');

2179: obj_texts(i) :=
2180: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2181:
2182: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2183: 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');
2184: END IF;
2185:
2186: OKC_K_NON_STD_ART_GRP.create_non_std_article(
2187: p_api_version => p_api_version,

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

2215:
2216: obj_ids(i) := l_cat_id;
2217: art_vers(i) := l_article_version_id;
2218:
2219: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2220: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2222: END IF;
2223: END IF; --IF obj_types(i) = 'SECTION' THEN

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

2216: obj_ids(i) := l_cat_id;
2217: art_vers(i) := l_article_version_id;
2218:
2219: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2220: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2222: END IF;
2223: END IF; --IF obj_types(i) = 'SECTION' THEN
2224: ELSIF actions(i) = 'UPDATED' THEN

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

2217: art_vers(i) := l_article_version_id;
2218:
2219: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2220: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11700: Before calling OKC_K_NON_STD_ART_GRP.create_non_std_article');
2221: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11800: lcat_id='||l_cat_id);
2222: END IF;
2223: END IF; --IF obj_types(i) = 'SECTION' THEN
2224: ELSIF actions(i) = 'UPDATED' THEN
2225:

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

2222: END IF;
2223: END IF; --IF obj_types(i) = 'SECTION' THEN
2224: ELSIF actions(i) = 'UPDATED' THEN
2225:
2226: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2227: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11900: Action is UPDATED');
2228: END IF;
2229:
2230: IF obj_types(i) = 'SECTION' THEN

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

2223: END IF; --IF obj_types(i) = 'SECTION' THEN
2224: ELSIF actions(i) = 'UPDATED' THEN
2225:
2226: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2227: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'11900: Action is UPDATED');
2228: END IF;
2229:
2230: IF obj_types(i) = 'SECTION' THEN
2231:

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

2228: END IF;
2229:
2230: IF obj_types(i) = 'SECTION' THEN
2231:
2232: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12000: B4 call OKC_TERMS_SECTIONS_GRP.update_section');
2234: END IF;
2235:
2236: OKC_TERMS_SECTIONS_GRP.update_section(

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

2229:
2230: IF obj_types(i) = 'SECTION' THEN
2231:
2232: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12000: B4 call OKC_TERMS_SECTIONS_GRP.update_section');
2234: END IF;
2235:
2236: OKC_TERMS_SECTIONS_GRP.update_section(
2237: p_api_version => p_api_version,

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

2252: p_description => NULL,
2253: p_scn_code => FND_API.G_MISS_CHAR,
2254: p_object_version_number => NULL);
2255:
2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2257: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');
2258: END IF;
2259:
2260: ELSIF obj_types(i) = 'ARTICLE' THEN

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

2253: p_scn_code => FND_API.G_MISS_CHAR,
2254: p_object_version_number => NULL);
2255:
2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2257: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');
2258: END IF;
2259:
2260: ELSIF obj_types(i) = 'ARTICLE' THEN
2261: obj_texts(i) :=

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

2260: ELSIF obj_types(i) = 'ARTICLE' THEN
2261: obj_texts(i) :=
2262: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2263:
2264: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2265: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: Object Type is ARTICLE');
2266: END IF;
2267:
2268: IF non_stds(i) = 'Y' THEN

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

2261: obj_texts(i) :=
2262: regexp_replace(regexp_replace(obj_texts(i),'','@]');
2263:
2264: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2265: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12200: Object Type is ARTICLE');
2266: END IF;
2267:
2268: IF non_stds(i) = 'Y' THEN
2269:

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

2266: END IF;
2267:
2268: IF non_stds(i) = 'Y' THEN
2269:
2270: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2271: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12300: Non-Std article');
2272: END IF;
2273:
2274: l_article_type := null;

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

2267:
2268: IF non_stds(i) = 'Y' THEN
2269:
2270: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2271: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12300: Non-Std article');
2272: END IF;
2273:
2274: l_article_type := null;
2275:

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

2276: open get_clause_type_csr(rut_ids(i));
2277: fetch get_clause_type_csr into l_article_type;
2278: close get_clause_type_csr;
2279:
2280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: 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');
2282: END IF;
2283:
2284: OKC_K_NON_STD_ART_GRP.update_non_std_article(

Line 2281: 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');

2277: fetch get_clause_type_csr into l_article_type;
2278: close get_clause_type_csr;
2279:
2280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: 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');
2282: END IF;
2283:
2284: OKC_K_NON_STD_ART_GRP.update_non_std_article(
2285: p_api_version => p_api_version,

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

2311:
2312: obj_ids(i) := l_cat_id;
2313: art_vers(i) := l_article_version_id;
2314:
2315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12500: After OKC_K_NON_STD_ART_GRP.update_non_std_article');
2317: END IF;
2318:
2319: ELSE --IF non_stds(i) = 'Y' THEN

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

2312: obj_ids(i) := l_cat_id;
2313: art_vers(i) := l_article_version_id;
2314:
2315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2316: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12500: After OKC_K_NON_STD_ART_GRP.update_non_std_article');
2317: END IF;
2318:
2319: ELSE --IF non_stds(i) = 'Y' THEN
2320:

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

2317: END IF;
2318:
2319: ELSE --IF non_stds(i) = 'Y' THEN
2320:
2321: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12600: Std article');
2323: END IF;
2324:
2325: is_ibr := 'N';

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

2318:
2319: ELSE --IF non_stds(i) = 'Y' THEN
2320:
2321: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12600: Std article');
2323: END IF;
2324:
2325: is_ibr := 'N';
2326: is_lock_text := 'N';

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

2328: open is_article_ibr(rut_ids(i));
2329: fetch is_article_ibr into is_ibr;
2330: close is_article_ibr;
2331:
2332: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: is_ibr='||is_ibr);
2334: END IF;
2335:
2336: IF (is_ibr <> 'Y') THEN

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

2329: fetch is_article_ibr into is_ibr;
2330: close is_article_ibr;
2331:
2332: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12700: is_ibr='||is_ibr);
2334: END IF;
2335:
2336: IF (is_ibr <> 'Y') THEN
2337:

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

2338: open is_article_text_locked(rut_ids(i));
2339: fetch is_article_text_locked into is_lock_text;
2340: close is_article_text_locked;
2341:
2342: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2343: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12800: is_lock_text='||is_lock_text);
2344: END IF;
2345:
2346:

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

2339: fetch is_article_text_locked into is_lock_text;
2340: close is_article_text_locked;
2341:
2342: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2343: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12800: is_lock_text='||is_lock_text);
2344: END IF;
2345:
2346:
2347: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR

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

2346:
2347: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2348: is_lock_text <> 'Y') THEN
2349:
2350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2352: 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');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;

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

2347: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2348: is_lock_text <> 'Y') THEN
2349:
2350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2352: 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');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;
2355:

Line 2352: 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');

2348: is_lock_text <> 'Y') THEN
2349:
2350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2352: 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');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;
2355:
2356: UPDATE okc_k_articles_b

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

2349:
2350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2352: 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');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;
2355:
2356: UPDATE okc_k_articles_b
2357: SET scn_id = l_ref_id

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

2390:
2391: obj_ids(i) := l_cat_id;
2392: art_vers(i) := l_article_version_id;
2393:
2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');
2396: END IF;
2397: END IF; -- if l_user_access...
2398: END IF; -- if ibr_text <> 'Y'

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

2391: obj_ids(i) := l_cat_id;
2392: art_vers(i) := l_article_version_id;
2393:
2394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13200: After OKC_K_NON_STD_ART_GRP.create_non_std_article');
2396: END IF;
2397: END IF; -- if l_user_access...
2398: END IF; -- if ibr_text <> 'Y'
2399: END IF; -- IF non_stds(i) = 'Y' THEN

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

2400: END IF;
2401:
2402: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2403:
2404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2407: END IF;
2408:

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

2401:
2402: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2403:
2404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2407: END IF;
2408:
2409: IF obj_types(i) = 'SECTION' THEN

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

2402: ELSIF (actions(i) = 'DELETED' OR actions(i) = 'MERGED') THEN
2403:
2404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13300: Action='||actions(i));
2406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13400: object Type='||obj_types(i));
2407: END IF;
2408:
2409: IF obj_types(i) = 'SECTION' THEN
2410: IF p_mode = 'AMEND' THEN

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

2407: END IF;
2408:
2409: IF obj_types(i) = 'SECTION' THEN
2410: IF p_mode = 'AMEND' THEN
2411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2413: END IF;
2414:
2415: UPDATE okc_sections_b scn

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

2408:
2409: IF obj_types(i) = 'SECTION' THEN
2410: IF p_mode = 'AMEND' THEN
2411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13500: p_mode='||p_mode);
2413: END IF;
2414:
2415: UPDATE okc_sections_b scn
2416: SET scn.last_updated_by = fnd_global.user_id,

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

2425: scn.last_amendment_date = sysdate
2426: WHERE scn.id = obj_ids(i);
2427: ELSE
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,'13500: p_mode='||p_mode);
2431: END IF;
2432:
2433: DELETE FROM okc_sections_b

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

2426: WHERE scn.id = obj_ids(i);
2427: ELSE
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,'13500: p_mode='||p_mode);
2431: END IF;
2432:
2433: DELETE FROM okc_sections_b
2434: WHERE id = obj_ids(i);

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

2435: END IF; --IF p_mode = 'AMEND' THEN
2436:
2437: ELSIF obj_types(i) = 'ARTICLE' THEN
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,'13800: Clause Title=' || obj_titles(i));
2441: END IF;
2442:
2443: is_mandatory_text := 'N';

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

2436:
2437: ELSIF obj_types(i) = 'ARTICLE' THEN
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,'13800: Clause Title=' || obj_titles(i));
2441: END IF;
2442:
2443: is_mandatory_text := 'N';
2444:

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

2445: open is_article_mandatory(rut_ids(i));
2446: fetch is_article_mandatory into is_mandatory_text;
2447: close is_article_mandatory;
2448:
2449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2451: END IF;
2452:
2453: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then

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

2446: fetch is_article_mandatory into is_mandatory_text;
2447: close is_article_mandatory;
2448:
2449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2451: END IF;
2452:
2453: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13900: is_article_mandatory='|| is_mandatory_text);
2451: END IF;
2452:
2453: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2456: END IF;
2457: IF p_mode = 'AMEND' THEN
2458:

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

2451: END IF;
2452:
2453: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2456: END IF;
2457: IF p_mode = 'AMEND' THEN
2458:
2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2456: END IF;
2457: IF p_mode = 'AMEND' THEN
2458:
2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2461: END IF;
2462:
2463: UPDATE okc_k_articles_b kart

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

2456: END IF;
2457: IF p_mode = 'AMEND' THEN
2458:
2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2461: END IF;
2462:
2463: UPDATE okc_k_articles_b kart
2464: SET kart.last_updated_by = fnd_global.user_id,

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

2473: kart.last_amendment_date = sysdate
2474: WHERE kart.id = obj_ids(i);
2475: ELSE
2476:
2477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2479: END IF;
2480:
2481: DELETE FROM okc_k_articles_b

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

2474: WHERE kart.id = obj_ids(i);
2475: ELSE
2476:
2477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2479: END IF;
2480:
2481: DELETE FROM okc_k_articles_b
2482: WHERE id = obj_ids(i);

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

2481: DELETE FROM okc_k_articles_b
2482: WHERE id = obj_ids(i);
2483: END IF;
2484:
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2487: END IF;
2488: END IF; --IF ((l_user_access = 'SUPER_USER' )
2489: END IF; --IF obj_types(i) = 'SECTION' THEN

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

2482: WHERE id = obj_ids(i);
2483: END IF;
2484:
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2487: END IF;
2488: END IF; --IF ((l_user_access = 'SUPER_USER' )
2489: END IF; --IF obj_types(i) = 'SECTION' THEN
2490: --ELSE

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

2491: END IF; --IF actions(i) = 'ADDED'
2492: END LOOP;
2493: END IF; --IF rut_ids.COUNT > 0 THEN
2494:
2495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2497: END IF;
2498:
2499: FORALL i IN rut_ids.FIRST..rut_ids.LAST

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

2492: END LOOP;
2493: END IF; --IF rut_ids.COUNT > 0 THEN
2494:
2495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14400: Before Bulk update of okc_sections_b');
2497: END IF;
2498:
2499: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2500: UPDATE okc_sections_b

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

2502: section_sequence = disp_seqs(i)
2503: WHERE id = obj_ids(i)
2504: AND obj_types(i) = 'SECTION';
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,'14500: Before Bulk update of okc_k_articles_b');
2508: END IF;
2509:
2510: FORALL i IN rut_ids.FIRST..rut_ids.LAST

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

2503: WHERE id = obj_ids(i)
2504: AND obj_types(i) = 'SECTION';
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,'14500: Before Bulk update of okc_k_articles_b');
2508: END IF;
2509:
2510: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2511: UPDATE okc_k_articles_b

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

2513: display_sequence = disp_seqs(i)
2514: WHERE id = obj_ids(i)
2515: AND obj_types(i) = 'ARTICLE';
2516:
2517: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2518: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2519: END IF;
2520:
2521: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

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

2514: WHERE id = obj_ids(i)
2515: AND obj_types(i) = 'ARTICLE';
2516:
2517: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2518: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14600: Before delete on Review Tables');
2519: END IF;
2520:
2521: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2522: p_api_version => l_api_version,

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

2543: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2544: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2545: document_id = p_document_id);
2546:
2547: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');
2549: END IF;
2550:
2551: open current_num_scheme;

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

2544: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2545: document_id = p_document_id);
2546:
2547: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: After delete on Review Tables');
2549: END IF;
2550:
2551: open current_num_scheme;
2552: fetch current_num_scheme into l_doc_num_scheme;

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

2551: open current_num_scheme;
2552: fetch current_num_scheme into l_doc_num_scheme;
2553: close current_num_scheme;
2554:
2555: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2557: END IF;
2558:
2559: IF (l_doc_num_scheme is NOT NULL) THEN

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

2552: fetch current_num_scheme into l_doc_num_scheme;
2553: close current_num_scheme;
2554:
2555: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2557: END IF;
2558:
2559: IF (l_doc_num_scheme is NOT NULL) THEN
2560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14800: l_doc_num_scheme=' || l_doc_num_scheme);
2557: END IF;
2558:
2559: IF (l_doc_num_scheme is NOT NULL) THEN
2560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Before invoking apply_numbering_scheme');
2562: END IF;
2563:
2564: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(

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

2557: END IF;
2558:
2559: IF (l_doc_num_scheme is NOT NULL) THEN
2560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14900: Before invoking apply_numbering_scheme');
2562: END IF;
2563:
2564: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(
2565: p_api_version => p_api_version,

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

2572: p_doc_type => p_document_type,
2573: p_doc_id => p_document_id,
2574: p_num_scheme_id => l_doc_num_scheme);
2575:
2576: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2578: END IF;
2579: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2580:

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

2573: p_doc_id => p_document_id,
2574: p_num_scheme_id => l_doc_num_scheme);
2575:
2576: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2578: END IF;
2579: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2580:
2581: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2577: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15000: After invoking apply_numbering_scheme');
2578: END IF;
2579: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2580:
2581: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2582: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2583: END IF;
2584:
2585: -- Standard check of p_commit

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

2578: END IF;
2579: END IF; --IF (l_doc_num_scheme is NOT NULL) THEN
2580:
2581: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2582: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2583: END IF;
2584:
2585: -- Standard check of p_commit
2586: IF FND_API.To_Boolean( p_commit ) THEN

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

2588: END IF;
2589:
2590: EXCEPTION
2591: WHEN FND_API.G_EXC_ERROR THEN
2592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2593: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2594: END IF;
2595: ROLLBACK TO g_accept_changes;
2596: x_return_status := G_RET_STS_ERROR ;

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

2589:
2590: EXCEPTION
2591: WHEN FND_API.G_EXC_ERROR THEN
2592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2593: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2594: END IF;
2595: ROLLBACK TO g_accept_changes;
2596: x_return_status := G_RET_STS_ERROR ;
2597: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2596: x_return_status := G_RET_STS_ERROR ;
2597: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2598:
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2602: END IF;
2603: ROLLBACK TO g_accept_Changes;
2604: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2597: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2598:
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2602: END IF;
2603: ROLLBACK TO g_accept_Changes;
2604: x_return_status := G_RET_STS_UNEXP_ERROR ;
2605: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2604: x_return_status := G_RET_STS_UNEXP_ERROR ;
2605: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2606:
2607: WHEN OTHERS THEN
2608: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);
2610: END IF;
2611:
2612: ROLLBACK TO g_accept_changes;

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

2605: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2606:
2607: WHEN OTHERS THEN
2608: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15400: Leaving accept_changes because of EXCEPTION: '||sqlerrm);
2610: END IF;
2611:
2612: ROLLBACK TO g_accept_changes;
2613: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2633: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Changes';
2634: l_api_version CONSTANT NUMBER := 1;
2635:
2636: BEGIN
2637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2639: END IF;
2640:
2641: -- Standard Start of API savepoint

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

2634: l_api_version CONSTANT NUMBER := 1;
2635:
2636: BEGIN
2637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2639: END IF;
2640:
2641: -- Standard Start of API savepoint
2642: SAVEPOINT g_reject_changes;

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

2662: p_document_type => p_document_type,
2663: p_document_id => p_document_id
2664: );
2665:
2666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2668: END IF;
2669: -- Standard check of p_commit
2670: IF FND_API.To_Boolean( p_commit ) THEN

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

2663: p_document_id => p_document_id
2664: );
2665:
2666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2668: END IF;
2669: -- Standard check of p_commit
2670: IF FND_API.To_Boolean( p_commit ) THEN
2671: COMMIT WORK;

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

2672: END IF;
2673:
2674: EXCEPTION
2675: WHEN FND_API.G_EXC_ERROR THEN
2676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2678: END IF;
2679: ROLLBACK TO g_reject_changes;
2680: x_return_status := G_RET_STS_ERROR ;

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

2673:
2674: EXCEPTION
2675: WHEN FND_API.G_EXC_ERROR THEN
2676: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2677: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2678: END IF;
2679: ROLLBACK TO g_reject_changes;
2680: x_return_status := G_RET_STS_ERROR ;
2681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2680: x_return_status := G_RET_STS_ERROR ;
2681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2682:
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2685: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2686: END IF;
2687: ROLLBACK TO g_reject_Changes;
2688: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2682:
2683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2684: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2685: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2686: END IF;
2687: ROLLBACK TO g_reject_Changes;
2688: x_return_status := G_RET_STS_UNEXP_ERROR ;
2689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

2688: x_return_status := G_RET_STS_UNEXP_ERROR ;
2689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2690:
2691: WHEN OTHERS THEN
2692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
2694: END IF;
2695:
2696: ROLLBACK TO g_reject_changes;

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

2689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2690:
2691: WHEN OTHERS THEN
2692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
2694: END IF;
2695:
2696: ROLLBACK TO g_reject_changes;
2697: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2719: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Uploaded_Terms';
2720: l_api_version CONSTANT NUMBER := 1;
2721:
2722: BEGIN
2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2725: END IF;
2726:
2727: -- Standard Start of API savepoint

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

2720: l_api_version CONSTANT NUMBER := 1;
2721:
2722: BEGIN
2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2725: END IF;
2726:
2727: -- Standard Start of API savepoint
2728: SAVEPOINT g_delete_uploaded_terms;

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

2744: FROM okc_REVIEW_UPLD_TERMS
2745: WHERE document_id = p_document_id
2746: AND document_type = p_document_type);
2747:
2748: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2749: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2750: END IF;
2751:
2752: DELETE

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

2745: WHERE document_id = p_document_id
2746: AND document_type = p_document_type);
2747:
2748: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2749: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2750: END IF;
2751:
2752: DELETE
2753: FROM OKC_REVIEW_VAR_VALUES v

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

2756: FROM okc_REVIEW_UPLD_TERMS
2757: WHERE document_id = p_document_id
2758: AND document_type = p_document_type);
2759:
2760: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2761: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');
2762: END IF;
2763:
2764: DELETE

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

2757: WHERE document_id = p_document_id
2758: AND document_type = p_document_type);
2759:
2760: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2761: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: After delete review variables');
2762: END IF;
2763:
2764: DELETE
2765: FROM OKC_REVIEW_UPLD_TERMS

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

2770: FROM OKC_REVIEW_UPLD_HEADER
2771: WHERE document_id = p_document_id
2772: AND document_type = p_document_type;
2773:
2774: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2776: END IF;
2777:
2778: -- Standard check of p_commit

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

2771: WHERE document_id = p_document_id
2772: AND document_type = p_document_type;
2773:
2774: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2776: END IF;
2777:
2778: -- Standard check of p_commit
2779: IF FND_API.To_Boolean( p_commit ) THEN

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 Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_delete_uploaded_terms;
2789: x_return_status := G_RET_STS_ERROR ;

Line 2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: 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 Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_delete_uploaded_terms;
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 Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_delete_uploaded_terms;
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 Delete_Uploaded_terms: 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 Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_delete_uploaded_terms;
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 delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);
2803: END IF;
2804:
2805: ROLLBACK TO g_delete_uploaded_terms;

Line 2802: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving delete_uploaded_Terms 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 delete_uploaded_Terms because of EXCEPTION: '||sqlerrm);
2803: END IF;
2804:
2805: ROLLBACK TO g_delete_uploaded_terms;
2806: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3607:
3608: open clauses_without_parent_exist;
3609: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3610: if (clauses_without_parent_exist%FOUND) THEN
3611: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3612: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');
3613: END IF;
3614: open unassigned_section_exists;
3615: fetch unassigned_section_exists into l_unassigned_scn_id;

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

3608: open clauses_without_parent_exist;
3609: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3610: if (clauses_without_parent_exist%FOUND) THEN
3611: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3612: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'120: Creating Unassgined Section ');
3613: END IF;
3614: open unassigned_section_exists;
3615: fetch unassigned_section_exists into l_unassigned_scn_id;
3616: if(unassigned_section_exists%NOTFOUND)THEN

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

3623: x_return_status => x_return_status,
3624: x_msg_count => x_msg_count,
3625: x_msg_data => x_msg_data
3626: );
3627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3629: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3630: END IF;
3631:

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

3624: x_msg_count => x_msg_count,
3625: x_msg_data => x_msg_data
3626: );
3627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3629: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3630: END IF;
3631:
3632: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

3625: x_msg_data => x_msg_data
3626: );
3627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: l_unassigned_scn_id : '||l_unassigned_scn_id);
3629: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3630: END IF;
3631:
3632: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

3849: where revvar.review_upld_terms_id = rev.review_upld_terms_id
3850: and rev.document_type = p_document_type
3851: and rev.document_id = p_document_id);
3852:
3853: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3854: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
3855: for upd_csr in get_updated_articles_csr loop
3856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
3857: end loop;

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

3850: and rev.document_type = p_document_type
3851: and rev.document_id = p_document_id);
3852:
3853: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3854: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
3855: for upd_csr in get_updated_articles_csr loop
3856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
3857: end loop;
3858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');

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

3852:
3853: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3854: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
3855: for upd_csr in get_updated_articles_csr loop
3856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
3857: end loop;
3858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');
3859: END IF;
3860:

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

3854: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5000: Begin: Logging the ones that were determined as UPDATED');
3855: for upd_csr in get_updated_articles_csr loop
3856: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5010: for review_upld_terms_id=' || upd_csr.review_upld_terms_id );
3857: end loop;
3858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: End: Logging the ones that were determined as UPDATED');
3859: END IF;
3860:
3861:
3862:

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

3859: END IF;
3860:
3861:
3862:
3863: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3864: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
3865: END IF;
3866: l_clause_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_CLAUSE');
3867: l_section_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_SECTION');

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

3860:
3861:
3862:
3863: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3864: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
3865: END IF;
3866: l_clause_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_CLAUSE');
3867: l_section_title := OKC_TERMS_UTIL_PVT.Get_Message('OKC','OKC_TERMS_DUMMY_SECTION');
3868: l_clause_counter:= 1;

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

4065: END IF;
4066:
4067: EXCEPTION
4068: WHEN FND_API.G_EXC_ERROR THEN
4069: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4071: END IF;
4072: ROLLBACK TO g_reject_changes;
4073: x_return_status := G_RET_STS_ERROR ;

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

4066:
4067: EXCEPTION
4068: WHEN FND_API.G_EXC_ERROR THEN
4069: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4071: END IF;
4072: ROLLBACK TO g_reject_changes;
4073: x_return_status := G_RET_STS_ERROR ;
4074: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

4073: x_return_status := G_RET_STS_ERROR ;
4074: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4075:
4076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4077: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4078: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4079: END IF;
4080: ROLLBACK TO g_reject_Changes;
4081: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4074: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4075:
4076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4077: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4078: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4079: END IF;
4080: ROLLBACK TO g_reject_Changes;
4081: x_return_status := G_RET_STS_UNEXP_ERROR ;
4082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

4081: x_return_status := G_RET_STS_UNEXP_ERROR ;
4082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4083:
4084: WHEN OTHERS THEN
4085: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
4087: END IF;
4088:
4089: ROLLBACK TO g_reject_changes;

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

4082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4083:
4084: WHEN OTHERS THEN
4085: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving reject_changes because of EXCEPTION: '||sqlerrm);
4087: END IF;
4088:
4089: ROLLBACK TO g_reject_changes;
4090: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4126: AND DOCUMENT_ID = p_document_id
4127: AND PARENT_ID IS NULL or new_parent_id = p_document_id;
4128:
4129: BEGIN
4130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4132: END IF;
4133: -- Standard Start of API savepoint
4134: SAVEPOINT g_Create_Unassigned_Section;

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

4127: AND PARENT_ID IS NULL or new_parent_id = p_document_id;
4128:
4129: BEGIN
4130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4132: END IF;
4133: -- Standard Start of API savepoint
4134: SAVEPOINT g_Create_Unassigned_Section;
4135: -- Standard call to check for call compatibility.

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

4148: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
4149: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
4150: -- Set x_scn_id to id returned by simpel API.
4151: --------------------------------------------
4152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');
4154: END IF;
4155: --------------------------------------------
4156: l_meaning := Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE);

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

4149: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
4150: -- Set x_scn_id to id returned by simpel API.
4151: --------------------------------------------
4152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');
4154: END IF;
4155: --------------------------------------------
4156: l_meaning := Okc_Util.Decode_Lookup('OKC_ARTICLE_SECTION',G_UNASSIGNED_SECTION_CODE);
4157:

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

4234: COMMIT WORK;
4235: END IF;
4236: -- Standard call to get message count and if count is 1, get message info.
4237: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4240: END IF;
4241: EXCEPTION
4242: WHEN FND_API.G_EXC_ERROR THEN

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

4235: END IF;
4236: -- Standard call to get message count and if count is 1, get message info.
4237: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4240: END IF;
4241: EXCEPTION
4242: WHEN FND_API.G_EXC_ERROR THEN
4243: ROLLBACK TO g_Create_Unassigned_Section;

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

4240: END IF;
4241: EXCEPTION
4242: WHEN FND_API.G_EXC_ERROR THEN
4243: ROLLBACK TO g_Create_Unassigned_Section;
4244: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4245: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');
4246: END IF;
4247:
4248: IF l_get_max_seq_csr%ISOPEN THEN

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

4241: EXCEPTION
4242: WHEN FND_API.G_EXC_ERROR THEN
4243: ROLLBACK TO g_Create_Unassigned_Section;
4244: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4245: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');
4246: END IF;
4247:
4248: IF l_get_max_seq_csr%ISOPEN THEN
4249: CLOSE l_get_max_seq_csr;

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

4253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4254:
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: ROLLBACK TO g_Create_Unassigned_Section;
4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4258: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4259: END IF;
4260:
4261: IF l_get_max_seq_csr%ISOPEN THEN

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

4254:
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: ROLLBACK TO g_Create_Unassigned_Section;
4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4258: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4259: END IF;
4260:
4261: IF l_get_max_seq_csr%ISOPEN THEN
4262: CLOSE l_get_max_seq_csr;

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

4266: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4267:
4268: WHEN OTHERS THEN
4269: ROLLBACK TO g_Create_Unassigned_Section;
4270: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4271: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Create_Unassigned_Section because of EXCEPTION: '||sqlerrm);
4272: END IF;
4273:
4274: IF l_get_max_seq_csr%ISOPEN THEN

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

4267:
4268: WHEN OTHERS THEN
4269: ROLLBACK TO g_Create_Unassigned_Section;
4270: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4271: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Create_Unassigned_Section because of EXCEPTION: '||sqlerrm);
4272: END IF;
4273:
4274: IF l_get_max_seq_csr%ISOPEN THEN
4275: CLOSE l_get_max_seq_csr;