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

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21:
22: PROCEDURE create_segment_list
23: ( p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_owner_user_id IN NUMBER,
28: p_cell_id IN NUMBER,

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

21:
22: PROCEDURE create_segment_list
23: ( p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_owner_user_id IN NUMBER,
28: p_cell_id IN NUMBER,
29: x_return_status OUT NOCOPY VARCHAR2,

Line 26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE create_segment_list
23: ( p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_owner_user_id IN NUMBER,
28: p_cell_id IN NUMBER,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 38: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

34: p_list_name in VARCHAR2 --DEFAULT NULL
35: )
36: is
37: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
38: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
39: l_api_version NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'Create_segment_List';
41: l_action_rec AMS_ListAction_PVT.action_rec_type ;
42: l_action_id NUMBER;

Line 103: IF NOT FND_API.Compatible_API_Call ( l_api_version,

99: ELSE
100: l_cell_list_name := p_list_name ;
101: END IF;
102:
103: IF NOT FND_API.Compatible_API_Call ( l_api_version,
104: p_api_version,
105: l_api_name,
106: G_PKG_NAME) THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: IF NOT FND_API.Compatible_API_Call ( l_api_version,
104: p_api_version,
105: l_api_name,
106: G_PKG_NAME) THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: -- Initialize message list IF p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 111: IF FND_API.to_Boolean( p_init_msg_list ) THEN

107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: -- Initialize message list IF p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list ) THEN
112: FND_MSG_PUB.initialize;
113: END IF;
114:
115: -- Debug Message

Line 139: IF l_return_status = FND_API.g_ret_sts_error THEN

135: x_msg_data => x_msg_data,
136: p_cell_id => p_cell_id,
137: x_sql_string => l_sql_string
138: );
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;

Line 140: RAISE FND_API.g_exc_error;

136: p_cell_id => p_cell_id,
137: x_sql_string => l_sql_string
138: );
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144:

Line 141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

137: x_sql_string => l_sql_string
138: );
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144:
145: IF l_sql_string IS NULL OR

Line 142: RAISE FND_API.g_exc_unexpected_error;

138: );
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144:
145: IF l_sql_string IS NULL OR
146: l_sql_string = ''

Line 152: RAISE FND_API.G_EXC_ERROR;

148: IF (AMS_DEBUG_HIGH_ON) THEN
149:
150: AMS_Utility_PVT.debug_message(l_api_name ||': empty sql string');
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: ELSE
154: --l_sql_string := UPPER(l_sql_string);
155: --dbms_output.put_line('sql_string: ' || l_sql_string);
156:

Line 199: RAISE FND_API.G_EXC_ERROR;

195:
196: IF l_found = 'N' THEN
197: FND_MESSAGE.set_name('AMS', 'AMS_LIST_FROM_NOT_FOUND');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: IF (AMS_DEBUG_HIGH_ON) THEN
203:

Line 226: RAISE FND_API.G_EXC_ERROR;

222:
223: IF l_found = 'N' THEN
224: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_MASTER_TYPE');
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228: IF (AMS_DEBUG_HIGH_ON) THEN
229:
230: AMS_Utility_PVT.debug_message(l_api_name ||': master_type = '||l_master_type);

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: x_list_source_type := l_master_type;
234:
235: -------------------- create_listheader -----------------
236: -- Initialize API return status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Perform the database operation
240: IF (AMS_DEBUG_HIGH_ON) THEN
241:

Line 263: IF x_return_status <> FND_API.g_ret_sts_success THEN

259: p_listheader_rec => l_list_header_rec,
260: x_listheader_id => x_list_header_id
261: );
262:
263: IF x_return_status <> FND_API.g_ret_sts_success THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (AMS_DEBUG_HIGH_ON) THEN
267:

Line 264: RAISE FND_API.G_EXC_ERROR;

260: x_listheader_id => x_list_header_id
261: );
262:
263: IF x_return_status <> FND_API.g_ret_sts_success THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (AMS_DEBUG_HIGH_ON) THEN
267:
268: AMS_Utility_PVT.debug_message(l_api_name ||'listheader_id = '||x_list_header_id);

Line 299: IF x_return_status <> FND_API.g_ret_sts_success THEN

295: ) ;
296: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
297: FND_MSG_PUB.Add;
298:
299: IF x_return_status <> FND_API.g_ret_sts_success THEN
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: -- Standard check of p_commit.

Line 300: RAISE FND_API.G_EXC_ERROR;

296: FND_MESSAGE.set_name('AMS','after list action->'|| l_action_id|| '<-');
297: FND_MSG_PUB.Add;
298:
299: IF x_return_status <> FND_API.g_ret_sts_success THEN
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: -- Standard check of p_commit.
304:

Line 305: IF FND_API.To_Boolean(p_commit)

301: END IF;
302:
303: -- Standard check of p_commit.
304:
305: IF FND_API.To_Boolean(p_commit)
306: THEN
307: COMMIT WORK;
308: END IF;
309:

Line 328: p_encoded => FND_API.g_false,

324: FND_MSG_PUB.Add;
325: --END IF;
326:
327: FND_MSG_PUB.count_and_get(
328: p_encoded => FND_API.g_false,
329: p_count => x_msg_count,
330: p_data => x_msg_data
331: );
332: END IF;

Line 335: WHEN FND_API.G_EXC_ERROR THEN

331: );
332: END IF;
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
337: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
338: FND_MSG_PUB.Add;
339: -- Check if reset of the status is required

Line 340: x_return_status := FND_API.G_RET_STS_ERROR ;

336: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
337: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
338: FND_MSG_PUB.Add;
339: -- Check if reset of the status is required
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data);

Line 342: p_encoded => FND_API.g_false,

338: FND_MSG_PUB.Add;
339: -- Check if reset of the status is required
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
348: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
349: FND_MSG_PUB.Add;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
348: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
349: FND_MSG_PUB.Add;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.count_and_get(
352: p_encoded => FND_API.g_false,
353: p_count => x_msg_count,
354: p_data => x_msg_data);

Line 352: p_encoded => FND_API.g_false,

348: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
349: FND_MSG_PUB.Add;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.count_and_get(
352: p_encoded => FND_API.g_false,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355:
356: WHEN OTHERS THEN

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

356: WHEN OTHERS THEN
357: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
358: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
359: FND_MSG_PUB.Add;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: FND_MSG_PUB.count_and_get(
362: p_encoded => FND_API.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data);

Line 362: p_encoded => FND_API.g_false,

358: FND_MESSAGE.Set_Token('ROW', sqlerrm||' '||sqlcode);
359: FND_MSG_PUB.Add;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361: FND_MSG_PUB.count_and_get(
362: p_encoded => FND_API.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365: END CREATE_Segment_LIST;
366: