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_TRANS_ENGINE_PVT dependencies on FND_API

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

78: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_TRANS_ENGINE_PVT';
79:
80: PROCEDURE CREATE_PENDING_TRANSACTION
81: ( p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83: , p_commit IN VARCHAR2 := FND_API.G_FALSE
84: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
85: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
86: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

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

79:
80: PROCEDURE CREATE_PENDING_TRANSACTION
81: ( p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83: , p_commit IN VARCHAR2 := FND_API.G_FALSE
84: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
85: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
86: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
87: , x_return_status OUT NOCOPY VARCHAR2

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

80: PROCEDURE CREATE_PENDING_TRANSACTION
81: ( p_api_version IN NUMBER
82: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
83: , p_commit IN VARCHAR2 := FND_API.G_FALSE
84: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
85: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
86: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
87: , x_return_status OUT NOCOPY VARCHAR2
88: , x_msg_count OUT NOCOPY NUMBER

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: /* Standard Start OF API savepoint*/
104: SAVEPOINT create_pending_transaction;
105:
106: /* Initialize API return status to sucess*/
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: /* Move transaction Table record to local*/
110: /* This has to be done to add new trans id record */
111: l_tran_rec := p_tran_rec;

Line 113: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

109: /* Move transaction Table record to local*/
110: /* This has to be done to add new trans id record */
111: l_tran_rec := p_tran_rec;
112:
113: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
114: THEN
115: SET_DEFAULTS (p_tran_rec => p_tran_rec, x_tran_rec => l_tran_rec);
116: END IF;
117:

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: p_retry_flag => l_retry_flag,
123: x_tran_rec => l_tran_rec
124: )
125: THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: /* ***********************************************************
130: Jalaj Srivastava Bug 2519568

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142:
143: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND
144: ( p_tran_row => l_tran_row, x_tran_row => x_tran_row)
145: THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148:
149:
150: /* Standard Check of p_commit. */

Line 152: IF FND_API.to_boolean(p_commit)

148:
149:
150: /* Standard Check of p_commit. */
151:
152: IF FND_API.to_boolean(p_commit)
153: THEN
154: COMMIT WORK;
155: END IF;
156:

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154: COMMIT WORK;
155: END IF;
156:
157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO create_pending_transaction;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
162: , p_count => x_msg_count

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156:
157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO create_pending_transaction;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );

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

157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: ROLLBACK TO create_pending_transaction;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );
165:

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO create_pending_transaction;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
170: , p_count => x_msg_count

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO create_pending_transaction;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
170: , p_count => x_msg_count
171: , p_data => x_msg_data
172: );
173: WHEN OTHERS THEN

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: , p_data => x_msg_data
172: );
173: WHEN OTHERS THEN
174: ROLLBACK TO create_pending_transaction;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
178: , l_api_name
179: );

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

177: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
178: , l_api_name
179: );
180:
181: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
182: , p_count => x_msg_count
183: , p_data => x_msg_data
184: );
185:

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

