APPS.CSM_UTIL_PKG dependencies on FND_API

Line 1453: , p_encoded => FND_API.G_FALSE

1449: /*** API error -> retrieve error from message stack ***/
1450: IF FND_MSG_PUB.Count_Msg > 0 THEN
1451: FND_MSG_PUB.Get
1452: ( p_msg_index => 1
1453: , p_encoded => FND_API.G_FALSE
1454: , p_data => l_msg_data
1455: , p_msg_index_out => l_msg_dummy
1456: );
1457: l_fnd_message := l_msg_data;

Line 1463: , p_encoded => FND_API.G_FALSE

1459: IN 2 .. FND_MSG_PUB.Count_Msg
1460: LOOP
1461: FND_MSG_PUB.Get
1462: ( p_msg_index => l_counter
1463: , p_encoded => FND_API.G_FALSE
1464: , p_data => l_msg_data
1465: , p_msg_index_out => l_msg_dummy
1466: );
1467: l_fnd_message := l_fnd_message || FND_GLOBAL.Newline || l_msg_data;

Line 1510: x_return_status := FND_API.G_RET_STS_SUCCESS;

1506: x_return_status IN OUT NOCOPY VARCHAR2
1507: ) IS
1508: l_tracking_id NUMBER;
1509: BEGIN
1510: x_return_status := FND_API.G_RET_STS_SUCCESS;
1511:
1512: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1513: log
1514: ( 'Entering DELETE_RECORD');

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 1553: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1549: p_seqno,
1550: x_return_status);
1551:
1552:
1553: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1554: log( 'ASG Delete row unsuccessful');
1555:
1556: /*** error occurred ***/
1557: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', 'Unknown error');

Line 1587: x_return_status := FND_API.G_RET_STS_ERROR;

1583: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1584: log
1585: ( 'Leaving DELETE_RECORD');
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: END DELETE_RECORD;
1589:
1590: /***
1591: This procedure is called by APPLY_CLIENT_CHANGES wrapper procedure

Line 1619: x_return_status := FND_API.G_RET_STS_SUCCESS;

1615: l_error_msg VARCHAR2(4000);
1616: l_t VARCHAR2(1);
1617:
1618: BEGIN
1619: x_return_status := FND_API.G_RET_STS_SUCCESS;
1620:
1621: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1622: log
1623: ( 'Entering DEFER_RECORD');

Line 1635: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1631: x_return_status);
1632:
1633:
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:

Line 1675: x_return_status := FND_API.G_RET_STS_ERROR;

1671: log
1672: ( 'Leaving DEFER_RECORD');
1673: END IF;
1674:
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: END DEFER_RECORD;
1677:
1678: /***
1679: This procedure is called by APPLY_CLIENT_CHANGES wrapper procedure

Line 1705: x_return_status := FND_API.G_RET_STS_SUCCESS;

1701:
1702: l_acc NUMBER;
1703:
1704: BEGIN
1705: x_return_status := FND_API.G_RET_STS_SUCCESS;
1706:
1707: IF g_debug_level = CSM_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1708: log( 'Entering REJECT_RECORD');
1709: END IF;

Line 1719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1715: 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;

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;

Line 1747: x_return_status := FND_API.G_RET_STS_ERROR;

1743: log( 'Leaving REJECT_RECORD');
1744: END IF;
1745: EXCEPTION WHEN OTHERS THEN
1746: log( 'Exception occurred in REJECT_RECORD:' || ' ' || sqlerrm);
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748: END REJECT_RECORD;
1749:
1750:
1751: /* Two functions to check if field service palm is enabled. */