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

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: FROM ams_jtf_rs_emp_v
38: WHERE resource_id = p_user_id ;
39: l_person_id number;
40: BEGIN
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: OPEN c_resource ;
43: FETCH c_resource INTO l_person_id ;
44: IF c_resource%NOTFOUND THEN
45: x_return_status := FND_API.G_RET_STS_ERROR;

Line 45: x_return_status := FND_API.G_RET_STS_ERROR;

41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: OPEN c_resource ;
43: FETCH c_resource INTO l_person_id ;
44: IF c_resource%NOTFOUND THEN
45: x_return_status := FND_API.G_RET_STS_ERROR;
46: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
47: FND_MSG_PUB.Add;
48: END IF;
49: CLOSE c_resource ;

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53: p_orig_system_id => l_person_id ,
54: p_name => x_role_name,
55: p_display_name => x_role_display_name );
56: IF x_role_name is null then
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: FND_MESSAGE.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
59: FND_MSG_PUB.Add;
60: END IF;
61: END Get_User_Role;

Line 81: p_encoded => FND_API.G_FALSE,

77: WHILE l_cnt < p_msg_count
78: LOOP
79: FND_MSG_PUB.Get
80: (p_msg_index => l_cnt + 1,
81: p_encoded => FND_API.G_FALSE,
82: p_data => l_msg_data,
83: p_msg_index_out => l_msg_index ) ;
84: l_final_data := l_final_data ||l_msg_index||': '
85: ||l_msg_data||fnd_global.local_chr(10) ;

Line 209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

205: x_role_display_name => l_display_name,
206: x_return_status => l_return_status);
207: --
208:
209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213:

Line 210: RAISE FND_API.G_EXC_ERROR;

206: x_return_status => l_return_status);
207: --
208:
209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212:
213:
214: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 285: l_return_status := FND_API.G_RET_STS_SUCCESS;

281: (itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'LIST_HEADER_ID');
284:
285: l_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: AMS_ListGeneration_PKG.GENERATE_LIST
288: ( p_api_version => 1.0,
289: p_init_msg_list => FND_API.G_TRUE,

Line 289: p_init_msg_list => FND_API.G_TRUE,

285: l_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: AMS_ListGeneration_PKG.GENERATE_LIST
288: ( p_api_version => 1.0,
289: p_init_msg_list => FND_API.G_TRUE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292: p_list_header_id => l_list_header_id,
293: x_return_status => l_return_status,

Line 290: p_commit => FND_API.G_FALSE,

286:
287: AMS_ListGeneration_PKG.GENERATE_LIST
288: ( p_api_version => 1.0,
289: p_init_msg_list => FND_API.G_TRUE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292: p_list_header_id => l_list_header_id,
293: x_return_status => l_return_status,
294: x_msg_count => l_msg_count,

Line 291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

287: AMS_ListGeneration_PKG.GENERATE_LIST
288: ( p_api_version => 1.0,
289: p_init_msg_list => FND_API.G_TRUE,
290: p_commit => FND_API.G_FALSE,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292: p_list_header_id => l_list_header_id,
293: x_return_status => l_return_status,
294: x_msg_count => l_msg_count,
295: x_msg_data => l_msg_data) ;

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

293: x_return_status => l_return_status,
294: x_msg_count => l_msg_count,
295: x_msg_data => l_msg_data) ;
296:
297: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN
298: result := 'COMPLETE:SUCCESS' ;
299: RETURN;
300: ELSE
301: result := 'COMPLETE:FAILURE' ;

Line 500: p_init_msg_list => FND_API.G_TRUE,

496: close c2;
497:
498: AMS_Act_List_PVT.generate_target_group_list_old
499: ( p_api_version => 1.0,
500: p_init_msg_list => FND_API.G_TRUE,
501: p_commit => FND_API.G_FALSE,
502: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
503: p_list_used_by => l_list_used_by,
504: p_list_used_by_id => l_list_used_by_id,

Line 501: p_commit => FND_API.G_FALSE,

497:
498: AMS_Act_List_PVT.generate_target_group_list_old
499: ( p_api_version => 1.0,
500: p_init_msg_list => FND_API.G_TRUE,
501: p_commit => FND_API.G_FALSE,
502: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
503: p_list_used_by => l_list_used_by,
504: p_list_used_by_id => l_list_used_by_id,
505: x_return_status => l_return_status,

Line 502: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

498: AMS_Act_List_PVT.generate_target_group_list_old
499: ( p_api_version => 1.0,
500: p_init_msg_list => FND_API.G_TRUE,
501: p_commit => FND_API.G_FALSE,
502: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
503: p_list_used_by => l_list_used_by,
504: p_list_used_by_id => l_list_used_by_id,
505: x_return_status => l_return_status,
506: x_msg_count => l_msg_count,

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

508: ) ;
509: result := 'COMPLETE:' ;
510:
511: --To fix bug 5187640
512: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN
513: result := 'COMPLETE:SUCCESS' ;
514: RETURN;
515: ELSE
516: result := 'COMPLETE:FAILURE' ;

Line 578: RAISE FND_API.G_EXC_ERROR;

574: );
575:
576: IF (l_is_manual = 'Y')
577: then
578: RAISE FND_API.G_EXC_ERROR;
579: end if;
580:
581:
582: AMS_Utility_PVT.Create_Log (

Line 625: p_init_msg_list => FND_API.G_TRUE,

621: FETCH c_list_det INTO l_start_time, l_timezone;
622: CLOSE c_list_det;
623: /*
624: AMS_UTILITY_PVT.Convert_Timezone(
625: p_init_msg_list => FND_API.G_TRUE,
626: x_return_status => l_return_status,
627: x_msg_count => l_msg_count,
628: x_msg_data => l_msg_data,
629:

Line 638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

634: x_out_time => l_sys_start_time
635: );
636: */
637: -- If any errors happen let start time be sysdate
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: l_sys_start_time := SYSDATE;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: l_sys_start_time := SYSDATE;
642: END IF;

Line 640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

636: */
637: -- If any errors happen let start time be sysdate
638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
639: l_sys_start_time := SYSDATE;
640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
641: l_sys_start_time := SYSDATE;
642: END IF;
643: AMS_Utility_PVT.debug_message('Raise Business event-- Start');
644: /*

Line 794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

790: x_role_name => l_requester_role,
791: x_role_display_name => l_display_name,
792: x_return_status => l_return_status);
793: --
794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797:
798:

Line 795: RAISE FND_API.G_EXC_ERROR;

791: x_role_display_name => l_display_name,
792: x_return_status => l_return_status);
793: --
794: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
795: RAISE FND_API.G_EXC_ERROR;
796: END IF;
797:
798:
799: WF_ENGINE.SetItemAttrText(itemtype => itemtype,