[Home] [Help]
4074: -- Name
4075: -- DEFAULT_XMLGTXN_MAPPING
4076: -- Purpose
4077: -- This is the public procedure which returns the application id for a given set of
4078: -- parameters passed while refering to teh CLN_CH_XMLGTXN_MAPPING.
4079: -- Arguments
4080: --
4081: -- Notes
4082: -- No specific notes.
4150: -- Get the trading partner details
4151: IF ((p_app_id IS NULL) OR (p_coll_type IS NULL) OR (p_doc_type IS NULL)) THEN
4152: BEGIN
4153: IF (l_Debug_Level <= 1) THEN
4154: ecx_cln_debug_pub.Add('-- Before sql query to CLN_CH_XMLGTXN_MAPPING --',1);
4155: END IF;
4156:
4157: SELECT application_id, collaboration_type, document_type
4158: INTO l_application_id, l_collaboration_type, l_document_type
4155: END IF;
4156:
4157: SELECT application_id, collaboration_type, document_type
4158: INTO l_application_id, l_collaboration_type, l_document_type
4159: FROM CLN_CH_XMLGTXN_MAPPING
4160: WHERE XMLG_TRANSACTION_TYPE = p_xmlg_transaction_type
4161: AND XMLG_TRANSACTION_SUBTYPE = p_xmlg_transaction_subtype
4162: AND DOCUMENT_DIRECTION = p_doc_dir ;
4163: IF (l_Debug_Level <= 1) THEN
4160: WHERE XMLG_TRANSACTION_TYPE = p_xmlg_transaction_type
4161: AND XMLG_TRANSACTION_SUBTYPE = p_xmlg_transaction_subtype
4162: AND DOCUMENT_DIRECTION = p_doc_dir ;
4163: IF (l_Debug_Level <= 1) THEN
4164: ecx_cln_debug_pub.Add('-- After sql query to CLN_CH_XMLGTXN_MAPPING --',1);
4165: END IF;
4166:
4167:
4168: EXCEPTION
4174: IF (l_Debug_Level <= 1) THEN
4175: ecx_cln_debug_pub.Add(l_msg_data,1);
4176: END IF;
4177:
4178: FND_MESSAGE.SET_NAME('CLN','CLN_CH_XMLGTXN_MAPPING_NF');
4179: x_msg_data := FND_MESSAGE.GET;
4180: x_return_status := FND_API.G_RET_STS_SUCCESS;
4181: RETURN;
4182: END;