DBA Data[Home] [Help]

APPS.OKE_FUNDING_PUB dependencies on OKE_FUNDING_PUB

Line 1: package body OKE_FUNDING_PUB as

1: package body OKE_FUNDING_PUB as
2: /* $Header: OKEPKFDB.pls 120.1.12020000.2 2012/09/25 06:54:01 skuchima ship $ */
3:
4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_funding_pub.';
5:

Line 4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_funding_pub.';

1: package body OKE_FUNDING_PUB as
2: /* $Header: OKEPKFDB.pls 120.1.12020000.2 2012/09/25 06:54:01 skuchima ship $ */
3:
4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_funding_pub.';
5:
6: --
7: -- Private Procedures and Functions
8: --

Line 421: --dbms_output.put_line('entering oke_funding_pub.create_funding');

417: l_funding_in_rec funding_rec_in_type;
418:
419: BEGIN
420:
421: --dbms_output.put_line('entering oke_funding_pub.create_funding');
422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.create_funding');
423:
424: x_return_status := OKE_API.G_RET_STS_SUCCESS;
425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

Line 422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.create_funding');

418:
419: BEGIN
420:
421: --dbms_output.put_line('entering oke_funding_pub.create_funding');
422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.create_funding');
423:
424: x_return_status := OKE_API.G_RET_STS_SUCCESS;
425: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
426:

Line 450: --dbms_output.put_line('calling oke_fundsource_pvt.create_funding from oke_funding_pub');

446: --
447: -- Call OKE_FUNDSOURCE_PVT.create_funding to create contract funding
448: --
449:
450: --dbms_output.put_line('calling oke_fundsource_pvt.create_funding from oke_funding_pub');
451: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.create_funding from oke_funding_pub');
452:
453: OKE_FUNDSOURCE_PVT.create_funding(p_api_version => p_api_version ,
454: p_init_msg_list => OKE_API.G_FALSE ,

Line 451: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.create_funding from oke_funding_pub');

447: -- Call OKE_FUNDSOURCE_PVT.create_funding to create contract funding
448: --
449:
450: --dbms_output.put_line('calling oke_fundsource_pvt.create_funding from oke_funding_pub');
451: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_fundsource_pvt.create_funding from oke_funding_pub');
452:
453: OKE_FUNDSOURCE_PVT.create_funding(p_api_version => p_api_version ,
454: p_init_msg_list => OKE_API.G_FALSE ,
455: p_commit => OKE_API.G_FALSE ,

Line 480: --dbms_output.put_line('calling oke_funding_pub.add_allocation');

476: --
477: -- Call add_allocation to create contract funding allocation
478: --
479:
480: --dbms_output.put_line('calling oke_funding_pub.add_allocation');
481: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_funding_pub.add_allocation');
482:
483: IF (p_allocation_in_tbl.COUNT > 0 )THEN
484:

Line 481: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_funding_pub.add_allocation');

477: -- Call add_allocation to create contract funding allocation
478: --
479:
480: --dbms_output.put_line('calling oke_funding_pub.add_allocation');
481: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_funding_pub.add_allocation');
482:
483: IF (p_allocation_in_tbl.COUNT > 0 )THEN
484:
485: i := p_allocation_in_tbl.FIRST;

Line 585: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);

581: COMMIT WORK;
582:
583: END IF;
584:
585: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
586: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
587:
588: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
589: x_msg_data => x_msg_data

Line 586: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);

582:
583: END IF;
584:
585: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
586: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
587:
588: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
589: x_msg_data => x_msg_data
590: );

Line 673: --dbms_output.put_line('entering oke_funding_pub.update_funding');

669:
670: l_receivables_term_id number;
671: BEGIN
672:
673: --dbms_output.put_line('entering oke_funding_pub.update_funding');
674: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_funding');
675:
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

Line 674: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_funding');

670: l_receivables_term_id number;
671: BEGIN
672:
673: --dbms_output.put_line('entering oke_funding_pub.update_funding');
674: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_funding');
675:
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: x_funding_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
678:

Line 869: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);

865: COMMIT WORK;
866:
867: END IF;
868:
869: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
870: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
871:
872: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
873: x_msg_data => x_msg_data

