APPS.GMO_DISPENSE_PVT dependencies on DBMS_LOB

Line 941: DBMS_LOB.CREATETEMPORARY(X_OUTPUT_XML, TRUE, DBMS_LOB.SESSION);

937: BEGIN
938: --Set L_INSTR_XML to null.
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

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 945: IF P_CURRENT_XML IS NOT NULL AND DBMS_LOB.GETLENGTH(P_CURRENT_XML) > 0 THEN

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;
948: --Obtain the process instruction details in XML format for the specified instruction process ID.
949: GMO_INSTRUCTION_GRP.GET_INSTR_INSTANCE_XML

Line 946: DBMS_LOB.APPEND(X_OUTPUT_XML,P_CURRENT_XML);

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;
948: --Obtain the process instruction details in XML format for the specified instruction process ID.
949: GMO_INSTRUCTION_GRP.GET_INSTR_INSTANCE_XML
950: (P_API_VERSION => 1.0,

Line 963: IF L_INSTR_XML IS NOT NULL AND DBMS_LOB.GETLENGTH(L_INSTR_XML) > 0 THEN

959: IF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR OR L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
960: RAISE XML_ERROR;
961: END IF;
962: --If the XML representing the process instruction details is not null then append the same into the final XMl CLOB holder.
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);

Line 964: DBMS_LOB.APPEND(X_OUTPUT_XML,L_INSTR_XML);

960: RAISE XML_ERROR;
961: END IF;
962: --If the XML representing the process instruction details is not null then append the same into the final XMl CLOB holder.
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

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