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.CSM_CLIENT_NFN_LOG_PKG dependencies on CSM_CLIENT_NFN_LOG

Line 1: PACKAGE BODY CSM_CLIENT_NFN_LOG_PKG AS

1: PACKAGE BODY CSM_CLIENT_NFN_LOG_PKG AS
2: /* $Header: csmucnlb.pls 120.1.12010000.1 2009/08/03 06:33:08 appldev noship $ */
3:
4: /*
5: * The function is to upload csm_clinet_nfn_log auto sync table to base table

Line 17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_PKG'; -- package name

13: -- --------- ------------------- ------------------------------------------
14: -- Enter procedure, function bodies as shown below
15:
16: /*** Globals ***/
17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21:

Line 18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG'; -- publication item name

14: -- Enter procedure, function bodies as shown below
15:
16: /*** Globals ***/
17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21:
22: g_cl_nfn_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC';

Line 22: g_cl_nfn_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC';

18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21:
22: g_cl_nfn_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC';
23: g_cl_nfn_log_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG';
24: g_cl_nfn_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC_S';
25: g_cl_nfn_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
26: g_cl_nfn_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 23: g_cl_nfn_log_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG';

19: g_debug_level NUMBER; -- debug level
20:
21:
22: g_cl_nfn_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC';
23: g_cl_nfn_log_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG';
24: g_cl_nfn_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC_S';
25: g_cl_nfn_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
26: g_cl_nfn_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG');

Line 24: g_cl_nfn_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC_S';

20:
21:
22: g_cl_nfn_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC';
23: g_cl_nfn_log_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG';
24: g_cl_nfn_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC_S';
25: g_cl_nfn_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
26: g_cl_nfn_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG');
28:

Line 27: CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG');

23: g_cl_nfn_log_table_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG';
24: g_cl_nfn_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_CLIENT_NFN_LOG_ACC_S';
25: g_cl_nfn_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
26: g_cl_nfn_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG');
28:
29:
30: CURSOR c_client_nfn_log_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
31: SELECT *

Line 32: FROM csm_client_nfn_log_inq

28:
29:
30: CURSOR c_client_nfn_log_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
31: SELECT *
32: FROM csm_client_nfn_log_inq
33: WHERE tranid$$ = b_tranid
34: AND clid$$cs = b_user_name;
35:
36: -----------------------------------------------------------------------------------------------------------

Line 70: FROM CSM_CLIENT_NFN_LOG_ACC ACC;