188:
189:
190: PROCEDURE CREATE_COMPLETED_TRANSACTION
191: ( p_api_version IN NUMBER
192: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: , p_commit IN VARCHAR2 := FND_API.G_FALSE
194: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
195: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
196: , x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE

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

189:
190: PROCEDURE CREATE_COMPLETED_TRANSACTION
191: ( p_api_version IN NUMBER
192: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: , p_commit IN VARCHAR2 := FND_API.G_FALSE
194: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
195: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
196: , x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
197: , x_return_status OUT NOCOPY VARCHAR2

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

190: PROCEDURE CREATE_COMPLETED_TRANSACTION
191: ( p_api_version IN NUMBER
192: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
193: , p_commit IN VARCHAR2 := FND_API.G_FALSE
194: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
195: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
196: , x_tran_row OUT NOCOPY IC_TRAN_CMP%ROWTYPE
197: , x_return_status OUT NOCOPY VARCHAR2
198: , x_msg_count OUT NOCOPY NUMBER

Line 233: IF NOT FND_API.Compatible_API_CALL

229: BEGIN
230: /* Standard Start OF API savepoint */
231: SAVEPOINT create_completed_transaction;
232: /* Standard call to check for call compatibility. */
233: IF NOT FND_API.Compatible_API_CALL
234: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
235: THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: /* Standard call to check for call compatibility. */
233: IF NOT FND_API.Compatible_API_CALL
234: (l_api_version , p_api_version , l_api_name , G_PKG_NAME)
235: THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: /* Initialize message list if p_int_msg_list is set TRUE. */
240: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 240: IF FND_API.to_boolean(p_init_msg_list) THEN

236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: /* Initialize message list if p_int_msg_list is set TRUE. */
240: IF FND_API.to_boolean(p_init_msg_list) THEN
241: FND_MSG_PUB.Initialize;
242: END IF;
243:
244: /* Initialize API return status to sucess */

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: FND_MSG_PUB.Initialize;
242: END IF;
243:
244: /* Initialize API return status to sucess */
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: /* Move transaction Table record to local */
248: /* This has to be done to add new trans id record */
249: l_tran_rec := p_tran_rec;

Line 251: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

247: /* Move transaction Table record to local */
248: /* This has to be done to add new trans id record */
249: l_tran_rec := p_tran_rec;
250:
251: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
252: SET_DEFAULTS ( p_tran_rec => p_tran_rec ,x_tran_rec => l_tran_rec);
253: END IF;
254:
255: /* Jalaj Srivastava Bug 1427922 */

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: p_retry_flag => l_retry_flag,
266: x_tran_rec => l_tran_rec
267: )
268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:
272: END IF;
273:

Line 286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

282: x_return_status =>l_return_status
283: );
284:
285: /* if errors were found then Raise Exception */
286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
287: THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284:
285: /* if errors were found then Raise Exception */
286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
287: THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: END IF;

Line 289: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

285: /* if errors were found then Raise Exception */
286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
287: THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: END IF;
293:

Line 290: RAISE FND_API.G_EXC_ERROR;

286: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
287: THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292: END IF;
293:
294: /* Update Inventory Balances ( Actuals). */

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378:
379: IF NOT GMI_TRAN_CMP_PVT.INSERT_IC_TRAN_CMP
380: ( p_tran_row => l_tran_cmp, x_tran_row => x_tran_row)
381: THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384: -- BEGIN Bug# 2341493 VRA Srinivas 26/04/2002
385: END IF; -- l_status_ctl =2 and p_tran_rec.doc_type='STSI')
386: -- END Bug# 2341493

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431:
432: IF NOT GMI_TRAN_PND_DB_PVT.INSERT_IC_TRAN_PND
433: ( p_tran_row => l_tran_pnd, x_tran_row => l_tran_pnd)
434: THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438: /* Need to sort out the return row to the caller.... */
439: x_tran_row.trans_id := l_tran_pnd.trans_id;

Line 484: IF FND_API.to_boolean(p_commit)

480: END IF;
481:
482:
483: /* Standard Check of p_commit. */
484: IF FND_API.to_boolean(p_commit)
485: THEN
486: COMMIT WORK;
487: END IF;
488:

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: COMMIT WORK;
487: END IF;
488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO create_completed_transaction;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
494: , p_count => x_msg_count

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488:
489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO create_completed_transaction;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
494: , p_count => x_msg_count
495: , p_data => x_msg_data
496: );

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

489: EXCEPTION
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO create_completed_transaction;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
494: , p_count => x_msg_count
495: , p_data => x_msg_data
496: );
497:

Line 498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

494: , p_count => x_msg_count
495: , p_data => x_msg_data
496: );
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: ROLLBACK TO create_completed_transaction;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
502: , p_count => x_msg_count

Line 500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

496: );
497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: ROLLBACK TO create_completed_transaction;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
502: , p_count => x_msg_count
503: , p_data => x_msg_data
504: );

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

497:
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: ROLLBACK TO create_completed_transaction;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
502: , p_count => x_msg_count
503: , p_data => x_msg_data
504: );
505: WHEN OTHERS THEN

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: , p_data => x_msg_data
504: );
505: WHEN OTHERS THEN
506: ROLLBACK TO create_completed_transaction;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508:
509: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
510: , l_api_name
511: );

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

509: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
510: , l_api_name
511: );
512:
513: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
514: , p_count => x_msg_count
515: , p_data => x_msg_data
516: );
517:

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

