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_ATTACHMENT_INT dependencies on ASO_DEBUG_PUB

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

182:
183: -- Initialize API return status to error, i.e, its not duplicate
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_header_id: ' || p_quote_header_id, 1, 'N');
188: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_id: ' || p_order_id, 1, 'N');
189: END IF;
190:

Line 187: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_header_id: ' || p_quote_header_id, 1, 'N');

183: -- Initialize API return status to error, i.e, its not duplicate
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_header_id: ' || p_quote_header_id, 1, 'N');
188: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_id: ' || p_order_id, 1, 'N');
189: END IF;
190:
191: ASO_ATTACHMENT_INT.Copy_Attachments(

Line 188: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_id: ' || p_order_id, 1, 'N');

184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
187: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_header_id: ' || p_quote_header_id, 1, 'N');
188: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_id: ' || p_order_id, 1, 'N');
189: END IF;
190:
191: ASO_ATTACHMENT_INT.Copy_Attachments(
192: p_api_version => l_api_version,

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

206: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
211: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: line tbl count: ' || p_order_line_tbl.count, 1, 'N');
212: END IF;
213:
214: FOR i IN 1..p_order_line_tbl.count LOOP

Line 211: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: line tbl count: ' || p_order_line_tbl.count, 1, 'N');

207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
211: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: line tbl count: ' || p_order_line_tbl.count, 1, 'N');
212: END IF;
213:
214: FOR i IN 1..p_order_line_tbl.count LOOP
215:

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

216: OPEN c_quote_line (p_Order_Line_Tbl(i).QUOTE_SHIPMENT_LINE_ID);
217: FETCH c_quote_line into l_quote_line_id;
218: CLOSE c_quote_line;
219:
220: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
221: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_line_id: ' || l_quote_line_id, 1, 'N');
222: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_line_id: ' || p_order_line_tbl(i).ORDER_LINE_ID, 1, 'N');
223: END IF;
224:

Line 221: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_line_id: ' || l_quote_line_id, 1, 'N');

217: FETCH c_quote_line into l_quote_line_id;
218: CLOSE c_quote_line;
219:
220: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
221: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_line_id: ' || l_quote_line_id, 1, 'N');
222: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_line_id: ' || p_order_line_tbl(i).ORDER_LINE_ID, 1, 'N');
223: END IF;
224:
225: ASO_ATTACHMENT_INT.Copy_Attachments(

Line 222: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_line_id: ' || p_order_line_tbl(i).ORDER_LINE_ID, 1, 'N');

218: CLOSE c_quote_line;
219:
220: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
221: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: quote_line_id: ' || l_quote_line_id, 1, 'N');
222: aso_debug_pub.add('COPY_ATTACHMENTS_TO_ORDER: order_line_id: ' || p_order_line_tbl(i).ORDER_LINE_ID, 1, 'N');
223: END IF;
224:
225: ASO_ATTACHMENT_INT.Copy_Attachments(
226: p_api_version => l_api_version,

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

348: FND_MSG_PUB.initialize;
349: END IF;
350:
351:
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.add (
354: 'DELETE_ATTACHMENTS: quote_header_id ' || p_quote_header_id,
355: 1,
356: 'Y'

Line 353: aso_debug_pub.add (

349: END IF;
350:
351:
352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
353: aso_debug_pub.add (
354: 'DELETE_ATTACHMENTS: quote_header_id ' || p_quote_header_id,
355: 1,
356: 'Y'
357: );

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

363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
366:
367: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
368: aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');
369: END IF;
370:
371: -- Get the media_id for the attachment.

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

364:
365: FOR i in 1..p_quote_attachment_ids.COUNT LOOP
366:
367: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
368: aso_debug_pub.add ('DELETE_ATTACHMENTS: quote_attachment_id ' || p_quote_attachment_ids(i),1,'Y');
369: END IF;
370:
371: -- Get the media_id for the attachment.
372: OPEN c_get_media_id (p_quote_attachment_ids(i));

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

395: END IF;
396:
397: RAISE fnd_api.g_exc_error;
398: ELSE
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
400: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
401: END IF;
402: END IF;
403:

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

396:
397: RAISE fnd_api.g_exc_error;
398: ELSE
399: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
400: aso_debug_pub.add ('DELETE_ATTACHMENTS: l_document_id : ' || l_document_id,1,'Y');
401: END IF;
402: END IF;
403:
404: CLOSE c_get_media_id;

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

406: -- Call the procedure to delete the attachment and document.
407: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
408: '6', 'N' );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');
412: END IF;
413:
414: OPEN c_get_document_id_rows( l_document_id);

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

407: FND_ATTACHED_DOCUMENTS3_PKG.delete_row ( p_quote_attachment_ids(i),
408: '6', 'N' );
409:
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Check to see if the attachment was from an Opportunity...', 1, 'Y');
412: END IF;
413:
414: OPEN c_get_document_id_rows( l_document_id);
415: FETCH c_get_document_id_rows into l_document_id;

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

416:
417: IF c_get_document_id_rows%NOTFOUND
418: THEN
419: CLOSE c_get_document_id_rows;
420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
421: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
422: END IF;
423: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
424: ELSE

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

417: IF c_get_document_id_rows%NOTFOUND
418: THEN
419: CLOSE c_get_document_id_rows;
420: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
421: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
422: END IF;
423: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
424: ELSE
425: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

421: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
422: END IF;
423: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
424: ELSE
425: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
426: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');
427: END IF;
428: END IF;
429:

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

422: END IF;
423: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
424: ELSE
425: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
426: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');
427: END IF;
428: END IF;
429:
430: IF c_get_document_id_rows%ISOPEN THEN

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

572: -- Initialize API return status to success
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574: -- API body
575:
576: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');
578: aso_debug_pub.add('COPY_ATTACHMENTS: new_object_id: ' || p_new_object_id, 1, 'N');
579: END IF;
580:

Line 577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');

573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574: -- API body
575:
576: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');
578: aso_debug_pub.add('COPY_ATTACHMENTS: new_object_id: ' || p_new_object_id, 1, 'N');
579: END IF;
580:
581: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

Line 578: aso_debug_pub.add('COPY_ATTACHMENTS: new_object_id: ' || p_new_object_id, 1, 'N');

574: -- API body
575:
576: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
577: aso_debug_pub.add('COPY_ATTACHMENTS: old_object_id: ' || p_old_object_id, 1, 'N');
578: aso_debug_pub.add('COPY_ATTACHMENTS: new_object_id: ' || p_new_object_id, 1, 'N');
579: END IF;
580:
581: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
582: x_from_entity_name => p_old_object_code,