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

Line 442: l_commit CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

438: l_conc_request BOOLEAN;
439:
440: l_api_version CONSTANT NUMBER := 1.0;
441: l_init_message_list CONSTANT VARCHAR2(10) := 'FALSE';
442: l_commit CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
443:
444: l_call_error VARCHAR2(400);
445:
446: l_err_data VARCHAR2(2400);

Line 467: l_err_status := fnd_api.g_ret_sts_success;

463: debug('start_accrual_load +');
464:
465: l_stmt_num := 5;
466:
467: l_err_status := fnd_api.g_ret_sts_success;
468: l_err_ret_status := fnd_api.g_ret_sts_success;
469:
470: debug(' l_stmt_num :' || l_stmt_num);
471: debug(' p_from_date :' || p_from_date);

Line 468: l_err_ret_status := fnd_api.g_ret_sts_success;

464:
465: l_stmt_num := 5;
466:
467: l_err_status := fnd_api.g_ret_sts_success;
468: l_err_ret_status := fnd_api.g_ret_sts_success;
469:
470: debug(' l_stmt_num :' || l_stmt_num);
471: debug(' p_from_date :' || p_from_date);
472: debug(' p_to_date :' || p_to_date);

Line 500: RAISE fnd_api.g_exc_unexpected_error;

496: debug(' accrual_load - l_err_data :'||l_err_data);
497:
498:
499: IF l_err_count IS NOT NULL AND l_err_count > 0 THEN
500: RAISE fnd_api.g_exc_unexpected_error;
501: END IF;
502:
503: l_stmt_num := 10;
504:

Line 509: WHEN FND_API.g_exc_unexpected_error THEN

505: debug('start_accrual_load-');
506:
507: EXCEPTION
508:
509: WHEN FND_API.g_exc_unexpected_error THEN
510: ROLLBACK;
511: debug('EXCEPTION FND_API.g_exc_unexpected_error IN Start_accrual_load');
512: debug(' l_stmt_num :'||l_stmt_num);
513: debug(' l_err_status:'||l_err_status);

Line 511: debug('EXCEPTION FND_API.g_exc_unexpected_error IN Start_accrual_load');

507: EXCEPTION
508:
509: WHEN FND_API.g_exc_unexpected_error THEN
510: ROLLBACK;
511: debug('EXCEPTION FND_API.g_exc_unexpected_error IN Start_accrual_load');
512: debug(' l_stmt_num :'||l_stmt_num);
513: debug(' l_err_status:'||l_err_status);
514: debug(' l_err_count :'||l_err_count);
515: debug(' l_err_data :'||l_err_data);

Line 641: IF NOT FND_API.Compatible_API_Call (

637: l_stmt_num := 5;
638:
639: debug(' l_stmt_num:'||l_stmt_num);
640: -- Standard call to check for call compatibility
641: IF NOT FND_API.Compatible_API_Call (
642: l_api_version,
643: p_api_version,
644: l_api_name,
645: G_PKG_NAME

Line 647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: p_api_version,
644: l_api_name,
645: G_PKG_NAME
646: ) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: x_return_status := fnd_api.g_ret_sts_success;
651:

Line 650: x_return_status := fnd_api.g_ret_sts_success;

646: ) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649:
650: x_return_status := fnd_api.g_ret_sts_success;
651:
652: /* check for incompatibility. If there is another load running for the same OU,error out this one */
653:
654: SELECT FCR.argument1 into l_req_arg

Line 675: RAISE fnd_api.g_exc_error;

671:
672: IF (l_req_running > 1) THEN /* More than one running, so error this one out*/
673: l_error_message := 'CST_ACC_ERROR';
674: fnd_message.set_name('BOM','CST_ACC_ERROR');
675: RAISE fnd_api.g_exc_error;
676: END IF;
677:
678:
679: l_stmt_num := 10;

Line 696: RAISE fnd_api.g_exc_error;

