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_ACCRUALWRITEOFFREPORT_PVT dependencies on FND_API

Line 64: l_return_status := fnd_api.g_ret_sts_success;

60:
61: -- Initialze variables
62: l_amount := 16383;
63: l_offset := 1;
64: l_return_status := fnd_api.g_ret_sts_success;
65: l_msg_count := 0;
66:
67: -- select the operating unit for which the program is launched.
68:

Line 102: RAISE fnd_api.g_exc_error;

98: If (p_from_write_off_date is not null and p_to_write_off_date < p_from_write_off_date ) then
99:
100: l_error_message := 'CST_INVALID_TO_DATE';
101: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
102: RAISE fnd_api.g_exc_error;
103: End If;
104:
105: l_stmt_num := 20;
106:

Line 113: RAISE fnd_api.g_exc_error;

109: If (p_from_amount is not null and p_to_amount < p_from_amount ) then
110:
111: l_error_message := 'CST_INVALID_TO_AMOUNT';
112: fnd_message.set_name('BOM','CST_INVALID_TO_AMOUNT');
113: RAISE fnd_api.g_exc_error;
114: End If;
115:
116: -- Initialze variables for storing XML Data
117:

Line 167: p_init_msg_list => FND_API.G_FALSE,

163:
164: l_stmt_num := 50;
165:
166: Add_Parameters (p_api_version => l_api_version,
167: p_init_msg_list => FND_API.G_FALSE,
168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
169: x_return_status => l_return_status,
170: x_msg_count => l_msg_count,
171: x_msg_data => l_msg_data,

Line 168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

164: l_stmt_num := 50;
165:
166: Add_Parameters (p_api_version => l_api_version,
167: p_init_msg_list => FND_API.G_FALSE,
168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
169: x_return_status => l_return_status,
170: x_msg_count => l_msg_count,
171: x_msg_data => l_msg_data,
172: i_title => p_title,

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

182: x_xml_doc => l_xml_doc);
183:
184: -- Standard call to check the return status from API called
185:
186: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: /*========================================================================*/

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183:
184: -- Standard call to check the return status from API called
185:
186: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: /*========================================================================*/
191: -- Call to Procedure Add Parameters. To add write off data to XML data

Line 197: p_init_msg_list => FND_API.G_FALSE,

193:
194: l_stmt_num := 60;
195:
196: Add_WriteOffData (p_api_version => l_api_version,
197: p_init_msg_list => FND_API.G_FALSE,
198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
199: x_return_status => l_return_status,
200: x_msg_count => l_msg_count,
201: x_msg_data => l_msg_data,

Line 198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

194: l_stmt_num := 60;
195:
196: Add_WriteOffData (p_api_version => l_api_version,
197: p_init_msg_list => FND_API.G_FALSE,
198: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
199: x_return_status => l_return_status,
200: x_msg_count => l_msg_count,
201: x_msg_data => l_msg_data,
202: i_title => p_title,

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

212: x_xml_doc => l_xml_doc);
213:
214: -- Standard call to check the return status from API called
215:
216: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- write the closing tag to the XML data

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213:
214: -- Standard call to check the return status from API called
215:
216: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- write the closing tag to the XML data
221:

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: '<<< ' || l_api_name);
256: END IF;
257:
258: EXCEPTION
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:
258: EXCEPTION
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 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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 637: IF NOT FND_API.Compatible_API_Call ( l_api_version,

633: END IF;
634:
635: -- Standard call to check for call compatibility.
636:
637: IF NOT FND_API.Compatible_API_Call ( l_api_version,
638: p_api_version,
639: l_api_name,
640: G_PKG_NAME )
641: THEN

Line 642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

638: p_api_version,
639: l_api_name,
640: G_PKG_NAME )
641: THEN
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: END IF;
644:
645: -- Initialize message list if p_init_msg_list is set to TRUE.
646:

Line 647: IF FND_API.to_Boolean( p_init_msg_list ) THEN

643: END IF;
644:
645: -- Initialize message list if p_init_msg_list is set to TRUE.
646:
647: IF FND_API.to_Boolean( p_init_msg_list ) THEN
648: FND_MSG_PUB.initialize;
649: END IF;
650:
651: -- Initialize API return status to success

Line 653: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 964: WHEN FND_API.G_EXC_ERROR THEN

960: '<<< ' || l_api_name);
961: END IF;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: x_return_status := FND_API.G_RET_STS_ERROR ;
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data

Line 965: x_return_status := FND_API.G_RET_STS_ERROR ;

961: END IF;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: x_return_status := FND_API.G_RET_STS_ERROR ;
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data
969: );

Line 971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

967: ( p_count => x_msg_count,
968: p_data => x_msg_data
969: );
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
973: FND_MSG_PUB.Count_And_Get
974: ( p_count => x_msg_count,
975: p_data => x_msg_data);

Line 972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

968: p_data => x_msg_data
969: );
970:
971: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
973: FND_MSG_PUB.Count_And_Get
974: ( p_count => x_msg_count,
975: p_data => x_msg_data);
976:

Line 978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

974: ( p_count => x_msg_count,
975: p_data => x_msg_data);
976:
977: WHEN OTHERS THEN
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF (l_uLog) THEN
980: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
981: l_module || '.' || l_stmt_num,
982: SUBSTRB (SQLERRM , 1 , 240));