DBA Data[Home] [Help]

APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on FND_API

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41: --variable declarations
42: l_err_msg VARCHAR2(4000);
43:
44: BEGIN
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS' || ' for PK ' || to_char(p_counter_value_id);
47: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS', FND_LOG.LEVEL_PROCEDURE);
48:
49: -- Open USER IDs loop

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: CLOSE c_prop_value_ins;
69: END IF;
70:
71: p_error_msg := ' FAILED CTR_PROPERTY_READ_INS FOR COUNTER VALUE:' || to_char(p_counter_value_id);
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS',FND_LOG.LEVEL_EXCEPTION);
74: RAISE;
75:
76: END CTR_PROPERTY_READ_INS;

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: l_markdirty BOOLEAN;
101: l_pub_item_name VARCHAR2(240) := 'CSM_COUNTER_PROP_VALUES';
102:
103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD' || ' for PK(COUNTER VALUE ID) ' || to_char(p_counter_value_id);
106: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD', FND_LOG.LEVEL_PROCEDURE);
107:
108: -- Open USER IDs loop

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124: CLOSE c_prop_value_upd;
125: END IF;
126:
127: p_error_msg := ' FAILED CTR_PROPERTY_READ_UPD FOR COUNTER VALUE ID : ' || to_char(p_counter_value_id);
128: x_return_status := FND_API.G_RET_STS_ERROR;
129: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD',FND_LOG.LEVEL_EXCEPTION);
130: RAISE;
131:
132:

Line 158: x_return_status := FND_API.G_RET_STS_SUCCESS;

154: --variable declarations
155: l_err_msg VARCHAR2(4000);
156:
157: BEGIN
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: l_err_msg := 'Entering CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL' || ' for PK(COUNTER VALUE ID ' || to_char(p_counter_value_id);
160: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL', FND_LOG.LEVEL_PROCEDURE);
161:
162: -- Open counter property id loop

Line 184: x_return_status := FND_API.G_RET_STS_ERROR;

180: CLOSE c_prop_value_del;
181: END IF;
182:
183: p_error_msg := ' FAILED CTR_PROPERTY_READ_DEL FOR COUNTER VALUE ID : ' || to_char(p_counter_value_id);
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL',FND_LOG.LEVEL_EXCEPTION);
186: RAISE;
187:
188: END CTR_PROPERTY_READ_DEL;