692:
693: IF l_acc_accounts = 0 THEN
694: l_error_message := 'CST_ACC_ACCOUNTS_ERR';
695: fnd_message.set_name('BOM','CST_ACC_ACCOUNTS_ERR');
696: RAISE fnd_api.g_exc_error;
697: END IF;
698:
699: l_stmt_num := 20;
700: debug(' l_stmt_num:'||l_stmt_num);

Line 763: RAISE fnd_api.g_exc_error;

759:
760: IF l_p_from_date > l_to_date THEN
761: l_error_message := 'CST_INVALID_TO_DATE';
762: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
763: RAISE fnd_api.g_exc_error;
764: ELSE
765: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
766: fnd_message.set_token('MESSAGE','Calculated from_date:'||
767: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||

Line 794: If l_err_status <> FND_API.G_RET_STS_SUCCESS then

790: x_msg_count => l_err_count,
791: x_msg_data => l_err_data,
792: x_return_status => l_err_status);
793:
794: If l_err_status <> FND_API.G_RET_STS_SUCCESS then
795:
796: debug(' Upgrade_old_data API fails with ');
797: debug(' x_msg_count = '||l_err_count);
798: debug(' x_msg_data = '||l_err_data);

Line 800: RAISE fnd_api.g_exc_unexpected_error;

796: debug(' Upgrade_old_data API fails with ');
797: debug(' x_msg_count = '||l_err_count);
798: debug(' x_msg_data = '||l_err_data);
799: debug(' x_return_status = '||l_err_status );
800: RAISE fnd_api.g_exc_unexpected_error;
801:
802: END IF; --check of l_err_status
803:
804:

Line 822: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

818: x_msg_data => l_err_data,
819: x_return_status => l_err_status
820: );
821:
822: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
823: IF l_exceptionLog THEN
824: l_call_error := 'Insert_build_parameters API fails with '
825: ||'x_msg_count = '||to_char(l_err_count)
826: ||'x_msg_data = '||l_err_data

Line 830: RAISE fnd_api.g_exc_unexpected_error;

826: ||'x_msg_data = '||l_err_data
827: ||'x_return_status = '||l_err_status ;
828: END IF;
829: debug(l_call_error);
830: RAISE fnd_api.g_exc_unexpected_error;
831: END IF;
832:
833:
834: -- Added for bug 7528609 so that upgrade data is committed

Line 873: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

869: x_msg_data => l_err_data,
870: x_return_status => l_err_status
871: );
872:
873: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
874:
875: debug('Load_ap_po_data API fails with ');
876: debug(' x_msg_count : '||l_err_count);
877: debug(' x_msg_data : '||l_err_data);

Line 879: RAISE fnd_api.g_exc_unexpected_error;

875: debug('Load_ap_po_data API fails with ');
876: debug(' x_msg_count : '||l_err_count);
877: debug(' x_msg_data : '||l_err_data);
878: debug(' x_return_status : '||l_err_status);
879: RAISE fnd_api.g_exc_unexpected_error;
880:
881: END IF;
882:
883:

Line 897: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

893: x_return_status => l_err_status
894: );
895:
896:
897: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
898: debug('Load_ap_misc_data API fails with ');
899: debug(' x_msg_count :'||to_char(l_err_count));
900: debug(' x_msg_data :'||l_err_data);
901: debug(' x_return_status :'||l_err_status);

Line 903: RAISE fnd_api.g_exc_unexpected_error;

899: debug(' x_msg_count :'||to_char(l_err_count));
900: debug(' x_msg_data :'||l_err_data);
901: debug(' x_return_status :'||l_err_status);
902: debug(l_call_error);
903: RAISE fnd_api.g_exc_unexpected_error;
904: END IF;
905:
906:
907: l_stmt_num := 90;

Line 935: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

931: x_return_status => l_err_status
932: );
933:
934:
935: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
936: debug('Load_inv_misc_data API fails with ');
937: debug(' x_msg_count : '||l_err_count);
938: debug(' x_msg_data : '||l_err_data);
939: debug(' x_return_status : '||l_err_status );

Line 940: RAISE fnd_api.g_exc_unexpected_error;

936: debug('Load_inv_misc_data API fails with ');
937: debug(' x_msg_count : '||l_err_count);
938: debug(' x_msg_data : '||l_err_data);
939: debug(' x_return_status : '||l_err_status );
940: RAISE fnd_api.g_exc_unexpected_error;
941: END IF;
942: END IF;
943:
944: --- Standard check of p_commit

Line 945: IF FND_API.to_Boolean(p_commit) THEN

941: END IF;
942: END IF;
943:
944: --- Standard check of p_commit
945: IF FND_API.to_Boolean(p_commit) THEN
946: COMMIT WORK;
947: END IF;
948:
949: debug('accrual_load-');

Line 952: WHEN FND_API.g_exc_error THEN

948:
949: debug('accrual_load-');
950:
951: EXCEPTION
952: WHEN FND_API.g_exc_error THEN
953: ROLLBACK;
954: x_return_status := FND_API.g_ret_sts_error;
955: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
956: debug('l_stmt_num :'||l_stmt_num);

Line 954: x_return_status := FND_API.g_ret_sts_error;

950:
951: EXCEPTION
952: WHEN FND_API.g_exc_error THEN
953: ROLLBACK;
954: x_return_status := FND_API.g_ret_sts_error;
955: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
956: debug('l_stmt_num :'||l_stmt_num);
957: FND_MSG_PUB.count_and_get
958: ( p_count => x_msg_count

Line 955: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');

951: EXCEPTION
952: WHEN FND_API.g_exc_error THEN
953: ROLLBACK;
954: x_return_status := FND_API.g_ret_sts_error;
955: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
956: debug('l_stmt_num :'||l_stmt_num);
957: FND_MSG_PUB.count_and_get
958: ( p_count => x_msg_count
959: , p_data => x_msg_data

Line 967: WHEN FND_API.g_exc_unexpected_error THEN

963:
964: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||' in accrual_load - statement:'||l_stmt_num);
965:
966:
967: WHEN FND_API.g_exc_unexpected_error THEN
968: ROLLBACK;
969: x_return_status := FND_API.g_ret_sts_unexp_error ;
970: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
971: debug('l_stmt_num :'||l_stmt_num);

Line 969: x_return_status := FND_API.g_ret_sts_unexp_error ;

965:
966:
967: WHEN FND_API.g_exc_unexpected_error THEN
968: ROLLBACK;
969: x_return_status := FND_API.g_ret_sts_unexp_error ;
970: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
971: debug('l_stmt_num :'||l_stmt_num);
972:
973: FND_MSG_PUB.count_and_get

Line 970: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');

966:
967: WHEN FND_API.g_exc_unexpected_error THEN
968: ROLLBACK;
969: x_return_status := FND_API.g_ret_sts_unexp_error ;
970: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
971: debug('l_stmt_num :'||l_stmt_num);
972:
973: FND_MSG_PUB.count_and_get
974: ( p_count => x_msg_count

Line 985: x_return_status := FND_API.g_ret_sts_success;

981:
982: WHEN stop_here THEN
983:
984: ROLLBACK;
985: x_return_status := FND_API.g_ret_sts_success;
986: debug('Stop here IN accrual_load');
987: debug('l_stmt_num :'||l_stmt_num);
988: FND_MSG_PUB.count_and_get
989: ( p_count => x_msg_count

Line 999: x_return_status := FND_API.g_ret_sts_unexp_error ;

995:
996: WHEN OTHERS THEN
997:
998: ROLLBACK;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: fnd_message.set_name('BOM','CST_UNEXPECTED');
1001: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
1002: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
1003: debug('l_stmt_num:'||l_stmt_num);

Line 1083: x_return_status := fnd_api.g_ret_sts_success;

1079: debug(' p_upg_from_date : ' || TO_CHAR(p_upg_from_date,'YYYY/MM/DD HH24:MI:SS'));
1080: debug(' p_upg_to_date : ' || TO_CHAR(p_upg_to_date,'YYYY/MM/DD HH24:MI:SS'));
1081:
1082:
1083: x_return_status := fnd_api.g_ret_sts_success;
1084:
1085: /* Upgrade PO data. We are joining on the sub ledger tables directly to get the entered amounts
1086: as data for pre 11.5.10 may not have the entered columns populated in the old write off table */
1087:

Line 2165: x_return_status := FND_API.g_ret_sts_unexp_error ;

2161: EXCEPTION
2162:
2163: WHEN OTHERS THEN
2164: rollback;
2165: x_return_status := FND_API.g_ret_sts_unexp_error ;
2166: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2167: fnd_message.set_name('BOM','CST_UNEXPECTED');
2168: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2169: debug('l_stmt_num:'||l_stmt_num);

Line 2252: x_return_status := fnd_api.g_ret_sts_success;

2248:
2249: l_stmt_num := 10;
2250: debug(' l_stmt_num :'||l_stmt_num );
2251:
2252: x_return_status := fnd_api.g_ret_sts_success;
2253:
2254: xla_security_pkg.set_security_context(p_application_id => 200);
2255:
2256: /* Get all the CONC WHO columns */

Line 2471: x_return_status := FND_API.g_ret_sts_unexp_error ;

2467: EXCEPTION
2468:
2469: WHEN OTHERS THEN
2470: rollback;
2471: x_return_status := FND_API.g_ret_sts_unexp_error ;
2472: fnd_message.set_name('BOM','CST_UNEXPECTED');
2473: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2474: debug('l_stmt_num :'||l_stmt_num);
2475: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));

Line 2563: x_return_status := fnd_api.g_ret_sts_success;

2559: debug(' p_to_date : ' || to_char(p_to_date,'DD-MON-YYYY HH24:MI:SS'));
2560: debug(' p_round_unit : ' || p_round_unit);
2561: l_stmt_num := 10;
2562: debug(' l_stmt_num :'|| l_stmt_num);
2563: x_return_status := fnd_api.g_ret_sts_success;
2564:
2565:
2566: xla_security_pkg.set_security_context(p_application_id => 707);
2567:

Line 2942: x_return_status := FND_API.g_ret_sts_unexp_error ;

2938: EXCEPTION
2939:
2940: WHEN OTHERS THEN
2941: rollback;
2942: x_return_status := FND_API.g_ret_sts_unexp_error ;
2943: fnd_message.set_name('BOM','CST_UNEXPECTED');
2944: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2945: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
2946: debug('l_stmt_num :'||l_stmt_num);

Line 3007: x_return_status := fnd_api.g_ret_sts_success;

3003: debug(' p_to_date : ' || to_char(p_to_date,'DD-MON-YYYY HH24:MI:SS'));
3004:
3005: l_stmt_num := 10;
3006: debug(' l_stmt_num :'||l_stmt_num);
3007: x_return_status := fnd_api.g_ret_sts_success;
3008:
3009:
3010: INSERT into CST_RECONCILIATION_BUILD(
3011: build_id,

Line 3046: x_return_status := FND_API.g_ret_sts_unexp_error ;

3042: EXCEPTION
3043:
3044: WHEN OTHERS THEN
3045: rollback;
3046: x_return_status := FND_API.g_ret_sts_unexp_error ;
3047: fnd_message.set_name('BOM','CST_UNEXPECTED');
3048: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3049: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3050: debug('l_stmt_num :'||l_stmt_num);

Line 3948: x_return_status := FND_API.g_ret_sts_unexp_error ;

3944:
3945: WHEN OTHERS THEN
3946: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
3947: CLOSE c_po_dists;
3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: fnd_message.set_name('BOM','CST_UNEXPECTED');
3950: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3951: ROLLBACK;
3952: fnd_msg_pub.add;