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.PVX_ATTACHMENT_INT dependencies on ASO_DEBUG_PUB

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

216: FND_MSG_PUB.initialize;
217: END IF;
218:
219:
220: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
221: aso_debug_pub.add (
222: 'DELETE_ATTACHMENTS: quote_header_id ' || p_quote_header_id,
223: 1,
224: 'Y'

Line 221: aso_debug_pub.add (

217: END IF;
218:
219:
220: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
221: aso_debug_pub.add (
222: 'DELETE_ATTACHMENTS: quote_header_id ' || p_quote_header_id,
223: 1,
224: 'Y'
225: );

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

231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
234:
235: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
236: aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');
237: END IF;
238:
239: -- Get the media_id for the attachment.

Line 236: aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');

232:
233: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
234:
235: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
236: aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');
237: END IF;
238:
239: -- Get the media_id for the attachment.
240: OPEN c_get_media_id (p_quote_attachment_ids(i));

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

263: END IF;
264:
265: RAISE fnd_api.g_exc_error;
266: ELSE
267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
268: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
269: END IF;
270: END IF;
271:

Line 268: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');

264:
265: RAISE fnd_api.g_exc_error;
266: ELSE
267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
268: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
269: END IF;
270: END IF;
271:
272: CLOSE c_get_media_id;

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

274: -- Call the procedure to delete the attachment and document.
275: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
276: '6', 'N' );
277:
278: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
279: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');
280: END IF;
281:
282: OPEN c_get_document_id_rows( l_document_id);

Line 279: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');

275: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
276: '6', 'N' );
277:
278: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
279: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');
280: END IF;
281:
282: OPEN c_get_document_id_rows( l_document_id);
283: FETCH c_get_document_id_rows into l_document_id;

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

284:
285: IF c_get_document_id_rows%NOTFOUND
286: THEN
287: CLOSE c_get_document_id_rows;
288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
289: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
290: END IF;
291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
292: ELSE

Line 289: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');

285: IF c_get_document_id_rows%NOTFOUND
286: THEN
287: CLOSE c_get_document_id_rows;
288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
289: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
290: END IF;
291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
292: ELSE
293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

289: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
290: END IF;
291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
292: ELSE
293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
294: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');
295: END IF;
296: END IF;
297:

Line 294: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');

290: END IF;
291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
292: ELSE
293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
294: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');
295: END IF;
296: END IF;
297:
298: IF c_get_document_id_rows%ISOPEN THEN