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.

[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on FND_API

Line 347: raise fnd_api.g_exc_unexpected_error;

343:
344: if(x_status_flag <> 'C') then
345: x_error_flag := 1;
346: x_error_mssg := 'EAM_RET_MAT_UNEXPECTED_ERROR';
347: raise fnd_api.g_exc_unexpected_error;
348: end if;
349: /*
350: if(p_txn_header_id is null) then
351: x_header_id := x_trx_temp_id ;

Line 432: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

428: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
429: 'INV_TXN_MANAGER_PUB.process_Transactions returned. '||
430: 'Return status:'|| x_wip_ret_status);
431: end if;
432: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
433: x_wip_ret_status = FND_API.G_RET_STS_ERROR OR
434: x_inv_ret_status <> 0) then
435: if (l_log) then FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
436: 'INV_TXN_MANAGER_PUB.process_Transactions returned a error. '||

Line 433: x_wip_ret_status = FND_API.G_RET_STS_ERROR OR

429: 'INV_TXN_MANAGER_PUB.process_Transactions returned. '||
430: 'Return status:'|| x_wip_ret_status);
431: end if;
432: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR
433: x_wip_ret_status = FND_API.G_RET_STS_ERROR OR
434: x_inv_ret_status <> 0) then
435: if (l_log) then FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module,
436: 'INV_TXN_MANAGER_PUB.process_Transactions returned a error. '||
437: 'Return message:'|| x_error_mssg);

Line 447: When fnd_api.g_exc_unexpected_error then

443: end if; -- end of if EAM_MATERIALISSUE_PVT.get_tx_processor_mode() = 1
444: end if; -- end of check for p_wip_process
445:
446: Exception
447: When fnd_api.g_exc_unexpected_error then
448: rollback to eammttxnsp;
449: End PROCESSMTLTXN;
450:
451:

Line 569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

565:
566: PROCEDURE MoreMaterial_Add
567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,

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

566: PROCEDURE MoreMaterial_Add
567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,
574: p_organization_id IN NUMBER,

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

567: (
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
572:
573: p_work_object_id IN NUMBER,
574: p_organization_id IN NUMBER,
575: p_operation_seq_num IN NUMBER,

Line 650: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

646: BEGIN
647: -- Standard Start of API savepoint
648: SAVEPOINT EAM_WO_MATERIAL_UTIL_PUB;
649: -- Standard call to check for call compatibility.
650: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
651: p_api_version ,
652: l_api_name ,
653: G_PKG_NAME )
654: THEN

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: p_api_version ,
652: l_api_name ,
653: G_PKG_NAME )
654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;

Line 658: IF FND_API.to_Boolean( p_init_msg_list ) THEN

654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661: -- Initialize API return status to success
662: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661: -- Initialize API return status to success
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: -- API body
664:
665: /* Initialize the local variables */
666: l_stmt_num := 10;

Line 673: l_return_status := FND_API.G_RET_STS_SUCCESS;

669: l_organization_id := p_organization_id;
670: l_operation_seq_num := p_operation_seq_num;
671: l_item_id := p_item_id;
672: l_required_quantity := p_required_quantity;
673: l_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: /* get output directory path from database */
676: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
677:

Line 759: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

755: );
756:
757:
758:
759: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RETURN;
762:
763: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 760: x_return_status := FND_API.G_RET_STS_ERROR;

756:
757:
758:
759: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RETURN;
762:
763: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 763: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

759: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RETURN;
762:
763: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: RETURN;
766:
767: END IF;

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

760: x_return_status := FND_API.G_RET_STS_ERROR;
761: RETURN;
762:
763: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: RETURN;
766:
767: END IF;
768:

Line 771: IF FND_API.To_Boolean( p_commit ) THEN

767: END IF;
768:
769: -- End of API body.
770: -- Standard check of p_commit.
771: IF FND_API.To_Boolean( p_commit ) THEN
772: --dbms_output.put_line('committing');
773: COMMIT WORK;
774: END IF;
775: -- Standard call to get message count and if count is 1, get message info.

Line 781: WHEN FND_API.G_EXC_ERROR THEN