Line 870: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);

866:
867: END IF;
868:
869: --dbms_output.put_line('finished oke_funding_pub.create_funding w/ ' || x_return_status);
870: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.create_funding w/ ' || x_return_status);
871:
872: OKE_API.END_ACTIVITY(x_msg_count => x_msg_count ,
873: x_msg_data => x_msg_data
874: );

Line 917: -- OKE_FUNDING_PUB.delete_allocation

913: --
914: -- Calling subprograms: OKE_API.start_activity
915: -- OKE_API.end_activity
916: -- OKE_FUNDSOURCE_PVT.delete_funding
917: -- OKE_FUNDING_PUB.delete_allocation
918: --
919:
920: PROCEDURE delete_funding(p_api_version IN NUMBER ,
921: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

Line 945: --dbms_output.put_line('entering oke_funding_pub.delete_funding');

941: l_return_status VARCHAR2(1);
942:
943: BEGIN
944:
945: --dbms_output.put_line('entering oke_funding_pub.delete_funding');
946: -- --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_funding');
947:
948: x_return_status := OKE_API.G_RET_STS_SUCCESS;
949:

Line 946: -- --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_funding');

942:
943: BEGIN
944:
945: --dbms_output.put_line('entering oke_funding_pub.delete_funding');
946: -- --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_funding');
947:
948: x_return_status := OKE_API.G_RET_STS_SUCCESS;
949:
950: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 970: -- Call OKE_FUNDING_PUB to delete contract funding allocation

966:
967: END IF;
968:
969: --
970: -- Call OKE_FUNDING_PUB to delete contract funding allocation
971: --
972:
973: --dbms_output.put_line('in loop: calling delete_allocation');
974: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'in loop: calling delete_allocation');

Line 1029: --dbms_output.put_line('finished oke_funding_pub.delete_funding w/ ' || x_return_status);

1025: RAISE OKE_API.G_EXCEPTION_ERROR;
1026:
1027: END IF;
1028:
1029: --dbms_output.put_line('finished oke_funding_pub.delete_funding w/ ' || x_return_status);
1030: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_funding w/ ' || x_return_status);
1031:
1032: IF FND_API.to_boolean(p_commit) THEN
1033:

Line 1030: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_funding w/ ' || x_return_status);

1026:
1027: END IF;
1028:
1029: --dbms_output.put_line('finished oke_funding_pub.delete_funding w/ ' || x_return_status);
1030: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_funding w/ ' || x_return_status);
1031:
1032: IF FND_API.to_boolean(p_commit) THEN
1033:
1034: COMMIT WORK;

Line 1101: --dbms_output.put_line('entering oke_funding_pub.add_allocation');

1097: l_allocation_in_rec ALLOCATION_REC_IN_TYPE := p_allocation_in_rec;
1098:
1099: BEGIN
1100:
1101: --dbms_output.put_line('entering oke_funding_pub.add_allocation');
1102: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.add_allocation');
1103:
1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

Line 1102: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.add_allocation');

1098:
1099: BEGIN
1100:
1101: --dbms_output.put_line('entering oke_funding_pub.add_allocation');
1102: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.add_allocation');
1103:
1104: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1105: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1106:

Line 1130: --dbms_output.put_line('calling oke_allocation_pvt.add_allocation from oke_funding_pub');

