APPS.PO_DRAFT_MERGE_PKG dependencies on PO_ONLINE_REPORT_TEXT_GT

Line 638: -- copying message from po_online_report_text_gt

634: x_progress := 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous - Return Status: '|| l_return_status ;
635: po_wf_debug_pkg.Insert_debug(itemtype,itemkey,x_progress );
636:
637: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL) THEN
638: -- copying message from po_online_report_text_gt
639: g_action:= 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : ';
640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id
641: and rownum =1;
642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );

Line 640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id

636:
637: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR l_return_status IS NULL) THEN
638: -- copying message from po_online_report_text_gt
639: g_action:= 'PO_DRAFT_MERGE_PKG.MergeReserve_Autonomous : ';
640: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = l_online_report_id
641: and rownum =1;
642: po_wf_debug_pkg.Insert_debug(itemtype,itemkey, g_action || g_error_message );
643: g_result := l_return_status;
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1218: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = x_online_report_id

1214: -- bug 13709183 Autonomous transaction must rollback in case of any error (expected, unexpected)
1215: -- IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1216: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1217: -- fetch error message
1218: SELECT TEXT_LINE into g_error_message FROM po_online_report_text_gt WHERE online_report_id = x_online_report_id
1219: and rownum=1;
1220: g_result := x_return_status;
1221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1222: END IF;