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.GMIVLDX dependencies on FND_API

Line 64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

60: +==========================================================================+ */
61:
62: PROCEDURE create_lot_in_opm
63: ( p_api_version IN NUMBER
64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
67: , x_return_status OUT NOCOPY VARCHAR2
68: , x_msg_count OUT NOCOPY NUMBER

Line 65: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

61:
62: PROCEDURE create_lot_in_opm
63: ( p_api_version IN NUMBER
64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
67: , x_return_status OUT NOCOPY VARCHAR2
68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2

Line 66: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

62: PROCEDURE create_lot_in_opm
63: ( p_api_version IN NUMBER
64: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
65: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
67: , x_return_status OUT NOCOPY VARCHAR2
68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , p_hdr_rec IN GMIVDX.hdr_type

Line 83: IF FND_API.to_boolean(p_init_msg_list) THEN

79: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;
80:
81: BEGIN
82:
83: IF FND_API.to_boolean(p_init_msg_list) THEN
84: FND_MSG_PUB.Initialize;
85: END IF;
86:
87: SAVEPOINT create_lot_in_opm;

Line 90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

86:
87: SAVEPOINT create_lot_in_opm;
88:
89: -- Standard call to check for call compatibility.
90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
91: p_api_version ,
92: l_api_name ,
93: G_PKG_NAME ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: x_return_status :=FND_API.G_RET_STS_SUCCESS;
98:

Line 97: x_return_status :=FND_API.G_RET_STS_SUCCESS;

93: G_PKG_NAME ) THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: x_return_status :=FND_API.G_RET_STS_SUCCESS;
98:
99: l_lot_rec.item_no := p_line_rec.opm_item_no;
100: l_lot_rec.lot_no := p_lot_rec.opm_lot_no;
101: l_lot_rec.sublot_no := p_lot_rec.opm_sublot_no;

Line 113: , p_init_msg_list => FND_API.G_FALSE

109: l_lot_rec.user_name := FND_GLOBAL.USER_NAME;
110:
111: GMIPAPI.Create_Lot
112: ( p_api_version => 3.0
113: , p_init_msg_list => FND_API.G_FALSE
114: , p_commit => FND_API.G_FALSE
115: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
116: , x_return_status => x_return_status
117: , x_msg_count => x_msg_count

Line 114: , p_commit => FND_API.G_FALSE

110:
111: GMIPAPI.Create_Lot
112: ( p_api_version => 3.0
113: , p_init_msg_list => FND_API.G_FALSE
114: , p_commit => FND_API.G_FALSE
115: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
116: , x_return_status => x_return_status
117: , x_msg_count => x_msg_count
118: , x_msg_data => x_msg_data

Line 115: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

111: GMIPAPI.Create_Lot
112: ( p_api_version => 3.0
113: , p_init_msg_list => FND_API.G_FALSE
114: , p_commit => FND_API.G_FALSE
115: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
116: , x_return_status => x_return_status
117: , x_msg_count => x_msg_count
118: , x_msg_data => x_msg_data
119: , p_lot_rec => l_lot_rec

Line 128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

124: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
125: log_msg('After the call to GMIPAPI.Create_Lot. return status is '||x_return_status);
126: END IF;
127:
128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;

Line 129: RAISE FND_API.G_EXC_ERROR;

125: log_msg('After the call to GMIPAPI.Create_Lot. return status is '||x_return_status);
126: END IF;
127:
128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:

Line 130: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

126: END IF;
127:
128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: FND_MSG_PUB.Count_AND_GET

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127:
128: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: FND_MSG_PUB.Count_AND_GET
135: (p_count => x_msg_count, p_data => x_msg_data);

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: (p_count => x_msg_count, p_data => x_msg_data);
136:
137: EXCEPTION
138:
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK to create_lot_in_opm;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_AND_GET
143: (p_count => x_msg_count, p_data => x_msg_data);

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137: EXCEPTION
138:
139: WHEN FND_API.G_EXC_ERROR THEN
140: ROLLBACK to create_lot_in_opm;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_AND_GET
143: (p_count => x_msg_count, p_data => x_msg_data);
144:
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

141: x_return_status := FND_API.G_RET_STS_ERROR;
142: FND_MSG_PUB.Count_AND_GET
143: (p_count => x_msg_count, p_data => x_msg_data);
144:
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK to create_lot_in_opm;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.Count_AND_GET
149: (p_count => x_msg_count, p_data => x_msg_data);

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: (p_count => x_msg_count, p_data => x_msg_data);
144:
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK to create_lot_in_opm;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.Count_AND_GET
149: (p_count => x_msg_count, p_data => x_msg_data);
150:
151: WHEN OTHERS THEN

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: (p_count => x_msg_count, p_data => x_msg_data);
150:
151: WHEN OTHERS THEN
152: ROLLBACK to create_lot_in_opm;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_AND_GET
155: (p_count => x_msg_count, p_data => x_msg_data);
156:
157:

Line 184: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

180: +==========================================================================+ */
181:
182: PROCEDURE verify_lot_uniqueness_in_odm
183: ( p_api_version IN NUMBER
184: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
185: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
186: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
187: , x_return_status OUT NOCOPY VARCHAR2
188: , x_msg_count OUT NOCOPY NUMBER

Line 185: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

181:
182: PROCEDURE verify_lot_uniqueness_in_odm
183: ( p_api_version IN NUMBER
184: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
185: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
186: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
187: , x_return_status OUT NOCOPY VARCHAR2
188: , x_msg_count OUT NOCOPY NUMBER
189: , x_msg_data OUT NOCOPY VARCHAR2

Line 186: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

182: PROCEDURE verify_lot_uniqueness_in_odm
183: ( p_api_version IN NUMBER
184: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
185: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
186: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
187: , x_return_status OUT NOCOPY VARCHAR2
188: , x_msg_count OUT NOCOPY NUMBER
189: , x_msg_data OUT NOCOPY VARCHAR2
190: , p_odm_item_id IN gmi_discrete_transfer_lines.odm_item_id%TYPE

Line 200: IF FND_API.to_boolean(p_init_msg_list) THEN

196: l_count pls_integer;
197:
198: BEGIN
199:
200: IF FND_API.to_boolean(p_init_msg_list) THEN
201: FND_MSG_PUB.Initialize;
202: END IF;
203:
204: -- Standard call to check for call compatibility.

Line 205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

201: FND_MSG_PUB.Initialize;
202: END IF;
203:
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
206: p_api_version ,
207: l_api_name ,
208: G_PKG_NAME ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
206: p_api_version ,
207: l_api_name ,
208: G_PKG_NAME ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: x_return_status :=FND_API.G_RET_STS_SUCCESS;
213:

Line 212: x_return_status :=FND_API.G_RET_STS_SUCCESS;

208: G_PKG_NAME ) THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: x_return_status :=FND_API.G_RET_STS_SUCCESS;
213:
214: SELECT COUNT(1)
215: INTO l_count
216: FROM mtl_transaction_lot_numbers

Line 224: RAISE FND_API.G_EXC_ERROR;

220:
221: IF (l_count > 0) THEN
222: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_NUMBER_EXISTS');
223: FND_MSG_PUB.Add;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: SELECT COUNT(1)
228: INTO l_count

Line 238: RAISE FND_API.G_EXC_ERROR;

234:
235: IF (l_count > 0) THEN
236: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_NUMBER_EXISTS');
237: FND_MSG_PUB.Add;
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:
241: SELECT COUNT(1)
242: INTO l_count

Line 251: RAISE FND_API.G_EXC_ERROR;

247:
248: IF (l_count > 0) THEN
249: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_NUMBER_EXISTS');
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:
254: FND_MSG_PUB.Count_AND_GET
255: (p_count => x_msg_count, p_data => x_msg_data);

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: (p_count => x_msg_count, p_data => x_msg_data);
256:
257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_AND_GET
262: (p_count => x_msg_count, p_data => x_msg_data);
263:

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256:
257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_AND_GET
262: (p_count => x_msg_count, p_data => x_msg_data);
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_AND_GET
262: (p_count => x_msg_count, p_data => x_msg_data);
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_AND_GET
267: (p_count => x_msg_count, p_data => x_msg_data);
268:

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: FND_MSG_PUB.Count_AND_GET
262: (p_count => x_msg_count, p_data => x_msg_data);
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_AND_GET
267: (p_count => x_msg_count, p_data => x_msg_data);
268:
269: WHEN OTHERS THEN

Line 270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

266: FND_MSG_PUB.Count_AND_GET
267: (p_count => x_msg_count, p_data => x_msg_data);
268:
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.Count_AND_GET
272: (p_count => x_msg_count, p_data => x_msg_data);
273:
274: