89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
99: END IF;
92:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
99: END IF;
100:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
99: END IF;
100:
101: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');
96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');
98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
99: END IF;
100:
101: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
102:
99: END IF;
100:
101: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
102:
103: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
104: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
105: END IF;
106:
107:
100:
101: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
102:
103: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
104: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
105: END IF;
106:
107:
108: JTF_NOTES_PUB.Create_Note_Context(
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
130: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: lx_jtf_note_context_id :' || lx_jtf_note_context_id, 1, 'N');
131: END IF;
132:
133: END LOOP;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
130: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: lx_jtf_note_context_id :' || lx_jtf_note_context_id, 1, 'N');
131: END IF;
132:
133: END LOOP;
134:
132:
133: END LOOP;
134:
135: -- End of API body.
136: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
137: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: End Copy_Notes()', 1, 'Y');
138: END IF;
139:
140: -- Standard check of p_commit.
133: END LOOP;
134:
135: -- End of API body.
136: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
137: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: End Copy_Notes()', 1, 'Y');
138: END IF;
139:
140: -- Standard check of p_commit.
141: IF FND_API.To_Boolean(p_commit) THEN
266:
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
276: END IF;
269:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
276: END IF;
277:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
276: END IF;
277:
278: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');
273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');
275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
276: END IF;
277:
278: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
279:
276: END IF;
277:
278: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
279:
280: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
281: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
282: END IF;
283:
284:
277:
278: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
279:
280: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
281: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
282: END IF;
283:
284:
285: JTF_NOTES_PUB.Create_Note_Context(
302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
307: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: lx_jtf_note_context_id: ' || lx_jtf_note_context_id, 1, 'N');
308: END IF;
309:
310: END LOOP;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
307: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: lx_jtf_note_context_id: ' || lx_jtf_note_context_id, 1, 'N');
308: END IF;
309:
310: END LOOP;
311:
309:
310: END LOOP;
311:
312: -- End of API body.
313: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
314: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: End Copy_Opp_Notes_To_Qte()', 1, 'Y');
315: END IF;
316:
317: -- Standard check of p_commit.
310: END LOOP;
311:
312: -- End of API body.
313: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
314: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: End Copy_Opp_Notes_To_Qte()', 1, 'Y');
315: END IF;
316:
317: -- Standard check of p_commit.
318: IF FND_API.To_Boolean(p_commit) THEN
455:
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
465: END IF;
458:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
465: END IF;
466:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
465: END IF;
466:
467: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');
462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');
463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');
464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');
465: END IF;
466:
467: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
468:
465: END IF;
466:
467: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
468:
469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
470: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
471: END IF;
472:
473: l_notes_detail := NULL;
466:
467: FOR l_note_rec IN l_notes_csr(p_old_object_id, p_old_object_type_code) LOOP
468:
469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
470: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');
471: END IF;
472:
473: l_notes_detail := NULL;
474: JTF_Notes_Pub.WriteLobToData(l_note_rec.jtf_note_id, l_notes_detail);
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
527: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_jtf_note_id: ' || l_jtf_note_id, 1, 'N');
528: END IF;
529:
530: END LOOP;
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
527: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_jtf_note_id: ' || l_jtf_note_id, 1, 'N');
528: END IF;
529:
530: END LOOP;
531:
529:
530: END LOOP;
531:
532: -- End of API body.
533: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
534: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: End Copy_Notes_copy_quote()', 1, 'Y');
535: END IF;
536:
537: -- Standard check of p_commit.
530: END LOOP;
531:
532: -- End of API body.
533: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
534: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: End Copy_Notes_copy_quote()', 1, 'Y');
535: END IF;
536:
537: -- Standard check of p_commit.
538: IF FND_API.To_Boolean(p_commit) THEN