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

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

2: /* $Header: INVINUTB.pls 115.6 2002/12/31 20:43:02 lplam ship $ */
3: g_pkg_name VARCHAR2(100) := 'inv_util';
4:
5: PROCEDURE insert_mmtt(p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE,
10: x_trx_header_id OUT NOCOPY NUMBER,

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

3: g_pkg_name VARCHAR2(100) := 'inv_util';
4:
5: PROCEDURE insert_mmtt(p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE,
10: x_trx_header_id OUT NOCOPY NUMBER,
11: x_trx_temp_id OUT NOCOPY NUMBER,

Line 8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4:
5: PROCEDURE insert_mmtt(p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE,
10: x_trx_header_id OUT NOCOPY NUMBER,
11: x_trx_temp_id OUT NOCOPY NUMBER,
12: x_return_status OUT NOCOPY VARCHAR2,

Line 21: x_return_status := fnd_api.g_ret_sts_success;

17: l_api_name CONSTANT VARCHAR2(30):= g_pkg_name||'.insert_mmtt';
18: l_trx_type_id NUMBER;
19: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: x_return_status := fnd_api.g_ret_sts_success;
22: x_trx_header_id := NULL;
23: x_trx_temp_id := NULL;
24:
25: IF (l_debug = 1) THEN

Line 32: IF NOT FND_API.Compatible_API_Call ( l_api_version,

28:
29: -- Standard Start of API savepoint
30: SAVEPOINT sp_insert_mmtt;
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call ( l_api_version,
33: p_api_version,
34: l_api_name,
35: g_pkg_name)
36: THEN

Line 37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

33: p_api_version,
34: l_api_name,
35: g_pkg_name)
36: THEN
37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 41: IF FND_API.to_Boolean( p_init_msg_list ) THEN

37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41: IF FND_API.to_Boolean( p_init_msg_list ) THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45:

Line 498: IF FND_API.To_Boolean( p_commit ) THEN

494: ,p_mmtt_rec.TRANSACTION_BATCH_ID
495: ,p_mmtt_rec.TRANSACTION_BATCH_SEQ);
496:
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;

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509:
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: ROLLBACK TO sp_insert_mmtt;
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);

Line 519: WHEN FND_API.G_EXC_ERROR THEN

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 ;
522: FND_MSG_PUB.Count_And_Get
523: (p_encoded => FND_API.G_FALSE,

Line 521: x_return_status := FND_API.G_RET_STS_ERROR ;

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 ;
522: FND_MSG_PUB.Count_And_Get
523: (p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data);

Line 523: (p_encoded => FND_API.G_FALSE,

519: WHEN FND_API.G_EXC_ERROR THEN
520: ROLLBACK TO sp_insert_mmtt;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: FND_MSG_PUB.Count_And_Get
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);

Line 529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;
532: FND_MSG_PUB.Count_And_Get
533: (p_encoded => FND_API.G_FALSE,

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
532: FND_MSG_PUB.Count_And_Get
533: (p_encoded => FND_API.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data);

Line 533: (p_encoded => FND_API.G_FALSE,

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 ;
532: FND_MSG_PUB.Count_And_Get
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);

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
542: IF FND_MSG_PUB.Check_Msg_Level
543: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN
545: FND_MSG_PUB.Add_Exc_Msg

Line 550: (p_encoded => FND_API.G_FALSE,

546: (G_PKG_NAME,
547: l_api_name);
548: END IF;
549: FND_MSG_PUB.Count_And_Get
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);

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

556: END insert_mmtt;
557: --
558:
559: PROCEDURE insert_mtlt(p_api_version IN NUMBER,
560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
563: p_mtlt_rec IN mtl_transaction_lots_temp%ROWTYPE,
564: x_return_status OUT NOCOPY VARCHAR2,

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

557: --
558:
559: PROCEDURE insert_mtlt(p_api_version IN NUMBER,
560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
563: p_mtlt_rec IN mtl_transaction_lots_temp%ROWTYPE,
564: x_return_status OUT NOCOPY VARCHAR2,
565: x_msg_count OUT NOCOPY NUMBER,

Line 562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

558:
559: PROCEDURE insert_mtlt(p_api_version IN NUMBER,
560: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
561: p_commit IN VARCHAR2 := FND_API.G_FALSE,
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
563: p_mtlt_rec IN mtl_transaction_lots_temp%ROWTYPE,
564: x_return_status OUT NOCOPY VARCHAR2,
565: x_msg_count OUT NOCOPY NUMBER,
566: x_msg_data OUT NOCOPY VARCHAR2)

Line 572: x_return_status := fnd_api.g_ret_sts_success;

568: l_api_version CONSTANT NUMBER := 1.0;
569: l_api_name CONSTANT VARCHAR2(30):= g_pkg_name||'.insert_mtlt';
570: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
571: BEGIN
572: x_return_status := fnd_api.g_ret_sts_success;
573:
574: -- Standard Start of API savepoint
575: SAVEPOINT sp_insert_mtlt;
576: -- Standard call to check for call compatibility.

Line 577: IF NOT FND_API.Compatible_API_Call ( l_api_version,

573:
574: -- Standard Start of API savepoint
575: SAVEPOINT sp_insert_mtlt;
576: -- Standard call to check for call compatibility.
577: IF NOT FND_API.Compatible_API_Call ( l_api_version,
578: p_api_version,
579: l_api_name,
580: g_pkg_name)
581: THEN

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578: p_api_version,
579: l_api_name,
580: g_pkg_name)
581: THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 586: IF FND_API.to_Boolean( p_init_msg_list ) THEN

582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF FND_API.to_Boolean( p_init_msg_list ) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: INSERT INTO mtl_transaction_lots_temp

Line 775: WHEN FND_API.G_EXC_ERROR THEN

771: ,p_mtlt_rec.SECONDARY_QUANTITY
772: ,p_mtlt_rec.SECONDARY_UNIT_OF_MEASURE
773: ,p_mtlt_rec.QC_GRADE);
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO sp_insert_mtlt;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: FND_MSG_PUB.Count_And_Get
779: (p_encoded => FND_API.G_FALSE,

Line 777: x_return_status := FND_API.G_RET_STS_ERROR ;

773: ,p_mtlt_rec.QC_GRADE);
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO sp_insert_mtlt;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: FND_MSG_PUB.Count_And_Get
779: (p_encoded => FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data);

Line 779: (p_encoded => FND_API.G_FALSE,

775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO sp_insert_mtlt;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: FND_MSG_PUB.Count_And_Get
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);

Line 785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;
788: FND_MSG_PUB.Count_And_Get
789: (p_encoded => FND_API.G_FALSE,

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
788: FND_MSG_PUB.Count_And_Get
789: (p_encoded => FND_API.G_FALSE,
790: p_count => x_msg_count,
791: p_data => x_msg_data);

Line 789: (p_encoded => FND_API.G_FALSE,

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 ;
788: FND_MSG_PUB.Count_And_Get
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);

Line 797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
798: IF FND_MSG_PUB.Check_Msg_Level
799: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
800: THEN
801: FND_MSG_PUB.Add_Exc_Msg

Line 806: (p_encoded => FND_API.G_FALSE,

802: (G_PKG_NAME,
803: l_api_name);
804: END IF;
805: FND_MSG_PUB.Count_And_Get
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);

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

812: END insert_mtlt;
813: --
814:
815: PROCEDURE insert_msnt(p_api_version IN NUMBER,
816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
817: p_commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: p_msnt_rec IN mtl_serial_numbers_temp%ROWTYPE,
820: x_return_status OUT NOCOPY VARCHAR2,

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

813: --
814:
815: PROCEDURE insert_msnt(p_api_version IN NUMBER,
816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
817: p_commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: p_msnt_rec IN mtl_serial_numbers_temp%ROWTYPE,
820: x_return_status OUT NOCOPY VARCHAR2,
821: x_msg_count OUT NOCOPY NUMBER,

Line 818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

814:
815: PROCEDURE insert_msnt(p_api_version IN NUMBER,
816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
817: p_commit IN VARCHAR2 := FND_API.G_FALSE,
818: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
819: p_msnt_rec IN mtl_serial_numbers_temp%ROWTYPE,
820: x_return_status OUT NOCOPY VARCHAR2,
821: x_msg_count OUT NOCOPY NUMBER,
822: x_msg_data OUT NOCOPY VARCHAR2)

Line 828: x_return_status := fnd_api.g_ret_sts_success;

824: l_api_version CONSTANT NUMBER := 1.0;
825: l_api_name CONSTANT VARCHAR2(30):= g_pkg_name||'.insert_msnt';
826: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
827: BEGIN
828: x_return_status := fnd_api.g_ret_sts_success;
829:
830: -- Standard Start of API savepoint
831: SAVEPOINT sp_insert_mmtt;
832: -- Standard call to check for call compatibility.

Line 833: IF NOT FND_API.Compatible_API_Call ( l_api_version,

829:
830: -- Standard Start of API savepoint
831: SAVEPOINT sp_insert_mmtt;
832: -- Standard call to check for call compatibility.
833: IF NOT FND_API.Compatible_API_Call ( l_api_version,
834: p_api_version,
835: l_api_name,
836: g_pkg_name)
837: THEN

Line 838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

834: p_api_version,
835: l_api_name,
836: g_pkg_name)
837: THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: END IF;
840:
841: -- Initialize message list if p_init_msg_list is set to TRUE.
842: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 842: IF FND_API.to_Boolean( p_init_msg_list ) THEN

838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: END IF;
840:
841: -- Initialize message list if p_init_msg_list is set to TRUE.
842: IF FND_API.to_Boolean( p_init_msg_list ) THEN
843: FND_MSG_PUB.initialize;
844: END IF;
845:
846: INSERT INTO mtl_serial_numbers_temp

Line 997: WHEN FND_API.G_EXC_ERROR THEN

993: ,p_msnt_rec.TIME_SINCE_MARK
994: ,p_msnt_rec.CYCLES_SINCE_MARK
995: ,p_msnt_rec.number_of_repairs);
996: EXCEPTION
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO sp_insert_msnt;
999: IF FND_MSG_PUB.Check_Msg_Level
1000: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1001: THEN

Line 1006: x_return_status := FND_API.G_RET_STS_ERROR;

1002: FND_MSG_PUB.Add_Exc_Msg
1003: (G_PKG_NAME,
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

Line 1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
1013: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1015: FND_MSG_PUB.Add_Exc_Msg
1016: (G_PKG_NAME,
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

Line 1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1026: IF FND_MSG_PUB.Check_Msg_Level
1027: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg

Line 1034: (p_encoded => FND_API.G_FALSE,

1030: (G_PKG_NAME,
1031: l_api_name);
1032: END IF;
1033: FND_MSG_PUB.Count_And_Get
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) ;