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_LINES_CUHK dependencies on CSP_REQUIREMENT_LINES_CUHK

Line 1: PACKAGE BODY csp_requirement_lines_cuhk AS

1: PACKAGE BODY csp_requirement_lines_cuhk AS
2: /* $Header: cspcrqlb.pls 115.3 2002/11/26 08:01:16 hhaugeru noship $ */
3:
4: /*****************************************************************************************
5: This is the Vertical Industry User Hook API.

Line 19: Savepoint csp_requirement_lines_cuhk;

15: x_msg_data OUT NOCOPY VARCHAR2
16: ) IS
17: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
18: BEGIN
19: Savepoint csp_requirement_lines_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

Line 29: ROLLBACK TO csp_requirement_lines_cuhk;

25: p_data => x_msg_data );
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN
29: ROLLBACK TO csp_requirement_lines_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 );

Line 35: ROLLBACK TO csp_requirement_lines_cuhk;

31: FND_MSG_PUB.Count_And_Get
32: ( p_count => x_msg_count,
33: p_data => x_msg_data );
34: WHEN OTHERS THEN
35: ROLLBACK TO csp_requirement_lines_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;

Line 58: Savepoint csp_requirement_lines_cuhk;

54: x_msg_data OUT NOCOPY VARCHAR2
55: ) IS
56: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
57: BEGIN
58: Savepoint csp_requirement_lines_cuhk;
59:
60: x_return_status := fnd_api.g_ret_sts_success;
61: NULL;
62: -- Standard call to get message count and if count is 1, get message info

Line 68: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 74: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 98: Savepoint csp_requirement_lines_cuhk;

94: x_msg_data OUT NOCOPY VARCHAR2
95: ) IS
96: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
97: BEGIN
98: Savepoint csp_requirement_lines_cuhk;
99:
100: x_return_status := fnd_api.g_ret_sts_success;
101: NULL;
102: -- Standard call to get message count and if count is 1, get message info

Line 108: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 114: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 135: Savepoint csp_requirement_lines_cuhk;

131: x_msg_data OUT NOCOPY VARCHAR2
132: ) IS
133: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
134: BEGIN
135: Savepoint csp_requirement_lines_cuhk;
136:
137: x_return_status := fnd_api.g_ret_sts_success;
138: NULL;
139: -- Standard call to get message count and if count is 1, get message info

Line 145: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 151: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 171: Savepoint csp_requirement_lines_cuhk;

167: x_msg_data OUT NOCOPY VARCHAR2
168: ) IS
169: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
170: BEGIN
171: Savepoint csp_requirement_lines_cuhk;
172:
173: x_return_status := fnd_api.g_ret_sts_success;
174: NULL;
175: -- Standard call to get message count and if count is 1, get message info

Line 181: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 187: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 207: Savepoint csp_requirement_lines_cuhk;

203: x_msg_data OUT NOCOPY VARCHAR2
204: ) IS
205: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
206: BEGIN
207: Savepoint csp_requirement_lines_cuhk;
208:
209: x_return_status := fnd_api.g_ret_sts_success;
210: NULL;
211: -- Standard call to get message count and if count is 1, get message info

Line 217: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 223: ROLLBACK TO csp_requirement_lines_cuhk;

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

Line 234: END csp_requirement_lines_cuhk;

230: p_data => x_msg_data
231: );
232:
233: END delete_requirement_line_post;
234: END csp_requirement_lines_cuhk;