eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_MISCACCRUALREPORT_PVT dependencies on FND_API

Line 65: l_return_status := fnd_api.g_ret_sts_success;

61:
62: -- Initialze variables
63: l_amount := 16383; --Changed for bug 7013852
64: l_offset := 1;
65: l_return_status := fnd_api.g_ret_sts_success;
66: l_msg_count := 0;
67:
68:
69:

Line 134: RAISE fnd_api.g_exc_error;

130: If (p_from_date is not null and p_to_date < p_from_date ) then
131:
132: l_error_message := 'CST_INVALID_TO_DATE';
133: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
134: RAISE fnd_api.g_exc_error;
135: End If;
136:
137: /* check if to_amount is greater than or equal to from_amount */
138:

Line 143: RAISE fnd_api.g_exc_error;

139: If (p_from_amount is not null and p_to_amount < p_from_amount ) then
140:
141: l_error_message := 'CST_INVALID_TO_AMOUNT';
142: fnd_message.set_name('BOM','CST_INVALID_TO_AMOUNT');
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.

Line 164: p_init_msg_list => FND_API.G_FALSE,

160:
161: l_stmt_num := 40;
162:
163: Add_Parameters (p_api_version => l_api_version,
164: p_init_msg_list => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
166: x_return_status => l_return_status,
167: x_msg_count => l_msg_count,
168: x_msg_data => l_msg_data,

Line 165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

161: l_stmt_num := 40;
162:
163: Add_Parameters (p_api_version => l_api_version,
164: p_init_msg_list => FND_API.G_FALSE,
165: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
166: x_return_status => l_return_status,
167: x_msg_count => l_msg_count,
168: x_msg_data => l_msg_data,
169: i_title => p_title,

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

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;
186:
187:

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
186:
187:
188: /*========================================================================*/

Line 195: p_init_msg_list => FND_API.G_FALSE,

191:
192: l_stmt_num := 50;
193:
194: Add_MiscData (p_api_version => l_api_version,
195: p_init_msg_list => FND_API.G_FALSE,
196: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
197: x_return_status => l_return_status,
198: x_msg_count => l_msg_count,
199: x_msg_data => l_msg_data,

Line 196: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

192: l_stmt_num := 50;
193:
194: Add_MiscData (p_api_version => l_api_version,
195: p_init_msg_list => FND_API.G_FALSE,
196: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
197: x_return_status => l_return_status,
198: x_msg_count => l_msg_count,
199: x_msg_data => l_msg_data,
200: i_title => p_title,

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

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;
217:
218: -- write the closing tag to the XML data

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
217:
218: -- write the closing tag to the XML data
219:

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: END IF;
256:
257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK;
261: l_return_status := FND_API.g_ret_sts_error;
262: If l_errorLog then
263: fnd_log.message(FND_LOG.LEVEL_ERROR,

Line 261: l_return_status := FND_API.g_ret_sts_error;

257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK;
261: l_return_status := FND_API.g_ret_sts_error;
262: If l_errorLog then
263: fnd_log.message(FND_LOG.LEVEL_ERROR,
264: G_LOG_HEADER || '.' || l_api_name || '(' ||to_char(l_stmt_num)||')',
265: FALSE

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292:
293: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM',l_error_message),1,240));
294:
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: FND_MSG_PUB.Count_And_Get
298: ( p_count => l_msg_count,
299: p_data => l_msg_data
300: );

Line 395: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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,
398: G_PKG_NAME )
399: THEN

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: p_api_version,
397: l_api_name,
398: G_PKG_NAME )
399: THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404:

Line 405: IF FND_API.to_Boolean( p_init_msg_list ) THEN

401: END IF;
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404:
405: IF FND_API.to_Boolean( p_init_msg_list ) THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:
409: -- Initialize API return status to success

Line 411: x_return_status := FND_API.G_RET_STS_SUCCESS;

407: END IF;
408:
409: -- Initialize API return status to success
410:
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412:
413: -- Initialize temporary variable to hold xml data
414:
415: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 545: WHEN FND_API.G_EXC_ERROR THEN

541: '<<< ' || l_api_name);
542: END IF;
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: x_return_status := FND_API.G_RET_STS_ERROR ;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data

Line 546: x_return_status := FND_API.G_RET_STS_ERROR ;

542: END IF;
543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_ERROR THEN
546: x_return_status := FND_API.G_RET_STS_ERROR ;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );

Line 552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551:
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

549: p_data => x_msg_data
550: );
551:
552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: ( p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

556: p_data => x_msg_data
557: );
558:
559: WHEN OTHERS THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: IF (l_uLog) THEN
562: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
563: l_module || '.' || l_stmt_num,
564: SUBSTRB (SQLERRM , 1 , 240));

Line 641: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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,
644: G_PKG_NAME )
645: THEN

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642: p_api_version,
643: l_api_name,
644: G_PKG_NAME )
645: THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650:

Line 651: IF FND_API.to_Boolean( p_init_msg_list ) THEN

647: END IF;
648:
649: -- Initialize message list if p_init_msg_list is set to TRUE.
650:
651: IF FND_API.to_Boolean( p_init_msg_list ) THEN
652: FND_MSG_PUB.initialize;
653: END IF;
654:
655: -- Initialize API return status to success

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: END IF;
654:
655: -- Initialize API return status to success
656:
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: -- Initialize temporary variable to hold xml data
660:
661: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 994: WHEN FND_API.G_EXC_ERROR THEN

990: '<<< ' || l_api_name);
991: END IF;
992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_ERROR ;
996: FND_MSG_PUB.Count_And_Get
997: ( p_count => x_msg_count,
998: p_data => x_msg_data

Line 995: x_return_status := FND_API.G_RET_STS_ERROR ;

991: END IF;
992:
993: EXCEPTION
994: WHEN FND_API.G_EXC_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_ERROR ;
996: FND_MSG_PUB.Count_And_Get
997: ( p_count => x_msg_count,
998: p_data => x_msg_data
999: );

Line 1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

997: ( p_count => x_msg_count,
998: p_data => x_msg_data
999: );
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_count => x_msg_count,
1005: p_data => x_msg_data);

Line 1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

998: p_data => x_msg_data
999: );
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1004: ( p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:
1007: WHEN OTHERS THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009: IF (l_uLog) THEN
1010: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1011: l_module || '.' || l_stmt_num,
1012: SUBSTRB (SQLERRM , 1 , 240));