eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_NOTES_INT dependencies on ASO_NOTES_INT

Line 1: PACKAGE BODY ASO_NOTES_INT AS

1: PACKAGE BODY ASO_NOTES_INT AS
2: /* $Header: asoinotb.pls 120.1 2005/06/29 12:34:02 appldev ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_NOTES_INT

Line 5: -- Package name : ASO_NOTES_INT

1: PACKAGE BODY ASO_NOTES_INT AS
2: /* $Header: asoinotb.pls 120.1 2005/06/29 12:34:02 appldev ship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_NOTES_INT
6: -- Purpose :
7: -- History :
8: -- 10/07/2002 - hyang: 2611381, performance fix for 1158.
9: -- 28-JAN-2003 - subha madapusi : ER 2732010.

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_NOTES_INT';

10: -- 01-MAY-2003 Subha Madapusi : bug - 2915604.
11: -- NOTE :
12: -- End of Comments
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_NOTES_INT';
15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoinotb.pls';
16:
17:
18: /*

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

Line 592: END ASO_NOTES_INT;

588:
589: END Copy_Notes_copy_quote;
590:
591:
592: END ASO_NOTES_INT;