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.ASG_CONS_QPKG dependencies on ASG_USER

Line 23: -- 28-mar-2003 rsripada Store synctime end in asg_user table

19: -- 01-oct-2003 ssabesan Purge SDQ changes (bug 3170790)
20: -- 12-jun-2003 rsripada Added support to store device type
21: -- 10-apr-2003 ssabesan use last_wireless_contact_date for error logging
22: -- 31-mar-2003 rsripada Fix Online-query bug: 2878674
23: -- 28-mar-2003 rsripada Store synctime end in asg_user table
24: -- 25-mar-2003 ssabesan update synch_errors column with synch time errors
25: -- 25-feb-2003 rsripada Added validate_login method
26: -- 24-feb-2003 rsripada update hwm_tranid so that it can handle
27: -- exceptions in download

Line 99: FROM asg_user

95: RETURN VARCHAR2 IS
96: l_stored_last_tranid NUMBER;
97: BEGIN
98: SELECT nvl(last_tranid, 0) into l_stored_last_tranid
99: FROM asg_user
100: WHERE user_name = p_user_name;
101:
102: IF (p_last_tranid > l_stored_last_tranid) THEN
103: return FND_API.G_TRUE;

Line 218: UPDATE asg_user SET hwm_tranid = nvl(l_sync_id,hwm_tranid) WHERE user_name = p_clientid;

214: IF (asg_base.is_auto_sync() = 'N')
215: AND (fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',asg_base.get_user_id(p_clientid))='Y') THEN
216:
217: l_sync_id:=set_sync_id(p_clientid, p_tranid);
218: UPDATE asg_user SET hwm_tranid = nvl(l_sync_id,hwm_tranid) WHERE user_name = p_clientid;
219: asg_apply.synchronous_process_upload(p_clientid);
220:
221: END IF;
222:

Line 306: FROM asg_user

302: -- This is relevant only for first synch
303: -- Raise error if password has expired.
304: -- Subsequent synchs raise error during authentication itself.
305: SELECT nvl(password_expired, 'N') into l_pwd_expired
306: FROM asg_user
307: WHERE user_name = p_clientid;
308: IF l_pwd_expired = 'Y' THEN
309: raise password_expired;
310: END IF;

Line 378: 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);

374: --12.1
375: -- Start processing uploads when synchronized manually(i.e,not auto sync)
376: -- and when download is successful
377: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
378: 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);
379: END IF;
380: asg_helper.set_synch_errmsg(p_clientid,l_sync_id,g_device_type, null);
381: EXCEPTION
382:

Line 468: -- Update the synctime end in asg_user table

464: RAISE_APPLICATION_ERROR(-20997, 'Error during download in ' ||
465: 'asg_download.purgesdq ' || l_sqlerror_message);
466: END IF;
467:
468: -- Update the synctime end in asg_user table
469: l_last_tranid := asg_base.get_last_tranid();
470: IF ((l_last_tranid <= -1) OR
471: (g_first_synch = TRUE)) THEN
472: UPDATE asg_user

Line 472: UPDATE asg_user

468: -- Update the synctime end in asg_user table
469: l_last_tranid := asg_base.get_last_tranid();
470: IF ((l_last_tranid <= -1) OR
471: (g_first_synch = TRUE)) THEN
472: UPDATE asg_user
473: SET last_tranid = l_last_tranid,
474: last_synch_date_end = sysdate,
475: prior_synch_date_end = null
476: WHERE user_name = p_clientid;

Line 479: UPDATE asg_user

475: prior_synch_date_end = null
476: WHERE user_name = p_clientid;
477: ELSE
478: IF(g_last_synch_successful = FND_API.G_TRUE) THEN
479: UPDATE asg_user
480: SET last_tranid = l_last_tranid,
481: prior_synch_date_end = asg_base.get_last_synch_date(),
482: last_synch_date_end = sysdate
483: WHERE user_name = p_clientid;

Line 485: UPDATE asg_user

481: prior_synch_date_end = asg_base.get_last_synch_date(),
482: last_synch_date_end = sysdate
483: WHERE user_name = p_clientid;
484: ELSE
485: UPDATE asg_user
486: SET last_tranid = l_last_tranid,
487: last_synch_date_end = sysdate
488: WHERE user_name = p_clientid;
489: END IF;

Line 1417: UPDATE asg_user

1413: IS
1414: PRAGMA AUTONOMOUS_TRANSACTION;
1415: l_first_synch NUMBER := 0;
1416: BEGIN
1417: UPDATE asg_user
1418: SET password_expired = p_pwd_expired
1419: WHERE user_name = p_user_name;
1420:
1421: -- Find out if this is the very first synch for this user.

Line 1423: FROM asg_user

1419: WHERE user_name = p_user_name;
1420:
1421: -- Find out if this is the very first synch for this user.
1422: SELECT count(*) into l_first_synch
1423: FROM asg_user
1424: WHERE user_name = p_user_name AND
1425: hwm_tranid IS NULL AND
1426: NOT EXISTS (SELECT 1
1427: FROM asg_purge_sdq

Line 1491: FROM asg_user

1487: 'asg_cons_qpkg',g_stmt_level);
1488: END IF;
1489: IF (g_last_synch_successful = FND_API.G_TRUE) THEN
1490: SELECT last_synch_date_end into l_last_synch_date
1491: FROM asg_user
1492: WHERE user_name = p_user_name;
1493: ELSE
1494: SELECT prior_synch_date_end into l_last_synch_date
1495: FROM asg_user

Line 1495: FROM asg_user

1491: FROM asg_user
1492: WHERE user_name = p_user_name;
1493: ELSE
1494: SELECT prior_synch_date_end into l_last_synch_date
1495: FROM asg_user
1496: WHERE user_name = p_user_name;
1497: END IF;
1498: return l_last_synch_date;
1499: END IF;