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

Line 120: l_return_status := FND_API.G_RET_STS_SUCCESS;

116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: FND_MSG_PUB.initialize;
118:
119: -- Initialize API return status to success
120: l_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: -- Check whether GL is installed
123: l_stmt_num := 10;
124: l_return := FND_INSTALLATION.GET_APP_INFO (

Line 177: p_init_msg_list => FND_API.G_FALSE,

173: ---------------------------------------------------------------------
174: l_stmt_num := 60;
175: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
176: p_api_version => 1.0,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => l_msg_count,

Line 178: p_commit => FND_API.G_FALSE,

174: l_stmt_num := 60;
175: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
176: p_api_version => 1.0,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => l_msg_count,
182: x_msg_data => l_msg_data,

Line 179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

175: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
176: p_api_version => 1.0,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: x_return_status => l_return_status,
181: x_msg_count => l_msg_count,
182: x_msg_data => l_msg_data,
183: p_min_accrual_amount => p_min_accrual_amount,

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

191: p_closed_pos => NVL(p_inc_closed_pos, 'N'),
192: p_calling_api => CST_PerEndAccruals_PVT.G_UNINVOICED_RECEIPT_REPORT
193: );
194: -- If return status is not success, add message to the log
195: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
196: l_msg_data := 'Failed generating Period End Accrual information';
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: );
194: -- If return status is not success, add message to the log
195: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
196: l_msg_data := 'Failed generating Period End Accrual information';
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: l_stmt_num := 90;
201: DBMS_LOB.createtemporary(l_xml_header, TRUE);

Line 271: p_init_msg_list => FND_API.G_FALSE,

267: -- Generate XML data for header part
268: l_stmt_num := 120;
269: Generate_XML (
270: p_api_version => 1.0,
271: p_init_msg_list => FND_API.G_FALSE,
272: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
273: x_return_status => l_return_status,
274: x_msg_count => l_msg_count,
275: x_msg_data => l_msg_data,

Line 272: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

268: l_stmt_num := 120;
269: Generate_XML (
270: p_api_version => 1.0,
271: p_init_msg_list => FND_API.G_FALSE,
272: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
273: x_return_status => l_return_status,
274: x_msg_count => l_msg_count,
275: x_msg_data => l_msg_data,
276: p_ref_cur => l_header_ref_cur,

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

278: p_row_set_tag => l_row_set_tag,
279: x_xml_data => l_xml_header
280: );
281: -- If return status is not success, add message to the log
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
283: l_msg_data := 'Failed generating XML data to the report output' ;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:

Line 284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

280: );
281: -- If return status is not success, add message to the log
282: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
283: l_msg_data := 'Failed generating XML data to the report output' ;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: -- If row_count is 0, no need to open body_ref_cursor
288: IF (l_row_count > 0) THEN

Line 381: p_init_msg_list => FND_API.G_FALSE,

377: -- Generate XML data for report body
378: l_stmt_num := 150;
379: Generate_XML (
380: p_api_version => 1.0,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
383: x_return_status => l_return_status,
384: x_msg_count => l_msg_count,
385: x_msg_data => l_msg_data,

Line 382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

378: l_stmt_num := 150;
379: Generate_XML (
380: p_api_version => 1.0,
381: p_init_msg_list => FND_API.G_FALSE,
382: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
383: x_return_status => l_return_status,
384: x_msg_count => l_msg_count,
385: x_msg_data => l_msg_data,
386: p_ref_cur => l_body_ref_cur,

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

388: p_row_set_tag => l_row_set_tag,
389: x_xml_data => l_xml_body
390: );
391: -- If return status is not success, add message to the log
392: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
393: l_msg_data := 'Failed generating XML data to the report output' ;
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:

Line 394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

390: );
391: -- If return status is not success, add message to the log
392: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
393: l_msg_data := 'Failed generating XML data to the report output' ;
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: END IF;
398:

Line 405: p_init_msg_list => FND_API.G_FALSE,

