DBA Data[Home] [Help]

APPS.ASO_NOTES_INT dependencies on ASO_DEBUG_PUB

Line 93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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');

Line 94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');

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');

Line 95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 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;

Line 96: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_type_code: ' || p_old_object_type_code, 1, 'N');

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:

Line 97: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_id: ' || p_new_object_id, 1, 'N');

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

Line 98: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: new_object_type_code: ' || p_new_object_type_code, 1, 'N');

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:

Line 103: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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:

Line 104: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: l_note_rec.jtf_note_id: ' || l_note_rec.jtf_note_id, 1, 'N');

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(

Line 129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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;

Line 130: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: lx_jtf_note_context_id :' || lx_jtf_note_context_id, 1, 'N');

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:

Line 136: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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.

Line 137: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: End Copy_Notes()', 1, 'Y');

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

Line 270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');

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');

Line 272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 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;

Line 273: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_type_code: ' || p_old_object_type_code, 1, 'N');

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:

Line 274: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_id: ' || p_new_object_id, 1, 'N');

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

Line 275: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: new_object_type_code: ' || p_new_object_type_code, 1, 'N');

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:

Line 280: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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:

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

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(

Line 306: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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;

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

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:

Line 313: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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.

Line 314: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: End Copy_Opp_Notes_To_Qte()', 1, 'Y');

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

Line 459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' 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');

Line 460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');

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');

Line 461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 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;

Line 462: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_type_code: ' || p_old_object_type_code, 1, 'N');

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:

Line 463: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_id: ' || p_new_object_id, 1, 'N');

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

Line 464: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: new_object_type_code: ' || p_new_object_type_code, 1, 'N');

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:

Line 469: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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;

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

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);

Line 526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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;

Line 527: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_jtf_note_id: ' || l_jtf_note_id, 1, 'N');

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:

Line 533: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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.

Line 534: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: End Copy_Notes_copy_quote()', 1, 'Y');

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