519:
520:
521: PROCEDURE DELETE_PENDING_TRANSACTION
522: ( p_api_version IN NUMBER
523: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
524: , p_commit IN VARCHAR2 := FND_API.G_FALSE
525: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
526: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
527: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

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

520:
521: PROCEDURE DELETE_PENDING_TRANSACTION
522: ( p_api_version IN NUMBER
523: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
524: , p_commit IN VARCHAR2 := FND_API.G_FALSE
525: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
526: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
527: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
528: , x_return_status OUT NOCOPY VARCHAR2

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

521: PROCEDURE DELETE_PENDING_TRANSACTION
522: ( p_api_version IN NUMBER
523: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
524: , p_commit IN VARCHAR2 := FND_API.G_FALSE
525: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
526: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
527: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
528: , x_return_status OUT NOCOPY VARCHAR2
529: , x_msg_count OUT NOCOPY NUMBER

Line 548: x_return_status := FND_API.G_RET_STS_SUCCESS;

544: /* Standard Start OF API savepoint */
545: SAVEPOINT delete_pending_transaction;
546:
547: /* Initialize API return status to sucess */
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549:
550: /* Move transaction Table record to local*/
551: /* This has to be done to add new trans id record */
552: l_tran_rec := p_tran_rec;

Line 554: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

550: /* Move transaction Table record to local*/
551: /* This has to be done to add new trans id record */
552: l_tran_rec := p_tran_rec;
553:
554: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
555: THEN
556: SET_DEFAULTS ( p_tran_rec => p_tran_rec ,x_tran_rec => l_tran_rec);
557: END IF;
558:

Line 576: RAISE FND_API.G_EXC_ERROR;

572: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');
573: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
574: FND_MESSAGE.SET_TOKEN('WAREH',l_tran_rec.whse_code);
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: */
579:
580: /* Call the IC_TRAN_PND FETCH procedure to FETCH this record. */

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581:
582: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
583: ( p_tran_rec => l_tran_rec, x_tran_fetch_rec => l_tran_fetch_rec )
584: THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587:
588: /* Check If this is A Non-Inventory Item */
589:

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613:
614: IF NOT GMI_TRAN_PND_DB_PVT.DELETE_IC_TRAN_PND
615: ( p_tran_row => l_tran_row )
616: THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: /* Standard Check of p_commit. */
621: IF FND_API.to_boolean(p_commit)

Line 621: IF FND_API.to_boolean(p_commit)

617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: /* Standard Check of p_commit. */
621: IF FND_API.to_boolean(p_commit)
622: THEN
623: COMMIT WORK;
624: END IF;
625:

Line 631: WHEN FND_API.G_EXC_ERROR THEN

627:
628: x_return_status := l_return_status;
629:
630: EXCEPTION
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO delete_pending_transaction;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629:
630: EXCEPTION
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO delete_pending_transaction;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );

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

630: EXCEPTION
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO delete_pending_transaction;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );
638:

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO delete_pending_transaction;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
643: , p_count => x_msg_count

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: );
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO delete_pending_transaction;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
643: , p_count => x_msg_count
644: , p_data => x_msg_data
645: );

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

638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO delete_pending_transaction;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
643: , p_count => x_msg_count
644: , p_data => x_msg_data
645: );
646: WHEN OTHERS THEN

Line 648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

644: , p_data => x_msg_data
645: );
646: WHEN OTHERS THEN
647: ROLLBACK TO delete_pending_transaction;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649:
650: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
651: , l_api_name
652: );

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

650: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
651: , l_api_name
652: );
653:
654: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
655: , p_count => x_msg_count
656: , p_data => x_msg_data
657: );
658:

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

659: END DELETE_PENDING_TRANSACTION;
660:
661: PROCEDURE UPDATE_PENDING_TRANSACTION
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
664: , p_commit IN VARCHAR2 := FND_API.G_FALSE
665: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
666: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
667: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

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

660:
661: PROCEDURE UPDATE_PENDING_TRANSACTION
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
664: , p_commit IN VARCHAR2 := FND_API.G_FALSE
665: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
666: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
667: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
668: , x_return_status OUT NOCOPY VARCHAR2

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

661: PROCEDURE UPDATE_PENDING_TRANSACTION
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
664: , p_commit IN VARCHAR2 := FND_API.G_FALSE
665: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
666: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
667: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
668: , x_return_status OUT NOCOPY VARCHAR2
669: , x_msg_count OUT NOCOPY NUMBER

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: /* Standard Start OF API savepoint */
688: SAVEPOINT update_pending_transaction;
689:
690: /* Initialize API return status to sucess */
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692:
693: /* Move transaction Table record to local */
694: l_tran_rec := p_tran_rec;
695:

Line 696: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

692:
693: /* Move transaction Table record to local */
694: l_tran_rec := p_tran_rec;
695:
696: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
697: THEN
698: SET_DEFAULTS
699: ( p_tran_rec => p_tran_rec
700: ,x_tran_rec => l_tran_rec

Line 712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

708: p_retry_flag => l_retry_flag,
709: x_tran_rec => l_tran_rec
710: )
711: THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: END IF;
714:
715:
716:

