DBA Data[Home] [Help]

APPS.CST_APPOACCRUALREPORT_PVT dependencies on FND_API

Line 66: l_return_status := fnd_api.g_ret_sts_success;

62: -- Initialze variables
63:
64: l_amount := 16383;
65: l_offset := 1;
66: l_return_status := fnd_api.g_ret_sts_success;
67: l_msg_count := 0;
68:
69: /* check if to_amount is greater than or equal to from_amount */
70:

Line 75: RAISE fnd_api.g_exc_error;

71: If (p_from_amount is not null and p_to_amount < p_from_amount ) then
72:
73: l_error_message := 'CST_INVALID_TO_AMOUNT';
74: fnd_message.set_name('BOM','CST_INVALID_TO_AMOUNT');
75: RAISE fnd_api.g_exc_error;
76: End If;
77:
78:
79: /* check if aging bucket is greater than zero */

Line 85: RAISE fnd_api.g_exc_error;

81: If (p_aging_days < 0 ) then
82:
83: l_error_message := 'CST_INVALID_AGE';
84: fnd_message.set_name('BOM','CST_INVALID_AGE');
85: RAISE fnd_api.g_exc_error;
86: End If;
87:
88:
89: -- select the operating unit for which the program is launched.

Line 145: p_init_msg_list => FND_API.G_FALSE,

141: -- XML data
142: /*========================================================================*/
143:
144: Add_Parameters (p_api_version => l_api_version,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
147: x_return_status => l_return_status,
148: x_msg_count => l_msg_count,
149: x_msg_data => l_msg_data,

Line 146: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

142: /*========================================================================*/
143:
144: Add_Parameters (p_api_version => l_api_version,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
147: x_return_status => l_return_status,
148: x_msg_count => l_msg_count,
149: x_msg_data => l_msg_data,
150: i_title => p_title,

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

161: x_xml_doc => l_xml_doc);
162:
163: -- Standard call to check the return status from API called
164:
165: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169:

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162:
163: -- Standard call to check the return status from API called
164:
165: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169:
170: l_stmt_num := 30;

Line 177: p_init_msg_list => FND_API.G_FALSE,

173: -- Call to Procedure Add Parameters. To Add AP and PO data to XML data
174: /*========================================================================*/
175:
176: Add_ApPoData (p_api_version => l_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
179: x_return_status => l_return_status,
180: x_msg_count => l_msg_count,
181: x_msg_data => l_msg_data,

Line 178: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

174: /*========================================================================*/
175:
176: Add_ApPoData (p_api_version => l_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
179: x_return_status => l_return_status,
180: x_msg_count => l_msg_count,
181: x_msg_data => l_msg_data,
182: i_title => p_title,

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

193: x_xml_doc => l_xml_doc);
194:
195: -- Standard call to check the return status from API called
196:
197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: -- write the closing tag to the XML data

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194:
195: -- Standard call to check the return status from API called
196:
197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200:
201: -- write the closing tag to the XML data
202:

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: '<<< ' || l_api_name);
238: END IF;
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK;
243: l_return_status := FND_API.g_ret_sts_error;
244: If l_errorLog then
245: fnd_log.message(FND_LOG.LEVEL_ERROR,

Line 243: l_return_status := FND_API.g_ret_sts_error;

239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK;
243: l_return_status := FND_API.g_ret_sts_error;
244: If l_errorLog then
245: fnd_log.message(FND_LOG.LEVEL_ERROR,
246: G_LOG_HEADER || '.' || l_api_name || '(' ||to_char(l_stmt_num)||')',
247: FALSE

Line 277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

273: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
274:
275: l_conc_request := fnd_concurrent.set_completion_status('ERROR',substr(fnd_message.get_string('BOM',l_error_message),1,240));
276:
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: FND_MSG_PUB.Count_And_Get
279: ( p_count => l_msg_count,
280: p_data => l_msg_data
281: );

Line 377: IF NOT FND_API.Compatible_API_Call ( l_api_version,

373: END IF;
374:
375: -- Standard call to check for call compatibility.
376:
377: IF NOT FND_API.Compatible_API_Call ( l_api_version,
378: p_api_version,
379: l_api_name,
380: G_PKG_NAME )
381: THEN

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378: p_api_version,
379: l_api_name,
380: G_PKG_NAME )
381: THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Initialize message list if p_init_msg_list is set to TRUE.
386:

Line 387: IF FND_API.to_Boolean( p_init_msg_list ) THEN

383: END IF;
384:
385: -- Initialize message list if p_init_msg_list is set to TRUE.
386:
387: IF FND_API.to_Boolean( p_init_msg_list ) THEN
388: FND_MSG_PUB.initialize;
389: END IF;
390:
391: -- Initialize API return status to success

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: END IF;
390:
391: -- Initialize API return status to success
392:
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: -- Initialize temporary variable to hold xml data
396:
397: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 525: WHEN FND_API.G_EXC_ERROR THEN

521: '<<< ' || l_api_name);
522: END IF;
523:
524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data

Line 526: x_return_status := FND_API.G_RET_STS_ERROR ;

522: END IF;
523:
524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: ( p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count,
536: p_data => x_msg_data

Line 533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

529: p_data => x_msg_data
530: );
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count,
536: p_data => x_msg_data
537: );

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

536: p_data => x_msg_data
537: );
538:
539: WHEN OTHERS THEN
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
541: IF (l_uLog) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
543: l_module || '.' || l_stmt_num,
544: SUBSTRB (SQLERRM , 1 , 240));

Line 626: IF NOT FND_API.Compatible_API_Call ( l_api_version,

622: END IF;
623:
624: -- Standard call to check for call compatibility.
625:
626: IF NOT FND_API.Compatible_API_Call ( l_api_version,
627: p_api_version,
628: l_api_name,
629: G_PKG_NAME )
630: THEN

Line 631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

627: p_api_version,
628: l_api_name,
629: G_PKG_NAME )
630: THEN
631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
632: END IF;
633:
634: -- Initialize message list if p_init_msg_list is set to TRUE.
635:

Line 636: IF FND_API.to_Boolean( p_init_msg_list ) THEN

632: END IF;
633:
634: -- Initialize message list if p_init_msg_list is set to TRUE.
635:
636: IF FND_API.to_Boolean( p_init_msg_list ) THEN
637: FND_MSG_PUB.initialize;
638: END IF;
639:
640: -- Initialize API return status to success

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: END IF;
639:
640: -- Initialize API return status to success
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: -- Initialize temporary variable to hold xml data
645:
646: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 1015: WHEN FND_API.G_EXC_ERROR THEN

1011: '<<< ' || l_api_name);
1012: END IF;
1013:
1014: EXCEPTION
1015: WHEN FND_API.G_EXC_ERROR THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR ;

1012: END IF;
1013:
1014: EXCEPTION
1015: WHEN FND_API.G_EXC_ERROR THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR ;
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );

Line 1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1018: ( p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data);

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: p_data => x_msg_data
1020: );
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024: FND_MSG_PUB.Count_And_Get
1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1025: ( p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: WHEN OTHERS THEN
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: IF (l_uLog) THEN
1031: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1032: l_module || '.' || l_stmt_num,
1033: SUBSTRB (SQLERRM , 1 , 240));