DBA Data[Home] [Help]

APPS.GMO_DISPENSE_PVT dependencies on EDR_CONSTANTS_GRP

Line 943: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,LENGTH(EDR_CONSTANTS_GRP.G_ERECORD_XML_HEADER),EDR_CONSTANTS_GRP.G_ERECORD_XML_HEADER);

939: L_INSTR_XML := null;
940: --Initialize the final XML CLOB holder.
941: DBMS_LOB.CREATETEMPORARY(X_OUTPUT_XML, TRUE, DBMS_LOB.SESSION);
942: --Write the XML Header into the CLOB.
943: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,LENGTH(EDR_CONSTANTS_GRP.G_ERECORD_XML_HEADER),EDR_CONSTANTS_GRP.G_ERECORD_XML_HEADER);
944: --If the current transaction XML is not null then append the same into the final XML CLOB holder.
945: IF P_CURRENT_XML IS NOT NULL AND DBMS_LOB.GETLENGTH(P_CURRENT_XML) > 0 THEN
946: DBMS_LOB.APPEND(X_OUTPUT_XML,P_CURRENT_XML);
947: END IF;

Line 967: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,LENGTH(EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER),EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER);

963: IF L_INSTR_XML IS NOT NULL AND DBMS_LOB.GETLENGTH(L_INSTR_XML) > 0 THEN
964: DBMS_LOB.APPEND(X_OUTPUT_XML,L_INSTR_XML);
965: END IF;
966: --Append the XML Footer into the final XML CLOB holder.
967: DBMS_LOB.WRITEAPPEND(X_OUTPUT_XML,LENGTH(EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER),EDR_CONSTANTS_GRP.G_ERECORD_XML_FOOTER);
968: EXCEPTION
969: WHEN XML_ERROR THEN
970: FND_MESSAGE.SET_ENCODED(L_MSG_DATA);
971: --Diagnostics Start