401: l_stmt_num := 160;
402: Merge_XML
403: (
404: p_api_version => 1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
407: x_return_status => l_return_status,
408: x_msg_count => l_msg_count,
409: x_msg_data => l_msg_data,

Line 406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

402: Merge_XML
403: (
404: p_api_version => 1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
407: x_return_status => l_return_status,
408: x_msg_count => l_msg_count,
409: x_msg_data => l_msg_data,
410: p_xml_src1 => l_xml_header,

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

412: p_root_tag => 'ACR_REPORT',
413: x_xml_doc => l_xml_report
414: );
415: -- If return status is not success, add message to the log
416: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
417: l_msg_data := 'Failed generating XML data to the report output' ;
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: );
415: -- If return status is not success, add message to the log
416: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
417: l_msg_data := 'Failed generating XML data to the report output' ;
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420:
421: -- Print the XML data to the report output
422: l_stmt_num := 170;

Line 425: p_init_msg_list => FND_API.G_FALSE,

421: -- Print the XML data to the report output
422: l_stmt_num := 170;
423: Print_ClobOutput(
424: p_api_version => 1.0,
425: p_init_msg_list => FND_API.G_FALSE,
426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
427: x_return_status => l_return_status,
428: x_msg_count => l_msg_count,
429: x_msg_data => l_msg_data,

Line 426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

422: l_stmt_num := 170;
423: Print_ClobOutput(
424: p_api_version => 1.0,
425: p_init_msg_list => FND_API.G_FALSE,
426: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
427: x_return_status => l_return_status,
428: x_msg_count => l_msg_count,
429: x_msg_data => l_msg_data,
430: p_xml_data => l_xml_report

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

429: x_msg_data => l_msg_data,
430: p_xml_data => l_xml_report
431: );
432: -- If return status is not success, add message to the log
433: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
434: l_msg_data := 'Failed writing XML data to the report output' ;
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: );
432: -- If return status is not success, add message to the log
433: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
434: l_msg_data := 'Failed writing XML data to the report output' ;
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: -- Write log messages to request log
439: l_stmt_num := 180;

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

443: p_msg_data => l_msg_data,
444: x_return_status => l_return_status
445: );
446: -- If return status is not success, add message to the log
447: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
448: l_msg_data := 'Failed writing log messages' ;
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: );
446: -- If return status is not success, add message to the log
447: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
448: l_msg_data := 'Failed writing log messages' ;
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- Procedure level log message for exit point
453: IF (l_pLog) THEN

Line 462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

458: );
459: END IF;
460:
461: EXCEPTION
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: IF (l_exceptionLog) THEN
465: FND_LOG.STRING(
466: FND_LOG.LEVEL_EXCEPTION,

Line 566: IF NOT FND_API.Compatible_API_Call ( l_api_version,

562: 'Generate_XML <<');
563: END IF;
564:
565: -- Standard call to check for call compatibility.
566: IF NOT FND_API.Compatible_API_Call ( l_api_version,
567: p_api_version,
568: l_api_name,
569: G_PKG_NAME )
570: THEN

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

567: p_api_version,
568: l_api_name,
569: G_PKG_NAME )
570: THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 575: IF FND_API.to_Boolean( p_init_msg_list ) THEN

571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF FND_API.to_Boolean( p_init_msg_list ) THEN
576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581: l_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: -- create a new context with the SQL query
584: l_stmt_num := 10;

Line 581: l_return_status := FND_API.G_RET_STS_SUCCESS;

