eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ITEM_REVISION_PUB dependencies on FND_API

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

5:
6: PROCEDURE Create_Item_Revision
7: (
8: p_api_version IN NUMBER
9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12: , x_return_status OUT NOCOPY VARCHAR2
13: , x_msg_count OUT NOCOPY NUMBER

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

6: PROCEDURE Create_Item_Revision
7: (
8: p_api_version IN NUMBER
9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12: , x_return_status OUT NOCOPY VARCHAR2
13: , x_msg_count OUT NOCOPY NUMBER
14: , x_msg_data OUT NOCOPY VARCHAR2

Line 11: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

7: (
8: p_api_version IN NUMBER
9: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
10: , p_commit IN VARCHAR2 := FND_API.G_FALSE
11: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12: , x_return_status OUT NOCOPY VARCHAR2
13: , x_msg_count OUT NOCOPY NUMBER
14: , x_msg_data OUT NOCOPY VARCHAR2
15: , p_Item_Revision_rec IN Item_Revision_rec_type

Line 61: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

57: ,x_msg_data => x_msg_data
58: ,p_Item_Revision_rec => l_Item_Revision_rec
59: ) ;
60:
61: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: ,p_Item_Revision_rec => l_Item_Revision_rec
59: ) ;
60:
61: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66:

Line 63: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

59: ) ;
60:
61: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66:
67:

Line 64: RAISE FND_API.G_EXC_ERROR;

60:
61: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66:
67:
68: IF FND_API.to_boolean(p_commit) THEN

Line 68: IF FND_API.to_boolean(p_commit) THEN

64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66:
67:
68: IF FND_API.to_boolean(p_commit) THEN
69: COMMIT;
70: END IF;
71:
72: FND_MSG_PUB.Count_AND_Get

Line 75: p_encoded => FND_API.G_FALSE

71:
72: FND_MSG_PUB.Count_AND_Get
73: ( p_count => x_msg_count,
74: p_data => x_msg_data,
75: p_encoded => FND_API.G_FALSE
76: );
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

75: p_encoded => FND_API.G_FALSE
76: );
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: FND_MSG_PUB.count_And_Get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data,

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: );
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: FND_MSG_PUB.count_And_Get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE

Line 84: p_encoded => FND_API.G_FALSE

80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: FND_MSG_PUB.count_And_Get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE
85: );
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MSG_PUB.count_And_Get

Line 86: WHEN FND_API.G_EXC_ERROR THEN

82: ( p_count => x_msg_count,
83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE
85: );
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MSG_PUB.count_And_Get
89: ( p_count => x_msg_count,
90: p_data => x_msg_data,

Line 87: x_return_status := FND_API.G_RET_STS_ERROR;

83: p_data => x_msg_data,
84: p_encoded => FND_API.G_FALSE
85: );
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MSG_PUB.count_And_Get
89: ( p_count => x_msg_count,
90: p_data => x_msg_data,
91: p_encoded => FND_API.G_FALSE

Line 91: p_encoded => FND_API.G_FALSE

87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MSG_PUB.count_And_Get
89: ( p_count => x_msg_count,
90: p_data => x_msg_data,
91: p_encoded => FND_API.G_FALSE
92: );
93:
94: END;
95:

Line 102: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE

98:
99: PROCEDURE Update_Item_Revision
100: (
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
103: , p_commit IN VARCHAR2 := FND_API.g_FALSE
104: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
105: , x_return_status OUT NOCOPY VARCHAR2
106: , x_msg_count OUT NOCOPY NUMBER

Line 103: , p_commit IN VARCHAR2 := FND_API.g_FALSE

99: PROCEDURE Update_Item_Revision
100: (
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
103: , p_commit IN VARCHAR2 := FND_API.g_FALSE
104: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
105: , x_return_status OUT NOCOPY VARCHAR2
106: , x_msg_count OUT NOCOPY NUMBER
107: , x_msg_data OUT NOCOPY VARCHAR2

Line 104: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL

100: (
101: p_api_version IN NUMBER
102: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
103: , p_commit IN VARCHAR2 := FND_API.g_FALSE
104: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
105: , x_return_status OUT NOCOPY VARCHAR2
106: , x_msg_count OUT NOCOPY NUMBER
107: , x_msg_data OUT NOCOPY VARCHAR2
108: , p_Item_Revision_rec IN Item_Revision_rec_type

Line 149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

145: , x_msg_data => x_msg_data
146: , p_Item_Revision_rec => l_Item_Revision_rec
147: ) ;
148:
149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: , p_Item_Revision_rec => l_Item_Revision_rec
147: ) ;
148:
149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:

Line 151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

147: ) ;
148:
149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155:

Line 152: RAISE FND_API.G_EXC_ERROR;

148:
149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155:
156: IF FND_API.to_boolean(p_commit) THEN

Line 156: IF FND_API.to_boolean(p_commit) THEN

152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155:
156: IF FND_API.to_boolean(p_commit) THEN
157: COMMIT;
158: END IF;
159:
160: FND_MSG_PUB.Count_AND_Get

Line 163: p_encoded => FND_API.G_FALSE

159:
160: FND_MSG_PUB.Count_AND_Get
161: ( p_count => x_msg_count,
162: p_data => x_msg_data,
163: p_encoded => FND_API.G_FALSE
164: );
165:
166: EXCEPTION
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

163: p_encoded => FND_API.G_FALSE
164: );
165:
166: EXCEPTION
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data,

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164: );
165:
166: EXCEPTION
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => FND_API.G_FALSE