1126: --
1127: -- Call OKE_ALLOCATION_PVT.add_allocation
1128: --
1129:
1130: --dbms_output.put_line('calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1131: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1132:
1133: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
1134: p_init_msg_list => OKE_API.G_FALSE ,

Line 1131: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.add_allocation from oke_funding_pub');

1127: -- Call OKE_ALLOCATION_PVT.add_allocation
1128: --
1129:
1130: --dbms_output.put_line('calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1131: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.add_allocation from oke_funding_pub');
1132:
1133: OKE_ALLOCATION_PVT.add_allocation(p_api_version => p_api_version ,
1134: p_init_msg_list => OKE_API.G_FALSE ,
1135: p_commit => OKE_API.G_FALSE ,

Line 1178: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');

1174: --
1175: l_allocation_in_rec := get_record(p_fund_allocation_id => l_allocation_in_rec.fund_allocation_id);
1176: l_allocation_in_rec.agreement_id := p_allocation_in_rec.agreement_id;
1177:
1178: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1179: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1180:
1181: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1182: p_init_msg_list => OKE_API.G_FALSE ,

Line 1179: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');

1175: l_allocation_in_rec := get_record(p_fund_allocation_id => l_allocation_in_rec.fund_allocation_id);
1176: l_allocation_in_rec.agreement_id := p_allocation_in_rec.agreement_id;
1177:
1178: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1179: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1180:
1181: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1182: p_init_msg_list => OKE_API.G_FALSE ,
1183: p_commit => OKE_API.G_FALSE ,

Line 1202: --dbms_output.put_line('finished oke_funding_pub.add_allocation w/ ' || x_return_status);

1198: END IF;
1199:
1200: END IF;
1201:
1202: --dbms_output.put_line('finished oke_funding_pub.add_allocation w/ ' || x_return_status);
1203: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.add_allocation w/ ' || x_return_status);
1204:
1205: IF FND_API.to_boolean(p_commit) THEN
1206:

Line 1203: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.add_allocation w/ ' || x_return_status);

1199:
1200: END IF;
1201:
1202: --dbms_output.put_line('finished oke_funding_pub.add_allocation w/ ' || x_return_status);
1203: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.add_allocation w/ ' || x_return_status);
1204:
1205: IF FND_API.to_boolean(p_commit) THEN
1206:
1207: COMMIT WORK;

Line 1278: --dbms_output.put_line('entering oke_funding_pub.update_allocation');

1274: l_allocation_in_rec ALLOCATION_REC_IN_TYPE;
1275:
1276: BEGIN
1277:
1278: --dbms_output.put_line('entering oke_funding_pub.update_allocation');
1279: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_allocation');
1280:
1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;

Line 1279: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_allocation');

1275:
1276: BEGIN
1277:
1278: --dbms_output.put_line('entering oke_funding_pub.update_allocation');
1279: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.update_allocation');
1280:
1281: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1282: x_allocation_out_rec.return_status := OKE_API.G_RET_STS_SUCCESS;
1283:

Line 1309: --dbms_output.put_line('calling oke_allocation_pvt.update_allocation from oke_funding_pub');

1305: --
1306: -- Call OKE_ALLOCATION_PVT.update_allocation to update the allocation line
1307: --
1308:
1309: --dbms_output.put_line('calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1310: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1311:
1312: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
1313: p_init_msg_list => OKE_API.G_FALSE ,

Line 1310: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.update_allocation from oke_funding_pub');

1306: -- Call OKE_ALLOCATION_PVT.update_allocation to update the allocation line
1307: --
1308:
1309: --dbms_output.put_line('calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1310: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.update_allocation from oke_funding_pub');
1311:
1312: OKE_ALLOCATION_PVT.update_allocation(p_api_version => p_api_version ,
1313: p_init_msg_list => OKE_API.G_FALSE ,
1314: p_commit => OKE_API.G_FALSE ,

Line 1357: --dbms_output.put_line('calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');

1353: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'check if it is a update or add in pa');
1354:
1355: IF (check_update_add_pa(p_fund_allocation_id => p_allocation_in_rec.fund_allocation_id)) THEN
1356:
1357: --dbms_output.put_line('calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1358: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1359:
1360: OKE_AGREEMENT_PVT.update_pa_funding(p_api_version => p_api_version ,
1361: p_init_msg_list => OKE_API.G_FALSE ,

Line 1358: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');

1354:
1355: IF (check_update_add_pa(p_fund_allocation_id => p_allocation_in_rec.fund_allocation_id)) THEN
1356:
1357: --dbms_output.put_line('calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1358: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.update_pa_funding from oke_funding_pub');
1359:
1360: OKE_AGREEMENT_PVT.update_pa_funding(p_api_version => p_api_version ,
1361: p_init_msg_list => OKE_API.G_FALSE ,
1362: p_commit => OKE_API.G_FALSE ,

Line 1370: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');

1366: p_return_status => x_return_status
1367: );
1368: ELSE
1369:
1370: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1371: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1372:
1373: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1374: p_init_msg_list => OKE_API.G_FALSE ,

Line 1371: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');

1367: );
1368: ELSE
1369:
1370: --dbms_output.put_line('calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1371: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_agreement_pvt.add_pa_funding from oke_funding_pub');
1372:
1373: OKE_AGREEMENT_PVT.add_pa_funding(p_api_version => p_api_version ,
1374: p_init_msg_list => OKE_API.G_FALSE ,
1375: p_commit => OKE_API.G_FALSE ,

Line 1396: --dbms_output.put_line('finished oke_funding_pub.update_allocation w/ ' || x_return_status);

1392: END IF;
1393:
1394: END IF;
1395:
1396: --dbms_output.put_line('finished oke_funding_pub.update_allocation w/ ' || x_return_status);
1397: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.update_allocation w/ ' || x_return_status);
1398:
1399: IF FND_API.to_boolean(p_commit) THEN
1400:

Line 1397: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.update_allocation w/ ' || x_return_status);

1393:
1394: END IF;
1395:
1396: --dbms_output.put_line('finished oke_funding_pub.update_allocation w/ ' || x_return_status);
1397: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.update_allocation w/ ' || x_return_status);
1398:
1399: IF FND_API.to_boolean(p_commit) THEN
1400:
1401: COMMIT WORK;

Line 1489: --dbms_output.put_line('entering oke_funding_pub.delete_allocation');

1485: l_a_revenue_limit NUMBER;
1486:
1487: BEGIN
1488:
1489: --dbms_output.put_line('entering oke_funding_pub.delete_allocation');
1490: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_allocation');
1491:
1492: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1493:

Line 1490: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_allocation');

1486:
1487: BEGIN
1488:
1489: --dbms_output.put_line('entering oke_funding_pub.delete_allocation');
1490: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'entering oke_funding_pub.delete_allocation');
1491:
1492: x_return_status := OKE_API.G_RET_STS_SUCCESS;
1493:
1494: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

Line 1536: --dbms_output.put_line('calling oke_allocation_pvt.delete_allocation from oke_funding_pub');

1532: --
1533: -- Call OKE_ALLOCATION_PVT.delete_allocation to delete funding allocation line
1534: --
1535:
1536: --dbms_output.put_line('calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1537: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1538:
1539: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
1540: p_commit => OKE_API.G_FALSE ,

Line 1537: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.delete_allocation from oke_funding_pub');

1533: -- Call OKE_ALLOCATION_PVT.delete_allocation to delete funding allocation line
1534: --
1535:
1536: --dbms_output.put_line('calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1537: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'calling oke_allocation_pvt.delete_allocation from oke_funding_pub');
1538:
1539: OKE_ALLOCATION_PVT.delete_allocation(p_api_version => p_api_version ,
1540: p_commit => OKE_API.G_FALSE ,
1541: p_init_msg_list => OKE_API.G_FALSE ,

Line 1627: --dbms_output.put_line('finished oke_funding_pub.delete_allocation w/ ' || x_return_status);

1623: RAISE G_EXCEPTION_HALT_VALIDATION;
1624:
1625: END IF;
1626:
1627: --dbms_output.put_line('finished oke_funding_pub.delete_allocation w/ ' || x_return_status);
1628: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_allocation w/ ' || x_return_status);
1629:
1630: IF FND_API.to_boolean(p_commit) THEN
1631:

Line 1628: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_allocation w/ ' || x_return_status);

1624:
1625: END IF;
1626:
1627: --dbms_output.put_line('finished oke_funding_pub.delete_allocation w/ ' || x_return_status);
1628: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'finished oke_funding_pub.delete_allocation w/ ' || x_return_status);
1629:
1630: IF FND_API.to_boolean(p_commit) THEN
1631:
1632: COMMIT WORK;

Line 1669: end OKE_FUNDING_PUB;

1665: p_api_type => '_PUB'
1666: );
1667: END delete_allocation;
1668:
1669: end OKE_FUNDING_PUB;
1670: