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

Line 8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSF_REMOTE_VIEWS_PUB';
5:
6: procedure Parse_Query
7: ( p_api_version IN NUMBER
8: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
9: , x_return_status OUT VARCHAR2
10: , x_msg_count OUT NUMBER
11: , x_msg_data OUT VARCHAR2
12: , p_sql_query IN VARCHAR2

Line 24: IF NOT FND_API.Compatible_API_Call

20: t_cursor_name integer;
21:
22: begin
23: -- Standard call to check for call compatibility.
24: IF NOT FND_API.Compatible_API_Call
25: ( l_api_version
26: , p_api_version
27: , l_api_name
28: , G_PKG_NAME

Line 31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

27: , l_api_name
28: , G_PKG_NAME
29: )
30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean
35: ( p_init_msg_list

Line 34: IF FND_API.to_Boolean

30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean
35: ( p_init_msg_list
36: )
37: THEN
38: FND_MSG_PUB.initialize;

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: THEN
38: FND_MSG_PUB.initialize;
39: END IF;
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: -- All statements wich do not begin with 'select' are to be rejected.
43: -- This way modifications with statements like update ... or
44: -- delete ... can be prevented.
45: if Upper

Line 55: x_query_correct := FND_API.G_FALSE;

51: , 6
52: )
53: ) <> 'SELECT'
54: then
55: x_query_correct := FND_API.G_FALSE;
56: end if;
57: t_cursor_name := dbms_sql.open_cursor;
58: dbms_sql.parse
59: ( t_cursor_name

Line 66: x_query_correct := FND_API.G_TRUE;

62: );
63: dbms_sql.close_cursor
64: ( t_cursor_name
65: );
66: x_query_correct := FND_API.G_TRUE;
67: -- Standard call to get message count and if count is 1, get message info.
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count
70: , p_data => x_msg_data

Line 73: WHEN FND_API.G_EXC_ERROR

69: ( p_count => x_msg_count
70: , p_data => x_msg_data
71: );
72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR
74: THEN
75: x_return_status := FND_API.G_RET_STS_ERROR ;
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count

Line 75: x_return_status := FND_API.G_RET_STS_ERROR ;

71: );
72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR
74: THEN
75: x_return_status := FND_API.G_RET_STS_ERROR ;
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count
78: , p_data => x_msg_data
79: );

Line 80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count
78: , p_data => x_msg_data
79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
81: THEN
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84: ( p_count => x_msg_count

Line 82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

78: , p_data => x_msg_data
79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
81: THEN
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84: ( p_count => x_msg_count
85: , p_data => x_msg_data
86: );

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

85: , p_data => x_msg_data
86: );
87: WHEN OTHERS
88: THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: IF FND_MSG_PUB.Check_Msg_Level
91: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
92: )
93: THEN

Line 111: x_query_correct := FND_API.G_FALSE;

107: dbms_sql.close_cursor
108: (t_cursor_name
109: );
110: end if;
111: x_query_correct := FND_API.G_FALSE;
112: end Parse_Query;
113:
114: procedure Execute_Remote_View
115: ( p_api_version IN NUMBER

Line 116: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

112: end Parse_Query;
113:
114: procedure Execute_Remote_View
115: ( p_api_version IN NUMBER
116: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
117: , p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , x_return_status OUT VARCHAR2
119: , x_msg_count OUT NUMBER
120: , x_msg_data OUT VARCHAR2

Line 117: , p_commit IN VARCHAR2 := FND_API.G_FALSE

113:
114: procedure Execute_Remote_View
115: ( p_api_version IN NUMBER
116: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
117: , p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , x_return_status OUT VARCHAR2
119: , x_msg_count OUT NUMBER
120: , x_msg_data OUT VARCHAR2
121: , p_sqlstring IN VARCHAR2

Line 127: , p_queryrequest_id IN NUMBER := FND_API.G_MISS_NUM

123: , p_sqltitle IN VARCHAR2
124: , p_role IN VARCHAR2
125: , p_requestdate IN DATE
126: , p_query_id IN NUMBER
127: , p_queryrequest_id IN NUMBER := FND_API.G_MISS_NUM
128: , x_queryrequest_id OUT NUMBER
129: , x_notification_id OUT NUMBER
130: )
131: is

Line 322: IF NOT FND_API.Compatible_API_Call

318: begin
319: -- Standard Start of API savepoint
320: SAVEPOINT EXECUTE_REMOTE_VIEW_PUB;
321: -- Standard call to check for call compatibility.
322: IF NOT FND_API.Compatible_API_Call
323: ( l_api_version
324: , p_api_version
325: , l_api_name
326: , G_PKG_NAME

Line 329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

325: , l_api_name
326: , G_PKG_NAME
327: )
328: THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331: -- Initialize message list if p_init_msg_list is set to TRUE.
332: IF FND_API.to_Boolean
333: ( p_init_msg_list

Line 332: IF FND_API.to_Boolean

328: THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331: -- Initialize message list if p_init_msg_list is set to TRUE.
332: IF FND_API.to_Boolean
333: ( p_init_msg_list
334: )
335: THEN
336: FND_MSG_PUB.initialize;

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335: THEN
336: FND_MSG_PUB.initialize;
337: END IF;
338: -- Initialize API return status to success
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:
341: -- Convert resource_number to apps user name
342: open c_user
343: ( b_res_num => p_role

Line 388: raise FND_API.G_EXC_UNEXPECTED_ERROR;

384: ( 'CSF'
385: , 'CSF_RMT_VWS_PAR_MAPPING'
386: );
387: fnd_msg_pub.add;
388: raise FND_API.G_EXC_UNEXPECTED_ERROR;
389: else
390: c_query := dbms_sql.open_cursor;
391: -- Start a new block to be able to trap exceptions
392: -- when parsing it fails.

Line 649: raise FND_API.G_EXC_UNEXPECTED_ERROR;

645: ( 'CSF'
646: , 'CSF_RMT_VWS_PARSE_ERROR'
647: );
648: fnd_msg_pub.add;
649: raise FND_API.G_EXC_UNEXPECTED_ERROR;
650: end;
651: dbms_sql.close_cursor
652: ( c_query
653: );

Line 713: IF FND_API.To_Boolean

709: );
710: x_queryrequest_id := t_request_id;
711:
712: -- Standard check of p_commit.
713: IF FND_API.To_Boolean
714: ( p_commit
715: )
716: THEN
717: COMMIT WORK;

Line 726: WHEN FND_API.G_EXC_ERROR

722: ( p_count => x_msg_count
723: , p_data => x_msg_data
724: );
725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR
727: THEN
728: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get

Line 729: x_return_status := FND_API.G_RET_STS_ERROR ;

725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR
727: THEN
728: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count
732: , p_data => x_msg_data
733: );

Line 734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

730: FND_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count
732: , p_data => x_msg_data
733: );
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
735: THEN
736: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get

Line 737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

733: );
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
735: THEN
736: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
738: FND_MSG_PUB.Count_And_Get
739: ( p_count => x_msg_count
740: , p_data => x_msg_data
741: );

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

741: );
742: WHEN OTHERS
743: THEN
744: ROLLBACK TO EXECUTE_REMOTE_VIEW_PUB;
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
746: IF FND_MSG_PUB.Check_Msg_Level
747: ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
748: )
749: THEN