APPS.DPP_PURCHASEPRICE_PVT dependencies on DPP_OUTPUT_XML_GT

Line 570: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,

566: ||'Error in Currency Conversion to PO Currency: '
567: || po_rec.currency_code;
568: l_return_status := l_cur_return_status;
569: l_status_Update_tbl(i).update_status := 'N';
570: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
571: Document_Type,
572: Document_Number,
573: Line_Number,
574: Reason_For_Failure)

Line 619: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,

615: l_po_details_tbl(i).Reason_for_failure := l_api_errors.message_text(j);
616: -- Debug Message
617: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error Message: ' || l_api_errors.message_text(j));
618:
619: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
620: Document_Type,
621: Document_Number,
622: Line_Number,
623: Reason_For_Failure)

Line 654: --Get the output XML from DPP_OUTPUT_XML_GT table

650: --OutputXML Generation
651: BEGIN
652: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status before generating output xml: ' || x_return_status);
653:
654: --Get the output XML from DPP_OUTPUT_XML_GT table
655: l_Transaction_Number := ''''||l_item_price_rec.Transaction_Number||'''';
656: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
657: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
658: CURSOR (Select Item_Number ITEMNUMBER,

Line 663: from DPP_OUTPUT_XML_GT

659: Document_Type POTYPE,
660: Document_Number PONUMBER,
661: Line_Number LINENUMBER,
662: Reason_For_Failure REASON
663: from DPP_OUTPUT_XML_GT
664: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual'
665: );
666: ELSE
667: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');