DBA Data[Home] [Help]

APPS.AMS_CELL_INTEGRATE_PVT dependencies on FND_MSG_PUB

Line 18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

14: -- 04/03/02 yxliu check if sql is empty before call list generation
15: -- API to avoid endless loop
16: ---------------------------------------------------------------------
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
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

Line 19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

15: -- API to avoid endless loop
16: ---------------------------------------------------------------------
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
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,

Line 20: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

16: ---------------------------------------------------------------------
17:
18: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
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,

Line 112: FND_MSG_PUB.initialize;

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
116: IF (AMS_DEBUG_HIGH_ON) THEN

Line 121: FND_MSG_PUB.Add;

117: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
118: FND_MESSAGE.Set_Token('ROW',
119: 'AMS_ListGeneration_PKG.create_segemnt_list: Start',
120: TRUE);
121: FND_MSG_PUB.Add;
122: END IF;
123:
124: --------------------- find source type -----------------------
125: IF (AMS_DEBUG_HIGH_ON) THEN

Line 198: FND_MSG_PUB.Add;

194: x_counter => l_from_counter) ;
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

Line 225: FND_MSG_PUB.Add;

221: x_source_object_pk_field => l_source_object_pk_field);
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:

Line 297: FND_MSG_PUB.Add;

293: p_action_rec => l_action_rec,
294: x_action_id => l_action_id
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;

Line 312: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

308: END IF;
309:
310: -- Success Message
311: -- MMSG
312: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
313: --THEN
314: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
315: FND_MESSAGE.Set_Token('ROW', 'AMS_CELL_PVT.create_segment_list: ');
316: FND_MSG_PUB.Add;

Line 316: FND_MSG_PUB.Add;

312: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
313: --THEN
314: FND_MESSAGE.Set_Name('AMS', 'API_SUCCESS');
315: FND_MESSAGE.Set_Token('ROW', 'AMS_CELL_PVT.create_segment_list: ');
316: FND_MSG_PUB.Add;
317: --END IF;
318:
319:
320: --IF (AMS_DEBUG_HIGH_ON) THEN

Line 324: FND_MSG_PUB.Add;

320: --IF (AMS_DEBUG_HIGH_ON) THEN
321: --THEN
322: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
323: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_segment_list: END');
324: FND_MSG_PUB.Add;
325: --END IF;
326:
327: FND_MSG_PUB.count_and_get(
328: p_encoded => FND_API.g_false,

Line 327: FND_MSG_PUB.count_and_get(

323: FND_MESSAGE.Set_Token('ROW', 'AMS_ListGeneration_PKG.create_segment_list: END');
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: );

Line 338: FND_MSG_PUB.Add;

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
340: x_return_status := FND_API.G_RET_STS_ERROR ;
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,

Line 341: FND_MSG_PUB.count_and_get(

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);
345:

Line 349: FND_MSG_PUB.Add;

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 ;
351: FND_MSG_PUB.count_and_get(
352: p_encoded => FND_API.g_false,
353: p_count => x_msg_count,

Line 351: FND_MSG_PUB.count_and_get(

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);
355:

Line 359: FND_MSG_PUB.Add;

355:
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,

Line 361: FND_MSG_PUB.count_and_get(

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);
365: END CREATE_Segment_LIST;