[Home] [Help]
17: -- 01-oct-2003 ssabesan Purge SDQ changes (bug 3170790)
18: -- 12-jun-2003 rsripada Added support to store device type
19: -- 10-apr-2003 ssabesan use last_wireless_contact_date for error logging
20: -- 31-mar-2003 rsripada Fix Online-query bug: 2878674
21: -- 28-mar-2003 rsripada Store synctime end in asg_user table
22: -- 25-mar-2003 ssabesan update synch_errors column with synch time errors
23: -- 25-feb-2003 rsripada Added validate_login method
24: -- 24-feb-2003 rsripada update hwm_tranid so that it can handle
25: -- exceptions in download
92: RETURN VARCHAR2 IS
93: l_stored_last_tranid NUMBER;
94: BEGIN
95: SELECT nvl(last_tranid, 0) into l_stored_last_tranid
96: FROM asg_user
97: WHERE user_name = p_user_name;
98:
99: IF (p_last_tranid > l_stored_last_tranid) THEN
100: return FND_API.G_TRUE;
268: -- This is relevant only for first synch
269: -- Raise error if password has expired.
270: -- Subsequent synchs raise error during authentication itself.
271: SELECT nvl(password_expired, 'N') into l_pwd_expired
272: FROM asg_user
273: WHERE user_name = p_clientid;
274: IF l_pwd_expired = 'Y' THEN
275: raise password_expired;
276: END IF;
339: --12.1
340: -- Start processing uploads when synchronized manually(i.e,not auto sync)
341: -- and when download is successful
342: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
343: asg_helper.log('Set ASG_USER hwm_tranid to '||l_sync_id||' for Process Upload to pick it up.','asg_cons_qpkg',g_stmt_level);
344: END IF;
345: asg_helper.set_synch_errmsg(p_clientid,l_sync_id,g_device_type, null);
346: EXCEPTION
347:
428: RAISE_APPLICATION_ERROR(-20997, 'Error during download in ' ||
429: 'asg_download.purgesdq ' || l_sqlerror_message);
430: END IF;
431:
432: -- Update the synctime end in asg_user table
433: l_last_tranid := asg_base.get_last_tranid();
434: IF ((l_last_tranid <= -1) OR
435: (g_first_synch = TRUE)) THEN
436: UPDATE asg_user
432: -- Update the synctime end in asg_user table
433: l_last_tranid := asg_base.get_last_tranid();
434: IF ((l_last_tranid <= -1) OR
435: (g_first_synch = TRUE)) THEN
436: UPDATE asg_user
437: SET last_tranid = l_last_tranid,
438: last_synch_date_end = sysdate,
439: prior_synch_date_end = null
440: WHERE user_name = p_clientid;
439: prior_synch_date_end = null
440: WHERE user_name = p_clientid;
441: ELSE
442: IF(g_last_synch_successful = FND_API.G_TRUE) THEN
443: UPDATE asg_user
444: SET last_tranid = l_last_tranid,
445: prior_synch_date_end = asg_base.get_last_synch_date(),
446: last_synch_date_end = sysdate
447: WHERE user_name = p_clientid;
445: prior_synch_date_end = asg_base.get_last_synch_date(),
446: last_synch_date_end = sysdate
447: WHERE user_name = p_clientid;
448: ELSE
449: UPDATE asg_user
450: SET last_tranid = l_last_tranid,
451: last_synch_date_end = sysdate
452: WHERE user_name = p_clientid;
453: END IF;
1372: IS
1373: PRAGMA AUTONOMOUS_TRANSACTION;
1374: l_first_synch NUMBER := 0;
1375: BEGIN
1376: UPDATE asg_user
1377: SET password_expired = p_pwd_expired
1378: WHERE user_name = p_user_name;
1379:
1380: -- Find out if this is the very first synch for this user.
1378: WHERE user_name = p_user_name;
1379:
1380: -- Find out if this is the very first synch for this user.
1381: SELECT count(*) into l_first_synch
1382: FROM asg_user
1383: WHERE user_name = p_user_name AND
1384: hwm_tranid IS NULL AND
1385: NOT EXISTS (SELECT 1
1386: FROM asg_purge_sdq
1446: 'asg_cons_qpkg',g_stmt_level);
1447: END IF;
1448: IF (g_last_synch_successful = FND_API.G_TRUE) THEN
1449: SELECT last_synch_date_end into l_last_synch_date
1450: FROM asg_user
1451: WHERE user_name = p_user_name;
1452: ELSE
1453: SELECT prior_synch_date_end into l_last_synch_date
1454: FROM asg_user
1450: FROM asg_user
1451: WHERE user_name = p_user_name;
1452: ELSE
1453: SELECT prior_synch_date_end into l_last_synch_date
1454: FROM asg_user
1455: WHERE user_name = p_user_name;
1456: END IF;
1457: return l_last_synch_date;
1458: END IF;