211: CLOSE target_response_cur;
212:
213:
214: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables. ');
216: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:source busdoc id: '||to_char(p_source_doc_id));
217: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc id: '||to_char(p_target_doc_id));
218: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc type: '||p_target_doc_type);
219: END IF;
218: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc type: '||p_target_doc_type);
219: END IF;
220:
221:
222: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
223: p_api_version => 1,
224: p_init_msg_list => FND_API.G_FALSE,
225: p_source_doc_id => p_source_doc_id,
226: p_source_doc_type => p_source_doc_type,
241: x_msg_count => x_msg_count,
242: x_return_status => x_return_status );
243:
244: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
245: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
247: END IF;
248:
249: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
242: x_return_status => x_return_status );
243:
244: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
245: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
247: END IF;
248:
249: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
257:
258: IF (l_copy_deliverables ='Y' AND p_copy_for_amendment='Y') THEN
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
261: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment.');
262: END IF;
263:
264:
265: OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment (
261: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment.');
262: END IF;
263:
264:
265: OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment (
266: p_api_version => 1,
267: p_init_msg_list => FND_API.G_FALSE,
268: p_source_doc_id => p_source_doc_id,
269: p_source_doc_type => p_source_doc_type,
277: p_copy_del_attachments_yn => p_copy_del_attachments_yn,
278: p_target_contractual_doctype => p_target_contractual_doctype);
279:
280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment. ');
282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment x_return_status : '||x_return_status);
283: END IF;
284:
285: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
278: p_target_contractual_doctype => p_target_contractual_doctype);
279:
280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment. ');
282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_del_for_amendment x_return_status : '||x_return_status);
283: END IF;
284:
285: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
665:
666: /* Call Deliverable API to copy Deliverables */
667:
668: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables. ');
670: END IF;
671:
672:
673: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
669: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables. ');
670: END IF;
671:
672:
673: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
674: p_api_version => 1,
675: p_init_msg_list => FND_API.G_FALSE,
676: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
677: p_source_doc_id => p_template_id,
687: x_msg_count => x_msg_count,
688: x_return_status => x_return_status );
689:
690: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
692: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
693: END IF;
694:
695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
688: x_return_status => x_return_status );
689:
690: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
692: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
693: END IF;
694:
695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
934: FETCH target_response_cur INTO l_target_response_doctype;
935: CLOSE target_response_cur;
936:
937: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
938: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
939: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:l_target_response_doctype: '||l_target_response_doctype);
940: END IF;
941:
942:
939: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:l_target_response_doctype: '||l_target_response_doctype);
940: END IF;
941:
942:
943: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables (
944: p_api_version => 1,
945: p_init_msg_list => FND_API.G_FALSE,
946: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
947: p_source_doc_id => p_template_id,
960: x_msg_count => x_msg_count,
961: x_return_status => x_return_status );
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
965: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
966: END IF;
967:
968: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
961: x_return_status => x_return_status );
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
965: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
966: END IF;
967:
968: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1213:
1214: /* Call Deliverable API to copy Deliverables */
1215:
1216: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1217: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision. ');
1218: END IF;
1219: -- bug#4075168 New API for Template Revision replacing copy_deliverables
1220:
1221: OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision(
1217: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision. ');
1218: END IF;
1219: -- bug#4075168 New API for Template Revision replacing copy_deliverables
1220:
1221: OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision(
1222: p_api_version => 1,
1223: p_init_msg_list => FND_API.G_FALSE,
1224: p_source_doc_type => OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,
1225: p_source_doc_id => p_template_id,
1232: x_return_status => x_return_status );
1233:
1234:
1235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');
1237: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision x_return_status : '||x_return_status);
1238: END IF;
1239:
1240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1233:
1234:
1235: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision');
1237: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision x_return_status : '||x_return_status);
1238: END IF;
1239:
1240: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1551:
1552: /* Call Deliverable API to copy Deliverables */
1553:
1554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:Entering OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables.');
1556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:source busdoc id: '||to_char(p_source_doc_id));
1557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc id: '||to_char(p_target_doc_id));
1558: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc type: '||p_target_doc_type);
1559: END IF;
1558: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000:target busdoc type: '||p_target_doc_type);
1559: END IF;
1560:
1561:
1562: OKC_DELIVERABLE_PROCESS_PVT.copy_response_deliverables (
1563: p_api_version => 1,
1564: p_init_msg_list => FND_API.G_FALSE,
1565: p_source_doc_id => p_source_doc_id,
1566: p_source_doc_type => p_source_doc_type,
1571: x_msg_count => x_msg_count,
1572: x_return_status => x_return_status );
1573:
1574: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1575: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
1576: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
1577: END IF;
1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1572: x_return_status => x_return_status );
1573:
1574: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1575: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100:Finished OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables ');
1576: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables x_return_status : '||x_return_status);
1577: END IF;
1578:
1579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;