APPS.ASG_CONS_QPKG dependencies on FND_API

Line 56: g_last_synch_successful VARCHAR2(1) := FND_API.G_TRUE;

52: g_err_level NUMBER := FND_LOG.LEVEL_ERROR;
53:
54: g_first_synch BOOLEAN := FALSE;
55: g_auto_synch CHAR := 'N';
56: g_last_synch_successful VARCHAR2(1) := FND_API.G_TRUE;
57: g_device_type VARCHAR2(30):= NULL;
58:
59: PROCEDURE get_pubitem_list(p_pubitem_tbl IN OUT NOCOPY asg_base.pub_item_tbl_type)
60: IS

Line 103: return FND_API.G_TRUE;

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;
104: ELSE
105: return FND_API.G_FALSE;
106: END IF;
107:

Line 105: return FND_API.G_FALSE;

101:
102: IF (p_last_tranid > l_stored_last_tranid) THEN
103: return FND_API.G_TRUE;
104: ELSE
105: return FND_API.G_FALSE;
106: END IF;
107:
108: END is_previous_synch_successful;
109:

Line 196: = FND_API.G_FALSE THEN

192:
193: BEGIN
194: -- Check if user's synch is disabled
195: IF asg_helper.is_user_synch_enabled(p_clientid,l_disabled_synch_message)
196: = FND_API.G_FALSE THEN
197: raise synch_disabled;
198: END IF;
199: asg_base.set_upload_tranid(p_tranid);
200: --set hwm_tranid to tranid-1 and make synch_errors null

Line 313: = FND_API.G_FALSE THEN

309: raise password_expired;
310: END IF;
311: -- Check if user's synch is disabled
312: IF asg_helper.is_user_synch_enabled(p_clientid,l_disabled_synch_message)
313: = FND_API.G_FALSE THEN
314: raise synch_disabled;
315: END IF;
316: -- Initialize all the session information except the list of pubitems
317: -- to be downloaded

Line 478: IF(g_last_synch_successful = FND_API.G_TRUE) THEN

474: last_synch_date_end = sysdate,
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

Line 749: IF( l_ret = FND_API.G_TRUE ) THEN

745: l_str VARCHAR2(1024);
746: l_ret varchar2(2);
747: BEGIN
748: l_ret := is_previous_synch_successful(p_user_name,p_last_tranid);
749: IF( l_ret = FND_API.G_TRUE ) THEN
750: --previous synch was successful
751: IF(asg_helper.check_is_log_enabled(g_stmt_level))
752: THEN
753: asg_helper.log('Prev synch successful ',

Line 826: IF (l_detect_conflict = FND_API.G_FALSE) THEN

822: l_upload_tranid,
823: l_detect_conflict,
824: l_pubitem_tbl);
825:
826: IF (l_detect_conflict = FND_API.G_FALSE) THEN
827: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
828: asg_helper.log('No need to check for conflicts.',
829: 'asg_cons_qpkg',g_stmt_level);
830: END IF;

Line 881: p_detect_conflict := FND_API.G_FALSE;

877: l_pub_detect_conflict VARCHAR2(1);
878: l_conf_pubs VARCHAR2(2000) := NULL;
879: BEGIN
880:
881: p_detect_conflict := FND_API.G_FALSE;
882: l_conf_pis_exist := conflict_pub_items_exist(p_user_name,
883: p_upload_tranid);
884: IF (l_conf_pis_exist = asg_base.G_NO) THEN
885: return;

Line 975: p_detect_conflict := FND_API.G_TRUE;

971: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
972:
973: -- Some pubs need conflict detection
974: IF (l_counter > 1) THEN
975: p_detect_conflict := FND_API.G_TRUE;
976: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
977: asg_helper.log('Need to detect conflicts.',
978: 'asg_cons_qpkg',g_stmt_level);
979: END IF;

Line 1489: IF (g_last_synch_successful = FND_API.G_TRUE) THEN

1485: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
1486: asg_helper.log('Last Synch Successful: ' || g_last_synch_successful,
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