66:
67: -- get all notifications in which user is a recipient
68: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
69: SELECT DISTINCT notification_id
70: FROM CSM_CLIENT_NFN_LOG_ACC ACC;
71:
72: BEGIN
73: /* CSM_UTIL_PKG.LOG('Entering CLIENT_NFN_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,
74: g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

Line 112: l_notification_id csm_client_nfn_log.notification_id%TYPE ;

108: x_reject_row OUT NOCOPY BOOLEAN
109: ) IS
110:
111:
112: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
113: l_object_id csm_client_nfn_log.object_id%TYPE;
114: l_object_name csm_client_nfn_log.object_name%TYPE;
115: l_user_name asg_user.user_name%TYPE;
116:

Line 113: l_object_id csm_client_nfn_log.object_id%TYPE;

109: ) IS
110:
111:
112: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
113: l_object_id csm_client_nfn_log.object_id%TYPE;
114: l_object_name csm_client_nfn_log.object_name%TYPE;
115: l_user_name asg_user.user_name%TYPE;
116:
117: l_rowid ROWID;

Line 114: l_object_name csm_client_nfn_log.object_name%TYPE;

110:
111:
112: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
113: l_object_id csm_client_nfn_log.object_id%TYPE;
114: l_object_name csm_client_nfn_log.object_name%TYPE;
115: l_user_name asg_user.user_name%TYPE;
116:
117: l_rowid ROWID;
118:

Line 122: FROM CSM_CLIENT_NFN_LOG

118:
119: CURSOR c_record_exists
120: (b_notification_id NUMBER
121: )IS SELECT ROWID
122: FROM CSM_CLIENT_NFN_LOG
123: WHERE notification_id = b_notification_id;
124:
125:
126:

Line 132: 'CSM_CLIENT_NFN_LOG.APPLY_INSERT',

128:
129:
130: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
131: || ' for PK ' || p_record.notification_id,
132: 'CSM_CLIENT_NFN_LOG.APPLY_INSERT',
133: FND_LOG.LEVEL_PROCEDURE );
134:
135: /***************************************************************************
136: ** Initialize API return status to success

Line 144: insert into csm_client_nfn_log(NOTIFICATION_ID,

140: l_user_name := p_record.CLID$$CS;
141: l_object_id := p_record.object_id;
142: l_object_name := p_record.object_name;
143:
144: insert into csm_client_nfn_log(NOTIFICATION_ID,
145: OBJECT_ID ,
146: OBJECT_NAME,
147: MESSAGE,
148: STATUS,

Line 193: --delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

189: FND_LOG.LEVEL_ERROR );
190: RETURN ;
191: END IF;
192:
193: --delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
194: -- success
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196: COMMIT;
197:

Line 224: FROM csm_client_nfn_log

220: )
221: IS
222: CURSOR c_client_nfn_log ( b_notification_id NUMBER ) IS
223: SELECT *
224: FROM csm_client_nfn_log
225: WHERE notification_id = b_notification_id;
226:
227: CURSOR c_last_update_date ( b_notification_id NUMBER)
228: IS

Line 230: FROM csm_client_nfn_log

226:
227: CURSOR c_last_update_date ( b_notification_id NUMBER)
228: IS
229: SELECT LAST_UPDATE_DATE
230: FROM csm_client_nfn_log
231: WHERE notification_id = b_notification_id;
232:
233:
234: --variable declarations

Line 238: l_notification_id csm_client_nfn_log.notification_id%TYPE ;

234: --variable declarations
235:
236: l_item_rec c_client_nfn_log%ROWTYPE;
237:
238: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
239: l_object_id csm_client_nfn_log.object_id%TYPE;
240: l_object_name csm_client_nfn_log.object_name%TYPE;
241: l_user_name asg_user.user_name%TYPE;
242:

Line 239: l_object_id csm_client_nfn_log.object_id%TYPE;

235:
236: l_item_rec c_client_nfn_log%ROWTYPE;
237:
238: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
239: l_object_id csm_client_nfn_log.object_id%TYPE;
240: l_object_name csm_client_nfn_log.object_name%TYPE;
241: l_user_name asg_user.user_name%TYPE;
242:
243: l_rowid ROWID;

Line 240: l_object_name csm_client_nfn_log.object_name%TYPE;

236: l_item_rec c_client_nfn_log%ROWTYPE;
237:
238: l_notification_id csm_client_nfn_log.notification_id%TYPE ;
239: l_object_id csm_client_nfn_log.object_id%TYPE;
240: l_object_name csm_client_nfn_log.object_name%TYPE;
241: l_user_name asg_user.user_name%TYPE;
242:
243: l_rowid ROWID;
244:

Line 250: 'CSM_CLIENT_NFN_LOG.APPLY_UPDATE',

246:
247:
248: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
249: || ' for PK ' || p_record.notification_id,
250: 'CSM_CLIENT_NFN_LOG.APPLY_UPDATE',
251: FND_LOG.LEVEL_PROCEDURE );
252: /***************************************************************************
253: ** Initialize API return status to success
254: ***************************************************************************/

Line 272: fnd_message.set_name ('CSM', 'CSM_CLIENT_NFN_LOG');

268: IF (c_client_nfn_log%ISOPEN) THEN
269: CLOSE c_client_nfn_log;
270: END IF;
271:
272: fnd_message.set_name ('CSM', 'CSM_CLIENT_NFN_LOG');
273: fnd_message.set_token ('NOTIFICATION_ID', p_record.notification_id);
274: fnd_msg_pub.add;
275: RAISE no_data_found;
276: END IF;

Line 286: UPDATE csm_client_nfn_log

282: /***************************************************************************
283: ** Update the record
284: ***************************************************************************/
285:
286: UPDATE csm_client_nfn_log
287: SET NOTIFICATION_ID = p_record.notification_id,
288: OBJECT_ID = p_record.object_id ,
289: OBJECT_NAME = p_record.object_name,
290: MESSAGE = p_record.message,

Line 312: -- delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

308: RAISE NO_DATA_FOUND;
309: END IF;
310:
311: -- success
312: -- delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: EXCEPTION
316:

Line 405: publication item CSM_CLIENT_NFN_LOG

401: ----------------------------------------------------------------------------------------------------------------------
402:
403: /***
404: APPLY_CLIENT_CHANGE procedure is called by CSM_SERVICEP_WRAPPER_PKG, for upward sync of
405: publication item CSM_CLIENT_NFN_LOG
406: ***/
407: PROCEDURE APPLY_CLIENT_CHANGES
408: (
409: p_user_name IN VARCHAR2,

Line 530: END CSM_CLIENT_NFN_LOG_PKG;

526:
527: END APPLY_CLIENT_CHANGES;
528:
529:
530: END CSM_CLIENT_NFN_LOG_PKG;