777: ( p_count => x_msg_count ,
778: p_data => x_msg_data
779: );
780: EXCEPTION
781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := FND_API.G_RET_STS_ERROR ;
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count ,
785: p_data => x_msg_data

Line 782: x_return_status := FND_API.G_RET_STS_ERROR ;

778: p_data => x_msg_data
779: );
780: EXCEPTION
781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := FND_API.G_RET_STS_ERROR ;
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count ,
785: p_data => x_msg_data
786: );

Line 789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

785: p_data => x_msg_data
786: );
787:
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: FND_MSG_PUB.Count_And_Get
792: (
793: p_count => x_msg_count,

Line 790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

786: );
787:
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
791: FND_MSG_PUB.Count_And_Get
792: (
793: p_count => x_msg_count,
794: p_data => x_msg_data

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

794: p_data => x_msg_data
795: );
796:
797: WHEN OTHERS THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
799: IF FND_MSG_PUB.Check_Msg_Level
800: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
801: THEN
802: FND_MSG_PUB.Add_Exc_Msg

Line 818: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

814:
815: PROCEDURE MoreDirectItem_Add
816: (
817: p_api_version IN NUMBER,
818: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821:
822: p_work_object_id IN NUMBER,

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

815: PROCEDURE MoreDirectItem_Add
816: (
817: p_api_version IN NUMBER,
818: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821:
822: p_work_object_id IN NUMBER,
823: p_organization_id IN NUMBER,

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

816: (
817: p_api_version IN NUMBER,
818: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
820: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
821:
822: p_work_object_id IN NUMBER,
823: p_organization_id IN NUMBER,
824: p_operation_seq_num IN NUMBER,

Line 903: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

899: BEGIN
900: -- Standard Start of API savepoint
901: SAVEPOINT EAM_WO_MATERIAL_UTIL_PUB;
902: -- Standard call to check for call compatibility.
903: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
904: p_api_version ,
905: l_api_name ,
906: G_PKG_NAME )
907: THEN

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: p_api_version ,
905: l_api_name ,
906: G_PKG_NAME )
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: -- Initialize message list if p_init_msg_list is set to TRUE.
911: IF FND_API.to_Boolean( p_init_msg_list ) THEN
912: FND_MSG_PUB.initialize;

Line 911: IF FND_API.to_Boolean( p_init_msg_list ) THEN

907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: -- Initialize message list if p_init_msg_list is set to TRUE.
911: IF FND_API.to_Boolean( p_init_msg_list ) THEN
912: FND_MSG_PUB.initialize;
913: END IF;
914: -- Initialize API return status to success
915: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 915: x_return_status := FND_API.G_RET_STS_SUCCESS;

911: IF FND_API.to_Boolean( p_init_msg_list ) THEN
912: FND_MSG_PUB.initialize;
913: END IF;
914: -- Initialize API return status to success
915: x_return_status := FND_API.G_RET_STS_SUCCESS;
916: -- API body
917:
918: /* Initialize the local variables */
919: l_stmt_num := 10;

Line 927: l_return_status := FND_API.G_RET_STS_SUCCESS;

923: l_operation_seq_num := p_operation_seq_num;
924: l_item_id := p_item_id;
925: l_need_by_date := p_need_by_date;
926: l_required_quantity := p_required_quantity;
927: l_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: /* get output directory path from database */
930: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
931:

Line 1035: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1031: , p_output_dir => l_output_dir
1032: );
1033:
1034:
1035: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: RETURN;
1038:
1039: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1036: x_return_status := FND_API.G_RET_STS_ERROR;

1032: );
1033:
1034:
1035: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: RETURN;
1038:
1039: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1039: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1035: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: RETURN;
1038:
1039: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: RETURN;
1042:
1043: END IF;

Line 1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: RETURN;
1038:
1039: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: RETURN;
1042:
1043: END IF;
1044:

Line 1047: IF FND_API.To_Boolean( p_commit ) THEN

1043: END IF;
1044:
1045: -- End of API body.
1046: -- Standard check of p_commit.
1047: IF FND_API.To_Boolean( p_commit ) THEN
1048: --dbms_output.put_line('committing');
1049: COMMIT WORK;
1050: END IF;
1051: -- Standard call to get message count and if count is 1, get message info.

