DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on FND_API

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: FROM csm_item_instances_acc
37: WHERE instance_id = p_instance_id;
38:
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER ',
42: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);
43:
44: -- get users who have access to this instance_ID

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);
57:
58: EXCEPTION
59: WHEN others THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: p_error_msg := 'FAILED ITEM_INSTANCE_MDIRTY_U_ECHUSER InstanceId:' || p_instance_id;
62: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_EXCEPTION);
63: RAISE;
64: END ITEM_INSTANCE_MDIRTY_U_ECHUSER;

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: p_error_msg OUT NOCOPY VARCHAR2,
69: x_return_status IN OUT NOCOPY VARCHAR2)
70: IS
71: BEGIN
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',
74: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
75:
76: CSM_ACC_PKG.Insert_Acc

Line 91: x_return_status := FND_API.G_RET_STS_ERROR;

87: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I', FND_LOG.LEVEL_PROCEDURE);
88:
89: EXCEPTION
90: WHEN others THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: p_error_msg := ' FAILED II_RELATIONSHIPS_ACC_I RELATIONSHIP_ID: ' || to_char(p_relationship_id);
93: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
94: RAISE;
95: END II_RELATIONSHIPS_ACC_I;

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: WHERE CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
122: AND CIR.SUBJECT_ID = c_instance_id;
123:
124: BEGIN
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
127: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
128:
129: IF p_instance_id IS NOT NULL AND p_user_id IS NOT NULL THEN

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
175: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
176: EXCEPTION
177: WHEN others THEN
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_PROCESSOR INSTANCE_ID: ' || to_char(p_instance_id);
180: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
181: RAISE;
182: END ITEM_INSTANCES_ACC_PROCESSOR;

Line 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

186: p_error_msg OUT NOCOPY VARCHAR2,
187: x_return_status IN OUT NOCOPY VARCHAR2)
188: IS
189: BEGIN
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D ',
192: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
193:
194: CSM_ACC_PKG.Delete_Acc

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D', FND_LOG.LEVEL_PROCEDURE);
205:
206: EXCEPTION
207: WHEN others THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: p_error_msg := ' FAILED II_RELATIONSHIPS_ACC_D RELATIONSHIP_ID: ' || to_char(p_relationship_id);
210: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
211: RAISE;
212: END II_RELATIONSHIPS_ACC_D;

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: l_inv_item_id NUMBER;
237: l_lst_vld_org_id NUMBER;
238:
239: BEGIN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',
242: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
243:
244: OPEN l_check_instance_ref(p_instance_id, p_user_id) ;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
276:
277: EXCEPTION
278: WHEN others THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_D INSTANCE_ID: ' || to_char(p_instance_id);
281: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_EXCEPTION);
282: RAISE;
283: END ITEM_INSTANCES_ACC_D;