[Home] [Help]
567: ||'Error in Currency Conversion to PO Currency: '
568: || po_rec.currency_code;
569: l_return_status := l_cur_return_status;
570: l_status_Update_tbl(i).update_status := 'N';
571: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
572: Document_Type,
573: Document_Number,
574: Line_Number,
575: Reason_For_Failure)
621: -- Debug Message
622: IF g_debug THEN
623: DPP_UTILITY_PVT.debug_message('Error Message: ' || l_api_errors.message_text(j));
624: END IF;
625: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
626: Document_Type,
627: Document_Number,
628: Line_Number,
629: Reason_For_Failure)
658: BEGIN
659: IF g_debug THEN
660: DPP_UTILITY_PVT.debug_message('Status before generating output xml: ' || x_return_status);
661: END IF;
662: --Get the output XML from DPP_OUTPUT_XML_GT table
663: l_Transaction_Number := ''''||l_item_price_rec.Transaction_Number||'''';
664: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
665: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
666: CURSOR (Select Item_Number ITEMNUMBER,
667: Document_Type POTYPE,
668: Document_Number PONUMBER,
669: Line_Number LINENUMBER,
670: Reason_For_Failure REASON
671: from DPP_OUTPUT_XML_GT
672: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual'
673: );
674: ELSE
675: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');