Line 724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

720:
721: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
722: ( p_tran_rec => l_tran_rec, x_tran_fetch_rec => l_tran_fetch_rec )
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726:
727: /* Compare the old tran rec QC_GRADE AND WHSE_CODE */
728: /* to determine If we are still updating same RECORD */

Line 732: l_old_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);

728: /* to determine If we are still updating same RECORD */
729: /* or we have changed record charateristics. */
730:
731: /* Add Following To Get NULL QC_GRADE Logic */
732: l_old_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);
733: l_new_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);
734:
735: IF l_tran_fetch_rec.whse_code <> l_tran_rec.whse_code
736: OR l_old_qc_grade <> l_new_qc_grade

Line 733: l_new_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);

729: /* or we have changed record charateristics. */
730:
731: /* Add Following To Get NULL QC_GRADE Logic */
732: l_old_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);
733: l_new_qc_grade := NVL(l_tran_fetch_rec.qc_grade,FND_API.g_miss_char);
734:
735: IF l_tran_fetch_rec.whse_code <> l_tran_rec.whse_code
736: OR l_old_qc_grade <> l_new_qc_grade
737: THEN

Line 775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

771:
772: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND
773: ( p_tran_row => l_tran_row)
774: THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: /* Standard Check of p_commit. */
779: IF FND_API.to_boolean(p_commit)

Line 779: IF FND_API.to_boolean(p_commit)

775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: /* Standard Check of p_commit. */
779: IF FND_API.to_boolean(p_commit)
780: THEN
781: COMMIT WORK;
782: END IF;
783:

Line 789: WHEN FND_API.G_EXC_ERROR THEN

785:
786: x_return_status := l_return_status;
787:
788: EXCEPTION
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO update_pending_transaction;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
793: , p_count => x_msg_count

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787:
788: EXCEPTION
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO update_pending_transaction;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
793: , p_count => x_msg_count
794: , p_data => x_msg_data
795: );

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

788: EXCEPTION
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO update_pending_transaction;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
793: , p_count => x_msg_count
794: , p_data => x_msg_data
795: );
796:

Line 797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

793: , p_count => x_msg_count
794: , p_data => x_msg_data
795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO update_pending_transaction;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
801: , p_count => x_msg_count

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO update_pending_transaction;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
801: , p_count => x_msg_count
802: , p_data => x_msg_data
803: );

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

796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO update_pending_transaction;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
801: , p_count => x_msg_count
802: , p_data => x_msg_data
803: );
804: WHEN OTHERS THEN

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

802: , p_data => x_msg_data
803: );
804: WHEN OTHERS THEN
805: ROLLBACK TO update_pending_transaction;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
809: , l_api_name
810: );

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

808: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
809: , l_api_name
810: );
811:
812: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
813: , p_count => x_msg_count
814: , p_data => x_msg_data
815: );
816: END UPDATE_PENDING_TRANSACTION;

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