Line 172: p_encoded => FND_API.G_FALSE

168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => FND_API.G_FALSE
173: );
174: WHEN FND_API.G_EXC_ERROR THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MSG_PUB.count_And_Get

Line 174: WHEN FND_API.G_EXC_ERROR THEN

170: ( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => FND_API.G_FALSE
173: );
174: WHEN FND_API.G_EXC_ERROR THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MSG_PUB.count_And_Get
177: ( p_count => x_msg_count,
178: p_data => x_msg_data,

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: p_data => x_msg_data,
172: p_encoded => FND_API.G_FALSE
173: );
174: WHEN FND_API.G_EXC_ERROR THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MSG_PUB.count_And_Get
177: ( p_count => x_msg_count,
178: p_data => x_msg_data,
179: p_encoded => FND_API.G_FALSE

Line 179: p_encoded => FND_API.G_FALSE

175: x_return_status := FND_API.G_RET_STS_ERROR;
176: FND_MSG_PUB.count_And_Get
177: ( p_count => x_msg_count,
178: p_data => x_msg_data,
179: p_encoded => FND_API.G_FALSE
180: );
181:
182: END;
183:

Line 189: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE

185:
186: PROCEDURE Delete_Item_Revision
187: (
188: p_api_version IN NUMBER
189: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
190: , p_commit IN VARCHAR2 := FND_API.g_FALSE
191: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
192: , x_return_status OUT NOCOPY VARCHAR2
193: , x_msg_count OUT NOCOPY NUMBER

Line 190: , p_commit IN VARCHAR2 := FND_API.g_FALSE

186: PROCEDURE Delete_Item_Revision
187: (
188: p_api_version IN NUMBER
189: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
190: , p_commit IN VARCHAR2 := FND_API.g_FALSE
191: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
192: , x_return_status OUT NOCOPY VARCHAR2
193: , x_msg_count OUT NOCOPY NUMBER
194: , x_msg_data OUT NOCOPY VARCHAR2

Line 191: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL

187: (
188: p_api_version IN NUMBER
189: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
190: , p_commit IN VARCHAR2 := FND_API.g_FALSE
191: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
192: , x_return_status OUT NOCOPY VARCHAR2
193: , x_msg_count OUT NOCOPY NUMBER
194: , x_msg_data OUT NOCOPY VARCHAR2
195: , p_inventory_item_id IN NUMBER

Line 244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

240: , p_revision => l_revision
241: , p_object_version_number => l_object_version_number
242: ) ;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: , p_object_version_number => l_object_version_number
242: ) ;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:

Line 246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

242: ) ;
243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:

Line 247: RAISE FND_API.G_EXC_ERROR;

243:
244: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:
251: IF FND_API.to_boolean(p_commit) THEN

Line 251: IF FND_API.to_boolean(p_commit) THEN

247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:
251: IF FND_API.to_boolean(p_commit) THEN
252: COMMIT;
253: END IF;
254:
255: FND_MSG_PUB.Count_AND_Get

Line 258: p_encoded => FND_API.G_FALSE

254:
255: FND_MSG_PUB.Count_AND_Get
256: ( p_count => x_msg_count,
257: p_data => x_msg_data,
258: p_encoded => FND_API.G_FALSE
259: );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

258: p_encoded => FND_API.G_FALSE
259: );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.count_And_Get
265: ( p_count => x_msg_count,
266: p_data => x_msg_data,

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.count_And_Get
265: ( p_count => x_msg_count,
266: p_data => x_msg_data,
267: p_encoded => FND_API.G_FALSE

Line 267: p_encoded => FND_API.G_FALSE

263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.count_And_Get
265: ( p_count => x_msg_count,
266: p_data => x_msg_data,
267: p_encoded => FND_API.G_FALSE
268: );
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.count_And_Get

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: ( p_count => x_msg_count,
266: p_data => x_msg_data,
267: p_encoded => FND_API.G_FALSE
268: );
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.count_And_Get
272: ( p_count => x_msg_count,
273: p_data => x_msg_data,

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: p_data => x_msg_data,
267: p_encoded => FND_API.G_FALSE
268: );
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.count_And_Get
272: ( p_count => x_msg_count,
273: p_data => x_msg_data,
274: p_encoded => FND_API.G_FALSE

Line 274: p_encoded => FND_API.G_FALSE

270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MSG_PUB.count_And_Get
272: ( p_count => x_msg_count,
273: p_data => x_msg_data,
274: p_encoded => FND_API.G_FALSE
275: );
276:
277:
278: END;