577: END IF;
578:
579: -- Initialize API return status to success
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581: l_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: -- create a new context with the SQL query
584: l_stmt_num := 10;
585: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: );
614:
615: EXCEPTION
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619:
620: FND_MSG_PUB.Count_And_Get
621: ( p_count => x_msg_count,

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

614:
615: EXCEPTION
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619:
620: FND_MSG_PUB.Count_And_Get
621: ( p_count => x_msg_count,
622: p_data => x_msg_data

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

622: p_data => x_msg_data
623: );
624:
625: WHEN OTHERS THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627:
628: -- Unexpected level log message
629: IF (l_uLog) THEN
630: FND_LOG.STRING(

Line 709: IF NOT FND_API.Compatible_API_Call ( l_api_version,

705: 'Merge_XML <<');
706: END IF;
707:
708: -- Standard call to check for call compatibility.
709: IF NOT FND_API.Compatible_API_Call ( l_api_version,
710: p_api_version,
711: l_api_name,
712: G_PKG_NAME )
713: THEN

Line 714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

710: p_api_version,
711: l_api_name,
712: G_PKG_NAME )
713: THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716:
717: -- Initialize message list if p_init_msg_list is set to TRUE.
718: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 718: IF FND_API.to_Boolean( p_init_msg_list ) THEN

714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716:
717: -- Initialize message list if p_init_msg_list is set to TRUE.
718: IF FND_API.to_Boolean( p_init_msg_list ) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: -- Initialize API return status to success

Line 723: x_return_status := FND_API.G_RET_STS_SUCCESS;

719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: -- Initialize API return status to success
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724: l_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: l_stmt_num := 10;
727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);

Line 724: l_return_status := FND_API.G_RET_STS_SUCCESS;

720: END IF;
721:
722: -- Initialize API return status to success
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724: l_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: l_stmt_num := 10;
727: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);
728: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);

Line 801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

797: );
798:
799: EXCEPTION
800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803:
804: FND_MSG_PUB.Count_And_Get
805: ( p_count => x_msg_count,

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

798:
799: EXCEPTION
800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803:
804: FND_MSG_PUB.Count_And_Get
805: ( p_count => x_msg_count,
806: p_data => x_msg_data

Line 810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

806: p_data => x_msg_data
807: );
808:
809: WHEN OTHERS THEN
810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811:
812: -- Unexpected level log message
813: IF (l_uLog) THEN
814: FND_LOG.STRING(

Line 884: IF NOT FND_API.Compatible_API_Call ( l_api_version,

880: 'Print_ClobOutput <<');
881: END IF;
882:
883: -- Standard call to check for call compatibility.
884: IF NOT FND_API.Compatible_API_Call ( l_api_version,
885: p_api_version,
886: l_api_name,
887: G_PKG_NAME )
888: THEN

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: p_api_version,
886: l_api_name,
887: G_PKG_NAME )
888: THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891:
892: -- Initialize message list if p_init_msg_list is set to TRUE.
893: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 893: IF FND_API.to_Boolean( p_init_msg_list ) THEN

889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891:
892: -- Initialize message list if p_init_msg_list is set to TRUE.
893: IF FND_API.to_Boolean( p_init_msg_list ) THEN
894: FND_MSG_PUB.initialize;
895: END IF;
896:
897: -- Initialize API return status to success

Line 898: x_return_status := FND_API.G_RET_STS_SUCCESS;

894: FND_MSG_PUB.initialize;
895: END IF;
896:
897: -- Initialize API return status to success
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899: l_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: -- Get length of the CLOB p_xml_data
902: l_stmt_num := 10;

Line 899: l_return_status := FND_API.G_RET_STS_SUCCESS;

895: END IF;
896:
897: -- Initialize API return status to success
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899: l_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: -- Get length of the CLOB p_xml_data
902: l_stmt_num := 10;
903: l_length := nvl(DBMS_LOB.getlength(p_xml_data), 0);

Line 944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

940: );
941:
942: EXCEPTION
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946:
947: FND_MSG_PUB.Count_And_Get
948: ( p_count => x_msg_count,

Line 945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

941:
942: EXCEPTION
943:
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946:
947: FND_MSG_PUB.Count_And_Get
948: ( p_count => x_msg_count,
949: p_data => x_msg_data

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: p_data => x_msg_data
950: );
951:
952: WHEN OTHERS THEN
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954:
955: -- Unexpected level log message
956: IF (l_uLog) THEN
957: FND_LOG.STRING(