816: END UPDATE_PENDING_TRANSACTION;
817:
818: PROCEDURE UPDATE_PENDING_TO_COMPLETED
819: ( p_api_version IN NUMBER
820: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: , p_commit IN VARCHAR2 := FND_API.G_FALSE
822: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
823: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
824: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

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

817:
818: PROCEDURE UPDATE_PENDING_TO_COMPLETED
819: ( p_api_version IN NUMBER
820: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: , p_commit IN VARCHAR2 := FND_API.G_FALSE
822: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
823: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
824: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
825: , x_return_status OUT NOCOPY VARCHAR2

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

818: PROCEDURE UPDATE_PENDING_TO_COMPLETED
819: ( p_api_version IN NUMBER
820: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: , p_commit IN VARCHAR2 := FND_API.G_FALSE
822: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
823: , p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
824: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
825: , x_return_status OUT NOCOPY VARCHAR2
826: , x_msg_count OUT NOCOPY NUMBER

Line 876: x_return_status := FND_API.G_RET_STS_SUCCESS;

872: /* Standard Start OF API savepoint */
873: SAVEPOINT complete_pending_transaction;
874:
875: /* Initialize API return status to sucess */
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:
878: /* 1.Move transaction Table record to local */
879: l_tran_rec := p_tran_rec;
880:

Line 881: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

877:
878: /* 1.Move transaction Table record to local */
879: l_tran_rec := p_tran_rec;
880:
881: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
882: THEN
883: SET_DEFAULTS
884: (
885: p_tran_rec => p_tran_rec

Line 900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

896: p_retry_flag => l_retry_flag,
897: x_tran_rec => l_tran_rec
898: )
899: THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: END IF;
902:
903:
904: IF l_tran_rec.non_inv = 0

Line 914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

910: p_tran_rec => l_tran_rec,
911: x_tran_fetch_rec => l_tran_fetch_rec
912: )
913: THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
917: /* Negate Out Previous Transactions */
918:

Line 938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

934: );
935:
936: /* if errors were found then Raise Exception */
937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
939: THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: RAISE FND_API.G_EXC_ERROR;

Line 940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

936: /* if errors were found then Raise Exception */
937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
939: THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944:

Line 941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
939: THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944:
945: END IF;

Line 942: RAISE FND_API.G_EXC_ERROR;

938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
939: THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944:
945: END IF;
946:

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: IF NOT gmivdbl.ic_item_mst_select (
953: p_ic_item_mst_row => l_item_mst_rec,
954: x_ic_item_mst_row => l_item_mst_rec
955: ) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END IF;
958:
959: IF (l_item_mst_rec.status_ctl > 0 ) THEN
960: OPEN Cur_lot_status(

Line 985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

981: );
982:
983: IF NOT GMI_TRAN_PND_DB_PVT.UPDATE_IC_TRAN_PND ( p_tran_row => l_tran_row)
984: THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:
988: /* Standard Check of p_commit.*/
989: IF FND_API.to_boolean(p_commit)

Line 989: IF FND_API.to_boolean(p_commit)

985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:
988: /* Standard Check of p_commit.*/
989: IF FND_API.to_boolean(p_commit)
990: THEN
991: COMMIT WORK;
992: END IF;
993:

Line 997: WHEN FND_API.G_EXC_ERROR THEN

993:
994: x_tran_row := l_tran_row;
995:
996: EXCEPTION
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO complete_pending_transaction;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1001: , p_count => x_msg_count

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995:
996: EXCEPTION
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO complete_pending_transaction;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1001: , p_count => x_msg_count
1002: , p_data => x_msg_data
1003: );

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

996: EXCEPTION
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO complete_pending_transaction;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1001: , p_count => x_msg_count
1002: , p_data => x_msg_data
1003: );
1004:

Line 1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1001: , p_count => x_msg_count
1002: , p_data => x_msg_data
1003: );
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO complete_pending_transaction;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1009: , p_count => x_msg_count

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: );
1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO complete_pending_transaction;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );

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

1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO complete_pending_transaction;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );
1012: WHEN OTHERS THEN

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1010: , p_data => x_msg_data
1011: );
1012: WHEN OTHERS THEN
1013: ROLLBACK TO complete_pending_transaction;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015:
1016: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1017: , l_api_name
1018: );

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

1016: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1017: , l_api_name
1018: );
1019:
1020: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1021: , p_count => x_msg_count
1022: , p_data => x_msg_data
1023: );
1024:

Line 1034: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

1030: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
1031: , x_return_status OUT NOCOPY VARCHAR2
1032: )
1033: IS
1034: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1035: l_tran_row IC_TRAN_PND%ROWTYPE;
1036: BEGIN
1037: x_tran_row.trans_id := p_tran_rec.trans_id;
1038: x_tran_row.item_id := p_tran_rec.item_id;

Line 1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1080:
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083:
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1085:
1086: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1087: ,'PENDING_TRANSACTION_BUILD'
1088: );

Line 1099: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

1095: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
1096: , x_return_status OUT NOCOPY VARCHAR2
1097: )
1098: IS
1099: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
1100: l_tran_row IC_TRAN_PND%ROWTYPE;
1101:
1102: BEGIN
1103:

Line 1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1157:
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160:
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162:
1163: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1164: ,'COMPLETED_TRANSACTION_BUILD'
1165: );

Line 1221: IF p_tran_rec.trans_qty2 = FND_API.G_MISS_NUM THEN

1217: IF p_tran_rec.staged_ind is NULL THEN
1218: x_tran_rec.staged_ind :=0;
1219: END IF;
1220:
1221: IF p_tran_rec.trans_qty2 = FND_API.G_MISS_NUM THEN
1222: x_tran_rec.trans_qty2 := NULL;
1223: END IF;
1224:
1225: END SET_DEFAULTS;