DBA Data[Home] [Help]

APPS.AMS_ITEM_CATEGORY_PVT dependencies on FND_API

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

13:
14: PROCEDURE Create_Category_Assignment
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_errorcode OUT NOCOPY NUMBER,
21: x_msg_count OUT NOCOPY NUMBER,

Line 18: p_commit IN VARCHAR2 := FND_API.G_FALSE,

14: PROCEDURE Create_Category_Assignment
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_errorcode OUT NOCOPY NUMBER,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,

Line 49: IF fnd_api.to_boolean (p_init_msg_list) THEN

45:
46:
47: BEGIN
48:
49: IF fnd_api.to_boolean (p_init_msg_list) THEN
50: fnd_msg_pub.initialize;
51: END IF;
52:
53: INV_ITEM_CATEGORY_PUB.Create_Category_Assignment

Line 66: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

62: p_category_set_id => l_category_set_id,
63: p_inventory_item_id => l_inventory_item_id,
64: p_organization_id => l_organization_id
65: );
66: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
67: RAISE FND_API.G_EXC_ERROR;
68:
69: /***** commented by ABHOLA
70: ELSE

Line 67: RAISE FND_API.G_EXC_ERROR;

63: p_inventory_item_id => l_inventory_item_id,
64: p_organization_id => l_organization_id
65: );
66: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
67: RAISE FND_API.G_EXC_ERROR;
68:
69: /***** commented by ABHOLA
70: ELSE
71: OPEN get_owner_id;

Line 77: p_init_msg_list => FND_API.g_false,

73: CLOSE get_owner_id;
74:
75: AMS_ObjectAttribute_PVT.modify_object_attribute(
76: p_api_version => l_api_version,
77: p_init_msg_list => FND_API.g_false,
78: p_commit => FND_API.g_false,
79: p_validation_level => FND_API.g_valid_level_full,
80: x_return_status => l_return_status_cue,
81: x_msg_count => x_msg_count,

Line 78: p_commit => FND_API.g_false,

74:
75: AMS_ObjectAttribute_PVT.modify_object_attribute(
76: p_api_version => l_api_version,
77: p_init_msg_list => FND_API.g_false,
78: p_commit => FND_API.g_false,
79: p_validation_level => FND_API.g_valid_level_full,
80: x_return_status => l_return_status_cue,
81: x_msg_count => x_msg_count,
82: x_msg_data => x_msg_data,

Line 79: p_validation_level => FND_API.g_valid_level_full,

75: AMS_ObjectAttribute_PVT.modify_object_attribute(
76: p_api_version => l_api_version,
77: p_init_msg_list => FND_API.g_false,
78: p_commit => FND_API.g_false,
79: p_validation_level => FND_API.g_valid_level_full,
80: x_return_status => l_return_status_cue,
81: x_msg_count => x_msg_count,
82: x_msg_data => x_msg_data,
83: p_object_type => 'PROD',

Line 91: IF FND_API.to_boolean(p_commit) THEN

87: );
88: ***********************************************/
89: END IF;
90:
91: IF FND_API.to_boolean(p_commit) THEN
92: COMMIT;
93: END IF;
94:
95: FND_MSG_PUB.Count_AND_Get

Line 98: p_encoded => FND_API.G_FALSE

94:
95: FND_MSG_PUB.Count_AND_Get
96: ( p_count => x_msg_count,
97: p_data => x_msg_data,
98: p_encoded => FND_API.G_FALSE
99: );
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

98: p_encoded => FND_API.G_FALSE
99: );
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: FND_MSG_PUB.count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data,

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

99: );
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: FND_MSG_PUB.count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data,
107: p_encoded => FND_API.G_FALSE

Line 107: p_encoded => FND_API.G_FALSE

