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 20: x_return_status := fnd_api.g_ret_sts_success;

16: x_msg_data OUT NOCOPY VARCHAR2)
17: return VARCHAR2 is
18: begin
19:
20: x_return_status := fnd_api.g_ret_sts_success;
21:
22: if qty_precision = 0 then return('999G999G999G990');
23:
24: elsif qty_precision = 1 then return('999G999G999G990D0');

Line 56: x_return_status := FND_API.g_ret_sts_unexp_error;

52: end if;
53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: x_return_status := FND_API.g_ret_sts_unexp_error;
57: x_msg_data := SQLERRM;
58: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
59: p_data => x_msg_data);
60: fnd_file.put_line(FND_FILE.LOG,'Error in: CST_UninvoicedReceipts_PVT.get_qty_precision()');

Line 179: l_return_status := FND_API.G_RET_STS_SUCCESS;

175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: FND_MSG_PUB.initialize;
177:
178: -- Initialize API return status to success
179: l_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: -- Check whether GL is installed
182: l_stmt_num := 10;
183: l_return := FND_INSTALLATION.GET_APP_INFO (

Line 237: p_init_msg_list => FND_API.G_FALSE,

233: ---------------------------------------------------------------------
234: l_stmt_num := 60;
235: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
236: p_api_version => 1.0,
237: p_init_msg_list => FND_API.G_FALSE,
238: p_commit => FND_API.G_FALSE,
239: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
240: x_return_status => l_return_status,
241: x_msg_count => l_msg_count,

Line 238: p_commit => FND_API.G_FALSE,

234: l_stmt_num := 60;
235: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
236: p_api_version => 1.0,
237: p_init_msg_list => FND_API.G_FALSE,
238: p_commit => FND_API.G_FALSE,
239: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
240: x_return_status => l_return_status,
241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data,

Line 239: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

235: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
236: p_api_version => 1.0,
237: p_init_msg_list => FND_API.G_FALSE,
238: p_commit => FND_API.G_FALSE,
239: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
240: x_return_status => l_return_status,
241: x_msg_count => l_msg_count,
242: x_msg_data => l_msg_data,
243: p_min_accrual_amount => p_min_accrual_amount,

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

251: p_closed_pos => NVL(p_inc_closed_pos, 'N'),
252: p_calling_api => CST_PerEndAccruals_PVT.G_UNINVOICED_RECEIPT_REPORT
253: );
254: -- If return status is not success, add message to the log
255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
256: l_msg_data := 'Failed generating Period End Accrual information';
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253: );
254: -- If return status is not success, add message to the log
255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
256: l_msg_data := 'Failed generating Period End Accrual information';
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:
260: l_stmt_num := 90;
261: DBMS_LOB.createtemporary(l_xml_header, TRUE);

Line 326: if(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

322: qty_precision => p_qty_precision,
323: x_return_status => l_return_status,
324: x_msg_count => l_msg_count,
325: x_msg_data => l_msg_data);
326: if(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
327: l_msg_data := 'Failed getting qty precision';
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: x_msg_count => l_msg_count,
325: x_msg_data => l_msg_data);
326: if(l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
327: l_msg_data := 'Failed getting qty precision';
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: l_stmt_num := 110;
332: OPEN l_header_ref_cur FOR

Line 374: p_init_msg_list => FND_API.G_FALSE,

370: -- Generate XML data for header part
371: l_stmt_num := 120;
372: Generate_XML (
373: p_api_version => 1.0,
374: p_init_msg_list => FND_API.G_FALSE,
375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
376: x_return_status => l_return_status,
377: x_msg_count => l_msg_count,
378: x_msg_data => l_msg_data,

Line 375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

371: l_stmt_num := 120;
372: Generate_XML (
373: p_api_version => 1.0,
374: p_init_msg_list => FND_API.G_FALSE,
375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
376: x_return_status => l_return_status,
377: x_msg_count => l_msg_count,
378: x_msg_data => l_msg_data,
379: p_ref_cur => l_header_ref_cur,

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

381: p_row_set_tag => l_row_set_tag,
382: x_xml_data => l_xml_header
383: );
384: -- If return status is not success, add message to the log
385: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
386: l_msg_data := 'Failed generating XML data to the report output' ;
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: );
384: -- If return status is not success, add message to the log
385: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
386: l_msg_data := 'Failed generating XML data to the report output' ;
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: -- If row_count is 0, no need to open body_ref_cursor
391: IF (l_row_count > 0) THEN

Line 488: p_init_msg_list => FND_API.G_FALSE,

484: -- Generate XML data for report body
485: l_stmt_num := 150;
486: Generate_XML (
487: p_api_version => 1.0,
488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: x_return_status => l_return_status,
491: x_msg_count => l_msg_count,
492: x_msg_data => l_msg_data,

Line 489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

485: l_stmt_num := 150;
486: Generate_XML (
487: p_api_version => 1.0,
488: p_init_msg_list => FND_API.G_FALSE,
489: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
490: x_return_status => l_return_status,
491: x_msg_count => l_msg_count,
492: x_msg_data => l_msg_data,
493: p_ref_cur => l_body_ref_cur,

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

495: p_row_set_tag => l_row_set_tag,
496: x_xml_data => l_xml_body
497: );
498: -- If return status is not success, add message to the log
499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
500: l_msg_data := 'Failed generating XML data to the report output' ;
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497: );
498: -- If return status is not success, add message to the log
499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
500: l_msg_data := 'Failed generating XML data to the report output' ;
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: END IF;
505:

Line 512: p_init_msg_list => FND_API.G_FALSE,

508: l_stmt_num := 160;
509: Merge_XML
510: (
511: p_api_version => 1.0,
512: p_init_msg_list => FND_API.G_FALSE,
513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
514: x_return_status => l_return_status,
515: x_msg_count => l_msg_count,
516: x_msg_data => l_msg_data,

Line 513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

509: Merge_XML
510: (
511: p_api_version => 1.0,
512: p_init_msg_list => FND_API.G_FALSE,
513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
514: x_return_status => l_return_status,
515: x_msg_count => l_msg_count,
516: x_msg_data => l_msg_data,
517: p_xml_src1 => l_xml_header,

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

519: p_root_tag => 'ACR_REPORT',
520: x_xml_doc => l_xml_report
521: );
522: -- If return status is not success, add message to the log
523: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
524: l_msg_data := 'Failed generating XML data to the report output' ;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521: );
522: -- If return status is not success, add message to the log
523: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
524: l_msg_data := 'Failed generating XML data to the report output' ;
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: -- Print the XML data to the report output
529: l_stmt_num := 170;

Line 532: p_init_msg_list => FND_API.G_FALSE,

528: -- Print the XML data to the report output
529: l_stmt_num := 170;
530: Print_ClobOutput(
531: p_api_version => 1.0,
532: p_init_msg_list => FND_API.G_FALSE,
533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
534: x_return_status => l_return_status,
535: x_msg_count => l_msg_count,
536: x_msg_data => l_msg_data,

Line 533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

529: l_stmt_num := 170;
530: Print_ClobOutput(
531: p_api_version => 1.0,
532: p_init_msg_list => FND_API.G_FALSE,
533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
534: x_return_status => l_return_status,
535: x_msg_count => l_msg_count,
536: x_msg_data => l_msg_data,
537: p_xml_data => l_xml_report

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

536: x_msg_data => l_msg_data,
537: p_xml_data => l_xml_report
538: );
539: -- If return status is not success, add message to the log
540: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
541: l_msg_data := 'Failed writing XML data to the report output' ;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;
544:

Line 542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: );
539: -- If return status is not success, add message to the log
540: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
541: l_msg_data := 'Failed writing XML data to the report output' ;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;
544:
545: -- Write log messages to request log
546: l_stmt_num := 180;

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

550: p_msg_data => l_msg_data,
551: x_return_status => l_return_status
552: );
553: -- If return status is not success, add message to the log
554: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
555: l_msg_data := 'Failed writing log messages' ;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: );
553: -- If return status is not success, add message to the log
554: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
555: l_msg_data := 'Failed writing log messages' ;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559: -- Procedure level log message for exit point
560: IF (l_pLog) THEN

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

565: );
566: END IF;
567:
568: EXCEPTION
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570:
571: IF (l_exceptionLog) THEN
572: FND_LOG.STRING(
573: FND_LOG.LEVEL_EXCEPTION,

Line 673: IF NOT FND_API.Compatible_API_Call ( l_api_version,

669: 'Generate_XML <<');
670: END IF;
671:
672: -- Standard call to check for call compatibility.
673: IF NOT FND_API.Compatible_API_Call ( l_api_version,
674: p_api_version,
675: l_api_name,
676: G_PKG_NAME )
677: THEN

Line 678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

674: p_api_version,
675: l_api_name,
676: G_PKG_NAME )
677: THEN
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END IF;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 682: IF FND_API.to_Boolean( p_init_msg_list ) THEN

678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END IF;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF FND_API.to_Boolean( p_init_msg_list ) THEN
683: FND_MSG_PUB.initialize;
684: END IF;
685:
686: -- Initialize API return status to success

