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 453: l_commit CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

449: l_conc_request BOOLEAN;
450:
451: l_api_version CONSTANT NUMBER := 1.0;
452: l_init_message_list CONSTANT VARCHAR2(10) := 'FALSE';
453: l_commit CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
454:
455: l_call_error VARCHAR2(400);
456:
457: l_err_data VARCHAR2(2400);

Line 478: l_err_status := fnd_api.g_ret_sts_success;

474: debug('start_accrual_load +');
475:
476: l_stmt_num := 5;
477:
478: l_err_status := fnd_api.g_ret_sts_success;
479: l_err_ret_status := fnd_api.g_ret_sts_success;
480:
481: debug(' l_stmt_num :' || l_stmt_num);
482: debug(' p_from_date :' || p_from_date);

Line 479: l_err_ret_status := fnd_api.g_ret_sts_success;

475:
476: l_stmt_num := 5;
477:
478: l_err_status := fnd_api.g_ret_sts_success;
479: l_err_ret_status := fnd_api.g_ret_sts_success;
480:
481: debug(' l_stmt_num :' || l_stmt_num);
482: debug(' p_from_date :' || p_from_date);
483: debug(' p_to_date :' || p_to_date);

Line 511: RAISE fnd_api.g_exc_unexpected_error;

507: debug(' accrual_load - l_err_data :'||l_err_data);
508:
509:
510: IF l_err_count IS NOT NULL AND l_err_count > 0 THEN
511: RAISE fnd_api.g_exc_unexpected_error;
512: END IF;
513:
514: l_stmt_num := 10;
515:

Line 520: WHEN FND_API.g_exc_unexpected_error THEN

516: debug('start_accrual_load-');
517:
518: EXCEPTION
519:
520: WHEN FND_API.g_exc_unexpected_error THEN
521: ROLLBACK;
522: debug('EXCEPTION FND_API.g_exc_unexpected_error IN Start_accrual_load');
523: debug(' l_stmt_num :'||l_stmt_num);
524: debug(' l_err_status:'||l_err_status);

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

518: EXCEPTION
519:
520: WHEN FND_API.g_exc_unexpected_error THEN
521: ROLLBACK;
522: debug('EXCEPTION FND_API.g_exc_unexpected_error IN Start_accrual_load');
523: debug(' l_stmt_num :'||l_stmt_num);
524: debug(' l_err_status:'||l_err_status);
525: debug(' l_err_count :'||l_err_count);
526: debug(' l_err_data :'||l_err_data);

