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.AMS_LIST_PURGE_PVT dependencies on FND_API

Line 30: force_purge_flag IN VARCHAR2 := FND_API.g_false,

26: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
27:
28: PROCEDURE Purge_Expired_List_Headers
29: (
30: force_purge_flag IN VARCHAR2 := FND_API.g_false,
31: x_return_status OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,
33: x_msg_data OUT NOCOPY VARCHAR2
34: )

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119:
120: AMS_Utility_PVT.Debug_Message(l_api_name||': Start ');
121: END IF;
122:
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: l_lookup_code := 'PURGED';
126:
127: IF force_purge_flag = 'Y' THEN

Line 535: x_return_status := FND_API.g_ret_sts_unexp_error;

531: IF (c_all_imp_list_rec%ISOPEN) THEN
532: CLOSE c_all_imp_list_rec;
533: END IF;
534: ROLLBACK TO Purge_Expired_List_Header;
535: x_return_status := FND_API.g_ret_sts_unexp_error;
536: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
537: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
538: FND_MSG_PUB.add;
539: END IF;

Line 562: force_purge_flag in VARCHAR2 := FND_API.G_FALSE

558: PROCEDURE Purge_List_Import
559: (
560: errbuf OUT NOCOPY VARCHAR2,
561: retcode OUT NOCOPY NUMBER,
562: force_purge_flag in VARCHAR2 := FND_API.G_FALSE
563: )
564: IS
565: l_return_status VARCHAR2(1) ;
566: l_msg_count NUMBER ;

Line 581: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN

577: x_msg_data => l_msg_data);
578:
579: -- Write_log ;
580: Ams_Utility_Pvt.Write_Conc_log ;
581: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN
582: retcode := 0;
583: ELSE
584: retcode := 1;
585: errbuf := l_msg_data ;

Line 651: x_return_status := FND_API.G_RET_STS_SUCCESS;

647:
648: AMS_Utility_PVT.Debug_Message(l_api_name||' Start ');
649: END IF;
650:
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652:
653: -- get lookup_code for type 'TARGET'
654: l_lookup_type := null;
655: SELECT lookup_code INTO l_lookup_type

Line 770: x_return_status := FND_API.g_ret_sts_unexp_error;

766: IF (c_all_target_rec%ISOPEN) THEN
767: CLOSE c_all_target_rec;
768: END IF;
769: ROLLBACK TO Purge_Purged_Target;
770: x_return_status := FND_API.g_ret_sts_unexp_error;
771: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
772: FND_MESSAGE.set_name ('AMS', 'AMS_IMP_ERR_PURGE');
773: FND_MSG_PUB.add;
774: END IF;

Line 813: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN

809: x_msg_data => l_msg_data);
810:
811: -- Write_log ;
812: Ams_Utility_Pvt.Write_Conc_log ;
813: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN
814: retcode := 0;
815: ELSE
816: retcode := 1;
817: errbuf := l_msg_data ;

Line 836: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

832: -------------------------------------------------------------------------------
833: PROCEDURE Increase_Usage
834: (
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
837: p_commit IN VARCHAR2 := FND_API.g_false,
838: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
839:
840: x_return_status OUT NOCOPY VARCHAR2,

Line 837: p_commit IN VARCHAR2 := FND_API.g_false,

833: PROCEDURE Increase_Usage
834: (
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
837: p_commit IN VARCHAR2 := FND_API.g_false,
838: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
839:
840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,

Line 838: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

834: (
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
837: p_commit IN VARCHAR2 := FND_API.g_false,
838: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
839:
840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,

Line 879: IF FND_API.to_boolean(p_init_msg_list) THEN

875: AMS_Utility_PVT.Debug_Message(l_full_name||': Start ');
876:
877: END IF;
878:
879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: IF NOT FND_API.compatible_api_call(

Line 883: IF NOT FND_API.compatible_api_call(

879: IF FND_API.to_boolean(p_init_msg_list) THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: IF NOT FND_API.compatible_api_call(
884: l_api_version,
885: p_api_version,
886: l_api_name,
887: g_pkg_name

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: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:

Line 892: x_return_status := FND_API.G_RET_STS_SUCCESS;

888: ) THEN
889: RAISE FND_API.g_exc_unexpected_error;
890: END IF;
891:
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:
894: -- Get all related source line ids
895: OPEN c_source_line_rec(p_list_header_id);
896: LOOP

Line 923: IF FND_API.to_boolean(p_commit) THEN

919: , last_update_login = FND_GLOBAL.conc_login_id
920: WHERE import_source_line_id = l_source_line_id_tbl(i);
921: END IF;
922:
923: IF FND_API.to_boolean(p_commit) THEN
924: COMMIT;
925: END IF;
926:
927: FND_MSG_PUB.count_and_get(

Line 928: p_encoded => FND_API.g_false,

924: COMMIT;
925: END IF;
926:
927: FND_MSG_PUB.count_and_get(
928: p_encoded => FND_API.g_false,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );
932:

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

948: IF(c_source_line_rec%ISOPEN)then
949: CLOSE c_source_line_rec;
950: END IF;
951:
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
953:
954: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
955: THEN
956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 961: p_encoded => FND_API.G_FALSE

957: END IF;
958: FND_MSG_PUB.Count_AND_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => FND_API.G_FALSE
962: );
963:
964: END Increase_Usage;
965:

Line 971: x_return_status := FND_API.G_RET_STS_SUCCESS;

967: x_return_status OUT NOCOPY VARCHAR2,
968: x_msg_count OUT NOCOPY NUMBER,
969: x_msg_data OUT NOCOPY VARCHAR2) is
970: BEGIN
971: x_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: FORALL i in 1 .. p_id_tbl.count
974: DELETE from ams_act_logs
975: WHERE act_log_used_by_id = p_id_tbl(i);

Line 1064: x_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1060: WHERE request_id = l_request_id;
1061:
1062: l_list_header_id number;
1063: l_list_header_status varchar2(100);
1064: x_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1065: x_msg_data varchar2(2000);
1066: x_msg_count number;
1067: l_sel_id number := null;
1068: l_act_id number := null;

Line 1292: x_return_status := FND_API.G_RET_STS_SUCCESS;

1288: l_header_id_tbl num_tbl;
1289: l_request_id_tbl num_tbl;
1290:
1291: BEGIN
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293:
1294: FOR i in 1..p_list_header_id_tbl.count
1295: LOOP
1296: l_header_id_tbl(i) := p_list_header_id_tbl(i).l_list_header_id;

Line 1334: x_return_status := FND_API.G_RET_STS_SUCCESS;

1330:
1331: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;
1332:
1333: BEGIN
1334: x_return_status := FND_API.G_RET_STS_SUCCESS;
1335:
1336: FOR i in 1..p_list_header_id_tbl.count
1337: LOOP
1338: l_header_id_tbl(i) := p_list_header_id_tbl(i).l_list_header_id;

Line 1378: x_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1374: WHERE request_id = l_request_id;
1375:
1376: l_list_header_id number;
1377: l_list_header_status varchar2(100);
1378: x_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1379: x_msg_data varchar2(2000);
1380: x_msg_count number;
1381: l_errbuf varchar2(32767);
1382: l_retcode number;