DBA Data[Home] [Help]

APPS.IEX_SEND_FFM_PVT dependencies on IEX_SEND_FFM_PVT

Line 1: PACKAGE BODY IEX_SEND_FFM_PVT as

1: PACKAGE BODY IEX_SEND_FFM_PVT as
2: /* $Header: iexvffmb.pls 120.4 2004/10/28 20:30:24 clchang ship $ */
3: -- Start of Comments
4: -- Package name : IEX_SEND_FFM_PVT
5: -- Purpose : Calling Fulfillement

Line 4: -- Package name : IEX_SEND_FFM_PVT

1: PACKAGE BODY IEX_SEND_FFM_PVT as
2: /* $Header: iexvffmb.pls 120.4 2004/10/28 20:30:24 clchang ship $ */
3: -- Start of Comments
4: -- Package name : IEX_SEND_FFM_PVT
5: -- Purpose : Calling Fulfillement
6: -- NOTE :
7: -- History :
8: -- 03/20/2001 CLCHANG Created.

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SEND_FFM_PVT';

8: -- 03/20/2001 CLCHANG Created.
9: -- END of Comments
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SEND_FFM_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvffmb.pls';
14:
15:
16:

Line 25: P_Content_Tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,

21:
22: PROCEDURE Validate_Media_Type
23: (
24: P_Init_Msg_List IN VARCHAR2 ,
25: P_Content_Tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,
28: X_Msg_Data OUT NOCOPY VARCHAR2
29: )

Line 32: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE ;

28: X_Msg_Data OUT NOCOPY VARCHAR2
29: )
30: IS
31: l_api_name CONSTANT VARCHAR2(30) := 'Validate Media_Type';
32: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE ;
33: l_content_id NUMBER;
34: l_media_type VARCHAR2(30);
35: l_email VARCHAR2(1000) ;
36: l_printer VARCHAR2(1000) ;

Line 92: P_Procedure_name => 'IEX_SEND_FFM_PVT.VALIDATE_MEDIA_TYPE',

88: FND_MSG_PUB.Add;
89: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
90: /* IEX_CONC_REQUEST_MSG_PKG.Log_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;

Line 153: P_Content_tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,

149: P_User_id IN NUMBER,
150: P_Server_id IN NUMBER,
151: P_Party_id IN NUMBER,
152: P_Subject IN VARCHAR2,
153: P_Content_tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,
154: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
155: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
156: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
157: --p_bind_cnt_tbl IN IEX_SEND_FFM_PVT.BIND_CNT_TBL,

Line 157: --p_bind_cnt_tbl IN IEX_SEND_FFM_PVT.BIND_CNT_TBL,

153: P_Content_tbl IN IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE,
154: p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
155: p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
156: p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
157: --p_bind_cnt_tbl IN IEX_SEND_FFM_PVT.BIND_CNT_TBL,
158: /*
159: P_Content_ID IN NUMBER,
160: P_Media_Type IN VARCHAR2,
161: P_Request_Type IN VARCHAR2,

Line 180: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE ;

176: l_api_name CONSTANT VARCHAR2(30) := 'IEXVFFMB';
177: l_api_version NUMBER := 1.0;
178: l_commit VARCHAR2(5) ;
179: --
180: l_Content_tbl IEX_SEND_FFM_PVT.CONTENT_TBL_TYPE ;
181: l_content_id NUMBER;
182: l_media_type VARCHAR2(30);
183: l_request_type VARCHAR2(30);
184: l_user_note VARCHAR2(1000);

Line 189: --l_bind_cnt_tbl IEX_SEND_FFM_PVT.BIND_CNT_TBL := p_bind_cnt_tbl;

185: l_document_type VARCHAR2(100);
186: l_bind_var JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
187: l_bind_var_type JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
188: l_bind_val JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
189: --l_bind_cnt_tbl IEX_SEND_FFM_PVT.BIND_CNT_TBL := p_bind_cnt_tbl;
190: --l_bind_cnt NUMBER;
191: --l_bind_total NUMBER;
192: l_email VARCHAR2(1000) ;
193: l_printer VARCHAR2(1000) ;

Line 288: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

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',
289: P_MESSAGE => 'NO MEDIA_TYPE'); */
290: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
291: -- IF PG_DEBUG < 10 THEN
292: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 325: P_Procedure_name => 'IEX_SEND_FFM_PVT.VALIDATE_MEDIA_TYPE',

321: --msg
322: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
323: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
324: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
325: P_Procedure_name => 'IEX_SEND_FFM_PVT.VALIDATE_MEDIA_TYPE',
326: P_MESSAGE => 'ERROR To Start_Request;'); */
327: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
328: x_msg_count := l_msg_count;
329: x_msg_data := l_msg_data;

Line 429: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

425: --FND_MSG_PUB.Add;
426: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
427: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
428: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
429: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
430: P_MESSAGE => 'ERROR To GET_CONTENT;NO_DATA_FOUND;'); */
431: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
432: -- IF PG_DEBUG < 10 THEN
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 444: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

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,
444: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
445: P_MESSAGE => 'ERROR To GET_CONTENT;'); */
446: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
447: -- IF PG_DEBUG < 10 THEN
448: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 498: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

494: --
495: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
496: /* IEX_CONC_REQUEST_MSG_PKG.Log_Error(
497: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
498: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
499: P_MESSAGE => 'ERROR To GET_XML;');
500:
501: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
502: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 503: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

499: P_MESSAGE => 'ERROR To GET_XML;');
500:
501: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
502: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
503: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
504: P_MESSAGE => 'ERROR REQUEST_ID:'|| l_request_id
505: || ' l_msg_data= ' || l_msg_data); */
506: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
507:

Line 567: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

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,
567: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
568: P_MESSAGE => 'ERROR To SUBMIT_REQUEST;');
569:
570: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
571: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 572: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

568: P_MESSAGE => 'ERROR To SUBMIT_REQUEST;');
569:
570: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
571: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
572: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
573: P_MESSAGE => 'ERROR REQUEST_ID:'|| l_request_id ||
574: ' l_msg_data= ' || l_msg_data); */
575: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
576:

Line 597: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',

593: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
594: /*
595: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
596: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
597: P_Procedure_name => 'IEX_SEND_FFM_PVT.SEND_FFM',
598: P_MESSAGE => 'REQUEST_ID:'|| l_request_id); */
599: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
600: -- IF PG_DEBUG < 10 THEN
601: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 665: END IEX_SEND_FFM_PVT;

661:
662: BEGIN
663: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
664:
665: END IEX_SEND_FFM_PVT;