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.

[Home] [Help]

APPS.CST_MISCACCRUALREPORT_PVT dependencies on FND_API

Line 67: l_return_status := fnd_api.g_ret_sts_success;

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

Line 136: RAISE fnd_api.g_exc_error;

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

Line 145: RAISE fnd_api.g_exc_error;

141: If (p_from_amount is not null and p_to_amount < p_from_amount ) then
142:
143: l_error_message := 'CST_INVALID_TO_AMOUNT';
144: fnd_message.set_name('BOM','CST_INVALID_TO_AMOUNT');
145: RAISE fnd_api.g_exc_error;
146: End If;
147:
148:
149: -- Standard call to get message count and if count is 1, get message info.

Line 166: p_init_msg_list => FND_API.G_FALSE,

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

Line 167: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 197: p_init_msg_list => FND_API.G_FALSE,

193:
194: l_stmt_num := 50;
195:
196: Add_MiscData (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 := 50;
195:
196: Add_MiscData (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 261: WHEN FND_API.G_EXC_ERROR THEN

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

Line 263: l_return_status := FND_API.g_ret_sts_error;

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

Line 298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 397: IF NOT FND_API.Compatible_API_Call ( l_api_version,

393: END IF;
394:
395: -- Standard call to check for call compatibility.
396:
397: IF NOT FND_API.Compatible_API_Call ( l_api_version,
398: p_api_version,
399: l_api_name,
400: G_PKG_NAME )
401: THEN

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 407: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 547: WHEN FND_API.G_EXC_ERROR THEN

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

Line 548: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 643: IF NOT FND_API.Compatible_API_Call ( l_api_version,

639: END IF;
640:
641: -- Standard call to check for call compatibility.
642:
643: IF NOT FND_API.Compatible_API_Call ( l_api_version,
644: p_api_version,
645: l_api_name,
646: G_PKG_NAME )
647: THEN

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 653: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 659: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 996: WHEN FND_API.G_EXC_ERROR THEN

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

Line 997: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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