APPS.CSM_UTIL_PKG dependencies on ASG_DEFER

Line 1521: IF asg_defer.is_deferred(p_user_name, p_tranid,p_pub_name, p_seqno)=FND_API.G_TRUE THEN

1517: END IF;
1518:
1519: -- Remove tracking table record if this record is deferred.
1520: -- reqd if tracking records are reapplied via MFS Admin pages
1521: IF asg_defer.is_deferred(p_user_name, p_tranid,p_pub_name, p_seqno)=FND_API.G_TRUE THEN
1522: BEGIN
1523: SELECT TRACKING_ID INTO l_tracking_id
1524: FROM CSM_DEFERRED_NFN_INFO
1525: WHERE DEFERRED_TRAN_ID=p_tranid

Line 1609: SELECT ERROR_DESCRIPTION FROM ASG_DEFERRED_TRANINFO

1605: ) IS
1606:
1607: CURSOR c_err_msg
1608: IS
1609: SELECT ERROR_DESCRIPTION FROM ASG_DEFERRED_TRANINFO
1610: WHERE DEVICE_USER_NAME = p_user_name
1611: AND DEFERRED_TRAN_ID = p_tranid
1612: AND OBJECT_NAME = p_pub_name
1613: AND SEQUENCE = p_seqno;

Line 1626: asg_defer.defer_row(p_user_name,

1622: log
1623: ( 'Entering DEFER_RECORD');
1624: END IF;
1625:
1626: asg_defer.defer_row(p_user_name,
1627: p_tranid,
1628: p_pub_name,
1629: p_seqno,
1630: p_error_msg,

Line 1638: log( 'asg_defer.defer_row failed:' || ' ' || p_error_msg);

1634: /*** check if defer was successfull ***/
1635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1636: /*** no -> log and return error ***/
1637:
1638: log( 'asg_defer.defer_row failed:' || ' ' || p_error_msg);
1639:
1640: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1641: log
1642: ( 'Leaving DEFER_RECORD');

Line 1711: asg_defer.reject_row(p_user_name,

1707: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1708: log( 'Entering REJECT_RECORD');
1709: END IF;
1710:
1711: asg_defer.reject_row(p_user_name,
1712: p_tranid,
1713: p_pub_name,
1714: p_seqno,
1715: p_error_msg,

Line 1720: log( 'asg_defer.reject_row failed:' || ' ' || p_error_msg);

1716: x_return_status);
1717:
1718: /*** check if reject was successfull ***/
1719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: log( 'asg_defer.reject_row failed:' || ' ' || p_error_msg);
1721: ELSIF IS_HTML5_USER(p_user_name) THEN --this is required since access_id will be different in client
1722: OPEN c_acc_id;
1723: FETCH c_acc_id INTO l_acc;
1724: CLOSE c_acc_id;

Line 1736: IF asg_defer.is_deferred(p_user_name, p_tranid,p_pub_name, p_seqno)=FND_API.G_FALSE THEN

1732: AND EXISTS(SELECT 1 FROM ASG_DELETE_QUEUE b
1733: WHERE b.QID=a.QID
1734: AND b.ATTRIBUTE1=p_pk) ;
1735:
1736: IF asg_defer.is_deferred(p_user_name, p_tranid,p_pub_name, p_seqno)=FND_API.G_FALSE THEN
1737: DELETE FROM CSM_HTML5_PARSED_DATA WHERE SESSION_ID=p_tranid AND SEQUENCE=p_seqno;
1738: END IF;
1739: END IF;
1740: END IF;