Line 625: IF NOT FND_API.Compatible_API_Call (

621: l_stmt_num := 5;
622:
623: debug(' l_stmt_num:'||l_stmt_num);
624: -- Standard call to check for call compatibility
625: IF NOT FND_API.Compatible_API_Call (
626: l_api_version,
627: p_api_version,
628: l_api_name,
629: G_PKG_NAME

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

Line 634: x_return_status := fnd_api.g_ret_sts_success;

630: ) THEN
631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
632: END IF;
633:
634: x_return_status := fnd_api.g_ret_sts_success;
635:
636: /* check for incompatibility. If there is another load running for the same OU,error out this one */
637: --{BUG 12625738
638: /*SELECT FCR.argument1 into l_req_arg

Line 667: RAISE fnd_api.g_exc_error;

663:
664: IF (l_req_running > 1) THEN /* More than one running, so error this one out*/
665: l_error_message := 'CST_ACC_ERROR';
666: fnd_message.set_name('BOM','CST_ACC_ERROR');
667: RAISE fnd_api.g_exc_error;
668: END IF;
669:
670:
671: l_stmt_num := 10;

Line 688: RAISE fnd_api.g_exc_error;

684:
685: IF l_acc_accounts = 0 THEN
686: l_error_message := 'CST_ACC_ACCOUNTS_ERR';
687: fnd_message.set_name('BOM','CST_ACC_ACCOUNTS_ERR');
688: RAISE fnd_api.g_exc_error;
689: END IF;
690:
691: l_stmt_num := 20;
692: debug(' l_stmt_num:'||l_stmt_num);

Line 755: RAISE fnd_api.g_exc_error;

751:
752: IF l_p_from_date > l_to_date THEN
753: l_error_message := 'CST_INVALID_TO_DATE';
754: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
755: RAISE fnd_api.g_exc_error;
756: ELSE
757: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
758: fnd_message.set_token('MESSAGE','Calculated from_date:'||
759: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||

Line 786: If l_err_status <> FND_API.G_RET_STS_SUCCESS then

782: x_msg_count => l_err_count,
783: x_msg_data => l_err_data,
784: x_return_status => l_err_status);
785:
786: If l_err_status <> FND_API.G_RET_STS_SUCCESS then
787:
788: debug(' Upgrade_old_data API fails with ');
789: debug(' x_msg_count = '||l_err_count);
790: debug(' x_msg_data = '||l_err_data);

Line 792: RAISE fnd_api.g_exc_unexpected_error;

788: debug(' Upgrade_old_data API fails with ');
789: debug(' x_msg_count = '||l_err_count);
790: debug(' x_msg_data = '||l_err_data);
791: debug(' x_return_status = '||l_err_status );
792: RAISE fnd_api.g_exc_unexpected_error;
793:
794: END IF; --check of l_err_status
795:
796:

Line 814: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

810: x_msg_data => l_err_data,
811: x_return_status => l_err_status
812: );
813:
814: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
815: IF l_exceptionLog THEN
816: l_call_error := 'Insert_build_parameters API fails with '
817: ||'x_msg_count = '||to_char(l_err_count)
818: ||'x_msg_data = '||l_err_data

Line 822: RAISE fnd_api.g_exc_unexpected_error;

818: ||'x_msg_data = '||l_err_data
819: ||'x_return_status = '||l_err_status ;
820: END IF;
821: debug(l_call_error);
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824:
825:
826: -- Added for bug 7528609 so that upgrade data is committed

Line 865: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

861: x_msg_data => l_err_data,
862: x_return_status => l_err_status
863: );
864:
865: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
866:
867: debug('Load_ap_po_data API fails with ');
868: debug(' x_msg_count : '||l_err_count);
869: debug(' x_msg_data : '||l_err_data);

Line 871: RAISE fnd_api.g_exc_unexpected_error;

867: debug('Load_ap_po_data API fails with ');
868: debug(' x_msg_count : '||l_err_count);
869: debug(' x_msg_data : '||l_err_data);
870: debug(' x_return_status : '||l_err_status);
871: RAISE fnd_api.g_exc_unexpected_error;
872:
873: END IF;
874:
875:

Line 889: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

885: x_return_status => l_err_status
886: );
887:
888:
889: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
890: debug('Load_ap_misc_data API fails with ');
891: debug(' x_msg_count :'||to_char(l_err_count));
892: debug(' x_msg_data :'||l_err_data);
893: debug(' x_return_status :'||l_err_status);

Line 895: RAISE fnd_api.g_exc_unexpected_error;

891: debug(' x_msg_count :'||to_char(l_err_count));
892: debug(' x_msg_data :'||l_err_data);
893: debug(' x_return_status :'||l_err_status);
894: debug(l_call_error);
895: RAISE fnd_api.g_exc_unexpected_error;
896: END IF;
897:
898:
899: l_stmt_num := 90;

Line 912: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN

908: x_return_status => l_err_status
909: );
910:
911:
912: IF l_err_status <> FND_API.G_RET_STS_SUCCESS THEN
913: debug('Load_inv_misc_data API fails with ');
914: debug(' x_msg_count : '||l_err_count);
915: debug(' x_msg_data : '||l_err_data);
916: debug(' x_return_status : '||l_err_status );

Line 917: RAISE fnd_api.g_exc_unexpected_error;

