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 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

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