103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: FND_MSG_PUB.count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data,
107: p_encoded => FND_API.G_FALSE
108: );
109: WHEN FND_API.G_EXC_ERROR THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MSG_PUB.count_And_Get

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: ( p_count => x_msg_count,
106: p_data => x_msg_data,
107: p_encoded => FND_API.G_FALSE
108: );
109: WHEN FND_API.G_EXC_ERROR THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MSG_PUB.count_And_Get
112: ( p_count => x_msg_count,
113: p_data => x_msg_data,

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: p_data => x_msg_data,
107: p_encoded => FND_API.G_FALSE
108: );
109: WHEN FND_API.G_EXC_ERROR THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MSG_PUB.count_And_Get
112: ( p_count => x_msg_count,
113: p_data => x_msg_data,
114: p_encoded => FND_API.G_FALSE

Line 114: p_encoded => FND_API.G_FALSE

110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MSG_PUB.count_And_Get
112: ( p_count => x_msg_count,
113: p_data => x_msg_data,
114: p_encoded => FND_API.G_FALSE
115: );
116:
117: END Create_Category_Assignment;
118:

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

119:
120: PROCEDURE Delete_Category_Assignment
121: (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_errorcode OUT NOCOPY NUMBER,
127: x_msg_count OUT NOCOPY NUMBER,

Line 124: p_commit IN VARCHAR2 := FND_API.G_FALSE,

120: PROCEDURE Delete_Category_Assignment
121: (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_errorcode OUT NOCOPY NUMBER,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,

Line 163: IF fnd_api.to_boolean (p_init_msg_list) THEN

159:
160:
161: BEGIN
162:
163: IF fnd_api.to_boolean (p_init_msg_list) THEN
164: fnd_msg_pub.initialize;
165: END IF;
166:
167: INV_ITEM_CATEGORY_PUB.Delete_Category_Assignment

Line 201: p_init_msg_list => FND_API.g_false,

197: IF l_dummy =1 THEN
198:
199: AMS_ObjectAttribute_PVT.modify_object_attribute(
200: p_api_version => l_api_version,
201: p_init_msg_list => FND_API.g_false,
202: p_commit => FND_API.g_false,
203: p_validation_level => FND_API.g_valid_level_full,
204:
205: x_return_status => l_return_status,

Line 202: p_commit => FND_API.g_false,

198:
199: AMS_ObjectAttribute_PVT.modify_object_attribute(
200: p_api_version => l_api_version,
201: p_init_msg_list => FND_API.g_false,
202: p_commit => FND_API.g_false,
203: p_validation_level => FND_API.g_valid_level_full,
204:
205: x_return_status => l_return_status,
206: x_msg_count => x_msg_count,

Line 203: p_validation_level => FND_API.g_valid_level_full,

199: AMS_ObjectAttribute_PVT.modify_object_attribute(
200: p_api_version => l_api_version,
201: p_init_msg_list => FND_API.g_false,
202: p_commit => FND_API.g_false,
203: p_validation_level => FND_API.g_valid_level_full,
204:
205: x_return_status => l_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data,

Line 218: p_init_msg_list => FND_API.g_false,

214: ELSE
215:
216: AMS_ObjectAttribute_PVT.modify_object_attribute(
217: p_api_version => l_api_version,
218: p_init_msg_list => FND_API.g_false,
219: p_commit => FND_API.g_false,
220: p_validation_level => FND_API.g_valid_level_full,
221:
222: x_return_status => l_return_status,

Line 219: p_commit => FND_API.g_false,

215:
216: AMS_ObjectAttribute_PVT.modify_object_attribute(
217: p_api_version => l_api_version,
218: p_init_msg_list => FND_API.g_false,
219: p_commit => FND_API.g_false,
220: p_validation_level => FND_API.g_valid_level_full,
221:
222: x_return_status => l_return_status,
223: x_msg_count => x_msg_count,

Line 220: p_validation_level => FND_API.g_valid_level_full,

216: AMS_ObjectAttribute_PVT.modify_object_attribute(
217: p_api_version => l_api_version,
218: p_init_msg_list => FND_API.g_false,
219: p_commit => FND_API.g_false,
220: p_validation_level => FND_API.g_valid_level_full,
221:
222: x_return_status => l_return_status,
223: x_msg_count => x_msg_count,
224: x_msg_data => x_msg_data,

Line 235: IF FND_API.to_boolean(p_commit) THEN

231:
232: END IF;
233: *********************************************/
234:
235: IF FND_API.to_boolean(p_commit) THEN
236: COMMIT;
237: END IF;
238:
239: FND_MSG_PUB.count_And_Get

Line 242: p_encoded => FND_API.G_FALSE);

238:
239: FND_MSG_PUB.count_And_Get
240: ( p_count => x_msg_count,
241: p_data => x_msg_data,
242: p_encoded => FND_API.G_FALSE);
243:
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

242: p_encoded => FND_API.G_FALSE);
243:
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data,

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243:
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data,
251: p_encoded => FND_API.G_FALSE );

Line 251: p_encoded => FND_API.G_FALSE );

247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data,
251: p_encoded => FND_API.G_FALSE );
252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_And_Get
255: ( p_count => x_msg_count,

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: FND_MSG_PUB.count_And_Get
249: ( p_count => x_msg_count,
250: p_data => x_msg_data,
251: p_encoded => FND_API.G_FALSE );
252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data,

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: ( p_count => x_msg_count,
250: p_data => x_msg_data,
251: p_encoded => FND_API.G_FALSE );
252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data,
257: p_encoded => FND_API.G_FALSE);

Line 257: p_encoded => FND_API.G_FALSE);

253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data,
257: p_encoded => FND_API.G_FALSE);
258: END Delete_Category_Assignment;
259:
260: END;