913: debug('Load_inv_misc_data API fails with ');
914: debug(' x_msg_count : '||l_err_count);
915: debug(' x_msg_data : '||l_err_data);
916: debug(' x_return_status : '||l_err_status );
917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;
919:
920: --- Standard check of p_commit
921: IF FND_API.to_Boolean(p_commit) THEN

Line 921: IF FND_API.to_Boolean(p_commit) THEN

917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;
919:
920: --- Standard check of p_commit
921: IF FND_API.to_Boolean(p_commit) THEN
922: COMMIT WORK;
923: END IF;
924:
925: debug('accrual_load-');

Line 928: WHEN FND_API.g_exc_error THEN

924:
925: debug('accrual_load-');
926:
927: EXCEPTION
928: WHEN FND_API.g_exc_error THEN
929: ROLLBACK;
930: x_return_status := FND_API.g_ret_sts_error;
931: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
932: debug('l_stmt_num :'||l_stmt_num);

Line 930: x_return_status := FND_API.g_ret_sts_error;

926:
927: EXCEPTION
928: WHEN FND_API.g_exc_error THEN
929: ROLLBACK;
930: x_return_status := FND_API.g_ret_sts_error;
931: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
932: debug('l_stmt_num :'||l_stmt_num);
933: FND_MSG_PUB.count_and_get
934: ( p_count => x_msg_count

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

927: EXCEPTION
928: WHEN FND_API.g_exc_error THEN
929: ROLLBACK;
930: x_return_status := FND_API.g_ret_sts_error;
931: debug('EXCEPTION FND_API.g_exc_error IN accrual_load');
932: debug('l_stmt_num :'||l_stmt_num);
933: FND_MSG_PUB.count_and_get
934: ( p_count => x_msg_count
935: , p_data => x_msg_data

Line 943: WHEN FND_API.g_exc_unexpected_error THEN

939:
940: l_conc_request := fnd_concurrent.set_completion_status('ERROR',SUBSTRB(x_msg_data,1,140)||' in accrual_load - statement:'||l_stmt_num);
941:
942:
943: WHEN FND_API.g_exc_unexpected_error THEN
944: ROLLBACK;
945: x_return_status := FND_API.g_ret_sts_unexp_error ;
946: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
947: debug('l_stmt_num :'||l_stmt_num);

Line 945: x_return_status := FND_API.g_ret_sts_unexp_error ;

941:
942:
943: WHEN FND_API.g_exc_unexpected_error THEN
944: ROLLBACK;
945: x_return_status := FND_API.g_ret_sts_unexp_error ;
946: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
947: debug('l_stmt_num :'||l_stmt_num);
948:
949: FND_MSG_PUB.count_and_get

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

942:
943: WHEN FND_API.g_exc_unexpected_error THEN
944: ROLLBACK;
945: x_return_status := FND_API.g_ret_sts_unexp_error ;
946: debug('EXCEPTION FND_API.g_exc_unexpected_error IN accrual_load');
947: debug('l_stmt_num :'||l_stmt_num);
948:
949: FND_MSG_PUB.count_and_get
950: ( p_count => x_msg_count

Line 961: x_return_status := FND_API.g_ret_sts_success;

957:
958: WHEN stop_here THEN
959:
960: ROLLBACK;
961: x_return_status := FND_API.g_ret_sts_success;
962: debug('Stop here IN accrual_load');
963: debug('l_stmt_num :'||l_stmt_num);
964: FND_MSG_PUB.count_and_get
965: ( p_count => x_msg_count

Line 975: x_return_status := FND_API.g_ret_sts_unexp_error ;

971:
972: WHEN OTHERS THEN
973:
974: ROLLBACK;
975: x_return_status := FND_API.g_ret_sts_unexp_error ;
976: fnd_message.set_name('BOM','CST_UNEXPECTED');
977: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
978: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
979: debug('l_stmt_num:'||l_stmt_num);

Line 1058: x_return_status := fnd_api.g_ret_sts_success;

1054: debug(' p_upg_from_date : ' || TO_CHAR(p_upg_from_date,'YYYY/MM/DD HH24:MI:SS'));
1055: debug(' p_upg_to_date : ' || TO_CHAR(p_upg_to_date,'YYYY/MM/DD HH24:MI:SS'));
1056:
1057:
1058: x_return_status := fnd_api.g_ret_sts_success;
1059:
1060: /* Upgrade PO data. We are joining on the sub ledger tables directly to get the entered amounts
1061: as data for pre 11.5.10 may not have the entered columns populated in the old write off table */
1062:

Line 2235: x_return_status := FND_API.g_ret_sts_unexp_error ;

2231: EXCEPTION
2232:
2233: WHEN OTHERS THEN
2234: rollback;
2235: x_return_status := FND_API.g_ret_sts_unexp_error ;
2236: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2237: fnd_message.set_name('BOM','CST_UNEXPECTED');
2238: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2239: debug('l_stmt_num:'||l_stmt_num);

Line 2322: x_return_status := fnd_api.g_ret_sts_success;

2318:
2319: l_stmt_num := 10;
2320: debug(' l_stmt_num :'||l_stmt_num );
2321:
2322: x_return_status := fnd_api.g_ret_sts_success;
2323:
2324: xla_security_pkg.set_security_context(p_application_id => 200);
2325:
2326: /* Get all the CONC WHO columns */

Line 2628: x_return_status := FND_API.g_ret_sts_unexp_error ;

2624: EXCEPTION
2625:
2626: WHEN OTHERS THEN
2627: rollback;
2628: x_return_status := FND_API.g_ret_sts_unexp_error ;
2629: fnd_message.set_name('BOM','CST_UNEXPECTED');
2630: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2631: debug('l_stmt_num :'||l_stmt_num);
2632: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));

Line 2755: x_return_status := fnd_api.g_ret_sts_success;

2751: debug(' p_to_date : ' || to_char(p_to_date,'DD-MON-YYYY HH24:MI:SS'));
2752: debug(' p_round_unit : ' || p_round_unit);
2753: l_stmt_num := 10;
2754: debug(' l_stmt_num :'|| l_stmt_num);
2755: x_return_status := fnd_api.g_ret_sts_success;
2756:
2757:
2758: xla_security_pkg.set_security_context(p_application_id => 707);
2759:

Line 3240: x_return_status := FND_API.g_ret_sts_unexp_error ;

3236: EXCEPTION
3237:
3238: WHEN OTHERS THEN
3239: rollback;
3240: x_return_status := FND_API.g_ret_sts_unexp_error ;
3241: fnd_message.set_name('BOM','CST_UNEXPECTED');
3242: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
3243: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
3244: debug('l_stmt_num :'||l_stmt_num);

Line 3305: x_return_status := fnd_api.g_ret_sts_success;

3301: debug(' p_to_date : ' || to_char(p_to_date,'DD-MON-YYYY HH24:MI:SS'));
3302:
3303: l_stmt_num := 10;
3304: debug(' l_stmt_num :'||l_stmt_num);
3305: x_return_status := fnd_api.g_ret_sts_success;
3306:
3307:
3308: INSERT into CST_RECONCILIATION_BUILD(
3309: build_id,

Line 3344: x_return_status := FND_API.g_ret_sts_unexp_error ;

3340: EXCEPTION
3341:
3342: WHEN OTHERS THEN
3343: rollback;
3344: x_return_status := FND_API.g_ret_sts_unexp_error ;
3345: fnd_message.set_name('BOM','CST_UNEXPECTED');
3346: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3347: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3348: debug('l_stmt_num :'||l_stmt_num);

Line 4319: x_return_status := FND_API.g_ret_sts_unexp_error ;

4315:
4316: WHEN OTHERS THEN
4317: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
4318: CLOSE c_po_dists;
4319: x_return_status := FND_API.g_ret_sts_unexp_error ;
4320: fnd_message.set_name('BOM','CST_UNEXPECTED');
4321: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
4322: ROLLBACK;
4323: fnd_msg_pub.add;