APPS.HZ_BES_BO_DEFINITION_PVT dependencies on FND_API

Line 15: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

11: *
12: * ARGUMENTS
13: * IN:
14: * p_init_msg_list Initialize message stack if it is set to
15: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
16: * p_business_object_code Business Object Code.
17: * p_child_bo_code Child BO Code.
18: * p_entity_name Entity Name.
19: * p_user_mandated_flag User Mandated Flag.

Line 22: * be FND_API.G_RET_STS_SUCCESS (success),

18: * p_entity_name Entity Name.
19: * p_user_mandated_flag User Mandated Flag.
20: * OUT:
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.

Line 23: * FND_API.G_RET_STS_ERROR (error),

19: * p_user_mandated_flag User Mandated Flag.
20: * OUT:
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.
27: *

Line 24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

20: * OUT:
21: * x_return_status Return status after the call. The status can
22: * be FND_API.G_RET_STS_SUCCESS (success),
23: * FND_API.G_RET_STS_ERROR (error),
24: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
25: * x_msg_count Number of messages in message stack.
26: * x_msg_data Message text if x_msg_count is 1.
27: *
28: */

Line 31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

27: *
28: */
29:
30: PROCEDURE update_bod (
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_business_object_code IN VARCHAR2,
33: p_child_bo_code IN VARCHAR2,
34: p_entity_name IN VARCHAR2,
35: p_user_mandated_flag IN VARCHAR2,

Line 62: IF FND_API.to_Boolean(p_init_msg_list) THEN

58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
60:
61: --Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: --Initialize API return status to success.

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: --Initialize API return status to success.
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: -- check whether record has been updated by another user. If not, lock it.
70: BEGIN
71: SELECT OBJECT_VERSION_NUMBER,

Line 87: RAISE FND_API.G_EXC_ERROR;

83: p_object_version_number = l_ovn)) THEN
84: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
85: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_BUS_OBJ_DEFINITIONS');
86: FND_MSG_PUB.ADD;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: EXCEPTION
90: WHEN NO_DATA_FOUND THEN
91: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

Line 95: RAISE FND_API.G_EXC_ERROR;

91: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
92: FND_MESSAGE.SET_TOKEN('RECORD', 'business object definition');
93: FND_MESSAGE.SET_TOKEN('VALUE', 'Business Object Code: '||p_business_object_code||' Entity Name: '||p_entity_name||' Child BO Code: '||p_child_bo_code);
94: FND_MSG_PUB.ADD;
95: RAISE FND_API.G_EXC_ERROR;
96: END;
97:
98: p_object_version_number := nvl(l_ovn, 1) + 1;
99:

Line 110: RAISE FND_API.G_EXC_ERROR;

106: FND_MESSAGE.SET_TOKEN('CHILD_BO_CODE', p_child_bo_code);
107: END IF;
108: FND_MESSAGE.SET_TOKEN('BO_CODE', p_business_object_code);
109: FND_MSG_PUB.ADD;
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: -- Not doing any update if the existing flag setting is same as
114: -- user pass in

Line 163: RAISE FND_API.G_EXC_ERROR;

159:
160: IF(l_req_id IS NULL or l_req_id = 0) THEN
161: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: END IF;
166:
167: --Standard call to get message count and if count is 1, get message info.

Line 169: p_encoded => FND_API.G_FALSE,

165: END IF;
166:
167: --Standard call to get message count and if count is 1, get message info.
168: FND_MSG_PUB.Count_And_Get(
169: p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data);
172:
173: -- Debug info.

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: p_msg_level=>fnd_log.level_procedure);
185: END IF;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO update_bod_pvt;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO update_bod_pvt;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);

Line 192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO update_bod_pvt;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data);
195:
196: -- Debug info.

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO update_bod_pvt;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: END IF;
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO update_bod_pvt;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data);

Line 214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO update_bod_pvt;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213:
214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: -- Debug info.

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: END IF;
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO update_bod_pvt;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
237: FND_MSG_PUB.ADD;
238:

Line 239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

235: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
237: FND_MSG_PUB.ADD;
238:
239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243: -- Debug info.