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_AUTO_SYNC_LOG_PKG dependencies on CSM_AUTO_SYNC_LOG

Line 1: PACKAGE BODY CSM_AUTO_SYNC_LOG_PKG AS

1: PACKAGE BODY CSM_AUTO_SYNC_LOG_PKG AS
2: /* $Header: csmuaslb.pls 120.4 2011/01/10 10:27:23 saradhak noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync_log auto sync table to base table

Line 5: * The function is to upload csm_auto_sync_log auto sync table to base table

1: PACKAGE BODY CSM_AUTO_SYNC_LOG_PKG AS
2: /* $Header: csmuaslb.pls 120.4 2011/01/10 10:27:23 saradhak noship $ */
3:
4: /*
5: * The function is to upload csm_auto_sync_log auto sync table to base table
6: */
7:
8: --
9: -- MODIFICATION HISTORY

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

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

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

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

Line 21: g_auto_sync_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC';

17: g_object_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_PKG'; -- package name
18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC';
22: g_auto_sync_log_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG';
23: g_auto_sync_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC_S';
24: g_auto_sync_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 22: g_auto_sync_log_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG';

18: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG'; -- publication item name
19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC';
22: g_auto_sync_log_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG';
23: g_auto_sync_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC_S';
24: g_auto_sync_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_LOG');

Line 23: g_auto_sync_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC_S';

19: g_debug_level NUMBER; -- debug level
20:
21: g_auto_sync_log_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC';
22: g_auto_sync_log_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG';
23: g_auto_sync_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC_S';
24: g_auto_sync_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_LOG');
27:

Line 26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_LOG');

22: g_auto_sync_log_table_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG';
23: g_auto_sync_log_seq_name CONSTANT VARCHAR2(30) := 'CSM_AUTO_SYNC_LOG_ACC_S';
24: g_auto_sync_log_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
25: g_auto_sync_log_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSM_AUTO_SYNC_LOG');
27:
28:
29: CURSOR c_auto_sync_log_inq( b_user_name VARCHAR2, b_tranid NUMBER) IS
30: SELECT *

Line 31: FROM csm_auto_sync_log_inq

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

Line 68: FROM CSM_AUTO_SYNC_LOG_ACC ACC;

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

Line 88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_LOG_PKG.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

84: l_sqlerrno := to_char(SQLCODE);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);
86: l_error_msg := ' Exception in AUTO_SYNC_LOG_ACC_PROCESSOR for for user_id: ' || p_user_id
87: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_LOG_PKG.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
89: RAISE;
90: */
91: RETURN;
92: END AUTO_SYNC_LOG_ACC_PROCESSOR;

Line 108: l_id csm_auto_sync_log.id%TYPE;

104: x_return_status IN OUT NOCOPY VARCHAR2,
105: x_reject_row OUT NOCOPY BOOLEAN
106: ) IS
107:
108: l_id csm_auto_sync_log.id%TYPE;
109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;

Line 109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;

105: x_reject_row OUT NOCOPY BOOLEAN
106: ) IS
107:
108: l_id csm_auto_sync_log.id%TYPE;
109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;

Line 110: l_as_type csm_auto_sync_log.as_type%TYPE ;

106: ) IS
107:
108: l_id csm_auto_sync_log.id%TYPE;
109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;
114: l_email_sent csm_auto_sync_log.email_sent%TYPE;

Line 111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;

107:
108: l_id csm_auto_sync_log.id%TYPE;
109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;
114: l_email_sent csm_auto_sync_log.email_sent%TYPE;
115:

Line 112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;

108: l_id csm_auto_sync_log.id%TYPE;
109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;
114: l_email_sent csm_auto_sync_log.email_sent%TYPE;
115:
116: l_user_name asg_user.user_name%TYPE;

Line 113: l_as_result csm_auto_sync_log.as_result%TYPE;

109: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;
114: l_email_sent csm_auto_sync_log.email_sent%TYPE;
115:
116: l_user_name asg_user.user_name%TYPE;
117:

Line 114: l_email_sent csm_auto_sync_log.email_sent%TYPE;

110: l_as_type csm_auto_sync_log.as_type%TYPE ;
111: l_as_start_date csm_auto_sync_log.as_start_date%TYPE ;
112: l_as_finish_date csm_auto_sync_log.as_finish_date%TYPE ;
113: l_as_result csm_auto_sync_log.as_result%TYPE;
114: l_email_sent csm_auto_sync_log.email_sent%TYPE;
115:
116: l_user_name asg_user.user_name%TYPE;
117:
118: l_rowid ROWID;

Line 123: FROM CSM_AUTO_SYNC_LOG

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

Line 133: 'CSM_AUTO_SYNC_LOG.APPLY_INSERT',

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

Line 149: insert into csm_auto_sync_log(ID,

145: l_as_finish_date := p_record.as_finish_date;
146: l_as_result := p_record.as_result;
147: l_email_sent :=p_record.email_sent;
148:
149: insert into csm_auto_sync_log(ID,
150: NOTIFICATION_ID,
151: AS_TYPE,
152: AS_START_DATE,
153: AS_FINISH_DATE,

Line 200: -- delete csm_auto_sync_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

196:
197:
198:
199: -- success
200: -- delete csm_auto_sync_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: COMMIT;
203:
204: EXCEPTION

Line 230: FROM csm_auto_sync_log

226: )
227: IS
228: CURSOR c_auto_sync_log ( b_notification_id NUMBER ) IS
229: SELECT *
230: FROM csm_auto_sync_log
231: WHERE notification_id = b_notification_id;
232:
233: CURSOR c_last_update_date ( b_notification_id NUMBER)
234: IS

Line 237: FROM csm_auto_sync_log

233: CURSOR c_last_update_date ( b_notification_id NUMBER)
234: IS
235: SELECT LAST_UPDATE_DATE,
236: last_updated_by
237: FROM csm_auto_sync_log
238: WHERE notification_id = b_notification_id;
239:
240:
241: --variable declarations

Line 245: l_notification_id csm_auto_sync_log.notification_id%TYPE ;

241: --variable declarations
242:
243: l_item_rec c_auto_sync_log%ROWTYPE;
244:
245: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
246: l_id csm_auto_sync_log.id%TYPE ;
247: l_user_name asg_user.user_name%TYPE;
248:
249:

Line 246: l_id csm_auto_sync_log.id%TYPE ;

242:
243: l_item_rec c_auto_sync_log%ROWTYPE;
244:
245: l_notification_id csm_auto_sync_log.notification_id%TYPE ;
246: l_id csm_auto_sync_log.id%TYPE ;
247: l_user_name asg_user.user_name%TYPE;
248:
249:
250: l_rowid ROWID;

Line 257: 'CSM_AUTO_SYNC_LOG.APPLY_UPDATE',

253:
254:
255: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
256: || ' for PK ' || p_record.notification_id,
257: 'CSM_AUTO_SYNC_LOG.APPLY_UPDATE',
258: FND_LOG.LEVEL_PROCEDURE );
259: /***************************************************************************
260: ** Initialize API return status to success
261: ***************************************************************************/

Line 279: fnd_message.set_name ('CSM', 'CSM_AUTO_SYNC_LOG');

275: IF (c_auto_sync_log%ISOPEN) THEN
276: CLOSE c_auto_sync_log;
277: END IF;
278:
279: fnd_message.set_name ('CSM', 'CSM_AUTO_SYNC_LOG');
280: fnd_message.set_token ('NOTIFICATION_ID', p_record.notification_id);
281: fnd_msg_pub.add;
282: RAISE no_data_found;
283: END IF;

Line 293: UPDATE csm_auto_sync_log

289: /***************************************************************************
290: ** Update the record
291: ***************************************************************************/
292:
293: UPDATE csm_auto_sync_log
294: SET ID = p_record.id,
295: NOTIFICATION_ID = p_record.notification_id,
296: AS_TYPE = p_record.as_type,
297: AS_START_DATE = p_record.as_start_date,

Line 320: -- delete csm_auto_sync_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

316: END IF;
317:
318:
319: -- success
320: -- delete csm_auto_sync_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: EXCEPTION
324:

Line 418: publication item CSM_AUTO_SYNC_LOG

414: ----------------------------------------------------------------------------------------------------------------------
415:
416: /***
417: APPLY_CLIENT_CHANGE procedure is called by CSM_SERVICEP_WRAPPER_PKG, for upward sync of
418: publication item CSM_AUTO_SYNC_LOG
419: ***/
420: PROCEDURE APPLY_CLIENT_CHANGES
421: (
422: p_user_name IN VARCHAR2,

Line 541: END CSM_AUTO_SYNC_LOG_PKG;

537:
538: END APPLY_CLIENT_CHANGES;
539:
540:
541: END CSM_AUTO_SYNC_LOG_PKG;