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

Line 21: x_return_status := fnd_api.g_ret_sts_success;

17: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
18: BEGIN
19: Savepoint csp_requirement_headers_cuhk;
20:
21: x_return_status := fnd_api.g_ret_sts_success;
22: NULL;
23: -- Standard call to get message count and if count is 1, get message info
24: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
25: p_data => x_msg_data );

Line 28: WHEN FND_API.G_EXC_ERROR THEN

24: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
25: p_data => x_msg_data );
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN
29: ROLLBACK TO csp_requirement_headers_cuhk;
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get
32: ( p_count => x_msg_count,

Line 30: x_return_status := FND_API.G_RET_STS_ERROR;

26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN
29: ROLLBACK TO csp_requirement_headers_cuhk;
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get
32: ( p_count => x_msg_count,
33: p_data => x_msg_data );
34: WHEN OTHERS THEN

Line 36: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

32: ( p_count => x_msg_count,
33: p_data => x_msg_data );
34: WHEN OTHERS THEN
35: ROLLBACK TO csp_requirement_headers_cuhk;
36: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
37: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
38: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
39: END IF;
40: FND_MSG_PUB.Count_And_Get

Line 59: x_return_status := fnd_api.g_ret_sts_success;

55: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
56: BEGIN
57: Savepoint csp_requirement_headers_cuhk;
58:
59: x_return_status := fnd_api.g_ret_sts_success;
60: NULL;
61: -- Standard call to get message count and if count is 1, get message info
62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );
64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csp_requirement_headers_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csp_requirement_headers_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN
73: ROLLBACK TO csp_requirement_headers_cuhk;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
77: END IF;
78: FND_MSG_PUB.Count_And_Get

Line 97: x_return_status := fnd_api.g_ret_sts_success;

93: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
94: BEGIN
95: Savepoint csp_requirement_headers_cuhk;
96:
97: x_return_status := fnd_api.g_ret_sts_success;
98: NULL;
99: -- Standard call to get message count and if count is 1, get message info
100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
101: p_data => x_msg_data );

Line 104: WHEN FND_API.G_EXC_ERROR THEN

100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
101: p_data => x_msg_data );
102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO csp_requirement_headers_cuhk;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,

Line 106: x_return_status := FND_API.G_RET_STS_ERROR;

102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO csp_requirement_headers_cuhk;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
110: WHEN OTHERS THEN

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
110: WHEN OTHERS THEN
111: ROLLBACK TO csp_requirement_headers_cuhk;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get

Line 134: x_return_status := fnd_api.g_ret_sts_success;

130: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
131: BEGIN
132: Savepoint csp_requirement_headers_cuhk;
133:
134: x_return_status := fnd_api.g_ret_sts_success;
135: NULL;
136: -- Standard call to get message count and if count is 1, get message info
137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data );

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data );
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO csp_requirement_headers_cuhk;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO csp_requirement_headers_cuhk;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,
146: p_data => x_msg_data );
147: WHEN OTHERS THEN

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: ( p_count => x_msg_count,
146: p_data => x_msg_data );
147: WHEN OTHERS THEN
148: ROLLBACK TO csp_requirement_headers_cuhk;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
152: END IF;
153: FND_MSG_PUB.Count_And_Get

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
167: BEGIN
168: Savepoint csp_requirement_headers_cuhk;
169:
170: x_return_status := fnd_api.g_ret_sts_success;
171: NULL;
172: -- Standard call to get message count and if count is 1, get message info
173: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
174: p_data => x_msg_data );

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
174: p_data => x_msg_data );
175:
176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO csp_requirement_headers_cuhk;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,

Line 179: x_return_status := FND_API.G_RET_STS_ERROR;

175:
176: EXCEPTION
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO csp_requirement_headers_cuhk;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data );
183: WHEN OTHERS THEN

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181: ( p_count => x_msg_count,
182: p_data => x_msg_data );
183: WHEN OTHERS THEN
184: ROLLBACK TO csp_requirement_headers_cuhk;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
188: END IF;
189: FND_MSG_PUB.Count_And_Get

Line 206: x_return_status := fnd_api.g_ret_sts_success;

202: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
203: BEGIN
204: Savepoint csp_requirement_headers_cuhk;
205:
206: x_return_status := fnd_api.g_ret_sts_success;
207: NULL;
208: -- Standard call to get message count and if count is 1, get message info
209: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
210: p_data => x_msg_data );

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
210: p_data => x_msg_data );
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO csp_requirement_headers_cuhk;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO csp_requirement_headers_cuhk;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,
218: p_data => x_msg_data );
219: WHEN OTHERS THEN

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: ( p_count => x_msg_count,
218: p_data => x_msg_data );
219: WHEN OTHERS THEN
220: ROLLBACK TO csp_requirement_headers_cuhk;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
224: END IF;
225: FND_MSG_PUB.Count_And_Get