APPS.ASG_CONS_QPKG dependencies on FND_API

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

49: g_stmt_level NUMBER := FND_LOG.LEVEL_STATEMENT;
50: g_err_level NUMBER := FND_LOG.LEVEL_ERROR;
51:
52: g_first_synch BOOLEAN := FALSE;
53: g_last_synch_successful VARCHAR2(1) := FND_API.G_TRUE;
54: g_device_type VARCHAR2(30):= NULL;
55:
56: PROCEDURE get_pubitem_list(p_pubitem_tbl IN OUT NOCOPY asg_base.pub_item_tbl_type)
57: IS

Line 100: return FND_API.G_TRUE;

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;
101: ELSE
102: return FND_API.G_FALSE;
103: END IF;
104:

Line 102: return FND_API.G_FALSE;

98:
99: IF (p_last_tranid > l_stored_last_tranid) THEN
100: return FND_API.G_TRUE;
101: ELSE
102: return FND_API.G_FALSE;
103: END IF;
104:
105: END is_previous_synch_successful;
106:

Line 192: = FND_API.G_FALSE THEN

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

Line 279: = FND_API.G_FALSE THEN

275: raise password_expired;
276: END IF;
277: -- Check if user's synch is disabled
278: IF asg_helper.is_user_synch_enabled(p_clientid,l_disabled_synch_message)
279: = FND_API.G_FALSE THEN
280: raise synch_disabled;
281: END IF;
282: -- Initialize all the session information except the list of pubitems
283: -- to be downloaded

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

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

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

704: l_str VARCHAR2(1024);
705: l_ret varchar2(2);
706: BEGIN
707: l_ret := is_previous_synch_successful(p_user_name,p_last_tranid);
708: IF( l_ret = FND_API.G_TRUE ) THEN
709: --previous synch was successful
710: IF(asg_helper.check_is_log_enabled(g_stmt_level))
711: THEN
712: asg_helper.log('Prev synch successful ',

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

781: l_upload_tranid,
782: l_detect_conflict,
783: l_pubitem_tbl);
784:
785: IF (l_detect_conflict = FND_API.G_FALSE) THEN
786: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
787: asg_helper.log('No need to check for conflicts.',
788: 'asg_cons_qpkg',g_stmt_level);
789: END IF;

Line 840: p_detect_conflict := FND_API.G_FALSE;

836: l_pub_detect_conflict VARCHAR2(1);
837: l_conf_pubs VARCHAR2(2000) := NULL;
838: BEGIN
839:
840: p_detect_conflict := FND_API.G_FALSE;
841: l_conf_pis_exist := conflict_pub_items_exist(p_user_name,
842: p_upload_tranid);
843: IF (l_conf_pis_exist = asg_base.G_NO) THEN
844: return;

Line 934: p_detect_conflict := FND_API.G_TRUE;

930: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
931:
932: -- Some pubs need conflict detection
933: IF (l_counter > 1) THEN
934: p_detect_conflict := FND_API.G_TRUE;
935: IF(asg_helper.check_is_log_enabled(g_stmt_level)) THEN
936: asg_helper.log('Need to detect conflicts.',
937: 'asg_cons_qpkg',g_stmt_level);
938: END IF;

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

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