DBA Data[Home] [Help]

APPS.CST_ACCRUALSUMMARYREPORT_PVT dependencies on FND_API

Line 106: p_init_msg_list => FND_API.G_FALSE,

102: l_stmt_num := 20;
103:
104: Add_Parameters (p_api_version => l_api_version,
105: x_return_status => l_return_status,
106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: x_msg_count => l_msg_count,
109: x_msg_data => l_msg_data,
110: i_title => p_title,

Line 107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

103:
104: Add_Parameters (p_api_version => l_api_version,
105: x_return_status => l_return_status,
106: p_init_msg_list => FND_API.G_FALSE,
107: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: x_msg_count => l_msg_count,
109: x_msg_data => l_msg_data,
110: i_title => p_title,
111: i_bal_segment_from => p_bal_segment_from,

Line 117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

113: x_xml_doc => l_xml_doc);
114:
115: -- Standard call to check the return status from API called
116:
117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: /*========================================================================*/

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114:
115: -- Standard call to check the return status from API called
116:
117: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: /*========================================================================*/
122: -- Call to Procedure Add Parameters. To add summary data to XML data

Line 128: p_init_msg_list => FND_API.G_FALSE,

124:
125: l_stmt_num := 30;
126:
127: Add_SummaryData (p_api_version => l_api_version,
128: p_init_msg_list => FND_API.G_FALSE,
129: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
130: x_return_status => l_return_status,
131: x_msg_count => l_msg_count,
132: x_msg_data => l_msg_data,

Line 129: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

125: l_stmt_num := 30;
126:
127: Add_SummaryData (p_api_version => l_api_version,
128: p_init_msg_list => FND_API.G_FALSE,
129: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
130: x_return_status => l_return_status,
131: x_msg_count => l_msg_count,
132: x_msg_data => l_msg_data,
133: i_title => p_title,

Line 140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

136: x_xml_doc => l_xml_doc);
137:
138: -- Standard call to check the return status from API called
139:
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: -- write the closing tag to the XML data

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137:
138: -- Standard call to check the return status from API called
139:
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: -- write the closing tag to the XML data
145:

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: '<<< ' || l_api_name);
180: END IF;
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: l_return_status := FND_API.G_RET_STS_ERROR ;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => l_msg_count,
187: p_data => l_msg_data

Line 184: l_return_status := FND_API.G_RET_STS_ERROR ;

180: END IF;
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: l_return_status := FND_API.G_RET_STS_ERROR ;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => l_msg_count,
187: p_data => l_msg_data
188: );

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: ( p_count => l_msg_count,
187: p_data => l_msg_data
188: );
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: FND_MSG_PUB.Count_And_Get
192: ( p_count => l_msg_count,
193: p_data => l_msg_data
194: );

Line 282: IF NOT FND_API.Compatible_API_Call ( l_api_version,

278: END IF;
279:
280: -- Standard call to check for call compatibility.
281:
282: IF NOT FND_API.Compatible_API_Call ( l_api_version,
283: p_api_version,
284: l_api_name,
285: G_PKG_NAME )
286: THEN

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: p_api_version,
284: l_api_name,
285: G_PKG_NAME )
286: THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291:

Line 292: IF FND_API.to_Boolean( p_init_msg_list ) THEN

288: END IF;
289:
290: -- Initialize message list if p_init_msg_list is set to TRUE.
291:
292: IF FND_API.to_Boolean( p_init_msg_list ) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: -- Initialize API return status to success

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294: END IF;
295:
296: -- Initialize API return status to success
297:
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: -- Initialize temporary variable to hold xml data
301:
302: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 402: WHEN FND_API.G_EXC_ERROR THEN

398: '<<< ' || l_api_name);
399: END IF;
400:
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: x_return_status := FND_API.G_RET_STS_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data

Line 403: x_return_status := FND_API.G_RET_STS_ERROR ;

399: END IF;
400:
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: x_return_status := FND_API.G_RET_STS_ERROR ;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );

Line 409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

406: p_data => x_msg_data
407: );
408:
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

413: p_data => x_msg_data
414: );
415:
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: IF (l_uLog) THEN
419: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
420: l_module || '.' || l_stmt_num,
421: SUBSTRB (SQLERRM , 1 , 240));

Line 488: IF NOT FND_API.Compatible_API_Call ( l_api_version,

484: END IF;
485:
486: -- Standard call to check for call compatibility.
487:
488: IF NOT FND_API.Compatible_API_Call ( l_api_version,
489: p_api_version,
490: l_api_name,
491: G_PKG_NAME )
492: THEN

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: p_api_version,
490: l_api_name,
491: G_PKG_NAME )
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.
497:

Line 498: IF FND_API.to_Boolean( p_init_msg_list ) THEN

494: END IF;
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.
497:
498: IF FND_API.to_Boolean( p_init_msg_list ) THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: -- Initialize API return status to success

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: END IF;
501:
502: -- Initialize API return status to success
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Initialize temporary variable to hold xml data
507:
508: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: '<<< ' || l_api_name);
731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: x_return_status := FND_API.G_RET_STS_ERROR ;
736: FND_MSG_PUB.Count_And_Get
737: ( p_count => x_msg_count,
738: p_data => x_msg_data

Line 735: x_return_status := FND_API.G_RET_STS_ERROR ;

731: END IF;
732:
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: x_return_status := FND_API.G_RET_STS_ERROR ;
736: FND_MSG_PUB.Count_And_Get
737: ( p_count => x_msg_count,
738: p_data => x_msg_data
739: );

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: ( p_count => x_msg_count,
738: p_data => x_msg_data
739: );
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
743: FND_MSG_PUB.Count_And_Get
744: ( p_count => x_msg_count,
745: p_data => x_msg_data);

Line 742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

738: p_data => x_msg_data
739: );
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
743: FND_MSG_PUB.Count_And_Get
744: ( p_count => x_msg_count,
745: p_data => x_msg_data);
746:

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

744: ( p_count => x_msg_count,
745: p_data => x_msg_data);
746:
747: WHEN OTHERS THEN
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF (l_uLog) THEN
750: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
751: l_module || '.' || l_stmt_num,
752: SUBSTRB (SQLERRM , 1 , 240));