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

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

66: --| |
67: --+==========================================================================+
68: PROCEDURE Inventory_Posting
69: ( p_api_version IN NUMBER
70: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71: , p_commit IN VARCHAR2 := FND_API.G_FALSE
72: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
73: , p_trans_rec IN trans_rec_typ
74: , x_return_status OUT NOCOPY VARCHAR2

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

67: --+==========================================================================+
68: PROCEDURE Inventory_Posting
69: ( p_api_version IN NUMBER
70: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71: , p_commit IN VARCHAR2 := FND_API.G_FALSE
72: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
73: , p_trans_rec IN trans_rec_typ
74: , x_return_status OUT NOCOPY VARCHAR2
75: , x_msg_count OUT NOCOPY NUMBER

Line 72: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL

68: PROCEDURE Inventory_Posting
69: ( p_api_version IN NUMBER
70: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
71: , p_commit IN VARCHAR2 := FND_API.G_FALSE
72: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
73: , p_trans_rec IN trans_rec_typ
74: , x_return_status OUT NOCOPY VARCHAR2
75: , x_msg_count OUT NOCOPY NUMBER
76: , x_msg_data OUT NOCOPY VARCHAR2

Line 106: IF NOT FND_API.Compatible_API_CALL ( l_api_version

102:
103: -- Standard Start OF API savepoint
104: SAVEPOINT Inventory_Posting;
105: -- Standard call to check for call compatibility.
106: IF NOT FND_API.Compatible_API_CALL ( l_api_version
107: , p_api_version
108: , l_api_name
109: , G_PKG_NAME
110: )

Line 112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

108: , l_api_name
109: , G_PKG_NAME
110: )
111: THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114:
115: -- Initialize message list if p_int_msg_list is set TRUE.
116: IF FND_API.to_boolean(p_init_msg_list)

Line 116: IF FND_API.to_boolean(p_init_msg_list)

112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114:
115: -- Initialize message list if p_int_msg_list is set TRUE.
116: IF FND_API.to_boolean(p_init_msg_list)
117: THEN
118: FND_MSG_PUB.Initialize;
119: END IF;
120:

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

118: FND_MSG_PUB.Initialize;
119: END IF;
120:
121: -- Initialize API return status to sucess
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: -- Populate WHO columns
125: l_user_name :=p_trans_rec.user_name;
126: GMA_GLOBAL_GRP.Get_who( p_user_name => l_user_name

Line 135: RAISE FND_API.G_EXC_ERROR;

131: THEN
132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:
138: -- Move transaction record to local
139: l_trans_rec := p_trans_rec;

Line 174: IF (l_return_status = FND_API.G_RET_STS_ERROR)

170:
171: -- If no errors were found then proceed with posting the
172: -- transaction.
173:
174: IF (l_return_status = FND_API.G_RET_STS_ERROR)
175: THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF
178: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 176: RAISE FND_API.G_EXC_ERROR;

172: -- transaction.
173:
174: IF (l_return_status = FND_API.G_RET_STS_ERROR)
175: THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF
178: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;

Line 178: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

174: IF (l_return_status = FND_API.G_RET_STS_ERROR)
175: THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF
178: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: -- Get the surrogate key (journal_id) for the journal

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: THEN
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF
178: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182: -- Get the surrogate key (journal_id) for the journal
183: SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;

Line 189: RAISE FND_API.G_EXC_ERROR;

185: THEN
186: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
187: FND_MESSAGE.SET_TOKEN('SKEY','journal_id');
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: -- Set up PL/SQL record and insert item into ic_jrnl_mst
193: l_ic_jrnl_mst_rec.journal_id := l_journal_id;

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: l_ic_jrnl_mst_rec.last_update_login := l_user_id;
214:
215: IF NOT GMI_QUANTITY_PVT.insert_ic_jrnl_mst(l_ic_jrnl_mst_rec)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Write transactions to ic_adjs_jnl
221: -- First get the surrogate key (doc_id) for the transaction.

Line 228: RAISE FND_API.G_EXC_ERROR;

224: THEN
225: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
226: FND_MESSAGE.SET_TOKEN('SKEY','doc_id');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:
231: -- If create or Adjust transaction then insert 1 row to
232: -- ic_adjs_jnl. If Move, Change lot status or Change

Line 257: RAISE FND_API.G_EXC_ERROR;

253: THEN
254: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
255: FND_MESSAGE.SET_TOKEN('SKEY','line_id');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259: END IF;
260:
261: IF (l_trans_rec.trans_type = 1)

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337:
338:
339: IF NOT GMI_QUANTITY_PVT.insert_ic_adjs_jnl(l_ic_adjs_jnl_rec)
340: THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343:
344: --
345: -- Now polpulate the completed transaction PL/SQL record

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: l_cmp_tran_rec.text_code := NULL;
374:
375: IF NOT GMI_CMP_TRAN_PVT.Update_quantity_transaction(l_cmp_tran_rec)
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379:
380: END LOOP;
381:

Line 385: IF FND_API.to_boolean(p_commit)

381:
382: -- END of API Body
383:
384: -- Standard Check of p_commit.
385: IF FND_API.to_boolean(p_commit)
386: THEN
387: COMMIT WORK;
388: END IF;
389: -- Success message

Line 414: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

410: FND_MSG_PUB.Add;
411: -- Standard Call to get message count and if count is 1,
412: -- get message info.
413:
414: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
415: , p_count => x_msg_count
416: , p_data => x_msg_data
417: );
418:

Line 420: WHEN FND_API.G_EXC_ERROR THEN

416: , p_data => x_msg_data
417: );
418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO Inventory_Posting;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
424: , p_count => x_msg_count

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO Inventory_Posting;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
424: , p_count => x_msg_count
425: , p_data => x_msg_data
426: );

Line 423: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

419: EXCEPTION
420: WHEN FND_API.G_EXC_ERROR THEN
421: ROLLBACK TO Inventory_Posting;
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
424: , p_count => x_msg_count
425: , p_data => x_msg_data
426: );
427:

Line 428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

424: , p_count => x_msg_count
425: , p_data => x_msg_data
426: );
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO Inventory_Posting;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
432: , p_count => x_msg_count

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

426: );
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO Inventory_Posting;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
432: , p_count => x_msg_count
433: , p_data => x_msg_data
434: );

Line 431: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO Inventory_Posting;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
432: , p_count => x_msg_count
433: , p_data => x_msg_data
434: );
435: WHEN OTHERS THEN

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: , p_data => x_msg_data
434: );
435: WHEN OTHERS THEN
436: ROLLBACK TO Inventory_Posting;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: --IF FND_MSG_PUB.check_msg_level
439: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
440: --THEN
441:

Line 446: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

442: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
443: , l_api_name
444: );
445: -- END IF;
446: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
447: , p_count => x_msg_count
448: , p_data => x_msg_data
449: );
450: