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

Line 115: IF FND_API.to_Boolean( p_init_msg_list ) THEN

111: l_tx_qty number;
112: l_move_order_line_id number;
113: BEGIN
114: SAVEPOINT DELETE_ALLOCATION;
115: IF FND_API.to_Boolean( p_init_msg_list ) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: x_msg_count := 0;

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: SAVEPOINT DELETE_ALLOCATION;
115: IF FND_API.to_Boolean( p_init_msg_list ) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: x_msg_count := 0;
120:
121: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
122: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 153: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

149: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
150: eam_common_utilities_pvt.log_api_return(l_module,
151: 'inv_trx_util_pub.delete_transaction',x_return_status,x_msg_count,x_msg_data);
152: end if;
153: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
154: raise fnd_api.g_exc_error;
155: end if;
156: --API end
157:

Line 154: raise fnd_api.g_exc_error;

150: eam_common_utilities_pvt.log_api_return(l_module,
151: 'inv_trx_util_pub.delete_transaction',x_return_status,x_msg_count,x_msg_data);
152: end if;
153: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
154: raise fnd_api.g_exc_error;
155: end if;
156: --API end
157:
158: IF FND_API.To_Boolean( p_commit ) THEN

Line 158: IF FND_API.To_Boolean( p_commit ) THEN

154: raise fnd_api.g_exc_error;
155: end if;
156: --API end
157:
158: IF FND_API.To_Boolean( p_commit ) THEN
159: COMMIT WORK;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157:
158: IF FND_API.To_Boolean( p_commit ) THEN
159: COMMIT WORK;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
163: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
165: end if;

Line 168: WHEN fnd_api.g_exc_error THEN

164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
165: end if;
166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: x_return_status := fnd_api.g_ret_sts_error;
170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
171: ROLLBACK to delete_allocation;
172: WHEN OTHERS THEN

Line 169: x_return_status := fnd_api.g_ret_sts_error;

165: end if;
166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: x_return_status := fnd_api.g_ret_sts_error;
170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
171: ROLLBACK to delete_allocation;
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

169: x_return_status := fnd_api.g_ret_sts_error;
170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
171: ROLLBACK to delete_allocation;
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177: ROLLBACK to delete_allocation;

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: l_tx_qty number;
206: l_move_order_line_id number;
207: BEGIN
208: SAVEPOINT reduce_allocation_header;
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: x_msg_count := 0;
211:
212: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 289: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
286: 'inv_trx_util_pub.copy_insert_line_trx returned '
287: || 'x_new_txn_temp_id='|| x_new_transaction_temp_id);
288: end if;
289: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
290: raise fnd_api.g_exc_error;
291: end if;
292: end if;
293: --API end

Line 290: raise fnd_api.g_exc_error;

286: 'inv_trx_util_pub.copy_insert_line_trx returned '
287: || 'x_new_txn_temp_id='|| x_new_transaction_temp_id);
288: end if;
289: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
290: raise fnd_api.g_exc_error;
291: end if;
292: end if;
293: --API end
294:

Line 295: IF FND_API.To_Boolean( p_commit ) THEN

291: end if;
292: end if;
293: --API end
294:
295: IF FND_API.To_Boolean( p_commit ) THEN
296: COMMIT WORK;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

294:
295: IF FND_API.To_Boolean( p_commit ) THEN
296: COMMIT WORK;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
300: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
302: end if;

Line 305: WHEN fnd_api.g_exc_error THEN

301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
302: end if;
303:
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
308: ROLLBACK to reduce_allocation_header;
309: WHEN OTHERS THEN

Line 306: x_return_status := fnd_api.g_ret_sts_error;

302: end if;
303:
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
308: ROLLBACK to reduce_allocation_header;
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
308: ROLLBACK to reduce_allocation_header;
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get(
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314: ROLLBACK to reduce_allocation_header;

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
340: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
341: BEGIN
342: SAVEPOINT remove_serial;
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: x_msg_count := 0;
345:
346: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
347: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 381: IF FND_API.To_Boolean( p_commit ) THEN

377: AND serial_number = p_serial;
378: end if;
379: --API end
380:
381: IF FND_API.To_Boolean( p_commit ) THEN
382: COMMIT WORK;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380:
381: IF FND_API.To_Boolean( p_commit ) THEN
382: COMMIT WORK;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
386: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
388: end if;

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388: end if;
389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396: ROLLBACK to remove_serial;

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

417: l_insert_count number;
418: l_update_count number;
419: BEGIN
420: SAVEPOINT add_serial;
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: x_msg_count := 0;
423:
424: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 458: IF FND_API.To_Boolean( p_commit ) THEN

454: ' serials marked in MSN');
455: end if;
456: --API end
457:
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457:
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
463: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
464: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
465: end if;

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

465: end if;
466:
467: EXCEPTION
468: WHEN OTHERS THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
470: FND_MSG_PUB.Count_And_Get(
471: p_count => x_msg_count,
472: p_data => x_msg_data);
473: ROLLBACK to add_serial;

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

503: l_insert_ret_status number := null;
504: l_reduction_qty number := null;
505: BEGIN
506: SAVEPOINT reduce_lot;
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508: x_msg_count := 0;
509:
510: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 584: IF FND_API.To_Boolean( p_commit ) THEN

580: end if;
581: end if;
582: --API end
583:
584: IF FND_API.To_Boolean( p_commit ) THEN
585: COMMIT WORK;
586: END IF;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583:
584: IF FND_API.To_Boolean( p_commit ) THEN
585: COMMIT WORK;
586: END IF;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
589: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
591: end if;

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

591: end if;
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
596: FND_MSG_PUB.Count_And_Get(
597: p_count => x_msg_count,
598: p_data => x_msg_data);
599: ROLLBACK to reduce_lot;

Line 623: x_return_status := FND_API.G_RET_STS_ERROR;

619: l_update_count number := 0;
620: l_ser_trx_id number;
621: BEGIN
622: SAVEPOINT mark_lot_with_ser_temp_id;
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: x_msg_count := 0;
625:
626: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: and primary_quantity = p_primary_quantity
640: and rownum = 1;
641: l_update_count := SQL%ROWCOUNT;
642: if (l_update_count = 1) then
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644: x_ser_trx_id := l_ser_trx_id;
645: end if;
646: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, l_update_count ||

Line 652: IF FND_API.To_Boolean( p_commit ) THEN

648: ' row(s) updated in MTLT with serial_transaction_temp_id: '|| x_ser_trx_id);
649: end if;
650: --API end
651:
652: IF FND_API.To_Boolean( p_commit ) THEN
653: COMMIT WORK;
654: END IF;
655: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
656: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

658: end if;
659:
660: EXCEPTION
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666: ROLLBACK to mark_lot_with_ser_temp_id;