DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on FND_API

Line 629: ' , p_init_msg_list => FND_API.g_TRUE '||

625: ' BEGIN '||
626: ' ENI_ITEMS_STAR_PKG.Update_Categories '||
627: ' ( '||
628: ' p_api_version => 1.0 '||
629: ' , p_init_msg_list => FND_API.g_TRUE '||
630: ' , p_category_id => :X_CATEGORY_ID '||
631: ' , p_structure_id => :X_STRUCTURE_ID '||
632: ' , x_return_status => :l_return_status '||
633: ' , x_msg_count => :l_msg_count '||

Line 639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN

635: ' ); '||
636: ' END;'
637: USING IN X_CATEGORY_ID, IN X_STRUCTURE_ID, OUT l_return_Status, OUT l_msg_count, OUT l_msg_data;
638:
639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);

Line 642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN

638:
639: IF ( l_return_status = FND_API.g_RET_STS_ERROR ) THEN
640: FND_MESSAGE.Set_Encoded (l_msg_data);
641: APP_EXCEPTION.Raise_Exception;
642: ELSIF ( l_return_status = FND_API.g_RET_STS_UNEXP_ERROR ) THEN
643: FND_MESSAGE.Set_Encoded (l_msg_data);
644: APP_EXCEPTION.Raise_Exception;
645: END IF;
646:

Line 971: l_return_status := FND_API.G_RET_STS_SUCCESS;

967: AND CONCATENATED_SEGMENTS = cp_concatenated_segs;*/
968:
969: begin
970:
971: l_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: -- **********************************
974: -- Get the correct structure based on the parameter passed in
975: -- upload_to_functional_area. If the later is passed as an argument,

Line 1140: P_INIT_MSG_LIST => FND_API.G_FALSE,

1136:
1137: -- Create a Category record
1138: INV_ITEM_CATEGORY_PUB.Create_Category (
1139: P_API_VERSION => 1.0,
1140: P_INIT_MSG_LIST => FND_API.G_FALSE,
1141: P_COMMIT => FND_API.G_FALSE,
1142: X_RETURN_STATUS => l_return_status ,
1143: X_ERRORCODE => l_errorcode,
1144: X_MSG_COUNT => l_msg_count ,

Line 1141: P_COMMIT => FND_API.G_FALSE,

1137: -- Create a Category record
1138: INV_ITEM_CATEGORY_PUB.Create_Category (
1139: P_API_VERSION => 1.0,
1140: P_INIT_MSG_LIST => FND_API.G_FALSE,
1141: P_COMMIT => FND_API.G_FALSE,
1142: X_RETURN_STATUS => l_return_status ,
1143: X_ERRORCODE => l_errorcode,
1144: X_MSG_COUNT => l_msg_count ,
1145: X_MSG_DATA => l_msg_data ,

Line 1178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

1174: THEN
1175: FND_MESSAGE.SET_NAME('FND','GENERIC-INTERNAL ERROR');
1176: FND_MESSAGE.SET_TOKEN('ROUTINE','Category Migration');
1177: FND_MESSAGE.SET_TOKEN('REASON','Category to be updated not found.');
1178: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:
1181:
1182: l_category_rec.CATEGORY_ID := l_category_id ;

Line 1186: P_INIT_MSG_LIST => FND_API.G_FALSE,

1182: l_category_rec.CATEGORY_ID := l_category_id ;
1183:
1184: INV_ITEM_CATEGORY_PUB.Update_Category (
1185: P_API_VERSION => 1.0,
1186: P_INIT_MSG_LIST => FND_API.G_FALSE,
1187: P_COMMIT => FND_API.G_FALSE,
1188: X_RETURN_STATUS => l_return_status,
1189: X_ERRORCODE => l_errorcode,
1190: X_MSG_COUNT => l_msg_count,

Line 1187: P_COMMIT => FND_API.G_FALSE,

1183:
1184: INV_ITEM_CATEGORY_PUB.Update_Category (
1185: P_API_VERSION => 1.0,
1186: P_INIT_MSG_LIST => FND_API.G_FALSE,
1187: P_COMMIT => FND_API.G_FALSE,
1188: X_RETURN_STATUS => l_return_status,
1189: X_ERRORCODE => l_errorcode,
1190: X_MSG_COUNT => l_msg_count,
1191: X_MSG_DATA => l_msg_data,

Line 1195: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1191: X_MSG_DATA => l_msg_data,
1192: P_CATEGORY_REC => l_category_rec );
1193:
1194: END IF;
1195: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1196: THEN
1197: FND_MSG_PUB.COUNT_AND_GET (
1198: p_encoded => 'F'
1199: , p_count => l_msg_count