138: FND_LOG.STRING(G_PROC_LEVEL,
139: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
140: END IF;
141:
142: -- Standard Start of API savepoint
143: SAVEPOINT g_create_article_GRP;
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: -- Standard Start of API savepoint
143: SAVEPOINT g_create_article_GRP;
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: -- Initialize message list if p_init_msg_list is set to TRUE.
339: END IF;
340: END LOOP;
341: END IF;
342:
343: -- Standard check of p_commit
344: IF FND_API.To_Boolean( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347:
344: IF FND_API.To_Boolean( p_commit ) THEN
345: COMMIT WORK;
346: END IF;
347:
348: -- Standard call to get message count and if count is 1, get message info.
349: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
350:
351: /*IF (l_debug = 'Y') THEN
352: okc_debug.log('200: Leaving create_article', 2);
495: FND_LOG.STRING(G_PROC_LEVEL,
496: G_PKG_NAME, '100: p_commit : '||p_commit );
497: END IF;
498:
499: -- Standard Start of API savepoint
500: SAVEPOINT g_update_article_variable_GRP;
501: -- Standard call to check for call compatibility.
502: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: -- Standard Start of API savepoint
500: SAVEPOINT g_update_article_variable_GRP;
501: -- Standard call to check for call compatibility.
502: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505: -- Initialize message list if p_init_msg_list is set to TRUE.
608: END IF;
609: END LOOP;
610: END IF;
611:
612: -- Standard check of p_commit
613: IF FND_API.To_Boolean( p_commit ) THEN
614: COMMIT WORK;
615: END IF;
616:
613: IF FND_API.To_Boolean( p_commit ) THEN
614: COMMIT WORK;
615: END IF;
616:
617: -- Standard call to get message count and if count is 1, get message info.
618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
619:
620: /*IF (l_debug = 'Y') THEN
621: okc_debug.log('200: Leaving update_article_variable', 2);
745: FND_LOG.STRING(G_PROC_LEVEL,
746: G_PKG_NAME, '100: p_commit : '||p_commit );
747: END IF;
748:
749: -- Standard Start of API savepoint
750: SAVEPOINT g_update_structure_GRP;
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: -- Standard Start of API savepoint
750: SAVEPOINT g_update_structure_GRP;
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: END IF;
755:
855: END IF;
856: END LOOP;
857:
858: END IF;
859: -- Standard check of p_commit
860: IF FND_API.To_Boolean( p_commit ) THEN
861: COMMIT WORK;
862: END IF;
863:
860: IF FND_API.To_Boolean( p_commit ) THEN
861: COMMIT WORK;
862: END IF;
863:
864: -- Standard call to get message count and if count is 1, get message info.
865: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
866:
867: /*IF (l_debug = 'Y') THEN
868: okc_debug.log('200: Leaving update_structure', 2);
1185: FND_LOG.STRING(G_PROC_LEVEL,
1186: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1187: END IF;
1188:
1189: -- Standard Start of API savepoint
1190: SAVEPOINT g_sync_doc_with_expert_GRP;
1191: -- Standard call to check for call compatibility.
1192: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188:
1189: -- Standard Start of API savepoint
1190: SAVEPOINT g_sync_doc_with_expert_GRP;
1191: -- Standard call to check for call compatibility.
1192: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: -- Initialize message list if p_init_msg_list is set to TRUE.
1760:
1761: -- set the OUT parameter to indicate the number of provisional articles dropped
1762: x_articles_dropped := l_articles_dropped;
1763:
1764: -- Standard check of p_commit
1765: IF FND_API.To_Boolean( p_commit ) THEN
1766: COMMIT WORK;
1767: END IF;
1768:
1765: IF FND_API.To_Boolean( p_commit ) THEN
1766: COMMIT WORK;
1767: END IF;
1768:
1769: -- Standard call to get message count and if count is 1, get message info.
1770: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1771:
1772: /*IF (l_debug = 'Y') THEN
1773: okc_debug.log('200: Leaving sync_doc_with_expert', 2);
2031: FND_LOG.STRING(G_PROC_LEVEL,
2032: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2033: END IF;
2034:
2035: -- Standard Start of API savepoint
2036: SAVEPOINT g_refresh_articles_GRP;
2037: -- Standard call to check for call compatibility.
2038:
2039: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2033: END IF;
2034:
2035: -- Standard Start of API savepoint
2036: SAVEPOINT g_refresh_articles_GRP;
2037: -- Standard call to check for call compatibility.
2038:
2039: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: END IF;
2100: END IF;
2101:
2102: END LOOP;
2103:
2104: -- Standard check of p_commit
2105: IF FND_API.To_Boolean( p_commit ) THEN
2106: COMMIT WORK;
2107: END IF;
2108:
2105: IF FND_API.To_Boolean( p_commit ) THEN
2106: COMMIT WORK;
2107: END IF;
2108:
2109: -- Standard call to get message count and if count is 1, get message info.
2110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2111:
2112: /*IF (l_debug = 'Y') THEN
2113: okc_debug.log('200: Leaving refresh_articles', 2);
2317: FND_LOG.STRING(G_PROC_LEVEL,
2318: G_PKG_NAME, '100: p_to_object_id : '||p_to_object_id );
2319: END IF;
2320:
2321: -- Standard Start of API savepoint
2322: SAVEPOINT g_organize_layout_GRP;
2323: -- Standard call to check for call compatibility.
2324:
2325: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2319: END IF;
2320:
2321: -- Standard Start of API savepoint
2322: SAVEPOINT g_organize_layout_GRP;
2323: -- Standard call to check for call compatibility.
2324:
2325: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2327: END IF;
2704: END IF;
2705: END LOOP;
2706: END IF;
2707:
2708: -- Standard check of p_commit
2709: IF FND_API.To_Boolean( p_commit ) THEN
2710: COMMIT WORK;
2711: END IF;
2712:
2709: IF FND_API.To_Boolean( p_commit ) THEN
2710: COMMIT WORK;
2711: END IF;
2712:
2713: -- Standard call to get message count and if count is 1, get message info.
2714: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2715:
2716: /*IF (l_debug = 'Y') THEN
2717: okc_debug.log('1000: Leaving organize_layout', 2);
2928: FND_LOG.STRING(G_PROC_LEVEL,
2929: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2930: END IF;
2931:
2932: -- Standard Start of API savepoint
2933: SAVEPOINT g_merge_review_clauses_GRP;
2934: -- Standard call to check for call compatibility.
2935:
2936: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2930: END IF;
2931:
2932: -- Standard Start of API savepoint
2933: SAVEPOINT g_merge_review_clauses_GRP;
2934: -- Standard call to check for call compatibility.
2935:
2936: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2938: END IF;
3185: END IF;
3186:
3187: END IF; -- IF p_merge_review_tbl.COUNT>0
3188:
3189: -- Standard check of p_commit
3190: IF FND_API.To_Boolean( p_commit ) THEN
3191: COMMIT WORK;
3192: END IF;
3193:
3190: IF FND_API.To_Boolean( p_commit ) THEN
3191: COMMIT WORK;
3192: END IF;
3193:
3194: -- Standard call to get message count and if count is 1, get message info.
3195: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3196:
3197:
3198: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3317: FND_LOG.STRING(G_PROC_LEVEL,
3318: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
3319: END IF;
3320:
3321: -- Standard Start of API savepoint
3322: SAVEPOINT g_sort_clauses_GRP;
3323: -- Standard call to check for call compatibility.
3324:
3325: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3319: END IF;
3320:
3321: -- Standard Start of API savepoint
3322: SAVEPOINT g_sort_clauses_GRP;
3323: -- Standard call to check for call compatibility.
3324:
3325: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3327: END IF;