[Home] [Help]
22: x_trx_header_id := NULL;
23: x_trx_temp_id := NULL;
24:
25: IF (l_debug = 1) THEN
26: inv_log_util.trace('Begin insert_mmtt: action_id: ' || p_mmtt_rec.transaction_action_id, g_pkg_name, 9);
27: END IF;
28:
29: -- Standard Start of API savepoint
30: SAVEPOINT sp_insert_mmtt;
497: -- Standard check of p_commit.
498: IF FND_API.To_Boolean( p_commit ) THEN
499: COMMIT WORK;
500: IF (l_debug = 1) THEN
501: inv_log_util.trace('Inserted a New Record in MMTT', g_pkg_name, 9);
502: END IF;
503: END IF;
504:
505: -- Standard call to get message count and if count is 1, get message info.
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: FND_MESSAGE.SET_NAME('INV', 'INV_TRX_TYPE_ERROR');
515: FND_MSG_PUB.ADD;
516: IF (l_debug = 1) THEN
517: inv_log_util.trace('insert mmtt .. EXCEP NO_DATA_FOUND : ', g_pkg_name, 9);
518: END IF;
519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO sp_insert_mmtt;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
523: (p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526: IF (l_debug = 1) THEN
527: inv_log_util.trace('insert_mmtt .. EXCEP G_EXC_ERROR : ', g_pkg_name, 9);
528: END IF;
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: ROLLBACK TO sp_insert_mmtt;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: (p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data);
536: IF (l_debug = 1) THEN
537: inv_log_util.trace('insert_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ', g_pkg_name, 9);
538: END IF;
539: WHEN OTHERS THEN
540: ROLLBACK TO sp_insert_mmtt;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: (p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553: IF (l_debug = 1) THEN
554: inv_log_util.trace('insert_mmtt .. EXCEP others: ' || SQLERRM(SQLCODE), g_pkg_name, 9);
555: END IF;
556: END insert_mmtt;
557: --
558:
779: (p_encoded => FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data);
782: IF (l_debug = 1) THEN
783: inv_log_util.trace('insert_mtlt .. EXCEP G_EXC_ERROR : ', g_pkg_name, 9);
784: END IF;
785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
786: ROLLBACK TO sp_insert_mtlt;
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
789: (p_encoded => FND_API.G_FALSE,
790: p_count => x_msg_count,
791: p_data => x_msg_data);
792: IF (l_debug = 1) THEN
793: inv_log_util.trace('insert_mtlt .. EXCEP G_EXC_UNEXPECTED_ERROR : ', g_pkg_name, 9);
794: END IF;
795: WHEN OTHERS THEN
796: ROLLBACK TO sp_insert_mtlt;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: (p_encoded => FND_API.G_FALSE,
807: p_count => x_msg_count,
808: p_data => x_msg_data);
809: IF (l_debug = 1) THEN
810: inv_log_util.trace( 'proc_insert_mtlt .. EXCEP others : ', g_pkg_name, 9);
811: END IF;
812: END insert_mtlt;
813: --
814:
1004: l_api_name);
1005: END IF;
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: IF (l_debug = 1) THEN
1008: inv_log_util.trace('proc_insert_msnt .. EXCEP G_EXC_ERROR : ', g_pkg_name, 9);
1009: END IF;
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011: ROLLBACK TO sp_insert_msnt;
1012: IF FND_MSG_PUB.Check_Msg_Level
1017: l_api_name);
1018: END IF;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF (l_debug = 1) THEN
1021: inv_log_util.trace('proc_insert_msnt .. EXCEP G_EXC_UNEXPECTED_ERROR : ', g_pkg_name, 9);
1022: END IF;
1023: WHEN OTHERS THEN
1024: ROLLBACK TO sp_insert_msnt;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: (p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);
1037: IF (l_debug = 1) THEN
1038: inv_log_util.trace('proc_insert_msnt .. EXCEP others: ' || SQLERRM(SQLCODE), g_pkg_name, 9) ;
1039: END IF;
1040: END insert_msnt;
1041:
1042: END inv_util;