Line 1057: WHEN FND_API.G_EXC_ERROR THEN

1053: ( p_count => x_msg_count ,
1054: p_data => x_msg_data
1055: );
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_ERROR ;
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_count => x_msg_count ,
1061: p_data => x_msg_data

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR ;

1054: p_data => x_msg_data
1055: );
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_ERROR ;
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_count => x_msg_count ,
1061: p_data => x_msg_data
1062: );

Line 1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1061: p_data => x_msg_data
1062: );
1063:
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067: FND_MSG_PUB.Count_And_Get
1068: (
1069: p_count => x_msg_count,

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1062: );
1063:
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1067: FND_MSG_PUB.Count_And_Get
1068: (
1069: p_count => x_msg_count,
1070: p_data => x_msg_data

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1070: p_data => x_msg_data
1071: );
1072:
1073: WHEN OTHERS THEN
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075: IF FND_MSG_PUB.Check_Msg_Level
1076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1077: THEN
1078: FND_MSG_PUB.Add_Exc_Msg

Line 1094: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1090:
1091:
1092: PROCEDURE insert_into_wro(
1093: p_api_version IN NUMBER
1094: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1095: ,p_commit IN VARCHAR2 := fnd_api.g_false
1096: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1097: ,p_wip_entity_id IN NUMBER
1098: ,p_organization_id IN NUMBER

Line 1095: ,p_commit IN VARCHAR2 := fnd_api.g_false

1091:
1092: PROCEDURE insert_into_wro(
1093: p_api_version IN NUMBER
1094: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1095: ,p_commit IN VARCHAR2 := fnd_api.g_false
1096: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1097: ,p_wip_entity_id IN NUMBER
1098: ,p_organization_id IN NUMBER
1099: ,p_inventory_item_id IN NUMBER

Line 1096: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1092: PROCEDURE insert_into_wro(
1093: p_api_version IN NUMBER
1094: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1095: ,p_commit IN VARCHAR2 := fnd_api.g_false
1096: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1097: ,p_wip_entity_id IN NUMBER
1098: ,p_organization_id IN NUMBER
1099: ,p_inventory_item_id IN NUMBER
1100: ,p_description IN VARCHAR2

Line 1192: IF NOT fnd_api.compatible_api_call(

1188: SAVEPOINT get_insert_into_wro_pvt;
1189:
1190: l_stmt_num := 20;
1191: -- Standard call to check for call compatibility.
1192: IF NOT fnd_api.compatible_api_call(
1193: l_api_version
1194: ,p_api_version
1195: ,l_api_name
1196: ,g_pkg_name) THEN

Line 1197: RAISE fnd_api.g_exc_unexpected_error;

1193: l_api_version
1194: ,p_api_version
1195: ,l_api_name
1196: ,g_pkg_name) THEN
1197: RAISE fnd_api.g_exc_unexpected_error;
1198: END IF;
1199:
1200: l_stmt_num := 30;
1201: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1202: IF fnd_api.to_boolean(p_init_msg_list) THEN

1198: END IF;
1199:
1200: l_stmt_num := 30;
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF fnd_api.to_boolean(p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: l_stmt_num := 40;

Line 1208: x_return_status := fnd_api.g_ret_sts_success;

1204: END IF;
1205:
1206: l_stmt_num := 40;
1207: -- Initialize API return status to success
1208: x_return_status := fnd_api.g_ret_sts_success;
1209:
1210: l_stmt_num := 50;
1211: -- API body
1212:

Line 1409: IF fnd_api.to_boolean(p_commit)

1405: END IF;
1406:
1407: -- End of API body.
1408: -- Standard check of p_commit.
1409: IF fnd_api.to_boolean(p_commit)
1410: and x_return_status = 'S' THEN
1411: COMMIT WORK;
1412: END IF;
1413:

Line 1420: WHEN fnd_api.g_exc_error THEN

1416: fnd_msg_pub.count_and_get(
1417: p_count => x_msg_count
1418: ,p_data => x_msg_data);
1419: EXCEPTION
1420: WHEN fnd_api.g_exc_error THEN
1421: ROLLBACK TO get_insert_into_wro_pvt;
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: fnd_msg_pub.count_and_get(
1424: -- p_encoded => FND_API.g_false

Line 1422: x_return_status := fnd_api.g_ret_sts_error;

1418: ,p_data => x_msg_data);
1419: EXCEPTION
1420: WHEN fnd_api.g_exc_error THEN
1421: ROLLBACK TO get_insert_into_wro_pvt;
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: fnd_msg_pub.count_and_get(
1424: -- p_encoded => FND_API.g_false
1425: p_count => x_msg_count
1426: ,p_data => x_msg_data);

Line 1424: -- p_encoded => FND_API.g_false

1420: WHEN fnd_api.g_exc_error THEN
1421: ROLLBACK TO get_insert_into_wro_pvt;
1422: x_return_status := fnd_api.g_ret_sts_error;
1423: fnd_msg_pub.count_and_get(
1424: -- p_encoded => FND_API.g_false
1425: p_count => x_msg_count
1426: ,p_data => x_msg_data);
1427: WHEN fnd_api.g_exc_unexpected_error THEN
1428: ROLLBACK TO get_insert_into_wro_pvt;

Line 1427: WHEN fnd_api.g_exc_unexpected_error THEN

1423: fnd_msg_pub.count_and_get(
1424: -- p_encoded => FND_API.g_false
1425: p_count => x_msg_count
1426: ,p_data => x_msg_data);
1427: WHEN fnd_api.g_exc_unexpected_error THEN
1428: ROLLBACK TO get_insert_into_wro_pvt;
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430:
1431: fnd_msg_pub.count_and_get(

Line 1429: x_return_status := fnd_api.g_ret_sts_unexp_error;

1425: p_count => x_msg_count
1426: ,p_data => x_msg_data);
1427: WHEN fnd_api.g_exc_unexpected_error THEN
1428: ROLLBACK TO get_insert_into_wro_pvt;
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430:
1431: fnd_msg_pub.count_and_get(
1432: p_count => x_msg_count
1433: ,p_data => x_msg_data);

Line 1436: x_return_status := fnd_api.g_ret_sts_unexp_error;

1432: p_count => x_msg_count
1433: ,p_data => x_msg_data);
1434: WHEN OTHERS THEN
1435: ROLLBACK TO get_insert_into_wro_pvt;
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437: IF fnd_msg_pub.check_msg_level(
1438: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1439: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1440: END IF;

Line 1451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1447:
1448:
1449: PROCEDURE insert_into_wdi(
1450: p_api_version IN NUMBER
1451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1452: ,p_commit IN VARCHAR2 := fnd_api.g_false
1453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1454: ,p_wip_entity_id IN NUMBER
1455: ,p_organization_id IN NUMBER

Line 1452: ,p_commit IN VARCHAR2 := fnd_api.g_false

1448:
1449: PROCEDURE insert_into_wdi(
1450: p_api_version IN NUMBER
1451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1452: ,p_commit IN VARCHAR2 := fnd_api.g_false
1453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1454: ,p_wip_entity_id IN NUMBER
1455: ,p_organization_id IN NUMBER
1456: ,p_direct_item_seq_id IN NUMBER := NULL

Line 1453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

1449: PROCEDURE insert_into_wdi(
1450: p_api_version IN NUMBER
1451: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1452: ,p_commit IN VARCHAR2 := fnd_api.g_false
1453: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
1454: ,p_wip_entity_id IN NUMBER
1455: ,p_organization_id IN NUMBER
1456: ,p_direct_item_seq_id IN NUMBER := NULL
1457: ,p_description IN VARCHAR2

Line 1558: IF NOT fnd_api.compatible_api_call(

1554: SAVEPOINT get_insert_into_wro_pvt;
1555:
1556: l_stmt_num := 20;
1557: -- Standard call to check for call compatibility.
1558: IF NOT fnd_api.compatible_api_call(
1559: l_api_version
1560: ,p_api_version
1561: ,l_api_name
1562: ,g_pkg_name) THEN

Line 1563: RAISE fnd_api.g_exc_unexpected_error;

1559: l_api_version
1560: ,p_api_version
1561: ,l_api_name
1562: ,g_pkg_name) THEN
1563: RAISE fnd_api.g_exc_unexpected_error;
1564: END IF;
1565:
1566: l_stmt_num := 30;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1568: IF fnd_api.to_boolean(p_init_msg_list) THEN

1564: END IF;
1565:
1566: l_stmt_num := 30;
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF fnd_api.to_boolean(p_init_msg_list) THEN
1569: fnd_msg_pub.initialize;
1570: END IF;
1571:
1572: l_stmt_num := 40;

Line 1574: x_return_status := fnd_api.g_ret_sts_success;

1570: END IF;
1571:
1572: l_stmt_num := 40;
1573: -- Initialize API return status to success
1574: x_return_status := fnd_api.g_ret_sts_success;
1575:
1576: l_stmt_num := 50;
1577: -- API body
1578:

Line 1771: IF fnd_api.to_boolean(p_commit)

1767: END IF;
1768:
1769: -- End of API body.
1770: -- Standard check of p_commit.
1771: IF fnd_api.to_boolean(p_commit)
1772: and x_return_status = 'S' THEN
1773: COMMIT WORK;
1774: END IF;
1775:

Line 1782: WHEN fnd_api.g_exc_error THEN

1778: fnd_msg_pub.count_and_get(
1779: p_count => x_msg_count
1780: ,p_data => x_msg_data);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN
1783: ROLLBACK TO get_insert_into_wro_pvt;
1784: x_return_status := fnd_api.g_ret_sts_error;
1785: fnd_msg_pub.count_and_get(
1786: -- p_encoded => FND_API.g_false

Line 1784: x_return_status := fnd_api.g_ret_sts_error;

1780: ,p_data => x_msg_data);
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_error THEN
1783: ROLLBACK TO get_insert_into_wro_pvt;
1784: x_return_status := fnd_api.g_ret_sts_error;
1785: fnd_msg_pub.count_and_get(
1786: -- p_encoded => FND_API.g_false
1787: p_count => x_msg_count
1788: ,p_data => x_msg_data);

Line 1786: -- p_encoded => FND_API.g_false

1782: WHEN fnd_api.g_exc_error THEN
1783: ROLLBACK TO get_insert_into_wro_pvt;
1784: x_return_status := fnd_api.g_ret_sts_error;
1785: fnd_msg_pub.count_and_get(
1786: -- p_encoded => FND_API.g_false
1787: p_count => x_msg_count
1788: ,p_data => x_msg_data);
1789: WHEN fnd_api.g_exc_unexpected_error THEN
1790: ROLLBACK TO get_insert_into_wro_pvt;

Line 1789: WHEN fnd_api.g_exc_unexpected_error THEN

1785: fnd_msg_pub.count_and_get(
1786: -- p_encoded => FND_API.g_false
1787: p_count => x_msg_count
1788: ,p_data => x_msg_data);
1789: WHEN fnd_api.g_exc_unexpected_error THEN
1790: ROLLBACK TO get_insert_into_wro_pvt;
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:
1793: fnd_msg_pub.count_and_get(

Line 1791: x_return_status := fnd_api.g_ret_sts_unexp_error;

1787: p_count => x_msg_count
1788: ,p_data => x_msg_data);
1789: WHEN fnd_api.g_exc_unexpected_error THEN
1790: ROLLBACK TO get_insert_into_wro_pvt;
1791: x_return_status := fnd_api.g_ret_sts_unexp_error;
1792:
1793: fnd_msg_pub.count_and_get(
1794: p_count => x_msg_count
1795: ,p_data => x_msg_data);

Line 1798: x_return_status := fnd_api.g_ret_sts_unexp_error;

1794: p_count => x_msg_count
1795: ,p_data => x_msg_data);
1796: WHEN OTHERS THEN
1797: ROLLBACK TO get_insert_into_wro_pvt;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: IF fnd_msg_pub.check_msg_level(
1800: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1801: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1802: END IF;