DBA Data[Home] [Help]

APPS.IEX_SEND_FFM_PVT dependencies on FND_API

Line 50: IF FND_API.to_Boolean( p_init_msg_list )

46:
47: l_content_tbl := p_content_tbl;
48:
49: -- Initialize message list IF p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: -- Debug Message
59: iex_dunning_pvt.WriteLog('iexvffmb.pls:Validate Media Type');
60:

Line 95: raise FND_API.G_EXC_ERROR;

91: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
92: P_Procedure_name => 'IEX_SEND_FFM_PVT.VALIDATE_MEDIA_TYPE',
93: P_MESSAGE => 'NO MEDIA_TYPE'); */
94: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
95: raise FND_API.G_EXC_ERROR;
96: end if;
97: end loop;
98:
99:

Line 105: WHEN FND_API.G_EXC_ERROR THEN

101: ( p_count => x_msg_count,
102: p_data => x_msg_data );
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
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

Line 106: x_return_status := FND_API.G_RET_STS_ERROR;

102: p_data => x_msg_data );
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
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: );

Line 115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

111: iex_dunning_pvt.WriteLog('iexvffmb:Validate:Exc Exception');
112: errmsg := SQLERRM;
113: iex_dunning_pvt.WriteLog('iexvffmb:Validate:error='||errmsg);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get
118: ( p_count => x_msg_count,
119: p_data => x_msg_data

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

112: errmsg := SQLERRM;
113: iex_dunning_pvt.WriteLog('iexvffmb:Validate:error='||errmsg);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MSG_PUB.Count_And_Get
118: ( p_count => x_msg_count,
119: p_data => x_msg_data
120: );

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: errmsg := SQLERRM;
123: iex_dunning_pvt.WriteLog('iexvffmb:Validate:error='||errmsg);
124:
125: WHEN OTHERS THEN
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.Count_And_Get
128: ( p_count => x_msg_count,
129: p_data => x_msg_data
130: );

Line 223: IF NOT FND_API.Compatible_API_Call ( l_api_version,

219: l_server_id := p_server_id;
220: l_subject := p_subject;
221:
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call ( l_api_version,
224: p_api_version_number,
225: l_api_name,
226: G_PKG_NAME )
227: THEN

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: p_api_version_number,
225: l_api_name,
226: G_PKG_NAME )
227: THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230:
231: -- Initialize message list IF p_init_msg_list is set to TRUE.
232: IF FND_API.to_Boolean( p_init_msg_list )

Line 232: IF FND_API.to_Boolean( p_init_msg_list )

228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230:
231: -- Initialize message list IF p_init_msg_list is set to TRUE.
232: IF FND_API.to_Boolean( p_init_msg_list )
233: THEN
234: FND_MSG_PUB.initialize;
235: END IF;
236:

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242: END IF;
243:
244:
245: -- Initialize API return status to SUCCESS
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: --
249: -- API body
250: --

Line 267: RAISE FND_API.G_EXC_ERROR;

263: p_token1 => 'PROFILE',
264: p_token1_value => 'USER_ID');
265:
266: END IF;
267: RAISE FND_API.G_EXC_ERROR;
268: END IF;
269: */
270:
271: -- Debug message

Line 284: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

280: x_msg_count => l_msg_count,
281: x_msg_data => l_msg_data
282: );
283:
284: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
285: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
286: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
287: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
288: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

Line 297: RAISE FND_API.G_EXC_ERROR;

293: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM : NO MEDIA_TYPE');
294: END IF;
295: x_msg_count := l_msg_count;
296: x_msg_data := l_msg_data;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: -- Debug message
301: -- IF PG_DEBUG < 10 THEN

Line 317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

313: x_msg_data => l_msg_data,
314: x_request_id => l_request_id
315: );
316:
317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
318: --dbms_output.put_line('no request id');
319: --FND_MESSAGE.Set_Name('IEX', 'IEX_NO_REQUEST_ID');
320: --FND_MSG_PUB.ADD;
321: --msg

Line 337: RAISE FND_API.G_EXC_ERROR;

333: END IF;
334: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
335: FND_MESSAGE.Set_Token ('INFO', 'not get request_id');
336: FND_MSG_PUB.Add;
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:
340:
341:

Line 439: RAISE FND_API.G_EXC_ERROR;

435: END IF;
436: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
437: FND_MESSAGE.Set_Token ('INFO', 'error to get_Content:no_data_found');
438: FND_MSG_PUB.Add;
439: RAISE FND_API.G_EXC_ERROR;
440: WHEN OTHERS THEN
441: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
442: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
443: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: END IF;
451: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
452: FND_MESSAGE.Set_Token ('INFO', 'error to get_content');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END;
456:
457: -- IF PG_DEBUG < 10 THEN
458: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

480: x_msg_data => l_msg_data,
481: x_content_xml => l_one_content_xml );
482:
483:
484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
485: --DBMS_OUTPUT.PUT_LINE('Message Data: '||l_msg_data);
486: --msg
487: -- IF PG_DEBUG < 10 THEN
488: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 512: RAISE FND_API.G_EXC_ERROR;

508: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
509: FND_MESSAGE.Set_Token ('INFO', 'error to get_content_XML');
510: FND_MSG_PUB.Add;
511:
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:
515: --clchang added for bug 3807829 08/04/2004
516: --keep the content xml to trace

Line 558: p_queue_response => FND_API.G_TRUE,

554: p_subject => l_subject,
555: p_party_id => l_party_id,
556: p_user_id => l_user_id,
557: p_server_id => l_server_id,
558: p_queue_response => FND_API.G_TRUE,
559: p_content_xml => l_content_xml,
560: p_request_id => l_request_id );
561:
562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: p_queue_response => FND_API.G_TRUE,
559: p_content_xml => l_content_xml,
560: p_request_id => l_request_id );
561:
562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: --msg
564: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
565: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
566: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 587: RAISE FND_API.G_EXC_ERROR;

583: x_msg_count := l_msg_count;
584: FND_MESSAGE.Set_Name('IEX', 'API_FAIL_SEND_FFM');
585: FND_MESSAGE.Set_Token ('INFO', 'error to submit_request');
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:
590:
591: x_request_id := l_request_id;

Line 610: IF FND_API.to_Boolean( p_commit )

606: -- END of API body
607: --
608:
609: -- Standard check for p_commit
610: IF FND_API.to_Boolean( p_commit )
611: THEN
612: COMMIT WORK;
613: END IF;
614:

Line 623: WHEN FND_API.G_EXC_ERROR THEN

619: ( p_count => x_msg_count,
620: p_data => x_msg_data );
621:
622: EXCEPTION
623: WHEN FND_API.G_EXC_ERROR THEN
624: -- IF PG_DEBUG < 10 THEN
625: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
626: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM: Exc_Error:'|| SQLERRM);
627: END IF;

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
626: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM: Exc_Error:'|| SQLERRM);
627: END IF;
628: ROLLBACK TO SEND_FFM_PUB;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get
631: ( p_count => x_msg_count,
632: p_data => x_msg_data
633: );

Line 635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

631: ( p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: -- IF PG_DEBUG < 10 THEN
637: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
638: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM: UnExc_Error:'||SQLERRM);
639: END IF;

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
638: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM: UnExc_Error:'||SQLERRM);
639: END IF;
640: ROLLBACK TO SEND_FFM_PUB;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get
643: ( p_count => x_msg_count,
644: p_data => x_msg_data
645: );

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
650: IEX_DEBUG_PUB.LogMessage('iexvffmb.pls:SEND_FFM: Other_Error:'||SQLERRM);
651: END IF;
652: ROLLBACK TO SEND_FFM_PUB;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: FND_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data
657: );