[Home] [Help]
143: RAISE fnd_api.g_exc_error;
144: End If;
145:
146:
147: -- Standard call to get message count and if count is 1, get message info.
148:
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => l_msg_count,
151: p_data => l_msg_data
177: i_bal_segment_from => p_bal_segment_from,
178: i_bal_segment_to => p_bal_segment_to,
179: x_xml_doc => l_xml_doc);
180:
181: -- Standard call to check the return status from API called
182:
183: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
208: i_bal_segment_from => p_bal_segment_from,
209: i_bal_segment_to => p_bal_segment_to,
210: x_xml_doc => l_xml_doc);
211:
212: -- Standard call to check the return status from API called
213:
214: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
389: l_module || '.begin',
390: '>>> ' || l_api_name);
391: END IF;
392:
393: -- Standard call to check for call compatibility.
394:
395: IF NOT FND_API.Compatible_API_Call ( l_api_version,
396: p_api_version,
397: l_api_name,
525: DBMS_XMLGEN.closeContext(l_qryCtx);
526: CLOSE l_ref_cur;
527: DBMS_LOB.FREETEMPORARY (l_xml_temp);
528:
529: -- Standard call to get message count and if count is 1, get message info.
530:
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
635: l_module || '.begin',
636: '>>> ' || l_api_name);
637: END IF;
638:
639: -- Standard call to check for call compatibility.
640:
641: IF NOT FND_API.Compatible_API_Call ( l_api_version,
642: p_api_version,
643: l_api_name,
974: CLOSE l_ref_cur;
975: DBMS_LOB.FREETEMPORARY (l_xml_temp);
976:
977:
978: -- Standard call to get message count and if count is 1, get message info.
979:
980: FND_MSG_PUB.Count_And_Get
981: ( p_count => x_msg_count,
982: p_data => x_msg_data