Line 687: x_return_status := FND_API.G_RET_STS_SUCCESS;

683: FND_MSG_PUB.initialize;
684: END IF;
685:
686: -- Initialize API return status to success
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: l_return_status := FND_API.G_RET_STS_SUCCESS;
689:
690: -- create a new context with the SQL query
691: l_stmt_num := 10;

Line 688: l_return_status := FND_API.G_RET_STS_SUCCESS;

684: END IF;
685:
686: -- Initialize API return status to success
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: l_return_status := FND_API.G_RET_STS_SUCCESS;
689:
690: -- create a new context with the SQL query
691: l_stmt_num := 10;
692: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);

Line 724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

720: );
721:
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
726:
727: FND_MSG_PUB.Count_And_Get
728: ( p_count => x_msg_count,

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

721:
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
726:
727: FND_MSG_PUB.Count_And_Get
728: ( p_count => x_msg_count,
729: p_data => x_msg_data

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

729: p_data => x_msg_data
730: );
731:
732: WHEN OTHERS THEN
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734:
735: -- Unexpected level log message
736: IF (l_uLog) THEN
737: FND_LOG.STRING(

Line 816: IF NOT FND_API.Compatible_API_Call ( l_api_version,

812: 'Merge_XML <<');
813: END IF;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT FND_API.Compatible_API_Call ( l_api_version,
817: p_api_version,
818: l_api_name,
819: G_PKG_NAME )
820: THEN

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817: p_api_version,
818: l_api_name,
819: G_PKG_NAME )
820: THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: -- Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 825: IF FND_API.to_Boolean( p_init_msg_list ) THEN

821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: -- Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean( p_init_msg_list ) THEN
826: FND_MSG_PUB.initialize;
827: END IF;
828:
829: -- Initialize API return status to success

Line 830: x_return_status := FND_API.G_RET_STS_SUCCESS;

826: FND_MSG_PUB.initialize;
827: END IF;
828:
829: -- Initialize API return status to success
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831: l_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: l_stmt_num := 10;
834: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);

Line 831: l_return_status := FND_API.G_RET_STS_SUCCESS;

827: END IF;
828:
829: -- Initialize API return status to success
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831: l_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: l_stmt_num := 10;
834: l_length_src1 := DBMS_LOB.GETLENGTH(p_xml_src1);
835: l_length_src2 := DBMS_LOB.GETLENGTH(p_xml_src2);

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: );
905:
906: EXCEPTION
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910:
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count,

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

905:
906: EXCEPTION
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910:
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count,
913: p_data => x_msg_data

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: p_data => x_msg_data
914: );
915:
916: WHEN OTHERS THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918:
919: -- Unexpected level log message
920: IF (l_uLog) THEN
921: FND_LOG.STRING(

Line 991: IF NOT FND_API.Compatible_API_Call ( l_api_version,

987: 'Print_ClobOutput <<');
988: END IF;
989:
990: -- Standard call to check for call compatibility.
991: IF NOT FND_API.Compatible_API_Call ( l_api_version,
992: p_api_version,
993: l_api_name,
994: G_PKG_NAME )
995: THEN

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: p_api_version,
993: l_api_name,
994: G_PKG_NAME )
995: THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998:
999: -- Initialize message list if p_init_msg_list is set to TRUE.
1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN

996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998:
999: -- Initialize message list if p_init_msg_list is set to TRUE.
1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: -- Initialize API return status to success

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: -- Initialize API return status to success
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: l_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: -- Get length of the CLOB p_xml_data
1009: l_stmt_num := 10;

Line 1006: l_return_status := FND_API.G_RET_STS_SUCCESS;

1002: END IF;
1003:
1004: -- Initialize API return status to success
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: l_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: -- Get length of the CLOB p_xml_data
1009: l_stmt_num := 10;
1010: l_length := nvl(DBMS_LOB.getlength(p_xml_data), 0);

Line 1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1047: );
1048:
1049: EXCEPTION
1050:
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053:
1054: FND_MSG_PUB.Count_And_Get
1055: ( p_count => x_msg_count,

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1048:
1049: EXCEPTION
1050:
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053:
1054: FND_MSG_PUB.Count_And_Get
1055: ( p_count => x_msg_count,
1056: p_data => x_msg_data

Line 1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1056: p_data => x_msg_data
1057: );
1058:
1059: WHEN OTHERS THEN
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061:
1062: -- Unexpected level log message
1063: IF (l_uLog) THEN
1064: FND_LOG.STRING(